APPS.JTF_FM_IH_LOGGER_PVT dependencies on JTF_FM_STATUS_ALL

Line 404: --remove header from the jtf_fm_status_all table

400:
401:
402: -- DISPLAY(l_interaction_clob);
403:
404: --remove header from the jtf_fm_status_all table
405: Remove_from_status(l_header_rec.hist_req_id);
406:
407: --Update jtf_fm_request_history_all to success
408: if ( ( l_header_status_success_flag = 'T') and ( l_header_status_failure_flag = 'F')) then

Line 437: --remove header from the jtf_fm_status_all table

433:
434: WHEN RESOURCE_NOT_FOUND_EXCEPTION THEN
435: ROLLBACK TO Log_interactionrequest;
436:
437: --remove header from the jtf_fm_status_all table
438: Remove_from_status(l_header_rec.hist_req_id);
439:
440: Update_history(l_header_rec.hist_req_id, 'IHFAILED');
441: commit;

Line 451: --remove header from the jtf_fm_status_all table

447:
448: WHEN FND_API.G_EXC_ERROR THEN
449: ROLLBACK TO Log_interactionrequest;
450:
451: --remove header from the jtf_fm_status_all table
452: Remove_from_status(l_header_rec.hist_req_id);
453:
454: Update_history(l_header_rec.hist_req_id, 'IHFAILED');
455: commit;

Line 468: --remove header from the jtf_fm_status_all table

464:
465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
466: ROLLBACK TO Log_interactionrequest;
467:
468: --remove header from the jtf_fm_status_all table
469: Remove_from_status(l_header_rec.hist_req_id);
470:
471: Update_history(l_header_rec.hist_req_id, 'IHFAILED');
472: commit;

Line 485: --remove header from the jtf_fm_status_all table

481:
482: WHEN OTHERS THEN
483: ROLLBACK TO Log_interactionrequest;
484:
485: --remove header from the jtf_fm_status_all table
486: Remove_from_status(l_header_rec.hist_req_id);
487:
488: Update_history(l_header_rec.hist_req_id, 'IHFAILED');
489: commit;

Line 507: delete from jtf_fm_status_all

503:
504: PROCEDURE Remove_from_status(P_Request_ID IN NUMBER) Is
505: BEGIN
506:
507: delete from jtf_fm_status_all
508: where request_id = P_Request_ID;
509:
510: --commit;
511: