DBA Data[Home] [Help]

APPS.RCV_ROI_TRANSACTION dependencies on FND_PROFILE

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

1: PACKAGE BODY rcv_roi_transaction
2: /* $Header: RCVPRETB.pls 120.41.12010000.3 2008/12/26 20:15:38 vthevark ship $*/
3: AS
4: g_asn_debug VARCHAR2(1) := NVL(fnd_profile.VALUE('RCV_DEBUG_MODE'), 'N');
5: x_progress VARCHAR2(3);
6: g_pkg_name CONSTANT VARCHAR2(30) := 'RCV_ROI_TRANSACTION';
7: x_drop_ship_flag VARCHAR2(1) := 'N';
8: x_auto_deliver VARCHAR2(1);

Line 2618: fnd_profile.get('PO_AUTO_DELIVER_DROPSHIP_ASN', x_auto_deliver);

2614: asn_debug.put_line('Dropship: Setting RCV Routing to Direct Deliver');
2615: END IF;
2616:
2617: x_cascaded_table(n).routing_header_id := 3;
2618: fnd_profile.get('PO_AUTO_DELIVER_DROPSHIP_ASN', x_auto_deliver);
2619:
2620: IF x_auto_deliver = 'Y' THEN
2621: IF (g_asn_debug = 'Y') THEN
2622: asn_debug.put_line('Dropship: Auto deliver feature enabled, ' || 'set auto_transact_code to DELIVER for drop ship ASNs');

Line 2977: profile_user_id := fnd_profile.VALUE('USER_ID');

2973: l_blind_receiving_flag VARCHAR2(1) := 'N'; -- Bug 6796920
2974: BEGIN
2975: --check line quanity > 0
2976: x_progress := '097';
2977: profile_user_id := fnd_profile.VALUE('USER_ID');
2978: profile_resp_id := fnd_profile.VALUE('RESPONSIBILITY_ID');
2979: profile_appl_id := fnd_profile.VALUE('APPLICATION_ID');
2980: fnd_profile.get_specific('RCV_CLOSED_PO_DEFAULT_OPTION',
2981: profile_user_id,

Line 2978: profile_resp_id := fnd_profile.VALUE('RESPONSIBILITY_ID');

2974: BEGIN
2975: --check line quanity > 0
2976: x_progress := '097';
2977: profile_user_id := fnd_profile.VALUE('USER_ID');
2978: profile_resp_id := fnd_profile.VALUE('RESPONSIBILITY_ID');
2979: profile_appl_id := fnd_profile.VALUE('APPLICATION_ID');
2980: fnd_profile.get_specific('RCV_CLOSED_PO_DEFAULT_OPTION',
2981: profile_user_id,
2982: profile_resp_id,

Line 2979: profile_appl_id := fnd_profile.VALUE('APPLICATION_ID');

2975: --check line quanity > 0
2976: x_progress := '097';
2977: profile_user_id := fnd_profile.VALUE('USER_ID');
2978: profile_resp_id := fnd_profile.VALUE('RESPONSIBILITY_ID');
2979: profile_appl_id := fnd_profile.VALUE('APPLICATION_ID');
2980: fnd_profile.get_specific('RCV_CLOSED_PO_DEFAULT_OPTION',
2981: profile_user_id,
2982: profile_resp_id,
2983: profile_appl_id,

Line 2980: fnd_profile.get_specific('RCV_CLOSED_PO_DEFAULT_OPTION',

2976: x_progress := '097';
2977: profile_user_id := fnd_profile.VALUE('USER_ID');
2978: profile_resp_id := fnd_profile.VALUE('RESPONSIBILITY_ID');
2979: profile_appl_id := fnd_profile.VALUE('APPLICATION_ID');
2980: fnd_profile.get_specific('RCV_CLOSED_PO_DEFAULT_OPTION',
2981: profile_user_id,
2982: profile_resp_id,
2983: profile_appl_id,
2984: x_include_closed_po,

Line 4900: x_allow_rate_override := NVL(fnd_profile.value('ALLOW_RATE_OVERRIDE_FOR_USER_RATE_TYPE'), 'N');

4896: ** option only when the match option is receipt and thus to avoid executing the below
4897: ** function call always.
4898: */
4899: IF (x_ShipmentDistributionRec.match_option = 'R') THEN
4900: x_allow_rate_override := NVL(fnd_profile.value('ALLOW_RATE_OVERRIDE_FOR_USER_RATE_TYPE'), 'N');
4901: END IF;
4902:
4903: IF (g_asn_debug = 'Y') THEN
4904: asn_debug.put_line('Match Option:' || x_ShipmentDistributionRec.match_option ||

Line 5453: profile_user_id := fnd_profile.VALUE('USER_ID');

5449: IF (g_asn_debug = 'Y') THEN
5450: asn_debug.put_line('derive_vendor_rcv_line_amt ' || x_progress);
5451: END IF;
5452:
5453: profile_user_id := fnd_profile.VALUE('USER_ID');
5454: profile_resp_id := fnd_profile.VALUE('RESPONSIBILITY_ID');
5455: profile_appl_id := fnd_profile.VALUE('APPLICATION_ID');
5456: fnd_profile.get_specific('RCV_CLOSED_PO_DEFAULT_OPTION',
5457: profile_user_id,

Line 5454: profile_resp_id := fnd_profile.VALUE('RESPONSIBILITY_ID');

5450: asn_debug.put_line('derive_vendor_rcv_line_amt ' || x_progress);
5451: END IF;
5452:
5453: profile_user_id := fnd_profile.VALUE('USER_ID');
5454: profile_resp_id := fnd_profile.VALUE('RESPONSIBILITY_ID');
5455: profile_appl_id := fnd_profile.VALUE('APPLICATION_ID');
5456: fnd_profile.get_specific('RCV_CLOSED_PO_DEFAULT_OPTION',
5457: profile_user_id,
5458: profile_resp_id,

Line 5455: profile_appl_id := fnd_profile.VALUE('APPLICATION_ID');

5451: END IF;
5452:
5453: profile_user_id := fnd_profile.VALUE('USER_ID');
5454: profile_resp_id := fnd_profile.VALUE('RESPONSIBILITY_ID');
5455: profile_appl_id := fnd_profile.VALUE('APPLICATION_ID');
5456: fnd_profile.get_specific('RCV_CLOSED_PO_DEFAULT_OPTION',
5457: profile_user_id,
5458: profile_resp_id,
5459: profile_appl_id,

Line 5456: fnd_profile.get_specific('RCV_CLOSED_PO_DEFAULT_OPTION',

5452:
5453: profile_user_id := fnd_profile.VALUE('USER_ID');
5454: profile_resp_id := fnd_profile.VALUE('RESPONSIBILITY_ID');
5455: profile_appl_id := fnd_profile.VALUE('APPLICATION_ID');
5456: fnd_profile.get_specific('RCV_CLOSED_PO_DEFAULT_OPTION',
5457: profile_user_id,
5458: profile_resp_id,
5459: profile_appl_id,
5460: x_include_closed_po,

Line 6458: x_allow_rate_override := NVL(fnd_profile.value('ALLOW_RATE_OVERRIDE_FOR_USER_RATE_TYPE'), 'N');

6454: ** option only when the match option is receipt and thus to avoid executing the below
6455: ** function call always.
6456: */
6457: IF (x_ShipmentDistributionRec.match_option = 'R') THEN
6458: x_allow_rate_override := NVL(fnd_profile.value('ALLOW_RATE_OVERRIDE_FOR_USER_RATE_TYPE'), 'N');
6459: END IF;
6460:
6461: IF (g_asn_debug = 'Y') THEN
6462: asn_debug.put_line('Match Option:' || x_ShipmentDistributionRec.match_option ||

Line 16011: l_rate_override := NVL(fnd_profile.value('ALLOW_RATE_OVERRIDE_FOR_USER_RATE_TYPE'), 'N');

16007: END IF;
16008: ELSE
16009: x_cascaded_table(n).currency_conversion_date := l_po_rate_date;
16010:
16011: l_rate_override := NVL(fnd_profile.value('ALLOW_RATE_OVERRIDE_FOR_USER_RATE_TYPE'), 'N');
16012: asn_debug.put_line('l_rate_override => ' || l_rate_override, null, 14);
16013:
16014: IF (l_rate_override = 'N' OR x_cascaded_table(n).currency_conversion_rate IS NULL) THEN
16015: x_cascaded_table(n).currency_conversion_rate := l_po_rate;