eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_PPA_PKG dependencies on FND_MESSAGE

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

528:
529: EXCEPTION
530: WHEN OTHERS THEN
531: IF (SQLCODE <> -20001) THEN
532: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
533: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
534: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
535: FND_MESSAGE.SET_TOKEN('PARAMETERS',
536: 'Invoice_id = '|| to_char(p_invoice_id)

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

529: EXCEPTION
530: WHEN OTHERS THEN
531: IF (SQLCODE <> -20001) THEN
532: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
533: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
534: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
535: FND_MESSAGE.SET_TOKEN('PARAMETERS',
536: 'Invoice_id = '|| to_char(p_invoice_id)
537: || 'System User = '|| to_char(p_system_user)

Line 534: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);

530: WHEN OTHERS THEN
531: IF (SQLCODE <> -20001) THEN
532: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
533: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
534: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
535: FND_MESSAGE.SET_TOKEN('PARAMETERS',
536: 'Invoice_id = '|| to_char(p_invoice_id)
537: || 'System User = '|| to_char(p_system_user)
538: || 'Receipt Acc Days = '|| to_char(p_receipt_acc_days));

Line 535: FND_MESSAGE.SET_TOKEN('PARAMETERS',

531: IF (SQLCODE <> -20001) THEN
532: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
533: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
534: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
535: FND_MESSAGE.SET_TOKEN('PARAMETERS',
536: 'Invoice_id = '|| to_char(p_invoice_id)
537: || 'System User = '|| to_char(p_system_user)
538: || 'Receipt Acc Days = '|| to_char(p_receipt_acc_days));
539: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

Line 539: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

535: FND_MESSAGE.SET_TOKEN('PARAMETERS',
536: 'Invoice_id = '|| to_char(p_invoice_id)
537: || 'System User = '|| to_char(p_system_user)
538: || 'Receipt Acc Days = '|| to_char(p_receipt_acc_days));
539: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
540: END IF;
541: APP_EXCEPTION.RAISE_EXCEPTION;
542: END Due_Date_Sweeper;
543:

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

633:
634: EXCEPTION
635: WHEN NO_DATA_FOUND THEN
636: l_debug_info := 'Start date should not be null';
637: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
638: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
639: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
640: FND_MESSAGE.SET_TOKEN('PARAMETERS',
641: 'Invoice_id = '|| to_char(p_invoice_id));

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

634: EXCEPTION
635: WHEN NO_DATA_FOUND THEN
636: l_debug_info := 'Start date should not be null';
637: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
638: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
639: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
640: FND_MESSAGE.SET_TOKEN('PARAMETERS',
641: 'Invoice_id = '|| to_char(p_invoice_id));
642: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

Line 639: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);

635: WHEN NO_DATA_FOUND THEN
636: l_debug_info := 'Start date should not be null';
637: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
638: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
639: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
640: FND_MESSAGE.SET_TOKEN('PARAMETERS',
641: 'Invoice_id = '|| to_char(p_invoice_id));
642: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
643: APP_EXCEPTION.RAISE_EXCEPTION;

Line 640: FND_MESSAGE.SET_TOKEN('PARAMETERS',

636: l_debug_info := 'Start date should not be null';
637: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
638: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
639: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
640: FND_MESSAGE.SET_TOKEN('PARAMETERS',
641: 'Invoice_id = '|| to_char(p_invoice_id));
642: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
643: APP_EXCEPTION.RAISE_EXCEPTION;
644: WHEN OTHERS THEN

Line 642: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

638: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
639: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
640: FND_MESSAGE.SET_TOKEN('PARAMETERS',
641: 'Invoice_id = '|| to_char(p_invoice_id));
642: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
643: APP_EXCEPTION.RAISE_EXCEPTION;
644: WHEN OTHERS THEN
645: IF (SQLCODE <> -20001) THEN
646: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

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

642: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
643: APP_EXCEPTION.RAISE_EXCEPTION;
644: WHEN OTHERS THEN
645: IF (SQLCODE <> -20001) THEN
646: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
647: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
648: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
649: FND_MESSAGE.SET_TOKEN('PARAMETERS',
650: 'Invoice_id = '|| to_char(p_invoice_id));

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

643: APP_EXCEPTION.RAISE_EXCEPTION;
644: WHEN OTHERS THEN
645: IF (SQLCODE <> -20001) THEN
646: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
647: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
648: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
649: FND_MESSAGE.SET_TOKEN('PARAMETERS',
650: 'Invoice_id = '|| to_char(p_invoice_id));
651: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

Line 648: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);

644: WHEN OTHERS THEN
645: IF (SQLCODE <> -20001) THEN
646: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
647: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
648: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
649: FND_MESSAGE.SET_TOKEN('PARAMETERS',
650: 'Invoice_id = '|| to_char(p_invoice_id));
651: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
652: END IF;

Line 649: FND_MESSAGE.SET_TOKEN('PARAMETERS',

645: IF (SQLCODE <> -20001) THEN
646: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
647: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
648: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
649: FND_MESSAGE.SET_TOKEN('PARAMETERS',
650: 'Invoice_id = '|| to_char(p_invoice_id));
651: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
652: END IF;
653: APP_EXCEPTION.RAISE_EXCEPTION;

Line 651: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

647: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
648: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
649: FND_MESSAGE.SET_TOKEN('PARAMETERS',
650: 'Invoice_id = '|| to_char(p_invoice_id));
651: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
652: END IF;
653: APP_EXCEPTION.RAISE_EXCEPTION;
654: END Get_Matched_Start_Date;
655:

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

685:
686: EXCEPTION
687: WHEN OTHERS THEN
688: IF (SQLCODE <> -20001) THEN
689: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
690: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
691: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
692: FND_MESSAGE.SET_TOKEN('PARAMETERS',
693: 'Invoice_id = '|| to_char(p_invoice_id));

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

686: EXCEPTION
687: WHEN OTHERS THEN
688: IF (SQLCODE <> -20001) THEN
689: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
690: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
691: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
692: FND_MESSAGE.SET_TOKEN('PARAMETERS',
693: 'Invoice_id = '|| to_char(p_invoice_id));
694: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

Line 691: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);

687: WHEN OTHERS THEN
688: IF (SQLCODE <> -20001) THEN
689: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
690: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
691: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
692: FND_MESSAGE.SET_TOKEN('PARAMETERS',
693: 'Invoice_id = '|| to_char(p_invoice_id));
694: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
695: END IF;

Line 692: FND_MESSAGE.SET_TOKEN('PARAMETERS',

688: IF (SQLCODE <> -20001) THEN
689: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
690: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
691: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
692: FND_MESSAGE.SET_TOKEN('PARAMETERS',
693: 'Invoice_id = '|| to_char(p_invoice_id));
694: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
695: END IF;
696: APP_EXCEPTION.RAISE_EXCEPTION;

Line 694: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

690: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
691: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
692: FND_MESSAGE.SET_TOKEN('PARAMETERS',
693: 'Invoice_id = '|| to_char(p_invoice_id));
694: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
695: END IF;
696: APP_EXCEPTION.RAISE_EXCEPTION;
697: END Get_Inv_Start_Date;
698:

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

741: WHEN NO_DATA_FOUND THEN
742: NULL;
743: WHEN OTHERS THEN
744: IF (SQLCODE <> -20001) THEN
745: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
746: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
747: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
748: FND_MESSAGE.SET_TOKEN('PARAMETERS',
749: 'Invoice_id = '|| to_char(p_invoice_id));

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

742: NULL;
743: WHEN OTHERS THEN
744: IF (SQLCODE <> -20001) THEN
745: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
746: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
747: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
748: FND_MESSAGE.SET_TOKEN('PARAMETERS',
749: 'Invoice_id = '|| to_char(p_invoice_id));
750: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

Line 747: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);

743: WHEN OTHERS THEN
744: IF (SQLCODE <> -20001) THEN
745: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
746: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
747: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
748: FND_MESSAGE.SET_TOKEN('PARAMETERS',
749: 'Invoice_id = '|| to_char(p_invoice_id));
750: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
751: END IF;

Line 748: FND_MESSAGE.SET_TOKEN('PARAMETERS',

744: IF (SQLCODE <> -20001) THEN
745: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
746: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
747: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
748: FND_MESSAGE.SET_TOKEN('PARAMETERS',
749: 'Invoice_id = '|| to_char(p_invoice_id));
750: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
751: END IF;
752: APP_EXCEPTION.RAISE_EXCEPTION;

Line 750: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

746: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
747: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
748: FND_MESSAGE.SET_TOKEN('PARAMETERS',
749: 'Invoice_id = '|| to_char(p_invoice_id));
750: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
751: END IF;
752: APP_EXCEPTION.RAISE_EXCEPTION;
753: END Get_PO_Terms_Info;
754:

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

1010:
1011: EXCEPTION
1012: WHEN OTHERS THEN
1013: IF (SQLCODE <> -20001) THEN
1014: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1015: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1016: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1017: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1018: 'Invoice_id = '|| to_char(p_invoice_id)

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

1011: EXCEPTION
1012: WHEN OTHERS THEN
1013: IF (SQLCODE <> -20001) THEN
1014: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1015: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1016: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1017: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1018: 'Invoice_id = '|| to_char(p_invoice_id)
1019: || 'Curr PS Pay Num = '|| to_char(p_curr_ps_pay_num)

Line 1016: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);

1012: WHEN OTHERS THEN
1013: IF (SQLCODE <> -20001) THEN
1014: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1015: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1016: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1017: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1018: 'Invoice_id = '|| to_char(p_invoice_id)
1019: || 'Curr PS Pay Num = '|| to_char(p_curr_ps_pay_num)
1020: || 'Term Id = '|| to_char(p_term_id)

Line 1017: FND_MESSAGE.SET_TOKEN('PARAMETERS',

1013: IF (SQLCODE <> -20001) THEN
1014: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1015: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1016: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1017: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1018: 'Invoice_id = '|| to_char(p_invoice_id)
1019: || 'Curr PS Pay Num = '|| to_char(p_curr_ps_pay_num)
1020: || 'Term Id = '|| to_char(p_term_id)
1021: || 'Term Name = '|| p_term_name

Line 1023: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

1019: || 'Curr PS Pay Num = '|| to_char(p_curr_ps_pay_num)
1020: || 'Term Id = '|| to_char(p_term_id)
1021: || 'Term Name = '|| p_term_name
1022: || 'System User = '|| to_char(p_system_user));
1023: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1024: END IF;
1025: APP_EXCEPTION.RAISE_EXCEPTION;
1026: END Calc_Pay_Sched;
1027:

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

1063:
1064: EXCEPTION
1065: WHEN OTHERS THEN
1066: IF (SQLCODE <> -20001) THEN
1067: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1068: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1069: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1070: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1071: 'Invoice_id = '|| to_char(p_invoice_id));

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

1064: EXCEPTION
1065: WHEN OTHERS THEN
1066: IF (SQLCODE <> -20001) THEN
1067: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1068: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1069: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1070: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1071: 'Invoice_id = '|| to_char(p_invoice_id));
1072: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

Line 1069: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);

1065: WHEN OTHERS THEN
1066: IF (SQLCODE <> -20001) THEN
1067: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1068: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1069: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1070: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1071: 'Invoice_id = '|| to_char(p_invoice_id));
1072: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1073: END IF;

Line 1070: FND_MESSAGE.SET_TOKEN('PARAMETERS',

1066: IF (SQLCODE <> -20001) THEN
1067: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1068: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1069: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1070: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1071: 'Invoice_id = '|| to_char(p_invoice_id));
1072: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1073: END IF;
1074: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1072: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

1068: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1069: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1070: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1071: 'Invoice_id = '|| to_char(p_invoice_id));
1072: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1073: END IF;
1074: APP_EXCEPTION.RAISE_EXCEPTION;
1075:
1076: END Get_Invoice_Info;

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

1144:
1145: EXCEPTION
1146: WHEN OTHERS THEN
1147: IF (SQLCODE <> -20001) THEN
1148: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1149: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1150: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1151: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1152: 'Invoice_id = '|| to_char(p_invoice_id));

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

1145: EXCEPTION
1146: WHEN OTHERS THEN
1147: IF (SQLCODE <> -20001) THEN
1148: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1149: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1150: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1151: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1152: 'Invoice_id = '|| to_char(p_invoice_id));
1153: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

Line 1150: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);

1146: WHEN OTHERS THEN
1147: IF (SQLCODE <> -20001) THEN
1148: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1149: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1150: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1151: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1152: 'Invoice_id = '|| to_char(p_invoice_id));
1153: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1154: END IF;

Line 1151: FND_MESSAGE.SET_TOKEN('PARAMETERS',

1147: IF (SQLCODE <> -20001) THEN
1148: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1149: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1150: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1151: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1152: 'Invoice_id = '|| to_char(p_invoice_id));
1153: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1154: END IF;
1155: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1153: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

1149: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1150: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1151: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1152: 'Invoice_id = '|| to_char(p_invoice_id));
1153: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1154: END IF;
1155: APP_EXCEPTION.RAISE_EXCEPTION;
1156: END Get_PaySched_Info;
1157:

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

1240:
1241: EXCEPTION
1242: WHEN OTHERS THEN
1243: IF (SQLCODE <> -20001) THEN
1244: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1245: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1246: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1247: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1248: 'Invoice_id = '|| to_char(p_invoice_id)

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

1241: EXCEPTION
1242: WHEN OTHERS THEN
1243: IF (SQLCODE <> -20001) THEN
1244: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1245: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1246: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1247: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1248: 'Invoice_id = '|| to_char(p_invoice_id)
1249: || 'Payment Num = '|| to_char(p_payment_num)

Line 1246: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);

1242: WHEN OTHERS THEN
1243: IF (SQLCODE <> -20001) THEN
1244: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1245: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1246: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1247: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1248: 'Invoice_id = '|| to_char(p_invoice_id)
1249: || 'Payment Num = '|| to_char(p_payment_num)
1250: || 'PPA Due Date = '|| to_char(p_ppa_due_date)

Line 1247: FND_MESSAGE.SET_TOKEN('PARAMETERS',

1243: IF (SQLCODE <> -20001) THEN
1244: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1245: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1246: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1247: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1248: 'Invoice_id = '|| to_char(p_invoice_id)
1249: || 'Payment Num = '|| to_char(p_payment_num)
1250: || 'PPA Due Date = '|| to_char(p_ppa_due_date)
1251: || '1st Disc Amt Avail = '|| to_char(p_1st_disc_amt_available)

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

1294:
1295: EXCEPTION
1296: WHEN OTHERS THEN
1297: IF (SQLCODE <> -20001) THEN
1298: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1299: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1300: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1301: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1302: 'Invoice_id = '|| to_char(p_invoice_id)

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

1295: EXCEPTION
1296: WHEN OTHERS THEN
1297: IF (SQLCODE <> -20001) THEN
1298: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1299: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1300: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1301: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1302: 'Invoice_id = '|| to_char(p_invoice_id)
1303: || 'Payment Num = '|| to_char(p_payment_num));

Line 1300: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);

1296: WHEN OTHERS THEN
1297: IF (SQLCODE <> -20001) THEN
1298: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1299: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1300: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1301: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1302: 'Invoice_id = '|| to_char(p_invoice_id)
1303: || 'Payment Num = '|| to_char(p_payment_num));
1304: END IF;

Line 1301: FND_MESSAGE.SET_TOKEN('PARAMETERS',

1297: IF (SQLCODE <> -20001) THEN
1298: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1299: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1300: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1301: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1302: 'Invoice_id = '|| to_char(p_invoice_id)
1303: || 'Payment Num = '|| to_char(p_payment_num));
1304: END IF;
1305: APP_EXCEPTION.RAISE_EXCEPTION;

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

1610: WHEN NO_DATA_FOUND THEN
1611: RETURN;
1612: WHEN OTHERS THEN
1613: IF (SQLCODE <> -20001) THEN
1614: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1615: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1616: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1617: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1618: ' Invoice_id = '|| to_char(p_invoice_id)

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

1611: RETURN;
1612: WHEN OTHERS THEN
1613: IF (SQLCODE <> -20001) THEN
1614: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1615: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1616: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1617: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1618: ' Invoice_id = '|| to_char(p_invoice_id)
1619: || ' Term Id = '|| to_char(p_term_id)

Line 1616: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);

1612: WHEN OTHERS THEN
1613: IF (SQLCODE <> -20001) THEN
1614: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1615: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1616: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1617: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1618: ' Invoice_id = '|| to_char(p_invoice_id)
1619: || ' Term Id = '|| to_char(p_term_id)
1620: || ' PS Pay Num = '|| to_char(p_ps_pay_num)

Line 1617: FND_MESSAGE.SET_TOKEN('PARAMETERS',

1613: IF (SQLCODE <> -20001) THEN
1614: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1615: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1616: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1617: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1618: ' Invoice_id = '|| to_char(p_invoice_id)
1619: || ' Term Id = '|| to_char(p_term_id)
1620: || ' PS Pay Num = '|| to_char(p_ps_pay_num)
1621: || ' p_start_date = '|| to_char(p_start_date)

Line 1628: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

1624: || ' p_payment_cross_rate = '|| to_char(p_payment_cross_rate)
1625: || ' l_min_unit = '|| to_char(l_min_unit)
1626: || ' l_precision = '|| to_char(l_precision));
1627:
1628: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1629: END IF;
1630: APP_EXCEPTION.RAISE_EXCEPTION;
1631: END Calc_PS_Dates_Percents_Amts;
1632:

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

1747:
1748: EXCEPTION
1749: WHEN OTHERS THEN
1750: IF (SQLCODE <> -20001) THEN
1751: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1752: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1753: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1754: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1755: 'Invoice_id = '|| to_char(p_invoice_id)

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

1748: EXCEPTION
1749: WHEN OTHERS THEN
1750: IF (SQLCODE <> -20001) THEN
1751: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1752: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1753: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1754: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1755: 'Invoice_id = '|| to_char(p_invoice_id)
1756: || 'Pay Sched Pay Num = '|| to_char(p_ps_pay_num)

Line 1753: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);

1749: WHEN OTHERS THEN
1750: IF (SQLCODE <> -20001) THEN
1751: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1752: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1753: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1754: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1755: 'Invoice_id = '|| to_char(p_invoice_id)
1756: || 'Pay Sched Pay Num = '|| to_char(p_ps_pay_num)
1757: || 'System User = '|| to_char(p_system_user)

Line 1754: FND_MESSAGE.SET_TOKEN('PARAMETERS',

1750: IF (SQLCODE <> -20001) THEN
1751: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1752: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1753: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1754: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1755: 'Invoice_id = '|| to_char(p_invoice_id)
1756: || 'Pay Sched Pay Num = '|| to_char(p_ps_pay_num)
1757: || 'System User = '|| to_char(p_system_user)
1758: || 'Pay Cross Rate = '|| to_char(p_payment_cross_rate)

Line 1775: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

1771: || 'Creation Date = '|| to_char(p_creation_date)
1772: || 'Created By = '|| to_char(p_created_by)
1773: || 'Last Update Login = '|| to_char(p_last_update_login)
1774: || 'Payment Method = '|| p_payment_method_code);
1775: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1776: END IF;
1777: APP_EXCEPTION.RAISE_EXCEPTION;
1778: END Insert_Pay_Sched;
1779:

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

1943:
1944: EXCEPTION
1945: WHEN OTHERS THEN
1946: IF (SQLCODE <> -20001) THEN
1947: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1948: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1949: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1950: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1951: 'Invoice_id = '|| to_char(p_invoice_id)

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

1944: EXCEPTION
1945: WHEN OTHERS THEN
1946: IF (SQLCODE <> -20001) THEN
1947: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1948: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1949: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1950: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1951: 'Invoice_id = '|| to_char(p_invoice_id)
1952: || 'Cur PS Pay Num = '|| to_char(p_curr_ps_pay_num)

Line 1949: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);

1945: WHEN OTHERS THEN
1946: IF (SQLCODE <> -20001) THEN
1947: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1948: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1949: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1950: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1951: 'Invoice_id = '|| to_char(p_invoice_id)
1952: || 'Cur PS Pay Num = '|| to_char(p_curr_ps_pay_num)
1953: || 'System User = '|| to_char(p_system_user)

Line 1950: FND_MESSAGE.SET_TOKEN('PARAMETERS',

1946: IF (SQLCODE <> -20001) THEN
1947: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1948: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1949: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
1950: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1951: 'Invoice_id = '|| to_char(p_invoice_id)
1952: || 'Cur PS Pay Num = '|| to_char(p_curr_ps_pay_num)
1953: || 'System User = '|| to_char(p_system_user)
1954: || 'Payment Cross Rate = '|| to_char(p_payment_cross_rate)

Line 1966: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

1962: || 'Created By = '|| to_char(p_created_by)
1963: || 'Last Update Login = '|| to_char(p_last_update_login)
1964: || 'Payment Method Lookup = '|| p_payment_method_code
1965: ||' p_external_bank_account_id = '||to_char(p_external_bank_account_id));
1966: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1967: END IF;
1968: APP_EXCEPTION.RAISE_EXCEPTION;
1969: END Create_Pay_Scheds;
1970:

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

2033:
2034: EXCEPTION
2035: WHEN OTHERS THEN
2036: IF (SQLCODE <> -20001) THEN
2037: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2038: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2039: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
2040: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2041: 'Invoice_id = '|| to_char(p_invoice_id));

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

2034: EXCEPTION
2035: WHEN OTHERS THEN
2036: IF (SQLCODE <> -20001) THEN
2037: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2038: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2039: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
2040: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2041: 'Invoice_id = '|| to_char(p_invoice_id));
2042: END IF;

Line 2039: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);

2035: WHEN OTHERS THEN
2036: IF (SQLCODE <> -20001) THEN
2037: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2038: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2039: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
2040: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2041: 'Invoice_id = '|| to_char(p_invoice_id));
2042: END IF;
2043: APP_EXCEPTION.RAISE_EXCEPTION;

Line 2040: FND_MESSAGE.SET_TOKEN('PARAMETERS',

2036: IF (SQLCODE <> -20001) THEN
2037: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2038: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2039: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
2040: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2041: 'Invoice_id = '|| to_char(p_invoice_id));
2042: END IF;
2043: APP_EXCEPTION.RAISE_EXCEPTION;
2044: