DBA Data[Home] [Help]

APPS.OKC_TERMINATE_PVT dependencies on OKC_DEBUG

Line 727: okc_debug.set_trace_off;

723: OKC_ASSENT_PUB.get_default_status( x_return_status => l_return_status,
724: p_status_type => 'TERMINATED',
725: x_status_code => l_ter_status_code);
726: IF (l_debug = 'Y') THEN
727: okc_debug.set_trace_off;
728: END IF;
729: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
730: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
731: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 738: okc_debug.set_trace_off;

734: OKC_ASSENT_PUB.get_default_status( x_return_status => l_return_status,
735: p_status_type => 'CANCELLED',
736: x_status_code => l_can_status_code);
737: IF (l_debug = 'Y') THEN
738: okc_debug.set_trace_off;
739: END IF;
740: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
741: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
742: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 834: okc_debug.set_trace_off;

830: */
831: -- END if;
832: FOR lines_rec in lock_lines LOOP
833: IF (l_debug = 'Y') THEN
834: okc_debug.set_trace_off;
835: END IF;
836: l_lse_id := lines_rec.lse_id;
837:
838: IF lines_rec.ste_code in ('ACTIVE','ENTERED','HOLD','SIGNED','EXPIRED') THEN

Line 908: okc_debug.set_trace_off;

904: p_restricted_update => okc_api.g_true,
905: p_clev_rec => l_clev_rec,
906: x_clev_rec => i_clev_rec );
907: IF (l_debug = 'Y') THEN
908: okc_debug.set_trace_off;
909: END IF;
910: --dbms_output.put_line(' update_contract_line (-) ');
911:
912: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 946: okc_debug.set_trace_on;

942: END IF; -- ste_code
943:
944: END LOOP;
945: IF (l_debug = 'Y') THEN
946: okc_debug.set_trace_on;
947: END IF;
948: FOR conditions_rec in cur_condition_headers LOOP
949: IF (l_debug = 'Y') THEN
950: okc_debug.set_trace_off;

Line 950: okc_debug.set_trace_off;

946: okc_debug.set_trace_on;
947: END IF;
948: FOR conditions_rec in cur_condition_headers LOOP
949: IF (l_debug = 'Y') THEN
950: okc_debug.set_trace_off;
951: END IF;
952: l_cnh_rec.id := conditions_rec.id;
953: l_cnh_rec.object_version_number := conditions_rec.object_version_number;
954: l_cnh_rec.date_inactive := p_terminate_in_parameters_rec.p_termination_date;

Line 979: okc_debug.set_trace_off;

975: x_msg_data => x_msg_data,
976: p_cnhv_rec => l_cnh_rec,
977: x_cnhv_rec => i_cnh_rec);
978: IF (l_debug = 'Y') THEN
979: okc_debug.set_trace_off;
980: END IF;
981: --dbms_output.put_line(' update_cond_hdrs (-) ');
982:
983: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

Line 991: okc_debug.set_trace_on;

987: END IF;
988:
989: END LOOP;
990: IF (l_debug = 'Y') THEN
991: okc_debug.set_trace_on;
992: END IF;
993: FOR change_requests_rec in cur_change_requests LOOP
994: IF (l_debug = 'Y') THEN
995: okc_debug.set_trace_off;

Line 995: okc_debug.set_trace_off;

991: okc_debug.set_trace_on;
992: END IF;
993: FOR change_requests_rec in cur_change_requests LOOP
994: IF (l_debug = 'Y') THEN
995: okc_debug.set_trace_off;
996: END IF;
997: l_crtv_rec.id := change_requests_rec.id;
998: l_crtv_rec.object_version_number := change_requests_rec.object_version_number;
999: l_crtv_rec.datetime_ineffective := p_terminate_in_parameters_rec.p_termination_date;

Line 1013: okc_debug.set_trace_off;

1009: x_msg_data => x_msg_data,
1010: p_crtv_rec => l_crtv_rec,
1011: x_crtv_rec => i_crtv_rec);
1012: IF (l_debug = 'Y') THEN
1013: okc_debug.set_trace_off;
1014: END IF;
1015: --dbms_output.put_line(' update_change_request (-) ');
1016:
1017: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

Line 1025: okc_debug.set_trace_on;

1021: END IF;
1022:
1023: END LOOP;
1024: IF (l_debug = 'Y') THEN
1025: okc_debug.set_trace_on;
1026: END IF;
1027:
1028: --dbms_output.put_line(' acn_assemble (+) ');
1029: -- Raise the event

Line 1067: okc_debug.set_trace_on;

1063: --dbms_output.put_line(' terminate_chr (-) ');
1064: EXCEPTION
1065: WHEN E_Resource_Busy THEN
1066: IF (l_debug = 'Y') THEN
1067: okc_debug.set_trace_on;
1068: END IF;
1069: x_return_status := okc_api.g_ret_sts_error;
1070:
1071: OKC_API.set_message(G_FND_APP,

Line 1077: okc_debug.set_trace_on;

1073: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
1074:
1075: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1076: IF (l_debug = 'Y') THEN
1077: okc_debug.set_trace_on;
1078: END IF;
1079: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1080: (l_api_name,
1081: G_PKG_NAME,

Line 1088: okc_debug.set_trace_on;

1084: x_msg_data,
1085: '_PROCESS');
1086: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1087: IF (l_debug = 'Y') THEN
1088: okc_debug.set_trace_on;
1089: END IF;
1090: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1091: (l_api_name,
1092: G_PKG_NAME,

Line 1099: okc_debug.set_trace_on;

1095: x_msg_data,
1096: '_PROCESS');
1097: WHEN OTHERS THEN
1098: IF (l_debug = 'Y') THEN
1099: okc_debug.set_trace_on;
1100: END IF;
1101: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1102: (l_api_name,
1103: G_PKG_NAME,

Line 1490: okc_debug.set_trace_off;

1486: OKC_ASSENT_PUB.get_default_status( x_return_status => l_return_status,
1487: p_status_type => 'TERMINATED',
1488: x_status_code => l_ter_status_code );
1489: IF (l_debug = 'Y') THEN
1490: okc_debug.set_trace_off;
1491: END IF;
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

Line 1501: okc_debug.set_trace_off;

1497: OKC_ASSENT_PUB.get_default_status( x_return_status => l_return_status,
1498: p_status_type => 'CANCELLED',
1499: x_status_code => l_can_status_code);
1500: IF (l_debug = 'Y') THEN
1501: okc_debug.set_trace_off;
1502: END IF;
1503: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1504: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1505: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 1509: OKC_DEBUG.SET_TRACE_OFF;

1505: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1506: raise OKC_API.G_EXCEPTION_ERROR;
1507: END IF;
1508: IF (l_debug = 'Y') THEN
1509: OKC_DEBUG.SET_TRACE_OFF;
1510: END IF;
1511: FOR lines_rec in cur_lines LOOP
1512: l_loop_counter := l_loop_counter + 1;
1513: IF (l_debug = 'Y') THEN

Line 1514: okc_debug.set_trace_off;

1510: END IF;
1511: FOR lines_rec in cur_lines LOOP
1512: l_loop_counter := l_loop_counter + 1;
1513: IF (l_debug = 'Y') THEN
1514: okc_debug.set_trace_off;
1515: END IF;
1516: OPEN cur_status(lines_rec.sts_code);
1517: fetch cur_status into l_status;
1518: close cur_status;

Line 1590: okc_debug.set_trace_off;

1586: p_restricted_update => okc_api.g_true,
1587: p_clev_rec => l_clev_rec,
1588: x_clev_rec => i_clev_rec );
1589: IF (l_debug = 'Y') THEN
1590: okc_debug.set_trace_off;
1591: END IF;
1592: --dbms_output.put_line('update_contract_line (-) ');
1593: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1594: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1623: OKC_DEBUG.set_trace_off;

1619: END IF; -- effectivity
1620: END IF; -- l_status
1621: END LOOP;
1622: IF (l_debug = 'Y') THEN
1623: OKC_DEBUG.set_trace_off;
1624: END IF;
1625: OKC_CONTRACT_PUB.update_contract_line( p_api_version => 1,
1626: p_init_msg_list => OKC_API.G_FALSE,
1627: x_return_status => l_return_status,

Line 1634: OKC_DEBUG.set_trace_off;

1630: p_restricted_update => OKC_API.g_true,
1631: p_clev_tbl => l_clev_tbl,
1632: x_clev_tbl => i_clev_tbl );
1633: IF (l_debug = 'Y') THEN
1634: OKC_DEBUG.set_trace_off;
1635: END IF;
1636: --dbms_output.put_line('update_contract_line (-) ');
1637: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1638: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1644: okc_debug.set_trace_on;

1640: RAISE OKC_API.G_EXCEPTION_ERROR;
1641: END IF;
1642:
1643: IF (l_debug = 'Y') THEN
1644: okc_debug.set_trace_on;
1645: END IF;
1646: /* Commented for Bug 1925467
1647: OPEN is_line_a_service_line;
1648: FETCH is_line_a_service_line into l_dummy;

Line 1721: okc_debug.set_trace_on;

1717:
1718: EXCEPTION
1719: WHEN E_Resource_Busy THEN
1720: IF (l_debug = 'Y') THEN
1721: okc_debug.set_trace_on;
1722: END IF;
1723: x_return_status := okc_api.g_ret_sts_error;
1724: OKC_API.set_message(G_FND_APP,
1725: G_FORM_UNABLE_TO_RESERVE_REC);

Line 1730: okc_debug.set_trace_on;

1726: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
1727:
1728: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1729: IF (l_debug = 'Y') THEN
1730: okc_debug.set_trace_on;
1731: END IF;
1732: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1733: (l_api_name,
1734: G_PKG_NAME,

Line 1742: okc_debug.set_trace_on;

1738: '_PROCESS');
1739:
1740: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1741: IF (l_debug = 'Y') THEN
1742: okc_debug.set_trace_on;
1743: END IF;
1744: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1745: (l_api_name,
1746: G_PKG_NAME,

Line 1753: okc_debug.set_trace_on;

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