88:
89: IEM_SERVICEREQUEST_NOT_CREATE EXCEPTION;
90:
91: BEGIN
92: -- Standard Start of API savepoint
93: SAVEPOINT Create_ServiceRequest_Wrap;
94:
95: -- Standard call to check for call compatibility.
96: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
91: BEGIN
92: -- Standard Start of API savepoint
93: SAVEPOINT Create_ServiceRequest_Wrap;
94:
95: -- Standard call to check for call compatibility.
96: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
97: p_api_version,
98: l_api_name,
99: G_PKG_NAME)
311: end if;
312:
313: x_return_status := l_return_status ;
314:
315: --Standard check of p_commit
316: IF FND_API.to_Boolean(p_commit) THEN
317: COMMIT WORK;
318: END IF;
319:
395:
396: IEM_SERVICEREQUEST_NOT_UPDATED EXCEPTION;
397:
398: BEGIN
399: -- Standard Start of API savepoint
400: SAVEPOINT Update_ServiceRequest_Wrap;
401: -- Standard call to check for call compatibility.
402: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
403: p_api_version,
397:
398: BEGIN
399: -- Standard Start of API savepoint
400: SAVEPOINT Update_ServiceRequest_Wrap;
401: -- Standard call to check for call compatibility.
402: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
403: p_api_version,
404: l_api_name,
405: G_PKG_NAME)
612: raise IEM_SERVICEREQUEST_NOT_UPDATED;
613: end if;
614:
615: x_return_status := l_return_status ;
616: --Standard check of p_commit
617: IF FND_API.to_Boolean(p_commit) THEN
618: COMMIT WORK;
619: END IF;
620:
838:
839: IEM_UPDATE_SR_STATUS_FAIL EXCEPTION;
840:
841: begin
842: -- Standard Start of API savepoint
843: SAVEPOINT Update_Status_Wrap;
844:
845: -- Standard call to check for call compatibility.
846: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
841: begin
842: -- Standard Start of API savepoint
843: SAVEPOINT Update_Status_Wrap;
844:
845: -- Standard call to check for call compatibility.
846: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
847: p_api_version,
848: l_api_name,
849: G_PKG_NAME)
911: end if;
912:
913: x_return_status := l_return_status ;
914:
915: --Standard check of p_commit
916: IF FND_API.to_Boolean(p_commit) THEN
917: COMMIT WORK;
918: END IF;
919:
1009: l_coverage_template_id NUMBER;
1010:
1011: BEGIN
1012:
1013: -- Standard Start of API savepoint
1014: SAVEPOINT IEM_CREATE_SR;
1015:
1016: -- Standard call to check for call compatibility.
1017: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1012:
1013: -- Standard Start of API savepoint
1014: SAVEPOINT IEM_CREATE_SR;
1015:
1016: -- Standard call to check for call compatibility.
1017: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1018: p_api_version,
1019: l_api_name,
1020: G_PKG_NAME)
1119:
1120: x_return_status := l_return_status ;
1121: x_request_id := l_sr_create_out_rec.request_id;
1122:
1123: --Standard check of p_commit
1124: IF FND_API.to_Boolean(p_commit) THEN
1125: COMMIT WORK;
1126: END IF;
1127: