DBA Data[Home] [Help]

APPS.AP_PAY_INVOICE_PKG dependencies on FND_MESSAGE

Line 593: FND_MESSAGE.SET_NAME('SQLAP', 'AP_INP_MUST_POST_VOID');

589: EXCEPTION
590:
591: WHEN NO_DATA_FOUND then
592: if (debug_info = 'check void') then
593: FND_MESSAGE.SET_NAME('SQLAP', 'AP_INP_MUST_POST_VOID');
594: APP_EXCEPTION.RAISE_EXCEPTION;
595: elsif(debug_info ='Get period_name') then
596: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
597: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

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

592: if (debug_info = 'check void') then
593: FND_MESSAGE.SET_NAME('SQLAP', 'AP_INP_MUST_POST_VOID');
594: APP_EXCEPTION.RAISE_EXCEPTION;
595: elsif(debug_info ='Get period_name') then
596: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
597: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
598: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
599: FND_MESSAGE.SET_TOKEN('DEBUG_INFO','the GL_date(sysdate) is not in an open period');
600: APP_EXCEPTION.RAISE_EXCEPTION;

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

593: FND_MESSAGE.SET_NAME('SQLAP', 'AP_INP_MUST_POST_VOID');
594: APP_EXCEPTION.RAISE_EXCEPTION;
595: elsif(debug_info ='Get period_name') then
596: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
597: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
598: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
599: FND_MESSAGE.SET_TOKEN('DEBUG_INFO','the GL_date(sysdate) is not in an open period');
600: APP_EXCEPTION.RAISE_EXCEPTION;
601: end if;

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

594: APP_EXCEPTION.RAISE_EXCEPTION;
595: elsif(debug_info ='Get period_name') then
596: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
597: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
598: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
599: FND_MESSAGE.SET_TOKEN('DEBUG_INFO','the GL_date(sysdate) is not in an open period');
600: APP_EXCEPTION.RAISE_EXCEPTION;
601: end if;
602:

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

595: elsif(debug_info ='Get period_name') then
596: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
597: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
598: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
599: FND_MESSAGE.SET_TOKEN('DEBUG_INFO','the GL_date(sysdate) is not in an open period');
600: APP_EXCEPTION.RAISE_EXCEPTION;
601: end if;
602:
603: WHEN OTHERS then

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

601: end if;
602:
603: WHEN OTHERS then
604: if (SQLCODE <> -20001 ) then
605: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
606: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
607: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
608: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_id = '||TO_CHAR(P_invoice_id)
609: ||', Payment_num = '||TO_CHAR(P_payment_num)

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

602:
603: WHEN OTHERS then
604: if (SQLCODE <> -20001 ) then
605: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
606: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
607: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
608: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_id = '||TO_CHAR(P_invoice_id)
609: ||', Payment_num = '||TO_CHAR(P_payment_num)
610: ||', Check_id = '||TO_CHAR(P_check_id)

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

603: WHEN OTHERS then
604: if (SQLCODE <> -20001 ) then
605: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
606: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
607: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
608: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_id = '||TO_CHAR(P_invoice_id)
609: ||', Payment_num = '||TO_CHAR(P_payment_num)
610: ||', Check_id = '||TO_CHAR(P_check_id)
611: ||', Invoice_payment_id = '||TO_CHAR(P_invoice_payment_id)

Line 608: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_id = '||TO_CHAR(P_invoice_id)

604: if (SQLCODE <> -20001 ) then
605: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
606: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
607: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
608: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_id = '||TO_CHAR(P_invoice_id)
609: ||', Payment_num = '||TO_CHAR(P_payment_num)
610: ||', Check_id = '||TO_CHAR(P_check_id)
611: ||', Invoice_payment_id = '||TO_CHAR(P_invoice_payment_id)
612: ||', Old Invoice_payment_id = '||TO_CHAR(P_old_invoice_payment_id)

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

627: ||', future_pay_posted_flag = '||P_future_pay_posted_flag
628: ||', payment_dists_flag = '||P_payment_dists_flag
629: ||', payment_mode = '||P_payment_mode
630: ||', replace_flag = '||P_replace_flag);
631: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
632: end if;
633:
634: APP_EXCEPTION.RAISE_EXCEPTION;
635:

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

744:
745: WHEN OTHERS then
746:
747: if (SQLCODE <> -20001 ) then
748: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
749: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
750: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
751: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_id = '||TO_CHAR(P_invoice_id)
752: ||', Check_id = '||TO_CHAR(P_check_id)

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

745: WHEN OTHERS then
746:
747: if (SQLCODE <> -20001 ) then
748: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
749: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
750: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
751: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_id = '||TO_CHAR(P_invoice_id)
752: ||', Check_id = '||TO_CHAR(P_check_id)
753: ||', Amount = '||TO_CHAR(P_amount)

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

746:
747: if (SQLCODE <> -20001 ) then
748: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
749: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
750: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
751: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_id = '||TO_CHAR(P_invoice_id)
752: ||', Check_id = '||TO_CHAR(P_check_id)
753: ||', Amount = '||TO_CHAR(P_amount)
754: ||', discount_taken = '||TO_CHAR(P_discount_taken)

Line 751: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_id = '||TO_CHAR(P_invoice_id)

747: if (SQLCODE <> -20001 ) then
748: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
749: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
750: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
751: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_id = '||TO_CHAR(P_invoice_id)
752: ||', Check_id = '||TO_CHAR(P_check_id)
753: ||', Amount = '||TO_CHAR(P_amount)
754: ||', discount_taken = '||TO_CHAR(P_discount_taken)
755: ||', Last_updated_by = '||TO_CHAR(P_last_updated_by)

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

756: ||', Last_update_date = '||TO_CHAR(P_last_update_date)
757: ||', payment_dists_flag = '||P_payment_dists_flag
758: ||', payment_mode = '||P_payment_mode
759: ||', replace_flag = '||P_replace_flag);
760: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
761: end if;
762:
763: APP_EXCEPTION.RAISE_EXCEPTION;
764:

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

944: EXCEPTION
945: WHEN OTHERS then
946:
947: if (SQLCODE <> -20001 ) then
948: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
949: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
950: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
951: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_id = '||TO_CHAR(P_invoice_id)
952: ||', Payment_num = '||TO_CHAR(P_payment_num)

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

945: WHEN OTHERS then
946:
947: if (SQLCODE <> -20001 ) then
948: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
949: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
950: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
951: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_id = '||TO_CHAR(P_invoice_id)
952: ||', Payment_num = '||TO_CHAR(P_payment_num)
953: ||', Check_id = '||TO_CHAR(P_check_id)

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

946:
947: if (SQLCODE <> -20001 ) then
948: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
949: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
950: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
951: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_id = '||TO_CHAR(P_invoice_id)
952: ||', Payment_num = '||TO_CHAR(P_payment_num)
953: ||', Check_id = '||TO_CHAR(P_check_id)
954: ||', Invoice_payment_id = '||TO_CHAR(P_invoice_payment_id)

Line 951: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_id = '||TO_CHAR(P_invoice_id)

947: if (SQLCODE <> -20001 ) then
948: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
949: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
950: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
951: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_id = '||TO_CHAR(P_invoice_id)
952: ||', Payment_num = '||TO_CHAR(P_payment_num)
953: ||', Check_id = '||TO_CHAR(P_check_id)
954: ||', Invoice_payment_id = '||TO_CHAR(P_invoice_payment_id)
955: ||', Old Invoice_payment_id = '||TO_CHAR(P_old_invoice_payment_id)

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

1002: ||', payment_dists_flag = '||P_payment_dists_flag
1003: ||', payment_mode = '||P_payment_mode
1004: ||', replace_flag = '||P_replace_flag);
1005:
1006: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1007: end if;
1008:
1009: APP_EXCEPTION.RAISE_EXCEPTION;
1010:

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

1234: EXCEPTION
1235: WHEN OTHERS then
1236:
1237: if (SQLCODE <> -20001 ) then
1238: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1239: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1240: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1241: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_id = '||TO_CHAR(P_invoice_id)
1242: ||', Payment_num = '||TO_CHAR(P_payment_num)

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

1235: WHEN OTHERS then
1236:
1237: if (SQLCODE <> -20001 ) then
1238: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1239: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1240: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1241: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_id = '||TO_CHAR(P_invoice_id)
1242: ||', Payment_num = '||TO_CHAR(P_payment_num)
1243: ||', Check_id = '||TO_CHAR(P_check_id)

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

1236:
1237: if (SQLCODE <> -20001 ) then
1238: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1239: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1240: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1241: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_id = '||TO_CHAR(P_invoice_id)
1242: ||', Payment_num = '||TO_CHAR(P_payment_num)
1243: ||', Check_id = '||TO_CHAR(P_check_id)
1244: ||', Amount = '||TO_CHAR(P_amount)

Line 1241: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_id = '||TO_CHAR(P_invoice_id)

1237: if (SQLCODE <> -20001 ) then
1238: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1239: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1240: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1241: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_id = '||TO_CHAR(P_invoice_id)
1242: ||', Payment_num = '||TO_CHAR(P_payment_num)
1243: ||', Check_id = '||TO_CHAR(P_check_id)
1244: ||', Amount = '||TO_CHAR(P_amount)
1245: ||', discount_taken = '||TO_CHAR(P_discount_taken)

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

1247: ||', Last_update_date = '||TO_CHAR(P_last_update_date)
1248: ||', payment_dists_flag = '||P_payment_dists_flag
1249: ||', payment_mode = '||P_payment_mode
1250: ||', replace_flag = '||P_replace_flag);
1251: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1252: end if;
1253:
1254: APP_EXCEPTION.RAISE_EXCEPTION;
1255:

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

1366: Exception
1367: WHEN OTHERS then
1368:
1369: if (SQLCODE <> -20001 ) then
1370: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1371: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1372: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1373: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_id = '||TO_CHAR(P_invoice_id)
1374: ||', Payment_line_number = '||TO_CHAR(P_payment_line_number)

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

1367: WHEN OTHERS then
1368:
1369: if (SQLCODE <> -20001 ) then
1370: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1371: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1372: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1373: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_id = '||TO_CHAR(P_invoice_id)
1374: ||', Payment_line_number = '||TO_CHAR(P_payment_line_number)
1375: ||', Amount = '||TO_CHAR(P_amount)

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

1368:
1369: if (SQLCODE <> -20001 ) then
1370: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1371: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1372: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1373: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_id = '||TO_CHAR(P_invoice_id)
1374: ||', Payment_line_number = '||TO_CHAR(P_payment_line_number)
1375: ||', Amount = '||TO_CHAR(P_amount)
1376: ||', discount_taken = '||TO_CHAR(P_discount)

Line 1373: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_id = '||TO_CHAR(P_invoice_id)

1369: if (SQLCODE <> -20001 ) then
1370: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1371: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1372: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1373: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_id = '||TO_CHAR(P_invoice_id)
1374: ||', Payment_line_number = '||TO_CHAR(P_payment_line_number)
1375: ||', Amount = '||TO_CHAR(P_amount)
1376: ||', discount_taken = '||TO_CHAR(P_discount)
1377: ||', Last_update_by = '||TO_CHAR(P_last_updated_by)

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

1376: ||', discount_taken = '||TO_CHAR(P_discount)
1377: ||', Last_update_by = '||TO_CHAR(P_last_updated_by)
1378: ||', Last_update_date = '||TO_CHAR(P_last_update_date));
1379:
1380: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1381: end if;
1382:
1383: APP_EXCEPTION.RAISE_EXCEPTION;
1384: