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

Line 77: p_commit := NVL(p_commit,FND_API.G_TRUE);

73:
74: BEGIN
75: l_SafeMode := NVL(p_SafeMode,'TRUE');
76: l_Active := NVL(p_Active,'N');
77: p_commit := NVL(p_commit,FND_API.G_TRUE);
78: TranRows := NVL(TranRows,1000);
79: -- Check range for purge. If you are going to purge all interactions
80: -- then you should specify the p_Purge_Type = 'ALL'
81: IF p_Start_Date IS NULL AND p_End_Date IS NULL

Line 278: IF ( (n_Media_Id IS NOT NULL) AND (n_Media_Id <> fnd_api.g_miss_num) ) THEN

274: WHERE ACTIVITY_ID = curActivity.ACTIVITY_ID
275: RETURNING Media_ID INTO n_Media_Id;
276:
277: nCountActivities := nCountActivities + 1;
278: IF ( (n_Media_Id IS NOT NULL) AND (n_Media_Id <> fnd_api.g_miss_num) ) THEN
279: SELECT Count(*) INTO nCountMedia
280: FROM JTF_IH_ACTIVITIES WHERE MEDIA_ID = n_Media_Id;
281: --
282: -- Delete Media Item If they aren't

Line 330: IF p_commit = FND_API.G_TRUE THEN

326: nCountInteraction := nCountInteraction + 1;
327: nRowTrn := nRowTrn + 1;
328: -- Make a commit for transactions only if SafeMode is False.
329: IF nRowTrn = TranRows AND l_SafeMode = 'FALSE' THEN
330: IF p_commit = FND_API.G_TRUE THEN
331: COMMIT;
332: nRowTrn := 0;
333: END IF;
334: END IF;

Line 341: IF p_commit = FND_API.G_TRUE THEN

337: nCntWrngInteraction := nCntWrngInteraction + 1;
338: END;
339: END LOOP;
340:
341: IF p_commit = FND_API.G_TRUE THEN
342: COMMIT;
343: NULL;
344: END IF;
345:

Line 486: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,

482: -- Standard start of API savepoint
483: SAVEPOINT delete_interactions_p;
484:
485: -- Standard call to check for call compatibility
486: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
487: l_api_name, g_pkg_name) THEN
488: RAISE fnd_api.g_exc_unexpected_error;
489: END IF;
490:

Line 488: RAISE fnd_api.g_exc_unexpected_error;

484:
485: -- Standard call to check for call compatibility
486: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
487: l_api_name, g_pkg_name) THEN
488: RAISE fnd_api.g_exc_unexpected_error;
489: END IF;
490:
491: -- Initialize message list if p_init_msg_list is set to TRUE
492: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 492: IF fnd_api.to_boolean(p_init_msg_list) THEN

488: RAISE fnd_api.g_exc_unexpected_error;
489: END IF;
490:
491: -- Initialize message list if p_init_msg_list is set to TRUE
492: IF fnd_api.to_boolean(p_init_msg_list) THEN
493: fnd_msg_pub.initialize;
494: END IF;
495:
496: -- Initialize API return status to success

Line 497: x_return_status := fnd_api.g_ret_sts_success;

493: fnd_msg_pub.initialize;
494: END IF;
495:
496: -- Initialize API return status to success
497: x_return_status := fnd_api.g_ret_sts_success;
498: l_return_status := x_return_status;
499:
500: OPEN c_jtf_obj_purge_temp_success;
501: FETCH c_jtf_obj_purge_temp_success bulk collect

Line 603: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

599: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
600: 'jtf.plsql.JTF_IH_PURGE.P_DELETE_INTERACTIONS.end.purge_notes', 'After call to Notes Purge API for Activities');
601: END IF;
602:
603: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
604: RAISE FND_API.G_EXC_ERROR;
605: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
607: END IF;

Line 604: RAISE FND_API.G_EXC_ERROR;

600: 'jtf.plsql.JTF_IH_PURGE.P_DELETE_INTERACTIONS.end.purge_notes', 'After call to Notes Purge API for Activities');
601: END IF;
602:
603: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
604: RAISE FND_API.G_EXC_ERROR;
605: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
607: END IF;
608:

Line 605: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

601: END IF;
602:
603: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
604: RAISE FND_API.G_EXC_ERROR;
605: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
607: END IF;
608:
609: END IF;

Line 606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

602:
603: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
604: RAISE FND_API.G_EXC_ERROR;
605: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
607: END IF;
608:
609: END IF;
610:

Line 735: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

731: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
732: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
733: 'jtf.plsql.JTF_IH_PURGE.P_DELETE_INTERACTIONS.end.purge_notes', 'After call to Notes Purge API for Activities');
734: END IF;
735: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
736: RAISE FND_API.G_EXC_ERROR;
737: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
738: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
739: END IF;

Line 736: RAISE FND_API.G_EXC_ERROR;

732: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
733: 'jtf.plsql.JTF_IH_PURGE.P_DELETE_INTERACTIONS.end.purge_notes', 'After call to Notes Purge API for Activities');
734: END IF;
735: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
736: RAISE FND_API.G_EXC_ERROR;
737: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
738: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
739: END IF;
740:

Line 737: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

733: 'jtf.plsql.JTF_IH_PURGE.P_DELETE_INTERACTIONS.end.purge_notes', 'After call to Notes Purge API for Activities');
734: END IF;
735: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
736: RAISE FND_API.G_EXC_ERROR;
737: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
738: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
739: END IF;
740:
741: END IF;

Line 738: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

734: END IF;
735: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
736: RAISE FND_API.G_EXC_ERROR;
737: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
738: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
739: END IF;
740:
741: END IF;
742:

Line 752: AND media_id <> fnd_api.g_miss_num

748: FORALL j IN l_media_ids.FIRST..l_media_ids.LAST
749: DELETE
750: FROM JTF_IH_MEDIA_ITEMS
751: WHERE media_id IS NOT NULL
752: AND media_id <> fnd_api.g_miss_num
753: AND media_id = l_media_ids(j)
754: AND
755: NOT EXISTS (SELECT 1
756: FROM JTF_IH_ACTIVITIES

Line 780: IF p_commit = FND_API.G_TRUE THEN

776: FROM JTF_IH_MEDIA_ITEM_LC_SEGS
777: WHERE MEDIA_ID = lc_media_ids(j);
778: END IF;
779:
780: IF p_commit = FND_API.G_TRUE THEN
781: COMMIT;
782: END IF;
783:
784: --Logging after deleting media life cycle segments

Line 806: WHEN fnd_api.g_exc_error THEN

802: 'jtf.plsql.JTF_IH_PURGE.P_DELETE_INTERACTIONS.end', l_fnd_log_msg);
803: END IF;
804:
805: EXCEPTION
806: WHEN fnd_api.g_exc_error THEN
807: ROLLBACK TO delete_interactions_p;
808: --dbms_output.put_line('FAILURE EXPECTED');
809: x_return_status := fnd_api.g_ret_sts_error;
810: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 809: x_return_status := fnd_api.g_ret_sts_error;

805: EXCEPTION
806: WHEN fnd_api.g_exc_error THEN
807: ROLLBACK TO delete_interactions_p;
808: --dbms_output.put_line('FAILURE EXPECTED');
809: x_return_status := fnd_api.g_ret_sts_error;
810: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
811: fnd_msg_pub.count_and_get
812: ( p_count => x_msg_count,
813: p_data => x_msg_data );

Line 819: WHEN fnd_api.g_exc_unexpected_error THEN

815: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
816: 'jtf.plsql.JTF_IH_PURGE.P_DELETE_INTERACTIONS', x_msg_data);
817: END IF;
818:
819: WHEN fnd_api.g_exc_unexpected_error THEN
820: ROLLBACK TO delete_interactions_p;
821: --dbms_output.put_line('FAILURE UNEXPECTED');
822: x_return_status := fnd_api.g_ret_sts_unexp_error;
823: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 822: x_return_status := fnd_api.g_ret_sts_unexp_error;

818:
819: WHEN fnd_api.g_exc_unexpected_error THEN
820: ROLLBACK TO delete_interactions_p;
821: --dbms_output.put_line('FAILURE UNEXPECTED');
822: x_return_status := fnd_api.g_ret_sts_unexp_error;
823: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
824: fnd_msg_pub.count_and_get
825: ( p_count => x_msg_count,
826: p_data => x_msg_data );

Line 834: x_return_status := fnd_api.g_ret_sts_success;

830: END IF;
831:
832: WHEN ErrNoRecFound THEN
833: ROLLBACK TO delete_interactions_p;
834: x_return_status := fnd_api.g_ret_sts_success;
835: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
836: fnd_msg_pub.count_and_get
837: ( p_count => x_msg_count,
838: p_data => x_msg_data );

Line 847: x_return_status := fnd_api.g_ret_sts_unexp_error;

843:
844: WHEN OTHERS THEN
845: ROLLBACK TO delete_interactions_p;
846: --dbms_output.put_line('FAILURE OTHERS');
847: x_return_status := fnd_api.g_ret_sts_unexp_error;
848: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
849: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
850: END IF;
851: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then