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_PS_GEN_008 dependencies on IGS_GE_GEN_003

Line 978: l_org_id := igs_ge_gen_003.get_org_id;

974: BEGIN
975: FOR v_unit_cat_rec IN c_unit_cat_rec LOOP
976: BEGIN
977: x_rowid := NULL;
978: l_org_id := igs_ge_gen_003.get_org_id;
979:
980: IGS_PS_UNIT_CATEGORY_PKG.Insert_Row(
981: X_ROWID => x_rowid,
982: X_UNIT_CD => p_new_unit_cd,

Line 1025: l_org_id := igs_ge_gen_003.get_org_id;

1021: FOR v_crs_unit_lvl_rec IN c_crs_unit_lvl_rec LOOP
1022: BEGIN
1023: x_rowid := NULL;
1024:
1025: l_org_id := igs_ge_gen_003.get_org_id;
1026: -- ijeddy, Bug# 3181938 removed course_type from the parameters.
1027: IGS_PS_UNIT_LVL_PKG.Insert_Row(
1028: X_ROWID => x_rowid,
1029: X_UNIT_CD => p_new_unit_cd,

Line 1190: l_org_id := igs_ge_gen_003.get_org_id;

1186: -- new IGS_PS_UNIT-version
1187: BEGIN
1188: x_rowid := NULL;
1189:
1190: l_org_id := igs_ge_gen_003.get_org_id;
1191:
1192: IGS_PS_TCH_RESP_OVRD_PKG.INSERT_ROW(
1193: X_ROWID => x_rowid,
1194: X_UNIT_CD => p_new_unit_cd,

Line 1433: l_org_id := igs_ge_gen_003.get_org_id;

1429: INTO v_new_uoo_id
1430: FROM dual;
1431: x_rowid := NULL;
1432:
1433: l_org_id := igs_ge_gen_003.get_org_id;
1434: -- Added auditable_ind, audit_permission_ind parameters to the following call to insert_row
1435: -- as part of Bug# 2636716, EN Integration by shtatiko.
1436:
1437: --bug#2768783, added the validate/generate call number logic

Line 1659: X_ORG_ID => igs_ge_gen_003.get_org_id,

1655: X_ACTION_DT => v_unit_assessment_item_rec.action_dt,
1656: X_EXAM_CAL_TYPE => v_unit_assessment_item_rec.exam_cal_type,
1657: X_EXAM_CI_SEQUENCE_NUMBER => v_unit_assessment_item_rec.exam_ci_sequence_number,
1658: X_MODE => 'R',
1659: X_ORG_ID => igs_ge_gen_003.get_org_id,
1660: X_GRADING_SCHEMA_CD => v_unit_assessment_item_rec.grading_schema_cd,
1661: X_GS_VERSION_NUMBER => v_unit_assessment_item_rec.gs_version_number,
1662: X_RELEASE_DATE => v_unit_assessment_item_rec.release_date,
1663: X_UNIT_ASS_ITEM_ID => l_unit_ass_item_id, --out parameter

Line 1875: l_org_id := igs_ge_gen_003.get_org_id;

1871: END IF;
1872: CLOSE c_unit_offer_pat_rec;
1873: x_rowid := NULL;
1874:
1875: l_org_id := igs_ge_gen_003.get_org_id;
1876:
1877: IGS_PS_UNIT_OFR_PAT_PKG.INSERT_ROW(
1878: X_ROWID => x_rowid,
1879: X_UNIT_CD => p_new_unit_cd,

Line 2614: -- jbegum As part of bug#2563596 the call to IGS_GE_GEN_003.genp_ins_log_entry was modified .

2610: l_d_us_dest_end_dt DATE;
2611:
2612: l_c_usec_status igs_ps_unit_ofr_opt_all.unit_section_status%TYPE;
2613:
2614: -- jbegum As part of bug#2563596 the call to IGS_GE_GEN_003.genp_ins_log_entry was modified .
2615: -- The concatenated string being passed to parameter p_key has the substring FND_MESSAGE.GET_STRING('IGS', l_message_name)
2616: -- removed as this was causing the TBH procedure IGS_GE_S_LOG_ENTRY_PKG.INSERT_ROW to throw up an invalid value error,which
2617: -- was in turn causing function IGS_PS_GEN_008.crsp_ins_uop_uoo to throw up an unhandled exception.
2618: -- Also the concatenated string being passed to parameter p_text has only l_message_name concatenated to it instead of

Line 2647: igs_ge_gen_003.genp_ins_log_entry (

2643: OPEN cur_org_unit (p_old_uoo_id);
2644: FETCH cur_org_unit INTO lcur_org_unit;
2645: CLOSE cur_org_unit;
2646:
2647: igs_ge_gen_003.genp_ins_log_entry (
2648: 'USEC-ROLL' , --This s_log_type
2649: p_log_creation_date, -- This will be accepted AS parameter AND defaulted TO NULL;
2650: lcur_org_unit.owner_org_unit_cd || ',' || p_old_uoo_id || ',' || p_source_cal_type ||
2651: ',' || p_source_ci_sequence_number, --This is the key

Line 3114: -- an insert is happening into igs_ge_s_log table thru a call to IGS_GE_GEN_003.genp_ins_log.The same creation date is being

3110: CLOSE c_uop_dest_rec;
3111:
3112: -- Added by jbegum as part of bug #2563596
3113: -- The package IGS_PS_GEN_006 has a call to IGS_PS_GEN_008.crsp_ins_uop_uoo.Before this call in the package IGS_PS_GEN_006
3114: -- an insert is happening into igs_ge_s_log table thru a call to IGS_GE_GEN_003.genp_ins_log.The same creation date is being
3115: -- passed to the call of IGS_PS_GEN_008.crsp_ins_uop_uoo.Hence added code here to check for existence of the record in
3116: -- igs_ge_s_log table before inserting into it.Thus preventing the error 'Record already exists' being thrown up as unhandled
3117: -- exception by the procedure IGS_PS_GEN_006.crsp_ins_ci_uop_uoo
3118:

Line 3201: l_org_id := igs_ge_gen_003.get_org_id;

3197: CLOSE c_uoo_seq_num;
3198:
3199: -- insert the IGS_PS_UNIT_OFR_OPT record, with this next uoo_id
3200: x_rowid := NULL;
3201: l_org_id := igs_ge_gen_003.get_org_id;
3202:
3203:
3204: --bug#2768783, added the validate/generate call number logic
3205:

Line 3525: x_org_id => igs_ge_gen_003.get_org_id,

3521: x_action_dt => NULL,
3522: x_exam_cal_type => v_exam_cal_type,
3523: x_exam_ci_sequence_number => v_exam_ci_sequence_number,
3524: x_mode => 'R',
3525: x_org_id => igs_ge_gen_003.get_org_id,
3526: x_grading_schema_cd => v_uai_rec.grading_schema_cd,
3527: x_gs_version_number => v_uai_rec.gs_version_number,
3528: x_release_date => v_uai_rec.release_date,
3529: x_unit_ass_item_id => l_unit_ass_item_id, --out parameter

Line 3856: -- jbegum As part of bug#2563596 the call to IGS_GE_GEN_003.genp_ins_log_entry was modified .

3852: END IF;
3853: App_Exception.Raise_Exception;
3854: END;
3855:
3856: -- jbegum As part of bug#2563596 the call to IGS_GE_GEN_003.genp_ins_log_entry was modified .
3857: -- The concatenated string being passed to parameter p_key has the substring FND_MESSAGE.GET_STRING('IGS', p_message_name)
3858: -- removed as this was causing the TBH procedure IGS_GE_S_LOG_ENTRY_PKG.INSERT_ROW to throw up an invalid value error,which
3859: -- was in turn causing function IGS_PS_GEN_008.crsp_ins_uop_uoo to throw up an unhandled exception.
3860: -- Also the concatenated string being passed to parameter p_text has only p_message_name concatenated to it instead of

Line 3885: IGS_GE_GEN_003.genp_ins_log_entry (

3881:
3882: OPEN cur_org_unit (l_old_uoo_id);
3883: FETCH cur_org_unit INTO lcur_org_unit;
3884:
3885: IGS_GE_GEN_003.genp_ins_log_entry (
3886: 'USEC-ROLL' ,
3887: p_log_creation_date, -- This will be accepted AS parameter AND defaulted TO NULL;
3888: lcur_org_unit.owner_org_unit_cd || ',' || l_old_uoo_id || ',' || p_source_cal_type ||
3889: ',' || p_source_ci_sequence_number,