APPS.OZF_TP_ACCRUAL_PVT dependencies on OZF_RESALE_LOGS_ALL

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 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 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 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';