DBA Data[Home] [Help]

APPS.PO_MULTI_MOD_VALIDATIONS dependencies on PO_MESSAGE_S

Line 856: , p_message_name => PO_MESSAGE_S.PO_ALL_SQL_ERROR

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'
856: , p_message_name => PO_MESSAGE_S.PO_ALL_SQL_ERROR
857: , p_token1_name => PO_MESSAGE_S.c_ROUTINE_token
858: , p_token1_value => d_mod
859: , p_token2_name => PO_MESSAGE_S.c_ERR_NUMBER_token
860: , p_token2_value => TO_CHAR(d_position)

Line 857: , p_token1_name => PO_MESSAGE_S.c_ROUTINE_token

853: , p_validation_type => p_validation_type
854: , p_result_type => c_result_type_FATAL
855: , p_message_application => 'PO'
856: , p_message_name => PO_MESSAGE_S.PO_ALL_SQL_ERROR
857: , p_token1_name => PO_MESSAGE_S.c_ROUTINE_token
858: , p_token1_value => d_mod
859: , p_token2_name => PO_MESSAGE_S.c_ERR_NUMBER_token
860: , p_token2_value => TO_CHAR(d_position)
861: , p_token3_name => PO_MESSAGE_S.c_SQL_ERR_token

Line 859: , p_token2_name => PO_MESSAGE_S.c_ERR_NUMBER_token

855: , p_message_application => 'PO'
856: , p_message_name => PO_MESSAGE_S.PO_ALL_SQL_ERROR
857: , p_token1_name => PO_MESSAGE_S.c_ROUTINE_token
858: , p_token1_value => d_mod
859: , p_token2_name => PO_MESSAGE_S.c_ERR_NUMBER_token
860: , p_token2_value => TO_CHAR(d_position)
861: , p_token3_name => PO_MESSAGE_S.c_SQL_ERR_token
862: , p_token3_value => l_val
863: , p_token4_name => PO_MESSAGE_S.c_LSQL_ERR_token

Line 861: , p_token3_name => PO_MESSAGE_S.c_SQL_ERR_token

857: , p_token1_name => PO_MESSAGE_S.c_ROUTINE_token
858: , p_token1_value => d_mod
859: , p_token2_name => PO_MESSAGE_S.c_ERR_NUMBER_token
860: , p_token2_value => TO_CHAR(d_position)
861: , p_token3_name => PO_MESSAGE_S.c_SQL_ERR_token
862: , p_token3_value => l_val
863: , p_token4_name => PO_MESSAGE_S.c_LSQL_ERR_token
864: , p_token4_value => SQLERRM
865: );

Line 863: , p_token4_name => PO_MESSAGE_S.c_LSQL_ERR_token

859: , p_token2_name => PO_MESSAGE_S.c_ERR_NUMBER_token
860: , p_token2_value => TO_CHAR(d_position)
861: , p_token3_name => PO_MESSAGE_S.c_SQL_ERR_token
862: , p_token3_value => l_val
863: , p_token4_name => PO_MESSAGE_S.c_LSQL_ERR_token
864: , p_token4_value => SQLERRM
865: );
866: END;
867:

Line 963: , p_message_name => PO_MESSAGE_S.PO_MULTIMOD_NO_DOC_SELECTED

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'
963: , p_message_name => PO_MESSAGE_S.PO_MULTIMOD_NO_DOC_SELECTED
964: );
965: END IF;
966: d_position := 30;
967:

Line 1054: , p_message_name => PO_MESSAGE_S.PO_MULTIMOD_NO_EXEMPT_REASON

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'
1054: , p_message_name => PO_MESSAGE_S.PO_MULTIMOD_NO_EXEMPT_REASON
1055: );
1056: END IF; --IF p_initiate_app_flag
1057:
1058:

Line 1180: , p_message_name => PO_MESSAGE_S.PO_MULTIMOD_NO_VENDOR_CONTACT

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'
1180: , p_message_name => PO_MESSAGE_S.PO_MULTIMOD_NO_VENDOR_CONTACT
1181: , p_token1_name => 'NEW_SUPPLIER_SITE'
1182: , p_token1_value => p_new_vendor_site_id_tbl(i)
1183: );
1184: END IF;

Line 1211: , p_message_name => PO_MESSAGE_S.PO_SUB_ENTER_VENDOR_CONTACT

1207: , p_result_type => 'ERROR'
1208: , P_document_id => p_document_id_tbl(i)
1209: , p_validation_type => p_validation_type
1210: , p_message_application => 'PO'
1211: , p_message_name => PO_MESSAGE_S.PO_SUB_ENTER_VENDOR_CONTACT
1212: );
1213: END IF; --l_vendor_contact_id
1214: END LOOP; --1..p_multi_mod_doc_id_tbl.COUNT
1215: END IF; --IF p_change_id_tbl.COUNT > 0

