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.IGF_AP_TODO_GRPS_PRC_PKG dependencies on FND_FILE

Line 221: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

217: OPEN c_person_group(p_person_id_grp);
218: FETCH c_person_group INTO l_group_desc;
219: CLOSE c_person_group;
220:
221: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
222: FND_FILE.PUT_LINE(FND_FILE.LOG, l_para_pass); --------------Parameters Passed--------------
223: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
224:
225: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_award_year_pmpt,40) || ' : '|| lv_awd_alternate_code);

Line 222: FND_FILE.PUT_LINE(FND_FILE.LOG, l_para_pass); --------------Parameters Passed--------------

218: FETCH c_person_group INTO l_group_desc;
219: CLOSE c_person_group;
220:
221: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
222: FND_FILE.PUT_LINE(FND_FILE.LOG, l_para_pass); --------------Parameters Passed--------------
223: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
224:
225: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_award_year_pmpt,40) || ' : '|| lv_awd_alternate_code);
226: IF l_group_desc IS NOT NULL THEN

Line 223: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

219: CLOSE c_person_group;
220:
221: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
222: FND_FILE.PUT_LINE(FND_FILE.LOG, l_para_pass); --------------Parameters Passed--------------
223: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
224:
225: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_award_year_pmpt,40) || ' : '|| lv_awd_alternate_code);
226: IF l_group_desc IS NOT NULL THEN
227: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_person_id_grp_pmpt,40) || ' : '|| l_group_desc);

Line 225: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_award_year_pmpt,40) || ' : '|| lv_awd_alternate_code);

221: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
222: FND_FILE.PUT_LINE(FND_FILE.LOG, l_para_pass); --------------Parameters Passed--------------
223: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
224:
225: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_award_year_pmpt,40) || ' : '|| lv_awd_alternate_code);
226: IF l_group_desc IS NOT NULL THEN
227: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_person_id_grp_pmpt,40) || ' : '|| l_group_desc);
228: END IF;
229: IF l_person_number IS NOT NULL THEN

Line 227: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_person_id_grp_pmpt,40) || ' : '|| l_group_desc);

223: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
224:
225: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_award_year_pmpt,40) || ' : '|| lv_awd_alternate_code);
226: IF l_group_desc IS NOT NULL THEN
227: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_person_id_grp_pmpt,40) || ' : '|| l_group_desc);
228: END IF;
229: IF l_person_number IS NOT NULL THEN
230: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_person_number_pmpt,40) || ' : '|| l_person_number);
231: END IF;

Line 230: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_person_number_pmpt,40) || ' : '|| l_person_number);

226: IF l_group_desc IS NOT NULL THEN
227: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_person_id_grp_pmpt,40) || ' : '|| l_group_desc);
228: END IF;
229: IF l_person_number IS NOT NULL THEN
230: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_person_number_pmpt,40) || ' : '|| l_person_number);
231: END IF;
232:
233: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(l_upd_mode_pmpt,40) || ' : '|| igf_aw_gen.lookup_desc('IGF_AP_TD_UPD_MODE',p_upd_mode));
234:

Line 233: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(l_upd_mode_pmpt,40) || ' : '|| igf_aw_gen.lookup_desc('IGF_AP_TD_UPD_MODE',p_upd_mode));

229: IF l_person_number IS NOT NULL THEN
230: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_person_number_pmpt,40) || ' : '|| l_person_number);
231: END IF;
232:
233: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(l_upd_mode_pmpt,40) || ' : '|| igf_aw_gen.lookup_desc('IGF_AP_TD_UPD_MODE',p_upd_mode));
234:
235: l_item_description := NULL;
236: IF p_item_number_1 IS NOT NULL THEN
237: OPEN c_item_descrption(p_item_number_1);

Line 240: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_item_code_pmpt || ' 1', 40) || ' : ' || l_item_description );

236: IF p_item_number_1 IS NOT NULL THEN
237: OPEN c_item_descrption(p_item_number_1);
238: FETCH c_item_descrption INTO l_item_description;
239: CLOSE c_item_descrption;
240: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_item_code_pmpt || ' 1', 40) || ' : ' || l_item_description );
241: IF p_status_1 IS NOT NULL THEN
242: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_status_pmpt || ' 1', 40) || ' : ' || igf_aw_gen.lookup_desc('IGF_TD_ITEM_STATUS',p_status_1));
243: END IF;
244: END IF;

Line 242: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_status_pmpt || ' 1', 40) || ' : ' || igf_aw_gen.lookup_desc('IGF_TD_ITEM_STATUS',p_status_1));

238: FETCH c_item_descrption INTO l_item_description;
239: CLOSE c_item_descrption;
240: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_item_code_pmpt || ' 1', 40) || ' : ' || l_item_description );
241: IF p_status_1 IS NOT NULL THEN
242: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_status_pmpt || ' 1', 40) || ' : ' || igf_aw_gen.lookup_desc('IGF_TD_ITEM_STATUS',p_status_1));
243: END IF;
244: END IF;
245:
246: l_item_description := NULL;

Line 251: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_item_code_pmpt || ' 2', 40) || ' : ' || l_item_description );

247: IF p_item_number_2 IS NOT NULL THEN
248: OPEN c_item_descrption(p_item_number_2);
249: FETCH c_item_descrption INTO l_item_description;
250: CLOSE c_item_descrption;
251: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_item_code_pmpt || ' 2', 40) || ' : ' || l_item_description );
252: IF p_status_2 IS NOT NULL THEN
253: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_status_pmpt || ' 1', 40) || ' : ' || igf_aw_gen.lookup_desc('IGF_TD_ITEM_STATUS',p_status_2));
254: END IF;
255: END IF ;

Line 253: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_status_pmpt || ' 1', 40) || ' : ' || igf_aw_gen.lookup_desc('IGF_TD_ITEM_STATUS',p_status_2));

249: FETCH c_item_descrption INTO l_item_description;
250: CLOSE c_item_descrption;
251: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_item_code_pmpt || ' 2', 40) || ' : ' || l_item_description );
252: IF p_status_2 IS NOT NULL THEN
253: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_status_pmpt || ' 1', 40) || ' : ' || igf_aw_gen.lookup_desc('IGF_TD_ITEM_STATUS',p_status_2));
254: END IF;
255: END IF ;
256:
257: l_item_description := NULL;

Line 262: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_item_code_pmpt || ' 3', 40) || ' : ' || l_item_description );

258: IF p_item_number_3 IS NOT NULL THEN
259: OPEN c_item_descrption(p_item_number_3);
260: FETCH c_item_descrption INTO l_item_description;
261: CLOSE c_item_descrption;
262: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_item_code_pmpt || ' 3', 40) || ' : ' || l_item_description );
263: IF p_status_3 IS NOT NULL THEN
264: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_status_pmpt || ' 1', 40) || ' : ' || igf_aw_gen.lookup_desc('IGF_TD_ITEM_STATUS',p_status_3));
265: END IF;
266: END IF;

Line 264: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_status_pmpt || ' 1', 40) || ' : ' || igf_aw_gen.lookup_desc('IGF_TD_ITEM_STATUS',p_status_3));

260: FETCH c_item_descrption INTO l_item_description;
261: CLOSE c_item_descrption;
262: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_item_code_pmpt || ' 3', 40) || ' : ' || l_item_description );
263: IF p_status_3 IS NOT NULL THEN
264: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_status_pmpt || ' 1', 40) || ' : ' || igf_aw_gen.lookup_desc('IGF_TD_ITEM_STATUS',p_status_3));
265: END IF;
266: END IF;
267:
268: l_item_description := NULL;

Line 273: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_item_code_pmpt || ' 4', 40) || ' : ' || l_item_description );

269: IF p_item_number_4 IS NOT NULL THEN
270: OPEN c_item_descrption(p_item_number_4);
271: FETCH c_item_descrption INTO l_item_description;
272: CLOSE c_item_descrption;
273: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_item_code_pmpt || ' 4', 40) || ' : ' || l_item_description );
274: IF p_status_4 IS NOT NULL THEN
275: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_status_pmpt || ' 1', 40) || ' : ' || igf_aw_gen.lookup_desc('IGF_TD_ITEM_STATUS',p_status_4));
276: END IF;
277: END IF ;

Line 275: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_status_pmpt || ' 1', 40) || ' : ' || igf_aw_gen.lookup_desc('IGF_TD_ITEM_STATUS',p_status_4));

271: FETCH c_item_descrption INTO l_item_description;
272: CLOSE c_item_descrption;
273: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_item_code_pmpt || ' 4', 40) || ' : ' || l_item_description );
274: IF p_status_4 IS NOT NULL THEN
275: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_status_pmpt || ' 1', 40) || ' : ' || igf_aw_gen.lookup_desc('IGF_TD_ITEM_STATUS',p_status_4));
276: END IF;
277: END IF ;
278:
279: l_item_description := NULL;

Line 284: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_item_code_pmpt || ' 5', 40) || ' : ' || l_item_description );

280: IF p_item_number_5 IS NOT NULL THEN
281: OPEN c_item_descrption(p_item_number_5);
282: FETCH c_item_descrption INTO l_item_description;
283: CLOSE c_item_descrption;
284: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_item_code_pmpt || ' 5', 40) || ' : ' || l_item_description );
285: IF p_status_5 IS NOT NULL THEN
286: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_status_pmpt || ' 1', 40) || ' : ' || igf_aw_gen.lookup_desc('IGF_TD_ITEM_STATUS',p_status_5));
287: END IF;
288: END IF;

Line 286: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_status_pmpt || ' 1', 40) || ' : ' || igf_aw_gen.lookup_desc('IGF_TD_ITEM_STATUS',p_status_5));

282: FETCH c_item_descrption INTO l_item_description;
283: CLOSE c_item_descrption;
284: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_item_code_pmpt || ' 5', 40) || ' : ' || l_item_description );
285: IF p_status_5 IS NOT NULL THEN
286: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_status_pmpt || ' 1', 40) || ' : ' || igf_aw_gen.lookup_desc('IGF_TD_ITEM_STATUS',p_status_5));
287: END IF;
288: END IF;
289:
290: l_item_description := NULL;

Line 295: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_item_code_pmpt || ' 6', 40) || ' : ' || l_item_description );

291: IF p_item_number_6 IS NOT NULL THEN
292: OPEN c_item_descrption(p_item_number_6);
293: FETCH c_item_descrption INTO l_item_description;
294: CLOSE c_item_descrption;
295: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_item_code_pmpt || ' 6', 40) || ' : ' || l_item_description );
296: IF p_status_6 IS NOT NULL THEN
297: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_status_pmpt || ' 1', 40) || ' : ' || igf_aw_gen.lookup_desc('IGF_TD_ITEM_STATUS',p_status_6));
298: END IF;
299: END IF;

Line 297: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_status_pmpt || ' 1', 40) || ' : ' || igf_aw_gen.lookup_desc('IGF_TD_ITEM_STATUS',p_status_6));

293: FETCH c_item_descrption INTO l_item_description;
294: CLOSE c_item_descrption;
295: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_item_code_pmpt || ' 6', 40) || ' : ' || l_item_description );
296: IF p_status_6 IS NOT NULL THEN
297: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_status_pmpt || ' 1', 40) || ' : ' || igf_aw_gen.lookup_desc('IGF_TD_ITEM_STATUS',p_status_6));
298: END IF;
299: END IF;
300:
301: l_item_description := NULL;

Line 306: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_item_code_pmpt || ' 7', 40) || ' : ' || l_item_description );

302: IF p_item_number_7 IS NOT NULL THEN
303: OPEN c_item_descrption(p_item_number_7);
304: FETCH c_item_descrption INTO l_item_description;
305: CLOSE c_item_descrption;
306: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_item_code_pmpt || ' 7', 40) || ' : ' || l_item_description );
307: IF p_status_7 IS NOT NULL THEN
308: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_status_pmpt || ' 1', 40) || ' : ' || igf_aw_gen.lookup_desc('IGF_TD_ITEM_STATUS',p_status_7));
309: END IF;
310: END IF;

Line 308: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_status_pmpt || ' 1', 40) || ' : ' || igf_aw_gen.lookup_desc('IGF_TD_ITEM_STATUS',p_status_7));

304: FETCH c_item_descrption INTO l_item_description;
305: CLOSE c_item_descrption;
306: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_item_code_pmpt || ' 7', 40) || ' : ' || l_item_description );
307: IF p_status_7 IS NOT NULL THEN
308: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_status_pmpt || ' 1', 40) || ' : ' || igf_aw_gen.lookup_desc('IGF_TD_ITEM_STATUS',p_status_7));
309: END IF;
310: END IF;
311:
312: l_item_description := NULL;

Line 317: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_item_code_pmpt || ' 8', 40) || ' : ' || l_item_description );

313: IF p_item_number_8 IS NOT NULL THEN
314: OPEN c_item_descrption(p_item_number_8);
315: FETCH c_item_descrption INTO l_item_description;
316: CLOSE c_item_descrption;
317: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_item_code_pmpt || ' 8', 40) || ' : ' || l_item_description );
318: IF p_status_8 IS NOT NULL THEN
319: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_status_pmpt || ' 1', 40) || ' : ' || igf_aw_gen.lookup_desc('IGF_TD_ITEM_STATUS',p_status_8));
320: END IF;
321: END IF;

Line 319: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_status_pmpt || ' 1', 40) || ' : ' || igf_aw_gen.lookup_desc('IGF_TD_ITEM_STATUS',p_status_8));

315: FETCH c_item_descrption INTO l_item_description;
316: CLOSE c_item_descrption;
317: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_item_code_pmpt || ' 8', 40) || ' : ' || l_item_description );
318: IF p_status_8 IS NOT NULL THEN
319: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_status_pmpt || ' 1', 40) || ' : ' || igf_aw_gen.lookup_desc('IGF_TD_ITEM_STATUS',p_status_8));
320: END IF;
321: END IF;
322:
323: l_item_description := NULL;

Line 328: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_item_code_pmpt || ' 9', 40) || ' : ' || l_item_description );

324: IF p_item_number_9 IS NOT NULL THEN
325: OPEN c_item_descrption(p_item_number_9);
326: FETCH c_item_descrption INTO l_item_description;
327: CLOSE c_item_descrption;
328: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_item_code_pmpt || ' 9', 40) || ' : ' || l_item_description );
329: IF p_status_9 IS NOT NULL THEN
330: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_status_pmpt || ' 1', 40) || ' : ' || igf_aw_gen.lookup_desc('IGF_TD_ITEM_STATUS',p_status_9));
331: END IF;
332: END IF;

Line 330: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_status_pmpt || ' 1', 40) || ' : ' || igf_aw_gen.lookup_desc('IGF_TD_ITEM_STATUS',p_status_9));

326: FETCH c_item_descrption INTO l_item_description;
327: CLOSE c_item_descrption;
328: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_item_code_pmpt || ' 9', 40) || ' : ' || l_item_description );
329: IF p_status_9 IS NOT NULL THEN
330: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_status_pmpt || ' 1', 40) || ' : ' || igf_aw_gen.lookup_desc('IGF_TD_ITEM_STATUS',p_status_9));
331: END IF;
332: END IF;
333:
334: l_item_description := NULL;

Line 339: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_item_code_pmpt || ' 10', 40) || ' : ' || l_item_description );

335: IF p_item_number_10 IS NOT NULL THEN
336: OPEN c_item_descrption(p_item_number_10);
337: FETCH c_item_descrption INTO l_item_description;
338: CLOSE c_item_descrption;
339: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_item_code_pmpt || ' 10', 40) || ' : ' || l_item_description );
340: IF p_status_10 IS NOT NULL THEN
341: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_status_pmpt || ' 1', 40) || ' : ' || igf_aw_gen.lookup_desc('IGF_TD_ITEM_STATUS',p_status_10));
342: END IF;
343: END IF;

Line 341: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_status_pmpt || ' 1', 40) || ' : ' || igf_aw_gen.lookup_desc('IGF_TD_ITEM_STATUS',p_status_10));

337: FETCH c_item_descrption INTO l_item_description;
338: CLOSE c_item_descrption;
339: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_item_code_pmpt || ' 10', 40) || ' : ' || l_item_description );
340: IF p_status_10 IS NOT NULL THEN
341: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_status_pmpt || ' 1', 40) || ' : ' || igf_aw_gen.lookup_desc('IGF_TD_ITEM_STATUS',p_status_10));
342: END IF;
343: END IF;
344:
345: l_item_description := NULL;

Line 350: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_item_code_pmpt || ' 11', 40) || ' : ' || l_item_description );

346: IF p_item_number_11 IS NOT NULL THEN
347: OPEN c_item_descrption(p_item_number_11);
348: FETCH c_item_descrption INTO l_item_description;
349: CLOSE c_item_descrption;
350: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_item_code_pmpt || ' 11', 40) || ' : ' || l_item_description );
351: IF p_status_11 IS NOT NULL THEN
352: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_status_pmpt || ' 1', 40) || ' : ' || igf_aw_gen.lookup_desc('IGF_TD_ITEM_STATUS',p_status_11));
353: END IF;
354: END IF;

Line 352: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_status_pmpt || ' 1', 40) || ' : ' || igf_aw_gen.lookup_desc('IGF_TD_ITEM_STATUS',p_status_11));

348: FETCH c_item_descrption INTO l_item_description;
349: CLOSE c_item_descrption;
350: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_item_code_pmpt || ' 11', 40) || ' : ' || l_item_description );
351: IF p_status_11 IS NOT NULL THEN
352: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_status_pmpt || ' 1', 40) || ' : ' || igf_aw_gen.lookup_desc('IGF_TD_ITEM_STATUS',p_status_11));
353: END IF;
354: END IF;
355:
356: l_item_description := NULL;

Line 361: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_item_code_pmpt || ' 12', 40) || ' : ' || l_item_description );

357: IF p_item_number_12 IS NOT NULL THEN
358: OPEN c_item_descrption(p_item_number_12);
359: FETCH c_item_descrption INTO l_item_description;
360: CLOSE c_item_descrption;
361: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_item_code_pmpt || ' 12', 40) || ' : ' || l_item_description );
362: IF p_status_12 IS NOT NULL THEN
363: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_status_pmpt || ' 1', 40) || ' : ' || igf_aw_gen.lookup_desc('IGF_TD_ITEM_STATUS',p_status_12));
364: END IF;
365: END IF;

Line 363: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_status_pmpt || ' 1', 40) || ' : ' || igf_aw_gen.lookup_desc('IGF_TD_ITEM_STATUS',p_status_12));

359: FETCH c_item_descrption INTO l_item_description;
360: CLOSE c_item_descrption;
361: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_item_code_pmpt || ' 12', 40) || ' : ' || l_item_description );
362: IF p_status_12 IS NOT NULL THEN
363: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_status_pmpt || ' 1', 40) || ' : ' || igf_aw_gen.lookup_desc('IGF_TD_ITEM_STATUS',p_status_12));
364: END IF;
365: END IF;
366:
367: l_item_description := NULL;

Line 372: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_item_code_pmpt || ' 13', 40) || ' : ' || l_item_description );

368: IF p_item_number_13 IS NOT NULL THEN
369: OPEN c_item_descrption(p_item_number_13);
370: FETCH c_item_descrption INTO l_item_description;
371: CLOSE c_item_descrption;
372: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_item_code_pmpt || ' 13', 40) || ' : ' || l_item_description );
373: IF p_status_13 IS NOT NULL THEN
374: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_status_pmpt || ' 1', 40) || ' : ' || igf_aw_gen.lookup_desc('IGF_TD_ITEM_STATUS',p_status_13));
375: END IF;
376: END IF;

Line 374: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_status_pmpt || ' 1', 40) || ' : ' || igf_aw_gen.lookup_desc('IGF_TD_ITEM_STATUS',p_status_13));

370: FETCH c_item_descrption INTO l_item_description;
371: CLOSE c_item_descrption;
372: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_item_code_pmpt || ' 13', 40) || ' : ' || l_item_description );
373: IF p_status_13 IS NOT NULL THEN
374: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_status_pmpt || ' 1', 40) || ' : ' || igf_aw_gen.lookup_desc('IGF_TD_ITEM_STATUS',p_status_13));
375: END IF;
376: END IF;
377:
378: l_item_description := NULL;

Line 383: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_item_code_pmpt || ' 14', 40) || ' : ' || l_item_description );

379: IF p_item_number_14 IS NOT NULL THEN
380: OPEN c_item_descrption(p_item_number_14);
381: FETCH c_item_descrption INTO l_item_description;
382: CLOSE c_item_descrption;
383: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_item_code_pmpt || ' 14', 40) || ' : ' || l_item_description );
384: IF p_status_14 IS NOT NULL THEN
385: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_status_pmpt || ' 1', 40) || ' : ' || igf_aw_gen.lookup_desc('IGF_TD_ITEM_STATUS',p_status_14));
386: END IF;
387: END IF;

Line 385: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_status_pmpt || ' 1', 40) || ' : ' || igf_aw_gen.lookup_desc('IGF_TD_ITEM_STATUS',p_status_14));

381: FETCH c_item_descrption INTO l_item_description;
382: CLOSE c_item_descrption;
383: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_item_code_pmpt || ' 14', 40) || ' : ' || l_item_description );
384: IF p_status_14 IS NOT NULL THEN
385: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_status_pmpt || ' 1', 40) || ' : ' || igf_aw_gen.lookup_desc('IGF_TD_ITEM_STATUS',p_status_14));
386: END IF;
387: END IF;
388:
389: l_item_description := NULL;

Line 394: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_item_code_pmpt || ' 15', 40) || ' : ' || l_item_description );

390: IF p_item_number_15 IS NOT NULL THEN
391: OPEN c_item_descrption(p_item_number_15);
392: FETCH c_item_descrption INTO l_item_description;
393: CLOSE c_item_descrption;
394: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_item_code_pmpt || ' 15', 40) || ' : ' || l_item_description );
395: IF p_status_15 IS NOT NULL THEN
396: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_status_pmpt || ' 1', 40) || ' : ' || igf_aw_gen.lookup_desc('IGF_TD_ITEM_STATUS',p_status_15));
397: END IF;
398: END IF;

Line 396: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_status_pmpt || ' 1', 40) || ' : ' || igf_aw_gen.lookup_desc('IGF_TD_ITEM_STATUS',p_status_15));

392: FETCH c_item_descrption INTO l_item_description;
393: CLOSE c_item_descrption;
394: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_item_code_pmpt || ' 15', 40) || ' : ' || l_item_description );
395: IF p_status_15 IS NOT NULL THEN
396: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_status_pmpt || ' 1', 40) || ' : ' || igf_aw_gen.lookup_desc('IGF_TD_ITEM_STATUS',p_status_15));
397: END IF;
398: END IF;
399:
400: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

Line 400: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

396: FND_FILE.PUT_LINE(FND_FILE.LOG, RPAD(lv_status_pmpt || ' 1', 40) || ' : ' || igf_aw_gen.lookup_desc('IGF_TD_ITEM_STATUS',p_status_15));
397: END IF;
398: END IF;
399:
400: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
401: FND_FILE.PUT_LINE(FND_FILE.LOG, '-------------------------------------------------------------');
402: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
403: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
404:

Line 401: FND_FILE.PUT_LINE(FND_FILE.LOG, '-------------------------------------------------------------');

397: END IF;
398: END IF;
399:
400: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
401: FND_FILE.PUT_LINE(FND_FILE.LOG, '-------------------------------------------------------------');
402: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
403: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
404:
405: EXCEPTION

Line 402: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

398: END IF;
399:
400: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
401: FND_FILE.PUT_LINE(FND_FILE.LOG, '-------------------------------------------------------------');
402: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
403: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
404:
405: EXCEPTION
406: WHEN others THEN

Line 403: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

399:
400: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
401: FND_FILE.PUT_LINE(FND_FILE.LOG, '-------------------------------------------------------------');
402: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
403: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
404:
405: EXCEPTION
406: WHEN others THEN
407: FND_MESSAGE.SET_NAME('IGF','IGF_GE_UNHANDLED_EXP');

Line 545: FND_FILE.PUT_LINE(FND_FILE.LOG ,FND_MESSAGE.GET);

541: IF c_check_preflender%FOUND THEN
542: -- If already an active preflender present - then Skip that item for processing and log a message
543: fnd_message.set_name('IGF','IGF_AP_LEND_TD_NO_ASSGN');
544: fnd_message.set_token('ITEM',lc_item_details.description);
545: FND_FILE.PUT_LINE(FND_FILE.LOG ,FND_MESSAGE.GET);
546: ln_skip_items := ln_skip_items + 1;
547: RETURN;
548: END IF;
549: CLOSE c_check_preflender;

