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_BURDENDETAILS_PUB dependencies on FND_MSG_PUB

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

104: -- Global variables
105: G_PKG_NAME CONSTANT VARCHAR2(30) := 'GMF_BurdenDetails_PUB';
106:
107: -- Bug 2659435
108: G_tmp BOOLEAN := FND_MSG_PUB.Check_Msg_Level(0) ; -- temp call to initialize the
109: -- msg level threshhold gobal
110: -- variable.
111: G_debug_level NUMBER(2) := FND_MSG_PUB.G_Msg_Level_Threshold; -- Use this variable everywhere
112: -- to decide to log a debug msg.

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

107: -- Bug 2659435
108: G_tmp BOOLEAN := FND_MSG_PUB.Check_Msg_Level(0) ; -- temp call to initialize the
109: -- msg level threshhold gobal
110: -- variable.
111: G_debug_level NUMBER(2) := FND_MSG_PUB.G_Msg_Level_Threshold; -- Use this variable everywhere
112: -- to decide to log a debug msg.
113: G_header_logged VARCHAR2(1); -- to indicate whether header is already in
114: -- error stack or not - avoid logging duplicate headers
115:

Line 186: FND_MSG_PUB.initialize;

182: SAVEPOINT Create_Burden_Details_PUB ;
183:
184: -- Initialize message list if p_init_msg_list is set to TRUE.
185: IF FND_API.to_Boolean( p_init_msg_list ) THEN
186: FND_MSG_PUB.initialize;
187: END IF;
188:
189: -- Standard call to check for call compatibility.
190: 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: -- Initialize API return status to success
199: x_return_status := FND_API.G_RET_STS_SUCCESS;
200:
201: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
202: log_msg('Beginning Create Burden details process.');
203: END IF;
204:
205: G_header_logged := 'N'; -- to avoid logging duplicate header for errors

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

203: END IF;
204:
205: G_header_logged := 'N'; -- to avoid logging duplicate header for errors
206:
207: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
208: log_msg('In public API. # of Detail records : ' || p_dtl_tbl.count);
209: END IF;
210:
211: IF p_dtl_tbl.count > 0 THEN

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

208: log_msg('In public API. # of Detail records : ' || p_dtl_tbl.count);
209: END IF;
210:
211: IF p_dtl_tbl.count > 0 THEN
212: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
213: log_msg('Validating input parameters');
214: END IF;
215: -- Validate all the input parameters.
216: Validate_Input_Params

Line 228: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2681243

224: ,x_brdn_factor_tbl => l_brdn_factor_tbl
225: ,x_return_status => l_return_status
226: ) ;
227:
228: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2681243
229: log_msg('Return Status after validating : ' || l_return_status);
230: END IF;
231:
232: -- Return if validation failures detected

Line 236: FND_MSG_PUB.Add;

232: -- Return if validation failures detected
233: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
234: add_header_to_error_stack(p_header_rec); -- Bug 2659435
235: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_INS');
236: FND_MSG_PUB.Add;
237: RAISE FND_API.G_EXC_ERROR;
238: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
239: add_header_to_error_stack(p_header_rec); -- Bug 2659435
240: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_INS');

Line 241: FND_MSG_PUB.Add;

237: RAISE FND_API.G_EXC_ERROR;
238: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
239: add_header_to_error_stack(p_header_rec); -- Bug 2659435
240: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_INS');
241: FND_MSG_PUB.Add;
242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
243: END IF;
244: END IF;
245:

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

243: END IF;
244: END IF;
245:
246: IF l_dtl_tbl.count > 0 THEN
247: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
248: log_msg('Calling private API to insert record...');
249: END IF;
250: GMF_BurdenDetails_PVT.Create_Burden_Details
251: (

Line 273: FND_MSG_PUB.Add;

269: IF l_return_status = FND_API.G_RET_STS_ERROR
270: THEN
271: add_header_to_error_stack(l_header_rec); -- Bug 2659435
272: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_INS');
273: FND_MSG_PUB.Add;
274: RAISE FND_API.G_EXC_ERROR;
275: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
276: THEN
277: add_header_to_error_stack(l_header_rec); -- Bug 2659435

Line 279: FND_MSG_PUB.Add;

275: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
276: THEN
277: add_header_to_error_stack(l_header_rec); -- Bug 2659435
278: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_INS');
279: FND_MSG_PUB.Add;
280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
281: END IF;
282:
283: add_header_to_error_stack(l_header_rec); -- Bug 2659435

Line 286: FND_MSG_PUB.Add;

282:
283: add_header_to_error_stack(l_header_rec); -- Bug 2659435
284: FND_MESSAGE.SET_NAME('GMF','GMF_API_ROWS_INS');
285: FND_MESSAGE.SET_TOKEN('NUM_ROWS',x_burdenline_ids.count);
286: FND_MSG_PUB.Add;
287: ELSE
288: add_header_to_error_stack(p_header_rec); -- Bug 2659435
289: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_INS');
290: FND_MSG_PUB.Add;

Line 290: FND_MSG_PUB.Add;

286: FND_MSG_PUB.Add;
287: ELSE
288: add_header_to_error_stack(p_header_rec); -- Bug 2659435
289: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_INS');
290: FND_MSG_PUB.Add;
291: END IF ;
292:
293: -- Standard check of p_commit.
294: IF FND_API.To_Boolean( p_commit ) THEN

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_Burden_Details_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_Burden_Details_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_Burden_Details_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_Burden_Details_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 402: FND_MSG_PUB.initialize;

398: SAVEPOINT Update_Burden_Details_PUB;
399:
400: -- Initialize message list if p_init_msg_list is set to TRUE.
401: IF FND_API.to_Boolean( p_init_msg_list ) THEN
402: FND_MSG_PUB.initialize;
403: END IF;
404:
405: -- Standard call to check for call compatibility.
406: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

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

413:
414: -- Initialize API return status to success
415: x_return_status := FND_API.G_RET_STS_SUCCESS;
416:
417: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
418: log_msg('Beginning Update Burden Details Definition process.');
419: END IF;
420:
421: G_header_logged := 'N'; -- to avoid logging duplicate header for errors

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

419: END IF;
420:
421: G_header_logged := 'N'; -- to avoid logging duplicate header for errors
422:
423: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
424: log_msg('In public API. # of detail records : ' || p_dtl_tbl.count);
425: END IF;
426:
427: IF p_dtl_tbl.count > 0 THEN

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

424: log_msg('In public API. # of detail records : ' || p_dtl_tbl.count);
425: END IF;
426:
427: IF p_dtl_tbl.count > 0 THEN
428: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
429: log_msg('Validating input parameters');
430: END IF;
431: -- Validate all the input parameters.
432: Validate_Input_Params

Line 444: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2681243

440: ,x_brdn_factor_tbl => l_brdn_factor_tbl
441: ,x_return_status => l_return_status
442: ) ;
443:
444: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2681243
445: log_msg('Return Status after validating : ' || l_return_status);
446: END IF;
447:
448: -- Return if validation failures detected

Line 452: FND_MSG_PUB.Add;

448: -- Return if validation failures detected
449: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
450: add_header_to_error_stack(p_header_rec); -- Bug 2659435
451: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_UPD');
452: FND_MSG_PUB.Add;
453: RAISE FND_API.G_EXC_ERROR;
454: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
455: add_header_to_error_stack(p_header_rec); -- Bug 2659435
456: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_UPD');

Line 457: FND_MSG_PUB.Add;

453: RAISE FND_API.G_EXC_ERROR;
454: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
455: add_header_to_error_stack(p_header_rec); -- Bug 2659435
456: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_UPD');
457: FND_MSG_PUB.Add;
458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
459: END IF;
460: END IF;
461:

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

459: END IF;
460: END IF;
461:
462: IF l_dtl_tbl.count > 0 THEN
463: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
464: log_msg('Calling private API to update records...');
465: END IF;
466: GMF_BurdenDetails_PVT.Update_Burden_Details
467: (

Line 486: FND_MSG_PUB.Add;

482: -- Return if update fails for any reason
483: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
484: add_header_to_error_stack(l_header_rec); -- Bug 2659435
485: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_UPD');
486: FND_MSG_PUB.Add;
487: RAISE FND_API.G_EXC_ERROR;
488: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
489: add_header_to_error_stack(l_header_rec); -- Bug 2659435
490: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_UPD');

Line 491: FND_MSG_PUB.Add;

487: RAISE FND_API.G_EXC_ERROR;
488: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
489: add_header_to_error_stack(l_header_rec); -- Bug 2659435
490: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_UPD');
491: FND_MSG_PUB.Add;
492: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
493: END IF;
494:
495: add_header_to_error_stack(l_header_rec); -- Bug 2659435

Line 498: FND_MSG_PUB.Add;

494:
495: add_header_to_error_stack(l_header_rec); -- Bug 2659435
496: FND_MESSAGE.SET_NAME('GMF','GMF_API_ROWS_UPD');
497: FND_MESSAGE.SET_TOKEN('NUM_ROWS',l_dtl_tbl.count);
498: FND_MSG_PUB.Add;
499:
500: ELSE
501: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_UPD');
502: add_header_to_error_stack(p_header_rec); -- Bug 2659435

Line 503: FND_MSG_PUB.Add;

499:
500: ELSE
501: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_UPD');
502: add_header_to_error_stack(p_header_rec); -- Bug 2659435
503: FND_MSG_PUB.Add;
504: END IF ;
505: --log_msg( l_no_rows_upd || ' rows updated.');
506:
507:

Line 514: FND_MSG_PUB.Count_And_Get

510: COMMIT WORK;
511: END IF;
512:
513: -- Standard call to get message count and if count is 1, get message info.
514: FND_MSG_PUB.Count_And_Get
515: ( p_count => x_msg_count ,
516: p_data => x_msg_data
517: );
518:

Line 523: FND_MSG_PUB.Count_And_Get

519: EXCEPTION
520: WHEN FND_API.G_EXC_ERROR THEN
521: ROLLBACK TO Update_Burden_Details_PUB;
522: x_return_status := FND_API.G_RET_STS_ERROR ;
523: FND_MSG_PUB.Count_And_Get
524: ( p_count => x_msg_count ,
525: p_data => x_msg_data
526: );
527: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 530: FND_MSG_PUB.Count_And_Get

526: );
527: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
528: ROLLBACK TO Update_Burden_Details_PUB;
529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
530: FND_MSG_PUB.Count_And_Get
531: ( p_count => x_msg_count ,
532: p_data => x_msg_data
533: );
534: WHEN OTHERS THEN

Line 537: IF FND_MSG_PUB.Check_Msg_Level

533: );
534: WHEN OTHERS THEN
535: ROLLBACK TO Update_Burden_Details_PUB;
536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
537: IF FND_MSG_PUB.Check_Msg_Level
538: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
539: THEN
540: FND_MSG_PUB.Add_Exc_Msg
541: ( G_PKG_NAME ,

Line 538: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

534: WHEN OTHERS THEN
535: ROLLBACK TO Update_Burden_Details_PUB;
536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
537: IF FND_MSG_PUB.Check_Msg_Level
538: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
539: THEN
540: FND_MSG_PUB.Add_Exc_Msg
541: ( G_PKG_NAME ,
542: l_api_name

Line 540: FND_MSG_PUB.Add_Exc_Msg

536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
537: IF FND_MSG_PUB.Check_Msg_Level
538: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
539: THEN
540: FND_MSG_PUB.Add_Exc_Msg
541: ( G_PKG_NAME ,
542: l_api_name
543: );
544: END IF;

Line 545: FND_MSG_PUB.Count_And_Get

541: ( G_PKG_NAME ,
542: l_api_name
543: );
544: END IF;
545: FND_MSG_PUB.Count_And_Get
546: ( p_count => x_msg_count ,
547: p_data => x_msg_data
548: );
549:

Line 618: FND_MSG_PUB.initialize;

614: SAVEPOINT Delete_Burden_Details_PUB;
615:
616: -- Initialize message list if p_init_msg_list is set to TRUE.
617: IF FND_API.to_Boolean( p_init_msg_list ) THEN
618: FND_MSG_PUB.initialize;
619: END IF;
620:
621: -- Standard call to check for call compatibility.
622: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

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

629:
630: -- Initialize API return status to success
631: x_return_status := FND_API.G_RET_STS_SUCCESS;
632:
633: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
634: log_msg('Beginning Delete Burden Details process.');
635: END IF;
636:
637: G_header_logged := 'N'; -- to avoid logging duplicate header for errors

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

635: END IF;
636:
637: G_header_logged := 'N'; -- to avoid logging duplicate header for errors
638:
639: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
640: log_msg('In public API. # of detail records : ' || p_dtl_tbl.count);
641: END IF;
642:
643: IF p_dtl_tbl.count > 0 THEN

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

640: log_msg('In public API. # of detail records : ' || p_dtl_tbl.count);
641: END IF;
642:
643: IF p_dtl_tbl.count > 0 THEN
644: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
645: log_msg('Validating input parameters');
646: END IF;
647:
648: -- Validate all the input parameters.

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

657: ,x_brdn_factor_tbl => l_brdn_factor_tbl
658: ,x_return_status => l_return_status
659: ) ;
660:
661: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2681243
662: log_msg('Return Status after validating : ' || l_return_status);
663: END IF;
664:
665: -- Return if validation failures detected

Line 669: FND_MSG_PUB.Add;

665: -- Return if validation failures detected
666: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
667: add_header_to_error_stack(p_header_rec); -- Bug 2659435
668: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_DEL');
669: FND_MSG_PUB.Add;
670: RAISE FND_API.G_EXC_ERROR;
671: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
672: add_header_to_error_stack(p_header_rec); -- Bug 2659435
673: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_DEL');

Line 674: FND_MSG_PUB.Add;

670: RAISE FND_API.G_EXC_ERROR;
671: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
672: add_header_to_error_stack(p_header_rec); -- Bug 2659435
673: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_DEL');
674: FND_MSG_PUB.Add;
675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
676: END IF;
677: END IF;
678:

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

676: END IF;
677: END IF;
678:
679: IF l_dtl_tbl.count > 0 THEN
680: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
681: log_msg('Calling private API to delete records...');
682: END IF;
683:
684: GMF_BurdenDetails_PVT.Update_Burden_Details

Line 704: FND_MSG_PUB.Add;

700: -- Return if update fails for any reason
701: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
702: add_header_to_error_stack(l_header_rec); -- Bug 2659435
703: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_DEL');
704: FND_MSG_PUB.Add;
705: RAISE FND_API.G_EXC_ERROR;
706: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
707: add_header_to_error_stack(l_header_rec); -- Bug 2659435
708: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_DEL');

Line 709: FND_MSG_PUB.Add;

705: RAISE FND_API.G_EXC_ERROR;
706: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
707: add_header_to_error_stack(l_header_rec); -- Bug 2659435
708: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_DEL');
709: FND_MSG_PUB.Add;
710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
711: END IF;
712:
713: add_header_to_error_stack(l_header_rec); -- Bug 2659435

Line 716: FND_MSG_PUB.Add;

712:
713: add_header_to_error_stack(l_header_rec); -- Bug 2659435
714: FND_MESSAGE.SET_NAME('GMF','GMF_API_ROWS_DEL');
715: FND_MESSAGE.SET_TOKEN('NUM_ROWS',l_dtl_tbl.count);
716: FND_MSG_PUB.Add;
717:
718: ELSE
719: add_header_to_error_stack(l_header_rec); -- Bug 2659435
720: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_DEL');

Line 721: FND_MSG_PUB.Add;

717:
718: ELSE
719: add_header_to_error_stack(l_header_rec); -- Bug 2659435
720: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_DEL');
721: FND_MSG_PUB.Add;
722: END IF ;
723:
724: --log_msg(l_no_rows_del || ' rows deleted.');
725:

Line 732: FND_MSG_PUB.Count_And_Get

728: COMMIT WORK;
729: END IF;
730:
731: -- Standard call to get message count and if count is 1, get message info.
732: FND_MSG_PUB.Count_And_Get
733: ( p_count => x_msg_count ,
734: p_data => x_msg_data
735: );
736:

Line 741: FND_MSG_PUB.Count_And_Get

737: EXCEPTION
738: WHEN FND_API.G_EXC_ERROR THEN
739: ROLLBACK TO Delete_Burden_Details_PUB;
740: x_return_status := FND_API.G_RET_STS_ERROR ;
741: FND_MSG_PUB.Count_And_Get
742: ( p_count => x_msg_count ,
743: p_data => x_msg_data
744: );
745: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 748: FND_MSG_PUB.Count_And_Get

744: );
745: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
746: ROLLBACK TO Delete_Burden_Details_PUB;
747: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
748: FND_MSG_PUB.Count_And_Get
749: ( p_count => x_msg_count ,
750: p_data => x_msg_data
751: );
752: WHEN OTHERS THEN

Line 755: IF FND_MSG_PUB.Check_Msg_Level

751: );
752: WHEN OTHERS THEN
753: ROLLBACK TO Delete_Burden_Details_PUB;
754: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
755: IF FND_MSG_PUB.Check_Msg_Level
756: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
757: THEN
758: FND_MSG_PUB.Add_Exc_Msg
759: ( G_PKG_NAME ,

Line 756: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

752: WHEN OTHERS THEN
753: ROLLBACK TO Delete_Burden_Details_PUB;
754: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
755: IF FND_MSG_PUB.Check_Msg_Level
756: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
757: THEN
758: FND_MSG_PUB.Add_Exc_Msg
759: ( G_PKG_NAME ,
760: l_api_name

Line 758: FND_MSG_PUB.Add_Exc_Msg

754: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
755: IF FND_MSG_PUB.Check_Msg_Level
756: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
757: THEN
758: FND_MSG_PUB.Add_Exc_Msg
759: ( G_PKG_NAME ,
760: l_api_name
761: );
762: END IF;

Line 763: FND_MSG_PUB.Count_And_Get

759: ( G_PKG_NAME ,
760: l_api_name
761: );
762: END IF;
763: FND_MSG_PUB.Count_And_Get
764: ( p_count => x_msg_count ,
765: p_data => x_msg_data
766: );
767:

Line 836: FND_MSG_PUB.initialize;

832: SAVEPOINT Get_Burden_Details_PUB;
833:
834: -- Initialize message list if p_init_msg_list is set to TRUE.
835: IF FND_API.to_Boolean( p_init_msg_list ) THEN
836: FND_MSG_PUB.initialize;
837: END IF;
838:
839: -- Standard call to check for call compatibility.
840:

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

848:
849: -- Initialize API return status to success
850: x_return_status := FND_API.G_RET_STS_SUCCESS;
851:
852: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
853: log_msg('Beginning Get Burden Details process.');
854: END IF;
855:
856: G_header_logged := 'N'; -- to avoid logging duplicate header for errors

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

863: -- use organization code
864: -- organization id
865: IF (p_header_rec.organization_id <> FND_API.G_MISS_NUM) AND
866: (p_header_rec.organization_id IS NOT NULL) THEN
867: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
868: log_msg('validating organization_id : ' || p_header_rec.organization_id);
869: END IF;
870: IF NOT GMF_VALIDATIONS_PVT.Validate_organization_id(p_header_rec.organization_id)
871: THEN

Line 875: FND_MSG_PUB.Add;

871: THEN
872: add_header_to_error_stack(p_header_rec); -- Bug 2659435
873: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ORGN_ID');
874: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_header_rec.organization_id);
875: FND_MSG_PUB.Add;
876: RAISE FND_API.G_EXC_ERROR;
877: END IF;
878: -- Log message to ignore if organization_Code is also passed
879: IF (p_header_rec.organization_code <> FND_API.G_MISS_CHAR) AND

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

877: END IF;
878: -- Log message to ignore if organization_Code is also passed
879: IF (p_header_rec.organization_code <> FND_API.G_MISS_CHAR) AND
880: (p_header_rec.organization_code IS NOT NULL) THEN
881: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
882: add_header_to_error_stack(p_header_rec); -- Bug 2659435
883: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_ORGN_CODE');
884: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',p_header_rec.organization_code);
885: FND_MSG_PUB.Add;

Line 885: FND_MSG_PUB.Add;

881: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
882: add_header_to_error_stack(p_header_rec); -- Bug 2659435
883: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_ORGN_CODE');
884: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',p_header_rec.organization_code);
885: FND_MSG_PUB.Add;
886: END IF;
887: END IF;
888: -- organization code
889: ELSIF (p_header_rec.organization_code <> FND_API.G_MISS_CHAR) AND

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

887: END IF;
888: -- organization code
889: ELSIF (p_header_rec.organization_code <> FND_API.G_MISS_CHAR) AND
890: (p_header_rec.organization_code IS NOT NULL) THEN
891: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
892: log_msg('validating organization_code : ' || p_header_rec.organization_code);
893: END IF;
894:
895: l_header_rec.organization_id := GMF_VALIDATIONS_PVT.Validate_organization_Code(p_header_rec.organization_code);

Line 900: FND_MSG_PUB.Add;

896: IF l_header_rec.organization_id IS NULL THEN
897: add_header_to_error_stack(p_header_rec); -- Bug 2659435
898: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ORGN_CODE');
899: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',p_header_rec.organization_code);
900: FND_MSG_PUB.Add;
901: RAISE FND_API.G_EXC_ERROR;
902: ELSE
903: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 5589409, pmarada
904: log_msg('Organization Id : ' || l_header_rec.organization_id );

Line 903: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 5589409, pmarada

899: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',p_header_rec.organization_code);
900: FND_MSG_PUB.Add;
901: RAISE FND_API.G_EXC_ERROR;
902: ELSE
903: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 5589409, pmarada
904: log_msg('Organization Id : ' || l_header_rec.organization_id );
905: END IF;
906: END IF;
907: ELSE

Line 910: FND_MSG_PUB.Add;

906: END IF;
907: ELSE
908: add_header_to_error_stack(p_header_rec);
909: FND_MESSAGE.SET_NAME('GMF','GMF_API_ORGANIZATION_ID_REQ');
910: FND_MSG_PUB.Add;
911: RAISE FND_API.G_EXC_ERROR;
912: END IF;
913: -- End organization validation
914: --

Line 925: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

921: --
922: IF (p_header_rec.inventory_item_id <> FND_API.G_MISS_NUM) AND
923: (p_header_rec.inventory_item_id IS NOT NULL) THEN
924: -- validate inventory_item_id
925: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
926: log_msg('validating inventory_item_id : ' || p_header_rec.inventory_item_id);
927: END IF;
928:
929: IF NOT (GMF_VALIDATIONS_PVT.Validate_inventory_item_Id(p_header_rec.inventory_item_id, p_header_rec.organization_id))

Line 934: FND_MSG_PUB.Add;

930: THEN
931: add_header_to_error_stack(p_header_rec); -- Bug 2659435
932: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ITEM_ID');
933: FND_MESSAGE.SET_TOKEN('ITEM_ID',p_header_rec.inventory_item_id);
934: FND_MSG_PUB.Add;
935: RAISE FND_API.G_EXC_ERROR;
936: END IF;
937: -- Log message if item_number is also passed
938: IF (p_header_rec.item_number <> FND_API.G_MISS_CHAR) AND

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

936: END IF;
937: -- Log message if item_number is also passed
938: IF (p_header_rec.item_number <> FND_API.G_MISS_CHAR) AND
939: (p_header_rec.item_number IS NOT NULL) THEN
940: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
941: add_header_to_error_stack(p_header_rec); -- Bug 2659435
942: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_ITEM_NO');
943: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_header_rec.item_number);
944: FND_MSG_PUB.Add;

Line 944: FND_MSG_PUB.Add;

940: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
941: add_header_to_error_stack(p_header_rec); -- Bug 2659435
942: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_ITEM_NO');
943: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_header_rec.item_number);
944: FND_MSG_PUB.Add;
945: END IF;
946: END IF;
947: ELSIF (p_header_rec.item_number <> FND_API.G_MISS_CHAR) AND
948: (p_header_rec.item_number IS NOT NULL) THEN

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

946: END IF;
947: ELSIF (p_header_rec.item_number <> FND_API.G_MISS_CHAR) AND
948: (p_header_rec.item_number IS NOT NULL) THEN
949: -- Convert item number value into item ID.
950: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
951: log_msg('validating item_number : ' || p_header_rec.item_number);
952: END IF;
953: -- If Organization id is passed as null then assign the derived organization id
954: l_header_rec.organization_id := nvl(p_header_rec.organization_id,l_header_rec.organization_id) ;

Line 963: FND_MSG_PUB.Add;

959: add_header_to_error_stack(p_header_rec); -- Bug 2659435
960: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ITEM_NO');
961: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_header_rec.item_number);
962: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',l_header_rec.organization_id);
963: FND_MSG_PUB.Add;
964: RAISE FND_API.G_EXC_ERROR;
965: ELSE
966: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
967: log_msg('inventory_item_id : ' || l_header_rec.inventory_item_id );

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

962: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',l_header_rec.organization_id);
963: FND_MSG_PUB.Add;
964: RAISE FND_API.G_EXC_ERROR;
965: ELSE
966: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
967: log_msg('inventory_item_id : ' || l_header_rec.inventory_item_id );
968: END IF;
969: END IF;
970: ELSE

Line 973: FND_MSG_PUB.Add;

969: END IF;
970: ELSE
971: add_header_to_error_stack(p_header_rec); -- Bug 2659435
972: FND_MESSAGE.SET_NAME('GMF','GMF_API_ITEM_ID_REQ');
973: FND_MSG_PUB.Add;
974: RAISE FND_API.G_EXC_ERROR;
975: END IF;
976: -- End Item validation
977:

Line 985: IF (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level)

981: ------------------------
982: IF (p_header_rec.cost_type_id <> FND_API.G_MISS_NUM)
983: AND (p_header_rec.cost_type_id IS NOT NULL)
984: THEN
985: IF (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level)
986: THEN
987: log_msg('Validating Cost type Id : ' || p_header_rec.cost_type_id);
988: END IF;
989: -- cost type id should be standard or actual cost type because this API is for Standard and actual cost

Line 996: FND_MSG_PUB.Add;

992: IF GMF_VALIDATIONS_PVT.Validate_Lot_Cost_type_id(p_header_rec.cost_type_id) THEN
993: add_header_to_error_stack(p_header_rec);
994: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_COST_TYPE_ID');
995: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',p_header_rec.cost_type_id);
996: FND_MSG_PUB.Add;
997: RAISE FND_API.G_EXC_ERROR;
998: END IF;
999: -- log a message to ignore if cost method code also passed
1000: IF (p_header_rec.cost_mthd_code <> FND_API.G_MISS_CHAR) AND (p_header_rec.cost_mthd_code IS NOT NULL) THEN

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

997: RAISE FND_API.G_EXC_ERROR;
998: END IF;
999: -- log a message to ignore if cost method code also passed
1000: IF (p_header_rec.cost_mthd_code <> FND_API.G_MISS_CHAR) AND (p_header_rec.cost_mthd_code IS NOT NULL) THEN
1001: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1002: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_COST_TYPE');
1003: FND_MESSAGE.SET_TOKEN('COST_TYPE', p_header_rec.cost_mthd_code);
1004: FND_MSG_PUB.Add;
1005: END IF;

Line 1004: FND_MSG_PUB.Add;

1000: IF (p_header_rec.cost_mthd_code <> FND_API.G_MISS_CHAR) AND (p_header_rec.cost_mthd_code IS NOT NULL) THEN
1001: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1002: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_COST_TYPE');
1003: FND_MESSAGE.SET_TOKEN('COST_TYPE', p_header_rec.cost_mthd_code);
1004: FND_MSG_PUB.Add;
1005: END IF;
1006: END IF;
1007: -- if cost type method code passed
1008: ELSE

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

1008: ELSE
1009: IF (p_header_rec.cost_mthd_code <> FND_API.G_MISS_CHAR)
1010: AND (p_header_rec.cost_mthd_code IS NOT NULL)
1011: THEN
1012: IF (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level) THEN
1013: log_msg('Validating Cost type : ' || p_header_rec.cost_mthd_code);
1014: END IF;
1015: -- call validate lot cost type
1016: l_header_rec.cost_Type_id := GMF_VALIDATIONS_PVT.Validate_Cost_type_Code(p_header_rec.cost_mthd_code);

Line 1026: FND_MSG_PUB.Add;

1022: OR (l_lc_cost_type_id IS NOT NULL ) THEN
1023: add_header_to_error_stack(p_header_rec);
1024: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_COST_TYPE');
1025: FND_MESSAGE.SET_TOKEN('COST_TYPE',p_header_rec.cost_mthd_code);
1026: FND_MSG_PUB.Add;
1027: RAISE FND_API.G_EXC_ERROR;
1028: ELSE
1029: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1030: log_msg('Cost_Type_id : ' || l_header_rec.cost_Type_id );

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

1025: FND_MESSAGE.SET_TOKEN('COST_TYPE',p_header_rec.cost_mthd_code);
1026: FND_MSG_PUB.Add;
1027: RAISE FND_API.G_EXC_ERROR;
1028: ELSE
1029: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1030: log_msg('Cost_Type_id : ' || l_header_rec.cost_Type_id );
1031: END IF;
1032: END IF;
1033: ELSE

Line 1036: FND_MSG_PUB.Add;

1032: END IF;
1033: ELSE
1034: add_header_to_error_stack(p_header_rec);
1035: FND_MESSAGE.SET_NAME('GMF','GMF_API_COST_TYPE_ID_REQ');
1036: FND_MSG_PUB.Add;
1037: RAISE FND_API.G_EXC_ERROR;
1038: END IF;
1039: END IF;
1040: -- End Cost Method Code

Line 1047: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

1043: -- Period Id validation
1044: ------------------------
1045: IF (p_header_rec.period_id <> FND_API.G_MISS_NUM) AND (p_header_rec.period_id IS NOT NULL)
1046: THEN
1047: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
1048: THEN
1049: log_msg('validating Period Id : ' || p_header_rec.period_id);
1050: END IF;
1051: IF NOT GMF_VALIDATIONS_PVT.Validate_period_id(p_header_rec.period_id)

Line 1056: FND_MSG_PUB.Add;

1052: THEN
1053: add_header_to_error_stack(p_header_rec);
1054: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_PERIOD_ID');
1055: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header_rec.period_id);
1056: FND_MSG_PUB.Add;
1057: RAISE FND_API.G_EXC_ERROR;
1058: END IF;
1059: -- If period code also passed then ignore period code
1060: IF ((p_header_rec.calendar_code <> FND_API.G_MISS_CHAR) AND (p_header_rec.calendar_code IS NOT NULL))

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

1058: END IF;
1059: -- If period code also passed then ignore period code
1060: IF ((p_header_rec.calendar_code <> FND_API.G_MISS_CHAR) AND (p_header_rec.calendar_code IS NOT NULL))
1061: AND ((p_header_rec.period_code <> FND_API.G_MISS_CHAR) AND (p_header_rec.period_code IS NOT NULL)) THEN
1062: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1063: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_PERIOD_CODE');
1064: FND_MESSAGE.SET_TOKEN('CALENDAR_CODE', p_header_rec.calendar_code);
1065: FND_MESSAGE.SET_TOKEN('PERIOD_CODE', p_header_rec.period_code);
1066: FND_MSG_PUB.Add;

Line 1066: FND_MSG_PUB.Add;

1062: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1063: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_PERIOD_CODE');
1064: FND_MESSAGE.SET_TOKEN('CALENDAR_CODE', p_header_rec.calendar_code);
1065: FND_MESSAGE.SET_TOKEN('PERIOD_CODE', p_header_rec.period_code);
1066: FND_MSG_PUB.Add;
1067: END IF;
1068: END IF;
1069: -- period code and calendar code are passed instead of period id
1070: ELSE

Line 1074: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

1070: ELSE
1071: IF ((p_header_rec.calendar_code <> FND_API.G_MISS_CHAR) AND (p_header_rec.calendar_code IS NOT NULL))
1072: AND ((p_header_rec.period_code <> FND_API.G_MISS_CHAR) AND (p_header_rec.period_code IS NOT NULL))
1073: THEN
1074: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
1075: THEN
1076: log_msg('Validating Calendar Code : '|| p_header_rec.Calendar_code||' period_code : ' || p_header_rec.period_code);
1077: END IF;
1078: -- if cost type id passed as null then assign derived cost type id to the record

Line 1090: FND_MSG_PUB.Add;

1086: add_header_to_error_stack(p_header_rec);
1087: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_CLDR_PERIOD');
1088: FND_MESSAGE.SET_TOKEN('CALENDAR_CODE',p_header_rec.calendar_code);
1089: FND_MESSAGE.SET_TOKEN('PERIOD_CODE',p_header_rec.period_code);
1090: FND_MSG_PUB.Add;
1091: RAISE FND_API.G_EXC_ERROR;
1092: ELSE
1093: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1094: log_msg('period_id : ' || l_header_rec.period_id );

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

1089: FND_MESSAGE.SET_TOKEN('PERIOD_CODE',p_header_rec.period_code);
1090: FND_MSG_PUB.Add;
1091: RAISE FND_API.G_EXC_ERROR;
1092: ELSE
1093: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1094: log_msg('period_id : ' || l_header_rec.period_id );
1095: END IF;
1096: END IF;
1097: ELSE

Line 1100: FND_MSG_PUB.Add;

1096: END IF;
1097: ELSE
1098: add_header_to_error_stack(p_header_rec);
1099: FND_MESSAGE.SET_NAME('GMF','GMF_API_PERIOD_ID_REQ');
1100: FND_MSG_PUB.Add;
1101: RAISE FND_API.G_EXC_ERROR;
1102: END IF;
1103: END IF;
1104:

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

1110: -- Populate WHO columns
1111: ------------------------
1112: IF (p_header_rec.user_name <> FND_API.G_MISS_CHAR) AND
1113: (p_header_rec.user_name IS NOT NULL) THEN
1114: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1115: log_msg('Validating user name : ' || p_header_rec.user_name);
1116: END IF;
1117: GMA_GLOBAL_GRP.Get_who( p_user_name => p_header_rec.user_name
1118: , x_user_id => l_user_id

Line 1125: FND_MSG_PUB.Add;

1121: IF l_user_id = -1 THEN -- Bug 2681243: GMA changed return status value to -1.
1122: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1123: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_USER_NAME');
1124: FND_MESSAGE.SET_TOKEN('USER_NAME',p_header_rec.user_name);
1125: FND_MSG_PUB.Add;
1126: RAISE FND_API.G_EXC_ERROR;
1127: END IF;
1128:
1129: ELSE

Line 1132: FND_MSG_PUB.Add;

1128:
1129: ELSE
1130: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1131: FND_MESSAGE.SET_NAME('GMF','GMF_API_USER_NAME_REQ');
1132: FND_MSG_PUB.Add;
1133: RAISE FND_API.G_EXC_ERROR;
1134: END IF;
1135: -- End User Name
1136: l_header_rec.organization_id := nvl(p_header_rec.organization_id,l_header_rec.organization_id) ;

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

1143: l_header_rec.cost_type_id := nvl(p_header_rec.cost_type_id,l_header_rec.cost_type_id) ;
1144: l_header_rec.cost_mthd_code := p_header_rec.cost_mthd_code ;
1145: l_header_rec.user_name := p_header_rec.user_name ;
1146:
1147: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1148: log_msg( 'organization_id : ' || l_header_rec.organization_id ) ;
1149: log_msg( 'organization_code : ' || l_header_rec.organization_code ) ;
1150: log_msg( 'inventory_item_id : ' || l_header_rec.inventory_item_id ) ;
1151: log_msg( 'item_number : ' || l_header_rec.item_number ) ;

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

1157: log_msg( 'user_name : ' || l_header_rec.user_name ) ;
1158: END IF;
1159:
1160: /* End of Validations on Header Record */
1161: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1162: log_msg('Calling private API to retrieve records...');
1163: END IF;
1164: GMF_BurdenDetails_PVT.Get_Burden_Details
1165: (

Line 1192: FND_MSG_PUB.Count_And_Get

1188: END IF;
1189: */
1190:
1191: -- Standard call to get message count and if count is 1, get message info.
1192: FND_MSG_PUB.Count_And_Get
1193: ( p_count => x_msg_count ,
1194: p_data => x_msg_data
1195: );
1196:

Line 1201: FND_MSG_PUB.Count_And_Get

1197: EXCEPTION
1198: WHEN FND_API.G_EXC_ERROR THEN
1199: ROLLBACK TO Get_Burden_Details_PUB;
1200: x_return_status := FND_API.G_RET_STS_ERROR ;
1201: FND_MSG_PUB.Count_And_Get
1202: ( p_count => x_msg_count ,
1203: p_data => x_msg_data
1204: );
1205: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1208: FND_MSG_PUB.Count_And_Get

1204: );
1205: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1206: ROLLBACK TO Get_Burden_Details_PUB;
1207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1208: FND_MSG_PUB.Count_And_Get
1209: ( p_count => x_msg_count ,
1210: p_data => x_msg_data
1211: );
1212: WHEN OTHERS THEN

Line 1215: IF FND_MSG_PUB.Check_Msg_Level

1211: );
1212: WHEN OTHERS THEN
1213: ROLLBACK TO Get_Burden_Details_PUB;
1214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1215: IF FND_MSG_PUB.Check_Msg_Level
1216: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1217: THEN
1218: FND_MSG_PUB.Add_Exc_Msg
1219: ( G_PKG_NAME ,

Line 1216: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1212: WHEN OTHERS THEN
1213: ROLLBACK TO Get_Burden_Details_PUB;
1214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1215: IF FND_MSG_PUB.Check_Msg_Level
1216: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1217: THEN
1218: FND_MSG_PUB.Add_Exc_Msg
1219: ( G_PKG_NAME ,
1220: l_api_name

Line 1218: FND_MSG_PUB.Add_Exc_Msg

1214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1215: IF FND_MSG_PUB.Check_Msg_Level
1216: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1217: THEN
1218: FND_MSG_PUB.Add_Exc_Msg
1219: ( G_PKG_NAME ,
1220: l_api_name
1221: );
1222: END IF;

Line 1223: FND_MSG_PUB.Count_And_Get

1219: ( G_PKG_NAME ,
1220: l_api_name
1221: );
1222: END IF;
1223: FND_MSG_PUB.Count_And_Get
1224: ( p_count => x_msg_count ,
1225: p_data => x_msg_data
1226: );
1227: END Get_Burden_Details ;

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

1327: -- use organization code
1328: -- organization id
1329: IF (p_header_rec.organization_id <> FND_API.G_MISS_NUM) AND
1330: (p_header_rec.organization_id IS NOT NULL) THEN
1331: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1332: log_msg('validating organization_id : ' || p_header_rec.organization_id);
1333: END IF;
1334:
1335: IF NOT GMF_VALIDATIONS_PVT.Validate_organization_id(p_header_rec.organization_id)

Line 1340: FND_MSG_PUB.Add;

1336: THEN
1337: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1338: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ORGN_ID');
1339: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',p_header_rec.organization_id);
1340: FND_MSG_PUB.Add;
1341: RAISE FND_API.G_EXC_ERROR;
1342: END IF;
1343:
1344: -- Log message to ignore if organization_Code is also passed

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

1343:
1344: -- Log message to ignore if organization_Code is also passed
1345: IF (p_header_rec.organization_code <> FND_API.G_MISS_CHAR) AND
1346: (p_header_rec.organization_code IS NOT NULL) THEN
1347: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1348: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1349: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_ORGN_CODE');
1350: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',p_header_rec.organization_code);
1351: FND_MSG_PUB.Add;

Line 1351: FND_MSG_PUB.Add;

1347: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1348: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1349: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_ORGN_CODE');
1350: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',p_header_rec.organization_code);
1351: FND_MSG_PUB.Add;
1352: END IF;
1353: END IF;
1354: -- organization code
1355: ELSIF (p_header_rec.organization_code <> FND_API.G_MISS_CHAR) AND

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

1354: -- organization code
1355: ELSIF (p_header_rec.organization_code <> FND_API.G_MISS_CHAR) AND
1356: (p_header_rec.organization_code IS NOT NULL) THEN
1357:
1358: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1359: log_msg('validating organization_code : ' || p_header_rec.organization_code);
1360: END IF;
1361: x_header_rec.organization_id := GMF_VALIDATIONS_PVT.Validate_organization_Code(p_header_rec.organization_code);
1362: IF x_header_rec.organization_id IS NULL THEN

Line 1366: FND_MSG_PUB.Add;

1362: IF x_header_rec.organization_id IS NULL THEN
1363: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1364: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ORGN_CODE');
1365: FND_MESSAGE.SET_TOKEN('ORG_CODE',p_header_rec.organization_code);
1366: FND_MSG_PUB.Add;
1367: RAISE FND_API.G_EXC_ERROR;
1368: ELSE
1369: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 5589409, pmarada
1370: log_msg('Organization Id : ' || x_header_rec.organization_id );

Line 1369: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 5589409, pmarada

1365: FND_MESSAGE.SET_TOKEN('ORG_CODE',p_header_rec.organization_code);
1366: FND_MSG_PUB.Add;
1367: RAISE FND_API.G_EXC_ERROR;
1368: ELSE
1369: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 5589409, pmarada
1370: log_msg('Organization Id : ' || x_header_rec.organization_id );
1371: END IF;
1372: END IF;
1373: ELSE

Line 1376: FND_MSG_PUB.Add;

1372: END IF;
1373: ELSE
1374: add_header_to_error_stack(p_header_rec);
1375: FND_MESSAGE.SET_NAME('GMF','GMF_API_ORGANIZATION_ID_REQ');
1376: FND_MSG_PUB.Add;
1377: RAISE FND_API.G_EXC_ERROR;
1378: END IF;
1379: -- End organization validation
1380: -------------------

Line 1390: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

1386: --
1387: IF (p_header_rec.inventory_item_id <> FND_API.G_MISS_NUM) AND
1388: (p_header_rec.inventory_item_id IS NOT NULL) THEN
1389: -- validate inventory_item_id
1390: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
1391: log_msg('validating inventory_item_id : ' || p_header_rec.inventory_item_id);
1392: END IF;
1393: x_header_rec.organization_id := nvl(p_header_rec.organization_id,x_header_rec.organization_id) ;
1394: IF NOT GMF_VALIDATIONS_PVT.Validate_inventory_item_Id(p_header_rec.inventory_item_id, x_header_rec.organization_id)

Line 1399: FND_MSG_PUB.Add;

1395: THEN
1396: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1397: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ITEM_ID');
1398: FND_MESSAGE.SET_TOKEN('ITEM_ID',p_header_rec.inventory_item_id);
1399: FND_MSG_PUB.Add;
1400: RAISE FND_API.G_EXC_ERROR;
1401: END IF;
1402: -- Log message if item_number is also passed
1403: IF (p_header_rec.item_number <> FND_API.G_MISS_CHAR) AND

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

1401: END IF;
1402: -- Log message if item_number is also passed
1403: IF (p_header_rec.item_number <> FND_API.G_MISS_CHAR) AND
1404: (p_header_rec.item_number IS NOT NULL) THEN
1405: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1406: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1407: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_ITEM_NO');
1408: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_header_rec.item_number);
1409: FND_MSG_PUB.Add;

Line 1409: FND_MSG_PUB.Add;

1405: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1406: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1407: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_ITEM_NO');
1408: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_header_rec.item_number);
1409: FND_MSG_PUB.Add;
1410: END IF;
1411: END IF;
1412: ELSIF (p_header_rec.item_number <> FND_API.G_MISS_CHAR) AND
1413: (p_header_rec.item_number IS NOT NULL) THEN

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

