DBA Data[Home] [Help]

APPS.OKC_XPRT_QA_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 783: WHEN FND_API.G_EXC_ERROR THEN

779: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
780: END IF;
781:
782: EXCEPTION
783: WHEN FND_API.G_EXC_ERROR THEN
784: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
785: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
786: G_MODULE||l_api_name,
787: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 793: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

789:
790: x_return_status := G_RET_STS_ERROR ;
791: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
792:
793: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
794: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
795: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
796: G_MODULE||l_api_name,
797: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 964: WHEN FND_API.G_EXC_ERROR THEN

960: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
961: END IF;
962:
963: EXCEPTION
964: WHEN FND_API.G_EXC_ERROR THEN
965: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
966: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
967: G_MODULE||l_api_name,
968: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 974: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

970:
971: x_return_status := G_RET_STS_ERROR ;
972: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
973:
974: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
975: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
976: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
977: G_MODULE||l_api_name,
978: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 1380: WHEN FND_API.G_EXC_ERROR THEN

1376: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1377: END IF;
1378:
1379: EXCEPTION
1380: WHEN FND_API.G_EXC_ERROR THEN
1381: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1382: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1383: G_MODULE||l_api_name,
1384: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 1390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1386:
1387: x_return_status := G_RET_STS_ERROR ;
1388: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1389:
1390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1391: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1392: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1393: G_MODULE||l_api_name,
1394: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 1864: WHEN FND_API.G_EXC_ERROR THEN

1860: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1861: END IF;
1862:
1863: EXCEPTION
1864: WHEN FND_API.G_EXC_ERROR THEN
1865: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1866: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1867: G_MODULE||l_api_name,
1868: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 1874: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1870:
1871: x_return_status := G_RET_STS_ERROR ;
1872: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1873:
1874: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1875: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1876: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1877: G_MODULE||l_api_name,
1878: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 2014: WHEN FND_API.G_EXC_ERROR THEN

2010: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2011: END IF;
2012:
2013: EXCEPTION
2014: WHEN FND_API.G_EXC_ERROR THEN
2015: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2016: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2017: G_MODULE||l_api_name,
2018: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 2024: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2020:
2021: x_return_status := G_RET_STS_ERROR ;
2022: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2023:
2024: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2025: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2026: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2027: G_MODULE||l_api_name,
2028: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 2152: WHEN FND_API.G_EXC_ERROR THEN

2148: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2149: END IF;
2150:
2151: EXCEPTION
2152: WHEN FND_API.G_EXC_ERROR THEN
2153: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2154: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2155: G_MODULE||l_api_name,
2156: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 2162: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2158:
2159: x_return_status := G_RET_STS_ERROR ;
2160: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2161:
2162: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2163: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2164: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2165: G_MODULE||l_api_name,
2166: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 2418: WHEN FND_API.G_EXC_ERROR THEN

2414: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2415: END IF;
2416:
2417: EXCEPTION
2418: WHEN FND_API.G_EXC_ERROR THEN
2419: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2420: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2421: G_MODULE||l_api_name,
2422: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 2428: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2424:
2425: x_return_status := G_RET_STS_ERROR ;
2426: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2427:
2428: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2429: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2430: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2431: G_MODULE||l_api_name,
2432: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 2574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2570:
2571:
2572: --- If any errors happen abort API
2573: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2575: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2576: RAISE FND_API.G_EXC_ERROR;
2577: END IF;
2578:

Line 2576: RAISE FND_API.G_EXC_ERROR;

2572: --- If any errors happen abort API
2573: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2575: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2576: RAISE FND_API.G_EXC_ERROR;
2577: END IF;
2578:
2579: check_draft_clauses
2580: (

Line 2603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2599: END IF;
2600:
2601: --- If any errors happen abort API
2602: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2604: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2605: RAISE FND_API.G_EXC_ERROR;
2606: END IF;
2607:

Line 2605: RAISE FND_API.G_EXC_ERROR;

2601: --- If any errors happen abort API
2602: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2604: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2605: RAISE FND_API.G_EXC_ERROR;
2606: END IF;
2607:
2608:
2609: check_circular_dependency

Line 2634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2630: END IF;
2631:
2632: --- If any errors happen abort API
2633: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2635: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2636: RAISE FND_API.G_EXC_ERROR;
2637: END IF;
2638:

Line 2636: RAISE FND_API.G_EXC_ERROR;

2632: --- If any errors happen abort API
2633: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2635: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2636: RAISE FND_API.G_EXC_ERROR;
2637: END IF;
2638:
2639:
2640: check_invalid_questions

Line 2664: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2660: END IF;
2661:
2662: --- If any errors happen abort API
2663: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2664: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2665: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2666: RAISE FND_API.G_EXC_ERROR;
2667: END IF;
2668:

Line 2666: RAISE FND_API.G_EXC_ERROR;

2662: --- If any errors happen abort API
2663: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2664: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2665: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2666: RAISE FND_API.G_EXC_ERROR;
2667: END IF;
2668:
2669: check_rule_templates
2670: (

Line 2693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2689: END IF;
2690:
2691: --- If any errors happen abort API
2692: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2694: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2695: RAISE FND_API.G_EXC_ERROR;
2696: END IF;
2697:

Line 2695: RAISE FND_API.G_EXC_ERROR;

2691: --- If any errors happen abort API
2692: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2694: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2695: RAISE FND_API.G_EXC_ERROR;
2696: END IF;
2697:
2698: check_invalid_vset_var
2699: (

Line 2722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2718: END IF;
2719:
2720: --- If any errors happen abort API
2721: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2723: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2724: RAISE FND_API.G_EXC_ERROR;
2725: END IF;
2726:

Line 2724: RAISE FND_API.G_EXC_ERROR;

2720: --- If any errors happen abort API
2721: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2723: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2724: RAISE FND_API.G_EXC_ERROR;
2725: END IF;
2726:
2727: END IF; -- p_qa_mode is PUBLISH
2728:

Line 2760: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2756: END IF;
2757:
2758: --- If any errors happen abort API
2759: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2760: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2761: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2762: RAISE FND_API.G_EXC_ERROR;
2763: END IF;
2764:

Line 2762: RAISE FND_API.G_EXC_ERROR;

2758: --- If any errors happen abort API
2759: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2760: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2761: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2762: RAISE FND_API.G_EXC_ERROR;
2763: END IF;
2764:
2765:
2766: check_invalid_udv_procedure

Line 2790: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2786: END IF;
2787:
2788: --- If any errors happen abort API
2789: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2790: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2791: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2792: RAISE FND_API.G_EXC_ERROR;
2793: END IF;
2794:

Line 2792: RAISE FND_API.G_EXC_ERROR;

2788: --- If any errors happen abort API
2789: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2790: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2791: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2792: RAISE FND_API.G_EXC_ERROR;
2793: END IF;
2794:
2795: END IF; -- p_qa_mode IN ('PUBLISH','APPROVAL')
2796:

Line 2817: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2813: );
2814:
2815: --- If any errors happen abort API
2816: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2817: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2818: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2819: RAISE FND_API.G_EXC_ERROR;
2820: END IF;
2821:

Line 2819: RAISE FND_API.G_EXC_ERROR;

2815: --- If any errors happen abort API
2816: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2817: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2818: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2819: RAISE FND_API.G_EXC_ERROR;
2820: END IF;
2821:
2822: END IF; -- Rule QA was successful
2823:

Line 2837: WHEN FND_API.G_EXC_ERROR THEN

2833: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2834: END IF;
2835:
2836: EXCEPTION
2837: WHEN FND_API.G_EXC_ERROR THEN
2838: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2839: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2840: G_MODULE||l_api_name,
2841: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 2847: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2843:
2844: x_return_status := G_RET_STS_ERROR ;
2845: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2846:
2847: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2848: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2849: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2850: G_MODULE||l_api_name,
2851: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 2984: RAISE FND_API.G_EXC_ERROR;

2980:
2981: IF NVL(x_request_id,0) = 0 THEN
2982: -- Could Not submit Conc Pgm
2983: fnd_message.set_name('OKC','OKC_XPRT_SUB_CZ_RUL_PGM');
2984: RAISE FND_API.G_EXC_ERROR;
2985: END IF; -- x_request_id is 0
2986:
2987:
2988: -- end debug log

Line 2999: WHEN FND_API.G_EXC_ERROR THEN

2995: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2996: END IF;
2997:
2998: EXCEPTION
2999: WHEN FND_API.G_EXC_ERROR THEN
3000: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3001: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
3002: G_MODULE||l_api_name,
3003: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 3009: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3005:
3006: x_return_status := G_RET_STS_ERROR ;
3007: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3008:
3009: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3010: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3011: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
3012: G_MODULE||l_api_name,
3013: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);