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.OZF_TP_ACCRUAL_PVT dependencies on OZF_RESALE_LOGS

Line 175: INSERT INTO ozf_resale_logs_all(

171:
172: x_return_status := FND_API.G_RET_STS_ERROR;
173: ozf_utility_pvt.error_message('OZF_BATCH_STATUS_WNG');
174: BEGIN
175: INSERT INTO ozf_resale_logs_all(
176: resale_log_id,
177: resale_id,
178: resale_id_type,
179: error_code,

Line 185: ozf_resale_logs_all_s.nextval,

181: column_name,
182: column_value,
183: org_id
184: ) SELECT
185: ozf_resale_logs_all_s.nextval,
186: p_resale_batch_id,
187: 'BATCH',
188: 'OZF_BATCH_STATUS_WNG',
189: FND_MESSAGE.get_string('OZF','OZF_BATCH_STATUS_WNG'),

Line 196: FROM ozf_resale_logs a

192: l_org_id
193: FROM dual
194: WHERE NOT EXISTS (
195: SELECT 1
196: FROM ozf_resale_logs a
197: WHERE a.resale_id = p_resale_batch_id
198: AND a.resale_id_type = 'BATCH'
199: AND a.error_code = 'OZF_BATCH_STATUS_WNG'
200: );

Line 308: INSERT INTO ozf_resale_logs_all(

304:
305: -- Make sure that selling_price is not NULL for direct customers
306: IF p_caller_type = 'IFACE' THEN
307: BEGIN
308: INSERT INTO ozf_resale_logs_all(
309: resale_log_id,
310: resale_id,
311: resale_id_type,
312: error_code,

Line 318: ozf_resale_logs_all_s.nextval,

314: column_name,
315: column_value,
316: org_id
317: ) SELECT
318: ozf_resale_logs_all_s.nextval,
319: resale_line_int_id,
320: 'IFACE',
321: 'OZF_RESALE_SELL_PRICE_NULL',
322: FND_MESSAGE.get_string('OZF','OZF_RESALE_SELL_PRICE_NULL'),

Line 333: FROM ozf_resale_logs_all a

329: AND b.selling_price IS NULL
330: AND b.resale_batch_id = p_resale_batch_id
331: AND NOT EXISTS(
332: SELECT 1
333: FROM ozf_resale_logs_all a
334: WHERE a.resale_id = b.resale_line_int_id
335: AND a.resale_id_type = 'IFACE'
336: AND a.error_code ='OZF_RESALE_SELL_PRICE_NULL'
337: );

Line 360: INSERT INTO ozf_resale_logs_all(

356: END;
357:
358: ELSE
359: BEGIN
360: INSERT INTO ozf_resale_logs_all(
361: resale_log_id,
362: resale_id,
363: resale_id_type,
364: error_code,

Line 370: ozf_resale_logs_all_s.nextval,

366: column_name,
367: column_value,
368: org_id
369: ) SELECT
370: ozf_resale_logs_all_s.nextval,
371: b.resale_line_id,
372: 'LINE',
373: 'OZF_RESALE_SELL_PRICE_NULL',
374: FND_MESSAGE.get_string('OZF','OZF_RESALE_SELL_PRICE_NULL'),

Line 385: FROM ozf_resale_logs_all a

381: AND b.selling_price IS NULL
382: AND b.resale_line_id = c.resale_line_id
383: AND c.resale_batch_id = p_resale_batch_id
384: AND NOT EXISTS(SELECT 1
385: FROM ozf_resale_logs_all a
386: WHERE a.resale_id = b.resale_line_id
387: AND a.resale_id_type = 'LINE'
388: AND a.error_code ='OZF_RESALE_SELL_PRICE_NULL'
389: );

Line 1445: OZF_RESALE_LOGS_PKG.Insert_Row(

1441: FETCH OZF_RESALE_COMMON_PVT.gc_iface_org_id INTO l_org_id;
1442: CLOSE OZF_RESALE_COMMON_PVT.gc_iface_org_id;
1443: END IF;
1444:
1445: OZF_RESALE_LOGS_PKG.Insert_Row(
1446: px_resale_log_id => l_log_id,
1447: p_resale_id => p_line_tbl(i).chargeback_int_id,
1448: p_resale_id_type => l_id_type,
1449: p_error_code => p_line_tbl(i).pricing_status_code,

Line 2025: DELETE FROM ozf_resale_logs

2021:
2022: -- ???????? Purge the any error message that might be there. Rethink this
2023: -- OK for now
2024: BEGIN
2025: DELETE FROM ozf_resale_logs
2026: WHERE resale_id = l_order_set_tbl(J).resale_line_id
2027: AND resale_id_type = OZF_RESALE_COMMON_PVT.G_ID_TYPE_LINE;
2028: EXCEPTION
2029: WHEN OTHERS THEN

Line 2259: OZF_RESALE_LOGS_PKG.Insert_Row(

2255: OPEN OZF_RESALE_COMMON_PVT.gc_line_org_id(l_order_set_tbl(p).resale_line_id);
2256: FETCH OZF_RESALE_COMMON_PVT.gc_line_org_id INTO l_org_id;
2257: CLOSE OZF_RESALE_COMMON_PVT.gc_line_org_id;
2258:
2259: OZF_RESALE_LOGS_PKG.Insert_Row(
2260: px_resale_log_id => l_log_id,
2261: p_resale_id => l_order_set_tbl(p).resale_line_id,
2262: p_resale_id_type => OZF_RESALE_COMMON_PVT.G_ID_TYPE_LINE,
2263: p_error_code => 'OZF_GET_ORDER_PRIC_ERR',

Line 2323: OZF_RESALE_LOGS_PKG.Insert_Row(

2319: OPEN OZF_RESALE_COMMON_PVT.gc_line_org_id(l_order_set_tbl(i).resale_line_id);
2320: FETCH OZF_RESALE_COMMON_PVT.gc_line_org_id INTO l_org_id;
2321: CLOSE OZF_RESALE_COMMON_PVT.gc_line_org_id;
2322:
2323: OZF_RESALE_LOGS_PKG.Insert_Row(
2324: px_resale_log_id => l_log_id,
2325: p_resale_id => l_order_set_tbl(i).resale_line_id,
2326: p_resale_id_type => OZF_RESALE_COMMON_PVT.G_ID_TYPE_LINE,
2327: p_error_code => 'OZF_PROC_PRIC_RESLT_ERR',

Line 2714: DELETE FROM ozf_resale_logs_all a

2710: END LOOP;
2711: CLOSE interface_rec_csr;
2712:
2713: -- DELETE the error log before INSERT the orders
2714: DELETE FROM ozf_resale_logs_all a
2715: WHERE a.resale_id_type = 'IFACE'
2716: AND a.resale_id IN (
2717: SELECT resale_line_int_id
2718: FROM ozf_resale_lines_int_all b

Line 2955: , ozf_resale_logs_all lg

2951: , lg.error_message
2952: , lg.column_name
2953: , lg.column_value
2954: FROM ozf_resale_lines_int_all i
2955: , ozf_resale_logs_all lg
2956: , ozf_lookups lk
2957: WHERE i.dispute_code = lk.lookup_code(+)
2958: AND lk.lookup_type(+) = 'OZF_RESALE_DISPUTE_CODE'
2959: AND i.status_code = 'DISPUTED'

Line 3257: DELETE FROM ozf_resale_logs

3253: FOR j IN l_order_set_tbl.FIRST .. l_order_set_tbl.LAST
3254: LOOP
3255: -- Purge the any error message that might be there.
3256: BEGIN
3257: DELETE FROM ozf_resale_logs
3258: WHERE resale_id = l_order_set_tbl(j).resale_line_int_id
3259: AND resale_id_type = 'IFACE';
3260: EXCEPTION
3261: WHEN OTHERS THEN

Line 3520: OZF_RESALE_LOGS_PKG.Insert_Row(

3516: OPEN OZF_RESALE_COMMON_PVT.gc_iface_org_id(l_order_set_tbl(p).resale_line_int_id);
3517: FETCH OZF_RESALE_COMMON_PVT.gc_iface_org_id INTO l_org_id;
3518: CLOSE OZF_RESALE_COMMON_PVT.gc_iface_org_id;
3519:
3520: OZF_RESALE_LOGS_PKG.Insert_Row(
3521: px_resale_log_id => l_log_id,
3522: p_resale_id => l_order_set_tbl(p).resale_line_int_id,
3523: p_resale_id_type => 'IFACE',
3524: p_error_code => 'OZF_GET_ORDER_PRIC_ERR',

Line 3576: OZF_RESALE_LOGS_PKG.Insert_Row(

3572: OPEN OZF_RESALE_COMMON_PVT.gc_iface_org_id(l_order_set_tbl(p).resale_line_int_id);
3573: FETCH OZF_RESALE_COMMON_PVT.gc_iface_org_id INTO l_org_id;
3574: CLOSE OZF_RESALE_COMMON_PVT.gc_iface_org_id;
3575:
3576: OZF_RESALE_LOGS_PKG.Insert_Row(
3577: px_resale_log_id => l_log_id,
3578: p_resale_id => l_order_set_tbl(p).resale_line_int_id,
3579: p_resale_id_type => 'IFACE',
3580: p_error_code => 'OZF_PRIC_RESULT_ERR',

Line 3986: DELETE FROM ozf_resale_logs_all

3982: AND request_id IS NULL
3983: AND org_id = MO_GLOBAL.get_current_org_id();
3984: END IF;
3985:
3986: DELETE FROM ozf_resale_logs_all
3987: WHERE resale_id IN (SELECT resale_line_int_id
3988: FROM ozf_resale_lines_int
3989: WHERE request_id = G_CONC_REQUEST_ID)
3990: AND resale_id_type = 'IFACE';