DBA Data[Home] [Help]

APPS.AP_AUTO_DM_CREATION_PKG dependencies on FND_MESSAGE

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

442: Exception
443: WHEN NO_DATA_FOUND Then
444: -- It is not a valid pay site , a user freindly error message
445: -- is set on the stack.
446: fnd_message.set_name('SQLAP','AP_NOT_VALID_PAY_SITE');
447: app_exception.raise_exception;
448: End;
449: end if;
450:

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

726: IF NOT(l_success) THEN
727:
728: debug_info := 'Call to EBTax api - Calculate Tax failed';
729:
730: fnd_message.set_name('SQLAP',l_error_code);
731:
732: Return(FALSE);
733:
734: END IF;

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

792: Exception
793: WHEN OTHERS THEN
794:
795: If (SQLCODE <> -20001) Then
796: fnd_message.set_name('SQLAP','AP_DEBUG');
797: fnd_message.set_token('ERROR',SQLERRM);
798: fnd_message.set_token('CALLING_SEQUENCE',curr_calling_sequence);
799:
800: fnd_message.set_token('PARAMETERS',

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

793: WHEN OTHERS THEN
794:
795: If (SQLCODE <> -20001) Then
796: fnd_message.set_name('SQLAP','AP_DEBUG');
797: fnd_message.set_token('ERROR',SQLERRM);
798: fnd_message.set_token('CALLING_SEQUENCE',curr_calling_sequence);
799:
800: fnd_message.set_token('PARAMETERS',
801: ' rcv_transaction_id = '||to_char(p_rcv_txn_id)

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

794:
795: If (SQLCODE <> -20001) Then
796: fnd_message.set_name('SQLAP','AP_DEBUG');
797: fnd_message.set_token('ERROR',SQLERRM);
798: fnd_message.set_token('CALLING_SEQUENCE',curr_calling_sequence);
799:
800: fnd_message.set_token('PARAMETERS',
801: ' rcv_transaction_id = '||to_char(p_rcv_txn_id)
802: ||' po_dist_id = '||to_char(p_po_dist_id)

Line 800: fnd_message.set_token('PARAMETERS',

796: fnd_message.set_name('SQLAP','AP_DEBUG');
797: fnd_message.set_token('ERROR',SQLERRM);
798: fnd_message.set_token('CALLING_SEQUENCE',curr_calling_sequence);
799:
800: fnd_message.set_token('PARAMETERS',
801: ' rcv_transaction_id = '||to_char(p_rcv_txn_id)
802: ||' po_dist_id = '||to_char(p_po_dist_id)
803: ||' quantity = '||to_char(p_quantity)
804: ||' unit price = '||to_char(p_unit_price)

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

804: ||' unit price = '||to_char(p_unit_price)
805: ||' user_id = '||to_char(p_user_id)
806: ||' login_id = '||to_char(p_login_id));
807:
808: fnd_message.set_token('DEBUG_INFO',debug_info);
809: End if;
810:
811: Return(FALSE);
812:

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

930:
931: Exception
932: WHEN OTHERS THEN
933: If (SQLCODE <> -20001) Then
934: fnd_message.set_name('SQLAP','AP_DEBUG');
935: fnd_message.set_token('ERROR',SQLERRM);
936: fnd_message.set_token('CALLING_SEQUENCE',curr_calling_sequence);
937: fnd_message.set_token('PARAMETERS',
938: ' rcv_transaction_id = '||to_char(p_rcv_txn_id));

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

931: Exception
932: WHEN OTHERS THEN
933: If (SQLCODE <> -20001) Then
934: fnd_message.set_name('SQLAP','AP_DEBUG');
935: fnd_message.set_token('ERROR',SQLERRM);
936: fnd_message.set_token('CALLING_SEQUENCE',curr_calling_sequence);
937: fnd_message.set_token('PARAMETERS',
938: ' rcv_transaction_id = '||to_char(p_rcv_txn_id));
939: fnd_message.set_token('DEBUG_INFO',debug_info);

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

932: WHEN OTHERS THEN
933: If (SQLCODE <> -20001) Then
934: fnd_message.set_name('SQLAP','AP_DEBUG');
935: fnd_message.set_token('ERROR',SQLERRM);
936: fnd_message.set_token('CALLING_SEQUENCE',curr_calling_sequence);
937: fnd_message.set_token('PARAMETERS',
938: ' rcv_transaction_id = '||to_char(p_rcv_txn_id));
939: fnd_message.set_token('DEBUG_INFO',debug_info);
940: End if;

Line 937: fnd_message.set_token('PARAMETERS',

933: If (SQLCODE <> -20001) Then
934: fnd_message.set_name('SQLAP','AP_DEBUG');
935: fnd_message.set_token('ERROR',SQLERRM);
936: fnd_message.set_token('CALLING_SEQUENCE',curr_calling_sequence);
937: fnd_message.set_token('PARAMETERS',
938: ' rcv_transaction_id = '||to_char(p_rcv_txn_id));
939: fnd_message.set_token('DEBUG_INFO',debug_info);
940: End if;
941: app_exception.raise_exception;

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

935: fnd_message.set_token('ERROR',SQLERRM);
936: fnd_message.set_token('CALLING_SEQUENCE',curr_calling_sequence);
937: fnd_message.set_token('PARAMETERS',
938: ' rcv_transaction_id = '||to_char(p_rcv_txn_id));
939: fnd_message.set_token('DEBUG_INFO',debug_info);
940: End if;
941: app_exception.raise_exception;
942:
943: End Get_Receipt_Info;

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

1020:
1021: Exception
1022: WHEN OTHERS THEN
1023: If (SQLCODE <> -20001) Then
1024: fnd_message.set_name('SQLAP','AP_DEBUG');
1025: fnd_message.set_token('ERROR',SQLERRM);
1026: fnd_message.set_token('CALLING_SEQUENCE',curr_calling_sequence);
1027: fnd_message.set_token('PARAMETERS',
1028: ' vendor_site_id = '||to_char(p_vendor_site_id));

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

1021: Exception
1022: WHEN OTHERS THEN
1023: If (SQLCODE <> -20001) Then
1024: fnd_message.set_name('SQLAP','AP_DEBUG');
1025: fnd_message.set_token('ERROR',SQLERRM);
1026: fnd_message.set_token('CALLING_SEQUENCE',curr_calling_sequence);
1027: fnd_message.set_token('PARAMETERS',
1028: ' vendor_site_id = '||to_char(p_vendor_site_id));
1029: fnd_message.set_token('DEBUG_INFO',debug_info);

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

1022: WHEN OTHERS THEN
1023: If (SQLCODE <> -20001) Then
1024: fnd_message.set_name('SQLAP','AP_DEBUG');
1025: fnd_message.set_token('ERROR',SQLERRM);
1026: fnd_message.set_token('CALLING_SEQUENCE',curr_calling_sequence);
1027: fnd_message.set_token('PARAMETERS',
1028: ' vendor_site_id = '||to_char(p_vendor_site_id));
1029: fnd_message.set_token('DEBUG_INFO',debug_info);
1030: End if;

Line 1027: fnd_message.set_token('PARAMETERS',

1023: If (SQLCODE <> -20001) Then
1024: fnd_message.set_name('SQLAP','AP_DEBUG');
1025: fnd_message.set_token('ERROR',SQLERRM);
1026: fnd_message.set_token('CALLING_SEQUENCE',curr_calling_sequence);
1027: fnd_message.set_token('PARAMETERS',
1028: ' vendor_site_id = '||to_char(p_vendor_site_id));
1029: fnd_message.set_token('DEBUG_INFO',debug_info);
1030: End if;
1031: app_exception.raise_exception;

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

1025: fnd_message.set_token('ERROR',SQLERRM);
1026: fnd_message.set_token('CALLING_SEQUENCE',curr_calling_sequence);
1027: fnd_message.set_token('PARAMETERS',
1028: ' vendor_site_id = '||to_char(p_vendor_site_id));
1029: fnd_message.set_token('DEBUG_INFO',debug_info);
1030: End if;
1031: app_exception.raise_exception;
1032:
1033: End Get_Vendor_info;

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

1116:
1117: Exception
1118: WHEN OTHERS THEN
1119: If (SQLCODE <> -20001) Then
1120: fnd_message.set_name('SQLAP','AP_DEBUG');
1121: fnd_message.set_token('ERROR',SQLERRM);
1122: fnd_message.set_token('CALLING_SEQUENCE',curr_calling_sequence);
1123: fnd_message.set_token('PARAMETERS',
1124: ' receipt_num = '||p_receipt_num

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

1117: Exception
1118: WHEN OTHERS THEN
1119: If (SQLCODE <> -20001) Then
1120: fnd_message.set_name('SQLAP','AP_DEBUG');
1121: fnd_message.set_token('ERROR',SQLERRM);
1122: fnd_message.set_token('CALLING_SEQUENCE',curr_calling_sequence);
1123: fnd_message.set_token('PARAMETERS',
1124: ' receipt_num = '||p_receipt_num
1125: ||'p_inv_curr = '||p_inv_curr

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

1118: WHEN OTHERS THEN
1119: If (SQLCODE <> -20001) Then
1120: fnd_message.set_name('SQLAP','AP_DEBUG');
1121: fnd_message.set_token('ERROR',SQLERRM);
1122: fnd_message.set_token('CALLING_SEQUENCE',curr_calling_sequence);
1123: fnd_message.set_token('PARAMETERS',
1124: ' receipt_num = '||p_receipt_num
1125: ||'p_inv_curr = '||p_inv_curr
1126: ||'p_inv_payment_curr = '||p_inv_payment_curr);

Line 1123: fnd_message.set_token('PARAMETERS',

1119: If (SQLCODE <> -20001) Then
1120: fnd_message.set_name('SQLAP','AP_DEBUG');
1121: fnd_message.set_token('ERROR',SQLERRM);
1122: fnd_message.set_token('CALLING_SEQUENCE',curr_calling_sequence);
1123: fnd_message.set_token('PARAMETERS',
1124: ' receipt_num = '||p_receipt_num
1125: ||'p_inv_curr = '||p_inv_curr
1126: ||'p_inv_payment_curr = '||p_inv_payment_curr);
1127: fnd_message.set_token('DEBUG_INFO',debug_info);

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

1123: fnd_message.set_token('PARAMETERS',
1124: ' receipt_num = '||p_receipt_num
1125: ||'p_inv_curr = '||p_inv_curr
1126: ||'p_inv_payment_curr = '||p_inv_payment_curr);
1127: fnd_message.set_token('DEBUG_INFO',debug_info);
1128: End if;
1129: app_exception.raise_exception;
1130: End Create_Invoice_Batch;
1131:

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

1280: Exception
1281: WHEN NO_DATA_FOUND Then
1282: -- It is not a valid pay site , a user freindly error message
1283: -- is set on the stack.
1284: fnd_message.set_name('SQLAP','AP_NOT_VALID_PAY_SITE');
1285: app_exception.raise_exception;
1286: End;
1287:
1288: if ( l_valid_pay_site = 'y') then

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

1303: END IF;
1304:
1305:
1306: If (p_quantity > 0) Then
1307: fnd_message.set_name('SQLAP','AP_QUANTITY_POSITIVE');
1308: app_exception.raise_exception;
1309: End if;
1310:
1311: -- step c :

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

1318: END IF;
1319:
1320:
1321: If (p_receipt_uom <> p_quantity_uom) then
1322: fnd_message.set_name('SQLAP','AP_QUANTITY_UOM_INCORRECT');
1323: app_exception.raise_exception;
1324: End if;
1325:
1326: -- Step d :

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

1332: debug_info);
1333: END IF;
1334:
1335: If (p_quantity_billed + p_quantity) < 0 Then
1336: fnd_message.set_name ('SQLAP','AP_QUANTITY_BILLED_NEGATIVE');
1337: app_exception.raise_exception;
1338: End if;
1339:
1340: -- Step e :

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

1453: l_gl_period,
1454: l_gl_date);
1455: l_inv_gl_date := l_gl_date;
1456: If (l_inv_gl_date is null) Then
1457: fnd_message.set_name('SQLAP','AP_NO_OPEN_PERIOD');
1458: app_exception.raise_exception;
1459: End if;
1460: End if;
1461:

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

1492: debug_info);
1493: END IF;
1494:
1495:
1496: fnd_message.set_name('SQLAP','AP_AUTO_DM_DESCRIPTION');
1497: l_inv_desc := fnd_message.get;
1498:
1499: -- Step i :
1500: ---------------

Line 1497: l_inv_desc := fnd_message.get;

1493: END IF;
1494:
1495:
1496: fnd_message.set_name('SQLAP','AP_AUTO_DM_DESCRIPTION');
1497: l_inv_desc := fnd_message.get;
1498:
1499: -- Step i :
1500: ---------------
1501: debug_info := 'Assigning document sequence ';

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

1567: l_doc_seq_value := null;
1568: End if;
1569:
1570: If (l_seq_num_profile = 'A' and l_doc_seq_value IS null) then
1571: fnd_message.set_name('SQLAP','AP_CANNOT_ASSIGN_DOC_SEQ');
1572: app_exception.raise_exception;
1573: End if;
1574:
1575: End if;

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

1793:
1794: Exception
1795: WHEN OTHERS THEN
1796: If (SQLCODE <> -20001) Then
1797: fnd_message.set_name('SQLAP','AP_DEBUG');
1798: fnd_message.set_token('ERROR',SQLERRM);
1799: fnd_message.set_token('CALLING_SEQUENCE',curr_calling_sequence);
1800: fnd_message.set_token('PARAMETERS',
1801: ' p_vendor_site_id = '||to_char(p_vendor_site_id)

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

1794: Exception
1795: WHEN OTHERS THEN
1796: If (SQLCODE <> -20001) Then
1797: fnd_message.set_name('SQLAP','AP_DEBUG');
1798: fnd_message.set_token('ERROR',SQLERRM);
1799: fnd_message.set_token('CALLING_SEQUENCE',curr_calling_sequence);
1800: fnd_message.set_token('PARAMETERS',
1801: ' p_vendor_site_id = '||to_char(p_vendor_site_id)
1802: ||' p_vendor_id = '||to_char(p_vendor_id)

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

1795: WHEN OTHERS THEN
1796: If (SQLCODE <> -20001) Then
1797: fnd_message.set_name('SQLAP','AP_DEBUG');
1798: fnd_message.set_token('ERROR',SQLERRM);
1799: fnd_message.set_token('CALLING_SEQUENCE',curr_calling_sequence);
1800: fnd_message.set_token('PARAMETERS',
1801: ' p_vendor_site_id = '||to_char(p_vendor_site_id)
1802: ||' p_vendor_id = '||to_char(p_vendor_id)
1803: ||' p_invoice_curr = '||p_invoice_curr

Line 1800: fnd_message.set_token('PARAMETERS',

1796: If (SQLCODE <> -20001) Then
1797: fnd_message.set_name('SQLAP','AP_DEBUG');
1798: fnd_message.set_token('ERROR',SQLERRM);
1799: fnd_message.set_token('CALLING_SEQUENCE',curr_calling_sequence);
1800: fnd_message.set_token('PARAMETERS',
1801: ' p_vendor_site_id = '||to_char(p_vendor_site_id)
1802: ||' p_vendor_id = '||to_char(p_vendor_id)
1803: ||' p_invoice_curr = '||p_invoice_curr
1804: ||' p_inv_pay_curr = '||p_inv_pay_curr

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

1807: ||' p_set_of_books_id = '||to_char(p_set_of_books_id)
1808: ||' p_quantity = '||to_char(p_quantity)
1809: ||' p_price = '||to_char(p_price)
1810: ||' p_quantity_billed = '||to_char(p_quantity_billed));
1811: fnd_message.set_token('DEBUG_INFO',debug_info);
1812: End if;
1813: app_exception.raise_exception;
1814: End Create_Invoice_Header;
1815: