DBA Data[Home] [Help]

APPS.IGS_RE_SPRVSR_LGCY_PUB dependencies on FND_MESSAGE

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

44: BEGIN
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:

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

51: END IF;
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:

Line 62: FND_MESSAGE.SET_NAME('IGS','IGS_PS_STARDT_NOT_NULL');

58: END IF;
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:

Line 69: FND_MESSAGE.SET_NAME('IGS','IGS_RE_SPRVSR_TYP_NULL');

65: END IF;
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

Line 90: FND_MESSAGE.Set_Name('IGS','IGS_RE_SPRVSR_TYPE_VAL');

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;
92: l_sprvsr_status := 'INVALID';
93: END;
94: END IF;

Line 106: FND_MESSAGE.Set_Name('IGS','IGS_RE_SPRVSN_PERC_INVALID_VAL');

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;
110: END IF;

Line 122: FND_MESSAGE.Set_Name('IGS','IGS_RE_FUND_PERC_INVALID_VAL');

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;
126: END IF;

Line 137: FND_MESSAGE.Set_Name('IGS','IGS_FI_INVALID_ORG_UNIT_CD');

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';
141: END;

Line 138: FND_MESSAGE.SET_TOKEN('ORG_CD',p_sprvsr_dtls_rec.org_unit_cd);

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';
141: END;
142: END IF;

Line 167: bdeviset 13-Feb-2006 REplaced cursor c_meaning with fnd_message.set and get and using the cursor c_org_unit_exists

163: Change History
164: Who When What
165: bdeviset 27-Jan-2006 Modified cursor c_date_ovrlp.Used the call igs_en_gen_003.get_staff_ind
166: and removed cursor c_staff_ind for bug# 4995230
167: bdeviset 13-Feb-2006 REplaced cursor c_meaning with fnd_message.set and get and using the cursor c_org_unit_exists
168: instead of literal when no where clause exists.Bug# 5034696
169: ***********************************************************************************************/
170:
171:

Line 285: FND_MESSAGE.SET_NAME('IGS', 'IGS_RE_END_DT_CANT_GE_ST_DT');

281: -- Check whether there is any overlap of date.
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:

Line 351: FND_MESSAGE.SET_NAME('IGS','IGS_RE_ORG_UNIT_CD');

347:
348:
349: IF l_rec_found IS NULL THEN
350:
351: FND_MESSAGE.SET_NAME('IGS','IGS_RE_ORG_UNIT_CD');
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);

Line 352: l_message_text := FND_MESSAGE.GET();

348:
349: IF l_rec_found IS NULL THEN
350:
351: FND_MESSAGE.SET_NAME('IGS','IGS_RE_ORG_UNIT_CD');
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;

Line 354: FND_MESSAGE.SET_NAME('IGS','IGS_EN_INV');

350:
351: FND_MESSAGE.SET_NAME('IGS','IGS_RE_ORG_UNIT_CD');
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;

Line 355: FND_MESSAGE.SET_TOKEN('PARAM',l_message_text);

351: FND_MESSAGE.SET_NAME('IGS','IGS_RE_ORG_UNIT_CD');
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:

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

361:
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;

Line 432: FND_MESSAGE.Set_Name('IGS','IGS_RE_SPRVSR_EXTS');

428: -- to the calling procedure.
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;

Line 440: FND_MESSAGE.Set_Name('IGS','IGS_RE_CAND_NOT_EXTS');

436: RETURN l_ret_value;
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;

Line 447: FND_MESSAGE.Set_Name('IGS','IGS_RE_SPRVSR_TYP_NT_EXTS');

443: l_ret_value := 'E';
444: END IF;
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';

Line 448: fnd_message.set_token('TYPE',p_sprvsr_dtls_rec.research_supervisor_type);

444: END IF;
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;

Line 549: FND_MESSAGE.Set_Name('IGS','IGS_GE_INVALID_PERSON_NUMBER');

545: l_ca_person_id := Igs_Ge_Gen_003.Get_Person_id (p_sprvsr_dtls_rec.ca_person_number);
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:

Line 558: FND_MESSAGE.Set_Name('IGS','IGS_GE_INVALID_PERSON_NUMBER');

554: -- Check whether ca_person_number is valid or not.
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:

Line 571: FND_MESSAGE.Set_Name('IGS','IGS_RE_CAND_NOT_EXTS');

567: l_ca_sequence_number
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: