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

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

10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_MODULE CONSTANT VARCHAR2(250) := 'okc.plsql.'||g_pkg_name||'.';
12: G_APPLICATION_ID CONSTANT NUMBER :=510; -- OKC Application
13:
14: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
15: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
16:
17: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
18: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

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

11: G_MODULE CONSTANT VARCHAR2(250) := 'okc.plsql.'||g_pkg_name||'.';
12: G_APPLICATION_ID CONSTANT NUMBER :=510; -- OKC Application
13:
14: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
15: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
16:
17: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
18: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
19: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

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

13:
14: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
15: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
16:
17: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
18: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
19: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
20:
21: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';

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

14: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
15: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
16:
17: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
18: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
19: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
20:
21: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
22: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';

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

15: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
16:
17: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
18: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
19: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
20:
21: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
22: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
23: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';

Line 37: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

33: ---------------------------------------------------
34:
35: PROCEDURE get_system_variables (
36: p_api_version IN NUMBER,
37: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
38: x_return_status OUT NOCOPY VARCHAR2,
39: x_msg_data OUT NOCOPY VARCHAR2,
40: x_msg_count OUT NOCOPY NUMBER,
41: p_doc_type IN VARCHAR2,

Line 43: p_only_doc_variables IN VARCHAR2 := FND_API.G_TRUE,

39: x_msg_data OUT NOCOPY VARCHAR2,
40: x_msg_count OUT NOCOPY NUMBER,
41: p_doc_type IN VARCHAR2,
42: p_doc_id IN NUMBER,
43: p_only_doc_variables IN VARCHAR2 := FND_API.G_TRUE,
44: x_sys_var_value_tbl OUT NOCOPY var_value_tbl_type
45: )
46: IS
47: l_api_name VARCHAR2(30) := 'get_system_variables';

Line 78: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

74: x_sys_var_value_tbl => l_sys_var_value_tbl);
75:
76: --- If any errors happen abort API
77: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
78: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
79: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
80: RAISE FND_API.G_EXC_ERROR;
81: END IF;
82:

Line 80: RAISE FND_API.G_EXC_ERROR;

76: --- If any errors happen abort API
77: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
78: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
79: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
80: RAISE FND_API.G_EXC_ERROR;
81: END IF;
82:
83: -- Log all Variable values in the Pl/sql table
84:

Line 142: WHEN FND_API.G_EXC_ERROR THEN

138:
139:
140: EXCEPTION
141:
142: WHEN FND_API.G_EXC_ERROR THEN
143: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
144: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
145: G_MODULE||l_api_name,
146: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 152: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

148:
149: x_return_status := G_RET_STS_ERROR ;
150: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
151:
152: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
153: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
154: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
155: G_MODULE||l_api_name,
156: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 249: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

245: ---------------------------------------------------
246:
247: PROCEDURE get_line_system_variables (
248: p_api_version IN NUMBER,
249: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
250: p_doc_type IN VARCHAR2,
251: p_doc_id IN NUMBER,
252: p_org_id IN NUMBER,
253: x_return_status OUT NOCOPY VARCHAR2,

Line 293: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

289: --null;
290:
291: --- If any errors happen abort API
292: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
293: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
294: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
295: RAISE FND_API.G_EXC_ERROR;
296: END IF;
297: END IF;

Line 295: RAISE FND_API.G_EXC_ERROR;

291: --- If any errors happen abort API
292: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
293: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
294: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
295: RAISE FND_API.G_EXC_ERROR;
296: END IF;
297: END IF;
298:
299: IF (p_doc_type = 'QUOTE')

Line 316: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

312:
313: --null;
314: --- If any errors happen abort API
315: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
316: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
317: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
318: RAISE FND_API.G_EXC_ERROR;
319: END IF;
320: END IF;

Line 318: RAISE FND_API.G_EXC_ERROR;

314: --- If any errors happen abort API
315: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
316: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
317: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
318: RAISE FND_API.G_EXC_ERROR;
319: END IF;
320: END IF;
321:
322: -- Log all Variable values in the Pl/sql table

Line 357: WHEN FND_API.G_EXC_ERROR THEN

353:
354: EXCEPTION
355:
356:
357: WHEN FND_API.G_EXC_ERROR THEN
358: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
359: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
360: G_MODULE||l_api_name,
361: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 367: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

363:
364: x_return_status := G_RET_STS_ERROR ;
365: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
366:
367: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
368: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
369: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
370: G_MODULE||l_api_name,
371: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 398: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

394: ---------------------------------------------------
395:
396: PROCEDURE get_user_defined_variables (
397: p_api_version IN NUMBER,
398: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
399: p_doc_type IN VARCHAR2,
400: p_doc_id IN NUMBER,
401: p_org_id IN NUMBER,
402: p_intent IN VARCHAR2,

Line 518: WHEN FND_API.G_EXC_ERROR THEN

514:
515: EXCEPTION
516:
517:
518: WHEN FND_API.G_EXC_ERROR THEN
519: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
520: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
521: G_MODULE||l_api_name,
522: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 528: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

524:
525: x_return_status := G_RET_STS_ERROR ;
526: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
527:
528: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
529: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
530: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
531: G_MODULE||l_api_name,
532: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 559: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

555: ---------------------------------------------------
556:
557: PROCEDURE get_constant_values (
558: p_api_version IN NUMBER,
559: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
560: p_intent IN VARCHAR2,
561: x_return_status OUT NOCOPY VARCHAR2,
562: x_msg_data OUT NOCOPY VARCHAR2,
563: x_msg_count OUT NOCOPY NUMBER,

Line 624: WHEN FND_API.G_EXC_ERROR THEN

620: END IF;
621:
622: EXCEPTION
623:
624: WHEN FND_API.G_EXC_ERROR THEN
625: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
626: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
627: G_MODULE||l_api_name,
628: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 634: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 665: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

661: ---------------------------------------------------
662:
663: PROCEDURE get_udv_with_procedures (
664: p_api_version IN NUMBER,
665: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
666: p_doc_type IN VARCHAR2,
667: p_doc_id IN NUMBER,
668: p_org_id IN NUMBER,
669: p_intent IN VARCHAR2,

Line 882: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 884: RAISE FND_API.G_EXC_ERROR;

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

Line 932: WHEN FND_API.G_EXC_ERROR THEN

928:
929: EXCEPTION
930:
931:
932: WHEN FND_API.G_EXC_ERROR THEN
933: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
934: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
935: G_MODULE||l_api_name,
936: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 942: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

938:
939: x_return_status := G_RET_STS_ERROR ;
940: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
941:
942: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
943: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
944: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
945: G_MODULE||l_api_name,
946: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 974: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

970: ---------------------------------------------------
971:
972: PROCEDURE get_document_values (
973: p_api_version IN NUMBER,
974: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
975: p_doc_type IN VARCHAR2,
976: p_doc_id IN NUMBER,
977: x_return_status OUT NOCOPY VARCHAR2,
978: x_msg_data OUT NOCOPY VARCHAR2,

Line 1061: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1057:
1058: OPEN csr_get_intent(p_doc_type);
1059: FETCH csr_get_intent INTO l_intent;
1060: IF (csr_get_intent%NOTFOUND) THEN
1061: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1062: END IF;
1063: CLOSE csr_get_intent;
1064: x_intent := l_intent;
1065:

Line 1069: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1065:
1066: OPEN csr_get_org_id(p_doc_type, p_doc_id);
1067: FETCH csr_get_org_id INTO l_org_id;
1068: IF (csr_get_org_id%NOTFOUND) THEN
1069: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1070: END IF;
1071: CLOSE csr_get_org_id;
1072: x_org_id := l_org_id;
1073:

Line 1088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1084: x_sys_var_value_tbl => l_sys_var_value_tbl);
1085:
1086: --- If any errors happen abort API
1087: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1089: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1090: RAISE FND_API.G_EXC_ERROR;
1091: END IF;
1092:

Line 1090: RAISE FND_API.G_EXC_ERROR;

1086: --- If any errors happen abort API
1087: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1089: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1090: RAISE FND_API.G_EXC_ERROR;
1091: END IF;
1092:
1093: -- start debug log
1094: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1129: x_line_variables_count => x_line_variables_count);
1130:
1131: --- If any errors happen abort API
1132: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1134: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1135: RAISE FND_API.G_EXC_ERROR;
1136: END IF;
1137:

Line 1135: RAISE FND_API.G_EXC_ERROR;

1131: --- If any errors happen abort API
1132: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1134: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1135: RAISE FND_API.G_EXC_ERROR;
1136: END IF;
1137:
1138: -- start debug log
1139: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1155: x_item_tbl => l_item_tbl);
1156:
1157: --- If any errors happen abort API
1158: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1160: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1161: RAISE FND_API.G_EXC_ERROR;
1162: END IF;
1163:

Line 1161: RAISE FND_API.G_EXC_ERROR;

1157: --- If any errors happen abort API
1158: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1160: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1161: RAISE FND_API.G_EXC_ERROR;
1162: END IF;
1163:
1164: -- Add Item/Item Category to header level variables
1165: var_tbl_cnt := l_sys_var_value_tbl.COUNT + 1;

Line 1246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1242: x_udf_var_value_tbl => l_udf_var_value_tbl);
1243:
1244: --- If any errors happen abort API
1245: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1247: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1248: RAISE FND_API.G_EXC_ERROR;
1249: END IF;
1250:

Line 1248: RAISE FND_API.G_EXC_ERROR;

1244: --- If any errors happen abort API
1245: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1247: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1248: RAISE FND_API.G_EXC_ERROR;
1249: END IF;
1250:
1251: -- start debug log
1252: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1269: x_udf_var_value_tbl => l_udf_var_with_proc_value_tbl);
1270:
1271: --- If any errors happen abort API
1272: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1274: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1275: RAISE FND_API.G_EXC_ERROR;
1276: END IF;
1277:

Line 1275: RAISE FND_API.G_EXC_ERROR;

1271: --- If any errors happen abort API
1272: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1274: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1275: RAISE FND_API.G_EXC_ERROR;
1276: END IF;
1277:
1278: -- start debug log
1279: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1296: x_udf_var_value_tbl => l_clm_udf_tbl);
1297:
1298: --- If any errors happen abort API
1299: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1301: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1302: RAISE FND_API.G_EXC_ERROR;
1303: END IF;
1304:

Line 1302: RAISE FND_API.G_EXC_ERROR;

1298: --- If any errors happen abort API
1299: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1301: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1302: RAISE FND_API.G_EXC_ERROR;
1303: END IF;
1304:
1305: -- start debug log
1306: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1320: x_constant_tbl => l_constant_tbl);
1321:
1322: --- If any errors happen abort API
1323: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1325: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1326: RAISE FND_API.G_EXC_ERROR;
1327: END IF;
1328:

Line 1326: RAISE FND_API.G_EXC_ERROR;

1322: --- If any errors happen abort API
1323: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1325: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1326: RAISE FND_API.G_EXC_ERROR;
1327: END IF;
1328:
1329: -- start debug log
1330: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1477: WHEN FND_API.G_EXC_ERROR THEN

1473:
1474: EXCEPTION
1475:
1476:
1477: WHEN FND_API.G_EXC_ERROR THEN
1478: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1479: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1480: G_MODULE||l_api_name,
1481: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 1487: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1483:
1484: x_return_status := G_RET_STS_ERROR ;
1485: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1486:
1487: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1488: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1489: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1490: G_MODULE||l_api_name,
1491: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);