DBA Data[Home] [Help]

APPS.PO_MULTI_MOD_VALIDATIONS dependencies on PO_MULTI_MOD_VAL_RESULTS_S

Line 851: p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval

847:
848: x_result_type := c_result_type_FATAL;
849:
850: x_results.add_result(
851: p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval
852: , p_multi_mod_request_id => p_multi_mod_request_id
853: , p_validation_type => p_validation_type
854: , p_result_type => c_result_type_FATAL
855: , p_message_application => 'PO'

Line 958: p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval

954:
955: IF p_multi_mod_doc_id_tbl.COUNT < 1 THEN
956: d_position := 20;
957: x_results.add_result(
958: p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval
959: , p_multi_mod_request_id => p_request_id
960: , p_result_type => 'ERROR'
961: , p_validation_type => p_validation_type
962: , p_message_application => 'PO'

Line 1049: p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval

1045:
1046: IF p_initiate_app_flag = 'Y' AND p_exemption_reason IS NULL THEN
1047: d_position := 20;
1048: x_results.add_result(
1049: p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval
1050: , p_multi_mod_request_id => p_request_id
1051: , p_result_type => 'ERROR'
1052: , p_validation_type => p_validation_type
1053: , p_message_application => 'PO'

Line 1175: p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval

1171: AND p_new_vendor_contact_id_tbl(i) IS NULL) THEN
1172:
1173: d_position := 50;
1174: x_results.add_result(
1175: p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval
1176: , p_multi_mod_request_id => p_request_id
1177: , p_result_type => 'ERROR'
1178: , p_validation_type => p_validation_type
1179: , p_message_application => 'PO'

Line 1204: p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval

1200:
1201: IF l_vendor_contact_id IS NULL THEN
1202: d_position := 80;
1203: x_results.add_result(
1204: p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval
1205: , p_multi_mod_request_id => p_request_id
1206: , P_multi_mod_doc_id => p_multi_mod_doc_id_tbl(i)
1207: , p_result_type => 'ERROR'
1208: , P_document_id => p_document_id_tbl(i)

Line 1303: p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval

1299:
1300: IF p_acceptance_reqd_flag IN ('S','P') AND (p_acceptance_due_date Is NULL OR p_acceptance_due_date <= SYSDATE) THEN
1301: d_position := 20;
1302: x_results.add_result(
1303: p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval
1304: , p_multi_mod_request_id => p_request_id
1305: , p_result_type => 'ERROR'
1306: , p_validation_type => p_validation_type
1307: , p_message_application => 'PO'

Line 1392: p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval

1388: IF (p_acceptance_reqd_flag IN ('S','P')) AND (NVL(p_clm_noofcopies,0) <= 0) THEN
1389:
1390:
1391: x_results.add_result(
1392: p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval
1393: , p_multi_mod_request_id => p_request_id
1394: , p_result_type => 'ERROR'
1395: , p_validation_type => p_validation_type
1396: , p_message_application => 'PO'

Line 1491: p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval

1487: IF p_change_type_tbl(i) = 'VENDOR_NAME' THEN
1488: IF p_old_vendor_name_tbl(i) = p_new_vendor_name_tbl(i) THEN
1489: d_position := 50;
1490: x_results.add_result(
1491: p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval
1492: , p_multi_mod_request_id => p_request_id
1493: , p_result_type => 'ERROR'
1494: , p_validation_type => p_validation_type
1495: , p_message_application => 'PO'

Line 1594: p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval

1590: IF p_change_type_tbl(i) = 'VENDOR' THEN
1591: IF p_old_vendor_id_tbl(i) = p_new_vendor_id_tbl(i) THEN
1592: d_position := 50;
1593: x_results.add_result(
1594: p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval
1595: , p_multi_mod_request_id => p_request_id
1596: , p_result_type => 'ERROR'
1597: , p_validation_type => p_validation_type
1598: , p_message_application => 'PO'

Line 1710: p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval

1706:
1707: IF l_hold_exists = 'Y' THEN
1708: d_position := 30;
1709: x_results.add_result(
1710: p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval
1711: , p_multi_mod_request_id => p_request_id
1712: , p_result_type => 'ERROR'
1713: , p_validation_type => p_validation_type
1714: , p_message_application => 'PO'

Line 1900: p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval

1896: IF l_has_vendor_changed = 'N' THEN
1897:
1898: d_position := 40;
1899: x_results.add_result(
1900: p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval
1901: , p_multi_mod_request_id => p_request_id
1902: , p_result_type => 'ERROR'
1903: , p_validation_type => p_validation_type
1904: , p_message_application => 'PO'

Line 2011: p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval

2007: AND p_new_vendor_site_id_tbl(i) IS NULL) THEN
2008:
2009: d_position := 30;
2010: x_results.add_result(
2011: p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval
2012: , p_multi_mod_request_id => p_request_id
2013: , p_result_type => 'ERROR'
2014: , p_validation_type => p_validation_type
2015: , p_message_application => 'PO'

Line 2163: p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval

2159: IF NOT l_new_valid_registration THEN
2160:
2161: d_position := 60;
2162: x_results.add_result(
2163: p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval
2164: , p_multi_mod_request_id => p_request_id
2165: , p_result_type => 'ERROR'
2166: , p_validation_type => p_validation_type
2167: , p_message_application => 'PO'

Line 2389: p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval

2385: END IF;
2386:
2387: d_position := 100;
2388: x_results.add_result(
2389: p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval
2390: , p_multi_mod_request_id => p_request_id
2391: , p_result_type => 'ERROR'
2392: , p_validation_type => 'PRE-SUBMIT'
2393: , p_message_application => l_application

Line 2493: p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval

2489: IF (NVL(l_ko_sign_required,'N') = 'Y') AND (p_clm_contract_officer IS NULL) THEN
2490:
2491:
2492: x_results.add_result(
2493: p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval
2494: , p_multi_mod_request_id => p_request_id
2495: , p_result_type => 'ERROR'
2496: , p_validation_type => p_validation_type
2497: , p_message_application => 'PO'

Line 2797: p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval

2793:
2794: FOR i IN 1..l_document_id_tbl.Count() LOOP
2795:
2796: x_results.add_result(
2797: p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval
2798: , p_multi_mod_request_id => p_request_id
2799: , p_validation_type => 'ERROR'
2800: , p_document_number => l_document_num_tbl(i)
2801: , p_message_application => 'PO'

Line 2925: x_results.add_result(p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval

2921: FOR i IN 1..l_sum_check_tbl.Count() LOOP
2922:
2923: IF l_sum_check_tbl(i) > 0 THEN
2924:
2925: x_results.add_result(p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval
2926: , p_multi_mod_request_id => p_request_id
2927: , p_validation_type => 'ERROR'
2928: , p_document_number => l_document_number_tbl(i)
2929: , p_message_application => 'PO'

Line 3015: x_results.add_result(p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval

3011: END IF;
3012:
3013: FOR i IN 1..l_document_num_tbl.Count() LOOP
3014:
3015: x_results.add_result(p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval
3016: , p_multi_mod_request_id => p_request_id
3017: , p_validation_type => 'ERROR'
3018: , p_document_number => l_document_num_tbl(i)
3019: , p_message_application => 'PO'

Line 3128: p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval

3124:
3125: FOR i IN 1..l_document_id_tbl.COUNT LOOP
3126: d_position := 30;
3127: x_results.add_result(
3128: p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval
3129: , p_multi_mod_request_id => p_request_id
3130: , p_multi_mod_doc_id => p_multi_mod_doc_id_tbl(i)
3131: , p_result_type => 'ERROR'
3132: , p_exception_type => PO_MESSAGE_S.PO_MULTIMOD_AWARD_NOT_INC_SUM

Line 3253: p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval

3249: FOR i IN 1..l_document_id_tbl.COUNT LOOP
3250: d_position := 30;
3251:
3252: x_results.add_result(
3253: p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval
3254: , p_multi_mod_request_id => p_request_id
3255: , p_multi_mod_doc_id => p_multi_mod_doc_id_tbl(i)
3256: , p_result_type => 'ERROR'
3257: , p_exception_type => PO_MESSAGE_S.PO_MULTIMOD_IDV_NOT_INC_SUM

Line 3445: p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval

3441: d_position := 80;
3442: --check if invoice is paid
3443: IF unpaid_invoices_exists(l_invoice_id) THEN
3444: x_results.add_result(
3445: p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval
3446: , p_multi_mod_request_id => p_request_id
3447: , p_result_type => 'WARNING'
3448: , p_exception_type => 'Unpaid Invoices exists for Receipts.'
3449: , p_validation_type => 'RECEIPTS'

Line 3462: p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval

3458: d_position := 90;
3459: --check if invoice is validated
3460: IF unval_invoices_exists(p_document_id_tbl(i),l_invoice_id) THEN
3461: x_results.add_result(
3462: p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval
3463: , p_multi_mod_request_id => p_request_id
3464: , p_result_type => 'WARNING'
3465: , p_exception_type => 'Unpaid Invoices exists for Receipts.'
3466: , p_validation_type => 'RECEIPTS'

Line 3760: p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval

3756: d_position := 40;
3757: --check if invoice is paid
3758: IF unpaid_invoices_exists(l_invoice_id_tbl(i)) THEN
3759: x_results.add_result(
3760: p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval
3761: , p_multi_mod_request_id => p_request_id
3762: , p_multi_mod_doc_id => l_multi_mod_doc_id
3763: , p_result_type => 'ERROR'
3764: , p_exception_type => PO_MESSAGE_S.PO_SUPCHG_UNPD_INV_SUM

Line 3781: p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval

3777: d_position := 50;
3778: --check if invoice is validated
3779: IF unval_invoices_exists(l_document_id,l_invoice_id_tbl(i)) THEN
3780: x_results.add_result(
3781: p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval
3782: , p_multi_mod_request_id => p_request_id
3783: , p_multi_mod_doc_id => l_multi_mod_doc_id
3784: , p_result_type => 'ERROR'
3785: , p_exception_type => PO_MESSAGE_S.PO_SUPCHG_UNPD_INV_SUM

Line 3804: p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval

3800:
3801: IF NVL(l_invoice_date_tbl(i),sysdate) >= NVL(p_novation_effective_date,sysdate) THEN
3802:
3803: x_results.add_result(
3804: p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval
3805: , p_multi_mod_request_id => p_request_id
3806: , p_multi_mod_doc_id => l_multi_mod_doc_id
3807: , p_result_type => 'ERROR'
3808: , p_exception_type => PO_MESSAGE_S.PO_SUPCHG_INDAT_GE_NOVDAT_SUM

Line 3855: p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval

3851:
3852: IF l_invoice_id_tbl.Count > 0 THEN
3853: FOR i IN 1..l_invoice_id_tbl.COUNT LOOP
3854: x_results.add_result(
3855: p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval
3856: , p_multi_mod_request_id => p_request_id
3857: , p_multi_mod_doc_id => l_multi_mod_doc_id
3858: , p_result_type => 'ERROR'
3859: , p_exception_type => PO_MESSAGE_S.PO_SUPCHG_UNMTCH_INV_VNDR_SUM

Line 3883: p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval

3879:
3880: IF l_invoice_id_tbl.Count > 0 THEN
3881: FOR i IN 1..l_invoice_id_tbl.COUNT LOOP
3882: x_results.add_result(
3883: p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval
3884: , p_multi_mod_request_id => p_request_id
3885: , p_multi_mod_doc_id => l_multi_mod_doc_id
3886: , p_result_type => 'ERROR'
3887: , p_exception_type => PO_MESSAGE_S.PO_SUPCHG_PARTPD_INV_VNDR_SUM

Line 3911: p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval

3907:
3908: IF l_invoice_id_tbl.Count > 0 THEN
3909: FOR i IN 1..l_invoice_id_tbl.COUNT LOOP
3910: x_results.add_result(
3911: p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval
3912: , p_multi_mod_request_id => p_request_id
3913: , p_multi_mod_doc_id => l_multi_mod_doc_id
3914: , p_result_type => 'ERROR'
3915: , p_exception_type => PO_MESSAGE_S.PO_SUPCHG_PREPD_INV_VNDR_SUM