DBA Data[Home] [Help]

APPS.AP_INVOICES_POST_PROCESS_PKG dependencies on FND_MESSAGE

Line 135: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

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',

Line 136: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

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

Line 137: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

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

Line 139: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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

Line 145: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

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;

Line 321: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

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',

Line 322: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

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));

Line 323: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

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);

Line 325: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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;

Line 327: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

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;

Line 478: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

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',

Line 479: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

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

Line 480: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

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

Line 482: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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

Line 498: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

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;

Line 675: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

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',

Line 676: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

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

Line 677: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

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

Line 679: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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

Line 685: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

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;

Line 800: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

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',

Line 801: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

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

Line 802: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

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

Line 804: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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

Line 821: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

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;

Line 858: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');

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

Line 859: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);

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 = '||

Line 860: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);

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);

Line 861: FND_MESSAGE.SET_TOKEN('PARAMETERS','Batch Id = '||X_Batch_ID

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);

Line 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: