DBA Data[Home] [Help]

APPS.GMF_BURDENDETAILS_PVT dependencies on FND_MSG_PUB

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

66:
67: -- Global variables
68: G_PKG_NAME CONSTANT VARCHAR2(30) := 'GMF_BurdenDetails_PVT';
69:
70: G_debug_level NUMBER(2) := FND_MSG_PUB.G_Msg_Level_Threshold; -- Use this variable everywhere
71: -- to decide to log a debug msg.
72:
73:
74: --Start of comments

Line 140: FND_MSG_PUB.initialize;

136: SAVEPOINT Create_Burden_Details_PVT ;
137:
138: -- Initialize message list if p_init_msg_list is set to TRUE.
139: IF FND_API.to_Boolean( p_init_msg_list ) THEN
140: FND_MSG_PUB.initialize;
141: END IF;
142:
143: -- Standard call to check for call compatibility.
144: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

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

151:
152: -- Initialize API return status to success
153: x_return_status := FND_API.G_RET_STS_SUCCESS;
154:
155: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
156: log_msg('Beginning Private Create Burden Details API.');
157: END IF;
158:
159: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435

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

155: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
156: log_msg('Beginning Private Create Burden Details API.');
157: END IF;
158:
159: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
160: log_msg('Burden Detail Count : ' || p_dtl_tbl.count);
161: log_msg('Inserting Burden Details for Item ' || p_header_rec.inventory_item_id ||
162: ' organization_id ' || p_header_rec.organization_id || ' organization_code ' || p_header_rec.organization_code ||
163: ' Calendar ' || p_header_rec.calendar_code || ' Period ' || p_header_rec.Period_code ||

Line 188: FND_MSG_PUB.Add;

184: FND_MESSAGE.SET_TOKEN('PERIOD_ID',p_header_rec.period_id);
185: FND_MESSAGE.SET_TOKEN('COST_TYPE_ID',p_header_rec.cost_type_id);
186: FND_MESSAGE.SET_TOKEN('COST_CMPNTCLS_ID',p_dtl_tbl(i).cost_cmpntcls_id);
187: FND_MESSAGE.SET_TOKEN('COST_ANALYSIS_CODE',p_dtl_tbl(i).cost_analysis_code);
188: FND_MSG_PUB.Add;
189: RAISE FND_API.G_EXC_ERROR;
190: END IF;
191:
192: SELECT gem5_burdenline_id_S.NEXTVAL

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

262: , p_dtl_tbl(i).item_uom
263: , p_dtl_tbl(i).burden_uom
264: );
265:
266: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
267: log_msg( '1 row inserted for Resource ' || p_dtl_tbl(i).resources ||
268: ' Cmptcls Id ' || p_dtl_tbl(i).cost_cmpntcls_id || ' Alys Code ' || p_dtl_tbl(i).cost_analysis_code ||
269: ' Burdenline Id ' || l_burdenline_id);
270: END IF;

Line 286: FND_MSG_PUB.Add;

282: FND_MESSAGE.SET_NAME('GMF','GMF_API_BRDN_INSERT_FAILED');
283: FND_MESSAGE.SET_TOKEN('RESOURCE', p_dtl_tbl(i).resources);
284: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_dtl_tbl(i).cost_cmpntcls_id);
285: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_dtl_tbl(i).cost_analysis_code);
286: FND_MSG_PUB.Add;
287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
288: RAISE ;
289: END ;
290: END LOOP ;

Line 298: FND_MSG_PUB.Count_And_Get

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

Line 307: FND_MSG_PUB.Count_And_Get

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

Line 314: FND_MSG_PUB.Count_And_Get

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

Line 321: IF FND_MSG_PUB.Check_Msg_Level

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

Line 322: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 324: FND_MSG_PUB.Add_Exc_Msg

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

Line 329: FND_MSG_PUB.Count_And_Get

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

Line 395: FND_MSG_PUB.initialize;

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

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

406:
407: -- Initialize API return status to success
408: x_return_status := FND_API.G_RET_STS_SUCCESS;
409:
410: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
411: log_msg('Beginning Update Burden Details process.');
412: END IF;
413:
414: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435

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

410: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
411: log_msg('Beginning Update Burden Details process.');
412: END IF;
413:
414: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
415: log_msg('Burden Detail Count : ' || p_dtl_tbl.count);
416: log_msg('Processing Burden Details for Item ' || p_header_rec.inventory_item_id ||
417: ' organization_id ' || p_header_rec.organization_id || ' organization_code ' || p_header_rec.organization_code ||
418: ' Calendar ' || p_header_rec.calendar_code || ' Period ' || p_header_rec.Period_code ||

Line 502: FND_MSG_PUB.Add;

498: IF SQL%NOTFOUND THEN -- burden details not found
499: IF p_dtl_tbl(i).delete_mark = 0 THEN
500: FND_MESSAGE.SET_NAME('GMF','GMF_API_BRDN_NOT_FOUND_FOR_ID');
501: FND_MESSAGE.SET_TOKEN('BURDENLINE_ID', p_dtl_tbl(i).burdenline_id);
502: FND_MSG_PUB.Add;
503: ELSE
504: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEL_BRDN_NOT_FOUND_ID');
505: FND_MESSAGE.SET_TOKEN('OVERHEADLINE_ID', p_dtl_tbl(i).burdenline_id);
506: FND_MSG_PUB.Add;

Line 506: FND_MSG_PUB.Add;

502: FND_MSG_PUB.Add;
503: ELSE
504: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEL_BRDN_NOT_FOUND_ID');
505: FND_MESSAGE.SET_TOKEN('OVERHEADLINE_ID', p_dtl_tbl(i).burdenline_id);
506: FND_MSG_PUB.Add;
507: END IF ;
508: x_return_status := FND_API.G_RET_STS_ERROR ;
509: EXIT ;
510: ELSE

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

510: ELSE
511: l_no_rows_upd := l_no_rows_upd + 1 ;
512:
513: IF p_dtl_tbl(i).delete_mark = 0 THEN
514: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
515: log_msg( '1 row updated for Burdenline Id ' || p_dtl_tbl(i).burdenline_id);
516: END IF;
517: ELSE
518: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435

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

514: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
515: log_msg( '1 row updated for Burdenline Id ' || p_dtl_tbl(i).burdenline_id);
516: END IF;
517: ELSE
518: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
519: log_msg( '1 row deleted for Burdenline Id ' || p_dtl_tbl(i).burdenline_id);
520: END IF;
521: END IF ;
522: END IF ;

Line 608: FND_MSG_PUB.Add;

604: FND_MESSAGE.SET_NAME('GMF','GMF_API_BRDN_NOT_FOUND_FOR_DTL');
605: FND_MESSAGE.SET_TOKEN('RESOURCE', p_dtl_tbl(i).resources);
606: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_dtl_tbl(i).cost_cmpntcls_id);
607: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_dtl_tbl(i).cost_analysis_code);
608: FND_MSG_PUB.Add;
609: ELSE
610: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEL_BRDN_NOT_FOUND_DTL');
611: FND_MESSAGE.SET_TOKEN('RESOURCE', p_dtl_tbl(i).resources);
612: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_dtl_tbl(i).cost_cmpntcls_id);

Line 614: FND_MSG_PUB.Add;

610: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEL_BRDN_NOT_FOUND_DTL');
611: FND_MESSAGE.SET_TOKEN('RESOURCE', p_dtl_tbl(i).resources);
612: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_dtl_tbl(i).cost_cmpntcls_id);
613: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_dtl_tbl(i).cost_analysis_code);
614: FND_MSG_PUB.Add;
615: END IF ;
616: x_return_status := FND_API.G_RET_STS_ERROR ;
617: EXIT ;
618: ELSE

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

618: ELSE
619: l_no_rows_upd := l_no_rows_upd + 1 ;
620:
621: IF p_dtl_tbl(i).delete_mark = 0 THEN
622: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
623: log_msg( '1 row updated for Resource ' || p_dtl_tbl(i).resources ||
624: ' Cmptcls Id ' || p_dtl_tbl(i).cost_cmpntcls_id || ' Alys Code ' || p_dtl_tbl(i).cost_analysis_code);
625: END IF;
626: ELSE

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

623: log_msg( '1 row updated for Resource ' || p_dtl_tbl(i).resources ||
624: ' Cmptcls Id ' || p_dtl_tbl(i).cost_cmpntcls_id || ' Alys Code ' || p_dtl_tbl(i).cost_analysis_code);
625: END IF;
626: ELSE
627: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
628: log_msg( '1 row deleted for Resource ' || p_dtl_tbl(i).resources ||
629: ' Cmptcls Id ' || p_dtl_tbl(i).cost_cmpntcls_id || ' Alys Code ' || p_dtl_tbl(i).cost_analysis_code);
630: END IF;
631: END IF ;

Line 643: FND_MSG_PUB.Add;

639: IF (p_dtl_tbl(i).burdenline_id IS NOT NULL) OR -- burdenline_id is sent
640: (p_dtl_tbl(i).burdenline_id <> FND_API.G_MISS_NUM) THEN
641: FND_MESSAGE.SET_NAME('GMF','GMF_API_BRDN_UPD_FAILED_ID');
642: FND_MESSAGE.SET_TOKEN('OVERHEADLINE_ID','Burdenline Id ' || p_dtl_tbl(i).burdenline_id);
643: FND_MSG_PUB.Add;
644: ELSE
645: FND_MESSAGE.SET_NAME('GMF','GMF_API_BRDN_UPD_FAILED_DTLS');
646: FND_MESSAGE.SET_TOKEN('RESOURCE', p_dtl_tbl(i).resources);
647: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_dtl_tbl(i).cost_cmpntcls_id);

Line 649: FND_MSG_PUB.Add;

645: FND_MESSAGE.SET_NAME('GMF','GMF_API_BRDN_UPD_FAILED_DTLS');
646: FND_MESSAGE.SET_TOKEN('RESOURCE', p_dtl_tbl(i).resources);
647: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_dtl_tbl(i).cost_cmpntcls_id);
648: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_dtl_tbl(i).cost_analysis_code);
649: FND_MSG_PUB.Add;
650: END IF ;
651: ELSE -- delete
652: IF (p_dtl_tbl(i).burdenline_id IS NOT NULL) OR -- burdenline_id is sent
653: (p_dtl_tbl(i).burdenline_id <> FND_API.G_MISS_NUM) THEN

Line 656: FND_MSG_PUB.Add;

652: IF (p_dtl_tbl(i).burdenline_id IS NOT NULL) OR -- burdenline_id is sent
653: (p_dtl_tbl(i).burdenline_id <> FND_API.G_MISS_NUM) THEN
654: FND_MESSAGE.SET_NAME('GMF','GMF_API_BRDN_DEL_FAILED_ID');
655: FND_MESSAGE.SET_TOKEN('OVERHEADLINE_ID','Burdenline Id ' || p_dtl_tbl(i).burdenline_id);
656: FND_MSG_PUB.Add;
657: ELSE
658: FND_MESSAGE.SET_NAME('GMF','GMF_API_BRDN_DEL_FAILED_DTLS');
659: FND_MESSAGE.SET_TOKEN('RESOURCE', p_dtl_tbl(i).resources);
660: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_dtl_tbl(i).cost_cmpntcls_id);

Line 662: FND_MSG_PUB.Add;

658: FND_MESSAGE.SET_NAME('GMF','GMF_API_BRDN_DEL_FAILED_DTLS');
659: FND_MESSAGE.SET_TOKEN('RESOURCE', p_dtl_tbl(i).resources);
660: FND_MESSAGE.SET_TOKEN('CMPNTCLS_ID', p_dtl_tbl(i).cost_cmpntcls_id);
661: FND_MESSAGE.SET_TOKEN('ALYS_CODE', p_dtl_tbl(i).cost_analysis_code);
662: FND_MSG_PUB.Add;
663: END IF ;
664: END IF ;
665: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
666: RAISE ;

Line 676: FND_MSG_PUB.Count_And_Get

672: COMMIT WORK;
673: END IF;
674:
675: -- Standard call to get message count and if count is 1, get message info.
676: FND_MSG_PUB.Count_And_Get
677: ( p_count => x_msg_count ,
678: p_data => x_msg_data
679: );
680:

Line 685: FND_MSG_PUB.Count_And_Get

681: EXCEPTION
682: WHEN FND_API.G_EXC_ERROR THEN
683: ROLLBACK TO Update_Burden_Details_PVT;
684: x_return_status := FND_API.G_RET_STS_ERROR ;
685: FND_MSG_PUB.Count_And_Get
686: ( p_count => x_msg_count ,
687: p_data => x_msg_data
688: );
689: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 692: FND_MSG_PUB.Count_And_Get

688: );
689: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
690: ROLLBACK TO Update_Burden_Details_PVT;
691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
692: FND_MSG_PUB.Count_And_Get
693: ( p_count => x_msg_count ,
694: p_data => x_msg_data
695: );
696: WHEN OTHERS THEN

Line 699: IF FND_MSG_PUB.Check_Msg_Level

695: );
696: WHEN OTHERS THEN
697: ROLLBACK TO Update_Burden_Details_PVT;
698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
699: IF FND_MSG_PUB.Check_Msg_Level
700: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
701: THEN
702: FND_MSG_PUB.Add_Exc_Msg
703: ( G_PKG_NAME ,

Line 700: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

696: WHEN OTHERS THEN
697: ROLLBACK TO Update_Burden_Details_PVT;
698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
699: IF FND_MSG_PUB.Check_Msg_Level
700: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
701: THEN
702: FND_MSG_PUB.Add_Exc_Msg
703: ( G_PKG_NAME ,
704: l_api_name

Line 702: FND_MSG_PUB.Add_Exc_Msg

698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
699: IF FND_MSG_PUB.Check_Msg_Level
700: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
701: THEN
702: FND_MSG_PUB.Add_Exc_Msg
703: ( G_PKG_NAME ,
704: l_api_name
705: );
706: END IF;

Line 707: FND_MSG_PUB.Count_And_Get

703: ( G_PKG_NAME ,
704: l_api_name
705: );
706: END IF;
707: FND_MSG_PUB.Count_And_Get
708: ( p_count => x_msg_count ,
709: p_data => x_msg_data
710: );
711:

Line 797: FND_MSG_PUB.initialize;

793: -- Standard Start of API savepoint
794: SAVEPOINT Get_Burden_Details_PVT;
795: -- Initialize message list if p_init_msg_list is set to TRUE.
796: IF FND_API.to_Boolean( p_init_msg_list ) THEN
797: FND_MSG_PUB.initialize;
798: END IF;
799:
800: -- Standard call to check for call compatibility.
801: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

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

808:
809: -- Initialize API return status to success
810: x_return_status := FND_API.G_RET_STS_SUCCESS;
811:
812: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
813: log_msg('Beginning Private Get Item Cost API.');
814: END IF;
815:
816: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435

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

812: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
813: log_msg('Beginning Private Get Item Cost API.');
814: END IF;
815:
816: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
817: log_msg('Retrieving Burden Details for Item ' || p_header_rec.inventory_item_id ||
818: ' organization_id ' || p_header_rec.organization_id || ' organization_code ' || p_header_rec.organization_code ||
819: ' Calendar ' || p_header_rec.calendar_code || ' Period ' || p_header_rec.Period_code ||
820: ' Mthd ' || p_header_rec.cost_mthd_code ) ;

Line 850: FND_MSG_PUB.Count_And_Get

846: END IF;
847: */
848:
849: -- Standard call to get message count and if count is 1, get message info.
850: FND_MSG_PUB.Count_And_Get
851: ( p_count => x_msg_count ,
852: p_data => x_msg_data
853: );
854:

Line 859: FND_MSG_PUB.Count_And_Get

855: EXCEPTION
856: WHEN FND_API.G_EXC_ERROR THEN
857: ROLLBACK TO Get_Burden_Details_PVT;
858: x_return_status := FND_API.G_RET_STS_ERROR ;
859: FND_MSG_PUB.Count_And_Get
860: ( p_count => x_msg_count ,
861: p_data => x_msg_data
862: );
863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 866: FND_MSG_PUB.Count_And_Get

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

Line 873: IF FND_MSG_PUB.Check_Msg_Level

869: );
870: WHEN OTHERS THEN
871: ROLLBACK TO Get_Burden_Details_PVT;
872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
873: IF FND_MSG_PUB.Check_Msg_Level
874: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
875: THEN
876: FND_MSG_PUB.Add_Exc_Msg
877: ( G_PKG_NAME ,

Line 874: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

870: WHEN OTHERS THEN
871: ROLLBACK TO Get_Burden_Details_PVT;
872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
873: IF FND_MSG_PUB.Check_Msg_Level
874: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
875: THEN
876: FND_MSG_PUB.Add_Exc_Msg
877: ( G_PKG_NAME ,
878: l_api_name

Line 876: FND_MSG_PUB.Add_Exc_Msg

872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
873: IF FND_MSG_PUB.Check_Msg_Level
874: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
875: THEN
876: FND_MSG_PUB.Add_Exc_Msg
877: ( G_PKG_NAME ,
878: l_api_name
879: );
880: END IF;

Line 881: FND_MSG_PUB.Count_And_Get

877: ( G_PKG_NAME ,
878: l_api_name
879: );
880: END IF;
881: FND_MSG_PUB.Count_And_Get
882: ( p_count => x_msg_count ,
883: p_data => x_msg_data
884: );
885: END Get_Burden_Details ;

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

990: )
991: IS
992: BEGIN
993:
994: -- IF FND_MSG_PUB.Check_Msg_Level (p_msg_lvl) THEN -- Bug 2659435
995: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEBUG');
996: FND_MESSAGE.SET_TOKEN('MSG',p_msg_text);
997: FND_MSG_PUB.Add;
998: -- END IF;

Line 997: FND_MSG_PUB.Add;

993:
994: -- IF FND_MSG_PUB.Check_Msg_Level (p_msg_lvl) THEN -- Bug 2659435
995: FND_MESSAGE.SET_NAME('GMF','GMF_API_DEBUG');
996: FND_MESSAGE.SET_TOKEN('MSG',p_msg_text);
997: FND_MSG_PUB.Add;
998: -- END IF;
999:
1000: END log_msg ;
1001: