eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.RLM_CUM_SV dependencies on FND_FILE

Line 231: fnd_file.put_line(fnd_file.log,x_cum_record.msg_data);

227: x_cum_record);
228: --
229: IF x_cum_record.record_return_status = FALSE THEN
230: --
231: fnd_file.put_line(fnd_file.log,x_cum_record.msg_data);
232: --
233: END IF;
234: --
235: IF (l_debug <> -1) THEN

Line 1784: fnd_file.put_line(fnd_file.log, v_msg_text);

1780: x_value4 => v_cum_record.actual_shipment_date,
1781: x_token5 => 'SHIP_QTY',
1782: x_value5 => v_cum_record.shipped_quantity);
1783: --
1784: fnd_file.put_line(fnd_file.log, v_msg_text);
1785: --
1786: --Find customer_id, as it is a required input parameter for rlm_setup_terms
1787: --
1788: v_level := 'CUSTOMER_ID';

Line 1841: fnd_file.put_line(fnd_file.log, v_msg_text);

1837: x_text => v_msg_text,
1838: x_token1 => 'CUM_CONTROL_CODE',
1839: x_value1 => v_rlm_setup_terms_record.cum_control_code);
1840: --
1841: fnd_file.put_line(fnd_file.log, v_msg_text);
1842: --
1843: --Continue only if cum_control_code is found and not set to NO_CUM
1844: --
1845: IF v_setup_terms_status = TRUE AND

Line 1895: fnd_file.put_line(fnd_file.log, v_msg_text);

1891: x_text => v_msg_text,
1892: x_token1 => 'CUM_KEY_ID',
1893: x_value1 => v_cum_record.cum_key_id);
1894: --
1895: fnd_file.put_line(fnd_file.log, v_msg_text);
1896: --
1897: ELSE
1898: --
1899: RAISE e_general_error;

Line 2082: fnd_file.put_line(fnd_file.log, v_msg_text);

2078: rlm_message_sv.get_msg_text(
2079: x_message_name => 'RLM_TRIP_NO_UPDATE',
2080: x_text => v_msg_text);
2081: --
2082: fnd_file.put_line(fnd_file.log, v_msg_text);
2083: --
2084: -- Pls do not remove the line below
2085: --
2086: v_msg_text := 'RLM_TRIP_NO_UPDATE';

Line 2112: fnd_file.put_line(fnd_file.log, v_msg_text);

2108: rlm_message_sv.get_msg_text(
2109: x_message_name => 'RLM_TRIP_NO_SETUP',
2110: x_text => v_msg_text);
2111: --
2112: fnd_file.put_line(fnd_file.log, v_msg_text);
2113: --
2114: END IF; -- v_cum_control_code <> 'NO_CUM'
2115: --
2116: END LOOP; -- END LOOP to fetch OE Order Lines

Line 2229: fnd_file.put_line(fnd_file.log, x_msg_data);

2225: --
2226: x_msg_data := oe_msg_pub.get( p_msg_index => k,
2227: p_encoded => 'F');
2228: --
2229: fnd_file.put_line(fnd_file.log, x_msg_data);
2230: --
2231: IF (l_debug <> -1) THEN
2232: rlm_core_sv.dlog(C_SDEBUG, 'x_msg_data', x_msg_data);
2233: END IF;

Line 2250: fnd_file.put_line(fnd_file.log, v_msg_text);

2246: rlm_message_sv.get_msg_text(
2247: x_message_name => 'RLM_CUM_PROCESS_ORDER',
2248: x_text => v_msg_text);
2249: --
2250: fnd_file.put_line(fnd_file.log, v_msg_text);
2251: --
2252: IF (l_debug <> -1) THEN
2253: rlm_core_sv.stop_debug;
2254: END IF;

Line 2289: fnd_file.put_line(fnd_file.log, x_msg_data);

2285: --
2286: x_msg_data := oe_msg_pub.get( p_msg_index => k,
2287: p_encoded => 'F');
2288: --
2289: fnd_file.put_line(fnd_file.log, x_msg_data);
2290: --
2291: IF (l_debug <> -1) THEN
2292: rlm_core_sv.dlog(C_SDEBUG, 'x_msg_data', x_msg_data);
2293: END IF;

Line 2310: fnd_file.put_line(fnd_file.log, v_msg_text);

2306: rlm_message_sv.get_msg_text(
2307: x_message_name => 'RLM_CUM_PROCESS_ORDER',
2308: x_text => v_msg_text);
2309: --
2310: fnd_file.put_line(fnd_file.log, v_msg_text);
2311: --
2312: IF (l_debug <> -1) THEN
2313: rlm_core_sv.stop_debug;
2314: END IF;

Line 2346: fnd_file.put_line(fnd_file.log, x_msg_data);

2342: --
2343: x_msg_data := oe_msg_pub.get( p_msg_index => k,
2344: p_encoded => 'F');
2345: --
2346: fnd_file.put_line(fnd_file.log, x_msg_data);
2347: --
2348: IF (l_debug <> -1) THEN
2349: rlm_core_sv.dlog(C_SDEBUG, 'x_msg_data', x_msg_data);
2350: END IF;

Line 2365: fnd_file.put_line(fnd_file.log, v_msg_text);

2361: rlm_message_sv.get_msg_text(
2362: x_message_name => 'RLM_CUM_PROCESS_ORDER',
2363: x_text => v_msg_text);
2364: --
2365: fnd_file.put_line(fnd_file.log, v_msg_text);
2366: --
2367: IF (l_debug <> -1) THEN
2368: rlm_core_sv.stop_debug;
2369: END IF;

Line 2389: fnd_file.put_line(fnd_file.log, v_msg_text);

2385: rlm_message_sv.get_msg_text(
2386: x_message_name => 'RLM_CUM_SUCCESS',
2387: x_text => v_msg_text);
2388: --
2389: fnd_file.put_line(fnd_file.log, v_msg_text);
2390: --
2391: IF (l_debug <> -1) THEN
2392: rlm_core_sv.stop_debug;
2393: END IF;

Line 2444: fnd_file.put_line(fnd_file.log, v_msg_text);

2440: x_text => v_msg_text);
2441: --
2442: END IF;
2443: --
2444: fnd_file.put_line(fnd_file.log, v_msg_text);
2445: --
2446: WHEN e_no_shipment_line THEN
2447: ----------------------------------------------------+
2448: DECLARE

Line 2482: -- fnd_file.put_line(fnd_file.log, v_msg_text);

2478: --
2479: -- Bug 1306894: Shipping requests the removal of this
2480: -- misleading message for non-RLM customers
2481: --
2482: -- fnd_file.put_line(fnd_file.log, v_msg_text);
2483: --
2484: IF (l_debug <> -1) THEN
2485: rlm_core_sv.stop_debug;
2486: END IF;

Line 2503: fnd_file.put_line(fnd_file.log, v_msg_text);

2499: rlm_core_sv.dpop(C_SDEBUG, v_msg_text);
2500: rlm_core_sv.stop_debug;
2501: END IF;
2502: --
2503: fnd_file.put_line(fnd_file.log, v_msg_text);
2504: --
2505: END;
2506: -----------------------------------------------------------+
2507: WHEN e_null_mandatory THEN

Line 2524: fnd_file.put_line(fnd_file.log, v_msg_text);

2520: rlm_core_sv.dpop(C_SDEBUG, v_msg_text);
2521: rlm_core_sv.stop_debug;
2522: END IF;
2523: --
2524: fnd_file.put_line(fnd_file.log, v_msg_text);
2525: --
2526: WHEN e_cum_start_date THEN
2527: --
2528: ROLLBACK to updatecumkey;

Line 2543: fnd_file.put_line(fnd_file.log, v_msg_text);

2539: rlm_core_sv.dpop(C_SDEBUG, v_msg_text);
2540: rlm_core_sv.stop_debug;
2541: END IF;
2542: --
2543: fnd_file.put_line(fnd_file.log, v_msg_text);
2544: --
2545: WHEN e_no_cum_key THEN
2546: ROLLBACK to updatecumkey;
2547: rlm_message_sv.get_msg_text(

Line 2559: fnd_file.put_line(fnd_file.log, v_msg_text);

2555: rlm_core_sv.dlog(C_SDEBUG, 'EXCEPTION: e_no_cum_key');
2556: rlm_core_sv.dpop(C_SDEBUG);
2557: rlm_core_sv.stop_debug;
2558: END IF;
2559: fnd_file.put_line(fnd_file.log, v_msg_text);
2560:
2561: WHEN e_general_error THEN
2562: --
2563: ROLLBACK to updatecumkey;

Line 2582: fnd_file.put_line(fnd_file.log, v_msg_text);

2578: rlm_core_sv.dpop(C_SDEBUG, v_msg_text);
2579: rlm_core_sv.stop_debug;
2580: END IF;
2581: --
2582: fnd_file.put_line(fnd_file.log, v_msg_text);
2583: --
2584: END UpdateCumKey;
2585:
2586: /*============================================================================

Line 3518: fnd_file.put_line(fnd_file.log, 'User Input Parameters: ');

3514: END IF;
3515: --
3516: -- Start logging the ResetCum trail into the fnd log file here!
3517: --
3518: fnd_file.put_line(fnd_file.log, 'User Input Parameters: ');
3519: fnd_file.put_line(fnd_file.log, 'Operating Unit: ' ||p_org_id);
3520: fnd_file.put_line(fnd_file.log, 'Ship-From Organization ID: ' ||x_ship_from_org_id);
3521: fnd_file.put_line(fnd_file.log, 'Ship-To Organization ID: ' ||x_ship_to_org_id);
3522: fnd_file.put_line(fnd_file.log, 'Intermediate Ship-To Organization ID: ' ||x_intrmd_ship_to_org_id);

Line 3519: fnd_file.put_line(fnd_file.log, 'Operating Unit: ' ||p_org_id);

3515: --
3516: -- Start logging the ResetCum trail into the fnd log file here!
3517: --
3518: fnd_file.put_line(fnd_file.log, 'User Input Parameters: ');
3519: fnd_file.put_line(fnd_file.log, 'Operating Unit: ' ||p_org_id);
3520: fnd_file.put_line(fnd_file.log, 'Ship-From Organization ID: ' ||x_ship_from_org_id);
3521: fnd_file.put_line(fnd_file.log, 'Ship-To Organization ID: ' ||x_ship_to_org_id);
3522: fnd_file.put_line(fnd_file.log, 'Intermediate Ship-To Organization ID: ' ||x_intrmd_ship_to_org_id);
3523: fnd_file.put_line(fnd_file.log, 'Bill-To Organization ID: ' ||x_bill_to_org_id);

Line 3520: fnd_file.put_line(fnd_file.log, 'Ship-From Organization ID: ' ||x_ship_from_org_id);

3516: -- Start logging the ResetCum trail into the fnd log file here!
3517: --
3518: fnd_file.put_line(fnd_file.log, 'User Input Parameters: ');
3519: fnd_file.put_line(fnd_file.log, 'Operating Unit: ' ||p_org_id);
3520: fnd_file.put_line(fnd_file.log, 'Ship-From Organization ID: ' ||x_ship_from_org_id);
3521: fnd_file.put_line(fnd_file.log, 'Ship-To Organization ID: ' ||x_ship_to_org_id);
3522: fnd_file.put_line(fnd_file.log, 'Intermediate Ship-To Organization ID: ' ||x_intrmd_ship_to_org_id);
3523: fnd_file.put_line(fnd_file.log, 'Bill-To Organization ID: ' ||x_bill_to_org_id);
3524: fnd_file.put_line(fnd_file.log, 'Customer Item ID: ' ||x_customer_item_id);

Line 3521: fnd_file.put_line(fnd_file.log, 'Ship-To Organization ID: ' ||x_ship_to_org_id);

3517: --
3518: fnd_file.put_line(fnd_file.log, 'User Input Parameters: ');
3519: fnd_file.put_line(fnd_file.log, 'Operating Unit: ' ||p_org_id);
3520: fnd_file.put_line(fnd_file.log, 'Ship-From Organization ID: ' ||x_ship_from_org_id);
3521: fnd_file.put_line(fnd_file.log, 'Ship-To Organization ID: ' ||x_ship_to_org_id);
3522: fnd_file.put_line(fnd_file.log, 'Intermediate Ship-To Organization ID: ' ||x_intrmd_ship_to_org_id);
3523: fnd_file.put_line(fnd_file.log, 'Bill-To Organization ID: ' ||x_bill_to_org_id);
3524: fnd_file.put_line(fnd_file.log, 'Customer Item ID: ' ||x_customer_item_id);
3525: fnd_file.put_line(fnd_file.log, 'Transaction Start Date: ' ||x_transaction_start_date);

Line 3522: fnd_file.put_line(fnd_file.log, 'Intermediate Ship-To Organization ID: ' ||x_intrmd_ship_to_org_id);

3518: fnd_file.put_line(fnd_file.log, 'User Input Parameters: ');
3519: fnd_file.put_line(fnd_file.log, 'Operating Unit: ' ||p_org_id);
3520: fnd_file.put_line(fnd_file.log, 'Ship-From Organization ID: ' ||x_ship_from_org_id);
3521: fnd_file.put_line(fnd_file.log, 'Ship-To Organization ID: ' ||x_ship_to_org_id);
3522: fnd_file.put_line(fnd_file.log, 'Intermediate Ship-To Organization ID: ' ||x_intrmd_ship_to_org_id);
3523: fnd_file.put_line(fnd_file.log, 'Bill-To Organization ID: ' ||x_bill_to_org_id);
3524: fnd_file.put_line(fnd_file.log, 'Customer Item ID: ' ||x_customer_item_id);
3525: fnd_file.put_line(fnd_file.log, 'Transaction Start Date: ' ||x_transaction_start_date);
3526: fnd_file.put_line(fnd_file.log, 'Transaction End Date: ' ||NVL(v_end_date_time, SYSDATE));

Line 3523: fnd_file.put_line(fnd_file.log, 'Bill-To Organization ID: ' ||x_bill_to_org_id);

3519: fnd_file.put_line(fnd_file.log, 'Operating Unit: ' ||p_org_id);
3520: fnd_file.put_line(fnd_file.log, 'Ship-From Organization ID: ' ||x_ship_from_org_id);
3521: fnd_file.put_line(fnd_file.log, 'Ship-To Organization ID: ' ||x_ship_to_org_id);
3522: fnd_file.put_line(fnd_file.log, 'Intermediate Ship-To Organization ID: ' ||x_intrmd_ship_to_org_id);
3523: fnd_file.put_line(fnd_file.log, 'Bill-To Organization ID: ' ||x_bill_to_org_id);
3524: fnd_file.put_line(fnd_file.log, 'Customer Item ID: ' ||x_customer_item_id);
3525: fnd_file.put_line(fnd_file.log, 'Transaction Start Date: ' ||x_transaction_start_date);
3526: fnd_file.put_line(fnd_file.log, 'Transaction End Date: ' ||NVL(v_end_date_time, SYSDATE));
3527: fnd_file.put_line(fnd_file.log, ' ');

Line 3524: fnd_file.put_line(fnd_file.log, 'Customer Item ID: ' ||x_customer_item_id);

3520: fnd_file.put_line(fnd_file.log, 'Ship-From Organization ID: ' ||x_ship_from_org_id);
3521: fnd_file.put_line(fnd_file.log, 'Ship-To Organization ID: ' ||x_ship_to_org_id);
3522: fnd_file.put_line(fnd_file.log, 'Intermediate Ship-To Organization ID: ' ||x_intrmd_ship_to_org_id);
3523: fnd_file.put_line(fnd_file.log, 'Bill-To Organization ID: ' ||x_bill_to_org_id);
3524: fnd_file.put_line(fnd_file.log, 'Customer Item ID: ' ||x_customer_item_id);
3525: fnd_file.put_line(fnd_file.log, 'Transaction Start Date: ' ||x_transaction_start_date);
3526: fnd_file.put_line(fnd_file.log, 'Transaction End Date: ' ||NVL(v_end_date_time, SYSDATE));
3527: fnd_file.put_line(fnd_file.log, ' ');
3528: --

Line 3525: fnd_file.put_line(fnd_file.log, 'Transaction Start Date: ' ||x_transaction_start_date);

3521: fnd_file.put_line(fnd_file.log, 'Ship-To Organization ID: ' ||x_ship_to_org_id);
3522: fnd_file.put_line(fnd_file.log, 'Intermediate Ship-To Organization ID: ' ||x_intrmd_ship_to_org_id);
3523: fnd_file.put_line(fnd_file.log, 'Bill-To Organization ID: ' ||x_bill_to_org_id);
3524: fnd_file.put_line(fnd_file.log, 'Customer Item ID: ' ||x_customer_item_id);
3525: fnd_file.put_line(fnd_file.log, 'Transaction Start Date: ' ||x_transaction_start_date);
3526: fnd_file.put_line(fnd_file.log, 'Transaction End Date: ' ||NVL(v_end_date_time, SYSDATE));
3527: fnd_file.put_line(fnd_file.log, ' ');
3528: --
3529: -- v_level is used to keep track of where in the program flow the exception occurs

Line 3526: fnd_file.put_line(fnd_file.log, 'Transaction End Date: ' ||NVL(v_end_date_time, SYSDATE));

3522: fnd_file.put_line(fnd_file.log, 'Intermediate Ship-To Organization ID: ' ||x_intrmd_ship_to_org_id);
3523: fnd_file.put_line(fnd_file.log, 'Bill-To Organization ID: ' ||x_bill_to_org_id);
3524: fnd_file.put_line(fnd_file.log, 'Customer Item ID: ' ||x_customer_item_id);
3525: fnd_file.put_line(fnd_file.log, 'Transaction Start Date: ' ||x_transaction_start_date);
3526: fnd_file.put_line(fnd_file.log, 'Transaction End Date: ' ||NVL(v_end_date_time, SYSDATE));
3527: fnd_file.put_line(fnd_file.log, ' ');
3528: --
3529: -- v_level is used to keep track of where in the program flow the exception occurs
3530: -- Find the ship_to_address_id

Line 3527: fnd_file.put_line(fnd_file.log, ' ');

3523: fnd_file.put_line(fnd_file.log, 'Bill-To Organization ID: ' ||x_bill_to_org_id);
3524: fnd_file.put_line(fnd_file.log, 'Customer Item ID: ' ||x_customer_item_id);
3525: fnd_file.put_line(fnd_file.log, 'Transaction Start Date: ' ||x_transaction_start_date);
3526: fnd_file.put_line(fnd_file.log, 'Transaction End Date: ' ||NVL(v_end_date_time, SYSDATE));
3527: fnd_file.put_line(fnd_file.log, ' ');
3528: --
3529: -- v_level is used to keep track of where in the program flow the exception occurs
3530: -- Find the ship_to_address_id
3531: --

Line 3674: fnd_file.put_line(fnd_file.log, 'p_ship_from_org_id: '

3670: rlm_core_sv.dlog(C_SDEBUG, 'v_end_date_time',
3671: v_end_date_time);
3672: END IF;
3673: --
3674: fnd_file.put_line(fnd_file.log, 'p_ship_from_org_id: '
3675: ||p_ship_from_org_id);
3676: fnd_file.put_line(fnd_file.log, 'p_ship_to_org_id: '
3677: ||p_ship_to_org_id);
3678: fnd_file.put_line(fnd_file.log, 'p_intmed_ship_to_org_id: '

Line 3676: fnd_file.put_line(fnd_file.log, 'p_ship_to_org_id: '

3672: END IF;
3673: --
3674: fnd_file.put_line(fnd_file.log, 'p_ship_from_org_id: '
3675: ||p_ship_from_org_id);
3676: fnd_file.put_line(fnd_file.log, 'p_ship_to_org_id: '
3677: ||p_ship_to_org_id);
3678: fnd_file.put_line(fnd_file.log, 'p_intmed_ship_to_org_id: '
3679: ||p_intmed_ship_to_org_id);
3680: fnd_file.put_line(fnd_file.log, 'p_bill_to_org_id: '

Line 3678: fnd_file.put_line(fnd_file.log, 'p_intmed_ship_to_org_id: '

3674: fnd_file.put_line(fnd_file.log, 'p_ship_from_org_id: '
3675: ||p_ship_from_org_id);
3676: fnd_file.put_line(fnd_file.log, 'p_ship_to_org_id: '
3677: ||p_ship_to_org_id);
3678: fnd_file.put_line(fnd_file.log, 'p_intmed_ship_to_org_id: '
3679: ||p_intmed_ship_to_org_id);
3680: fnd_file.put_line(fnd_file.log, 'p_bill_to_org_id: '
3681: ||p_bill_to_org_id);
3682: fnd_file.put_line(fnd_file.log, ' ');

Line 3680: fnd_file.put_line(fnd_file.log, 'p_bill_to_org_id: '

3676: fnd_file.put_line(fnd_file.log, 'p_ship_to_org_id: '
3677: ||p_ship_to_org_id);
3678: fnd_file.put_line(fnd_file.log, 'p_intmed_ship_to_org_id: '
3679: ||p_intmed_ship_to_org_id);
3680: fnd_file.put_line(fnd_file.log, 'p_bill_to_org_id: '
3681: ||p_bill_to_org_id);
3682: fnd_file.put_line(fnd_file.log, ' ');
3683: fnd_file.put_line(fnd_file.log,
3684: 'Loop to find all qualified shipment lines ');

Line 3682: fnd_file.put_line(fnd_file.log, ' ');

3678: fnd_file.put_line(fnd_file.log, 'p_intmed_ship_to_org_id: '
3679: ||p_intmed_ship_to_org_id);
3680: fnd_file.put_line(fnd_file.log, 'p_bill_to_org_id: '
3681: ||p_bill_to_org_id);
3682: fnd_file.put_line(fnd_file.log, ' ');
3683: fnd_file.put_line(fnd_file.log,
3684: 'Loop to find all qualified shipment lines ');
3685: fnd_file.put_line(fnd_file.log, ' ');
3686: --

Line 3683: fnd_file.put_line(fnd_file.log,

3679: ||p_intmed_ship_to_org_id);
3680: fnd_file.put_line(fnd_file.log, 'p_bill_to_org_id: '
3681: ||p_bill_to_org_id);
3682: fnd_file.put_line(fnd_file.log, ' ');
3683: fnd_file.put_line(fnd_file.log,
3684: 'Loop to find all qualified shipment lines ');
3685: fnd_file.put_line(fnd_file.log, ' ');
3686: --
3687: --

Line 3685: fnd_file.put_line(fnd_file.log, ' ');

3681: ||p_bill_to_org_id);
3682: fnd_file.put_line(fnd_file.log, ' ');
3683: fnd_file.put_line(fnd_file.log,
3684: 'Loop to find all qualified shipment lines ');
3685: fnd_file.put_line(fnd_file.log, ' ');
3686: --
3687: --
3688:
3689: v_cum_key_record.customer_id := x_customer_id;

Line 4141: fnd_file.put_line(fnd_file.output, v_trail1);

4137: rlm_message_sv.get_msg_text(
4138: x_message_name => 'RLM_CUM_RESET_TRAIL4',
4139: x_text => v_trail4);
4140: --
4141: fnd_file.put_line(fnd_file.output, v_trail1);
4142: fnd_file.put_line(fnd_file.output, v_trail2);
4143: fnd_file.put_line(fnd_file.output, v_trail3);
4144: fnd_file.put_line(fnd_file.output, v_trail4);
4145: --

Line 4142: fnd_file.put_line(fnd_file.output, v_trail2);

4138: x_message_name => 'RLM_CUM_RESET_TRAIL4',
4139: x_text => v_trail4);
4140: --
4141: fnd_file.put_line(fnd_file.output, v_trail1);
4142: fnd_file.put_line(fnd_file.output, v_trail2);
4143: fnd_file.put_line(fnd_file.output, v_trail3);
4144: fnd_file.put_line(fnd_file.output, v_trail4);
4145: --
4146: END IF; --}

Line 4143: fnd_file.put_line(fnd_file.output, v_trail3);

4139: x_text => v_trail4);
4140: --
4141: fnd_file.put_line(fnd_file.output, v_trail1);
4142: fnd_file.put_line(fnd_file.output, v_trail2);
4143: fnd_file.put_line(fnd_file.output, v_trail3);
4144: fnd_file.put_line(fnd_file.output, v_trail4);
4145: --
4146: END IF; --}
4147: EXIT;

Line 4144: fnd_file.put_line(fnd_file.output, v_trail4);

4140: --
4141: fnd_file.put_line(fnd_file.output, v_trail1);
4142: fnd_file.put_line(fnd_file.output, v_trail2);
4143: fnd_file.put_line(fnd_file.output, v_trail3);
4144: fnd_file.put_line(fnd_file.output, v_trail4);
4145: --
4146: END IF; --}
4147: EXIT;
4148: --}

Line 4229: fnd_file.put_line(fnd_file.output, v_trail1);

4225: rlm_message_sv.get_msg_text(
4226: x_message_name => 'RLM_CUM_RESET_TRAIL4',
4227: x_text => v_trail4);
4228: --
4229: fnd_file.put_line(fnd_file.output, v_trail1);
4230: fnd_file.put_line(fnd_file.output, v_trail2);
4231: fnd_file.put_line(fnd_file.output, v_trail3);
4232: fnd_file.put_line(fnd_file.output, v_trail4);
4233: --

Line 4230: fnd_file.put_line(fnd_file.output, v_trail2);

4226: x_message_name => 'RLM_CUM_RESET_TRAIL4',
4227: x_text => v_trail4);
4228: --
4229: fnd_file.put_line(fnd_file.output, v_trail1);
4230: fnd_file.put_line(fnd_file.output, v_trail2);
4231: fnd_file.put_line(fnd_file.output, v_trail3);
4232: fnd_file.put_line(fnd_file.output, v_trail4);
4233: --
4234: END IF; --}

Line 4231: fnd_file.put_line(fnd_file.output, v_trail3);

4227: x_text => v_trail4);
4228: --
4229: fnd_file.put_line(fnd_file.output, v_trail1);
4230: fnd_file.put_line(fnd_file.output, v_trail2);
4231: fnd_file.put_line(fnd_file.output, v_trail3);
4232: fnd_file.put_line(fnd_file.output, v_trail4);
4233: --
4234: END IF; --}
4235: --

Line 4232: fnd_file.put_line(fnd_file.output, v_trail4);

4228: --
4229: fnd_file.put_line(fnd_file.output, v_trail1);
4230: fnd_file.put_line(fnd_file.output, v_trail2);
4231: fnd_file.put_line(fnd_file.output, v_trail3);
4232: fnd_file.put_line(fnd_file.output, v_trail4);
4233: --
4234: END IF; --}
4235: --
4236: g_oe_line_tbl.DELETE;

Line 4268: fnd_file.put_line(fnd_file.log, 'Process Order Error: '

4264: rlm_core_sv.dlog(C_SDEBUG, 'v_msg_count', v_msg_count);
4265: rlm_core_sv.dlog(C_SDEBUG, 'Main v_msg_data', v_msg_data);
4266: END IF;
4267: --
4268: fnd_file.put_line(fnd_file.log, 'Process Order Error: '
4269: ||v_msg_data);
4270: fnd_file.put_line(fnd_file.log, ' ');
4271: --
4272: IF v_msg_count > 0 THEN --{

Line 4270: fnd_file.put_line(fnd_file.log, ' ');

4266: END IF;
4267: --
4268: fnd_file.put_line(fnd_file.log, 'Process Order Error: '
4269: ||v_msg_data);
4270: fnd_file.put_line(fnd_file.log, ' ');
4271: --
4272: IF v_msg_count > 0 THEN --{
4273: --
4274: FOR k in 1 .. v_msg_count LOOP --{

Line 4279: fnd_file.put_line(fnd_file.log, v_msg_data);

4275: --
4276: v_msg_data := oe_msg_pub.get( p_msg_index => k,
4277: p_encoded=> 'F');
4278: --
4279: fnd_file.put_line(fnd_file.log, v_msg_data);
4280: --
4281: IF (l_debug <> -1) THEN
4282: rlm_core_sv.dlog(C_SDEBUG, 'v_msg_data',
4283: v_msg_data);

Line 4300: fnd_file.put_line(fnd_file.output, v_trail1);

4296: rlm_message_sv.get_msg_text(
4297: x_message_name => 'RLM_CUM_RESET_TRAIL5',
4298: x_text => v_trail5);
4299: --
4300: fnd_file.put_line(fnd_file.output, v_trail1);
4301: fnd_file.put_line(fnd_file.output, v_trail2);
4302: fnd_file.put_line(fnd_file.output, v_trail3);
4303: fnd_file.put_line(fnd_file.output, v_trail4);
4304: fnd_file.put_line(fnd_file.output, v_trail5);

Line 4301: fnd_file.put_line(fnd_file.output, v_trail2);

4297: x_message_name => 'RLM_CUM_RESET_TRAIL5',
4298: x_text => v_trail5);
4299: --
4300: fnd_file.put_line(fnd_file.output, v_trail1);
4301: fnd_file.put_line(fnd_file.output, v_trail2);
4302: fnd_file.put_line(fnd_file.output, v_trail3);
4303: fnd_file.put_line(fnd_file.output, v_trail4);
4304: fnd_file.put_line(fnd_file.output, v_trail5);
4305: --

Line 4302: fnd_file.put_line(fnd_file.output, v_trail3);

4298: x_text => v_trail5);
4299: --
4300: fnd_file.put_line(fnd_file.output, v_trail1);
4301: fnd_file.put_line(fnd_file.output, v_trail2);
4302: fnd_file.put_line(fnd_file.output, v_trail3);
4303: fnd_file.put_line(fnd_file.output, v_trail4);
4304: fnd_file.put_line(fnd_file.output, v_trail5);
4305: --
4306: error_count := error_count+1;

Line 4303: fnd_file.put_line(fnd_file.output, v_trail4);

4299: --
4300: fnd_file.put_line(fnd_file.output, v_trail1);
4301: fnd_file.put_line(fnd_file.output, v_trail2);
4302: fnd_file.put_line(fnd_file.output, v_trail3);
4303: fnd_file.put_line(fnd_file.output, v_trail4);
4304: fnd_file.put_line(fnd_file.output, v_trail5);
4305: --
4306: error_count := error_count+1;
4307: --

Line 4304: fnd_file.put_line(fnd_file.output, v_trail5);

4300: fnd_file.put_line(fnd_file.output, v_trail1);
4301: fnd_file.put_line(fnd_file.output, v_trail2);
4302: fnd_file.put_line(fnd_file.output, v_trail3);
4303: fnd_file.put_line(fnd_file.output, v_trail4);
4304: fnd_file.put_line(fnd_file.output, v_trail5);
4305: --
4306: error_count := error_count+1;
4307: --
4308: ROLLBACK;

Line 4332: fnd_file.put_line(fnd_file.log, 'Process Order Error: '

4328: rlm_core_sv.dlog(C_SDEBUG, 'v_msg_count', v_msg_count);
4329: rlm_core_sv.dlog(C_SDEBUG, 'Main v_msg_data', v_msg_data);
4330: END IF;
4331: --
4332: fnd_file.put_line(fnd_file.log, 'Process Order Error: '
4333: ||v_msg_data);
4334: fnd_file.put_line(fnd_file.log, ' ');
4335: IF v_msg_count > 0 THEN --{
4336: --

Line 4334: fnd_file.put_line(fnd_file.log, ' ');

4330: END IF;
4331: --
4332: fnd_file.put_line(fnd_file.log, 'Process Order Error: '
4333: ||v_msg_data);
4334: fnd_file.put_line(fnd_file.log, ' ');
4335: IF v_msg_count > 0 THEN --{
4336: --
4337: FOR k in 1 .. v_msg_count LOOP --{
4338: --

Line 4342: fnd_file.put_line(fnd_file.log, v_msg_data);

4338: --
4339: v_msg_data := oe_msg_pub.get( p_msg_index => k,
4340: p_encoded=> 'F');
4341: --
4342: fnd_file.put_line(fnd_file.log, v_msg_data);
4343: --
4344: IF (l_debug <> -1) THEN
4345: rlm_core_sv.dlog(C_SDEBUG, 'v_msg_data',
4346: v_msg_data);

Line 4359: fnd_file.put_line(fnd_file.log, 'Process Order Error: '

4355: 'Process Order Error. Rollback');
4356: END IF;
4357: --
4358: --
4359: fnd_file.put_line(fnd_file.log, 'Process Order Error: '
4360: ||v_msg_data);
4361: fnd_file.put_line(fnd_file.log, ' ');
4362: --
4363: rlm_message_sv.get_msg_text(

Line 4361: fnd_file.put_line(fnd_file.log, ' ');

4357: --
4358: --
4359: fnd_file.put_line(fnd_file.log, 'Process Order Error: '
4360: ||v_msg_data);
4361: fnd_file.put_line(fnd_file.log, ' ');
4362: --
4363: rlm_message_sv.get_msg_text(
4364: x_message_name => 'RLM_CUM_RESET_TRAIL5',
4365: x_text => v_trail5);

Line 4367: fnd_file.put_line(fnd_file.output, v_trail1);

4363: rlm_message_sv.get_msg_text(
4364: x_message_name => 'RLM_CUM_RESET_TRAIL5',
4365: x_text => v_trail5);
4366: --
4367: fnd_file.put_line(fnd_file.output, v_trail1);
4368: fnd_file.put_line(fnd_file.output, v_trail2);
4369: fnd_file.put_line(fnd_file.output, v_trail3);
4370: fnd_file.put_line(fnd_file.output, v_trail4);
4371: fnd_file.put_line(fnd_file.output, v_trail5);

Line 4368: fnd_file.put_line(fnd_file.output, v_trail2);

4364: x_message_name => 'RLM_CUM_RESET_TRAIL5',
4365: x_text => v_trail5);
4366: --
4367: fnd_file.put_line(fnd_file.output, v_trail1);
4368: fnd_file.put_line(fnd_file.output, v_trail2);
4369: fnd_file.put_line(fnd_file.output, v_trail3);
4370: fnd_file.put_line(fnd_file.output, v_trail4);
4371: fnd_file.put_line(fnd_file.output, v_trail5);
4372: --

Line 4369: fnd_file.put_line(fnd_file.output, v_trail3);

4365: x_text => v_trail5);
4366: --
4367: fnd_file.put_line(fnd_file.output, v_trail1);
4368: fnd_file.put_line(fnd_file.output, v_trail2);
4369: fnd_file.put_line(fnd_file.output, v_trail3);
4370: fnd_file.put_line(fnd_file.output, v_trail4);
4371: fnd_file.put_line(fnd_file.output, v_trail5);
4372: --
4373: error_count := error_count+1;

Line 4370: fnd_file.put_line(fnd_file.output, v_trail4);

4366: --
4367: fnd_file.put_line(fnd_file.output, v_trail1);
4368: fnd_file.put_line(fnd_file.output, v_trail2);
4369: fnd_file.put_line(fnd_file.output, v_trail3);
4370: fnd_file.put_line(fnd_file.output, v_trail4);
4371: fnd_file.put_line(fnd_file.output, v_trail5);
4372: --
4373: error_count := error_count+1;
4374: --

Line 4371: fnd_file.put_line(fnd_file.output, v_trail5);

4367: fnd_file.put_line(fnd_file.output, v_trail1);
4368: fnd_file.put_line(fnd_file.output, v_trail2);
4369: fnd_file.put_line(fnd_file.output, v_trail3);
4370: fnd_file.put_line(fnd_file.output, v_trail4);
4371: fnd_file.put_line(fnd_file.output, v_trail5);
4372: --
4373: error_count := error_count+1;
4374: --
4375: ROLLBACK;

Line 4397: fnd_file.put_line(fnd_file.log, 'Process Order Error: '

4393: rlm_core_sv.dlog(C_SDEBUG, 'v_msg_count', v_msg_count);
4394: rlm_core_sv.dlog(C_SDEBUG, 'Main v_msg_data', v_msg_data);
4395: END IF;
4396: --
4397: fnd_file.put_line(fnd_file.log, 'Process Order Error: '
4398: ||v_msg_data);
4399: fnd_file.put_line(fnd_file.log, ' ');
4400: --
4401: IF v_msg_count > 0 THEN --{

Line 4399: fnd_file.put_line(fnd_file.log, ' ');

4395: END IF;
4396: --
4397: fnd_file.put_line(fnd_file.log, 'Process Order Error: '
4398: ||v_msg_data);
4399: fnd_file.put_line(fnd_file.log, ' ');
4400: --
4401: IF v_msg_count > 0 THEN --{
4402: --
4403: FOR k in 1 .. v_msg_count LOOP --{

Line 4408: fnd_file.put_line(fnd_file.log, v_msg_data);

4404: --
4405: v_msg_data := oe_msg_pub.get( p_msg_index => k,
4406: p_encoded=> 'F');
4407: --
4408: fnd_file.put_line(fnd_file.log, v_msg_data);
4409: --
4410: IF (l_debug <> -1) THEN
4411: rlm_core_sv.dlog(C_SDEBUG, 'v_msg_data',
4412: v_msg_data);

Line 4424: fnd_file.put_line(fnd_file.log, 'Process Order Error: '

4420: rlm_core_sv.dpop(C_SDEBUG,
4421: 'Process Order Error. Rollback');
4422: END IF;
4423: --
4424: fnd_file.put_line(fnd_file.log, 'Process Order Error: '
4425: || v_msg_data);
4426: fnd_file.put_line(fnd_file.log, ' ');
4427: --
4428: rlm_message_sv.get_msg_text(

Line 4426: fnd_file.put_line(fnd_file.log, ' ');

4422: END IF;
4423: --
4424: fnd_file.put_line(fnd_file.log, 'Process Order Error: '
4425: || v_msg_data);
4426: fnd_file.put_line(fnd_file.log, ' ');
4427: --
4428: rlm_message_sv.get_msg_text(
4429: x_message_name => 'RLM_CUM_RESET_TRAIL5',
4430: x_text => v_trail5);

Line 4432: fnd_file.put_line(fnd_file.output, v_trail1);

4428: rlm_message_sv.get_msg_text(
4429: x_message_name => 'RLM_CUM_RESET_TRAIL5',
4430: x_text => v_trail5);
4431: --
4432: fnd_file.put_line(fnd_file.output, v_trail1);
4433: fnd_file.put_line(fnd_file.output, v_trail2);
4434: fnd_file.put_line(fnd_file.output, v_trail3);
4435: fnd_file.put_line(fnd_file.output, v_trail4);
4436: fnd_file.put_line(fnd_file.output, v_trail5);

Line 4433: fnd_file.put_line(fnd_file.output, v_trail2);

4429: x_message_name => 'RLM_CUM_RESET_TRAIL5',
4430: x_text => v_trail5);
4431: --
4432: fnd_file.put_line(fnd_file.output, v_trail1);
4433: fnd_file.put_line(fnd_file.output, v_trail2);
4434: fnd_file.put_line(fnd_file.output, v_trail3);
4435: fnd_file.put_line(fnd_file.output, v_trail4);
4436: fnd_file.put_line(fnd_file.output, v_trail5);
4437: --

Line 4434: fnd_file.put_line(fnd_file.output, v_trail3);

4430: x_text => v_trail5);
4431: --
4432: fnd_file.put_line(fnd_file.output, v_trail1);
4433: fnd_file.put_line(fnd_file.output, v_trail2);
4434: fnd_file.put_line(fnd_file.output, v_trail3);
4435: fnd_file.put_line(fnd_file.output, v_trail4);
4436: fnd_file.put_line(fnd_file.output, v_trail5);
4437: --
4438: error_count := error_count+1;

Line 4435: fnd_file.put_line(fnd_file.output, v_trail4);

4431: --
4432: fnd_file.put_line(fnd_file.output, v_trail1);
4433: fnd_file.put_line(fnd_file.output, v_trail2);
4434: fnd_file.put_line(fnd_file.output, v_trail3);
4435: fnd_file.put_line(fnd_file.output, v_trail4);
4436: fnd_file.put_line(fnd_file.output, v_trail5);
4437: --
4438: error_count := error_count+1;
4439: --

Line 4436: fnd_file.put_line(fnd_file.output, v_trail5);

4432: fnd_file.put_line(fnd_file.output, v_trail1);
4433: fnd_file.put_line(fnd_file.output, v_trail2);
4434: fnd_file.put_line(fnd_file.output, v_trail3);
4435: fnd_file.put_line(fnd_file.output, v_trail4);
4436: fnd_file.put_line(fnd_file.output, v_trail5);
4437: --
4438: error_count := error_count+1;
4439: --
4440: ROLLBACK;

Line 4455: fnd_file.put_line(fnd_file.log, v_msg_data);

4451: IF (l_debug <> -1) THEN
4452: rlm_core_sv.dlog(C_DEBUG, v_msg_data);
4453: END IF;
4454: --
4455: fnd_file.put_line(fnd_file.log, v_msg_data);
4456: --
4457: END IF; -- cum_control_code }
4458: --}
4459: ELSE --{

Line 4467: fnd_file.put_line(fnd_file.log, v_msg_data);

4463: IF (l_debug <> -1) THEN
4464: rlm_core_sv.dlog(C_DEBUG, v_msg_data);
4465: END IF;
4466: --
4467: fnd_file.put_line(fnd_file.log, v_msg_data);
4468: --
4469: END IF; -- setup_terms_status }
4470: --
4471: v_msg_data := 'Number of lines eligible for adjustment: ';

Line 4477: --fnd_file.put_line(fnd_file.log, v_msg_data ||counter2);

4473: IF (l_debug <> -1) THEN
4474: rlm_core_sv.dlog(C_DEBUG, v_msg_data, counter -1);
4475: END IF;
4476: --
4477: --fnd_file.put_line(fnd_file.log, v_msg_data ||counter2);
4478: --
4479: IF error_count > 0 THEN --{
4480: --
4481: v_msg_data := 'Completed with errors';

Line 4487: fnd_file.put_line(fnd_file.log, v_msg_data);

4483: IF (l_debug <> -1) THEN
4484: rlm_core_sv.dpop(C_DEBUG, v_msg_data);
4485: END IF;
4486: --
4487: fnd_file.put_line(fnd_file.log, v_msg_data);
4488: -- }
4489: ELSE
4490: -- {
4491: IF (l_debug <> -1) THEN

Line 4533: fnd_file.put_line(fnd_file.log, v_msg_data);

4529: IF (l_debug <> -1) THEN
4530: rlm_core_sv.dpop(C_DEBUG, v_msg_data);
4531: END IF;
4532: --
4533: fnd_file.put_line(fnd_file.log, v_msg_data);
4534: --
4535: END IF;--} if error_count = 0
4536: --
4537: EXCEPTION

Line 4609: fnd_file.put_line(fnd_file.log,v_msg_data);

4605: COMMIT;
4606: --
4607: v_msg_data := 'There are no qualifying shipments.';
4608: --
4609: fnd_file.put_line(fnd_file.log,v_msg_data);
4610: --
4611: IF (l_debug <> -1) THEN
4612: rlm_core_sv.dpop(C_SDEBUG,'ResetCum:e_NoCum');
4613: END IF;

Line 4620: fnd_file.put_line(fnd_file.log,v_msg_data);

4616: --
4617: v_msg_data := 'There are no qualifying shipments. Manual adjustments'
4618: ||' would be processed';
4619: --
4620: fnd_file.put_line(fnd_file.log,v_msg_data);
4621: --
4622: BEGIN
4623: --
4624: IF (l_debug <> -1) THEN

Line 4656: fnd_file.put_line(fnd_file.log,v_msg_data);

4652: ROLLBACK;
4653: --
4654: END IF;
4655: --
4656: fnd_file.put_line(fnd_file.log,v_msg_data);
4657: --
4658: ELSE
4659: --
4660: v_msg_data := 'Completed successfully';

Line 4662: fnd_file.put_line(fnd_file.log,v_msg_data);

4658: ELSE
4659: --
4660: v_msg_data := 'Completed successfully';
4661: --
4662: fnd_file.put_line(fnd_file.log,v_msg_data);
4663: --
4664: END IF;
4665: --
4666: COMMIT;

Line 4675: fnd_file.put_line(fnd_file.log, substr(SQLERRM,1,200));

4671: IF (l_debug <> -1) THEN
4672: rlm_core_sv.dlog(C_DEBUG, 'when others::',substr(SQLERRM,1,200));
4673: END IF;
4674: --
4675: fnd_file.put_line(fnd_file.log, substr(SQLERRM,1,200));
4676: --
4677: x_return_status := FALSE;
4678: END;
4679: --

Line 4690: fnd_file.put_line(fnd_file.log, substr(SQLERRM,1,200));

4686: IF (l_debug <> -1) THEN
4687: rlm_core_sv.dpop(C_SDEBUG, substr(SQLERRM,1,200));
4688: END IF;
4689: --
4690: fnd_file.put_line(fnd_file.log, substr(SQLERRM,1,200));
4691: --
4692: x_return_status := FALSE;
4693: --
4694: ROLLBACK;

Line 5192: fnd_file.put_line(fnd_file.log,'Could not find '

5188: --
5189: IF(v_cum_rec_ctr - v_counter_ctr) <> 1 THEN --{
5190: --
5191: IF x_cum_records.EXISTS(v_cum_rec_ctr-1) THEN
5192: fnd_file.put_line(fnd_file.log,'Could not find '
5193: ||'corresponding CumKey for cum_key_id: ' ||
5194: x_cum_records(v_cum_rec_ctr-1).cum_key_id);
5195: --
5196: IF (l_debug <> -1) THEN

Line 6027: fnd_file.put_line(fnd_file.log,'Failed to update Old CUMs, rolling back');

6023: IF (l_debug <> -1) THEN
6024: rlm_core_sv.dlog(C_DEBUG,'SetSupplierCum failed');
6025: END IF;
6026: --
6027: fnd_file.put_line(fnd_file.log,'Failed to update Old CUMs, rolling back');
6028: RAISE e_SetSupplierCum;
6029: --
6030: ELSE --{
6031: --

Line 6323: fnd_file.put_line(fnd_file.log, v_msg_data);

6319: rlm_message_sv.get_msg_text(
6320: x_message_name => 'RLM_CUM_PROCESS_ORDER',
6321: x_text => v_msg_data);
6322: --
6323: fnd_file.put_line(fnd_file.log, v_msg_data);
6324: --
6325: -- DEBUGGING
6326: IF (l_debug <> -1) THEN
6327: rlm_core_sv.dlog(C_SDEBUG, 'G_EXC_ERROR');

Line 6341: fnd_file.put_line(fnd_file.log, v_msg_data);

6337: --
6338: v_msg_data := oe_msg_pub.get( p_msg_index => k,
6339: p_encoded => 'F');
6340: --
6341: fnd_file.put_line(fnd_file.log, v_msg_data);
6342: --
6343: IF (l_debug <> -1) THEN
6344: rlm_core_sv.dlog(C_SDEBUG, 'v_msg_data', v_msg_data);
6345: END IF;

Line 6372: fnd_file.put_line(fnd_file.log, v_msg_data);

6368: rlm_message_sv.get_msg_text(
6369: x_message_name => 'RLM_CUM_PROCESS_ORDER',
6370: x_text => v_msg_data);
6371: --
6372: fnd_file.put_line(fnd_file.log, v_msg_data);
6373: --
6374: -- DEBUGGING
6375: IF (l_debug <> -1) THEN
6376: rlm_core_sv.dlog(C_SDEBUG, 'G_EXC_UNEXPECTED_ERROR');

Line 6390: fnd_file.put_line(fnd_file.log, v_msg_data);

6386: --
6387: v_msg_data := oe_msg_pub.get( p_msg_index => k,
6388: p_encoded => 'F');
6389: --
6390: fnd_file.put_line(fnd_file.log, v_msg_data);
6391: --
6392: IF (l_debug <> -1) THEN
6393: rlm_core_sv.dlog(C_SDEBUG, 'v_msg_data', v_msg_data);
6394: END IF;