[Home] [Help]
28: --| |
29: --| Valid values for message levels are from 1-50. |
30: --| 1 being least severe and 50 highest. |
31: --| |
32: --| The pre-defined levels correspond to standard API |
33: --| return status. Debug levels are used to control the amount of |
34: --| debug information a program writes to the PL/SQL message table. |
35: --| |
36: --| G_MSG_LVL_UNEXP_ERROR CONSTANT NUMBER := 60; |
111: l_adjustment_id GMF_LOT_COST_ADJUSTMENTS.ADJUSTMENT_ID%TYPE;
112: l_adjustment_dtl_id GMF_LOT_COST_ADJUSTMENT_DTLS.ADJUSTMENT_DTL_ID%TYPE;
113: BEGIN
114:
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
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.
124: IF NOT FND_API.Compatible_API_Call (
125: l_api_version ,
126: p_api_version ,
127: l_api_name ,
362: END IF;
363: END IF;
364: END LOOP;
365:
366: -- Standard call to get message count and if count is 1, get message info.
367: FND_MSG_PUB.Count_And_Get (
368: p_count => x_msg_count
369: , p_data => x_msg_data
370: );
449: l_adjustment_id GMF_LOT_COST_ADJUSTMENTS.ADJUSTMENT_ID%TYPE;
450: l_adjustment_dtl_id GMF_LOT_COST_ADJUSTMENT_DTLS.ADJUSTMENT_DTL_ID%TYPE;
451: BEGIN
452:
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
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.
462: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
463: p_api_version ,
464: l_api_name ,
465: G_PKG_NAME
514:
515: END LOOP;
516:
517:
518: -- Standard call to get message count and if count is 1, get message info.
519: FND_MSG_PUB.Count_And_Get (
520: p_count => x_msg_count
521: , p_data => x_msg_data
522: );
602: l_adjustment_dtl_id GMF_LOT_COST_ADJUSTMENT_DTLS.ADJUSTMENT_DTL_ID%TYPE;
603: l_adjustment_dtl_cnt NUMBER := 0;
604: BEGIN
605:
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
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.
615: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
616: p_api_version ,
617: l_api_name ,
618: G_PKG_NAME
724: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
725: log_msg(p_dtl_tbl.COUNT || ' Lot Cost Adjustment Detail row(s) Deleted');
726: END IF;
727:
728: -- Standard call to get message count and if count is 1, get message info.
729: FND_MSG_PUB.Count_And_Get (
730: p_count => x_msg_count
731: , p_data => x_msg_data
732: );
883: l_api_version CONSTANT NUMBER := 2.0 ;
884: l_idx NUMBER := 0;
885:
886: BEGIN
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
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.
896: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
897: p_api_version ,
898: l_api_name ,
899: G_PKG_NAME
996: END IF;
997: CLOSE adjustment_dtls_csr;
998:
999:
1000: -- Standard call to get message count and if count is 1, get message info.
1001: FND_MSG_PUB.Count_And_Get (
1002: p_count => x_msg_count
1003: , p_data => x_msg_data
1004: );