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_CA_INS_ROLL_CI dependencies on IGS_GE_S_LOG_ENTRY

Line 200: cp_s_log_type IGS_GE_S_LOG_ENTRY.s_log_type%TYPE,

196: SELECT *
197: FROM IGS_CA_STAT
198: WHERE CAL_STATUS = cp_cal_status;
199: CURSOR c_s_log_entry_dai(
200: cp_s_log_type IGS_GE_S_LOG_ENTRY.s_log_type%TYPE,
201: cp_creation_dt IGS_GE_S_LOG_ENTRY.creation_dt%TYPE,
202: cp_key IGS_GE_S_LOG_ENTRY.key%TYPE,
203: cp_text IGS_GE_S_LOG_ENTRY.text%TYPE) IS
204: SELECT *

Line 201: cp_creation_dt IGS_GE_S_LOG_ENTRY.creation_dt%TYPE,

197: FROM IGS_CA_STAT
198: WHERE CAL_STATUS = cp_cal_status;
199: CURSOR c_s_log_entry_dai(
200: cp_s_log_type IGS_GE_S_LOG_ENTRY.s_log_type%TYPE,
201: cp_creation_dt IGS_GE_S_LOG_ENTRY.creation_dt%TYPE,
202: cp_key IGS_GE_S_LOG_ENTRY.key%TYPE,
203: cp_text IGS_GE_S_LOG_ENTRY.text%TYPE) IS
204: SELECT *
205: FROM IGS_GE_S_LOG_ENTRY

Line 202: cp_key IGS_GE_S_LOG_ENTRY.key%TYPE,

198: WHERE CAL_STATUS = cp_cal_status;
199: CURSOR c_s_log_entry_dai(
200: cp_s_log_type IGS_GE_S_LOG_ENTRY.s_log_type%TYPE,
201: cp_creation_dt IGS_GE_S_LOG_ENTRY.creation_dt%TYPE,
202: cp_key IGS_GE_S_LOG_ENTRY.key%TYPE,
203: cp_text IGS_GE_S_LOG_ENTRY.text%TYPE) IS
204: SELECT *
205: FROM IGS_GE_S_LOG_ENTRY
206: WHERE s_log_type = cp_s_log_type

Line 203: cp_text IGS_GE_S_LOG_ENTRY.text%TYPE) IS

199: CURSOR c_s_log_entry_dai(
200: cp_s_log_type IGS_GE_S_LOG_ENTRY.s_log_type%TYPE,
201: cp_creation_dt IGS_GE_S_LOG_ENTRY.creation_dt%TYPE,
202: cp_key IGS_GE_S_LOG_ENTRY.key%TYPE,
203: cp_text IGS_GE_S_LOG_ENTRY.text%TYPE) IS
204: SELECT *
205: FROM IGS_GE_S_LOG_ENTRY
206: WHERE s_log_type = cp_s_log_type
207: AND creation_dt = cp_creation_dt

Line 205: FROM IGS_GE_S_LOG_ENTRY

201: cp_creation_dt IGS_GE_S_LOG_ENTRY.creation_dt%TYPE,
202: cp_key IGS_GE_S_LOG_ENTRY.key%TYPE,
203: cp_text IGS_GE_S_LOG_ENTRY.text%TYPE) IS
204: SELECT *
205: FROM IGS_GE_S_LOG_ENTRY
206: WHERE s_log_type = cp_s_log_type
207: AND creation_dt = cp_creation_dt
208: AND key = cp_key
209: AND text = cp_text;

Line 210: v_sled_rec IGS_GE_S_LOG_ENTRY%ROWTYPE;

206: WHERE s_log_type = cp_s_log_type
207: AND creation_dt = cp_creation_dt
208: AND key = cp_key
209: AND text = cp_text;
210: v_sled_rec IGS_GE_S_LOG_ENTRY%ROWTYPE;
211: CURSOR IGS_GE_S_LOG_ENTRY_CUR is
212: SELECT ROWID
213: FROM IGS_GE_S_LOG_ENTRY
214: WHERE s_log_type = gv_log_type

Line 211: CURSOR IGS_GE_S_LOG_ENTRY_CUR is

207: AND creation_dt = cp_creation_dt
208: AND key = cp_key
209: AND text = cp_text;
210: v_sled_rec IGS_GE_S_LOG_ENTRY%ROWTYPE;
211: CURSOR IGS_GE_S_LOG_ENTRY_CUR is
212: SELECT ROWID
213: FROM IGS_GE_S_LOG_ENTRY
214: WHERE s_log_type = gv_log_type
215: AND creation_dt = gv_log_creation_dt

Line 213: FROM IGS_GE_S_LOG_ENTRY

209: AND text = cp_text;
210: v_sled_rec IGS_GE_S_LOG_ENTRY%ROWTYPE;
211: CURSOR IGS_GE_S_LOG_ENTRY_CUR is
212: SELECT ROWID
213: FROM IGS_GE_S_LOG_ENTRY
214: WHERE s_log_type = gv_log_type
215: AND creation_dt = gv_log_creation_dt
216: AND key = gv_log_key
217: AND text = v_other_detail;

Line 468: -- Delete IGS_GE_S_LOG_ENTRY for DAIP if it exists.

464: p_ci_sequence_number) LOOP
465: v_dairn_start_dt := v_cal_instance_rec.start_dt;
466: v_dairn_end_dt := v_cal_instance_rec.end_dt;
467: END LOOP;
468: -- Delete IGS_GE_S_LOG_ENTRY for DAIP if it exists.
469:
470:
471: token1_val := p_cal_type|| '|'||p_ci_sequence_number|| '|' ||p_val_dt_alias||
472: '|' || p_val_dai_sequence_number||'|';

Line 538: for v_IGS_GE_S_LOG_ENTRY_CUR in IGS_GE_S_LOG_ENTRY_CUR loop

534: ELSE
535: CLOSE c_s_log_entry_dai;
536:
537:
538: for v_IGS_GE_S_LOG_ENTRY_CUR in IGS_GE_S_LOG_ENTRY_CUR loop
539: IGS_GE_S_LOG_ENTRY_PKG.DELETE_ROW(v_IGS_GE_S_LOG_ENTRY_CUR.ROWID);
540: end loop;
541:
542:

Line 539: IGS_GE_S_LOG_ENTRY_PKG.DELETE_ROW(v_IGS_GE_S_LOG_ENTRY_CUR.ROWID);

535: CLOSE c_s_log_entry_dai;
536:
537:
538: for v_IGS_GE_S_LOG_ENTRY_CUR in IGS_GE_S_LOG_ENTRY_CUR loop
539: IGS_GE_S_LOG_ENTRY_PKG.DELETE_ROW(v_IGS_GE_S_LOG_ENTRY_CUR.ROWID);
540: end loop;
541:
542:
543: END IF;

Line 548: for v_IGS_GE_S_LOG_ENTRY_CUR in IGS_GE_S_LOG_ENTRY_CUR loop

544: ELSE
545: CLOSE c_s_log_entry_dai;
546:
547:
548: for v_IGS_GE_S_LOG_ENTRY_CUR in IGS_GE_S_LOG_ENTRY_CUR loop
549: IGS_GE_S_LOG_ENTRY_PKG.DELETE_ROW(v_IGS_GE_S_LOG_ENTRY_CUR.ROWID);
550: end loop;
551:
552:

Line 549: IGS_GE_S_LOG_ENTRY_PKG.DELETE_ROW(v_IGS_GE_S_LOG_ENTRY_CUR.ROWID);

545: CLOSE c_s_log_entry_dai;
546:
547:
548: for v_IGS_GE_S_LOG_ENTRY_CUR in IGS_GE_S_LOG_ENTRY_CUR loop
549: IGS_GE_S_LOG_ENTRY_PKG.DELETE_ROW(v_IGS_GE_S_LOG_ENTRY_CUR.ROWID);
550: end loop;
551:
552:
553: END IF;

Line 782: v_sled_rec IGS_GE_S_LOG_ENTRY%ROWTYPE;

778: v_ins_offset_dt_alias IGS_CA_DA_INST.DT_ALIAS%TYPE;
779: v_ins_offset_dai_seq_num IGS_CA_DA_INST.sequence_number%TYPE;
780: v_ins_offset_cal_type IGS_CA_DA_INST.CAL_TYPE%TYPE;
781: v_ins_offset_ci_seq_num IGS_CA_DA_INST.ci_sequence_number%TYPE;
782: v_sled_rec IGS_GE_S_LOG_ENTRY%ROWTYPE;
783: CURSOR c_new_dt_alias_instance(
784: cp_dt_alias IGS_CA_DA_INST_V.DT_ALIAS%TYPE,
785: cp_cal_type IGS_CA_DA_INST_V.CAL_TYPE%TYPE,
786: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE) IS

Line 814: cp_s_log_type IGS_GE_S_LOG_ENTRY.s_log_type%TYPE,

810: SELECT *
811: FROM IGS_CA_STAT
812: WHERE CAL_STATUS = cp_cal_status;
813: CURSOR c_s_log_entry_dai(
814: cp_s_log_type IGS_GE_S_LOG_ENTRY.s_log_type%TYPE,
815: cp_creation_dt IGS_GE_S_LOG_ENTRY.creation_dt%TYPE,
816: cp_key IGS_GE_S_LOG_ENTRY.key%TYPE,
817: cp_text IGS_GE_S_LOG_ENTRY.text%TYPE) IS
818: SELECT *

Line 815: cp_creation_dt IGS_GE_S_LOG_ENTRY.creation_dt%TYPE,

811: FROM IGS_CA_STAT
812: WHERE CAL_STATUS = cp_cal_status;
813: CURSOR c_s_log_entry_dai(
814: cp_s_log_type IGS_GE_S_LOG_ENTRY.s_log_type%TYPE,
815: cp_creation_dt IGS_GE_S_LOG_ENTRY.creation_dt%TYPE,
816: cp_key IGS_GE_S_LOG_ENTRY.key%TYPE,
817: cp_text IGS_GE_S_LOG_ENTRY.text%TYPE) IS
818: SELECT *
819: FROM IGS_GE_S_LOG_ENTRY

Line 816: cp_key IGS_GE_S_LOG_ENTRY.key%TYPE,

812: WHERE CAL_STATUS = cp_cal_status;
813: CURSOR c_s_log_entry_dai(
814: cp_s_log_type IGS_GE_S_LOG_ENTRY.s_log_type%TYPE,
815: cp_creation_dt IGS_GE_S_LOG_ENTRY.creation_dt%TYPE,
816: cp_key IGS_GE_S_LOG_ENTRY.key%TYPE,
817: cp_text IGS_GE_S_LOG_ENTRY.text%TYPE) IS
818: SELECT *
819: FROM IGS_GE_S_LOG_ENTRY
820: WHERE s_log_type = cp_s_log_type

Line 817: cp_text IGS_GE_S_LOG_ENTRY.text%TYPE) IS

813: CURSOR c_s_log_entry_dai(
814: cp_s_log_type IGS_GE_S_LOG_ENTRY.s_log_type%TYPE,
815: cp_creation_dt IGS_GE_S_LOG_ENTRY.creation_dt%TYPE,
816: cp_key IGS_GE_S_LOG_ENTRY.key%TYPE,
817: cp_text IGS_GE_S_LOG_ENTRY.text%TYPE) IS
818: SELECT *
819: FROM IGS_GE_S_LOG_ENTRY
820: WHERE s_log_type = cp_s_log_type
821: AND creation_dt = cp_creation_dt

Line 819: FROM IGS_GE_S_LOG_ENTRY

815: cp_creation_dt IGS_GE_S_LOG_ENTRY.creation_dt%TYPE,
816: cp_key IGS_GE_S_LOG_ENTRY.key%TYPE,
817: cp_text IGS_GE_S_LOG_ENTRY.text%TYPE) IS
818: SELECT *
819: FROM IGS_GE_S_LOG_ENTRY
820: WHERE s_log_type = cp_s_log_type
821: AND creation_dt = cp_creation_dt
822: AND key = cp_key
823: AND text = cp_text;

Line 824: CURSOR IGS_GE_S_LOG_ENTRY_CUR is

820: WHERE s_log_type = cp_s_log_type
821: AND creation_dt = cp_creation_dt
822: AND key = cp_key
823: AND text = cp_text;
824: CURSOR IGS_GE_S_LOG_ENTRY_CUR is
825: SELECT ROWID
826: FROM IGS_GE_S_LOG_ENTRY
827: WHERE s_log_type = gv_log_type
828: AND creation_dt = gv_log_creation_dt

Line 826: FROM IGS_GE_S_LOG_ENTRY

822: AND key = cp_key
823: AND text = cp_text;
824: CURSOR IGS_GE_S_LOG_ENTRY_CUR is
825: SELECT ROWID
826: FROM IGS_GE_S_LOG_ENTRY
827: WHERE s_log_type = gv_log_type
828: AND creation_dt = gv_log_creation_dt
829: AND key = gv_log_key
830: AND text = v_other_detail;

Line 1126: -- Delete IGS_GE_S_LOG_ENTRY for DAI if it exists.

1122: p_ci_sequence_number) LOOP
1123: v_dairn_start_dt := v_cal_instance_rec.start_dt;
1124: v_dairn_end_dt := v_cal_instance_rec.end_dt;
1125: END LOOP;
1126: -- Delete IGS_GE_S_LOG_ENTRY for DAI if it exists.
1127:
1128: token1_val := p_cal_type|| '|'||p_ci_sequence_number|| '|' ||p_val_dt_alias||
1129: '|' || p_val_dai_sequence_number||'|';
1130:

Line 1195: for v_IGS_GE_S_LOG_ENTRY_CUR in IGS_GE_S_LOG_ENTRY_CUR loop

1191: ELSE
1192: CLOSE c_s_log_entry_dai;
1193:
1194:
1195: for v_IGS_GE_S_LOG_ENTRY_CUR in IGS_GE_S_LOG_ENTRY_CUR loop
1196: IGS_GE_S_LOG_ENTRY_PKG.DELETE_ROW(v_IGS_GE_S_LOG_ENTRY_CUR.ROWID);
1197: end loop;
1198:
1199:

Line 1196: IGS_GE_S_LOG_ENTRY_PKG.DELETE_ROW(v_IGS_GE_S_LOG_ENTRY_CUR.ROWID);

1192: CLOSE c_s_log_entry_dai;
1193:
1194:
1195: for v_IGS_GE_S_LOG_ENTRY_CUR in IGS_GE_S_LOG_ENTRY_CUR loop
1196: IGS_GE_S_LOG_ENTRY_PKG.DELETE_ROW(v_IGS_GE_S_LOG_ENTRY_CUR.ROWID);
1197: end loop;
1198:
1199:
1200:

Line 1206: for v_IGS_GE_S_LOG_ENTRY_CUR in IGS_GE_S_LOG_ENTRY_CUR loop

1202: ELSE
1203: CLOSE c_s_log_entry_dai;
1204:
1205:
1206: for v_IGS_GE_S_LOG_ENTRY_CUR in IGS_GE_S_LOG_ENTRY_CUR loop
1207: IGS_GE_S_LOG_ENTRY_PKG.DELETE_ROW(v_IGS_GE_S_LOG_ENTRY_CUR.ROWID);
1208: end loop;
1209:
1210:

Line 1207: IGS_GE_S_LOG_ENTRY_PKG.DELETE_ROW(v_IGS_GE_S_LOG_ENTRY_CUR.ROWID);

1203: CLOSE c_s_log_entry_dai;
1204:
1205:
1206: for v_IGS_GE_S_LOG_ENTRY_CUR in IGS_GE_S_LOG_ENTRY_CUR loop
1207: IGS_GE_S_LOG_ENTRY_PKG.DELETE_ROW(v_IGS_GE_S_LOG_ENTRY_CUR.ROWID);
1208: end loop;
1209:
1210:
1211: END IF;

Line 1323: -- instance rollover process. Notes are inserted into IGS_GE_S_LOG_ENTRY

1319: l_prog_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_dai';
1320: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_dai.start';
1321:
1322: -- Rollover date alias instances and their offsets as part of the calendar
1323: -- instance rollover process. Notes are inserted into IGS_GE_S_LOG_ENTRY
1324: -- so that if a date alias instance cannot be inserted, it can be reported.
1325: -- Insert new dt_alias_instances for the calendar instance.
1326: FOR c_dt_alias_instance_rec IN c_dt_alias_instance(
1327: p_cal_type,

Line 1610: -- instances. Notes are inserted into IGS_GE_S_LOG_ENTRY so that

1606: BEGIN -- calp_ins_rollvr_cir
1607: -- Insert calendar instance relationships as part of the calendar instance
1608: -- rollover process. This function takes the relationships of the existing
1609: -- calendar instance and tries to duplicate them for the new calendar
1610: -- instances. Notes are inserted into IGS_GE_S_LOG_ENTRY so that
1611: -- relationships that cannot be inserted, can be reported.
1612: --Insert superior passed. This is the superior passed from CALF0320 and is
1613: -- validated in the form logic.
1614: DECLARE

Line 1678: cp_s_log_type IGS_GE_S_LOG_ENTRY.s_log_type%TYPE,

1674: cir.sup_ci_sequence_number = cp_sup_ci_sequence_number;
1675: p_rowid VARCHAR2(25);
1676: p_val VARCHAR2(1);
1677: CURSOR c_s_log_entry_cir(
1678: cp_s_log_type IGS_GE_S_LOG_ENTRY.s_log_type%TYPE,
1679: cp_creation_dt IGS_GE_S_LOG_ENTRY.creation_dt%TYPE,
1680: cp_key IGS_GE_S_LOG_ENTRY.key%TYPE,
1681: cp_text IGS_GE_S_LOG_ENTRY.text%TYPE) IS
1682: SELECT SLE.rowid

Line 1679: cp_creation_dt IGS_GE_S_LOG_ENTRY.creation_dt%TYPE,

1675: p_rowid VARCHAR2(25);
1676: p_val VARCHAR2(1);
1677: CURSOR c_s_log_entry_cir(
1678: cp_s_log_type IGS_GE_S_LOG_ENTRY.s_log_type%TYPE,
1679: cp_creation_dt IGS_GE_S_LOG_ENTRY.creation_dt%TYPE,
1680: cp_key IGS_GE_S_LOG_ENTRY.key%TYPE,
1681: cp_text IGS_GE_S_LOG_ENTRY.text%TYPE) IS
1682: SELECT SLE.rowid
1683: FROM IGS_GE_S_LOG_ENTRY sle

Line 1680: cp_key IGS_GE_S_LOG_ENTRY.key%TYPE,

1676: p_val VARCHAR2(1);
1677: CURSOR c_s_log_entry_cir(
1678: cp_s_log_type IGS_GE_S_LOG_ENTRY.s_log_type%TYPE,
1679: cp_creation_dt IGS_GE_S_LOG_ENTRY.creation_dt%TYPE,
1680: cp_key IGS_GE_S_LOG_ENTRY.key%TYPE,
1681: cp_text IGS_GE_S_LOG_ENTRY.text%TYPE) IS
1682: SELECT SLE.rowid
1683: FROM IGS_GE_S_LOG_ENTRY sle
1684: WHERE sle.s_log_type = cp_s_log_type AND

Line 1681: cp_text IGS_GE_S_LOG_ENTRY.text%TYPE) IS

1677: CURSOR c_s_log_entry_cir(
1678: cp_s_log_type IGS_GE_S_LOG_ENTRY.s_log_type%TYPE,
1679: cp_creation_dt IGS_GE_S_LOG_ENTRY.creation_dt%TYPE,
1680: cp_key IGS_GE_S_LOG_ENTRY.key%TYPE,
1681: cp_text IGS_GE_S_LOG_ENTRY.text%TYPE) IS
1682: SELECT SLE.rowid
1683: FROM IGS_GE_S_LOG_ENTRY sle
1684: WHERE sle.s_log_type = cp_s_log_type AND
1685: sle.creation_dt = cp_creation_dt AND

Line 1683: FROM IGS_GE_S_LOG_ENTRY sle

1679: cp_creation_dt IGS_GE_S_LOG_ENTRY.creation_dt%TYPE,
1680: cp_key IGS_GE_S_LOG_ENTRY.key%TYPE,
1681: cp_text IGS_GE_S_LOG_ENTRY.text%TYPE) IS
1682: SELECT SLE.rowid
1683: FROM IGS_GE_S_LOG_ENTRY sle
1684: WHERE sle.s_log_type = cp_s_log_type AND
1685: sle.creation_dt = cp_creation_dt AND
1686: sle.key = cp_key AND
1687: sle.text = cp_text

Line 1749: -- Insert IGS_GE_NOTE into IGS_GE_S_LOG_ENTRY

1745: v_cal_inst_rltsp_sup_rec.load_research_percentage;
1746: ELSE
1747: -- Validate that superior calendar instance match is not inactive.
1748: IF v_derived_cal_instance_rec.s_cal_status = cst_inactive THEN
1749: -- Insert IGS_GE_NOTE into IGS_GE_S_LOG_ENTRY
1750: -- for reporting purposes
1751: token1_val := p_sub_cal_type || '|' ||p_sub_ci_sequence_number || '|' ;
1752: token2_val := v_derived_cal_instance_rec.CAL_TYPE ||' '||IGS_GE_DATE.IGSCHAR(v_derived_start_dt) ||
1753: '-'||IGS_GE_DATE.IGSCHAR(v_derived_end_dt);

Line 1783: -- Insert IGS_GE_NOTE into IGS_GE_S_LOG_ENTRY for reporting purposes

1779: p_sub_ci_sequence_number,
1780: v_derived_cal_instance_rec.CAL_TYPE,
1781: v_derived_cal_instance_rec.sequence_number,
1782: p_message_name) THEN
1783: -- Insert IGS_GE_NOTE into IGS_GE_S_LOG_ENTRY for reporting purposes
1784:
1785: token1_val := p_sub_cal_type || '|' ||p_sub_ci_sequence_number || '|';
1786: token2_val := v_derived_cal_instance_rec.CAL_TYPE ||' '||IGS_GE_DATE.IGSCHAR(v_derived_start_dt) ||
1787: '-'||IGS_GE_DATE.IGSCHAR(v_derived_end_dt);

Line 1846: IGS_GE_S_LOG_ENTRY_PKG.DELETE_ROW(p_rowid);

1842:
1843: fetch c_s_log_entry_cir INTO p_rowid;
1844: if c_s_log_entry_cir%Found Then
1845:
1846: IGS_GE_S_LOG_ENTRY_PKG.DELETE_ROW(p_rowid);
1847:
1848: else
1849: close c_s_log_entry_cir;
1850: exit;

Line 1869: -- Insert IGS_GE_NOTE into IGS_GE_S_LOG_ENTRY

1865: END IF;
1866: END IF;
1867: ELSE -- NOT c_derived_cal_instance%FOUND
1868: CLOSE c_derived_cal_instance;
1869: -- Insert IGS_GE_NOTE into IGS_GE_S_LOG_ENTRY
1870: -- for reporting purposes when superior calendar instance does
1871: -- not exist.
1872:
1873: token1_val := p_sub_cal_type || '|' ||p_sub_ci_sequence_number || '|' ;

Line 1927: -- Insert IGS_GE_NOTE into IGS_GE_S_LOG_ENTRY

1923: p_sub_ci_sequence_number,
1924: p_sup_cal_type,
1925: p_sup_ci_sequence_number,
1926: p_message_name) THEN
1927: -- Insert IGS_GE_NOTE into IGS_GE_S_LOG_ENTRY
1928: -- for reporting purposes
1929:
1930: token1_val := p_sub_cal_type || '|' ||p_sub_ci_sequence_number || '|';
1931: token2_val := v_cal_inst_rec.CAL_TYPE ||' '||IGS_GE_DATE.IGSCHAR(v_derived_start_dt) ||

Line 1984: IGS_GE_S_LOG_ENTRY_PKG.DELETE_ROW(v_c_dummy_rec.ROWID);

1980: gv_log_creation_dt,
1981: gv_log_key,
1982: v_other_detail) LOOP
1983:
1984: IGS_GE_S_LOG_ENTRY_PKG.DELETE_ROW(v_c_dummy_rec.ROWID);
1985:
1986: END LOOP;
1987: EXCEPTION
1988: -- locking conflict exception.

Line 2253: -- Insert message into IGS_GE_S_LOG_ENTRY for reporting

2249: -- Validate that the calendar instance calendar type is not closed
2250: IF(IGS_CA_GEN_001.CALP_GET_CAT_CLOSED(
2251: p_cal_type,
2252: p_message_name) = TRUE) THEN
2253: -- Insert message into IGS_GE_S_LOG_ENTRY for reporting
2254: -- why the calendar instance was not rolled.
2255: token1_val := p_cal_type || '|' ||p_sequence_number || '|';
2256: token2_val := p_cal_type||IGS_GE_DATE.IGSCHAR(v_new_start_dt) ||
2257: IGS_GE_DATE.IGSCHAR(v_new_end_dt) ;

Line 2305: -- Insert message into IGS_GE_S_LOG_ENTRY for reporting

2301: CLOSE c_new_cal_instance;
2302: ELSE
2303:
2304: CLOSE c_new_cal_instance;
2305: -- Insert message into IGS_GE_S_LOG_ENTRY for reporting
2306: -- why the calendar instance was not rolled.
2307:
2308:
2309: token1_val := p_cal_type || '|' ||p_sequence_number || '|';