DBA Data[Home] [Help]

APPS.CSP_PICKLIST_LINES_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_lines_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_lines_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 184: -- Standard check for p_commit

180: --
181: -- End of API body
182: --
183:
184: -- Standard check for p_commit
185: IF FND_API.to_Boolean( p_commit )
186: THEN
187: COMMIT WORK;
188: END IF;

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

191: -- Debug Message
192: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Error','Private API: ' || l_api_name || 'end');
193:
194:
195: -- Standard call to get message count and if count is 1, get message info.
196: FND_MSG_PUB.Count_And_Get
197: ( p_count => x_msg_count,
198: p_data => x_msg_data
199: );

Line 310: -- Standard Start of API savepoint

306: l_ref_picklist_line_rec CSP_picklist_lines_PVT.picklist_line_Rec_Type;
307: l_tar_picklist_line_rec CSP_picklist_lines_PVT.picklist_line_Rec_Type := P_picklist_line_Rec;
308: l_rowid ROWID;
309: BEGIN
310: -- Standard Start of API savepoint
311: SAVEPOINT UPDATE_picklist_lines_PVT;
312:
313: -- Standard call to check for call compatibility.
314: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

309: BEGIN
310: -- Standard Start of API savepoint
311: SAVEPOINT UPDATE_picklist_lines_PVT;
312:
313: -- Standard call to check for call compatibility.
314: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
315: p_api_version_number,
316: l_api_name,
317: G_PKG_NAME)

Line 505: -- Standard check for p_commit

501: p_ATTRIBUTE15 => p_picklist_line_rec.ATTRIBUTE15);
502: --
503: -- End of API body.
504: --
505: -- Standard check for p_commit
506: IF FND_API.to_Boolean( p_commit )
507: THEN
508: COMMIT WORK;
509: END IF;

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

512: -- Debug Message
513: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Error','Private API: ' || l_api_name || 'end');
514:
515:
516: -- Standard call to get message count and if count is 1, get message info.
517: FND_MSG_PUB.Count_And_Get
518: ( p_count => x_msg_count,
519: p_data => x_msg_data
520: );

Line 592: -- Standard Start of API savepoint

588: l_api_name CONSTANT VARCHAR2(30) := 'Delete_picklist_lines';
589: l_api_version_number CONSTANT NUMBER := 1.0;
590: --l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
591: BEGIN
592: -- Standard Start of API savepoint
593: SAVEPOINT DELETE_picklist_lines_PVT;
594:
595: -- Standard call to check for call compatibility.
596: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

591: BEGIN
592: -- Standard Start of API savepoint
593: SAVEPOINT DELETE_picklist_lines_PVT;
594:
595: -- Standard call to check for call compatibility.
596: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
597: p_api_version_number,
598: l_api_name,
599: G_PKG_NAME)

Line 663: -- Standard check for p_commit

659: --
660: -- End of API body
661: --
662:
663: -- Standard check for p_commit
664: IF FND_API.to_Boolean( p_commit )
665: THEN
666: COMMIT WORK;
667: END IF;

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

670: -- Debug Message
671: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Error','Private API: ' || l_api_name || 'end');
672:
673:
674: -- Standard call to get message count and if count is 1, get message info.
675: FND_MSG_PUB.Count_And_Get
676: ( p_count => x_msg_count,
677: p_data => x_msg_data
678: );

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

1078: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1079: NULL;
1080: END IF;
1081:
1082: -- Standard call to get message count and if count is 1, get message info.
1083: FND_MSG_PUB.Count_And_Get
1084: ( p_count => x_msg_count,
1085: p_data => x_msg_data
1086: );

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

1132: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1133: NULL;
1134: END IF;
1135:
1136: -- Standard call to get message count and if count is 1, get message info.
1137: FND_MSG_PUB.Count_And_Get
1138: ( p_count => x_msg_count,
1139: p_data => x_msg_data
1140: );

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

1186: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1187: NULL;
1188: END IF;
1189:
1190: -- Standard call to get message count and if count is 1, get message info.
1191: FND_MSG_PUB.Count_And_Get
1192: ( p_count => x_msg_count,
1193: p_data => x_msg_data
1194: );

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

1240: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1241: NULL;
1242: END IF;
1243:
1244: -- Standard call to get message count and if count is 1, get message info.
1245: FND_MSG_PUB.Count_And_Get
1246: ( p_count => x_msg_count,
1247: p_data => x_msg_data
1248: );

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

1294: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1295: NULL;
1296: END IF;
1297:
1298: -- Standard call to get message count and if count is 1, get message info.
1299: FND_MSG_PUB.Count_And_Get
1300: ( p_count => x_msg_count,
1301: p_data => x_msg_data
1302: );

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

1348: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1349: NULL;
1350: END IF;
1351:
1352: -- Standard call to get message count and if count is 1, get message info.
1353: FND_MSG_PUB.Count_And_Get
1354: ( p_count => x_msg_count,
1355: p_data => x_msg_data
1356: );

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

1395: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1396: NULL;
1397: END IF;
1398:
1399: -- Standard call to get message count and if count is 1, get message info.
1400: FND_MSG_PUB.Count_And_Get
1401: ( p_count => x_msg_count,
1402: p_data => x_msg_data
1403: );

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

1449: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1450: NULL;
1451: END IF;
1452:
1453: -- Standard call to get message count and if count is 1, get message info.
1454: FND_MSG_PUB.Count_And_Get
1455: ( p_count => x_msg_count,
1456: p_data => x_msg_data
1457: );

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

1503: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1504: NULL;
1505: END IF;
1506:
1507: -- Standard call to get message count and if count is 1, get message info.
1508: FND_MSG_PUB.Count_And_Get
1509: ( p_count => x_msg_count,
1510: p_data => x_msg_data
1511: );

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

1545:
1546: -- Debug Message
1547: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ERROR', 'API_INVALID_RECORD');
1548:
1549: -- Standard call to get message count and if count is 1, get message info.
1550: FND_MSG_PUB.Count_And_Get
1551: ( p_count => x_msg_count,
1552: p_data => x_msg_data
1553: );