Line 583: FND_FILE.PUT_LINE(FND_FILE.LOG ,FND_MESSAGE.GET);

579: CLOSE c_to_do_item;
580: IF lc_to_do_item.inactive_flag = 'Y' THEN
581: fnd_message.set_name('IGF','IGF_AP_INAC_TD_SKIP');
582: fnd_message.set_token('ITEMCODE',lc_item_details.description);
583: FND_FILE.PUT_LINE(FND_FILE.LOG ,FND_MESSAGE.GET);
584: ln_skip_items := ln_skip_items + 1;
585: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
586: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.add_to_do.debug','p_todo_number:'||p_todo_number||' skipped as it is inactive');
587: END IF;

Line 625: FND_FILE.PUT_LINE(FND_FILE.LOG ,FND_MESSAGE.GET);

621: -- Log message with the Updated To Do Item.
622: fnd_message.set_name('IGF','IGF_AP_TODO_UPD');
623: fnd_message.set_token('ITEM',lc_item_details.description);
624: fnd_message.set_token('STATUS',igf_aw_gen.lookup_desc('IGF_TD_ITEM_STATUS',l_status));
625: FND_FILE.PUT_LINE(FND_FILE.LOG ,FND_MESSAGE.GET);
626: END IF;
627: ELSIF lb_item_present = FALSE THEN
628: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
629: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.add_to_do.debug','calling igf_ap_td_item_inst_pkg.insert_row with base_id/item_seq_number:'||l_base_id||'/'||p_todo_number);

Line 653: FND_FILE.PUT_LINE(FND_FILE.LOG ,FND_MESSAGE.GET);

649: -- Log message with the added To Do Item added to the student.
650: fnd_message.set_name('IGF','IGF_AP_TODO_ASSIGN');
651: fnd_message.set_token('ITEM',lc_item_details.description);
652: fnd_message.set_token('STATUS',igf_aw_gen.lookup_desc('IGF_TD_ITEM_STATUS',l_status));
653: FND_FILE.PUT_LINE(FND_FILE.LOG ,FND_MESSAGE.GET);
654: END IF;
655:
656: EXCEPTION
657: WHEN others THEN

Line 1008: FND_FILE.PUT_LINE(FND_FILE.LOG ,FND_MESSAGE.GET);

1004: END IF;
1005:
1006: FND_MESSAGE.SET_NAME('IGF', 'IGF_AP_TODO_ADDED');
1007: FND_MESSAGE.SET_TOKEN('COUNT', TO_CHAR(ln_item_cnt-ln_skip_items));
1008: FND_FILE.PUT_LINE(FND_FILE.LOG ,FND_MESSAGE.GET);
1009: FND_FILE.PUT_LINE(FND_FILE.LOG ,' ');
1010: FND_FILE.PUT_LINE(FND_FILE.LOG ,' ');
1011:
1012: -- Update the FA Process Stauses with the TO DO Details

Line 1009: FND_FILE.PUT_LINE(FND_FILE.LOG ,' ');

1005:
1006: FND_MESSAGE.SET_NAME('IGF', 'IGF_AP_TODO_ADDED');
1007: FND_MESSAGE.SET_TOKEN('COUNT', TO_CHAR(ln_item_cnt-ln_skip_items));
1008: FND_FILE.PUT_LINE(FND_FILE.LOG ,FND_MESSAGE.GET);
1009: FND_FILE.PUT_LINE(FND_FILE.LOG ,' ');
1010: FND_FILE.PUT_LINE(FND_FILE.LOG ,' ');
1011:
1012: -- Update the FA Process Stauses with the TO DO Details
1013: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 1010: FND_FILE.PUT_LINE(FND_FILE.LOG ,' ');

1006: FND_MESSAGE.SET_NAME('IGF', 'IGF_AP_TODO_ADDED');
1007: FND_MESSAGE.SET_TOKEN('COUNT', TO_CHAR(ln_item_cnt-ln_skip_items));
1008: FND_FILE.PUT_LINE(FND_FILE.LOG ,FND_MESSAGE.GET);
1009: FND_FILE.PUT_LINE(FND_FILE.LOG ,' ');
1010: FND_FILE.PUT_LINE(FND_FILE.LOG ,' ');
1011:
1012: -- Update the FA Process Stauses with the TO DO Details
1013: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1014: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.each_student_todo.debug','calling igf_ap_batch_ver_prc_pkg.update_process_status');

Line 1035: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

1031: END IF;
1032: -- If both Person and Person ID Group are present then return back false
1033: IF p_base_id IS NOT NULL AND p_person_id_grp IS NOT NULL THEN
1034: FND_MESSAGE.SET_NAME('IGS','IGS_FI_NO_PERS_PGRP');
1035: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1036: RETURN FALSE;
1037:
1038: ELSIF p_base_id IS NULL AND p_person_id_grp IS NULL THEN
1039: FND_MESSAGE.SET_NAME('IGS','IGS_FI_PRS_PRSIDGRP_NULL');

Line 1040: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

1036: RETURN FALSE;
1037:
1038: ELSIF p_base_id IS NULL AND p_person_id_grp IS NULL THEN
1039: FND_MESSAGE.SET_NAME('IGS','IGS_FI_PRS_PRSIDGRP_NULL');
1040: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1041: RETURN FALSE;
1042:
1043: ELSE
1044:

Line 1057: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

1053: IF p_calling_from = 'TODO' THEN
1054: FND_MESSAGE.SET_NAME('IGF','IGF_AP_PROCESSING_STUDENT');
1055: FND_MESSAGE.SET_TOKEN('PERSON_NAME',lc_person_details_rec.person_name);
1056: FND_MESSAGE.SET_TOKEN('PERSON_NUMBER',lc_person_details_rec.person_number);
1057: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1058: END IF;
1059:
1060: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1061: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_todo_grps_prc_pkg.assign_todo.debug','calling each_student_todo for base_id:'||p_base_id);

Line 1095: FND_FILE.PUT_LINE(FND_FILE.LOG,l_person_number|| ' : '|| c_person_id_grp_rec.person_number);

1091:
1092: OPEN c_get_parameters;
1093: FETCH c_get_parameters INTO l_person_number;
1094: CLOSE c_get_parameters;
1095: FND_FILE.PUT_LINE(FND_FILE.LOG,l_person_number|| ' : '|| c_person_id_grp_rec.person_number);
1096:
1097: -- Log a message and skip the student
1098: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_BASEID');
1099: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

Line 1099: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

1095: FND_FILE.PUT_LINE(FND_FILE.LOG,l_person_number|| ' : '|| c_person_id_grp_rec.person_number);
1096:
1097: -- Log a message and skip the student
1098: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_BASEID');
1099: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1100: ELSE
1101:
1102: -- log a message for the processing student.
1103: IF p_calling_from = 'TODO' THEN

Line 1107: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

1103: IF p_calling_from = 'TODO' THEN
1104: FND_MESSAGE.SET_NAME('IGF','IGF_AP_PROCESSING_STUDENT');
1105: FND_MESSAGE.SET_TOKEN('PERSON_NAME',c_person_id_grp_rec.full_name);
1106: FND_MESSAGE.SET_TOKEN('PERSON_NUMBER',c_person_id_grp_rec.person_number);
1107: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1108: END IF;
1109:
1110: -- Process the student, add TO DO to the students
1111: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 1247: FND_FILE.PUT_LINE (FND_FILE.LOG,FND_MESSAGE.GET);

1243:
1244: EXCEPTION
1245: WHEN OTHERS THEN
1246: FND_MESSAGE.SET_NAME ('IGF','IGF_AP_INVALID_QUERY');
1247: FND_FILE.PUT_LINE (FND_FILE.LOG,FND_MESSAGE.GET);
1248: RETURN;
1249: END;
1250:
1251: IF ln_stdnt_count = 0 THEN

Line 1253: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

1249: END;
1250:
1251: IF ln_stdnt_count = 0 THEN
1252: FND_MESSAGE.SET_NAME('IGF','IGF_DB_NO_PER_GRP');
1253: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1254: retcode := 0;
1255: RETURN;
1256: END IF;
1257: END IF;

Line 1289: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);

1285: END IF;
1286: EXCEPTION
1287: WHEN others THEN
1288: ROLLBACK;
1289: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
1290: RETCODE := 2 ;
1291: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1292: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_TODO_GRPS_PRC_PKG.MAIN');
1293: errbuf := FND_MESSAGE.GET ;