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 1775: fnd_file.put_line(fnd_file.log, v_msg_text);

1771: x_value4 => v_cum_record.actual_shipment_date,
1772: x_token5 => 'SHIP_QTY',
1773: x_value5 => v_cum_record.shipped_quantity);
1774: --
1775: fnd_file.put_line(fnd_file.log, v_msg_text);
1776: --
1777: --Find customer_id, as it is a required input parameter for rlm_setup_terms
1778: --
1779: v_level := 'CUSTOMER_ID';

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

1828: x_text => v_msg_text,
1829: x_token1 => 'CUM_CONTROL_CODE',
1830: x_value1 => v_rlm_setup_terms_record.cum_control_code);
1831: --
1832: fnd_file.put_line(fnd_file.log, v_msg_text);
1833: --
1834: --Continue only if cum_control_code is found and not set to NO_CUM
1835: --
1836: IF v_setup_terms_status = TRUE AND

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

1882: x_text => v_msg_text,
1883: x_token1 => 'CUM_KEY_ID',
1884: x_value1 => v_cum_record.cum_key_id);
1885: --
1886: fnd_file.put_line(fnd_file.log, v_msg_text);
1887: --
1888: ELSE
1889: --
1890: RAISE e_general_error;

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

2068: rlm_message_sv.get_msg_text(
2069: x_message_name => 'RLM_TRIP_NO_UPDATE',
2070: x_text => v_msg_text);
2071: --
2072: fnd_file.put_line(fnd_file.log, v_msg_text);
2073: --
2074: -- Pls do not remove the line below
2075: --
2076: v_msg_text := 'RLM_TRIP_NO_UPDATE';

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

2098: rlm_message_sv.get_msg_text(
2099: x_message_name => 'RLM_TRIP_NO_SETUP',
2100: x_text => v_msg_text);
2101: --
2102: fnd_file.put_line(fnd_file.log, v_msg_text);
2103: --
2104: END IF; -- v_cum_control_code <> 'NO_CUM'
2105: --
2106: END LOOP; -- END LOOP to fetch OE Order Lines

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

2215: --
2216: x_msg_data := oe_msg_pub.get( p_msg_index => k,
2217: p_encoded => 'F');
2218: --
2219: fnd_file.put_line(fnd_file.log, x_msg_data);
2220: --
2221: IF (l_debug <> -1) THEN
2222: rlm_core_sv.dlog(C_SDEBUG, 'x_msg_data', x_msg_data);
2223: END IF;

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

2236: rlm_message_sv.get_msg_text(
2237: x_message_name => 'RLM_CUM_PROCESS_ORDER',
2238: x_text => v_msg_text);
2239: --
2240: fnd_file.put_line(fnd_file.log, v_msg_text);
2241: --
2242: IF (l_debug <> -1) THEN
2243: rlm_core_sv.stop_debug;
2244: END IF;

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

2275: --
2276: x_msg_data := oe_msg_pub.get( p_msg_index => k,
2277: p_encoded => 'F');
2278: --
2279: fnd_file.put_line(fnd_file.log, x_msg_data);
2280: --
2281: IF (l_debug <> -1) THEN
2282: rlm_core_sv.dlog(C_SDEBUG, 'x_msg_data', x_msg_data);
2283: END IF;

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

2296: rlm_message_sv.get_msg_text(
2297: x_message_name => 'RLM_CUM_PROCESS_ORDER',
2298: x_text => v_msg_text);
2299: --
2300: fnd_file.put_line(fnd_file.log, v_msg_text);
2301: --
2302: IF (l_debug <> -1) THEN
2303: rlm_core_sv.stop_debug;
2304: END IF;

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

2332: --
2333: x_msg_data := oe_msg_pub.get( p_msg_index => k,
2334: p_encoded => 'F');
2335: --
2336: fnd_file.put_line(fnd_file.log, x_msg_data);
2337: --
2338: IF (l_debug <> -1) THEN
2339: rlm_core_sv.dlog(C_SDEBUG, 'x_msg_data', x_msg_data);
2340: END IF;

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

2351: rlm_message_sv.get_msg_text(
2352: x_message_name => 'RLM_CUM_PROCESS_ORDER',
2353: x_text => v_msg_text);
2354: --
2355: fnd_file.put_line(fnd_file.log, v_msg_text);
2356: --
2357: IF (l_debug <> -1) THEN
2358: rlm_core_sv.stop_debug;
2359: END IF;

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

2375: rlm_message_sv.get_msg_text(
2376: x_message_name => 'RLM_CUM_SUCCESS',
2377: x_text => v_msg_text);
2378: --
2379: fnd_file.put_line(fnd_file.log, v_msg_text);
2380: --
2381: IF (l_debug <> -1) THEN
2382: rlm_core_sv.stop_debug;
2383: END IF;

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

2430: x_text => v_msg_text);
2431: --
2432: END IF;
2433: --
2434: fnd_file.put_line(fnd_file.log, v_msg_text);
2435: --
2436: WHEN e_no_shipment_line THEN
2437: ----------------------------------------------------+
2438: DECLARE

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

2468: --
2469: -- Bug 1306894: Shipping requests the removal of this
2470: -- misleading message for non-RLM customers
2471: --
2472: -- fnd_file.put_line(fnd_file.log, v_msg_text);
2473: --
2474: IF (l_debug <> -1) THEN
2475: rlm_core_sv.stop_debug;
2476: END IF;

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

2489: rlm_core_sv.dpop(C_SDEBUG, v_msg_text);
2490: rlm_core_sv.stop_debug;
2491: END IF;
2492: --
2493: fnd_file.put_line(fnd_file.log, v_msg_text);
2494: --
2495: END;
2496: -----------------------------------------------------------+
2497: WHEN e_null_mandatory THEN

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

2510: rlm_core_sv.dpop(C_SDEBUG, v_msg_text);
2511: rlm_core_sv.stop_debug;
2512: END IF;
2513: --
2514: fnd_file.put_line(fnd_file.log, v_msg_text);
2515: --
2516: WHEN e_cum_start_date THEN
2517: --
2518: ROLLBACK to updatecumkey;

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

2529: rlm_core_sv.dpop(C_SDEBUG, v_msg_text);
2530: rlm_core_sv.stop_debug;
2531: END IF;
2532: --
2533: fnd_file.put_line(fnd_file.log, v_msg_text);
2534: --
2535: WHEN e_no_cum_key THEN
2536: ROLLBACK to updatecumkey;
2537: rlm_message_sv.get_msg_text(

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

2545: rlm_core_sv.dlog(C_SDEBUG, 'EXCEPTION: e_no_cum_key');
2546: rlm_core_sv.dpop(C_SDEBUG);
2547: rlm_core_sv.stop_debug;
2548: END IF;
2549: fnd_file.put_line(fnd_file.log, v_msg_text);
2550:
2551: WHEN e_general_error THEN
2552: --
2553: ROLLBACK to updatecumkey;

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

2568: rlm_core_sv.dpop(C_SDEBUG, v_msg_text);
2569: rlm_core_sv.stop_debug;
2570: END IF;
2571: --
2572: fnd_file.put_line(fnd_file.log, v_msg_text);
2573: --
2574: END UpdateCumKey;
2575:
2576: /*============================================================================

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

3504: END IF;
3505: --
3506: -- Start logging the ResetCum trail into the fnd log file here!
3507: --
3508: fnd_file.put_line(fnd_file.log, 'User Input Parameters: ');
3509: fnd_file.put_line(fnd_file.log, 'Operating Unit: ' ||p_org_id);
3510: fnd_file.put_line(fnd_file.log, 'Ship-From Organization ID: ' ||x_ship_from_org_id);
3511: fnd_file.put_line(fnd_file.log, 'Ship-To Organization ID: ' ||x_ship_to_org_id);
3512: fnd_file.put_line(fnd_file.log, 'Intermediate Ship-To Organization ID: ' ||x_intrmd_ship_to_org_id);

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

3505: --
3506: -- Start logging the ResetCum trail into the fnd log file here!
3507: --
3508: fnd_file.put_line(fnd_file.log, 'User Input Parameters: ');
3509: fnd_file.put_line(fnd_file.log, 'Operating Unit: ' ||p_org_id);
3510: fnd_file.put_line(fnd_file.log, 'Ship-From Organization ID: ' ||x_ship_from_org_id);
3511: fnd_file.put_line(fnd_file.log, 'Ship-To Organization ID: ' ||x_ship_to_org_id);
3512: fnd_file.put_line(fnd_file.log, 'Intermediate Ship-To Organization ID: ' ||x_intrmd_ship_to_org_id);
3513: fnd_file.put_line(fnd_file.log, 'Bill-To Organization ID: ' ||x_bill_to_org_id);

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

3506: -- Start logging the ResetCum trail into the fnd log file here!
3507: --
3508: fnd_file.put_line(fnd_file.log, 'User Input Parameters: ');
3509: fnd_file.put_line(fnd_file.log, 'Operating Unit: ' ||p_org_id);
3510: fnd_file.put_line(fnd_file.log, 'Ship-From Organization ID: ' ||x_ship_from_org_id);
3511: fnd_file.put_line(fnd_file.log, 'Ship-To Organization ID: ' ||x_ship_to_org_id);
3512: fnd_file.put_line(fnd_file.log, 'Intermediate Ship-To Organization ID: ' ||x_intrmd_ship_to_org_id);
3513: fnd_file.put_line(fnd_file.log, 'Bill-To Organization ID: ' ||x_bill_to_org_id);
3514: fnd_file.put_line(fnd_file.log, 'Customer Item ID: ' ||x_customer_item_id);

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

3507: --
3508: fnd_file.put_line(fnd_file.log, 'User Input Parameters: ');
3509: fnd_file.put_line(fnd_file.log, 'Operating Unit: ' ||p_org_id);
3510: fnd_file.put_line(fnd_file.log, 'Ship-From Organization ID: ' ||x_ship_from_org_id);
3511: fnd_file.put_line(fnd_file.log, 'Ship-To Organization ID: ' ||x_ship_to_org_id);
3512: fnd_file.put_line(fnd_file.log, 'Intermediate Ship-To Organization ID: ' ||x_intrmd_ship_to_org_id);
3513: fnd_file.put_line(fnd_file.log, 'Bill-To Organization ID: ' ||x_bill_to_org_id);
3514: fnd_file.put_line(fnd_file.log, 'Customer Item ID: ' ||x_customer_item_id);
3515: fnd_file.put_line(fnd_file.log, 'Transaction Start Date: ' ||x_transaction_start_date);

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

3508: fnd_file.put_line(fnd_file.log, 'User Input Parameters: ');
3509: fnd_file.put_line(fnd_file.log, 'Operating Unit: ' ||p_org_id);
3510: fnd_file.put_line(fnd_file.log, 'Ship-From Organization ID: ' ||x_ship_from_org_id);
3511: fnd_file.put_line(fnd_file.log, 'Ship-To Organization ID: ' ||x_ship_to_org_id);
3512: fnd_file.put_line(fnd_file.log, 'Intermediate Ship-To Organization ID: ' ||x_intrmd_ship_to_org_id);
3513: fnd_file.put_line(fnd_file.log, 'Bill-To Organization ID: ' ||x_bill_to_org_id);
3514: fnd_file.put_line(fnd_file.log, 'Customer Item ID: ' ||x_customer_item_id);
3515: fnd_file.put_line(fnd_file.log, 'Transaction Start Date: ' ||x_transaction_start_date);
3516: fnd_file.put_line(fnd_file.log, 'Transaction End Date: ' ||NVL(v_end_date_time, SYSDATE));

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

3509: fnd_file.put_line(fnd_file.log, 'Operating Unit: ' ||p_org_id);
3510: fnd_file.put_line(fnd_file.log, 'Ship-From Organization ID: ' ||x_ship_from_org_id);
3511: fnd_file.put_line(fnd_file.log, 'Ship-To Organization ID: ' ||x_ship_to_org_id);
3512: fnd_file.put_line(fnd_file.log, 'Intermediate Ship-To Organization ID: ' ||x_intrmd_ship_to_org_id);
3513: fnd_file.put_line(fnd_file.log, 'Bill-To Organization ID: ' ||x_bill_to_org_id);
3514: fnd_file.put_line(fnd_file.log, 'Customer Item ID: ' ||x_customer_item_id);
3515: fnd_file.put_line(fnd_file.log, 'Transaction Start Date: ' ||x_transaction_start_date);
3516: fnd_file.put_line(fnd_file.log, 'Transaction End Date: ' ||NVL(v_end_date_time, SYSDATE));
3517: fnd_file.put_line(fnd_file.log, ' ');

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

3510: fnd_file.put_line(fnd_file.log, 'Ship-From Organization ID: ' ||x_ship_from_org_id);
3511: fnd_file.put_line(fnd_file.log, 'Ship-To Organization ID: ' ||x_ship_to_org_id);
3512: fnd_file.put_line(fnd_file.log, 'Intermediate Ship-To Organization ID: ' ||x_intrmd_ship_to_org_id);
3513: fnd_file.put_line(fnd_file.log, 'Bill-To Organization ID: ' ||x_bill_to_org_id);
3514: fnd_file.put_line(fnd_file.log, 'Customer Item ID: ' ||x_customer_item_id);
3515: fnd_file.put_line(fnd_file.log, 'Transaction Start Date: ' ||x_transaction_start_date);
3516: fnd_file.put_line(fnd_file.log, 'Transaction End Date: ' ||NVL(v_end_date_time, SYSDATE));
3517: fnd_file.put_line(fnd_file.log, ' ');
3518: --

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

3511: fnd_file.put_line(fnd_file.log, 'Ship-To Organization ID: ' ||x_ship_to_org_id);
3512: fnd_file.put_line(fnd_file.log, 'Intermediate Ship-To Organization ID: ' ||x_intrmd_ship_to_org_id);
3513: fnd_file.put_line(fnd_file.log, 'Bill-To Organization ID: ' ||x_bill_to_org_id);
3514: fnd_file.put_line(fnd_file.log, 'Customer Item ID: ' ||x_customer_item_id);
3515: fnd_file.put_line(fnd_file.log, 'Transaction Start Date: ' ||x_transaction_start_date);
3516: fnd_file.put_line(fnd_file.log, 'Transaction End Date: ' ||NVL(v_end_date_time, SYSDATE));
3517: fnd_file.put_line(fnd_file.log, ' ');
3518: --
3519: -- v_level is used to keep track of where in the program flow the exception occurs

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

3512: fnd_file.put_line(fnd_file.log, 'Intermediate Ship-To Organization ID: ' ||x_intrmd_ship_to_org_id);
3513: fnd_file.put_line(fnd_file.log, 'Bill-To Organization ID: ' ||x_bill_to_org_id);
3514: fnd_file.put_line(fnd_file.log, 'Customer Item ID: ' ||x_customer_item_id);
3515: fnd_file.put_line(fnd_file.log, 'Transaction Start Date: ' ||x_transaction_start_date);
3516: fnd_file.put_line(fnd_file.log, 'Transaction End Date: ' ||NVL(v_end_date_time, SYSDATE));
3517: fnd_file.put_line(fnd_file.log, ' ');
3518: --
3519: -- v_level is used to keep track of where in the program flow the exception occurs
3520: -- Find the ship_to_address_id

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

3513: fnd_file.put_line(fnd_file.log, 'Bill-To Organization ID: ' ||x_bill_to_org_id);
3514: fnd_file.put_line(fnd_file.log, 'Customer Item ID: ' ||x_customer_item_id);
3515: fnd_file.put_line(fnd_file.log, 'Transaction Start Date: ' ||x_transaction_start_date);
3516: fnd_file.put_line(fnd_file.log, 'Transaction End Date: ' ||NVL(v_end_date_time, SYSDATE));
3517: fnd_file.put_line(fnd_file.log, ' ');
3518: --
3519: -- v_level is used to keep track of where in the program flow the exception occurs
3520: -- Find the ship_to_address_id
3521: --

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

3660: rlm_core_sv.dlog(C_SDEBUG, 'v_end_date_time',
3661: v_end_date_time);
3662: END IF;
3663: --
3664: fnd_file.put_line(fnd_file.log, 'p_ship_from_org_id: '
3665: ||p_ship_from_org_id);
3666: fnd_file.put_line(fnd_file.log, 'p_ship_to_org_id: '
3667: ||p_ship_to_org_id);
3668: fnd_file.put_line(fnd_file.log, 'p_intmed_ship_to_org_id: '

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

3662: END IF;
3663: --
3664: fnd_file.put_line(fnd_file.log, 'p_ship_from_org_id: '
3665: ||p_ship_from_org_id);
3666: fnd_file.put_line(fnd_file.log, 'p_ship_to_org_id: '
3667: ||p_ship_to_org_id);
3668: fnd_file.put_line(fnd_file.log, 'p_intmed_ship_to_org_id: '
3669: ||p_intmed_ship_to_org_id);
3670: fnd_file.put_line(fnd_file.log, 'p_bill_to_org_id: '

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

3664: fnd_file.put_line(fnd_file.log, 'p_ship_from_org_id: '
3665: ||p_ship_from_org_id);
3666: fnd_file.put_line(fnd_file.log, 'p_ship_to_org_id: '
3667: ||p_ship_to_org_id);
3668: fnd_file.put_line(fnd_file.log, 'p_intmed_ship_to_org_id: '
3669: ||p_intmed_ship_to_org_id);
3670: fnd_file.put_line(fnd_file.log, 'p_bill_to_org_id: '
3671: ||p_bill_to_org_id);
3672: fnd_file.put_line(fnd_file.log, ' ');

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

3666: fnd_file.put_line(fnd_file.log, 'p_ship_to_org_id: '
3667: ||p_ship_to_org_id);
3668: fnd_file.put_line(fnd_file.log, 'p_intmed_ship_to_org_id: '
3669: ||p_intmed_ship_to_org_id);
3670: fnd_file.put_line(fnd_file.log, 'p_bill_to_org_id: '
3671: ||p_bill_to_org_id);
3672: fnd_file.put_line(fnd_file.log, ' ');
3673: fnd_file.put_line(fnd_file.log,
3674: 'Loop to find all qualified shipment lines ');

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

3668: fnd_file.put_line(fnd_file.log, 'p_intmed_ship_to_org_id: '
3669: ||p_intmed_ship_to_org_id);
3670: fnd_file.put_line(fnd_file.log, 'p_bill_to_org_id: '
3671: ||p_bill_to_org_id);
3672: fnd_file.put_line(fnd_file.log, ' ');
3673: fnd_file.put_line(fnd_file.log,
3674: 'Loop to find all qualified shipment lines ');
3675: fnd_file.put_line(fnd_file.log, ' ');
3676: --

Line 3673: fnd_file.put_line(fnd_file.log,

3669: ||p_intmed_ship_to_org_id);
3670: fnd_file.put_line(fnd_file.log, 'p_bill_to_org_id: '
3671: ||p_bill_to_org_id);
3672: fnd_file.put_line(fnd_file.log, ' ');
3673: fnd_file.put_line(fnd_file.log,
3674: 'Loop to find all qualified shipment lines ');
3675: fnd_file.put_line(fnd_file.log, ' ');
3676: --
3677: --

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

3671: ||p_bill_to_org_id);
3672: fnd_file.put_line(fnd_file.log, ' ');
3673: fnd_file.put_line(fnd_file.log,
3674: 'Loop to find all qualified shipment lines ');
3675: fnd_file.put_line(fnd_file.log, ' ');
3676: --
3677: --
3678:
3679: v_cum_key_record.customer_id := x_customer_id;

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

4127: rlm_message_sv.get_msg_text(
4128: x_message_name => 'RLM_CUM_RESET_TRAIL4',
4129: x_text => v_trail4);
4130: --
4131: fnd_file.put_line(fnd_file.output, v_trail1);
4132: fnd_file.put_line(fnd_file.output, v_trail2);
4133: fnd_file.put_line(fnd_file.output, v_trail3);
4134: fnd_file.put_line(fnd_file.output, v_trail4);
4135: --

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

4128: x_message_name => 'RLM_CUM_RESET_TRAIL4',
4129: x_text => v_trail4);
4130: --
4131: fnd_file.put_line(fnd_file.output, v_trail1);
4132: fnd_file.put_line(fnd_file.output, v_trail2);
4133: fnd_file.put_line(fnd_file.output, v_trail3);
4134: fnd_file.put_line(fnd_file.output, v_trail4);
4135: --
4136: END IF; --}

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

4129: x_text => v_trail4);
4130: --
4131: fnd_file.put_line(fnd_file.output, v_trail1);
4132: fnd_file.put_line(fnd_file.output, v_trail2);
4133: fnd_file.put_line(fnd_file.output, v_trail3);
4134: fnd_file.put_line(fnd_file.output, v_trail4);
4135: --
4136: END IF; --}
4137: EXIT;

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

4130: --
4131: fnd_file.put_line(fnd_file.output, v_trail1);
4132: fnd_file.put_line(fnd_file.output, v_trail2);
4133: fnd_file.put_line(fnd_file.output, v_trail3);
4134: fnd_file.put_line(fnd_file.output, v_trail4);
4135: --
4136: END IF; --}
4137: EXIT;
4138: --}

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

4215: rlm_message_sv.get_msg_text(
4216: x_message_name => 'RLM_CUM_RESET_TRAIL4',
4217: x_text => v_trail4);
4218: --
4219: fnd_file.put_line(fnd_file.output, v_trail1);
4220: fnd_file.put_line(fnd_file.output, v_trail2);
4221: fnd_file.put_line(fnd_file.output, v_trail3);
4222: fnd_file.put_line(fnd_file.output, v_trail4);
4223: --

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

4216: x_message_name => 'RLM_CUM_RESET_TRAIL4',
4217: x_text => v_trail4);
4218: --
4219: fnd_file.put_line(fnd_file.output, v_trail1);
4220: fnd_file.put_line(fnd_file.output, v_trail2);
4221: fnd_file.put_line(fnd_file.output, v_trail3);
4222: fnd_file.put_line(fnd_file.output, v_trail4);
4223: --
4224: END IF; --}

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

4217: x_text => v_trail4);
4218: --
4219: fnd_file.put_line(fnd_file.output, v_trail1);
4220: fnd_file.put_line(fnd_file.output, v_trail2);
4221: fnd_file.put_line(fnd_file.output, v_trail3);
4222: fnd_file.put_line(fnd_file.output, v_trail4);
4223: --
4224: END IF; --}
4225: --

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

4218: --
4219: fnd_file.put_line(fnd_file.output, v_trail1);
4220: fnd_file.put_line(fnd_file.output, v_trail2);
4221: fnd_file.put_line(fnd_file.output, v_trail3);
4222: fnd_file.put_line(fnd_file.output, v_trail4);
4223: --
4224: END IF; --}
4225: --
4226: g_oe_line_tbl.DELETE;

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

4254: rlm_core_sv.dlog(C_SDEBUG, 'v_msg_count', v_msg_count);
4255: rlm_core_sv.dlog(C_SDEBUG, 'Main v_msg_data', v_msg_data);
4256: END IF;
4257: --
4258: fnd_file.put_line(fnd_file.log, 'Process Order Error: '
4259: ||v_msg_data);
4260: fnd_file.put_line(fnd_file.log, ' ');
4261: --
4262: IF v_msg_count > 0 THEN --{

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

4256: END IF;
4257: --
4258: fnd_file.put_line(fnd_file.log, 'Process Order Error: '
4259: ||v_msg_data);
4260: fnd_file.put_line(fnd_file.log, ' ');
4261: --
4262: IF v_msg_count > 0 THEN --{
4263: --
4264: FOR k in 1 .. v_msg_count LOOP --{

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

4265: --
4266: v_msg_data := oe_msg_pub.get( p_msg_index => k,
4267: p_encoded=> 'F');
4268: --
4269: fnd_file.put_line(fnd_file.log, v_msg_data);
4270: --
4271: IF (l_debug <> -1) THEN
4272: rlm_core_sv.dlog(C_SDEBUG, 'v_msg_data',
4273: v_msg_data);

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

4286: rlm_message_sv.get_msg_text(
4287: x_message_name => 'RLM_CUM_RESET_TRAIL5',
4288: x_text => v_trail5);
4289: --
4290: fnd_file.put_line(fnd_file.output, v_trail1);
4291: fnd_file.put_line(fnd_file.output, v_trail2);
4292: fnd_file.put_line(fnd_file.output, v_trail3);
4293: fnd_file.put_line(fnd_file.output, v_trail4);
4294: fnd_file.put_line(fnd_file.output, v_trail5);

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

4287: x_message_name => 'RLM_CUM_RESET_TRAIL5',
4288: x_text => v_trail5);
4289: --
4290: fnd_file.put_line(fnd_file.output, v_trail1);
4291: fnd_file.put_line(fnd_file.output, v_trail2);
4292: fnd_file.put_line(fnd_file.output, v_trail3);
4293: fnd_file.put_line(fnd_file.output, v_trail4);
4294: fnd_file.put_line(fnd_file.output, v_trail5);
4295: --

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

4288: x_text => v_trail5);
4289: --
4290: fnd_file.put_line(fnd_file.output, v_trail1);
4291: fnd_file.put_line(fnd_file.output, v_trail2);
4292: fnd_file.put_line(fnd_file.output, v_trail3);
4293: fnd_file.put_line(fnd_file.output, v_trail4);
4294: fnd_file.put_line(fnd_file.output, v_trail5);
4295: --
4296: error_count := error_count+1;

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

4289: --
4290: fnd_file.put_line(fnd_file.output, v_trail1);
4291: fnd_file.put_line(fnd_file.output, v_trail2);
4292: fnd_file.put_line(fnd_file.output, v_trail3);
4293: fnd_file.put_line(fnd_file.output, v_trail4);
4294: fnd_file.put_line(fnd_file.output, v_trail5);
4295: --
4296: error_count := error_count+1;
4297: --

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

4290: fnd_file.put_line(fnd_file.output, v_trail1);
4291: fnd_file.put_line(fnd_file.output, v_trail2);
4292: fnd_file.put_line(fnd_file.output, v_trail3);
4293: fnd_file.put_line(fnd_file.output, v_trail4);
4294: fnd_file.put_line(fnd_file.output, v_trail5);
4295: --
4296: error_count := error_count+1;
4297: --
4298: ROLLBACK;

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

4318: rlm_core_sv.dlog(C_SDEBUG, 'v_msg_count', v_msg_count);
4319: rlm_core_sv.dlog(C_SDEBUG, 'Main v_msg_data', v_msg_data);
4320: END IF;
4321: --
4322: fnd_file.put_line(fnd_file.log, 'Process Order Error: '
4323: ||v_msg_data);
4324: fnd_file.put_line(fnd_file.log, ' ');
4325: IF v_msg_count > 0 THEN --{
4326: --

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

4320: END IF;
4321: --
4322: fnd_file.put_line(fnd_file.log, 'Process Order Error: '
4323: ||v_msg_data);
4324: fnd_file.put_line(fnd_file.log, ' ');
4325: IF v_msg_count > 0 THEN --{
4326: --
4327: FOR k in 1 .. v_msg_count LOOP --{
4328: --

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

4328: --
4329: v_msg_data := oe_msg_pub.get( p_msg_index => k,
4330: p_encoded=> 'F');
4331: --
4332: fnd_file.put_line(fnd_file.log, v_msg_data);
4333: --
4334: IF (l_debug <> -1) THEN
4335: rlm_core_sv.dlog(C_SDEBUG, 'v_msg_data',
4336: v_msg_data);

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

4345: 'Process Order Error. Rollback');
4346: END IF;
4347: --
4348: --
4349: fnd_file.put_line(fnd_file.log, 'Process Order Error: '
4350: ||v_msg_data);
4351: fnd_file.put_line(fnd_file.log, ' ');
4352: --
4353: rlm_message_sv.get_msg_text(

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

4347: --
4348: --
4349: fnd_file.put_line(fnd_file.log, 'Process Order Error: '
4350: ||v_msg_data);
4351: fnd_file.put_line(fnd_file.log, ' ');
4352: --
4353: rlm_message_sv.get_msg_text(
4354: x_message_name => 'RLM_CUM_RESET_TRAIL5',
4355: x_text => v_trail5);

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

4353: rlm_message_sv.get_msg_text(
4354: x_message_name => 'RLM_CUM_RESET_TRAIL5',
4355: x_text => v_trail5);
4356: --
4357: fnd_file.put_line(fnd_file.output, v_trail1);
4358: fnd_file.put_line(fnd_file.output, v_trail2);
4359: fnd_file.put_line(fnd_file.output, v_trail3);
4360: fnd_file.put_line(fnd_file.output, v_trail4);
4361: fnd_file.put_line(fnd_file.output, v_trail5);

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

4354: x_message_name => 'RLM_CUM_RESET_TRAIL5',
4355: x_text => v_trail5);
4356: --
4357: fnd_file.put_line(fnd_file.output, v_trail1);
4358: fnd_file.put_line(fnd_file.output, v_trail2);
4359: fnd_file.put_line(fnd_file.output, v_trail3);
4360: fnd_file.put_line(fnd_file.output, v_trail4);
4361: fnd_file.put_line(fnd_file.output, v_trail5);
4362: --

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

4355: x_text => v_trail5);
4356: --
4357: fnd_file.put_line(fnd_file.output, v_trail1);
4358: fnd_file.put_line(fnd_file.output, v_trail2);
4359: fnd_file.put_line(fnd_file.output, v_trail3);
4360: fnd_file.put_line(fnd_file.output, v_trail4);
4361: fnd_file.put_line(fnd_file.output, v_trail5);
4362: --
4363: error_count := error_count+1;

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

4356: --
4357: fnd_file.put_line(fnd_file.output, v_trail1);
4358: fnd_file.put_line(fnd_file.output, v_trail2);
4359: fnd_file.put_line(fnd_file.output, v_trail3);
4360: fnd_file.put_line(fnd_file.output, v_trail4);
4361: fnd_file.put_line(fnd_file.output, v_trail5);
4362: --
4363: error_count := error_count+1;
4364: --

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

4357: fnd_file.put_line(fnd_file.output, v_trail1);
4358: fnd_file.put_line(fnd_file.output, v_trail2);
4359: fnd_file.put_line(fnd_file.output, v_trail3);
4360: fnd_file.put_line(fnd_file.output, v_trail4);
4361: fnd_file.put_line(fnd_file.output, v_trail5);
4362: --
4363: error_count := error_count+1;
4364: --
4365: ROLLBACK;

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

4383: rlm_core_sv.dlog(C_SDEBUG, 'v_msg_count', v_msg_count);
4384: rlm_core_sv.dlog(C_SDEBUG, 'Main v_msg_data', v_msg_data);
4385: END IF;
4386: --
4387: fnd_file.put_line(fnd_file.log, 'Process Order Error: '
4388: ||v_msg_data);
4389: fnd_file.put_line(fnd_file.log, ' ');
4390: --
4391: IF v_msg_count > 0 THEN --{

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

4385: END IF;
4386: --
4387: fnd_file.put_line(fnd_file.log, 'Process Order Error: '
4388: ||v_msg_data);
4389: fnd_file.put_line(fnd_file.log, ' ');
4390: --
4391: IF v_msg_count > 0 THEN --{
4392: --
4393: FOR k in 1 .. v_msg_count LOOP --{

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

4394: --
4395: v_msg_data := oe_msg_pub.get( p_msg_index => k,
4396: p_encoded=> 'F');
4397: --
4398: fnd_file.put_line(fnd_file.log, v_msg_data);
4399: --
4400: IF (l_debug <> -1) THEN
4401: rlm_core_sv.dlog(C_SDEBUG, 'v_msg_data',
4402: v_msg_data);

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

4410: rlm_core_sv.dpop(C_SDEBUG,
4411: 'Process Order Error. Rollback');
4412: END IF;
4413: --
4414: fnd_file.put_line(fnd_file.log, 'Process Order Error: '
4415: || v_msg_data);
4416: fnd_file.put_line(fnd_file.log, ' ');
4417: --
4418: rlm_message_sv.get_msg_text(

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

4412: END IF;
4413: --
4414: fnd_file.put_line(fnd_file.log, 'Process Order Error: '
4415: || v_msg_data);
4416: fnd_file.put_line(fnd_file.log, ' ');
4417: --
4418: rlm_message_sv.get_msg_text(
4419: x_message_name => 'RLM_CUM_RESET_TRAIL5',
4420: x_text => v_trail5);

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

4418: rlm_message_sv.get_msg_text(
4419: x_message_name => 'RLM_CUM_RESET_TRAIL5',
4420: x_text => v_trail5);
4421: --
4422: fnd_file.put_line(fnd_file.output, v_trail1);
4423: fnd_file.put_line(fnd_file.output, v_trail2);
4424: fnd_file.put_line(fnd_file.output, v_trail3);
4425: fnd_file.put_line(fnd_file.output, v_trail4);
4426: fnd_file.put_line(fnd_file.output, v_trail5);

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

4419: x_message_name => 'RLM_CUM_RESET_TRAIL5',
4420: x_text => v_trail5);
4421: --
4422: fnd_file.put_line(fnd_file.output, v_trail1);
4423: fnd_file.put_line(fnd_file.output, v_trail2);
4424: fnd_file.put_line(fnd_file.output, v_trail3);
4425: fnd_file.put_line(fnd_file.output, v_trail4);
4426: fnd_file.put_line(fnd_file.output, v_trail5);
4427: --

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

4420: x_text => v_trail5);
4421: --
4422: fnd_file.put_line(fnd_file.output, v_trail1);
4423: fnd_file.put_line(fnd_file.output, v_trail2);
4424: fnd_file.put_line(fnd_file.output, v_trail3);
4425: fnd_file.put_line(fnd_file.output, v_trail4);
4426: fnd_file.put_line(fnd_file.output, v_trail5);
4427: --
4428: error_count := error_count+1;

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

4421: --
4422: fnd_file.put_line(fnd_file.output, v_trail1);
4423: fnd_file.put_line(fnd_file.output, v_trail2);
4424: fnd_file.put_line(fnd_file.output, v_trail3);
4425: fnd_file.put_line(fnd_file.output, v_trail4);
4426: fnd_file.put_line(fnd_file.output, v_trail5);
4427: --
4428: error_count := error_count+1;
4429: --

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

4422: fnd_file.put_line(fnd_file.output, v_trail1);
4423: fnd_file.put_line(fnd_file.output, v_trail2);
4424: fnd_file.put_line(fnd_file.output, v_trail3);
4425: fnd_file.put_line(fnd_file.output, v_trail4);
4426: fnd_file.put_line(fnd_file.output, v_trail5);
4427: --
4428: error_count := error_count+1;
4429: --
4430: ROLLBACK;

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

4441: IF (l_debug <> -1) THEN
4442: rlm_core_sv.dlog(C_DEBUG, v_msg_data);
4443: END IF;
4444: --
4445: fnd_file.put_line(fnd_file.log, v_msg_data);
4446: --
4447: END IF; -- cum_control_code }
4448: --}
4449: ELSE --{

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

4453: IF (l_debug <> -1) THEN
4454: rlm_core_sv.dlog(C_DEBUG, v_msg_data);
4455: END IF;
4456: --
4457: fnd_file.put_line(fnd_file.log, v_msg_data);
4458: --
4459: END IF; -- setup_terms_status }
4460: --
4461: v_msg_data := 'Number of lines eligible for adjustment: ';

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

4463: IF (l_debug <> -1) THEN
4464: rlm_core_sv.dlog(C_DEBUG, v_msg_data, counter -1);
4465: END IF;
4466: --
4467: --fnd_file.put_line(fnd_file.log, v_msg_data ||counter2);
4468: --
4469: IF error_count > 0 THEN --{
4470: --
4471: v_msg_data := 'Completed with errors';

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

4473: IF (l_debug <> -1) THEN
4474: rlm_core_sv.dpop(C_DEBUG, v_msg_data);
4475: END IF;
4476: --
4477: fnd_file.put_line(fnd_file.log, v_msg_data);
4478: -- }
4479: ELSE
4480: -- {
4481: IF (l_debug <> -1) THEN

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

4519: IF (l_debug <> -1) THEN
4520: rlm_core_sv.dpop(C_DEBUG, v_msg_data);
4521: END IF;
4522: --
4523: fnd_file.put_line(fnd_file.log, v_msg_data);
4524: --
4525: END IF;--} if error_count = 0
4526: --
4527: EXCEPTION

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

4595: COMMIT;
4596: --
4597: v_msg_data := 'There are no qualifying shipments.';
4598: --
4599: fnd_file.put_line(fnd_file.log,v_msg_data);
4600: --
4601: IF (l_debug <> -1) THEN
4602: rlm_core_sv.dpop(C_SDEBUG,'ResetCum:e_NoCum');
4603: END IF;

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

4606: --
4607: v_msg_data := 'There are no qualifying shipments. Manual adjustments'
4608: ||' would be processed';
4609: --
4610: fnd_file.put_line(fnd_file.log,v_msg_data);
4611: --
4612: BEGIN
4613: --
4614: IF (l_debug <> -1) THEN

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

4642: ROLLBACK;
4643: --
4644: END IF;
4645: --
4646: fnd_file.put_line(fnd_file.log,v_msg_data);
4647: --
4648: ELSE
4649: --
4650: v_msg_data := 'Completed successfully';

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

4648: ELSE
4649: --
4650: v_msg_data := 'Completed successfully';
4651: --
4652: fnd_file.put_line(fnd_file.log,v_msg_data);
4653: --
4654: END IF;
4655: --
4656: COMMIT;

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

4661: IF (l_debug <> -1) THEN
4662: rlm_core_sv.dlog(C_DEBUG, 'when others::',substr(SQLERRM,1,200));
4663: END IF;
4664: --
4665: fnd_file.put_line(fnd_file.log, substr(SQLERRM,1,200));
4666: --
4667: x_return_status := FALSE;
4668: END;
4669: --

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

4676: IF (l_debug <> -1) THEN
4677: rlm_core_sv.dpop(C_SDEBUG, substr(SQLERRM,1,200));
4678: END IF;
4679: --
4680: fnd_file.put_line(fnd_file.log, substr(SQLERRM,1,200));
4681: --
4682: x_return_status := FALSE;
4683: --
4684: ROLLBACK;

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

5178: --
5179: IF(v_cum_rec_ctr - v_counter_ctr) <> 1 THEN --{
5180: --
5181: IF x_cum_records.EXISTS(v_cum_rec_ctr-1) THEN
5182: fnd_file.put_line(fnd_file.log,'Could not find '
5183: ||'corresponding CumKey for cum_key_id: ' ||
5184: x_cum_records(v_cum_rec_ctr-1).cum_key_id);
5185: --
5186: IF (l_debug <> -1) THEN

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

6013: IF (l_debug <> -1) THEN
6014: rlm_core_sv.dlog(C_DEBUG,'SetSupplierCum failed');
6015: END IF;
6016: --
6017: fnd_file.put_line(fnd_file.log,'Failed to update Old CUMs, rolling back');
6018: RAISE e_SetSupplierCum;
6019: --
6020: ELSE --{
6021: --

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

6309: rlm_message_sv.get_msg_text(
6310: x_message_name => 'RLM_CUM_PROCESS_ORDER',
6311: x_text => v_msg_data);
6312: --
6313: fnd_file.put_line(fnd_file.log, v_msg_data);
6314: --
6315: -- DEBUGGING
6316: IF (l_debug <> -1) THEN
6317: rlm_core_sv.dlog(C_SDEBUG, 'G_EXC_ERROR');

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

6327: --
6328: v_msg_data := oe_msg_pub.get( p_msg_index => k,
6329: p_encoded => 'F');
6330: --
6331: fnd_file.put_line(fnd_file.log, v_msg_data);
6332: --
6333: IF (l_debug <> -1) THEN
6334: rlm_core_sv.dlog(C_SDEBUG, 'v_msg_data', v_msg_data);
6335: END IF;

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

6358: rlm_message_sv.get_msg_text(
6359: x_message_name => 'RLM_CUM_PROCESS_ORDER',
6360: x_text => v_msg_data);
6361: --
6362: fnd_file.put_line(fnd_file.log, v_msg_data);
6363: --
6364: -- DEBUGGING
6365: IF (l_debug <> -1) THEN
6366: rlm_core_sv.dlog(C_SDEBUG, 'G_EXC_UNEXPECTED_ERROR');

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

6376: --
6377: v_msg_data := oe_msg_pub.get( p_msg_index => k,
6378: p_encoded => 'F');
6379: --
6380: fnd_file.put_line(fnd_file.log, v_msg_data);
6381: --
6382: IF (l_debug <> -1) THEN
6383: rlm_core_sv.dlog(C_SDEBUG, 'v_msg_data', v_msg_data);
6384: END IF;