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 FND_API

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

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

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

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

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

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

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

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

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

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

Line 58: RETURN FND_API.G_TRUE;

54: OPEN csr_check_rule_exists(p_rule_id);
55: FETCH csr_check_rule_exists INTO l_exists;
56: IF csr_check_rule_exists%FOUND THEN
57: CLOSE csr_check_rule_exists;
58: RETURN FND_API.G_TRUE;
59: ELSE
60: CLOSE csr_check_rule_exists;
61: RETURN FND_API.G_FALSE;
62: END IF;

Line 61: RETURN FND_API.G_FALSE;

57: CLOSE csr_check_rule_exists;
58: RETURN FND_API.G_TRUE;
59: ELSE
60: CLOSE csr_check_rule_exists;
61: RETURN FND_API.G_FALSE;
62: END IF;
63:
64:
65: EXCEPTION

Line 221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

217: fnd_file.put_line(FND_FILE.LOG,' ');
218:
219: --- If any errors happen abort API
220: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
222: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
223: RAISE FND_API.G_EXC_ERROR;
224: END IF;
225:

Line 223: RAISE FND_API.G_EXC_ERROR;

219: --- If any errors happen abort API
220: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
222: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
223: RAISE FND_API.G_EXC_ERROR;
224: END IF;
225:
226: -- Check If any rules had QA errors and abort
227: IF l_qa_status <> 'S' THEN

Line 297: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

293: l_rule_exists_flag := 'F';
294: END LOOP;
295: COMMIT;
296: -- Added for Bug 4757731
297: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
298:
299: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
300: -- Added for Bug 4757731
301: FOR csr_pub_rule_rec IN csr_pub_rule_list

Line 312: RAISE FND_API.G_EXC_ERROR;

308: l_rule_exists_flag := 'F';
309: END LOOP;
310: COMMIT;
311: -- Added for Bug 4757731
312: RAISE FND_API.G_EXC_ERROR;
313: END IF;
314:
315:
316: /*

Line 356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

352: l_rule_exists_flag := 'F';
353: END LOOP;
354: COMMIT;
355: -- Added for Bug 4757731
356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
357:
358: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
359: -- Added for Bug 4757731
360: FOR csr_pub_rule_rec IN csr_pub_rule_list

Line 371: RAISE FND_API.G_EXC_ERROR;

367: l_rule_exists_flag := 'F';
368: END LOOP;
369: COMMIT;
370: -- Added for Bug 4757731
371: RAISE FND_API.G_EXC_ERROR;
372: END IF;
373:
374: /*
375: Step 4: Import Template Model(s)

Line 410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

406: l_rule_exists_flag := 'F';
407: END LOOP;
408: COMMIT;
409: -- Added for Bug 4757731
410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
411:
412: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
413: -- Added for Bug 4757731
414: FOR csr_pub_rule_rec IN csr_pub_rule_list

Line 425: RAISE FND_API.G_EXC_ERROR;

421: l_rule_exists_flag := 'F';
422: END LOOP;
423: COMMIT;
424: -- Added for Bug 4757731
425: RAISE FND_API.G_EXC_ERROR;
426: END IF;
427:
428:
429: /*

Line 467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

463: l_rule_exists_flag := 'F';
464: END LOOP;
465: COMMIT;
466: -- Added for Bug 4757731
467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
468:
469: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
470: -- Added for Bug 4757731
471: FOR csr_pub_rule_rec IN csr_pub_rule_list

Line 482: RAISE FND_API.G_EXC_ERROR;

478: l_rule_exists_flag := 'F';
479: END LOOP;
480: COMMIT;
481: -- Added for Bug 4757731
482: RAISE FND_API.G_EXC_ERROR;
483: END IF;
484:
485: /*
486: Step 5.1: Count Rules to be imported

Line 536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

532: l_rule_exists_flag := 'F';
533: END LOOP;
534: COMMIT;
535: -- Added for Bug 4757731
536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
537:
538: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
539: -- Added for Bug 4757731
540: FOR csr_pub_rule_rec IN csr_pub_rule_list

Line 551: RAISE FND_API.G_EXC_ERROR;

547: l_rule_exists_flag := 'F';
548: END LOOP;
549: COMMIT;
550: -- Added for Bug 4757731
551: RAISE FND_API.G_EXC_ERROR;
552: END IF;
553:
554: fnd_file.put_line(FND_FILE.LOG,' ');
555: fnd_file.put_line(FND_FILE.LOG,'Rules has No expert template attached');

Line 637: RAISE FND_API.G_EXC_ERROR;

633: l_rule_exists_flag := 'F';
634: END LOOP;
635: COMMIT;
636:
637: RAISE FND_API.G_EXC_ERROR;
638: ELSE
639: -- child submission successful, pause the parent program
640: fnd_conc_global.set_req_globals
641: ( conc_status => 'PAUSED',

Line 706: RAISE FND_API.G_EXC_ERROR;

702: l_rule_exists_flag := 'F';
703: END LOOP;
704: COMMIT;
705:
706: RAISE FND_API.G_EXC_ERROR;
707: END IF;
708:
709:
710: /*

Line 749: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

745: l_rule_exists_flag := 'F';
746: END LOOP;
747: COMMIT;
748: -- Added for Bug 4757731
749: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
750:
751: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
752: -- Added for Bug 4757731
753: FOR csr_pub_rule_rec IN csr_pub_rule_list

Line 764: RAISE FND_API.G_EXC_ERROR;

760: l_rule_exists_flag := 'F';
761: END LOOP;
762: COMMIT;
763: -- Added for Bug 4757731
764: RAISE FND_API.G_EXC_ERROR;
765: END IF;
766:
767:
768: /*

Line 804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

800: l_rule_exists_flag := 'F';
801: END LOOP;
802: COMMIT;
803: -- Added for Bug 4757731
804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
805:
806: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
807: -- Added for Bug 4757731
808: FOR csr_pub_rule_rec IN csr_pub_rule_list

Line 819: RAISE FND_API.G_EXC_ERROR;

815: l_rule_exists_flag := 'F';
816: END LOOP;
817: COMMIT;
818: -- Added for Bug 4757731
819: RAISE FND_API.G_EXC_ERROR;
820: END IF;
821: /*
822: Step 10: Call the Production Publication API
823: */

Line 859: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

855: l_rule_exists_flag := 'F';
856: END LOOP;
857: COMMIT;
858: -- Added for Bug 4757731
859: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
860:
861: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
862: -- Added for Bug 4757731
863: FOR csr_pub_rule_rec IN csr_pub_rule_list

Line 874: RAISE FND_API.G_EXC_ERROR;

870: l_rule_exists_flag := 'F';
871: END LOOP;
872: COMMIT;
873: -- Added for Bug 4757731
874: RAISE FND_API.G_EXC_ERROR;
875: END IF;
876:
877:
878:

Line 909: WHEN FND_API.G_EXC_ERROR THEN

905:
906: END IF; -- req_data IS NULL
907:
908: EXCEPTION
909: WHEN FND_API.G_EXC_ERROR THEN
910: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
911: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
912: G_MODULE||l_api_name,
913: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 923: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

919: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_ERROR);
920: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);
921: fnd_file.put_line(FND_FILE.LOG,' ');
922:
923: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
924: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
925: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
926: G_MODULE||l_api_name,
927: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 1101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1097: l_rule_exists_flag := 'F';
1098: END LOOP;
1099: COMMIT;
1100: -- Added for Bug 4757731
1101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1102:
1103: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1104: -- Added for Bug 4757731
1105: FOR csr_dis_rule_rec IN csr_dis_rule_list

Line 1116: RAISE FND_API.G_EXC_ERROR;

1112: l_rule_exists_flag := 'F';
1113: END LOOP;
1114: COMMIT;
1115: -- Added for Bug 4757731
1116: RAISE FND_API.G_EXC_ERROR;
1117: END IF;
1118:
1119:
1120: /*

Line 1158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1154: l_rule_exists_flag := 'F';
1155: END LOOP;
1156: COMMIT;
1157: -- Added for Bug 4757731
1158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1159:
1160: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1161: -- Added for Bug 4757731
1162: FOR csr_dis_rule_rec IN csr_dis_rule_list

Line 1173: RAISE FND_API.G_EXC_ERROR;

1169: l_rule_exists_flag := 'F';
1170: END LOOP;
1171: COMMIT;
1172: -- Added for Bug 4757731
1173: RAISE FND_API.G_EXC_ERROR;
1174: END IF;
1175: /*
1176: Step 3.1: Count Rules to be imported
1177: Check if there are any records in cz_imp_rules

Line 1226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1222: l_rule_exists_flag := 'F';
1223: END LOOP;
1224: COMMIT;
1225: -- Added for Bug 4757731
1226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1227:
1228: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1229: -- Added for Bug 4757731
1230: FOR csr_dis_rule_rec IN csr_dis_rule_list

Line 1241: RAISE FND_API.G_EXC_ERROR;

1237: l_rule_exists_flag := 'F';
1238: END LOOP;
1239: COMMIT;
1240: -- Added for Bug 4757731
1241: RAISE FND_API.G_EXC_ERROR;
1242: END IF;
1243:
1244: fnd_file.put_line(FND_FILE.LOG,' ');
1245: fnd_file.put_line(FND_FILE.LOG,'Rules has No expert template attached');

Line 1298: RAISE FND_API.G_EXC_ERROR;

1294: l_rule_exists_flag := 'F';
1295: END LOOP;
1296: COMMIT;
1297: -- Added for Bug 4757731
1298: RAISE FND_API.G_EXC_ERROR;
1299: ELSE
1300: -- child submission successful, pause the parent program
1301: fnd_conc_global.set_req_globals
1302: ( conc_status => 'PAUSED',

Line 1364: RAISE FND_API.G_EXC_ERROR;

1360: AND rule_id = csr_dis_rule_rec.rule_id;
1361: l_rule_exists_flag := 'F';
1362: END LOOP;
1363: COMMIT;
1364: RAISE FND_API.G_EXC_ERROR;
1365: END IF;
1366:
1367:
1368: /*

Line 1407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1403: l_rule_exists_flag := 'F';
1404: END LOOP;
1405: COMMIT;
1406: -- Added for Bug 4757731
1407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1408:
1409: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1410: -- Added for Bug 4757731
1411: FOR csr_dis_rule_rec IN csr_dis_rule_list

Line 1422: RAISE FND_API.G_EXC_ERROR;

1418: l_rule_exists_flag := 'F';
1419: END LOOP;
1420: COMMIT;
1421: -- Added for Bug 4757731
1422: RAISE FND_API.G_EXC_ERROR;
1423: END IF;
1424:
1425: /*
1426: Step 6: Call the Test Publication API

Line 1462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1458: l_rule_exists_flag := 'F';
1459: END LOOP;
1460: COMMIT;
1461: -- Added for Bug 4757731
1462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1463:
1464: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1465: -- Added for Bug 4757731
1466: FOR csr_dis_rule_rec IN csr_dis_rule_list

Line 1477: RAISE FND_API.G_EXC_ERROR;

1473: l_rule_exists_flag := 'F';
1474: END LOOP;
1475: COMMIT;
1476: -- Added for Bug 4757731
1477: RAISE FND_API.G_EXC_ERROR;
1478: END IF;
1479:
1480: /*
1481: Step 7: Call the Production Publication API

Line 1518: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1514: l_rule_exists_flag := 'F';
1515: END LOOP;
1516: COMMIT;
1517: -- Added for Bug 4757731
1518: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1519:
1520: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1521: -- Added for Bug 4757731
1522: FOR csr_dis_rule_rec IN csr_dis_rule_list

Line 1533: RAISE FND_API.G_EXC_ERROR;

1529: l_rule_exists_flag := 'F';
1530: END LOOP;
1531: COMMIT;
1532: -- Added for Bug 4757731
1533: RAISE FND_API.G_EXC_ERROR;
1534: END IF;
1535:
1536:
1537:

Line 1566: WHEN FND_API.G_EXC_ERROR THEN

1562:
1563: END IF; -- req_data IS NULL
1564:
1565: EXCEPTION
1566: WHEN FND_API.G_EXC_ERROR THEN
1567: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1568: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1569: G_MODULE||l_api_name,
1570: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 1580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1576: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_ERROR);
1577: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);
1578: fnd_file.put_line(FND_FILE.LOG,' ');
1579:
1580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1581: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1582: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1583: G_MODULE||l_api_name,
1584: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 1718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1714: fnd_file.put_line(FND_FILE.LOG,' ');
1715:
1716: --- If any errors happen abort API
1717: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1719: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1720: RAISE FND_API.G_EXC_ERROR;
1721: END IF;
1722:

Line 1720: RAISE FND_API.G_EXC_ERROR;

1716: --- If any errors happen abort API
1717: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1719: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1720: RAISE FND_API.G_EXC_ERROR;
1721: END IF;
1722:
1723:
1724:

Line 1749: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1745: fnd_file.put_line(FND_FILE.LOG,' ');
1746:
1747: --- If any errors happen abort API
1748: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1749: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1750: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1751: RAISE FND_API.G_EXC_ERROR;
1752: END IF;
1753:

Line 1751: RAISE FND_API.G_EXC_ERROR;

1747: --- If any errors happen abort API
1748: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1749: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1750: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1751: RAISE FND_API.G_EXC_ERROR;
1752: END IF;
1753:
1754:
1755: /*

Line 1781: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1777: fnd_file.put_line(FND_FILE.LOG,' ');
1778:
1779: --- If any errors happen abort API
1780: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1781: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1782: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1783: RAISE FND_API.G_EXC_ERROR;
1784: END IF;
1785:

Line 1783: RAISE FND_API.G_EXC_ERROR;

1779: --- If any errors happen abort API
1780: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1781: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1782: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1783: RAISE FND_API.G_EXC_ERROR;
1784: END IF;
1785:
1786:
1787:

Line 1814: WHEN FND_API.G_EXC_ERROR THEN

1810: END IF;
1811:
1812:
1813: EXCEPTION
1814: WHEN FND_API.G_EXC_ERROR THEN
1815: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1816: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1817: G_MODULE||l_api_name,
1818: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 1828: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1824: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_ERROR);
1825: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);
1826: fnd_file.put_line(FND_FILE.LOG,' ');
1827:
1828: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1829: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1830: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1831: G_MODULE||l_api_name,
1832: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 1955: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1951: fnd_file.put_line(FND_FILE.LOG,' ');
1952:
1953: --- If any errors happen abort API
1954: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1955: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1956: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1957: RAISE FND_API.G_EXC_ERROR;
1958: END IF;
1959:

Line 1957: RAISE FND_API.G_EXC_ERROR;

1953: --- If any errors happen abort API
1954: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1955: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1956: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1957: RAISE FND_API.G_EXC_ERROR;
1958: END IF;
1959:
1960: -- Check If any rules had QA errors and abort
1961: IF l_qa_status <> 'S' THEN

Line 2003: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1999: fnd_file.put_line(FND_FILE.LOG,' ');
2000:
2001: --- If any errors happen abort API
2002: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2003: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2004: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2005: RAISE FND_API.G_EXC_ERROR;
2006: END IF;
2007:

Line 2005: RAISE FND_API.G_EXC_ERROR;

2001: --- If any errors happen abort API
2002: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2003: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2004: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2005: RAISE FND_API.G_EXC_ERROR;
2006: END IF;
2007:
2008:
2009: /*

Line 2037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2033: fnd_file.put_line(FND_FILE.LOG,' ');
2034:
2035: --- If any errors happen abort API
2036: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2038: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2039: RAISE FND_API.G_EXC_ERROR;
2040: END IF;
2041:

Line 2039: RAISE FND_API.G_EXC_ERROR;

2035: --- If any errors happen abort API
2036: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2038: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2039: RAISE FND_API.G_EXC_ERROR;
2040: END IF;
2041:
2042:
2043: /*

Line 2139: RAISE FND_API.G_EXC_ERROR;

2135: IF NVL(G_REQUEST_ID,0) = 0 THEN
2136: -- Could Not submit Conc Pgm
2137: fnd_message.set_name('OKC','OKC_XPRT_SUB_CZ_RUL_PGM');
2138: fnd_file.put_line(FND_FILE.LOG,'Could NOT submit CZ Concurrent Program');
2139: RAISE FND_API.G_EXC_ERROR;
2140: ELSE
2141: -- child submission successful, pause the parent program
2142: fnd_conc_global.set_req_globals
2143: ( conc_status => 'PAUSED',

Line 2195: RAISE FND_API.G_EXC_ERROR;

2191: -- error in CZ Concurrent Program
2192: fnd_file.put_line(FND_FILE.LOG, 'Error in CZ Rule Import Concurrent Program ');
2193: fnd_file.put_line(FND_FILE.LOG, 'Request Id :'||G_REQUEST_ID);
2194: fnd_file.put_line(FND_FILE.LOG, 'Run Id :'||G_RUN_ID);
2195: RAISE FND_API.G_EXC_ERROR;
2196: END IF;
2197:
2198:
2199: /*

Line 2226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2222: fnd_file.put_line(FND_FILE.LOG,' ');
2223:
2224: --- If any errors happen abort API
2225: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2227: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2228: RAISE FND_API.G_EXC_ERROR;
2229: END IF;
2230:

Line 2228: RAISE FND_API.G_EXC_ERROR;

2224: --- If any errors happen abort API
2225: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2227: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2228: RAISE FND_API.G_EXC_ERROR;
2229: END IF;
2230:
2231:
2232: /*

Line 2256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2252: fnd_file.put_line(FND_FILE.LOG,' ');
2253:
2254: --- If any errors happen abort API
2255: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2257: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2258: RAISE FND_API.G_EXC_ERROR;
2259: END IF;
2260:

Line 2258: RAISE FND_API.G_EXC_ERROR;

2254: --- If any errors happen abort API
2255: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2257: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2258: RAISE FND_API.G_EXC_ERROR;
2259: END IF;
2260:
2261:
2262: -- Standard call to get message count and if count is 1, get message info.

Line 2275: WHEN FND_API.G_EXC_ERROR THEN

2271:
2272: END IF; -- req_data IS NULL
2273:
2274: EXCEPTION
2275: WHEN FND_API.G_EXC_ERROR THEN
2276: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2277: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2278: G_MODULE||l_api_name,
2279: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 2289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2285: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_ERROR);
2286: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);
2287: fnd_file.put_line(FND_FILE.LOG,' ');
2288:
2289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2290: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2291: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2292: G_MODULE||l_api_name,
2293: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);