DBA Data[Home] [Help]

APPS.GMF_ACTUAL_COST_ADJUSTMENT_PVT dependencies on FND_API

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

98: ********************************************************************/
99: PROCEDURE CREATE_ACTUAL_COST_ADJUSTMENT
100: (
101: p_api_version IN NUMBER,
102: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
103: x_return_status OUT NOCOPY VARCHAR2,
104: x_msg_count OUT NOCOPY NUMBER,
105: x_msg_data OUT NOCOPY VARCHAR2,
106: p_adjustment_rec IN OUT NOCOPY GMF_ACTUAL_COST_ADJUSTMENT_PUB.ADJUSTMENT_REC_TYPE

Line 127: IF FND_API.to_Boolean( p_init_msg_list )

123:
124: /*************************************************************
125: * Initialize message list if p_init_msg_list is set to TRUE. *
126: *************************************************************/
127: IF FND_API.to_Boolean( p_init_msg_list )
128: THEN
129: FND_MSG_PUB.initialize;
130: END IF;
131:

Line 135: IF NOT FND_API.Compatible_API_Call

131:
132: /*************************************************
133: * Standard call to check for call compatibility. *
134: *************************************************/
135: IF NOT FND_API.Compatible_API_Call
136: (
137: l_api_version,
138: p_api_version,
139: l_api_name,

Line 143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

139: l_api_name,
140: G_PKG_NAME
141: )
142: THEN
143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
144: END IF;
145:
146: /******************************************
147: * Initialize API return status to success *

Line 149: x_return_status := FND_API.G_RET_STS_SUCCESS;

145:
146: /******************************************
147: * Initialize API return status to success *
148: ******************************************/
149: x_return_status := FND_API.G_RET_STS_SUCCESS;
150:
151: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
152: THEN
153: log_msg('Beginning Private Create Actual Cost Adjustment API');

Line 326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

322: FND_MESSAGE.SET_TOKEN('PERIOD_ID', p_adjustment_rec.period_id);
323: FND_MESSAGE.SET_TOKEN('COST_CMPNT_CLS', p_adjustment_rec.cost_cmpntcls_id);
324: FND_MESSAGE.SET_TOKEN('COST_ANALYSIS_CODE', p_adjustment_rec.cost_analysis_code);
325: FND_MSG_PUB.Add;
326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
327: RAISE ;
328: END;
329:
330: ELSIF p_adjustment_rec.cost_adjust_id IS NOT NULL

Line 355: WHEN FND_API.G_EXC_ERROR THEN

351: p_count => x_msg_count
352: , p_data => x_msg_data
353: );
354: EXCEPTION
355: WHEN FND_API.G_EXC_ERROR THEN
356: ROLLBACK TO CREATE_ACT_COST_ADJUSTMENT_PVT;
357: x_return_status := FND_API.G_RET_STS_ERROR ;
358: FND_MSG_PUB.Count_And_Get (
359: p_count => x_msg_count

Line 357: x_return_status := FND_API.G_RET_STS_ERROR ;

353: );
354: EXCEPTION
355: WHEN FND_API.G_EXC_ERROR THEN
356: ROLLBACK TO CREATE_ACT_COST_ADJUSTMENT_PVT;
357: x_return_status := FND_API.G_RET_STS_ERROR ;
358: FND_MSG_PUB.Count_And_Get (
359: p_count => x_msg_count
360: , p_data => x_msg_data
361: );

Line 362: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

358: FND_MSG_PUB.Count_And_Get (
359: p_count => x_msg_count
360: , p_data => x_msg_data
361: );
362: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
363: ROLLBACK TO CREATE_ACT_COST_ADJUSTMENT_PVT;
364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
365: FND_MSG_PUB.Count_And_Get (
366: p_count => x_msg_count

Line 364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

360: , p_data => x_msg_data
361: );
362: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
363: ROLLBACK TO CREATE_ACT_COST_ADJUSTMENT_PVT;
364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
365: FND_MSG_PUB.Count_And_Get (
366: p_count => x_msg_count
367: , p_data => x_msg_data
368: );

Line 371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

367: , p_data => x_msg_data
368: );
369: WHEN OTHERS THEN
370: ROLLBACK TO CREATE_ACT_COST_ADJUSTMENT_PVT;
371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
372: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
373: FND_MSG_PUB.Add_Exc_Msg (
374: G_PKG_NAME
375: , l_api_name

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

412:
413: PROCEDURE UPDATE_ACTUAL_COST_ADJUSTMENT
414: (
415: p_api_version IN NUMBER,
416: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
417: x_return_status OUT NOCOPY VARCHAR2,
418: x_msg_count OUT NOCOPY NUMBER,
419: x_msg_data OUT NOCOPY VARCHAR2,
420: p_adjustment_rec IN OUT NOCOPY GMF_ACTUAL_COST_ADJUSTMENT_PUB.ADJUSTMENT_REC_TYPE

Line 441: IF FND_API.to_Boolean( p_init_msg_list )

437:
438: /*************************************************************
439: * Initialize message list if p_init_msg_list is set to TRUE. *
440: *************************************************************/
441: IF FND_API.to_Boolean( p_init_msg_list )
442: THEN
443: FND_MSG_PUB.initialize;
444: END IF;
445:

Line 449: IF NOT FND_API.Compatible_API_Call

445:
446: /*************************************************
447: * Standard call to check for call compatibility. *
448: *************************************************/
449: IF NOT FND_API.Compatible_API_Call
450: (
451: l_api_version,
452: p_api_version,
453: l_api_name,

Line 457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

453: l_api_name,
454: G_PKG_NAME
455: )
456: THEN
457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
458: END IF;
459:
460: /******************************************
461: * Initialize API return status to success *

Line 463: x_return_status := FND_API.G_RET_STS_SUCCESS;

459:
460: /******************************************
461: * Initialize API return status to success *
462: ******************************************/
463: x_return_status := FND_API.G_RET_STS_SUCCESS;
464:
465: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
466: THEN
467: log_msg('Beginning Private Update Actual Cost Adjustment API');

Line 497: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

493: WHEN OTHERS THEN
494: FND_MESSAGE.SET_NAME('GMF','GMF_API_ACA_UPD_FAILED');
495: FND_MESSAGE.SET_TOKEN('COST_ADJUST_ID', p_adjustment_rec.cost_adjust_id);
496: FND_MSG_PUB.Add;
497: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
498: RAISE ;
499: END ;
500: ELSIF p_adjustment_rec.cost_adjust_id IS NULL
501: THEN

Line 518: WHEN FND_API.G_EXC_ERROR THEN

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

Line 520: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 525: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

530: , p_data => x_msg_data
531: );
532: WHEN OTHERS THEN
533: ROLLBACK TO UPDATE_ACT_COST_ADJUSTMENT_PVT;
534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
535: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
536: THEN
537: FND_MSG_PUB.Add_Exc_Msg (
538: G_PKG_NAME

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

576:
577: PROCEDURE DELETE_ACTUAL_COST_ADJUSTMENT
578: (
579: p_api_version IN NUMBER,
580: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
581: x_return_status OUT NOCOPY VARCHAR2,
582: x_msg_count OUT NOCOPY NUMBER,
583: x_msg_data OUT NOCOPY VARCHAR2,
584: p_adjustment_rec IN OUT NOCOPY GMF_ACTUAL_COST_ADJUSTMENT_PUB.ADJUSTMENT_REC_TYPE

Line 605: IF FND_API.to_Boolean( p_init_msg_list )

601:
602: /*************************************************************
603: * Initialize message list if p_init_msg_list is set to TRUE. *
604: *************************************************************/
605: IF FND_API.to_Boolean( p_init_msg_list )
606: THEN
607: FND_MSG_PUB.initialize;
608: END IF;
609:

Line 613: IF NOT FND_API.Compatible_API_Call

609:
610: /*************************************************
611: * Standard call to check for call compatibility. *
612: *************************************************/
613: IF NOT FND_API.Compatible_API_Call
614: (
615: l_api_version,
616: p_api_version,
617: l_api_name,

Line 621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

617: l_api_name,
618: G_PKG_NAME
619: )
620: THEN
621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
622: END IF;
623:
624: /******************************************
625: * Initialize API return status to success *

Line 627: x_return_status := FND_API.G_RET_STS_SUCCESS;

623:
624: /******************************************
625: * Initialize API return status to success *
626: ******************************************/
627: x_return_status := FND_API.G_RET_STS_SUCCESS;
628:
629: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
630: THEN
631: log_msg('Beginning Private Delete Actual Cost Adjustment API');

Line 649: x_return_status := FND_API.G_RET_STS_ERROR ;

645: IF SQL%NOTFOUND THEN
646: FND_MESSAGE.SET_NAME('GMF','GMF_API_ACA_DEL_FAILED');
647: FND_MESSAGE.SET_TOKEN('ADJUST_ID', p_adjustment_rec.cost_adjust_id);
648: FND_MSG_PUB.Add;
649: x_return_status := FND_API.G_RET_STS_ERROR ;
650: RAISE FND_API.G_EXC_ERROR;
651: END IF;
652: EXCEPTION
653: WHEN OTHERS THEN

Line 650: RAISE FND_API.G_EXC_ERROR;

646: FND_MESSAGE.SET_NAME('GMF','GMF_API_ACA_DEL_FAILED');
647: FND_MESSAGE.SET_TOKEN('ADJUST_ID', p_adjustment_rec.cost_adjust_id);
648: FND_MSG_PUB.Add;
649: x_return_status := FND_API.G_RET_STS_ERROR ;
650: RAISE FND_API.G_EXC_ERROR;
651: END IF;
652: EXCEPTION
653: WHEN OTHERS THEN
654: IF (p_adjustment_rec.cost_adjust_id IS NOT NULL) OR (p_adjustment_rec.cost_adjust_id <> FND_API.G_MISS_NUM)

Line 654: IF (p_adjustment_rec.cost_adjust_id IS NOT NULL) OR (p_adjustment_rec.cost_adjust_id <> FND_API.G_MISS_NUM)

650: RAISE FND_API.G_EXC_ERROR;
651: END IF;
652: EXCEPTION
653: WHEN OTHERS THEN
654: IF (p_adjustment_rec.cost_adjust_id IS NOT NULL) OR (p_adjustment_rec.cost_adjust_id <> FND_API.G_MISS_NUM)
655: THEN
656: FND_MESSAGE.SET_NAME('GMF','GMF_API_ACA_DEL_FAILED');
657: FND_MESSAGE.SET_TOKEN('ADJUST_ID', p_adjustment_rec.cost_adjust_id);
658: FND_MSG_PUB.Add;

Line 678: WHEN FND_API.G_EXC_ERROR THEN

674: p_count => x_msg_count
675: , p_data => x_msg_data
676: );
677: EXCEPTION
678: WHEN FND_API.G_EXC_ERROR THEN
679: ROLLBACK TO DELETE_ACT_COST_ADJUSTMENT_PVT;
680: x_return_status := FND_API.G_RET_STS_ERROR ;
681: FND_MSG_PUB.Count_And_Get (
682: p_count => x_msg_count

Line 680: x_return_status := FND_API.G_RET_STS_ERROR ;

676: );
677: EXCEPTION
678: WHEN FND_API.G_EXC_ERROR THEN
679: ROLLBACK TO DELETE_ACT_COST_ADJUSTMENT_PVT;
680: x_return_status := FND_API.G_RET_STS_ERROR ;
681: FND_MSG_PUB.Count_And_Get (
682: p_count => x_msg_count
683: , p_data => x_msg_data
684: );

Line 685: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

683: , p_data => x_msg_data
684: );
685: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
686: ROLLBACK TO DELETE_ACT_COST_ADJUSTMENT_PVT;
687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
688: FND_MSG_PUB.Count_And_Get (
689: p_count => x_msg_count
690: , p_data => x_msg_data
691: );

Line 694: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

690: , p_data => x_msg_data
691: );
692: WHEN OTHERS THEN
693: ROLLBACK TO DELETE_ACT_COST_ADJUSTMENT_PVT;
694: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
695: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
696: THEN
697: FND_MSG_PUB.Add_Exc_Msg (
698: G_PKG_NAME

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

735: ********************************************************************/
736: PROCEDURE GET_ACTUAL_COST_ADJUSTMENT
737: (
738: p_api_version IN NUMBER,
739: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
740: x_return_status OUT NOCOPY VARCHAR2,
741: x_msg_count OUT NOCOPY NUMBER,
742: x_msg_data OUT NOCOPY VARCHAR2,
743: p_adjustment_rec IN OUT NOCOPY GMF_ACTUAL_COST_ADJUSTMENT_PUB.ADJUSTMENT_REC_TYPE

Line 807: IF FND_API.to_Boolean( p_init_msg_list )

803:
804: /*************************************************************
805: * Initialize message list if p_init_msg_list is set to TRUE. *
806: *************************************************************/
807: IF FND_API.to_Boolean( p_init_msg_list )
808: THEN
809: FND_MSG_PUB.initialize;
810: END IF;
811:

Line 815: IF NOT FND_API.Compatible_API_Call

811:
812: /*************************************************
813: * Standard call to check for call compatibility. *
814: *************************************************/
815: IF NOT FND_API.Compatible_API_Call
816: (
817: l_api_version,
818: p_api_version,
819: l_api_name,

Line 823: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

819: l_api_name,
820: G_PKG_NAME
821: )
822: THEN
823: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
824: END IF;
825:
826: /******************************************
827: * Initialize API return status to success *

Line 829: x_return_status := FND_API.G_RET_STS_SUCCESS;

825:
826: /******************************************
827: * Initialize API return status to success *
828: ******************************************/
829: x_return_status := FND_API.G_RET_STS_SUCCESS;
830:
831: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level
832: THEN
833: log_msg('Beginning Private Get Actual Cost Adjustment API');

Line 952: RAISE FND_API.G_EXC_ERROR;

948: ' Analysis code ' || p_adjustment_rec.cost_analysis_code ||
949: ' Adjustment Indicator ' || p_adjustment_rec.adjustment_ind
950: );
951: END IF;
952: RAISE FND_API.G_EXC_ERROR;
953: END IF;
954:
955: /**************************************************************************
956: * Standard call to get message count and if count is 1, get message info. *

Line 963: WHEN FND_API.G_EXC_ERROR THEN

959: p_count => x_msg_count
960: , p_data => x_msg_data
961: );
962: EXCEPTION
963: WHEN FND_API.G_EXC_ERROR THEN
964: x_return_status := FND_API.G_RET_STS_ERROR ;
965: FND_MSG_PUB.Count_And_Get (
966: p_count => x_msg_count
967: , p_data => x_msg_data

Line 964: x_return_status := FND_API.G_RET_STS_ERROR ;

960: , p_data => x_msg_data
961: );
962: EXCEPTION
963: WHEN FND_API.G_EXC_ERROR THEN
964: x_return_status := FND_API.G_RET_STS_ERROR ;
965: FND_MSG_PUB.Count_And_Get (
966: p_count => x_msg_count
967: , p_data => x_msg_data
968: );

Line 969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

965: FND_MSG_PUB.Count_And_Get (
966: p_count => x_msg_count
967: , p_data => x_msg_data
968: );
969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
970: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
971: FND_MSG_PUB.Count_And_Get (
972: p_count => x_msg_count
973: , p_data => x_msg_data

Line 970: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

966: p_count => x_msg_count
967: , p_data => x_msg_data
968: );
969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
970: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
971: FND_MSG_PUB.Count_And_Get (
972: p_count => x_msg_count
973: , p_data => x_msg_data
974: );

Line 976: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

972: p_count => x_msg_count
973: , p_data => x_msg_data
974: );
975: WHEN OTHERS THEN
976: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
977: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
978: THEN
979: FND_MSG_PUB.Add_Exc_Msg (
980: G_PKG_NAME