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_PS_SCH_INT_API_PUB dependencies on FND_MESSAGE

Line 144: FND_MESSAGE.Set_Name('IGS','IGS_FI_INVALID_TXN_TYPE');

140: -- Validation 0
141: -- Transaction type should have a valid value
142: IF p_transaction_type IS NULL OR
143: p_transaction_type NOT IN ('REQUEST','UPDATE','CANCEL') THEN
144: FND_MESSAGE.Set_Name('IGS','IGS_FI_INVALID_TXN_TYPE');
145: FND_MESSAGE.Set_Token('TXN_TYPE',p_transaction_type);
146: FND_MSG_PUB.Add;
147: x_return_status := FND_API.G_RET_STS_ERROR;
148: END IF;

Line 145: FND_MESSAGE.Set_Token('TXN_TYPE',p_transaction_type);

141: -- Transaction type should have a valid value
142: IF p_transaction_type IS NULL OR
143: p_transaction_type NOT IN ('REQUEST','UPDATE','CANCEL') THEN
144: FND_MESSAGE.Set_Name('IGS','IGS_FI_INVALID_TXN_TYPE');
145: FND_MESSAGE.Set_Token('TXN_TYPE',p_transaction_type);
146: FND_MSG_PUB.Add;
147: x_return_status := FND_API.G_RET_STS_ERROR;
148: END IF;
149:

Line 154: FND_MESSAGE.Set_Name('IGS','IGS_PS_SCH_ERR_TEXT_NULL');

150: -- Validation 1
151: -- Error text is mandatory for unit section occurrence scheduled as Error.
152:
153: IF p_schedule_status = 'ERROR' AND p_error_text IS NULL THEN
154: FND_MESSAGE.Set_Name('IGS','IGS_PS_SCH_ERR_TEXT_NULL');
155: FND_MSG_PUB.Add;
156: x_return_status := FND_API.G_RET_STS_ERROR;
157: END IF;
158:

Line 165: FND_MESSAGE.Set_Name('IGS','IGS_PS_SCH_BD_OR_RM_NULL');

161:
162: IF p_schedule_status = 'OK' AND
163: (p_building_id IS NULL) AND
164: (p_transaction_type = 'UPDATE' OR p_transaction_type = 'REQUEST') THEN
165: FND_MESSAGE.Set_Name('IGS','IGS_PS_SCH_BD_OR_RM_NULL');
166: FND_MSG_PUB.Add;
167: x_return_status := FND_API.G_RET_STS_ERROR;
168: END IF;
169:

Line 176: FND_MESSAGE.Set_Name('IGS','IGS_PS_SCH_BD_OR_RM_NOT_NULL');

172:
173: IF p_schedule_status = 'OK' AND
174: (p_building_id IS NOT NULL OR p_room_id IS NOT NULL) AND
175: p_transaction_type = 'CANCEL' THEN
176: FND_MESSAGE.Set_Name('IGS','IGS_PS_SCH_BD_OR_RM_NOT_NULL');
177: FND_MSG_PUB.Add;
178: x_return_status := FND_API.G_RET_STS_ERROR;
179: END IF;
180:

Line 186: FND_MESSAGE.Set_Name('IGS','IGS_PS_CONFLICT_SCHD');

182: -- Validation 4
183: -- Checking if the scheduling done through third party software is conflicting with the existing schedule
184:
185: IF cur_usec_rec.schedule_status IN ('PROCESSING','USER_UPDATE','USER_CANCEL') THEN
186: FND_MESSAGE.Set_Name('IGS','IGS_PS_CONFLICT_SCHD');
187: FND_MSG_PUB.Add;
188: x_return_status := FND_API.G_RET_STS_ERROR;
189: END IF;
190:

Line 201: FND_MESSAGE.Set_Name('IGS','IGS_PE_EDT_LT_SDT');

197: p_uso_end_date IS NOT NULL AND
198: p_uso_start_date > p_uso_end_date AND
199: cur_usec_rec.to_be_announced = 'Y' AND
200: (p_transaction_type = 'UPDATE' OR p_transaction_type = 'REQUEST') THEN
201: FND_MESSAGE.Set_Name('IGS','IGS_PE_EDT_LT_SDT');
202: FND_MSG_PUB.Add;
203: x_return_status := FND_API.G_RET_STS_ERROR;
204: END IF;
205:

Line 214: FND_MESSAGE.Set_Name('IGS','IGS_PS_USO_STDT_GE_US_STDT');

210: p_uso_start_date IS NOT NULL AND
211: p_uso_start_date < p_cal_start_dt AND
212: cur_usec_rec.to_be_announced = 'Y' AND
213: (p_transaction_type = 'UPDATE' OR p_transaction_type = 'REQUEST') THEN
214: FND_MESSAGE.Set_Name('IGS','IGS_PS_USO_STDT_GE_US_STDT');
215: FND_MSG_PUB.Add;
216: x_return_status := FND_API.G_RET_STS_ERROR;
217: END IF;
218:

Line 228: FND_MESSAGE.Set_Name('IGS','IGS_PS_USO_STDT_GE_TP_STDT');

224: p_cal_start_dt IS NULL AND
225: p_uso_start_date < rec_cal.start_dt AND
226: cur_usec_rec.to_be_announced = 'Y' AND
227: (p_transaction_type = 'UPDATE' OR p_transaction_type = 'REQUEST') THEN
228: FND_MESSAGE.Set_Name('IGS','IGS_PS_USO_STDT_GE_TP_STDT');
229: FND_MSG_PUB.Add;
230: x_return_status := FND_API.G_RET_STS_ERROR;
231: END IF;
232:

Line 241: FND_MESSAGE.Set_Name('IGS','IGS_PS_USO_ST_DT_UOO_END_DT');

237: p_uso_start_date IS NOT NULL AND
238: p_uso_start_date > p_cal_end_dt AND
239: cur_usec_rec.to_be_announced = 'Y' AND
240: (p_transaction_type = 'UPDATE' OR p_transaction_type = 'REQUEST') THEN
241: FND_MESSAGE.Set_Name('IGS','IGS_PS_USO_ST_DT_UOO_END_DT');
242: FND_MSG_PUB.Add;
243: x_return_status := FND_API.G_RET_STS_ERROR;
244: END IF;
245:

Line 255: FND_MESSAGE.Set_Name('IGS','IGS_PS_USO_ST_DT_TP_END_DT');

251: p_cal_end_dt IS NULL AND
252: p_uso_start_date > rec_cal.end_dt AND
253: cur_usec_rec.to_be_announced = 'Y' AND
254: (p_transaction_type = 'UPDATE' OR p_transaction_type = 'REQUEST') THEN
255: FND_MESSAGE.Set_Name('IGS','IGS_PS_USO_ST_DT_TP_END_DT');
256: FND_MSG_PUB.Add;
257: x_return_status := FND_API.G_RET_STS_ERROR;
258: END IF;
259:

Line 268: FND_MESSAGE.Set_Name('IGS','IGS_PS_USO_END_DT_UOO_ST_DT');

264: p_uso_end_date IS NOT NULL AND
265: p_uso_end_date < p_cal_start_dt AND
266: cur_usec_rec.to_be_announced = 'Y' AND
267: (p_transaction_type = 'UPDATE' OR p_transaction_type = 'REQUEST') THEN
268: FND_MESSAGE.Set_Name('IGS','IGS_PS_USO_END_DT_UOO_ST_DT');
269: FND_MSG_PUB.Add;
270: x_return_status := FND_API.G_RET_STS_ERROR;
271: END IF;
272:

Line 282: FND_MESSAGE.Set_Name('IGS','IGS_PS_USO_END_DT_TP_ST_DT');

278: p_cal_start_dt IS NULL AND
279: p_uso_end_date < rec_cal.start_dt AND
280: cur_usec_rec.to_be_announced = 'Y' AND
281: (p_transaction_type = 'UPDATE' OR p_transaction_type = 'REQUEST') THEN
282: FND_MESSAGE.Set_Name('IGS','IGS_PS_USO_END_DT_TP_ST_DT');
283: FND_MSG_PUB.Add;
284: x_return_status := FND_API.G_RET_STS_ERROR;
285: END IF;
286:

Line 295: FND_MESSAGE.Set_Name('IGS','IGS_PS_USO_ENDT_LE_US_ENDT');

291: p_uso_end_date IS NOT NULL AND
292: p_uso_end_date > p_cal_end_dt AND
293: cur_usec_rec.to_be_announced = 'Y' AND
294: (p_transaction_type = 'UPDATE' OR p_transaction_type = 'REQUEST') THEN
295: FND_MESSAGE.Set_Name('IGS','IGS_PS_USO_ENDT_LE_US_ENDT');
296: FND_MSG_PUB.Add;
297: x_return_status := FND_API.G_RET_STS_ERROR;
298: END IF;
299:

Line 309: FND_MESSAGE.Set_Name('IGS','IGS_PS_USO_ENDT_LE_TP_ENDT');

305: p_cal_end_dt IS NULL AND
306: p_uso_end_date > rec_cal.end_dt AND
307: cur_usec_rec.to_be_announced = 'Y' AND
308: (p_transaction_type = 'UPDATE' OR p_transaction_type = 'REQUEST') THEN
309: FND_MESSAGE.Set_Name('IGS','IGS_PS_USO_ENDT_LE_TP_ENDT');
310: FND_MSG_PUB.Add;
311: x_return_status := FND_API.G_RET_STS_ERROR;
312: END IF;
313:

Line 323: FND_MESSAGE.Set_Name('IGS','IGS_PS_BUILDING_ID_INVALID');

319: (p_transaction_type = 'UPDATE' OR p_transaction_type = 'REQUEST') THEN
320: OPEN c_bld(p_building_id);
321: FETCH c_bld INTO rec_bld;
322: IF c_bld%NOTFOUND THEN
323: FND_MESSAGE.Set_Name('IGS','IGS_PS_BUILDING_ID_INVALID');
324: FND_MSG_PUB.Add;
325: x_return_status := FND_API.G_RET_STS_ERROR;
326: END IF;
327: CLOSE c_bld;

Line 339: FND_MESSAGE.Set_Name('IGS','IGS_PS_ROOM_ID_INVALID');

335: (p_transaction_type = 'UPDATE' OR p_transaction_type = 'REQUEST') THEN
336: OPEN c_room(p_room_id);
337: FETCH c_room INTO rec_room;
338: IF c_room%NOTFOUND THEN
339: FND_MESSAGE.Set_Name('IGS','IGS_PS_ROOM_ID_INVALID');
340: FND_MSG_PUB.Add;
341: x_return_status := FND_API.G_RET_STS_ERROR;
342: END IF;
343: CLOSE c_room;

Line 356: FND_MESSAGE.Set_Name('IGS','IGS_PS_ROOM_INV_FOR_BLD');

352: (p_transaction_type = 'UPDATE' OR p_transaction_type = 'REQUEST') THEN
353: OPEN c_bld_room(p_room_id,p_building_id);
354: FETCH c_bld_room INTO rec_bld_room;
355: IF c_bld_room%NOTFOUND THEN
356: FND_MESSAGE.Set_Name('IGS','IGS_PS_ROOM_INV_FOR_BLD');
357: FND_MSG_PUB.Add;
358: x_return_status := FND_API.G_RET_STS_ERROR;
359: END IF;
360: CLOSE c_bld_room;

Line 377: FND_MESSAGE.Set_Name('IGS','IGS_PS_ATLEAST_ONE_DAY_CHECK');

373: NVL(p_friday,'N') = 'N' AND
374: NVL(p_saturday,'N') = 'N' AND
375: cur_usec_rec.to_be_announced = 'Y' AND
376: (p_transaction_type = 'UPDATE' OR p_transaction_type = 'REQUEST') THEN
377: FND_MESSAGE.Set_Name('IGS','IGS_PS_ATLEAST_ONE_DAY_CHECK');
378: FND_MSG_PUB.Add;
379: x_return_status := FND_API.G_RET_STS_ERROR;
380: END IF;
381:

Line 855: FND_MESSAGE.Set_Name('IGS','IGS_PS_SCH_ERR_TEXT_NULL');

851: -- Validation 1
852: -- Error text is mandatory for unit section occurrence scheduled as Error.
853:
854: IF p_schedule_status = 'ERROR' AND p_error_text IS NULL THEN
855: FND_MESSAGE.Set_Name('IGS','IGS_PS_SCH_ERR_TEXT_NULL');
856: FND_MSG_PUB.Add;
857: x_return_status := FND_API.G_RET_STS_ERROR;
858: END IF;
859:

Line 866: FND_MESSAGE.Set_Name('IGS','IGS_PS_SCH_BD_OR_RM_NULL');

862:
863: IF p_schedule_status = 'OK' AND
864: (p_building_id IS NULL) AND
865: (cur_usec_rec.transaction_type = 'UPDATE' OR cur_usec_rec.transaction_type = 'REQUEST') THEN
866: FND_MESSAGE.Set_Name('IGS','IGS_PS_SCH_BD_OR_RM_NULL');
867: FND_MSG_PUB.Add;
868: x_return_status := FND_API.G_RET_STS_ERROR;
869: END IF;
870:

Line 877: FND_MESSAGE.Set_Name('IGS','IGS_PS_SCH_BD_OR_RM_NOT_NULL');

873:
874: IF p_schedule_status = 'OK' AND
875: (p_building_id IS NOT NULL OR p_room_id IS NOT NULL) AND
876: cur_usec_rec.transaction_type = 'CANCEL' THEN
877: FND_MESSAGE.Set_Name('IGS','IGS_PS_SCH_BD_OR_RM_NOT_NULL');
878: FND_MSG_PUB.Add;
879: x_return_status := FND_API.G_RET_STS_ERROR;
880: END IF;
881:

Line 892: FND_MESSAGE.Set_Name('IGS','IGS_PE_EDT_LT_SDT');

888: p_uso_start_date > p_uso_end_date AND
889: (cur_usec_rec.transaction_type = 'UPDATE' OR cur_usec_rec.transaction_type = 'REQUEST') AND
890: cur_usec_rec.tba_status = 'Y' AND
891: cur_usec_rec.uso_start_date IS NULL AND cur_usec_rec.uso_end_date IS NULL THEN
892: FND_MESSAGE.Set_Name('IGS','IGS_PE_EDT_LT_SDT');
893: FND_MSG_PUB.Add;
894: x_return_status := FND_API.G_RET_STS_ERROR;
895: END IF;
896:

Line 906: FND_MESSAGE.Set_Name('IGS','IGS_PS_USO_STDT_GE_US_STDT');

902: p_uso_start_date < cur_usec_rec.us_start_date AND
903: (cur_usec_rec.transaction_type = 'UPDATE' OR cur_usec_rec.transaction_type = 'REQUEST') AND
904: cur_usec_rec.tba_status = 'Y' AND
905: cur_usec_rec.uso_start_date IS NULL THEN
906: FND_MESSAGE.Set_Name('IGS','IGS_PS_USO_STDT_GE_US_STDT');
907: FND_MSG_PUB.Add;
908: x_return_status := FND_API.G_RET_STS_ERROR;
909: END IF;
910:

Line 920: FND_MESSAGE.Set_Name('IGS','IGS_PS_USO_ST_DT_UOO_END_DT');

916: p_uso_start_date > cur_usec_rec.us_end_date AND
917: (cur_usec_rec.transaction_type = 'UPDATE' OR cur_usec_rec.transaction_type = 'REQUEST') AND
918: cur_usec_rec.tba_status = 'Y' AND
919: cur_usec_rec.uso_start_date IS NULL THEN
920: FND_MESSAGE.Set_Name('IGS','IGS_PS_USO_ST_DT_UOO_END_DT');
921: FND_MSG_PUB.Add;
922: x_return_status := FND_API.G_RET_STS_ERROR;
923: END IF;
924:

Line 934: FND_MESSAGE.Set_Name('IGS','IGS_PS_USO_END_DT_UOO_ST_DT');

930: p_uso_end_date < cur_usec_rec.us_start_date AND
931: (cur_usec_rec.transaction_type = 'UPDATE' OR cur_usec_rec.transaction_type = 'REQUEST') AND
932: cur_usec_rec.tba_status = 'Y' AND
933: cur_usec_rec.uso_end_date IS NULL THEN
934: FND_MESSAGE.Set_Name('IGS','IGS_PS_USO_END_DT_UOO_ST_DT');
935: FND_MSG_PUB.Add;
936: x_return_status := FND_API.G_RET_STS_ERROR;
937: END IF;
938:

Line 948: FND_MESSAGE.Set_Name('IGS','IGS_PS_USO_ENDT_LE_US_ENDT');

944: p_uso_end_date > cur_usec_rec.us_end_date AND
945: (cur_usec_rec.transaction_type = 'UPDATE' OR cur_usec_rec.transaction_type = 'REQUEST') AND
946: cur_usec_rec.tba_status = 'Y' AND
947: cur_usec_rec.uso_end_date IS NULL THEN
948: FND_MESSAGE.Set_Name('IGS','IGS_PS_USO_ENDT_LE_US_ENDT');
949: FND_MSG_PUB.Add;
950: x_return_status := FND_API.G_RET_STS_ERROR;
951: END IF;
952:

Line 963: FND_MESSAGE.Set_Name('IGS','IGS_PS_BUILDING_ID_INVALID');

959:
960: OPEN c_bld(p_building_id);
961: FETCH c_bld INTO rec_bld;
962: IF c_bld%NOTFOUND THEN
963: FND_MESSAGE.Set_Name('IGS','IGS_PS_BUILDING_ID_INVALID');
964: FND_MSG_PUB.Add;
965: x_return_status := FND_API.G_RET_STS_ERROR;
966: END IF;
967: CLOSE c_bld;

Line 981: FND_MESSAGE.Set_Name('IGS','IGS_PS_ROOM_ID_INVALID');

977:
978: OPEN c_room(p_room_id);
979: FETCH c_room INTO rec_room;
980: IF c_room%NOTFOUND THEN
981: FND_MESSAGE.Set_Name('IGS','IGS_PS_ROOM_ID_INVALID');
982: FND_MSG_PUB.Add;
983: x_return_status := FND_API.G_RET_STS_ERROR;
984: END IF;
985: CLOSE c_room;

Line 1000: FND_MESSAGE.Set_Name('IGS','IGS_PS_ROOM_INV_FOR_BLD');

996:
997: OPEN c_bld_room(p_room_id,p_building_id);
998: FETCH c_bld_room INTO rec_bld_room;
999: IF c_bld_room%NOTFOUND THEN
1000: FND_MESSAGE.Set_Name('IGS','IGS_PS_ROOM_INV_FOR_BLD');
1001: FND_MSG_PUB.Add;
1002: x_return_status := FND_API.G_RET_STS_ERROR;
1003: END IF;
1004: CLOSE c_bld_room;

Line 1022: FND_MESSAGE.Set_Name('IGS','IGS_PS_ATLEAST_ONE_DAY_CHECK');

1018: NVL(p_saturday,'N') = 'N' AND
1019: cur_usec_rec.tba_status = 'Y' AND
1020: (cur_usec_rec.transaction_type = 'UPDATE' OR cur_usec_rec.transaction_type = 'REQUEST') THEN
1021:
1022: FND_MESSAGE.Set_Name('IGS','IGS_PS_ATLEAST_ONE_DAY_CHECK');
1023: FND_MSG_PUB.Add;
1024: x_return_status := FND_API.G_RET_STS_ERROR;
1025: END IF;
1026: