DBA Data[Home] [Help]

APPS.OKC_DOC_QA_LIST_GRP dependencies on OKC_API

Line 9: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;

5:
6: ---------------------------------------------------------------------------
7: -- GLOBAL MESSAGE CONSTANTS
8: ---------------------------------------------------------------------------
9: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
10: ---------------------------------------------------------------------------
11: -- GLOBAL VARIABLES
12: ---------------------------------------------------------------------------
13: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_DOC_QA_LIST_GRP';

Line 14: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

10: ---------------------------------------------------------------------------
11: -- GLOBAL VARIABLES
12: ---------------------------------------------------------------------------
13: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_DOC_QA_LIST_GRP';
14: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
15:
16: ------------------------------------------------------------------------------
17: -- GLOBAL CONSTANTS
18: ------------------------------------------------------------------------------

Line 106: okc_debug.log('300: Leaving Validate_Doc_Qa_List: OKC_API.G_EXCEPTION_ERROR Exception', 2);

102:
103: EXCEPTION
104: WHEN FND_API.G_EXC_ERROR THEN
105: IF (l_debug = 'Y') THEN
106: okc_debug.log('300: Leaving Validate_Doc_Qa_List: OKC_API.G_EXCEPTION_ERROR Exception', 2);
107: END IF;
108: ROLLBACK TO g_Validate_Doc_Qa_List_GRP;
109: x_return_status := G_RET_STS_ERROR ;
110: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 114: okc_debug.log('400: Leaving Validate_Doc_Qa_List: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

110: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
111:
112: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
113: IF (l_debug = 'Y') THEN
114: okc_debug.log('400: Leaving Validate_Doc_Qa_List: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
115: END IF;
116: ROLLBACK TO g_Validate_Doc_Qa_List_GRP;
117: x_return_status := G_RET_STS_UNEXP_ERROR ;
118: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 221: okc_debug.log('800: Leaving Insert_Doc_Qa_List: OKC_API.G_EXCEPTION_ERROR Exception', 2);

217:
218: EXCEPTION
219: WHEN FND_API.G_EXC_ERROR THEN
220: IF (l_debug = 'Y') THEN
221: okc_debug.log('800: Leaving Insert_Doc_Qa_List: OKC_API.G_EXCEPTION_ERROR Exception', 2);
222: END IF;
223: ROLLBACK TO g_Insert_Doc_Qa_List_GRP;
224: x_return_status := G_RET_STS_ERROR ;
225: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 229: okc_debug.log('900: Leaving Insert_Doc_Qa_List: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

225: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
226:
227: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
228: IF (l_debug = 'Y') THEN
229: okc_debug.log('900: Leaving Insert_Doc_Qa_List: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
230: END IF;
231: ROLLBACK TO g_Insert_Doc_Qa_List_GRP;
232: x_return_status := G_RET_STS_UNEXP_ERROR ;
233: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 311: okc_debug.log('1300: Leaving Lock_Doc_Qa_List: OKC_API.G_EXCEPTION_ERROR Exception', 2);

307:
308: EXCEPTION
309: WHEN FND_API.G_EXC_ERROR THEN
310: IF (l_debug = 'Y') THEN
311: okc_debug.log('1300: Leaving Lock_Doc_Qa_List: OKC_API.G_EXCEPTION_ERROR Exception', 2);
312: END IF;
313: ROLLBACK TO g_Lock_Doc_Qa_List_GRP;
314: x_return_status := G_RET_STS_ERROR ;
315: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 319: okc_debug.log('1400: Leaving Lock_Doc_Qa_List: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

315: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
316:
317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
318: IF (l_debug = 'Y') THEN
319: okc_debug.log('1400: Leaving Lock_Doc_Qa_List: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
320: END IF;
321: ROLLBACK TO g_Lock_Doc_Qa_List_GRP;
322: x_return_status := G_RET_STS_UNEXP_ERROR ;
323: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 419: okc_debug.log('1900: Leaving Update_Doc_Qa_List: OKC_API.G_EXCEPTION_ERROR Exception', 2);

415:
416: EXCEPTION
417: WHEN FND_API.G_EXC_ERROR THEN
418: IF (l_debug = 'Y') THEN
419: okc_debug.log('1900: Leaving Update_Doc_Qa_List: OKC_API.G_EXCEPTION_ERROR Exception', 2);
420: END IF;
421: ROLLBACK TO g_Update_Doc_Qa_List_GRP;
422: x_return_status := G_RET_STS_ERROR ;
423: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 427: okc_debug.log('2000: Leaving Update_Doc_Qa_List: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

423: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
424:
425: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
426: IF (l_debug = 'Y') THEN
427: okc_debug.log('2000: Leaving Update_Doc_Qa_List: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
428: END IF;
429: ROLLBACK TO g_Update_Doc_Qa_List_GRP;
430: x_return_status := G_RET_STS_UNEXP_ERROR ;
431: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 515: okc_debug.log('2400: Leaving Delete_Doc_Qa_List: OKC_API.G_EXCEPTION_ERROR Exception', 2);

511:
512: EXCEPTION
513: WHEN FND_API.G_EXC_ERROR THEN
514: IF (l_debug = 'Y') THEN
515: okc_debug.log('2400: Leaving Delete_Doc_Qa_List: OKC_API.G_EXCEPTION_ERROR Exception', 2);
516: END IF;
517: ROLLBACK TO g_Delete_Doc_Qa_List_GRP;
518: x_return_status := G_RET_STS_ERROR ;
519: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 523: okc_debug.log('2500: Leaving Delete_Doc_Qa_List: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

519: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
520:
521: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
522: IF (l_debug = 'Y') THEN
523: okc_debug.log('2500: Leaving Delete_Doc_Qa_List: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
524: END IF;
525: ROLLBACK TO g_Delete_Doc_Qa_List_GRP;
526: x_return_status := G_RET_STS_UNEXP_ERROR ;
527: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );