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_GR_GRD_LGCY_PUB dependencies on FND_MSG_PUB

Line 133: FND_MSG_PUB.initialize;

129: END IF;
130:
131: --Initialize message list if p_init_msg_list is set to TRUE.
132: IF FND_API.to_Boolean(p_init_msg_list) THEN
133: FND_MSG_PUB.initialize;
134: END IF;
135:
136: --Initialize API return status to success.
137: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 314: FND_MSG_PUB.Count_And_Get(

310: IF FND_API.to_Boolean(p_commit) THEN
311: commit;
312: END IF;
313:
314: FND_MSG_PUB.Count_And_Get(
315: p_count => x_MSG_COUNT,
316: p_data => X_MSG_DATA);
317:
318:

Line 323: FND_MSG_PUB.Count_And_Get(

319: EXCEPTION
320: WHEN WARN_TYPE_ERR THEN
321: ROLLBACK TO create_graduand;
322: x_return_status := 'W';
323: FND_MSG_PUB.Count_And_Get(
324: p_count => x_msg_count,
325: p_data => x_msg_data);
326: WHEN FND_API.G_EXC_ERROR THEN
327: ROLLBACK TO create_graduand;

Line 329: FND_MSG_PUB.Count_And_Get(

325: p_data => x_msg_data);
326: WHEN FND_API.G_EXC_ERROR THEN
327: ROLLBACK TO create_graduand;
328: x_return_status := FND_API.G_RET_STS_ERROR;
329: FND_MSG_PUB.Count_And_Get(
330: p_count => x_msg_count,
331: p_data => x_msg_data);
332:
333: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 336: FND_MSG_PUB.Count_And_Get(

332:
333: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
334: ROLLBACK TO create_graduand;
335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
336: FND_MSG_PUB.Count_And_Get(
337: p_count => x_msg_count,
338: p_data => x_msg_data);
339: WHEN OTHERS THEN
340: ROLLBACK TO create_graduand;

Line 344: FND_MSG_PUB.ADD;

340: ROLLBACK TO create_graduand;
341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
342: FND_MESSAGE.SET_NAME('IGS', 'IGS_AV_UNHANDLED_ERROR');
343: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
344: FND_MSG_PUB.ADD;
345:
346: FND_MSG_PUB.Count_And_Get(
347: p_count => x_msg_count,
348: p_data => x_msg_data);

Line 346: FND_MSG_PUB.Count_And_Get(

342: FND_MESSAGE.SET_NAME('IGS', 'IGS_AV_UNHANDLED_ERROR');
343: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
344: FND_MSG_PUB.ADD;
345:
346: FND_MSG_PUB.Count_And_Get(
347: p_count => x_msg_count,
348: p_data => x_msg_data);
349:
350: END create_graduand ;

Line 389: FND_MSG_PUB.ADD;

385:
386: IF p_lgcy_grd_rec.person_number IS NULL THEN
387: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);
388: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_PER_NUM_NULL');
389: FND_MSG_PUB.ADD;
390: END IF;
391:
392: IF p_lgcy_grd_rec.create_dt IS NULL THEN
393: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);

Line 395: FND_MSG_PUB.ADD;

391:
392: IF p_lgcy_grd_rec.create_dt IS NULL THEN
393: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);
394: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GR_CREATE_DT_NOT_NULL');
395: FND_MSG_PUB.ADD;
396: END IF;
397:
398: IF p_lgcy_grd_rec.GRD_CAL_ALT_CODE IS NULL THEN
399: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);

Line 401: FND_MSG_PUB.ADD;

397:
398: IF p_lgcy_grd_rec.GRD_CAL_ALT_CODE IS NULL THEN
399: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);
400: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GR_CALALTCD_NOT_NULL');
401: FND_MSG_PUB.ADD;
402: END IF;
403:
404:
405: IF p_lgcy_grd_rec.AWARD_CD IS NULL THEN

Line 408: FND_MSG_PUB.ADD;

404:
405: IF p_lgcy_grd_rec.AWARD_CD IS NULL THEN
406: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);
407: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GR_AWARD_CD_NOT_NULL');
408: FND_MSG_PUB.ADD;
409: END IF;
410:
411: IF p_lgcy_grd_rec.GRADUAND_STATUS IS NULL THEN
412: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);

Line 414: FND_MSG_PUB.ADD;

410:
411: IF p_lgcy_grd_rec.GRADUAND_STATUS IS NULL THEN
412: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);
413: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GR_GRADSTAT_NOT_NULL');
414: FND_MSG_PUB.ADD;
415: END IF;
416:
417: IF p_lgcy_grd_rec.GRADUAND_APPR_STATUS IS NULL THEN
418: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);

Line 420: FND_MSG_PUB.ADD;

416:
417: IF p_lgcy_grd_rec.GRADUAND_APPR_STATUS IS NULL THEN
418: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);
419: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GR_GRD_APPRSTAT_NOT_NULL');
420: FND_MSG_PUB.ADD;
421: END IF;
422:
423: --If the Award_program_code record type parameter is not NULL
424: --then Award_program_version_number should be >=1 and <= 999

Line 435: FND_MSG_PUB.ADD;

431: )
432: THEN
433: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);
434: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GR_AWD_PRGVER_BET_1_999');
435: FND_MSG_PUB.ADD;
436: END IF;
437:
438: --If the record parameter SUR_FOR_PROGRAM_CD is Not Null
439: --then SUR_FOR_PROG_VERSION_NUMBER should have a value >= 1 and <= 999

Line 450: FND_MSG_PUB.ADD;

446: )
447: THEN
448: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);
449: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GR_SUR_PRGVER_BET_1_999');
450: FND_MSG_PUB.ADD;
451: END IF;
452:
453: --If the record parameter SUR_FOR_PROGRAM_CD is Not Null
454: --then the record parameter SUR_FOR_AWARD_CD should have a not null value

Line 464: FND_MSG_PUB.ADD;

460: )
461: THEN
462: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);
463: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GR_SUR_AWDCD_NOT_NULL');
464: FND_MSG_PUB.ADD;
465: END IF;
466:
467: --Validate the flex definition
468: IF NOT IGS_AD_IMP_018.validate_desc_flex(

Line 493: FND_MSG_PUB.ADD;

489: p_ATTRIBUTE20 => p_lgcy_grd_rec.ATTRIBUTE20 ,
490: p_desc_flex_name => 'IGS_GR_GRADUAND_FLEX' ) THEN
491: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);
492: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_INVALID_DESC_FLEX');
493: FND_MSG_PUB.ADD;
494: END IF;
495:
496: RETURN l_return_value ;
497:

Line 533: FND_MSG_PUB.ADD;

529:
530: --Get person id
531: IF p_person_id IS NULL THEN
532: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GE_INVALID_PERSON_NUMBER');
533: FND_MSG_PUB.ADD;
534: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);
535: RETURN l_return_value;
536: END IF;
537: --End of Get person id

Line 544: FND_MSG_PUB.ADD;

540: igs_ge_gen_003.get_calendar_instance(p_lgcy_grd_rec.GRD_CAL_ALT_CODE,NULL,p_cal_type, p_sequence_number, l_start_dt, l_end_dt, l_message) ;
541:
542: IF p_cal_type IS NULL OR p_sequence_number IS NULL THEN
543: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AV_INVALID_CAL_ALT_CODE');
544: FND_MSG_PUB.ADD;
545: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);
546: RETURN l_return_value;
547: END IF;
548: --End of Get calendar info

Line 556: FND_MSG_PUB.ADD;

552: p_proxy_award_person_id := Igs_Ge_Gen_003.Get_Person_id (p_lgcy_grd_rec.proxy_award_person_number) ;
553:
554: IF p_proxy_award_person_id IS NULL THEN -- Wrong proxy person number is passed
555: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GR_INVALID_PRXYPERS_NUM');
556: FND_MSG_PUB.ADD;
557: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);
558: RETURN l_return_value;
559: ELSE
560: -- Correct proxy person number is passed, so set the ind to Y

Line 621: FND_MSG_PUB.ADD;

617: -- Check for record existance
618: IF Igs_Gr_Graduand_Pkg.Get_Pk_For_Validation(X_PERSON_ID => p_person_id,
619: X_CREATE_DT => p_lgcy_grd_rec.create_dt) THEN
620: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GR_GRAD_PK_ALREADY_EXISTS');
621: FND_MSG_PUB.ADD;
622: l_return_value := 'W'; -- Error out
623: RETURN l_return_value;
624: END IF;
625: -- End of check for record existance

Line 637: FND_MSG_PUB.ADD;

633: X_AWARD_CD => p_lgcy_grd_rec.award_cd
634: )
635: THEN
636: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GR_GRAD_UK_ALREADY_EXISTS');
637: FND_MSG_PUB.ADD;
638: l_return_value := 'W'; -- Error out
639: RETURN l_return_value;
640: END IF;
641: -- End of Check for Unique key check

Line 647: FND_MSG_PUB.ADD;

643: -- Foreign key validation with the table IGS_PS_AWD_PKG Column Award_Cd
644: IF NOT IGS_PS_AWD_PKG.Get_PK_For_Validation(X_AWARD_CD => p_lgcy_grd_rec.award_cd)
645: THEN
646: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GR_AWDCD_FK_NOT_EXISTS');
647: FND_MSG_PUB.ADD;
648: l_return_value := 'E'; --Continue
649: END IF;
650: -- End of Foreign key validation with the table IGS_PS_AWD_PKG Column Award_Cd
651:

Line 661: FND_MSG_PUB.ADD;

657: X_VERSION_NUMBER => p_lgcy_grd_rec.AWARD_PROG_VERSION_NUMBER ,
658: X_AWARD_CD => p_lgcy_grd_rec.AWARD_CD )
659: THEN
660: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GR_AWDDET_FK_NOT_EXISTS');
661: FND_MSG_PUB.ADD;
662: l_return_value := 'E';--Continue
663: END IF;
664: -- End of Foreign key validation with the table IGS_PS_AWARD_PKG Columns award_course_cd, award_crs_version_number and Award_Cd
665:

Line 673: FND_MSG_PUB.ADD;

669: X_GRD_CI_SEQUENCE_NUMBER => p_sequence_number
670: )
671: THEN
672: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GR_CRMRND_FK_NOT_EXISTS');
673: FND_MSG_PUB.ADD;
674: l_return_value := 'E';--Continue
675: END IF;
676: --End of Foreign key validation with the table IGS_GR_CRMN_ROUND_PKG column grd_cal_type and grd_ci_sequence_number
677:

Line 682: FND_MSG_PUB.ADD;

678: --7Foreign key validation with the table IGS_GR_APRV_STAT_PKG column graduand_appr_status
679: IF NOT IGS_GR_APRV_STAT_PKG.Get_PK_For_Validation(X_GRADUAND_APPR_STATUS => p_lgcy_grd_rec.GRADUAND_APPR_STATUS)
680: THEN
681: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GR_APRSTAT_FK_NOT_EXISTS');
682: FND_MSG_PUB.ADD;
683: l_return_value := 'E';--Continue
684: END IF;
685: --7End of Foreign key validation with the table IGS_GR_APRV_STAT_PKG column graduand_appr_status
686:

Line 691: FND_MSG_PUB.ADD;

687: --Foreign key validation with the table IGS_GR_STAT_PKG column graduand_status
688: IF NOT IGS_GR_STAT_PKG.Get_PK_For_Validation(X_GRADUAND_STATUS => p_lgcy_grd_rec.GRADUAND_STATUS)
689: THEN
690: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GR_GRDSTAT_FK_NOT_EXISTS');
691: FND_MSG_PUB.ADD;
692: l_return_value := 'E';--Continue
693: END IF;
694: --End of Foreign key validation with the table IGS_GR_STAT_PKG column graduand_status
695:

Line 703: FND_MSG_PUB.ADD;

699: NOT IGS_EN_STDNT_PS_ATT_PKG.Get_PK_For_Validation(X_PERSON_ID => p_person_id,
700: X_COURSE_CD => p_lgcy_grd_rec.program_cd)
701: THEN
702: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GR_STPRATPT_FK_NOT_EXISTS');
703: FND_MSG_PUB.ADD;
704: l_return_value := 'E';--Continue
705: END IF;
706: --End of Foreign key validation with the table IGS_EN_STDNT_PS_ATT_PKG column person_id and course_cd
707:

Line 718: FND_MSG_PUB.ADD;

714: X_VERSION_NUMBER => p_lgcy_grd_rec.sur_for_prog_version_number ,
715: X_AWARD_CD => p_lgcy_grd_rec.sur_for_award_cd)
716: THEN
717: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GR_SURCRSCD_FK_NOT_EXISTS');
718: FND_MSG_PUB.ADD;
719: l_return_value := 'E';--Continue
720: END IF;
721: --End of Foreign key validation with the table IGS_PS_AWARD_PKG column sur_for_course_cd, sur_for_crs_version_number and sur_for_award_cd
722:

Line 725: FND_MSG_PUB.ADD;

721: --End of Foreign key validation with the table IGS_PS_AWARD_PKG column sur_for_course_cd, sur_for_crs_version_number and sur_for_award_cd
722:
723: IF p_lgcy_grd_rec.CONVOCATION_MEMBERSHIP_IND NOT IN('Y','N') THEN
724: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GR_CONV_MEM_IND_Y_N');
725: FND_MSG_PUB.ADD;
726: l_return_value := 'E';--Continue
727: END IF;
728:
729: --S_GRADUAND_TYPE should not have any other value except for Attending , Inabsentia , Articulate , Deferred , Unknown , Declined:

Line 732: FND_MSG_PUB.ADD;

728:
729: --S_GRADUAND_TYPE should not have any other value except for Attending , Inabsentia , Articulate , Deferred , Unknown , Declined:
730: IF p_lgcy_grd_rec.S_GRADUAND_TYPE NOT IN ( 'ATTENDING' , 'INABSENTIA' , 'ARTICULATE' , 'DEFERRED' , 'UNKNOWN' , 'DECLINED' ) THEN
731: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GR_SGRADTYP_INVALID_VAL');
732: FND_MSG_PUB.ADD;
733: l_return_value := 'E';--Continue
734: END IF;
735: --End of S_GRADUAND_TYPE should not have any other value except for Attending , Inabsentia , Articulate , Deferred , Unknown , Declined:
736:

Line 849: FND_MSG_PUB.ADD;

845: p_sur_for_award_cd => p_lgcy_grd_rec.sur_for_award_cd,
846: p_message_name => l_message )THEN
847:
848: FND_MESSAGE.SET_NAME ('IGS', l_message);
849: FND_MSG_PUB.ADD;
850: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE); --Continue
851:
852: END IF;
853: --End of 1-7 Validate that the surrendering for program award can only be specified when surrendering or articulating an award

Line 860: FND_MSG_PUB.ADD;

856: -- the proxy award person number must be a different person from that of the graduand.
857: IF p_lgcy_grd_rec.proxy_award_person_number IS NOT NULL AND
858: p_lgcy_grd_rec.proxy_award_person_number = p_lgcy_grd_rec.person_number THEN
859: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GR_PRXY_AWD_MUST_BE_DIFF');
860: FND_MSG_PUB.ADD;
861: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE); --Continue
862: END IF;
863: -- End of Validate that if the Proxy award person number is passed
864: -- then the proxy award person number must be a different person from that of the graduand.

Line 878: FND_MSG_PUB.ADD;

874:
875: IF v_gst_s_graduand_status IN (cst_graduated,cst_surrender) THEN
876: IF v_gas_s_graduand_appr_status <> cst_approved THEN
877: FND_MESSAGE.SET_NAME ('IGS','IGS_GR_MUST_HAVE_VALUE_APPROV');
878: FND_MSG_PUB.ADD;
879: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE); --Continue
880: END IF;
881: END IF;
882: --End of Validate that the Graduand cannot be graduated unless the graduand approval status has a system value of "APPROVED

Line 894: FND_MSG_PUB.ADD;

890: p_award_cd => p_lgcy_grd_rec.award_cd,
891: p_message_name => l_message) THEN
892:
893: FND_MESSAGE.SET_NAME ('IGS',l_message);
894: FND_MSG_PUB.ADD;
895: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE); --Continue
896: END IF;
897: --11 End of Validate that if the program award code and program award version number is the same as the program code and version number then validate
898:

Line 904: FND_MSG_PUB.ADD;

900: IF NOT IGS_GR_VAL_GR.grdp_val_gr_sca(p_person_id => p_person_id,
901: p_course_cd => p_lgcy_grd_rec.program_cd,
902: p_message_name => l_message) THEN
903: FND_MESSAGE.SET_NAME ('IGS',l_message);
904: FND_MSG_PUB.ADD;
905: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE); --Continue
906: END IF;
907: --End of Validate that the students are allowed to graduate from the specified program
908:

Line 921: FND_MSG_PUB.ADD;

917: IF NOT IGS_GR_VAL_AWC.grdp_val_award_type(p_award_cd => p_lgcy_grd_rec.award_cd,
918: p_s_award_type => l_s_award_type,
919: p_message_name => l_message) THEN
920: FND_MESSAGE.SET_NAME ('IGS',l_message);
921: FND_MSG_PUB.ADD;
922: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE); --Continue
923: END IF;
924: --End of 13, 14 ,15 Validate that the award must be of system award type PROGRAM, HON
925:

Line 937: FND_MSG_PUB.ADD;

933: p_award_cd => p_lgcy_grd_rec.award_cd,
934: p_message_name => l_message
935: )THEN
936: FND_MESSAGE.SET_NAME ('IGS',l_message);
937: FND_MSG_PUB.ADD;
938: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE); --Continue
939: END IF;
940: --End of 16 Validate that the graduand record program award is an award for the student program attempt or an alternative exit
941:

Line 953: FND_MSG_PUB.ADD;

949: p_sur_for_award_cd => p_lgcy_grd_rec.sur_for_award_cd ,
950: p_message_name => l_message) THEN
951:
952: FND_MESSAGE.SET_NAME ('IGS',l_message);
953: FND_MSG_PUB.ADD;
954: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE); --Continue
955: END IF;
956: --end of 17, 18
957:

Line 961: FND_MSG_PUB.ADD;

957:
958: --20
959: IF p_lgcy_grd_rec.s_graduand_type = 'ATTENDING' AND p_lgcy_grd_rec.proxy_award_person_number IS NOT NULL THEN
960: FND_MESSAGE.SET_NAME ('IGS','IGS_GR_PROXY_NOT_ALLOW');
961: FND_MSG_PUB.ADD;
962: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE); --Continue
963: END IF;
964: --End of 20
965:

Line 1009: FND_MSG_PUB.ADD;

1005: p_award_crs_version_number=> p_lgcy_grd_rec.award_prog_version_number,
1006: p_award_cd => p_lgcy_grd_rec.award_cd,
1007: p_message_name => l_message ) THEN
1008: FND_MESSAGE.SET_NAME ('IGS','IGS_GR_GRAD_CR_DT_FAIL');
1009: FND_MSG_PUB.ADD;
1010: l_return_value := FND_API.TO_BOOLEAN(FND_API.G_FALSE);
1011: END IF;
1012:
1013: RETURN l_return_value;