[Home] [Help]
401: --
402: BEGIN
403: --dbms_output.put_line('Create_TerrResource PVT: Entering API');
404:
405: -- Standard Start of API savepoint
406: SAVEPOINT CREATE_TERRRESOURCE_PVT;
407:
408: -- Standard call to check for call compatibility.
409: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
404:
405: -- Standard Start of API savepoint
406: SAVEPOINT CREATE_TERRRESOURCE_PVT;
407:
408: -- Standard call to check for call compatibility.
409: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
410: p_api_version_number,
411: l_api_name,
412: G_PKG_NAME)
472: fnd_message.set_name ('PROC_NAME', l_api_name);
473: fnd_msg_pub.add;
474: END IF;
475:
476: -- Standard check for p_commit
477: IF FND_API.to_Boolean( p_commit )
478: THEN
479: COMMIT WORK;
480: END IF;
596: --
597: BEGIN
598: --dbms_output.put_line('Create_TerrResource PVT: Entering API');
599:
600: -- Standard Start of API savepoint
601: SAVEPOINT CREATE_TERRRESOURCE_PVT;
602:
603: -- Standard call to check for call compatibility.
604: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
599:
600: -- Standard Start of API savepoint
601: SAVEPOINT CREATE_TERRRESOURCE_PVT;
602:
603: -- Standard call to check for call compatibility.
604: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
605: p_api_version_number,
606: l_api_name,
607: G_PKG_NAME)
826: ( p_count => x_msg_count,
827: p_data => x_msg_data
828: );
829:
830: -- Standard check for p_commit
831: IF FND_API.to_Boolean( p_commit )
832: THEN
833: COMMIT WORK;
834: END IF;
933: l_return_status VARCHAR2(1);
934:
935: BEGIN
936: --
937: -- Standard Start of API savepoint
938: SAVEPOINT DELETE_TERR_RESOURCE_PVT;
939:
940: -- Standard call to check for call compatibility.
941: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
936: --
937: -- Standard Start of API savepoint
938: SAVEPOINT DELETE_TERR_RESOURCE_PVT;
939:
940: -- Standard call to check for call compatibility.
941: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
942: p_api_version_number,
943: l_api_name,
944: G_PKG_NAME)
1012: ( p_count => x_msg_count,
1013: p_data => x_msg_data
1014: );
1015:
1016: -- Standard check for p_commit
1017: IF FND_API.to_Boolean( p_commit )
1018: THEN
1019: COMMIT WORK;
1020: END IF;
1111: l_return_status VARCHAR2(1);
1112:
1113:
1114: BEGIN
1115: -- Standard Start of API savepoint
1116: SAVEPOINT UPDATE_TERRRESOURCE_PVT;
1117:
1118: --ARPATEL: bug#2849410
1119: /* Check_for_duplicate (p_TerrRsc_Tbl => p_TerrRsc_Tbl,
1124: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1125: x_return_status := l_return_status;
1126: END IF;
1127: */
1128: -- Standard call to check for call compatibility.
1129: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1130: p_api_version_number,
1131: l_api_name,
1132: G_PKG_NAME)
1205: ( p_count => x_msg_count,
1206: p_data => x_msg_data
1207: );
1208:
1209: -- Standard check for p_commit
1210: IF FND_API.to_Boolean( p_commit )
1211: THEN
1212: COMMIT WORK;
1213: END IF;
2139: l_api_version_number CONSTANT NUMBER := 1.0;
2140: l_return_status VARCHAR2(1);
2141:
2142: BEGIN
2143: -- Standard start of PAI savepoint
2144: SAVEPOINT DELETE_TERRRSC_ACCESS_PVT;
2145:
2146: -- Standard call to check for call compatibility.
2147: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2142: BEGIN
2143: -- Standard start of PAI savepoint
2144: SAVEPOINT DELETE_TERRRSC_ACCESS_PVT;
2145:
2146: -- Standard call to check for call compatibility.
2147: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2148: p_api_version_number,
2149: l_api_name,
2150: G_PKG_NAME)
2195: ( p_count => x_msg_count,
2196: p_data => x_msg_data
2197: );
2198:
2199: -- Standard check for p_commit
2200: IF FND_API.to_Boolean( p_commit )
2201: THEN
2202: COMMIT WORK;
2203: END IF;
2278: l_api_version_number CONSTANT NUMBER := 1.0;
2279: l_return_status VARCHAR2(1);
2280:
2281: BEGIN
2282: -- Standard start of PAI savepoint
2283: SAVEPOINT DELETE_TERRRSC_PVT;
2284:
2285: -- Standard call to check for call compatibility.
2286: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2281: BEGIN
2282: -- Standard start of PAI savepoint
2283: SAVEPOINT DELETE_TERRRSC_PVT;
2284:
2285: -- Standard call to check for call compatibility.
2286: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2287: p_api_version_number,
2288: l_api_name,
2289: G_PKG_NAME)
2336: ( p_count => x_msg_count,
2337: p_data => x_msg_data
2338: );
2339:
2340: -- Standard check for p_commit
2341: IF FND_API.to_Boolean( p_commit )
2342: THEN
2343: COMMIT WORK;
2344: END IF;
4400:
4401:
4402: BEGIN
4403:
4404: -- Standard Start of API savepoint
4405: SAVEPOINT COPY_TERR_RESOURCES;
4406:
4407: /*
4408: -- Standard call to check for call compatibility.
4404: -- Standard Start of API savepoint
4405: SAVEPOINT COPY_TERR_RESOURCES;
4406:
4407: /*
4408: -- Standard call to check for call compatibility.
4409: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
4410: p_api_version_number,
4411: l_api_name,
4412: G_PKG_NAME)
4543: x_Msg_Data := l_Msg_Data;
4544: */
4545:
4546:
4547: /* Standard call to get message count and
4548: the message information */
4549:
4550: FND_MSG_PUB.Count_And_Get
4551: (
4746: and ( jt.terr_group_flag is null OR jt.terr_group_flag = 'N' )
4747: and not jt.terr_id = 1;
4748:
4749: BEGIN
4750: -- Standard Start of API savepoint
4751: SAVEPOINT TRANSFER_TERR_RES;
4752:
4753:
4754: -- Standard call to check for call compatibility.
4750: -- Standard Start of API savepoint
4751: SAVEPOINT TRANSFER_TERR_RES;
4752:
4753:
4754: -- Standard call to check for call compatibility.
4755: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
4756: p_api_version_number,
4757: l_api_name,
4758: G_PKG_NAME)
5033: ( p_count => x_msg_count,
5034: p_data => x_msg_data
5035: );
5036:
5037: -- Standard check for p_commit
5038: IF FND_API.to_Boolean( p_commit )
5039: THEN
5040: COMMIT WORK;
5041: END IF;