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 121: G_tmp BOOLEAN := FND_MSG_PUB.Check_Msg_Level(0) ; -- temp call to initialize the

117: G_PKG_NAME CONSTANT VARCHAR2(30) := 'GMF_ResourceCost_PUB';
118:
119: -- Bug 2659435
120: G_operation VARCHAR2(30); -- values will be Insert, Update or Delete
121: G_tmp BOOLEAN := FND_MSG_PUB.Check_Msg_Level(0) ; -- temp call to initialize the
122: -- msg level threshhold gobal
123: -- variable.
124: G_debug_level NUMBER(2) := FND_MSG_PUB.G_Msg_Level_Threshold; -- Use this variable everywhere
125: -- to decide to log a debug msg.

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

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

Line 190: FND_MSG_PUB.initialize;

186: SAVEPOINT Create_Alloc_Definition_PUB;
187:
188: -- Initialize message list if p_init_msg_list is set to TRUE.
189: IF FND_API.to_Boolean( p_init_msg_list ) THEN
190: FND_MSG_PUB.initialize;
191: END IF;
192:
193: -- Standard call to check for call compatibility.
194: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

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

204:
205: G_operation := 'INSERT'; -- Bug 2659435
206: G_header_logged := 'N'; -- to avoid logging duplicate header for errors
207:
208: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
209: log_msg('Validating input parameters');
210: END IF;
211: -- Validate all the input parameters.
212: VALIDATE_INPUT_PARAMS

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

214: ,x_rsrc_cost_rec => l_rsrc_cost_rec
215: ,x_user_id => l_user_id
216: ,x_return_status => l_return_status) ;
217:
218: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
219: log_msg('Return Status after validating : ' || l_return_status);
220: END IF;
221:
222:

Line 247: FND_MSG_PUB.Add;

243: FND_MESSAGE.SET_TOKEN('LEGAL_ENTITY_ID',l_rsrc_cost_rec.legal_entity_id);
244: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',l_rsrc_cost_rec.organization_id);
245: FND_MESSAGE.SET_TOKEN('PERIOD_ID',l_rsrc_cost_rec.period_id);
246: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',l_rsrc_cost_rec.cost_type_id);
247: FND_MSG_PUB.Add;
248: RAISE FND_API.G_EXC_ERROR;
249: END IF;
250:
251: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435

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

247: FND_MSG_PUB.Add;
248: RAISE FND_API.G_EXC_ERROR;
249: END IF;
250:
251: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
252: log_msg('Inserting record for resource : ' || l_rsrc_cost_rec.resources ||
253: ' Legal entity id ' || l_rsrc_cost_rec.legal_entity_id ||
254: ' Organization Id ' || l_rsrc_cost_rec.organization_id ||
255: ' Period Id ' || l_rsrc_cost_rec.Period_id ||

Line 287: FND_MSG_PUB.Add;

283:
284: add_header_to_error_stack(p_resource_cost_rec); -- Bug 2659435
285: FND_MESSAGE.SET_NAME('GMF','GMF_API_ROWS_INS');
286: FND_MESSAGE.SET_TOKEN('NUM_ROWS',l_no_rows_ins);
287: FND_MSG_PUB.Add;
288:
289: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
290: log_msg('1 row inserted');
291: END IF;

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

285: FND_MESSAGE.SET_NAME('GMF','GMF_API_ROWS_INS');
286: FND_MESSAGE.SET_TOKEN('NUM_ROWS',l_no_rows_ins);
287: FND_MSG_PUB.Add;
288:
289: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
290: log_msg('1 row inserted');
291: END IF;
292:
293: -- Standard check of p_commit.

Line 299: FND_MSG_PUB.Count_And_Get

295: COMMIT WORK;
296: END IF;
297:
298: -- Standard call to get message count and if count is 1, get message info.
299: FND_MSG_PUB.Count_And_Get
300: ( p_count => x_msg_count ,
301: p_data => x_msg_data
302: );
303:

Line 308: FND_MSG_PUB.Count_And_Get

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

Line 315: FND_MSG_PUB.Count_And_Get

311: );
312: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
313: ROLLBACK TO Create_Alloc_Definition_PUB;
314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
315: FND_MSG_PUB.Count_And_Get
316: ( p_count => x_msg_count ,
317: p_data => x_msg_data
318: );
319: WHEN OTHERS THEN

Line 322: IF FND_MSG_PUB.Check_Msg_Level

318: );
319: WHEN OTHERS THEN
320: ROLLBACK TO Create_Alloc_Definition_PUB;
321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
322: IF FND_MSG_PUB.Check_Msg_Level
323: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
324: THEN
325: FND_MSG_PUB.Add_Exc_Msg
326: ( G_PKG_NAME ,

Line 323: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

319: WHEN OTHERS THEN
320: ROLLBACK TO Create_Alloc_Definition_PUB;
321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
322: IF FND_MSG_PUB.Check_Msg_Level
323: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
324: THEN
325: FND_MSG_PUB.Add_Exc_Msg
326: ( G_PKG_NAME ,
327: l_api_name

Line 325: FND_MSG_PUB.Add_Exc_Msg

321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
322: IF FND_MSG_PUB.Check_Msg_Level
323: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
324: THEN
325: FND_MSG_PUB.Add_Exc_Msg
326: ( G_PKG_NAME ,
327: l_api_name
328: );
329: END IF;

Line 330: FND_MSG_PUB.Count_And_Get

326: ( G_PKG_NAME ,
327: l_api_name
328: );
329: END IF;
330: FND_MSG_PUB.Count_And_Get
331: ( p_count => x_msg_count ,
332: p_data => x_msg_data
333: );
334:

Line 397: FND_MSG_PUB.initialize;

393: SAVEPOINT Update_Alloc_Definition_PUB;
394:
395: -- Initialize message list if p_init_msg_list is set to TRUE.
396: IF FND_API.to_Boolean( p_init_msg_list ) THEN
397: FND_MSG_PUB.initialize;
398: END IF;
399:
400: -- Standard call to check for call compatibility.
401: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

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

412: G_operation := 'UPDATE'; -- Bug 2659435
413: G_header_logged := 'N'; -- to avoid logging duplicate header for errors
414:
415: -- Validate all the input parameters.
416: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
417: log_msg('Validating input parameters');
418: END IF;
419:
420: VALIDATE_INPUT_PARAMS

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

422: ,x_rsrc_cost_rec => l_rsrc_cost_rec
423: ,x_user_id => l_user_id
424: ,x_return_status => l_return_status) ;
425:
426: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
427: log_msg('Return Status after validating : ' || l_return_status);
428: END IF;
429:
430: -- Return if validation failures detected

Line 452: FND_MSG_PUB.Add;

448: FND_MESSAGE.SET_TOKEN('LEGAL_ENTITY_ID',l_rsrc_cost_rec.legal_entity_id);
449: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',l_rsrc_cost_rec.organization_id);
450: FND_MESSAGE.SET_TOKEN('PERIOD_ID',l_rsrc_cost_rec.period_id);
451: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',l_rsrc_cost_rec.cost_type_id);
452: FND_MSG_PUB.Add;
453: RAISE FND_API.G_EXC_ERROR;
454: END IF ;
455:
456: IF l_rsrc_cost_rec.delete_mark = 1 THEN

Line 459: FND_MSG_PUB.Add;

455:
456: IF l_rsrc_cost_rec.delete_mark = 1 THEN
457: add_header_to_error_stack(p_resource_cost_rec); -- Bug 2659435
458: FND_MESSAGE.SET_NAME('GMF','GMF_API_CANT_MARK_FOR_PURGE');
459: FND_MSG_PUB.Add;
460: RAISE FND_API.G_EXC_ERROR;
461: END IF ;
462:
463: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435

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

459: FND_MSG_PUB.Add;
460: RAISE FND_API.G_EXC_ERROR;
461: END IF ;
462:
463: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
464: log_msg('Updating record for resource : ' || l_rsrc_cost_rec.resources ||
465: ' Legal entity id ' || l_rsrc_cost_rec.legal_entity_id ||
466: ' Organization Id ' || l_rsrc_cost_rec.organization_id ||
467: ' Period Id ' || l_rsrc_cost_rec.Period_id ||

Line 497: FND_MSG_PUB.Add;

493:
494: add_header_to_error_stack(p_resource_cost_rec); -- Bug 2659435
495: FND_MESSAGE.SET_NAME('GMF','GMF_API_ROWS_UPD');
496: FND_MESSAGE.SET_TOKEN('NUM_ROWS',l_no_rows_upd);
497: FND_MSG_PUB.Add;
498:
499: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
500: log_msg( l_no_rows_upd || ' rows updated.');
501: END IF;

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

495: FND_MESSAGE.SET_NAME('GMF','GMF_API_ROWS_UPD');
496: FND_MESSAGE.SET_TOKEN('NUM_ROWS',l_no_rows_upd);
497: FND_MSG_PUB.Add;
498:
499: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
500: log_msg( l_no_rows_upd || ' rows updated.');
501: END IF;
502:
503: -- Standard check of p_commit.

Line 509: FND_MSG_PUB.Count_And_Get

505: COMMIT WORK;
506: END IF;
507:
508: -- Standard call to get message count and if count is 1, get message info.
509: FND_MSG_PUB.Count_And_Get
510: ( p_count => x_msg_count ,
511: p_data => x_msg_data
512: );
513:

Line 518: FND_MSG_PUB.Count_And_Get

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

Line 525: FND_MSG_PUB.Count_And_Get

521: );
522: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
523: ROLLBACK TO Update_Alloc_Definition_PUB;
524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
525: FND_MSG_PUB.Count_And_Get
526: ( p_count => x_msg_count ,
527: p_data => x_msg_data
528: );
529: WHEN OTHERS THEN

Line 532: IF FND_MSG_PUB.Check_Msg_Level

528: );
529: WHEN OTHERS THEN
530: ROLLBACK TO Update_Alloc_Definition_PUB;
531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
532: IF FND_MSG_PUB.Check_Msg_Level
533: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
534: THEN
535: FND_MSG_PUB.Add_Exc_Msg
536: ( G_PKG_NAME ,

Line 533: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

529: WHEN OTHERS THEN
530: ROLLBACK TO Update_Alloc_Definition_PUB;
531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
532: IF FND_MSG_PUB.Check_Msg_Level
533: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
534: THEN
535: FND_MSG_PUB.Add_Exc_Msg
536: ( G_PKG_NAME ,
537: l_api_name

Line 535: FND_MSG_PUB.Add_Exc_Msg

531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
532: IF FND_MSG_PUB.Check_Msg_Level
533: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
534: THEN
535: FND_MSG_PUB.Add_Exc_Msg
536: ( G_PKG_NAME ,
537: l_api_name
538: );
539: END IF;

Line 540: FND_MSG_PUB.Count_And_Get

536: ( G_PKG_NAME ,
537: l_api_name
538: );
539: END IF;
540: FND_MSG_PUB.Count_And_Get
541: ( p_count => x_msg_count ,
542: p_data => x_msg_data
543: );
544:

Line 607: FND_MSG_PUB.initialize;

603: SAVEPOINT Delete_Alloc_Definition_PUB;
604:
605: -- Initialize message list if p_init_msg_list is set to TRUE.
606: IF FND_API.to_Boolean( p_init_msg_list ) THEN
607: FND_MSG_PUB.initialize;
608: END IF;
609:
610: -- Standard call to check for call compatibility.
611: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

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

622: G_operation := 'DELETE'; -- Bug 2659435
623: G_header_logged := 'N'; -- to avoid logging duplicate header for errors
624:
625: -- Validate all the input parameters.
626: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
627: log_msg('Validating input parameters');
628: END IF;
629:
630: VALIDATE_INPUT_PARAMS

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

632: ,x_rsrc_cost_rec => l_rsrc_cost_rec
633: ,x_user_id => l_user_id
634: ,x_return_status => l_return_status) ;
635:
636: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
637: log_msg('Return Status after validating : ' || l_return_status);
638: END IF;
639:
640: -- Return if validation failures detected

Line 662: FND_MSG_PUB.Add;

658: FND_MESSAGE.SET_TOKEN('LEGAL_ENTITY_ID',l_rsrc_cost_rec.legal_entity_id);
659: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',l_rsrc_cost_rec.organization_id);
660: FND_MESSAGE.SET_TOKEN('PERIOD_ID',l_rsrc_cost_rec.period_id);
661: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',l_rsrc_cost_rec.cost_type_id);
662: FND_MSG_PUB.Add;
663: RAISE FND_API.G_EXC_ERROR;
664: END IF ;
665:
666: -- set delete mark to 1 irrespective of users input.

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

665:
666: -- set delete mark to 1 irrespective of users input.
667: l_rsrc_cost_rec.delete_mark := 1 ;
668:
669: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
670: log_msg('Deleting record for resource : ' || l_rsrc_cost_rec.resources ||
671: ' Legal entity id ' || l_rsrc_cost_rec.legal_entity_id ||
672: ' Organization Id ' || l_rsrc_cost_rec.organization_id ||
673: ' Period Id ' || l_rsrc_cost_rec.Period_id ||

Line 705: FND_MSG_PUB.Add;

701:
702: add_header_to_error_stack(p_resource_cost_rec); -- Bug 2659435
703: FND_MESSAGE.SET_NAME('GMF','GMF_API_ROWS_DEL');
704: FND_MESSAGE.SET_TOKEN('NUM_ROWS',l_no_rows_del);
705: FND_MSG_PUB.Add;
706:
707: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
708: log_msg(l_no_rows_del || ' row(s) deleted.');
709: END IF;

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

703: FND_MESSAGE.SET_NAME('GMF','GMF_API_ROWS_DEL');
704: FND_MESSAGE.SET_TOKEN('NUM_ROWS',l_no_rows_del);
705: FND_MSG_PUB.Add;
706:
707: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
708: log_msg(l_no_rows_del || ' row(s) deleted.');
709: END IF;
710:
711: -- Standard check of p_commit.

Line 717: FND_MSG_PUB.Count_And_Get

713: COMMIT WORK;
714: END IF;
715:
716: -- Standard call to get message count and if count is 1, get message info.
717: FND_MSG_PUB.Count_And_Get
718: ( p_count => x_msg_count ,
719: p_data => x_msg_data
720: );
721:

Line 726: FND_MSG_PUB.Count_And_Get

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

Line 733: FND_MSG_PUB.Count_And_Get

729: );
730: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
731: ROLLBACK TO Delete_Alloc_Definition_PUB;
732: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
733: FND_MSG_PUB.Count_And_Get
734: ( p_count => x_msg_count ,
735: p_data => x_msg_data
736: );
737: WHEN OTHERS THEN

Line 740: IF FND_MSG_PUB.Check_Msg_Level

736: );
737: WHEN OTHERS THEN
738: ROLLBACK TO Delete_Alloc_Definition_PUB;
739: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
740: IF FND_MSG_PUB.Check_Msg_Level
741: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
742: THEN
743: FND_MSG_PUB.Add_Exc_Msg
744: ( G_PKG_NAME ,

Line 741: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

737: WHEN OTHERS THEN
738: ROLLBACK TO Delete_Alloc_Definition_PUB;
739: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
740: IF FND_MSG_PUB.Check_Msg_Level
741: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
742: THEN
743: FND_MSG_PUB.Add_Exc_Msg
744: ( G_PKG_NAME ,
745: l_api_name

Line 743: FND_MSG_PUB.Add_Exc_Msg

739: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
740: IF FND_MSG_PUB.Check_Msg_Level
741: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
742: THEN
743: FND_MSG_PUB.Add_Exc_Msg
744: ( G_PKG_NAME ,
745: l_api_name
746: );
747: END IF;

Line 748: FND_MSG_PUB.Count_And_Get

744: ( G_PKG_NAME ,
745: l_api_name
746: );
747: END IF;
748: FND_MSG_PUB.Count_And_Get
749: ( p_count => x_msg_count ,
750: p_data => x_msg_data
751: );
752:

Line 812: FND_MSG_PUB.initialize;

808: SAVEPOINT Get_Resource_Cost_PUB;
809:
810: -- Initialize message list if p_init_msg_list is set to TRUE.
811: IF FND_API.to_Boolean( p_init_msg_list ) THEN
812: FND_MSG_PUB.initialize;
813: END IF;
814:
815: -- Standard call to check for call compatibility.
816: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

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

823:
824: -- Initialize API return status to success
825: x_return_status := FND_API.G_RET_STS_SUCCESS;
826:
827: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
828: log_msg('Beginning Get Resource Cost process.');
829: END IF;
830:
831: G_header_logged := 'N'; -- to avoid logging duplicate header for errors

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

829: END IF;
830:
831: G_header_logged := 'N'; -- to avoid logging duplicate header for errors
832:
833: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
834: log_msg('Calling private API to fetch records...');
835: END IF;
836:
837: GMF_ResourceCost_PVT.Get_Resource_Cost

Line 865: FND_MSG_PUB.Count_And_Get

861: COMMIT WORK;
862: END IF;
863: */
864: -- Standard call to get message count and if count is 1, get message info.
865: FND_MSG_PUB.Count_And_Get
866: ( p_count => x_msg_count ,
867: p_data => x_msg_data
868: );
869:

Line 874: FND_MSG_PUB.Count_And_Get

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

Line 881: FND_MSG_PUB.Count_And_Get

877: );
878: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
879: ROLLBACK TO Get_Resource_Cost_PUB;
880: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
881: FND_MSG_PUB.Count_And_Get
882: ( p_count => x_msg_count ,
883: p_data => x_msg_data
884: );
885: WHEN OTHERS THEN

Line 888: IF FND_MSG_PUB.Check_Msg_Level

884: );
885: WHEN OTHERS THEN
886: ROLLBACK TO Get_Resource_Cost_PUB;
887: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
888: IF FND_MSG_PUB.Check_Msg_Level
889: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
890: THEN
891: FND_MSG_PUB.Add_Exc_Msg
892: ( G_PKG_NAME ,

Line 889: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

885: WHEN OTHERS THEN
886: ROLLBACK TO Get_Resource_Cost_PUB;
887: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
888: IF FND_MSG_PUB.Check_Msg_Level
889: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
890: THEN
891: FND_MSG_PUB.Add_Exc_Msg
892: ( G_PKG_NAME ,
893: l_api_name

Line 891: FND_MSG_PUB.Add_Exc_Msg

887: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
888: IF FND_MSG_PUB.Check_Msg_Level
889: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
890: THEN
891: FND_MSG_PUB.Add_Exc_Msg
892: ( G_PKG_NAME ,
893: l_api_name
894: );
895: END IF;

Line 896: FND_MSG_PUB.Count_And_Get

892: ( G_PKG_NAME ,
893: l_api_name
894: );
895: END IF;
896: FND_MSG_PUB.Count_And_Get
897: ( p_count => x_msg_count ,
898: p_data => x_msg_data
899: );
900:

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

979: l_nominal_cost := p_rsrc_cost_rec.nominal_cost ;
980: l_delete_mark := p_rsrc_cost_rec.delete_mark ;
981: l_user_name := p_rsrc_cost_rec.user_name ;
982:
983: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
984: log_msg( 'resources : ' || l_resources);
985: log_msg( 'legal_entity_id : ' || l_legal_entity_id);
986: log_msg( 'organization_id : ' || l_organization_id);
987: log_msg( 'period_id : ' || l_period_id);

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

997: -------------
998: IF (l_resources <> FND_API.G_MISS_CHAR) AND
999: (l_resources IS NOT NULL) THEN
1000: -- validate alloc_id
1001: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1002: log_msg('validating resources : '|| l_resources);
1003: END IF;
1004:
1005: --

Line 1013: FND_MSG_PUB.Add;

1009: IF NOT (GMF_VALIDATIONS_PVT.Validate_Resources(l_resources)) THEN
1010: add_header_to_error_stack(p_rsrc_cost_rec); -- Bug 2659435
1011: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_RESOURCES');
1012: FND_MESSAGE.SET_TOKEN('RESOURCES',l_resources);
1013: FND_MSG_PUB.Add;
1014: RAISE FND_API.G_EXC_ERROR;
1015: END IF;
1016: -- Get the resource UOM code, resource UOM class for further processing
1017: GMF_VALIDATIONS_PVT.Validate_Resource(l_resources,l_resource_uom,l_resource_uom_class);

Line 1022: FND_MSG_PUB.Add;

1018: IF l_resource_uom IS NULL AND l_resource_uom_class IS NULL THEN
1019: add_header_to_error_stack(p_rsrc_cost_rec); -- Bug 2659435
1020: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_RESOURCES');
1021: FND_MESSAGE.SET_TOKEN('RESOURCES',l_resources);
1022: FND_MSG_PUB.Add;
1023: RAISE FND_API.G_EXC_ERROR;
1024: END IF;
1025: ELSE
1026: add_header_to_error_stack(p_rsrc_cost_rec); -- Bug 2659435

Line 1028: FND_MSG_PUB.Add;

1024: END IF;
1025: ELSE
1026: add_header_to_error_stack(p_rsrc_cost_rec); -- Bug 2659435
1027: FND_MESSAGE.SET_NAME('GMF','GMF_API_RESOURCES_REQ');
1028: FND_MSG_PUB.Add;
1029: RAISE FND_API.G_EXC_ERROR;
1030: END IF;
1031: -- End Resource
1032:

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

1032:
1033: --------------------------
1034: -- Legal entity
1035: --------------------------
1036: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1037: log_msg('validating legal_entity_id : ' || l_legal_entity_id);
1038: END IF;
1039:
1040: IF (l_legal_entity_id <> FND_API.G_MISS_NUM) AND

Line 1046: FND_MSG_PUB.Add;

1042: IF NOT GMF_VALIDATIONS_PVT.Validate_legal_entity_id(l_legal_entity_id) THEN
1043: add_header_to_error_stack(p_rsrc_cost_rec); -- Bug 2659435
1044: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_LE_ID');
1045: FND_MESSAGE.SET_TOKEN('LEGAL_ENTITY',l_legal_entity_id);
1046: FND_MSG_PUB.Add;
1047: RAISE FND_API.G_EXC_ERROR;
1048: END IF;
1049: ELSE
1050: add_header_to_error_stack(p_rsrc_cost_rec); -- Bug 2659435

Line 1052: FND_MSG_PUB.Add;

1048: END IF;
1049: ELSE
1050: add_header_to_error_stack(p_rsrc_cost_rec); -- Bug 2659435
1051: FND_MESSAGE.SET_NAME('GMF','GMF_API_LE_ID_REQ');
1052: FND_MSG_PUB.Add;
1053: RAISE FND_API.G_EXC_ERROR;
1054: END IF;
1055:
1056: -- End legal entity

Line 1063: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_debug_level THEN

1059: -- Organization validation
1060: --------------------------
1061: -- validate organization id
1062: IF ((l_organization_id <> FND_API.G_MISS_NUM) AND (l_organization_id IS NOT NULL)) THEN
1063: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_debug_level THEN
1064: log_msg('Validation Organization ID : '||l_organization_id);
1065: END IF;
1066: -- invoke validate organization id method
1067: IF NOT gmf_validations_pvt.Validate_organization_id(l_organization_id) THEN

Line 1070: FND_MSG_PUB.Add;

1066: -- invoke validate organization id method
1067: IF NOT gmf_validations_pvt.Validate_organization_id(l_organization_id) THEN
1068: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ORGN_ID');
1069: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID', l_organization_id);
1070: FND_MSG_PUB.Add;
1071: RAISE FND_API.G_EXC_ERROR;
1072: END IF;
1073: -- if organization code also passed then log a message to ignore organization code
1074: IF ( l_organization_code <> FND_API.G_MISS_CHAR) AND (l_organization_code IS NOT NULL) THEN

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

1071: RAISE FND_API.G_EXC_ERROR;
1072: END IF;
1073: -- if organization code also passed then log a message to ignore organization code
1074: IF ( l_organization_code <> FND_API.G_MISS_CHAR) AND (l_organization_code IS NOT NULL) THEN
1075: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1076: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_ORGN_CODE');
1077: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE', l_organization_code);
1078: FND_MSG_PUB.Add;
1079: END IF;

Line 1078: FND_MSG_PUB.Add;

1074: IF ( l_organization_code <> FND_API.G_MISS_CHAR) AND (l_organization_code IS NOT NULL) THEN
1075: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1076: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_ORGN_CODE');
1077: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE', l_organization_code);
1078: FND_MSG_PUB.Add;
1079: END IF;
1080: END IF;
1081: -- Organization code passed
1082: ELSIF (l_organization_code <> FND_API.G_MISS_CHAR ) AND (l_organization_code IS NOT NULL ) THEN

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

1079: END IF;
1080: END IF;
1081: -- Organization code passed
1082: ELSIF (l_organization_code <> FND_API.G_MISS_CHAR ) AND (l_organization_code IS NOT NULL ) THEN
1083: IF (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level) THEN
1084: log_msg('Validating Organization Code : ' ||l_organization_code);
1085: END IF;
1086: -- get the organization id
1087: l_organization_id := gmf_validations_pvt.validate_organization_code(l_organization_code);

Line 1088: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

1084: log_msg('Validating Organization Code : ' ||l_organization_code);
1085: END IF;
1086: -- get the organization id
1087: l_organization_id := gmf_validations_pvt.validate_organization_code(l_organization_code);
1088: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
1089: log_msg('Organization id : ' || l_organization_id);
1090: END IF;
1091: -- if organization id is null then log message
1092: IF l_organization_id IS NULL THEN

Line 1095: FND_MSG_PUB.Add;

1091: -- if organization id is null then log message
1092: IF l_organization_id IS NULL THEN
1093: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ORGN_CODE');
1094: FND_MESSAGE.SET_TOKEN('ORG_CODE', l_organization_code);
1095: FND_MSG_PUB.Add;
1096: RAISE FND_API.G_EXC_ERROR;
1097: END IF;
1098: -- Either organization id or organization code required
1099: ELSE

Line 1103: FND_MSG_PUB.Add;

1099: ELSE
1100: /* Bug 12333658. Do not raise ERROR even though both organization_id and organization_code are NULL */
1101: /*
1102: FND_MESSAGE.SET_NAME('GMF','GMF_API_ORGANIZATION_ID_REQ');
1103: FND_MSG_PUB.Add;
1104: RAISE FND_API.G_EXC_ERROR;
1105: */
1106: null;
1107: END IF;

Line 1114: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

1110: ----------------------------
1111: -- * Cost Type Validation *
1112: ----------------------------
1113: IF (l_cost_type_id <> FND_API.G_MISS_NUM) AND (l_cost_type_id IS NOT NULL) THEN
1114: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
1115: log_msg('Validating Cost Type Id : ' || l_cost_type_id);
1116: END IF;
1117: -- Invoke cost type id validation method
1118: IF NOT gmf_validations_pvt.validate_cost_type_id (l_cost_type_id) THEN

Line 1121: FND_MSG_PUB.Add;

1117: -- Invoke cost type id validation method
1118: IF NOT gmf_validations_pvt.validate_cost_type_id (l_cost_type_id) THEN
1119: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_COST_TYPE_ID');
1120: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID', l_cost_type_id);
1121: FND_MSG_PUB.Add;
1122: RAISE FND_API.G_EXC_ERROR;
1123: END IF;
1124: -- if cost method code is not then log a message
1125: IF (l_cost_type_code <> FND_API.G_MISS_CHAR) AND (l_cost_type_code IS NOT NULL) THEN

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

1122: RAISE FND_API.G_EXC_ERROR;
1123: END IF;
1124: -- if cost method code is not then log a message
1125: IF (l_cost_type_code <> FND_API.G_MISS_CHAR) AND (l_cost_type_code IS NOT NULL) THEN
1126: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1127: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_COST_TYPE');
1128: FND_MESSAGE.SET_TOKEN('COST_TYPE', l_cost_type_code);
1129: FND_MSG_PUB.Add;
1130: END IF;

Line 1129: FND_MSG_PUB.Add;

1125: IF (l_cost_type_code <> FND_API.G_MISS_CHAR) AND (l_cost_type_code IS NOT NULL) THEN
1126: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1127: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_COST_TYPE');
1128: FND_MESSAGE.SET_TOKEN('COST_TYPE', l_cost_type_code);
1129: FND_MSG_PUB.Add;
1130: END IF;
1131: END IF;
1132: ELSIF (l_cost_type_code <> FND_API.G_MISS_CHAR) AND (l_cost_type_code IS NOT NULL) THEN
1133:

Line 1135: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

1131: END IF;
1132: ELSIF (l_cost_type_code <> FND_API.G_MISS_CHAR) AND (l_cost_type_code IS NOT NULL) THEN
1133:
1134: -- Get the cost type id from the method
1135: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
1136: log_msg('Validating Cost Type Code : ' || l_cost_type_code);
1137: END IF;
1138:
1139: l_cost_type_id := GMF_VALIDATIONS_PVT.Validate_cost_type_code(l_cost_type_code);

Line 1140: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

1136: log_msg('Validating Cost Type Code : ' || l_cost_type_code);
1137: END IF;
1138:
1139: l_cost_type_id := GMF_VALIDATIONS_PVT.Validate_cost_type_code(l_cost_type_code);
1140: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
1141: log_msg('Cost Type Id : ' || l_cost_type_id);
1142: END IF;
1143: IF l_cost_type_id IS NULL THEN
1144: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_COST_TYPE');

Line 1146: FND_MSG_PUB.Add;

1142: END IF;
1143: IF l_cost_type_id IS NULL THEN
1144: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_COST_TYPE');
1145: FND_MESSAGE.SET_TOKEN('COST_TYPE',l_cost_type_code);
1146: FND_MSG_PUB.Add;
1147: RAISE FND_API.G_EXC_ERROR;
1148: END IF;
1149: ELSE
1150: FND_MESSAGE.SET_NAME('GMF','GMF_API_COST_TYPE_ID_REQ');

Line 1151: FND_MSG_PUB.Add;

1147: RAISE FND_API.G_EXC_ERROR;
1148: END IF;
1149: ELSE
1150: FND_MESSAGE.SET_NAME('GMF','GMF_API_COST_TYPE_ID_REQ');
1151: FND_MSG_PUB.Add;
1152: RAISE FND_API.G_EXC_ERROR;
1153: END IF;
1154: -- End Cost Method
1155: --

Line 1161: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

1157: --------------------------
1158: -- * Period Validation *
1159: --------------------------
1160: IF (l_period_id <> FND_API.G_MISS_NUM) AND (l_period_id IS NOT NULL) THEN
1161: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
1162: log_msg('Validating Period Id : ' || l_period_id);
1163: END IF;
1164: -- Invoke validate period id method
1165: IF NOT gmf_validations_pvt.validate_period_id(l_period_id) THEN

Line 1168: FND_MSG_PUB.Add;

1164: -- Invoke validate period id method
1165: IF NOT gmf_validations_pvt.validate_period_id(l_period_id) THEN
1166: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_PERIOD_ID');
1167: FND_MESSAGE.SET_TOKEN('PERIOD_ID', l_period_id);
1168: FND_MSG_PUB.Add;
1169: RAISE FND_API.G_EXC_ERROR;
1170: END IF;
1171: -- If period code also passed then ignore period code
1172: IF ((l_calendar_code <> FND_API.G_MISS_CHAR) AND (l_calendar_code IS NOT NULL))

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

1170: END IF;
1171: -- If period code also passed then ignore period code
1172: IF ((l_calendar_code <> FND_API.G_MISS_CHAR) AND (l_calendar_code IS NOT NULL))
1173: AND ((l_period_code <> FND_API.G_MISS_CHAR) AND (l_period_code IS NOT NULL)) THEN
1174: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1175: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_PERIOD_CODE');
1176: FND_MESSAGE.SET_TOKEN('CALENDAR_CODE', l_calendar_code);
1177: FND_MESSAGE.SET_TOKEN('PERIOD_CODE', l_period_code);
1178: FND_MSG_PUB.Add;

Line 1178: FND_MSG_PUB.Add;

1174: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1175: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_PERIOD_CODE');
1176: FND_MESSAGE.SET_TOKEN('CALENDAR_CODE', l_calendar_code);
1177: FND_MESSAGE.SET_TOKEN('PERIOD_CODE', l_period_code);
1178: FND_MSG_PUB.Add;
1179: END IF;
1180: END IF;
1181: ELSIF (l_calendar_code <> FND_API.G_MISS_CHAR) AND (l_calendar_code IS NOT NULL)
1182: AND ((l_period_code <> FND_API.G_MISS_CHAR) AND (l_period_code IS NOT NULL)) THEN

Line 1185: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

1181: ELSIF (l_calendar_code <> FND_API.G_MISS_CHAR) AND (l_calendar_code IS NOT NULL)
1182: AND ((l_period_code <> FND_API.G_MISS_CHAR) AND (l_period_code IS NOT NULL)) THEN
1183:
1184: -- Get the period id passing period code to the validate period id method
1185: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
1186: log_msg('Validating Calendar Code : ' || l_calendar_code||', Period Code : '||l_period_code);
1187: END IF;
1188:
1189: /* Begin Bug 12333658 */

Line 1210: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

1206: END;
1207: END IF;
1208: /* End Bug 12333658 */
1209:
1210: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
1211: log_msg('Period Id : ' || l_period_id);
1212: END IF;
1213: -- if period id null then log message with invalid period code
1214: IF l_period_id IS NULL THEN

Line 1218: FND_MSG_PUB.Add;

1214: IF l_period_id IS NULL THEN
1215: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_CLDR_PERIOD');
1216: FND_MESSAGE.SET_TOKEN('CALENDAR_CODE',l_calendar_code);
1217: FND_MESSAGE.SET_TOKEN('PERIOD_CODE',l_period_code);
1218: FND_MSG_PUB.Add;
1219: RAISE FND_API.G_EXC_ERROR;
1220: END IF;
1221: ELSE
1222: FND_MESSAGE.SET_NAME('GMF','GMF_API_PERIOD_ID_REQ');

Line 1223: FND_MSG_PUB.Add;

1219: RAISE FND_API.G_EXC_ERROR;
1220: END IF;
1221: ELSE
1222: FND_MESSAGE.SET_NAME('GMF','GMF_API_PERIOD_ID_REQ');
1223: FND_MSG_PUB.Add;
1224: RAISE FND_API.G_EXC_ERROR;
1225: END IF;
1226:
1227: -- End Period Validation

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

1235:
1236: --
1237: -- Usage Unit of Measure
1238: --
1239: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1240: log_msg('validating usage_uom : ' || l_usage_uom);
1241: END IF;
1242:
1243: IF (l_usage_uom <> FND_API.G_MISS_CHAR) AND

Line 1256: FND_MSG_PUB.Add;

1252: IF l_usage_uom_class IS NULL THEN
1253: add_header_to_error_stack(p_rsrc_cost_rec); -- Bug 2659435
1254: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_USAGE_UM');
1255: FND_MESSAGE.SET_TOKEN('USAGE_UM',l_usage_uom);
1256: FND_MSG_PUB.Add;
1257: RAISE FND_API.G_EXC_ERROR;
1258: END IF;
1259:
1260: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435

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

1256: FND_MSG_PUB.Add;
1257: RAISE FND_API.G_EXC_ERROR;
1258: END IF;
1259:
1260: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1261: log_msg('Usage UOM Class : ' || l_usage_uom_class ||
1262: ' resource UOM Class : ' || l_resource_uom_class);
1263: END IF;
1264:

Line 1271: FND_MSG_PUB.Add;

1267: add_header_to_error_stack(p_rsrc_cost_rec);
1268: FND_MESSAGE.SET_NAME('GMF','GMF_API_USAGE_UOM_SAMETYPE_REQ');
1269: FND_MESSAGE.SET_TOKEN('USAGE_UM',l_usage_uom);
1270: FND_MESSAGE.SET_TOKEN('RESOURCE_UM',l_resource_uom);
1271: FND_MSG_PUB.Add;
1272: RAISE FND_API.G_EXC_ERROR;
1273: END IF;
1274: -- End of bug 2692459
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_USAGE_UM_REQ');
1281: FND_MSG_PUB.Add;
1282: RAISE FND_API.G_EXC_ERROR;
1283: END IF;
1284: -- End Usage Unit of Measure
1285:

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

1288: -- Nominal Cost should be > 0
1289: -- In the form the format mask for this is : 999999999D999999999(999,999,999.999999999)
1290: -- To put that check here, the cost should not be >= 1,000,000,000
1291: --
1292: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1293: log_msg('Validating Nominal Cost : '||l_nominal_cost);
1294: END IF;
1295:
1296: /*************************************************************************

Line 1305: FND_MSG_PUB.Add;

1301: IF ((nvl(l_nominal_cost,0) <= 0) OR (nvl(l_nominal_cost,0) >= 1000000000)) THEN
1302: add_header_to_error_stack(p_rsrc_cost_rec); -- Bug 2659435
1303: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_NOMINAL_COST');
1304: FND_MESSAGE.SET_TOKEN('NOMINAL_COST',l_nominal_cost);
1305: FND_MSG_PUB.Add;
1306: RAISE FND_API.G_EXC_ERROR;
1307: END IF;
1308: ELSIF (l_nominal_cost = FND_API.G_MISS_NUM AND
1309: */

Line 1315: FND_MSG_PUB.Add;

1311: ((G_operation = 'UPDATE') OR
1312: (G_operation = 'INSERT')) THEN
1313: add_header_to_error_stack(p_rsrc_cost_rec); -- Bug 2659435
1314: FND_MESSAGE.SET_NAME('GMF','GMF_API_NOMINAL_COST_REQ');
1315: FND_MSG_PUB.Add;
1316: RAISE FND_API.G_EXC_ERROR;
1317: END IF;
1318: -- End Nominal Cost
1319:

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

1319:
1320: --
1321: -- Delete Mark
1322: --
1323: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1324: log_msg('Validating delete_mark : ' || l_delete_mark);
1325: END IF;
1326:
1327: IF (l_delete_mark <> FND_API.G_MISS_NUM) AND

Line 1333: FND_MSG_PUB.Add;

1329: IF l_delete_mark NOT IN (0,1) THEN
1330: add_header_to_error_stack(p_rsrc_cost_rec); -- Bug 2659435
1331: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_DELETE_MARK');
1332: FND_MESSAGE.SET_TOKEN('DELETE_MARK',l_delete_mark);
1333: FND_MSG_PUB.Add;
1334: RAISE FND_API.G_EXC_ERROR;
1335: END IF;
1336: ELSIF (l_delete_mark = FND_API.G_MISS_NUM AND
1337: G_operation = 'UPDATE') OR

Line 1341: FND_MSG_PUB.Add;

1337: G_operation = 'UPDATE') OR
1338: (G_operation = 'INSERT') THEN
1339: add_header_to_error_stack(p_rsrc_cost_rec); -- Bug 2659435
1340: FND_MESSAGE.SET_NAME('GMF','GMF_API_DELETE_MARK_REQ');
1341: FND_MSG_PUB.Add;
1342: RAISE FND_API.G_EXC_ERROR;
1343: END IF;
1344:
1345: -- Bug 2692459

Line 1349: FND_MSG_PUB.Add;

1345: -- Bug 2692459
1346: IF ((G_operation = 'UPDATE') AND (l_delete_mark = 1)) THEN
1347: add_header_to_error_stack(p_rsrc_cost_rec);
1348: FND_MESSAGE.SET_NAME('GMF','GMF_API_CANT_MARK_FOR_PURGE');
1349: FND_MSG_PUB.Add;
1350: RAISE FND_API.G_EXC_ERROR;
1351: END IF;
1352: -- End Delete Mark
1353:

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

1353:
1354: END IF; -- Bug 2692459: G_operation <> 'DELETE'
1355:
1356: -- Populate WHO columns
1357: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1358: log_msg('Validating user name : ' || l_user_name);
1359: END IF;
1360:
1361: IF (l_user_name <> FND_API.G_MISS_CHAR) AND

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

1363: GMA_GLOBAL_GRP.Get_who( p_user_name => l_user_name
1364: , x_user_id => l_user_id
1365: );
1366:
1367: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1368: log_msg('user id : ' || l_user_id);
1369: END IF;
1370:
1371: IF l_user_id = -1 THEN -- Bug 2681243: GMA changed return status value to -1.

Line 1375: FND_MSG_PUB.Add;

1371: IF l_user_id = -1 THEN -- Bug 2681243: GMA changed return status value to -1.
1372: add_header_to_error_stack(p_rsrc_cost_rec); -- Bug 2659435
1373: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_USER_NAME');
1374: FND_MESSAGE.SET_TOKEN('USER_NAME',l_user_name);
1375: FND_MSG_PUB.Add;
1376: RAISE FND_API.G_EXC_ERROR;
1377: END IF;
1378:
1379: ELSE

Line 1382: FND_MSG_PUB.Add;

1378:
1379: ELSE
1380: add_header_to_error_stack(p_rsrc_cost_rec); -- Bug 2659435
1381: FND_MESSAGE.SET_NAME('GMF','GMF_API_USER_NAME_REQ');
1382: FND_MSG_PUB.Add;
1383: RAISE FND_API.G_EXC_ERROR;
1384: END IF;
1385: -- End User Name
1386:

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

1510: )
1511: IS
1512: BEGIN
1513:
1514: -- IF FND_MSG_PUB.Check_Msg_Level (p_msg_lvl) THEN Bug 2659435
1515: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEBUG');
1516: FND_MESSAGE.SET_TOKEN('MSG',p_msg_text);
1517: FND_MSG_PUB.Add;
1518: -- END IF; Bug 2659435

Line 1517: FND_MSG_PUB.Add;

1513:
1514: -- IF FND_MSG_PUB.Check_Msg_Level (p_msg_lvl) THEN Bug 2659435
1515: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEBUG');
1516: FND_MESSAGE.SET_TOKEN('MSG',p_msg_text);
1517: FND_MSG_PUB.Add;
1518: -- END IF; Bug 2659435
1519:
1520: END log_msg ;
1521:

Line 1557: FND_MSG_PUB.Add;

1553: FND_MESSAGE.SET_TOKEN('LEGAL_ENTITY_ID',p_header.legal_entity_id);
1554: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_header.organization_id);
1555: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header.period_id);
1556: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',p_header.cost_type_id);
1557: FND_MSG_PUB.Add;
1558: END IF;
1559:
1560: END add_header_to_error_stack;
1561: