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_R11_PREPAY_PKG dependencies on FND_MESSAGE

Line 826: FND_MESSAGE.SET_NAME('SQLAP','AP_INV_PREPAY_GT_NOT_ON_HOLD');

822:
823: EXCEPTION
824: WHEN NO_DATA_FOUND then
825: if (debug_info = 'The apply amount is more than amount not on hold') then
826: FND_MESSAGE.SET_NAME('SQLAP','AP_INV_PREPAY_GT_NOT_ON_HOLD');
827: FND_MESSAGE.SET_TOKEN('INVOICE_NUM',invoice_number);
828: APP_EXCEPTION.RAISE_EXCEPTION;
829: else
830: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

Line 827: FND_MESSAGE.SET_TOKEN('INVOICE_NUM',invoice_number);

823: EXCEPTION
824: WHEN NO_DATA_FOUND then
825: if (debug_info = 'The apply amount is more than amount not on hold') then
826: FND_MESSAGE.SET_NAME('SQLAP','AP_INV_PREPAY_GT_NOT_ON_HOLD');
827: FND_MESSAGE.SET_TOKEN('INVOICE_NUM',invoice_number);
828: APP_EXCEPTION.RAISE_EXCEPTION;
829: else
830: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
831: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

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

826: FND_MESSAGE.SET_NAME('SQLAP','AP_INV_PREPAY_GT_NOT_ON_HOLD');
827: FND_MESSAGE.SET_TOKEN('INVOICE_NUM',invoice_number);
828: APP_EXCEPTION.RAISE_EXCEPTION;
829: else
830: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
831: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
832: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
833: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_id = '||TO_CHAR(X_invoice_id)
834: ||' Prepay_id = '||TO_CHAR(X_prepay_id)

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

827: FND_MESSAGE.SET_TOKEN('INVOICE_NUM',invoice_number);
828: APP_EXCEPTION.RAISE_EXCEPTION;
829: else
830: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
831: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
832: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
833: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_id = '||TO_CHAR(X_invoice_id)
834: ||' Prepay_id = '||TO_CHAR(X_prepay_id)
835: ||' Amount_apply = '||TO_CHAR(X_amount_apply)

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

828: APP_EXCEPTION.RAISE_EXCEPTION;
829: else
830: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
831: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
832: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
833: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_id = '||TO_CHAR(X_invoice_id)
834: ||' Prepay_id = '||TO_CHAR(X_prepay_id)
835: ||' Amount_apply = '||TO_CHAR(X_amount_apply)
836: ||' User_id = '||TO_CHAR(X_user_id)

Line 833: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_id = '||TO_CHAR(X_invoice_id)

829: else
830: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
831: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
832: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
833: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_id = '||TO_CHAR(X_invoice_id)
834: ||' Prepay_id = '||TO_CHAR(X_prepay_id)
835: ||' Amount_apply = '||TO_CHAR(X_amount_apply)
836: ||' User_id = '||TO_CHAR(X_user_id)
837: ||' Last_update_login = '||TO_CHAR(X_last_update_login)

Line 842: FND_MESSAGE.SET_TOKEN('DEBUG_INFO','No currency code for this prepayment');

838: ||' gl_date = '||TO_CHAR(X_gl_date)
839: ||' Period_name = '||X_period_name);
840:
841: if (debug_info = 'Get min_unit and precision for the prepayment') then
842: FND_MESSAGE.SET_TOKEN('DEBUG_INFO','No currency code for this prepayment');
843: APP_EXCEPTION.RAISE_EXCEPTION;
844: elsif(debug_info ='Get min_unit and precision from base_currency') then
845: FND_MESSAGE.SET_TOKEN('DEBUG_INFO','No Base currency code');
846: APP_EXCEPTION.RAISE_EXCEPTION;

Line 845: FND_MESSAGE.SET_TOKEN('DEBUG_INFO','No Base currency code');

841: if (debug_info = 'Get min_unit and precision for the prepayment') then
842: FND_MESSAGE.SET_TOKEN('DEBUG_INFO','No currency code for this prepayment');
843: APP_EXCEPTION.RAISE_EXCEPTION;
844: elsif(debug_info ='Get min_unit and precision from base_currency') then
845: FND_MESSAGE.SET_TOKEN('DEBUG_INFO','No Base currency code');
846: APP_EXCEPTION.RAISE_EXCEPTION;
847: elsif(debug_info ='Get period_name') then
848: FND_MESSAGE.SET_TOKEN('DEBUG_INFO','the GL_date(sysdate) is not in an open period');
849: APP_EXCEPTION.RAISE_EXCEPTION;

Line 848: FND_MESSAGE.SET_TOKEN('DEBUG_INFO','the GL_date(sysdate) is not in an open period');

844: elsif(debug_info ='Get min_unit and precision from base_currency') then
845: FND_MESSAGE.SET_TOKEN('DEBUG_INFO','No Base currency code');
846: APP_EXCEPTION.RAISE_EXCEPTION;
847: elsif(debug_info ='Get period_name') then
848: FND_MESSAGE.SET_TOKEN('DEBUG_INFO','the GL_date(sysdate) is not in an open period');
849: APP_EXCEPTION.RAISE_EXCEPTION;
850: else
851: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
852: APP_EXCEPTION.RAISE_EXCEPTION;

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

847: elsif(debug_info ='Get period_name') then
848: FND_MESSAGE.SET_TOKEN('DEBUG_INFO','the GL_date(sysdate) is not in an open period');
849: APP_EXCEPTION.RAISE_EXCEPTION;
850: else
851: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
852: APP_EXCEPTION.RAISE_EXCEPTION;
853: end if;
854: end if;
855:

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

854: end if;
855:
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','Invoice_id = '||TO_CHAR(X_invoice_id)
862: ||' Prepay_id = '||TO_CHAR(X_prepay_id)

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

855:
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','Invoice_id = '||TO_CHAR(X_invoice_id)
862: ||' Prepay_id = '||TO_CHAR(X_prepay_id)
863: ||' Amount_apply = '||TO_CHAR(X_amount_apply)

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','Invoice_id = '||TO_CHAR(X_invoice_id)
862: ||' Prepay_id = '||TO_CHAR(X_prepay_id)
863: ||' Amount_apply = '||TO_CHAR(X_amount_apply)
864: ||' User_id = '||TO_CHAR(X_user_id)

Line 861: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_id = '||TO_CHAR(X_invoice_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','Invoice_id = '||TO_CHAR(X_invoice_id)
862: ||' Prepay_id = '||TO_CHAR(X_prepay_id)
863: ||' Amount_apply = '||TO_CHAR(X_amount_apply)
864: ||' User_id = '||TO_CHAR(X_user_id)
865: ||' Last_update_login = '||TO_CHAR(X_last_update_login)

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

864: ||' User_id = '||TO_CHAR(X_user_id)
865: ||' Last_update_login = '||TO_CHAR(X_last_update_login)
866: ||' gl_date = '||TO_CHAR(X_gl_date)
867: ||' Period_name = '||X_period_name);
868: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
869: end if;
870:
871: APP_EXCEPTION.RAISE_EXCEPTION;
872:

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

962:
963: WHEN OTHERS then
964:
965: if (SQLCODE <> -20001 ) then
966: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
967: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
968: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
969: FND_MESSAGE.SET_TOKEN('PARAMETERS','Prepay_id = '||TO_CHAR(X_prepay_id)
970: ||' Invoice_id = '||TO_CHAR(X_invoice_id)

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

963: WHEN OTHERS then
964:
965: if (SQLCODE <> -20001 ) then
966: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
967: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
968: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
969: FND_MESSAGE.SET_TOKEN('PARAMETERS','Prepay_id = '||TO_CHAR(X_prepay_id)
970: ||' Invoice_id = '||TO_CHAR(X_invoice_id)
971: ||' Amount_apply = '||TO_CHAR(X_amount_apply)

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

964:
965: if (SQLCODE <> -20001 ) then
966: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
967: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
968: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
969: FND_MESSAGE.SET_TOKEN('PARAMETERS','Prepay_id = '||TO_CHAR(X_prepay_id)
970: ||' Invoice_id = '||TO_CHAR(X_invoice_id)
971: ||' Amount_apply = '||TO_CHAR(X_amount_apply)
972: ||' User_id = '||TO_CHAR(X_user_id)

Line 969: FND_MESSAGE.SET_TOKEN('PARAMETERS','Prepay_id = '||TO_CHAR(X_prepay_id)

965: if (SQLCODE <> -20001 ) then
966: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
967: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
968: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
969: FND_MESSAGE.SET_TOKEN('PARAMETERS','Prepay_id = '||TO_CHAR(X_prepay_id)
970: ||' Invoice_id = '||TO_CHAR(X_invoice_id)
971: ||' Amount_apply = '||TO_CHAR(X_amount_apply)
972: ||' User_id = '||TO_CHAR(X_user_id)
973: ||' Last_update_login = '||TO_CHAR(X_last_update_login)

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

973: ||' Last_update_login = '||TO_CHAR(X_last_update_login)
974: ||' Base_currency = '||X_base_currency
975: ||' Min_unit = '||TO_CHAR(X_min_unit)
976: ||' Precision = '||TO_CHAR(X_precision));
977: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
978: end if;
979:
980: APP_EXCEPTION.RAISE_EXCEPTION;
981:

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

1135: EXCEPTION
1136: WHEN OTHERS then
1137:
1138: if (SQLCODE <> -20001 ) then
1139: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1140: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1141: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1142: FND_MESSAGE.SET_TOKEN('PARAMETERS','Prepay_id = '||TO_CHAR(X_prepay_id)
1143: ||' Dist_line_amount = '||TO_CHAR(X_dist_line_amount)

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

1136: WHEN OTHERS then
1137:
1138: if (SQLCODE <> -20001 ) then
1139: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1140: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1141: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1142: FND_MESSAGE.SET_TOKEN('PARAMETERS','Prepay_id = '||TO_CHAR(X_prepay_id)
1143: ||' Dist_line_amount = '||TO_CHAR(X_dist_line_amount)
1144: ||' Copy_dist_num = '||TO_CHAR(X_copy_dist_num)

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

1137:
1138: if (SQLCODE <> -20001 ) then
1139: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1140: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1141: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1142: FND_MESSAGE.SET_TOKEN('PARAMETERS','Prepay_id = '||TO_CHAR(X_prepay_id)
1143: ||' Dist_line_amount = '||TO_CHAR(X_dist_line_amount)
1144: ||' Copy_dist_num = '||TO_CHAR(X_copy_dist_num)
1145: ||' User_id = '||TO_CHAR(X_user_id)

Line 1142: FND_MESSAGE.SET_TOKEN('PARAMETERS','Prepay_id = '||TO_CHAR(X_prepay_id)

1138: if (SQLCODE <> -20001 ) then
1139: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1140: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1141: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1142: FND_MESSAGE.SET_TOKEN('PARAMETERS','Prepay_id = '||TO_CHAR(X_prepay_id)
1143: ||' Dist_line_amount = '||TO_CHAR(X_dist_line_amount)
1144: ||' Copy_dist_num = '||TO_CHAR(X_copy_dist_num)
1145: ||' User_id = '||TO_CHAR(X_user_id)
1146: ||' Last_update_login = '||TO_CHAR(X_last_update_login)

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

1149: ||' Min_unit = '||TO_CHAR(X_min_unit)
1150: ||' Precision = '||TO_CHAR(X_precision)
1151: ||' gl_date = '||TO_CHAR(X_gl_date)
1152: ||' Period_name = '||X_period_name);
1153: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1154: end if;
1155:
1156: APP_EXCEPTION.RAISE_EXCEPTION;
1157:

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

1246: EXCEPTION
1247: WHEN OTHERS then
1248:
1249: if (SQLCODE <> -20001 ) then
1250: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1251: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1252: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1253: FND_MESSAGE.SET_TOKEN('PARAMETERS',' Prepay_id = '||TO_CHAR(X_prepay_id)
1254: ||' Amount_apply = '||TO_CHAR(X_amount_apply)

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

1247: WHEN OTHERS then
1248:
1249: if (SQLCODE <> -20001 ) then
1250: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1251: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1252: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1253: FND_MESSAGE.SET_TOKEN('PARAMETERS',' Prepay_id = '||TO_CHAR(X_prepay_id)
1254: ||' Amount_apply = '||TO_CHAR(X_amount_apply)
1255: ||' Max_payment_num = '||TO_CHAR(X_max_pay_num)

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

1248:
1249: if (SQLCODE <> -20001 ) then
1250: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1251: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1252: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1253: FND_MESSAGE.SET_TOKEN('PARAMETERS',' Prepay_id = '||TO_CHAR(X_prepay_id)
1254: ||' Amount_apply = '||TO_CHAR(X_amount_apply)
1255: ||' Max_payment_num = '||TO_CHAR(X_max_pay_num)
1256: ||' Copy_payment_num = '||TO_CHAR(X_copy_payment_num)

Line 1253: FND_MESSAGE.SET_TOKEN('PARAMETERS',' Prepay_id = '||TO_CHAR(X_prepay_id)

1249: if (SQLCODE <> -20001 ) then
1250: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1251: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1252: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1253: FND_MESSAGE.SET_TOKEN('PARAMETERS',' Prepay_id = '||TO_CHAR(X_prepay_id)
1254: ||' Amount_apply = '||TO_CHAR(X_amount_apply)
1255: ||' Max_payment_num = '||TO_CHAR(X_max_pay_num)
1256: ||' Copy_payment_num = '||TO_CHAR(X_copy_payment_num)
1257: ||' User_id = '||TO_CHAR(X_user_id)

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

1257: ||' User_id = '||TO_CHAR(X_user_id)
1258: ||' Last_update_login = '||TO_CHAR(X_last_update_login)
1259: ||' Min_unit = '||TO_CHAR(X_min_unit)
1260: ||' Precision = '||TO_CHAR(X_precision));
1261: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1262: end if;
1263:
1264: APP_EXCEPTION.RAISE_EXCEPTION;
1265:

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

1522: EXCEPTION
1523: WHEN OTHERS then
1524:
1525: if (SQLCODE <> -20001 ) then
1526: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1527: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1528: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1529: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_id = '||TO_CHAR(X_invoice_id)
1530: ||' Prepay_id = '||TO_CHAR(X_prepay_id)

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

1523: WHEN OTHERS then
1524:
1525: if (SQLCODE <> -20001 ) then
1526: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1527: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1528: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1529: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_id = '||TO_CHAR(X_invoice_id)
1530: ||' Prepay_id = '||TO_CHAR(X_prepay_id)
1531: ||' Amount_apply = '||TO_CHAR(X_amount_apply)

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

1524:
1525: if (SQLCODE <> -20001 ) then
1526: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1527: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1528: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1529: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_id = '||TO_CHAR(X_invoice_id)
1530: ||' Prepay_id = '||TO_CHAR(X_prepay_id)
1531: ||' Amount_apply = '||TO_CHAR(X_amount_apply)
1532: ||' Amount_positive = '||X_amount_positive

Line 1529: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_id = '||TO_CHAR(X_invoice_id)

1525: if (SQLCODE <> -20001 ) then
1526: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1527: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1528: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1529: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_id = '||TO_CHAR(X_invoice_id)
1530: ||' Prepay_id = '||TO_CHAR(X_prepay_id)
1531: ||' Amount_apply = '||TO_CHAR(X_amount_apply)
1532: ||' Amount_positive = '||X_amount_positive
1533: ||' Amount_apply_remaining = '||TO_CHAR(C_amount_apply_remaining)

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

1544: ||' Min_unit = '||TO_CHAR(X_min_unit)
1545: ||' Precision = '||TO_CHAR(X_precision)
1546: ||' gl_date = '||TO_CHAR(X_gl_date)
1547: ||' Period_name = '||X_period_name);
1548: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1549: end if;
1550:
1551: APP_EXCEPTION.RAISE_EXCEPTION;
1552:

Line 1801: FND_MESSAGE.SET_NAME('SQLAP','AP_PAY_DIST_NOT_FLEXBUILT');

1797: EXCEPTION
1798: WHEN NO_DATA_FOUND then
1799:
1800: if (debug_info = 'Check flexbuilt') then
1801: FND_MESSAGE.SET_NAME('SQLAP','AP_PAY_DIST_NOT_FLEXBUILT');
1802: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1803: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1804: FND_MESSAGE.SET_TOKEN('PARAMETERS','Prepay_id = '||TO_CHAR(X_prepay_id)
1805: ||' New_invoice_id = '||TO_CHAR(X_new_invoice_id)

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

1798: WHEN NO_DATA_FOUND then
1799:
1800: if (debug_info = 'Check flexbuilt') then
1801: FND_MESSAGE.SET_NAME('SQLAP','AP_PAY_DIST_NOT_FLEXBUILT');
1802: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1803: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1804: FND_MESSAGE.SET_TOKEN('PARAMETERS','Prepay_id = '||TO_CHAR(X_prepay_id)
1805: ||' New_invoice_id = '||TO_CHAR(X_new_invoice_id)
1806: ||' Invoice_type = '||C_invoice_type

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

1799:
1800: if (debug_info = 'Check flexbuilt') then
1801: FND_MESSAGE.SET_NAME('SQLAP','AP_PAY_DIST_NOT_FLEXBUILT');
1802: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1803: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1804: FND_MESSAGE.SET_TOKEN('PARAMETERS','Prepay_id = '||TO_CHAR(X_prepay_id)
1805: ||' New_invoice_id = '||TO_CHAR(X_new_invoice_id)
1806: ||' Invoice_type = '||C_invoice_type
1807: ||' Amount_apply = '||TO_CHAR(X_amount_apply)

Line 1804: FND_MESSAGE.SET_TOKEN('PARAMETERS','Prepay_id = '||TO_CHAR(X_prepay_id)

1800: if (debug_info = 'Check flexbuilt') then
1801: FND_MESSAGE.SET_NAME('SQLAP','AP_PAY_DIST_NOT_FLEXBUILT');
1802: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1803: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1804: FND_MESSAGE.SET_TOKEN('PARAMETERS','Prepay_id = '||TO_CHAR(X_prepay_id)
1805: ||' New_invoice_id = '||TO_CHAR(X_new_invoice_id)
1806: ||' Invoice_type = '||C_invoice_type
1807: ||' Amount_apply = '||TO_CHAR(X_amount_apply)
1808: ||' Copy_inv_pay_id = '||TO_CHAR(X_copy_inv_pay_id)

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

1817: ||' Min_unit = '||TO_CHAR(X_min_unit)
1818: ||' Precision = '||TO_CHAR(X_precision)
1819: ||' gl_date = '||TO_CHAR(X_gl_date)
1820: ||' Period_name = '||X_period_name);
1821: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1822: APP_EXCEPTION.RAISE_EXCEPTION;
1823:
1824: end if;
1825:

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

1825:
1826: WHEN OTHERS then
1827:
1828: if (SQLCODE <> -20001) then
1829: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1830: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1831: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1832: FND_MESSAGE.SET_TOKEN('PARAMETERS','Prepay_id = '||TO_CHAR(X_prepay_id)
1833: ||' New_invoice_id = '||TO_CHAR(X_new_invoice_id)

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

1826: WHEN OTHERS then
1827:
1828: if (SQLCODE <> -20001) then
1829: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1830: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1831: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1832: FND_MESSAGE.SET_TOKEN('PARAMETERS','Prepay_id = '||TO_CHAR(X_prepay_id)
1833: ||' New_invoice_id = '||TO_CHAR(X_new_invoice_id)
1834: ||' Invoice_type = '||C_invoice_type

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

1827:
1828: if (SQLCODE <> -20001) then
1829: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1830: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1831: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1832: FND_MESSAGE.SET_TOKEN('PARAMETERS','Prepay_id = '||TO_CHAR(X_prepay_id)
1833: ||' New_invoice_id = '||TO_CHAR(X_new_invoice_id)
1834: ||' Invoice_type = '||C_invoice_type
1835: ||' Amount_apply = '||TO_CHAR(X_amount_apply)

Line 1832: FND_MESSAGE.SET_TOKEN('PARAMETERS','Prepay_id = '||TO_CHAR(X_prepay_id)

1828: if (SQLCODE <> -20001) then
1829: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1830: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1831: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1832: FND_MESSAGE.SET_TOKEN('PARAMETERS','Prepay_id = '||TO_CHAR(X_prepay_id)
1833: ||' New_invoice_id = '||TO_CHAR(X_new_invoice_id)
1834: ||' Invoice_type = '||C_invoice_type
1835: ||' Amount_apply = '||TO_CHAR(X_amount_apply)
1836: ||' Copy_inv_pay_id = '||TO_CHAR(X_copy_inv_pay_id)

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

1845: ||' Min_unit = '||TO_CHAR(X_min_unit)
1846: ||' Precision = '||TO_CHAR(X_precision)
1847: ||' gl_date = '||TO_CHAR(X_gl_date)
1848: ||' Period_name = '||X_period_name);
1849: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1850: end if;
1851:
1852: APP_EXCEPTION.RAISE_EXCEPTION;
1853:

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

1945: EXCEPTION
1946: WHEN OTHERS then
1947:
1948: if (SQLCODE <> -20001) then
1949: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1950: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1951: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1952: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_id = '||TO_CHAR(X_invoice_id)
1953: ||' Prepay_id = '||TO_CHAR(X_prepay_id)

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

1946: WHEN OTHERS then
1947:
1948: if (SQLCODE <> -20001) then
1949: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1950: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1951: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1952: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_id = '||TO_CHAR(X_invoice_id)
1953: ||' Prepay_id = '||TO_CHAR(X_prepay_id)
1954: ||' Amount_apply = '||TO_CHAR(X_amount_apply)

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

1947:
1948: if (SQLCODE <> -20001) then
1949: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1950: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1951: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1952: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_id = '||TO_CHAR(X_invoice_id)
1953: ||' Prepay_id = '||TO_CHAR(X_prepay_id)
1954: ||' Amount_apply = '||TO_CHAR(X_amount_apply)
1955: ||' User_id = '||TO_CHAR(X_user_id)

Line 1952: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_id = '||TO_CHAR(X_invoice_id)

1948: if (SQLCODE <> -20001) then
1949: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1950: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1951: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1952: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_id = '||TO_CHAR(X_invoice_id)
1953: ||' Prepay_id = '||TO_CHAR(X_prepay_id)
1954: ||' Amount_apply = '||TO_CHAR(X_amount_apply)
1955: ||' User_id = '||TO_CHAR(X_user_id)
1956: ||' Last_update_login = '||TO_CHAR(X_last_update_login)

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

1955: ||' User_id = '||TO_CHAR(X_user_id)
1956: ||' Last_update_login = '||TO_CHAR(X_last_update_login)
1957: ||' Min_unit = '||TO_CHAR(X_min_unit)
1958: ||' Precision = '||TO_CHAR(X_precision));
1959: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1960: end if;
1961:
1962: APP_EXCEPTION.RAISE_EXCEPTION;
1963:

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

2023: EXCEPTION
2024: WHEN OTHERS then
2025:
2026: if (SQLCODE <> -20001) then
2027: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2028: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2029: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2030: FND_MESSAGE.SET_TOKEN('PARAMETERS','prepay_id = '||TO_CHAR(X_prepay_id));
2031: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

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

2024: WHEN OTHERS then
2025:
2026: if (SQLCODE <> -20001) then
2027: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2028: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2029: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2030: FND_MESSAGE.SET_TOKEN('PARAMETERS','prepay_id = '||TO_CHAR(X_prepay_id));
2031: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
2032: end if;

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

2025:
2026: if (SQLCODE <> -20001) then
2027: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2028: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2029: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2030: FND_MESSAGE.SET_TOKEN('PARAMETERS','prepay_id = '||TO_CHAR(X_prepay_id));
2031: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
2032: end if;
2033: APP_EXCEPTION.RAISE_EXCEPTION;

Line 2030: FND_MESSAGE.SET_TOKEN('PARAMETERS','prepay_id = '||TO_CHAR(X_prepay_id));

2026: if (SQLCODE <> -20001) then
2027: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2028: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2029: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2030: FND_MESSAGE.SET_TOKEN('PARAMETERS','prepay_id = '||TO_CHAR(X_prepay_id));
2031: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
2032: end if;
2033: APP_EXCEPTION.RAISE_EXCEPTION;
2034:

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

2027: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2028: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2029: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2030: FND_MESSAGE.SET_TOKEN('PARAMETERS','prepay_id = '||TO_CHAR(X_prepay_id));
2031: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
2032: end if;
2033: APP_EXCEPTION.RAISE_EXCEPTION;
2034:
2035: END app_update_inv_distributions;