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.GMO_DISPENSE_GRP dependencies on FND_MSG_PUB

Line 35: FND_MSG_PUB.initialize;

31: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
32: END IF;
33: -- Initialize message list if p_init_msg_list is set to TRUE.
34: IF FND_API.to_Boolean( p_init_msg_list ) THEN
35: FND_MSG_PUB.initialize;
36: END IF;
37:
38: -- check if GMO is enabled
39: IF (GMO_SETUP_GRP.IS_GMO_ENABLED = GMO_CONSTANTS_GRP.NO) THEN

Line 42: FND_MSG_PUB.ADD;

38: -- check if GMO is enabled
39: IF (GMO_SETUP_GRP.IS_GMO_ENABLED = GMO_CONSTANTS_GRP.NO) THEN
40: x_return_status := FND_API.G_RET_STS_SUCCESS;
41: FND_MESSAGE.SET_NAME('GMO','GMO_DISABLED_ERR');
42: FND_MSG_PUB.ADD;
43: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
44: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
45: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_dispense_grp.maintain_reservation', FALSE);
46: end if;

Line 43: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

39: IF (GMO_SETUP_GRP.IS_GMO_ENABLED = GMO_CONSTANTS_GRP.NO) THEN
40: x_return_status := FND_API.G_RET_STS_SUCCESS;
41: FND_MESSAGE.SET_NAME('GMO','GMO_DISABLED_ERR');
42: FND_MSG_PUB.ADD;
43: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
44: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
45: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_dispense_grp.maintain_reservation', FALSE);
46: end if;
47: RETURN;

Line 77: FND_MSG_PUB.Count_And_Get

73: COMMIT;
74: END IF;
75:
76: -- Standard call to get message count and if count is 1, get message info.
77: FND_MSG_PUB.Count_And_Get
78: ( p_count=> x_msg_count,
79: p_data => x_msg_data
80: );
81: EXCEPTION

Line 85: FND_MSG_PUB.ADD;

81: EXCEPTION
82: WHEN FND_API.G_EXC_ERROR THEN
83: ROLLBACK TO MAINTAIN_RESERVATION;
84: x_return_status := FND_API.G_RET_STS_ERROR ;
85: FND_MSG_PUB.ADD;
86: FND_MSG_PUB.Count_And_Get
87: ( p_count=> x_msg_count ,
88: p_data=> x_msg_data
89: );

Line 86: FND_MSG_PUB.Count_And_Get

82: WHEN FND_API.G_EXC_ERROR THEN
83: ROLLBACK TO MAINTAIN_RESERVATION;
84: x_return_status := FND_API.G_RET_STS_ERROR ;
85: FND_MSG_PUB.ADD;
86: FND_MSG_PUB.Count_And_Get
87: ( p_count=> x_msg_count ,
88: p_data=> x_msg_data
89: );
90: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 93: FND_MSG_PUB.ADD;

89: );
90: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
91: ROLLBACK TO MAINTAIN_RESERVATION;
92: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
93: FND_MSG_PUB.ADD;
94: FND_MSG_PUB.Count_And_Get
95: ( p_count=> x_msg_count ,
96: p_data=> x_msg_data
97: );

Line 94: FND_MSG_PUB.Count_And_Get

90: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
91: ROLLBACK TO MAINTAIN_RESERVATION;
92: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
93: FND_MSG_PUB.ADD;
94: FND_MSG_PUB.Count_And_Get
95: ( p_count=> x_msg_count ,
96: p_data=> x_msg_data
97: );
98: WHEN OTHERS THEN

Line 101: IF FND_MSG_PUB.Check_Msg_Level

97: );
98: WHEN OTHERS THEN
99: ROLLBACK TO MAINTAIN_RESERVATION;
100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
101: IF FND_MSG_PUB.Check_Msg_Level
102: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
103: THEN
104: FND_MSG_PUB.Add_Exc_Msg
105: ( G_PKG_NAME ,

Line 102: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

98: WHEN OTHERS THEN
99: ROLLBACK TO MAINTAIN_RESERVATION;
100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
101: IF FND_MSG_PUB.Check_Msg_Level
102: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
103: THEN
104: FND_MSG_PUB.Add_Exc_Msg
105: ( G_PKG_NAME ,
106: l_api_name

Line 104: FND_MSG_PUB.Add_Exc_Msg

100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
101: IF FND_MSG_PUB.Check_Msg_Level
102: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
103: THEN
104: FND_MSG_PUB.Add_Exc_Msg
105: ( G_PKG_NAME ,
106: l_api_name
107: );
108: END IF;

Line 109: FND_MSG_PUB.Count_And_Get

105: ( G_PKG_NAME ,
106: l_api_name
107: );
108: END IF;
109: FND_MSG_PUB.Count_And_Get
110: ( p_count=> x_msg_count ,
111: p_data=> x_msg_data
112: );
113:

Line 147: FND_MSG_PUB.initialize;

143:
144: END IF;
145: -- Initialize message list if p_init_msg_list is set to TRUE.
146: IF FND_API.to_Boolean( p_init_msg_list ) THEN
147: FND_MSG_PUB.initialize;
148: END IF;
149: -- check if GMO is enabled
150: IF (GMO_SETUP_GRP.IS_GMO_ENABLED = GMO_CONSTANTS_GRP.NO) THEN
151: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 153: FND_MSG_PUB.ADD;

149: -- check if GMO is enabled
150: IF (GMO_SETUP_GRP.IS_GMO_ENABLED = GMO_CONSTANTS_GRP.NO) THEN
151: x_return_status := FND_API.G_RET_STS_SUCCESS;
152: FND_MESSAGE.SET_NAME('GMO','GMO_DISABLED_ERR');
153: FND_MSG_PUB.ADD;
154: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
155: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
156: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_dispense_grp.change_dispense_status', FALSE);
157:

Line 154: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

150: IF (GMO_SETUP_GRP.IS_GMO_ENABLED = GMO_CONSTANTS_GRP.NO) THEN
151: x_return_status := FND_API.G_RET_STS_SUCCESS;
152: FND_MESSAGE.SET_NAME('GMO','GMO_DISABLED_ERR');
153: FND_MSG_PUB.ADD;
154: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
155: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
156: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_dispense_grp.change_dispense_status', FALSE);
157:
158: end if;

Line 188: FND_MSG_PUB.Count_And_Get

184: END IF;
185:
186:
187: -- Standard call to get message count and if count is 1, get message info.
188: FND_MSG_PUB.Count_And_Get
189: ( p_count=> x_msg_count,
190: p_data => x_msg_data
191: );
192:

Line 197: FND_MSG_PUB.ADD;

193: EXCEPTION
194: WHEN FND_API.G_EXC_ERROR THEN
195: ROLLBACK TO CHANGE_DISPENSE_STATUS;
196: x_return_status := FND_API.G_RET_STS_ERROR ;
197: FND_MSG_PUB.ADD;
198: FND_MSG_PUB.Count_And_Get
199: ( p_count=> x_msg_count ,
200: p_data=> x_msg_data
201: );

Line 198: FND_MSG_PUB.Count_And_Get

194: WHEN FND_API.G_EXC_ERROR THEN
195: ROLLBACK TO CHANGE_DISPENSE_STATUS;
196: x_return_status := FND_API.G_RET_STS_ERROR ;
197: FND_MSG_PUB.ADD;
198: FND_MSG_PUB.Count_And_Get
199: ( p_count=> x_msg_count ,
200: p_data=> x_msg_data
201: );
202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 205: FND_MSG_PUB.ADD;

201: );
202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
203: ROLLBACK TO CHANGE_DISPENSE_STATUS;
204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
205: FND_MSG_PUB.ADD;
206: FND_MSG_PUB.Count_And_Get
207: ( p_count=> x_msg_count ,
208: p_data=> x_msg_data
209: );

Line 206: FND_MSG_PUB.Count_And_Get

202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
203: ROLLBACK TO CHANGE_DISPENSE_STATUS;
204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
205: FND_MSG_PUB.ADD;
206: FND_MSG_PUB.Count_And_Get
207: ( p_count=> x_msg_count ,
208: p_data=> x_msg_data
209: );
210: WHEN WRONG_STATUS_ERROR THEN

Line 213: FND_MSG_PUB.ADD;

209: );
210: WHEN WRONG_STATUS_ERROR THEN
211: ROLLBACK TO CHANGE_DISPENSE_STATUS;
212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
213: FND_MSG_PUB.ADD;
214: FND_MSG_PUB.Count_And_Get
215: ( p_count=> x_msg_count ,
216: p_data=> x_msg_data
217: );

Line 214: FND_MSG_PUB.Count_And_Get

210: WHEN WRONG_STATUS_ERROR THEN
211: ROLLBACK TO CHANGE_DISPENSE_STATUS;
212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
213: FND_MSG_PUB.ADD;
214: FND_MSG_PUB.Count_And_Get
215: ( p_count=> x_msg_count ,
216: p_data=> x_msg_data
217: );
218: WHEN OTHERS THEN

Line 221: IF FND_MSG_PUB.Check_Msg_Level

217: );
218: WHEN OTHERS THEN
219: ROLLBACK TO CHANGE_DISPENSE_STATUS;
220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
221: IF FND_MSG_PUB.Check_Msg_Level
222: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
223: THEN
224: FND_MSG_PUB.Add_Exc_Msg
225: ( G_PKG_NAME ,

Line 222: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

218: WHEN OTHERS THEN
219: ROLLBACK TO CHANGE_DISPENSE_STATUS;
220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
221: IF FND_MSG_PUB.Check_Msg_Level
222: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
223: THEN
224: FND_MSG_PUB.Add_Exc_Msg
225: ( G_PKG_NAME ,
226: l_api_name

Line 224: FND_MSG_PUB.Add_Exc_Msg

220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
221: IF FND_MSG_PUB.Check_Msg_Level
222: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
223: THEN
224: FND_MSG_PUB.Add_Exc_Msg
225: ( G_PKG_NAME ,
226: l_api_name
227: );
228: END IF;

Line 229: FND_MSG_PUB.Count_And_Get

225: ( G_PKG_NAME ,
226: l_api_name
227: );
228: END IF;
229: FND_MSG_PUB.Count_And_Get
230: ( p_count=> x_msg_count ,
231: p_data=> x_msg_data
232: );
233:

Line 270: FND_MSG_PUB.initialize;

266: END IF;
267:
268: -- Initialize message list if the caller asks me to do so
269: IF FND_API.to_Boolean( p_init_msg_list ) THEN
270: FND_MSG_PUB.initialize;
271: END IF;
272: -- check if GMO is enabled
273: IF (GMO_SETUP_GRP.IS_GMO_ENABLED = GMO_CONSTANTS_GRP.NO) THEN
274: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 276: FND_MSG_PUB.ADD;

272: -- check if GMO is enabled
273: IF (GMO_SETUP_GRP.IS_GMO_ENABLED = GMO_CONSTANTS_GRP.NO) THEN
274: x_return_status := FND_API.G_RET_STS_SUCCESS;
275: FND_MESSAGE.SET_NAME('GMO','GMO_DISABLED_ERR');
276: FND_MSG_PUB.ADD;
277: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
278: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
279: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_dispense_grp.IS_DISPENSE_ITEM', FALSE);
280: end if;

Line 277: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

273: IF (GMO_SETUP_GRP.IS_GMO_ENABLED = GMO_CONSTANTS_GRP.NO) THEN
274: x_return_status := FND_API.G_RET_STS_SUCCESS;
275: FND_MESSAGE.SET_NAME('GMO','GMO_DISABLED_ERR');
276: FND_MSG_PUB.ADD;
277: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
278: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
279: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_dispense_grp.IS_DISPENSE_ITEM', FALSE);
280: end if;
281: x_dispense_required := 'N';

Line 309: FND_MSG_PUB.Add;

305: END IF;
306: END IF;
307:
308: x_return_status := FND_API.G_RET_STS_SUCCESS;
309: FND_MSG_PUB.Add;
310: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
311:
312: EXCEPTION
313: WHEN FND_API.G_EXC_ERROR THEN

Line 310: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

306: END IF;
307:
308: x_return_status := FND_API.G_RET_STS_SUCCESS;
309: FND_MSG_PUB.Add;
310: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
311:
312: EXCEPTION
313: WHEN FND_API.G_EXC_ERROR THEN
314: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 315: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

311:
312: EXCEPTION
313: WHEN FND_API.G_EXC_ERROR THEN
314: x_return_status := FND_API.G_RET_STS_ERROR ;
315: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
316:
317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
319: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

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

315: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
316:
317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
319: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
320: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
321: END IF;
322: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
323:

Line 320: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );

316:
317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
319: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
320: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
321: END IF;
322: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
323:
324: WHEN GMO_ITEM_NOT_RESERVABLE_ERR THEN

Line 322: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
319: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
320: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
321: END IF;
322: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
323:
324: WHEN GMO_ITEM_NOT_RESERVABLE_ERR THEN
325: x_return_status := 'W';
326: x_dispense_required := 'N';

Line 328: FND_MSG_PUB.ADD;

324: WHEN GMO_ITEM_NOT_RESERVABLE_ERR THEN
325: x_return_status := 'W';
326: x_dispense_required := 'N';
327: FND_MESSAGE.SET_NAME('GMO','GMO_ITEM_NOT_RESERVABLE_ERR');
328: FND_MSG_PUB.ADD;
329: FND_MSG_PUB.COUNT_AND_GET ( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
330:
331: WHEN OTHERS THEN
332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 329: FND_MSG_PUB.COUNT_AND_GET ( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );

325: x_return_status := 'W';
326: x_dispense_required := 'N';
327: FND_MESSAGE.SET_NAME('GMO','GMO_ITEM_NOT_RESERVABLE_ERR');
328: FND_MSG_PUB.ADD;
329: FND_MSG_PUB.COUNT_AND_GET ( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
330:
331: WHEN OTHERS THEN
332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
333: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

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

329: FND_MSG_PUB.COUNT_AND_GET ( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
330:
331: WHEN OTHERS THEN
332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
333: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
334: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
335: END IF;
336: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
337:

Line 334: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );

330:
331: WHEN OTHERS THEN
332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
333: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
334: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
335: END IF;
336: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
337:
338: END IS_DISPENSE_ITEM;

Line 336: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
333: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
334: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
335: END IF;
336: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
337:
338: END IS_DISPENSE_ITEM;
339:
340: PROCEDURE GET_MATERIAL_DISPENSE_DATA (p_api_version IN NUMBER,

Line 358: FND_MSG_PUB.initialize;

354: THEN RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
355: END IF;
356:
357: IF FND_API.to_Boolean( p_init_msg_list ) THEN
358: FND_MSG_PUB.initialize;
359: END IF;
360: -- check if GMO is enabled
361: IF (GMO_SETUP_GRP.IS_GMO_ENABLED = GMO_CONSTANTS_GRP.NO) THEN
362: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 364: FND_MSG_PUB.ADD;

360: -- check if GMO is enabled
361: IF (GMO_SETUP_GRP.IS_GMO_ENABLED = GMO_CONSTANTS_GRP.NO) THEN
362: x_return_status := FND_API.G_RET_STS_SUCCESS;
363: FND_MESSAGE.SET_NAME('GMO','GMO_DISABLED_ERR');
364: FND_MSG_PUB.ADD;
365: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
366: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
367: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_dispense_grp.GET_MATERIAL_DISPENSE_DATA', FALSE);
368: end if;

Line 365: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

361: IF (GMO_SETUP_GRP.IS_GMO_ENABLED = GMO_CONSTANTS_GRP.NO) THEN
362: x_return_status := FND_API.G_RET_STS_SUCCESS;
363: FND_MESSAGE.SET_NAME('GMO','GMO_DISABLED_ERR');
364: FND_MSG_PUB.ADD;
365: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
366: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
367: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_dispense_grp.GET_MATERIAL_DISPENSE_DATA', FALSE);
368: end if;
369: RETURN ;

Line 376: FND_MSG_PUB.Add;

372: GMO_DISPENSE_PVT.GET_MATERIAL_DISPENSE_DATA( p_material_detail_id,
373: x_dispense_data);
374: x_return_status := FND_API.G_RET_STS_SUCCESS;
375:
376: FND_MSG_PUB.Add;
377: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
378: EXCEPTION
379: WHEN FND_API.G_EXC_ERROR THEN
380: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 377: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

373: x_dispense_data);
374: x_return_status := FND_API.G_RET_STS_SUCCESS;
375:
376: FND_MSG_PUB.Add;
377: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
378: EXCEPTION
379: WHEN FND_API.G_EXC_ERROR THEN
380: x_return_status := FND_API.G_RET_STS_ERROR ;
381: FND_MSG_PUB.ADD;

Line 381: FND_MSG_PUB.ADD;

377: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
378: EXCEPTION
379: WHEN FND_API.G_EXC_ERROR THEN
380: x_return_status := FND_API.G_RET_STS_ERROR ;
381: FND_MSG_PUB.ADD;
382: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
383: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
385: FND_MSG_PUB.ADD;

Line 382: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

378: EXCEPTION
379: WHEN FND_API.G_EXC_ERROR THEN
380: x_return_status := FND_API.G_RET_STS_ERROR ;
381: FND_MSG_PUB.ADD;
382: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
383: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
385: FND_MSG_PUB.ADD;
386: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

Line 385: FND_MSG_PUB.ADD;

381: FND_MSG_PUB.ADD;
382: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
383: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
385: FND_MSG_PUB.ADD;
386: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
387: WHEN OTHERS THEN
388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
389: FND_MSG_PUB.ADD;

Line 386: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

382: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
383: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
385: FND_MSG_PUB.ADD;
386: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
387: WHEN OTHERS THEN
388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
389: FND_MSG_PUB.ADD;
390: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

Line 389: FND_MSG_PUB.ADD;

385: FND_MSG_PUB.ADD;
386: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
387: WHEN OTHERS THEN
388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
389: FND_MSG_PUB.ADD;
390: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
391: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
392: END IF;
393: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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

386: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
387: WHEN OTHERS THEN
388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
389: FND_MSG_PUB.ADD;
390: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
391: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
392: END IF;
393: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
394: END GET_MATERIAL_DISPENSE_DATA;

Line 391: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );

387: WHEN OTHERS THEN
388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
389: FND_MSG_PUB.ADD;
390: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
391: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
392: END IF;
393: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
394: END GET_MATERIAL_DISPENSE_DATA;
395:

Line 393: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

389: FND_MSG_PUB.ADD;
390: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
391: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name, l_api_name );
392: END IF;
393: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
394: END GET_MATERIAL_DISPENSE_DATA;
395:
396:
397: --This procedure is used to instantiate the dispense setup identified by the specified

Line 432: FND_MSG_PUB.INITIALIZE;

428:
429: --Initialized the message list if specified so.
430: IF FND_API.TO_BOOLEAN(P_INIT_MSG_LIST) THEN
431:
432: FND_MSG_PUB.INITIALIZE;
433:
434: END IF;
435:
436:

Line 440: FND_MSG_PUB.ADD;

436:
437: IF (GMO_SETUP_GRP.IS_GMO_ENABLED = GMO_CONSTANTS_GRP.NO) THEN
438: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
439: FND_MESSAGE.SET_NAME('GMO','GMO_DISABLED_ERR');
440: FND_MSG_PUB.ADD;
441: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
442: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
443: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_dispense_grp.maintain_reservation', FALSE);
444: END IF;

Line 441: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

437: IF (GMO_SETUP_GRP.IS_GMO_ENABLED = GMO_CONSTANTS_GRP.NO) THEN
438: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
439: FND_MESSAGE.SET_NAME('GMO','GMO_DISABLED_ERR');
440: FND_MSG_PUB.ADD;
441: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
442: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
443: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_dispense_grp.maintain_reservation', FALSE);
444: END IF;
445:

Line 464: FND_MSG_PUB.COUNT_AND_GET

460: X_MSG_DATA => X_MSG_DATA);
461:
462: --Get the message count.
463: --If count is 1, then get the message data.
464: FND_MSG_PUB.COUNT_AND_GET
465: (P_COUNT => X_MSG_COUNT,
466: P_DATA => X_MSG_DATA);
467:
468:

Line 479: IF FND_MSG_PUB.CHECK_MSG_LEVEL( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

475: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
476: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
477: FND_MESSAGE.SET_TOKEN('PKG_NAME','GMO_DISPENSE_GRP');
478: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','INSTANTIATE_DISPENSE_SETUP');
479: IF FND_MSG_PUB.CHECK_MSG_LEVEL( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
480:
481: FND_MSG_PUB.ADD_EXC_MSG (G_PKG_NAME,
482: L_API_NAME );
483:

Line 481: FND_MSG_PUB.ADD_EXC_MSG (G_PKG_NAME,

477: FND_MESSAGE.SET_TOKEN('PKG_NAME','GMO_DISPENSE_GRP');
478: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','INSTANTIATE_DISPENSE_SETUP');
479: IF FND_MSG_PUB.CHECK_MSG_LEVEL( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
480:
481: FND_MSG_PUB.ADD_EXC_MSG (G_PKG_NAME,
482: L_API_NAME );
483:
484: END IF;
485:

Line 486: FND_MSG_PUB.COUNT_AND_GET

482: L_API_NAME );
483:
484: END IF;
485:
486: FND_MSG_PUB.COUNT_AND_GET
487: (P_COUNT => X_MSG_COUNT,
488: P_DATA => X_MSG_DATA);
489:
490: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN