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_DEL_DISABLED_LIST_PVT dependencies on FND_FILE

Line 74: FND_FILE.PUT_LINE(FND_FILE.LOG, '--- Start '|| l_full_name || '---');

70:
71:
72: BEGIN
73:
74: FND_FILE.PUT_LINE(FND_FILE.LOG, '--- Start '|| l_full_name || '---');
75: FND_FILE.PUT_LINE(FND_FILE.LOG, 'list_header_id: ' || p_list_name);
76:
77: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || l_schema || '.AMS_LIST_ENTRIES_PURGE');
78:

Line 75: FND_FILE.PUT_LINE(FND_FILE.LOG, 'list_header_id: ' || p_list_name);

71:
72: BEGIN
73:
74: FND_FILE.PUT_LINE(FND_FILE.LOG, '--- Start '|| l_full_name || '---');
75: FND_FILE.PUT_LINE(FND_FILE.LOG, 'list_header_id: ' || p_list_name);
76:
77: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || l_schema || '.AMS_LIST_ENTRIES_PURGE');
78:
79: INSERT INTO AMS_LIST_ENTRIES_PURGE (LIST_HEADER_ID,LIST_ENTRY_ROW_ID)

Line 87: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Inserted into AMS_LIST_ENTRIES_PURGE ' );

83: AND ale.enabled_flag = 'N' ;
84:
85: COMMIT;
86:
87: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Inserted into AMS_LIST_ENTRIES_PURGE ' );
88:
89: -- Delete with incremental commit
90: LOOP
91:

Line 98: FND_FILE.PUT_LINE(FND_FILE.LOG, ' OPEN cursor c_list_entries_deleted' );

94: l_loop_count := l_loop_count + 1;
95:
96: -- Open Cursor
97: BEGIN
98: FND_FILE.PUT_LINE(FND_FILE.LOG, ' OPEN cursor c_list_entries_deleted' );
99: OPEN c_list_entries_deleted;
100: FETCH c_list_entries_deleted
101: BULK COLLECT INTO l_list_rec.tbl_rowid,
102: l_list_rec.list_header_id,

Line 111: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Others Exception in OPEN c_list_entries_deleted ' );

107: when others then
108: IF c_list_entries_deleted%ISOPEN THEN
109: CLOSE c_list_entries_deleted;
110: END IF;
111: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Others Exception in OPEN c_list_entries_deleted ' );
112: errbuf := 'Error in cursor c_list_entries_deleted ' || SQLERRM;
113: retcode := 2;
114: RAISE;
115: END;

Line 122: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Delete list_entries from AMS_LIST_ENTRIES ' );

118: l_limit_flag := TRUE;
119: END IF;
120:
121: -- Delete from tables
122: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Delete list_entries from AMS_LIST_ENTRIES ' );
123: IF AMS_DEBUG_LOW_ON THEN
124: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 1, l_cursor_limit ' || l_cursor_limit );
125: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 1, l_list_rec.list_header_id.first ' || l_list_rec.list_header_id.first );
126: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 1, l_list_rec.list_header_id.last ' || l_list_rec.list_header_id.last );

Line 124: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 1, l_cursor_limit ' || l_cursor_limit );

120:
121: -- Delete from tables
122: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Delete list_entries from AMS_LIST_ENTRIES ' );
123: IF AMS_DEBUG_LOW_ON THEN
124: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 1, l_cursor_limit ' || l_cursor_limit );
125: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 1, l_list_rec.list_header_id.first ' || l_list_rec.list_header_id.first );
126: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 1, l_list_rec.list_header_id.last ' || l_list_rec.list_header_id.last );
127: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 1, l_list_rec.list_header_id.count ' || l_list_rec.list_header_id.count );
128: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 1, l_first ' || l_first );

Line 125: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 1, l_list_rec.list_header_id.first ' || l_list_rec.list_header_id.first );

121: -- Delete from tables
122: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Delete list_entries from AMS_LIST_ENTRIES ' );
123: IF AMS_DEBUG_LOW_ON THEN
124: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 1, l_cursor_limit ' || l_cursor_limit );
125: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 1, l_list_rec.list_header_id.first ' || l_list_rec.list_header_id.first );
126: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 1, l_list_rec.list_header_id.last ' || l_list_rec.list_header_id.last );
127: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 1, l_list_rec.list_header_id.count ' || l_list_rec.list_header_id.count );
128: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 1, l_first ' || l_first );
129: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 1, l_last ' || l_last );

Line 126: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 1, l_list_rec.list_header_id.last ' || l_list_rec.list_header_id.last );

122: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Delete list_entries from AMS_LIST_ENTRIES ' );
123: IF AMS_DEBUG_LOW_ON THEN
124: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 1, l_cursor_limit ' || l_cursor_limit );
125: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 1, l_list_rec.list_header_id.first ' || l_list_rec.list_header_id.first );
126: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 1, l_list_rec.list_header_id.last ' || l_list_rec.list_header_id.last );
127: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 1, l_list_rec.list_header_id.count ' || l_list_rec.list_header_id.count );
128: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 1, l_first ' || l_first );
129: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 1, l_last ' || l_last );
130: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 1, G_NUM_REC ' || G_NUM_REC );

Line 127: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 1, l_list_rec.list_header_id.count ' || l_list_rec.list_header_id.count );

123: IF AMS_DEBUG_LOW_ON THEN
124: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 1, l_cursor_limit ' || l_cursor_limit );
125: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 1, l_list_rec.list_header_id.first ' || l_list_rec.list_header_id.first );
126: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 1, l_list_rec.list_header_id.last ' || l_list_rec.list_header_id.last );
127: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 1, l_list_rec.list_header_id.count ' || l_list_rec.list_header_id.count );
128: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 1, l_first ' || l_first );
129: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 1, l_last ' || l_last );
130: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 1, G_NUM_REC ' || G_NUM_REC );
131: END IF;

Line 128: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 1, l_first ' || l_first );

124: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 1, l_cursor_limit ' || l_cursor_limit );
125: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 1, l_list_rec.list_header_id.first ' || l_list_rec.list_header_id.first );
126: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 1, l_list_rec.list_header_id.last ' || l_list_rec.list_header_id.last );
127: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 1, l_list_rec.list_header_id.count ' || l_list_rec.list_header_id.count );
128: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 1, l_first ' || l_first );
129: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 1, l_last ' || l_last );
130: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 1, G_NUM_REC ' || G_NUM_REC );
131: END IF;
132:

Line 129: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 1, l_last ' || l_last );

125: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 1, l_list_rec.list_header_id.first ' || l_list_rec.list_header_id.first );
126: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 1, l_list_rec.list_header_id.last ' || l_list_rec.list_header_id.last );
127: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 1, l_list_rec.list_header_id.count ' || l_list_rec.list_header_id.count );
128: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 1, l_first ' || l_first );
129: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 1, l_last ' || l_last );
130: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 1, G_NUM_REC ' || G_NUM_REC );
131: END IF;
132:
133: IF l_list_rec.list_header_id.count = 0 THEN

Line 130: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 1, G_NUM_REC ' || G_NUM_REC );

126: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 1, l_list_rec.list_header_id.last ' || l_list_rec.list_header_id.last );
127: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 1, l_list_rec.list_header_id.count ' || l_list_rec.list_header_id.count );
128: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 1, l_first ' || l_first );
129: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 1, l_last ' || l_last );
130: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 1, G_NUM_REC ' || G_NUM_REC );
131: END IF;
132:
133: IF l_list_rec.list_header_id.count = 0 THEN
134: FND_FILE.PUT_LINE(FND_FILE.LOG, ' No entry for this list with enabled_flag as N ' );

Line 134: FND_FILE.PUT_LINE(FND_FILE.LOG, ' No entry for this list with enabled_flag as N ' );

130: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 1, G_NUM_REC ' || G_NUM_REC );
131: END IF;
132:
133: IF l_list_rec.list_header_id.count = 0 THEN
134: FND_FILE.PUT_LINE(FND_FILE.LOG, ' No entry for this list with enabled_flag as N ' );
135: ELSIF l_list_rec.list_header_id.count > 0 THEN
136: l_flag := TRUE;
137: l_first := l_list_rec.list_header_id.first;
138: l_last := l_first + G_NUM_REC;

Line 142: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 2 ' );

138: l_last := l_first + G_NUM_REC;
139:
140: WHILE l_flag LOOP
141: IF AMS_DEBUG_LOW_ON THEN
142: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 2 ' );
143: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 2, l_last ' || l_last );
144: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 2, l_list_rec.list_header_id.last ' || l_list_rec.list_header_id.last );
145: END IF;
146:

Line 143: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 2, l_last ' || l_last );

139:
140: WHILE l_flag LOOP
141: IF AMS_DEBUG_LOW_ON THEN
142: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 2 ' );
143: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 2, l_last ' || l_last );
144: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 2, l_list_rec.list_header_id.last ' || l_list_rec.list_header_id.last );
145: END IF;
146:
147: IF l_last > l_list_rec.list_header_id.last THEN

Line 144: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 2, l_list_rec.list_header_id.last ' || l_list_rec.list_header_id.last );

140: WHILE l_flag LOOP
141: IF AMS_DEBUG_LOW_ON THEN
142: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 2 ' );
143: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 2, l_last ' || l_last );
144: FND_FILE.PUT_LINE(FND_FILE.LOG, ' in loop 2, l_list_rec.list_header_id.last ' || l_list_rec.list_header_id.last );
145: END IF;
146:
147: IF l_last > l_list_rec.list_header_id.last THEN
148: l_last := l_list_rec.list_header_id.last;

Line 159: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Records deleted: ' || l_first ||'-'|| l_last );

155: DELETE FROM AMS_LIST_ENTRIES_PURGE
156: WHERE rowid = l_list_rec.purge_rowid(i);
157: COMMIT;
158:
159: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Records deleted: ' || l_first ||'-'|| l_last );
160:
161: l_first := l_last + 1;
162: l_last := l_first + G_NUM_REC;
163: IF l_first > l_list_rec.list_header_id.last THEN

Line 173: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Exception: others in DEL_DISABLED_LIST_ENTRIES ' );

169: END LOOP;
170:
171: EXCEPTION
172: WHEN others THEN
173: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Exception: others in DEL_DISABLED_LIST_ENTRIES ' );
174: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SQLCODE ' || to_char(SQLCODE) || ' SQLERRM ' || substr(SQLERRM, 1, 100));
175: errbuf := 'Error in proc DEL_DISABLED_LIST_ENTRIES ' || SQLERRM;
176: retcode := 2;
177: RAISE;

Line 174: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SQLCODE ' || to_char(SQLCODE) || ' SQLERRM ' || substr(SQLERRM, 1, 100));

170:
171: EXCEPTION
172: WHEN others THEN
173: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Exception: others in DEL_DISABLED_LIST_ENTRIES ' );
174: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SQLCODE ' || to_char(SQLCODE) || ' SQLERRM ' || substr(SQLERRM, 1, 100));
175: errbuf := 'Error in proc DEL_DISABLED_LIST_ENTRIES ' || SQLERRM;
176: retcode := 2;
177: RAISE;
178: