DBA Data[Home] [Help]

APPS.IGS_AD_EXTRACURR_ACT_PKG dependencies on FND_MESSAGE

Line 48: Fnd_Message.Set_Name('IGS','IGS_FI_ST_DT_LE_END_DT');

44: -- A few validation that need to be done
45: -- added by amuthu during ID prospective applicant part 2 of 1 build
46:
47: IF NOT (x_start_date <= x_end_date) THEN
48: Fnd_Message.Set_Name('IGS','IGS_FI_ST_DT_LE_END_DT');
49: IGS_GE_MSG_STACK.ADD;
50: x_msg_data := FND_MESSAGE.GET;
51: l_msg_count :=1;
52: x_return_status := 'E';

Line 50: x_msg_data := FND_MESSAGE.GET;

46:
47: IF NOT (x_start_date <= x_end_date) THEN
48: Fnd_Message.Set_Name('IGS','IGS_FI_ST_DT_LE_END_DT');
49: IGS_GE_MSG_STACK.ADD;
50: x_msg_data := FND_MESSAGE.GET;
51: l_msg_count :=1;
52: x_return_status := 'E';
53: RETURN;
54: ELSIF NOT (x_start_date <= SYSDATE ) THEN

Line 55: Fnd_Message.Set_Name('IGS','IGS_AD_ST_DT_LT_SYS_DT');

51: l_msg_count :=1;
52: x_return_status := 'E';
53: RETURN;
54: ELSIF NOT (x_start_date <= SYSDATE ) THEN
55: Fnd_Message.Set_Name('IGS','IGS_AD_ST_DT_LT_SYS_DT');
56: IGS_GE_MSG_STACK.ADD;
57: x_msg_data := FND_MESSAGE.GET;
58: l_msg_count :=1;
59: x_return_status := 'E';

Line 57: x_msg_data := FND_MESSAGE.GET;

53: RETURN;
54: ELSIF NOT (x_start_date <= SYSDATE ) THEN
55: Fnd_Message.Set_Name('IGS','IGS_AD_ST_DT_LT_SYS_DT');
56: IGS_GE_MSG_STACK.ADD;
57: x_msg_data := FND_MESSAGE.GET;
58: l_msg_count :=1;
59: x_return_status := 'E';
60: RETURN;
61: END IF;

Line 64: Fnd_Message.Set_Name('IGS','IGS_EN_TS_SDT');

60: RETURN;
61: END IF;
62:
63: IF x_start_date IS NULL AND x_end_date IS NOT NULL THEN
64: Fnd_Message.Set_Name('IGS','IGS_EN_TS_SDT');
65: IGS_GE_MSG_STACK.ADD;
66: x_msg_data := FND_MESSAGE.GET;
67: x_return_status := 'E';
68: l_msg_count :=1;

Line 66: x_msg_data := FND_MESSAGE.GET;

62:
63: IF x_start_date IS NULL AND x_end_date IS NOT NULL THEN
64: Fnd_Message.Set_Name('IGS','IGS_EN_TS_SDT');
65: IGS_GE_MSG_STACK.ADD;
66: x_msg_data := FND_MESSAGE.GET;
67: x_return_status := 'E';
68: l_msg_count :=1;
69: RETURN;
70: END IF;

Line 73: Fnd_Message.Set_Name('IGS','IGS_GE_END_DT_GE_ST_DATE');

69: RETURN;
70: END IF;
71:
72: IF NOT (x_end_date >= x_start_date OR x_end_date IS NULL) THEN
73: Fnd_Message.Set_Name('IGS','IGS_GE_END_DT_GE_ST_DATE');
74: IGS_GE_MSG_STACK.ADD;
75: x_msg_data := FND_MESSAGE.GET;
76: x_return_status := 'E';
77: l_msg_count :=1;

Line 75: x_msg_data := FND_MESSAGE.GET;

71:
72: IF NOT (x_end_date >= x_start_date OR x_end_date IS NULL) THEN
73: Fnd_Message.Set_Name('IGS','IGS_GE_END_DT_GE_ST_DATE');
74: IGS_GE_MSG_STACK.ADD;
75: x_msg_data := FND_MESSAGE.GET;
76: x_return_status := 'E';
77: l_msg_count :=1;
78: RETURN;
79: END IF;

Line 83: Fnd_Message.Set_Name('IGS','IGS_AD_HRS_PER_WEEK');

79: END IF;
80:
81: IF NOT (x_hours_per_week >= 0
82: AND x_hours_per_week <= 168 ) THEN
83: Fnd_Message.Set_Name('IGS','IGS_AD_HRS_PER_WEEK');
84: IGS_GE_MSG_STACK.ADD;
85: x_msg_data := FND_MESSAGE.GET;
86: x_return_status := 'E';
87: l_msg_count :=1;

Line 85: x_msg_data := FND_MESSAGE.GET;

81: IF NOT (x_hours_per_week >= 0
82: AND x_hours_per_week <= 168 ) THEN
83: Fnd_Message.Set_Name('IGS','IGS_AD_HRS_PER_WEEK');
84: IGS_GE_MSG_STACK.ADD;
85: x_msg_data := FND_MESSAGE.GET;
86: x_return_status := 'E';
87: l_msg_count :=1;
88: RETURN;
89: END IF;

Line 93: Fnd_Message.Set_Name('IGS','IGS_AD_WKS_PER_YEAR');

89: END IF;
90:
91: IF NOT (x_weeks_per_year >= 0
92: AND x_weeks_per_year <= 52 ) THEN
93: Fnd_Message.Set_Name('IGS','IGS_AD_WKS_PER_YEAR');
94: IGS_GE_MSG_STACK.ADD;
95: x_msg_data := FND_MESSAGE.GET;
96: x_return_status := 'E';
97: l_msg_count :=1;

Line 95: x_msg_data := FND_MESSAGE.GET;

91: IF NOT (x_weeks_per_year >= 0
92: AND x_weeks_per_year <= 52 ) THEN
93: Fnd_Message.Set_Name('IGS','IGS_AD_WKS_PER_YEAR');
94: IGS_GE_MSG_STACK.ADD;
95: x_msg_data := FND_MESSAGE.GET;
96: x_return_status := 'E';
97: l_msg_count :=1;
98: RETURN;
99: END IF;

Line 103: Fnd_Message.Set_Name('IGS','IGS_PE_DREC_GT_BTDT');

99: END IF;
100: OPEN c_birth_date_val; FETCH c_birth_date_val INTO l_date_of_birth; CLOSE c_birth_date_val;
101: IF(x_start_date IS NOT NULL AND l_Date_of_birth IS NOT NULL) THEN
102: IF(x_start_date < l_date_of_birth) THEN
103: Fnd_Message.Set_Name('IGS','IGS_PE_DREC_GT_BTDT');
104: IGS_GE_MSG_STACK.ADD;
105: x_msg_data := FND_MESSAGE.GET;
106: x_return_status := 'E';
107: l_msg_count :=1;

Line 105: x_msg_data := FND_MESSAGE.GET;

101: IF(x_start_date IS NOT NULL AND l_Date_of_birth IS NOT NULL) THEN
102: IF(x_start_date < l_date_of_birth) THEN
103: Fnd_Message.Set_Name('IGS','IGS_PE_DREC_GT_BTDT');
104: IGS_GE_MSG_STACK.ADD;
105: x_msg_data := FND_MESSAGE.GET;
106: x_return_status := 'E';
107: l_msg_count :=1;
108: RETURN;
109: END IF;

Line 240: Fnd_Message.Set_Name('IGS','IGS_FI_ST_DT_LE_END_DT');

236:
237: -- The following code checks for check constraints on the Columns.
238:
239: IF NOT (x_start_date <= x_end_date) THEN
240: Fnd_Message.Set_Name('IGS','IGS_FI_ST_DT_LE_END_DT');
241: IGS_GE_MSG_STACK.ADD;
242: x_msg_data := FND_MESSAGE.GET;
243: x_return_status := 'E';
244: RETURN;

Line 242: x_msg_data := FND_MESSAGE.GET;

238:
239: IF NOT (x_start_date <= x_end_date) THEN
240: Fnd_Message.Set_Name('IGS','IGS_FI_ST_DT_LE_END_DT');
241: IGS_GE_MSG_STACK.ADD;
242: x_msg_data := FND_MESSAGE.GET;
243: x_return_status := 'E';
244: RETURN;
245: ELSIF NOT (x_start_date <= SYSDATE ) THEN
246: Fnd_Message.Set_Name('IGS','IGS_AD_ST_DT_LT_SYS_DT');

Line 246: Fnd_Message.Set_Name('IGS','IGS_AD_ST_DT_LT_SYS_DT');

242: x_msg_data := FND_MESSAGE.GET;
243: x_return_status := 'E';
244: RETURN;
245: ELSIF NOT (x_start_date <= SYSDATE ) THEN
246: Fnd_Message.Set_Name('IGS','IGS_AD_ST_DT_LT_SYS_DT');
247: IGS_GE_MSG_STACK.ADD;
248: x_msg_data := FND_MESSAGE.GET;
249: x_return_status := 'E';
250: RETURN;

Line 248: x_msg_data := FND_MESSAGE.GET;

244: RETURN;
245: ELSIF NOT (x_start_date <= SYSDATE ) THEN
246: Fnd_Message.Set_Name('IGS','IGS_AD_ST_DT_LT_SYS_DT');
247: IGS_GE_MSG_STACK.ADD;
248: x_msg_data := FND_MESSAGE.GET;
249: x_return_status := 'E';
250: RETURN;
251: END IF;
252:

Line 254: Fnd_Message.Set_Name('IGS','IGS_EN_TS_SDT');

250: RETURN;
251: END IF;
252:
253: IF x_start_date IS NULL AND x_end_date IS NOT NULL THEN
254: Fnd_Message.Set_Name('IGS','IGS_EN_TS_SDT');
255: IGS_GE_MSG_STACK.ADD;
256: x_msg_data := FND_MESSAGE.GET;
257: x_return_status := 'E';
258: RETURN;

Line 256: x_msg_data := FND_MESSAGE.GET;

252:
253: IF x_start_date IS NULL AND x_end_date IS NOT NULL THEN
254: Fnd_Message.Set_Name('IGS','IGS_EN_TS_SDT');
255: IGS_GE_MSG_STACK.ADD;
256: x_msg_data := FND_MESSAGE.GET;
257: x_return_status := 'E';
258: RETURN;
259: END IF;
260:

Line 262: Fnd_Message.Set_Name('IGS','IGS_GE_END_DT_GE_ST_DATE');

258: RETURN;
259: END IF;
260:
261: IF NOT (x_end_date >= x_start_date OR x_end_date IS NULL) THEN
262: Fnd_Message.Set_Name('IGS','IGS_GE_END_DT_GE_ST_DATE');
263: IGS_GE_MSG_STACK.ADD;
264: x_msg_data := FND_MESSAGE.GET;
265: x_return_status := 'E';
266: RETURN;

Line 264: x_msg_data := FND_MESSAGE.GET;

260:
261: IF NOT (x_end_date >= x_start_date OR x_end_date IS NULL) THEN
262: Fnd_Message.Set_Name('IGS','IGS_GE_END_DT_GE_ST_DATE');
263: IGS_GE_MSG_STACK.ADD;
264: x_msg_data := FND_MESSAGE.GET;
265: x_return_status := 'E';
266: RETURN;
267: END IF;
268:

Line 271: Fnd_Message.Set_Name('IGS','IGS_AD_HRS_PER_WEEK');

267: END IF;
268:
269: IF NOT (x_hours_per_week >= 0
270: AND x_hours_per_week <= 168 ) THEN
271: Fnd_Message.Set_Name('IGS','IGS_AD_HRS_PER_WEEK');
272: IGS_GE_MSG_STACK.ADD;
273: x_msg_data := FND_MESSAGE.GET;
274: x_return_status := 'E';
275: RETURN;

Line 273: x_msg_data := FND_MESSAGE.GET;

269: IF NOT (x_hours_per_week >= 0
270: AND x_hours_per_week <= 168 ) THEN
271: Fnd_Message.Set_Name('IGS','IGS_AD_HRS_PER_WEEK');
272: IGS_GE_MSG_STACK.ADD;
273: x_msg_data := FND_MESSAGE.GET;
274: x_return_status := 'E';
275: RETURN;
276: END IF;
277:

Line 280: Fnd_Message.Set_Name('IGS','IGS_AD_WKS_PER_YEAR');

276: END IF;
277:
278: IF NOT (x_weeks_per_year >= 0
279: AND x_weeks_per_year <= 52 ) THEN
280: Fnd_Message.Set_Name('IGS','IGS_AD_WKS_PER_YEAR');
281: IGS_GE_MSG_STACK.ADD;
282: x_msg_data := FND_MESSAGE.GET;
283: x_return_status := 'E';
284: RETURN;

Line 282: x_msg_data := FND_MESSAGE.GET;

278: IF NOT (x_weeks_per_year >= 0
279: AND x_weeks_per_year <= 52 ) THEN
280: Fnd_Message.Set_Name('IGS','IGS_AD_WKS_PER_YEAR');
281: IGS_GE_MSG_STACK.ADD;
282: x_msg_data := FND_MESSAGE.GET;
283: x_return_status := 'E';
284: RETURN;
285: END IF;
286: OPEN c_birth_date_val; FETCH c_birth_date_val INTO l_date_of_birth; CLOSE c_birth_date_val;

Line 289: Fnd_Message.Set_Name('IGS','IGS_PE_DREC_GT_BTDT');

285: END IF;
286: OPEN c_birth_date_val; FETCH c_birth_date_val INTO l_date_of_birth; CLOSE c_birth_date_val;
287: IF(x_start_date IS NOT NULL AND l_Date_of_birth IS NOT NULL) THEN
288: IF(x_start_date < l_date_of_birth) THEN
289: Fnd_Message.Set_Name('IGS','IGS_PE_DREC_GT_BTDT');
290: IGS_GE_MSG_STACK.ADD;
291: x_msg_data := FND_MESSAGE.GET;
292: x_return_status := 'E';
293: l_msg_count :=1;

Line 291: x_msg_data := FND_MESSAGE.GET;

287: IF(x_start_date IS NOT NULL AND l_Date_of_birth IS NOT NULL) THEN
288: IF(x_start_date < l_date_of_birth) THEN
289: Fnd_Message.Set_Name('IGS','IGS_PE_DREC_GT_BTDT');
290: IGS_GE_MSG_STACK.ADD;
291: x_msg_data := FND_MESSAGE.GET;
292: x_return_status := 'E';
293: l_msg_count :=1;
294: RETURN;
295: END IF;