94:
95: IEM_SERVICEREQUEST_NOT_CREATE EXCEPTION;
96:
97: BEGIN
98: -- Standard Start of API savepoint
99: SAVEPOINT Create_ServiceRequest_Wrap;
100:
101: -- Standard call to check for call compatibility.
102: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
97: BEGIN
98: -- Standard Start of API savepoint
99: SAVEPOINT Create_ServiceRequest_Wrap;
100:
101: -- Standard call to check for call compatibility.
102: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
103: p_api_version,
104: l_api_name,
105: G_PKG_NAME)
317: end if;
318:
319: x_return_status := l_return_status ;
320:
321: --Standard check of p_commit
322: IF FND_API.to_Boolean(p_commit) THEN
323: COMMIT WORK;
324: END IF;
325:
401:
402: IEM_SERVICEREQUEST_NOT_UPDATED EXCEPTION;
403:
404: BEGIN
405: -- Standard Start of API savepoint
406: SAVEPOINT Update_ServiceRequest_Wrap;
407: -- Standard call to check for call compatibility.
408: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
409: p_api_version,
403:
404: BEGIN
405: -- Standard Start of API savepoint
406: SAVEPOINT Update_ServiceRequest_Wrap;
407: -- Standard call to check for call compatibility.
408: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
409: p_api_version,
410: l_api_name,
411: G_PKG_NAME)
618: raise IEM_SERVICEREQUEST_NOT_UPDATED;
619: end if;
620:
621: x_return_status := l_return_status ;
622: --Standard check of p_commit
623: IF FND_API.to_Boolean(p_commit) THEN
624: COMMIT WORK;
625: END IF;
626:
844:
845: IEM_UPDATE_SR_STATUS_FAIL EXCEPTION;
846:
847: begin
848: -- Standard Start of API savepoint
849: SAVEPOINT Update_Status_Wrap;
850:
851: -- Standard call to check for call compatibility.
852: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
847: begin
848: -- Standard Start of API savepoint
849: SAVEPOINT Update_Status_Wrap;
850:
851: -- Standard call to check for call compatibility.
852: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
853: p_api_version,
854: l_api_name,
855: G_PKG_NAME)
917: end if;
918:
919: x_return_status := l_return_status ;
920:
921: --Standard check of p_commit
922: IF FND_API.to_Boolean(p_commit) THEN
923: COMMIT WORK;
924: END IF;
925:
1023: -- end of addition for bug 12663292
1024:
1025: BEGIN
1026:
1027: -- Standard Start of API savepoint
1028: SAVEPOINT IEM_CREATE_SR;
1029:
1030: -- Standard call to check for call compatibility.
1031: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1026:
1027: -- Standard Start of API savepoint
1028: SAVEPOINT IEM_CREATE_SR;
1029:
1030: -- Standard call to check for call compatibility.
1031: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1032: p_api_version,
1033: l_api_name,
1034: G_PKG_NAME)
1170:
1171: x_return_status := l_return_status ;
1172: x_request_id := l_sr_create_out_rec.request_id;
1173:
1174: --Standard check of p_commit
1175: IF FND_API.to_Boolean(p_commit) THEN
1176: COMMIT WORK;
1177: END IF;
1178: