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_PVT dependencies on FND_API

Line 112: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

108:
109: PROCEDURE Create_Burden_Details
110: (
111: p_api_version IN NUMBER ,
112: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
113: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
114:
115: x_return_status OUT NOCOPY VARCHAR2 ,
116: x_msg_count OUT NOCOPY VARCHAR2 ,

Line 113: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

109: PROCEDURE Create_Burden_Details
110: (
111: p_api_version IN NUMBER ,
112: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
113: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
114:
115: x_return_status OUT NOCOPY VARCHAR2 ,
116: x_msg_count OUT NOCOPY VARCHAR2 ,
117: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 139: IF FND_API.to_Boolean( p_init_msg_list ) THEN

135: -- Standard Start of API savepoint
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.

Line 144: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

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 ,
145: p_api_version ,
146: l_api_name ,
147: G_PKG_NAME )
148: THEN

Line 149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

145: p_api_version ,
146: l_api_name ,
147: G_PKG_NAME )
148: THEN
149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
150: END IF;
151:
152: -- Initialize API return status to success
153: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 153: x_return_status := FND_API.G_RET_STS_SUCCESS;

149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
150: END IF;
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;

Line 189: RAISE FND_API.G_EXC_ERROR;

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
193: INTO l_burdenline_id

Line 287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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 ;
291:

Line 293: IF FND_API.To_Boolean( p_commit ) THEN

289: END ;
290: END LOOP ;
291:
292: -- Standard check of p_commit.
293: IF FND_API.To_Boolean( p_commit ) THEN
294: COMMIT WORK;
295: END IF;
296:
297: -- Standard call to get message count and if count is 1, get message info.

Line 304: WHEN FND_API.G_EXC_ERROR THEN

300: p_data => x_msg_data
301: );
302:
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 ,

Line 306: x_return_status := FND_API.G_RET_STS_ERROR ;

302:
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: );

Line 311: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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
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 ,

Line 313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

309: p_data => x_msg_data
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: );

Line 320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

316: p_data => x_msg_data
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

Line 371: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

367:
368: PROCEDURE Update_Burden_Details
369: (
370: p_api_version IN NUMBER ,
371: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
372: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
373:
374: x_return_status OUT NOCOPY VARCHAR2 ,
375: x_msg_count OUT NOCOPY VARCHAR2 ,

Line 372: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

368: PROCEDURE Update_Burden_Details
369: (
370: p_api_version IN NUMBER ,
371: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
372: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
373:
374: x_return_status OUT NOCOPY VARCHAR2 ,
375: x_msg_count OUT NOCOPY VARCHAR2 ,
376: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 394: IF FND_API.to_Boolean( p_init_msg_list ) THEN

390: -- Standard Start of API savepoint
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.

Line 399: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

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 ,
400: p_api_version ,
401: l_api_name ,
402: G_PKG_NAME )
403: THEN

Line 404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

400: p_api_version ,
401: l_api_name ,
402: G_PKG_NAME )
403: THEN
404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
405: END IF;
406:
407: -- Initialize API return status to success
408: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 408: x_return_status := FND_API.G_RET_STS_SUCCESS;

404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
405: END IF;
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;

Line 432: (p_dtl_tbl(i).burdenline_id <> FND_API.G_MISS_NUM) THEN

428: -- In case of failure error msg will be logged and will continue with the next record
429: --
430: BEGIN
431: IF (p_dtl_tbl(i).burdenline_id IS NOT NULL) AND -- Bug 2659435 OR to AND
432: (p_dtl_tbl(i).burdenline_id <> FND_API.G_MISS_NUM) THEN
433:
434: IF p_dtl_tbl(i).delete_mark = 0 THEN -- Update
435: UPDATE cm_brdn_dtl
436: SET

Line 439: , FND_API.G_MISS_CHAR, NULL

435: UPDATE cm_brdn_dtl
436: SET
437: /* Bug 2659435: key columns should not be changed.
438: resources = decode(p_dtl_tbl(i).resources
439: , FND_API.G_MISS_CHAR, NULL
440: , NULL, resources
441: , p_dtl_tbl(i).resources )
442: , cost_cmpntcls_id = decode(p_dtl_tbl(i).cost_cmpntcls_id
443: , FND_API.G_MISS_NUM, NULL

Line 443: , FND_API.G_MISS_NUM, NULL

439: , FND_API.G_MISS_CHAR, NULL
440: , NULL, resources
441: , p_dtl_tbl(i).resources )
442: , cost_cmpntcls_id = decode(p_dtl_tbl(i).cost_cmpntcls_id
443: , FND_API.G_MISS_NUM, NULL
444: , NULL, cost_cmpntcls_id
445: , p_dtl_tbl(i).cost_cmpntcls_id )
446: , cost_analysis_code= decode(p_dtl_tbl(i).cost_analysis_code
447: , FND_API.G_MISS_CHAR, NULL

Line 447: , FND_API.G_MISS_CHAR, NULL

443: , FND_API.G_MISS_NUM, NULL
444: , NULL, cost_cmpntcls_id
445: , p_dtl_tbl(i).cost_cmpntcls_id )
446: , cost_analysis_code= decode(p_dtl_tbl(i).cost_analysis_code
447: , FND_API.G_MISS_CHAR, NULL
448: , NULL, cost_analysis_code
449: , p_dtl_tbl(i).cost_analysis_code )
450: */
451: burden_usage = decode(p_dtl_tbl(i).burden_usage

Line 452: , FND_API.G_MISS_NUM, NULL

448: , NULL, cost_analysis_code
449: , p_dtl_tbl(i).cost_analysis_code )
450: */
451: burden_usage = decode(p_dtl_tbl(i).burden_usage
452: , FND_API.G_MISS_NUM, NULL
453: , NULL, burden_usage
454: , p_dtl_tbl(i).burden_usage )
455: , item_qty = decode(p_dtl_tbl(i).item_qty
456: , FND_API.G_MISS_NUM, NULL

Line 456: , FND_API.G_MISS_NUM, NULL

452: , FND_API.G_MISS_NUM, NULL
453: , NULL, burden_usage
454: , p_dtl_tbl(i).burden_usage )
455: , item_qty = decode(p_dtl_tbl(i).item_qty
456: , FND_API.G_MISS_NUM, NULL
457: , NULL, item_qty
458: , p_dtl_tbl(i).item_qty )
459: , item_uom = decode(p_dtl_tbl(i).item_uom
460: , FND_API.G_MISS_CHAR, NULL

Line 460: , FND_API.G_MISS_CHAR, NULL

456: , FND_API.G_MISS_NUM, NULL
457: , NULL, item_qty
458: , p_dtl_tbl(i).item_qty )
459: , item_uom = decode(p_dtl_tbl(i).item_uom
460: , FND_API.G_MISS_CHAR, NULL
461: , NULL, item_uom
462: , p_dtl_tbl(i).item_uom )
463: , burden_qty = decode(p_dtl_tbl(i).burden_qty
464: , FND_API.G_MISS_NUM, NULL

Line 464: , FND_API.G_MISS_NUM, NULL

460: , FND_API.G_MISS_CHAR, NULL
461: , NULL, item_uom
462: , p_dtl_tbl(i).item_uom )
463: , burden_qty = decode(p_dtl_tbl(i).burden_qty
464: , FND_API.G_MISS_NUM, NULL
465: , NULL, burden_qty
466: , p_dtl_tbl(i).burden_qty )
467: , burden_uom = decode(p_dtl_tbl(i).burden_uom
468: , FND_API.G_MISS_CHAR, NULL

Line 468: , FND_API.G_MISS_CHAR, NULL

464: , FND_API.G_MISS_NUM, NULL
465: , NULL, burden_qty
466: , p_dtl_tbl(i).burden_qty )
467: , burden_uom = decode(p_dtl_tbl(i).burden_uom
468: , FND_API.G_MISS_CHAR, NULL
469: , NULL, burden_uom
470: , p_dtl_tbl(i).burden_uom )
471: , burden_factor = decode(p_burden_factor_tbl(i).burden_factor
472: , FND_API.G_MISS_NUM, NULL

Line 472: , FND_API.G_MISS_NUM, NULL

468: , FND_API.G_MISS_CHAR, NULL
469: , NULL, burden_uom
470: , p_dtl_tbl(i).burden_uom )
471: , burden_factor = decode(p_burden_factor_tbl(i).burden_factor
472: , FND_API.G_MISS_NUM, NULL
473: , NULL, burden_factor
474: , p_burden_factor_tbl(i).burden_factor )
475: , delete_mark = 0
476: -- , creation_date = sysdate -- Bug 2722404

Line 508: x_return_status := FND_API.G_RET_STS_ERROR ;

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
511: l_no_rows_upd := l_no_rows_upd + 1 ;
512:

Line 530: , FND_API.G_MISS_CHAR, NULL

526: UPDATE cm_brdn_dtl
527: SET
528: /* Bug 2659435: key columns should not be changed.
529: resources = decode(p_dtl_tbl(i).resources
530: , FND_API.G_MISS_CHAR, NULL
531: , NULL, resources
532: , p_dtl_tbl(i).resources )
533: , cost_cmpntcls_id = decode(p_dtl_tbl(i).cost_cmpntcls_id
534: , FND_API.G_MISS_NUM, NULL

Line 534: , FND_API.G_MISS_NUM, NULL

530: , FND_API.G_MISS_CHAR, NULL
531: , NULL, resources
532: , p_dtl_tbl(i).resources )
533: , cost_cmpntcls_id = decode(p_dtl_tbl(i).cost_cmpntcls_id
534: , FND_API.G_MISS_NUM, NULL
535: , NULL, cost_cmpntcls_id
536: , p_dtl_tbl(i).cost_cmpntcls_id )
537: , cost_analysis_code= decode(p_dtl_tbl(i).cost_analysis_code
538: , FND_API.G_MISS_CHAR, NULL

Line 538: , FND_API.G_MISS_CHAR, NULL

534: , FND_API.G_MISS_NUM, NULL
535: , NULL, cost_cmpntcls_id
536: , p_dtl_tbl(i).cost_cmpntcls_id )
537: , cost_analysis_code= decode(p_dtl_tbl(i).cost_analysis_code
538: , FND_API.G_MISS_CHAR, NULL
539: , NULL, cost_analysis_code
540: , p_dtl_tbl(i).cost_analysis_code )
541: */
542: burden_usage = decode(p_dtl_tbl(i).burden_usage

Line 543: , FND_API.G_MISS_NUM, NULL

539: , NULL, cost_analysis_code
540: , p_dtl_tbl(i).cost_analysis_code )
541: */
542: burden_usage = decode(p_dtl_tbl(i).burden_usage
543: , FND_API.G_MISS_NUM, NULL
544: , NULL, burden_usage
545: , p_dtl_tbl(i).burden_usage )
546: , item_qty = decode(p_dtl_tbl(i).item_qty
547: , FND_API.G_MISS_NUM, NULL

Line 547: , FND_API.G_MISS_NUM, NULL

543: , FND_API.G_MISS_NUM, NULL
544: , NULL, burden_usage
545: , p_dtl_tbl(i).burden_usage )
546: , item_qty = decode(p_dtl_tbl(i).item_qty
547: , FND_API.G_MISS_NUM, NULL
548: , NULL, item_qty
549: , p_dtl_tbl(i).item_qty )
550: , item_uom = decode(p_dtl_tbl(i).item_uom
551: , FND_API.G_MISS_CHAR, NULL

Line 551: , FND_API.G_MISS_CHAR, NULL

547: , FND_API.G_MISS_NUM, NULL
548: , NULL, item_qty
549: , p_dtl_tbl(i).item_qty )
550: , item_uom = decode(p_dtl_tbl(i).item_uom
551: , FND_API.G_MISS_CHAR, NULL
552: , NULL, item_uom
553: , p_dtl_tbl(i).item_uom )
554: , burden_qty = decode(p_dtl_tbl(i).burden_qty
555: , FND_API.G_MISS_NUM, NULL

Line 555: , FND_API.G_MISS_NUM, NULL

551: , FND_API.G_MISS_CHAR, NULL
552: , NULL, item_uom
553: , p_dtl_tbl(i).item_uom )
554: , burden_qty = decode(p_dtl_tbl(i).burden_qty
555: , FND_API.G_MISS_NUM, NULL
556: , NULL, burden_qty
557: , p_dtl_tbl(i).burden_qty )
558: , burden_uom = decode(p_dtl_tbl(i).burden_uom
559: , FND_API.G_MISS_CHAR, NULL

Line 559: , FND_API.G_MISS_CHAR, NULL

555: , FND_API.G_MISS_NUM, NULL
556: , NULL, burden_qty
557: , p_dtl_tbl(i).burden_qty )
558: , burden_uom = decode(p_dtl_tbl(i).burden_uom
559: , FND_API.G_MISS_CHAR, NULL
560: , NULL, burden_uom
561: , p_dtl_tbl(i).burden_uom )
562: , burden_factor = decode(p_burden_factor_tbl(i).burden_factor
563: , FND_API.G_MISS_NUM, NULL

Line 563: , FND_API.G_MISS_NUM, NULL

559: , FND_API.G_MISS_CHAR, NULL
560: , NULL, burden_uom
561: , p_dtl_tbl(i).burden_uom )
562: , burden_factor = decode(p_burden_factor_tbl(i).burden_factor
563: , FND_API.G_MISS_NUM, NULL
564: , NULL, burden_factor
565: , p_burden_factor_tbl(i).burden_factor )
566: , delete_mark = 0
567: -- , creation_date = sysdate -- Bug 2722404

Line 616: x_return_status := FND_API.G_RET_STS_ERROR ;

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
619: l_no_rows_upd := l_no_rows_upd + 1 ;
620:

Line 640: (p_dtl_tbl(i).burdenline_id <> FND_API.G_MISS_NUM) THEN

636: EXCEPTION
637: WHEN OTHERS THEN
638: IF p_dtl_tbl(i).delete_mark = 0 THEN -- Update
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

Line 653: (p_dtl_tbl(i).burdenline_id <> FND_API.G_MISS_NUM) THEN

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
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

Line 665: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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 ;
667: END ;
668: END LOOP ;
669:

Line 671: IF FND_API.To_Boolean( p_commit ) THEN

667: END ;
668: END LOOP ;
669:
670: -- Standard check of p_commit.
671: IF FND_API.To_Boolean( p_commit ) THEN
672: COMMIT WORK;
673: END IF;
674:
675: -- Standard call to get message count and if count is 1, get message info.

Line 682: WHEN FND_API.G_EXC_ERROR THEN

678: p_data => x_msg_data
679: );
680:
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 ,

Line 684: x_return_status := FND_API.G_RET_STS_ERROR ;

680:
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: );

Line 689: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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
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 ,

Line 691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

687: p_data => x_msg_data
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: );

Line 698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

694: p_data => x_msg_data
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

Line 746: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

742: -- End of comments
743: PROCEDURE Get_Burden_Details
744: (
745: p_api_version IN NUMBER ,
746: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
747:
748: x_return_status OUT NOCOPY VARCHAR2 ,
749: x_msg_count OUT NOCOPY VARCHAR2 ,
750: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 796: IF FND_API.to_Boolean( p_init_msg_list ) THEN

792:
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.

Line 801: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

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 ,
802: p_api_version ,
803: l_api_name ,
804: G_PKG_NAME )
805: THEN

Line 806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

802: p_api_version ,
803: l_api_name ,
804: G_PKG_NAME )
805: THEN
806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
807: END IF;
808:
809: -- Initialize API return status to success
810: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 810: x_return_status := FND_API.G_RET_STS_SUCCESS;

806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
807: END IF;
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;

Line 844: IF FND_API.To_Boolean( p_commit ) THEN

840:
841:
842: /*
843: -- Standard check of p_commit.
844: IF FND_API.To_Boolean( p_commit ) THEN
845: COMMIT WORK;
846: END IF;
847: */
848:

Line 856: WHEN FND_API.G_EXC_ERROR THEN

852: p_data => x_msg_data
853: );
854:
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 ,

Line 858: x_return_status := FND_API.G_RET_STS_ERROR ;

854:
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: );

Line 863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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
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 ,

Line 865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

861: p_data => x_msg_data
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: );

Line 872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

868: p_data => x_msg_data
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