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

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 ) THEN
128: FND_MSG_PUB.initialize;
129: END IF;
130:
131: /*************************************************

Line 134: IF NOT FND_API.Compatible_API_Call

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

Line 142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 148: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

318: FND_MESSAGE.SET_TOKEN('PERIOD_ID', p_adjustment_rec.period_id);
319: FND_MESSAGE.SET_TOKEN('COST_CMPNT_CLS', p_adjustment_rec.cost_cmpntcls_id);
320: FND_MESSAGE.SET_TOKEN('COST_ANALYSIS_CODE', p_adjustment_rec.cost_analysis_code);
321: FND_MSG_PUB.Add;
322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
323: RAISE ;
324: END;
325:
326: ELSIF p_adjustment_rec.cost_adjust_id IS NOT NULL THEN

Line 349: WHEN FND_API.G_EXC_ERROR THEN

345: p_count => x_msg_count
346: , p_data => x_msg_data
347: );
348: EXCEPTION
349: WHEN FND_API.G_EXC_ERROR THEN
350: ROLLBACK TO CREATE_ACT_COST_ADJUSTMENT_PVT;
351: x_return_status := FND_API.G_RET_STS_ERROR ;
352: FND_MSG_PUB.Count_And_Get(
353: p_count => x_msg_count

Line 351: x_return_status := FND_API.G_RET_STS_ERROR ;

347: );
348: EXCEPTION
349: WHEN FND_API.G_EXC_ERROR THEN
350: ROLLBACK TO CREATE_ACT_COST_ADJUSTMENT_PVT;
351: x_return_status := FND_API.G_RET_STS_ERROR ;
352: FND_MSG_PUB.Count_And_Get(
353: p_count => x_msg_count
354: , p_data => x_msg_data
355: );

Line 356: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

361: , p_data => x_msg_data
362: );
363: WHEN OTHERS THEN
364: ROLLBACK TO CREATE_ACT_COST_ADJUSTMENT_PVT;
365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
366: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
367: FND_MSG_PUB.Add_Exc_Msg (
368: G_PKG_NAME
369: , l_api_name

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

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

Line 438: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 445: IF NOT FND_API.Compatible_API_Call

441:
442: /*************************************************
443: * Standard call to check for call compatibility. *
444: *************************************************/
445: IF NOT FND_API.Compatible_API_Call
446: (
447: l_api_version,
448: p_api_version,
449: l_api_name,

Line 453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

449: l_api_name,
450: G_PKG_NAME
451: )
452: THEN
453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
454: END IF;
455:
456: /******************************************
457: * Initialize API return status to success *

Line 459: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 514: WHEN FND_API.G_EXC_ERROR THEN

510: p_count => x_msg_count
511: , p_data => x_msg_data
512: );
513: EXCEPTION
514: WHEN FND_API.G_EXC_ERROR THEN
515: ROLLBACK TO UPDATE_ACT_COST_ADJUSTMENT_PVT;
516: x_return_status := FND_API.G_RET_STS_ERROR ;
517: FND_MSG_PUB.Count_And_Get(
518: p_count => x_msg_count

Line 516: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 521: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

526: , p_data => x_msg_data
527: );
528: WHEN OTHERS THEN
529: ROLLBACK TO UPDATE_ACT_COST_ADJUSTMENT_PVT;
530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
531: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
532: FND_MSG_PUB.Add_Exc_Msg(
533: G_PKG_NAME
534: , l_api_name

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

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

Line 602: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 609: IF NOT FND_API.Compatible_API_Call

605:
606: /*************************************************
607: * Standard call to check for call compatibility. *
608: *************************************************/
609: IF NOT FND_API.Compatible_API_Call
610: (
611: l_api_version,
612: p_api_version,
613: l_api_name,

Line 617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

613: l_api_name,
614: G_PKG_NAME
615: )
616: THEN
617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
618: END IF;
619:
620: /******************************************
621: * Initialize API return status to success *

Line 623: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 651: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 652: RAISE FND_API.G_EXC_ERROR;

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

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

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

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) THEN
696: FND_MSG_PUB.Add_Exc_Msg(
697: G_PKG_NAME
698: , l_api_name

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

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

Line 806: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 814: IF NOT FND_API.Compatible_API_Call

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

Line 822: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 828: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 949: RAISE FND_API.G_EXC_ERROR;

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

Line 960: WHEN FND_API.G_EXC_ERROR THEN

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

Line 961: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 966: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 967: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 973: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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