[Home] [Help]
39: l_creation_date DATE := P_psl_Rec.creation_date;
40: l_last_update_date DATE := P_psl_Rec.last_update_date;
41:
42: BEGIN
43: -- Standard Start of API savepoint
44: SAVEPOINT CREATE_pick_serial_lots_PVT;
45:
46: -- Standard call to check for call compatibility.
47: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
42: BEGIN
43: -- Standard Start of API savepoint
44: SAVEPOINT CREATE_pick_serial_lots_PVT;
45:
46: -- Standard call to check for call compatibility.
47: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
48: p_api_version_number,
49: l_api_name,
50: G_PKG_NAME)
182: --
183: -- End of API body
184: --
185:
186: -- Standard check for p_commit
187: IF FND_API.to_Boolean( p_commit )
188: THEN
189: COMMIT WORK;
190: END IF;
193: -- Debug Message
194: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: ' || l_api_name || 'end');
195:
196:
197: -- Standard call to get message count and if count is 1, get message info.
198: FND_MSG_PUB.Count_And_Get
199: ( p_count => x_msg_count,
200: p_data => x_msg_data
201: );
290: l_ref_psl_rec csp_pick_serial_lots_PVT.psl_Rec_Type;
291: l_tar_psl_rec csp_pick_serial_lots_PVT.psl_Rec_Type := P_psl_Rec;
292: l_rowid ROWID;
293: BEGIN
294: -- Standard Start of API savepoint
295: SAVEPOINT UPDATE_pick_serial_lots_PVT;
296:
297: -- Standard call to check for call compatibility.
298: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
293: BEGIN
294: -- Standard Start of API savepoint
295: SAVEPOINT UPDATE_pick_serial_lots_PVT;
296:
297: -- Standard call to check for call compatibility.
298: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
299: p_api_version_number,
300: l_api_name,
301: G_PKG_NAME)
452: --
453: -- End of API body.
454: --
455:
456: -- Standard check for p_commit
457: IF FND_API.to_Boolean( p_commit )
458: THEN
459: COMMIT WORK;
460: END IF;
463: -- Debug Message
464: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: ' || l_api_name || 'end');
465:
466:
467: -- Standard call to get message count and if count is 1, get message info.
468: FND_MSG_PUB.Count_And_Get
469: ( p_count => x_msg_count,
470: p_data => x_msg_data
471: );
539: l_api_name CONSTANT VARCHAR2(30) := 'Delete_pick_serial_lots';
540: l_api_version_number CONSTANT NUMBER := 1.0;
541: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
542: BEGIN
543: -- Standard Start of API savepoint
544: SAVEPOINT DELETE_pick_serial_lots_PVT;
545:
546: -- Standard call to check for call compatibility.
547: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
542: BEGIN
543: -- Standard Start of API savepoint
544: SAVEPOINT DELETE_pick_serial_lots_PVT;
545:
546: -- Standard call to check for call compatibility.
547: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
548: p_api_version_number,
549: l_api_name,
550: G_PKG_NAME)
611: --
612: -- End of API body
613: --
614:
615: -- Standard check for p_commit
616: IF FND_API.to_Boolean( p_commit )
617: THEN
618: COMMIT WORK;
619: END IF;
622: -- Debug Message
623: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: ' || l_api_name || 'end');
624:
625:
626: -- Standard call to get message count and if count is 1, get message info.
627: FND_MSG_PUB.Count_And_Get
628: ( p_count => x_msg_count,
629: p_data => x_msg_data
630: );
976: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
977: NULL;
978: END IF;
979:
980: -- Standard call to get message count and if count is 1, get message info.
981: FND_MSG_PUB.Count_And_Get
982: ( p_count => x_msg_count,
983: p_data => x_msg_data
984: );
1030: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1031: NULL;
1032: END IF;
1033:
1034: -- Standard call to get message count and if count is 1, get message info.
1035: FND_MSG_PUB.Count_And_Get
1036: ( p_count => x_msg_count,
1037: p_data => x_msg_data
1038: );
1084: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1085: NULL;
1086: END IF;
1087:
1088: -- Standard call to get message count and if count is 1, get message info.
1089: FND_MSG_PUB.Count_And_Get
1090: ( p_count => x_msg_count,
1091: p_data => x_msg_data
1092: );
1138: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1139: NULL;
1140: END IF;
1141:
1142: -- Standard call to get message count and if count is 1, get message info.
1143: FND_MSG_PUB.Count_And_Get
1144: ( p_count => x_msg_count,
1145: p_data => x_msg_data
1146: );
1192: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1193: NULL;
1194: END IF;
1195:
1196: -- Standard call to get message count and if count is 1, get message info.
1197: FND_MSG_PUB.Count_And_Get
1198: ( p_count => x_msg_count,
1199: p_data => x_msg_data
1200: );
1239: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1240: NULL;
1241: END IF;
1242:
1243: -- Standard call to get message count and if count is 1, get message info.
1244: FND_MSG_PUB.Count_And_Get
1245: ( p_count => x_msg_count,
1246: p_data => x_msg_data
1247: );
1286: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1287: NULL;
1288: END IF;
1289:
1290: -- Standard call to get message count and if count is 1, get message info.
1291: FND_MSG_PUB.Count_And_Get
1292: ( p_count => x_msg_count,
1293: p_data => x_msg_data
1294: );
1328:
1329: -- Debug Message
1330: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'API_INVALID_RECORD');
1331:
1332: -- Standard call to get message count and if count is 1, get message info.
1333: FND_MSG_PUB.Count_And_Get
1334: ( p_count => x_msg_count,
1335: p_data => x_msg_data
1336: );