290:
291: token2_val := p_val_cal_type||' '||IGS_GE_DATE.IGSCHAR(v_val_start_dt)||'-'||
292: IGS_GE_DATE.IGSCHAR(v_val_end_dt);
293:
294: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_REL_CAL_NOT_EXIST');
295: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
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;
291: token2_val := p_val_cal_type||' '||IGS_GE_DATE.IGSCHAR(v_val_start_dt)||'-'||
292: IGS_GE_DATE.IGSCHAR(v_val_end_dt);
293:
294: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_REL_CAL_NOT_EXIST');
295: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
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:
292: IGS_GE_DATE.IGSCHAR(v_val_end_dt);
293:
294: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_REL_CAL_NOT_EXIST');
295: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
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
293:
294: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_REL_CAL_NOT_EXIST');
295: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
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:
294: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_REL_CAL_NOT_EXIST');
295: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
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';
325:
326: token2_val := p_val_cal_type||' '||IGS_GE_DATE.IGSCHAR(v_val_start_dt)||'-'||
327: IGS_GE_DATE.IGSCHAR(v_val_end_dt);
328:
329: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_REL_CAL_INACTIVE');
330: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
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;
326: token2_val := p_val_cal_type||' '||IGS_GE_DATE.IGSCHAR(v_val_start_dt)||'-'||
327: IGS_GE_DATE.IGSCHAR(v_val_end_dt);
328:
329: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_REL_CAL_INACTIVE');
330: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
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:
327: IGS_GE_DATE.IGSCHAR(v_val_end_dt);
328:
329: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_REL_CAL_INACTIVE');
330: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
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
328:
329: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_REL_CAL_INACTIVE');
330: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
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:
329: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_REL_CAL_INACTIVE');
330: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
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';
363: ' '||p_val_cal_type||' '||IGS_GE_DATE.IGSCHAR(v_val_start_dt)||
364: '-'||IGS_GE_DATE.IGSCHAR(v_val_end_dt);
365:
366:
367: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_NO_REL_DTALIAS_EXIST');
368: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
369: FND_MESSAGE.SET_TOKEN('TOKEN2',token2_val);
370: v_other_detail:=FND_MESSAGE.GET;
371:
364: '-'||IGS_GE_DATE.IGSCHAR(v_val_end_dt);
365:
366:
367: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_NO_REL_DTALIAS_EXIST');
368: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
369: FND_MESSAGE.SET_TOKEN('TOKEN2',token2_val);
370: v_other_detail:=FND_MESSAGE.GET;
371:
372:
365:
366:
367: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_NO_REL_DTALIAS_EXIST');
368: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
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
366:
367: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_NO_REL_DTALIAS_EXIST');
368: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
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:
398:
399: token2_val := p_val_dt_alias||' '||p_val_cal_type||' '||IGS_GE_DATE.IGSCHAR(v_val_start_dt)||
400: '-'||IGS_GE_DATE.IGSCHAR(v_val_end_dt)||'.';
401:
402: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_NON_UNIQUE_REL_DTALIAS');
403: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
404: FND_MESSAGE.SET_TOKEN('TOKEN2',token2_val);
405: v_other_detail:=FND_MESSAGE.GET;
406:
399: token2_val := p_val_dt_alias||' '||p_val_cal_type||' '||IGS_GE_DATE.IGSCHAR(v_val_start_dt)||
400: '-'||IGS_GE_DATE.IGSCHAR(v_val_end_dt)||'.';
401:
402: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_NON_UNIQUE_REL_DTALIAS');
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
400: '-'||IGS_GE_DATE.IGSCHAR(v_val_end_dt)||'.';
401:
402: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_NON_UNIQUE_REL_DTALIAS');
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:
401:
402: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_NON_UNIQUE_REL_DTALIAS');
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';
475: ' '||p_val_cal_type||' '||IGS_GE_DATE.IGSCHAR(v_val_start_dt)||
476: '-'||IGS_GE_DATE.IGSCHAR(v_val_end_dt);
477:
478:
479: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_NO_REL_DTALIAS_EXIST');
480: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
481: FND_MESSAGE.SET_TOKEN('TOKEN2',token2_val);
482: v_other_detail:=FND_MESSAGE.GET;
483:
476: '-'||IGS_GE_DATE.IGSCHAR(v_val_end_dt);
477:
478:
479: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_NO_REL_DTALIAS_EXIST');
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
477:
478:
479: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_NO_REL_DTALIAS_EXIST');
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:
478:
479: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_NO_REL_DTALIAS_EXIST');
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';
506:
507: token2_val := p_cal_type||' '||IGS_GE_DATE.IGSCHAR(v_dairn_start_dt)||
508: '-'||IGS_GE_DATE.IGSCHAR(v_dairn_end_dt);
509:
510: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_REL_CAL_NOT_EXIST');
511: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
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;
507: token2_val := p_cal_type||' '||IGS_GE_DATE.IGSCHAR(v_dairn_start_dt)||
508: '-'||IGS_GE_DATE.IGSCHAR(v_dairn_end_dt);
509:
510: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_REL_CAL_NOT_EXIST');
511: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
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:
508: '-'||IGS_GE_DATE.IGSCHAR(v_dairn_end_dt);
509:
510: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_REL_CAL_NOT_EXIST');
511: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
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
509:
510: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_REL_CAL_NOT_EXIST');
511: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
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:
510: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_REL_CAL_NOT_EXIST');
511: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
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';
900: token2_val := p_val_cal_type||' '||IGS_GE_DATE.IGSCHAR(v_val_start_dt)||
901: '-'||IGS_GE_DATE.IGSCHAR(v_val_end_dt);
902:
903:
904: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_OFFSET_CAL_NOT_EXIST');
905: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
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;
901: '-'||IGS_GE_DATE.IGSCHAR(v_val_end_dt);
902:
903:
904: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_OFFSET_CAL_NOT_EXIST');
905: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
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:
902:
903:
904: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_OFFSET_CAL_NOT_EXIST');
905: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
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
903:
904: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_OFFSET_CAL_NOT_EXIST');
905: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
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:
904: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_OFFSET_CAL_NOT_EXIST');
905: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
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';
935:
936: token2_val := p_val_cal_type||' '||IGS_GE_DATE.IGSCHAR(v_val_start_dt)||'-'||
937: IGS_GE_DATE.IGSCHAR(v_val_end_dt);
938:
939: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_OFFSET_CAL_INACTIVE');
940: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
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;
936: token2_val := p_val_cal_type||' '||IGS_GE_DATE.IGSCHAR(v_val_start_dt)||'-'||
937: IGS_GE_DATE.IGSCHAR(v_val_end_dt);
938:
939: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_OFFSET_CAL_INACTIVE');
940: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
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:
937: IGS_GE_DATE.IGSCHAR(v_val_end_dt);
938:
939: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_OFFSET_CAL_INACTIVE');
940: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
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
938:
939: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_OFFSET_CAL_INACTIVE');
940: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
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:
939: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_OFFSET_CAL_INACTIVE');
940: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
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';
971: ' '||p_val_cal_type||' '||IGS_GE_DATE.IGSCHAR(v_val_start_dt)||
972: '-'||IGS_GE_DATE.IGSCHAR(v_val_end_dt);
973:
974:
975: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_NO_OFFSET_DTALIAS_EXIST');
976: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
977: FND_MESSAGE.SET_TOKEN('TOKEN2',token2_val);
978: v_other_detail:=FND_MESSAGE.GET;
979:
972: '-'||IGS_GE_DATE.IGSCHAR(v_val_end_dt);
973:
974:
975: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_NO_OFFSET_DTALIAS_EXIST');
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
973:
974:
975: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_NO_OFFSET_DTALIAS_EXIST');
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:
974:
975: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_NO_OFFSET_DTALIAS_EXIST');
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';
1005: token2_val := p_val_dt_alias||' '||p_val_cal_type||
1006: ' '||IGS_GE_DATE.IGSCHAR(v_val_start_dt)||
1007: '-'||IGS_GE_DATE.IGSCHAR(v_val_end_dt)||'.';
1008:
1009: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_DUP_OFFSET_DTALIAS');
1010: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
1011: FND_MESSAGE.SET_TOKEN('TOKEN2',token2_val);
1012: v_other_detail:=FND_MESSAGE.GET;
1013:
1006: ' '||IGS_GE_DATE.IGSCHAR(v_val_start_dt)||
1007: '-'||IGS_GE_DATE.IGSCHAR(v_val_end_dt)||'.';
1008:
1009: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_DUP_OFFSET_DTALIAS');
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
1007: '-'||IGS_GE_DATE.IGSCHAR(v_val_end_dt)||'.';
1008:
1009: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_DUP_OFFSET_DTALIAS');
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:
1008:
1009: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_DUP_OFFSET_DTALIAS');
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';
1131: token2_val := p_dt_alias||'('||p_dai_sequence_number||')'||
1132: ' '||p_cal_type||' '||IGS_GE_DATE.IGSCHAR(v_val_start_dt)||
1133: '-'||IGS_GE_DATE.IGSCHAR(v_val_end_dt);
1134:
1135: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_NO_OFFSET_DTALIAS_EXIST');
1136: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
1137: FND_MESSAGE.SET_TOKEN('TOKEN2',token2_val);
1138: v_other_detail:=FND_MESSAGE.GET;
1139:
1132: ' '||p_cal_type||' '||IGS_GE_DATE.IGSCHAR(v_val_start_dt)||
1133: '-'||IGS_GE_DATE.IGSCHAR(v_val_end_dt);
1134:
1135: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_NO_OFFSET_DTALIAS_EXIST');
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
1133: '-'||IGS_GE_DATE.IGSCHAR(v_val_end_dt);
1134:
1135: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_NO_OFFSET_DTALIAS_EXIST');
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:
1134:
1135: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_NO_OFFSET_DTALIAS_EXIST');
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';
1163: token2_val := p_cal_type||' '||IGS_GE_DATE.IGSCHAR(v_dairn_start_dt)||
1164: '-'||IGS_GE_DATE.IGSCHAR(v_dairn_end_dt);
1165:
1166:
1167: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_OFFSET_CAL_NOT_EXIST');
1168: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
1169: FND_MESSAGE.SET_TOKEN('TOKEN2',token2_val);
1170: FND_MESSAGE.SET_TOKEN('TOKEN3',p_dt_alias);
1171: v_other_detail:=FND_MESSAGE.GET;
1164: '-'||IGS_GE_DATE.IGSCHAR(v_dairn_end_dt);
1165:
1166:
1167: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_OFFSET_CAL_NOT_EXIST');
1168: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
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:
1165:
1166:
1167: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_OFFSET_CAL_NOT_EXIST');
1168: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
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
1166:
1167: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_OFFSET_CAL_NOT_EXIST');
1168: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
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:
1167: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_OFFSET_CAL_NOT_EXIST');
1168: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
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';
1334: IF v_message_name = 'IGS_CA_DTALIAS_CLOSED' THEN
1335:
1336: token1_val := p_rollover_cal_type|| '|' ||p_rollover_ci_sequence_number|| '|' ;
1337:
1338: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_DTALIAS_INS_CLOSED');
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:
1335:
1336: token1_val := p_rollover_cal_type|| '|' ||p_rollover_ci_sequence_number|| '|' ;
1337:
1338: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_DTALIAS_INS_CLOSED');
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
1336: token1_val := p_rollover_cal_type|| '|' ||p_rollover_ci_sequence_number|| '|' ;
1337:
1338: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_DTALIAS_INS_CLOSED');
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:
1337:
1338: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_DTALIAS_INS_CLOSED');
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';
1359: ELSIF v_message_name = 'IGS_CA_DTALIAS_CALCAT_NOMATCH' THEN
1360:
1361: token1_val := p_rollover_cal_type|| '|' ||p_rollover_ci_sequence_number|| '|' ;
1362:
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
1360:
1361: token1_val := p_rollover_cal_type|| '|' ||p_rollover_ci_sequence_number|| '|' ;
1362:
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:
1361: token1_val := p_rollover_cal_type|| '|' ||p_rollover_ci_sequence_number|| '|' ;
1362:
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';
1362:
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;
1390: v_message_name) = FALSE THEN
1391:
1392: token1_val := p_rollover_cal_type|| '|' ||p_rollover_ci_sequence_number|| '|' ;
1393:
1394: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_DT_ADMPRD_OVRIDE_DT');
1395: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
1396: v_other_detail:=FND_MESSAGE.GET;
1397:
1398: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
1391:
1392: token1_val := p_rollover_cal_type|| '|' ||p_rollover_ci_sequence_number|| '|' ;
1393:
1394: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_DT_ADMPRD_OVRIDE_DT');
1395: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
1396: v_other_detail:=FND_MESSAGE.GET;
1397:
1398: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
1399: gv_log_type,
1392: token1_val := p_rollover_cal_type|| '|' ||p_rollover_ci_sequence_number|| '|' ;
1393:
1394: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_DT_ADMPRD_OVRIDE_DT');
1395: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
1396: v_other_detail:=FND_MESSAGE.GET;
1397:
1398: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
1399: gv_log_type,
1400: gv_log_creation_dt,
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);
1754:
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
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);
1754:
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:
1753: '-'||IGS_GE_DATE.IGSCHAR(v_derived_end_dt);
1754:
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';
1754:
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;
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);
1788:
1789: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_SUP_CAL_INVALID_REL');
1790: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
1791: FND_MESSAGE.SET_TOKEN('TOKEN2',token2_val);
1792: v_other_detail:=FND_MESSAGE.GET;
1793:
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);
1788:
1789: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_SUP_CAL_INVALID_REL');
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
1787: '-'||IGS_GE_DATE.IGSCHAR(v_derived_end_dt);
1788:
1789: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_SUP_CAL_INVALID_REL');
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:
1788:
1789: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_SUP_CAL_INVALID_REL');
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';
1853: EXCEPTION
1854:
1855: -- locking conflict exception.
1856: WHEN e_resource_busy THEN
1857: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_LOCKED');
1858: IGS_GE_MSG_STACK.ADD;
1859: WHEN OTHERS THEN
1860:
1861: RAISE;
1873: token1_val := p_sub_cal_type || '|' ||p_sub_ci_sequence_number || '|' ;
1874: token2_val := v_cal_inst_rec.CAL_TYPE||' '||IGS_GE_DATE.IGSCHAR(v_derived_start_dt) ||
1875: '-'||IGS_GE_DATE.IGSCHAR(v_derived_end_dt);
1876:
1877: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_SUP_CAL_NOT_EXIST');
1878: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
1879: FND_MESSAGE.SET_TOKEN('TOKEN2',token2_val);
1880: v_other_detail:=FND_MESSAGE.GET;
1881:
1874: token2_val := v_cal_inst_rec.CAL_TYPE||' '||IGS_GE_DATE.IGSCHAR(v_derived_start_dt) ||
1875: '-'||IGS_GE_DATE.IGSCHAR(v_derived_end_dt);
1876:
1877: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_SUP_CAL_NOT_EXIST');
1878: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
1879: FND_MESSAGE.SET_TOKEN('TOKEN2',token2_val);
1880: v_other_detail:=FND_MESSAGE.GET;
1881:
1882: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
1875: '-'||IGS_GE_DATE.IGSCHAR(v_derived_end_dt);
1876:
1877: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_SUP_CAL_NOT_EXIST');
1878: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
1879: FND_MESSAGE.SET_TOKEN('TOKEN2',token2_val);
1880: v_other_detail:=FND_MESSAGE.GET;
1881:
1882: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
1883: gv_log_type,
1876:
1877: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_SUP_CAL_NOT_EXIST');
1878: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
1879: FND_MESSAGE.SET_TOKEN('TOKEN2',token2_val);
1880: v_other_detail:=FND_MESSAGE.GET;
1881:
1882: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
1883: gv_log_type,
1884: gv_log_creation_dt,
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) ||
1932: '-'||IGS_GE_DATE.IGSCHAR(v_derived_end_dt);
1933:
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
1931: token2_val := v_cal_inst_rec.CAL_TYPE ||' '||IGS_GE_DATE.IGSCHAR(v_derived_start_dt) ||
1932: '-'||IGS_GE_DATE.IGSCHAR(v_derived_end_dt);
1933:
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:
1932: '-'||IGS_GE_DATE.IGSCHAR(v_derived_end_dt);
1933:
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';
1933:
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;
1968: token1_val := p_sub_cal_type || '|' ||p_sub_ci_sequence_number || '|' ;
1969: token2_val := v_cal_inst_rec.CAL_TYPE ||' '||IGS_GE_DATE.IGSCHAR(v_cal_inst_rec.start_dt) ||
1970: '-'||IGS_GE_DATE.IGSCHAR(v_cal_inst_rec.end_dt);
1971:
1972: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_SUP_CAL_NOT_EXIST');
1973: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
1974: FND_MESSAGE.SET_TOKEN('TOKEN2',token2_val);
1975: v_other_detail:=FND_MESSAGE.GET;
1976: BEGIN
1969: token2_val := v_cal_inst_rec.CAL_TYPE ||' '||IGS_GE_DATE.IGSCHAR(v_cal_inst_rec.start_dt) ||
1970: '-'||IGS_GE_DATE.IGSCHAR(v_cal_inst_rec.end_dt);
1971:
1972: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_SUP_CAL_NOT_EXIST');
1973: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
1974: FND_MESSAGE.SET_TOKEN('TOKEN2',token2_val);
1975: v_other_detail:=FND_MESSAGE.GET;
1976: BEGIN
1977: -- Remove any exception errors previously inserted.
1970: '-'||IGS_GE_DATE.IGSCHAR(v_cal_inst_rec.end_dt);
1971:
1972: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_SUP_CAL_NOT_EXIST');
1973: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
1974: FND_MESSAGE.SET_TOKEN('TOKEN2',token2_val);
1975: v_other_detail:=FND_MESSAGE.GET;
1976: BEGIN
1977: -- Remove any exception errors previously inserted.
1978: FOR v_c_dummy_rec IN c_s_log_entry_cir(
1971:
1972: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_SUP_CAL_NOT_EXIST');
1973: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
1974: FND_MESSAGE.SET_TOKEN('TOKEN2',token2_val);
1975: v_other_detail:=FND_MESSAGE.GET;
1976: BEGIN
1977: -- Remove any exception errors previously inserted.
1978: FOR v_c_dummy_rec IN c_s_log_entry_cir(
1979: gv_log_type,
1986: END LOOP;
1987: EXCEPTION
1988: -- locking conflict exception.
1989: WHEN e_resource_busy THEN
1990: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_LOCKED');
1991: IGS_GE_MSG_STACK.ADD;
1992:
1993: END;
1994:
2210: IF(v_message_name = 'IGS_OR_LOC_TYPE_CLOSED') THEN
2211:
2212:
2213: token1_val := p_cal_type || '|' ||p_sequence_number || '|';
2214: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_SUB_CAL_NOT_EXISTS');
2215: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
2216: FND_MESSAGE.SET_TOKEN('TOKEN2',p_cal_type);
2217: v_other_detail:=FND_MESSAGE.GET;
2218:
2211:
2212:
2213: token1_val := p_cal_type || '|' ||p_sequence_number || '|';
2214: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_SUB_CAL_NOT_EXISTS');
2215: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
2216: FND_MESSAGE.SET_TOKEN('TOKEN2',p_cal_type);
2217: v_other_detail:=FND_MESSAGE.GET;
2218:
2219: ELSIF(v_message_name = 'IGS_OR_ADDR_TYPE_CLOSE') THEN
2212:
2213: token1_val := p_cal_type || '|' ||p_sequence_number || '|';
2214: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_SUB_CAL_NOT_EXISTS');
2215: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
2216: FND_MESSAGE.SET_TOKEN('TOKEN2',p_cal_type);
2217: v_other_detail:=FND_MESSAGE.GET;
2218:
2219: ELSIF(v_message_name = 'IGS_OR_ADDR_TYPE_CLOSE') THEN
2220:
2213: token1_val := p_cal_type || '|' ||p_sequence_number || '|';
2214: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_SUB_CAL_NOT_EXISTS');
2215: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
2216: FND_MESSAGE.SET_TOKEN('TOKEN2',p_cal_type);
2217: v_other_detail:=FND_MESSAGE.GET;
2218:
2219: ELSIF(v_message_name = 'IGS_OR_ADDR_TYPE_CLOSE') THEN
2220:
2221: token1_val := p_cal_type || '|' ||p_sequence_number || '|';
2220:
2221: token1_val := p_cal_type || '|' ||p_sequence_number || '|';
2222: token2_val := p_cal_type||IGS_GE_DATE.IGSCHAR(v_new_start_dt) ||
2223: IGS_GE_DATE.IGSCHAR(v_new_end_dt) ;
2224: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_SUB_CAL_INACTIVE');
2225: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
2226: FND_MESSAGE.SET_TOKEN('TOKEN2',token2_val);
2227: v_other_detail:=FND_MESSAGE.GET;
2228:
2221: token1_val := p_cal_type || '|' ||p_sequence_number || '|';
2222: token2_val := p_cal_type||IGS_GE_DATE.IGSCHAR(v_new_start_dt) ||
2223: IGS_GE_DATE.IGSCHAR(v_new_end_dt) ;
2224: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_SUB_CAL_INACTIVE');
2225: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
2226: FND_MESSAGE.SET_TOKEN('TOKEN2',token2_val);
2227: v_other_detail:=FND_MESSAGE.GET;
2228:
2229: END IF;
2222: token2_val := p_cal_type||IGS_GE_DATE.IGSCHAR(v_new_start_dt) ||
2223: IGS_GE_DATE.IGSCHAR(v_new_end_dt) ;
2224: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_SUB_CAL_INACTIVE');
2225: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
2226: FND_MESSAGE.SET_TOKEN('TOKEN2',token2_val);
2227: v_other_detail:=FND_MESSAGE.GET;
2228:
2229: END IF;
2230:
2223: IGS_GE_DATE.IGSCHAR(v_new_end_dt) ;
2224: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_SUB_CAL_INACTIVE');
2225: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
2226: FND_MESSAGE.SET_TOKEN('TOKEN2',token2_val);
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
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) ;
2258:
2259: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_SUB_CAL_CLOSED');
2260: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
2261: FND_MESSAGE.SET_TOKEN('TOKEN2',token2_val);
2262: v_other_detail:=FND_MESSAGE.GET;
2263:
2256: token2_val := p_cal_type||IGS_GE_DATE.IGSCHAR(v_new_start_dt) ||
2257: IGS_GE_DATE.IGSCHAR(v_new_end_dt) ;
2258:
2259: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_SUB_CAL_CLOSED');
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
2257: IGS_GE_DATE.IGSCHAR(v_new_end_dt) ;
2258:
2259: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_SUB_CAL_CLOSED');
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:
2258:
2259: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_SUB_CAL_CLOSED');
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';
2309: token1_val := p_cal_type || '|' ||p_sequence_number || '|';
2310: token2_val := p_cal_type||IGS_GE_DATE.IGSCHAR(v_new_start_dt) ||
2311: IGS_GE_DATE.IGSCHAR(v_new_end_dt);
2312:
2313: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_SUB_CAL_EXISTS');
2314: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
2315: FND_MESSAGE.SET_TOKEN('TOKEN2',token2_val);
2316: v_other_detail:=FND_MESSAGE.GET;
2317:
2310: token2_val := p_cal_type||IGS_GE_DATE.IGSCHAR(v_new_start_dt) ||
2311: IGS_GE_DATE.IGSCHAR(v_new_end_dt);
2312:
2313: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_SUB_CAL_EXISTS');
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
2311: IGS_GE_DATE.IGSCHAR(v_new_end_dt);
2312:
2313: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_SUB_CAL_EXISTS');
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:
2312:
2313: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_SUB_CAL_EXISTS');
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';
2440: );
2441: -- Write to rollover messages
2442: token1_val := v_new_cal_type|| '|' ||v_new_sequence_number|| '|';
2443:
2444: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_ROLLOVER_CREATED');
2445: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
2446: v_other_detail:=FND_MESSAGE.GET;
2447:
2448: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
2441: -- Write to rollover messages
2442: token1_val := v_new_cal_type|| '|' ||v_new_sequence_number|| '|';
2443:
2444: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_ROLLOVER_CREATED');
2445: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
2446: v_other_detail:=FND_MESSAGE.GET;
2447:
2448: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
2449: gv_log_type,
2442: token1_val := v_new_cal_type|| '|' ||v_new_sequence_number|| '|';
2443:
2444: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_ROLLOVER_CREATED');
2445: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
2446: v_other_detail:=FND_MESSAGE.GET;
2447:
2448: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
2449: gv_log_type,
2450: gv_log_creation_dt,
2498: RETURN TRUE;
2499: /* EXCEPTION
2500: WHEN OTHERS THEN
2501:
2502: FND_MESSAGE.PARSE_ENCODED(FND_MESSAGE.GET_ENCODED, l_app, l_message_name);
2503:
2504: IF l_message_name = 'IGS_PE_UNIQUE_PID' THEN
2505: l_error_code := 'E567';
2506: ELSE
2505: l_error_code := 'E567';
2506: ELSE
2507: l_error_code := 'E322';
2508: END IF;
2509: fnd_message.set_name('IGS',l_message_name);
2510: app_exception.raise_exception;*/
2511: END;
2512: END calpl_ins_rollvr_ci;
2513: BEGIN
2797:
2798:
2799: token1_val := p_rollover_cal_type|| '|' ||p_rollover_sequence_number|| '|';
2800:
2801: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_ROLLOVER_NOT_CREATED');
2802: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
2803: v_other_detail:=FND_MESSAGE.GET;
2804:
2805: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
2798:
2799: token1_val := p_rollover_cal_type|| '|' ||p_rollover_sequence_number|| '|';
2800:
2801: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_ROLLOVER_NOT_CREATED');
2802: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
2803: v_other_detail:=FND_MESSAGE.GET;
2804:
2805: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
2806: gv_log_type,
2799: token1_val := p_rollover_cal_type|| '|' ||p_rollover_sequence_number|| '|';
2800:
2801: FND_MESSAGE.SET_NAME('IGS', 'IGS_CA_ROLLOVER_NOT_CREATED');
2802: FND_MESSAGE.SET_TOKEN('TOKEN1',token1_val);
2803: v_other_detail:=FND_MESSAGE.GET;
2804:
2805: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
2806: gv_log_type,
2807: gv_log_creation_dt,
2815: p_message_name := NULL;
2816: RETURN TRUE;
2817: EXCEPTION
2818: WHEN OTHERS THEN
2819: l_msg_txt := fnd_message.get;
2820: fnd_message.set_name('IGS','IGS_CA_GENERIC_MSG');
2821: IF l_func_name IS NULL THEN
2822: l_func_name := 'calp_ins_rollvr_ci';
2823: END IF;
2816: RETURN TRUE;
2817: EXCEPTION
2818: WHEN OTHERS THEN
2819: l_msg_txt := fnd_message.get;
2820: fnd_message.set_name('IGS','IGS_CA_GENERIC_MSG');
2821: IF l_func_name IS NULL THEN
2822: l_func_name := 'calp_ins_rollvr_ci';
2823: END IF;
2824: fnd_message.set_token('FUNC_NAME',l_func_name);
2820: fnd_message.set_name('IGS','IGS_CA_GENERIC_MSG');
2821: IF l_func_name IS NULL THEN
2822: l_func_name := 'calp_ins_rollvr_ci';
2823: END IF;
2824: fnd_message.set_token('FUNC_NAME',l_func_name);
2825: fnd_message.set_token('ERR_MSG',l_msg_txt);
2826: App_Exception.Raise_Exception;
2827: END;
2828: END calp_ins_rollvr_ci;
2821: IF l_func_name IS NULL THEN
2822: l_func_name := 'calp_ins_rollvr_ci';
2823: END IF;
2824: fnd_message.set_token('FUNC_NAME',l_func_name);
2825: fnd_message.set_token('ERR_MSG',l_msg_txt);
2826: App_Exception.Raise_Exception;
2827: END;
2828: END calp_ins_rollvr_ci;
2829: