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.CSL_CSP_REQ_HEADERS_ACC_PKG dependencies on FND_API

Line 292: x_return_status := FND_API.G_RET_STS_SUCCESS;

288: ( x_return_status OUT NOCOPY varchar2
289: )
290: IS
291: BEGIN
292: x_return_status := FND_API.G_RET_STS_SUCCESS;
293: END PRE_INSERT_REQ_HEADER;
294:
295: /*** Called after requirement Insert ***/
296: PROCEDURE POST_INSERT_REQ_HEADER( x_return_status OUT NOCOPY varchar2 )

Line 303: x_return_status := FND_API.G_RET_STS_SUCCESS;

299: l_enabled_flag VARCHAR2(30);
300: BEGIN
301: l_enabled_flag := JTM_PROFILE_UTL_PKG.GET_ENABLE_FLAG_AT_RESP( P_APP_SHORT_NAME => 'CSL' );
302: IF l_enabled_flag <> 'Y' THEN
303: x_return_status := FND_API.G_RET_STS_SUCCESS;
304: RETURN;
305: END IF;
306: /*** get debug level ***/
307: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

Line 331: x_return_status := FND_API.G_RET_STS_SUCCESS;

327: , 'Leaving POST_INSERT hook'
328: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
329: END IF;
330:
331: x_return_status := FND_API.G_RET_STS_SUCCESS;
332: RETURN;
333:
334: EXCEPTION WHEN OTHERS THEN
335: /*** hook failed -> log error ***/

Line 344: -- x_return_status := FND_API.G_RET_STS_ERROR;

340: , 'Caught exception in POST_INSERT hook:' || fnd_global.local_chr(10) || sqlerrm
341: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
342: END IF;
343: fnd_msg_pub.Add_Exc_Msg('CSL_CSP_REQ_HEADERS_ACC_PKG','POST_INSERT_REQ_HEADER',sqlerrm);
344: -- x_return_status := FND_API.G_RET_STS_ERROR;
345: x_return_status := FND_API.G_RET_STS_SUCCESS;
346: END POST_INSERT_REQ_HEADER;
347:
348: /* Called before requirement Update */

Line 345: x_return_status := FND_API.G_RET_STS_SUCCESS;

341: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
342: END IF;
343: fnd_msg_pub.Add_Exc_Msg('CSL_CSP_REQ_HEADERS_ACC_PKG','POST_INSERT_REQ_HEADER',sqlerrm);
344: -- x_return_status := FND_API.G_RET_STS_ERROR;
345: x_return_status := FND_API.G_RET_STS_SUCCESS;
346: END POST_INSERT_REQ_HEADER;
347:
348: /* Called before requirement Update */
349: PROCEDURE PRE_UPDATE_REQ_HEADER

Line 354: x_return_status := FND_API.G_RET_STS_SUCCESS;

350: ( x_return_status OUT NOCOPY varchar2
351: )
352: IS
353: BEGIN
354: x_return_status := FND_API.G_RET_STS_SUCCESS;
355:
356: EXCEPTION WHEN OTHERS THEN
357: /*** hook failed -> log error ***/
358: fnd_msg_pub.Add_Exc_Msg('CSL_CSP_REQ_HEADERS_ACC_PKG','PRE_UPDATE_REQ_HEADER',sqlerrm);

Line 359: -- x_return_status := FND_API.G_RET_STS_ERROR;

355:
356: EXCEPTION WHEN OTHERS THEN
357: /*** hook failed -> log error ***/
358: fnd_msg_pub.Add_Exc_Msg('CSL_CSP_REQ_HEADERS_ACC_PKG','PRE_UPDATE_REQ_HEADER',sqlerrm);
359: -- x_return_status := FND_API.G_RET_STS_ERROR;
360: x_return_status := FND_API.G_RET_STS_SUCCESS;
361: END PRE_UPDATE_REQ_HEADER;
362:
363: /* Called after requirement Update */

Line 360: x_return_status := FND_API.G_RET_STS_SUCCESS;

356: EXCEPTION WHEN OTHERS THEN
357: /*** hook failed -> log error ***/
358: fnd_msg_pub.Add_Exc_Msg('CSL_CSP_REQ_HEADERS_ACC_PKG','PRE_UPDATE_REQ_HEADER',sqlerrm);
359: -- x_return_status := FND_API.G_RET_STS_ERROR;
360: x_return_status := FND_API.G_RET_STS_SUCCESS;
361: END PRE_UPDATE_REQ_HEADER;
362:
363: /* Called after requirement Update */
364: PROCEDURE POST_UPDATE_REQ_HEADER( x_return_status OUT NOCOPY varchar2 )

Line 371: x_return_status := FND_API.G_RET_STS_SUCCESS;

367: l_enabled_flag VARCHAR2(30);
368: BEGIN
369: l_enabled_flag := JTM_PROFILE_UTL_PKG.GET_ENABLE_FLAG_AT_RESP( P_APP_SHORT_NAME => 'CSL' );
370: IF l_enabled_flag <> 'Y' THEN
371: x_return_status := FND_API.G_RET_STS_SUCCESS;
372: RETURN;
373: END IF;
374: /*** get debug level ***/
375: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

Line 399: x_return_status := FND_API.G_RET_STS_SUCCESS;

395: , 'Leaving POST_UPDATE hook'
396: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
397: END IF;
398:
399: x_return_status := FND_API.G_RET_STS_SUCCESS;
400: EXCEPTION WHEN OTHERS THEN
401: /*** hook failed -> log error ***/
402: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
403: jtm_message_log_pkg.Log_Msg

Line 410: -- x_return_status := FND_API.G_RET_STS_ERROR;

406: , 'Caught exception in POST_UPDATE hook:' || fnd_global.local_chr(10) || sqlerrm
407: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
408: END IF;
409: fnd_msg_pub.Add_Exc_Msg('CSL_CSP_REQ_HEADERS_ACC_PKG','POST_UPDATE_REQ_HEADER',sqlerrm);
410: -- x_return_status := FND_API.G_RET_STS_ERROR;
411: x_return_status := FND_API.G_RET_STS_SUCCESS;
412: END POST_UPDATE_REQ_HEADER;
413:
414: /* Called before req header Delete */

Line 411: x_return_status := FND_API.G_RET_STS_SUCCESS;

407: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
408: END IF;
409: fnd_msg_pub.Add_Exc_Msg('CSL_CSP_REQ_HEADERS_ACC_PKG','POST_UPDATE_REQ_HEADER',sqlerrm);
410: -- x_return_status := FND_API.G_RET_STS_ERROR;
411: x_return_status := FND_API.G_RET_STS_SUCCESS;
412: END POST_UPDATE_REQ_HEADER;
413:
414: /* Called before req header Delete */
415: PROCEDURE PRE_DELETE_REQ_HEADER

Line 420: x_return_status := FND_API.G_RET_STS_SUCCESS;

416: ( x_return_status OUT NOCOPY varchar2
417: )
418: IS
419: BEGIN
420: x_return_status := FND_API.G_RET_STS_SUCCESS;
421: END PRE_DELETE_REQ_HEADER;
422:
423: /* Called after req header Delete */
424: PROCEDURE POST_DELETE_REQ_HEADER

Line 430: x_return_status := FND_API.G_RET_STS_SUCCESS;

426: )
427: IS
428: BEGIN
429:
430: x_return_status := FND_API.G_RET_STS_SUCCESS;
431:
432: EXCEPTION WHEN OTHERS THEN
433: /*** hook failed -> log error ***/
434: fnd_msg_pub.Add_Exc_Msg('CSL_CSP_REQ_HEADERS_ACC_PKG','POST_DELETE_REQ_HEADER',sqlerrm);

Line 435: -- x_return_status := FND_API.G_RET_STS_ERROR;

431:
432: EXCEPTION WHEN OTHERS THEN
433: /*** hook failed -> log error ***/
434: fnd_msg_pub.Add_Exc_Msg('CSL_CSP_REQ_HEADERS_ACC_PKG','POST_DELETE_REQ_HEADER',sqlerrm);
435: -- x_return_status := FND_API.G_RET_STS_ERROR;
436: x_return_status := FND_API.G_RET_STS_SUCCESS;
437: END POST_DELETE_REQ_HEADER;
438:
439: /* Remove all ACC records of a mobile user */

Line 436: x_return_status := FND_API.G_RET_STS_SUCCESS;

432: EXCEPTION WHEN OTHERS THEN
433: /*** hook failed -> log error ***/
434: fnd_msg_pub.Add_Exc_Msg('CSL_CSP_REQ_HEADERS_ACC_PKG','POST_DELETE_REQ_HEADER',sqlerrm);
435: -- x_return_status := FND_API.G_RET_STS_ERROR;
436: x_return_status := FND_API.G_RET_STS_SUCCESS;
437: END POST_DELETE_REQ_HEADER;
438:
439: /* Remove all ACC records of a mobile user */
440: PROCEDURE Delete_All_ACC_Records

Line 486: x_return_status := FND_API.G_RET_STS_SUCCESS;

482: , 'Leaving Delete_All_ACC_Records procedure for user: ' || p_resource_id
483: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
484: END IF;
485:
486: x_return_status := FND_API.G_RET_STS_SUCCESS;
487: EXCEPTION WHEN OTHERS THEN
488: /*** hook failed -> log error ***/
489: fnd_msg_pub.Add_Exc_Msg('CSL_CSP_REQ_HEADERS_ACC_PKG','Delete_All_ACC_Records',sqlerrm);
490: -- x_return_status := FND_API.G_RET_STS_ERROR;

Line 490: -- x_return_status := FND_API.G_RET_STS_ERROR;

486: x_return_status := FND_API.G_RET_STS_SUCCESS;
487: EXCEPTION WHEN OTHERS THEN
488: /*** hook failed -> log error ***/
489: fnd_msg_pub.Add_Exc_Msg('CSL_CSP_REQ_HEADERS_ACC_PKG','Delete_All_ACC_Records',sqlerrm);
490: -- x_return_status := FND_API.G_RET_STS_ERROR;
491: x_return_status := FND_API.G_RET_STS_SUCCESS;
492: END Delete_All_ACC_Records;
493:
494: /* Full synch for a mobile user */

Line 491: x_return_status := FND_API.G_RET_STS_SUCCESS;

487: EXCEPTION WHEN OTHERS THEN
488: /*** hook failed -> log error ***/
489: fnd_msg_pub.Add_Exc_Msg('CSL_CSP_REQ_HEADERS_ACC_PKG','Delete_All_ACC_Records',sqlerrm);
490: -- x_return_status := FND_API.G_RET_STS_ERROR;
491: x_return_status := FND_API.G_RET_STS_SUCCESS;
492: END Delete_All_ACC_Records;
493:
494: /* Full synch for a mobile user */
495: PROCEDURE Insert_All_ACC_Records

Line 545: x_return_status := FND_API.G_RET_STS_SUCCESS;

541: , 'Leaving Insert_All_ACC_Records procedure for user: ' || p_resource_id
542: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
543: END IF;
544:
545: x_return_status := FND_API.G_RET_STS_SUCCESS;
546: EXCEPTION WHEN OTHERS THEN
547: /*** hook failed -> log error ***/
548: fnd_msg_pub.Add_Exc_Msg('CSL_CSP_REQ_HEADERS_ACC_PKG','Insert_All_ACC_Records',sqlerrm);
549: -- x_return_status := FND_API.G_RET_STS_ERROR;

Line 549: -- x_return_status := FND_API.G_RET_STS_ERROR;

545: x_return_status := FND_API.G_RET_STS_SUCCESS;
546: EXCEPTION WHEN OTHERS THEN
547: /*** hook failed -> log error ***/
548: fnd_msg_pub.Add_Exc_Msg('CSL_CSP_REQ_HEADERS_ACC_PKG','Insert_All_ACC_Records',sqlerrm);
549: -- x_return_status := FND_API.G_RET_STS_ERROR;
550: x_return_status := FND_API.G_RET_STS_SUCCESS;
551: END Insert_All_ACC_Records;
552:
553: END CSL_CSP_REQ_HEADERS_ACC_PKG;

Line 550: x_return_status := FND_API.G_RET_STS_SUCCESS;

546: EXCEPTION WHEN OTHERS THEN
547: /*** hook failed -> log error ***/
548: fnd_msg_pub.Add_Exc_Msg('CSL_CSP_REQ_HEADERS_ACC_PKG','Insert_All_ACC_Records',sqlerrm);
549: -- x_return_status := FND_API.G_RET_STS_ERROR;
550: x_return_status := FND_API.G_RET_STS_SUCCESS;
551: END Insert_All_ACC_Records;
552:
553: END CSL_CSP_REQ_HEADERS_ACC_PKG;