Line 1308: , p_message_name => PO_MESSAGE_S.PO_MULTIMOD_INVALID_ACK_BY

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'
1308: , p_message_name => PO_MESSAGE_S.PO_MULTIMOD_INVALID_ACK_BY
1309: );
1310: END IF;
1311:
1312: d_position := 30;

Line 1397: , p_message_name => PO_MESSAGE_S.PO_MULTIMOD_NOOFCOPIES_GE_ZERO

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'
1397: , p_message_name => PO_MESSAGE_S.PO_MULTIMOD_NOOFCOPIES_GE_ZERO
1398: );
1399: END IF;
1400:
1401: d_position := 20;

Line 1496: , p_message_name => PO_MESSAGE_S.PO_MULTIMOD_INV_VNDRNAME_CHG

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'
1496: , p_message_name => PO_MESSAGE_S.PO_MULTIMOD_INV_VNDRNAME_CHG
1497: , p_token1_name => 'NEW_SUPPLIER'
1498: , p_token1_value => p_new_vendor_name_tbl(i)
1499: , p_token2_name => 'OLD_SUPPLIER'
1500: , p_token2_value => p_old_vendor_name_tbl(i)

Line 1599: , p_message_name => PO_MESSAGE_S.PO_MULTIMOD_INV_VNDR_CHG

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'
1599: , p_message_name => PO_MESSAGE_S.PO_MULTIMOD_INV_VNDR_CHG
1600: , p_token1_name => 'NEW_SUPPLIER'
1601: , p_token1_value => p_new_vendor_id_tbl(i)
1602: , p_token2_name => 'OLD_SUPPLIER'
1603: , p_token2_value => p_old_vendor_id_tbl(i)

Line 1715: , p_message_name => PO_MESSAGE_S.PO_SUB_VENDOR_ON_HOLD

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'
1715: , p_message_name => PO_MESSAGE_S.PO_SUB_VENDOR_ON_HOLD
1716: );
1717: END IF; --Il_hold_exists = 'Y'
1718: END IF; --IF p_change_type_tbl(i) = 'VENDOR_NAME' THEN
1719: END LOOP;

Line 1905: , p_message_name => PO_MESSAGE_S.PO_MULTIMOD_NO_CHANGE_DONE

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'
1905: , p_message_name => PO_MESSAGE_S.PO_MULTIMOD_NO_CHANGE_DONE
1906: );
1907: END IF;
1908: END IF;
1909: END IF;

Line 2016: , p_message_name => PO_MESSAGE_S.PO_MULTIMOD_NO_VENDOR_SITE

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'
2016: , p_message_name => PO_MESSAGE_S.PO_MULTIMOD_NO_VENDOR_SITE
2017: );
2018: END IF;
2019:
2020: END LOOP; --i IN 1..p_change_id_tbl.COUNT

Line 2168: , p_message_name => PO_MESSAGE_S.PO_MULTIMOD_NO_VENDOR_CCR

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'
2168: , p_message_name => PO_MESSAGE_S.PO_MULTIMOD_NO_VENDOR_CCR
2169: , p_token1_name => 'NEW_SUPPLIER_SITE'
2170: , p_token1_value => p_new_vendor_site_id_tbl(i)
2171: );
2172:

Line 3132: , p_exception_type => PO_MESSAGE_S.PO_MULTIMOD_AWARD_NOT_INC_SUM

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
3133: , p_validation_type => 'IDV'
3134: , p_document_id => l_document_id_tbl(i)
3135: , p_document_number => l_document_number_tbl(i)
3136: , p_related_document_id => l_related_document_id_tbl(i)

Line 3139: , p_message_name => PO_MESSAGE_S.PO_MULTIMOD_AWARD_NOT_INC --PO_MULTIMOD_AWARD_NOT_INC_SUM

3135: , p_document_number => l_document_number_tbl(i)
3136: , p_related_document_id => l_related_document_id_tbl(i)
3137: , p_related_document_number => l_related_doc_number_tbl(i)
3138: , p_message_application => 'PO'
3139: , p_message_name => PO_MESSAGE_S.PO_MULTIMOD_AWARD_NOT_INC --PO_MULTIMOD_AWARD_NOT_INC_SUM
3140: );
3141: END LOOP;
3142:
3143: d_position := 40;

Line 3257: , p_exception_type => PO_MESSAGE_S.PO_MULTIMOD_IDV_NOT_INC_SUM

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
3258: , p_validation_type => 'AWARD'
3259: , p_document_id => l_document_id_tbl(i)
3260: , p_document_number => l_document_number_tbl(i)
3261: , p_related_document_id => l_related_document_id_tbl(i)

Line 3264: , p_message_name => PO_MESSAGE_S.PO_MULTIMOD_IDV_NOT_INC

3260: , p_document_number => l_document_number_tbl(i)
3261: , p_related_document_id => l_related_document_id_tbl(i)
3262: , p_related_document_number => l_related_doc_number_tbl(i)
3263: , p_message_application => 'PO'
3264: , p_message_name => PO_MESSAGE_S.PO_MULTIMOD_IDV_NOT_INC
3265: );
3266: END LOOP;
3267:
3268: d_position := 40;

Line 3455: , p_message_name => PO_MESSAGE_S.PO_SUPCHG_UNPD_RCV

3451: , p_related_document_id => l_shipment_header_id
3452: , p_related_document_number => l_receipt_num
3453: , p_related_document_date => l_receipt_date
3454: , p_related_document_amount => l_receipt_amount
3455: , p_message_name => PO_MESSAGE_S.PO_SUPCHG_UNPD_RCV
3456: );
3457: END IF;
3458: d_position := 90;
3459: --check if invoice is validated

Line 3472: , p_message_name => PO_MESSAGE_S.PO_SUPCHG_UNVAL_RCV

3468: , p_related_document_id => l_shipment_header_id
3469: , p_related_document_number => l_receipt_num
3470: , p_related_document_date => l_receipt_date
3471: , p_related_document_amount => l_receipt_amount
3472: , p_message_name => PO_MESSAGE_S.PO_SUPCHG_UNVAL_RCV
3473: );
3474: END IF;
3475:
3476: END IF; --IF l_match_exists = 'Y'

Line 3566: , p_message_name => PO_MESSAGE_S.PO_SUPCHG_UNINV_4WAY

3562: , p_related_document_number => l_results.related_document_number(i)
3563: , p_related_document_date => l_results.related_document_date(i)
3564: , p_related_document_amount => l_results.related_document_amount(i)
3565: , p_message_application => 'PO'
3566: , p_message_name => PO_MESSAGE_S.PO_SUPCHG_UNINV_4WAY
3567: );
3568:
3569: -- 3 way match
3570: ELSIF (l_match_option = 'R' AND l_receipt_required_flag = 'Y' AND l_inspection_required_flag = 'N') THEN

Line 3584: , p_message_name => PO_MESSAGE_S.PO_SUPCHG_UNINV_3WAY

3580: , p_related_document_number => l_results.related_document_number(i)
3581: , p_related_document_date => l_results.related_document_date(i)
3582: , p_related_document_amount => l_results.related_document_amount(i)
3583: , p_message_application => 'PO'
3584: , p_message_name => PO_MESSAGE_S.PO_SUPCHG_UNINV_3WAY
3585: );
3586:
3587: -- 2 way match
3588: ELSIF (l_match_option = 'R' AND l_receipt_required_flag = 'N' AND l_inspection_required_flag = 'N') THEN

Line 3602: , p_message_name => PO_MESSAGE_S.PO_SUPCHG_UNINV_2WAY

3598: , p_related_document_number => l_results.related_document_number(i)
3599: , p_related_document_date => l_results.related_document_date(i)
3600: , p_related_document_amount => l_results.related_document_amount(i)
3601: , p_message_application => 'PO'
3602: , p_message_name => PO_MESSAGE_S.PO_SUPCHG_UNINV_2WAY
3603: );
3604:
3605: END IF;
3606:

Line 3764: , p_exception_type => PO_MESSAGE_S.PO_SUPCHG_UNPD_INV_SUM

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
3765: , p_validation_type => 'INVOICE'
3766: , p_document_id => l_document_id
3767: , p_related_document_id => l_invoice_id_tbl(i)
3768: , p_related_document_number => l_invoice_num_tbl(i)

Line 3772: , p_message_name => PO_MESSAGE_S.PO_SUPCHG_UNPD_INV

3768: , p_related_document_number => l_invoice_num_tbl(i)
3769: , p_related_document_date => l_invoice_date_tbl(i)
3770: , p_related_document_amount => l_invoice_amount_tbl(i)
3771: , p_message_application => 'PO'
3772: , p_message_name => PO_MESSAGE_S.PO_SUPCHG_UNPD_INV
3773: );
3774:
3775: END IF;
3776:

Line 3785: , p_exception_type => PO_MESSAGE_S.PO_SUPCHG_UNPD_INV_SUM

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
3786: , p_validation_type => 'INVOICE'
3787: , p_document_id => l_document_id
3788: , p_related_document_id => l_invoice_id_tbl(i)
3789: , p_related_document_number => l_invoice_num_tbl(i)

Line 3793: , p_message_name => PO_MESSAGE_S.PO_SUPCHG_UNVAL_INV

3789: , p_related_document_number => l_invoice_num_tbl(i)
3790: , p_related_document_date => l_invoice_date_tbl(i)
3791: , p_related_document_amount => l_invoice_amount_tbl(i)
3792: , p_message_application => 'PO'
3793: , p_message_name => PO_MESSAGE_S.PO_SUPCHG_UNVAL_INV
3794: );
3795:
3796:
3797: END IF;

Line 3808: , p_exception_type => PO_MESSAGE_S.PO_SUPCHG_INDAT_GE_NOVDAT_SUM

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
3809: , p_validation_type => 'INVOICE'
3810: , p_document_id => l_document_id
3811: , p_related_document_id => l_invoice_id_tbl(i)
3812: , p_related_document_number => l_invoice_num_tbl(i)

Line 3816: , p_message_name => PO_MESSAGE_S.PO_SUPCHG_INDAT_GE_NOVDAT

3812: , p_related_document_number => l_invoice_num_tbl(i)
3813: , p_related_document_date => l_invoice_date_tbl(i)
3814: , p_related_document_amount => l_invoice_amount_tbl(i)
3815: , p_message_application => 'PO'
3816: , p_message_name => PO_MESSAGE_S.PO_SUPCHG_INDAT_GE_NOVDAT
3817: );
3818:
3819: END IF;
3820: END LOOP; --FOR i IN 1..l_invoice_id_tbl.COUNT LOOP

Line 3859: , p_exception_type => PO_MESSAGE_S.PO_SUPCHG_UNMTCH_INV_VNDR_SUM

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
3860: , p_validation_type => 'INVOICE'
3861: , p_document_id => null--l_vendor_id
3862: , p_related_document_id => l_invoice_id_tbl(i)
3863: , p_related_document_number => l_invoice_num_tbl(i)

Line 3866: , p_message_name => PO_MESSAGE_S.PO_SUPCHG_UNMTCH_INV_VNDR

3862: , p_related_document_id => l_invoice_id_tbl(i)
3863: , p_related_document_number => l_invoice_num_tbl(i)
3864: , p_related_document_date => l_invoice_date_tbl(i)
3865: , p_message_application => 'PO'
3866: , p_message_name => PO_MESSAGE_S.PO_SUPCHG_UNMTCH_INV_VNDR
3867: );
3868: END LOOP;
3869: END IF;
3870:

Line 3887: , p_exception_type => PO_MESSAGE_S.PO_SUPCHG_PARTPD_INV_VNDR_SUM

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
3888: , p_validation_type => 'INVOICE'
3889: , p_document_id => null -- l_vendor_id
3890: , p_related_document_id => l_invoice_id_tbl(i)
3891: , p_related_document_number => l_invoice_num_tbl(i)

Line 3894: , p_message_name => PO_MESSAGE_S.PO_SUPCHG_PARTPD_INV_VNDR

3890: , p_related_document_id => l_invoice_id_tbl(i)
3891: , p_related_document_number => l_invoice_num_tbl(i)
3892: , p_related_document_date => l_invoice_date_tbl(i)
3893: , p_message_application => 'PO'
3894: , p_message_name => PO_MESSAGE_S.PO_SUPCHG_PARTPD_INV_VNDR
3895: );
3896: END LOOP;
3897: END IF;
3898:

Line 3915: , p_exception_type => PO_MESSAGE_S.PO_SUPCHG_PREPD_INV_VNDR_SUM

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
3916: , p_validation_type => 'INVOICE'
3917: , p_document_id => null --l_vendor_id
3918: , p_related_document_id => l_invoice_id_tbl(i)
3919: , p_related_document_number => l_invoice_num_tbl(i)

Line 3922: , p_message_name => PO_MESSAGE_S.PO_SUPCHG_PREPD_INV_VNDR

3918: , p_related_document_id => l_invoice_id_tbl(i)
3919: , p_related_document_number => l_invoice_num_tbl(i)
3920: , p_related_document_date => l_invoice_date_tbl(i)
3921: , p_message_application => 'PO'
3922: , p_message_name => PO_MESSAGE_S.PO_SUPCHG_PREPD_INV_VNDR
3923: );
3924: END LOOP;
3925: END IF;
3926: