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_CA_INS_ROLL_CI

Line 1: PACKAGE BODY IGS_CA_INS_ROLL_CI AS

1: PACKAGE BODY IGS_CA_INS_ROLL_CI AS
2: /* $Header: IGSCA03B.pls 120.1 2005/08/04 06:37:03 appldev ship $ */
3:
4: /***** Bug No : 1956374
5: Task : Duplicated Procedures and functions

Line 220: l_prog_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_daip';

216: AND key = gv_log_key
217: AND text = v_other_detail;
218: BEGIN
219:
220: l_prog_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_daip';
221: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_daip.start';
222:
223: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
224: l_debug_str := 'calp_ins_rollvr_daip : Starting';

Line 221: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_daip.start';

217: AND text = v_other_detail;
218: BEGIN
219:
220: l_prog_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_daip';
221: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_daip.start';
222:
223: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
224: l_debug_str := 'calp_ins_rollvr_daip : Starting';
225: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,l_roll_seq);

Line 302: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_daip.no_ci';

298: v_other_detail:=FND_MESSAGE.GET;
299:
300: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
301:
302: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_daip.no_ci';
303: l_debug_str := 'igs_ca_ins_roll_ci.calp_ins_rollvr_daip Log Message: ' || v_other_detail;
304: fnd_log.string_with_context( fnd_log.level_procedure,
305: l_label,
306: l_debug_str, NULL,

Line 303: l_debug_str := 'igs_ca_ins_roll_ci.calp_ins_rollvr_daip Log Message: ' || v_other_detail;

299:
300: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
301:
302: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_daip.no_ci';
303: l_debug_str := 'igs_ca_ins_roll_ci.calp_ins_rollvr_daip Log Message: ' || v_other_detail;
304: fnd_log.string_with_context( fnd_log.level_procedure,
305: l_label,
306: l_debug_str, NULL,
307: NULL,NULL,NULL,NULL,l_roll_seq);

Line 337: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_daip.inactive_ci';

333: v_other_detail:=FND_MESSAGE.GET;
334:
335: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
336:
337: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_daip.inactive_ci';
338: l_debug_str := 'igs_ca_ins_roll_ci.calp_ins_rollvr_daip Log Message: ' || v_other_detail;
339: fnd_log.string_with_context( fnd_log.level_procedure,
340: l_label,
341: l_debug_str, NULL,

Line 338: l_debug_str := 'igs_ca_ins_roll_ci.calp_ins_rollvr_daip Log Message: ' || v_other_detail;

334:
335: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
336:
337: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_daip.inactive_ci';
338: l_debug_str := 'igs_ca_ins_roll_ci.calp_ins_rollvr_daip Log Message: ' || v_other_detail;
339: fnd_log.string_with_context( fnd_log.level_procedure,
340: l_label,
341: l_debug_str, NULL,
342: NULL,NULL,NULL,NULL,l_roll_seq);

Line 375: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_daip.no_dai';

371:
372:
373: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
374:
375: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_daip.no_dai';
376: l_debug_str := 'igs_ca_ins_roll_ci.calp_ins_rollvr_daip Log Message: ' || v_other_detail;
377: fnd_log.string_with_context( fnd_log.level_procedure,
378: l_label,
379: l_debug_str, NULL,

Line 376: l_debug_str := 'igs_ca_ins_roll_ci.calp_ins_rollvr_daip Log Message: ' || v_other_detail;

372:
373: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
374:
375: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_daip.no_dai';
376: l_debug_str := 'igs_ca_ins_roll_ci.calp_ins_rollvr_daip Log Message: ' || v_other_detail;
377: fnd_log.string_with_context( fnd_log.level_procedure,
378: l_label,
379: l_debug_str, NULL,
380: NULL,NULL,NULL,NULL,l_roll_seq);

Line 409: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_daip.multi_dai';

405: v_other_detail:=FND_MESSAGE.GET;
406:
407: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
408:
409: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_daip.multi_dai';
410: l_debug_str := 'igs_ca_ins_roll_ci.calp_ins_rollvr_daip Log Message: ' || v_other_detail;
411: fnd_log.string_with_context( fnd_log.level_procedure,
412: l_label,
413: l_debug_str, NULL,

Line 410: l_debug_str := 'igs_ca_ins_roll_ci.calp_ins_rollvr_daip Log Message: ' || v_other_detail;

406:
407: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
408:
409: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_daip.multi_dai';
410: l_debug_str := 'igs_ca_ins_roll_ci.calp_ins_rollvr_daip Log Message: ' || v_other_detail;
411: fnd_log.string_with_context( fnd_log.level_procedure,
412: l_label,
413: l_debug_str, NULL,
414: NULL,NULL,NULL,NULL,l_roll_seq);

Line 486: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_daip.multi_dai';

482: v_other_detail:=FND_MESSAGE.GET;
483:
484: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
485:
486: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_daip.multi_dai';
487: l_debug_str := 'igs_ca_ins_roll_ci.calp_ins_rollvr_daip Log Message: ' || v_other_detail;
488: fnd_log.string_with_context( fnd_log.level_procedure,
489: l_label,
490: l_debug_str, NULL,

Line 487: l_debug_str := 'igs_ca_ins_roll_ci.calp_ins_rollvr_daip Log Message: ' || v_other_detail;

483:
484: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
485:
486: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_daip.multi_dai';
487: l_debug_str := 'igs_ca_ins_roll_ci.calp_ins_rollvr_daip Log Message: ' || v_other_detail;
488: fnd_log.string_with_context( fnd_log.level_procedure,
489: l_label,
490: l_debug_str, NULL,
491: NULL,NULL,NULL,NULL,l_roll_seq);

Line 518: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_daip.multi_dai';

514: v_other_detail:=FND_MESSAGE.GET;
515:
516: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
517:
518: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_daip.multi_dai';
519: l_debug_str := 'igs_ca_ins_roll_ci.calp_ins_rollvr_daip Log Message: ' || v_other_detail;
520: fnd_log.string_with_context( fnd_log.level_procedure,
521: l_label,
522: l_debug_str, NULL,

Line 519: l_debug_str := 'igs_ca_ins_roll_ci.calp_ins_rollvr_daip Log Message: ' || v_other_detail;

515:
516: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
517:
518: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_daip.multi_dai';
519: l_debug_str := 'igs_ca_ins_roll_ci.calp_ins_rollvr_daip Log Message: ' || v_other_detail;
520: fnd_log.string_with_context( fnd_log.level_procedure,
521: l_label,
522: l_debug_str, NULL,
523: NULL,NULL,NULL,NULL,l_roll_seq);

Line 833: l_prog_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_daio';

829: AND key = gv_log_key
830: AND text = v_other_detail;
831: BEGIN
832:
833: l_prog_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_daio';
834: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_daio.start';
835:
836:
837: -- Determine calendar instance match by adding rollover days difference

Line 834: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_daio.start';

830: AND text = v_other_detail;
831: BEGIN
832:
833: l_prog_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_daio';
834: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_daio.start';
835:
836:
837: -- Determine calendar instance match by adding rollover days difference
838: -- to start and end dates.

Line 912: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_daio.no_caoff';

908: v_other_detail:=FND_MESSAGE.GET;
909:
910: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
911:
912: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_daio.no_caoff';
913: l_debug_str := 'igs_ca_ins_roll_ci.calp_ins_rollvr_daio Log Message: ' || v_other_detail;
914: fnd_log.string_with_context( fnd_log.level_procedure,
915: l_label,
916: l_debug_str, NULL,

Line 913: l_debug_str := 'igs_ca_ins_roll_ci.calp_ins_rollvr_daio Log Message: ' || v_other_detail;

909:
910: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
911:
912: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_daio.no_caoff';
913: l_debug_str := 'igs_ca_ins_roll_ci.calp_ins_rollvr_daio Log Message: ' || v_other_detail;
914: fnd_log.string_with_context( fnd_log.level_procedure,
915: l_label,
916: l_debug_str, NULL,
917: NULL,NULL,NULL,NULL,l_roll_seq);

Line 947: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_daio.inactive_caoff';

943: v_other_detail:=FND_MESSAGE.GET;
944:
945: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
946:
947: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_daio.inactive_caoff';
948: l_debug_str := 'igs_ca_ins_roll_ci.calp_ins_rollvr_daio Log Message: ' || v_other_detail;
949: fnd_log.string_with_context( fnd_log.level_procedure,
950: l_label,
951: l_debug_str, NULL,

Line 948: l_debug_str := 'igs_ca_ins_roll_ci.calp_ins_rollvr_daio Log Message: ' || v_other_detail;

944:
945: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
946:
947: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_daio.inactive_caoff';
948: l_debug_str := 'igs_ca_ins_roll_ci.calp_ins_rollvr_daio Log Message: ' || v_other_detail;
949: fnd_log.string_with_context( fnd_log.level_procedure,
950: l_label,
951: l_debug_str, NULL,
952: NULL,NULL,NULL,NULL,l_roll_seq);

Line 982: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_daio.no_offda';

978: v_other_detail:=FND_MESSAGE.GET;
979:
980: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
981:
982: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_daio.no_offda';
983: l_debug_str := 'igs_ca_ins_roll_ci.calp_ins_rollvr_daio Log Message: ' || v_other_detail;
984: fnd_log.string_with_context( fnd_log.level_procedure,
985: l_label,
986: l_debug_str, NULL,

Line 983: l_debug_str := 'igs_ca_ins_roll_ci.calp_ins_rollvr_daio Log Message: ' || v_other_detail;

979:
980: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
981:
982: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_daio.no_offda';
983: l_debug_str := 'igs_ca_ins_roll_ci.calp_ins_rollvr_daio Log Message: ' || v_other_detail;
984: fnd_log.string_with_context( fnd_log.level_procedure,
985: l_label,
986: l_debug_str, NULL,
987: NULL,NULL,NULL,NULL,l_roll_seq);

Line 1016: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_daio.dupp_off';

1012: v_other_detail:=FND_MESSAGE.GET;
1013:
1014: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1015:
1016: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_daio.dupp_off';
1017: l_debug_str := 'igs_ca_ins_roll_ci.calp_ins_rollvr_daio Log Message: ' || v_other_detail;
1018: fnd_log.string_with_context( fnd_log.level_procedure,
1019: l_label,
1020: l_debug_str, NULL,

Line 1017: l_debug_str := 'igs_ca_ins_roll_ci.calp_ins_rollvr_daio Log Message: ' || v_other_detail;

1013:
1014: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1015:
1016: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_daio.dupp_off';
1017: l_debug_str := 'igs_ca_ins_roll_ci.calp_ins_rollvr_daio Log Message: ' || v_other_detail;
1018: fnd_log.string_with_context( fnd_log.level_procedure,
1019: l_label,
1020: l_debug_str, NULL,
1021: NULL,NULL,NULL,NULL,l_roll_seq);

Line 1142: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_daip.multi_dai';

1138: v_other_detail:=FND_MESSAGE.GET;
1139:
1140: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1141:
1142: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_daip.multi_dai';
1143: l_debug_str := 'igs_ca_ins_roll_ci.calp_ins_rollvr_daip Log Message: ' || v_other_detail;
1144: fnd_log.string_with_context( fnd_log.level_procedure,
1145: l_label,
1146: l_debug_str, NULL,

Line 1143: l_debug_str := 'igs_ca_ins_roll_ci.calp_ins_rollvr_daip Log Message: ' || v_other_detail;

1139:
1140: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1141:
1142: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_daip.multi_dai';
1143: l_debug_str := 'igs_ca_ins_roll_ci.calp_ins_rollvr_daip Log Message: ' || v_other_detail;
1144: fnd_log.string_with_context( fnd_log.level_procedure,
1145: l_label,
1146: l_debug_str, NULL,
1147: NULL,NULL,NULL,NULL,l_roll_seq);

Line 1175: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_daip.multi_dai';

1171: v_other_detail:=FND_MESSAGE.GET;
1172:
1173: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1174:
1175: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_daip.multi_dai';
1176: l_debug_str := 'igs_ca_ins_roll_ci.calp_ins_rollvr_daip Log Message: ' || v_other_detail;
1177: fnd_log.string_with_context( fnd_log.level_procedure,
1178: l_label,
1179: l_debug_str, NULL,

Line 1176: l_debug_str := 'igs_ca_ins_roll_ci.calp_ins_rollvr_daip Log Message: ' || v_other_detail;

1172:
1173: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1174:
1175: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_daip.multi_dai';
1176: l_debug_str := 'igs_ca_ins_roll_ci.calp_ins_rollvr_daip Log Message: ' || v_other_detail;
1177: fnd_log.string_with_context( fnd_log.level_procedure,
1178: l_label,
1179: l_debug_str, NULL,
1180: NULL,NULL,NULL,NULL,l_roll_seq);

Line 1319: l_prog_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_dai';

1315: related_cal_type = cp_cal_type AND
1316: related_ci_sequence_number = cp_ci_seq;
1317: BEGIN
1318:
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

Line 1320: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_dai.start';

1316: related_ci_sequence_number = cp_ci_seq;
1317: BEGIN
1318:
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.

Line 1345: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_dai.dai_closed';

1341: v_other_detail:=FND_MESSAGE.GET;
1342:
1343: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1344:
1345: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_dai.dai_closed';
1346: l_debug_str := 'igs_ca_ins_roll_ci.calp_ins_rollvr_dai Log Message: ' || v_other_detail;
1347: fnd_log.string_with_context( fnd_log.level_procedure,
1348: l_label,
1349: l_debug_str, NULL,

Line 1346: l_debug_str := 'igs_ca_ins_roll_ci.calp_ins_rollvr_dai Log Message: ' || v_other_detail;

1342:
1343: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1344:
1345: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_dai.dai_closed';
1346: l_debug_str := 'igs_ca_ins_roll_ci.calp_ins_rollvr_dai Log Message: ' || v_other_detail;
1347: fnd_log.string_with_context( fnd_log.level_procedure,
1348: l_label,
1349: l_debug_str, NULL,
1350: NULL,NULL,NULL,NULL,l_roll_seq);

Line 1369: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_dai.calcat';

1365: FND_MESSAGE.SET_TOKEN('TOKEN2',c_dt_alias_instance_rec.DT_ALIAS);
1366: v_other_detail:=FND_MESSAGE.GET;
1367: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1368:
1369: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_dai.calcat';
1370: l_debug_str := 'igs_ca_ins_roll_ci.calp_ins_rollvr_dai Log Message: ' || v_other_detail;
1371: fnd_log.string_with_context( fnd_log.level_procedure,
1372: l_label,
1373: l_debug_str, NULL,

Line 1370: l_debug_str := 'igs_ca_ins_roll_ci.calp_ins_rollvr_dai Log Message: ' || v_other_detail;

1366: v_other_detail:=FND_MESSAGE.GET;
1367: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1368:
1369: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_dai.calcat';
1370: l_debug_str := 'igs_ca_ins_roll_ci.calp_ins_rollvr_dai Log Message: ' || v_other_detail;
1371: fnd_log.string_with_context( fnd_log.level_procedure,
1372: l_label,
1373: l_debug_str, NULL,
1374: NULL,NULL,NULL,NULL,l_roll_seq);

Line 1385: ELSIF IGS_CA_INS_ROLL_CI.calp_val_apcood_roll(

1381: v_other_detail);
1382:
1383: END IF;
1384: -- NEW CODE FROM JULIE
1385: ELSIF IGS_CA_INS_ROLL_CI.calp_val_apcood_roll(
1386: c_dt_alias_instance_rec.DT_ALIAS,
1387: c_dt_alias_instance_rec.sequence_number,
1388: c_dt_alias_instance_rec.CAL_TYPE,
1389: c_dt_alias_instance_rec.ci_sequence_number,

Line 1697: l_prog_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_cir';

1693: sle.message_name,
1694: sle.text NOWAIT;
1695: BEGIN
1696:
1697: l_prog_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_cir';
1698: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_cir.start';
1699:
1700: -- Default value.
1701: p_message_name := null;

Line 1698: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_cir.start';

1694: sle.text NOWAIT;
1695: BEGIN
1696:
1697: l_prog_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_cir';
1698: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_cir.start';
1699:
1700: -- Default value.
1701: p_message_name := null;
1702: -------------------------- Used to test the module ------------------------

Line 1761: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_cir.inact_supcal';

1757: FND_MESSAGE.SET_TOKEN('TOKEN2',token2_val);
1758: v_other_detail:=FND_MESSAGE.GET;
1759: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1760:
1761: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_cir.inact_supcal';
1762: l_debug_str := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_cir Log Message: ' || v_other_detail;
1763: fnd_log.string_with_context( fnd_log.level_procedure,
1764: l_label,
1765: l_debug_str, NULL,

Line 1762: l_debug_str := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_cir Log Message: ' || v_other_detail;

1758: v_other_detail:=FND_MESSAGE.GET;
1759: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1760:
1761: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_cir.inact_supcal';
1762: l_debug_str := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_cir Log Message: ' || v_other_detail;
1763: fnd_log.string_with_context( fnd_log.level_procedure,
1764: l_label,
1765: l_debug_str, NULL,
1766: NULL,NULL,NULL,NULL,l_roll_seq);

Line 1796: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_cir.invalid_rel';

1792: v_other_detail:=FND_MESSAGE.GET;
1793:
1794: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1795:
1796: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_cir.invalid_rel';
1797: l_debug_str := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_cir Log Message: ' || v_other_detail;
1798: fnd_log.string_with_context( fnd_log.level_procedure,
1799: l_label,
1800: l_debug_str, NULL,

Line 1797: l_debug_str := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_cir Log Message: ' || v_other_detail;

1793:
1794: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1795:
1796: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_cir.invalid_rel';
1797: l_debug_str := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_cir Log Message: ' || v_other_detail;
1798: fnd_log.string_with_context( fnd_log.level_procedure,
1799: l_label,
1800: l_debug_str, NULL,
1801: NULL,NULL,NULL,NULL,l_roll_seq);

Line 1940: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_cir.inv_rel_supcal';

1936: FND_MESSAGE.SET_TOKEN('TOKEN2',token2_val);
1937: v_other_detail:=FND_MESSAGE.GET;
1938: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1939:
1940: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_cir.inv_rel_supcal';
1941: l_debug_str := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_cir Log Message: ' || v_other_detail;
1942: fnd_log.string_with_context( fnd_log.level_procedure,
1943: l_label,
1944: l_debug_str, NULL,

Line 1941: l_debug_str := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_cir Log Message: ' || v_other_detail;

1937: v_other_detail:=FND_MESSAGE.GET;
1938: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1939:
1940: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_cir.inv_rel_supcal';
1941: l_debug_str := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_cir Log Message: ' || v_other_detail;
1942: fnd_log.string_with_context( fnd_log.level_procedure,
1943: l_label,
1944: l_debug_str, NULL,
1945: NULL,NULL,NULL,NULL,l_roll_seq);

Line 2233: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calpl_ins_rollvr_ci.val1';

2229: END IF;
2230:
2231: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2232:
2233: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calpl_ins_rollvr_ci.val1';
2234: l_debug_str := 'igs.plsql.igs_ca_ins_roll_ci.calpl_ins_rollvr_ci Log Message: ' || v_other_detail;
2235: fnd_log.string_with_context( fnd_log.level_procedure,
2236: l_label,
2237: l_debug_str, NULL,

Line 2234: l_debug_str := 'igs.plsql.igs_ca_ins_roll_ci.calpl_ins_rollvr_ci Log Message: ' || v_other_detail;

2230:
2231: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2232:
2233: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calpl_ins_rollvr_ci.val1';
2234: l_debug_str := 'igs.plsql.igs_ca_ins_roll_ci.calpl_ins_rollvr_ci Log Message: ' || v_other_detail;
2235: fnd_log.string_with_context( fnd_log.level_procedure,
2236: l_label,
2237: l_debug_str, NULL,
2238: NULL,NULL,NULL,NULL,l_roll_seq);

Line 2266: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calpl_ins_rollvr_ci.val2';

2262: v_other_detail:=FND_MESSAGE.GET;
2263:
2264: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2265:
2266: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calpl_ins_rollvr_ci.val2';
2267: l_debug_str := 'igs.plsql.igs_ca_ins_roll_ci.calpl_ins_rollvr_ci Log Message: ' || v_other_detail;
2268: fnd_log.string_with_context( fnd_log.level_procedure,
2269: l_label,
2270: l_debug_str, NULL,

Line 2267: l_debug_str := 'igs.plsql.igs_ca_ins_roll_ci.calpl_ins_rollvr_ci Log Message: ' || v_other_detail;

2263:
2264: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2265:
2266: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calpl_ins_rollvr_ci.val2';
2267: l_debug_str := 'igs.plsql.igs_ca_ins_roll_ci.calpl_ins_rollvr_ci Log Message: ' || v_other_detail;
2268: fnd_log.string_with_context( fnd_log.level_procedure,
2269: l_label,
2270: l_debug_str, NULL,
2271: NULL,NULL,NULL,NULL,l_roll_seq);

Line 2320: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calpl_ins_rollvr_ci.val3';

2316: v_other_detail:=FND_MESSAGE.GET;
2317:
2318: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2319:
2320: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calpl_ins_rollvr_ci.val3';
2321: l_debug_str := 'igs.plsql.igs_ca_ins_roll_ci.calpl_ins_rollvr_ci Log Message: ' || v_other_detail;
2322: fnd_log.string_with_context( fnd_log.level_procedure,
2323: l_label,
2324: l_debug_str, NULL,

Line 2321: l_debug_str := 'igs.plsql.igs_ca_ins_roll_ci.calpl_ins_rollvr_ci Log Message: ' || v_other_detail;

2317:
2318: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2319:
2320: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calpl_ins_rollvr_ci.val3';
2321: l_debug_str := 'igs.plsql.igs_ca_ins_roll_ci.calpl_ins_rollvr_ci Log Message: ' || v_other_detail;
2322: fnd_log.string_with_context( fnd_log.level_procedure,
2323: l_label,
2324: l_debug_str, NULL,
2325: NULL,NULL,NULL,NULL,l_roll_seq);

Line 2622: l_prog_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_ci';

2618: gv_log_key,
2619: gv_log_creation_dt);
2620: gv_cal_count := gv_cal_count + 1;
2621:
2622: l_prog_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_ci';
2623: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_ci.begin';
2624: l_roll_seq := v_ci_rollover_sequence_number;
2625: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2626:

Line 2623: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_ci.begin';

2619: gv_log_creation_dt);
2620: gv_cal_count := gv_cal_count + 1;
2621:
2622: l_prog_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_ci';
2623: l_label := 'igs.plsql.igs_ca_ins_roll_ci.calp_ins_rollvr_ci.begin';
2624: l_roll_seq := v_ci_rollover_sequence_number;
2625: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2626:
2627: l_debug_str := 'Rollover Sequence : ' || v_ci_rollover_sequence_number;

Line 2830: END IGS_CA_INS_ROLL_CI;

2826: App_Exception.Raise_Exception;
2827: END;
2828: END calp_ins_rollvr_ci;
2829:
2830: END IGS_CA_INS_ROLL_CI;