DBA Data[Home] [Help]

APPS.OKC_EXTEND_PVT dependencies on OKC_DEBUG

Line 842: okc_debug.set_trace_off;

838:
839:
840: FOR conditions_rec in cur_condition_headers LOOP
841: IF (l_debug = 'Y') THEN
842: okc_debug.set_trace_off;
843: END IF;
844: l_cnh_rec.id := conditions_rec.id;
845:
846: l_cnh_rec.object_version_number := conditions_rec.object_version_number;

Line 858: okc_debug.set_trace_off;

854: x_msg_data => x_msg_data,
855: p_cnhv_rec => l_cnh_rec,
856: x_cnhv_rec => i_cnh_rec);
857: IF (l_debug = 'Y') THEN
858: okc_debug.set_trace_off;
859: END IF;
860: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
861: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
862: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

Line 868: okc_debug.set_trace_on;

864: END IF;
865:
866: end LOOP;
867: IF (l_debug = 'Y') THEN
868: okc_debug.set_trace_on;
869: END IF;
870: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
871:
872: EXCEPTION

Line 875: okc_debug.set_trace_on;

871:
872: EXCEPTION
873: WHEN E_Resource_Busy THEN
874: IF (l_debug = 'Y') THEN
875: okc_debug.set_trace_on;
876: END IF;
877: x_return_status := okc_api.g_ret_sts_error;
878:
879: OKC_API.set_message(G_FND_APP,

Line 885: okc_debug.set_trace_on;

881: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
882:
883: WHEN OKC_API.G_EXCEPTION_ERROR THEN
884: IF (l_debug = 'Y') THEN
885: okc_debug.set_trace_on;
886: END IF;
887: x_return_status := OKC_API.HANDLE_EXCEPTIONS
888: (l_api_name,
889: G_PKG_NAME,

Line 897: okc_debug.set_trace_on;

893: '_PROCESS');
894:
895: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
896: IF (l_debug = 'Y') THEN
897: okc_debug.set_trace_on;
898: END IF;
899: x_return_status := OKC_API.HANDLE_EXCEPTIONS
900: (l_api_name,
901: G_PKG_NAME,

Line 908: okc_debug.set_trace_on;

904: x_msg_data,
905: '_PROCESS');
906: WHEN OTHERS THEN
907: IF (l_debug = 'Y') THEN
908: okc_debug.set_trace_on;
909: END IF;
910: x_return_status := OKC_API.HANDLE_EXCEPTIONS
911: (l_api_name,
912: G_PKG_NAME,

Line 1281: okc_debug.set_trace_off;

1277: -- This condition will imply that the dates on the contract have been changed after the user submitted
1278: -- the contract for extension. In this case skip the contract for extension and RAISE expected error.
1279:
1280: IF (l_debug = 'Y') THEN
1281: okc_debug.set_trace_off;
1282: END IF;
1283: IF cur_k_header%notfound THEN
1284:
1285: OKC_API.set_message(p_app_name => g_app_name,

Line 1294: okc_debug.set_trace_on;

1290: p_token2_value => p_extend_in_parameters_rec.p_contract_modifier);
1291:
1292: CLOSE cur_k_header;
1293: IF (l_debug = 'Y') THEN
1294: okc_debug.set_trace_on;
1295: END IF;
1296: RAISE okc_api.g_exception_error;
1297:
1298: END IF;

Line 1302: okc_debug.set_trace_on;

1298: END IF;
1299:
1300: CLOSE cur_k_header;
1301: IF (l_debug = 'Y') THEN
1302: okc_debug.set_trace_on;
1303: END IF;
1304: -- Now that the dates haven't changed validate the input arguements
1305:
1306: --dbms_output.put_line(' VALIDATE_CHR + ');

Line 1466: okc_debug.set_trace_on;

1462: EXCEPTION
1463:
1464: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1465: IF (l_debug = 'Y') THEN
1466: okc_debug.set_trace_on;
1467: END IF;
1468: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1469: (l_api_name,
1470: G_PKG_NAME,

Line 1478: okc_debug.set_trace_on;

1474: '_PROCESS');
1475:
1476: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1477: IF (l_debug = 'Y') THEN
1478: okc_debug.set_trace_on;
1479: END IF;
1480: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1481: (l_api_name,
1482: G_PKG_NAME,

Line 1489: okc_debug.set_trace_on;

1485: x_msg_data,
1486: '_PROCESS');
1487: WHEN OTHERS THEN
1488: IF (l_debug = 'Y') THEN
1489: okc_debug.set_trace_on;
1490: END IF;
1491: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1492: (l_api_name,
1493: G_PKG_NAME,

Line 1626: okc_debug.set_trace_off;

1622:
1623: FOR lines_rec in cur_lines LOOP
1624: --dbms_output.put_line('header line handler (+) ');
1625: IF (l_debug = 'Y') THEN
1626: okc_debug.set_trace_off;
1627: END IF;
1628:
1629: OPEN cur_status(lines_rec.sts_code);
1630: FETCH cur_status into l_status;

Line 1655: okc_debug.set_trace_off;

1651: OKC_ASSENT_PUB.get_default_status( x_return_status => l_return_status,
1652: p_status_type => 'ACTIVE',
1653: x_status_code => l_status_code );
1654: IF (l_debug = 'Y') THEN
1655: okc_debug.set_trace_off;
1656: END IF;
1657: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1658: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1659: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 1682: okc_debug.set_trace_off;

1678: p_restricted_update => okc_api.g_true,
1679: p_clev_rec => l_cle_rec,
1680: x_clev_rec => i_cle_rec );
1681: IF (l_debug = 'Y') THEN
1682: okc_debug.set_trace_off;
1683: END IF;
1684: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1685: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1686: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

Line 1694: okc_debug.set_trace_on;

1690: END IF; -- l_status
1691:
1692: END LOOP;
1693: IF (l_debug = 'Y') THEN
1694: okc_debug.set_trace_on;
1695: END IF;
1696: OPEN cur_header;
1697: FETCH cur_header into l_contract_number,l_contract_modifier,l_scs_code,l_cls_code,
1698: l_price_negotiated,l_kl_sts_code;

Line 1752: okc_debug.set_trace_on;

1748:
1749: EXCEPTION
1750: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1751: IF (l_debug = 'Y') THEN
1752: okc_debug.set_trace_on;
1753: END IF;
1754: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1755: (l_api_name,
1756: G_PKG_NAME,

Line 1763: okc_debug.set_trace_on;

1759: x_msg_data,
1760: '_PROCESS');
1761: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1762: IF (l_debug = 'Y') THEN
1763: okc_debug.set_trace_on;
1764: END IF;
1765: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1766: (l_api_name,
1767: G_PKG_NAME,

Line 1774: okc_debug.set_trace_on;

1770: x_msg_data,
1771: '_PROCESS');
1772: WHEN OTHERS THEN
1773: IF (l_debug = 'Y') THEN
1774: okc_debug.set_trace_on;
1775: END IF;
1776: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1777: (l_api_name,
1778: G_PKG_NAME,