DBA Data[Home] [Help]

APPS.AS_FOUNDATION_PUB dependencies on FND_MSG_PUB

Line 61: FND_MSG_PUB.initialize;

57:
58:
59: -- Initialize message list if p_init_msg_list is set to TRUE.
60: IF FND_API.to_Boolean( p_init_msg_list ) THEN
61: FND_MSG_PUB.initialize;
62: END IF;
63:
64: -- Debug Message
65: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

Line 65: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

61: FND_MSG_PUB.initialize;
62: END IF;
63:
64: -- Debug Message
65: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
66: --THEN
67: --dbms_output.put_line('AS_FOUNDATION_PUB.Get_inventory_items: Start');
68: --END IF;
69:

Line 95: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

91:
92: x_return_status := FND_API.G_RET_STS_SUCCESS;
93:
94: -- Success Message
95: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
96: THEN
97: FND_MESSAGE.Set_Name('AS', 'API_SUCCESS');
98: FND_MESSAGE.Set_Token('ROW', 'AS_Foundation', TRUE);
99: FND_MSG_PUB.Add;

Line 99: FND_MSG_PUB.Add;

95: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
96: THEN
97: FND_MESSAGE.Set_Name('AS', 'API_SUCCESS');
98: FND_MESSAGE.Set_Token('ROW', 'AS_Foundation', TRUE);
99: FND_MSG_PUB.Add;
100: END IF;
101:
102:
103: -- Debug Message

Line 104: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

100: END IF;
101:
102:
103: -- Debug Message
104: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
105: --THEN
106: --dbms_output.put_line('AS_FOUNDATION_PUB.Get_inventory_items: End');
107: --END IF;
108:

Line 110: FND_MSG_PUB.Count_And_Get

106: --dbms_output.put_line('AS_FOUNDATION_PUB.Get_inventory_items: End');
107: --END IF;
108:
109: -- Standard call to get message count and if count is 1, get message info.
110: FND_MSG_PUB.Count_And_Get
111: ( p_count => x_msg_count,
112: p_data => x_msg_data
113: );
114:

Line 122: FND_MSG_PUB.Count_And_Get

118: WHEN FND_API.G_EXC_ERROR THEN
119:
120: x_return_status := FND_API.G_RET_STS_ERROR ;
121:
122: FND_MSG_PUB.Count_And_Get
123: ( p_count => x_msg_count,
124: p_data => x_msg_data
125: );
126:

Line 132: FND_MSG_PUB.Count_And_Get

128: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
129:
130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
131:
132: FND_MSG_PUB.Count_And_Get
133: ( p_count => x_msg_count,
134: p_data => x_msg_data
135: );
136:

Line 143: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

139:
140:
141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
142:
143: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
144: THEN
145: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
146: END IF;
147:

Line 145: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
142:
143: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
144: THEN
145: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
146: END IF;
147:
148: FND_MSG_PUB.Count_And_Get
149: ( p_count => x_msg_count,

Line 148: FND_MSG_PUB.Count_And_Get

144: THEN
145: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
146: END IF;
147:
148: FND_MSG_PUB.Count_And_Get
149: ( p_count => x_msg_count,
150: p_data => x_msg_data
151: );
152:

Line 222: FND_MSG_PUB.initialize;

218: END IF;
219:
220: -- Initialize message list if p_init_msg_list is set to TRUE.
221: IF FND_API.to_Boolean( p_init_msg_list ) THEN
222: FND_MSG_PUB.initialize;
223: END IF;
224:
225: -- Debug Message
226: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

Line 226: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

222: FND_MSG_PUB.initialize;
223: END IF;
224:
225: -- Debug Message
226: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
227: --dbms_output.put_line('AS_Foundation_PUB.Calculate_Amount: Start');
228: --END IF;
229:
230: -- Initialize API return status to success

Line 246: --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

242: x_msg_count => x_msg_count,
243: x_msg_data => x_msg_data,
244: x_inventory_item_tbl => l_inv_item_tbl);
245: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
246: --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
247: --dbms_output.put_line('AS_FOUNDATION_PUB - Item : Not Found');
248: --END IF;
249: raise FND_API.G_EXC_ERROR;
250: END IF;

Line 255: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

251: IF (p_inventory_item_rec.Primary_UOM_Code IS NOT NULL) THEN
252: l_inv_item_tbl(1).Primary_UOM_Code := p_inventory_item_rec.Primary_UOM_Code;
253: END IF;
254: -- Debug Message
255: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
256: --dbms_output.put_line('AS_Foundation_PVT - UOM:' || p_inventory_item_rec.Primary_Uom_Code);
257: --END IF;
258: AS_FOUNDATION_PVT.Get_Price_Info(p_api_version_number => 2.0,
259: p_init_msg_list => FND_API.G_FALSE,

Line 282: -- IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

278: x_price_list_id => l_price_list_id,
279: x_price => l_price);
280: END IF;
281: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
282: -- IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
283: --dbms_output.put_line('AS_FOUNDATION_PUB - Price : Not Found');
284: --END IF;
285: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
286: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');

Line 285: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

281: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
282: -- IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
283: --dbms_output.put_line('AS_FOUNDATION_PUB - Price : Not Found');
284: --END IF;
285: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
286: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
287: FND_MESSAGE.Set_Token('COLUMN','Price', FALSE);
288: FND_MSG_PUB.ADD;
289: END IF;

Line 288: FND_MSG_PUB.ADD;

284: --END IF;
285: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
286: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
287: FND_MESSAGE.Set_Token('COLUMN','Price', FALSE);
288: FND_MSG_PUB.ADD;
289: END IF;
290: raise FND_API.G_EXC_ERROR;
291: END IF;
292: -- Fix bug 858155

Line 298: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

294: l_amount := NULL;
295: ELSE
296: l_amount := p_volume * l_price;
297: END IF;
298: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
299: --dbms_output.put_line('AS_Foundation_PUB - Amount: ' || to_char(l_amount));
300: --END IF;
301: x_amount := l_amount;
302: -- Success Message

Line 303: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN

299: --dbms_output.put_line('AS_Foundation_PUB - Amount: ' || to_char(l_amount));
300: --END IF;
301: x_amount := l_amount;
302: -- Success Message
303: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
304: FND_MESSAGE.Set_Name('AS', 'API_SUCCESS');
305: FND_MESSAGE.Set_Token('ROW', 'AS_Foundation', TRUE);
306: FND_MSG_PUB.Add;
307: END IF;

Line 306: FND_MSG_PUB.Add;

302: -- Success Message
303: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
304: FND_MESSAGE.Set_Name('AS', 'API_SUCCESS');
305: FND_MESSAGE.Set_Token('ROW', 'AS_Foundation', TRUE);
306: FND_MSG_PUB.Add;
307: END IF;
308:
309: -- Debug Message
310: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

Line 310: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

306: FND_MSG_PUB.Add;
307: END IF;
308:
309: -- Debug Message
310: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
311: --dbms_output.put_line('AS_Foundation_PUB.Calculate_Amount: End');
312: --END IF;
313:
314: -- Standard call to get message count and if count is 1, get message info.

Line 315: FND_MSG_PUB.Count_And_Get

311: --dbms_output.put_line('AS_Foundation_PUB.Calculate_Amount: End');
312: --END IF;
313:
314: -- Standard call to get message count and if count is 1, get message info.
315: FND_MSG_PUB.Count_And_Get
316: ( p_count => x_msg_count,
317: p_data => x_msg_data
318: );
319:

Line 323: FND_MSG_PUB.Count_And_Get

319:
320: EXCEPTION
321: WHEN FND_API.G_EXC_ERROR THEN
322: x_return_status := FND_API.G_RET_STS_ERROR ;
323: FND_MSG_PUB.Count_And_Get
324: ( p_count => x_msg_count,
325: p_data => x_msg_data
326: );
327: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 329: FND_MSG_PUB.Count_And_Get

325: p_data => x_msg_data
326: );
327: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
329: FND_MSG_PUB.Count_And_Get
330: ( p_count => x_msg_count,
331: p_data => x_msg_data
332: );
333: WHEN NO_DATA_FOUND THEN

Line 335: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

331: p_data => x_msg_data
332: );
333: WHEN NO_DATA_FOUND THEN
334: x_return_status := FND_API.G_RET_STS_ERROR ;
335: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
336: --THEN
337: --dbms_output.put_line('AS_Foundation_PUB. - Cannot Find Price List Id');
338: --END IF;
339: FND_MSG_PUB.Count_And_Get

Line 339: FND_MSG_PUB.Count_And_Get

335: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
336: --THEN
337: --dbms_output.put_line('AS_Foundation_PUB. - Cannot Find Price List Id');
338: --END IF;
339: FND_MSG_PUB.Count_And_Get
340: ( p_count => x_msg_count,
341: p_data => x_msg_data
342: );
343: WHEN OTHERS THEN

Line 345: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

341: p_data => x_msg_data
342: );
343: WHEN OTHERS THEN
344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
345: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
346: THEN
347: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
348: END IF;
349: FND_MSG_PUB.Count_And_Get

Line 347: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

343: WHEN OTHERS THEN
344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
345: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
346: THEN
347: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
348: END IF;
349: FND_MSG_PUB.Count_And_Get
350: ( p_count => x_msg_count,
351: p_data => x_msg_data

Line 349: FND_MSG_PUB.Count_And_Get

345: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
346: THEN
347: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
348: END IF;
349: FND_MSG_PUB.Count_And_Get
350: ( p_count => x_msg_count,
351: p_data => x_msg_data
352: );
353: END Calculate_Amount;

Line 377: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

373: p_api_version_number,
374: l_api_name,
375: G_PKG_NAME)
376: THEN
377: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
378: THEN
379: FND_MESSAGE.Set_Name('AS', 'API_UNEXP_ERROR_IN_PROCESSING');
380: FND_MESSAGE.Set_Token('ROW', 'AS_ACCESSES', TRUE);
381: FND_MSG_PUB.ADD;

Line 381: FND_MSG_PUB.ADD;

377: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
378: THEN
379: FND_MESSAGE.Set_Name('AS', 'API_UNEXP_ERROR_IN_PROCESSING');
380: FND_MESSAGE.Set_Token('ROW', 'AS_ACCESSES', TRUE);
381: FND_MSG_PUB.ADD;
382: END IF;
383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
384: END IF;
385:

Line 389: FND_MSG_PUB.initialize;

385:
386: -- Initialize message list if p_init_msg_list is set to TRUE.
387: IF FND_API.to_Boolean( p_init_msg_list )
388: THEN
389: FND_MSG_PUB.initialize;
390: END IF;
391:
392: -- Initialize API return status to success
393: --

Line 404: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

400: -- Validate Environment
401:
402: IF FND_GLOBAL.User_Id IS NULL
403: THEN
404: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
405: THEN
406: FND_MESSAGE.Set_Name('AS', 'UT_CANNOT_GET_PROFILE_VALUE');
407: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
408: FND_MSG_PUB.ADD;

Line 408: FND_MSG_PUB.ADD;

404: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
405: THEN
406: FND_MESSAGE.Set_Name('AS', 'UT_CANNOT_GET_PROFILE_VALUE');
407: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
408: FND_MSG_PUB.ADD;
409: END IF;
410: END IF;
411:
412: l_period_rec_in.period_name := p_period_rec.period_name;

Line 433: FND_MSG_PUB.Count_And_Get

429: WHEN FND_API.G_EXC_ERROR THEN
430:
431: x_return_status := FND_API.G_RET_STS_ERROR ;
432:
433: FND_MSG_PUB.Count_And_Get
434: ( p_count => x_msg_count,
435: p_data => x_msg_data
436: );
437:

Line 443: FND_MSG_PUB.Count_And_Get

439: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
440:
441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
442:
443: FND_MSG_PUB.Count_And_Get
444: ( p_count => x_msg_count,
445: p_data => x_msg_data
446: );
447:

Line 454: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

450:
451:
452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
453:
454: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
455: THEN
456: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
457: END IF;
458:

Line 456: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
453:
454: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
455: THEN
456: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
457: END IF;
458:
459: FND_MSG_PUB.Count_And_Get
460: ( p_count => x_msg_count,

Line 459: FND_MSG_PUB.Count_And_Get

455: THEN
456: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
457: END IF;
458:
459: FND_MSG_PUB.Count_And_Get
460: ( p_count => x_msg_count,
461: p_data => x_msg_data
462: );
463: