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 629: WHEN FND_API.G_EXC_ERROR THEN

625: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
626: END IF;
627:
628: EXCEPTION
629: WHEN FND_API.G_EXC_ERROR THEN
630: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
631: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
632: G_MODULE||l_api_name,
633: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 645: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

641: x_msg_data := SQLERRM;
642:
643: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
644:
645: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
646: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
647: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
648: G_MODULE||l_api_name,
649: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 815: RAISE FND_API.G_EXC_ERROR;

811: G_MODULE||l_api_name,
812: '110: Invalid Template Id: '||p_template_id);
813: END IF;
814: FND_MESSAGE.set_name('OKC','OKC_XPRT_INVALID_TEMPLATE');
815: RAISE FND_API.G_EXC_ERROR;
816: END IF;
817:
818: CLOSE csr_template_dtls;
819:

Line 843: RAISE FND_API.G_EXC_ERROR;

839: '110: Template Model Does Not Exists : '||l_template_name);
840: END IF;
841: FND_MESSAGE.set_name('OKC','OKC_XPRT_INVALID_TMPL_MODEL');
842: FND_MESSAGE.set_token('TEMPLATE_NAME',l_template_name);
843: RAISE FND_API.G_EXC_ERROR;
844: END IF;
845:
846: CLOSE csr_template_model_id;
847:

Line 884: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

880: ) ;
881:
882: --- If any errors happen abort API
883: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
884: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
885: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
886: RAISE FND_API.G_EXC_ERROR;
887: END IF;
888:

Line 886: RAISE FND_API.G_EXC_ERROR;

882: --- If any errors happen abort API
883: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
884: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
885: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
886: RAISE FND_API.G_EXC_ERROR;
887: END IF;
888:
889: END IF; -- rule text generation
890:

Line 1174: WHEN FND_API.G_EXC_ERROR THEN

1170: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1171: END IF;
1172:
1173: EXCEPTION
1174: WHEN FND_API.G_EXC_ERROR THEN
1175: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1176: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1177: G_MODULE||l_api_name,
1178: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 1189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1185: x_return_status := G_RET_STS_ERROR ;
1186: x_msg_data := SQLERRM;
1187: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1188:
1189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1190: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1191: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1192: G_MODULE||l_api_name,
1193: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 1372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1368: );
1369:
1370: --- If any errors happen abort API
1371: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1373: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1374: RAISE FND_API.G_EXC_ERROR;
1375: END IF;
1376:

Line 1374: RAISE FND_API.G_EXC_ERROR;

1370: --- If any errors happen abort API
1371: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1373: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1374: RAISE FND_API.G_EXC_ERROR;
1375: END IF;
1376:
1377:
1378: END LOOP; -- Template Csr

Line 1402: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1398: );
1399:
1400: --- If any errors happen abort API
1401: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1402: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1403: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1404: RAISE FND_API.G_EXC_ERROR;
1405: END IF;
1406:

Line 1404: RAISE FND_API.G_EXC_ERROR;

1400: --- If any errors happen abort API
1401: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1402: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1403: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1404: RAISE FND_API.G_EXC_ERROR;
1405: END IF;
1406:
1407:
1408: END LOOP; -- csr_templates_to_delete

Line 1431: WHEN FND_API.G_EXC_ERROR THEN

1427: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1428: END IF;
1429:
1430: EXCEPTION
1431: WHEN FND_API.G_EXC_ERROR THEN
1432: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1433: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1434: G_MODULE||l_api_name,
1435: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 1441: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1437:
1438: x_return_status := G_RET_STS_ERROR ;
1439: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1440:
1441: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1442: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1443: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1444: G_MODULE||l_api_name,
1445: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 1561: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1557: );
1558:
1559: --- If any errors happen abort API
1560: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1561: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1562: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1563: RAISE FND_API.G_EXC_ERROR;
1564: END IF;
1565:

Line 1563: RAISE FND_API.G_EXC_ERROR;

1559: --- If any errors happen abort API
1560: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1561: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1562: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1563: RAISE FND_API.G_EXC_ERROR;
1564: END IF;
1565:
1566:
1567: END LOOP; -- csr_templates_to_delete

Line 1588: WHEN FND_API.G_EXC_ERROR THEN

1584: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1585: END IF;
1586:
1587: EXCEPTION
1588: WHEN FND_API.G_EXC_ERROR THEN
1589: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1590: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1591: G_MODULE||l_api_name,
1592: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 1598: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1594:
1595: x_return_status := G_RET_STS_ERROR ;
1596: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1597:
1598: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1599: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1600: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1601: G_MODULE||l_api_name,
1602: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 1735: RAISE FND_API.G_EXC_ERROR;

1731: G_MODULE||l_api_name,
1732: '110: Invalid Template Id: '||p_template_id);
1733: END IF;
1734: FND_MESSAGE.set_name('OKC','OKC_XPRT_INVALID_TEMPLATE');
1735: RAISE FND_API.G_EXC_ERROR;
1736: END IF;
1737:
1738: CLOSE csr_template_dtls;
1739:

Line 1819: WHEN FND_API.G_EXC_ERROR THEN

1815: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1816: END IF;
1817:
1818: EXCEPTION
1819: WHEN FND_API.G_EXC_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: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 1833: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1829:
1830: x_return_status := G_RET_STS_ERROR ;
1831: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1832:
1833: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1834: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1835: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1836: G_MODULE||l_api_name,
1837: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 1908: RETURN FND_API.G_TRUE;

1904: IF csr_check_cla_model%FOUND THEN
1905: OPEN csr_check_ext_rule(l_devl_project_id);
1906: FETCH csr_check_ext_rule INTO l_exists;
1907: IF csr_check_ext_rule%FOUND THEN
1908: RETURN FND_API.G_TRUE;
1909: ELSE
1910: RETURN FND_API.G_FALSE;
1911: END IF;
1912: CLOSE csr_check_ext_rule;

Line 1910: RETURN FND_API.G_FALSE;

1906: FETCH csr_check_ext_rule INTO l_exists;
1907: IF csr_check_ext_rule%FOUND THEN
1908: RETURN FND_API.G_TRUE;
1909: ELSE
1910: RETURN FND_API.G_FALSE;
1911: END IF;
1912: CLOSE csr_check_ext_rule;
1913: ELSE
1914: RETURN FND_API.G_FALSE;

Line 1914: RETURN FND_API.G_FALSE;

1910: RETURN FND_API.G_FALSE;
1911: END IF;
1912: CLOSE csr_check_ext_rule;
1913: ELSE
1914: RETURN FND_API.G_FALSE;
1915: END IF;
1916: CLOSE csr_check_cla_model;
1917:
1918: EXCEPTION

Line 2017: RAISE FND_API.G_EXC_ERROR;

2013: -- Modified to attach extension rule to Clause model from R12
2014: OPEN csr_get_cla_model_dtl(l_org_id,l_intent);
2015: FETCH csr_get_cla_model_dtl INTO l_model_id, l_model_osr;
2016: IF csr_get_cla_model_dtl%NOTFOUND THEN
2017: RAISE FND_API.G_EXC_ERROR;
2018: END IF;
2019: CLOSE csr_get_cla_model_dtl;
2020:
2021: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

2031: END IF;
2032:
2033: -- Generate the Rule Text for this Run Id if the rule doesn't exist/has been deleted/disabled
2034: -- Check_extension rule changed in R12 to check against Clause model. Added new parameter l_org_id
2035: IF (check_extension_rule(l_intent, l_org_id) = FND_API.G_FALSE) THEN
2036:
2037: fnd_file.put_line(FND_FILE.LOG,' ');
2038: fnd_file.put_line(FND_FILE.LOG,'Creating Extension Rule for : '||l_model_osr);
2039: fnd_file.put_line(FND_FILE.LOG,' ');

Line 2332: WHEN FND_API.G_EXC_ERROR THEN

2328: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2329: END IF;
2330:
2331: EXCEPTION
2332: WHEN FND_API.G_EXC_ERROR THEN
2333: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2334: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2335: G_MODULE||l_api_name,
2336: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 2342: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2338:
2339: x_return_status := G_RET_STS_ERROR ;
2340: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2341:
2342: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2343: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2344: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2345: G_MODULE||l_api_name,
2346: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 2456: RAISE FND_API.G_EXC_ERROR;

2452: -- Modified to attach extension rule to Clause model from R12
2453: OPEN csr_get_cla_model_dtl(l_intent,l_org_id);
2454: FETCH csr_get_cla_model_dtl INTO l_model_id, l_model_osr;
2455: IF csr_get_cla_model_dtl%NOTFOUND THEN
2456: RAISE FND_API.G_EXC_ERROR;
2457: END IF;
2458: CLOSE csr_get_cla_model_dtl;
2459:
2460: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

2470: END IF;
2471:
2472: -- Generate the Rule Text for this Run Id if the rule doesn't exist/has been deleted/disabled
2473: -- Check_extension rule changed in R12 to check against Clause model. Added new parameter l_org_id
2474: IF (check_extension_rule(l_intent, l_org_id) = FND_API.G_FALSE) THEN
2475:
2476: fnd_file.put_line(FND_FILE.LOG,' ');
2477: fnd_file.put_line(FND_FILE.LOG,'Creating Extension Rule for : '||l_model_osr);
2478: fnd_file.put_line(FND_FILE.LOG,' ');

Line 2771: WHEN FND_API.G_EXC_ERROR THEN

2767: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2768: END IF;
2769:
2770: EXCEPTION
2771: WHEN FND_API.G_EXC_ERROR THEN
2772: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2773: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2774: G_MODULE||l_api_name,
2775: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 2781: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2777:
2778: x_return_status := G_RET_STS_ERROR ;
2779: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2780:
2781: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2782: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2783: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2784: G_MODULE||l_api_name,
2785: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);