DBA Data[Home] [Help]

APPS.AP_AUTO_DM_CREATION_PKG dependencies on FND_MESSAGE

Line 659: fnd_message.set_name('SQLAP',l_error_code);

655: IF NOT(l_success) THEN
656:
657: debug_info := 'Call to EBTax api - Calculate Tax failed';
658:
659: fnd_message.set_name('SQLAP',l_error_code);
660:
661: Return(FALSE);
662:
663: END IF;

Line 725: fnd_message.set_name('SQLAP','AP_DEBUG');

721: Exception
722: WHEN OTHERS THEN
723:
724: If (SQLCODE <> -20001) Then
725: fnd_message.set_name('SQLAP','AP_DEBUG');
726: fnd_message.set_token('ERROR',SQLERRM);
727: fnd_message.set_token('CALLING_SEQUENCE',curr_calling_sequence);
728:
729: fnd_message.set_token('PARAMETERS',

Line 726: fnd_message.set_token('ERROR',SQLERRM);

722: WHEN OTHERS THEN
723:
724: If (SQLCODE <> -20001) Then
725: fnd_message.set_name('SQLAP','AP_DEBUG');
726: fnd_message.set_token('ERROR',SQLERRM);
727: fnd_message.set_token('CALLING_SEQUENCE',curr_calling_sequence);
728:
729: fnd_message.set_token('PARAMETERS',
730: ' rcv_transaction_id = '||to_char(p_rcv_txn_id)

Line 727: fnd_message.set_token('CALLING_SEQUENCE',curr_calling_sequence);

723:
724: If (SQLCODE <> -20001) Then
725: fnd_message.set_name('SQLAP','AP_DEBUG');
726: fnd_message.set_token('ERROR',SQLERRM);
727: fnd_message.set_token('CALLING_SEQUENCE',curr_calling_sequence);
728:
729: fnd_message.set_token('PARAMETERS',
730: ' rcv_transaction_id = '||to_char(p_rcv_txn_id)
731: ||' po_dist_id = '||to_char(p_po_dist_id)

Line 729: fnd_message.set_token('PARAMETERS',

725: fnd_message.set_name('SQLAP','AP_DEBUG');
726: fnd_message.set_token('ERROR',SQLERRM);
727: fnd_message.set_token('CALLING_SEQUENCE',curr_calling_sequence);
728:
729: fnd_message.set_token('PARAMETERS',
730: ' rcv_transaction_id = '||to_char(p_rcv_txn_id)
731: ||' po_dist_id = '||to_char(p_po_dist_id)
732: ||' quantity = '||to_char(p_quantity)
733: ||' unit price = '||to_char(p_unit_price)

Line 737: fnd_message.set_token('DEBUG_INFO',debug_info);

733: ||' unit price = '||to_char(p_unit_price)
734: ||' user_id = '||to_char(p_user_id)
735: ||' login_id = '||to_char(p_login_id));
736:
737: fnd_message.set_token('DEBUG_INFO',debug_info);
738: End if;
739:
740: Return(FALSE);
741:

Line 863: fnd_message.set_name('SQLAP','AP_DEBUG');

859:
860: Exception
861: WHEN OTHERS THEN
862: If (SQLCODE <> -20001) Then
863: fnd_message.set_name('SQLAP','AP_DEBUG');
864: fnd_message.set_token('ERROR',SQLERRM);
865: fnd_message.set_token('CALLING_SEQUENCE',curr_calling_sequence);
866: fnd_message.set_token('PARAMETERS',
867: ' rcv_transaction_id = '||to_char(p_rcv_txn_id));

Line 864: fnd_message.set_token('ERROR',SQLERRM);

860: Exception
861: WHEN OTHERS THEN
862: If (SQLCODE <> -20001) Then
863: fnd_message.set_name('SQLAP','AP_DEBUG');
864: fnd_message.set_token('ERROR',SQLERRM);
865: fnd_message.set_token('CALLING_SEQUENCE',curr_calling_sequence);
866: fnd_message.set_token('PARAMETERS',
867: ' rcv_transaction_id = '||to_char(p_rcv_txn_id));
868: fnd_message.set_token('DEBUG_INFO',debug_info);

Line 865: fnd_message.set_token('CALLING_SEQUENCE',curr_calling_sequence);

861: WHEN OTHERS THEN
862: If (SQLCODE <> -20001) Then
863: fnd_message.set_name('SQLAP','AP_DEBUG');
864: fnd_message.set_token('ERROR',SQLERRM);
865: fnd_message.set_token('CALLING_SEQUENCE',curr_calling_sequence);
866: fnd_message.set_token('PARAMETERS',
867: ' rcv_transaction_id = '||to_char(p_rcv_txn_id));
868: fnd_message.set_token('DEBUG_INFO',debug_info);
869: End if;

Line 866: fnd_message.set_token('PARAMETERS',

862: If (SQLCODE <> -20001) Then
863: fnd_message.set_name('SQLAP','AP_DEBUG');
864: fnd_message.set_token('ERROR',SQLERRM);
865: fnd_message.set_token('CALLING_SEQUENCE',curr_calling_sequence);
866: fnd_message.set_token('PARAMETERS',
867: ' rcv_transaction_id = '||to_char(p_rcv_txn_id));
868: fnd_message.set_token('DEBUG_INFO',debug_info);
869: End if;
870: app_exception.raise_exception;

Line 868: fnd_message.set_token('DEBUG_INFO',debug_info);

864: fnd_message.set_token('ERROR',SQLERRM);
865: fnd_message.set_token('CALLING_SEQUENCE',curr_calling_sequence);
866: fnd_message.set_token('PARAMETERS',
867: ' rcv_transaction_id = '||to_char(p_rcv_txn_id));
868: fnd_message.set_token('DEBUG_INFO',debug_info);
869: End if;
870: app_exception.raise_exception;
871:
872: End Get_Receipt_Info;

Line 952: fnd_message.set_name('SQLAP','AP_DEBUG');

948:
949: Exception
950: WHEN OTHERS THEN
951: If (SQLCODE <> -20001) Then
952: fnd_message.set_name('SQLAP','AP_DEBUG');
953: fnd_message.set_token('ERROR',SQLERRM);
954: fnd_message.set_token('CALLING_SEQUENCE',curr_calling_sequence);
955: fnd_message.set_token('PARAMETERS',
956: ' vendor_site_id = '||to_char(p_vendor_site_id));

Line 953: fnd_message.set_token('ERROR',SQLERRM);

949: Exception
950: WHEN OTHERS THEN
951: If (SQLCODE <> -20001) Then
952: fnd_message.set_name('SQLAP','AP_DEBUG');
953: fnd_message.set_token('ERROR',SQLERRM);
954: fnd_message.set_token('CALLING_SEQUENCE',curr_calling_sequence);
955: fnd_message.set_token('PARAMETERS',
956: ' vendor_site_id = '||to_char(p_vendor_site_id));
957: fnd_message.set_token('DEBUG_INFO',debug_info);

Line 954: fnd_message.set_token('CALLING_SEQUENCE',curr_calling_sequence);

950: WHEN OTHERS THEN
951: If (SQLCODE <> -20001) Then
952: fnd_message.set_name('SQLAP','AP_DEBUG');
953: fnd_message.set_token('ERROR',SQLERRM);
954: fnd_message.set_token('CALLING_SEQUENCE',curr_calling_sequence);
955: fnd_message.set_token('PARAMETERS',
956: ' vendor_site_id = '||to_char(p_vendor_site_id));
957: fnd_message.set_token('DEBUG_INFO',debug_info);
958: End if;

Line 955: fnd_message.set_token('PARAMETERS',

951: If (SQLCODE <> -20001) Then
952: fnd_message.set_name('SQLAP','AP_DEBUG');
953: fnd_message.set_token('ERROR',SQLERRM);
954: fnd_message.set_token('CALLING_SEQUENCE',curr_calling_sequence);
955: fnd_message.set_token('PARAMETERS',
956: ' vendor_site_id = '||to_char(p_vendor_site_id));
957: fnd_message.set_token('DEBUG_INFO',debug_info);
958: End if;
959: app_exception.raise_exception;

Line 957: fnd_message.set_token('DEBUG_INFO',debug_info);

953: fnd_message.set_token('ERROR',SQLERRM);
954: fnd_message.set_token('CALLING_SEQUENCE',curr_calling_sequence);
955: fnd_message.set_token('PARAMETERS',
956: ' vendor_site_id = '||to_char(p_vendor_site_id));
957: fnd_message.set_token('DEBUG_INFO',debug_info);
958: End if;
959: app_exception.raise_exception;
960:
961: End Get_Vendor_info;

Line 1048: fnd_message.set_name('SQLAP','AP_DEBUG');

1044:
1045: Exception
1046: WHEN OTHERS THEN
1047: If (SQLCODE <> -20001) Then
1048: fnd_message.set_name('SQLAP','AP_DEBUG');
1049: fnd_message.set_token('ERROR',SQLERRM);
1050: fnd_message.set_token('CALLING_SEQUENCE',curr_calling_sequence);
1051: fnd_message.set_token('PARAMETERS',
1052: ' receipt_num = '||p_receipt_num

Line 1049: fnd_message.set_token('ERROR',SQLERRM);

1045: Exception
1046: WHEN OTHERS THEN
1047: If (SQLCODE <> -20001) Then
1048: fnd_message.set_name('SQLAP','AP_DEBUG');
1049: fnd_message.set_token('ERROR',SQLERRM);
1050: fnd_message.set_token('CALLING_SEQUENCE',curr_calling_sequence);
1051: fnd_message.set_token('PARAMETERS',
1052: ' receipt_num = '||p_receipt_num
1053: ||'p_inv_curr = '||p_inv_curr

Line 1050: fnd_message.set_token('CALLING_SEQUENCE',curr_calling_sequence);

1046: WHEN OTHERS THEN
1047: If (SQLCODE <> -20001) Then
1048: fnd_message.set_name('SQLAP','AP_DEBUG');
1049: fnd_message.set_token('ERROR',SQLERRM);
1050: fnd_message.set_token('CALLING_SEQUENCE',curr_calling_sequence);
1051: fnd_message.set_token('PARAMETERS',
1052: ' receipt_num = '||p_receipt_num
1053: ||'p_inv_curr = '||p_inv_curr
1054: ||'p_inv_payment_curr = '||p_inv_payment_curr);

Line 1051: fnd_message.set_token('PARAMETERS',

1047: If (SQLCODE <> -20001) Then
1048: fnd_message.set_name('SQLAP','AP_DEBUG');
1049: fnd_message.set_token('ERROR',SQLERRM);
1050: fnd_message.set_token('CALLING_SEQUENCE',curr_calling_sequence);
1051: fnd_message.set_token('PARAMETERS',
1052: ' receipt_num = '||p_receipt_num
1053: ||'p_inv_curr = '||p_inv_curr
1054: ||'p_inv_payment_curr = '||p_inv_payment_curr);
1055: fnd_message.set_token('DEBUG_INFO',debug_info);

Line 1055: fnd_message.set_token('DEBUG_INFO',debug_info);

1051: fnd_message.set_token('PARAMETERS',
1052: ' receipt_num = '||p_receipt_num
1053: ||'p_inv_curr = '||p_inv_curr
1054: ||'p_inv_payment_curr = '||p_inv_payment_curr);
1055: fnd_message.set_token('DEBUG_INFO',debug_info);
1056: End if;
1057: app_exception.raise_exception;
1058: End Create_Invoice_Batch;
1059:

Line 1211: fnd_message.set_name('SQLAP','AP_NOT_VALID_PAY_SITE');

1207: Exception
1208: WHEN NO_DATA_FOUND Then
1209: -- It is not a valid pay site , a user freindly error message
1210: -- is set on the stack.
1211: fnd_message.set_name('SQLAP','AP_NOT_VALID_PAY_SITE');
1212: app_exception.raise_exception;
1213: End;
1214:
1215: if ( l_valid_pay_site = 'y') then

Line 1232: fnd_message.set_name('SQLAP','AP_QUANTITY_POSITIVE');

1228: END IF;
1229:
1230:
1231: If (p_quantity > 0) Then
1232: fnd_message.set_name('SQLAP','AP_QUANTITY_POSITIVE');
1233: app_exception.raise_exception;
1234: End if;
1235:
1236: -- step c :

Line 1247: fnd_message.set_name('SQLAP','AP_QUANTITY_UOM_INCORRECT');

1243: END IF;
1244:
1245:
1246: If (p_receipt_uom <> p_quantity_uom) then
1247: fnd_message.set_name('SQLAP','AP_QUANTITY_UOM_INCORRECT');
1248: app_exception.raise_exception;
1249: End if;
1250:
1251: -- Step d :

Line 1261: fnd_message.set_name ('SQLAP','AP_QUANTITY_BILLED_NEGATIVE');

1257: debug_info);
1258: END IF;
1259:
1260: If (p_quantity_billed + p_quantity) < 0 Then
1261: fnd_message.set_name ('SQLAP','AP_QUANTITY_BILLED_NEGATIVE');
1262: app_exception.raise_exception;
1263: End if;
1264:
1265: -- Step e :

Line 1382: fnd_message.set_name('SQLAP','AP_NO_OPEN_PERIOD');

1378: l_gl_period,
1379: l_gl_date);
1380: l_inv_gl_date := l_gl_date;
1381: If (l_inv_gl_date is null) Then
1382: fnd_message.set_name('SQLAP','AP_NO_OPEN_PERIOD');
1383: app_exception.raise_exception;
1384: End if;
1385: End if;
1386:

Line 1421: fnd_message.set_name('SQLAP','AP_AUTO_DM_DESCRIPTION');

1417: debug_info);
1418: END IF;
1419:
1420:
1421: fnd_message.set_name('SQLAP','AP_AUTO_DM_DESCRIPTION');
1422: l_inv_desc := fnd_message.get;
1423:
1424: -- Step i :
1425: ---------------

Line 1422: l_inv_desc := fnd_message.get;

1418: END IF;
1419:
1420:
1421: fnd_message.set_name('SQLAP','AP_AUTO_DM_DESCRIPTION');
1422: l_inv_desc := fnd_message.get;
1423:
1424: -- Step i :
1425: ---------------
1426: debug_info := 'Assigning document sequence ';

Line 1495: fnd_message.set_name('SQLAP','AP_CANNOT_ASSIGN_DOC_SEQ');

1491: l_doc_seq_value := null;
1492: End if;
1493:
1494: If (l_seq_num_profile = 'A' and l_doc_seq_value IS null) then
1495: fnd_message.set_name('SQLAP','AP_CANNOT_ASSIGN_DOC_SEQ');
1496: app_exception.raise_exception;
1497: End if;
1498:
1499: End if;

Line 1714: fnd_message.set_name('SQLAP','AP_DEBUG');

1710:
1711: Exception
1712: WHEN OTHERS THEN
1713: If (SQLCODE <> -20001) Then
1714: fnd_message.set_name('SQLAP','AP_DEBUG');
1715: fnd_message.set_token('ERROR',SQLERRM);
1716: fnd_message.set_token('CALLING_SEQUENCE',curr_calling_sequence);
1717: fnd_message.set_token('PARAMETERS',
1718: ' p_vendor_site_id = '||to_char(p_vendor_site_id)

Line 1715: fnd_message.set_token('ERROR',SQLERRM);

1711: Exception
1712: WHEN OTHERS THEN
1713: If (SQLCODE <> -20001) Then
1714: fnd_message.set_name('SQLAP','AP_DEBUG');
1715: fnd_message.set_token('ERROR',SQLERRM);
1716: fnd_message.set_token('CALLING_SEQUENCE',curr_calling_sequence);
1717: fnd_message.set_token('PARAMETERS',
1718: ' p_vendor_site_id = '||to_char(p_vendor_site_id)
1719: ||' p_vendor_id = '||to_char(p_vendor_id)

Line 1716: fnd_message.set_token('CALLING_SEQUENCE',curr_calling_sequence);

1712: WHEN OTHERS THEN
1713: If (SQLCODE <> -20001) Then
1714: fnd_message.set_name('SQLAP','AP_DEBUG');
1715: fnd_message.set_token('ERROR',SQLERRM);
1716: fnd_message.set_token('CALLING_SEQUENCE',curr_calling_sequence);
1717: fnd_message.set_token('PARAMETERS',
1718: ' p_vendor_site_id = '||to_char(p_vendor_site_id)
1719: ||' p_vendor_id = '||to_char(p_vendor_id)
1720: ||' p_invoice_curr = '||p_invoice_curr

Line 1717: fnd_message.set_token('PARAMETERS',

1713: If (SQLCODE <> -20001) Then
1714: fnd_message.set_name('SQLAP','AP_DEBUG');
1715: fnd_message.set_token('ERROR',SQLERRM);
1716: fnd_message.set_token('CALLING_SEQUENCE',curr_calling_sequence);
1717: fnd_message.set_token('PARAMETERS',
1718: ' p_vendor_site_id = '||to_char(p_vendor_site_id)
1719: ||' p_vendor_id = '||to_char(p_vendor_id)
1720: ||' p_invoice_curr = '||p_invoice_curr
1721: ||' p_inv_pay_curr = '||p_inv_pay_curr

Line 1728: fnd_message.set_token('DEBUG_INFO',debug_info);

1724: ||' p_set_of_books_id = '||to_char(p_set_of_books_id)
1725: ||' p_quantity = '||to_char(p_quantity)
1726: ||' p_price = '||to_char(p_price)
1727: ||' p_quantity_billed = '||to_char(p_quantity_billed));
1728: fnd_message.set_token('DEBUG_INFO',debug_info);
1729: End if;
1730: app_exception.raise_exception;
1731: End Create_Invoice_Header;
1732: