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 IGF_AW_GEN

Line 176: lv_status_pmpt := igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','STATUS');

172:
173: BEGIN
174:
175: -- Set all the Prompts for the Input Parameters
176: lv_status_pmpt := igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','STATUS');
177:
178: OPEN c_get_parameters;
179: LOOP
180: FETCH c_get_parameters INTO parameter_rec;

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 624: fnd_message.set_token('STATUS',igf_aw_gen.lookup_desc('IGF_TD_ITEM_STATUS',l_status));

620:
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

Line 652: fnd_message.set_token('STATUS',igf_aw_gen.lookup_desc('IGF_TD_ITEM_STATUS',l_status));

648:
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

Line 1180: || tsailaja 13/Jan/2006 Bug 4947880 Added invocation of igf_aw_gen.set_org_id(NULL);

1176: || Known limitations, enhancements or remarks :
1177: || Change History :
1178: || Who When What
1179: || ridas 07-Feb-2006 Bug #5021084. Added new parameter 'lv_group_type' in call to igf_ap_ss_pkg.get_pid
1180: || tsailaja 13/Jan/2006 Bug 4947880 Added invocation of igf_aw_gen.set_org_id(NULL);
1181: || bvisvana 21-Jun-2005 Signature of main is changed to include status from 1 to 15
1182: || log_input_params and assign_todo signature changed
1183: || (reverse chronological order - newest change first)
1184: */

Line 1197: igf_aw_gen.set_org_id(NULL);

1193: lv_group_type igs_pe_persid_group_v.group_type%TYPE;
1194: lv_sql_stmt VARCHAR(32767) := igf_ap_ss_pkg.get_pid(p_person_id_grp,lv_status,lv_group_type);
1195:
1196: BEGIN
1197: igf_aw_gen.set_org_id(NULL);
1198: retcode := 0;
1199:
1200: -- Get the Award Year Calender Type and the Sequence Number for processing the students in context with the given Award Year.
1201: lv_ci_cal_type := RTRIM(SUBSTR(p_award_year,1,10));