1411: END IF;
1412: ELSIF (p_header_rec.item_number <> FND_API.G_MISS_CHAR) AND
1413: (p_header_rec.item_number IS NOT NULL) THEN
1414: -- Convert item number value into item ID.
1415: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1416: log_msg('validating item_number : ' || p_header_rec.item_number);
1417: END IF;
1418: -- If Organization id is passed as null then assign the derived organization id
1419: x_header_rec.organization_id := nvl(p_header_rec.organization_id,x_header_rec.organization_id) ;

Line 1427: FND_MSG_PUB.Add;

1423: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1424: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ITEM_NO');
1425: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_header_rec.item_number);
1426: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',x_header_rec.organization_id);
1427: FND_MSG_PUB.Add;
1428: RAISE FND_API.G_EXC_ERROR;
1429: ELSE
1430: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1431: log_msg('inventory_item_id : ' || x_header_rec.inventory_item_id );

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

1426: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',x_header_rec.organization_id);
1427: FND_MSG_PUB.Add;
1428: RAISE FND_API.G_EXC_ERROR;
1429: ELSE
1430: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1431: log_msg('inventory_item_id : ' || x_header_rec.inventory_item_id );
1432: END IF;
1433: END IF;
1434: ELSE

Line 1437: FND_MSG_PUB.Add;

1433: END IF;
1434: ELSE
1435: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1436: FND_MESSAGE.SET_NAME('GMF','GMF_API_ITEM_ID_REQ');
1437: FND_MSG_PUB.Add;
1438: RAISE FND_API.G_EXC_ERROR;
1439: END IF;
1440: -- End Item validation
1441:

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

1452: -------------------
1453: IF (p_header_rec.cost_type_id <> FND_API.G_MISS_NUM)
1454: AND (p_header_rec.cost_type_id IS NOT NULL)
1455: THEN
1456: IF (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level) THEN
1457: log_msg('Validating Cost type Id : ' || p_header_rec.cost_type_id);
1458: END IF;
1459: --validate cost type id
1460: -- cost type id should be standard or actual cost type because this API is for Standard and actual cost

Line 1467: FND_MSG_PUB.Add;

1463: IF GMF_VALIDATIONS_PVT.Validate_Lot_Cost_type_id(p_header_rec.cost_type_id) THEN
1464: add_header_to_error_stack(p_header_rec);
1465: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_COST_TYPE_ID');
1466: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',p_header_rec.cost_type_id);
1467: FND_MSG_PUB.Add;
1468: RAISE FND_API.G_EXC_ERROR;
1469: END IF;
1470: -- log a message to ignore if cost method code also passed
1471: IF (p_header_rec.cost_mthd_code <> FND_API.G_MISS_CHAR) AND (p_header_rec.cost_mthd_code IS NOT NULL) THEN

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

1468: RAISE FND_API.G_EXC_ERROR;
1469: END IF;
1470: -- log a message to ignore if cost method code also passed
1471: IF (p_header_rec.cost_mthd_code <> FND_API.G_MISS_CHAR) AND (p_header_rec.cost_mthd_code IS NOT NULL) THEN
1472: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1473: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_COST_TYPE');
1474: FND_MESSAGE.SET_TOKEN('COST_TYPE', p_header_rec.cost_mthd_code);
1475: FND_MSG_PUB.Add;
1476: END IF;

Line 1475: FND_MSG_PUB.Add;

1471: IF (p_header_rec.cost_mthd_code <> FND_API.G_MISS_CHAR) AND (p_header_rec.cost_mthd_code IS NOT NULL) THEN
1472: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1473: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_COST_TYPE');
1474: FND_MESSAGE.SET_TOKEN('COST_TYPE', p_header_rec.cost_mthd_code);
1475: FND_MSG_PUB.Add;
1476: END IF;
1477: END IF;
1478: -- If cost type code is passed then derive the cost type id
1479: ELSE

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

1479: ELSE
1480: IF (p_header_rec.cost_mthd_code <> FND_API.G_MISS_CHAR)
1481: AND (p_header_rec.cost_mthd_code IS NOT NULL)
1482: THEN
1483: IF (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level) THEN
1484: log_msg('Validating Cost type code : ' || p_header_rec.cost_mthd_code);
1485: END IF;
1486: -- Call validate cost type
1487: x_header_rec.cost_Type_id := GMF_VALIDATIONS_PVT.Validate_Cost_type_Code(p_header_rec.cost_mthd_code);

Line 1497: FND_MSG_PUB.Add;

1493: OR (l_lc_cost_type_id IS NOT NULL ) THEN
1494: add_header_to_error_stack(p_header_rec);
1495: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_COST_TYPE');
1496: FND_MESSAGE.SET_TOKEN('COST_TYPE',p_header_rec.cost_mthd_code);
1497: FND_MSG_PUB.Add;
1498: RAISE FND_API.G_EXC_ERROR;
1499: ELSE
1500: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 5589409, pmarada
1501: log_msg('Cost Type Id : ' || x_header_rec.cost_Type_id );

Line 1500: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 5589409, pmarada

1496: FND_MESSAGE.SET_TOKEN('COST_TYPE',p_header_rec.cost_mthd_code);
1497: FND_MSG_PUB.Add;
1498: RAISE FND_API.G_EXC_ERROR;
1499: ELSE
1500: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 5589409, pmarada
1501: log_msg('Cost Type Id : ' || x_header_rec.cost_Type_id );
1502: END IF;
1503: END IF;
1504: ELSE

Line 1507: FND_MSG_PUB.Add;

1503: END IF;
1504: ELSE
1505: add_header_to_error_stack(p_header_rec);
1506: FND_MESSAGE.SET_NAME('GMF','GMF_API_COST_TYPE_ID_REQ');
1507: FND_MSG_PUB.Add;
1508: RAISE FND_API.G_EXC_ERROR;
1509: END IF;
1510: END IF;
1511: -- End Cost Method Code

Line 1518: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

1514: -- Period Id validation
1515: ------------------------
1516: IF (p_header_rec.period_id <> FND_API.G_MISS_NUM) AND (p_header_rec.period_id IS NOT NULL)
1517: THEN
1518: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
1519: log_msg('validating Period Id : ' || p_header_rec.period_id);
1520: END IF;
1521: -- validate period id
1522: IF NOT GMF_VALIDATIONS_PVT.Validate_period_id(p_header_rec.period_id)

Line 1527: FND_MSG_PUB.Add;

1523: THEN
1524: add_header_to_error_stack(p_header_rec);
1525: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_PERIOD_ID');
1526: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header_rec.period_id);
1527: FND_MSG_PUB.Add;
1528: RAISE FND_API.G_EXC_ERROR;
1529: END IF;
1530: -- If period code also passed then ignore period code
1531: IF ((p_header_rec.calendar_code <> FND_API.G_MISS_CHAR) AND (p_header_rec.calendar_code IS NOT NULL))

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

1529: END IF;
1530: -- If period code also passed then ignore period code
1531: IF ((p_header_rec.calendar_code <> FND_API.G_MISS_CHAR) AND (p_header_rec.calendar_code IS NOT NULL))
1532: AND ((p_header_rec.period_code <> FND_API.G_MISS_CHAR) AND (p_header_rec.period_code IS NOT NULL)) THEN
1533: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1534: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_PERIOD_CODE');
1535: FND_MESSAGE.SET_TOKEN('CALENDAR_CODE', p_header_rec.calendar_code);
1536: FND_MESSAGE.SET_TOKEN('PERIOD_CODE', p_header_rec.period_code);
1537: FND_MSG_PUB.Add;

Line 1537: FND_MSG_PUB.Add;

1533: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1534: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_PERIOD_CODE');
1535: FND_MESSAGE.SET_TOKEN('CALENDAR_CODE', p_header_rec.calendar_code);
1536: FND_MESSAGE.SET_TOKEN('PERIOD_CODE', p_header_rec.period_code);
1537: FND_MSG_PUB.Add;
1538: END IF;
1539: END IF;
1540: ELSE
1541: -- period code and calendar code are passed instead of period id

Line 1545: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

1541: -- period code and calendar code are passed instead of period id
1542: IF ((p_header_rec.calendar_code <> FND_API.G_MISS_CHAR) AND (p_header_rec.calendar_code IS NOT NULL))
1543: AND ((p_header_rec.period_code <> FND_API.G_MISS_CHAR) AND (p_header_rec.period_code IS NOT NULL))
1544: THEN
1545: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
1546: log_msg('Validating Calendar Code : '|| p_header_rec.Calendar_code||' period_code : ' || p_header_rec.period_code);
1547: END IF;
1548: -- if cost type id passed as null then assign derived cost type id to the record
1549: -- and pass the derived cost type id for derving to period id

Line 1560: FND_MSG_PUB.Add;

1556: add_header_to_error_stack(p_header_rec);
1557: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_CLDR_PERIOD');
1558: FND_MESSAGE.SET_TOKEN('CALENDAR_CODE',p_header_rec.calendar_code);
1559: FND_MESSAGE.SET_TOKEN('PERIOD_CODE',p_header_rec.period_code);
1560: FND_MSG_PUB.Add;
1561: RAISE FND_API.G_EXC_ERROR;
1562: ELSE
1563: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 5589409, pmarada
1564: log_msg('Period Id : ' || x_header_rec.period_id );

Line 1563: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 5589409, pmarada

1559: FND_MESSAGE.SET_TOKEN('PERIOD_CODE',p_header_rec.period_code);
1560: FND_MSG_PUB.Add;
1561: RAISE FND_API.G_EXC_ERROR;
1562: ELSE
1563: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 5589409, pmarada
1564: log_msg('Period Id : ' || x_header_rec.period_id );
1565: END IF;
1566: END IF;
1567: ELSE

Line 1570: FND_MSG_PUB.Add;

1566: END IF;
1567: ELSE
1568: add_header_to_error_stack(p_header_rec);
1569: FND_MESSAGE.SET_NAME('GMF','GMF_API_PERIOD_ID_REQ');
1570: FND_MSG_PUB.Add;
1571: RAISE FND_API.G_EXC_ERROR;
1572: END IF;
1573: END IF;
1574:

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

1579:
1580: -- Populate WHO columns
1581: IF (p_header_rec.user_name <> FND_API.G_MISS_CHAR) AND
1582: (p_header_rec.user_name IS NOT NULL) THEN
1583: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1584: log_msg('Validating user name : ' || p_header_rec.user_name);
1585: END IF;
1586: GMA_GLOBAL_GRP.Get_who( p_user_name => p_header_rec.user_name
1587: , x_user_id => x_user_id

Line 1594: FND_MSG_PUB.Add;

1590: IF x_user_id = -1 THEN -- Bug 2681243: GMA changed return status value to -1.
1591: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1592: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_USER_NAME');
1593: FND_MESSAGE.SET_TOKEN('USER_NAME',p_header_rec.user_name);
1594: FND_MSG_PUB.Add;
1595: RAISE FND_API.G_EXC_ERROR;
1596: END IF;
1597:
1598: ELSE

Line 1601: FND_MSG_PUB.Add;

1597:
1598: ELSE
1599: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1600: FND_MESSAGE.SET_NAME('GMF','GMF_API_USER_NAME_REQ');
1601: FND_MSG_PUB.Add;
1602: RAISE FND_API.G_EXC_ERROR;
1603: END IF;
1604: -- End User Name
1605:

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

1613: x_header_rec.cost_type_id := nvl(p_header_rec.cost_type_id,x_header_rec.cost_type_id) ;
1614: x_header_rec.cost_mthd_code := p_header_rec.cost_mthd_code ;
1615: x_header_rec.user_name := p_header_rec.user_name ;
1616:
1617: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1618: log_msg( 'organization_id : ' || x_header_rec.organization_id ) ;
1619: log_msg( 'organization_code : ' || x_header_rec.organization_code ) ;
1620: log_msg( 'inventory_item_id : ' || x_header_rec.inventory_item_id ) ;
1621: log_msg( 'item_number : ' || x_header_rec.item_number ) ;

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

1637: FOR i in 1..p_dtl_tbl.count
1638: LOOP
1639: BEGIN
1640:
1641: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1642: log_msg('Record # : ' || i);
1643: END IF;
1644:
1645: -- initialize the local variables

Line 1677: FND_MSG_PUB.Add;

1673: ) THEN
1674: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1675: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_BRDN_UNIQUE_KEY');
1676: FND_MESSAGE.SET_TOKEN('OVERHEADLINE_ID', p_dtl_tbl(i).burdenline_id);
1677: FND_MSG_PUB.Add;
1678: l_burdenline_id := p_dtl_tbl(i).burdenline_id;
1679: ELSE
1680:
1681: --

Line 1713: FND_MSG_PUB.Add;

1709: WHEN NO_DATA_FOUND THEN
1710: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1711: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_BRDN_LINE_ID');
1712: FND_MESSAGE.SET_TOKEN('OVERHEADLINE_ID',p_dtl_tbl(i).burdenline_id);
1713: FND_MSG_PUB.Add;
1714: RAISE e_brdn_dtl;
1715: END;
1716:
1717: GMF_VALIDATIONS_PVT.Validate_Resource(l_resources, l_resource_uom, l_resource_uom_class) ;

Line 1723: FND_MSG_PUB.Add;

1719: IF (l_resource_uom IS NULL) OR (l_resource_uom_class IS NULL) THEN
1720: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1721: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_RESOURCES');
1722: FND_MESSAGE.SET_TOKEN('RESOURCES',p_dtl_tbl(i).resources);
1723: FND_MSG_PUB.Add;
1724: RAISE e_brdn_dtl;
1725: END IF;
1726:
1727: ELSE

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

1732: ------------
1733: IF (p_dtl_tbl(i).resources <> FND_API.G_MISS_CHAR) AND
1734: (p_dtl_tbl(i).resources IS NOT NULL) THEN
1735:
1736: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1737: log_msg('validating resources : '|| p_dtl_tbl(i).resources);
1738: END IF;
1739:
1740: l_resources := p_dtl_tbl(i).resources;

Line 1747: FND_MSG_PUB.Add;

1743: IF (l_resource_uom IS NULL) OR (l_resource_uom_class IS NULL) THEN
1744: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1745: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_RESOURCES');
1746: FND_MESSAGE.SET_TOKEN('RESOURCES',p_dtl_tbl(i).resources);
1747: FND_MSG_PUB.Add;
1748: RAISE e_brdn_dtl;
1749: END IF;
1750: ELSE
1751: add_header_to_error_stack(p_header_rec); -- Bug 2659435

Line 1753: FND_MSG_PUB.Add;

1749: END IF;
1750: ELSE
1751: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1752: FND_MESSAGE.SET_NAME('GMF','GMF_API_RESOURCES_REQ');
1753: FND_MSG_PUB.Add;
1754: RAISE e_brdn_dtl;
1755: END IF;
1756:
1757: --------------

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

1762: -- If both are not sent then raise error.
1763: --
1764: IF (p_dtl_tbl(i).cost_cmpntcls_id <> FND_API.G_MISS_NUM) AND
1765: (p_dtl_tbl(i).cost_cmpntcls_id IS NOT NULL) THEN
1766: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1767: log_msg('validating Cmpt Cls ID('||i||') : '||
1768: p_dtl_tbl(i).cost_cmpntcls_id);
1769: END IF;
1770:

Line 1777: FND_MSG_PUB.Add;

1773: IF l_usage_ind IS NULL THEN
1774: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1775: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_CMPNTCLS_ID');
1776: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID',p_dtl_tbl(i).cost_cmpntcls_id);
1777: FND_MSG_PUB.Add;
1778: RAISE e_brdn_dtl;
1779: ELSIF l_usage_ind <> 2 THEN
1780: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1781: FND_MESSAGE.SET_NAME('GMF','GMF_API_CMPNTCLS_USG_NOT_BRDN');

Line 1783: FND_MSG_PUB.Add;

1779: ELSIF l_usage_ind <> 2 THEN
1780: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1781: FND_MESSAGE.SET_NAME('GMF','GMF_API_CMPNTCLS_USG_NOT_BRDN');
1782: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID',p_dtl_tbl(i).cost_cmpntcls_id);
1783: FND_MSG_PUB.Add;
1784: RAISE e_brdn_dtl;
1785: END IF;
1786:
1787: l_cost_cmpntcls_id := p_dtl_tbl(i).cost_cmpntcls_id ;

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

1788:
1789: -- Log message if cost_cmpntcls_code is also passed
1790: IF (p_dtl_tbl(i).cost_cmpntcls_code <> FND_API.G_MISS_CHAR) AND
1791: (p_dtl_tbl(i).cost_cmpntcls_code IS NOT NULL) THEN
1792: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1793: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1794: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_CMPNTCLS_CODE');
1795: FND_MESSAGE.SET_TOKEN('CMPNTCLS_CODE',p_dtl_tbl(i).cost_cmpntcls_code);
1796: FND_MSG_PUB.Add;

Line 1796: FND_MSG_PUB.Add;

1792: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1793: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1794: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_CMPNTCLS_CODE');
1795: FND_MESSAGE.SET_TOKEN('CMPNTCLS_CODE',p_dtl_tbl(i).cost_cmpntcls_code);
1796: FND_MSG_PUB.Add;
1797: END IF;
1798: END IF;
1799: ELSIF (p_dtl_tbl(i).cost_cmpntcls_code <> FND_API.G_MISS_CHAR) AND
1800: (p_dtl_tbl(i).cost_cmpntcls_code IS NOT NULL) THEN

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

1799: ELSIF (p_dtl_tbl(i).cost_cmpntcls_code <> FND_API.G_MISS_CHAR) AND
1800: (p_dtl_tbl(i).cost_cmpntcls_code IS NOT NULL) THEN
1801: l_cost_cmpntcls_code := p_dtl_tbl(i).cost_cmpntcls_code ;
1802:
1803: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1804: log_msg('validating Cmpt Cls Code('||i||') : ' ||
1805: p_dtl_tbl(i).cost_cmpntcls_code);
1806:
1807: END IF;

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

1810: p_dtl_tbl(i).cost_cmpntcls_code,
1811: l_cost_cmpntcls_id,
1812: l_usage_ind
1813: ) ;
1814: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1815: log_msg('Cmpt Cls Id := ' || l_cost_cmpntcls_id);
1816: END IF;
1817:
1818: IF (l_cost_cmpntcls_id IS NULL) OR (l_usage_ind IS NULL) THEN

Line 1823: FND_MSG_PUB.Add;

1819: -- Conversion failed.
1820: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1821: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_CMPNTCLS_CODE');
1822: FND_MESSAGE.SET_TOKEN('CMPNTCLS_CODE',p_dtl_tbl(i).cost_cmpntcls_code);
1823: FND_MSG_PUB.Add;
1824: RAISE e_brdn_dtl;
1825: ELSIF l_usage_ind <> 2 THEN
1826: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1827: FND_MESSAGE.SET_NAME('GMF','GMF_API_CMPNTCLS_USG_NOT_BRDN');

Line 1829: FND_MSG_PUB.Add;

1825: ELSIF l_usage_ind <> 2 THEN
1826: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1827: FND_MESSAGE.SET_NAME('GMF','GMF_API_CMPNTCLS_USG_NOT_BRDN');
1828: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID',l_cost_cmpntcls_id);
1829: FND_MSG_PUB.Add;
1830: RAISE e_brdn_dtl;
1831: END IF;
1832: ELSE
1833: add_header_to_error_stack(p_header_rec); -- Bug 2659435

Line 1835: FND_MSG_PUB.Add;

1831: END IF;
1832: ELSE
1833: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1834: FND_MESSAGE.SET_NAME('GMF','GMF_API_CMPNTCLS_ID_REQ');
1835: FND_MSG_PUB.Add;
1836: RAISE e_brdn_dtl;
1837: END IF;
1838: -- End CmpntCls Id
1839:

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

1842: ----------------
1843: IF (p_dtl_tbl(i).cost_analysis_code <> FND_API.G_MISS_CHAR) AND
1844: (p_dtl_tbl(i).cost_analysis_code IS NOT NULL) THEN
1845:
1846: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1847: log_msg('validating analysis_code('||i||') : ' || p_dtl_tbl(i).cost_analysis_code);
1848: END IF;
1849: IF NOT GMF_VALIDATIONS_PVT.Validate_Analysis_Code(p_dtl_tbl(i).cost_analysis_code)
1850: THEN

Line 1854: FND_MSG_PUB.Add;

1850: THEN
1851: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1852: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ANALYSIS_CODE');
1853: FND_MESSAGE.SET_TOKEN('ANALYSIS_CODE',p_dtl_tbl(i).cost_analysis_code);
1854: FND_MSG_PUB.Add;
1855: RAISE e_brdn_dtl;
1856: END IF;
1857: ELSE
1858: add_header_to_error_stack(p_header_rec); -- Bug 2659435

Line 1860: FND_MSG_PUB.Add;

1856: END IF;
1857: ELSE
1858: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1859: FND_MESSAGE.SET_NAME('GMF','GMF_API_ANALYSIS_CODE_REQ');
1860: FND_MSG_PUB.Add;
1861: RAISE e_brdn_dtl;
1862: END IF;
1863: -- End Analysis Code
1864:

Line 1893: FND_MSG_PUB.Add;

1889: FND_MESSAGE.SET_TOKEN('RESOURCE',l_resources);
1890: FND_MESSAGE.SET_TOKEN('CMPNTCLS_CODE',p_dtl_tbl(i).cost_cmpntcls_code);
1891: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID',l_cost_cmpntcls_id);
1892: FND_MESSAGE.SET_TOKEN('ALYS_CODE',p_dtl_tbl(i).cost_analysis_code);
1893: FND_MSG_PUB.Add;
1894: RAISE e_brdn_dtl;
1895: END;
1896: END IF;
1897:

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

1908: -- Burden Usage should be > 0
1909: -- In the form the format mask for this is : 999999999D999999999(999,999,999.999999999)
1910: -- To put that check here, the cost should not be >= 1,000,000,000
1911: --
1912: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1913: log_msg('validating Burden Usage : '||p_dtl_tbl(i).burden_usage);
1914: END IF;
1915:
1916: IF (p_dtl_tbl(i).burden_usage <> FND_API.G_MISS_NUM) AND

Line 1931: FND_MSG_PUB.Add;

1927: (nvl(p_dtl_tbl(i).burden_usage,0) >= 1000000000)) THEN
1928: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1929: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_BURDEN_USAGE');
1930: FND_MESSAGE.SET_TOKEN('BURDEN_USAGE',p_dtl_tbl(i).burden_usage);
1931: FND_MSG_PUB.Add;
1932: RAISE e_brdn_dtl;
1933: END IF;
1934: */
1935:

Line 1941: FND_MSG_PUB.Add;

1937: p_operation = 'UPDATE') OR
1938: (p_operation = 'INSERT') THEN
1939: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1940: FND_MESSAGE.SET_NAME('GMF','GMF_API_BURDEN_USAGE_REQ');
1941: FND_MSG_PUB.Add;
1942: RAISE e_brdn_dtl;
1943: END IF;
1944: -- End Burden Usage
1945:

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

1949: -- Item Quantity should be > 0
1950: -- In the form the format mask for this is : 999999999D999999999(999,999,999.999999999)
1951: -- To put that check here, the cost should not be >= 1,000,000,000
1952: --
1953: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1954: log_msg('validating Item Quantity : '||p_dtl_tbl(i).item_qty);
1955: END IF;
1956:
1957: IF (p_dtl_tbl(i).item_qty <> FND_API.G_MISS_NUM) AND

Line 1967: FND_MSG_PUB.Add;

1963: (nvl(p_dtl_tbl(i).item_qty,0) >= 1000000000)) THEN
1964: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1965: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ITEM_QTY');
1966: FND_MESSAGE.SET_TOKEN('ITEM_QTY',p_dtl_tbl(i).item_qty);
1967: FND_MSG_PUB.Add;
1968: RAISE e_brdn_dtl;
1969: END IF;
1970: ELSIF (p_dtl_tbl(i).item_qty = FND_API.G_MISS_NUM AND -- Bug 2659435
1971: p_operation = 'UPDATE') OR

Line 1975: FND_MSG_PUB.Add;

1971: p_operation = 'UPDATE') OR
1972: (p_operation = 'INSERT') THEN
1973: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1974: FND_MESSAGE.SET_NAME('GMF','GMF_API_ITEM_QTY_REQ');
1975: FND_MSG_PUB.Add;
1976: RAISE e_brdn_dtl;
1977: END IF;
1978: -- End Item Quantity
1979:

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

1979:
1980: -----------------------
1981: -- Item Unit of Measure
1982: -----------------------
1983: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1984: log_msg('validating item_uom : ' || p_dtl_tbl(i).item_uom);
1985: END IF;
1986:
1987: IF (p_dtl_tbl(i).item_uom <> FND_API.G_MISS_CHAR) AND

Line 1995: FND_MSG_PUB.Add;

1991: IF NOT GMF_VALIDATIONS_PVT.Validate_Usage_Uom(p_dtl_tbl(i).item_uom) THEN
1992: add_header_to_error_stack(p_header_rec); -- Bug 2659435
1993: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ITEM_UM');
1994: FND_MESSAGE.SET_TOKEN('ITEM_UOM',p_dtl_tbl(i).item_uom);
1995: FND_MSG_PUB.Add;
1996: RAISE e_brdn_dtl;
1997: END IF;
1998:
1999: ELSIF (p_dtl_tbl(i).item_uom = FND_API.G_MISS_CHAR AND -- Bug 2659435

Line 2004: FND_MSG_PUB.Add;

2000: p_operation = 'UPDATE') OR
2001: (p_operation = 'INSERT') THEN
2002: add_header_to_error_stack(p_header_rec); -- Bug 2659435
2003: FND_MESSAGE.SET_NAME('GMF','GMF_API_ITEM_UM_REQ');
2004: FND_MSG_PUB.Add;
2005: RAISE e_brdn_dtl;
2006: END IF;
2007:
2008: --

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

2019: )
2020: ) THEN
2021:
2022: -- Convert item quantity actual item UOM
2023: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
2024: log_msg('Converting Item Qty ' || l_item_qty ||
2025: ' from UOM ' || l_item_uom || ' to UOM ' || l_act_item_uom ||
2026: ' for Item_Id : ' || x_header_rec.inventory_item_id);
2027: END IF;

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

2040: IF l_converted_item_qty = -99999 THEN
2041: RAISE e_brdn_dtl;
2042: End IF;
2043:
2044: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
2045: log_msg('Converted Item Qty : ' || l_converted_item_qty);
2046: END IF;
2047:
2048: EXCEPTION

Line 2055: FND_MSG_PUB.Add;

2051: FND_MESSAGE.SET_NAME('GMF','GMF_API_ITEM_UM_CONV_ERR');
2052: FND_MESSAGE.SET_TOKEN('ITEM_ID', x_header_rec.inventory_item_id); --p_header_rec.item_id); Bug# 1935297
2053: FND_MESSAGE.SET_TOKEN('ITEM_UM',l_item_uom);
2054: FND_MESSAGE.SET_TOKEN('ITEM_ACT_UM',l_act_item_uom);
2055: FND_MSG_PUB.Add;
2056: RAISE e_brdn_dtl;
2057: END ;
2058: END IF ;
2059: -- End Item Unit of Measure

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

2064: -- Burden Quantity should be > 0
2065: -- In the form the format mask for this is : 999999999D999999999(999,999,999.999999999)
2066: -- To put that check here, the cost should not be >= 1,000,000,000
2067: --
2068: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
2069: log_msg('validating Burden Quantity : '||p_dtl_tbl(i).burden_qty);
2070: END IF;
2071:
2072: IF (p_dtl_tbl(i).burden_qty <> FND_API.G_MISS_NUM) AND

Line 2081: FND_MSG_PUB.Add;

2077: (nvl(p_dtl_tbl(i).burden_qty,0) >= 1000000000)) THEN
2078: add_header_to_error_stack(p_header_rec); -- Bug 2659435
2079: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_BURDEN_QTY');
2080: FND_MESSAGE.SET_TOKEN('OVERHEAD_QTY',p_dtl_tbl(i).burden_qty);
2081: FND_MSG_PUB.Add;
2082: RAISE e_brdn_dtl;
2083: END IF;
2084: ELSIF (p_dtl_tbl(i).burden_qty = FND_API.G_MISS_NUM AND -- Bug 2659435
2085: p_operation = 'UPDATE') OR

Line 2089: FND_MSG_PUB.Add;

2085: p_operation = 'UPDATE') OR
2086: (p_operation = 'INSERT') THEN
2087: add_header_to_error_stack(p_header_rec); -- Bug 2659435
2088: FND_MESSAGE.SET_NAME('GMF','GMF_API_BURDEN_QTY_REQ');
2089: FND_MSG_PUB.Add;
2090: RAISE e_brdn_dtl;
2091: END IF;
2092: -- End Burden Quantity
2093:

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

2093:
2094: --------------------------
2095: -- Burden Unit of Measure
2096: --------------------------
2097: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
2098: log_msg('validating burden_uom : ' || p_dtl_tbl(i).burden_uom);
2099: END IF;
2100:
2101: IF (p_dtl_tbl(i).burden_uom <> FND_API.G_MISS_CHAR) AND

Line 2110: FND_MSG_PUB.Add;

2106: IF l_burden_uom_class IS NULL THEN
2107: add_header_to_error_stack(p_header_rec); -- Bug 2659435
2108: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_BURDEN_UM');
2109: FND_MESSAGE.SET_TOKEN('OVERHEAD_UM',p_dtl_tbl(i).burden_uom);
2110: FND_MSG_PUB.Add;
2111: RAISE e_brdn_dtl;
2112: END IF;
2113:
2114: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435

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

2110: FND_MSG_PUB.Add;
2111: RAISE e_brdn_dtl;
2112: END IF;
2113:
2114: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
2115: log_msg('Burden UOM Class : ' || l_burden_uom_class || ' resource UOM Class : ' || l_resource_uom_class);
2116: END IF;
2117:
2118: -- Burden UOM must be of the same type as the resource UOM

Line 2124: FND_MSG_PUB.Add;

2120: add_header_to_error_stack(p_header_rec); -- Bug 2659435
2121: FND_MESSAGE.SET_NAME('GMF','GMF_API_UOM_SAMETYPE_REQ');
2122: FND_MESSAGE.SET_TOKEN('OVERHEAD_UM',p_dtl_tbl(i).burden_uom);
2123: FND_MESSAGE.SET_TOKEN('RESOURCE_UM',l_resource_uom_class);
2124: FND_MSG_PUB.Add;
2125: RAISE e_brdn_dtl;
2126: END IF;
2127: ELSIF (p_dtl_tbl(i).burden_uom = FND_API.G_MISS_CHAR AND -- Bug 2659435
2128: p_operation = 'UPDATE') OR

Line 2132: FND_MSG_PUB.Add;

2128: p_operation = 'UPDATE') OR
2129: (p_operation = 'INSERT') THEN
2130: add_header_to_error_stack(p_header_rec); -- Bug 2659435
2131: FND_MESSAGE.SET_NAME('GMF','GMF_API_BURDEN_UM_REQ');
2132: FND_MSG_PUB.Add;
2133: RAISE e_brdn_dtl;
2134: END IF;
2135: -- End Burden Unit of Measure
2136:

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

2147: ELSIF l_converted_item_qty IS NOT NULL THEN
2148:
2149: -- Convert burden usage to resource uom.
2150: BEGIN
2151: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
2152: log_msg( 'Converting Brdn Usage ' || l_burden_usage ||
2153: ' from UOM ' || l_burden_uom || ' to UOM ' || l_resource_uom);
2154: END IF;
2155: l_converted_burden_qty :=inv_convert.inv_um_convert

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

2159: from_unit => l_burden_uom, -- initial qty to convert
2160: to_unit => l_resource_uom, -- initial Burden UOM to convert from
2161: from_name => NULL,
2162: to_name => NULL);
2163: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
2164: log_msg('Converted Burden Usage : ' || l_converted_burden_qty);
2165: END IF;
2166:
2167: l_burden_factor := ROUND( (l_converted_burden_qty / l_converted_item_qty) * l_burden_qty, 9 );

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

2165: END IF;
2166:
2167: l_burden_factor := ROUND( (l_converted_burden_qty / l_converted_item_qty) * l_burden_qty, 9 );
2168:
2169: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
2170: log_msg('Burden Factor : ' || l_burden_factor);
2171: END IF;
2172:
2173: EXCEPTION

Line 2180: FND_MSG_PUB.Add;

2176: FND_MESSAGE.SET_NAME('GMF','GMF_API_BRDN_UM_CONV_ERR');
2177: FND_MESSAGE.SET_TOKEN('RESOURCES',l_resources); -- Bug 2681243: use local variable.
2178: FND_MESSAGE.SET_TOKEN('OVERHEAD_UM',l_burden_uom);
2179: FND_MESSAGE.SET_TOKEN('RESOURCE_UM',l_resource_uom);
2180: FND_MSG_PUB.Add;
2181: RAISE e_brdn_dtl;
2182: END ;
2183: END IF;
2184:

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

2184:
2185: --------------
2186: -- Delete Mark
2187: --------------
2188: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
2189: log_msg('validating delete_mark('||i||') :' ||
2190: p_dtl_tbl(i).delete_mark);
2191: END IF;
2192:

Line 2199: FND_MSG_PUB.Add;

2195: IF p_dtl_tbl(i).delete_mark NOT IN (0,1) THEN
2196: add_header_to_error_stack(p_header_rec); -- Bug 2659435
2197: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_DELETE_MARK');
2198: FND_MESSAGE.SET_TOKEN('DELETE_MARK',p_dtl_tbl(i).delete_mark);
2199: FND_MSG_PUB.Add;
2200: RAISE e_brdn_dtl;
2201: END IF;
2202: ELSIF (p_dtl_tbl(i).delete_mark = FND_API.G_MISS_NUM AND -- Bug 2659435
2203: p_operation = 'UPDATE') OR

Line 2207: FND_MSG_PUB.Add;

2203: p_operation = 'UPDATE') OR
2204: (p_operation = 'INSERT') THEN
2205: add_header_to_error_stack(p_header_rec); -- Bug 2659435
2206: FND_MESSAGE.SET_NAME('GMF','GMF_API_DELETE_MARK_REQ');
2207: FND_MSG_PUB.Add;
2208: RAISE e_brdn_dtl;
2209: END IF;
2210: IF ((p_operation = 'UPDATE') AND (p_dtl_tbl(i).delete_mark = 1)) THEN
2211: add_header_to_error_stack(p_header_rec); -- Bug 2659435

Line 2213: FND_MSG_PUB.Add;

2209: END IF;
2210: IF ((p_operation = 'UPDATE') AND (p_dtl_tbl(i).delete_mark = 1)) THEN
2211: add_header_to_error_stack(p_header_rec); -- Bug 2659435
2212: FND_MESSAGE.SET_NAME('GMF','GMF_API_CANT_MARK_FOR_PURGE');
2213: FND_MSG_PUB.Add;
2214: RAISE e_brdn_dtl;
2215: END IF;
2216: -- End Delete Mark
2217:

Line 2233: FND_MSG_PUB.Add;

2229: ) THEN
2230: add_header_to_error_stack(p_header_rec); -- Bug 2659435
2231: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_BRDN_UNIQUE_KEY');
2232: FND_MESSAGE.SET_TOKEN('OVERHEADLINE_ID', p_dtl_tbl(i).burdenline_id);
2233: FND_MSG_PUB.Add;
2234: l_burdenline_id := p_dtl_tbl(i).burdenline_id;
2235: END IF ;
2236:
2237: END IF ; -- Main if(after for loop stmt) to check for delete operation and check for burdenline_id.

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

2253: x_dtl_tbl(l_idx).delete_mark := 1 ;
2254: END IF ;
2255: x_brdn_factor_tbl(l_idx).burden_factor:= l_burden_factor ;
2256:
2257: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
2258: log_msg('x_burdenline_id('||l_idx||'): '||x_dtl_tbl(l_idx).burdenline_id);
2259: log_msg('x_resources('||l_idx||'): '||x_dtl_tbl(l_idx).resources);
2260: log_msg('x_cost_cmpntcls_id('||l_idx||'): '||x_dtl_tbl(l_idx).cost_cmpntcls_id);
2261: log_msg('x_cost_cmpntcls_code('||l_idx||'): '|| x_dtl_tbl(l_idx).cost_cmpntcls_code) ;

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

2310: )
2311: IS
2312: BEGIN
2313:
2314: -- IF FND_MSG_PUB.Check_Msg_Level (p_msg_lvl) THEN -- Bug 2659435
2315: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEBUG');
2316: FND_MESSAGE.SET_TOKEN('MSG',p_msg_text);
2317: FND_MSG_PUB.Add;
2318: -- END IF;

Line 2317: FND_MSG_PUB.Add;

2313:
2314: -- IF FND_MSG_PUB.Check_Msg_Level (p_msg_lvl) THEN -- Bug 2659435
2315: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEBUG');
2316: FND_MESSAGE.SET_TOKEN('MSG',p_msg_text);
2317: FND_MSG_PUB.Add;
2318: -- END IF;
2319:
2320: END log_msg ;
2321:

Line 2360: FND_MSG_PUB.Add;

2356: FND_MESSAGE.SET_TOKEN('CALENDAR',p_header.calendar_code);
2357: FND_MESSAGE.SET_TOKEN('PERIOD_CODE',p_header.period_code);
2358: FND_MESSAGE.SET_TOKEN('COSTTYPE_ID',p_header.cost_type_id);
2359: FND_MESSAGE.SET_TOKEN('COST_TYPE',p_header.cost_mthd_code);
2360: FND_MSG_PUB.Add;
2361: END IF;
2362:
2363: END add_header_to_error_stack;
2364: