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

Line 49: FND_MSG_PUB.Add;

45:
46: -- Check whether the passed person number is null or not.
47: IF p_sprvsr_dtls_rec.ca_person_number IS NULL OR p_sprvsr_dtls_rec.person_number IS NULL THEN
48: FND_MESSAGE.SET_NAME('IGS','IGS_EN_PER_NUM_NULL');
49: FND_MSG_PUB.Add;
50: l_sprvsr_status := 'INVALID';
51: END IF;
52:
53: -- Check whether the user has passed program code or not.

Line 56: FND_MSG_PUB.Add;

52:
53: -- Check whether the user has passed program code or not.
54: IF p_sprvsr_dtls_rec.program_cd IS NULL THEN
55: FND_MESSAGE.SET_NAME('IGS','IGS_EN_PRGM_CD_NULL');
56: FND_MSG_PUB.Add;
57: l_sprvsr_status := 'INVALID';
58: END IF;
59:
60: -- Check whether the start date is null or not.

Line 63: FND_MSG_PUB.Add;

59:
60: -- Check whether the start date is null or not.
61: IF p_sprvsr_dtls_rec.start_dt IS NULL THEN
62: FND_MESSAGE.SET_NAME('IGS','IGS_PS_STARDT_NOT_NULL');
63: FND_MSG_PUB.Add;
64: l_sprvsr_status := 'INVALID';
65: END IF;
66:
67: -- Check whether the research supervisor type is null or not

Line 70: FND_MSG_PUB.Add;

66:
67: -- Check whether the research supervisor type is null or not
68: IF p_sprvsr_dtls_rec.research_supervisor_type IS NULL THEN
69: FND_MESSAGE.SET_NAME('IGS','IGS_RE_SPRVSR_TYP_NULL');
70: FND_MSG_PUB.Add;
71: l_sprvsr_status := 'INVALID';
72: ELSE
73: BEGIN
74:

Line 83: FND_MSG_PUB.COUNT_AND_GET( p_count => l_msg_count,

79: igs_re_sprvsr_pkg.check_constraints ('RESEARCH_SUPERVISOR_TYPE', p_sprvsr_dtls_rec.research_supervisor_type);
80:
81: EXCEPTION
82: WHEN OTHERS THEN
83: FND_MSG_PUB.COUNT_AND_GET( p_count => l_msg_count,
84: p_data => l_msg_data);
85:
86: -- Delete the message 'IGS_GE_INVALID_VALUE'
87: FND_MSG_PUB.DELETE_MSG (l_msg_count);

Line 87: FND_MSG_PUB.DELETE_MSG (l_msg_count);

83: FND_MSG_PUB.COUNT_AND_GET( p_count => l_msg_count,
84: p_data => l_msg_data);
85:
86: -- Delete the message 'IGS_GE_INVALID_VALUE'
87: FND_MSG_PUB.DELETE_MSG (l_msg_count);
88:
89: -- set the customized message
90: FND_MESSAGE.Set_Name('IGS','IGS_RE_SPRVSR_TYPE_VAL');
91: FND_MSG_PUB.Add;

Line 91: FND_MSG_PUB.Add;

87: FND_MSG_PUB.DELETE_MSG (l_msg_count);
88:
89: -- set the customized message
90: FND_MESSAGE.Set_Name('IGS','IGS_RE_SPRVSR_TYPE_VAL');
91: FND_MSG_PUB.Add;
92: l_sprvsr_status := 'INVALID';
93: END;
94: END IF;
95:

Line 102: FND_MSG_PUB.COUNT_AND_GET( p_count => l_msg_count,

98: BEGIN
99: igs_re_sprvsr_pkg.check_constraints ('SUPERVISION_PERCENTAGE', p_sprvsr_dtls_rec.supervision_percentage);
100: EXCEPTION
101: WHEN OTHERS THEN
102: FND_MSG_PUB.COUNT_AND_GET( p_count => l_msg_count,
103: p_data => l_msg_data);
104:
105: FND_MSG_PUB.DELETE_MSG (l_msg_count);
106: FND_MESSAGE.Set_Name('IGS','IGS_RE_SPRVSN_PERC_INVALID_VAL');

Line 105: FND_MSG_PUB.DELETE_MSG (l_msg_count);

101: WHEN OTHERS THEN
102: FND_MSG_PUB.COUNT_AND_GET( p_count => l_msg_count,
103: p_data => l_msg_data);
104:
105: FND_MSG_PUB.DELETE_MSG (l_msg_count);
106: FND_MESSAGE.Set_Name('IGS','IGS_RE_SPRVSN_PERC_INVALID_VAL');
107: FND_MSG_PUB.Add;
108: l_sprvsr_status := 'INVALID';
109: END;

Line 107: FND_MSG_PUB.Add;

103: p_data => l_msg_data);
104:
105: FND_MSG_PUB.DELETE_MSG (l_msg_count);
106: FND_MESSAGE.Set_Name('IGS','IGS_RE_SPRVSN_PERC_INVALID_VAL');
107: FND_MSG_PUB.Add;
108: l_sprvsr_status := 'INVALID';
109: END;
110: END IF;
111:

Line 118: FND_MSG_PUB.COUNT_AND_GET( p_count => l_msg_count,

114: BEGIN
115: igs_re_sprvsr_pkg.check_constraints ('FUNDING_PERCENTAGE', p_sprvsr_dtls_rec.funding_percentage);
116: EXCEPTION
117: WHEN OTHERS THEN
118: FND_MSG_PUB.COUNT_AND_GET( p_count => l_msg_count,
119: p_data => l_msg_data);
120:
121: FND_MSG_PUB.DELETE_MSG (l_msg_count);
122: FND_MESSAGE.Set_Name('IGS','IGS_RE_FUND_PERC_INVALID_VAL');

Line 121: FND_MSG_PUB.DELETE_MSG (l_msg_count);

117: WHEN OTHERS THEN
118: FND_MSG_PUB.COUNT_AND_GET( p_count => l_msg_count,
119: p_data => l_msg_data);
120:
121: FND_MSG_PUB.DELETE_MSG (l_msg_count);
122: FND_MESSAGE.Set_Name('IGS','IGS_RE_FUND_PERC_INVALID_VAL');
123: FND_MSG_PUB.Add;
124: l_sprvsr_status := 'INVALID';
125: END;

Line 123: FND_MSG_PUB.Add;

119: p_data => l_msg_data);
120:
121: FND_MSG_PUB.DELETE_MSG (l_msg_count);
122: FND_MESSAGE.Set_Name('IGS','IGS_RE_FUND_PERC_INVALID_VAL');
123: FND_MSG_PUB.Add;
124: l_sprvsr_status := 'INVALID';
125: END;
126: END IF;
127:

Line 134: FND_MSG_PUB.COUNT_AND_GET( p_count => l_msg_count,

130: BEGIN
131: igs_re_sprvsr_pkg.check_constraints ('ORG_UNIT_CD', p_sprvsr_dtls_rec.org_unit_cd);
132: EXCEPTION
133: WHEN OTHERS THEN
134: FND_MSG_PUB.COUNT_AND_GET( p_count => l_msg_count,
135: p_data => l_msg_data);
136: FND_MSG_PUB.DELETE_MSG (l_msg_count);
137: FND_MESSAGE.Set_Name('IGS','IGS_FI_INVALID_ORG_UNIT_CD');
138: FND_MESSAGE.SET_TOKEN('ORG_CD',p_sprvsr_dtls_rec.org_unit_cd);

Line 136: FND_MSG_PUB.DELETE_MSG (l_msg_count);

132: EXCEPTION
133: WHEN OTHERS THEN
134: FND_MSG_PUB.COUNT_AND_GET( p_count => l_msg_count,
135: p_data => l_msg_data);
136: FND_MSG_PUB.DELETE_MSG (l_msg_count);
137: FND_MESSAGE.Set_Name('IGS','IGS_FI_INVALID_ORG_UNIT_CD');
138: FND_MESSAGE.SET_TOKEN('ORG_CD',p_sprvsr_dtls_rec.org_unit_cd);
139: FND_MSG_PUB.Add;
140: l_sprvsr_status := 'INVALID';

Line 139: FND_MSG_PUB.Add;

135: p_data => l_msg_data);
136: FND_MSG_PUB.DELETE_MSG (l_msg_count);
137: FND_MESSAGE.Set_Name('IGS','IGS_FI_INVALID_ORG_UNIT_CD');
138: FND_MESSAGE.SET_TOKEN('ORG_CD',p_sprvsr_dtls_rec.org_unit_cd);
139: FND_MSG_PUB.Add;
140: l_sprvsr_status := 'INVALID';
141: END;
142: END IF;
143:

Line 286: FND_MSG_PUB.Add;

282: OPEN c_date_ovrlp(l_sequence_number);
283: FETCH c_date_ovrlp INTO l_date_ovrlp;
284: IF c_date_ovrlp%FOUND THEN
285: FND_MESSAGE.SET_NAME('IGS', 'IGS_RE_END_DT_CANT_GE_ST_DT');
286: FND_MSG_PUB.Add;
287: END IF;
288: CLOSE c_date_ovrlp;
289:
290: END IF;

Line 356: FND_MSG_PUB.Add;

352: l_message_text := FND_MESSAGE.GET();
353:
354: FND_MESSAGE.SET_NAME('IGS','IGS_EN_INV');
355: FND_MESSAGE.SET_TOKEN('PARAM',l_message_text);
356: FND_MSG_PUB.Add;
357: l_sprvsr_status := 'INVALID';
358: END IF;
359:
360: END IF;

Line 366: FND_MSG_PUB.Add;

362: -- Check whether research student is the same as the supervisor
363: IF NOT igs_re_val_rsup.resp_val_rsup_person( p_ca_person_id, p_person_id, l_legacy , l_message_name ) THEN
364: IF l_message_name IS NOT NULL THEN
365: FND_MESSAGE.SET_NAME('IGS',l_message_name);
366: FND_MSG_PUB.Add;
367: l_sprvsr_status := 'INVALID';
368: l_message_name := NULL;
369: END IF;
370: END IF;

Line 433: FND_MSG_PUB.Add;

429:
430: IF igs_re_sprvsr_pkg.get_uk1_for_validation ( p_ca_person_id, p_ca_sequence_number,
431: p_person_id, p_sprvsr_dtls_rec.start_dt ) THEN
432: FND_MESSAGE.Set_Name('IGS','IGS_RE_SPRVSR_EXTS');
433: FND_MSG_PUB.Add;
434: p_sprvsr_status := 'INVALID';
435: l_ret_value := 'W';
436: RETURN l_ret_value;
437: END IF;

Line 441: FND_MSG_PUB.Add;

437: END IF;
438:
439: IF NOT igs_re_candidature_pkg.get_pk_for_validation ( p_ca_person_id, p_ca_sequence_number ) THEN
440: FND_MESSAGE.Set_Name('IGS','IGS_RE_CAND_NOT_EXTS');
441: FND_MSG_PUB.Add;
442: p_sprvsr_status := 'INVALID';
443: l_ret_value := 'E';
444: END IF;
445:

Line 449: FND_MSG_PUB.Add;

445:
446: IF NOT igs_re_sprvsr_type_pkg.get_pk_for_validation (p_sprvsr_dtls_rec.research_supervisor_type) THEN
447: FND_MESSAGE.Set_Name('IGS','IGS_RE_SPRVSR_TYP_NT_EXTS');
448: fnd_message.set_token('TYPE',p_sprvsr_dtls_rec.research_supervisor_type);
449: FND_MSG_PUB.Add;
450: p_sprvsr_status := 'INVALID';
451: l_ret_value := 'E';
452: END IF;
453:

Line 530: FND_MSG_PUB.Initialize;

526: END IF;
527:
528: -- If the calling program has passed the parameter for initializing the message list
529: IF FND_API.To_Boolean(p_init_msg_list) THEN
530: FND_MSG_PUB.Initialize;
531: END IF;
532:
533: -- Set the return status to success
534: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 550: FND_MSG_PUB.Add;

546:
547: IF l_ca_person_id IS NULL THEN
548: -- Add exception to stack
549: FND_MESSAGE.Set_Name('IGS','IGS_GE_INVALID_PERSON_NUMBER');
550: FND_MSG_PUB.Add;
551: p_sprvsr_status := 'INVALID';
552: END IF;
553:
554: -- Check whether ca_person_number is valid or not.

Line 559: FND_MSG_PUB.Add;

555: l_person_id := Igs_Ge_Gen_003.Get_Person_id (p_sprvsr_dtls_rec.person_number);
556:
557: IF l_person_id IS NULL THEN
558: FND_MESSAGE.Set_Name('IGS','IGS_GE_INVALID_PERSON_NUMBER');
559: FND_MSG_PUB.Add;
560: p_sprvsr_status := 'INVALID';
561: END IF;
562:
563: -- Check whether candidacy details exists, if it exists then get the ca_sequence_number

Line 572: FND_MSG_PUB.Add;

568: );
569:
570: IF NOT l_result THEN
571: FND_MESSAGE.Set_Name('IGS','IGS_RE_CAND_NOT_EXTS');
572: FND_MSG_PUB.Add;
573: p_sprvsr_status := 'INVALID';
574: END IF;
575:
576: -- Get the start date of the organisation

Line 709: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,

705: END IF;
706:
707: END IF;
708:
709: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
710: p_data => x_msg_data);
711:
712: EXCEPTION
713: WHEN FND_API.G_EXC_ERROR THEN

Line 716: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,

712: EXCEPTION
713: WHEN FND_API.G_EXC_ERROR THEN
714: ROLLBACK TO create_re_sprvsr_pub;
715: x_return_status := FND_API.G_RET_STS_ERROR;
716: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
717: p_data => x_msg_data);
718:
719: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
720: ROLLBACK TO create_re_sprvsr_pub;

Line 722: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,

718:
719: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
720: ROLLBACK TO create_re_sprvsr_pub;
721: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
722: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
723: p_data => x_msg_data);
724:
725: WHEN OTHERS THEN
726: ROLLBACK TO create_re_sprvsr_pub;

Line 728: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

724:
725: WHEN OTHERS THEN
726: ROLLBACK TO create_re_sprvsr_pub;
727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
728: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
729: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,
730: l_api_name);
731: END IF;
732: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,

Line 729: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,

725: WHEN OTHERS THEN
726: ROLLBACK TO create_re_sprvsr_pub;
727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
728: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
729: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,
730: l_api_name);
731: END IF;
732: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
733: p_data => x_msg_data);

Line 732: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,

728: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
729: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,
730: l_api_name);
731: END IF;
732: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
733: p_data => x_msg_data);
734:
735: END create_sprvsr;
736: