[Home] [Help]
1889: FROM ams_list_headers_all
1890: WHERE list_header_id= x_list_header_id;
1891:
1892: BEGIN
1893: -- Standard Start of API savepoint
1894: SAVEPOINT CREATE_List_Entries_PVT;
1895:
1896: -- Standard call to check for call compatibility.
1897: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1892: BEGIN
1893: -- Standard Start of API savepoint
1894: SAVEPOINT CREATE_List_Entries_PVT;
1895:
1896: -- Standard call to check for call compatibility.
1897: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1898: p_api_version_number,
1899: l_api_name,
1900: G_PKG_NAME)
2387: --
2388: -- End of API body
2389: --
2390:
2391: -- Standard check for p_commit
2392: IF FND_API.to_Boolean( p_commit )
2393: THEN
2394: COMMIT WORK;
2395: END IF;
2398:
2399: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
2400: END IF;
2401:
2402: -- Standard call to get message count and if count is 1, get message info.
2403: FND_MSG_PUB.Count_And_Get
2404: (p_count => x_msg_count,
2405: p_data => x_msg_data
2406: );
2412:
2413: WHEN FND_API.G_EXC_ERROR THEN
2414: ROLLBACK TO CREATE_List_Entries_PVT;
2415: x_return_status := FND_API.G_RET_STS_ERROR;
2416: -- Standard call to get message count and if count=1, get the message
2417: FND_MSG_PUB.Count_And_Get (
2418: p_encoded => FND_API.G_FALSE,
2419: p_count => x_msg_count,
2420: p_data => x_msg_data
2422:
2423: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2424: ROLLBACK TO CREATE_List_Entries_PVT;
2425: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2426: -- Standard call to get message count and if count=1, get the message
2427: FND_MSG_PUB.Count_And_Get (
2428: p_encoded => FND_API.G_FALSE,
2429: p_count => x_msg_count,
2430: p_data => x_msg_data
2436: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2437: THEN
2438: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2439: END IF;
2440: -- Standard call to get message count and if count=1, get the message
2441: FND_MSG_PUB.Count_And_Get (
2442: p_encoded => FND_API.G_FALSE,
2443: p_count => x_msg_count,
2444: p_data => x_msg_data
2480: FROM ams_list_headers_all
2481: WHERE list_header_id= x_list_header_id;
2482:
2483: BEGIN
2484: -- Standard Start of API savepoint
2485: SAVEPOINT UPDATE_List_Entries_PVT;
2486:
2487: -- Standard call to check for call compatibility.
2488: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2483: BEGIN
2484: -- Standard Start of API savepoint
2485: SAVEPOINT UPDATE_List_Entries_PVT;
2486:
2487: -- Standard call to check for call compatibility.
2488: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2489: p_api_version_number,
2490: l_api_name,
2491: G_PKG_NAME)
2975: --
2976: -- End of API body.
2977: --
2978:
2979: -- Standard check for p_commit
2980: IF FND_API.to_Boolean( p_commit )
2981: THEN
2982: COMMIT WORK;
2983: END IF;
2988:
2989: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
2990: END IF;
2991:
2992: -- Standard call to get message count and if count is 1, get message info.
2993: FND_MSG_PUB.Count_And_Get
2994: (p_count => x_msg_count,
2995: p_data => x_msg_data
2996: );
3002:
3003: WHEN FND_API.G_EXC_ERROR THEN
3004: ROLLBACK TO UPDATE_List_Entries_PVT;
3005: x_return_status := FND_API.G_RET_STS_ERROR;
3006: -- Standard call to get message count and if count=1, get the message
3007: FND_MSG_PUB.Count_And_Get (
3008: p_encoded => FND_API.G_FALSE,
3009: p_count => x_msg_count,
3010: p_data => x_msg_data
3012:
3013: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3014: ROLLBACK TO UPDATE_List_Entries_PVT;
3015: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3016: -- Standard call to get message count and if count=1, get the message
3017: FND_MSG_PUB.Count_And_Get (
3018: p_encoded => FND_API.G_FALSE,
3019: p_count => x_msg_count,
3020: p_data => x_msg_data
3026: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3027: THEN
3028: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3029: END IF;
3030: -- Standard call to get message count and if count=1, get the message
3031: FND_MSG_PUB.Count_And_Get (
3032: p_encoded => FND_API.G_FALSE,
3033: p_count => x_msg_count,
3034: p_data => x_msg_data
3053: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
3054: l_object_version_number NUMBER;
3055:
3056: BEGIN
3057: -- Standard Start of API savepoint
3058: SAVEPOINT DELETE_List_Entries_PVT;
3059:
3060: -- Standard call to check for call compatibility.
3061: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3056: BEGIN
3057: -- Standard Start of API savepoint
3058: SAVEPOINT DELETE_List_Entries_PVT;
3059:
3060: -- Standard call to check for call compatibility.
3061: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3062: p_api_version_number,
3063: l_api_name,
3064: G_PKG_NAME)
3097: --
3098: -- End of API body
3099: --
3100:
3101: -- Standard check for p_commit
3102: IF FND_API.to_Boolean( p_commit )
3103: THEN
3104: COMMIT WORK;
3105: END IF;
3110:
3111: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
3112: END IF;
3113:
3114: -- Standard call to get message count and if count is 1, get message info.
3115: FND_MSG_PUB.Count_And_Get
3116: (p_count => x_msg_count,
3117: p_data => x_msg_data
3118: );
3124:
3125: WHEN FND_API.G_EXC_ERROR THEN
3126: ROLLBACK TO DELETE_List_Entries_PVT;
3127: x_return_status := FND_API.G_RET_STS_ERROR;
3128: -- Standard call to get message count and if count=1, get the message
3129: FND_MSG_PUB.Count_And_Get (
3130: p_encoded => FND_API.G_FALSE,
3131: p_count => x_msg_count,
3132: p_data => x_msg_data
3134:
3135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3136: ROLLBACK TO DELETE_List_Entries_PVT;
3137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3138: -- Standard call to get message count and if count=1, get the message
3139: FND_MSG_PUB.Count_And_Get (
3140: p_encoded => FND_API.G_FALSE,
3141: p_count => x_msg_count,
3142: p_data => x_msg_data
3148: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3149: THEN
3150: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3151: END IF;
3152: -- Standard call to get message count and if count=1, get the message
3153: FND_MSG_PUB.Count_And_Get (
3154: p_encoded => FND_API.G_FALSE,
3155: p_count => x_msg_count,
3156: p_data => x_msg_data
3198: THEN
3199: FND_MSG_PUB.initialize;
3200: END IF;
3201:
3202: -- Standard call to check for call compatibility.
3203: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3204: p_api_version_number,
3205: l_api_name,
3206: G_PKG_NAME)
3254:
3255: WHEN FND_API.G_EXC_ERROR THEN
3256: ROLLBACK TO LOCK_List_Entries_PVT;
3257: x_return_status := FND_API.G_RET_STS_ERROR;
3258: -- Standard call to get message count and if count=1, get the message
3259: FND_MSG_PUB.Count_And_Get (
3260: p_encoded => FND_API.G_FALSE,
3261: p_count => x_msg_count,
3262: p_data => x_msg_data
3264:
3265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3266: ROLLBACK TO LOCK_List_Entries_PVT;
3267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3268: -- Standard call to get message count and if count=1, get the message
3269: FND_MSG_PUB.Count_And_Get (
3270: p_encoded => FND_API.G_FALSE,
3271: p_count => x_msg_count,
3272: p_data => x_msg_data
3278: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3279: THEN
3280: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3281: END IF;
3282: -- Standard call to get message count and if count=1, get the message
3283: FND_MSG_PUB.Count_And_Get (
3284: p_encoded => FND_API.G_FALSE,
3285: p_count => x_msg_count,
3286: p_data => x_msg_data
3824: l_object_version_number NUMBER;
3825: l_list_entries_rec AMS_List_Entries_PVT.list_entries_rec_type;
3826:
3827: BEGIN
3828: -- Standard Start of API savepoint
3829: SAVEPOINT VALIDATE_List_Entries_;
3830:
3831: -- Standard call to check for call compatibility.
3832: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3827: BEGIN
3828: -- Standard Start of API savepoint
3829: SAVEPOINT VALIDATE_List_Entries_;
3830:
3831: -- Standard call to check for call compatibility.
3832: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3833: p_api_version_number,
3834: l_api_name,
3835: G_PKG_NAME)
3894:
3895: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
3896: END IF;
3897:
3898: -- Standard call to get message count and if count is 1, get message info.
3899: FND_MSG_PUB.Count_And_Get
3900: (p_count => x_msg_count,
3901: p_data => x_msg_data
3902: );
3908:
3909: WHEN FND_API.G_EXC_ERROR THEN
3910: ROLLBACK TO VALIDATE_List_Entries_;
3911: x_return_status := FND_API.G_RET_STS_ERROR;
3912: -- Standard call to get message count and if count=1, get the message
3913: FND_MSG_PUB.Count_And_Get (
3914: p_encoded => FND_API.G_FALSE,
3915: p_count => x_msg_count,
3916: p_data => x_msg_data
3918:
3919: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3920: ROLLBACK TO VALIDATE_List_Entries_;
3921: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3922: -- Standard call to get message count and if count=1, get the message
3923: FND_MSG_PUB.Count_And_Get (
3924: p_encoded => FND_API.G_FALSE,
3925: p_count => x_msg_count,
3926: p_data => x_msg_data
3932: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3933: THEN
3934: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3935: END IF;
3936: -- Standard call to get message count and if count=1, get the message
3937: FND_MSG_PUB.Count_And_Get (
3938: p_encoded => FND_API.G_FALSE,
3939: p_count => x_msg_count,
3940: p_data => x_msg_data
3970: IF (AMS_DEBUG_HIGH_ON) THEN
3971:
3972: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
3973: END IF;
3974: -- Standard call to get message count and if count is 1, get message info.
3975: FND_MSG_PUB.Count_And_Get
3976: (p_count => x_msg_count,
3977: p_data => x_msg_data
3978: );
4407:
4408: l_init_msg_list VARCHAR2(2000) := FND_API.G_FALSE;
4409:
4410: BEGIN
4411: -- Standard Start of API savepoint
4412: SAVEPOINT Copy_List_Entries_PVT;
4413:
4414: x_return_status := FND_API.G_RET_STS_SUCCESS;
4415:
4415:
4416:
4417:
4418:
4419: -- Standard call to check for call compatibility.
4420: IF NOT FND_API.Compatible_API_Call ( l_api_version,
4421: p_api_version_number,
4422: l_api_name,
4423: G_PKG_NAME) THEN
5185: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5187: END IF;
5188:
5189: -- Standard check of p_commit.
5190: IF FND_API.To_Boolean ( p_commit ) THEN
5191: COMMIT WORK;
5192: END IF;
5193:
5205: FND_MSG_PUB.Add;
5206: END IF;
5207:
5208:
5209: -- Standard call to get message count AND IF count is 1, get message info.
5210: FND_MSG_PUB.Count_AND_Get
5211: ( p_count => x_msg_count,
5212: p_data => x_msg_data,
5213: p_encoded => FND_API.G_FALSE