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 141: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

137: '100: p_template_id '||p_template_id);
138: END IF;
139:
140: -- Standard call to check for call compatibility.
141: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
143: END IF;
144:
145: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

138: END IF;
139:
140: -- Standard call to check for call compatibility.
141: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
143: END IF;
144:
145: -- Initialize message list if p_init_msg_list is set to TRUE.
146: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 146: IF FND_API.to_Boolean( p_init_msg_list ) THEN

142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
143: END IF;
144:
145: -- Initialize message list if p_init_msg_list is set to TRUE.
146: IF FND_API.to_Boolean( p_init_msg_list ) THEN
147: FND_MSG_PUB.initialize;
148: END IF;
149:
150: -- Initialize API return status to success

Line 151: x_return_status := FND_API.G_RET_STS_SUCCESS;

147: FND_MSG_PUB.initialize;
148: END IF;
149:
150: -- Initialize API return status to success
151: x_return_status := FND_API.G_RET_STS_SUCCESS;
152:
153: -- Get Template Details
154: OPEN csr_template_dtls;
155: FETCH csr_template_dtls INTO l_template_name,

Line 169: RAISE FND_API.G_EXC_ERROR;

165: G_MODULE||l_api_name,
166: '110: Invalid Template Id: '||p_template_id);
167: END IF;
168: FND_MESSAGE.set_name('OKC','OKC_XPRT_INVALID_TEMPLATE');
169: RAISE FND_API.G_EXC_ERROR;
170: END IF;
171: CLOSE csr_template_dtls;
172:
173: -- Put the Template Name in Concurrent Request Log File

Line 214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

210: END IF;
211:
212: --- If any errors happen abort API
213: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
215: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
216: RAISE FND_API.G_EXC_ERROR;
217: END IF;
218:

Line 216: RAISE FND_API.G_EXC_ERROR;

212: --- If any errors happen abort API
213: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
215: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
216: RAISE FND_API.G_EXC_ERROR;
217: END IF;
218:
219:
220: IF FND_API.To_Boolean( p_commit ) THEN

Line 220: IF FND_API.To_Boolean( p_commit ) THEN

216: RAISE FND_API.G_EXC_ERROR;
217: END IF;
218:
219:
220: IF FND_API.To_Boolean( p_commit ) THEN
221: COMMIT WORK;
222: END IF;
223:
224: -- Standard call to get message count and if count is 1, get message info.

Line 235: WHEN FND_API.G_EXC_ERROR THEN

231: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
232: END IF;
233:
234: EXCEPTION
235: WHEN FND_API.G_EXC_ERROR THEN
236: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
237: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
238: G_MODULE||l_api_name,
239: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

241:
242: x_return_status := G_RET_STS_ERROR ;
243: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
244:
245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
246: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
247: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
248: G_MODULE||l_api_name,
249: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 334: x_return_status := FND_API.G_RET_STS_SUCCESS;

330: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
331: END IF;
332:
333: -- Initialize API return status to success
334: x_return_status := FND_API.G_RET_STS_SUCCESS;
335:
336: -- Check if any rules in current request are Org Wide Rules
337: OPEN csr_org_rule_exists;
338: FETCH csr_org_rule_exists INTO l_org_rules_yn;

Line 380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

376: ) ;
377:
378: --- If any errors happen abort API
379: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
381: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
382: RAISE FND_API.G_EXC_ERROR;
383: END IF;
384:

Line 382: RAISE FND_API.G_EXC_ERROR;

378: --- If any errors happen abort API
379: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
381: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
382: RAISE FND_API.G_EXC_ERROR;
383: END IF;
384:
385: END LOOP; -- local
386: CLOSE csr_local_rules_templates;

Line 409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

405: ) ;
406:
407: --- If any errors happen abort API
408: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
410: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
411: RAISE FND_API.G_EXC_ERROR;
412: END IF;
413:

Line 411: RAISE FND_API.G_EXC_ERROR;

407: --- If any errors happen abort API
408: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
410: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
411: RAISE FND_API.G_EXC_ERROR;
412: END IF;
413:
414: END LOOP; -- Org Rules Templates
415: CLOSE csr_org_rules_templates;

Line 430: WHEN FND_API.G_EXC_ERROR THEN

426: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
427: END IF;
428:
429: EXCEPTION
430: WHEN FND_API.G_EXC_ERROR THEN
431: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
432: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
433: G_MODULE||l_api_name,
434: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 440: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

436:
437: x_return_status := G_RET_STS_ERROR ;
438: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
439:
440: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
441: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
442: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
443: G_MODULE||l_api_name,
444: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

630: fnd_file.put_line(FND_FILE.LOG,' ');
631:
632: --- If any errors happen abort API
633: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
635: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
636: RAISE FND_API.G_EXC_ERROR;
637: END IF;
638:

Line 636: RAISE FND_API.G_EXC_ERROR;

632: --- If any errors happen abort API
633: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
635: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
636: RAISE FND_API.G_EXC_ERROR;
637: END IF;
638:
639: -- Check If any rules had QA errors and abort
640: IF l_qa_status <> 'S' THEN

Line 710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

706: l_rule_exists_flag := 'F';
707: END LOOP;
708: COMMIT;
709: -- Added for Bug 4757731
710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
711:
712: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
713: -- Added for Bug 4757731
714: FOR csr_pub_rule_rec IN csr_pub_rule_list

Line 725: RAISE FND_API.G_EXC_ERROR;

721: l_rule_exists_flag := 'F';
722: END LOOP;
723: COMMIT;
724: -- Added for Bug 4757731
725: RAISE FND_API.G_EXC_ERROR;
726: END IF;
727:
728:
729: /*

Line 769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

765: l_rule_exists_flag := 'F';
766: END LOOP;
767: COMMIT;
768: -- Added for Bug 4757731
769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
770:
771: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
772: -- Added for Bug 4757731
773: FOR csr_pub_rule_rec IN csr_pub_rule_list

Line 784: RAISE FND_API.G_EXC_ERROR;

780: l_rule_exists_flag := 'F';
781: END LOOP;
782: COMMIT;
783: -- Added for Bug 4757731
784: RAISE FND_API.G_EXC_ERROR;
785: END IF;
786:
787: /*
788: Step 4: Import Template Model(s)

Line 823: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

819: l_rule_exists_flag := 'F';
820: END LOOP;
821: COMMIT;
822: -- Added for Bug 4757731
823: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
824:
825: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
826: -- Added for Bug 4757731
827: FOR csr_pub_rule_rec IN csr_pub_rule_list

Line 838: RAISE FND_API.G_EXC_ERROR;

834: l_rule_exists_flag := 'F';
835: END LOOP;
836: COMMIT;
837: -- Added for Bug 4757731
838: RAISE FND_API.G_EXC_ERROR;
839: END IF;
840:
841:
842: /*

Line 880: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

876: l_rule_exists_flag := 'F';
877: END LOOP;
878: COMMIT;
879: -- Added for Bug 4757731
880: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
881:
882: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
883: -- Added for Bug 4757731
884: FOR csr_pub_rule_rec IN csr_pub_rule_list

Line 895: RAISE FND_API.G_EXC_ERROR;

891: l_rule_exists_flag := 'F';
892: END LOOP;
893: COMMIT;
894: -- Added for Bug 4757731
895: RAISE FND_API.G_EXC_ERROR;
896: END IF;
897:
898: /*
899: Step 5.1: Count Rules to be imported

Line 949: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

945: l_rule_exists_flag := 'F';
946: END LOOP;
947: COMMIT;
948: -- Added for Bug 4757731
949: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
950:
951: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
952: -- Added for Bug 4757731
953: FOR csr_pub_rule_rec IN csr_pub_rule_list

Line 964: RAISE FND_API.G_EXC_ERROR;

960: l_rule_exists_flag := 'F';
961: END LOOP;
962: COMMIT;
963: -- Added for Bug 4757731
964: RAISE FND_API.G_EXC_ERROR;
965: END IF;
966:
967: fnd_file.put_line(FND_FILE.LOG,' ');
968: fnd_file.put_line(FND_FILE.LOG,'Rules has No expert template attached');

Line 1050: RAISE FND_API.G_EXC_ERROR;

1046: l_rule_exists_flag := 'F';
1047: END LOOP;
1048: COMMIT;
1049:
1050: RAISE FND_API.G_EXC_ERROR;
1051: ELSE
1052: -- child submission successful, pause the parent program
1053: fnd_conc_global.set_req_globals
1054: ( conc_status => 'PAUSED',

Line 1119: RAISE FND_API.G_EXC_ERROR;

1115: l_rule_exists_flag := 'F';
1116: END LOOP;
1117: COMMIT;
1118:
1119: RAISE FND_API.G_EXC_ERROR;
1120: END IF;
1121:
1122:
1123: /*

Line 1162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1158: l_rule_exists_flag := 'F';
1159: END LOOP;
1160: COMMIT;
1161: -- Added for Bug 4757731
1162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1163:
1164: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1165: -- Added for Bug 4757731
1166: FOR csr_pub_rule_rec IN csr_pub_rule_list

Line 1177: RAISE FND_API.G_EXC_ERROR;

1173: l_rule_exists_flag := 'F';
1174: END LOOP;
1175: COMMIT;
1176: -- Added for Bug 4757731
1177: RAISE FND_API.G_EXC_ERROR;
1178: END IF;
1179:
1180:
1181: /*

Line 1217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1213: l_rule_exists_flag := 'F';
1214: END LOOP;
1215: COMMIT;
1216: -- Added for Bug 4757731
1217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1218:
1219: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1220: -- Added for Bug 4757731
1221: FOR csr_pub_rule_rec IN csr_pub_rule_list

Line 1232: RAISE FND_API.G_EXC_ERROR;

1228: l_rule_exists_flag := 'F';
1229: END LOOP;
1230: COMMIT;
1231: -- Added for Bug 4757731
1232: RAISE FND_API.G_EXC_ERROR;
1233: END IF;
1234: /*
1235: Step 10: Call the Production Publication API
1236: */

Line 1272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1268: l_rule_exists_flag := 'F';
1269: END LOOP;
1270: COMMIT;
1271: -- Added for Bug 4757731
1272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1273:
1274: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1275: -- Added for Bug 4757731
1276: FOR csr_pub_rule_rec IN csr_pub_rule_list

Line 1287: RAISE FND_API.G_EXC_ERROR;

1283: l_rule_exists_flag := 'F';
1284: END LOOP;
1285: COMMIT;
1286: -- Added for Bug 4757731
1287: RAISE FND_API.G_EXC_ERROR;
1288: END IF;
1289:
1290: -- Standard call to get message count and if count is 1, get message info.
1291: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 1390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1392: RAISE FND_API.G_EXC_ERROR;

1388: --- If any errors happen abort API
1389: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1391: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1392: RAISE FND_API.G_EXC_ERROR;
1393: END IF;
1394:
1395: fnd_file.put_line(FND_FILE.LOG,'after');
1396:

Line 1508: WHEN FND_API.G_EXC_ERROR THEN

1504:
1505: END IF;
1506:
1507: EXCEPTION
1508: WHEN FND_API.G_EXC_ERROR THEN
1509: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1510: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1511: G_MODULE||l_api_name,
1512: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 1522: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1518: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_ERROR);
1519: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);
1520: fnd_file.put_line(FND_FILE.LOG,' ');
1521:
1522: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1523: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1524: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1525: G_MODULE||l_api_name,
1526: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 1719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1715: l_rule_exists_flag := 'F';
1716: END LOOP;
1717: COMMIT;
1718: -- Added for Bug 4757731
1719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1720:
1721: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1722: -- Added for Bug 4757731
1723: FOR csr_dis_rule_rec IN csr_dis_rule_list

Line 1734: RAISE FND_API.G_EXC_ERROR;

1730: l_rule_exists_flag := 'F';
1731: END LOOP;
1732: COMMIT;
1733: -- Added for Bug 4757731
1734: RAISE FND_API.G_EXC_ERROR;
1735: END IF;
1736:
1737:
1738: /*

Line 1776: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1772: l_rule_exists_flag := 'F';
1773: END LOOP;
1774: COMMIT;
1775: -- Added for Bug 4757731
1776: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1777:
1778: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1779: -- Added for Bug 4757731
1780: FOR csr_dis_rule_rec IN csr_dis_rule_list

Line 1791: RAISE FND_API.G_EXC_ERROR;

1787: l_rule_exists_flag := 'F';
1788: END LOOP;
1789: COMMIT;
1790: -- Added for Bug 4757731
1791: RAISE FND_API.G_EXC_ERROR;
1792: END IF;
1793: /*
1794: Step 3.1: Count Rules to be imported
1795: Check if there are any records in cz_imp_rules

Line 1844: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1840: l_rule_exists_flag := 'F';
1841: END LOOP;
1842: COMMIT;
1843: -- Added for Bug 4757731
1844: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1845:
1846: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1847: -- Added for Bug 4757731
1848: FOR csr_dis_rule_rec IN csr_dis_rule_list

Line 1859: RAISE FND_API.G_EXC_ERROR;

1855: l_rule_exists_flag := 'F';
1856: END LOOP;
1857: COMMIT;
1858: -- Added for Bug 4757731
1859: RAISE FND_API.G_EXC_ERROR;
1860: END IF;
1861:
1862: fnd_file.put_line(FND_FILE.LOG,' ');
1863: fnd_file.put_line(FND_FILE.LOG,'Rules has No expert template attached');

Line 1916: RAISE FND_API.G_EXC_ERROR;

1912: l_rule_exists_flag := 'F';
1913: END LOOP;
1914: COMMIT;
1915: -- Added for Bug 4757731
1916: RAISE FND_API.G_EXC_ERROR;
1917: ELSE
1918: -- child submission successful, pause the parent program
1919: fnd_conc_global.set_req_globals
1920: ( conc_status => 'PAUSED',

Line 1982: RAISE FND_API.G_EXC_ERROR;

1978: AND rule_id = csr_dis_rule_rec.rule_id;
1979: l_rule_exists_flag := 'F';
1980: END LOOP;
1981: COMMIT;
1982: RAISE FND_API.G_EXC_ERROR;
1983: END IF;
1984:
1985:
1986: /*

Line 2025: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2021: l_rule_exists_flag := 'F';
2022: END LOOP;
2023: COMMIT;
2024: -- Added for Bug 4757731
2025: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2026:
2027: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2028: -- Added for Bug 4757731
2029: FOR csr_dis_rule_rec IN csr_dis_rule_list

Line 2040: RAISE FND_API.G_EXC_ERROR;

2036: l_rule_exists_flag := 'F';
2037: END LOOP;
2038: COMMIT;
2039: -- Added for Bug 4757731
2040: RAISE FND_API.G_EXC_ERROR;
2041: END IF;
2042:
2043: /*
2044: Step 6: Call the Test Publication API

Line 2080: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2076: l_rule_exists_flag := 'F';
2077: END LOOP;
2078: COMMIT;
2079: -- Added for Bug 4757731
2080: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2081:
2082: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2083: -- Added for Bug 4757731
2084: FOR csr_dis_rule_rec IN csr_dis_rule_list

Line 2095: RAISE FND_API.G_EXC_ERROR;

2091: l_rule_exists_flag := 'F';
2092: END LOOP;
2093: COMMIT;
2094: -- Added for Bug 4757731
2095: RAISE FND_API.G_EXC_ERROR;
2096: END IF;
2097:
2098: /*
2099: Step 7: Call the Production Publication API

Line 2136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2132: l_rule_exists_flag := 'F';
2133: END LOOP;
2134: COMMIT;
2135: -- Added for Bug 4757731
2136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2137:
2138: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2139: -- Added for Bug 4757731
2140: FOR csr_dis_rule_rec IN csr_dis_rule_list

Line 2151: RAISE FND_API.G_EXC_ERROR;

2147: l_rule_exists_flag := 'F';
2148: END LOOP;
2149: COMMIT;
2150: -- Added for Bug 4757731
2151: RAISE FND_API.G_EXC_ERROR;
2152: END IF;
2153:
2154:
2155:

Line 2292: WHEN FND_API.G_EXC_ERROR THEN

2288:
2289: END IF;
2290:
2291: EXCEPTION
2292: WHEN FND_API.G_EXC_ERROR THEN
2293: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2294: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2295: G_MODULE||l_api_name,
2296: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 2306: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2302: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_ERROR);
2303: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);
2304: fnd_file.put_line(FND_FILE.LOG,' ');
2305:
2306: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2307: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2308: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2309: G_MODULE||l_api_name,
2310: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 2444: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2440: fnd_file.put_line(FND_FILE.LOG,' ');
2441:
2442: --- If any errors happen abort API
2443: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2444: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2445: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2446: RAISE FND_API.G_EXC_ERROR;
2447: END IF;
2448:

Line 2446: RAISE FND_API.G_EXC_ERROR;

2442: --- If any errors happen abort API
2443: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2444: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2445: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2446: RAISE FND_API.G_EXC_ERROR;
2447: END IF;
2448:
2449:
2450:

Line 2475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2471: fnd_file.put_line(FND_FILE.LOG,' ');
2472:
2473: --- If any errors happen abort API
2474: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2476: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2477: RAISE FND_API.G_EXC_ERROR;
2478: END IF;
2479:

Line 2477: RAISE FND_API.G_EXC_ERROR;

2473: --- If any errors happen abort API
2474: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2476: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2477: RAISE FND_API.G_EXC_ERROR;
2478: END IF;
2479:
2480:
2481: /*

Line 2507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2503: fnd_file.put_line(FND_FILE.LOG,' ');
2504:
2505: --- If any errors happen abort API
2506: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2508: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2509: RAISE FND_API.G_EXC_ERROR;
2510: END IF;
2511:

Line 2509: RAISE FND_API.G_EXC_ERROR;

2505: --- If any errors happen abort API
2506: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2508: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2509: RAISE FND_API.G_EXC_ERROR;
2510: END IF;
2511:
2512:
2513:

Line 2540: WHEN FND_API.G_EXC_ERROR THEN

2536: END IF;
2537:
2538:
2539: EXCEPTION
2540: WHEN FND_API.G_EXC_ERROR THEN
2541: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2542: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2543: G_MODULE||l_api_name,
2544: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 2554: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2550: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_ERROR);
2551: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);
2552: fnd_file.put_line(FND_FILE.LOG,' ');
2553:
2554: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2555: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2556: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2557: G_MODULE||l_api_name,
2558: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 2691: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2687: fnd_file.put_line(FND_FILE.LOG,' ');
2688:
2689: --- If any errors happen abort API
2690: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2691: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2692: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2693: RAISE FND_API.G_EXC_ERROR;
2694: END IF;
2695:

Line 2693: RAISE FND_API.G_EXC_ERROR;

2689: --- If any errors happen abort API
2690: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2691: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2692: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2693: RAISE FND_API.G_EXC_ERROR;
2694: END IF;
2695:
2696: -- Check If any rules had QA errors and abort
2697: IF l_qa_status <> 'S' THEN

Line 2739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2735: fnd_file.put_line(FND_FILE.LOG,' ');
2736:
2737: --- If any errors happen abort API
2738: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2740: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2741: RAISE FND_API.G_EXC_ERROR;
2742: END IF;
2743:

Line 2741: RAISE FND_API.G_EXC_ERROR;

2737: --- If any errors happen abort API
2738: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2740: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2741: RAISE FND_API.G_EXC_ERROR;
2742: END IF;
2743:
2744:
2745: /*

Line 2773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2769: fnd_file.put_line(FND_FILE.LOG,' ');
2770:
2771: --- If any errors happen abort API
2772: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2774: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2775: RAISE FND_API.G_EXC_ERROR;
2776: END IF;
2777:

Line 2775: RAISE FND_API.G_EXC_ERROR;

2771: --- If any errors happen abort API
2772: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2774: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2775: RAISE FND_API.G_EXC_ERROR;
2776: END IF;
2777:
2778:
2779: /*

Line 2875: RAISE FND_API.G_EXC_ERROR;

2871: IF NVL(G_REQUEST_ID,0) = 0 THEN
2872: -- Could Not submit Conc Pgm
2873: fnd_message.set_name('OKC','OKC_XPRT_SUB_CZ_RUL_PGM');
2874: fnd_file.put_line(FND_FILE.LOG,'Could NOT submit CZ Concurrent Program');
2875: RAISE FND_API.G_EXC_ERROR;
2876: ELSE
2877: -- child submission successful, pause the parent program
2878: fnd_conc_global.set_req_globals
2879: ( conc_status => 'PAUSED',

Line 2931: RAISE FND_API.G_EXC_ERROR;

2927: -- error in CZ Concurrent Program
2928: fnd_file.put_line(FND_FILE.LOG, 'Error in CZ Rule Import Concurrent Program ');
2929: fnd_file.put_line(FND_FILE.LOG, 'Request Id :'||G_REQUEST_ID);
2930: fnd_file.put_line(FND_FILE.LOG, 'Run Id :'||G_RUN_ID);
2931: RAISE FND_API.G_EXC_ERROR;
2932: END IF;
2933:
2934:
2935: /*

Line 2962: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2958: fnd_file.put_line(FND_FILE.LOG,' ');
2959:
2960: --- If any errors happen abort API
2961: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2962: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2963: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2964: RAISE FND_API.G_EXC_ERROR;
2965: END IF;
2966:

Line 2964: RAISE FND_API.G_EXC_ERROR;

2960: --- If any errors happen abort API
2961: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2962: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2963: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2964: RAISE FND_API.G_EXC_ERROR;
2965: END IF;
2966:
2967:
2968: /*

Line 2992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2988: fnd_file.put_line(FND_FILE.LOG,' ');
2989:
2990: --- If any errors happen abort API
2991: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2993: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2994: RAISE FND_API.G_EXC_ERROR;
2995: END IF;
2996:

Line 2994: RAISE FND_API.G_EXC_ERROR;

2990: --- If any errors happen abort API
2991: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2993: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2994: RAISE FND_API.G_EXC_ERROR;
2995: END IF;
2996:
2997:
2998: -- Standard call to get message count and if count is 1, get message info.

Line 3027: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3023: ) ;
3024:
3025: --- If any errors happen abort API
3026: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3027: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3028: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3029: RAISE FND_API.G_EXC_ERROR;
3030: END IF;
3031:

Line 3029: RAISE FND_API.G_EXC_ERROR;

3025: --- If any errors happen abort API
3026: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3027: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3028: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3029: RAISE FND_API.G_EXC_ERROR;
3030: END IF;
3031:
3032:
3033:

Line 3037: WHEN FND_API.G_EXC_ERROR THEN

3033:
3034: END IF;
3035:
3036: EXCEPTION
3037: WHEN FND_API.G_EXC_ERROR THEN
3038: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3039: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
3040: G_MODULE||l_api_name,
3041: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 3051: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3047: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_ERROR);
3048: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);
3049: fnd_file.put_line(FND_FILE.LOG,' ');
3050:
3051: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3052: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3053: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
3054: G_MODULE||l_api_name,
3055: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);