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.OKC_XPRT_IMPORT_PVT dependencies on OKC_XPRT_UTIL_PVT

Line 195: OKC_XPRT_UTIL_PVT.populate_questions_order

191:
192: --
193: -- Call API to populate template questions
194: --
195: OKC_XPRT_UTIL_PVT.populate_questions_order
196: (
197: p_template_id => p_template_id,
198: p_commit_flag => 'Y',
199: p_mode => p_mode,

Line 614: OKC_XPRT_UTIL_PVT.check_rules_validity

610: fnd_file.put_line(FND_FILE.LOG,'Step 1.1: Rules QA Checks old ');
611: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
612: fnd_file.put_line(FND_FILE.LOG,' ');
613:
614: OKC_XPRT_UTIL_PVT.check_rules_validity
615: (
616: p_qa_mode => 'PUBLISH',
617: p_template_id => NULL,
618: x_sequence_id => l_sequence_id,

Line 626: fnd_file.put_line(FND_FILE.LOG,'After OKC_XPRT_UTIL_PVT.check_rules_validity');

622: x_msg_count => x_msg_count
623: ) ;
624:
625: fnd_file.put_line(FND_FILE.LOG,' ');
626: fnd_file.put_line(FND_FILE.LOG,'After OKC_XPRT_UTIL_PVT.check_rules_validity');
627: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
628: fnd_file.put_line(FND_FILE.LOG,'x_qa_status: '||l_qa_status);
629: fnd_file.put_line(FND_FILE.LOG,'x_sequence_id: '||l_sequence_id);
630: fnd_file.put_line(FND_FILE.LOG,' ');

Line 922: OKC_XPRT_UTIL_PVT.publish_rule_with_no_tmpl

918:
919:
920: IF l_rules_cnt = 0 THEN
921:
922: OKC_XPRT_UTIL_PVT.publish_rule_with_no_tmpl
923: (
924: p_calling_mode => 'PUBLISH',
925: x_return_status => x_return_status,
926: x_msg_data => x_msg_data,

Line 931: fnd_file.put_line(FND_FILE.LOG,'After OKC_XPRT_UTIL_PVT.publish_rule_with_no_tmpl');

927: x_msg_count => x_msg_count
928: );
929:
930: fnd_file.put_line(FND_FILE.LOG,' ');
931: fnd_file.put_line(FND_FILE.LOG,'After OKC_XPRT_UTIL_PVT.publish_rule_with_no_tmpl');
932: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
933: fnd_file.put_line(FND_FILE.LOG,' ');
934:
935: --- If any errors happen abort API

Line 1133: OKC_XPRT_UTIL_PVT.check_import_status

1129: fnd_file.put_line(FND_FILE.LOG,'Step 8: Checking Status of Rules imported');
1130: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1131: fnd_file.put_line(FND_FILE.LOG,' ');
1132:
1133: OKC_XPRT_UTIL_PVT.check_import_status
1134: (
1135: p_run_id => G_RUN_ID,
1136: p_import_status => 'S',
1137: p_model_type => 'R', -- Rules Import

Line 1191: OKC_XPRT_UTIL_PVT.create_test_publication

1187: fnd_file.put_line(FND_FILE.LOG,'Step 9: Calling the Test Publication API');
1188: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1189: fnd_file.put_line(FND_FILE.LOG,' ');
1190:
1191: OKC_XPRT_UTIL_PVT.create_test_publication
1192: (
1193: x_return_status => x_return_status,
1194: x_msg_data => x_msg_data,
1195: x_msg_count => x_msg_count

Line 1244: OKC_XPRT_UTIL_PVT.create_production_publication

1240: fnd_file.put_line(FND_FILE.LOG,'Step 9: Calling the Production Publication API');
1241: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1242: fnd_file.put_line(FND_FILE.LOG,' ');
1243:
1244: OKC_XPRT_UTIL_PVT.create_production_publication
1245: (
1246: p_calling_mode => 'PUBLISH',
1247: p_template_id => NULL, -- pick all templates for the current request
1248: x_return_status => x_return_status,

Line 1370: OKC_XPRT_UTIL_PVT.check_rules_validity

1366: fnd_file.put_line(FND_FILE.LOG,'Step 1.1: Rules QA Checks new ');
1367: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1368: fnd_file.put_line(FND_FILE.LOG,' ');
1369:
1370: OKC_XPRT_UTIL_PVT.check_rules_validity
1371: (
1372: p_qa_mode => 'PUBLISH',
1373: p_template_id => NULL,
1374: x_sequence_id => l_sequence_id,

Line 1382: fnd_file.put_line(FND_FILE.LOG,'After OKC_XPRT_UTIL_PVT.check_rules_validity');

1378: x_msg_count => x_msg_count
1379: ) ;
1380:
1381: fnd_file.put_line(FND_FILE.LOG,' ');
1382: fnd_file.put_line(FND_FILE.LOG,'After OKC_XPRT_UTIL_PVT.check_rules_validity');
1383: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1384: fnd_file.put_line(FND_FILE.LOG,'x_qa_status: '||l_qa_status);
1385: fnd_file.put_line(FND_FILE.LOG,'x_sequence_id: '||l_sequence_id);
1386: fnd_file.put_line(FND_FILE.LOG,' ');

Line 1478: SELECT okc_xprt_util_pvt.is_rule_line_level(l_rule_id) INTO l_line_level_flag FROM DUAL;

1474: LOOP
1475: FETCH csr_rules INTO l_rule_id;
1476: EXIT WHEN csr_rules%NOTFOUND;
1477:
1478: SELECT okc_xprt_util_pvt.is_rule_line_level(l_rule_id) INTO l_line_level_flag FROM DUAL;
1479:
1480: UPDATE okc_xprt_rule_hdrs_all
1481: SET status_code = 'ACTIVE',
1482: published_flag = 'Y',

Line 1817: OKC_XPRT_UTIL_PVT.publish_rule_with_no_tmpl

1813:
1814:
1815: IF l_rules_cnt = 0 THEN
1816:
1817: OKC_XPRT_UTIL_PVT.publish_rule_with_no_tmpl
1818: (
1819: p_calling_mode => 'DISABLE',
1820: x_return_status => x_return_status,
1821: x_msg_data => x_msg_data,

Line 1826: fnd_file.put_line(FND_FILE.LOG,'After OKC_XPRT_UTIL_PVT.publish_rule_with_no_tmpl');

1822: x_msg_count => x_msg_count
1823: );
1824:
1825: fnd_file.put_line(FND_FILE.LOG,' ');
1826: fnd_file.put_line(FND_FILE.LOG,'After OKC_XPRT_UTIL_PVT.publish_rule_with_no_tmpl');
1827: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1828: fnd_file.put_line(FND_FILE.LOG,' ');
1829:
1830: --- If any errors happen abort API

Line 1996: OKC_XPRT_UTIL_PVT.check_import_status

1992: fnd_file.put_line(FND_FILE.LOG,'Step 5: Checking Status of Rules imported');
1993: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1994: fnd_file.put_line(FND_FILE.LOG,' ');
1995:
1996: OKC_XPRT_UTIL_PVT.check_import_status
1997: (
1998: p_run_id => G_RUN_ID,
1999: p_import_status => 'S',
2000: p_model_type => 'R', -- Rules Import

Line 2054: OKC_XPRT_UTIL_PVT.create_test_publication

2050: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2051: fnd_file.put_line(FND_FILE.LOG,' ');
2052:
2053:
2054: OKC_XPRT_UTIL_PVT.create_test_publication
2055: (
2056: x_return_status => x_return_status,
2057: x_msg_data => x_msg_data,
2058: x_msg_count => x_msg_count

Line 2108: OKC_XPRT_UTIL_PVT.create_production_publication

2104: fnd_file.put_line(FND_FILE.LOG,'Step 7: Calling the Production Publication API');
2105: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2106: fnd_file.put_line(FND_FILE.LOG,' ');
2107:
2108: OKC_XPRT_UTIL_PVT.create_production_publication
2109: (
2110: p_calling_mode => 'DISABLE',
2111: p_template_id => NULL, -- pick all templates for the current request
2112: x_return_status => x_return_status,

Line 2263: SELECT okc_xprt_util_pvt.is_rule_line_level(l_rule_id) INTO l_line_level_flag FROM DUAL;

2259: LOOP
2260: FETCH csr_rules INTO l_rule_id;
2261: EXIT WHEN csr_rules%NOTFOUND;
2262:
2263: SELECT okc_xprt_util_pvt.is_rule_line_level(l_rule_id) INTO l_line_level_flag FROM DUAL;
2264:
2265: UPDATE okc_xprt_rule_hdrs_all
2266: SET status_code = 'INACTIVE',
2267: published_flag = 'Y',

Line 2461: OKC_XPRT_UTIL_PVT.create_test_publication

2457: fnd_file.put_line(FND_FILE.LOG,'Step 2: Calling the Test Publication API');
2458: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2459: fnd_file.put_line(FND_FILE.LOG,' ');
2460:
2461: OKC_XPRT_UTIL_PVT.create_test_publication
2462: (
2463: x_return_status => x_return_status,
2464: x_msg_data => x_msg_data,
2465: x_msg_count => x_msg_count

Line 2491: OKC_XPRT_UTIL_PVT.create_production_publication

2487: fnd_file.put_line(FND_FILE.LOG,'Step 3: Calling the Production Publication API');
2488: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2489: fnd_file.put_line(FND_FILE.LOG,' ');
2490:
2491: OKC_XPRT_UTIL_PVT.create_production_publication
2492: (
2493: p_calling_mode => 'SYNC',
2494: p_template_id => NULL, -- pick all templates for the current request
2495: x_return_status => x_return_status,

Line 2671: OKC_XPRT_UTIL_PVT.check_rules_validity

2667: fnd_file.put_line(FND_FILE.LOG,'Step 0: Template Rules QA Checks ');
2668: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2669: fnd_file.put_line(FND_FILE.LOG,' ');
2670:
2671: OKC_XPRT_UTIL_PVT.check_rules_validity
2672: (
2673: p_qa_mode => 'APPROVAL',
2674: p_template_id => p_template_id,
2675: x_sequence_id => l_sequence_id,

Line 2683: fnd_file.put_line(FND_FILE.LOG,'After OKC_XPRT_UTIL_PVT.check_rules_validity');

2679: x_msg_count => x_msg_count
2680: ) ;
2681:
2682: fnd_file.put_line(FND_FILE.LOG,' ');
2683: fnd_file.put_line(FND_FILE.LOG,'After OKC_XPRT_UTIL_PVT.check_rules_validity');
2684: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
2685: fnd_file.put_line(FND_FILE.LOG,'x_qa_status: '||l_qa_status);
2686: fnd_file.put_line(FND_FILE.LOG,'x_sequence_id: '||l_sequence_id);
2687: fnd_file.put_line(FND_FILE.LOG,' ');

Line 2945: OKC_XPRT_UTIL_PVT.check_import_status

2941: fnd_file.put_line(FND_FILE.LOG,'Step 4: Checking Status of Rules imported');
2942: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2943: fnd_file.put_line(FND_FILE.LOG,' ');
2944:
2945: OKC_XPRT_UTIL_PVT.check_import_status
2946: (
2947: p_run_id => G_RUN_ID,
2948: p_import_status => 'S',
2949: p_model_type => 'R', -- Rules Import

Line 2978: OKC_XPRT_UTIL_PVT.create_test_publication

2974: fnd_file.put_line(FND_FILE.LOG,'Step 5: Calling the Test Publication API');
2975: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2976: fnd_file.put_line(FND_FILE.LOG,' ');
2977:
2978: OKC_XPRT_UTIL_PVT.create_test_publication
2979: (
2980: x_return_status => x_return_status,
2981: x_msg_data => x_msg_data,
2982: x_msg_count => x_msg_count