904: g_module || l_api_name,
905: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
906: END IF;
907: -------------------------------------------------------
908: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
909: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
910: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
911: RAISE OKC_API.G_EXCEPTION_ERROR;
912: END IF;
905: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
906: END IF;
907: -------------------------------------------------------
908: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
909: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
910: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
911: RAISE OKC_API.G_EXCEPTION_ERROR;
912: END IF;
913: --------------------------------------------------------
906: END IF;
907: -------------------------------------------------------
908: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
909: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
910: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
911: RAISE OKC_API.G_EXCEPTION_ERROR;
912: END IF;
913: --------------------------------------------------------
914: l_approver_record2.approval_status := ame_util.approvedStatus;
907: -------------------------------------------------------
908: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
909: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
910: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
911: RAISE OKC_API.G_EXCEPTION_ERROR;
912: END IF;
913: --------------------------------------------------------
914: l_approver_record2.approval_status := ame_util.approvedStatus;
915: ame_api2.updateApprovalStatus(
946: g_module || l_api_name,
947: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
948: END IF;
949: -------------------------------------------------------
950: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
951: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
952: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
953: RAISE OKC_API.G_EXCEPTION_ERROR;
954: END IF;
947: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
948: END IF;
949: -------------------------------------------------------
950: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
951: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
952: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
953: RAISE OKC_API.G_EXCEPTION_ERROR;
954: END IF;
955: --------------------------------------------------------
948: END IF;
949: -------------------------------------------------------
950: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
951: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
952: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
953: RAISE OKC_API.G_EXCEPTION_ERROR;
954: END IF;
955: --------------------------------------------------------
956:
949: -------------------------------------------------------
950: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
951: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
952: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
953: RAISE OKC_API.G_EXCEPTION_ERROR;
954: END IF;
955: --------------------------------------------------------
956:
957: l_approver_record2.approval_status := ame_util.rejectStatus;
1020: g_module || l_api_name,
1021: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
1022: END IF;
1023: -------------------------------------------------------
1024: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1025: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1026: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1027: RAISE OKC_API.G_EXCEPTION_ERROR;
1028: END IF;
1021: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
1022: END IF;
1023: -------------------------------------------------------
1024: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1025: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1026: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1027: RAISE OKC_API.G_EXCEPTION_ERROR;
1028: END IF;
1029: --------------------------------------------------------
1022: END IF;
1023: -------------------------------------------------------
1024: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1025: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1026: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1027: RAISE OKC_API.G_EXCEPTION_ERROR;
1028: END IF;
1029: --------------------------------------------------------
1030: l_approver_record2.approval_status := ame_util.noResponseStatus;
1023: -------------------------------------------------------
1024: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1025: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1026: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1027: RAISE OKC_API.G_EXCEPTION_ERROR;
1028: END IF;
1029: --------------------------------------------------------
1030: l_approver_record2.approval_status := ame_util.noResponseStatus;
1031:
1221: g_module || l_api_name,
1222: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
1223: END IF;
1224: -------------------------------------------------------
1225: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1226: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1227: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1228: RAISE OKC_API.G_EXCEPTION_ERROR;
1229: END IF;
1222: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
1223: END IF;
1224: -------------------------------------------------------
1225: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1226: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1227: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1228: RAISE OKC_API.G_EXCEPTION_ERROR;
1229: END IF;
1230: --------------------------------------------------------
1223: END IF;
1224: -------------------------------------------------------
1225: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1226: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1227: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1228: RAISE OKC_API.G_EXCEPTION_ERROR;
1229: END IF;
1230: --------------------------------------------------------
1231: l_approver_record2.approval_status := ame_util.approvedStatus;
1224: -------------------------------------------------------
1225: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1226: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1227: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1228: RAISE OKC_API.G_EXCEPTION_ERROR;
1229: END IF;
1230: --------------------------------------------------------
1231: l_approver_record2.approval_status := ame_util.approvedStatus;
1232: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1269: g_module || l_api_name,
1270: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
1271: END IF;
1272: -------------------------------------------------------
1273: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1274: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1275: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1276: RAISE OKC_API.G_EXCEPTION_ERROR;
1277: END IF;
1270: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
1271: END IF;
1272: -------------------------------------------------------
1273: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1274: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1275: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1276: RAISE OKC_API.G_EXCEPTION_ERROR;
1277: END IF;
1278: --------------------------------------------------------
1271: END IF;
1272: -------------------------------------------------------
1273: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1274: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1275: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1276: RAISE OKC_API.G_EXCEPTION_ERROR;
1277: END IF;
1278: --------------------------------------------------------
1279:
1272: -------------------------------------------------------
1273: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1274: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1275: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1276: RAISE OKC_API.G_EXCEPTION_ERROR;
1277: END IF;
1278: --------------------------------------------------------
1279:
1280: l_approver_record2.approval_status := ame_util.rejectStatus;
1344: g_module || l_api_name,
1345: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
1346: END IF;
1347: -------------------------------------------------------
1348: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1349: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1350: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1351: RAISE OKC_API.G_EXCEPTION_ERROR;
1352: END IF;
1345: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
1346: END IF;
1347: -------------------------------------------------------
1348: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1349: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1350: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1351: RAISE OKC_API.G_EXCEPTION_ERROR;
1352: END IF;
1353: --------------------------------------------------------
1346: END IF;
1347: -------------------------------------------------------
1348: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1349: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1350: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1351: RAISE OKC_API.G_EXCEPTION_ERROR;
1352: END IF;
1353: --------------------------------------------------------
1354: l_approver_record2.approval_status := ame_util.noResponseStatus;
1347: -------------------------------------------------------
1348: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1349: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1350: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1351: RAISE OKC_API.G_EXCEPTION_ERROR;
1352: END IF;
1353: --------------------------------------------------------
1354: l_approver_record2.approval_status := ame_util.noResponseStatus;
1355:
1488: g_module || l_api_name,
1489: 'Completed OKC_REP_UTIL_PVT.change_contract_status with return status: ' || l_return_status);
1490: END IF;
1491: -----------------------------------------------------
1492: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1493: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1494: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1495: RAISE OKC_API.G_EXCEPTION_ERROR;
1496: END IF;
1489: 'Completed OKC_REP_UTIL_PVT.change_contract_status with return status: ' || l_return_status);
1490: END IF;
1491: -----------------------------------------------------
1492: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1493: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1494: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1495: RAISE OKC_API.G_EXCEPTION_ERROR;
1496: END IF;
1497: --------------------------------------------------------
1490: END IF;
1491: -----------------------------------------------------
1492: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1493: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1494: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1495: RAISE OKC_API.G_EXCEPTION_ERROR;
1496: END IF;
1497: --------------------------------------------------------
1498: resultout := 'COMPLETE:';
1491: -----------------------------------------------------
1492: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1493: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1494: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1495: RAISE OKC_API.G_EXCEPTION_ERROR;
1496: END IF;
1497: --------------------------------------------------------
1498: resultout := 'COMPLETE:';
1499: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1608: g_module || l_api_name,
1609: 'Completed OKC_REP_UTIL_PVT.change_contract_status with return status: ' || l_return_status);
1610: END IF;
1611: -----------------------------------------------------
1612: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1613: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1614: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1615: RAISE OKC_API.G_EXCEPTION_ERROR;
1616: END IF;
1609: 'Completed OKC_REP_UTIL_PVT.change_contract_status with return status: ' || l_return_status);
1610: END IF;
1611: -----------------------------------------------------
1612: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1613: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1614: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1615: RAISE OKC_API.G_EXCEPTION_ERROR;
1616: END IF;
1617: --------------------------------------------------------
1610: END IF;
1611: -----------------------------------------------------
1612: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1613: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1614: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1615: RAISE OKC_API.G_EXCEPTION_ERROR;
1616: END IF;
1617: --------------------------------------------------------
1618:
1611: -----------------------------------------------------
1612: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1613: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1614: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1615: RAISE OKC_API.G_EXCEPTION_ERROR;
1616: END IF;
1617: --------------------------------------------------------
1618:
1619: resultout := 'COMPLETE:';