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

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

127: G_PKG_NAME CONSTANT VARCHAR2(30) := 'GMF_AllocationDefinition_PUB';
128:
129: -- Bug 2659435
130: G_operation VARCHAR2(30); -- values will be Insert, Update or Delete
131: G_tmp BOOLEAN := FND_MSG_PUB.Check_Msg_Level(0) ; -- temp call to initialize the
132: -- msg level threshhold gobal
133: -- variable.
134: G_debug_level NUMBER(2) := FND_MSG_PUB.G_Msg_Level_Threshold; -- Use this variable everywhere
135: -- to decide to log a debug msg.

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

130: G_operation VARCHAR2(30); -- values will be Insert, Update or Delete
131: G_tmp BOOLEAN := FND_MSG_PUB.Check_Msg_Level(0) ; -- temp call to initialize the
132: -- msg level threshhold gobal
133: -- variable.
134: G_debug_level NUMBER(2) := FND_MSG_PUB.G_Msg_Level_Threshold; -- Use this variable everywhere
135: -- to decide to log a debug msg.
136: G_header_logged VARCHAR2(1); -- to indicate whether header is already in
137: -- error stack or not - avoid logging duplicate headers
138:

Line 201: FND_MSG_PUB.initialize;

197: SAVEPOINT Create_Alloc_Definition_PUB;
198:
199: -- Initialize message list if p_init_msg_list is set to TRUE.
200: IF FND_API.to_Boolean( p_init_msg_list ) THEN
201: FND_MSG_PUB.initialize;
202: END IF;
203:
204: -- Standard call to check for call compatibility.
205: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

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

212:
213: -- Initialize API return status to success
214: x_return_status := FND_API.G_RET_STS_SUCCESS;
215:
216: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
217: log_msg('Beginning Create Allocation Definition process.');
218: END IF;
219:
220: G_operation := 'INSERT'; -- Bug 2659435

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

219:
220: G_operation := 'INSERT'; -- Bug 2659435
221: G_header_logged := 'N'; -- to indicate header is logged or not for errors
222:
223: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
224: log_msg('Validating input parameters');
225: END IF;
226:
227: -- Validate all the input parameters.

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

230: x_alloc_def_rec => l_alloc_def_rec,
231: x_user_id => l_user_id,
232: x_return_status => l_return_status) ;
233:
234: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
235: log_msg('Return Status after validating : ' || l_return_status);
236: END IF;
237:
238: -- Return if validation failures detected

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

243: THEN
244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
245: END IF;
246:
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:
251: GMF_AllocationDefinition_PVT.Create_Allocation_Definition

Line 280: FND_MSG_PUB.Add;

276: IF NOT is_fxdpct_hundred(l_alloc_def_rec.alloc_id) THEN
277: add_header_to_error_stack(l_alloc_def_rec); -- Bug 2659435
278: FND_MESSAGE.SET_NAME('GMF','GMF_API_TOTAL_PCT_NOTHUNDRED');
279: FND_MESSAGE.SET_TOKEN('ALLOC_ID',l_alloc_def_rec.alloc_id);
280: FND_MSG_PUB.Add;
281: END IF;
282: END IF;
283:
284: add_header_to_error_stack(l_alloc_def_rec); -- Bug 2659435

Line 287: FND_MSG_PUB.Add;

283:
284: add_header_to_error_stack(l_alloc_def_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 399: FND_MSG_PUB.initialize;

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

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

410:
411: -- Initialize API return status to success
412: x_return_status := FND_API.G_RET_STS_SUCCESS;
413:
414: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
415: log_msg('Beginning Update Allocation Definition process.');
416: END IF;
417:
418: G_operation := 'UPDATE'; -- Bug 2659435

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

421: --
422: -- Line Number.
423: -- Should be not null
424: --
425: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
426: log_msg('validating line_no : '||p_allocation_definition_rec.line_no);
427: END IF;
428:
429: IF (p_allocation_definition_rec.line_no IS NULL) OR

Line 433: FND_MSG_PUB.Add;

429: IF (p_allocation_definition_rec.line_no IS NULL) OR
430: (p_allocation_definition_rec.line_no = FND_API.G_MISS_NUM) THEN -- Bug 2659435
431: add_header_to_error_stack(p_allocation_definition_rec); -- Bug 2659435
432: FND_MESSAGE.SET_NAME('GMF','GMF_API_LINE_NO_REQ');
433: FND_MSG_PUB.Add;
434: RAISE FND_API.G_EXC_ERROR;
435: END IF;
436: -- End Line number
437:

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

435: END IF;
436: -- End Line number
437:
438: -- Validate all the input parameters.
439: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
440: log_msg('Validating input parameters');
441: END IF;
442:
443: VALIDATE_INPUT_PARAMS

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

445: x_alloc_def_rec => l_alloc_def_rec,
446: x_user_id => l_user_id,
447: x_return_status => l_return_status) ;
448:
449: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
450: log_msg('Return Status after validating : ' || l_return_status);
451: END IF;
452:
453: -- Return if validation failures detected

Line 474: FND_MSG_PUB.Add;

470: IF l_cnt = 0 THEN
471: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_FOUND');
472: FND_MESSAGE.SET_TOKEN('ALLOC_ID',l_alloc_def_rec.alloc_id);
473: FND_MESSAGE.SET_TOKEN('LINE_NO', l_alloc_def_rec.line_no);
474: FND_MSG_PUB.Add;
475: RAISE FND_API.G_EXC_ERROR;
476: END IF ;
477: */
478:

Line 485: FND_MSG_PUB.Add;

481: add_header_to_error_stack(l_alloc_def_rec); -- Bug 2659435
482: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_FOUND');
483: FND_MESSAGE.SET_TOKEN('ALLOC_ID',l_alloc_def_rec.alloc_id);
484: FND_MESSAGE.SET_TOKEN('LINE_NO', l_alloc_def_rec.line_no);
485: FND_MSG_PUB.Add;
486: RAISE FND_API.G_EXC_ERROR;
487: END IF ;
488:
489: IF l_alloc_def_rec.delete_mark = 1 THEN

Line 492: FND_MSG_PUB.Add;

488:
489: IF l_alloc_def_rec.delete_mark = 1 THEN
490: add_header_to_error_stack(l_alloc_def_rec); -- Bug 2659435
491: FND_MESSAGE.SET_NAME('GMF','GMF_API_CANT_MARK_FOR_PURGE');
492: FND_MSG_PUB.Add;
493: RAISE FND_API.G_EXC_ERROR;
494: END IF ;
495:
496: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435

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

492: FND_MSG_PUB.Add;
493: RAISE FND_API.G_EXC_ERROR;
494: END IF ;
495:
496: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
497: log_msg('Updating record for alloc_id : ' ||
498: l_alloc_def_rec.alloc_id || ' line_no : ' || l_alloc_def_rec.line_no);
499: END IF;
500:

Line 530: FND_MSG_PUB.Add;

526: IF NOT is_fxdpct_hundred(l_alloc_def_rec.alloc_id) THEN
527: add_header_to_error_stack(l_alloc_def_rec); -- Bug 2659435
528: FND_MESSAGE.SET_NAME('GMF','GMF_API_TOTAL_PCT_NOTHUNDRED');
529: FND_MESSAGE.SET_TOKEN('ALLOC_ID',l_alloc_def_rec.alloc_id);
530: FND_MSG_PUB.Add;
531: END IF;
532: END IF;
533:
534: add_header_to_error_stack(l_alloc_def_rec); -- Bug 2659435

Line 537: FND_MSG_PUB.Add;

533:
534: add_header_to_error_stack(l_alloc_def_rec); -- Bug 2659435
535: FND_MESSAGE.SET_NAME('GMF','GMF_API_ROWS_UPD');
536: FND_MESSAGE.SET_TOKEN('NUM_ROWS',l_no_rows_upd);
537: FND_MSG_PUB.Add;
538:
539: --log_msg( l_no_rows_upd || ' rows updated.');
540:
541: -- Standard check of p_commit.

Line 547: FND_MSG_PUB.Count_And_Get

543: COMMIT WORK;
544: END IF;
545:
546: -- Standard call to get message count and if count is 1, get message info.
547: FND_MSG_PUB.Count_And_Get
548: ( p_count => x_msg_count ,
549: p_data => x_msg_data
550: );
551:

Line 556: FND_MSG_PUB.Count_And_Get

552: EXCEPTION
553: WHEN FND_API.G_EXC_ERROR THEN
554: ROLLBACK TO Update_Alloc_Definition_PUB;
555: x_return_status := FND_API.G_RET_STS_ERROR ;
556: FND_MSG_PUB.Count_And_Get
557: ( p_count => x_msg_count ,
558: p_data => x_msg_data
559: );
560: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 563: FND_MSG_PUB.Count_And_Get

559: );
560: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
561: ROLLBACK TO Update_Alloc_Definition_PUB;
562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
563: FND_MSG_PUB.Count_And_Get
564: ( p_count => x_msg_count ,
565: p_data => x_msg_data
566: );
567: WHEN OTHERS THEN

Line 570: IF FND_MSG_PUB.Check_Msg_Level

566: );
567: WHEN OTHERS THEN
568: ROLLBACK TO Update_Alloc_Definition_PUB;
569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
570: IF FND_MSG_PUB.Check_Msg_Level
571: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
572: THEN
573: FND_MSG_PUB.Add_Exc_Msg
574: ( G_PKG_NAME ,

Line 571: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

567: WHEN OTHERS THEN
568: ROLLBACK TO Update_Alloc_Definition_PUB;
569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
570: IF FND_MSG_PUB.Check_Msg_Level
571: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
572: THEN
573: FND_MSG_PUB.Add_Exc_Msg
574: ( G_PKG_NAME ,
575: l_api_name

Line 573: FND_MSG_PUB.Add_Exc_Msg

569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
570: IF FND_MSG_PUB.Check_Msg_Level
571: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
572: THEN
573: FND_MSG_PUB.Add_Exc_Msg
574: ( G_PKG_NAME ,
575: l_api_name
576: );
577: END IF;

Line 578: FND_MSG_PUB.Count_And_Get

574: ( G_PKG_NAME ,
575: l_api_name
576: );
577: END IF;
578: FND_MSG_PUB.Count_And_Get
579: ( p_count => x_msg_count ,
580: p_data => x_msg_data
581: );
582:

Line 650: FND_MSG_PUB.initialize;

646: SAVEPOINT Delete_Alloc_Definition_PUB;
647:
648: -- Initialize message list if p_init_msg_list is set to TRUE.
649: IF FND_API.to_Boolean( p_init_msg_list ) THEN
650: FND_MSG_PUB.initialize;
651: END IF;
652:
653: -- Standard call to check for call compatibility.
654: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

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

661:
662: -- Initialize API return status to success
663: x_return_status := FND_API.G_RET_STS_SUCCESS;
664:
665: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
666: log_msg('Beginning Delete Allocation Definition process.');
667: END IF;
668:
669: G_header_logged := 'N'; -- Bug 2659435 to indicate header is logged or not for errors

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

667: END IF;
668:
669: G_header_logged := 'N'; -- Bug 2659435 to indicate header is logged or not for errors
670:
671: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
672: log_msg('alloc_id : '|| p_allocation_definition_rec.alloc_id);
673: log_msg('alloc_code : '|| p_allocation_definition_rec.alloc_code);
674: log_msg('legal entity id : '|| p_allocation_definition_rec.legal_entity_id);
675: log_msg('line_no : '|| p_allocation_definition_rec.line_no);

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

680: --
681: -- Line Number.
682: -- Should be not null
683: --
684: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
685: log_msg('validating line_no : '||p_allocation_definition_rec.line_no);
686: END IF;
687:
688: IF (p_allocation_definition_rec.line_no IS NULL) OR

Line 692: FND_MSG_PUB.Add;

688: IF (p_allocation_definition_rec.line_no IS NULL) OR
689: (p_allocation_definition_rec.line_no = FND_API.G_MISS_NUM) THEN -- Bug 2659435
690: add_header_to_error_stack(p_allocation_definition_rec); -- Bug 2659435
691: FND_MESSAGE.SET_NAME('GMF','GMF_API_LINE_NO_REQ');
692: FND_MSG_PUB.Add;
693: RAISE FND_API.G_EXC_ERROR;
694: ELSE
695: l_alloc_def_rec.line_no := p_allocation_definition_rec.line_no ;
696: END IF;

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

705: --
706: IF (p_allocation_definition_rec.alloc_id <> FND_API.G_MISS_NUM) AND
707: (p_allocation_definition_rec.alloc_id IS NOT NULL) THEN
708: -- validate alloc_id
709: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
710: log_msg('validating alloc_id : '||
711: p_allocation_definition_rec.alloc_id);
712: END IF;
713:

Line 718: FND_MSG_PUB.Add;

714: IF NOT GMF_VALIDATIONS_PVT.Validate_Alloc_Id(p_allocation_definition_rec.alloc_id) THEN
715: add_header_to_error_stack(p_allocation_definition_rec); -- Bug 2659435
716: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ALLOC_ID');
717: FND_MESSAGE.SET_TOKEN('ALLOC_ID',p_allocation_definition_rec.alloc_id);
718: FND_MSG_PUB.Add;
719: RAISE FND_API.G_EXC_ERROR;
720: END IF;
721:
722: l_alloc_def_rec.alloc_id := p_allocation_definition_rec.alloc_id ;

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

726: (p_allocation_definition_rec.alloc_code IS NOT NULL)) OR
727: ((p_allocation_definition_rec.legal_entity_id <> FND_API.G_MISS_NUM) AND
728: (p_allocation_definition_rec.legal_entity_id IS NOT NULL))
729: THEN
730: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
731: add_header_to_error_stack(p_allocation_definition_rec); -- Bug 2659435
732: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_ALLOC_CODE');
733: FND_MESSAGE.SET_TOKEN('ALLOC_CODE',p_allocation_definition_rec.alloc_code);
734: FND_MESSAGE.SET_TOKEN('LEGAL_ENTITY',p_allocation_definition_rec.LEGAL_ENTITY_ID);

Line 735: FND_MSG_PUB.Add;

731: add_header_to_error_stack(p_allocation_definition_rec); -- Bug 2659435
732: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_ALLOC_CODE');
733: FND_MESSAGE.SET_TOKEN('ALLOC_CODE',p_allocation_definition_rec.alloc_code);
734: FND_MESSAGE.SET_TOKEN('LEGAL_ENTITY',p_allocation_definition_rec.LEGAL_ENTITY_ID);
735: FND_MSG_PUB.Add;
736: END IF;
737: END IF;
738: ELSIF ((p_allocation_definition_rec.alloc_code <> FND_API.G_MISS_CHAR) AND
739: (p_allocation_definition_rec.alloc_code IS NOT NULL)) AND

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

741: (p_allocation_definition_rec.alloc_code IS NOT NULL)) THEN
742:
743: -- Convert value into ID.
744:
745: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
746: log_msg(
747: 'Fetching alloc_id using alloc_code : '|| p_allocation_definition_rec.alloc_code ||
748: ' legal entity : '|| p_allocation_definition_rec.legal_entity_id);
749: END IF;

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

751: l_alloc_def_rec.alloc_id := GMF_VALIDATIONS_PVT.Fetch_Alloc_Id(
752: p_allocation_definition_rec.alloc_code,
753: p_allocation_definition_rec.legal_entity_id);
754:
755: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
756: log_msg('alloc_id : '|| l_alloc_def_rec.alloc_id);
757: END IF;
758:
759: IF l_alloc_def_rec.alloc_id IS NULL THEN -- Alloc_Id fetch was not successful

Line 765: FND_MSG_PUB.Add;

761: add_header_to_error_stack(l_alloc_def_rec); -- Bug 2659435
762: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ALLOC_CODE');
763: FND_MESSAGE.SET_TOKEN('ALLOC_CODE',p_allocation_definition_rec.alloc_code);
764: FND_MESSAGE.SET_TOKEN('LEGAL_ENTITY',p_allocation_definition_rec.legal_entity_id);
765: FND_MSG_PUB.Add;
766: RAISE FND_API.G_EXC_ERROR;
767: END IF;
768: ELSE
769: add_header_to_error_stack(p_allocation_definition_rec); -- Bug 2659435

Line 771: FND_MSG_PUB.Add;

767: END IF;
768: ELSE
769: add_header_to_error_stack(p_allocation_definition_rec); -- Bug 2659435
770: FND_MESSAGE.SET_NAME('GMF','GMF_API_ALLOC_DTL_REQ');
771: FND_MSG_PUB.Add;
772: RAISE FND_API.G_EXC_ERROR;
773: END IF;
774: -- End Allocation Id
775:

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

772: RAISE FND_API.G_EXC_ERROR;
773: END IF;
774: -- End Allocation Id
775:
776: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
777: log_msg('validating user_name : '|| p_allocation_definition_rec.user_name);
778: END IF;
779:
780: IF (p_allocation_definition_rec.user_name <> FND_API.G_MISS_CHAR) AND

Line 789: FND_MSG_PUB.Add;

785: IF l_user_id = -1 THEN -- Bug 2681243: GMA changed return status value to -1.
786: add_header_to_error_stack(p_allocation_definition_rec); -- Bug 2659435
787: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_USER_NAME');
788: FND_MESSAGE.SET_TOKEN('USER_NAME',p_allocation_definition_rec.user_name);
789: FND_MSG_PUB.Add;
790: RAISE FND_API.G_EXC_ERROR;
791: ELSE
792: l_alloc_def_rec.user_name := p_allocation_definition_rec.user_name;
793: END IF;

Line 797: FND_MSG_PUB.Add;

793: END IF;
794: ELSE
795: add_header_to_error_stack(p_allocation_definition_rec); -- Bug 2659435
796: FND_MESSAGE.SET_NAME('GMF','GMF_API_USER_NAME_REQ');
797: FND_MSG_PUB.Add;
798: RAISE FND_API.G_EXC_ERROR;
799: END IF;
800: -- End User Name
801:

Line 816: FND_MSG_PUB.Add;

812: add_header_to_error_stack(l_alloc_def_rec); -- Bug 2659435
813: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_FOUND');
814: FND_MESSAGE.SET_TOKEN('ALLOC_ID',l_alloc_def_rec.alloc_id);
815: FND_MESSAGE.SET_TOKEN('LINE_NO', l_alloc_def_rec.line_no);
816: FND_MSG_PUB.Add;
817: RAISE FND_API.G_EXC_ERROR;
818: END IF ;
819: */
820:

Line 827: FND_MSG_PUB.Add;

823: add_header_to_error_stack(l_alloc_def_rec); -- Bug 2659435
824: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_FOUND');
825: FND_MESSAGE.SET_TOKEN('ALLOC_ID',l_alloc_def_rec.alloc_id);
826: FND_MESSAGE.SET_TOKEN('LINE_NO', l_alloc_def_rec.line_no);
827: FND_MSG_PUB.Add;
828: RAISE FND_API.G_EXC_ERROR;
829: END IF ;
830:
831: l_alloc_def_rec.delete_mark := 1;

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

829: END IF ;
830:
831: l_alloc_def_rec.delete_mark := 1;
832:
833: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
834: log_msg('deleteing record for alloc_id : ' ||
835: l_alloc_def_rec.alloc_id ||' line_no : ' || l_alloc_def_rec.line_no);
836: END IF;
837:

Line 865: FND_MSG_PUB.Add;

861: IF NOT is_fxdpct_hundred(l_alloc_def_rec.alloc_id) THEN
862: add_header_to_error_stack(l_alloc_def_rec); -- Bug 2659435
863: FND_MESSAGE.SET_NAME('GMF','GMF_API_TOTAL_PCT_NOTHUNDRED');
864: FND_MESSAGE.SET_TOKEN('ALLOC_ID',l_alloc_def_rec.alloc_id);
865: FND_MSG_PUB.Add;
866: END IF;
867: END IF;
868:
869: add_header_to_error_stack(l_alloc_def_rec); -- Bug 2659435

Line 872: FND_MSG_PUB.Add;

868:
869: add_header_to_error_stack(l_alloc_def_rec); -- Bug 2659435
870: FND_MESSAGE.SET_NAME('GMF','GMF_API_ROWS_DEL');
871: FND_MESSAGE.SET_TOKEN('NUM_ROWS',l_no_rows_del);
872: FND_MSG_PUB.Add;
873:
874: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
875: log_msg(l_no_rows_del || ' rows deleted.');
876: END IF;

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

870: FND_MESSAGE.SET_NAME('GMF','GMF_API_ROWS_DEL');
871: FND_MESSAGE.SET_TOKEN('NUM_ROWS',l_no_rows_del);
872: FND_MSG_PUB.Add;
873:
874: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
875: log_msg(l_no_rows_del || ' rows deleted.');
876: END IF;
877:
878: -- Standard check of p_commit.

Line 884: FND_MSG_PUB.Count_And_Get

880: COMMIT WORK;
881: END IF;
882:
883: -- Standard call to get message count and if count is 1, get message info.
884: FND_MSG_PUB.Count_And_Get
885: ( p_count => x_msg_count ,
886: p_data => x_msg_data
887: );
888:

Line 893: FND_MSG_PUB.Count_And_Get

889: EXCEPTION
890: WHEN FND_API.G_EXC_ERROR THEN
891: ROLLBACK TO Delete_Alloc_Definition_PUB;
892: x_return_status := FND_API.G_RET_STS_ERROR ;
893: FND_MSG_PUB.Count_And_Get
894: ( p_count => x_msg_count ,
895: p_data => x_msg_data
896: );
897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 900: FND_MSG_PUB.Count_And_Get

896: );
897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
898: ROLLBACK TO Delete_Alloc_Definition_PUB;
899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
900: FND_MSG_PUB.Count_And_Get
901: ( p_count => x_msg_count ,
902: p_data => x_msg_data
903: );
904: WHEN OTHERS THEN

Line 907: IF FND_MSG_PUB.Check_Msg_Level

903: );
904: WHEN OTHERS THEN
905: ROLLBACK TO Delete_Alloc_Definition_PUB;
906: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
907: IF FND_MSG_PUB.Check_Msg_Level
908: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
909: THEN
910: FND_MSG_PUB.Add_Exc_Msg
911: ( G_PKG_NAME ,

Line 908: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

904: WHEN OTHERS THEN
905: ROLLBACK TO Delete_Alloc_Definition_PUB;
906: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
907: IF FND_MSG_PUB.Check_Msg_Level
908: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
909: THEN
910: FND_MSG_PUB.Add_Exc_Msg
911: ( G_PKG_NAME ,
912: l_api_name

Line 910: FND_MSG_PUB.Add_Exc_Msg

906: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
907: IF FND_MSG_PUB.Check_Msg_Level
908: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
909: THEN
910: FND_MSG_PUB.Add_Exc_Msg
911: ( G_PKG_NAME ,
912: l_api_name
913: );
914: END IF;

Line 915: FND_MSG_PUB.Count_And_Get

911: ( G_PKG_NAME ,
912: l_api_name
913: );
914: END IF;
915: FND_MSG_PUB.Count_And_Get
916: ( p_count => x_msg_count ,
917: p_data => x_msg_data
918: );
919:

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

1000: l_organization_code := p_alloc_def_rec.organization_code;
1001: l_delete_mark := p_alloc_def_rec.delete_mark ;
1002: l_user_name := p_alloc_def_rec.user_name ;
1003:
1004: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1005: log_msg('alloc_id : '|| l_alloc_id);
1006: log_msg('alloc_code : '|| l_alloc_code);
1007: log_msg('legal_entity_id: '|| l_legal_entity_id);
1008: log_msg('alloc_mthd : '||l_alloc_method);

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

1031: --
1032:
1033: IF (l_alloc_id <> FND_API.G_MISS_NUM) AND
1034: (l_alloc_id IS NOT NULL) THEN
1035: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1036: log_msg('validating alloc_id : '|| l_alloc_id);
1037: END IF;
1038:
1039: -- validate alloc_id

Line 1044: FND_MSG_PUB.Add;

1040: IF NOT GMF_VALIDATIONS_PVT.Validate_Alloc_Id(l_alloc_id) THEN
1041: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1042: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ALLOC_ID');
1043: FND_MESSAGE.SET_TOKEN('ALLOC_ID',l_alloc_id);
1044: FND_MSG_PUB.Add;
1045: RAISE FND_API.G_EXC_ERROR;
1046: END IF;
1047:
1048: SELECT legal_entity_id

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

1049: INTO l_legal_entity_id
1050: FROM gl_aloc_mst
1051: WHERE alloc_id = l_alloc_id ;
1052:
1053: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1054: log_msg('legal_entity_id : '|| l_legal_entity_id);
1055: END IF;
1056:
1057: -- Log message if alloc_code and company is also passed

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

1058: IF ((l_alloc_code <> FND_API.G_MISS_CHAR) AND
1059: (l_alloc_code IS NOT NULL)) OR
1060: ((p_alloc_def_rec.legal_entity_id <> FND_API.G_MISS_NUM) AND
1061: (p_alloc_def_rec.legal_entity_id IS NOT NULL)) THEN
1062: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1063: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1064: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_ALLOC_CODE');
1065: FND_MESSAGE.SET_TOKEN('ALLOC_CODE',l_alloc_code);
1066: FND_MESSAGE.SET_TOKEN('LEGAL_ENTITY',p_alloc_def_rec.legal_entity_id);

Line 1067: FND_MSG_PUB.Add;

1063: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1064: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_ALLOC_CODE');
1065: FND_MESSAGE.SET_TOKEN('ALLOC_CODE',l_alloc_code);
1066: FND_MESSAGE.SET_TOKEN('LEGAL_ENTITY',p_alloc_def_rec.legal_entity_id);
1067: FND_MSG_PUB.Add;
1068: --RAISE FND_API.G_EXC_ERROR;
1069: END IF;
1070: END IF;
1071: ELSIF ((l_alloc_code <> FND_API.G_MISS_CHAR) AND

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

1073: ((l_legal_entity_id <> FND_API.G_MISS_NUM) AND
1074: (l_legal_entity_id IS NOT NULL)) THEN
1075:
1076:
1077: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1078: log_msg('Fetching alloc_id using alloc_code : '||
1079: l_alloc_code || ' legal_entity_id : '|| l_legal_entity_id);
1080: END IF;
1081:

Line 1092: FND_MSG_PUB.Add;

1088: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1089: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ALLOC_CODE');
1090: FND_MESSAGE.SET_TOKEN('ALLOC_CODE',l_alloc_code);
1091: FND_MESSAGE.SET_TOKEN('LEGAL_ENTITY',l_legal_entity_id);
1092: FND_MSG_PUB.Add;
1093: RAISE FND_API.G_EXC_ERROR;
1094: END IF;
1095: ELSE
1096: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435

Line 1098: FND_MSG_PUB.Add;

1094: END IF;
1095: ELSE
1096: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1097: FND_MESSAGE.SET_NAME('GMF','GMF_API_ALLOC_DTL_REQ');
1098: FND_MSG_PUB.Add;
1099: RAISE FND_API.G_EXC_ERROR;
1100: END IF;
1101: -- End Allocation Id
1102:

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

1103: --
1104: -- Allocation Method
1105: -- Should be 0 or 1
1106: --
1107: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1108: log_msg('validating alloc_mthd : '||l_alloc_method);
1109: END IF;
1110:
1111: IF (l_alloc_method <> FND_API.G_MISS_NUM) AND

Line 1117: FND_MSG_PUB.Add;

1113: IF (l_alloc_method NOT IN (0,1)) THEN
1114: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1115: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ALLOC_MTHD');
1116: FND_MESSAGE.SET_TOKEN('ALLOC_METHOD',l_alloc_method);
1117: FND_MSG_PUB.Add;
1118: RAISE FND_API.G_EXC_ERROR;
1119: END IF;
1120: ELSE
1121: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435

Line 1123: FND_MSG_PUB.Add;

1119: END IF;
1120: ELSE
1121: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1122: FND_MESSAGE.SET_NAME('GMF','GMF_API_ALLOC_MTHD_REQ');
1123: FND_MSG_PUB.Add;
1124: RAISE FND_API.G_EXC_ERROR;
1125: END IF;
1126: -- End Allocation Method
1127:

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

1129: -- Checks whether alloc def already exists or not. If exist, compare alloc_method.
1130: -- If alloc_method differs raise error.
1131: -- Bug 2659435: was above alloc method check
1132: --
1133: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1134: log_msg('checking for consistency of alloc method...');
1135: END IF;
1136:
1137: IF NOT check_alloc_def(l_alloc_id, l_alloc_method) THEN

Line 1141: FND_MSG_PUB.Add;

1137: IF NOT check_alloc_def(l_alloc_id, l_alloc_method) THEN
1138: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1139: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ALLOC_DEF');
1140: FND_MESSAGE.SET_TOKEN('ALLOC_METHOD',l_alloc_method);
1141: FND_MSG_PUB.Add;
1142: RAISE FND_API.G_EXC_ERROR;
1143: END IF ;
1144:
1145: --Organization Validation

Line 1149: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

1145: --Organization Validation
1146: IF (l_organization_id <> FND_API.G_MISS_NUM)
1147: AND (l_organization_id IS NOT NULL)
1148: THEN
1149: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
1150: THEN
1151: log_msg('Validating organization id: ' || l_organization_id);
1152: END IF;
1153:

Line 1158: FND_MSG_PUB.Add;

1154: IF NOT GMF_VALIDATIONS_PVT.Validate_organization_Id(l_organization_id)
1155: THEN
1156: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ORGN_ID');
1157: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',l_organization_id);
1158: FND_MSG_PUB.Add;
1159: RAISE FND_API.G_EXC_ERROR;
1160: END IF;
1161:
1162: -- Log message if organization_code is also passed

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

1162: -- Log message if organization_code is also passed
1163: IF (l_organization_code <> FND_API.G_MISS_CHAR) AND (l_organization_code IS NOT NULL)
1164: THEN
1165:
1166: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1167: THEN
1168:
1169: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_ORGN_CODE');
1170: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_organization_code);

Line 1171: FND_MSG_PUB.Add;

1167: THEN
1168:
1169: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_ORGN_CODE');
1170: FND_MESSAGE.SET_TOKEN('ORG_CODE',l_organization_code);
1171: FND_MSG_PUB.Add;
1172:
1173: END IF;
1174: END IF;
1175: ELSIF ((l_organization_code <> FND_API.G_MISS_CHAR)AND (l_organization_code IS NOT NULL))

Line 1178: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

1174: END IF;
1175: ELSIF ((l_organization_code <> FND_API.G_MISS_CHAR)AND (l_organization_code IS NOT NULL))
1176: THEN
1177:
1178: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
1179: THEN
1180: log_msg('Validating Organization Code : ' || l_organization_code);
1181: END IF;
1182:

Line 1185: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

1181: END IF;
1182:
1183: l_organization_id := gmf_validations_pvt.validate_organization_code(l_organization_code);
1184:
1185: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
1186: THEN
1187: log_msg('organization_id : ' || l_organization_id);
1188: END IF;
1189:

Line 1194: FND_MSG_PUB.Add;

1190: IF l_organization_id IS NULL
1191: THEN
1192: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ORGN_CODE');
1193: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
1194: FND_MSG_PUB.Add;
1195: RAISE FND_API.G_EXC_ERROR;
1196: END IF;
1197: ELSE
1198:

Line 1200: FND_MSG_PUB.Add;

1196: END IF;
1197: ELSE
1198:
1199: FND_MESSAGE.SET_NAME('GMF','GMF_API_ORGN_ID_REQ');
1200: FND_MSG_PUB.Add;
1201: RAISE FND_API.G_EXC_ERROR;
1202: END IF;
1203:
1204:

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

1212: --
1213: IF (l_item_id <> FND_API.G_MISS_NUM) AND
1214: (l_item_id IS NOT NULL) THEN
1215: -- validate item_id
1216: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1217: log_msg('validating item_id : ' || l_item_id);
1218: END IF;
1219:
1220: IF NOT GMF_VALIDATIONS_PVT.Validate_inventory_item_Id(l_item_id,l_organization_id) THEN

Line 1225: FND_MSG_PUB.Add;

1221: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1222: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ITEM_ID');
1223: FND_MESSAGE.SET_TOKEN('ITEM_ID',l_item_id);
1224: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',l_organization_id);
1225: FND_MSG_PUB.Add;
1226: RAISE FND_API.G_EXC_ERROR;
1227: END IF;
1228:
1229: -- Log message if item_number is also passed

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

1228:
1229: -- Log message if item_number is also passed
1230: IF (l_item_number <> FND_API.G_MISS_CHAR) AND
1231: (l_item_number IS NOT NULL) THEN
1232: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1233: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1234: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_ITEM_NO');
1235: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_number);
1236: FND_MSG_PUB.Add;

Line 1236: FND_MSG_PUB.Add;

1232: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1233: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1234: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_ITEM_NO');
1235: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_number);
1236: FND_MSG_PUB.Add;
1237: END IF;
1238: END IF;
1239: ELSIF (l_item_number <> FND_API.G_MISS_CHAR) AND
1240: (l_item_number IS NOT NULL) THEN

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

1238: END IF;
1239: ELSIF (l_item_number <> FND_API.G_MISS_CHAR) AND
1240: (l_item_number IS NOT NULL) THEN
1241: -- Convert value into ID.
1242: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1243: log_msg('validating item_number : ' || l_item_number);
1244: END IF;
1245:
1246: l_item_id := GMF_VALIDATIONS_PVT.Validate_Item_Number(l_item_number,l_organization_id);

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

1243: log_msg('validating item_number : ' || l_item_number);
1244: END IF;
1245:
1246: l_item_id := GMF_VALIDATIONS_PVT.Validate_Item_Number(l_item_number,l_organization_id);
1247: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1248: log_msg('item_id : ' || l_item_id);
1249: END IF;
1250:
1251: IF l_item_id IS NULL THEN -- item_Id fetch was not successful

Line 1257: FND_MSG_PUB.Add;

1253: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1254: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ITEM_NO');
1255: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_number);
1256: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',l_organization_id);
1257: FND_MSG_PUB.Add;
1258: RAISE FND_API.G_EXC_ERROR;
1259: END IF;
1260: ELSIF (l_item_number = FND_API.G_MISS_CHAR AND -- Bug 2659435
1261: G_operation = 'UPDATE') OR

Line 1265: FND_MSG_PUB.Add;

1261: G_operation = 'UPDATE') OR
1262: (G_operation = 'INSERT') THEN
1263: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1264: FND_MESSAGE.SET_NAME('GMF','GMF_API_ITEM_ID_REQ');
1265: FND_MSG_PUB.Add;
1266: RAISE FND_API.G_EXC_ERROR;
1267: END IF;
1268: -- End Item Id
1269:

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

1271: -- Basis Account Key and Balance Type
1272: -- Validate only when alloc_method = 0 else null.
1273: --
1274: IF l_alloc_method = 0 THEN
1275: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1276: log_msg('validating Basis Acct : '|| l_Basis_account_key);
1277: END IF;
1278:
1279: -- Validate Basis Account Key

Line 1283: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level

1279: -- Validate Basis Account Key
1280: IF (l_basis_account_id <> FND_API.G_MISS_NUM)
1281: AND (l_basis_account_id IS NOT NULL)
1282: THEN
1283: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
1284: THEN
1285: log_msg('Validating basis_account_id: ' || l_basis_account_id);
1286: END IF;
1287:

Line 1292: FND_MSG_PUB.Add;

1288: IF NOT GMF_VALIDATIONS_PVT.Validate_account_Id(l_basis_account_id,l_legal_entity_id)
1289: THEN
1290: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ACCT_ID');
1291: FND_MESSAGE.SET_TOKEN('ACCOUNT_ID',l_basis_account_id);
1292: FND_MSG_PUB.Add;
1293: RAISE FND_API.G_EXC_ERROR;
1294: END IF;
1295:
1296:

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

1296:
1297: IF (l_basis_account_key <> FND_API.G_MISS_CHAR) AND (l_basis_account_key IS NOT NULL)
1298: THEN
1299:
1300: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1301: THEN
1302:
1303: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_ACCT_KEY');
1304: FND_MESSAGE.SET_TOKEN('ACCT_KEY',l_basis_account_key);

Line 1305: FND_MSG_PUB.Add;

1301: THEN
1302:
1303: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_ACCT_KEY');
1304: FND_MESSAGE.SET_TOKEN('ACCT_KEY',l_basis_account_key);
1305: FND_MSG_PUB.Add;
1306:
1307: END IF;
1308: END IF;
1309: ELSIF (l_Basis_account_key <> FND_API.G_MISS_CHAR) AND

Line 1318: FND_MSG_PUB.Add;

1314: IF l_basis_account_id IS NULL THEN -- error in acctg_unit_no
1315: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1316: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ACCT_NO');
1317: FND_MESSAGE.SET_TOKEN('BAS_ACC_KEY',l_Basis_account_key);
1318: FND_MSG_PUB.Add;
1319: RAISE FND_API.G_EXC_ERROR;
1320: END IF;
1321: ELSIF (l_basis_account_key = FND_API.G_MISS_CHAR AND G_operation = 'UPDATE') OR
1322: (G_operation = 'INSERT') THEN

Line 1325: FND_MSG_PUB.Add;

1321: ELSIF (l_basis_account_key = FND_API.G_MISS_CHAR AND G_operation = 'UPDATE') OR
1322: (G_operation = 'INSERT') THEN
1323: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1324: FND_MESSAGE.SET_NAME('GMF','GMF_API_ACCOUNT_ID_REQ');
1325: FND_MSG_PUB.Add;
1326: RAISE FND_API.G_EXC_ERROR;
1327: END IF;
1328: -- End Basis Account Key
1329:

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

1329:
1330: --
1331: -- Balance Type must be 0 = Statistical; 1 = Budget; or 2 = Actual
1332: --
1333: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1334: log_msg('validating Balance Type :'|| l_balance_type);
1335: END IF;
1336:
1337: IF (l_balance_type <> FND_API.G_MISS_NUM) AND

Line 1344: FND_MSG_PUB.Add;

1340: IF (l_balance_type NOT IN (0,1,2) ) THEN
1341: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1342: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_BALANCE_TYPE');
1343: FND_MESSAGE.SET_TOKEN('BALANCE_TYPE',l_balance_type);
1344: FND_MSG_PUB.Add;
1345: RAISE FND_API.G_EXC_ERROR;
1346: END IF;
1347: ELSIF (l_balance_type = FND_API.G_MISS_NUM AND -- Bug 2659435
1348: G_operation = 'UPDATE') OR

Line 1352: FND_MSG_PUB.Add;

1348: G_operation = 'UPDATE') OR
1349: (G_operation = 'INSERT') THEN
1350: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1351: FND_MESSAGE.SET_NAME('GMF','GMF_API_BALANCE_TYPE_REQ');
1352: FND_MSG_PUB.Add;
1353: RAISE FND_API.G_EXC_ERROR;
1354: END IF;
1355: -- End Balance Type
1356:

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

1357: --
1358: -- Basis YTP/PTD must be either 0 = Period To Date Basis Amount or
1359: -- 1 = Year To Date Basis Amount
1360: --
1361: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1362: log_msg('validating Basis YTP/PTD :'|| l_bas_ytd_ptd);
1363: END IF;
1364:
1365: IF (l_bas_ytd_ptd <> FND_API.G_MISS_NUM) AND

Line 1372: FND_MSG_PUB.Add;

1368: IF (l_bas_ytd_ptd NOT IN (0,1) ) THEN
1369: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1370: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_BAS_YTD_PTD');
1371: FND_MESSAGE.SET_TOKEN('BAS_YTD_PTD',l_bas_ytd_ptd);
1372: FND_MSG_PUB.Add;
1373: RAISE FND_API.G_EXC_ERROR;
1374: END IF;
1375: ELSIF (l_bas_ytd_ptd = FND_API.G_MISS_NUM AND -- Bug 2659435
1376: G_operation = 'UPDATE') OR

Line 1380: FND_MSG_PUB.Add;

1376: G_operation = 'UPDATE') OR
1377: (G_operation = 'INSERT') THEN
1378: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1379: FND_MESSAGE.SET_NAME('GMF','GMF_API_BAS_YTD_PTD_REQ');
1380: FND_MSG_PUB.Add;
1381: RAISE FND_API.G_EXC_ERROR;
1382: END IF;
1383: -- End Basis YTP/PTD
1384:

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

1383: -- End Basis YTP/PTD
1384:
1385: IF (l_basis_type <> FND_API.G_MISS_NUM) AND
1386: (l_basis_type IS NOT NULL) THEN
1387: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1388: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1389: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_BASIS_TYPE');
1390: FND_MESSAGE.SET_TOKEN('BASIS_TYPE',l_basis_type);
1391: FND_MSG_PUB.Add;

Line 1391: FND_MSG_PUB.Add;

1387: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1388: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1389: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_BASIS_TYPE');
1390: FND_MESSAGE.SET_TOKEN('BASIS_TYPE',l_basis_type);
1391: FND_MSG_PUB.Add;
1392: END IF;
1393: END IF;
1394: IF (l_fixed_percent <> FND_API.G_MISS_NUM) AND
1395: (l_fixed_percent IS NOT NULL) THEN

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

1392: END IF;
1393: END IF;
1394: IF (l_fixed_percent <> FND_API.G_MISS_NUM) AND
1395: (l_fixed_percent IS NOT NULL) THEN
1396: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1397: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1398: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_FIXED_PERCENT');
1399: FND_MESSAGE.SET_TOKEN('FIXED_PERCENT',l_fixed_percent);
1400: FND_MSG_PUB.Add;

Line 1400: FND_MSG_PUB.Add;

1396: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1397: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1398: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_FIXED_PERCENT');
1399: FND_MESSAGE.SET_TOKEN('FIXED_PERCENT',l_fixed_percent);
1400: FND_MSG_PUB.Add;
1401: END IF;
1402: END IF;
1403:
1404: ELSE -- method = 1

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

1412: --
1413: IF l_alloc_method = 1 THEN
1414: --
1415:
1416: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1417: log_msg('validating basis type :'||l_basis_type);
1418: END IF;
1419:
1420: IF (l_basis_type <> FND_API.G_MISS_NUM) AND(l_basis_type IS NOT NULL) THEN

Line 1425: FND_MSG_PUB.Add;

1421: IF (l_basis_type <> 1) THEN
1422: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1423: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_BASIS_TYPE');
1424: FND_MESSAGE.SET_TOKEN('BASIS_TYPE',l_basis_type);
1425: FND_MSG_PUB.Add;
1426: RAISE FND_API.G_EXC_ERROR;
1427: END IF;
1428: ELSE
1429: l_basis_type := 1;

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

1430: END IF;
1431: -- Fixed percentage must be a valid number between 1 and 100
1432: -- (Used only when Allocation Method = 1).
1433: --
1434: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1435: log_msg('validating fixed percentage :'||l_fixed_percent);
1436: END IF;
1437:
1438: IF (l_fixed_percent <> FND_API.G_MISS_NUM) AND(l_fixed_percent IS NOT NULL) THEN

Line 1443: FND_MSG_PUB.Add;

1439: IF (l_fixed_percent < 0 OR l_fixed_percent > 100) THEN
1440: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1441: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_FIXED_PERCENT');
1442: FND_MESSAGE.SET_TOKEN('FIXED_PERCENT',l_fixed_percent);
1443: FND_MSG_PUB.Add;
1444: RAISE FND_API.G_EXC_ERROR;
1445: END IF;
1446: ELSIF (l_fixed_percent = FND_API.G_MISS_NUM AND G_operation = 'UPDATE') OR
1447: (G_operation = 'INSERT') THEN

Line 1450: FND_MSG_PUB.Add;

1446: ELSIF (l_fixed_percent = FND_API.G_MISS_NUM AND G_operation = 'UPDATE') OR
1447: (G_operation = 'INSERT') THEN
1448: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1449: FND_MESSAGE.SET_NAME('GMF','GMF_API_FIXED_PERCENT_REQ');
1450: FND_MSG_PUB.Add;
1451: RAISE FND_API.G_EXC_ERROR;
1452: END IF;
1453: IF( ((p_alloc_def_rec.basis_account_id <> FND_API.G_MISS_NUM) AND
1454: (p_alloc_def_rec.basis_account_id IS NOT NULL)) OR

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

1458: (p_alloc_def_rec.balance_type IS NOT NULL)) OR
1459: ((p_alloc_def_rec.bas_ytd_ptd <> FND_API.G_MISS_NUM) AND
1460: (p_alloc_def_rec.bas_ytd_ptd IS NOT NULL))
1461: ) THEN
1462: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1463: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1464: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_BASIS');
1465: FND_MSG_PUB.Add;
1466: END IF;

Line 1465: FND_MSG_PUB.Add;

1461: ) THEN
1462: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1463: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1464: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_BASIS');
1465: FND_MSG_PUB.Add;
1466: END IF;
1467: END IF;
1468: ELSE
1469: l_fixed_percent := '' ;

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

1479: -- If both are not sent then raise error.
1480: --
1481: IF (l_cmpntcls_id <> FND_API.G_MISS_NUM) AND
1482: (l_cmpntcls_id IS NOT NULL) THEN
1483: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1484: log_msg('validating Cmpt Cls ID :'|| l_cmpntcls_id);
1485: END IF;
1486:
1487: -- validate CmpntCls Id

Line 1495: FND_MSG_PUB.Add;

1491: IF l_usage_ind IS NULL THEN
1492: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1493: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_CMPNTCLS_ID');
1494: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID',l_cmpntcls_id);
1495: FND_MSG_PUB.Add;
1496: RAISE FND_API.G_EXC_ERROR;
1497: ELSIF l_usage_ind <> 4 THEN
1498: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1499: FND_MESSAGE.SET_NAME('GMF','GMF_API_CMPNTCLS_USG_NOT_ALC');

Line 1501: FND_MSG_PUB.Add;

1497: ELSIF l_usage_ind <> 4 THEN
1498: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1499: FND_MESSAGE.SET_NAME('GMF','GMF_API_CMPNTCLS_USG_NOT_ALC');
1500: FND_MESSAGE.SET_TOKEN('CMPNTCLS',l_cmpntcls_id);
1501: FND_MSG_PUB.Add;
1502: RAISE FND_API.G_EXC_ERROR;
1503: END IF;
1504:
1505: -- Log message if cost_cmpntcls_code is also passed

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

1504:
1505: -- Log message if cost_cmpntcls_code is also passed
1506: IF (p_alloc_def_rec.cost_cmpntcls_code <> FND_API.G_MISS_CHAR) AND
1507: (p_alloc_def_rec.cost_cmpntcls_code IS NOT NULL) THEN
1508: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1509: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1510: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_CMPNTCLS_CODE');
1511: FND_MESSAGE.SET_TOKEN('CMPNTCLS_CODE',p_alloc_def_rec.cost_cmpntcls_code);
1512: FND_MSG_PUB.Add;

Line 1512: FND_MSG_PUB.Add;

1508: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1509: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1510: FND_MESSAGE.SET_NAME('GMF','GMF_API_IGNORE_CMPNTCLS_CODE');
1511: FND_MESSAGE.SET_TOKEN('CMPNTCLS_CODE',p_alloc_def_rec.cost_cmpntcls_code);
1512: FND_MSG_PUB.Add;
1513: END IF;
1514: END IF;
1515: ELSIF (l_cost_cmpntcls_code <> FND_API.G_MISS_CHAR) AND
1516: (l_cost_cmpntcls_code IS NOT NULL) THEN

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

1513: END IF;
1514: END IF;
1515: ELSIF (l_cost_cmpntcls_code <> FND_API.G_MISS_CHAR) AND
1516: (l_cost_cmpntcls_code IS NOT NULL) THEN
1517: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1518: log_msg('validating Cmpt Cls Code :'|| l_cost_cmpntcls_code);
1519: END IF;
1520:
1521: -- Convert value into ID.

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

1523: l_cost_cmpntcls_code,
1524: l_cmpntcls_id,
1525: l_usage_ind
1526: ) ;
1527: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1528: log_msg('Cmpt Cls Id := ' || l_cmpntcls_id);
1529: END IF;
1530:
1531: IF (l_cmpntcls_id IS NULL) OR (l_usage_ind IS NULL) THEN -- Cmpntcls_Id fetch was not successful

Line 1536: FND_MSG_PUB.Add;

1532: -- Conversion failed.
1533: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1534: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_CMPNTCLS_CODE');
1535: FND_MESSAGE.SET_TOKEN('CMPNTCLS_CODE',l_cost_cmpntcls_code);
1536: FND_MSG_PUB.Add;
1537: RAISE FND_API.G_EXC_ERROR;
1538: ELSIF l_usage_ind <> 4 THEN
1539: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1540: FND_MESSAGE.SET_NAME('GMF','GMF_API_CMPNTCLS_USG_NOT_ALC');

Line 1542: FND_MSG_PUB.Add;

1538: ELSIF l_usage_ind <> 4 THEN
1539: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1540: FND_MESSAGE.SET_NAME('GMF','GMF_API_CMPNTCLS_USG_NOT_ALC');
1541: FND_MESSAGE.SET_TOKEN('CMPNTCLS',l_cost_cmpntcls_code);
1542: FND_MSG_PUB.Add;
1543: RAISE FND_API.G_EXC_ERROR;
1544: END IF;
1545: ELSIF (l_cmpntcls_id = FND_API.G_MISS_NUM AND -- Bug 2659435
1546: G_operation = 'UPDATE') OR

Line 1550: FND_MSG_PUB.Add;

1546: G_operation = 'UPDATE') OR
1547: (G_operation = 'INSERT') THEN
1548: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1549: FND_MESSAGE.SET_NAME('GMF','GMF_API_CMPNTCLS_ID_REQ');
1550: FND_MSG_PUB.Add;
1551: RAISE FND_API.G_EXC_ERROR;
1552: END IF;
1553: -- End CmpntCls Id
1554:

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

1554:
1555: --
1556: -- Analysis Code
1557: --
1558: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1559: log_msg('validating analysis_code :' || l_analysis_code);
1560: END IF;
1561:
1562: IF (l_analysis_code <> FND_API.G_MISS_CHAR) AND

Line 1569: FND_MSG_PUB.Add;

1565: THEN
1566: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1567: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_ANALYSIS_CODE');
1568: FND_MESSAGE.SET_TOKEN('ANALYSIS_CODE',l_analysis_code);
1569: FND_MSG_PUB.Add;
1570: RAISE FND_API.G_EXC_ERROR;
1571: END IF;
1572: ELSIF (l_analysis_code = FND_API.G_MISS_CHAR AND -- Bug 2659435
1573: G_operation = 'UPDATE') OR

Line 1577: FND_MSG_PUB.Add;

1573: G_operation = 'UPDATE') OR
1574: (G_operation = 'INSERT') THEN
1575: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1576: FND_MESSAGE.SET_NAME('GMF','GMF_API_ANALYSIS_CODE_REQ');
1577: FND_MSG_PUB.Add;
1578: RAISE FND_API.G_EXC_ERROR;
1579: END IF;
1580: -- End Analysis Code
1581: --

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

1582: -- Delete Mark
1583: --
1584: IF (l_delete_mark <> FND_API.G_MISS_NUM) AND
1585: (l_delete_mark IS NOT NULL) THEN
1586: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1587: log_msg('validating delete_mark :' || l_delete_mark);
1588: END IF;
1589:
1590: IF l_delete_mark NOT IN (0,1) THEN

Line 1594: FND_MSG_PUB.Add;

1590: IF l_delete_mark NOT IN (0,1) THEN
1591: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1592: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_DELETE_MARK');
1593: FND_MESSAGE.SET_TOKEN('DELETE_MARK',l_delete_mark);
1594: FND_MSG_PUB.Add;
1595: RAISE FND_API.G_EXC_ERROR;
1596: END IF;
1597: ELSIF (l_delete_mark = FND_API.G_MISS_NUM AND G_operation = 'UPDATE') OR
1598: (G_operation = 'INSERT') THEN

Line 1601: FND_MSG_PUB.Add;

1597: ELSIF (l_delete_mark = FND_API.G_MISS_NUM AND G_operation = 'UPDATE') OR
1598: (G_operation = 'INSERT') THEN
1599: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1600: FND_MESSAGE.SET_NAME('GMF','GMF_API_DELETE_MARK_REQ');
1601: FND_MSG_PUB.Add;
1602: RAISE FND_API.G_EXC_ERROR;
1603: END IF;
1604: -- End Delete Mark
1605:

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

1603: END IF;
1604: -- End Delete Mark
1605:
1606: -- Populate WHO columns
1607: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1608: log_msg('Validating user name : ' || l_user_name);
1609: END IF;
1610:
1611: IF (l_user_name <> FND_API.G_MISS_CHAR) AND

Line 1621: FND_MSG_PUB.Add;

1617: IF l_user_id = -1 THEN -- Bug 2681243: GMA changed return status value to -1.
1618: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1619: FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_USER_NAME');
1620: FND_MESSAGE.SET_TOKEN('USER_NAME',l_user_name);
1621: FND_MSG_PUB.Add;
1622: RAISE FND_API.G_EXC_ERROR;
1623: END IF;
1624: ELSE
1625: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435

Line 1627: FND_MSG_PUB.Add;

1623: END IF;
1624: ELSE
1625: add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435
1626: FND_MESSAGE.SET_NAME('GMF','GMF_API_USER_NAME_REQ');
1627: FND_MSG_PUB.Add;
1628: RAISE FND_API.G_EXC_ERROR;
1629: END IF;
1630: -- End User Name
1631:

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

1760: OPEN Cur_gl_aloc_bas(p_alloc_id);
1761: FETCH Cur_gl_aloc_bas INTO l_fixed_percent;
1762: CLOSE Cur_gl_aloc_bas;
1763:
1764: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
1765: log_msg('Total fixed percent : '||to_char(l_fixed_percent));
1766: END IF;
1767:
1768: IF (l_fixed_percent) = 100 THEN

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

1852: )
1853: IS
1854: BEGIN
1855:
1856: -- IF FND_MSG_PUB.Check_Msg_Level (p_msg_lvl) THEN Bug 2659435
1857: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEBUG');
1858: FND_MESSAGE.SET_TOKEN('MSG',p_msg_text);
1859: FND_MSG_PUB.Add;
1860: -- END IF; Bug 2659435

Line 1859: FND_MSG_PUB.Add;

1855:
1856: -- IF FND_MSG_PUB.Check_Msg_Level (p_msg_lvl) THEN Bug 2659435
1857: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEBUG');
1858: FND_MESSAGE.SET_TOKEN('MSG',p_msg_text);
1859: FND_MSG_PUB.Add;
1860: -- END IF; Bug 2659435
1861:
1862: END log_msg ;
1863:

Line 1900: FND_MSG_PUB.Add;

1896: FND_MESSAGE.SET_TOKEN('ITEM_ID',p_header.item_id);
1897: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_header.item_number);
1898: FND_MESSAGE.SET_TOKEN('CMPNT_CLASS_ID',p_header.cmpntcls_id);
1899: FND_MESSAGE.SET_TOKEN('CMPNT_CLASS_CODE',p_header.cmpntcls_id);
1900: FND_MSG_PUB.Add;
1901: END IF;
1902:
1903: END add_header_to_error_stack;
1904: