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 200: INSERT INTO ozf_resale_logs_all(

196:
197: x_return_status := FND_API.G_RET_STS_ERROR;
198: ozf_utility_pvt.error_message('OZF_BATCH_STATUS_WNG');
199: BEGIN
200: INSERT INTO ozf_resale_logs_all(
201: resale_log_id,
202: resale_id,
203: resale_id_type,
204: error_code,

Line 210: ozf_resale_logs_all_s.nextval,

206: column_name,
207: column_value,
208: org_id
209: ) SELECT
210: ozf_resale_logs_all_s.nextval,
211: p_resale_batch_id,
212: 'BATCH',
213: 'OZF_BATCH_STATUS_WNG',
214: FND_MESSAGE.get_string('OZF','OZF_BATCH_STATUS_WNG'),

Line 221: FROM ozf_resale_logs a

217: l_org_id
218: FROM dual
219: WHERE NOT EXISTS (
220: SELECT 1
221: FROM ozf_resale_logs a
222: WHERE a.resale_id = p_resale_batch_id
223: AND a.resale_id_type = 'BATCH'
224: AND a.error_code = 'OZF_BATCH_STATUS_WNG'
225: );

Line 333: INSERT INTO ozf_resale_logs_all(

329:
330: -- Make sure that selling_price is not NULL for direct customers
331: IF p_caller_type = 'IFACE' THEN
332: BEGIN
333: INSERT INTO ozf_resale_logs_all(
334: resale_log_id,
335: resale_id,
336: resale_id_type,
337: error_code,

Line 343: ozf_resale_logs_all_s.nextval,

339: column_name,
340: column_value,
341: org_id
342: ) SELECT
343: ozf_resale_logs_all_s.nextval,
344: resale_line_int_id,
345: 'IFACE',
346: 'OZF_RESALE_SELL_PRICE_NULL',
347: FND_MESSAGE.get_string('OZF','OZF_RESALE_SELL_PRICE_NULL'),

Line 358: FROM ozf_resale_logs_all a

354: AND b.selling_price IS NULL
355: AND b.resale_batch_id = p_resale_batch_id
356: AND NOT EXISTS(
357: SELECT 1
358: FROM ozf_resale_logs_all a
359: WHERE a.resale_id = b.resale_line_int_id
360: AND a.resale_id_type = 'IFACE'
361: AND a.error_code ='OZF_RESALE_SELL_PRICE_NULL'
362: );

Line 385: INSERT INTO ozf_resale_logs_all(

381: END;
382:
383: ELSE
384: BEGIN
385: INSERT INTO ozf_resale_logs_all(
386: resale_log_id,
387: resale_id,
388: resale_id_type,
389: error_code,

Line 395: ozf_resale_logs_all_s.nextval,

391: column_name,
392: column_value,
393: org_id
394: ) SELECT
395: ozf_resale_logs_all_s.nextval,
396: b.resale_line_id,
397: 'LINE',
398: 'OZF_RESALE_SELL_PRICE_NULL',
399: FND_MESSAGE.get_string('OZF','OZF_RESALE_SELL_PRICE_NULL'),

Line 410: FROM ozf_resale_logs_all a

406: AND b.selling_price IS NULL
407: AND b.resale_line_id = c.resale_line_id
408: AND c.resale_batch_id = p_resale_batch_id
409: AND NOT EXISTS(SELECT 1
410: FROM ozf_resale_logs_all a
411: WHERE a.resale_id = b.resale_line_id
412: AND a.resale_id_type = 'LINE'
413: AND a.error_code ='OZF_RESALE_SELL_PRICE_NULL'
414: );

Line 1835: OZF_RESALE_LOGS_PKG.Insert_Row(

1831: FETCH OZF_RESALE_COMMON_PVT.gc_iface_org_id INTO l_org_id;
1832: CLOSE OZF_RESALE_COMMON_PVT.gc_iface_org_id;
1833: END IF;
1834:
1835: OZF_RESALE_LOGS_PKG.Insert_Row(
1836: px_resale_log_id => l_log_id,
1837: p_resale_id => p_line_tbl(i).chargeback_int_id,
1838: p_resale_id_type => l_id_type,
1839: p_error_code => p_line_tbl(i).pricing_status_code,

Line 2196: -- Fux for bug Bug 14584673 : New exception block : This will catch exception for each line and log them into ozf_resale_logs_all table.

2192:
2193: -- For TPA Parallel Execution ER - 9614703 (-)
2194: END IF;
2195: END IF; -- END if current record is a line
2196: -- Fux for bug Bug 14584673 : New exception block : This will catch exception for each line and log them into ozf_resale_logs_all table.
2197: -- Program will not error out and Processing for other records will continue.
2198: EXCEPTION
2199: WHEN OTHERS THEN
2200: l_dispute_code := l_resale_int_rec.dispute_code;

Line 2553: DELETE FROM ozf_resale_logs

2549:
2550: -- ???????? Purge the any error message that might be there. Rethink this
2551: -- OK for now
2552: BEGIN
2553: DELETE FROM ozf_resale_logs
2554: WHERE resale_id = l_order_set_tbl(J).resale_line_id
2555: AND resale_id_type = OZF_RESALE_COMMON_PVT.G_ID_TYPE_LINE;
2556: EXCEPTION
2557: WHEN OTHERS THEN

Line 2848: OZF_RESALE_LOGS_PKG.Insert_Row(

2844: OPEN OZF_RESALE_COMMON_PVT.gc_line_org_id(l_order_set_tbl(p).resale_line_id);
2845: FETCH OZF_RESALE_COMMON_PVT.gc_line_org_id INTO l_org_id;
2846: CLOSE OZF_RESALE_COMMON_PVT.gc_line_org_id;
2847:
2848: OZF_RESALE_LOGS_PKG.Insert_Row(
2849: px_resale_log_id => l_log_id,
2850: p_resale_id => l_order_set_tbl(p).resale_line_id,
2851: p_resale_id_type => OZF_RESALE_COMMON_PVT.G_ID_TYPE_LINE,
2852: p_error_code => 'OZF_GET_ORDER_PRIC_ERR',

Line 2915: OZF_RESALE_LOGS_PKG.Insert_Row(

2911: OPEN OZF_RESALE_COMMON_PVT.gc_line_org_id(l_order_set_tbl(i).resale_line_id);
2912: FETCH OZF_RESALE_COMMON_PVT.gc_line_org_id INTO l_org_id;
2913: CLOSE OZF_RESALE_COMMON_PVT.gc_line_org_id;
2914:
2915: OZF_RESALE_LOGS_PKG.Insert_Row(
2916: px_resale_log_id => l_log_id,
2917: p_resale_id => l_order_set_tbl(i).resale_line_id,
2918: p_resale_id_type => OZF_RESALE_COMMON_PVT.G_ID_TYPE_LINE,
2919: p_error_code => 'OZF_PROC_PRIC_RESLT_ERR',

Line 3348: DELETE FROM ozf_resale_logs_all a

3344: END LOOP;
3345: CLOSE interface_rec_csr;
3346:
3347: -- DELETE the error log before INSERT the orders
3348: DELETE FROM ozf_resale_logs_all a
3349: WHERE a.resale_id_type = 'IFACE'
3350: AND a.resale_id IN (
3351: SELECT resale_line_int_id
3352: FROM ozf_resale_lines_int_all b

Line 3596: , ozf_resale_logs_all lg

3592: , lg.error_message
3593: , lg.column_name
3594: , lg.column_value
3595: FROM ozf_resale_lines_int_all i
3596: , ozf_resale_logs_all lg
3597: , ozf_lookups lk
3598: WHERE i.dispute_code = lk.lookup_code(+)
3599: AND lk.lookup_type(+) = 'OZF_RESALE_DISPUTE_CODE'
3600: AND i.status_code = 'DISPUTED'

Line 3611: , ozf_resale_logs_all lg

3607: SELECT i.resale_line_int_id id
3608: , DECODE(lg.column_value,'-1', 'RESALE_LINE_INT_ID', '-2', 'RESALE_LINE_ID') column_name
3609: , i.duplicated_line_id column_value
3610: FROM ozf_resale_lines_int_all i
3611: , ozf_resale_logs_all lg
3612: WHERE i.status_code = 'DUPLICATED'
3613: AND i.resale_batch_id = cv_batch_id
3614: AND i.resale_line_int_id = lg.resale_id
3615: ORDER BY i.resale_line_int_id;

Line 3928: DELETE FROM ozf_resale_logs

3924: FOR j IN l_order_set_tbl.FIRST .. l_order_set_tbl.LAST
3925: LOOP
3926: -- Purge the any error message that might be there.
3927: BEGIN
3928: DELETE FROM ozf_resale_logs
3929: WHERE resale_id = l_order_set_tbl(j).resale_line_int_id
3930: AND resale_id_type = 'IFACE';
3931: EXCEPTION
3932: WHEN OTHERS THEN

Line 4191: OZF_RESALE_LOGS_PKG.Insert_Row(

4187: OPEN OZF_RESALE_COMMON_PVT.gc_iface_org_id(l_order_set_tbl(p).resale_line_int_id);
4188: FETCH OZF_RESALE_COMMON_PVT.gc_iface_org_id INTO l_org_id;
4189: CLOSE OZF_RESALE_COMMON_PVT.gc_iface_org_id;
4190:
4191: OZF_RESALE_LOGS_PKG.Insert_Row(
4192: px_resale_log_id => l_log_id,
4193: p_resale_id => l_order_set_tbl(p).resale_line_int_id,
4194: p_resale_id_type => 'IFACE',
4195: p_error_code => 'OZF_GET_ORDER_PRIC_ERR',

Line 4252: OZF_RESALE_LOGS_PKG.Insert_Row(

4248: OPEN OZF_RESALE_COMMON_PVT.gc_iface_org_id(l_order_set_tbl(p).resale_line_int_id);
4249: FETCH OZF_RESALE_COMMON_PVT.gc_iface_org_id INTO l_org_id;
4250: CLOSE OZF_RESALE_COMMON_PVT.gc_iface_org_id;
4251:
4252: OZF_RESALE_LOGS_PKG.Insert_Row(
4253: px_resale_log_id => l_log_id,
4254: p_resale_id => l_order_set_tbl(p).resale_line_int_id,
4255: p_resale_id_type => 'IFACE',
4256: p_error_code => 'OZF_PRIC_RESULT_ERR',

Line 4801: FROM ozf_resale_logs_all logs, ozf_resale_lines_int_draft_all intDraft -- Fix for Bug 14584673

4797: ,OZF_TP_ACCRUAL_PVT.G_CONC_REQUEST_ID REQUEST_ID
4798: ,fnd_global.prog_appl_id PROGRAM_APPLICATION_ID
4799: ,fnd_global.conc_program_id PROGRAM_ID
4800: ,SYSDATE PROGRAM_UPDATE_DATE
4801: FROM ozf_resale_logs_all logs, ozf_resale_lines_int_draft_all intDraft -- Fix for Bug 14584673
4802: WHERE logs.resale_id = intDraft.resale_line_int_id
4803: AND intDraft.draft_run_id = l_draft_run_id
4804: AND intDraft.org_id = l_org_id; -- nepanda : Fix for bug # 15900683
4805:

Line 4897: DELETE FROM ozf_resale_logs_all

4893: AND request_id IS NULL
4894: AND org_id = l_org_id; -- nepanda : Fix for bug # 15900683
4895: END IF;
4896:
4897: DELETE FROM ozf_resale_logs_all
4898: WHERE resale_id IN (SELECT resale_line_int_id
4899: FROM ozf_resale_lines_int
4900: WHERE request_id = G_CONC_REQUEST_ID
4901: AND org_id = l_org_id ) -- nepanda : Fix for bug # 15900683