[Home] [Help]
39: l_creation_date DATE := P_plsl_Rec.creation_date;
40: l_last_update_date DATE := P_plsl_Rec.last_update_date;
41:
42: BEGIN
43: -- Standard Start of API savepoint
44: SAVEPOINT CREATE_Pack_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_Pack_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)
181: --
182: -- End of API body
183: --
184:
185: -- Standard check for p_commit
186: IF FND_API.to_Boolean( p_commit )
187: THEN
188: COMMIT WORK;
189: END IF;
192: -- Debug Message
193: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: ' || l_api_name || 'end');
194:
195:
196: -- Standard call to get message count and if count is 1, get message info.
197: FND_MSG_PUB.Count_And_Get
198: ( p_count => x_msg_count,
199: p_data => x_msg_data
200: );
289: l_ref_plsl_rec CSP_pack_serial_lots_PVT.plsl_Rec_Type;
290: l_tar_plsl_rec CSP_pack_serial_lots_PVT.plsl_Rec_Type := P_plsl_Rec;
291: l_rowid ROWID;
292: BEGIN
293: -- Standard Start of API savepoint
294: SAVEPOINT UPDATE_Pack_Serial_Lots_PVT;
295:
296: -- Standard call to check for call compatibility.
297: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
292: BEGIN
293: -- Standard Start of API savepoint
294: SAVEPOINT UPDATE_Pack_Serial_Lots_PVT;
295:
296: -- Standard call to check for call compatibility.
297: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
298: p_api_version_number,
299: l_api_name,
300: 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_pack_serial_lots';
540: l_api_version_number CONSTANT NUMBER := 2.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_Pack_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_Pack_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)
612: --
613: -- End of API body
614: --
615:
616: -- Standard check for p_commit
617: IF FND_API.to_Boolean( p_commit )
618: THEN
619: COMMIT WORK;
620: END IF;
623: -- Debug Message
624: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: ' || l_api_name || 'end');
625:
626:
627: -- Standard call to get message count and if count is 1, get message info.
628: FND_MSG_PUB.Count_And_Get
629: ( p_count => x_msg_count,
630: p_data => x_msg_data
631: );
946: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
947: NULL;
948: END IF;
949:
950: -- Standard call to get message count and if count is 1, get message info.
951: FND_MSG_PUB.Count_And_Get
952: ( p_count => x_msg_count,
953: p_data => x_msg_data
954: );
1000: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1001: NULL;
1002: END IF;
1003:
1004: -- Standard call to get message count and if count is 1, get message info.
1005: FND_MSG_PUB.Count_And_Get
1006: ( p_count => x_msg_count,
1007: p_data => x_msg_data
1008: );
1054: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1055: NULL;
1056: END IF;
1057:
1058: -- Standard call to get message count and if count is 1, get message info.
1059: FND_MSG_PUB.Count_And_Get
1060: ( p_count => x_msg_count,
1061: p_data => x_msg_data
1062: );
1108: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1109: NULL;
1110: END IF;
1111:
1112: -- Standard call to get message count and if count is 1, get message info.
1113: FND_MSG_PUB.Count_And_Get
1114: ( p_count => x_msg_count,
1115: p_data => x_msg_data
1116: );
1162: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1163: NULL;
1164: END IF;
1165:
1166: -- Standard call to get message count and if count is 1, get message info.
1167: FND_MSG_PUB.Count_And_Get
1168: ( p_count => x_msg_count,
1169: p_data => x_msg_data
1170: );
1209: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1210: NULL;
1211: END IF;
1212:
1213: -- Standard call to get message count and if count is 1, get message info.
1214: FND_MSG_PUB.Count_And_Get
1215: ( p_count => x_msg_count,
1216: p_data => x_msg_data
1217: );
1256: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1257: NULL;
1258: END IF;
1259:
1260: -- Standard call to get message count and if count is 1, get message info.
1261: FND_MSG_PUB.Count_And_Get
1262: ( p_count => x_msg_count,
1263: p_data => x_msg_data
1264: );
1298:
1299: -- Debug Message
1300: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'API_INVALID_RECORD');
1301:
1302: -- Standard call to get message count and if count is 1, get message info.
1303: FND_MSG_PUB.Count_And_Get
1304: ( p_count => x_msg_count,
1305: p_data => x_msg_data
1306: );