DBA Data[Home] [Help]

APPS.OKC_LSE_PVT dependencies on OKC_DEBUG

Line 970: okc_debug.set_indentation('validate_item_to_price_source');

966: OBJECT_CODE = l_object_code
967: AND OBJECT_USER_CODE = 'OKX_MTL_SYSTEM_ITEM';
968: BEGIN
969: IF (l_debug = 'Y') THEN
970: okc_debug.set_indentation('validate_item_to_price_source');
971: okc_debug.log('100:enteringvalidate_item_to_price_sourc');
972: END IF;
973: IF p_lsev_rec.item_to_price_yn = 'Y' THEN
974:

Line 971: okc_debug.log('100:enteringvalidate_item_to_price_sourc');

967: AND OBJECT_USER_CODE = 'OKX_MTL_SYSTEM_ITEM';
968: BEGIN
969: IF (l_debug = 'Y') THEN
970: okc_debug.set_indentation('validate_item_to_price_source');
971: okc_debug.log('100:enteringvalidate_item_to_price_sourc');
972: END IF;
973: IF p_lsev_rec.item_to_price_yn = 'Y' THEN
974:
975: IF (l_debug = 'Y') THEN

Line 976: okc_debug.log('100:here');

972: END IF;
973: IF p_lsev_rec.item_to_price_yn = 'Y' THEN
974:
975: IF (l_debug = 'Y') THEN
976: okc_debug.log('100:here');
977: END IF;
978: select JTOT_OBJECT_CODE
979: into l_object_code
980: from OKC_LINE_STYLE_SOURCES

Line 985: okc_debug.log('300:');

981: where lse_id = p_lsev_rec.id
982: and sysdate between START_DATE and nvl(END_DATE,sysdate);
983:
984: IF (l_debug = 'Y') THEN
985: okc_debug.log('300:');
986: END IF;
987: Open loc_source_csr;
988: Fetch loc_source_csr into l_object_user_code;
989: l_mtl_found := loc_source_csr%FOUND;

Line 994: okc_debug.log('400:');

990: Close loc_source_csr;
991:
992: IF NOT l_mtl_found THEN
993: IF (l_debug = 'Y') THEN
994: okc_debug.log('400:');
995: END IF;
996: x_return_status := OKC_API.G_RET_STS_ERROR;
997: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
998: p_msg_name => 'OKC_ITEM_TO_PRICE_SOURCE');

Line 1002: okc_debug.log('500:');

998: p_msg_name => 'OKC_ITEM_TO_PRICE_SOURCE');
999: END IF;
1000: IF l_mtl_found THEN
1001: IF (l_debug = 'Y') THEN
1002: okc_debug.log('500:');
1003: END IF;
1004: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1005: END IF;
1006:

Line 1009: okc_debug.log('600:');

1005: END IF;
1006:
1007: ELSE
1008: IF (l_debug = 'Y') THEN
1009: okc_debug.log('600:');
1010: END IF;
1011: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1012: END IF;
1013:

Line 1017: okc_debug.log('700:');

1013:
1014: EXCEPTION
1015: WHEN NO_DATA_FOUND THEN
1016: IF (l_debug = 'Y') THEN
1017: okc_debug.log('700:');
1018: END IF;
1019: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1020: --changed this to allow the line style to be item to priced when there is no line style source
1021: /* x_return_status := OKC_API.G_RET_STS_ERROR;

Line 1029: okc_debug.log('600:');

1025: NULL;
1026: WHEN OTHERS THEN
1027:
1028: IF (l_debug = 'Y') THEN
1029: okc_debug.log('600:');
1030: END IF;
1031: OKC_API.set_message(p_app_name => g_app_name,
1032: p_msg_name => g_unexpected_error,
1033: p_token1 => g_sqlcode_token,