DBA Data[Home] [Help]

APPS.RCV_ROI_PREPROCESSOR dependencies on FND_PROFILE

Line 4: g_asn_debug VARCHAR2(1) := NVL(fnd_profile.VALUE('RCV_DEBUG_MODE'), 'N');

1: PACKAGE BODY rcv_roi_preprocessor AS
2: /* $Header: RCVPREPB.pls 120.19.12010000.4 2009/01/22 12:54:23 smididud ship $*/
3: -- Read the profile option that enables/disables the debug log
4: g_asn_debug VARCHAR2(1) := NVL(fnd_profile.VALUE('RCV_DEBUG_MODE'), 'N');
5: x_interface_type VARCHAR2(25) := 'RCV-856';
6:
7: /* Shikyu Project This helping function is needed for cursor*/
8: FUNCTION get_oe_osa_flag(

Line 115: l_fsc_enabled VARCHAR2(1) := NVL(fnd_profile.VALUE('RCV_FSC_ENABLED'), 'N');

111: l_drop_ship_exists NUMBER; /* Bug3705658 */
112: l_auto_deliver VARCHAR2(1) := 'N'; /* Bug3705658 */
113: x_site_id_count NUMBER := 0; -- Bug 4355172
114: l_count NUMBER; --Bug 4881909
115: l_fsc_enabled VARCHAR2(1) := NVL(fnd_profile.VALUE('RCV_FSC_ENABLED'), 'N');
116: l_prev_org_id MO_GLOB_ORG_ACCESS_TMP.ORGANIZATION_ID%TYPE; --
117:
118: TYPE group_id_pool IS TABLE OF NUMBER
119: INDEX BY BINARY_INTEGER;

Line 188: g_asn_debug := NVL(fnd_profile.VALUE('RCV_DEBUG_MODE'), 'N');

184: AND GROUP_ID = DECODE(x_group_id, 0, GROUP_ID, x_group_id); */
185:
186: BEGIN
187: <>
188: g_asn_debug := NVL(fnd_profile.VALUE('RCV_DEBUG_MODE'), 'N');
189:
190:
191: /* For online mode, we send request_id as null. Consider it as -999 if
192: * it is null.

Line 214: fnd_profile.get('RCV_FAIL_IF_LINE_FAILS', x_fail_all_lines);

210: g_is_edi_installed := po_core_s.get_product_install_status('EC');
211: END IF;
212:
213: /* get the profile option */
214: fnd_profile.get('RCV_FAIL_IF_LINE_FAILS', x_fail_all_lines);
215:
216: IF x_fail_all_lines = 'Y' THEN
217: x_fail_if_one_line_fails := TRUE;
218: END IF;

Line 828: FND_PROFILE.GET('PO_AUTO_DELIVER_DROPSHIP_ASN', l_auto_deliver);

824: IF (g_asn_debug = 'Y') THEN
825: asn_debug.put_line('Number of Drop Ship Lines:' || l_drop_ship_exists);
826: END IF;
827: IF l_drop_ship_exists > 0 THEN --{
828: FND_PROFILE.GET('PO_AUTO_DELIVER_DROPSHIP_ASN', l_auto_deliver);
829: IF (g_asn_debug = 'Y') THEN
830: asn_debug.put_line('Profile Option PO_AUTO_DELIVER_DROPSHIP_ASN:' || l_auto_deliver);
831: END IF;
832: IF l_auto_deliver = 'Y' THEN --{