DBA Data[Home] [Help]

APPS.CSP_PICKLIST_HEADER_PVT dependencies on STANDARD

Line 37: -- Standard Start of API savepoint

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,

Line 40: -- Standard call to check for call compatibility.

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)

Line 183: -- Standard check for p_commit

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;

Line 194: -- Standard call to get message count and if count is 1, get message info.

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: );

Line 306: -- Standard Start of API savepoint

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,

Line 309: -- Standard call to check for call compatibility.

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)

Line 498: -- Standard check for p_commit

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;

Line 509: -- Standard call to get message count and if count is 1, get message info.

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: );

Line 585: -- Standard Start of API savepoint

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,

Line 588: -- Standard call to check for call compatibility.

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)

Line 656: -- Standard check for p_commit

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;

Line 667: -- Standard call to get message count and if count is 1, get message info.

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: );

Line 1067: -- Standard call to get message count and if count is 1, get message info.

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: );

Line 1121: -- Standard call to get message count and if count is 1, get message info.

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: );

Line 1168: -- Standard call to get message count and if count is 1, get message info.

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: );

Line 1222: -- Standard call to get message count and if count is 1, get message info.

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: );

Line 1269: -- Standard call to get message count and if count is 1, get message info.

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: );

Line 1316: -- Standard call to get message count and if count is 1, get message info.

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: );

Line 1358: -- Standard call to get message count and if count is 1, get message info.

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: );