DBA Data[Home] [Help]

APPS.CSP_REQUIREMENT_HEADERS_PVT dependencies on STANDARD

Line 34: -- Standard Start of API savepoint

30: l_api_version_number CONSTANT NUMBER := 1.0;
31: l_return_status_full VARCHAR2(1);
32: l_access_flag VARCHAR2(1);
33: BEGIN
34: -- Standard Start of API savepoint
35: SAVEPOINT CREATE_Requirement_headers_PUB;
36:
37: -- Standard call to check for call compatibility.
38: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

33: BEGIN
34: -- Standard Start of API savepoint
35: SAVEPOINT CREATE_Requirement_headers_PUB;
36:
37: -- Standard call to check for call compatibility.
38: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
39: p_api_version_number,
40: l_api_name,
41: G_PKG_NAME)

Line 168: -- Standard check for p_commit

164: --
165: -- End of API body
166: --
167:
168: -- Standard check for p_commit
169: IF FND_API.to_Boolean( p_commit )
170: THEN
171: COMMIT WORK;
172: END IF;

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

175: -- Debug Message
176: --JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
177:
178:
179: -- Standard call to get message count and if count is 1, get message info.
180: /* FND_MSG_PUB.Count_And_Get
181: ( p_count => x_msg_count,
182: p_data => x_msg_data
183: ); */

Line 275: -- Standard Start of API savepoint

271: l_ref_REQUIREMENT_HEADER_rec CSP_requirement_headers_PVT.REQUIREMENT_HEADER_Rec_Type;
272: l_tar_REQUIREMENT_HEADER_rec CSP_requirement_headers_PVT.REQUIREMENT_HEADER_Rec_Type := P_REQUIREMENT_HEADER_Rec;
273: l_rowid ROWID;
274: BEGIN
275: -- Standard Start of API savepoint
276: SAVEPOINT UPDATE_Requirement_headers_PUB;
277:
278: -- Standard call to check for call compatibility.
279: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

274: BEGIN
275: -- Standard Start of API savepoint
276: SAVEPOINT UPDATE_Requirement_headers_PUB;
277:
278: -- Standard call to check for call compatibility.
279: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
280: p_api_version_number,
281: l_api_name,
282: G_PKG_NAME)

Line 471: -- Standard check for p_commit

467: --
468: -- End of API body.
469: --
470:
471: -- Standard check for p_commit
472: IF FND_API.to_Boolean( p_commit )
473: THEN
474: COMMIT WORK;
475: END IF;

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

478: -- Debug Message
479: --JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
480:
481:
482: -- Standard call to get message count and if count is 1, get message info.
483: FND_MSG_PUB.Count_And_Get
484: ( p_count => x_msg_count,
485: p_data => x_msg_data
486: );

Line 537: -- Standard Start of API savepoint

533: IS
534: l_api_name CONSTANT VARCHAR2(30) := 'Delete_requirement_headers';
535: l_api_version_number CONSTANT NUMBER := 1.0;
536: BEGIN
537: -- Standard Start of API savepoint
538: SAVEPOINT DELETE_Requirement_headers_PUB;
539:
540: -- Standard call to check for call compatibility.
541: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

536: BEGIN
537: -- Standard Start of API savepoint
538: SAVEPOINT DELETE_Requirement_headers_PUB;
539:
540: -- Standard call to check for call compatibility.
541: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
542: p_api_version_number,
543: l_api_name,
544: G_PKG_NAME)

Line 582: -- Standard check for p_commit

578: --
579: -- End of API body
580: --
581:
582: -- Standard check for p_commit
583: IF FND_API.to_Boolean( p_commit )
584: THEN
585: COMMIT WORK;
586: END IF;

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

589: -- Debug Message
590: -- JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
591:
592:
593: -- Standard call to get message count and if count is 1, get message info.
594: FND_MSG_PUB.Count_And_Get
595: ( p_count => x_msg_count,
596: p_data => x_msg_data
597: );

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

934: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
935: NULL;
936: END IF;
937:
938: -- Standard call to get message count and if count is 1, get message info.
939: FND_MSG_PUB.Count_And_Get
940: ( p_count => x_msg_count,
941: p_data => x_msg_data
942: );

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

981: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
982: NULL;
983: END IF;
984:
985: -- Standard call to get message count and if count is 1, get message info.
986: FND_MSG_PUB.Count_And_Get
987: ( p_count => x_msg_count,
988: p_data => x_msg_data
989: );

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

1028: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1029: NULL;
1030: END IF;
1031:
1032: -- Standard call to get message count and if count is 1, get message info.
1033: FND_MSG_PUB.Count_And_Get
1034: ( p_count => x_msg_count,
1035: p_data => x_msg_data
1036: );

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

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

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

1122: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1123: NULL;
1124: END IF;
1125:
1126: -- Standard call to get message count and if count is 1, get message info.
1127: FND_MSG_PUB.Count_And_Get
1128: ( p_count => x_msg_count,
1129: p_data => x_msg_data
1130: );

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

1169: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1170: NULL;
1171: END IF;
1172:
1173: -- Standard call to get message count and if count is 1, get message info.
1174: FND_MSG_PUB.Count_And_Get
1175: ( p_count => x_msg_count,
1176: p_data => x_msg_data
1177: );

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

1216: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1217: NULL;
1218: END IF;
1219:
1220: -- Standard call to get message count and if count is 1, get message info.
1221: FND_MSG_PUB.Count_And_Get
1222: ( p_count => x_msg_count,
1223: p_data => x_msg_data
1224: );

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

1263: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1264: NULL;
1265: END IF;
1266:
1267: -- Standard call to get message count and if count is 1, get message info.
1268: FND_MSG_PUB.Count_And_Get
1269: ( p_count => x_msg_count,
1270: p_data => x_msg_data
1271: );

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

1310: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1311: NULL;
1312: END IF;
1313:
1314: -- Standard call to get message count and if count is 1, get message info.
1315: FND_MSG_PUB.Count_And_Get
1316: ( p_count => x_msg_count,
1317: p_data => x_msg_data
1318: );

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

1352:
1353: -- Debug Message
1354: JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'API_INVALID_RECORD');
1355:
1356: -- Standard call to get message count and if count is 1, get message info.
1357: FND_MSG_PUB.Count_And_Get
1358: ( p_count => x_msg_count,
1359: p_data => x_msg_data
1360: );