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

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

96:
97: PROCEDURE Create_LotCost_Adjustment
98: (
99: p_api_version IN NUMBER
100: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
101: , x_return_status OUT NOCOPY VARCHAR2
102: , x_msg_count OUT NOCOPY NUMBER
103: , x_msg_data OUT NOCOPY VARCHAR2
104: , p_header_rec IN OUT NOCOPY GMF_LotCostAdjustment_PUB.Lc_Adjustment_Header_Rec_Type

Line 119: IF FND_API.to_Boolean( p_init_msg_list ) THEN

115: -- Standard Start of API savepoint
116: SAVEPOINT Create_LotCost_Adjustment_PVT ;
117:
118: -- Initialize message list if p_init_msg_list is set to TRUE.
119: IF FND_API.to_Boolean( p_init_msg_list ) THEN
120: FND_MSG_PUB.initialize;
121: END IF;
122:
123: -- Standard call to check for call compatibility.

Line 124: IF NOT FND_API.Compatible_API_Call (

120: FND_MSG_PUB.initialize;
121: END IF;
122:
123: -- Standard call to check for call compatibility.
124: IF NOT FND_API.Compatible_API_Call (
125: l_api_version ,
126: p_api_version ,
127: l_api_name ,
128: G_PKG_NAME

Line 130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

126: p_api_version ,
127: l_api_name ,
128: G_PKG_NAME
129: ) THEN
130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
131: END IF;
132:
133: -- Initialize API return status to success
134: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 134: x_return_status := FND_API.G_RET_STS_SUCCESS;

130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
131: END IF;
132:
133: -- Initialize API return status to success
134: x_return_status := FND_API.G_RET_STS_SUCCESS;
135:
136: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
137: log_msg('Beginning Private Create Lot Cost Adjustment API');
138: END IF;

Line 277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

273: FND_MESSAGE.SET_TOKEN('COST_TYPE', p_header_rec.cost_type_id);
274: FND_MESSAGE.SET_TOKEN('LOT', p_header_rec.lot_number);
275: FND_MESSAGE.SET_TOKEN('ADJUSTMENT_DATE', p_header_rec.adjustment_date);
276: FND_MSG_PUB.Add;
277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
278: RAISE ;
279: END;
280:
281: ELSIF p_header_Rec.adjustment_id IS NOT NULL THEN

Line 353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

349: FND_MESSAGE.SET_NAME('GMF','GMF_API_LCA_DTL_INS_FAILED');
350: FND_MESSAGE.SET_TOKEN('COMPONENT_CLASS', p_dtl_tbl(i).cost_cmpntcls_id);
351: FND_MESSAGE.SET_TOKEN('ANALYSIS_CODE', p_dtl_tbl(i).cost_analysis_code);
352: FND_MSG_PUB.Add;
353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
354: RAISE ;
355: END ;
356: ELSIF p_dtl_tbl(i).adjustment_dtl_id IS NOT NULL THEN
357:

Line 372: WHEN FND_API.G_EXC_ERROR THEN

368: p_count => x_msg_count
369: , p_data => x_msg_data
370: );
371: EXCEPTION
372: WHEN FND_API.G_EXC_ERROR THEN
373: ROLLBACK TO Create_LotCost_Adjustment_PVT;
374: x_return_status := FND_API.G_RET_STS_ERROR ;
375: FND_MSG_PUB.Count_And_Get (
376: p_count => x_msg_count

Line 374: x_return_status := FND_API.G_RET_STS_ERROR ;

370: );
371: EXCEPTION
372: WHEN FND_API.G_EXC_ERROR THEN
373: ROLLBACK TO Create_LotCost_Adjustment_PVT;
374: x_return_status := FND_API.G_RET_STS_ERROR ;
375: FND_MSG_PUB.Count_And_Get (
376: p_count => x_msg_count
377: , p_data => x_msg_data
378: );

Line 379: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

375: FND_MSG_PUB.Count_And_Get (
376: p_count => x_msg_count
377: , p_data => x_msg_data
378: );
379: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
380: ROLLBACK TO Create_LotCost_Adjustment_PVT;
381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
382: FND_MSG_PUB.Count_And_Get (
383: p_count => x_msg_count

Line 381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

377: , p_data => x_msg_data
378: );
379: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
380: ROLLBACK TO Create_LotCost_Adjustment_PVT;
381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
382: FND_MSG_PUB.Count_And_Get (
383: p_count => x_msg_count
384: , p_data => x_msg_data
385: );

Line 388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

384: , p_data => x_msg_data
385: );
386: WHEN OTHERS THEN
387: ROLLBACK TO Create_LotCost_Adjustment_PVT;
388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
389: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
390: FND_MSG_PUB.Add_Exc_Msg (
391: G_PKG_NAME
392: , l_api_name

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

434:
435: PROCEDURE Update_LotCost_Adjustment
436: (
437: p_api_version IN NUMBER
438: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
439: , x_return_status OUT NOCOPY VARCHAR2
440: , x_msg_count OUT NOCOPY NUMBER
441: , x_msg_data OUT NOCOPY VARCHAR2
442: , p_header_rec IN OUT NOCOPY GMF_LotCostAdjustment_PUB.Lc_Adjustment_Header_Rec_Type

Line 457: IF FND_API.to_Boolean( p_init_msg_list ) THEN

453: -- Standard Start of API savepoint
454: SAVEPOINT Update_LotCost_Adjustment_PVT ;
455:
456: -- Initialize message list if p_init_msg_list is set to TRUE.
457: IF FND_API.to_Boolean( p_init_msg_list ) THEN
458: FND_MSG_PUB.initialize;
459: END IF;
460:
461: -- Standard call to check for call compatibility.

Line 462: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

458: FND_MSG_PUB.initialize;
459: END IF;
460:
461: -- Standard call to check for call compatibility.
462: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
463: p_api_version ,
464: l_api_name ,
465: G_PKG_NAME
466: ) THEN

Line 467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

463: p_api_version ,
464: l_api_name ,
465: G_PKG_NAME
466: ) THEN
467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
468: END IF;
469:
470: -- Initialize API return status to success
471: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 471: x_return_status := FND_API.G_RET_STS_SUCCESS;

467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
468: END IF;
469:
470: -- Initialize API return status to success
471: x_return_status := FND_API.G_RET_STS_SUCCESS;
472:
473: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
474: log_msg('Beginning Private Update Lot Cost Adjustment API');
475: END IF;

Line 486: , TEXT_CODE = decode( p_dtl_tbl(i).TEXT_CODE, FND_API.G_MISS_NUM, NULL, NULL, TEXT_CODE, p_dtl_tbl(i).TEXT_CODE )

482: END IF;
483: BEGIN
484: UPDATE gmf_lot_cost_adjustment_dtls
485: SET ADJUSTMENT_COST = p_dtl_tbl(i).ADJUSTMENT_COST
486: , TEXT_CODE = decode( p_dtl_tbl(i).TEXT_CODE, FND_API.G_MISS_NUM, NULL, NULL, TEXT_CODE, p_dtl_tbl(i).TEXT_CODE )
487: , LAST_UPDATED_BY = p_user_id
488: , LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
489: , LAST_UPDATE_DATE = SYSDATE
490: WHERE adjustment_dtl_id = p_dtl_tbl(i).adjustment_dtl_id

Line 501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

497: WHEN OTHERS THEN
498: FND_MESSAGE.SET_NAME('GMF','GMF_API_LCA_DTL_ID_UPD_FAILED');
499: FND_MESSAGE.SET_TOKEN('ADJUSTMENT_DTL_ID', p_dtl_tbl(i).adjustment_dtl_id);
500: FND_MSG_PUB.Add;
501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
502: RAISE ;
503: END ;
504: ELSIF p_dtl_tbl(i).adjustment_dtl_id IS NULL THEN
505:

Line 525: WHEN FND_API.G_EXC_ERROR THEN

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

Line 527: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 532: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

528: FND_MSG_PUB.Count_And_Get (
529: p_count => x_msg_count
530: , p_data => x_msg_data
531: );
532: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
533: ROLLBACK TO Update_LotCost_Adjustment_PVT;
534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
535: FND_MSG_PUB.Count_And_Get (
536: p_count => x_msg_count

Line 534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

530: , p_data => x_msg_data
531: );
532: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
533: ROLLBACK TO Update_LotCost_Adjustment_PVT;
534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
535: FND_MSG_PUB.Count_And_Get (
536: p_count => x_msg_count
537: , p_data => x_msg_data
538: );

Line 541: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

537: , p_data => x_msg_data
538: );
539: WHEN OTHERS THEN
540: ROLLBACK TO Update_LotCost_Adjustment_PVT;
541: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
542: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
543: FND_MSG_PUB.Add_Exc_Msg (
544: G_PKG_NAME
545: , l_api_name

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

587:
588: PROCEDURE Delete_LotCost_Adjustment
589: (
590: p_api_version IN NUMBER
591: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
592: , x_return_status OUT NOCOPY VARCHAR2
593: , x_msg_count OUT NOCOPY NUMBER
594: , x_msg_data OUT NOCOPY VARCHAR2
595: , p_header_rec IN OUT NOCOPY GMF_LotCostAdjustment_PUB.Lc_Adjustment_Header_Rec_Type

Line 610: IF FND_API.to_Boolean( p_init_msg_list ) THEN

606: -- Standard Start of API savepoint
607: SAVEPOINT Delete_LotCost_Adjustment_PVT ;
608:
609: -- Initialize message list if p_init_msg_list is set to TRUE.
610: IF FND_API.to_Boolean( p_init_msg_list ) THEN
611: FND_MSG_PUB.initialize;
612: END IF;
613:
614: -- Standard call to check for call compatibility.

Line 615: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

611: FND_MSG_PUB.initialize;
612: END IF;
613:
614: -- Standard call to check for call compatibility.
615: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
616: p_api_version ,
617: l_api_name ,
618: G_PKG_NAME
619: ) THEN

Line 620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

616: p_api_version ,
617: l_api_name ,
618: G_PKG_NAME
619: ) THEN
620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
621: END IF;
622:
623: -- Initialize API return status to success
624: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 624: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

646: WHEN OTHERS THEN
647: FND_MESSAGE.SET_NAME('GMF','GMF_API_LCA_DTL_ID_DEL_FAILED');
648: FND_MESSAGE.SET_TOKEN('ADJUSTMENT_ID', p_dtl_tbl(i).adjustment_dtl_id);
649: FND_MSG_PUB.Add;
650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
651: RAISE ;
652: END ;
653: ELSIF p_dtl_tbl(i).adjustment_dtl_id IS NULL THEN
654:

Line 698: x_return_status := FND_API.G_RET_STS_ERROR ;

694: FND_MESSAGE.SET_TOKEN('COST_TYPE', p_header_rec.cost_type_id);
695: FND_MESSAGE.SET_TOKEN('LOT', p_header_rec.lot_number);
696: FND_MESSAGE.SET_TOKEN('ADJUSTMENT_DATE', p_header_rec.adjustment_date);
697: FND_MSG_PUB.Add;
698: x_return_status := FND_API.G_RET_STS_ERROR ;
699: RAISE FND_API.G_EXC_ERROR;
700: ELSE
701: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
702: log_msg( SQL%ROWCOUNT || ' Record Deleted for Adjustment Id ' || p_header_rec.adjustment_id);

Line 699: RAISE FND_API.G_EXC_ERROR;

695: FND_MESSAGE.SET_TOKEN('LOT', p_header_rec.lot_number);
696: FND_MESSAGE.SET_TOKEN('ADJUSTMENT_DATE', p_header_rec.adjustment_date);
697: FND_MSG_PUB.Add;
698: x_return_status := FND_API.G_RET_STS_ERROR ;
699: RAISE FND_API.G_EXC_ERROR;
700: ELSE
701: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
702: log_msg( SQL%ROWCOUNT || ' Record Deleted for Adjustment Id ' || p_header_rec.adjustment_id);
703: END IF;

Line 707: IF (p_header_rec.adjustment_id IS NOT NULL) OR (p_header_rec.adjustment_id <> FND_API.G_MISS_NUM) THEN

703: END IF;
704: END IF ;
705: EXCEPTION
706: WHEN OTHERS THEN
707: IF (p_header_rec.adjustment_id IS NOT NULL) OR (p_header_rec.adjustment_id <> FND_API.G_MISS_NUM) THEN
708: FND_MESSAGE.SET_NAME('GMF','GMF_API_LCA_DEL_FAILED');
709: FND_MESSAGE.SET_TOKEN('ADJUSTMENT_ID', p_header_rec.adjustment_id);
710: FND_MSG_PUB.Add;
711: END IF ;

Line 734: WHEN FND_API.G_EXC_ERROR THEN

730: p_count => x_msg_count
731: , p_data => x_msg_data
732: );
733: EXCEPTION
734: WHEN FND_API.G_EXC_ERROR THEN
735: ROLLBACK TO Delete_LotCost_Adjustment_PVT;
736: x_return_status := FND_API.G_RET_STS_ERROR ;
737: FND_MSG_PUB.Count_And_Get (
738: p_count => x_msg_count

Line 736: x_return_status := FND_API.G_RET_STS_ERROR ;

732: );
733: EXCEPTION
734: WHEN FND_API.G_EXC_ERROR THEN
735: ROLLBACK TO Delete_LotCost_Adjustment_PVT;
736: x_return_status := FND_API.G_RET_STS_ERROR ;
737: FND_MSG_PUB.Count_And_Get (
738: p_count => x_msg_count
739: , p_data => x_msg_data
740: );

Line 741: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

737: FND_MSG_PUB.Count_And_Get (
738: p_count => x_msg_count
739: , p_data => x_msg_data
740: );
741: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
742: ROLLBACK TO Delete_LotCost_Adjustment_PVT;
743: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
744: FND_MSG_PUB.Count_And_Get (
745: p_count => x_msg_count

Line 743: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

739: , p_data => x_msg_data
740: );
741: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
742: ROLLBACK TO Delete_LotCost_Adjustment_PVT;
743: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
744: FND_MSG_PUB.Count_And_Get (
745: p_count => x_msg_count
746: , p_data => x_msg_data
747: );

Line 750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

746: , p_data => x_msg_data
747: );
748: WHEN OTHERS THEN
749: ROLLBACK TO Delete_LotCost_Adjustment_PVT;
750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
751: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
752: FND_MSG_PUB.Add_Exc_Msg (
753: G_PKG_NAME
754: , l_api_name

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

797:
798: PROCEDURE Get_LotCost_Adjustment
799: (
800: p_api_version IN NUMBER
801: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
802: , x_return_status OUT NOCOPY VARCHAR2
803: , x_msg_count OUT NOCOPY NUMBER
804: , x_msg_data OUT NOCOPY VARCHAR2
805: , p_header_rec IN OUT NOCOPY GMF_LotCostAdjustment_PUB.Lc_Adjustment_Header_Rec_Type

Line 891: IF FND_API.to_Boolean( p_init_msg_list ) THEN

887: -- Standard Start of API savepoint
888: SAVEPOINT Get_LotCost_Adjustment_PVT;
889:
890: -- Initialize message list if p_init_msg_list is set to TRUE.
891: IF FND_API.to_Boolean( p_init_msg_list ) THEN
892: FND_MSG_PUB.initialize;
893: END IF;
894:
895: -- Standard call to check for call compatibility.

Line 896: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

892: FND_MSG_PUB.initialize;
893: END IF;
894:
895: -- Standard call to check for call compatibility.
896: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
897: p_api_version ,
898: l_api_name ,
899: G_PKG_NAME
900: ) THEN

Line 901: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

897: p_api_version ,
898: l_api_name ,
899: G_PKG_NAME
900: ) THEN
901: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
902: END IF;
903:
904: -- Initialize API return status to success
905: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 905: x_return_status := FND_API.G_RET_STS_SUCCESS;

901: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
902: END IF;
903:
904: -- Initialize API return status to success
905: x_return_status := FND_API.G_RET_STS_SUCCESS;
906:
907: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
908: log_msg('Beginning Private Get Lot Cost Adjustment API.');
909: END IF;