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

Line 114: G_tmp BOOLEAN := FND_MSG_PUB.Check_Msg_Level(0) ; -- temp call to initialize the

110: G_PKG_NAME CONSTANT VARCHAR2(30) := 'GMF_ResourceCost_PUB';
111:
112: -- Bug 2659435
113: G_operation VARCHAR2(30); -- values will be Insert, Update or Delete
114: G_tmp BOOLEAN := FND_MSG_PUB.Check_Msg_Level(0) ; -- temp call to initialize the
115: -- msg level threshhold gobal
116: -- variable.
117: G_debug_level NUMBER(2) := FND_MSG_PUB.G_Msg_Level_Threshold; -- Use this variable everywhere
118: -- to decide to log a debug msg.

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

113: G_operation VARCHAR2(30); -- values will be Insert, Update or Delete
114: G_tmp BOOLEAN := FND_MSG_PUB.Check_Msg_Level(0) ; -- temp call to initialize the
115: -- msg level threshhold gobal
116: -- variable.
117: G_debug_level NUMBER(2) := FND_MSG_PUB.G_Msg_Level_Threshold; -- Use this variable everywhere
118: -- to decide to log a debug msg.
119: G_header_logged VARCHAR2(1); -- to indicate whether header is already in
120: -- error stack or not - avoid logging duplicate headers
121:

Line 183: FND_MSG_PUB.initialize;

179: SAVEPOINT Create_Alloc_Definition_PUB;
180:
181: -- Initialize message list if p_init_msg_list is set to TRUE.
182: IF FND_API.to_Boolean( p_init_msg_list ) THEN
183: FND_MSG_PUB.initialize;
184: END IF;
185:
186: -- Standard call to check for call compatibility.
187: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

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

197:
198: G_operation := 'INSERT'; -- Bug 2659435
199: G_header_logged := 'N'; -- to avoid logging duplicate header for errors
200:
201: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
202: log_msg('Validating input parameters');
203: END IF;
204: -- Validate all the input parameters.
205: VALIDATE_INPUT_PARAMS

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

207: ,x_rsrc_cost_rec => l_rsrc_cost_rec
208: ,x_user_id => l_user_id
209: ,x_return_status => l_return_status) ;
210:
211: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
212: log_msg('Return Status after validating : ' || l_return_status);
213: END IF;
214:
215:

Line 239: FND_MSG_PUB.Add;

235: FND_MESSAGE.SET_TOKEN('LEGAL_ENTITY_ID',l_rsrc_cost_rec.legal_entity_id);
236: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',l_rsrc_cost_rec.organization_id);
237: FND_MESSAGE.SET_TOKEN('PERIOD_ID',l_rsrc_cost_rec.period_id);
238: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',l_rsrc_cost_rec.cost_type_id);
239: FND_MSG_PUB.Add;
240: RAISE FND_API.G_EXC_ERROR;
241: END IF;
242:
243: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435

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

239: FND_MSG_PUB.Add;
240: RAISE FND_API.G_EXC_ERROR;
241: END IF;
242:
243: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
244: log_msg('Inserting record for resource : ' || l_rsrc_cost_rec.resources ||
245: ' Legal entity id ' || l_rsrc_cost_rec.legal_entity_id ||
246: ' Organization Id ' || l_rsrc_cost_rec.organization_id ||
247: ' Period Id ' || l_rsrc_cost_rec.Period_id ||

Line 279: FND_MSG_PUB.Add;

275:
276: add_header_to_error_stack(p_resource_cost_rec); -- Bug 2659435
277: FND_MESSAGE.SET_NAME('GMF','GMF_API_ROWS_INS');
278: FND_MESSAGE.SET_TOKEN('NUM_ROWS',l_no_rows_ins);
279: FND_MSG_PUB.Add;
280:
281: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
282: log_msg('1 row inserted');
283: END IF;

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

277: FND_MESSAGE.SET_NAME('GMF','GMF_API_ROWS_INS');
278: FND_MESSAGE.SET_TOKEN('NUM_ROWS',l_no_rows_ins);
279: FND_MSG_PUB.Add;
280:
281: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
282: log_msg('1 row inserted');
283: END IF;
284:
285: -- Standard check of p_commit.

Line 291: FND_MSG_PUB.Count_And_Get

287: COMMIT WORK;
288: END IF;
289:
290: -- Standard call to get message count and if count is 1, get message info.
291: FND_MSG_PUB.Count_And_Get
292: ( p_count => x_msg_count ,
293: p_data => x_msg_data
294: );
295:

Line 300: FND_MSG_PUB.Count_And_Get

296: EXCEPTION
297: WHEN FND_API.G_EXC_ERROR THEN
298: ROLLBACK TO Create_Alloc_Definition_PUB;
299: x_return_status := FND_API.G_RET_STS_ERROR ;
300: FND_MSG_PUB.Count_And_Get
301: ( p_count => x_msg_count ,
302: p_data => x_msg_data
303: );
304: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 307: FND_MSG_PUB.Count_And_Get

303: );
304: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
305: ROLLBACK TO Create_Alloc_Definition_PUB;
306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
307: FND_MSG_PUB.Count_And_Get
308: ( p_count => x_msg_count ,
309: p_data => x_msg_data
310: );
311: WHEN OTHERS THEN

Line 314: IF FND_MSG_PUB.Check_Msg_Level

310: );
311: WHEN OTHERS THEN
312: ROLLBACK TO Create_Alloc_Definition_PUB;
313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
314: IF FND_MSG_PUB.Check_Msg_Level
315: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
316: THEN
317: FND_MSG_PUB.Add_Exc_Msg
318: ( G_PKG_NAME ,

Line 315: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

311: WHEN OTHERS THEN
312: ROLLBACK TO Create_Alloc_Definition_PUB;
313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
314: IF FND_MSG_PUB.Check_Msg_Level
315: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
316: THEN
317: FND_MSG_PUB.Add_Exc_Msg
318: ( G_PKG_NAME ,
319: l_api_name

Line 317: FND_MSG_PUB.Add_Exc_Msg

313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
314: IF FND_MSG_PUB.Check_Msg_Level
315: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
316: THEN
317: FND_MSG_PUB.Add_Exc_Msg
318: ( G_PKG_NAME ,
319: l_api_name
320: );
321: END IF;

Line 322: FND_MSG_PUB.Count_And_Get

318: ( G_PKG_NAME ,
319: l_api_name
320: );
321: END IF;
322: FND_MSG_PUB.Count_And_Get
323: ( p_count => x_msg_count ,
324: p_data => x_msg_data
325: );
326:

Line 389: FND_MSG_PUB.initialize;

385: SAVEPOINT Update_Alloc_Definition_PUB;
386:
387: -- Initialize message list if p_init_msg_list is set to TRUE.
388: IF FND_API.to_Boolean( p_init_msg_list ) THEN
389: FND_MSG_PUB.initialize;
390: END IF;
391:
392: -- Standard call to check for call compatibility.
393: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

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

404: G_operation := 'UPDATE'; -- Bug 2659435
405: G_header_logged := 'N'; -- to avoid logging duplicate header for errors
406:
407: -- Validate all the input parameters.
408: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
409: log_msg('Validating input parameters');
410: END IF;
411:
412: VALIDATE_INPUT_PARAMS

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

414: ,x_rsrc_cost_rec => l_rsrc_cost_rec
415: ,x_user_id => l_user_id
416: ,x_return_status => l_return_status) ;
417:
418: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
419: log_msg('Return Status after validating : ' || l_return_status);
420: END IF;
421:
422: -- Return if validation failures detected

Line 444: FND_MSG_PUB.Add;

440: FND_MESSAGE.SET_TOKEN('LEGAL_ENTITY_ID',l_rsrc_cost_rec.legal_entity_id);
441: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',l_rsrc_cost_rec.organization_id);
442: FND_MESSAGE.SET_TOKEN('PERIOD_ID',l_rsrc_cost_rec.period_id);
443: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',l_rsrc_cost_rec.cost_type_id);
444: FND_MSG_PUB.Add;
445: RAISE FND_API.G_EXC_ERROR;
446: END IF ;
447:
448: IF l_rsrc_cost_rec.delete_mark = 1 THEN

Line 451: FND_MSG_PUB.Add;

447:
448: IF l_rsrc_cost_rec.delete_mark = 1 THEN
449: add_header_to_error_stack(p_resource_cost_rec); -- Bug 2659435
450: FND_MESSAGE.SET_NAME('GMF','GMF_API_CANT_MARK_FOR_PURGE');
451: FND_MSG_PUB.Add;
452: RAISE FND_API.G_EXC_ERROR;
453: END IF ;
454:
455: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435

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

451: FND_MSG_PUB.Add;
452: RAISE FND_API.G_EXC_ERROR;
453: END IF ;
454:
455: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
456: log_msg('Updating record for resource : ' || l_rsrc_cost_rec.resources ||
457: ' Legal entity id ' || l_rsrc_cost_rec.legal_entity_id ||
458: ' Organization Id ' || l_rsrc_cost_rec.organization_id ||
459: ' Period Id ' || l_rsrc_cost_rec.Period_id ||

Line 489: FND_MSG_PUB.Add;

485:
486: add_header_to_error_stack(p_resource_cost_rec); -- Bug 2659435
487: FND_MESSAGE.SET_NAME('GMF','GMF_API_ROWS_UPD');
488: FND_MESSAGE.SET_TOKEN('NUM_ROWS',l_no_rows_upd);
489: FND_MSG_PUB.Add;
490:
491: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
492: log_msg( l_no_rows_upd || ' rows updated.');
493: END IF;

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

487: FND_MESSAGE.SET_NAME('GMF','GMF_API_ROWS_UPD');
488: FND_MESSAGE.SET_TOKEN('NUM_ROWS',l_no_rows_upd);
489: FND_MSG_PUB.Add;
490:
491: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
492: log_msg( l_no_rows_upd || ' rows updated.');
493: END IF;
494:
495: -- Standard check of p_commit.

Line 501: FND_MSG_PUB.Count_And_Get

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

Line 510: FND_MSG_PUB.Count_And_Get

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

Line 517: FND_MSG_PUB.Count_And_Get

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

Line 524: IF FND_MSG_PUB.Check_Msg_Level

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

Line 525: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 527: FND_MSG_PUB.Add_Exc_Msg

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

Line 532: FND_MSG_PUB.Count_And_Get

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

Line 599: FND_MSG_PUB.initialize;

595: SAVEPOINT Delete_Alloc_Definition_PUB;
596:
597: -- Initialize message list if p_init_msg_list is set to TRUE.
598: IF FND_API.to_Boolean( p_init_msg_list ) THEN
599: FND_MSG_PUB.initialize;
600: END IF;
601:
602: -- Standard call to check for call compatibility.
603: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

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

614: G_operation := 'DELETE'; -- Bug 2659435
615: G_header_logged := 'N'; -- to avoid logging duplicate header for errors
616:
617: -- Validate all the input parameters.
618: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
619: log_msg('Validating input parameters');
620: END IF;
621:
622: VALIDATE_INPUT_PARAMS

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

624: ,x_rsrc_cost_rec => l_rsrc_cost_rec
625: ,x_user_id => l_user_id
626: ,x_return_status => l_return_status) ;
627:
628: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
629: log_msg('Return Status after validating : ' || l_return_status);
630: END IF;
631:
632: -- Return if validation failures detected

Line 654: FND_MSG_PUB.Add;

650: FND_MESSAGE.SET_TOKEN('LEGAL_ENTITY_ID',l_rsrc_cost_rec.legal_entity_id);
651: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',l_rsrc_cost_rec.organization_id);
652: FND_MESSAGE.SET_TOKEN('PERIOD_ID',l_rsrc_cost_rec.period_id);
653: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',l_rsrc_cost_rec.cost_type_id);
654: FND_MSG_PUB.Add;
655: RAISE FND_API.G_EXC_ERROR;
656: END IF ;
657:
658: -- set delete mark to 1 irrespective of users input.

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

657:
658: -- set delete mark to 1 irrespective of users input.
659: l_rsrc_cost_rec.delete_mark := 1 ;
660:
661: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
662: log_msg('Deleting record for resource : ' || l_rsrc_cost_rec.resources ||
663: ' Legal entity id ' || l_rsrc_cost_rec.legal_entity_id ||
664: ' Organization Id ' || l_rsrc_cost_rec.organization_id ||
665: ' Period Id ' || l_rsrc_cost_rec.Period_id ||

Line 697: FND_MSG_PUB.Add;

693:
694: add_header_to_error_stack(p_resource_cost_rec); -- Bug 2659435
695: FND_MESSAGE.SET_NAME('GMF','GMF_API_ROWS_DEL');
696: FND_MESSAGE.SET_TOKEN('NUM_ROWS',l_no_rows_del);
697: FND_MSG_PUB.Add;
698:
699: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
700: log_msg(l_no_rows_del || ' row(s) deleted.');
701: END IF;

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

695: FND_MESSAGE.SET_NAME('GMF','GMF_API_ROWS_DEL');
696: FND_MESSAGE.SET_TOKEN('NUM_ROWS',l_no_rows_del);
697: FND_MSG_PUB.Add;
698:
699: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
700: log_msg(l_no_rows_del || ' row(s) deleted.');
701: END IF;
702:
703: -- Standard check of p_commit.

Line 709: FND_MSG_PUB.Count_And_Get

705: COMMIT WORK;
706: END IF;
707:
708: -- Standard call to get message count and if count is 1, get message info.
709: FND_MSG_PUB.Count_And_Get
710: ( p_count => x_msg_count ,
711: p_data => x_msg_data
712: );
713:

Line 718: FND_MSG_PUB.Count_And_Get

714: EXCEPTION
715: WHEN FND_API.G_EXC_ERROR THEN
716: ROLLBACK TO Delete_Alloc_Definition_PUB;
717: x_return_status := FND_API.G_RET_STS_ERROR ;
718: FND_MSG_PUB.Count_And_Get
719: ( p_count => x_msg_count ,
720: p_data => x_msg_data
721: );
722: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 725: FND_MSG_PUB.Count_And_Get

721: );
722: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
723: ROLLBACK TO Delete_Alloc_Definition_PUB;
724: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
725: FND_MSG_PUB.Count_And_Get
726: ( p_count => x_msg_count ,
727: p_data => x_msg_data
728: );
729: WHEN OTHERS THEN

Line 732: IF FND_MSG_PUB.Check_Msg_Level

728: );
729: WHEN OTHERS THEN
730: ROLLBACK TO Delete_Alloc_Definition_PUB;
731: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
732: IF FND_MSG_PUB.Check_Msg_Level
733: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
734: THEN
735: FND_MSG_PUB.Add_Exc_Msg
736: ( G_PKG_NAME ,

Line 733: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

729: WHEN OTHERS THEN
730: ROLLBACK TO Delete_Alloc_Definition_PUB;
731: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
732: IF FND_MSG_PUB.Check_Msg_Level
733: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
734: THEN
735: FND_MSG_PUB.Add_Exc_Msg
736: ( G_PKG_NAME ,
737: l_api_name

Line 735: FND_MSG_PUB.Add_Exc_Msg

731: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
732: IF FND_MSG_PUB.Check_Msg_Level
733: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
734: THEN
735: FND_MSG_PUB.Add_Exc_Msg
736: ( G_PKG_NAME ,
737: l_api_name
738: );
739: END IF;

Line 740: FND_MSG_PUB.Count_And_Get

736: ( G_PKG_NAME ,
737: l_api_name
738: );
739: END IF;
740: FND_MSG_PUB.Count_And_Get
741: ( p_count => x_msg_count ,
742: p_data => x_msg_data
743: );
744:

Line 804: FND_MSG_PUB.initialize;

800: SAVEPOINT Get_Resource_Cost_PUB;
801:
802: -- Initialize message list if p_init_msg_list is set to TRUE.
803: IF FND_API.to_Boolean( p_init_msg_list ) THEN
804: FND_MSG_PUB.initialize;
805: END IF;
806:
807: -- Standard call to check for call compatibility.
808: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

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

815:
816: -- Initialize API return status to success
817: x_return_status := FND_API.G_RET_STS_SUCCESS;
818:
819: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
820: log_msg('Beginning Get Resource Cost process.');
821: END IF;
822:
823: G_header_logged := 'N'; -- to avoid logging duplicate header for errors

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

821: END IF;
822:
823: G_header_logged := 'N'; -- to avoid logging duplicate header for errors
824:
825: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
826: log_msg('Calling private API to fetch records...');
827: END IF;
828:
829: GMF_ResourceCost_PVT.Get_Resource_Cost

Line 857: FND_MSG_PUB.Count_And_Get

853: COMMIT WORK;
854: END IF;
855: */
856: -- Standard call to get message count and if count is 1, get message info.
857: FND_MSG_PUB.Count_And_Get
858: ( p_count => x_msg_count ,
859: p_data => x_msg_data
860: );
861:

Line 866: FND_MSG_PUB.Count_And_Get

862: EXCEPTION
863: WHEN FND_API.G_EXC_ERROR THEN
864: ROLLBACK TO Get_Resource_Cost_PUB;
865: x_return_status := FND_API.G_RET_STS_ERROR ;
866: FND_MSG_PUB.Count_And_Get
867: ( p_count => x_msg_count ,
868: p_data => x_msg_data
869: );
870: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 873: FND_MSG_PUB.Count_And_Get

869: );
870: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
871: ROLLBACK TO Get_Resource_Cost_PUB;
872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
873: FND_MSG_PUB.Count_And_Get
874: ( p_count => x_msg_count ,
875: p_data => x_msg_data
876: );
877: WHEN OTHERS THEN

Line 880: IF FND_MSG_PUB.Check_Msg_Level

876: );
877: WHEN OTHERS THEN
878: ROLLBACK TO Get_Resource_Cost_PUB;
879: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
880: IF FND_MSG_PUB.Check_Msg_Level
881: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
882: THEN
883: FND_MSG_PUB.Add_Exc_Msg
884: ( G_PKG_NAME ,

Line 881: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

877: WHEN OTHERS THEN
878: ROLLBACK TO Get_Resource_Cost_PUB;
879: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
880: IF FND_MSG_PUB.Check_Msg_Level
881: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
882: THEN
883: FND_MSG_PUB.Add_Exc_Msg
884: ( G_PKG_NAME ,
885: l_api_name

Line 883: FND_MSG_PUB.Add_Exc_Msg

879: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
880: IF FND_MSG_PUB.Check_Msg_Level
881: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
882: THEN
883: FND_MSG_PUB.Add_Exc_Msg
884: ( G_PKG_NAME ,
885: l_api_name
886: );
887: END IF;

Line 888: FND_MSG_PUB.Count_And_Get

884: ( G_PKG_NAME ,
885: l_api_name
886: );
887: END IF;
888: FND_MSG_PUB.Count_And_Get
889: ( p_count => x_msg_count ,
890: p_data => x_msg_data
891: );
892:

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

969: l_nominal_cost := p_rsrc_cost_rec.nominal_cost ;
970: l_delete_mark := p_rsrc_cost_rec.delete_mark ;
971: l_user_name := p_rsrc_cost_rec.user_name ;
972:
973: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
974: log_msg( 'resources : ' || l_resources);
975: log_msg( 'legal_entity_id : ' || l_legal_entity_id);
976: log_msg( 'organization_id : ' || l_organization_id);
977: log_msg( 'period_id : ' || l_period_id);

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

987: -------------
988: IF (l_resources <> FND_API.G_MISS_CHAR) AND
989: (l_resources IS NOT NULL) THEN
990: -- validate alloc_id
991: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
992: log_msg('validating resources : '|| l_resources);
993: END IF;
994:
995: --

Line 1003: FND_MSG_PUB.Add;

999: IF NOT (GMF_VALIDATIONS_PVT.Validate_Resources(l_resources)) THEN
1000: add_header_to_error_stack(p_rsrc_cost_rec); -- Bug 2659435
1001: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_RESOURCES');
1002: FND_MESSAGE.SET_TOKEN('RESOURCES',l_resources);
1003: FND_MSG_PUB.Add;
1004: RAISE FND_API.G_EXC_ERROR;
1005: END IF;
1006: -- Get the resource UOM code, resource UOM class for further processing
1007: GMF_VALIDATIONS_PVT.Validate_Resource(l_resources,l_resource_uom,l_resource_uom_class);

Line 1012: FND_MSG_PUB.Add;

1008: IF l_resource_uom IS NULL AND l_resource_uom_class IS NULL THEN
1009: add_header_to_error_stack(p_rsrc_cost_rec); -- Bug 2659435
1010: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_RESOURCES');
1011: FND_MESSAGE.SET_TOKEN('RESOURCES',l_resources);
1012: FND_MSG_PUB.Add;
1013: RAISE FND_API.G_EXC_ERROR;
1014: END IF;
1015: ELSE
1016: add_header_to_error_stack(p_rsrc_cost_rec); -- Bug 2659435

Line 1018: FND_MSG_PUB.Add;

1014: END IF;
1015: ELSE
1016: add_header_to_error_stack(p_rsrc_cost_rec); -- Bug 2659435
1017: FND_MESSAGE.SET_NAME('GMF','GMF_API_RESOURCES_REQ');
1018: FND_MSG_PUB.Add;
1019: RAISE FND_API.G_EXC_ERROR;
1020: END IF;
1021: -- End Resource
1022:

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

1022:
1023: --------------------------
1024: -- Legal entity
1025: --------------------------
1026: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1027: log_msg('validating legal_entity_id : ' || l_legal_entity_id);
1028: END IF;
1029:
1030: IF (l_legal_entity_id <> FND_API.G_MISS_NUM) AND

Line 1036: FND_MSG_PUB.Add;

1032: IF NOT GMF_VALIDATIONS_PVT.Validate_legal_entity_id(l_legal_entity_id) THEN
1033: add_header_to_error_stack(p_rsrc_cost_rec); -- Bug 2659435
1034: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_LE_ID');
1035: FND_MESSAGE.SET_TOKEN('LEGAL_ENTITY',l_legal_entity_id);
1036: FND_MSG_PUB.Add;
1037: RAISE FND_API.G_EXC_ERROR;
1038: END IF;
1039: ELSE
1040: add_header_to_error_stack(p_rsrc_cost_rec); -- Bug 2659435

Line 1042: FND_MSG_PUB.Add;

1038: END IF;
1039: ELSE
1040: add_header_to_error_stack(p_rsrc_cost_rec); -- Bug 2659435
1041: FND_MESSAGE.SET_NAME('GMF','GMF_API_LE_ID_REQ');
1042: FND_MSG_PUB.Add;
1043: RAISE FND_API.G_EXC_ERROR;
1044: END IF;
1045:
1046: -- End legal entity

Line 1053: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_debug_level THEN

1049: -- Organization validation
1050: --------------------------
1051: -- validate organization id
1052: IF ((l_organization_id <> FND_API.G_MISS_NUM) AND (l_organization_id IS NOT NULL)) THEN
1053: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_debug_level THEN
1054: log_msg('Validation Organization ID : '||l_organization_id);
1055: END IF;
1056: -- invoke validate organization id method
1057: IF NOT gmf_validations_pvt.Validate_organization_id(l_organization_id) THEN

Line 1060: FND_MSG_PUB.Add;

1056: -- invoke validate organization id method
1057: IF NOT gmf_validations_pvt.Validate_organization_id(l_organization_id) THEN
1058: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ORGN_ID');
1059: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID', l_organization_id);
1060: FND_MSG_PUB.Add;
1061: RAISE FND_API.G_EXC_ERROR;
1062: END IF;
1063: -- if organization code also passed then log a message to ignore organization code
1064: IF ( l_organization_code <> FND_API.G_MISS_CHAR) AND (l_organization_code IS NOT NULL) THEN

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

1061: RAISE FND_API.G_EXC_ERROR;
1062: END IF;
1063: -- if organization code also passed then log a message to ignore organization code
1064: IF ( l_organization_code <> FND_API.G_MISS_CHAR) AND (l_organization_code IS NOT NULL) THEN
1065: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1066: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_ORGN_CODE');
1067: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE', l_organization_code);
1068: FND_MSG_PUB.Add;
1069: END IF;

Line 1068: FND_MSG_PUB.Add;

1064: IF ( l_organization_code <> FND_API.G_MISS_CHAR) AND (l_organization_code IS NOT NULL) THEN
1065: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1066: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_ORGN_CODE');
1067: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE', l_organization_code);
1068: FND_MSG_PUB.Add;
1069: END IF;
1070: END IF;
1071: -- Organization code passed
1072: ELSIF (l_organization_code <> FND_API.G_MISS_CHAR ) AND (l_organization_code IS NOT NULL ) THEN

Line 1073: IF (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level) THEN

1069: END IF;
1070: END IF;
1071: -- Organization code passed
1072: ELSIF (l_organization_code <> FND_API.G_MISS_CHAR ) AND (l_organization_code IS NOT NULL ) THEN
1073: IF (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level) THEN
1074: log_msg('Validating Organization Code : ' ||l_organization_code);
1075: END IF;
1076: -- get the organization id
1077: l_organization_id := gmf_validations_pvt.validate_organization_code(l_organization_code);

Line 1078: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

1074: log_msg('Validating Organization Code : ' ||l_organization_code);
1075: END IF;
1076: -- get the organization id
1077: l_organization_id := gmf_validations_pvt.validate_organization_code(l_organization_code);
1078: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
1079: log_msg('Organization id : ' || l_organization_id);
1080: END IF;
1081: -- if organization id is null then log message
1082: IF l_organization_id IS NULL THEN

Line 1085: FND_MSG_PUB.Add;

1081: -- if organization id is null then log message
1082: IF l_organization_id IS NULL THEN
1083: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ORGN_CODE');
1084: FND_MESSAGE.SET_TOKEN('ORG_CODE', l_organization_code);
1085: FND_MSG_PUB.Add;
1086: RAISE FND_API.G_EXC_ERROR;
1087: END IF;
1088: -- Either organization id or organization code required
1089: ELSE

Line 1091: FND_MSG_PUB.Add;

1087: END IF;
1088: -- Either organization id or organization code required
1089: ELSE
1090: FND_MESSAGE.SET_NAME('GMF','GMF_API_ORGANIZATION_ID_REQ');
1091: FND_MSG_PUB.Add;
1092: RAISE FND_API.G_EXC_ERROR;
1093: END IF;
1094: -- End of Organization validation
1095:

Line 1100: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

1096: ----------------------------
1097: -- * Cost Type Validation *
1098: ----------------------------
1099: IF (l_cost_type_id <> FND_API.G_MISS_NUM) AND (l_cost_type_id IS NOT NULL) THEN
1100: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
1101: log_msg('Validating Cost Type Id : ' || l_cost_type_id);
1102: END IF;
1103: -- Invoke cost type id validation method
1104: IF NOT gmf_validations_pvt.validate_cost_type_id (l_cost_type_id) THEN

Line 1107: FND_MSG_PUB.Add;

1103: -- Invoke cost type id validation method
1104: IF NOT gmf_validations_pvt.validate_cost_type_id (l_cost_type_id) THEN
1105: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_COST_TYPE_ID');
1106: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID', l_cost_type_id);
1107: FND_MSG_PUB.Add;
1108: RAISE FND_API.G_EXC_ERROR;
1109: END IF;
1110: -- if cost method code is not then log a message
1111: IF (l_cost_type_code <> FND_API.G_MISS_CHAR) AND (l_cost_type_code IS NOT NULL) THEN

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

1108: RAISE FND_API.G_EXC_ERROR;
1109: END IF;
1110: -- if cost method code is not then log a message
1111: IF (l_cost_type_code <> FND_API.G_MISS_CHAR) AND (l_cost_type_code IS NOT NULL) THEN
1112: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1113: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_COST_TYPE');
1114: FND_MESSAGE.SET_TOKEN('COST_TYPE', l_cost_type_code);
1115: FND_MSG_PUB.Add;
1116: END IF;

Line 1115: FND_MSG_PUB.Add;

1111: IF (l_cost_type_code <> FND_API.G_MISS_CHAR) AND (l_cost_type_code IS NOT NULL) THEN
1112: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1113: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_COST_TYPE');
1114: FND_MESSAGE.SET_TOKEN('COST_TYPE', l_cost_type_code);
1115: FND_MSG_PUB.Add;
1116: END IF;
1117: END IF;
1118: ELSIF (l_cost_type_code <> FND_API.G_MISS_CHAR) AND (l_cost_type_code IS NOT NULL) THEN
1119:

Line 1121: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

1117: END IF;
1118: ELSIF (l_cost_type_code <> FND_API.G_MISS_CHAR) AND (l_cost_type_code IS NOT NULL) THEN
1119:
1120: -- Get the cost type id from the method
1121: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
1122: log_msg('Validating Cost Type Code : ' || l_cost_type_code);
1123: END IF;
1124:
1125: l_cost_type_id := GMF_VALIDATIONS_PVT.Validate_cost_type_code(l_cost_type_code);

Line 1126: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

1122: log_msg('Validating Cost Type Code : ' || l_cost_type_code);
1123: END IF;
1124:
1125: l_cost_type_id := GMF_VALIDATIONS_PVT.Validate_cost_type_code(l_cost_type_code);
1126: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
1127: log_msg('Cost Type Id : ' || l_cost_type_id);
1128: END IF;
1129: IF l_cost_type_id IS NULL THEN
1130: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_COST_TYPE');

Line 1132: FND_MSG_PUB.Add;

1128: END IF;
1129: IF l_cost_type_id IS NULL THEN
1130: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_COST_TYPE');
1131: FND_MESSAGE.SET_TOKEN('COST_TYPE',l_cost_type_code);
1132: FND_MSG_PUB.Add;
1133: RAISE FND_API.G_EXC_ERROR;
1134: END IF;
1135: ELSE
1136: FND_MESSAGE.SET_NAME('GMF','GMF_API_COST_TYPE_ID_REQ');

Line 1137: FND_MSG_PUB.Add;

1133: RAISE FND_API.G_EXC_ERROR;
1134: END IF;
1135: ELSE
1136: FND_MESSAGE.SET_NAME('GMF','GMF_API_COST_TYPE_ID_REQ');
1137: FND_MSG_PUB.Add;
1138: RAISE FND_API.G_EXC_ERROR;
1139: END IF;
1140: -- End Cost Method
1141: --

Line 1147: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

1143: --------------------------
1144: -- * Period Validation *
1145: --------------------------
1146: IF (l_period_id <> FND_API.G_MISS_NUM) AND (l_period_id IS NOT NULL) THEN
1147: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
1148: log_msg('Validating Period Id : ' || l_period_id);
1149: END IF;
1150: -- Invoke validate period id method
1151: IF NOT gmf_validations_pvt.validate_period_id(l_period_id) THEN

Line 1154: FND_MSG_PUB.Add;

1150: -- Invoke validate period id method
1151: IF NOT gmf_validations_pvt.validate_period_id(l_period_id) THEN
1152: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_PERIOD_ID');
1153: FND_MESSAGE.SET_TOKEN('PERIOD_ID', l_period_id);
1154: FND_MSG_PUB.Add;
1155: RAISE FND_API.G_EXC_ERROR;
1156: END IF;
1157: -- If period code also passed then ignore period code
1158: IF ((l_calendar_code <> FND_API.G_MISS_CHAR) AND (l_calendar_code IS NOT NULL))

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

1156: END IF;
1157: -- If period code also passed then ignore period code
1158: IF ((l_calendar_code <> FND_API.G_MISS_CHAR) AND (l_calendar_code IS NOT NULL))
1159: AND ((l_period_code <> FND_API.G_MISS_CHAR) AND (l_period_code IS NOT NULL)) THEN
1160: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1161: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_PERIOD_CODE');
1162: FND_MESSAGE.SET_TOKEN('CALENDAR_CODE', l_calendar_code);
1163: FND_MESSAGE.SET_TOKEN('PERIOD_CODE', l_period_code);
1164: FND_MSG_PUB.Add;

Line 1164: FND_MSG_PUB.Add;

1160: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1161: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_PERIOD_CODE');
1162: FND_MESSAGE.SET_TOKEN('CALENDAR_CODE', l_calendar_code);
1163: FND_MESSAGE.SET_TOKEN('PERIOD_CODE', l_period_code);
1164: FND_MSG_PUB.Add;
1165: END IF;
1166: END IF;
1167: ELSIF (l_calendar_code <> FND_API.G_MISS_CHAR) AND (l_calendar_code IS NOT NULL)
1168: AND ((l_period_code <> FND_API.G_MISS_CHAR) AND (l_period_code IS NOT NULL)) THEN

Line 1171: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

1167: ELSIF (l_calendar_code <> FND_API.G_MISS_CHAR) AND (l_calendar_code IS NOT NULL)
1168: AND ((l_period_code <> FND_API.G_MISS_CHAR) AND (l_period_code IS NOT NULL)) THEN
1169:
1170: -- Get the period id passing period code to the validate period id method
1171: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
1172: log_msg('Validating Calendar Code : ' || l_calendar_code||', Period Code : '||l_period_code);
1173: END IF;
1174:
1175: l_period_id := GMF_VALIDATIONS_PVT.Validate_period_code(l_organization_id, l_calendar_code, l_period_code, l_cost_type_id);

Line 1176: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

1172: log_msg('Validating Calendar Code : ' || l_calendar_code||', Period Code : '||l_period_code);
1173: END IF;
1174:
1175: l_period_id := GMF_VALIDATIONS_PVT.Validate_period_code(l_organization_id, l_calendar_code, l_period_code, l_cost_type_id);
1176: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
1177: log_msg('Period Id : ' || l_period_id);
1178: END IF;
1179: -- if period id null then log message with invalid period code
1180: IF l_period_id IS NULL THEN

Line 1184: FND_MSG_PUB.Add;

1180: IF l_period_id IS NULL THEN
1181: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_CLDR_PERIOD');
1182: FND_MESSAGE.SET_TOKEN('CALENDAR_CODE',l_calendar_code);
1183: FND_MESSAGE.SET_TOKEN('PERIOD_CODE',l_period_code);
1184: FND_MSG_PUB.Add;
1185: RAISE FND_API.G_EXC_ERROR;
1186: END IF;
1187: ELSE
1188: FND_MESSAGE.SET_NAME('GMF','GMF_API_PERIOD_ID_REQ');

Line 1189: FND_MSG_PUB.Add;

1185: RAISE FND_API.G_EXC_ERROR;
1186: END IF;
1187: ELSE
1188: FND_MESSAGE.SET_NAME('GMF','GMF_API_PERIOD_ID_REQ');
1189: FND_MSG_PUB.Add;
1190: RAISE FND_API.G_EXC_ERROR;
1191: END IF;
1192:
1193: -- End Period Validation

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

1201:
1202: --
1203: -- Usage Unit of Measure
1204: --
1205: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1206: log_msg('validating usage_uom : ' || l_usage_uom);
1207: END IF;
1208:
1209: IF (l_usage_uom <> FND_API.G_MISS_CHAR) AND

Line 1222: FND_MSG_PUB.Add;

1218: IF l_usage_uom_class IS NULL THEN
1219: add_header_to_error_stack(p_rsrc_cost_rec); -- Bug 2659435
1220: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_USAGE_UM');
1221: FND_MESSAGE.SET_TOKEN('USAGE_UM',l_usage_uom);
1222: FND_MSG_PUB.Add;
1223: RAISE FND_API.G_EXC_ERROR;
1224: END IF;
1225:
1226: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435

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

1222: FND_MSG_PUB.Add;
1223: RAISE FND_API.G_EXC_ERROR;
1224: END IF;
1225:
1226: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1227: log_msg('Usage UOM Class : ' || l_usage_uom_class ||
1228: ' resource UOM Class : ' || l_resource_uom_class);
1229: END IF;
1230:

Line 1237: FND_MSG_PUB.Add;

1233: add_header_to_error_stack(p_rsrc_cost_rec);
1234: FND_MESSAGE.SET_NAME('GMF','GMF_API_USAGE_UOM_SAMETYPE_REQ');
1235: FND_MESSAGE.SET_TOKEN('USAGE_UM',l_usage_uom);
1236: FND_MESSAGE.SET_TOKEN('RESOURCE_UM',l_resource_uom);
1237: FND_MSG_PUB.Add;
1238: RAISE FND_API.G_EXC_ERROR;
1239: END IF;
1240: -- End of bug 2692459
1241:

Line 1247: FND_MSG_PUB.Add;

1243: G_operation = 'UPDATE') OR
1244: (G_operation = 'INSERT') THEN
1245: add_header_to_error_stack(p_rsrc_cost_rec); -- Bug 2659435
1246: FND_MESSAGE.SET_NAME('GMF','GMF_API_USAGE_UM_REQ');
1247: FND_MSG_PUB.Add;
1248: RAISE FND_API.G_EXC_ERROR;
1249: END IF;
1250: -- End Usage Unit of Measure
1251:

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

1254: -- Nominal Cost should be > 0
1255: -- In the form the format mask for this is : 999999999D999999999(999,999,999.999999999)
1256: -- To put that check here, the cost should not be >= 1,000,000,000
1257: --
1258: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1259: log_msg('Validating Nominal Cost : '||l_nominal_cost);
1260: END IF;
1261:
1262: /*************************************************************************

Line 1271: FND_MSG_PUB.Add;

1267: IF ((nvl(l_nominal_cost,0) <= 0) OR (nvl(l_nominal_cost,0) >= 1000000000)) THEN
1268: add_header_to_error_stack(p_rsrc_cost_rec); -- Bug 2659435
1269: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_NOMINAL_COST');
1270: FND_MESSAGE.SET_TOKEN('NOMINAL_COST',l_nominal_cost);
1271: FND_MSG_PUB.Add;
1272: RAISE FND_API.G_EXC_ERROR;
1273: END IF;
1274: ELSIF (l_nominal_cost = FND_API.G_MISS_NUM AND
1275: */

Line 1281: FND_MSG_PUB.Add;

1277: ((G_operation = 'UPDATE') OR
1278: (G_operation = 'INSERT')) THEN
1279: add_header_to_error_stack(p_rsrc_cost_rec); -- Bug 2659435
1280: FND_MESSAGE.SET_NAME('GMF','GMF_API_NOMINAL_COST_REQ');
1281: FND_MSG_PUB.Add;
1282: RAISE FND_API.G_EXC_ERROR;
1283: END IF;
1284: -- End Nominal Cost
1285:

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

1285:
1286: --
1287: -- Delete Mark
1288: --
1289: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1290: log_msg('Validating delete_mark : ' || l_delete_mark);
1291: END IF;
1292:
1293: IF (l_delete_mark <> FND_API.G_MISS_NUM) AND

Line 1299: FND_MSG_PUB.Add;

1295: IF l_delete_mark NOT IN (0,1) THEN
1296: add_header_to_error_stack(p_rsrc_cost_rec); -- Bug 2659435
1297: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_DELETE_MARK');
1298: FND_MESSAGE.SET_TOKEN('DELETE_MARK',l_delete_mark);
1299: FND_MSG_PUB.Add;
1300: RAISE FND_API.G_EXC_ERROR;
1301: END IF;
1302: ELSIF (l_delete_mark = FND_API.G_MISS_NUM AND
1303: G_operation = 'UPDATE') OR

Line 1307: FND_MSG_PUB.Add;

1303: G_operation = 'UPDATE') OR
1304: (G_operation = 'INSERT') THEN
1305: add_header_to_error_stack(p_rsrc_cost_rec); -- Bug 2659435
1306: FND_MESSAGE.SET_NAME('GMF','GMF_API_DELETE_MARK_REQ');
1307: FND_MSG_PUB.Add;
1308: RAISE FND_API.G_EXC_ERROR;
1309: END IF;
1310:
1311: -- Bug 2692459

Line 1315: FND_MSG_PUB.Add;

1311: -- Bug 2692459
1312: IF ((G_operation = 'UPDATE') AND (l_delete_mark = 1)) THEN
1313: add_header_to_error_stack(p_rsrc_cost_rec);
1314: FND_MESSAGE.SET_NAME('GMF','GMF_API_CANT_MARK_FOR_PURGE');
1315: FND_MSG_PUB.Add;
1316: RAISE FND_API.G_EXC_ERROR;
1317: END IF;
1318: -- End Delete Mark
1319:

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

1319:
1320: END IF; -- Bug 2692459: G_operation <> 'DELETE'
1321:
1322: -- Populate WHO columns
1323: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1324: log_msg('Validating user name : ' || l_user_name);
1325: END IF;
1326:
1327: IF (l_user_name <> FND_API.G_MISS_CHAR) AND

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

1329: GMA_GLOBAL_GRP.Get_who( p_user_name => l_user_name
1330: , x_user_id => l_user_id
1331: );
1332:
1333: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1334: log_msg('user id : ' || l_user_id);
1335: END IF;
1336:
1337: IF l_user_id = -1 THEN -- Bug 2681243: GMA changed return status value to -1.

Line 1341: FND_MSG_PUB.Add;

1337: IF l_user_id = -1 THEN -- Bug 2681243: GMA changed return status value to -1.
1338: add_header_to_error_stack(p_rsrc_cost_rec); -- Bug 2659435
1339: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_USER_NAME');
1340: FND_MESSAGE.SET_TOKEN('USER_NAME',l_user_name);
1341: FND_MSG_PUB.Add;
1342: RAISE FND_API.G_EXC_ERROR;
1343: END IF;
1344:
1345: ELSE

Line 1348: FND_MSG_PUB.Add;

1344:
1345: ELSE
1346: add_header_to_error_stack(p_rsrc_cost_rec); -- Bug 2659435
1347: FND_MESSAGE.SET_NAME('GMF','GMF_API_USER_NAME_REQ');
1348: FND_MSG_PUB.Add;
1349: RAISE FND_API.G_EXC_ERROR;
1350: END IF;
1351: -- End User Name
1352:

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

1474: )
1475: IS
1476: BEGIN
1477:
1478: -- IF FND_MSG_PUB.Check_Msg_Level (p_msg_lvl) THEN Bug 2659435
1479: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEBUG');
1480: FND_MESSAGE.SET_TOKEN('MSG',p_msg_text);
1481: FND_MSG_PUB.Add;
1482: -- END IF; Bug 2659435

Line 1481: FND_MSG_PUB.Add;

1477:
1478: -- IF FND_MSG_PUB.Check_Msg_Level (p_msg_lvl) THEN Bug 2659435
1479: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEBUG');
1480: FND_MESSAGE.SET_TOKEN('MSG',p_msg_text);
1481: FND_MSG_PUB.Add;
1482: -- END IF; Bug 2659435
1483:
1484: END log_msg ;
1485:

Line 1521: FND_MSG_PUB.Add;

1517: FND_MESSAGE.SET_TOKEN('LEGAL_ENTITY_ID',p_header.legal_entity_id);
1518: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_header.organization_id);
1519: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header.period_id);
1520: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',p_header.cost_type_id);
1521: FND_MSG_PUB.Add;
1522: END IF;
1523:
1524: END add_header_to_error_stack;
1525: