DBA Data[Home] [Help]

APPS.OKC_REP_WF_PVT dependencies on OKC_API

Line 908: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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;

Line 909: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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: --------------------------------------------------------

Line 910: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

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;

Line 911: RAISE OKC_API.G_EXCEPTION_ERROR;

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(

Line 950: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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;

Line 951: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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: --------------------------------------------------------

Line 952: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

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:

Line 953: RAISE OKC_API.G_EXCEPTION_ERROR;

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;

Line 1024: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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;

Line 1025: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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: --------------------------------------------------------

Line 1026: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

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;

Line 1027: RAISE OKC_API.G_EXCEPTION_ERROR;

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:

Line 1225: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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;

Line 1226: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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: --------------------------------------------------------

Line 1227: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

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;

Line 1228: RAISE OKC_API.G_EXCEPTION_ERROR;

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

Line 1273: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) 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;

Line 1274: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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: --------------------------------------------------------

Line 1275: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

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:

Line 1276: RAISE OKC_API.G_EXCEPTION_ERROR;

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;

Line 1348: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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;

Line 1349: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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: --------------------------------------------------------

Line 1350: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

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;

Line 1351: RAISE OKC_API.G_EXCEPTION_ERROR;

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:

Line 1492: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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;

Line 1493: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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: --------------------------------------------------------

Line 1494: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

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:';

Line 1495: RAISE OKC_API.G_EXCEPTION_ERROR;

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

Line 1612: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) 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;

Line 1613: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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: --------------------------------------------------------

Line 1614: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

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:

Line 1615: RAISE OKC_API.G_EXCEPTION_ERROR;

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:';