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

Line 595: FND_MESSAGE.SET_NAME('IGS', 'IGS_AV_UNHANDLED_ERROR');

591:
592: WHEN OTHERS THEN
593: ROLLBACK TO create_unit_outcome;
594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
595: FND_MESSAGE.SET_NAME('IGS', 'IGS_AV_UNHANDLED_ERROR');
596: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
597: FND_MSG_PUB.ADD;
598:
599: FND_MSG_PUB.Count_And_Get(

Line 596: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

592: WHEN OTHERS THEN
593: ROLLBACK TO create_unit_outcome;
594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
595: FND_MESSAGE.SET_NAME('IGS', 'IGS_AV_UNHANDLED_ERROR');
596: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
597: FND_MSG_PUB.ADD;
598:
599: FND_MSG_PUB.Count_And_Get(
600: p_count => x_msg_count,

Line 634: FND_MESSAGE.SET_NAME('IGS', 'IGS_EN_PER_NUM_NULL');

630:
631: gen_log_info('Start of validate_parameters.Validation 1');
632:
633: IF p_lgcy_suo_rec.person_number IS NULL THEN
634: FND_MESSAGE.SET_NAME('IGS', 'IGS_EN_PER_NUM_NULL');
635: FND_MSG_PUB.ADD;
636: l_return_status := FALSE;
637: END IF;
638:

Line 646: FND_MESSAGE.SET_NAME('IGS', 'IGS_EN_PRGM_CD_NULL');

642:
643: gen_log_info('Start of validate_parameters.Validation 2');
644:
645: IF p_lgcy_suo_rec.program_cd IS NULL THEN
646: FND_MESSAGE.SET_NAME('IGS', 'IGS_EN_PRGM_CD_NULL');
647: FND_MSG_PUB.ADD;
648: l_return_status := FALSE;
649: END IF;
650:

Line 656: FND_MESSAGE.SET_NAME('IGS', 'IGS_AS_UNIT_CD_NULL');

652:
653: /*************************************** Validation 3 ******************************************/
654: gen_log_info('Start of validate_parameters.Validation 3');
655: IF p_lgcy_suo_rec.unit_cd IS NULL THEN
656: FND_MESSAGE.SET_NAME('IGS', 'IGS_AS_UNIT_CD_NULL');
657: FND_MSG_PUB.ADD;
658: l_return_status := FALSE;
659: END IF;
660: gen_log_info('End of validate_parameters.Validation 3');

Line 664: FND_MESSAGE.SET_NAME('IGS', 'IGS_AS_TCAL_ALTCD_NULL');

660: gen_log_info('End of validate_parameters.Validation 3');
661: /*************************************** Validation 4 ******************************************/
662: gen_log_info('Start of validate_parameters.Validation 4');
663: IF p_lgcy_suo_rec.teach_cal_alt_code IS NULL THEN
664: FND_MESSAGE.SET_NAME('IGS', 'IGS_AS_TCAL_ALTCD_NULL');
665: FND_MSG_PUB.ADD;
666: l_return_status := FALSE;
667: END IF;
668: gen_log_info('End of validate_parameters.Validation 4');

Line 672: FND_MESSAGE.SET_NAME('IGS', 'IGS_AS_OTCM_DT_NULL');

668: gen_log_info('End of validate_parameters.Validation 4');
669: /*************************************** Validation 5 ******************************************/
670: gen_log_info('Start of validate_parameters.Validation 5');
671: IF p_lgcy_suo_rec.outcome_dt IS NULL THEN
672: FND_MESSAGE.SET_NAME('IGS', 'IGS_AS_OTCM_DT_NULL');
673: FND_MSG_PUB.ADD;
674: l_return_status := FALSE;
675: END IF;
676: gen_log_info('End of validate_parameters.Validation 5');

Line 682: FND_MESSAGE.SET_NAME('IGS', 'IGS_AS_GRADE_NULL');

678: /*************************************** Validation 6 ******************************************/
679:
680: gen_log_info('Start of validate_parameters.Validation 6');
681: IF p_lgcy_suo_rec.grade IS NULL THEN
682: FND_MESSAGE.SET_NAME('IGS', 'IGS_AS_GRADE_NULL');
683: FND_MSG_PUB.ADD;
684: l_return_status := FALSE;
685: END IF;
686: gen_log_info('End of validate_parameters.Validation 6');

Line 692: FND_MESSAGE.SET_NAME('IGS', 'IGS_AS_GRAD_PRD_NULL');

688: /*************************************** Validation 7 ******************************************/
689:
690: gen_log_info('Start of validate_parameters.Validation 7');
691: IF p_lgcy_suo_rec.grading_period_cd IS NULL THEN
692: FND_MESSAGE.SET_NAME('IGS', 'IGS_AS_GRAD_PRD_NULL');
693: FND_MSG_PUB.ADD;
694: l_return_status := FALSE;
695: END IF;
696: gen_log_info('End of validate_parameters.Validation 7');

Line 706: FND_MESSAGE.SET_NAME('IGS', 'IGS_AS_GRDVER_NULL_NOTNULL');

702: */
703: gen_log_info('Start of validate_parameters.Validation 8');
704:
705: IF p_lgcy_suo_rec.grading_schema_cd IS NOT NULL AND p_lgcy_suo_rec.version_number IS NULL THEN
706: FND_MESSAGE.SET_NAME('IGS', 'IGS_AS_GRDVER_NULL_NOTNULL');
707: FND_MSG_PUB.ADD;
708: l_return_status := FALSE;
709: ELSIF p_lgcy_suo_rec.grading_schema_cd IS NULL AND p_lgcy_suo_rec.version_number IS NOT NULL THEN
710: FND_MESSAGE.SET_NAME('IGS', 'IGS_AS_GRDVER_NULL_NOTNULL');

Line 710: FND_MESSAGE.SET_NAME('IGS', 'IGS_AS_GRDVER_NULL_NOTNULL');

706: FND_MESSAGE.SET_NAME('IGS', 'IGS_AS_GRDVER_NULL_NOTNULL');
707: FND_MSG_PUB.ADD;
708: l_return_status := FALSE;
709: ELSIF p_lgcy_suo_rec.grading_schema_cd IS NULL AND p_lgcy_suo_rec.version_number IS NOT NULL THEN
710: FND_MESSAGE.SET_NAME('IGS', 'IGS_AS_GRDVER_NULL_NOTNULL');
711: FND_MSG_PUB.ADD;
712: l_return_status := FALSE;
713: END IF;
714: gen_log_info('End of validate_parameters.Validation 7');

Line 744: FND_MESSAGE.SET_NAME('IGS', 'IGS_AS_INCMP_VERNUM_BET_0_999');

740: BEGIN
741: IF p_lgcy_suo_rec.incomp_grading_schema_cd IS NOT NULL THEN
742:
743: IF NVL(p_lgcy_suo_rec.incomp_version_number,0) NOT BETWEEN 1 and 999 THEN
744: FND_MESSAGE.SET_NAME('IGS', 'IGS_AS_INCMP_VERNUM_BET_0_999');
745: FND_MSG_PUB.ADD;
746: l_return_status := FALSE;
747: END IF;
748:

Line 757: FND_MESSAGE.SET_NAME('IGS', 'IGS_AS_INCMP_GRDVER_BOTNULL');

753: */
754: OPEN cur_incomp_grd_sch_exists;
755: FETCH cur_incomp_grd_sch_exists INTO l_exists;
756: IF cur_incomp_grd_sch_exists%NOTFOUND THEN
757: FND_MESSAGE.SET_NAME('IGS', 'IGS_AS_INCMP_GRDVER_BOTNULL');
758: FND_MSG_PUB.ADD;
759: l_return_status := FALSE;
760: END IF;
761: CLOSE cur_incomp_grd_sch_exists;

Line 765: FND_MESSAGE.SET_NAME('IGS', 'IGS_AS_INCMP_GRDVER_BOTNULL');

761: CLOSE cur_incomp_grd_sch_exists;
762:
763:
764: ELSIF p_lgcy_suo_rec.incomp_grading_schema_cd IS NULL AND p_lgcy_suo_rec.incomp_version_number IS NOT NULL THEN
765: FND_MESSAGE.SET_NAME('IGS', 'IGS_AS_INCMP_GRDVER_BOTNULL');
766: FND_MSG_PUB.ADD;
767: l_return_status := FALSE;
768: END IF;
769: END;

Line 788: FND_MESSAGE.SET_NAME('IGS', 'IGS_AS_INCMP_GRADE_NOT_EXIST');

784: -- Incomplete default grade is not null
785: IF p_lgcy_suo_rec.incomp_grading_schema_cd IS NULL OR p_lgcy_suo_rec.incomp_version_number IS NULL THEN
786: -- incomplete grading schema code or incomplete version has be sent to the API as null.
787: -- set an error message to stack
788: FND_MESSAGE.SET_NAME('IGS', 'IGS_AS_INCMP_GRADE_NOT_EXIST');
789: FND_MSG_PUB.ADD;
790: l_return_status := FALSE;
791: ELSE
792: -- incomplete grading schema code and incomplete version both are not nulls

Line 817: FND_MESSAGE.SET_NAME('IGS', 'IGS_AS_INVALID_INCMP_GRADE');

813: /* set an error message as the incomplete default grade has not been defined for the incomplete
814: grading schema code/incomplete version number combination
815: */
816:
817: FND_MESSAGE.SET_NAME('IGS', 'IGS_AS_INVALID_INCMP_GRADE');
818: FND_MSG_PUB.ADD;
819: l_return_status := FALSE;
820: END IF;
821: CLOSE cur_incomp_grade_exists;

Line 844: FND_MESSAGE.SET_NAME('IGS', 'IGS_AS_INCMP_MARK_NOT_EXIST');

840: -- Incomplete defalut mark is not null
841: IF p_lgcy_suo_rec.incomp_grading_schema_cd IS NULL OR p_lgcy_suo_rec.incomp_default_grade IS NULL THEN
842: -- incomplete grading schema code or incomplete default grade has been sent to the APi as null.
843: -- set an error message to stack
844: FND_MESSAGE.SET_NAME('IGS', 'IGS_AS_INCMP_MARK_NOT_EXIST');
845: FND_MSG_PUB.ADD;
846: l_return_status := FALSE;
847: ELSE
848: -- incomplete grading schema code and incomplete default grade both are not nulls

Line 876: FND_MESSAGE.SET_NAME('IGS', 'IGS_AS_INVALID_INCMP_MARK');

872: /* set an error message as the incomplete default mark does not lie within the lower and upper mark ranges for
873: the passed incomplete grading schema code, incomplete version number and incomplete default grade combination.
874: */
875:
876: FND_MESSAGE.SET_NAME('IGS', 'IGS_AS_INVALID_INCMP_MARK');
877: FND_MSG_PUB.ADD;
878: l_return_status := FALSE;
879:
880: END IF;

Line 897: FND_MESSAGE.SET_NAME('IGS', 'IGS_AS_GRD_PRD_INVALID');

893: /*
894: Validate that parameter p_lgcy_suo_rec.grading_period_cd cannot have any other values except 'MIDTERM' or 'FINAL'
895: */
896: IF p_lgcy_suo_rec.grading_period_cd <> 'MIDTERM' AND p_lgcy_suo_rec.grading_period_cd <> 'FINAL' THEN
897: FND_MESSAGE.SET_NAME('IGS', 'IGS_AS_GRD_PRD_INVALID');
898: FND_MSG_PUB.ADD;
899: l_return_status := FALSE;
900: END IF;
901:

Line 945: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_INVALID_DESC_FLEX');

941: p_attribute19 => p_lgcy_suo_rec.attribute19 ,
942: p_attribute20 => p_lgcy_suo_rec.attribute20 ,
943: p_desc_flex_name => 'IGS_AS_SU_STMPTOUT_FLEX') THEN
944: l_return_status := FALSE;
945: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_INVALID_DESC_FLEX');
946: FND_MSG_PUB.ADD;
947: END IF;
948: END IF;
949:

Line 1009: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_INVALID_PERSON_NUMBER');

1005:
1006: p_person_id := IGS_GE_GEN_003.GET_PERSON_ID(p_lgcy_suo_rec.person_number);
1007: gen_log_info ('person_id : '||p_person_id);
1008: IF p_person_id IS NULL THEN
1009: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_INVALID_PERSON_NUMBER');
1010: FND_MSG_PUB.ADD;
1011: l_return_status := FALSE;
1012: END IF;
1013:

Line 1037: FND_MESSAGE.SET_NAME('IGS', 'IGS_AV_INVALID_CAL_ALT_CODE');

1033:
1034: gen_log_info('cal type, sequence number,start_dt,end dt : '||p_cal_type||p_sequence_number||p_start_dt||p_end_dt);
1035:
1036: IF p_cal_type IS NULL OR p_sequence_number IS NULL OR p_start_dt IS NULL THEN
1037: FND_MESSAGE.SET_NAME('IGS', 'IGS_AV_INVALID_CAL_ALT_CODE');
1038: FND_MSG_PUB.ADD;
1039: l_return_status := FALSE;
1040: END IF;
1041:

Line 1184: FND_MESSAGE.SET_NAME ('IGS','IGS_AS_INVALID_GRADE');

1180:
1181: IF cur_get_grade%NOTFOUND THEN
1182: -- Situation indicates an invalid legacy grade entry
1183: -- set the error message IGS_AS_INVALID_GRADE to stack and go to validation 4
1184: FND_MESSAGE.SET_NAME ('IGS','IGS_AS_INVALID_GRADE');
1185: FND_MSG_PUB.ADD;
1186: l_return_status := FALSE;
1187: ELSE
1188: -- both the grades are equal.

Line 1217: FND_MESSAGE.SET_NAME ('IGS','IGS_AS_INVALID_GRADE');

1213:
1214: IF cur_get_grade%NOTFOUND THEN
1215: -- Situation indicates an invalid legacy grade entry
1216: -- set the error message IGS_AS_INVALID_GRADE to stack and go to validation 4
1217: FND_MESSAGE.SET_NAME ('IGS','IGS_AS_INVALID_GRADE');
1218: FND_MSG_PUB.ADD;
1219: l_return_status := FALSE;
1220: ELSE
1221: -- both the grades are equal.

Line 1231: FND_MESSAGE.SET_NAME ('IGS','IGS_AS_GRDSCH_SETUP_NOT_EXIST');

1227:
1228: CLOSE cur_get_grade;
1229: ELSE
1230: --A Grading schema setup does not exist at the unit section level and the unit level
1231: FND_MESSAGE.SET_NAME ('IGS','IGS_AS_GRDSCH_SETUP_NOT_EXIST');
1232: FND_MSG_PUB.ADD;
1233: l_return_status := FALSE;
1234: END IF;
1235: CLOSE cur_get_grd_schm_unit_lvl;

Line 1400: FND_MESSAGE.SET_NAME('IGS', l_message_name);

1396: P_MESSAGE_NAME => l_message_name
1397: );
1398:
1399: IF l_message_name IS NOT NULL THEN
1400: FND_MESSAGE.SET_NAME('IGS', l_message_name);
1401: FND_MSG_PUB.ADD;
1402: l_return_status := FALSE;
1403: ELSE
1404: OPEN cur_cop(

Line 1495: FND_MESSAGE.SET_NAME ('IGS','IGS_AS_UTOTCM_ALREADY_EXISTS');

1491: Set an warning message to stack and set x_return_status to 'W'
1492: and return FALSE
1493: */
1494:
1495: FND_MESSAGE.SET_NAME ('IGS','IGS_AS_UTOTCM_ALREADY_EXISTS');
1496: FND_MSG_PUB.ADD;
1497: x_return_status := 'W';
1498: l_return_status := FALSE;
1499: RETURN l_return_status;

Line 1523: FND_MESSAGE.SET_NAME ('IGS','IGS_AS_STD_ENRL_NOT_EXISTS');

1519: Set an error message to stack and set x_return_status to 'E' and proceed
1520: to the next step
1521: */
1522:
1523: FND_MESSAGE.SET_NAME ('IGS','IGS_AS_STD_ENRL_NOT_EXISTS');
1524: FND_MSG_PUB.ADD;
1525: x_return_status := 'E';
1526: l_return_status := FALSE;
1527: END IF;

Line 1550: FND_MESSAGE.SET_NAME ('IGS','IGS_AS_GRD_SCH_NOT_EXISTS');

1546: Set an error message to stack and set x_return_status to 'E' and proceed
1547: to the next step
1548: */
1549:
1550: FND_MESSAGE.SET_NAME ('IGS','IGS_AS_GRD_SCH_NOT_EXISTS');
1551: FND_MSG_PUB.ADD;
1552: x_return_status := 'E';
1553: l_return_status := FALSE;
1554:

Line 1570: FND_MESSAGE.SET_NAME ('IGS','IGS_AS_GRD_CRTMTH_INVALID');

1566: IF p_lgcy_suo_rec.s_grade_creation_method_type <> 'CONVERSION' AND
1567: p_lgcy_suo_rec.s_grade_creation_method_type <> 'KEYED' AND
1568: p_lgcy_suo_rec.s_grade_creation_method_type <> 'UPLOAD'
1569: THEN
1570: FND_MESSAGE.SET_NAME ('IGS','IGS_AS_GRD_CRTMTH_INVALID');
1571: FND_MSG_PUB.ADD;
1572: x_return_status := 'E';
1573: l_return_status := FALSE;
1574: END IF;

Line 1605: FND_MESSAGE.Set_Name('IGS','IGS_AS_GRD_VERSION_BET_0_999');

1601: l_msg_count := FND_MSG_PUB.COUNT_MSG;
1602: -- Delete the message 'IGS_GE_INVALID_VALUE'
1603: FND_MSG_PUB.DELETE_MSG (l_msg_count);
1604: -- set the customized message
1605: FND_MESSAGE.Set_Name('IGS','IGS_AS_GRD_VERSION_BET_0_999');
1606: FND_MSG_PUB.Add;
1607: x_return_status := 'E';
1608: l_return_status := FALSE;
1609: END ;

Line 1638: FND_MESSAGE.Set_Name('IGS','IGS_EN_MARK_INV');

1634: l_msg_count := FND_MSG_PUB.COUNT_MSG;
1635: -- Delete the message 'IGS_GE_INVALID_VALUE'
1636: FND_MSG_PUB.DELETE_MSG (l_msg_count);
1637: -- set the customized message
1638: FND_MESSAGE.Set_Name('IGS','IGS_EN_MARK_INV');
1639: FND_MSG_PUB.Add;
1640: x_return_status := 'E';
1641: l_return_status := FALSE;
1642: END ;

Line 1674: FND_MESSAGE.Set_Name('IGS','IGS_AS_FNL_OTCN_IND_Y_N');

1670: l_msg_count := FND_MSG_PUB.COUNT_MSG;
1671: -- Delete the message 'IGS_GE_INVALID_VALUE'
1672: FND_MSG_PUB.DELETE_MSG (l_msg_count);
1673: -- set the customized message
1674: FND_MESSAGE.Set_Name('IGS','IGS_AS_FNL_OTCN_IND_Y_N');
1675: FND_MSG_PUB.Add;
1676: x_return_status := 'E';
1677: l_return_status := FALSE;
1678: END ;

Line 1709: FND_MESSAGE.Set_Name('IGS','IGS_AS_SEQ_NUM_BET_0_999999');

1705: l_msg_count := FND_MSG_PUB.COUNT_MSG;
1706: -- Delete the message 'IGS_GE_INVALID_VALUE'
1707: FND_MSG_PUB.DELETE_MSG (l_msg_count);
1708: -- set the customized message
1709: FND_MESSAGE.Set_Name('IGS','IGS_AS_SEQ_NUM_BET_0_999999');
1710: FND_MSG_PUB.Add;
1711: x_return_status := 'E';
1712: l_return_status := FALSE;
1713: END ;

Line 1745: FND_MESSAGE.Set_Name('IGS','IGS_AS_TRN_VERSION_BET_0_999');

1741: -- Delete the message 'IGS_GE_INVALID_VALUE'
1742: FND_MSG_PUB.DELETE_MSG (l_msg_count);
1743:
1744: -- set the customized message
1745: FND_MESSAGE.Set_Name('IGS','IGS_AS_TRN_VERSION_BET_0_999');
1746: FND_MSG_PUB.Add;
1747: x_return_status := 'E';
1748: l_return_status := FALSE;
1749: END ;

Line 1799: FND_MESSAGE.SET_NAME('IGS', 'IGS_AS_CANT_GRD_UNT_INV_STAT');

1795:
1796: IF p_unit_attempt_status <> 'ENROLLED' AND p_unit_attempt_status <> 'COMPLETED' THEN
1797: -- Validation unsuccessful as the unit_attempt_status is not in ENROLLED or COMPLETED.
1798: -- set an error message to stack and return FALSE.
1799: FND_MESSAGE.SET_NAME('IGS', 'IGS_AS_CANT_GRD_UNT_INV_STAT');
1800: FND_MSG_PUB.ADD;
1801: l_return_status := FALSE;
1802: END IF;
1803: