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 FND_LOG

Line 223: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

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);
226: END IF;
227:

Line 225: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,l_roll_seq);

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);
226: END IF;
227:
228: -- Determine calendar instance match by adding rollover days difference
229: -- to start and end dates.

Line 300: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

296: FND_MESSAGE.SET_TOKEN('TOKEN2',token2_val);
297: FND_MESSAGE.SET_TOKEN('TOKEN3',p_val_dt_alias);
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,

Line 304: fnd_log.string_with_context( fnd_log.level_procedure,

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);
308: END IF;

Line 335: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

331: FND_MESSAGE.SET_TOKEN('TOKEN2',token2_val);
332: FND_MESSAGE.SET_TOKEN('TOKEN3',p_val_dt_alias);
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,

Line 339: fnd_log.string_with_context( fnd_log.level_procedure,

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);
343: END IF;

Line 373: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

369: FND_MESSAGE.SET_TOKEN('TOKEN2',token2_val);
370: v_other_detail:=FND_MESSAGE.GET;
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,

Line 377: fnd_log.string_with_context( fnd_log.level_procedure,

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);
381: END IF;

Line 407: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

403: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
404: FND_MESSAGE.SET_TOKEN('TOKEN2',token2_val);
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,

Line 411: fnd_log.string_with_context( fnd_log.level_procedure,

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);
415: END IF;

Line 484: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

480: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
481: FND_MESSAGE.SET_TOKEN('TOKEN2',token2_val);
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,

Line 488: fnd_log.string_with_context( fnd_log.level_procedure,

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);
492: END IF;

Line 516: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

512: FND_MESSAGE.SET_TOKEN('TOKEN2',token2_val);
513: FND_MESSAGE.SET_TOKEN('TOKEN3',p_val_dt_alias);
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,

Line 520: fnd_log.string_with_context( fnd_log.level_procedure,

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);
524: END IF;

Line 558: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

554: p_message_name := null;
555: RETURN TRUE;
556: EXCEPTION
557: WHEN OTHERS THEN
558: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
559: l_debug_str := 'DA ='||p_dt_alias||'Seq num ='||(to_char(p_dai_sequence_number))||
560: 'Cal Type ='||p_cal_type||'CI Seq num ='||(to_char(p_ci_sequence_number))||
561: 'Diff Days ='||(to_char(p_diff_days))||'Diff Months ='||(to_char(p_diff_months))||
562: 'DAI val ='||p_val_dt_alias||'DAI seq num'||(to_char(p_val_dai_sequence_number))||

Line 565: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

561: 'Diff Days ='||(to_char(p_diff_days))||'Diff Months ='||(to_char(p_diff_months))||
562: 'DAI val ='||p_val_dt_alias||'DAI seq num'||(to_char(p_val_dai_sequence_number))||
563: 'Validating Cal Type ='||p_val_cal_type||'Val CI seq num ='||(to_char(p_val_ci_sequence_number ))||
564: 'Rollover CI seq num ='||(to_char(p_ci_rollover_sequence_number));
565: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
566: END IF;
567: IF l_func_name IS NULL THEN
568: l_func_name := 'calp_ins_rollvr_daip';
569: END IF;

Line 910: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

906: FND_MESSAGE.SET_TOKEN('TOKEN2',token2_val);
907: FND_MESSAGE.SET_TOKEN('TOKEN3',p_val_dt_alias);
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,

Line 914: fnd_log.string_with_context( fnd_log.level_procedure,

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);
918: END IF;

Line 945: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

941: FND_MESSAGE.SET_TOKEN('TOKEN2',token2_val);
942: FND_MESSAGE.SET_TOKEN('TOKEN3',p_val_dt_alias);
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,

Line 949: fnd_log.string_with_context( fnd_log.level_procedure,

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);
953: END IF;

Line 980: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

976: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
977: FND_MESSAGE.SET_TOKEN('TOKEN2',token2_val);
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,

Line 984: fnd_log.string_with_context( fnd_log.level_procedure,

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);
988: END IF;

Line 1014: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

1010: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
1011: FND_MESSAGE.SET_TOKEN('TOKEN2',token2_val);
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,

Line 1018: fnd_log.string_with_context( fnd_log.level_procedure,

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);
1022: END IF;

Line 1140: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

1136: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
1137: FND_MESSAGE.SET_TOKEN('TOKEN2',token2_val);
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,

Line 1144: fnd_log.string_with_context( fnd_log.level_procedure,

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);
1148: END IF;

Line 1173: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

1169: FND_MESSAGE.SET_TOKEN('TOKEN2',token2_val);
1170: FND_MESSAGE.SET_TOKEN('TOKEN3',p_dt_alias);
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,

Line 1177: fnd_log.string_with_context( fnd_log.level_procedure,

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);
1181: END IF;

Line 1216: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

1212: p_message_name := null;
1213: RETURN TRUE;
1214: EXCEPTION
1215: WHEN OTHERS THEN
1216: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1217: l_debug_str := 'Date Alias ='||p_dt_alias||'DAI seq num ='||(to_char(p_dai_sequence_number))||
1218: 'Cal Type ='||p_cal_type||'CI seq num ='||(to_char(p_ci_sequence_number))||
1219: 'Diff days ='||(to_char(p_diff_days))||'Diff months ='||(to_char(p_diff_months))||
1220: 'DAI val ='||p_val_dt_alias||'DAI seq num ='||(to_char(p_val_dai_sequence_number))||

Line 1225: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

1221: 'Val Cal Type ='||p_val_cal_type||'Val CI seq num ='||(to_char(p_val_ci_sequence_number))||
1222: 'Day offset'||(to_char(p_day_offset))||'Week offset ='||(to_char(p_week_offset))||'Month offset ='||(to_char(p_month_offset))||
1223: 'Year offset ='||(to_char(p_year_offset))||'Rollover CI seq num ='||(to_char(p_ci_rollover_sequence_number))||
1224: 'Old CI seq num ='||(to_char(p_old_ci_sequence_number));
1225: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
1226: END IF;
1227: IF l_func_name IS NULL THEN
1228: l_func_name := 'calp_ins_rollvr_daio';
1229: END IF;

Line 1343: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

1339: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
1340: FND_MESSAGE.SET_TOKEN('TOKEN2',c_dt_alias_instance_rec.DT_ALIAS);
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,

Line 1347: fnd_log.string_with_context( fnd_log.level_procedure,

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);
1351: END IF;

Line 1367: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

1363: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_DTALIAS_CALCAT_MISMATCH');
1364: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
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,

Line 1371: fnd_log.string_with_context( fnd_log.level_procedure,

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);
1375: END IF;

Line 1405: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

1401: gv_log_key,
1402: NULL,
1403: v_other_detail);
1404:
1405: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1406: v_other_detail := 'CIR' || '|' || 'E' || '|' ||p_rollover_cal_type|| '|' ||
1407: p_rollover_ci_sequence_number|| '|' ||'Date alias instance '||
1408: 'not created because it is an '||'Admission Period override date.';
1409: fnd_log.string_with_context( fnd_log.level_statement,l_label,v_other_detail, NULL,NULL,NULL,NULL,NULL,l_roll_seq);

Line 1409: fnd_log.string_with_context( fnd_log.level_statement,l_label,v_other_detail, NULL,NULL,NULL,NULL,NULL,l_roll_seq);

1405: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1406: v_other_detail := 'CIR' || '|' || 'E' || '|' ||p_rollover_cal_type|| '|' ||
1407: p_rollover_ci_sequence_number|| '|' ||'Date alias instance '||
1408: 'not created because it is an '||'Admission Period override date.';
1409: fnd_log.string_with_context( fnd_log.level_statement,l_label,v_other_detail, NULL,NULL,NULL,NULL,NULL,l_roll_seq);
1410: END IF;
1411:
1412: -- END NEW CODE FROM JULIE
1413: ELSE -- create IGS_CA_DA_INST

Line 1572: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

1568: RETURN TRUE;
1569: EXCEPTION
1570: WHEN OTHERS THEN
1571:
1572: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1573: l_debug_str := 'Cal Type ='||p_cal_type||'CI seq num ='||(to_char(p_ci_sequence_number))||
1574: 'Diff days ='||(to_char(p_diff_days))||'Diff months ='||(to_char(p_diff_months))||
1575: 'Rollover cal type ='||p_rollover_cal_type||'Rollover CI seq num ='||(to_char(p_rollover_ci_sequence_number))||
1576: 'CI rollover seq num ='||(to_char(p_ci_rollover_sequence_number));

Line 1577: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

1573: l_debug_str := 'Cal Type ='||p_cal_type||'CI seq num ='||(to_char(p_ci_sequence_number))||
1574: 'Diff days ='||(to_char(p_diff_days))||'Diff months ='||(to_char(p_diff_months))||
1575: 'Rollover cal type ='||p_rollover_cal_type||'Rollover CI seq num ='||(to_char(p_rollover_ci_sequence_number))||
1576: 'CI rollover seq num ='||(to_char(p_ci_rollover_sequence_number));
1577: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
1578: END IF;
1579: IF l_func_name IS NULL THEN
1580: l_func_name := 'calp_ins_rollvr_dai';
1581: END IF;

Line 1759: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

1755: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_SUP_CAL_INACTIVE');
1756: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
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,

Line 1763: fnd_log.string_with_context( fnd_log.level_procedure,

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);
1767: END IF;

Line 1794: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

1790: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
1791: FND_MESSAGE.SET_TOKEN('TOKEN2',token2_val);
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,

Line 1798: fnd_log.string_with_context( fnd_log.level_procedure,

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);
1802: END IF;

Line 1889: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

1885: gv_log_key,
1886: NULL,
1887: v_other_detail);
1888:
1889: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1890: v_other_detail := 'CIR|E|' ||p_sub_cal_type || '|' ||
1891: p_sub_ci_sequence_number || '|' ||' Superior calendar ' || v_cal_inst_rec.CAL_TYPE ||
1892: ' '||TO_CHAR(v_derived_start_dt,'DD/MM/YYYY') ||'-'||TO_CHAR(v_derived_end_dt,'DD/MM/YYYY') ||' does not exist.';
1893: fnd_log.string_with_context( fnd_log.level_statement,l_label,v_other_detail, NULL,NULL,NULL,NULL,NULL,l_roll_seq);

Line 1893: fnd_log.string_with_context( fnd_log.level_statement,l_label,v_other_detail, NULL,NULL,NULL,NULL,NULL,l_roll_seq);

1889: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1890: v_other_detail := 'CIR|E|' ||p_sub_cal_type || '|' ||
1891: p_sub_ci_sequence_number || '|' ||' Superior calendar ' || v_cal_inst_rec.CAL_TYPE ||
1892: ' '||TO_CHAR(v_derived_start_dt,'DD/MM/YYYY') ||'-'||TO_CHAR(v_derived_end_dt,'DD/MM/YYYY') ||' does not exist.';
1893: fnd_log.string_with_context( fnd_log.level_statement,l_label,v_other_detail, NULL,NULL,NULL,NULL,NULL,l_roll_seq);
1894: END IF;
1895:
1896: END IF;
1897: END LOOP; -- c_cal_inst_rltsp_sup

Line 1938: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

1934: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_SUP_CAL_INVALID_REL');
1935: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
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,

Line 1942: fnd_log.string_with_context( fnd_log.level_procedure,

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);
1946: END IF;

Line 1995: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

1991: IGS_GE_MSG_STACK.ADD;
1992:
1993: END;
1994:
1995: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1996: v_other_detail := 'CIR|E|' || p_sub_cal_type || '|' ||
1997: p_sub_ci_sequence_number || '|' ||' Superior calendar ' || v_cal_inst_rec.CAL_TYPE ||
1998: ' '||TO_CHAR( v_cal_inst_rec.start_dt,'DD/MM/YYYY') ||'-'||TO_CHAR( v_cal_inst_rec.end_dt,'DD/MM/YYYY') ||' does not exist.';
1999: fnd_log.string_with_context( fnd_log.level_statement,l_label,v_other_detail, NULL,NULL,NULL,NULL,NULL,l_roll_seq);

Line 1999: fnd_log.string_with_context( fnd_log.level_statement,l_label,v_other_detail, NULL,NULL,NULL,NULL,NULL,l_roll_seq);

1995: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1996: v_other_detail := 'CIR|E|' || p_sub_cal_type || '|' ||
1997: p_sub_ci_sequence_number || '|' ||' Superior calendar ' || v_cal_inst_rec.CAL_TYPE ||
1998: ' '||TO_CHAR( v_cal_inst_rec.start_dt,'DD/MM/YYYY') ||'-'||TO_CHAR( v_cal_inst_rec.end_dt,'DD/MM/YYYY') ||' does not exist.';
1999: fnd_log.string_with_context( fnd_log.level_statement,l_label,v_other_detail, NULL,NULL,NULL,NULL,NULL,l_roll_seq);
2000: END IF;
2001:
2002: END IF;
2003: ELSE

Line 2029: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

2025: RAISE;
2026: END;
2027: EXCEPTION
2028: WHEN OTHERS THEN
2029: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
2030: l_debug_str := 'Cal Type ='||p_cal_type||'Seq num ='||(to_char(p_sequence_number))||
2031: 'Diff days ='||(to_char(p_diff_days))||'Diff months ='||(to_char(p_diff_months))||
2032: 'Sub cal type ='||p_sub_cal_type||'Sub CI seq num ='||(to_char(p_sub_ci_sequence_number ))||
2033: 'Sup cal type ='||p_sup_cal_type||'Sup CI seq num ='||(to_char(p_sup_ci_sequence_number ))||

Line 2035: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);

2031: 'Diff days ='||(to_char(p_diff_days))||'Diff months ='||(to_char(p_diff_months))||
2032: 'Sub cal type ='||p_sub_cal_type||'Sub CI seq num ='||(to_char(p_sub_ci_sequence_number ))||
2033: 'Sup cal type ='||p_sup_cal_type||'Sup CI seq num ='||(to_char(p_sup_ci_sequence_number ))||
2034: 'Rollover CI seq num ='||(to_char( p_ci_rollover_sequence_number));
2035: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,null);
2036: END IF;
2037: IF l_func_name IS NULL THEN
2038: l_func_name := 'calp_ins_rollvr_cir';
2039: END IF;

Line 2231: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

2227: v_other_detail:=FND_MESSAGE.GET;
2228:
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,

Line 2235: fnd_log.string_with_context( fnd_log.level_procedure,

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);
2239: END IF;

Line 2264: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

2260: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
2261: FND_MESSAGE.SET_TOKEN('TOKEN2',token2_val);
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,

Line 2268: fnd_log.string_with_context( fnd_log.level_procedure,

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);
2272: END IF;

Line 2318: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

2314: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
2315: FND_MESSAGE.SET_TOKEN('TOKEN2',token2_val);
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,

Line 2322: fnd_log.string_with_context( fnd_log.level_procedure,

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);
2326: END IF;

Line 2455: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

2451: gv_log_key,
2452: NULL,
2453: v_other_detail);
2454:
2455: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2456: v_other_detail := 'CIR' || '|' || 'I' || '|' ||v_new_cal_type|| '|' ||v_new_sequence_number|| '|' ||'CREATED BY ROLLOVER';
2457: fnd_log.string_with_context( fnd_log.level_statement,l_label,v_other_detail, NULL,NULL,NULL,NULL,NULL,l_roll_seq);
2458: END IF;
2459:

Line 2457: fnd_log.string_with_context( fnd_log.level_statement,l_label,v_other_detail, NULL,NULL,NULL,NULL,NULL,l_roll_seq);

2453: v_other_detail);
2454:
2455: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2456: v_other_detail := 'CIR' || '|' || 'I' || '|' ||v_new_cal_type|| '|' ||v_new_sequence_number|| '|' ||'CREATED BY ROLLOVER';
2457: fnd_log.string_with_context( fnd_log.level_statement,l_label,v_other_detail, NULL,NULL,NULL,NULL,NULL,l_roll_seq);
2458: END IF;
2459:
2460: END IF;
2461: -- Insert new calendar instance into calendar instance relationships

Line 2625: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

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;
2628:
2629: fnd_log.string_with_context( fnd_log.level_procedure,

Line 2629: fnd_log.string_with_context( fnd_log.level_procedure,

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;
2628:
2629: fnd_log.string_with_context( fnd_log.level_procedure,
2630: l_label,
2631: l_debug_str, NULL,
2632: NULL,NULL,NULL,NULL,l_roll_seq);
2633: END IF;