281:
282: EXCEPTION
283: WHEN OTHERS THEN
284: IF (SQLCODE <> -20001) THEN
285: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
286: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
287: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'VALIDATE');
288: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
289: END IF;
282: EXCEPTION
283: WHEN OTHERS THEN
284: IF (SQLCODE <> -20001) THEN
285: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
286: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
287: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'VALIDATE');
288: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
289: END IF;
290: APP_EXCEPTION.RAISE_EXCEPTION;
283: WHEN OTHERS THEN
284: IF (SQLCODE <> -20001) THEN
285: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
286: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
287: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'VALIDATE');
288: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
289: END IF;
290: APP_EXCEPTION.RAISE_EXCEPTION;
291:
284: IF (SQLCODE <> -20001) THEN
285: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
286: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
287: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'VALIDATE');
288: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
289: END IF;
290: APP_EXCEPTION.RAISE_EXCEPTION;
291:
292: END;
429: 'GL#',
430: l_chart_of_accounts_id);
431:
432: IF (l_flex_segment_delimiter IS NULL) THEN
433: p_return_error_message := l_debug_info||': '||FND_MESSAGE.GET;
434: return;
435: END IF;
436:
437: -----------------------------------------------
443: 'GL#',
444: l_chart_of_accounts_id,
445: 'FA_COST_CTR',
446: l_cc_flex_segment_number)) THEN
447: p_return_error_message := l_debug_info||': '||FND_MESSAGE.GET;
448: return;
449: END IF;
450:
451: -----------------------------------------------
457: 'GL#',
458: l_chart_of_accounts_id,
459: 'GL_ACCOUNT',
460: l_flex_segment_number)) THEN
461: p_return_error_message := l_debug_info||': '||FND_MESSAGE.GET;
462: return;
463: END IF;
464:
465: OPEN lines_cursor;
513: l_default_emp_ccid,
514: l_num_segments,
515: l_default_emp_segments)) THEN
516:
517: p_return_error_message := l_debug_info||': '||FND_MESSAGE.GET;
518: raise INVALID_ACCT_EXCEPTION;
519: END IF;
520: end if;
521:
559: l_num_segments,
560: l_exp_line_acct_segs_array,
561: l_exp_line_ccid)) THEN
562:
563: p_return_error_message := l_debug_info||': '||FND_MESSAGE.GET;
564: raise INVALID_ACCT_EXCEPTION;
565: END IF;
566:
567: EXCEPTION
601: l_exp_line_ccid,
602: l_num_segments,
603: l_final_segments)) THEN
604:
605: p_return_error_message := l_debug_info||': '||FND_MESSAGE.GET;
606: return;
607: END IF;
608:
609: --
664:
665: EXCEPTION
666: WHEN OTHERS THEN
667: IF (SQLCODE <> -20001) THEN
668: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
669: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
670: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'CREATE_DISTRIBUTIONS');
671: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
672: END IF;
665: EXCEPTION
666: WHEN OTHERS THEN
667: IF (SQLCODE <> -20001) THEN
668: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
669: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
670: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'CREATE_DISTRIBUTIONS');
671: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
672: END IF;
673: APP_EXCEPTION.RAISE_EXCEPTION;
666: WHEN OTHERS THEN
667: IF (SQLCODE <> -20001) THEN
668: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
669: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
670: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'CREATE_DISTRIBUTIONS');
671: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
672: END IF;
673: APP_EXCEPTION.RAISE_EXCEPTION;
674:
667: IF (SQLCODE <> -20001) THEN
668: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
669: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
670: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'CREATE_DISTRIBUTIONS');
671: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
672: END IF;
673: APP_EXCEPTION.RAISE_EXCEPTION;
674:
675: END;
704:
705: EXCEPTION
706: WHEN OTHERS THEN
707: IF (SQLCODE <> -20001) THEN
708: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
709: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
710: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'CREATE_INTERFACE_RECORDS');
711: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
712: END IF;
705: EXCEPTION
706: WHEN OTHERS THEN
707: IF (SQLCODE <> -20001) THEN
708: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
709: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
710: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'CREATE_INTERFACE_RECORDS');
711: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
712: END IF;
713: APP_EXCEPTION.RAISE_EXCEPTION;
706: WHEN OTHERS THEN
707: IF (SQLCODE <> -20001) THEN
708: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
709: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
710: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'CREATE_INTERFACE_RECORDS');
711: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
712: END IF;
713: APP_EXCEPTION.RAISE_EXCEPTION;
714:
707: IF (SQLCODE <> -20001) THEN
708: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
709: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
710: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'CREATE_INTERFACE_RECORDS');
711: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
712: END IF;
713: APP_EXCEPTION.RAISE_EXCEPTION;
714:
715: END;