eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_CLOSEOUT_PVT dependencies on PO_MULTI_MOD_VAL_RESULTS

Line 845: --x_results PO_MULTI_MOD_VAL_RESULTS_TYPE

841: -- p_chk_list_req VARCHAR2
842:
843: --OUT:
844: --x_result_type VARCHAR2
845: --x_results PO_MULTI_MOD_VAL_RESULTS_TYPE
846:
847: --End of Comments
848: --------------------------------------------------------------------------------
849:

Line 854: , x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE

850: PROCEDURE validate_manage_closeout (
851: p_doc_id IN NUMBER
852: , p_chk_list_req IN VARCHAR2
853: , x_result_type OUT NOCOPY VARCHAR2
854: , x_results IN OUT NOCOPY PO_MULTI_MOD_VAL_RESULTS_TYPE
855: ) IS
856: l_progress NUMBER := 0;
857: l_result VARCHAR2(50);
858: l_tasklist_result VARCHAR2(50);

Line 903: X_RESULTS := PO_MULTI_MOD_VAL_RESULTS_TYPE.NEW_INSTANCE();

899:
900: l_progress := 10;
901:
902: IF (X_RESULTS IS NULL) THEN
903: X_RESULTS := PO_MULTI_MOD_VAL_RESULTS_TYPE.NEW_INSTANCE();
904: END IF;
905:
906: SELECT type_lookup_code
907: INTO l_type_lookup_code

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

917:
918: l_progress := 20;
919:
920: IF l_tasklist_result = c_result_type_FAILURE THEN
921: x_results.add_result(p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval
922: , p_multi_mod_request_id => p_doc_id
923: , p_validation_type => 'CHECKLIST'
924: , p_exception_type => c_result_type_FAILURE
925: , p_document_number => l_clm_doc_num

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

947: IF x_qa_result_tbl.COUNT > 0 THEN
948: FOR i IN x_qa_result_tbl.FIRST .. x_qa_result_tbl.LAST
949: LOOP
950: IF (x_qa_result_tbl(i).error_severity_name = OKC_REP_CLOSEOUT_PVT.G_QA_STS_WARNING) THEN
951: x_results.add_result(p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval
952: , p_multi_mod_request_id => p_doc_id
953: , p_validation_type => 'CONTRACT'
954: , p_exception_type => c_result_type_WARNING
955: , p_document_number => l_clm_doc_num

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

957: , p_message_name => ''
958: , p_message_text => x_qa_result_tbl(i).Problem_details);
959: ELSE
960: l_tasklist_result := c_result_type_FAILURE;
961: x_results.add_result(p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval
962: , p_multi_mod_request_id => p_doc_id
963: , p_validation_type => 'CONTRACT'
964: , p_exception_type => c_result_type_FAILURE
965: , p_document_number => l_clm_doc_num

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

988:
989: l_progress := 40;
990:
991: IF l_result = c_result_type_FAILURE THEN
992: x_results.add_result(p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval
993: , p_multi_mod_request_id => p_doc_id
994: , p_validation_type => 'MODIFICATION'
995: , p_exception_type => l_open_mod_fail_type
996: , p_document_number => l_clm_doc_num

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

1017:
1018: l_progress := 55;
1019:
1020: IF l_result = c_result_type_FAILURE THEN
1021: x_results.add_result(p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval
1022: , p_multi_mod_request_id => p_doc_id
1023: , p_validation_type => 'RECEIPTS'
1024: , p_exception_type => c_result_type_WARNING
1025: , p_document_number => l_clm_doc_num

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

1038:
1039: l_progress := 70;
1040:
1041: IF l_result = c_result_type_FAILURE THEN
1042: x_results.add_result(p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval
1043: , p_multi_mod_request_id => p_doc_id
1044: , p_validation_type => 'INVOICE'
1045: , p_exception_type => c_result_type_WARNING
1046: , p_document_number => l_clm_doc_num

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

1059:
1060: l_progress := 90;
1061:
1062: IF l_result = c_result_type_FAILURE THEN
1063: x_results.add_result(p_multi_mod_val_result_id => po_multi_mod_val_results_s.nextval
1064: , p_multi_mod_request_id => p_doc_id
1065: , p_validation_type => 'PAYMENT'
1066: , p_exception_type => c_result_type_WARNING
1067: , p_document_number => l_clm_doc_num

Line 1117: l_results PO_MULTI_MOD_VAL_RESULTS_TYPE;

1113: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || '.' || 'check_exceptions';
1114: l_progress NUMBER := 0;
1115: l_doc_id NUMBER;
1116: l_result_type VARCHAR2(20);
1117: l_results PO_MULTI_MOD_VAL_RESULTS_TYPE;
1118: l_fail_count NUMBER := 0;
1119: l_warn_count NUMBER := 0;
1120: l_validation_status VARCHAR2(20);
1121:

Line 1133: l_results := PO_MULTI_MOD_VAL_RESULTS_TYPE.NEW_INSTANCE();

1129: IF (PO_LOG.d_proc) THEN PO_LOG.proc_begin(d_module); END IF;
1130: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'p_req_id ' || p_req_id);
1131: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'p_chk_list_req ' || p_chk_list_req);
1132:
1133: l_results := PO_MULTI_MOD_VAL_RESULTS_TYPE.NEW_INSTANCE();
1134: l_progress := 10;
1135:
1136: DELETE
1137: FROM po_multi_mod_val_results

Line 1137: FROM po_multi_mod_val_results

1133: l_results := PO_MULTI_MOD_VAL_RESULTS_TYPE.NEW_INSTANCE();
1134: l_progress := 10;
1135:
1136: DELETE
1137: FROM po_multi_mod_val_results
1138: WHERE multi_mod_request_id = p_req_id;
1139:
1140: l_progress := 20;
1141:

Line 1166: INSERT INTO po_multi_mod_val_results

1162: l_progress := 50;
1163:
1164: FOR i IN l_results.MESSAGE_NAME.FIRST .. l_results.MESSAGE_NAME.LAST
1165: LOOP
1166: INSERT INTO po_multi_mod_val_results
1167: ( MULTI_MOD_VAL_RESULT_ID
1168: ,MULTI_MOD_REQUEST_ID
1169: ,MULTI_MOD_DOC_ID
1170: ,VALIDATION_TYPE

Line 1201: ( po_multi_mod_val_results_s.nextval

1197: ,CREATED_BY
1198: ,REQUEST_ID
1199: )
1200: VALUES
1201: ( po_multi_mod_val_results_s.nextval
1202: , p_req_id
1203: , l_doc_id
1204: , l_results.validation_type(i)
1205: , l_results.exception_type(i)

Line 1784: FROM po_multi_mod_val_results

1780: fnd_file.put_line(FND_FILE.LOG,'Checklist Required: ' || p_chk_list_req);
1781: fnd_file.put_line(FND_FILE.LOG,'--------------------------------------------------------------');
1782:
1783: DELETE
1784: FROM po_multi_mod_val_results
1785: WHERE multi_mod_request_id = p_req_id;
1786:
1787: l_progress := 5;
1788: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'Num of Records deleted from po_multi_mod_val_results:' || SQL%ROWCOUNT);

Line 1788: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'Num of Records deleted from po_multi_mod_val_results:' || SQL%ROWCOUNT);

1784: FROM po_multi_mod_val_results
1785: WHERE multi_mod_request_id = p_req_id;
1786:
1787: l_progress := 5;
1788: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'Num of Records deleted from po_multi_mod_val_results:' || SQL%ROWCOUNT);
1789: fnd_file.put_line(FND_FILE.LOG,'Existing validation records have been cleared');
1790:
1791: IF p_chk_list_req = 'Y' THEN
1792: l_open_mod_fail_type := 'WARNING';

Line 2446: -- Inserts the validation record into po_multi_mod_val_results

2442:
2443: --Name: store_validations
2444:
2445: --Function:
2446: -- Inserts the validation record into po_multi_mod_val_results
2447:
2448: --Parameters:
2449:
2450: --IN:

Line 2498: INSERT INTO po_multi_mod_val_results

2494: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || '.' || 'check_exceptions';
2495: l_progress NUMBER := 0;
2496:
2497: BEGIN
2498: INSERT INTO po_multi_mod_val_results
2499: ( MULTI_MOD_VAL_RESULT_ID
2500: ,MULTI_MOD_REQUEST_ID
2501: ,MULTI_MOD_DOC_ID
2502: ,VALIDATION_TYPE

Line 2533: ( po_multi_mod_val_results_s.nextval

2529: ,CREATED_BY
2530: ,REQUEST_ID
2531: )
2532: VALUES
2533: ( po_multi_mod_val_results_s.nextval
2534: , p_req_id
2535: , p_mod_doc_id
2536: , p_validation_type
2537: , p_exception_type

Line 3142: l_results PO_MULTI_MOD_VAL_RESULTS_TYPE;

3138: IS
3139: l_progress NUMBER := 0;
3140: l_document_id NUMBER;
3141: l_closeout_status VARCHAR2(50);
3142: l_results PO_MULTI_MOD_VAL_RESULTS_TYPE;
3143: l_result_type VARCHAR2(50) := 'SUCCESS';
3144: l_msg VARCHAR2(254);
3145: l_message_subject VARCHAR2(254);
3146: l_messages VARCHAR2(32000);

Line 3173: l_results := PO_MULTI_MOD_VAL_RESULTS_TYPE.NEW_INSTANCE();

3169: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'l_document_id ' || l_document_id);
3170:
3171: l_progress := 10;
3172:
3173: l_results := PO_MULTI_MOD_VAL_RESULTS_TYPE.NEW_INSTANCE();
3174:
3175: PO_CLOSEOUT_PVT.validate_manage_closeout (p_doc_id => l_document_id
3176: , p_chk_list_req => 'N' -- CheckList Error and Open Mod error are mutual exc, so the checklist added error not req for wf val.
3177: , x_result_type => l_result_type

Line 3412: l_results PO_MULTI_MOD_VAL_RESULTS_TYPE;

3408:
3409: l_progress NUMBER := 0;
3410: l_document_id NUMBER;
3411: l_closeout_status VARCHAR2(50);
3412: l_results PO_MULTI_MOD_VAL_RESULTS_TYPE;
3413: l_msg VARCHAR2(30);
3414:
3415: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || '.' || 'Set_Doc_TO_Prev_State';
3416: d_position NUMBER;

Line 3478: l_results PO_MULTI_MOD_VAL_RESULTS_TYPE;

3474:
3475: l_progress NUMBER := 0;
3476: l_document_id NUMBER;
3477: l_is_physical_complete VARCHAR2(1) := 'N';
3478: l_results PO_MULTI_MOD_VAL_RESULTS_TYPE;
3479: l_msg VARCHAR2(30);
3480:
3481: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || '.' || 'IS_STATUS_PHYSICAL_COMPLETE';
3482: d_position NUMBER;