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_RULES_PVT dependencies on FND_API

Line 19: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;

15: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
16: G_MODULE CONSTANT VARCHAR2(250) := 'okc.plsql.'||g_pkg_name||'.';
17: G_APPLICATION_ID CONSTANT NUMBER :=510; -- OKC Application
18:
19: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
20: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
21:
22: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
23: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

Line 20: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;

16: G_MODULE CONSTANT VARCHAR2(250) := 'okc.plsql.'||g_pkg_name||'.';
17: G_APPLICATION_ID CONSTANT NUMBER :=510; -- OKC Application
18:
19: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
20: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
21:
22: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
23: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
24: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

Line 22: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

18:
19: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
20: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
21:
22: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
23: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
24: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
25:
26: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';

Line 23: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

19: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
20: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
21:
22: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
23: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
24: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
25:
26: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
27: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';

Line 24: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

20: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
21:
22: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
23: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
24: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
25:
26: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
27: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
28: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';

Line 159: x_return_status := FND_API.G_RET_STS_SUCCESS;

155: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
156: END IF;
157:
158: -- Initialize API return status to success
159: x_return_status := FND_API.G_RET_STS_SUCCESS;
160:
161: -- 8i 9i compatibility issue
162: -- initialize the CLOB
163: DBMS_LOB.CREATETEMPORARY(x_stmt_rule, FALSE, DBMS_LOB.CALL);

Line 615: WHEN FND_API.G_EXC_ERROR THEN

611: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
612: END IF;
613:
614: EXCEPTION
615: WHEN FND_API.G_EXC_ERROR THEN
616: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
617: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
618: G_MODULE||l_api_name,
619: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 631: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

627: x_msg_data := SQLERRM;
628:
629: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
630:
631: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
632: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
633: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
634: G_MODULE||l_api_name,
635: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 801: RAISE FND_API.G_EXC_ERROR;

797: G_MODULE||l_api_name,
798: '110: Invalid Template Id: '||p_template_id);
799: END IF;
800: FND_MESSAGE.set_name('OKC','OKC_XPRT_INVALID_TEMPLATE');
801: RAISE FND_API.G_EXC_ERROR;
802: END IF;
803:
804: CLOSE csr_template_dtls;
805:

Line 829: RAISE FND_API.G_EXC_ERROR;

825: '110: Template Model Does Not Exists : '||l_template_name);
826: END IF;
827: FND_MESSAGE.set_name('OKC','OKC_XPRT_INVALID_TMPL_MODEL');
828: FND_MESSAGE.set_token('TEMPLATE_NAME',l_template_name);
829: RAISE FND_API.G_EXC_ERROR;
830: END IF;
831:
832: CLOSE csr_template_model_id;
833:

Line 870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

866: ) ;
867:
868: --- If any errors happen abort API
869: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
871: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
872: RAISE FND_API.G_EXC_ERROR;
873: END IF;
874:

Line 872: RAISE FND_API.G_EXC_ERROR;

868: --- If any errors happen abort API
869: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
871: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
872: RAISE FND_API.G_EXC_ERROR;
873: END IF;
874:
875: END IF; -- rule text generation
876:

Line 1160: WHEN FND_API.G_EXC_ERROR THEN

1156: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1157: END IF;
1158:
1159: EXCEPTION
1160: WHEN FND_API.G_EXC_ERROR THEN
1161: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1162: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1163: G_MODULE||l_api_name,
1164: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 1175: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1171: x_return_status := G_RET_STS_ERROR ;
1172: x_msg_data := SQLERRM;
1173: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1174:
1175: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1176: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1177: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1178: G_MODULE||l_api_name,
1179: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 1358: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1354: );
1355:
1356: --- If any errors happen abort API
1357: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1358: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1359: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1360: RAISE FND_API.G_EXC_ERROR;
1361: END IF;
1362:

Line 1360: RAISE FND_API.G_EXC_ERROR;

1356: --- If any errors happen abort API
1357: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1358: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1359: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1360: RAISE FND_API.G_EXC_ERROR;
1361: END IF;
1362:
1363:
1364: END LOOP; -- Template Csr

Line 1388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1384: );
1385:
1386: --- If any errors happen abort API
1387: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1389: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1390: RAISE FND_API.G_EXC_ERROR;
1391: END IF;
1392:

Line 1390: RAISE FND_API.G_EXC_ERROR;

1386: --- If any errors happen abort API
1387: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1389: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1390: RAISE FND_API.G_EXC_ERROR;
1391: END IF;
1392:
1393:
1394: END LOOP; -- csr_templates_to_delete

Line 1417: WHEN FND_API.G_EXC_ERROR THEN

1413: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1414: END IF;
1415:
1416: EXCEPTION
1417: WHEN FND_API.G_EXC_ERROR THEN
1418: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1419: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1420: G_MODULE||l_api_name,
1421: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 1427: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1423:
1424: x_return_status := G_RET_STS_ERROR ;
1425: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1426:
1427: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1428: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1429: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1430: G_MODULE||l_api_name,
1431: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 1547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1543: );
1544:
1545: --- If any errors happen abort API
1546: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1548: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1549: RAISE FND_API.G_EXC_ERROR;
1550: END IF;
1551:

Line 1549: RAISE FND_API.G_EXC_ERROR;

1545: --- If any errors happen abort API
1546: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1548: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1549: RAISE FND_API.G_EXC_ERROR;
1550: END IF;
1551:
1552:
1553: END LOOP; -- csr_templates_to_delete

Line 1574: WHEN FND_API.G_EXC_ERROR THEN

1570: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1571: END IF;
1572:
1573: EXCEPTION
1574: WHEN FND_API.G_EXC_ERROR THEN
1575: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1576: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1577: G_MODULE||l_api_name,
1578: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 1584: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1580:
1581: x_return_status := G_RET_STS_ERROR ;
1582: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1583:
1584: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1585: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1586: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1587: G_MODULE||l_api_name,
1588: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 1721: RAISE FND_API.G_EXC_ERROR;

1717: G_MODULE||l_api_name,
1718: '110: Invalid Template Id: '||p_template_id);
1719: END IF;
1720: FND_MESSAGE.set_name('OKC','OKC_XPRT_INVALID_TEMPLATE');
1721: RAISE FND_API.G_EXC_ERROR;
1722: END IF;
1723:
1724: CLOSE csr_template_dtls;
1725:

Line 1805: WHEN FND_API.G_EXC_ERROR THEN

1801: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1802: END IF;
1803:
1804: EXCEPTION
1805: WHEN FND_API.G_EXC_ERROR THEN
1806: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1807: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1808: G_MODULE||l_api_name,
1809: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 1819: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1815:
1816: x_return_status := G_RET_STS_ERROR ;
1817: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1818:
1819: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1820: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1821: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1822: G_MODULE||l_api_name,
1823: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 1894: RETURN FND_API.G_TRUE;

1890: IF csr_check_cla_model%FOUND THEN
1891: OPEN csr_check_ext_rule(l_devl_project_id);
1892: FETCH csr_check_ext_rule INTO l_exists;
1893: IF csr_check_ext_rule%FOUND THEN
1894: RETURN FND_API.G_TRUE;
1895: ELSE
1896: RETURN FND_API.G_FALSE;
1897: END IF;
1898: CLOSE csr_check_ext_rule;

Line 1896: RETURN FND_API.G_FALSE;

1892: FETCH csr_check_ext_rule INTO l_exists;
1893: IF csr_check_ext_rule%FOUND THEN
1894: RETURN FND_API.G_TRUE;
1895: ELSE
1896: RETURN FND_API.G_FALSE;
1897: END IF;
1898: CLOSE csr_check_ext_rule;
1899: ELSE
1900: RETURN FND_API.G_FALSE;

Line 1900: RETURN FND_API.G_FALSE;

1896: RETURN FND_API.G_FALSE;
1897: END IF;
1898: CLOSE csr_check_ext_rule;
1899: ELSE
1900: RETURN FND_API.G_FALSE;
1901: END IF;
1902: CLOSE csr_check_cla_model;
1903:
1904: EXCEPTION

Line 2003: RAISE FND_API.G_EXC_ERROR;

1999: -- Modified to attach extension rule to Clause model from R12
2000: OPEN csr_get_cla_model_dtl(l_org_id,l_intent);
2001: FETCH csr_get_cla_model_dtl INTO l_model_id, l_model_osr;
2002: IF csr_get_cla_model_dtl%NOTFOUND THEN
2003: RAISE FND_API.G_EXC_ERROR;
2004: END IF;
2005: CLOSE csr_get_cla_model_dtl;
2006:
2007: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2021: IF (check_extension_rule(l_intent, l_org_id) = FND_API.G_FALSE) THEN

2017: END IF;
2018:
2019: -- Generate the Rule Text for this Run Id if the rule doesn't exist/has been deleted/disabled
2020: -- Check_extension rule changed in R12 to check against Clause model. Added new parameter l_org_id
2021: IF (check_extension_rule(l_intent, l_org_id) = FND_API.G_FALSE) THEN
2022:
2023: fnd_file.put_line(FND_FILE.LOG,' ');
2024: fnd_file.put_line(FND_FILE.LOG,'Creating Extension Rule for : '||l_model_osr);
2025: fnd_file.put_line(FND_FILE.LOG,' ');

Line 2318: WHEN FND_API.G_EXC_ERROR THEN

2314: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2315: END IF;
2316:
2317: EXCEPTION
2318: WHEN FND_API.G_EXC_ERROR THEN
2319: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2320: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2321: G_MODULE||l_api_name,
2322: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 2328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2324:
2325: x_return_status := G_RET_STS_ERROR ;
2326: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2327:
2328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2329: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2330: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2331: G_MODULE||l_api_name,
2332: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 2442: RAISE FND_API.G_EXC_ERROR;

2438: -- Modified to attach extension rule to Clause model from R12
2439: OPEN csr_get_cla_model_dtl(l_intent,l_org_id);
2440: FETCH csr_get_cla_model_dtl INTO l_model_id, l_model_osr;
2441: IF csr_get_cla_model_dtl%NOTFOUND THEN
2442: RAISE FND_API.G_EXC_ERROR;
2443: END IF;
2444: CLOSE csr_get_cla_model_dtl;
2445:
2446: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2460: IF (check_extension_rule(l_intent, l_org_id) = FND_API.G_FALSE) THEN

2456: END IF;
2457:
2458: -- Generate the Rule Text for this Run Id if the rule doesn't exist/has been deleted/disabled
2459: -- Check_extension rule changed in R12 to check against Clause model. Added new parameter l_org_id
2460: IF (check_extension_rule(l_intent, l_org_id) = FND_API.G_FALSE) THEN
2461:
2462: fnd_file.put_line(FND_FILE.LOG,' ');
2463: fnd_file.put_line(FND_FILE.LOG,'Creating Extension Rule for : '||l_model_osr);
2464: fnd_file.put_line(FND_FILE.LOG,' ');

Line 2757: WHEN FND_API.G_EXC_ERROR THEN

2753: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2754: END IF;
2755:
2756: EXCEPTION
2757: WHEN FND_API.G_EXC_ERROR THEN
2758: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2759: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2760: G_MODULE||l_api_name,
2761: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 2767: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2763:
2764: x_return_status := G_RET_STS_ERROR ;
2765: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2766:
2767: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2768: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2769: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2770: G_MODULE||l_api_name,
2771: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);