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

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

679:
680: EXCEPTION
681: WHEN OTHERS then
682: IF ((SQLCODE <> -20001) OR (SQLCODE <> -20002) ) then
683: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
684: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
685: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
686: FND_MESSAGE.SET_TOKEN('PARAMETERS',
687: 'Invoice_date = '||TO_CHAR(P_invoice_date)

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

680: EXCEPTION
681: WHEN OTHERS then
682: IF ((SQLCODE <> -20001) OR (SQLCODE <> -20002) ) then
683: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
684: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
685: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
686: FND_MESSAGE.SET_TOKEN('PARAMETERS',
687: 'Invoice_date = '||TO_CHAR(P_invoice_date)
688: ||' Accounting_date = '||TO_CHAR(P_accounting_date)

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

681: WHEN OTHERS then
682: IF ((SQLCODE <> -20001) OR (SQLCODE <> -20002) ) then
683: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
684: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
685: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
686: FND_MESSAGE.SET_TOKEN('PARAMETERS',
687: 'Invoice_date = '||TO_CHAR(P_invoice_date)
688: ||' Accounting_date = '||TO_CHAR(P_accounting_date)
689: ||' Currency_code = '||P_invoice_currency_code

Line 686: FND_MESSAGE.SET_TOKEN('PARAMETERS',

682: IF ((SQLCODE <> -20001) OR (SQLCODE <> -20002) ) then
683: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
684: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
685: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
686: FND_MESSAGE.SET_TOKEN('PARAMETERS',
687: 'Invoice_date = '||TO_CHAR(P_invoice_date)
688: ||' Accounting_date = '||TO_CHAR(P_accounting_date)
689: ||' Currency_code = '||P_invoice_currency_code
690: ||' P_recurring_payment_id = '||TO_CHAR(P_recurring_payment_id)

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

711: ||' Last_updated_by = '||TO_CHAR(P_last_updated_by)
712: ||' Last_updated_date = '||TO_CHAR(P_last_update_date)
713: ||' P_po_match_flag = '||P_po_match_flag
714: ||' P_batch_control_flag = '||P_batch_control_flag);
715: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
716: END IF;
717:
718: APP_EXCEPTION.RAISE_EXCEPTION;
719:

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

986:
987: IF (debug_info = 'get offset tax amount and name') then
988: NULL;
989: ELSE
990: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
991: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
992: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
993: FND_MESSAGE.SET_TOKEN('PARAMETERS',
994: 'Invoice_date = '||TO_CHAR(P_invoice_date)

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

987: IF (debug_info = 'get offset tax amount and name') then
988: NULL;
989: ELSE
990: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
991: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
992: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
993: FND_MESSAGE.SET_TOKEN('PARAMETERS',
994: 'Invoice_date = '||TO_CHAR(P_invoice_date)
995: ||' Invoice_amount = '||TO_CHAR(P_invoice_amount)

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

988: NULL;
989: ELSE
990: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
991: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
992: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
993: FND_MESSAGE.SET_TOKEN('PARAMETERS',
994: 'Invoice_date = '||TO_CHAR(P_invoice_date)
995: ||' Invoice_amount = '||TO_CHAR(P_invoice_amount)
996: ||' Vendor_id = '||TO_CHAR(P_vendor_id)

Line 993: FND_MESSAGE.SET_TOKEN('PARAMETERS',

989: ELSE
990: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
991: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
992: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
993: FND_MESSAGE.SET_TOKEN('PARAMETERS',
994: 'Invoice_date = '||TO_CHAR(P_invoice_date)
995: ||' Invoice_amount = '||TO_CHAR(P_invoice_amount)
996: ||' Vendor_id = '||TO_CHAR(P_vendor_id)
997: ||' Vendor_site_id = '||TO_CHAR(P_vendor_site_id)

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

1000: ||' Tax_id = '||TO_CHAR(P_tax_id)
1001: ||' Currency_code = '||P_invoice_currency_code);
1002:
1003: IF (debug_info = 'Get min_unit and precision') then
1004: FND_MESSAGE.SET_TOKEN('DEBUG_INFO','No currency code for this invoice');
1005: APP_EXCEPTION.RAISE_EXCEPTION;
1006: elsif(debug_info ='Get period name') then
1007: FND_MESSAGE.SET_TOKEN('DEBUG_INFO','the GL_date(sysdate) is not in an open period');
1008: APP_EXCEPTION.RAISE_EXCEPTION;

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

1003: IF (debug_info = 'Get min_unit and precision') then
1004: FND_MESSAGE.SET_TOKEN('DEBUG_INFO','No currency code for this invoice');
1005: APP_EXCEPTION.RAISE_EXCEPTION;
1006: elsif(debug_info ='Get period name') then
1007: FND_MESSAGE.SET_TOKEN('DEBUG_INFO','the GL_date(sysdate) is not in an open period');
1008: APP_EXCEPTION.RAISE_EXCEPTION;
1009: else
1010: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1011: APP_EXCEPTION.RAISE_EXCEPTION;

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

1006: elsif(debug_info ='Get period name') then
1007: FND_MESSAGE.SET_TOKEN('DEBUG_INFO','the GL_date(sysdate) is not in an open period');
1008: APP_EXCEPTION.RAISE_EXCEPTION;
1009: else
1010: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1011: APP_EXCEPTION.RAISE_EXCEPTION;
1012: END IF;
1013: END IF;
1014:

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

1014:
1015: WHEN OTHERS then
1016:
1017: IF ((SQLCODE <> -20001) OR ((SQLCODE <> -20002))) then
1018: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1019: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1020: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1021:
1022: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

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

1015: WHEN OTHERS then
1016:
1017: IF ((SQLCODE <> -20001) OR ((SQLCODE <> -20002))) then
1018: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1019: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1020: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1021:
1022: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1023: END IF;

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

1016:
1017: IF ((SQLCODE <> -20001) OR ((SQLCODE <> -20002))) then
1018: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1019: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1020: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1021:
1022: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1023: END IF;
1024: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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

1018: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1019: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1020: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1021:
1022: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1023: END IF;
1024: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1025: 'Invoice_date = '||TO_CHAR(P_invoice_date)
1026: ||' Invoice_amount = '||TO_CHAR(P_invoice_amount)

Line 1024: FND_MESSAGE.SET_TOKEN('PARAMETERS',

1020: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1021:
1022: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1023: END IF;
1024: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1025: 'Invoice_date = '||TO_CHAR(P_invoice_date)
1026: ||' Invoice_amount = '||TO_CHAR(P_invoice_amount)
1027: ||' Vendor_id = '||TO_CHAR(P_vendor_id)
1028: ||' Vendor_site_id = '||TO_CHAR(P_vendor_site_id)

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

1138: EXCEPTION
1139: WHEN OTHERS then
1140:
1141: IF ((SQLCODE <> -20001) AND ((SQLCODE <> -20002))) then
1142: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1143: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1144: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1145: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1146: 'P_batch_name = '||P_batch_name

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

1139: WHEN OTHERS then
1140:
1141: IF ((SQLCODE <> -20001) AND ((SQLCODE <> -20002))) then
1142: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1143: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1144: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1145: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1146: 'P_batch_name = '||P_batch_name
1147: ||'P_batch_control_flag = '|| P_batch_control_flag

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

1140:
1141: IF ((SQLCODE <> -20001) AND ((SQLCODE <> -20002))) then
1142: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1143: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1144: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1145: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1146: 'P_batch_name = '||P_batch_name
1147: ||'P_batch_control_flag = '|| P_batch_control_flag
1148: ||'P_invoice_currency_code = '||P_invoice_currency_code

Line 1145: FND_MESSAGE.SET_TOKEN('PARAMETERS',

1141: IF ((SQLCODE <> -20001) AND ((SQLCODE <> -20002))) then
1142: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1143: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1144: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1145: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1146: 'P_batch_name = '||P_batch_name
1147: ||'P_batch_control_flag = '|| P_batch_control_flag
1148: ||'P_invoice_currency_code = '||P_invoice_currency_code
1149: ||'P_payment_currency_code = '||P_payment_currency_code

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

1148: ||'P_invoice_currency_code = '||P_invoice_currency_code
1149: ||'P_payment_currency_code = '||P_payment_currency_code
1150: ||'P_last_update_date = '||TO_CHAR(P_last_update_date)
1151: ||'P_last_updated_by = '||TO_CHAR(P_last_updated_by));
1152: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1153: END IF;
1154:
1155: APP_EXCEPTION.RAISE_EXCEPTION;
1156:

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

1525: EXCEPTION
1526: WHEN OTHERS then
1527:
1528: IF ((SQLCODE <> -20001) or ((SQLCODE <> -20002)) ) then
1529: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1530: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1531: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1532: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1533: ' batch_id = '||TO_CHAR(p_batch_id)

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

1526: WHEN OTHERS then
1527:
1528: IF ((SQLCODE <> -20001) or ((SQLCODE <> -20002)) ) then
1529: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1530: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1531: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1532: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1533: ' batch_id = '||TO_CHAR(p_batch_id)
1534: ||' c_source = '||c_source

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

1527:
1528: IF ((SQLCODE <> -20001) or ((SQLCODE <> -20002)) ) then
1529: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1530: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1531: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1532: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1533: ' batch_id = '||TO_CHAR(p_batch_id)
1534: ||' c_source = '||c_source
1535: ||' P_invoice_id = '||TO_CHAR(C_invoice_id)

Line 1532: FND_MESSAGE.SET_TOKEN('PARAMETERS',

1528: IF ((SQLCODE <> -20001) or ((SQLCODE <> -20002)) ) then
1529: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1530: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1531: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1532: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1533: ' batch_id = '||TO_CHAR(p_batch_id)
1534: ||' c_source = '||c_source
1535: ||' P_invoice_id = '||TO_CHAR(C_invoice_id)
1536: ||' P_tax_name = '||P_tax_name

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

1563: ||' Set 0f books id = '||TO_CHAR(P_set_of_books_id)
1564: ||' Last_updated_by = '||TO_CHAR(P_last_updated_by)
1565: ||' Last_updated_date = '||TO_CHAR(P_last_update_date));
1566:
1567: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1568: END IF;
1569:
1570: APP_EXCEPTION.RAISE_EXCEPTION;
1571:

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

1710: ELSIF (debug_info = 'Get next year period_num') then
1711: NULL;
1712: else
1713:
1714: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1715: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1716: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1717: FND_MESSAGE.SET_TOKEN('PARAMETERS','Period_type = '||P_period_type
1718: ||' Current period name = '||P_current_period_name);

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

1711: NULL;
1712: else
1713:
1714: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1715: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1716: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1717: FND_MESSAGE.SET_TOKEN('PARAMETERS','Period_type = '||P_period_type
1718: ||' Current period name = '||P_current_period_name);
1719: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

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

1712: else
1713:
1714: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1715: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1716: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1717: FND_MESSAGE.SET_TOKEN('PARAMETERS','Period_type = '||P_period_type
1718: ||' Current period name = '||P_current_period_name);
1719: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1720: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1717: FND_MESSAGE.SET_TOKEN('PARAMETERS','Period_type = '||P_period_type

1713:
1714: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1715: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1716: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1717: FND_MESSAGE.SET_TOKEN('PARAMETERS','Period_type = '||P_period_type
1718: ||' Current period name = '||P_current_period_name);
1719: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1720: APP_EXCEPTION.RAISE_EXCEPTION;
1721: END IF;

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

1715: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1716: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1717: FND_MESSAGE.SET_TOKEN('PARAMETERS','Period_type = '||P_period_type
1718: ||' Current period name = '||P_current_period_name);
1719: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1720: APP_EXCEPTION.RAISE_EXCEPTION;
1721: END IF;
1722:
1723: WHEN OTHERS then

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

1722:
1723: WHEN OTHERS then
1724:
1725: IF (SQLCODE <> -20001 ) then
1726: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1727: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1728: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1729: FND_MESSAGE.SET_TOKEN('PARAMETERS','Period_type = '||P_period_type
1730: ||' Current period name = '||P_current_period_name);

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

1723: WHEN OTHERS then
1724:
1725: IF (SQLCODE <> -20001 ) then
1726: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1727: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1728: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1729: FND_MESSAGE.SET_TOKEN('PARAMETERS','Period_type = '||P_period_type
1730: ||' Current period name = '||P_current_period_name);
1731: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

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

1724:
1725: IF (SQLCODE <> -20001 ) then
1726: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1727: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1728: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1729: FND_MESSAGE.SET_TOKEN('PARAMETERS','Period_type = '||P_period_type
1730: ||' Current period name = '||P_current_period_name);
1731: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1732: END IF;

Line 1729: FND_MESSAGE.SET_TOKEN('PARAMETERS','Period_type = '||P_period_type

1725: IF (SQLCODE <> -20001 ) then
1726: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1727: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1728: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1729: FND_MESSAGE.SET_TOKEN('PARAMETERS','Period_type = '||P_period_type
1730: ||' Current period name = '||P_current_period_name);
1731: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1732: END IF;
1733:

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

1727: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1728: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1729: FND_MESSAGE.SET_TOKEN('PARAMETERS','Period_type = '||P_period_type
1730: ||' Current period name = '||P_current_period_name);
1731: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1732: END IF;
1733:
1734: APP_EXCEPTION.RAISE_EXCEPTION;
1735:

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

1811:
1812: WHEN OTHERS then
1813:
1814: IF (SQLCODE <> -20001 ) then
1815: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1816: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1817: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1818: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1819: 'Increment_percent = '||TO_CHAR(P_increment_percent)

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

1812: WHEN OTHERS then
1813:
1814: IF (SQLCODE <> -20001 ) then
1815: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1816: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1817: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1818: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1819: 'Increment_percent = '||TO_CHAR(P_increment_percent)
1820: ||' Next period name = '||P_next_period_name);

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

1813:
1814: IF (SQLCODE <> -20001 ) then
1815: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1816: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1817: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1818: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1819: 'Increment_percent = '||TO_CHAR(P_increment_percent)
1820: ||' Next period name = '||P_next_period_name);
1821: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

Line 1818: FND_MESSAGE.SET_TOKEN('PARAMETERS',

1814: IF (SQLCODE <> -20001 ) then
1815: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1816: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1817: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1818: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1819: 'Increment_percent = '||TO_CHAR(P_increment_percent)
1820: ||' Next period name = '||P_next_period_name);
1821: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1822: END IF;

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

1817: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1818: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1819: 'Increment_percent = '||TO_CHAR(P_increment_percent)
1820: ||' Next period name = '||P_next_period_name);
1821: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1822: END IF;
1823:
1824: APP_EXCEPTION.RAISE_EXCEPTION;
1825:

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

1963:
1964: WHEN OTHERS then
1965:
1966: IF (SQLCODE <> -20001 ) then
1967: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1968: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1969: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1970: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1971: 'first_period_name = '||P_first_period_name

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

1964: WHEN OTHERS then
1965:
1966: IF (SQLCODE <> -20001 ) then
1967: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1968: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1969: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1970: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1971: 'first_period_name = '||P_first_period_name
1972: ||' P_special_period_name1 = '||P_special_period_name1

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

1965:
1966: IF (SQLCODE <> -20001 ) then
1967: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1968: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1969: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1970: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1971: 'first_period_name = '||P_first_period_name
1972: ||' P_special_period_name1 = '||P_special_period_name1
1973: ||' P_special_payment_amount1 = '||TO_CHAR(P_special_payment_amount1)

Line 1970: FND_MESSAGE.SET_TOKEN('PARAMETERS',

1966: IF (SQLCODE <> -20001 ) then
1967: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1968: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1969: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1970: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1971: 'first_period_name = '||P_first_period_name
1972: ||' P_special_period_name1 = '||P_special_period_name1
1973: ||' P_special_payment_amount1 = '||TO_CHAR(P_special_payment_amount1)
1974: ||' P_special_period_name2 = '||P_special_period_name2

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

1976: ||' P_number_of_regular_periods = '||TO_CHAR(P_number_of_regular_periods)
1977: ||' P_amount_source_flag = '||P_amount_source_flag
1978: ||' P_increment_percent = '||TO_CHAR(P_increment_percent)
1979: ||' P_currency_code = '||P_currency_code);
1980: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1981: END IF;
1982:
1983: APP_EXCEPTION.RAISE_EXCEPTION;
1984:

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

2362: EXCEPTION
2363:
2364: WHEN OTHERS then
2365: IF ((SQLCODE <> -20001) OR ((SQLCODE <> -20002))) then
2366: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2367: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2368: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2369: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
2370: END IF;

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

2363:
2364: WHEN OTHERS then
2365: IF ((SQLCODE <> -20001) OR ((SQLCODE <> -20002))) then
2366: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2367: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2368: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2369: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
2370: END IF;
2371: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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

2364: WHEN OTHERS then
2365: IF ((SQLCODE <> -20001) OR ((SQLCODE <> -20002))) then
2366: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2367: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2368: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2369: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
2370: END IF;
2371: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2372: ' Invoice_line_Number = '||TO_CHAR(l_invoice_line_number)

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

2365: IF ((SQLCODE <> -20001) OR ((SQLCODE <> -20002))) then
2366: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2367: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2368: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2369: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
2370: END IF;
2371: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2372: ' Invoice_line_Number = '||TO_CHAR(l_invoice_line_number)
2373: ||' Asset_bt_code = '||P_asset_bt_code

Line 2371: FND_MESSAGE.SET_TOKEN('PARAMETERS',

2367: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2368: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2369: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
2370: END IF;
2371: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2372: ' Invoice_line_Number = '||TO_CHAR(l_invoice_line_number)
2373: ||' Asset_bt_code = '||P_asset_bt_code
2374: ||' Transfer_flag = '||p_transfer_flag
2375: ||' Approval_wf_flag = '||P_approval_workflow_flag

Line 2497: FND_MESSAGE.SET_NAME('SQLAP','AP_VEN_DIST_SET_INVALID');

2493: FROM ap_distribution_sets
2494: WHERE distribution_set_id = p_distribution_set_id;
2495:
2496: IF (nvl(l_inactive_date, trunc(sysdate) + 1) <= trunc(sysdate)) THEN
2497: FND_MESSAGE.SET_NAME('SQLAP','AP_VEN_DIST_SET_INVALID');
2498: APP_EXCEPTION.RAISE_EXCEPTION;
2499: END IF;
2500:
2501: IF (l_dist_set_percent_number <> 100) then

Line 2502: FND_MESSAGE.SET_NAME('SQLAP','AP_CANT_USE_SKELETON_DIST_SET');

2498: APP_EXCEPTION.RAISE_EXCEPTION;
2499: END IF;
2500:
2501: IF (l_dist_set_percent_number <> 100) then
2502: FND_MESSAGE.SET_NAME('SQLAP','AP_CANT_USE_SKELETON_DIST_SET');
2503: APP_EXCEPTION.RAISE_EXCEPTION;
2504: END IF;
2505:
2506: EXCEPTION

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

2506: EXCEPTION
2507: WHEN NO_DATA_FOUND THEN
2508: Debug_info := debug_info || ': Cannot read Dist Set';
2509: IF (SQLCODE <> -20001) THEN
2510: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2511: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2512: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2513: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(p_invoice_id));
2514: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);

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

2507: WHEN NO_DATA_FOUND THEN
2508: Debug_info := debug_info || ': Cannot read Dist Set';
2509: IF (SQLCODE <> -20001) THEN
2510: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2511: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2512: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2513: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(p_invoice_id));
2514: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
2515: END IF;

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

2508: Debug_info := debug_info || ': Cannot read Dist Set';
2509: IF (SQLCODE <> -20001) THEN
2510: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2511: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2512: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2513: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(p_invoice_id));
2514: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
2515: END IF;
2516: APP_EXCEPTION.RAISE_EXCEPTION;

Line 2513: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(p_invoice_id));

2509: IF (SQLCODE <> -20001) THEN
2510: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2511: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2512: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2513: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(p_invoice_id));
2514: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
2515: END IF;
2516: APP_EXCEPTION.RAISE_EXCEPTION;
2517: END;

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

2510: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2511: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2512: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2513: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(p_invoice_id));
2514: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
2515: END IF;
2516: APP_EXCEPTION.RAISE_EXCEPTION;
2517: END;
2518:

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

2871:
2872: EXCEPTION
2873: WHEN OTHERS then
2874: IF ((SQLCODE <> -20001) OR (SQLCODE <> -20002) ) then
2875: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2876: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2877: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2878: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2879: 'Invoice_id = '||TO_CHAR(P_invoice_id)

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

2872: EXCEPTION
2873: WHEN OTHERS then
2874: IF ((SQLCODE <> -20001) OR (SQLCODE <> -20002) ) then
2875: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2876: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2877: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2878: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2879: 'Invoice_id = '||TO_CHAR(P_invoice_id)
2880: ||' Distribution_Set_id = '||TO_CHAR(P_distribution_set_id)

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

2873: WHEN OTHERS then
2874: IF ((SQLCODE <> -20001) OR (SQLCODE <> -20002) ) then
2875: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2876: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2877: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2878: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2879: 'Invoice_id = '||TO_CHAR(P_invoice_id)
2880: ||' Distribution_Set_id = '||TO_CHAR(P_distribution_set_id)
2881: ||' Line_Amount = '||TO_CHAR(p_line_amount)

Line 2878: FND_MESSAGE.SET_TOKEN('PARAMETERS',

2874: IF ((SQLCODE <> -20001) OR (SQLCODE <> -20002) ) then
2875: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2876: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2877: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2878: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2879: 'Invoice_id = '||TO_CHAR(P_invoice_id)
2880: ||' Distribution_Set_id = '||TO_CHAR(P_distribution_set_id)
2881: ||' Line_Amount = '||TO_CHAR(p_line_amount)
2882: ||' Accounting_date = '||TO_CHAR(P_accounting_date)

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

2882: ||' Accounting_date = '||TO_CHAR(P_accounting_date)
2883: ||' P_awt_group_id = '||TO_CHAR(P_awt_group_id)
2884: ||' Exchange Rate = '||TO_CHAR(P_exchange_rate)
2885: ||' Set 0f books id = '||TO_CHAR(P_set_of_books_id));
2886: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
2887: END IF;
2888:
2889: APP_EXCEPTION.RAISE_EXCEPTION;
2890: