DBA Data[Home] [Help]

APPS.IGS_AD_EXTRACURR_ACT_PKG dependencies on IGS_GE_MSG_STACK

Line 49: IGS_GE_MSG_STACK.ADD;

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';
53: RETURN;

Line 56: IGS_GE_MSG_STACK.ADD;

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';
60: RETURN;

Line 65: IGS_GE_MSG_STACK.ADD;

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;
69: RETURN;

Line 74: IGS_GE_MSG_STACK.ADD;

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;
78: RETURN;

Line 84: IGS_GE_MSG_STACK.ADD;

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;
88: RETURN;

Line 94: IGS_GE_MSG_STACK.ADD;

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;
98: RETURN;

Line 104: IGS_GE_MSG_STACK.ADD;

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;
108: RETURN;

Line 241: IGS_GE_MSG_STACK.ADD;

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;
245: ELSIF NOT (x_start_date <= SYSDATE ) THEN

Line 247: IGS_GE_MSG_STACK.ADD;

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

Line 255: IGS_GE_MSG_STACK.ADD;

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

Line 263: IGS_GE_MSG_STACK.ADD;

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

Line 272: IGS_GE_MSG_STACK.ADD;

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

Line 281: IGS_GE_MSG_STACK.ADD;

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

Line 290: IGS_GE_MSG_STACK.ADD;

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;
294: RETURN;