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_MSG_PUB

Line 118: FND_MSG_PUB.Initialize;

114:
115: -- If the p_init_msg_list is T, i.e. the calling program wants to initialise
116: -- the message list, then the message list is initialised using the API call
117: IF FND_API.To_Boolean(p_init_msg_list) THEN
118: FND_MSG_PUB.Initialize;
119: END IF;
120:
121: -- Set the return status as success for the api
122: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 146: FND_MSG_PUB.Add;

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:
150: -- Validation 1

Line 155: FND_MSG_PUB.Add;

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:
159: -- Validation 2

Line 166: FND_MSG_PUB.Add;

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:
170: -- Validation 3

Line 177: FND_MSG_PUB.Add;

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:
181:

Line 187: FND_MSG_PUB.Add;

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:
191:

Line 202: FND_MSG_PUB.Add;

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:
206: -- Validation 6

Line 215: FND_MSG_PUB.Add;

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:
219: -- Validation 7

Line 229: FND_MSG_PUB.Add;

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:
233: -- Validation 8

Line 242: FND_MSG_PUB.Add;

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:
246: -- Validation 9

Line 256: FND_MSG_PUB.Add;

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:
260: -- Validation 10

Line 269: FND_MSG_PUB.Add;

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:
273: -- Validation 11

Line 283: FND_MSG_PUB.Add;

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:
287: -- Validation 12

Line 296: FND_MSG_PUB.Add;

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:
300: -- Validation 13

Line 310: FND_MSG_PUB.Add;

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:
314: -- Validation 14

Line 324: FND_MSG_PUB.Add;

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

Line 340: FND_MSG_PUB.Add;

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

Line 357: FND_MSG_PUB.Add;

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

Line 378: FND_MSG_PUB.Add;

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:
382: -- Raising an exception if any any of the above validations fail

Line 688: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

684: IF FND_API.To_Boolean(p_commit) THEN
685: COMMIT WORK;
686: END IF;
687:
688: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
689: p_data => x_msg_data);
690:
691:
692: EXCEPTION

Line 696: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

692: EXCEPTION
693: WHEN FND_API.G_EXC_ERROR THEN
694: ROLLBACK TO Insert_schedule_pub;
695: x_return_status := FND_API.G_RET_STS_ERROR;
696: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
697: p_data => x_msg_data);
698:
699: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
700: ROLLBACK TO Insert_schedule_pub;

Line 702: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

698:
699: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
700: ROLLBACK TO Insert_schedule_pub;
701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
702: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
703: p_data => x_msg_data);
704:
705: WHEN OTHERS THEN
706: ROLLBACK TO Insert_schedule_pub;

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

705: WHEN OTHERS THEN
706: ROLLBACK TO Insert_schedule_pub;
707: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
708:
709: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
710: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,
711: l_api_name);
712: END IF;
713: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

Line 710: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,

706: ROLLBACK TO Insert_schedule_pub;
707: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
708:
709: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
710: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,
711: l_api_name);
712: END IF;
713: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
714: p_data => x_msg_data);

Line 713: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

709: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
710: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,
711: l_api_name);
712: END IF;
713: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
714: p_data => x_msg_data);
715:
716: END insert_schedule;
717:

Line 781: FND_MSG_PUB.Initialize;

777:
778: -- If the p_init_msg_list is T, i.e. the calling program wants to initialise
779: -- the message list, then the message list is initialised using the API call
780: IF FND_API.To_Boolean(p_init_msg_list) THEN
781: FND_MSG_PUB.Initialize;
782: END IF;
783:
784: -- Set the return status as success for the api
785: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 856: FND_MSG_PUB.Add;

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:
860: -- Validation 2

Line 867: FND_MSG_PUB.Add;

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:
871: -- Validation 3

Line 878: FND_MSG_PUB.Add;

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:
882: -- Validation 4

Line 893: FND_MSG_PUB.Add;

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:
897: -- Validation 5

Line 907: FND_MSG_PUB.Add;

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:
911: -- Validation 6

Line 921: FND_MSG_PUB.Add;

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:
925: -- Validation 7

Line 935: FND_MSG_PUB.Add;

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:
939: -- Validation 8

Line 949: FND_MSG_PUB.Add;

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:
953: -- Validation 9

Line 964: FND_MSG_PUB.Add;

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

Line 982: FND_MSG_PUB.Add;

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

Line 1001: FND_MSG_PUB.Add;

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

Line 1023: FND_MSG_PUB.Add;

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:
1027: -- Raising an exception if any any of the above validations fail

Line 1166: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1162: IF FND_API.To_Boolean(p_commit) THEN
1163: COMMIT WORK;
1164: END IF;
1165:
1166: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1167: p_data => x_msg_data);
1168:
1169:
1170: EXCEPTION

Line 1174: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

1170: EXCEPTION
1171: WHEN FND_API.G_EXC_ERROR THEN
1172: ROLLBACK TO Update_Schedule_pub;
1173: x_return_status := FND_API.G_RET_STS_ERROR;
1174: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1175: p_data => x_msg_data);
1176:
1177: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1178: ROLLBACK TO Update_Schedule_pub;

Line 1180: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

1176:
1177: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1178: ROLLBACK TO Update_Schedule_pub;
1179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1180: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1181: p_data => x_msg_data);
1182:
1183: WHEN OTHERS THEN
1184: ROLLBACK TO Update_Schedule_pub;

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

1183: WHEN OTHERS THEN
1184: ROLLBACK TO Update_Schedule_pub;
1185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1186:
1187: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1188:
1189: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,
1190: l_api_name);
1191:

Line 1189: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,

1185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1186:
1187: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1188:
1189: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,
1190: l_api_name);
1191:
1192: END IF;
1193: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

Line 1193: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

1189: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,
1190: l_api_name);
1191:
1192: END IF;
1193: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1194: p_data => x_msg_data);
1195:
1196: END update_schedule;
1197: