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:
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;
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',
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)
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)
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)
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:
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));
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);
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;
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;
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;
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));
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);
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;
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;
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;
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
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
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);
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);
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:
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
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 :
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 :
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 :
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:
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: ---------------
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 ';
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;
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)
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)
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
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
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: