DBA Data[Home] [Help]

APPS.GMF_RESOURCECOST_PVT dependencies on FND_MSG_PUB

Line 58: G_debug_level NUMBER(2) := FND_MSG_PUB.G_Msg_Level_Threshold; -- Use this variable everywhere

54:
55: -- Global variables
56: G_PKG_NAME CONSTANT VARCHAR2(30) := 'GMF_ResourceCost_PVT';
57:
58: G_debug_level NUMBER(2) := FND_MSG_PUB.G_Msg_Level_Threshold; -- Use this variable everywhere
59: -- to decide to log a debug msg.
60:
61:
62: --Start of comments

Line 119: FND_MSG_PUB.initialize;

115: SAVEPOINT Create_Resource_Cost_PVT;
116:
117: -- Initialize message list if p_init_msg_list is set to TRUE.
118: IF FND_API.to_Boolean( p_init_msg_list ) THEN
119: FND_MSG_PUB.initialize;
120: END IF;
121:
122: -- Standard call to check for call compatibility.
123: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

Line 134: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435

130:
131: -- Initialize API return status to success
132: x_return_status := FND_API.G_RET_STS_SUCCESS;
133:
134: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
135: log_msg('Inserting record for resource : ' || p_resource_cost_rec.resources ||
136: ' Legal Entity Id : ' || p_resource_cost_rec.legal_entity_id ||
137: ' Organization id : ' || p_resource_cost_rec.organization_id ||
138: ' Period Id : ' || p_resource_cost_rec.period_id ||

Line 181: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435

177: , p_resource_cost_rec.usage_uom
178: , p_resource_cost_rec.legal_entity_id
179: );
180:
181: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
182: log_msg('1 row inserted');
183: END IF;
184:
185: -- Standard check of p_commit.

Line 191: FND_MSG_PUB.Count_And_Get

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

Line 200: FND_MSG_PUB.Count_And_Get

196: EXCEPTION
197: WHEN FND_API.G_EXC_ERROR THEN
198: ROLLBACK TO Create_Resource_Cost_PVT;
199: x_return_status := FND_API.G_RET_STS_ERROR ;
200: FND_MSG_PUB.Count_And_Get
201: ( p_count => x_msg_count ,
202: p_data => x_msg_data
203: );
204: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 207: FND_MSG_PUB.Count_And_Get

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

Line 214: IF FND_MSG_PUB.Check_Msg_Level

210: );
211: WHEN OTHERS THEN
212: ROLLBACK TO Create_Resource_Cost_PVT;
213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
214: IF FND_MSG_PUB.Check_Msg_Level
215: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
216: THEN
217: FND_MSG_PUB.Add_Exc_Msg
218: ( G_PKG_NAME ,

Line 215: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

211: WHEN OTHERS THEN
212: ROLLBACK TO Create_Resource_Cost_PVT;
213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
214: IF FND_MSG_PUB.Check_Msg_Level
215: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
216: THEN
217: FND_MSG_PUB.Add_Exc_Msg
218: ( G_PKG_NAME ,
219: l_api_name

Line 217: FND_MSG_PUB.Add_Exc_Msg

213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
214: IF FND_MSG_PUB.Check_Msg_Level
215: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
216: THEN
217: FND_MSG_PUB.Add_Exc_Msg
218: ( G_PKG_NAME ,
219: l_api_name
220: );
221: END IF;

Line 222: FND_MSG_PUB.Count_And_Get

218: ( G_PKG_NAME ,
219: l_api_name
220: );
221: END IF;
222: FND_MSG_PUB.Count_And_Get
223: ( p_count => x_msg_count ,
224: p_data => x_msg_data
225: );
226:

Line 287: FND_MSG_PUB.initialize;

283: SAVEPOINT Update_Resource_Cost_PVT;
284:
285: -- Initialize message list if p_init_msg_list is set to TRUE.
286: IF FND_API.to_Boolean( p_init_msg_list ) THEN
287: FND_MSG_PUB.initialize;
288: END IF;
289:
290: -- Standard call to check for call compatibility.
291: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

Line 302: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435

298:
299: -- Initialize API return status to success
300: x_return_status := FND_API.G_RET_STS_SUCCESS;
301:
302: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
303: log_msg('Updating record for resource : ' || p_resource_cost_rec.resources ||
304: ' Legal Entity Id : ' || p_resource_cost_rec.legal_entity_id ||
305: ' Organization id : ' || p_resource_cost_rec.organization_id ||
306: ' Period Id : ' || p_resource_cost_rec.period_id ||

Line 342: FND_MSG_PUB.Count_And_Get

338: COMMIT WORK;
339: END IF;
340:
341: -- Standard call to get message count and if count is 1, get message info.
342: FND_MSG_PUB.Count_And_Get
343: ( p_count => x_msg_count ,
344: p_data => x_msg_data
345: );
346:

Line 351: FND_MSG_PUB.Count_And_Get

347: EXCEPTION
348: WHEN FND_API.G_EXC_ERROR THEN
349: ROLLBACK TO Update_Resource_Cost_PVT;
350: x_return_status := FND_API.G_RET_STS_ERROR ;
351: FND_MSG_PUB.Count_And_Get
352: ( p_count => x_msg_count ,
353: p_data => x_msg_data
354: );
355: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 358: FND_MSG_PUB.Count_And_Get

354: );
355: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
356: ROLLBACK TO Update_Resource_Cost_PVT;
357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
358: FND_MSG_PUB.Count_And_Get
359: ( p_count => x_msg_count ,
360: p_data => x_msg_data
361: );
362: WHEN OTHERS THEN

Line 365: IF FND_MSG_PUB.Check_Msg_Level

361: );
362: WHEN OTHERS THEN
363: ROLLBACK TO Update_Resource_Cost_PVT;
364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
365: IF FND_MSG_PUB.Check_Msg_Level
366: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
367: THEN
368: FND_MSG_PUB.Add_Exc_Msg
369: ( G_PKG_NAME ,

Line 366: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

362: WHEN OTHERS THEN
363: ROLLBACK TO Update_Resource_Cost_PVT;
364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
365: IF FND_MSG_PUB.Check_Msg_Level
366: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
367: THEN
368: FND_MSG_PUB.Add_Exc_Msg
369: ( G_PKG_NAME ,
370: l_api_name

Line 368: FND_MSG_PUB.Add_Exc_Msg

364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
365: IF FND_MSG_PUB.Check_Msg_Level
366: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
367: THEN
368: FND_MSG_PUB.Add_Exc_Msg
369: ( G_PKG_NAME ,
370: l_api_name
371: );
372: END IF;

Line 373: FND_MSG_PUB.Count_And_Get

369: ( G_PKG_NAME ,
370: l_api_name
371: );
372: END IF;
373: FND_MSG_PUB.Count_And_Get
374: ( p_count => x_msg_count ,
375: p_data => x_msg_data
376: );
377:

Line 435: FND_MSG_PUB.initialize;

431: SAVEPOINT Get_Reousrce_Cost_PVT;
432:
433: -- Initialize message list if p_init_msg_list is set to TRUE.
434: IF FND_API.to_Boolean( p_init_msg_list ) THEN
435: FND_MSG_PUB.initialize;
436: END IF;
437:
438: -- Standard call to check for call compatibility.
439: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

Line 450: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435

446:
447: -- Initialize API return status to success
448: x_return_status := FND_API.G_RET_STS_SUCCESS;
449:
450: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
451: log_msg('Beginning Private Get Resource Cost API.');
452: END IF;
453:
454: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435

Line 454: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435

450: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
451: log_msg('Beginning Private Get Resource Cost API.');
452: END IF;
453:
454: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
455: log_msg('Retrieving Resource Costs for legal entity id : ' || p_resource_cost_rec.legal_entity_id ||
456: ' Organization Id : ' || p_resource_cost_rec.organization_id ||
457: ' Resource : ' || p_resource_cost_rec.resources ||
458: ' Period Id : ' || p_resource_cost_rec.Period_id ||

Line 502: FND_MSG_PUB.Count_And_Get

498: END IF;
499: */
500:
501: -- Standard call to get message count and if count is 1, get message info.
502: FND_MSG_PUB.Count_And_Get
503: ( p_count => x_msg_count ,
504: p_data => x_msg_data
505: );
506:

Line 511: FND_MSG_PUB.Count_And_Get

507: EXCEPTION
508: WHEN FND_API.G_EXC_ERROR THEN
509: ROLLBACK TO Get_Reousrce_Cost_PVT;
510: x_return_status := FND_API.G_RET_STS_ERROR ;
511: FND_MSG_PUB.Count_And_Get
512: ( p_count => x_msg_count ,
513: p_data => x_msg_data
514: );
515: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 518: FND_MSG_PUB.Count_And_Get

514: );
515: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
516: ROLLBACK TO Get_Reousrce_Cost_PVT;
517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
518: FND_MSG_PUB.Count_And_Get
519: ( p_count => x_msg_count ,
520: p_data => x_msg_data
521: );
522: WHEN OTHERS THEN

Line 525: IF FND_MSG_PUB.Check_Msg_Level

521: );
522: WHEN OTHERS THEN
523: ROLLBACK TO Get_Reousrce_Cost_PVT;
524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
525: IF FND_MSG_PUB.Check_Msg_Level
526: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
527: THEN
528: FND_MSG_PUB.Add_Exc_Msg
529: ( G_PKG_NAME ,

Line 526: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

522: WHEN OTHERS THEN
523: ROLLBACK TO Get_Reousrce_Cost_PVT;
524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
525: IF FND_MSG_PUB.Check_Msg_Level
526: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
527: THEN
528: FND_MSG_PUB.Add_Exc_Msg
529: ( G_PKG_NAME ,
530: l_api_name

Line 528: FND_MSG_PUB.Add_Exc_Msg

524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
525: IF FND_MSG_PUB.Check_Msg_Level
526: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
527: THEN
528: FND_MSG_PUB.Add_Exc_Msg
529: ( G_PKG_NAME ,
530: l_api_name
531: );
532: END IF;

Line 533: FND_MSG_PUB.Count_And_Get

529: ( G_PKG_NAME ,
530: l_api_name
531: );
532: END IF;
533: FND_MSG_PUB.Count_And_Get
534: ( p_count => x_msg_count ,
535: p_data => x_msg_data
536: );
537: END Get_Resource_Cost;

Line 566: -- IF FND_MSG_PUB.Check_Msg_Level (p_msg_lvl) THEN -- Bug 2659435

562: )
563: IS
564: BEGIN
565:
566: -- IF FND_MSG_PUB.Check_Msg_Level (p_msg_lvl) THEN -- Bug 2659435
567: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEBUG');
568: FND_MESSAGE.SET_TOKEN('MSG',p_msg_text);
569: FND_MSG_PUB.Add;
570: -- END IF;

Line 569: FND_MSG_PUB.Add;

565:
566: -- IF FND_MSG_PUB.Check_Msg_Level (p_msg_lvl) THEN -- Bug 2659435
567: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEBUG');
568: FND_MESSAGE.SET_TOKEN('MSG',p_msg_text);
569: FND_MSG_PUB.Add;
570: -- END IF;
571:
572: END log_msg ;
573: