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_VAL_QLITY dependencies on FND_MESSAGE

Line 115: fnd_message.Set_Name('IGS','IGS_CA_GR_ONE_DAI_CI');

111: CLOSE chk_one_per_cal;
112: IF (l_count > 1)
113: THEN
114: -- Log an entry in the LOG table.
115: fnd_message.Set_Name('IGS','IGS_CA_GR_ONE_DAI_CI');
116: fnd_message.set_token('DA',get_all_sda_rec.date_alias);
117: fnd_message.set_token('CAL_DESC',l_cal_desc);
118: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY (p_s_log_type,
119: p_log_creation_dt,

Line 116: fnd_message.set_token('DA',get_all_sda_rec.date_alias);

112: IF (l_count > 1)
113: THEN
114: -- Log an entry in the LOG table.
115: fnd_message.Set_Name('IGS','IGS_CA_GR_ONE_DAI_CI');
116: fnd_message.set_token('DA',get_all_sda_rec.date_alias);
117: fnd_message.set_token('CAL_DESC',l_cal_desc);
118: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY (p_s_log_type,
119: p_log_creation_dt,
120: 'DATES' || ',' || p_acad_cal_type || ',' ||TO_CHAR (p_acad_sequence_number),

Line 117: fnd_message.set_token('CAL_DESC',l_cal_desc);

113: THEN
114: -- Log an entry in the LOG table.
115: fnd_message.Set_Name('IGS','IGS_CA_GR_ONE_DAI_CI');
116: fnd_message.set_token('DA',get_all_sda_rec.date_alias);
117: fnd_message.set_token('CAL_DESC',l_cal_desc);
118: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY (p_s_log_type,
119: p_log_creation_dt,
120: 'DATES' || ',' || p_acad_cal_type || ',' ||TO_CHAR (p_acad_sequence_number),
121: NULL,

Line 122: fnd_message.get);

118: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY (p_s_log_type,
119: p_log_creation_dt,
120: 'DATES' || ',' || p_acad_cal_type || ',' ||TO_CHAR (p_acad_sequence_number),
121: NULL,
122: fnd_message.get);
123: END IF;
124: END LOOP;
125: ELSE
126: -- Open cursor with the restrictions on the cal category and run the loop.

Line 136: fnd_message.Set_Name('IGS','IGS_CA_GR_ONE_DAI_CI');

132: CLOSE chk_one_per_cal;
133: IF (l_count > 1)
134: THEN
135: -- Log an entry in the LOG table.
136: fnd_message.Set_Name('IGS','IGS_CA_GR_ONE_DAI_CI');
137: fnd_message.set_token('DA',get_all_sda_rec.date_alias);
138: fnd_message.set_token('CAL_DESC',l_cal_desc);
139: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY (p_s_log_type,
140: p_log_creation_dt,

Line 137: fnd_message.set_token('DA',get_all_sda_rec.date_alias);

133: IF (l_count > 1)
134: THEN
135: -- Log an entry in the LOG table.
136: fnd_message.Set_Name('IGS','IGS_CA_GR_ONE_DAI_CI');
137: fnd_message.set_token('DA',get_all_sda_rec.date_alias);
138: fnd_message.set_token('CAL_DESC',l_cal_desc);
139: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY (p_s_log_type,
140: p_log_creation_dt,
141: p_cal_cat || ',' || p_acad_cal_type || ',' ||TO_CHAR (p_acad_sequence_number),

Line 138: fnd_message.set_token('CAL_DESC',l_cal_desc);

134: THEN
135: -- Log an entry in the LOG table.
136: fnd_message.Set_Name('IGS','IGS_CA_GR_ONE_DAI_CI');
137: fnd_message.set_token('DA',get_all_sda_rec.date_alias);
138: fnd_message.set_token('CAL_DESC',l_cal_desc);
139: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY (p_s_log_type,
140: p_log_creation_dt,
141: p_cal_cat || ',' || p_acad_cal_type || ',' ||TO_CHAR (p_acad_sequence_number),
142: NULL,

Line 143: fnd_message.get);

139: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY (p_s_log_type,
140: p_log_creation_dt,
141: p_cal_cat || ',' || p_acad_cal_type || ',' ||TO_CHAR (p_acad_sequence_number),
142: NULL,
143: fnd_message.get);
144: END IF;
145: END LOOP;
146: END IF;
147:

Line 386: Fnd_Message.Set_Name('IGS', 'IGS_CA_NO_RES_EFF_DT');

382: CLOSE c_srcc;
383:
384:
385: --- added by syam
386: Fnd_Message.Set_Name('IGS', 'IGS_CA_NO_RES_EFF_DT');
387: --- added by syam
388:
389: --- added by syam
390: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY (

Line 397: fnd_message.get);

393: 'DATES' || ',' ||
394: p_acad_cal_type || ',' ||
395: TO_CHAR(p_acad_sequence_number),
396: NULL,
397: fnd_message.get);
398: --- added by syam
399:
400:
401:

Line 413: Fnd_Message.Set_Name('IGS', 'IGS_CA_RES_EFF_IN_CAL');

409: v_effective_strt_dt_alias,
410: v_effective_end_dt_alias) LOOP
411:
412: --- added by syam
413: Fnd_Message.Set_Name('IGS', 'IGS_CA_RES_EFF_IN_CAL');
414: fnd_message.set_token('TOKEN1',v_dai_cat_rec.CAL_TYPE || ',' ||v_dai_cat_rec.S_CAL_CAT);
415:
416: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY (
417: p_s_log_type,

Line 414: fnd_message.set_token('TOKEN1',v_dai_cat_rec.CAL_TYPE || ',' ||v_dai_cat_rec.S_CAL_CAT);

410: v_effective_end_dt_alias) LOOP
411:
412: --- added by syam
413: Fnd_Message.Set_Name('IGS', 'IGS_CA_RES_EFF_IN_CAL');
414: fnd_message.set_token('TOKEN1',v_dai_cat_rec.CAL_TYPE || ',' ||v_dai_cat_rec.S_CAL_CAT);
415:
416: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY (
417: p_s_log_type,
418: p_log_creation_dt,

Line 423: fnd_message.get);

419: 'DATES' || ',' ||
420: p_acad_cal_type || ',' ||
421: TO_CHAR(p_acad_sequence_number),
422: NULL,
423: fnd_message.get);
424: --- added by syam
425:
426:
427:

Line 475: Fnd_Message.Set_Name('IGS', 'IGS_CA_EFF_START_END');

471: (v_end_counter = 0 AND
472: v_strt_counter = 1) THEN
473:
474: --- added by syam
475: Fnd_Message.Set_Name('IGS', 'IGS_CA_EFF_START_END');
476:
477: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY (
478: p_s_log_type,
479: p_log_creation_dt,

Line 484: fnd_message.get);

480: 'RESEARCH' || ',' ||
481: v_ci_cs_cat_rec.CAL_TYPE || ',' ||
482: TO_CHAR(v_ci_cs_cat_rec.sequence_number),
483: NULL,
484: fnd_message.get);
485: --- added by syam
486:
487:
488: ELSE

Line 492: Fnd_Message.Set_Name('IGS', 'IGS_CA_EFF_DATES_OUT_OF_ORDER');

488: ELSE
489: IF v_out_of_order THEN
490:
491: --- added by syam
492: Fnd_Message.Set_Name('IGS', 'IGS_CA_EFF_DATES_OUT_OF_ORDER');
493:
494: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY (
495: p_s_log_type,
496: p_log_creation_dt,

Line 501: fnd_message.get);

497: 'RESEARCH' || ',' ||
498: v_ci_cs_cat_rec.CAL_TYPE || ',' ||
499: TO_CHAR(v_ci_cs_cat_rec.sequence_number),
500: NULL,
501: fnd_message.get);
502:
503: --- added by syam
504:
505:

Line 519: Fnd_Message.Set_Name('IGS', 'IGS_CA_TPERIOD_SINGLE_CENS');

515: CLOSE c_dai_sgcc;
516: IF v_count > 1 THEN
517:
518: --- added by syam
519: Fnd_Message.Set_Name('IGS', 'IGS_CA_TPERIOD_SINGLE_CENS');
520:
521: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY (
522: p_s_log_type,
523: p_log_creation_dt,

Line 528: fnd_message.get);

524: 'RESEARCH' || ',' ||
525: v_ci_cs_cat_rec.CAL_TYPE || ',' ||
526: TO_CHAR(v_ci_cs_cat_rec.sequence_number),
527: NULL,
528: fnd_message.get);
529: --- added by syam
530:
531: END IF;
532: END IF;

Line 544: Fnd_Message.Set_Name('IGS', 'IGS_CA_NORMAL_TP_STD_EFTSU_USE');

540: FETCH c_uop_uv INTO v_unit_cd;
541: IF c_uop_uv%FOUND THEN
542: CLOSE c_uop_uv;
543: --- added by syam
544: Fnd_Message.Set_Name('IGS', 'IGS_CA_NORMAL_TP_STD_EFTSU_USE');
545: fnd_message.set_token('TOKEN1',v_unit_cd);
546:
547: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY (
548: p_s_log_type,

Line 545: fnd_message.set_token('TOKEN1',v_unit_cd);

541: IF c_uop_uv%FOUND THEN
542: CLOSE c_uop_uv;
543: --- added by syam
544: Fnd_Message.Set_Name('IGS', 'IGS_CA_NORMAL_TP_STD_EFTSU_USE');
545: fnd_message.set_token('TOKEN1',v_unit_cd);
546:
547: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY (
548: p_s_log_type,
549: p_log_creation_dt,

Line 554: fnd_message.get);

550: 'RESEARCH' || ',' ||
551: v_ci_cs_cat_rec.CAL_TYPE || ',' ||
552: TO_CHAR(v_ci_cs_cat_rec.sequence_number),
553: NULL,
554: fnd_message.get);
555:
556: --- added by syam
557:
558: ELSE

Line 601: Fnd_Message.Set_Name('IGS', 'IGS_CA_RES_EFF_DATES_OVERLAP');

597:
598:
599:
600: --- added by syam
601: Fnd_Message.Set_Name('IGS', 'IGS_CA_RES_EFF_DATES_OVERLAP');
602: fnd_message.set_token('TOKEN1',v_dai_ci_cs_cat_rec.DT_ALIAS||':'|| IGS_GE_DATE.IGSCHAR(v_dai_ci_cs_cat_rec.alias_val)|| ', '||v_last_alias_type||':'||IGS_GE_DATE.IGSCHAR(v_last_alias_val));
603: --- added by syam
604:
605:

Line 602: fnd_message.set_token('TOKEN1',v_dai_ci_cs_cat_rec.DT_ALIAS||':'|| IGS_GE_DATE.IGSCHAR(v_dai_ci_cs_cat_rec.alias_val)|| ', '||v_last_alias_type||':'||IGS_GE_DATE.IGSCHAR(v_last_alias_val));

598:
599:
600: --- added by syam
601: Fnd_Message.Set_Name('IGS', 'IGS_CA_RES_EFF_DATES_OVERLAP');
602: fnd_message.set_token('TOKEN1',v_dai_ci_cs_cat_rec.DT_ALIAS||':'|| IGS_GE_DATE.IGSCHAR(v_dai_ci_cs_cat_rec.alias_val)|| ', '||v_last_alias_type||':'||IGS_GE_DATE.IGSCHAR(v_last_alias_val));
603: --- added by syam
604:
605:
606: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY (

Line 613: fnd_message.get);

609: 'RESEARCH' || ',' ||
610: p_acad_cal_type || ',' ||
611: TO_CHAR(p_acad_sequence_number),
612: NULL,
613: fnd_message.get);
614: --- added by syam
615:
616:
617:

Line 635: Fnd_Message.Set_Name('IGS', 'IGS_CA_GAP_BTW_EFF_PERIODS');

631: v_last_ci_sequence_number,
632: 'Y') = 'Y' THEN
633:
634: --- added by syam
635: Fnd_Message.Set_Name('IGS', 'IGS_CA_GAP_BTW_EFF_PERIODS');
636: fnd_message.set_token('TOKEN1',v_dai_ci_cs_cat_rec.DT_ALIAS||':'||IGS_GE_DATE.IGSCHAR(v_dai_ci_cs_cat_rec.alias_val)||', '||v_last_alias_type||':'||IGS_GE_DATE.IGSCHAR(v_last_alias_val));
637:
638: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY (
639: p_s_log_type,

Line 636: fnd_message.set_token('TOKEN1',v_dai_ci_cs_cat_rec.DT_ALIAS||':'||IGS_GE_DATE.IGSCHAR(v_dai_ci_cs_cat_rec.alias_val)||', '||v_last_alias_type||':'||IGS_GE_DATE.IGSCHAR(v_last_alias_val));

632: 'Y') = 'Y' THEN
633:
634: --- added by syam
635: Fnd_Message.Set_Name('IGS', 'IGS_CA_GAP_BTW_EFF_PERIODS');
636: fnd_message.set_token('TOKEN1',v_dai_ci_cs_cat_rec.DT_ALIAS||':'||IGS_GE_DATE.IGSCHAR(v_dai_ci_cs_cat_rec.alias_val)||', '||v_last_alias_type||':'||IGS_GE_DATE.IGSCHAR(v_last_alias_val));
637:
638: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY (
639: p_s_log_type,
640: p_log_creation_dt,

Line 645: fnd_message.get);

641: 'RESEARCH' || ',' ||
642: p_acad_cal_type || ',' ||
643: TO_CHAR(p_acad_sequence_number),
644: NULL,
645: fnd_message.get);
646: --- added by syam
647:
648:
649:

Line 675: Fnd_Message.Set_Name('IGS','IGS_CA_MULT_TP_SINGLE_CAL');

671: v_cir_cat_ci_cs_rec.sequence_number) LOOP
672: IF c_dla_cir_ci_cs%ROWCOUNT > 1 THEN
673:
674: --- added by syam
675: Fnd_Message.Set_Name('IGS','IGS_CA_MULT_TP_SINGLE_CAL');
676: fnd_message.set_token('TOKEN1',v_cir_cat_ci_cs_rec.CAL_TYPE);
677:
678: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY (
679: p_s_log_type,

Line 676: fnd_message.set_token('TOKEN1',v_cir_cat_ci_cs_rec.CAL_TYPE);

672: IF c_dla_cir_ci_cs%ROWCOUNT > 1 THEN
673:
674: --- added by syam
675: Fnd_Message.Set_Name('IGS','IGS_CA_MULT_TP_SINGLE_CAL');
676: fnd_message.set_token('TOKEN1',v_cir_cat_ci_cs_rec.CAL_TYPE);
677:
678: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY (
679: p_s_log_type,
680: p_log_creation_dt,

Line 685: fnd_message.get);

681: 'RESEARCH' || ',' ||
682: p_acad_cal_type || ',' ||
683: TO_CHAR(p_acad_sequence_number),
684: NULL,
685: fnd_message.get);
686: ---added by syam
687:
688:
689:

Line 701: Fnd_Message.Set_Name('IGS','IGS_CA_RES_PERCENT_NOT_100');

697: CLOSE c_cir_ci_cs_cat;
698: IF v_total_perc <> 100 THEN
699:
700: --- added by syam
701: Fnd_Message.Set_Name('IGS','IGS_CA_RES_PERCENT_NOT_100');
702:
703: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY (
704: p_s_log_type,
705: p_log_creation_dt,

Line 710: fnd_message.get);

706: 'RESEARCH' || ',' ||
707: p_acad_cal_type || ',' ||
708: TO_CHAR(p_acad_sequence_number),
709: NULL,
710: fnd_message.get);
711: --- added by syam
712:
713: END IF;
714: EXCEPTION

Line 750: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');

746: App_Exception.Raise_Exception;
747: END;
748: EXCEPTION
749: WHEN OTHERS THEN
750: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
751: FND_MESSAGE.SET_TOKEN('NAME','IGS_CA_VAL_QLITY.calp_val_research_ci');
752: IGS_GE_MSG_STACK.ADD;
753: lv_param_values:=p_acad_cal_type||','||(to_char(p_acad_sequence_number));
754: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');

Line 751: FND_MESSAGE.SET_TOKEN('NAME','IGS_CA_VAL_QLITY.calp_val_research_ci');

747: END;
748: EXCEPTION
749: WHEN OTHERS THEN
750: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
751: FND_MESSAGE.SET_TOKEN('NAME','IGS_CA_VAL_QLITY.calp_val_research_ci');
752: IGS_GE_MSG_STACK.ADD;
753: lv_param_values:=p_acad_cal_type||','||(to_char(p_acad_sequence_number));
754: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
755: FND_MESSAGE.SET_TOKEN('VALUE',lv_param_values);

Line 754: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');

750: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
751: FND_MESSAGE.SET_TOKEN('NAME','IGS_CA_VAL_QLITY.calp_val_research_ci');
752: IGS_GE_MSG_STACK.ADD;
753: lv_param_values:=p_acad_cal_type||','||(to_char(p_acad_sequence_number));
754: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
755: FND_MESSAGE.SET_TOKEN('VALUE',lv_param_values);
756: IGS_GE_MSG_STACK.ADD;
757: lv_param_values:=p_s_log_type ||','||(to_char(p_log_creation_dt));
758: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');

Line 755: FND_MESSAGE.SET_TOKEN('VALUE',lv_param_values);

751: FND_MESSAGE.SET_TOKEN('NAME','IGS_CA_VAL_QLITY.calp_val_research_ci');
752: IGS_GE_MSG_STACK.ADD;
753: lv_param_values:=p_acad_cal_type||','||(to_char(p_acad_sequence_number));
754: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
755: FND_MESSAGE.SET_TOKEN('VALUE',lv_param_values);
756: IGS_GE_MSG_STACK.ADD;
757: lv_param_values:=p_s_log_type ||','||(to_char(p_log_creation_dt));
758: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
759: FND_MESSAGE.SET_TOKEN('VALUE',lv_param_values);

Line 758: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');

754: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
755: FND_MESSAGE.SET_TOKEN('VALUE',lv_param_values);
756: IGS_GE_MSG_STACK.ADD;
757: lv_param_values:=p_s_log_type ||','||(to_char(p_log_creation_dt));
758: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
759: FND_MESSAGE.SET_TOKEN('VALUE',lv_param_values);
760: IGS_GE_MSG_STACK.ADD;
761: App_Exception.Raise_Exception;
762: END calp_val_research_ci;

Line 759: FND_MESSAGE.SET_TOKEN('VALUE',lv_param_values);

755: FND_MESSAGE.SET_TOKEN('VALUE',lv_param_values);
756: IGS_GE_MSG_STACK.ADD;
757: lv_param_values:=p_s_log_type ||','||(to_char(p_log_creation_dt));
758: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
759: FND_MESSAGE.SET_TOKEN('VALUE',lv_param_values);
760: IGS_GE_MSG_STACK.ADD;
761: App_Exception.Raise_Exception;
762: END calp_val_research_ci;
763: --

Line 1040: Fnd_Message.Set_Name('IGS','IGS_CA_ADMCAL_ONLY_1_ACADCAL');

1036: p_acad_sequence_number) LOOP
1037:
1038:
1039: --- added by syam
1040: Fnd_Message.Set_Name('IGS','IGS_CA_ADMCAL_ONLY_1_ACADCAL');
1041:
1042: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
1043: p_s_log_type,
1044: p_log_creation_dt,

Line 1047: fnd_message.get);

1043: p_s_log_type,
1044: p_log_creation_dt,
1045: cst_admission2 || v_cal_type || ',' || TO_CHAR(v_sequence_number),
1046: NULL,
1047: fnd_message.get);
1048:
1049:
1050: END LOOP;
1051: --Check that all admission periods have at least one direct

Line 1062: Fnd_Message.Set_Name('IGS','IGS_CA_ADMCAL_HAVE_1_ENROLCAL');

1058: IF c_cat_cir2%NOTFOUND THEN
1059: CLOSE c_cat_cir2;
1060:
1061: --- added by syam
1062: Fnd_Message.Set_Name('IGS','IGS_CA_ADMCAL_HAVE_1_ENROLCAL');
1063:
1064: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
1065: p_s_log_type,
1066: p_log_creation_dt,

Line 1069: fnd_message.get);

1065: p_s_log_type,
1066: p_log_creation_dt,
1067: cst_admission2|| v_cal_type ||',' || TO_CHAR(v_sequence_number),
1068: NULL,
1069: fnd_message.get);
1070: --- added by syam
1071:
1072:
1073: ELSE

Line 1084: FND_MESSAGE.SET_NAME('IGS','IGS_CA_ADMCAL_HAVE_1_LOAD');

1080: cp_n_sup_sequence_number => v_sequence_number
1081: );
1082: FETCH c_cir_5 INTO rec_c_cir_5;
1083: IF c_cir_5%NOTFOUND THEN
1084: FND_MESSAGE.SET_NAME('IGS','IGS_CA_ADMCAL_HAVE_1_LOAD');
1085: igs_ge_gen_003.genp_ins_log_entry( p_s_log_type,
1086: p_log_creation_dt,
1087: cst_admission2|| v_cal_type ||',' || TO_CHAR(v_sequence_number),
1088: NULL,

Line 1089: fnd_message.get

1085: igs_ge_gen_003.genp_ins_log_entry( p_s_log_type,
1086: p_log_creation_dt,
1087: cst_admission2|| v_cal_type ||',' || TO_CHAR(v_sequence_number),
1088: NULL,
1089: fnd_message.get
1090: );
1091: END IF;
1092: CLOSE c_cir_5;
1093:

Line 1100: FND_MESSAGE.SET_NAME('IGS','IGS_CA_ADM_CAL_SUB_LOAD');

1096: -- as subordinate calendar
1097: OPEN ad_rel_load(v_cal_type,v_sequence_number);
1098: FETCH ad_rel_load INTO v_count;
1099: IF v_count > 1 THEN
1100: FND_MESSAGE.SET_NAME('IGS','IGS_CA_ADM_CAL_SUB_LOAD');
1101: igs_ge_gen_003.genp_ins_log_entry( p_s_log_type,
1102: p_log_creation_dt,
1103: cst_admission2|| v_cal_type ||',' || TO_CHAR(v_sequence_number),
1104: NULL,

Line 1105: fnd_message.get

1101: igs_ge_gen_003.genp_ins_log_entry( p_s_log_type,
1102: p_log_creation_dt,
1103: cst_admission2|| v_cal_type ||',' || TO_CHAR(v_sequence_number),
1104: NULL,
1105: fnd_message.get
1106: );
1107: END IF;
1108: CLOSE ad_rel_load;
1109:

Line 1121: Fnd_Message.Set_Name('IGS','IGS_CA_ADMCAL_HAVE_1_TEACHCAL');

1117: END LOOP;
1118: IF(v_cir_4_rec_found = FALSE) THEN
1119:
1120: --- added by syam
1121: Fnd_Message.Set_Name('IGS','IGS_CA_ADMCAL_HAVE_1_TEACHCAL');
1122: --- added by syam
1123:
1124: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
1125: p_s_log_type,

Line 1129: fnd_message.get);

1125: p_s_log_type,
1126: p_log_creation_dt,
1127: cst_admission2 || v_cal_type || ',' || TO_CHAR(v_sequence_number),
1128: NULL,
1129: fnd_message.get);
1130: --- added by syam
1131:
1132: ELSE
1133: v_cir_4_rec_found := FALSE;

Line 1144: Fnd_Message.Set_Name('IGS','IGS_CA_ADMCAL_DEFINE_1_ADMCAT');

1140: END LOOP;
1141: IF(v_aal_rec_found = FALSE) THEN
1142:
1143: --- added by syam
1144: Fnd_Message.Set_Name('IGS','IGS_CA_ADMCAL_DEFINE_1_ADMCAT');
1145:
1146: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
1147: p_s_log_type,
1148: p_log_creation_dt,

Line 1151: fnd_message.get);

1147: p_s_log_type,
1148: p_log_creation_dt,
1149: cst_admission2 || v_cal_type || ',' || TO_CHAR(v_sequence_number),
1150: NULL,
1151: fnd_message.get);
1152: --- added by syam
1153:
1154:
1155: ELSE

Line 1167: fnd_Message.Set_Name('IGS','IGS_CA_ADMCAL_NO_INIT_DATE');

1163: END LOOP;
1164: IF(v_daiv_1_rec_found = FALSE) THEN
1165:
1166: --- added by syam
1167: fnd_Message.Set_Name('IGS','IGS_CA_ADMCAL_NO_INIT_DATE');
1168:
1169: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
1170: p_s_log_type,
1171: p_log_creation_dt,

Line 1174: fnd_message.get);

1170: p_s_log_type,
1171: p_log_creation_dt,
1172: cst_admission2 || v_cal_type || ',' || TO_CHAR(v_sequence_number),
1173: NULL,
1174: fnd_message.get);
1175: --- added by syam
1176:
1177: ELSE
1178: v_daiv_1_rec_found := FALSE;

Line 1189: fnd_Message.Set_Name('IGS','IGS_CA_ADMCAL_NO_ENCUMB_DATE');

1185: IF(v_daiv_2_rec_found = FALSE) THEN
1186:
1187:
1188: --- added by syam
1189: fnd_Message.Set_Name('IGS','IGS_CA_ADMCAL_NO_ENCUMB_DATE');
1190:
1191: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
1192: p_s_log_type,
1193: p_log_creation_dt,

Line 1196: fnd_message.get);

1192: p_s_log_type,
1193: p_log_creation_dt,
1194: cst_admission2 || v_cal_type || ',' || TO_CHAR(v_sequence_number),
1195: NULL,
1196: fnd_message.get);
1197:
1198:
1199: ELSE
1200: v_daiv_2_rec_found := FALSE;

Line 1211: fnd_Message.Set_Name('IGS','IGS_CA_ADMCAL_NO_PSCOURSE_DATE');

1207: IF(v_daiv_3_rec_found = FALSE) THEN
1208:
1209:
1210: --- added by syam
1211: fnd_Message.Set_Name('IGS','IGS_CA_ADMCAL_NO_PSCOURSE_DATE');
1212: --- added by syam
1213:
1214: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
1215: p_s_log_type,

Line 1219: fnd_message.get);

1215: p_s_log_type,
1216: p_log_creation_dt,
1217: cst_admission2 || v_cal_type || ',' || TO_CHAR(v_sequence_number),
1218: NULL,
1219: fnd_message.get);
1220:
1221: ELSE
1222: v_daiv_3_rec_found := FALSE;
1223: END IF;

Line 1237: fnd_Message.Set_Name('IGS','IGS_CA_ADMCAL_THAN_1_DUEDATE');

1233: IF(v_count > 1) THEN
1234:
1235:
1236: --- added by syam
1237: fnd_Message.Set_Name('IGS','IGS_CA_ADMCAL_THAN_1_DUEDATE');
1238:
1239: --- added by syam
1240:
1241: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(

Line 1246: fnd_message.get);

1242: p_s_log_type,
1243: p_log_creation_dt,
1244: cst_admission2 || v_cal_type || ',' || TO_CHAR(v_sequence_number),
1245: NULL,
1246: fnd_message.get);
1247:
1248:
1249: END IF;
1250: OPEN c_daiv_5(

Line 1259: fnd_Message.Set_Name('IGS','IGS_CA_ADMCAL_THAN_1_APPLDATE');

1255: IF(v_count > 1) THEN
1256:
1257:
1258: --- added by syam
1259: fnd_Message.Set_Name('IGS','IGS_CA_ADMCAL_THAN_1_APPLDATE');
1260: --- added by syam
1261:
1262: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
1263: p_s_log_type,

Line 1267: fnd_Message.get);

1263: p_s_log_type,
1264: p_log_creation_dt,
1265: cst_admission2 || v_cal_type || ',' || TO_CHAR(v_sequence_number),
1266: NULL,
1267: fnd_Message.get);
1268:
1269: END IF;
1270: OPEN c_daiv_6(
1271: v_cal_type,

Line 1278: fnd_Message.Set_Name('IGS','IGS_CA_ADMCAL_THAN_1_OFRDATE');

1274: CLOSE c_daiv_6;
1275: IF(v_count > 1) THEN
1276:
1277: --- added by syam
1278: fnd_Message.Set_Name('IGS','IGS_CA_ADMCAL_THAN_1_OFRDATE');
1279:
1280: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
1281: p_s_log_type,
1282: p_log_creation_dt,

Line 1285: fnd_message.get);

1281: p_s_log_type,
1282: p_log_creation_dt,
1283: cst_admission2 || v_cal_type || ',' || TO_CHAR(v_sequence_number),
1284: NULL,
1285: fnd_message.get);
1286: --- added by syam
1287:
1288: END IF;
1289: ELSE

Line 1296: fnd_Message.Set_Name('IGS','IGS_CA_ADMCAL_HAVE_1_ACADCAL');

1292: END LOOP; -- c_cir_1
1293: IF(v_cir_1_rec_found = FALSE) THEN
1294:
1295: --- added by syam
1296: fnd_Message.Set_Name('IGS','IGS_CA_ADMCAL_HAVE_1_ACADCAL');
1297:
1298: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
1299: p_s_log_type,
1300: p_log_creation_dt,

Line 1303: fnd_message.get);

1299: p_s_log_type,
1300: p_log_creation_dt,
1301: cst_admission2 || v_cal_type || ',' || TO_CHAR(v_sequence_number),
1302: NULL,
1303: fnd_message.get);
1304:
1305: --- added by syam
1306:
1307: ELSE

Line 1360: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');

1356: App_Exception.Raise_Exception;
1357: END;
1358: EXCEPTION
1359: WHEN OTHERS THEN
1360: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1361: FND_MESSAGE.SET_TOKEN('NAME','IGS_CA_VAL_QLITY.calp_val_adm_ci');
1362: IGS_GE_MSG_STACK.ADD;
1363: lv_param_values:=p_acad_cal_type||','||(to_char(p_acad_sequence_number));
1364: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');

Line 1361: FND_MESSAGE.SET_TOKEN('NAME','IGS_CA_VAL_QLITY.calp_val_adm_ci');

1357: END;
1358: EXCEPTION
1359: WHEN OTHERS THEN
1360: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1361: FND_MESSAGE.SET_TOKEN('NAME','IGS_CA_VAL_QLITY.calp_val_adm_ci');
1362: IGS_GE_MSG_STACK.ADD;
1363: lv_param_values:=p_acad_cal_type||','||(to_char(p_acad_sequence_number));
1364: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
1365: FND_MESSAGE.SET_TOKEN('VALUE',lv_param_values);

Line 1364: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');

1360: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1361: FND_MESSAGE.SET_TOKEN('NAME','IGS_CA_VAL_QLITY.calp_val_adm_ci');
1362: IGS_GE_MSG_STACK.ADD;
1363: lv_param_values:=p_acad_cal_type||','||(to_char(p_acad_sequence_number));
1364: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
1365: FND_MESSAGE.SET_TOKEN('VALUE',lv_param_values);
1366: IGS_GE_MSG_STACK.ADD;
1367: lv_param_values:=p_s_log_type||','||(to_char(p_log_creation_dt));
1368: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');

Line 1365: FND_MESSAGE.SET_TOKEN('VALUE',lv_param_values);

1361: FND_MESSAGE.SET_TOKEN('NAME','IGS_CA_VAL_QLITY.calp_val_adm_ci');
1362: IGS_GE_MSG_STACK.ADD;
1363: lv_param_values:=p_acad_cal_type||','||(to_char(p_acad_sequence_number));
1364: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
1365: FND_MESSAGE.SET_TOKEN('VALUE',lv_param_values);
1366: IGS_GE_MSG_STACK.ADD;
1367: lv_param_values:=p_s_log_type||','||(to_char(p_log_creation_dt));
1368: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
1369: FND_MESSAGE.SET_TOKEN('VALUE',lv_param_values);

Line 1368: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');

1364: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
1365: FND_MESSAGE.SET_TOKEN('VALUE',lv_param_values);
1366: IGS_GE_MSG_STACK.ADD;
1367: lv_param_values:=p_s_log_type||','||(to_char(p_log_creation_dt));
1368: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
1369: FND_MESSAGE.SET_TOKEN('VALUE',lv_param_values);
1370: IGS_GE_MSG_STACK.ADD;
1371: App_Exception.Raise_Exception;
1372: END calp_val_adm_ci;

Line 1369: FND_MESSAGE.SET_TOKEN('VALUE',lv_param_values);

1365: FND_MESSAGE.SET_TOKEN('VALUE',lv_param_values);
1366: IGS_GE_MSG_STACK.ADD;
1367: lv_param_values:=p_s_log_type||','||(to_char(p_log_creation_dt));
1368: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
1369: FND_MESSAGE.SET_TOKEN('VALUE',lv_param_values);
1370: IGS_GE_MSG_STACK.ADD;
1371: App_Exception.Raise_Exception;
1372: END calp_val_adm_ci;
1373:

Line 1483: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');

1479: RETURN v_creation_dt;
1480: END;
1481: EXCEPTION
1482: WHEN OTHERS THEN
1483: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1484: FND_MESSAGE.SET_TOKEN('NAME','IGS_CA_VAL_QLITY.calp_val_qual_chk');
1485: IGS_GE_MSG_STACK.ADD;
1486: lv_param_values:= p_acad_cal_type||','||(to_char(p_acad_sequence_number)) ;
1487: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');

Line 1484: FND_MESSAGE.SET_TOKEN('NAME','IGS_CA_VAL_QLITY.calp_val_qual_chk');

1480: END;
1481: EXCEPTION
1482: WHEN OTHERS THEN
1483: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1484: FND_MESSAGE.SET_TOKEN('NAME','IGS_CA_VAL_QLITY.calp_val_qual_chk');
1485: IGS_GE_MSG_STACK.ADD;
1486: lv_param_values:= p_acad_cal_type||','||(to_char(p_acad_sequence_number)) ;
1487: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
1488: FND_MESSAGE.SET_TOKEN('VALUE',lv_param_values);

Line 1487: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');

1483: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1484: FND_MESSAGE.SET_TOKEN('NAME','IGS_CA_VAL_QLITY.calp_val_qual_chk');
1485: IGS_GE_MSG_STACK.ADD;
1486: lv_param_values:= p_acad_cal_type||','||(to_char(p_acad_sequence_number)) ;
1487: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
1488: FND_MESSAGE.SET_TOKEN('VALUE',lv_param_values);
1489: IGS_GE_MSG_STACK.ADD;
1490: lv_param_values:= p_calendar_category ;
1491: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');

Line 1488: FND_MESSAGE.SET_TOKEN('VALUE',lv_param_values);

1484: FND_MESSAGE.SET_TOKEN('NAME','IGS_CA_VAL_QLITY.calp_val_qual_chk');
1485: IGS_GE_MSG_STACK.ADD;
1486: lv_param_values:= p_acad_cal_type||','||(to_char(p_acad_sequence_number)) ;
1487: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
1488: FND_MESSAGE.SET_TOKEN('VALUE',lv_param_values);
1489: IGS_GE_MSG_STACK.ADD;
1490: lv_param_values:= p_calendar_category ;
1491: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
1492: FND_MESSAGE.SET_TOKEN('VALUE',lv_param_values);

Line 1491: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');

1487: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
1488: FND_MESSAGE.SET_TOKEN('VALUE',lv_param_values);
1489: IGS_GE_MSG_STACK.ADD;
1490: lv_param_values:= p_calendar_category ;
1491: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
1492: FND_MESSAGE.SET_TOKEN('VALUE',lv_param_values);
1493: IGS_GE_MSG_STACK.ADD;
1494: App_Exception.Raise_Exception;
1495: END calp_val_qual_chk;

Line 1492: FND_MESSAGE.SET_TOKEN('VALUE',lv_param_values);

1488: FND_MESSAGE.SET_TOKEN('VALUE',lv_param_values);
1489: IGS_GE_MSG_STACK.ADD;
1490: lv_param_values:= p_calendar_category ;
1491: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
1492: FND_MESSAGE.SET_TOKEN('VALUE',lv_param_values);
1493: IGS_GE_MSG_STACK.ADD;
1494: App_Exception.Raise_Exception;
1495: END calp_val_qual_chk;
1496: --

Line 1566: fnd_Message.Set_Name('IGS','IGS_CA_LODEFFDT_WITHIN_CALINS');

1562: FETCH c_chk_da_exists INTO v_check_dt_alias_flag;
1563: IF c_chk_da_exists%FOUND THEN
1564:
1565: --- added by syam
1566: fnd_Message.Set_Name('IGS','IGS_CA_LODEFFDT_WITHIN_CALINS');
1567: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
1568: p_s_log_type,
1569: p_log_creation_dt,
1570: 'DATES' || ',' || p_acad_cal_type || ',' || TO_CHAR(p_acad_sequence_number),

Line 1572: fnd_message.get);

1568: p_s_log_type,
1569: p_log_creation_dt,
1570: 'DATES' || ',' || p_acad_cal_type || ',' || TO_CHAR(p_acad_sequence_number),
1571: NULL,
1572: fnd_message.get);
1573:
1574: --- added by syam
1575: END IF;
1576: CLOSE c_chk_da_exists;

Line 1584: fnd_Message.Set_Name('IGS','IGS_CA_COMMDT_WITHIN_CALINS');

1580: IF c_chk_da_exists%FOUND THEN
1581:
1582:
1583: --- added by syam
1584: fnd_Message.Set_Name('IGS','IGS_CA_COMMDT_WITHIN_CALINS');
1585: --- added by syam
1586:
1587: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
1588: p_s_log_type,

Line 1592: fnd_message.get);

1588: p_s_log_type,
1589: p_log_creation_dt,
1590: 'DATES' || ',' || p_acad_cal_type || ',' || TO_CHAR(p_acad_sequence_number),
1591: NULL,
1592: fnd_message.get);
1593:
1594: END IF;
1595: CLOSE c_chk_da_exists;
1596: END IF;

Line 1603: fnd_Message.Set_Name('IGS','IGS_CA_COMCUTOF_WITHIN_CALINS');

1599: FETCH c_chk_da_exists INTO v_check_dt_alias_flag;
1600: IF c_chk_da_exists%FOUND THEN
1601:
1602: --- added by syam
1603: fnd_Message.Set_Name('IGS','IGS_CA_COMCUTOF_WITHIN_CALINS');
1604: --- added by syam
1605: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
1606: p_s_log_type,
1607: p_log_creation_dt,

Line 1610: fnd_message.get);

1606: p_s_log_type,
1607: p_log_creation_dt,
1608: 'DATES' || ',' || p_acad_cal_type || ',' || TO_CHAR(p_acad_sequence_number),
1609: NULL,
1610: fnd_message.get);
1611:
1612: END IF;
1613: CLOSE c_chk_da_exists;
1614: END IF;

Line 1620: fnd_Message.Set_Name('IGS','IGS_CA_ENRDUEDT_WITHIN_CALINS');

1616: OPEN c_chk_da_exists1( v_enr_form_due_dt_alias, cst_academic, cst_enrolment );
1617: FETCH c_chk_da_exists1 INTO v_check_dt_alias_flag;
1618: IF c_chk_da_exists1%FOUND THEN
1619: --- added by syam
1620: fnd_Message.Set_Name('IGS','IGS_CA_ENRDUEDT_WITHIN_CALINS');
1621: --- added by syam
1622:
1623: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
1624: p_s_log_type,

Line 1628: fnd_message.get);

1624: p_s_log_type,
1625: p_log_creation_dt,
1626: 'DATES' || ',' || p_acad_cal_type || ',' || TO_CHAR(p_acad_sequence_number),
1627: NULL,
1628: fnd_message.get);
1629:
1630:
1631: END IF;
1632: CLOSE c_chk_da_exists1;

Line 1641: fnd_Message.Set_Name('IGS','IGS_CA_ENRPKGDT_WITHIN_CALINS');

1637: FETCH c_chk_da_exists1 INTO v_check_dt_alias_flag;
1638: IF c_chk_da_exists1%FOUND THEN
1639:
1640: --- added by syam
1641: fnd_Message.Set_Name('IGS','IGS_CA_ENRPKGDT_WITHIN_CALINS');
1642: --- added by syam
1643:
1644:
1645: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(

Line 1650: fnd_message.get);

1646: p_s_log_type,
1647: p_log_creation_dt,
1648: 'DATES' || ',' || p_acad_cal_type || ',' || TO_CHAR(p_acad_sequence_number),
1649: NULL,
1650: fnd_message.get);
1651:
1652:
1653: END IF;
1654: CLOSE c_chk_da_exists1;

Line 1659: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');

1655: END IF;
1656: END;
1657: EXCEPTION
1658: WHEN OTHERS THEN
1659: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1660: FND_MESSAGE.SET_TOKEN('NAME','IGS_CA_VAL_QLITY.calp_val_dates_ci');
1661: IGS_GE_MSG_STACK.ADD;
1662: lv_param_values:= p_acad_cal_type||','||(to_char(p_acad_sequence_number));
1663: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');

Line 1660: FND_MESSAGE.SET_TOKEN('NAME','IGS_CA_VAL_QLITY.calp_val_dates_ci');

1656: END;
1657: EXCEPTION
1658: WHEN OTHERS THEN
1659: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1660: FND_MESSAGE.SET_TOKEN('NAME','IGS_CA_VAL_QLITY.calp_val_dates_ci');
1661: IGS_GE_MSG_STACK.ADD;
1662: lv_param_values:= p_acad_cal_type||','||(to_char(p_acad_sequence_number));
1663: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
1664: FND_MESSAGE.SET_TOKEN('VALUE',lv_param_values);

Line 1663: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');

1659: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1660: FND_MESSAGE.SET_TOKEN('NAME','IGS_CA_VAL_QLITY.calp_val_dates_ci');
1661: IGS_GE_MSG_STACK.ADD;
1662: lv_param_values:= p_acad_cal_type||','||(to_char(p_acad_sequence_number));
1663: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
1664: FND_MESSAGE.SET_TOKEN('VALUE',lv_param_values);
1665: IGS_GE_MSG_STACK.ADD;
1666: lv_param_values:= p_s_log_type ||','||(to_char(p_log_creation_dt));
1667: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');

Line 1664: FND_MESSAGE.SET_TOKEN('VALUE',lv_param_values);

1660: FND_MESSAGE.SET_TOKEN('NAME','IGS_CA_VAL_QLITY.calp_val_dates_ci');
1661: IGS_GE_MSG_STACK.ADD;
1662: lv_param_values:= p_acad_cal_type||','||(to_char(p_acad_sequence_number));
1663: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
1664: FND_MESSAGE.SET_TOKEN('VALUE',lv_param_values);
1665: IGS_GE_MSG_STACK.ADD;
1666: lv_param_values:= p_s_log_type ||','||(to_char(p_log_creation_dt));
1667: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
1668: FND_MESSAGE.SET_TOKEN('VALUE',lv_param_values);

Line 1667: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');

1663: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
1664: FND_MESSAGE.SET_TOKEN('VALUE',lv_param_values);
1665: IGS_GE_MSG_STACK.ADD;
1666: lv_param_values:= p_s_log_type ||','||(to_char(p_log_creation_dt));
1667: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
1668: FND_MESSAGE.SET_TOKEN('VALUE',lv_param_values);
1669: IGS_GE_MSG_STACK.ADD;
1670: App_Exception.Raise_Exception;
1671: END calp_val_dates_ci;

Line 1668: FND_MESSAGE.SET_TOKEN('VALUE',lv_param_values);

1664: FND_MESSAGE.SET_TOKEN('VALUE',lv_param_values);
1665: IGS_GE_MSG_STACK.ADD;
1666: lv_param_values:= p_s_log_type ||','||(to_char(p_log_creation_dt));
1667: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
1668: FND_MESSAGE.SET_TOKEN('VALUE',lv_param_values);
1669: IGS_GE_MSG_STACK.ADD;
1670: App_Exception.Raise_Exception;
1671: END calp_val_dates_ci;
1672: --

Line 1735: fnd_Message.Set_Name('IGS','IGS_CA_ENRCAL_ONLY_ACADMCAL');

1731: FOR v_chk_acad_ci IN c_chk_acad_ci LOOP
1732:
1733: --------
1734: --- added by syam
1735: fnd_Message.Set_Name('IGS','IGS_CA_ENRCAL_ONLY_ACADMCAL');
1736: fnd_message.set_token('TOKEN1',v_chk_acad_ci.S_CAL_CAT);
1737:
1738:
1739: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY( p_s_log_type,

Line 1736: fnd_message.set_token('TOKEN1',v_chk_acad_ci.S_CAL_CAT);

1732:
1733: --------
1734: --- added by syam
1735: fnd_Message.Set_Name('IGS','IGS_CA_ENRCAL_ONLY_ACADMCAL');
1736: fnd_message.set_token('TOKEN1',v_chk_acad_ci.S_CAL_CAT);
1737:
1738:
1739: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY( p_s_log_type,
1740: p_log_creation_dt,

Line 1744: fnd_message.get);

1740: p_log_creation_dt,
1741: 'ENROLMENT,' || v_chk_acad_ci.cal_type || ',' ||
1742: TO_CHAR(v_chk_acad_ci.sequence_number),
1743: NULL,
1744: fnd_message.get);
1745: --- added by syam
1746:
1747: --- Select enrolment calendars which have subordinates of any type
1748: -- skpandey changed for loop position, earlier it was an independent loop

Line 1752: fnd_Message.Set_Name('IGS','IGS_CA_ENRCAL_NO_SUBORCAL');

1748: -- skpandey changed for loop position, earlier it was an independent loop
1749: FOR v_chk_enr_ci IN c_chk_enr_ci(v_chk_acad_ci.cal_type, v_chk_acad_ci.sequence_number) LOOP
1750:
1751: --- added by syam
1752: fnd_Message.Set_Name('IGS','IGS_CA_ENRCAL_NO_SUBORCAL');
1753: fnd_message.set_token('TOKEN1',v_chk_enr_ci.S_CAL_CAT);
1754: --- added by syam
1755:
1756:

Line 1753: fnd_message.set_token('TOKEN1',v_chk_enr_ci.S_CAL_CAT);

1749: FOR v_chk_enr_ci IN c_chk_enr_ci(v_chk_acad_ci.cal_type, v_chk_acad_ci.sequence_number) LOOP
1750:
1751: --- added by syam
1752: fnd_Message.Set_Name('IGS','IGS_CA_ENRCAL_NO_SUBORCAL');
1753: fnd_message.set_token('TOKEN1',v_chk_enr_ci.S_CAL_CAT);
1754: --- added by syam
1755:
1756:
1757: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(

Line 1763: fnd_message.get);

1759: p_log_creation_dt,
1760: 'ENROLMENT,' || v_chk_enr_ci.sup_cal_type || ',' ||
1761: TO_CHAR(v_chk_enr_ci.sup_ci_sequence_number),
1762: NULL,
1763: fnd_message.get);
1764:
1765: END LOOP;
1766:
1767: END LOOP;

Line 1772: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');

1768:
1769: END;
1770: EXCEPTION
1771: WHEN OTHERS THEN
1772: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1773: FND_MESSAGE.SET_TOKEN('NAME','IGS_CA_VAL_QLITY.calp_val_enrol_ci');
1774: IGS_GE_MSG_STACK.ADD;
1775: App_Exception.Raise_Exception;
1776: END calp_val_enrol_ci;

Line 1773: FND_MESSAGE.SET_TOKEN('NAME','IGS_CA_VAL_QLITY.calp_val_enrol_ci');

1769: END;
1770: EXCEPTION
1771: WHEN OTHERS THEN
1772: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1773: FND_MESSAGE.SET_TOKEN('NAME','IGS_CA_VAL_QLITY.calp_val_enrol_ci');
1774: IGS_GE_MSG_STACK.ADD;
1775: App_Exception.Raise_Exception;
1776: END calp_val_enrol_ci;
1777: --

Line 2031: fnd_Message.Set_Name('IGS','IGS_CA_LODCAL_ONLY_ACADMCAL');

2027: v_key := 'LOAD,' ||
2028: v_ci_cat_cs_rec.CAL_TYPE || ',' ||
2029: v_ci_cat_cs_rec.sequence_number;
2030: --- added by syam
2031: fnd_Message.Set_Name('IGS','IGS_CA_LODCAL_ONLY_ACADMCAL');
2032: fnd_message.set_token('TOKEN1',v_cir_ci_cat_rec.S_CAL_CAT);
2033: v_warning_msg := fnd_message.get;
2034: --- added by syam
2035:

Line 2032: fnd_message.set_token('TOKEN1',v_cir_ci_cat_rec.S_CAL_CAT);

2028: v_ci_cat_cs_rec.CAL_TYPE || ',' ||
2029: v_ci_cat_cs_rec.sequence_number;
2030: --- added by syam
2031: fnd_Message.Set_Name('IGS','IGS_CA_LODCAL_ONLY_ACADMCAL');
2032: fnd_message.set_token('TOKEN1',v_cir_ci_cat_rec.S_CAL_CAT);
2033: v_warning_msg := fnd_message.get;
2034: --- added by syam
2035:
2036:

Line 2033: v_warning_msg := fnd_message.get;

2029: v_ci_cat_cs_rec.sequence_number;
2030: --- added by syam
2031: fnd_Message.Set_Name('IGS','IGS_CA_LODCAL_ONLY_ACADMCAL');
2032: fnd_message.set_token('TOKEN1',v_cir_ci_cat_rec.S_CAL_CAT);
2033: v_warning_msg := fnd_message.get;
2034: --- added by syam
2035:
2036:
2037: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(

Line 2067: fnd_Message.Set_Name('IGS','IGS_CA_OVERLAP_LOAD_CAL'); -- new message for this check.

2063: LOOP
2064:
2065: v_key := 'LOAD,' || v_load_calendars.CAL_TYPE || ',' || v_load_calendars.sequence_number || ',' || l_overlap.alternate_code ; -- key for the log table.
2066:
2067: fnd_Message.Set_Name('IGS','IGS_CA_OVERLAP_LOAD_CAL'); -- new message for this check.
2068: fnd_message.set_token('TOKEN1',l_overlap.alternate_code);
2069: fnd_message.set_token('TOKEN2',l_overlap.description);
2070: fnd_message.set_token('TOKEN3',l_overlap.start_dt);
2071: fnd_message.set_token('TOKEN4',l_overlap.end_dt);

Line 2068: fnd_message.set_token('TOKEN1',l_overlap.alternate_code);

2064:
2065: v_key := 'LOAD,' || v_load_calendars.CAL_TYPE || ',' || v_load_calendars.sequence_number || ',' || l_overlap.alternate_code ; -- key for the log table.
2066:
2067: fnd_Message.Set_Name('IGS','IGS_CA_OVERLAP_LOAD_CAL'); -- new message for this check.
2068: fnd_message.set_token('TOKEN1',l_overlap.alternate_code);
2069: fnd_message.set_token('TOKEN2',l_overlap.description);
2070: fnd_message.set_token('TOKEN3',l_overlap.start_dt);
2071: fnd_message.set_token('TOKEN4',l_overlap.end_dt);
2072: v_warning_msg := fnd_message.get;

Line 2069: fnd_message.set_token('TOKEN2',l_overlap.description);

2065: v_key := 'LOAD,' || v_load_calendars.CAL_TYPE || ',' || v_load_calendars.sequence_number || ',' || l_overlap.alternate_code ; -- key for the log table.
2066:
2067: fnd_Message.Set_Name('IGS','IGS_CA_OVERLAP_LOAD_CAL'); -- new message for this check.
2068: fnd_message.set_token('TOKEN1',l_overlap.alternate_code);
2069: fnd_message.set_token('TOKEN2',l_overlap.description);
2070: fnd_message.set_token('TOKEN3',l_overlap.start_dt);
2071: fnd_message.set_token('TOKEN4',l_overlap.end_dt);
2072: v_warning_msg := fnd_message.get;
2073:

Line 2070: fnd_message.set_token('TOKEN3',l_overlap.start_dt);

2066:
2067: fnd_Message.Set_Name('IGS','IGS_CA_OVERLAP_LOAD_CAL'); -- new message for this check.
2068: fnd_message.set_token('TOKEN1',l_overlap.alternate_code);
2069: fnd_message.set_token('TOKEN2',l_overlap.description);
2070: fnd_message.set_token('TOKEN3',l_overlap.start_dt);
2071: fnd_message.set_token('TOKEN4',l_overlap.end_dt);
2072: v_warning_msg := fnd_message.get;
2073:
2074: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(p_s_log_type,

Line 2071: fnd_message.set_token('TOKEN4',l_overlap.end_dt);

2067: fnd_Message.Set_Name('IGS','IGS_CA_OVERLAP_LOAD_CAL'); -- new message for this check.
2068: fnd_message.set_token('TOKEN1',l_overlap.alternate_code);
2069: fnd_message.set_token('TOKEN2',l_overlap.description);
2070: fnd_message.set_token('TOKEN3',l_overlap.start_dt);
2071: fnd_message.set_token('TOKEN4',l_overlap.end_dt);
2072: v_warning_msg := fnd_message.get;
2073:
2074: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(p_s_log_type,
2075: p_log_creation_dt,

Line 2072: v_warning_msg := fnd_message.get;

2068: fnd_message.set_token('TOKEN1',l_overlap.alternate_code);
2069: fnd_message.set_token('TOKEN2',l_overlap.description);
2070: fnd_message.set_token('TOKEN3',l_overlap.start_dt);
2071: fnd_message.set_token('TOKEN4',l_overlap.end_dt);
2072: v_warning_msg := fnd_message.get;
2073:
2074: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(p_s_log_type,
2075: p_log_creation_dt,
2076: v_key,

Line 2100: fnd_Message.Set_Name('IGS','IGS_CA_LODCAL_NO_SUBORCAL');

2096: v_load_calendars.sequence_number;
2097:
2098:
2099: --- added by syam
2100: fnd_Message.Set_Name('IGS','IGS_CA_LODCAL_NO_SUBORCAL');
2101: fnd_message.set_token('TOKEN1',v_sub_cal_type);
2102: v_warning_msg := fnd_message.get;
2103: --- added by syam
2104:

Line 2101: fnd_message.set_token('TOKEN1',v_sub_cal_type);

2097:
2098:
2099: --- added by syam
2100: fnd_Message.Set_Name('IGS','IGS_CA_LODCAL_NO_SUBORCAL');
2101: fnd_message.set_token('TOKEN1',v_sub_cal_type);
2102: v_warning_msg := fnd_message.get;
2103: --- added by syam
2104:
2105:

Line 2102: v_warning_msg := fnd_message.get;

2098:
2099: --- added by syam
2100: fnd_Message.Set_Name('IGS','IGS_CA_LODCAL_NO_SUBORCAL');
2101: fnd_message.set_token('TOKEN1',v_sub_cal_type);
2102: v_warning_msg := fnd_message.get;
2103: --- added by syam
2104:
2105:
2106: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(

Line 2127: fnd_Message.Set_Name('IGS','IGS_CA_LODCAL_SUB_TO_1_CALINS');

2123: v_load_calendars.CAL_TYPE || ',' ||
2124: v_load_calendars.sequence_number;
2125:
2126: --- added by syam
2127: fnd_Message.Set_Name('IGS','IGS_CA_LODCAL_SUB_TO_1_CALINS');
2128: v_warning_msg := fnd_message.get;
2129: --- added by syam
2130:
2131: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(

Line 2128: v_warning_msg := fnd_message.get;

2124: v_load_calendars.sequence_number;
2125:
2126: --- added by syam
2127: fnd_Message.Set_Name('IGS','IGS_CA_LODCAL_SUB_TO_1_CALINS');
2128: v_warning_msg := fnd_message.get;
2129: --- added by syam
2130:
2131: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
2132: p_s_log_type,

Line 2150: FND_MESSAGE.SET_NAME('IGS','IGS_CA_LOAD_HAVE_1_AWDCAL');

2146: cp_n_sub_sequence_number => v_load_calendars.sequence_number
2147: );
2148: FETCH c_cir_6 INTO rec_c_cir_6;
2149: IF c_cir_6%NOTFOUND THEN
2150: FND_MESSAGE.SET_NAME('IGS','IGS_CA_LOAD_HAVE_1_AWDCAL');
2151: igs_ge_gen_003.genp_ins_log_entry( p_s_log_type,
2152: p_log_creation_dt,
2153: 'LOAD,'|| v_load_calendars.cal_type ||',' ||v_load_calendars.sequence_number,
2154: NULL,

Line 2155: fnd_message.get

2151: igs_ge_gen_003.genp_ins_log_entry( p_s_log_type,
2152: p_log_creation_dt,
2153: 'LOAD,'|| v_load_calendars.cal_type ||',' ||v_load_calendars.sequence_number,
2154: NULL,
2155: fnd_message.get
2156: );
2157: END IF;
2158: CLOSE c_cir_6;
2159:

Line 2167: FND_MESSAGE.SET_NAME('IGS','IGS_CA_LOAD_HAVE_1_ADMCAL');

2163: cp_n_sub_sequence_number => v_load_calendars.sequence_number
2164: );
2165: FETCH c_cir_9 INTO rec_c_cir_9;
2166: IF c_cir_9%NOTFOUND THEN
2167: FND_MESSAGE.SET_NAME('IGS','IGS_CA_LOAD_HAVE_1_ADMCAL');
2168: igs_ge_gen_003.genp_ins_log_entry( p_s_log_type,
2169: p_log_creation_dt,
2170: 'LOAD,'|| v_load_calendars.cal_type ||',' ||v_load_calendars.sequence_number,
2171: NULL,

Line 2172: fnd_message.get

2168: igs_ge_gen_003.genp_ins_log_entry( p_s_log_type,
2169: p_log_creation_dt,
2170: 'LOAD,'|| v_load_calendars.cal_type ||',' ||v_load_calendars.sequence_number,
2171: NULL,
2172: fnd_message.get
2173: );
2174: END IF;
2175: CLOSE c_cir_9;
2176:

Line 2193: fnd_Message.Set_Name('IGS','IGS_CA_LDCLINS_1_EFFDTALIAS');

2189: v_load_calendars.CAL_TYPE || ',' ||
2190: v_load_calendars.sequence_number;
2191:
2192: --- added by syam
2193: fnd_Message.Set_Name('IGS','IGS_CA_LDCLINS_1_EFFDTALIAS');
2194: v_warning_msg := fnd_message.get;
2195: --- added by syam
2196:
2197: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(

Line 2194: v_warning_msg := fnd_message.get;

2190: v_load_calendars.sequence_number;
2191:
2192: --- added by syam
2193: fnd_Message.Set_Name('IGS','IGS_CA_LDCLINS_1_EFFDTALIAS');
2194: v_warning_msg := fnd_message.get;
2195: --- added by syam
2196:
2197: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
2198: p_s_log_type,

Line 2220: fnd_Message.Set_Name('IGS','IGS_CA_CALTYPE_NO_INSACAD');

2216: v_load_calendars.sequence_number;
2217:
2218:
2219: --- added by syam
2220: fnd_Message.Set_Name('IGS','IGS_CA_CALTYPE_NO_INSACAD');
2221: fnd_message.set_token('TOKEN1',v_dla_rec.teach_cal_type);
2222: v_warning_msg := fnd_message.get;
2223: --- added by syam
2224:

Line 2221: fnd_message.set_token('TOKEN1',v_dla_rec.teach_cal_type);

2217:
2218:
2219: --- added by syam
2220: fnd_Message.Set_Name('IGS','IGS_CA_CALTYPE_NO_INSACAD');
2221: fnd_message.set_token('TOKEN1',v_dla_rec.teach_cal_type);
2222: v_warning_msg := fnd_message.get;
2223: --- added by syam
2224:
2225: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(

Line 2222: v_warning_msg := fnd_message.get;

2218:
2219: --- added by syam
2220: fnd_Message.Set_Name('IGS','IGS_CA_CALTYPE_NO_INSACAD');
2221: fnd_message.set_token('TOKEN1',v_dla_rec.teach_cal_type);
2222: v_warning_msg := fnd_message.get;
2223: --- added by syam
2224:
2225: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
2226: p_s_log_type,

Line 2245: fnd_Message.Set_Name('IGS','IGS_CA_TEACHCAL_1_INSACAD');

2241: v_load_calendars.sequence_number;
2242:
2243:
2244: --- added by syam
2245: fnd_Message.Set_Name('IGS','IGS_CA_TEACHCAL_1_INSACAD');
2246: fnd_message.set_token('TOKEN1',v_dla_rec.teach_cal_type);
2247: v_warning_msg := fnd_message.get;
2248: --- added by syam
2249:

Line 2246: fnd_message.set_token('TOKEN1',v_dla_rec.teach_cal_type);

2242:
2243:
2244: --- added by syam
2245: fnd_Message.Set_Name('IGS','IGS_CA_TEACHCAL_1_INSACAD');
2246: fnd_message.set_token('TOKEN1',v_dla_rec.teach_cal_type);
2247: v_warning_msg := fnd_message.get;
2248: --- added by syam
2249:
2250: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(

Line 2247: v_warning_msg := fnd_message.get;

2243:
2244: --- added by syam
2245: fnd_Message.Set_Name('IGS','IGS_CA_TEACHCAL_1_INSACAD');
2246: fnd_message.set_token('TOKEN1',v_dla_rec.teach_cal_type);
2247: v_warning_msg := fnd_message.get;
2248: --- added by syam
2249:
2250: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
2251: p_s_log_type,

Line 2272: fnd_Message.Set_Name('IGS','IGS_CA_ATTYPE_NO_LODDTL');

2268: v_load_calendars.CAL_TYPE || ',' ||
2269: v_load_calendars.sequence_number;
2270:
2271: --- added by syam
2272: fnd_Message.Set_Name('IGS','IGS_CA_ATTYPE_NO_LODDTL');
2273: fnd_message.set_token('TOKEN1',v_att_rec.ATTENDANCE_TYPE);
2274: v_warning_msg := fnd_message.get;
2275: --- added by syam
2276:

Line 2273: fnd_message.set_token('TOKEN1',v_att_rec.ATTENDANCE_TYPE);

2269: v_load_calendars.sequence_number;
2270:
2271: --- added by syam
2272: fnd_Message.Set_Name('IGS','IGS_CA_ATTYPE_NO_LODDTL');
2273: fnd_message.set_token('TOKEN1',v_att_rec.ATTENDANCE_TYPE);
2274: v_warning_msg := fnd_message.get;
2275: --- added by syam
2276:
2277: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(

Line 2274: v_warning_msg := fnd_message.get;

2270:
2271: --- added by syam
2272: fnd_Message.Set_Name('IGS','IGS_CA_ATTYPE_NO_LODDTL');
2273: fnd_message.set_token('TOKEN1',v_att_rec.ATTENDANCE_TYPE);
2274: v_warning_msg := fnd_message.get;
2275: --- added by syam
2276:
2277: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
2278: p_s_log_type,

Line 2299: fnd_Message.Set_Name('IGS','IGS_CA_GAP_BW_ATTYPE_LODRNGES');

2295: v_load_calendars.sequence_number;
2296:
2297:
2298: --- added by syam
2299: fnd_Message.Set_Name('IGS','IGS_CA_GAP_BW_ATTYPE_LODRNGES');
2300: v_warning_msg := fnd_message.get;
2301: --- added by syam
2302:
2303:

Line 2300: v_warning_msg := fnd_message.get;

2296:
2297:
2298: --- added by syam
2299: fnd_Message.Set_Name('IGS','IGS_CA_GAP_BW_ATTYPE_LODRNGES');
2300: v_warning_msg := fnd_message.get;
2301: --- added by syam
2302:
2303:
2304: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(

Line 2321: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');

2317: END LOOP; -- (IGS_CA_INST)
2318: END;
2319: EXCEPTION
2320: WHEN OTHERS THEN
2321: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
2322: FND_MESSAGE.SET_TOKEN('NAME','IGA_CA_VAL_QLITY.calp_val_load_ci');
2323: IGS_GE_MSG_STACK.ADD;
2324: lv_param_values:= p_acad_cal_type ||','||(to_char(p_acad_sequence_number))||','||p_s_log_type||','||(to_char(p_log_creation_dt));
2325: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');

Line 2322: FND_MESSAGE.SET_TOKEN('NAME','IGA_CA_VAL_QLITY.calp_val_load_ci');

2318: END;
2319: EXCEPTION
2320: WHEN OTHERS THEN
2321: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
2322: FND_MESSAGE.SET_TOKEN('NAME','IGA_CA_VAL_QLITY.calp_val_load_ci');
2323: IGS_GE_MSG_STACK.ADD;
2324: lv_param_values:= p_acad_cal_type ||','||(to_char(p_acad_sequence_number))||','||p_s_log_type||','||(to_char(p_log_creation_dt));
2325: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
2326: FND_MESSAGE.SET_TOKEN('VALUE',lv_param_values);

Line 2325: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');

2321: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
2322: FND_MESSAGE.SET_TOKEN('NAME','IGA_CA_VAL_QLITY.calp_val_load_ci');
2323: IGS_GE_MSG_STACK.ADD;
2324: lv_param_values:= p_acad_cal_type ||','||(to_char(p_acad_sequence_number))||','||p_s_log_type||','||(to_char(p_log_creation_dt));
2325: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
2326: FND_MESSAGE.SET_TOKEN('VALUE',lv_param_values);
2327: IGS_GE_MSG_STACK.ADD;
2328: App_Exception.Raise_Exception;
2329: END calp_val_load_ci;

Line 2326: FND_MESSAGE.SET_TOKEN('VALUE',lv_param_values);

2322: FND_MESSAGE.SET_TOKEN('NAME','IGA_CA_VAL_QLITY.calp_val_load_ci');
2323: IGS_GE_MSG_STACK.ADD;
2324: lv_param_values:= p_acad_cal_type ||','||(to_char(p_acad_sequence_number))||','||p_s_log_type||','||(to_char(p_log_creation_dt));
2325: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
2326: FND_MESSAGE.SET_TOKEN('VALUE',lv_param_values);
2327: IGS_GE_MSG_STACK.ADD;
2328: App_Exception.Raise_Exception;
2329: END calp_val_load_ci;
2330: --

Line 2577: fnd_Message.set_name('IGS','IGS_CA_TEACHCAL_SUP_ACEXASCAL');

2573: IF v_chk_acad_fee_ci_rec.s_cal_cat NOT IN (cst_academic, cst_exam,
2574: cst_assessment, cst_progress) THEN
2575:
2576: --- added by syam
2577: fnd_Message.set_name('IGS','IGS_CA_TEACHCAL_SUP_ACEXASCAL');
2578: fnd_message.set_token('TOKEN1',v_chk_acad_fee_ci_rec.s_cal_cat);
2579: --- added by syam
2580:
2581:

Line 2578: fnd_message.set_token('TOKEN1',v_chk_acad_fee_ci_rec.s_cal_cat);

2574: cst_assessment, cst_progress) THEN
2575:
2576: --- added by syam
2577: fnd_Message.set_name('IGS','IGS_CA_TEACHCAL_SUP_ACEXASCAL');
2578: fnd_message.set_token('TOKEN1',v_chk_acad_fee_ci_rec.s_cal_cat);
2579: --- added by syam
2580:
2581:
2582: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(

Line 2588: fnd_message.get);

2584: p_log_creation_dt,
2585: 'TEACHING,' || v_chk_acad_fee_ci_rec.sub_cal_type || ',' ||
2586: TO_CHAR(v_chk_acad_fee_ci_rec.sub_ci_sequence_number),
2587: NULL,
2588: fnd_message.get);
2589:
2590: END IF;
2591:
2592: -- Check one per cal for SDAs.

Line 2624: fnd_Message.Set_Name('IGS','IGS_CA_TEACHCAL_SUB_ADMCAL');

2620: END LOOP; -- c_chk_tch_sub
2621: IF v_sub_not_admission = TRUE THEN
2622:
2623: --- added by syam
2624: fnd_Message.Set_Name('IGS','IGS_CA_TEACHCAL_SUB_ADMCAL');
2625: fnd_message.set_token('TOKEN1',v_chk_tch_sub_cal_type);
2626: --- added by syam
2627:
2628: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(

Line 2625: fnd_message.set_token('TOKEN1',v_chk_tch_sub_cal_type);

2621: IF v_sub_not_admission = TRUE THEN
2622:
2623: --- added by syam
2624: fnd_Message.Set_Name('IGS','IGS_CA_TEACHCAL_SUB_ADMCAL');
2625: fnd_message.set_token('TOKEN1',v_chk_tch_sub_cal_type);
2626: --- added by syam
2627:
2628: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
2629: p_s_log_type,

Line 2634: fnd_message.get);

2630: p_log_creation_dt,
2631: 'TEACHING,' || v_chk_teach_ci_rec.CAL_TYPE || ',' ||
2632: TO_CHAR(v_chk_teach_ci_rec.sequence_number),
2633: NULL,
2634: fnd_message.get);
2635:
2636: END IF;
2637: IF v_chk_tch_sub_rec_found = FALSE THEN
2638:

Line 2639: fnd_message.set_name('IGS','IGS_CA_TEACHCAL_HAVE_1_ADM');

2635:
2636: END IF;
2637: IF v_chk_tch_sub_rec_found = FALSE THEN
2638:
2639: fnd_message.set_name('IGS','IGS_CA_TEACHCAL_HAVE_1_ADM');
2640: fnd_message.set_token('CAL_TYPE',v_chk_tch_sub_cal_type);
2641:
2642: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
2643: p_s_log_type,

Line 2640: fnd_message.set_token('CAL_TYPE',v_chk_tch_sub_cal_type);

2636: END IF;
2637: IF v_chk_tch_sub_rec_found = FALSE THEN
2638:
2639: fnd_message.set_name('IGS','IGS_CA_TEACHCAL_HAVE_1_ADM');
2640: fnd_message.set_token('CAL_TYPE',v_chk_tch_sub_cal_type);
2641:
2642: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
2643: p_s_log_type,
2644: p_log_creation_dt,

Line 2648: fnd_message.get);

2644: p_log_creation_dt,
2645: 'TEACHING,' || v_chk_teach_ci_rec.CAL_TYPE || ',' ||
2646: TO_CHAR(v_chk_teach_ci_rec.sequence_number),
2647: NULL,
2648: fnd_message.get);
2649: END IF;
2650: v_total_percentage := 0;
2651: --- Check that the calendar instance has at least 1 census date.
2652: OPEN c_chk_census_dt(

Line 2661: fnd_Message.Set_Name('IGS','IGS_CA_TEACHCAL_1_CENSUSALIAS');

2657: FETCH c_chk_census_dt INTO v_exists_flag;
2658: IF c_chk_census_dt%NOTFOUND THEN
2659:
2660: --- added by syam
2661: fnd_Message.Set_Name('IGS','IGS_CA_TEACHCAL_1_CENSUSALIAS');
2662: --- added by syam
2663:
2664:
2665: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(

Line 2671: fnd_message.get);

2667: p_log_creation_dt,
2668: 'TEACHING,' || v_chk_teach_ci_rec.CAL_TYPE || ',' ||
2669: TO_CHAR(v_chk_teach_ci_rec.sequence_number),
2670: NULL,
2671: fnd_message.get);
2672:
2673: END IF;
2674: CLOSE c_chk_census_dt;
2675: --- Loop through all apportionments that the teaching period has to load

Line 2728: fnd_Message.Set_Name('IGS','IGS_CA_TOTLODAPPORTION_NOT_100');

2724: END LOOP; --- c_chk_acad_pct
2725: IF v_total_percentage <> 100 THEN
2726:
2727: --- added by syam
2728: fnd_Message.Set_Name('IGS','IGS_CA_TOTLODAPPORTION_NOT_100');
2729: --- added by syam
2730: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
2731: p_s_log_type,
2732: p_log_creation_dt,

Line 2736: fnd_message.get);

2732: p_log_creation_dt,
2733: 'TEACHING,' || v_chk_teach_ci_rec.CAL_TYPE || ',' ||
2734: TO_CHAR(v_chk_teach_ci_rec.sequence_number),
2735: NULL,
2736: fnd_message.get);
2737:
2738: END IF;
2739: END IF; ---- Bug:2697221 end of check added to avoid calculating load apportionment for planned calendar
2740: END LOOP; -- c_chk_teach_ci

Line 2765: fnd_Message.Set_Name('IGS','IGS_CA_ADMIN_STATUS_LNK_LODCAL');

2761: FETCH c_chk_ausl INTO v_exists_flag;
2762: IF c_chk_ausl%NOTFOUND THEN
2763:
2764: --- added by syam
2765: fnd_Message.Set_Name('IGS','IGS_CA_ADMIN_STATUS_LNK_LODCAL');
2766: fnd_message.set_token('TOKEN1',v_chk_aus_rec.ADMINISTRATIVE_UNIT_STATUS);
2767: --- added by syam
2768:
2769:

Line 2766: fnd_message.set_token('TOKEN1',v_chk_aus_rec.ADMINISTRATIVE_UNIT_STATUS);

2762: IF c_chk_ausl%NOTFOUND THEN
2763:
2764: --- added by syam
2765: fnd_Message.Set_Name('IGS','IGS_CA_ADMIN_STATUS_LNK_LODCAL');
2766: fnd_message.set_token('TOKEN1',v_chk_aus_rec.ADMINISTRATIVE_UNIT_STATUS);
2767: --- added by syam
2768:
2769:
2770: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(

Line 2776: fnd_message.get);

2772: p_log_creation_dt,
2773: 'TEACHING,' || v_chk_tch_ci_aus_rec.CAL_TYPE || ',' ||
2774: TO_CHAR(v_chk_tch_ci_aus_rec.sequence_number),
2775: NULL,
2776: fnd_message.get);
2777:
2778:
2779: END IF;
2780: CLOSE c_chk_ausl;

Line 2823: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');

2819: App_Exception.Raise_Exception;
2820: END;
2821: EXCEPTION
2822: WHEN OTHERS THEN
2823: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
2824: FND_MESSAGE.SET_TOKEN('NAME','IGS_CA_VAL_QLITY.calp_val_teach_ci');
2825: IGS_GE_MSG_STACK.ADD;
2826: lv_param_values:= p_acad_cal_type||','||(to_char(p_acad_sequence_number))||','||p_s_log_type||','||(to_char(p_log_creation_dt));
2827: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');

Line 2824: FND_MESSAGE.SET_TOKEN('NAME','IGS_CA_VAL_QLITY.calp_val_teach_ci');

2820: END;
2821: EXCEPTION
2822: WHEN OTHERS THEN
2823: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
2824: FND_MESSAGE.SET_TOKEN('NAME','IGS_CA_VAL_QLITY.calp_val_teach_ci');
2825: IGS_GE_MSG_STACK.ADD;
2826: lv_param_values:= p_acad_cal_type||','||(to_char(p_acad_sequence_number))||','||p_s_log_type||','||(to_char(p_log_creation_dt));
2827: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
2828: FND_MESSAGE.SET_TOKEN('VALUE',lv_param_values);

Line 2827: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');

2823: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
2824: FND_MESSAGE.SET_TOKEN('NAME','IGS_CA_VAL_QLITY.calp_val_teach_ci');
2825: IGS_GE_MSG_STACK.ADD;
2826: lv_param_values:= p_acad_cal_type||','||(to_char(p_acad_sequence_number))||','||p_s_log_type||','||(to_char(p_log_creation_dt));
2827: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
2828: FND_MESSAGE.SET_TOKEN('VALUE',lv_param_values);
2829: IGS_GE_MSG_STACK.ADD;
2830: App_Exception.Raise_Exception;
2831: END calp_val_teach_ci;

Line 2828: FND_MESSAGE.SET_TOKEN('VALUE',lv_param_values);

2824: FND_MESSAGE.SET_TOKEN('NAME','IGS_CA_VAL_QLITY.calp_val_teach_ci');
2825: IGS_GE_MSG_STACK.ADD;
2826: lv_param_values:= p_acad_cal_type||','||(to_char(p_acad_sequence_number))||','||p_s_log_type||','||(to_char(p_log_creation_dt));
2827: Fnd_Message.Set_Name('IGS','IGS_GE_PARAMETERS');
2828: FND_MESSAGE.SET_TOKEN('VALUE',lv_param_values);
2829: IGS_GE_MSG_STACK.ADD;
2830: App_Exception.Raise_Exception;
2831: END calp_val_teach_ci;
2832:

Line 2921: FND_MESSAGE.SET_NAME('IGS','IGS_CA_AWDCAL_HAVE_1_LOAD');

2917: cp_n_sup_sequence_number => rec_c_ca_inst_awd.sequence_number
2918: );
2919: FETCH c_cir_8 INTO rec_c_cir_8;
2920: IF c_cir_8%NOTFOUND THEN
2921: FND_MESSAGE.SET_NAME('IGS','IGS_CA_AWDCAL_HAVE_1_LOAD');
2922: igs_ge_gen_003.genp_ins_log_entry( p_c_s_log_type,
2923: p_d_log_creation_dt,
2924: 'LOAD,'|| rec_c_ca_inst_awd.cal_type ||',' ||rec_c_ca_inst_awd.sequence_number,
2925: NULL,

Line 2926: fnd_message.get

2922: igs_ge_gen_003.genp_ins_log_entry( p_c_s_log_type,
2923: p_d_log_creation_dt,
2924: 'LOAD,'|| rec_c_ca_inst_awd.cal_type ||',' ||rec_c_ca_inst_awd.sequence_number,
2925: NULL,
2926: fnd_message.get
2927: );
2928: END IF;
2929: CLOSE c_cir_8;
2930: END LOOP;