33: l_api_version_number CONSTANT NUMBER := 1.0;
34: l_return_status_full VARCHAR2(1);
35: --l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
36: BEGIN
37: -- Standard Start of API savepoint
38: SAVEPOINT CREATE_picklist_header_PVT;
39:
40: -- Standard call to check for call compatibility.
41: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
36: BEGIN
37: -- Standard Start of API savepoint
38: SAVEPOINT CREATE_picklist_header_PVT;
39:
40: -- Standard call to check for call compatibility.
41: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
42: p_api_version_number,
43: l_api_name,
44: G_PKG_NAME)
179: --
180: -- End of API body
181: --
182:
183: -- Standard check for p_commit
184: IF FND_API.to_Boolean( p_commit )
185: THEN
186: COMMIT WORK;
187: END IF;
190: -- Debug Message
191: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
192:
193:
194: -- Standard call to get message count and if count is 1, get message info.
195: FND_MSG_PUB.Count_And_Get
196: ( p_count => x_msg_count,
197: p_data => x_msg_data
198: );
302: l_ref_PICK_HEADER_rec CSP_picklist_header_PVT.PICK_HEADER_Rec_Type;
303: l_tar_PICK_HEADER_rec CSP_picklist_header_PVT.PICK_HEADER_Rec_Type := P_PICK_HEADER_Rec;
304: l_rowid ROWID;
305: BEGIN
306: -- Standard Start of API savepoint
307: SAVEPOINT UPDATE_picklist_header_PVT;
308:
309: -- Standard call to check for call compatibility.
310: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
305: BEGIN
306: -- Standard Start of API savepoint
307: SAVEPOINT UPDATE_picklist_header_PVT;
308:
309: -- Standard call to check for call compatibility.
310: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
311: p_api_version_number,
312: l_api_name,
313: G_PKG_NAME)
494: --
495: -- End of API body.
496: --
497:
498: -- Standard check for p_commit
499: IF FND_API.to_Boolean( p_commit )
500: THEN
501: COMMIT WORK;
502: END IF;
505: -- Debug Message
506: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
507:
508:
509: -- Standard call to get message count and if count is 1, get message info.
510: FND_MSG_PUB.Count_And_Get
511: ( p_count => x_msg_count,
512: p_data => x_msg_data
513: );
581: l_api_name CONSTANT VARCHAR2(30) := 'Delete_picklist_header';
582: l_api_version_number CONSTANT NUMBER := 1.0;
583: --l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
584: BEGIN
585: -- Standard Start of API savepoint
586: SAVEPOINT DELETE_picklist_header_PVT;
587:
588: -- Standard call to check for call compatibility.
589: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
584: BEGIN
585: -- Standard Start of API savepoint
586: SAVEPOINT DELETE_picklist_header_PVT;
587:
588: -- Standard call to check for call compatibility.
589: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
590: p_api_version_number,
591: l_api_name,
592: G_PKG_NAME)
652: --
653: -- End of API body
654: --
655:
656: -- Standard check for p_commit
657: IF FND_API.to_Boolean( p_commit )
658: THEN
659: COMMIT WORK;
660: END IF;
663: -- Debug Message
664: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
665:
666:
667: -- Standard call to get message count and if count is 1, get message info.
668: FND_MSG_PUB.Count_And_Get
669: ( p_count => x_msg_count,
670: p_data => x_msg_data
671: );
1063: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1064: NULL;
1065: END IF;
1066:
1067: -- Standard call to get message count and if count is 1, get message info.
1068: FND_MSG_PUB.Count_And_Get
1069: ( p_count => x_msg_count,
1070: p_data => x_msg_data
1071: );
1117: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1118: NULL;
1119: END IF;
1120:
1121: -- Standard call to get message count and if count is 1, get message info.
1122: FND_MSG_PUB.Count_And_Get
1123: ( p_count => x_msg_count,
1124: p_data => x_msg_data
1125: );
1164: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1165: NULL;
1166: END IF;
1167:
1168: -- Standard call to get message count and if count is 1, get message info.
1169: FND_MSG_PUB.Count_And_Get
1170: ( p_count => x_msg_count,
1171: p_data => x_msg_data
1172: );
1218: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1219: NULL;
1220: END IF;
1221:
1222: -- Standard call to get message count and if count is 1, get message info.
1223: FND_MSG_PUB.Count_And_Get
1224: ( p_count => x_msg_count,
1225: p_data => x_msg_data
1226: );
1265: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1266: NULL;
1267: END IF;
1268:
1269: -- Standard call to get message count and if count is 1, get message info.
1270: FND_MSG_PUB.Count_And_Get
1271: ( p_count => x_msg_count,
1272: p_data => x_msg_data
1273: );
1312: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1313: NULL;
1314: END IF;
1315:
1316: -- Standard call to get message count and if count is 1, get message info.
1317: FND_MSG_PUB.Count_And_Get
1318: ( p_count => x_msg_count,
1319: p_data => x_msg_data
1320: );
1354:
1355: -- Debug Message
1356: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Error', 'API_INVALID_RECORD');
1357:
1358: -- Standard call to get message count and if count is 1, get message info.
1359: FND_MSG_PUB.Count_And_Get
1360: ( p_count => x_msg_count,
1361: p_data => x_msg_data
1362: );