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.AMS_WEB_TRACK_PVT dependencies on AMS_WEB_TRACKING

Line 101: SELECT AMS_WEB_TRACKING_S.NEXTVAL

97: l_org_id NUMBER := FND_API.G_MISS_NUM;
98: l_web_tracking_id NUMBER;
99: l_dummy NUMBER;
100: CURSOR c_id IS
101: SELECT AMS_WEB_TRACKING_S.NEXTVAL
102: FROM dual;
103:
104: CURSOR c_id_exists (l_id IN NUMBER) IS
105: SELECT 1

Line 106: FROM AMS_WEB_TRACKING

102: FROM dual;
103:
104: CURSOR c_id_exists (l_id IN NUMBER) IS
105: SELECT 1
106: FROM AMS_WEB_TRACKING
107: WHERE web_tracking_id = l_id;
108: BEGIN
109: -- Standard Start of API savepoint
110: SAVEPOINT create_web_track_pvt;

Line 352: FROM AMS_WEB_TRACKING

348:
349:
350: CURSOR c_get_web_track(web_tracking_id NUMBER) IS
351: SELECT *
352: FROM AMS_WEB_TRACKING
353: WHERE web_tracking_id = p_web_track_rec.web_tracking_id;
354: -- Hint: Developer need to provide Where clause
355:
356:

Line 848: 'ams_web_tracking',

844: IF p_validation_mode = JTF_PLSQL_API.g_create
845: AND p_web_track_rec.web_tracking_id IS NOT NULL
846: THEN
847: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
848: 'ams_web_tracking',
849: 'web_tracking_id = ''' || p_web_track_rec.web_tracking_id ||''''
850: );
851: END IF;
852:

Line 854: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_web_tracking_id_DUPLICATE');

850: );
851: END IF;
852:
853: IF l_valid_flag = FND_API.g_false THEN
854: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_web_tracking_id_DUPLICATE');
855: x_return_status := FND_API.g_ret_sts_error;
856: END IF;
857:
858: END check_Web_Track_Uk_Items;

Line 1034: FROM ams_web_tracking

1030: l_return_status VARCHAR2(1);
1031:
1032: CURSOR c_complete IS
1033: SELECT *
1034: FROM ams_web_tracking
1035: WHERE web_tracking_id = p_web_track_rec.web_tracking_id;
1036: l_web_track_rec c_complete%ROWTYPE;
1037: BEGIN
1038: x_complete_rec := p_web_track_rec;

Line 2751: -- dbms_output.put_line('before inserting into AMS_Web_Tracking web_tracking_id'||l_web_tracking_id );

2747:
2748: --insert_log_mesg('Private API: Create_Web_Imp_Track');
2749:
2750: --validate web_track_rec_type
2751: -- dbms_output.put_line('before inserting into AMS_Web_Tracking web_tracking_id'||l_web_tracking_id );
2752: -- dbms_output.put_line('before inserting into AMS_Web_Tracking schedule_id '||l_schedule_id );
2753: -- dbms_output.put_line('before inserting into AMS_Web_Tracking party_id'||l_party_id );
2754: -- dbms_output.put_line('before inserting into AMS_Web_Tracking placement_id '||l_placement_id );
2755: -- dbms_output.put_line('before inserting into AMS_Web_Tracking content_item_id'||l_content_item_id );

Line 2752: -- dbms_output.put_line('before inserting into AMS_Web_Tracking schedule_id '||l_schedule_id );

2748: --insert_log_mesg('Private API: Create_Web_Imp_Track');
2749:
2750: --validate web_track_rec_type
2751: -- dbms_output.put_line('before inserting into AMS_Web_Tracking web_tracking_id'||l_web_tracking_id );
2752: -- dbms_output.put_line('before inserting into AMS_Web_Tracking schedule_id '||l_schedule_id );
2753: -- dbms_output.put_line('before inserting into AMS_Web_Tracking party_id'||l_party_id );
2754: -- dbms_output.put_line('before inserting into AMS_Web_Tracking placement_id '||l_placement_id );
2755: -- dbms_output.put_line('before inserting into AMS_Web_Tracking content_item_id'||l_content_item_id );
2756:

Line 2753: -- dbms_output.put_line('before inserting into AMS_Web_Tracking party_id'||l_party_id );

2749:
2750: --validate web_track_rec_type
2751: -- dbms_output.put_line('before inserting into AMS_Web_Tracking web_tracking_id'||l_web_tracking_id );
2752: -- dbms_output.put_line('before inserting into AMS_Web_Tracking schedule_id '||l_schedule_id );
2753: -- dbms_output.put_line('before inserting into AMS_Web_Tracking party_id'||l_party_id );
2754: -- dbms_output.put_line('before inserting into AMS_Web_Tracking placement_id '||l_placement_id );
2755: -- dbms_output.put_line('before inserting into AMS_Web_Tracking content_item_id'||l_content_item_id );
2756:
2757: --insert_log_mesg(p_web_track_rec.schedule_id);

Line 2754: -- dbms_output.put_line('before inserting into AMS_Web_Tracking placement_id '||l_placement_id );

2750: --validate web_track_rec_type
2751: -- dbms_output.put_line('before inserting into AMS_Web_Tracking web_tracking_id'||l_web_tracking_id );
2752: -- dbms_output.put_line('before inserting into AMS_Web_Tracking schedule_id '||l_schedule_id );
2753: -- dbms_output.put_line('before inserting into AMS_Web_Tracking party_id'||l_party_id );
2754: -- dbms_output.put_line('before inserting into AMS_Web_Tracking placement_id '||l_placement_id );
2755: -- dbms_output.put_line('before inserting into AMS_Web_Tracking content_item_id'||l_content_item_id );
2756:
2757: --insert_log_mesg(p_web_track_rec.schedule_id);
2758: l_web_track_rec.web_tracking_id := null;

Line 2755: -- dbms_output.put_line('before inserting into AMS_Web_Tracking content_item_id'||l_content_item_id );

2751: -- dbms_output.put_line('before inserting into AMS_Web_Tracking web_tracking_id'||l_web_tracking_id );
2752: -- dbms_output.put_line('before inserting into AMS_Web_Tracking schedule_id '||l_schedule_id );
2753: -- dbms_output.put_line('before inserting into AMS_Web_Tracking party_id'||l_party_id );
2754: -- dbms_output.put_line('before inserting into AMS_Web_Tracking placement_id '||l_placement_id );
2755: -- dbms_output.put_line('before inserting into AMS_Web_Tracking content_item_id'||l_content_item_id );
2756:
2757: --insert_log_mesg(p_web_track_rec.schedule_id);
2758: l_web_track_rec.web_tracking_id := null;
2759: l_web_track_rec.schedule_id := p_web_track_rec.schedule_id;

Line 2778: --dbms_output.put_line('before inserting into AMS_Web_Tracking web_tracking_id'||l_web_tracking_id );

2774: p_web_track_rec => l_web_track_rec,
2775: x_web_tracking_id => l_web_tracking_id
2776: );
2777: --insert_log_mesg('Done Create_Web_Track ::::');
2778: --dbms_output.put_line('before inserting into AMS_Web_Tracking web_tracking_id'||l_web_tracking_id );
2779: --insert_log_mesg('l_web_tracking_id');
2780: --insert_log_mesg('Web Tracking Id ::::'||l_web_tracking_id);
2781:
2782: IF l_web_tracking_id IS NULL THEN

Line 2790: --dbms_output.put_line('after inserting into AMS_WEB_TRACKING '||l_web_tracking_id );

2786: END IF;
2787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2788: END IF;
2789:
2790: --dbms_output.put_line('after inserting into AMS_WEB_TRACKING '||l_web_tracking_id );
2791: --dbms_output.put_line('l_web_recomms_tbl_type.COUNT '||web_recomms_tbl_type.COUNT);
2792:
2793: IF ( (p_web_track_rec.schedule_type = 'WEB_ADV') OR (p_web_track_rec.schedule_type = 'WEB_OFFER') ) THEN
2794: x_impr_obj_id_rec(0).impr_track_id := l_web_tracking_id;