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

838: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
839: END IF;
840:
841: EXCEPTION
842: WHEN FND_API.G_EXC_ERROR THEN
843: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
844: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
845: G_MODULE||l_api_name,
846: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 852: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

848:
849: x_return_status := G_RET_STS_ERROR ;
850: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
851:
852: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
853: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
854: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
855: G_MODULE||l_api_name,
856: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 1035: WHEN FND_API.G_EXC_ERROR THEN

1031: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1032: END IF;
1033:
1034: EXCEPTION
1035: WHEN FND_API.G_EXC_ERROR THEN
1036: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1037: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1038: G_MODULE||l_api_name,
1039: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 1045: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1041:
1042: x_return_status := G_RET_STS_ERROR ;
1043: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1044:
1045: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1046: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1047: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1048: G_MODULE||l_api_name,
1049: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 1451: WHEN FND_API.G_EXC_ERROR THEN

1447: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1448: END IF;
1449:
1450: EXCEPTION
1451: WHEN FND_API.G_EXC_ERROR THEN
1452: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1453: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1454: G_MODULE||l_api_name,
1455: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 1461: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1457:
1458: x_return_status := G_RET_STS_ERROR ;
1459: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1460:
1461: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1462: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1463: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1464: G_MODULE||l_api_name,
1465: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 1935: WHEN FND_API.G_EXC_ERROR THEN

1931: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1932: END IF;
1933:
1934: EXCEPTION
1935: WHEN FND_API.G_EXC_ERROR THEN
1936: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1937: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1938: G_MODULE||l_api_name,
1939: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 1945: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1941:
1942: x_return_status := G_RET_STS_ERROR ;
1943: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1944:
1945: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1946: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1947: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1948: G_MODULE||l_api_name,
1949: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 2085: WHEN FND_API.G_EXC_ERROR THEN

2081: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2082: END IF;
2083:
2084: EXCEPTION
2085: WHEN FND_API.G_EXC_ERROR THEN
2086: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2087: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2088: G_MODULE||l_api_name,
2089: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 2095: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2091:
2092: x_return_status := G_RET_STS_ERROR ;
2093: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2094:
2095: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2096: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2097: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2098: G_MODULE||l_api_name,
2099: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 2223: WHEN FND_API.G_EXC_ERROR THEN

2219: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2220: END IF;
2221:
2222: EXCEPTION
2223: WHEN FND_API.G_EXC_ERROR THEN
2224: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2225: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2226: G_MODULE||l_api_name,
2227: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 2233: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2229:
2230: x_return_status := G_RET_STS_ERROR ;
2231: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2232:
2233: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2234: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2235: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2236: G_MODULE||l_api_name,
2237: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 2489: WHEN FND_API.G_EXC_ERROR THEN

2485: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2486: END IF;
2487:
2488: EXCEPTION
2489: WHEN FND_API.G_EXC_ERROR THEN
2490: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2491: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2492: G_MODULE||l_api_name,
2493: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 2499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2495:
2496: x_return_status := G_RET_STS_ERROR ;
2497: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2498:
2499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2500: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2501: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2502: G_MODULE||l_api_name,
2503: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 2646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2642:
2643:
2644: --- If any errors happen abort API
2645: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2647: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2648: RAISE FND_API.G_EXC_ERROR;
2649: END IF;
2650:

Line 2648: RAISE FND_API.G_EXC_ERROR;

2644: --- If any errors happen abort API
2645: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2647: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2648: RAISE FND_API.G_EXC_ERROR;
2649: END IF;
2650:
2651: check_draft_clauses
2652: (

Line 2675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2671: END IF;
2672:
2673: --- If any errors happen abort API
2674: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2676: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2677: RAISE FND_API.G_EXC_ERROR;
2678: END IF;
2679:

Line 2677: RAISE FND_API.G_EXC_ERROR;

2673: --- If any errors happen abort API
2674: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2676: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2677: RAISE FND_API.G_EXC_ERROR;
2678: END IF;
2679:
2680: select fnd_profile.value('OKC_DISABLE_CYCLIC_CHECK') into cyclic_check_flag from dual;
2681:

Line 2711: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2707: END IF;
2708:
2709: --- If any errors happen abort API
2710: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2711: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2712: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2713: RAISE FND_API.G_EXC_ERROR;
2714: END IF;
2715:

Line 2713: RAISE FND_API.G_EXC_ERROR;

2709: --- If any errors happen abort API
2710: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2711: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2712: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2713: RAISE FND_API.G_EXC_ERROR;
2714: END IF;
2715:
2716:
2717: check_invalid_questions

Line 2741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2743: RAISE FND_API.G_EXC_ERROR;

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

Line 2770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2766: END IF;
2767:
2768: --- If any errors happen abort API
2769: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2771: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2772: RAISE FND_API.G_EXC_ERROR;
2773: END IF;
2774:

Line 2772: RAISE FND_API.G_EXC_ERROR;

2768: --- If any errors happen abort API
2769: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2771: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2772: RAISE FND_API.G_EXC_ERROR;
2773: END IF;
2774:
2775: check_invalid_vset_var
2776: (

Line 2799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2795: END IF;
2796:
2797: --- If any errors happen abort API
2798: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2800: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2801: RAISE FND_API.G_EXC_ERROR;
2802: END IF;
2803:

Line 2801: RAISE FND_API.G_EXC_ERROR;

2797: --- If any errors happen abort API
2798: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2800: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2801: RAISE FND_API.G_EXC_ERROR;
2802: END IF;
2803:
2804: END IF; -- p_qa_mode is PUBLISH
2805:

Line 2837: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2833: END IF;
2834:
2835: --- If any errors happen abort API
2836: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2837: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2838: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2839: RAISE FND_API.G_EXC_ERROR;
2840: END IF;
2841:

Line 2839: RAISE FND_API.G_EXC_ERROR;

2835: --- If any errors happen abort API
2836: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2837: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2838: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2839: RAISE FND_API.G_EXC_ERROR;
2840: END IF;
2841:
2842:
2843: check_invalid_udv_procedure

Line 2867: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2863: END IF;
2864:
2865: --- If any errors happen abort API
2866: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2867: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2868: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2869: RAISE FND_API.G_EXC_ERROR;
2870: END IF;
2871:

Line 2869: RAISE FND_API.G_EXC_ERROR;

2865: --- If any errors happen abort API
2866: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2867: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2868: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2869: RAISE FND_API.G_EXC_ERROR;
2870: END IF;
2871:
2872: END IF; -- p_qa_mode IN ('PUBLISH','APPROVAL')
2873:

Line 2894: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2890: );
2891:
2892: --- If any errors happen abort API
2893: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2894: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2895: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2896: RAISE FND_API.G_EXC_ERROR;
2897: END IF;
2898:

Line 2896: RAISE FND_API.G_EXC_ERROR;

2892: --- If any errors happen abort API
2893: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2894: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2895: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2896: RAISE FND_API.G_EXC_ERROR;
2897: END IF;
2898:
2899: END IF; -- Rule QA was successful
2900:

Line 2914: WHEN FND_API.G_EXC_ERROR THEN

2910: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2911: END IF;
2912:
2913: EXCEPTION
2914: WHEN FND_API.G_EXC_ERROR THEN
2915: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2916: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2917: G_MODULE||l_api_name,
2918: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 2924: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2920:
2921: x_return_status := G_RET_STS_ERROR ;
2922: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2923:
2924: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2925: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2926: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2927: G_MODULE||l_api_name,
2928: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 3071: RAISE FND_API.G_EXC_ERROR;

3067:
3068: IF NVL(x_request_id,0) = 0 THEN
3069: -- Could Not submit Conc Pgm
3070: fnd_message.set_name('OKC','OKC_XPRT_SUB_CZ_RUL_PGM');
3071: RAISE FND_API.G_EXC_ERROR;
3072: END IF; -- x_request_id is 0
3073:
3074:
3075: -- end debug log

Line 3086: WHEN FND_API.G_EXC_ERROR THEN

3082: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
3083: END IF;
3084:
3085: EXCEPTION
3086: WHEN FND_API.G_EXC_ERROR THEN
3087: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3088: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
3089: G_MODULE||l_api_name,
3090: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 3096: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3092:
3093: x_return_status := G_RET_STS_ERROR ;
3094: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3095:
3096: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3097: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3098: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
3099: G_MODULE||l_api_name,
3100: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);