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.IGS_AS_GEN_007 dependencies on IGS_GE_GEN_003

Line 251: igs_ge_gen_003.genp_ins_log ('ASS3610', NULL, v_log_dt);

247: || v_uai_unit_mode
248: || '|'
249: || v_uai_location_cd;
250: IF (gv_log_created = FALSE) THEN
251: igs_ge_gen_003.genp_ins_log ('ASS3610', NULL, v_log_dt);
252: gv_log_created := TRUE;
253: -- Insert into the IGS_GE_S_LOG_ENTRY table
254: igs_ge_gen_003.genp_ins_log_entry ('ASS3610', v_log_dt, 'NO_DUE_DT', NULL, v_record);
255: ELSE

Line 254: igs_ge_gen_003.genp_ins_log_entry ('ASS3610', v_log_dt, 'NO_DUE_DT', NULL, v_record);

250: IF (gv_log_created = FALSE) THEN
251: igs_ge_gen_003.genp_ins_log ('ASS3610', NULL, v_log_dt);
252: gv_log_created := TRUE;
253: -- Insert into the IGS_GE_S_LOG_ENTRY table
254: igs_ge_gen_003.genp_ins_log_entry ('ASS3610', v_log_dt, 'NO_DUE_DT', NULL, v_record);
255: ELSE
256: -- Only insert if a log entry not already exists.
257: OPEN c_sle (v_log_dt, 'NO_DUE_DT', v_record);
258: FETCH c_sle INTO v_check;

Line 260: igs_ge_gen_003.genp_ins_log_entry ('ASS3610', v_log_dt, 'NO_DUE_DT', NULL, v_record);

256: -- Only insert if a log entry not already exists.
257: OPEN c_sle (v_log_dt, 'NO_DUE_DT', v_record);
258: FETCH c_sle INTO v_check;
259: IF (c_sle%NOTFOUND) THEN
260: igs_ge_gen_003.genp_ins_log_entry ('ASS3610', v_log_dt, 'NO_DUE_DT', NULL, v_record);
261: END IF;
262: CLOSE c_sle;
263: END IF;
264: ELSE

Line 297: igs_ge_gen_003.genp_ins_log ('ASS3610', NULL, v_log_dt); -- out NOCOPY

293: || v_uai_unit_mode
294: || '|'
295: || v_uai_location_cd;
296: IF gv_log_created = FALSE THEN
297: igs_ge_gen_003.genp_ins_log ('ASS3610', NULL, v_log_dt); -- out NOCOPY
298: gv_log_created := TRUE;
299: -- Insert into the IGS_GE_S_LOG_ENTRY table.
300: igs_ge_gen_003.genp_ins_log_entry ('ASS3610', v_log_dt, 'EARLY_DUE_DT', NULL, v_record);
301: ELSE

Line 300: igs_ge_gen_003.genp_ins_log_entry ('ASS3610', v_log_dt, 'EARLY_DUE_DT', NULL, v_record);

296: IF gv_log_created = FALSE THEN
297: igs_ge_gen_003.genp_ins_log ('ASS3610', NULL, v_log_dt); -- out NOCOPY
298: gv_log_created := TRUE;
299: -- Insert into the IGS_GE_S_LOG_ENTRY table.
300: igs_ge_gen_003.genp_ins_log_entry ('ASS3610', v_log_dt, 'EARLY_DUE_DT', NULL, v_record);
301: ELSE
302: -- Check to see if a log entry already exists for this
303: -- assessment item indicating that the due date is earlier
304: -- than the tracking start date..

Line 311: igs_ge_gen_003.genp_ins_log_entry ('ASS3610', v_log_dt, 'EARLY_DUE_DT', NULL, v_record);

307: -- If no record found then insert the entry,
308: -- otherwise do nothing.
309: IF (c_sle%NOTFOUND) THEN
310: CLOSE c_sle;
311: igs_ge_gen_003.genp_ins_log_entry ('ASS3610', v_log_dt, 'EARLY_DUE_DT', NULL, v_record);
312: ELSE
313: CLOSE c_sle;
314: END IF;
315: END IF;

Line 371: igs_ge_gen_003.genp_ins_log ('ASS3610', NULL, v_log_dt); -- out NOCOPY

367: || v_uai_unit_mode
368: || '|'
369: || v_uai_location_cd;
370: IF gv_log_created = FALSE THEN
371: igs_ge_gen_003.genp_ins_log ('ASS3610', NULL, v_log_dt); -- out NOCOPY
372: gv_log_created := TRUE;
373: -- Insert into the IGS_GE_S_LOG_ENTRY table.
374: igs_ge_gen_003.genp_ins_log_entry ('ASS3610', v_log_dt, 'TRI_ERROR', v_message_name, v_record);
375: ELSE

Line 374: igs_ge_gen_003.genp_ins_log_entry ('ASS3610', v_log_dt, 'TRI_ERROR', v_message_name, v_record);

370: IF gv_log_created = FALSE THEN
371: igs_ge_gen_003.genp_ins_log ('ASS3610', NULL, v_log_dt); -- out NOCOPY
372: gv_log_created := TRUE;
373: -- Insert into the IGS_GE_S_LOG_ENTRY table.
374: igs_ge_gen_003.genp_ins_log_entry ('ASS3610', v_log_dt, 'TRI_ERROR', v_message_name, v_record);
375: ELSE
376: -- Check to see if a log entry already exists for
377: -- this assessment item indicating that the due date
378: -- is earlier than the tracking start date..

Line 384: igs_ge_gen_003.genp_ins_log_entry ('ASS3610', v_log_dt, 'TRI_ERROR', v_message_name, v_record);

380: FETCH c_sle INTO v_check;
381: -- If no record found then insert the entry,
382: -- otherwise do nothing.
383: IF (c_sle%NOTFOUND) THEN
384: igs_ge_gen_003.genp_ins_log_entry ('ASS3610', v_log_dt, 'TRI_ERROR', v_message_name, v_record);
385: CLOSE c_sle;
386: END IF;
387: CLOSE c_sle;
388: END IF;

Line 485: igs_ge_gen_003.genp_ins_log ('ASS3610', NULL, v_log_dt); -- out NOCOPY

481: || v_uai_unit_mode
482: || '|'
483: || v_uai_location_cd;
484: IF gv_log_created = FALSE THEN
485: igs_ge_gen_003.genp_ins_log ('ASS3610', NULL, v_log_dt); -- out NOCOPY
486: gv_log_created := TRUE;
487: -- Insert into the IGS_GE_S_LOG_ENTRY table.
488: igs_ge_gen_003.genp_ins_log_entry ('ASS3610', v_log_dt, 'STEP_DUE_DT', v_message_name, v_record);
489: ELSE

Line 488: igs_ge_gen_003.genp_ins_log_entry ('ASS3610', v_log_dt, 'STEP_DUE_DT', v_message_name, v_record);

484: IF gv_log_created = FALSE THEN
485: igs_ge_gen_003.genp_ins_log ('ASS3610', NULL, v_log_dt); -- out NOCOPY
486: gv_log_created := TRUE;
487: -- Insert into the IGS_GE_S_LOG_ENTRY table.
488: igs_ge_gen_003.genp_ins_log_entry ('ASS3610', v_log_dt, 'STEP_DUE_DT', v_message_name, v_record);
489: ELSE
490: -- Check to see if a log entry already exists for this
491: -- assessment item indicating that the due date is
492: -- earlier than the tracking start date..

Line 498: igs_ge_gen_003.genp_ins_log_entry ('ASS3610', v_log_dt, 'STEP_DUE_DT', v_message_name, v_record);

494: FETCH c_sle INTO v_check;
495: -- If no record found then insert the entry,
496: -- otherwise do nothing.
497: IF (c_sle%NOTFOUND) THEN
498: igs_ge_gen_003.genp_ins_log_entry ('ASS3610', v_log_dt, 'STEP_DUE_DT', v_message_name, v_record);
499: CLOSE c_sle;
500: END IF;
501: CLOSE c_sle;
502: END IF;

Line 602: igs_ge_gen_003.genp_ins_log ('ASS3610', NULL, v_log_dt); -- out NOCOPY

598: || v_uai_reference
599: || '|'
600: || SUBSTR (igs_ge_date.igschardt (v_suaai_rec.creation_dt), 1, 18);
601: IF gv_log_created = FALSE THEN
602: igs_ge_gen_003.genp_ins_log ('ASS3610', NULL, v_log_dt); -- out NOCOPY
603: gv_log_created := TRUE;
604: END IF;
605: -- Insert into the IGS_GE_S_LOG_ENTRY table.
606: igs_ge_gen_003.genp_ins_log_entry ('ASS3610', v_log_dt, 'SUAAI_LOCK', NULL, v_record);

Line 606: igs_ge_gen_003.genp_ins_log_entry ('ASS3610', v_log_dt, 'SUAAI_LOCK', NULL, v_record);

602: igs_ge_gen_003.genp_ins_log ('ASS3610', NULL, v_log_dt); -- out NOCOPY
603: gv_log_created := TRUE;
604: END IF;
605: -- Insert into the IGS_GE_S_LOG_ENTRY table.
606: igs_ge_gen_003.genp_ins_log_entry ('ASS3610', v_log_dt, 'SUAAI_LOCK', NULL, v_record);
607: WHEN OTHERS THEN
608: RAISE;
609: END; -- sub block
610: END IF; -- IF create item

Line 730: l_org_id := igs_ge_gen_003.get_org_id;

726: x_rowid VARCHAR2 (25);
727: l_org_id NUMBER (15);
728: BEGIN
729: --get org id
730: l_org_id := igs_ge_gen_003.get_org_id;
731: -- This is Added by DDEY as a part of Bug # 2370562
732: -- remove one second from the hist_start_dt value
733: -- when the hist_start_dt and hist_end_dt are the same
734: -- to avoid a primary key constraint from occurring

Line 1046: IF igs_ge_gen_003.genp_upd_str_lgc_del (

1042: -- logically delete the IGS_PE_STD_TODO entry.
1043: -- If a lock occurs on the item, rollback the whole event for
1044: -- this todo item. (Will also need a commit so that it can be restartable.)
1045: --
1046: IF igs_ge_gen_003.genp_upd_str_lgc_del (
1047: v_todo_rec.person_id,
1048: v_todo_rec.s_student_todo_type,
1049: v_todo_rec.sequence_number,
1050: v_todo_rec.reference_number,

Line 1087: igs_ge_gen_003.genp_set_sle_count (

1083: v_record := cst_error_count;
1084: --
1085: -- Increment the count of errors.
1086: --
1087: igs_ge_gen_003.genp_set_sle_count (
1088: cst_ass3212,
1089: v_key,
1090: v_record,
1091: 'IGS_AS_TOTAL_ERRO_COUNT', -- message number - Total errors.

Line 1100: igs_ge_gen_003.genp_set_sle_count (

1096: v_record := cst_warning_count;
1097: --
1098: -- Increment the count of errors.
1099: --
1100: igs_ge_gen_003.genp_set_sle_count (
1101: cst_ass3212,
1102: v_key,
1103: v_record,
1104: 'IGS_AS_TOTAL_WRNG_COUNT', -- message number - Total errors.

Line 1123: igs_ge_gen_003.genp_set_sle_count (

1119: || TO_CHAR (v_todo_rec.uoo_id);
1120: --
1121: -- Increment the count of students per unit.
1122: --
1123: igs_ge_gen_003.genp_set_sle_count (
1124: cst_ass3212,
1125: v_key,
1126: v_record,
1127: 'IGS_AS_TOTAL_STUD_PROCESSED', -- message number

Line 1724: igs_ge_gen_003.genp_set_sle_count (

1720: -- Create any Exception records.
1721: igs_ge_ins_sle.genp_ins_sle (v_creation_dt);
1722: v_record := cst_error_item_count;
1723: -- Increment the count of errors.
1724: igs_ge_gen_003.genp_set_sle_count (
1725: cst_ass3213,
1726: v_key,
1727: v_record,
1728: 'IGS_AS_TOTAL_ERRO_COUNT', -- message number - Total errors.

Line 1735: igs_ge_gen_003.genp_set_sle_count (

1731: v_total_count
1732: );
1733: v_record := cst_warn_item_count;
1734: -- Increment the count of errors.
1735: igs_ge_gen_003.genp_set_sle_count (
1736: cst_ass3213,
1737: v_key,
1738: v_record,
1739: 'IGS_AS_TOTAL_WRNG_COUNT', -- message number - Total errors.

Line 1746: igs_ge_gen_003.genp_set_sle_count (

1742: v_total_count
1743: );
1744: v_record := cst_unit_item_count;
1745: -- Increment the count of unit assessment items processed.
1746: igs_ge_gen_003.genp_set_sle_count (
1747: cst_ass3213,
1748: v_key,
1749: v_record,
1750: 'IGS_AS_TOTAL_UNIT_ASSITEM', -- message number

Line 1896: v_return_val := igs_ge_gen_003.genp_ins_stdnt_todo (p_person_id, v_s_student_todo_type, SYSDATE, cst_yes);

1892: v_s_student_todo_type := cst_ass_change;
1893: v_todo_flag := TRUE;
1894: END IF;
1895: IF (v_todo_flag = TRUE) THEN
1896: v_return_val := igs_ge_gen_003.genp_ins_stdnt_todo (p_person_id, v_s_student_todo_type, SYSDATE, cst_yes);
1897: DECLARE
1898: l_val NUMBER;
1899: lv_rowid VARCHAR2 (25);
1900: BEGIN