131:
132: EXCEPTION
133: WHEN OTHERS THEN
134: IF (SQLCODE <> -20001) THEN
135: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
136: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
137: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
138: current_calling_sequence);
139: FND_MESSAGE.SET_TOKEN('PARAMETERS',
132: EXCEPTION
133: WHEN OTHERS THEN
134: IF (SQLCODE <> -20001) THEN
135: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
136: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
137: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
138: current_calling_sequence);
139: FND_MESSAGE.SET_TOKEN('PARAMETERS',
140: 'X_invoice_id = '||X_invoice_id
133: WHEN OTHERS THEN
134: IF (SQLCODE <> -20001) THEN
135: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
136: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
137: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
138: current_calling_sequence);
139: FND_MESSAGE.SET_TOKEN('PARAMETERS',
140: 'X_invoice_id = '||X_invoice_id
141: ||'X_event = '||X_event
135: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
136: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
137: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
138: current_calling_sequence);
139: FND_MESSAGE.SET_TOKEN('PARAMETERS',
140: 'X_invoice_id = '||X_invoice_id
141: ||'X_event = '||X_event
142: ||'X_update_base = '||X_update_base
143: ||'X_vendor_changed_flag = '||X_vendor_changed_flag
141: ||'X_event = '||X_event
142: ||'X_update_base = '||X_update_base
143: ||'X_vendor_changed_flag = '||X_vendor_changed_flag
144: );
145: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
146: END IF;
147: APP_EXCEPTION.RAISE_EXCEPTION;
148:
149: END create_holds;
317:
318: EXCEPTION
319: WHEN OTHERS THEN
320: IF (SQLCODE <> -20001) THEN
321: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
322: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
323: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
324: current_calling_sequence);
325: FND_MESSAGE.SET_TOKEN('PARAMETERS',
318: EXCEPTION
319: WHEN OTHERS THEN
320: IF (SQLCODE <> -20001) THEN
321: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
322: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
323: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
324: current_calling_sequence);
325: FND_MESSAGE.SET_TOKEN('PARAMETERS',
326: ' X_Invoice_Id = ' ||TO_CHAR(X_invoice_id));
319: WHEN OTHERS THEN
320: IF (SQLCODE <> -20001) THEN
321: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
322: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
323: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
324: current_calling_sequence);
325: FND_MESSAGE.SET_TOKEN('PARAMETERS',
326: ' X_Invoice_Id = ' ||TO_CHAR(X_invoice_id));
327: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
321: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
322: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
323: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
324: current_calling_sequence);
325: FND_MESSAGE.SET_TOKEN('PARAMETERS',
326: ' X_Invoice_Id = ' ||TO_CHAR(X_invoice_id));
327: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
328: END IF;
329: APP_EXCEPTION.RAISE_EXCEPTION;
323: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
324: current_calling_sequence);
325: FND_MESSAGE.SET_TOKEN('PARAMETERS',
326: ' X_Invoice_Id = ' ||TO_CHAR(X_invoice_id));
327: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
328: END IF;
329: APP_EXCEPTION.RAISE_EXCEPTION;
330:
331: END insert_children;
474:
475: EXCEPTION
476: WHEN OTHERS THEN
477: IF (SQLCODE <> -20001) THEN
478: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
479: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
480: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
481: current_calling_sequence);
482: FND_MESSAGE.SET_TOKEN('PARAMETERS',
475: EXCEPTION
476: WHEN OTHERS THEN
477: IF (SQLCODE <> -20001) THEN
478: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
479: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
480: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
481: current_calling_sequence);
482: FND_MESSAGE.SET_TOKEN('PARAMETERS',
483: 'X_invoice_id = '||X_invoice_id
476: WHEN OTHERS THEN
477: IF (SQLCODE <> -20001) THEN
478: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
479: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
480: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
481: current_calling_sequence);
482: FND_MESSAGE.SET_TOKEN('PARAMETERS',
483: 'X_invoice_id = '||X_invoice_id
484: ||', X_invoice_amount = '||X_invoice_amount
478: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
479: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
480: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
481: current_calling_sequence);
482: FND_MESSAGE.SET_TOKEN('PARAMETERS',
483: 'X_invoice_id = '||X_invoice_id
484: ||', X_invoice_amount = '||X_invoice_amount
485: ||', X_payment_status_flag = '||X_payment_status_flag
486: ||', X_invoice_type_lookup_code = '||X_invoice_type_lookup_code
494: ||', X_reset_match_status = '||X_reset_match_status
495: ||', X_recalc_pay_sched = ' ||X_recalc_pay_sched
496: ||', X_liability_adjusted_flag = ' ||X_liability_adjusted_flag
497: );
498: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
499: END IF;
500: APP_EXCEPTION.RAISE_EXCEPTION;
501:
502: END invoice_pre_update;
671:
672: EXCEPTION
673: WHEN OTHERS THEN
674: IF (SQLCODE <> -20001) THEN
675: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
676: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
677: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
678: current_calling_sequence);
679: FND_MESSAGE.SET_TOKEN('PARAMETERS',
672: EXCEPTION
673: WHEN OTHERS THEN
674: IF (SQLCODE <> -20001) THEN
675: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
676: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
677: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
678: current_calling_sequence);
679: FND_MESSAGE.SET_TOKEN('PARAMETERS',
680: 'X_invoice_id = ' ||X_invoice_id
673: WHEN OTHERS THEN
674: IF (SQLCODE <> -20001) THEN
675: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
676: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
677: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
678: current_calling_sequence);
679: FND_MESSAGE.SET_TOKEN('PARAMETERS',
680: 'X_invoice_id = ' ||X_invoice_id
681: ||', X_payment_priority = '||X_payment_priority
675: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
676: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
677: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
678: current_calling_sequence);
679: FND_MESSAGE.SET_TOKEN('PARAMETERS',
680: 'X_invoice_id = ' ||X_invoice_id
681: ||', X_payment_priority = '||X_payment_priority
682: ||', X_recalc_pay_sched = '||X_recalc_pay_sched
683: ||', X_Hold_count = ' ||X_Hold_count
681: ||', X_payment_priority = '||X_payment_priority
682: ||', X_recalc_pay_sched = '||X_recalc_pay_sched
683: ||', X_Hold_count = ' ||X_Hold_count
684: );
685: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
686: END IF;
687: APP_EXCEPTION.RAISE_EXCEPTION;
688:
689: END invoice_post_update;
796:
797: EXCEPTION
798: WHEN OTHERS THEN
799: IF (SQLCODE <> -20001) THEN
800: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
801: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
802: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
803: current_calling_sequence);
804: FND_MESSAGE.SET_TOKEN('PARAMETERS',
797: EXCEPTION
798: WHEN OTHERS THEN
799: IF (SQLCODE <> -20001) THEN
800: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
801: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
802: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
803: current_calling_sequence);
804: FND_MESSAGE.SET_TOKEN('PARAMETERS',
805: 'X_invoice_id = ' ||X_invoice_id
798: WHEN OTHERS THEN
799: IF (SQLCODE <> -20001) THEN
800: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
801: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
802: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
803: current_calling_sequence);
804: FND_MESSAGE.SET_TOKEN('PARAMETERS',
805: 'X_invoice_id = ' ||X_invoice_id
806: ||', X_type_1099 = ' ||X_type_1099
800: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
801: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
802: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
803: current_calling_sequence);
804: FND_MESSAGE.SET_TOKEN('PARAMETERS',
805: 'X_invoice_id = ' ||X_invoice_id
806: ||', X_type_1099 = ' ||X_type_1099
807: ||', X_income_tax_region = ' ||X_income_tax_region
808: ||', X_vendor_changed_flag = ' ||X_vendor_changed_flag
817: ||', X_highest_line_num = ' ||X_highest_line_num
818: ||', X_actual_invoice_count = ' ||X_actual_invoice_count
819: ||', X_actual_invoice_total = ' ||X_actual_invoice_total
820: ||', X_line_total = ' ||X_Line_total );
821: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
822: END IF;
823: APP_EXCEPTION.RAISE_EXCEPTION;
824:
825: END post_forms_commit;
854:
855: EXCEPTION
856: WHEN OTHERS THEN
857: if (SQLCODE <> -20001) then
858: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
859: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
860: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
861: FND_MESSAGE.SET_TOKEN('PARAMETERS','Batch Id = '||X_Batch_ID
862: ||',Total = '||X_Total
855: EXCEPTION
856: WHEN OTHERS THEN
857: if (SQLCODE <> -20001) then
858: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
859: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
860: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
861: FND_MESSAGE.SET_TOKEN('PARAMETERS','Batch Id = '||X_Batch_ID
862: ||',Total = '||X_Total
863: ||',Total RTOT DB = '||
856: WHEN OTHERS THEN
857: if (SQLCODE <> -20001) then
858: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
859: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
860: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
861: FND_MESSAGE.SET_TOKEN('PARAMETERS','Batch Id = '||X_Batch_ID
862: ||',Total = '||X_Total
863: ||',Total RTOT DB = '||
864: X_Total_Rtot_DB);
857: if (SQLCODE <> -20001) then
858: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
859: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
860: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
861: FND_MESSAGE.SET_TOKEN('PARAMETERS','Batch Id = '||X_Batch_ID
862: ||',Total = '||X_Total
863: ||',Total RTOT DB = '||
864: X_Total_Rtot_DB);
865: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
861: FND_MESSAGE.SET_TOKEN('PARAMETERS','Batch Id = '||X_Batch_ID
862: ||',Total = '||X_Total
863: ||',Total RTOT DB = '||
864: X_Total_Rtot_DB);
865: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
866: end if;
867: APP_EXCEPTION.RAISE_EXCEPTION;
868: END Select_Summary;
869: