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 501: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

497:
498: EXCEPTION
499: WHEN OTHERS THEN
500: IF (SQLCODE <> -20001) THEN
501: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
502: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
503: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
504: current_calling_sequence);
505: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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

498: EXCEPTION
499: WHEN OTHERS THEN
500: IF (SQLCODE <> -20001) THEN
501: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
502: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
503: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
504: current_calling_sequence);
505: FND_MESSAGE.SET_TOKEN('PARAMETERS',
506: 'X_invoice_id = '||X_invoice_id

Line 503: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

499: WHEN OTHERS THEN
500: IF (SQLCODE <> -20001) THEN
501: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
502: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
503: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
504: current_calling_sequence);
505: FND_MESSAGE.SET_TOKEN('PARAMETERS',
506: 'X_invoice_id = '||X_invoice_id
507: ||', X_invoice_amount = '||X_invoice_amount

Line 505: FND_MESSAGE.SET_TOKEN('PARAMETERS',

501: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
502: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
503: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
504: current_calling_sequence);
505: FND_MESSAGE.SET_TOKEN('PARAMETERS',
506: 'X_invoice_id = '||X_invoice_id
507: ||', X_invoice_amount = '||X_invoice_amount
508: ||', X_payment_status_flag = '||X_payment_status_flag
509: ||', X_invoice_type_lookup_code = '||X_invoice_type_lookup_code

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

517: ||', X_reset_match_status = '||X_reset_match_status
518: ||', X_recalc_pay_sched = ' ||X_recalc_pay_sched
519: ||', X_liability_adjusted_flag = ' ||X_liability_adjusted_flag
520: );
521: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
522: END IF;
523: APP_EXCEPTION.RAISE_EXCEPTION;
524:
525: END invoice_pre_update;

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

729:
730: EXCEPTION
731: WHEN OTHERS THEN
732: IF (SQLCODE <> -20001) THEN
733: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
734: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
735: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
736: current_calling_sequence);
737: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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

730: EXCEPTION
731: WHEN OTHERS THEN
732: IF (SQLCODE <> -20001) THEN
733: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
734: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
735: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
736: current_calling_sequence);
737: FND_MESSAGE.SET_TOKEN('PARAMETERS',
738: 'X_invoice_id = ' ||X_invoice_id

Line 735: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

731: WHEN OTHERS THEN
732: IF (SQLCODE <> -20001) THEN
733: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
734: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
735: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
736: current_calling_sequence);
737: FND_MESSAGE.SET_TOKEN('PARAMETERS',
738: 'X_invoice_id = ' ||X_invoice_id
739: ||', X_payment_priority = '||X_payment_priority

Line 737: FND_MESSAGE.SET_TOKEN('PARAMETERS',

733: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
734: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
735: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
736: current_calling_sequence);
737: FND_MESSAGE.SET_TOKEN('PARAMETERS',
738: 'X_invoice_id = ' ||X_invoice_id
739: ||', X_payment_priority = '||X_payment_priority
740: ||', X_recalc_pay_sched = '||X_recalc_pay_sched
741: ||', X_Hold_count = ' ||X_Hold_count

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

739: ||', X_payment_priority = '||X_payment_priority
740: ||', X_recalc_pay_sched = '||X_recalc_pay_sched
741: ||', X_Hold_count = ' ||X_Hold_count
742: );
743: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
744: END IF;
745: APP_EXCEPTION.RAISE_EXCEPTION;
746:
747: END invoice_post_update;

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',
861: current_calling_sequence);
862: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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',
861: current_calling_sequence);
862: FND_MESSAGE.SET_TOKEN('PARAMETERS',
863: 'X_invoice_id = ' ||X_invoice_id

Line 860: FND_MESSAGE.SET_TOKEN('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',
861: current_calling_sequence);
862: FND_MESSAGE.SET_TOKEN('PARAMETERS',
863: 'X_invoice_id = ' ||X_invoice_id
864: ||', X_type_1099 = ' ||X_type_1099

Line 862: FND_MESSAGE.SET_TOKEN('PARAMETERS',

858: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
859: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
860: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
861: current_calling_sequence);
862: FND_MESSAGE.SET_TOKEN('PARAMETERS',
863: 'X_invoice_id = ' ||X_invoice_id
864: ||', X_type_1099 = ' ||X_type_1099
865: ||', X_income_tax_region = ' ||X_income_tax_region
866: ||', X_vendor_changed_flag = ' ||X_vendor_changed_flag

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

875: ||', X_highest_line_num = ' ||X_highest_line_num
876: ||', X_actual_invoice_count = ' ||X_actual_invoice_count
877: ||', X_actual_invoice_total = ' ||X_actual_invoice_total
878: ||', X_line_total = ' ||X_Line_total );
879: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
880: END IF;
881: APP_EXCEPTION.RAISE_EXCEPTION;
882:
883: END post_forms_commit;

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

912:
913: EXCEPTION
914: WHEN OTHERS THEN
915: if (SQLCODE <> -20001) then
916: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
917: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
918: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
919: FND_MESSAGE.SET_TOKEN('PARAMETERS','Batch Id = '||X_Batch_ID
920: ||',Total = '||X_Total

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

913: EXCEPTION
914: WHEN OTHERS THEN
915: if (SQLCODE <> -20001) then
916: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
917: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
918: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
919: FND_MESSAGE.SET_TOKEN('PARAMETERS','Batch Id = '||X_Batch_ID
920: ||',Total = '||X_Total
921: ||',Total RTOT DB = '||

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

914: WHEN OTHERS THEN
915: if (SQLCODE <> -20001) then
916: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
917: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
918: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
919: FND_MESSAGE.SET_TOKEN('PARAMETERS','Batch Id = '||X_Batch_ID
920: ||',Total = '||X_Total
921: ||',Total RTOT DB = '||
922: X_Total_Rtot_DB);

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

915: if (SQLCODE <> -20001) then
916: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
917: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
918: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
919: FND_MESSAGE.SET_TOKEN('PARAMETERS','Batch Id = '||X_Batch_ID
920: ||',Total = '||X_Total
921: ||',Total RTOT DB = '||
922: X_Total_Rtot_DB);
923: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);

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

919: FND_MESSAGE.SET_TOKEN('PARAMETERS','Batch Id = '||X_Batch_ID
920: ||',Total = '||X_Total
921: ||',Total RTOT DB = '||
922: X_Total_Rtot_DB);
923: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
924: end if;
925: APP_EXCEPTION.RAISE_EXCEPTION;
926: END Select_Summary;
927: