DBA Data[Home] [Help]

APPS.RCV_ROI_TRANSACTION dependencies on FND_PROFILE

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

3096: asn_debug.put_line('Dropship: Setting RCV Routing to Direct Deliver');
3097: END IF;
3098:
3099: x_cascaded_table(n).routing_header_id := 3;
3100: fnd_profile.get('PO_AUTO_DELIVER_DROPSHIP_ASN', x_auto_deliver);
3101:
3102: IF x_auto_deliver = 'Y' THEN
3103: IF (g_asn_debug = 'Y') THEN
3104: asn_debug.put_line('Dropship: Auto deliver feature enabled, ' || 'set auto_transact_code to DELIVER for drop ship ASNs');

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

3467:
3468: BEGIN
3469: --check line quanity > 0
3470: x_progress := '097';
3471: profile_user_id := fnd_profile.VALUE('USER_ID');
3472: profile_resp_id := fnd_profile.VALUE('RESPONSIBILITY_ID');
3473: profile_appl_id := fnd_profile.VALUE('APPLICATION_ID');
3474: fnd_profile.get_specific('RCV_CLOSED_PO_DEFAULT_OPTION',
3475: profile_user_id,

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

3468: BEGIN
3469: --check line quanity > 0
3470: x_progress := '097';
3471: profile_user_id := fnd_profile.VALUE('USER_ID');
3472: profile_resp_id := fnd_profile.VALUE('RESPONSIBILITY_ID');
3473: profile_appl_id := fnd_profile.VALUE('APPLICATION_ID');
3474: fnd_profile.get_specific('RCV_CLOSED_PO_DEFAULT_OPTION',
3475: profile_user_id,
3476: profile_resp_id,

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

3469: --check line quanity > 0
3470: x_progress := '097';
3471: profile_user_id := fnd_profile.VALUE('USER_ID');
3472: profile_resp_id := fnd_profile.VALUE('RESPONSIBILITY_ID');
3473: profile_appl_id := fnd_profile.VALUE('APPLICATION_ID');
3474: fnd_profile.get_specific('RCV_CLOSED_PO_DEFAULT_OPTION',
3475: profile_user_id,
3476: profile_resp_id,
3477: profile_appl_id,

Line 3474: fnd_profile.get_specific('RCV_CLOSED_PO_DEFAULT_OPTION',

3470: x_progress := '097';
3471: profile_user_id := fnd_profile.VALUE('USER_ID');
3472: profile_resp_id := fnd_profile.VALUE('RESPONSIBILITY_ID');
3473: profile_appl_id := fnd_profile.VALUE('APPLICATION_ID');
3474: fnd_profile.get_specific('RCV_CLOSED_PO_DEFAULT_OPTION',
3475: profile_user_id,
3476: profile_resp_id,
3477: profile_appl_id,
3478: x_include_closed_po,

Line 4704: if (nvl(fnd_profile.value('wms_deployment_mode'), 1) = 3) then

4700:
4701:
4702: begin
4703: x_po_header_id := x_cascaded_table(n).po_header_id;
4704: if (nvl(fnd_profile.value('wms_deployment_mode'), 1) = 3) then
4705: l_client_code := wms_deploy.get_po_client_code(x_po_header_id);
4706: if (l_client_code is not null) then
4707: select nvl(max(receipt_asn_exists_code),'none')
4708: into l_asn_exists_code

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

5512: ** option only when the match option is receipt and thus to avoid executing the below
5513: ** function call always.
5514: */
5515: IF (x_ShipmentDistributionRec.match_option = 'R') THEN
5516: x_allow_rate_override := NVL(fnd_profile.value('ALLOW_RATE_OVERRIDE_FOR_USER_RATE_TYPE'), 'N');
5517: END IF;
5518:
5519: IF (g_asn_debug = 'Y') THEN
5520: asn_debug.put_line('Match Option:' || x_ShipmentDistributionRec.match_option ||

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

6097: IF (g_asn_debug = 'Y') THEN
6098: asn_debug.put_line('derive_vendor_rcv_line_amt ' || x_progress);
6099: END IF;
6100:
6101: profile_user_id := fnd_profile.VALUE('USER_ID');
6102: profile_resp_id := fnd_profile.VALUE('RESPONSIBILITY_ID');
6103: profile_appl_id := fnd_profile.VALUE('APPLICATION_ID');
6104: fnd_profile.get_specific('RCV_CLOSED_PO_DEFAULT_OPTION',
6105: profile_user_id,

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

6098: asn_debug.put_line('derive_vendor_rcv_line_amt ' || x_progress);
6099: END IF;
6100:
6101: profile_user_id := fnd_profile.VALUE('USER_ID');
6102: profile_resp_id := fnd_profile.VALUE('RESPONSIBILITY_ID');
6103: profile_appl_id := fnd_profile.VALUE('APPLICATION_ID');
6104: fnd_profile.get_specific('RCV_CLOSED_PO_DEFAULT_OPTION',
6105: profile_user_id,
6106: profile_resp_id,

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

6099: END IF;
6100:
6101: profile_user_id := fnd_profile.VALUE('USER_ID');
6102: profile_resp_id := fnd_profile.VALUE('RESPONSIBILITY_ID');
6103: profile_appl_id := fnd_profile.VALUE('APPLICATION_ID');
6104: fnd_profile.get_specific('RCV_CLOSED_PO_DEFAULT_OPTION',
6105: profile_user_id,
6106: profile_resp_id,
6107: profile_appl_id,

Line 6104: fnd_profile.get_specific('RCV_CLOSED_PO_DEFAULT_OPTION',

6100:
6101: profile_user_id := fnd_profile.VALUE('USER_ID');
6102: profile_resp_id := fnd_profile.VALUE('RESPONSIBILITY_ID');
6103: profile_appl_id := fnd_profile.VALUE('APPLICATION_ID');
6104: fnd_profile.get_specific('RCV_CLOSED_PO_DEFAULT_OPTION',
6105: profile_user_id,
6106: profile_resp_id,
6107: profile_appl_id,
6108: x_include_closed_po,

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

7132: ** option only when the match option is receipt and thus to avoid executing the below
7133: ** function call always.
7134: */
7135: IF (x_ShipmentDistributionRec.match_option = 'R') THEN
7136: x_allow_rate_override := NVL(fnd_profile.value('ALLOW_RATE_OVERRIDE_FOR_USER_RATE_TYPE'), 'N');
7137: END IF;
7138:
7139: IF (g_asn_debug = 'Y') THEN
7140: asn_debug.put_line('Match Option:' || x_ShipmentDistributionRec.match_option ||

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

10020: l_ship_head_id
10021: FROM rcv_transactions_interface
10022: WHERE interface_transaction_id = l_ls_table(k).new_interface_trx_id;
10023:
10024: fnd_profile.get('RCV_FAIL_IF_LINE_FAILS', x_fail_all_lines);
10025: IF ( x_fail_all_lines='Y') THEN
10026: rcv_roi_preprocessor.update_rti_error
10027: (null,
10028: null,