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_SPECIAL_PRICING_PVT dependencies on OZF_RESALE_COMMON_PVT

Line 87: AND status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN;

83: CURSOR OPEN_line_count_csr (p_id in NUMBER) IS
84: SELECT count(1)
85: From ozf_resale_lines_int
86: WHERE resale_batch_id = p_id
87: AND status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN;
88: l_count NUMBER;
89:
90: TYPE id_type IS RECORD (
91: id NUMBER

Line 96: l_line_int_rec OZF_RESALE_COMMON_PVT.g_interface_rec_csr%rowtype;

92: );
93:
94: TYPE id_tbl_type is TABLE OF id_type INDEX BY binary_integer;
95:
96: l_line_int_rec OZF_RESALE_COMMON_PVT.g_interface_rec_csr%rowtype;
97:
98: CURSOR valid_line_id_csr(p_id in NUMBER,
99: p_order_number in VARCHAR2,
100: p_cust_id in NUMBER,

Line 109: --AND status_code in(OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DUPLICATED, OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED) ;

105: AND order_number = p_order_number
106: AND sold_from_cust_account_id = p_cust_id
107: AND date_ordered = p_date
108: AND status_code = 'PROCESSED';
109: --AND status_code in(OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DUPLICATED, OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED) ;
110:
111: l_valid_line_id_tbl id_tbl_type;
112:
113: i NUMBER;

Line 129: --AND status_code in(OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DUPLICATED, OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED)

125: date_ordered
126: FROM ozf_resale_lines_int
127: WHERE resale_batch_id = p_id
128: AND status_code = 'PROCESSED'
129: --AND status_code in(OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DUPLICATED, OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED)
130: ORDER BY date_ordered;
131:
132: TYPE order_num_tbl_type IS TABLE OF batch_order_num_csr%rowtype INDEX BY binary_integer;
133: l_order_num_tbl order_num_tbl_type;

Line 202: l_dup_header_id_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;

198: AND b.status_code IN ('DUPLICATED', 'PROCESSED')
199: AND b.duplicated_line_id = c.resale_line_id
200: AND c.resale_header_id = a.resale_header_id;
201:
202: l_dup_header_id_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
203:
204: BEGIN
205: -- Standard begin of API savepoint
206: SAVEPOINT INIT_PAYMENT_SPP;

Line 242: IF l_batch_status = OZF_RESALE_COMMON_PVT.G_BATCH_PENDING_PAYMENT THEN

238: l_batch_number,
239: l_last_updated_by;
240: CLOSE batch_info_csr;
241:
242: IF l_batch_status = OZF_RESALE_COMMON_PVT.G_BATCH_PENDING_PAYMENT THEN
243:
244: OPEN OPEN_line_count_csr(p_resale_batch_id);
245: FETCH OPEN_line_count_csr INTO l_count;
246: CLOSE OPEN_line_count_csr;

Line 257: OPEN OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr;

253: -- There is no need to find a fund id for the SPECIAL PRICING REQUEST
254: l_chargeback_fund_id := NULL;
255:
256: -- Check whether there is a need to do inventory_verification
257: OPEN OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr;
258: FETCH OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr INTO l_inventory_tracking;
259: CLOSE OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr;
260:
261: IF l_inventory_tracking = 'T' THEN

Line 258: FETCH OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr INTO l_inventory_tracking;

254: l_chargeback_fund_id := NULL;
255:
256: -- Check whether there is a need to do inventory_verification
257: OPEN OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr;
258: FETCH OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr INTO l_inventory_tracking;
259: CLOSE OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr;
260:
261: IF l_inventory_tracking = 'T' THEN
262: -- Bug 4380203 (+)

Line 259: CLOSE OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr;

255:
256: -- Check whether there is a need to do inventory_verification
257: OPEN OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr;
258: FETCH OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr INTO l_inventory_tracking;
259: CLOSE OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr;
260:
261: IF l_inventory_tracking = 'T' THEN
262: -- Bug 4380203 (+)
263: OZF_SALES_TRANSACTIONS_PVT.Initiate_Inventory_tmp (

Line 302: OZF_RESALE_COMMON_PVT.Update_Duplicates (

298: END IF;
299: /*
300: -- SLKRISHN change to use Update_Duplicates
301: -- Check for Duplicates
302: OZF_RESALE_COMMON_PVT.Update_Duplicates (
303: p_api_version => 1.0,
304: p_init_msg_list => FND_API.G_FALSE,
305: p_commit => FND_API.G_FALSE,
306: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 321: IF l_batch_status = OZF_RESALE_COMMON_PVT.G_BATCH_REJECTED THEN

317: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
319: END IF;
320:
321: IF l_batch_status = OZF_RESALE_COMMON_PVT.G_BATCH_REJECTED THEN
322: IF OZF_DEBUG_LOW_ON THEN
323: OZF_UTILITY_PVT.debug_message('OZF_RESALE_REJECTED');
324: END IF;
325: ELSE

Line 368: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,

364: -- There is something wrong with this order. dispute all the orders
365: -- and move to the next one.
366: -- JXWU move update to common pvt
367: UPDATE ozf_resale_lines_int_all
368: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
369: dispute_code = 'OZF_RESALE_MULTI_HEADER',
370: followup_action_code = 'C',
371: response_type = 'CA',
372: response_code = 'N'

Line 377: AND status_code in (OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DUPLICATED, OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED);

373: WHERE resale_batch_id = p_resale_batch_id
374: AND order_number = l_order_num_tbl(k).order_number
375: AND sold_from_cust_account_id = l_order_num_tbl(k).sold_from_cust_account_id
376: AND date_ordered = l_order_num_tbl(k).date_ordered
377: AND status_code in (OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DUPLICATED, OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED);
378:
379: GOTO END_ORDER_HEADER;
380: ELSE
381: l_create_order_header := false;

Line 418: OPEN OZF_RESALE_COMMON_PVT.g_interface_rec_csr(l_valid_line_id_tbl(j).id);

414: IF OZF_DEBUG_LOW_ON THEN
415: ozf_utility_PVT.debug_message('Current line_int_id:' || l_valid_line_id_tbl(j).id);
416: END IF;
417:
418: OPEN OZF_RESALE_COMMON_PVT.g_interface_rec_csr(l_valid_line_id_tbl(j).id);
419: FETCH OZF_RESALE_COMMON_PVT.g_interface_rec_csr INTO l_line_int_rec;
420: CLOSE OZF_RESALE_COMMON_PVT.g_interface_rec_csr;
421:
422: -- Need to check against inventory

Line 419: FETCH OZF_RESALE_COMMON_PVT.g_interface_rec_csr INTO l_line_int_rec;

415: ozf_utility_PVT.debug_message('Current line_int_id:' || l_valid_line_id_tbl(j).id);
416: END IF;
417:
418: OPEN OZF_RESALE_COMMON_PVT.g_interface_rec_csr(l_valid_line_id_tbl(j).id);
419: FETCH OZF_RESALE_COMMON_PVT.g_interface_rec_csr INTO l_line_int_rec;
420: CLOSE OZF_RESALE_COMMON_PVT.g_interface_rec_csr;
421:
422: -- Need to check against inventory
423: IF l_line_int_rec.status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED AND

Line 420: CLOSE OZF_RESALE_COMMON_PVT.g_interface_rec_csr;

416: END IF;
417:
418: OPEN OZF_RESALE_COMMON_PVT.g_interface_rec_csr(l_valid_line_id_tbl(j).id);
419: FETCH OZF_RESALE_COMMON_PVT.g_interface_rec_csr INTO l_line_int_rec;
420: CLOSE OZF_RESALE_COMMON_PVT.g_interface_rec_csr;
421:
422: -- Need to check against inventory
423: IF l_line_int_rec.status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED AND
424: l_inventory_tracking = 'T' THEN

Line 423: IF l_line_int_rec.status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED AND

419: FETCH OZF_RESALE_COMMON_PVT.g_interface_rec_csr INTO l_line_int_rec;
420: CLOSE OZF_RESALE_COMMON_PVT.g_interface_rec_csr;
421:
422: -- Need to check against inventory
423: IF l_line_int_rec.status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED AND
424: l_inventory_tracking = 'T' THEN
425:
426: -- Check inventory level first
427: OZF_SALES_TRANSACTIONS_PVT.Validate_Inventory_level (

Line 445: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,

441: END IF;
442:
443: -- Here turn this line to disputed and create a disput code for it.
444: UPDATE ozf_resale_lines_int
445: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
446: dispute_code = 'OZF_LT_INVT',
447: followup_action_code = 'C',
448: response_type = 'CA',
449: response_code = 'N'

Line 454: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED

450: WHERE resale_line_int_id = l_line_int_rec.resale_line_int_id;
451:
452: -- SET Batch as disputed
453: UPDATE ozf_resale_batches
454: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED
455: WHERE resale_batch_id = l_line_int_rec.resale_batch_id;
456:
457: goto END_LOOP2;
458: END IF;

Line 468: OZF_RESALE_COMMON_PVT.Insert_resale_header(

464: -- First, check whether there is need to create a header for this order
465: IF j = 1 THEN
466: -- Determin header id
467: IF l_create_order_header THEN
468: OZF_RESALE_COMMON_PVT.Insert_resale_header(
469: p_api_version => 1
470: ,p_init_msg_list => FND_API.G_FALSE
471: ,p_commit => FND_API.G_FALSE
472: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 490: IF l_line_int_rec.status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED THEN

486: -- We should have the l_header_id FROM the order level
487: END IF;
488: END IF;
489:
490: IF l_line_int_rec.status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED THEN
491: IF l_line_int_rec.duplicated_line_id is NULL THEN
492:
493: -- No problem so far. Insert INTO batch_lines table
494: OZF_RESALE_COMMON_PVT.Insert_resale_line(

Line 494: OZF_RESALE_COMMON_PVT.Insert_resale_line(

490: IF l_line_int_rec.status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED THEN
491: IF l_line_int_rec.duplicated_line_id is NULL THEN
492:
493: -- No problem so far. Insert INTO batch_lines table
494: OZF_RESALE_COMMON_PVT.Insert_resale_line(
495: p_api_version => 1
496: ,p_init_msg_list => FND_API.G_FALSE
497: ,p_commit => FND_API.G_FALSE
498: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 513: OZF_RESALE_COMMON_PVT.Create_Sales_Transaction (

509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
510: END IF;
511:
512: -- FOR processed order line, I need to create a transaction FOR it.
513: OZF_RESALE_COMMON_PVT.Create_Sales_Transaction (
514: p_api_version => 1.0
515: ,p_init_msg_list => FND_API.G_FALSE
516: ,p_commit => FND_API.G_FALSE
517: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 555: ELSIF l_line_int_rec.status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DUPLICATED THEN

551: -- Bug 4380203 Fixing (-)
552: ELSE
553: l_line_id := l_line_int_rec.duplicated_line_id;
554: END IF;
555: ELSIF l_line_int_rec.status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DUPLICATED THEN
556: l_line_id := l_line_int_rec.duplicated_line_id;
557: END IF;
558: IF OZF_DEBUG_LOW_ON THEN
559: OZF_UTILITY_PVT.debug_message('line_id is '|| l_line_id);

Line 562: IF l_line_int_rec.status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED OR

558: IF OZF_DEBUG_LOW_ON THEN
559: OZF_UTILITY_PVT.debug_message('line_id is '|| l_line_id);
560: END IF;
561:
562: IF l_line_int_rec.status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED OR
563: l_line_int_rec.status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DUPLICATED THEN
564:
565: -- only create mapping for the lines that are processed or
566: -- duplicated, yet the adjustment is new then

Line 563: l_line_int_rec.status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DUPLICATED THEN

559: OZF_UTILITY_PVT.debug_message('line_id is '|| l_line_id);
560: END IF;
561:
562: IF l_line_int_rec.status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED OR
563: l_line_int_rec.status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DUPLICATED THEN
564:
565: -- only create mapping for the lines that are processed or
566: -- duplicated, yet the adjustment is new then
567: OZF_RESALE_COMMON_PVT.Insert_resale_line_mapping(

Line 567: OZF_RESALE_COMMON_PVT.Insert_resale_line_mapping(

563: l_line_int_rec.status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DUPLICATED THEN
564:
565: -- only create mapping for the lines that are processed or
566: -- duplicated, yet the adjustment is new then
567: OZF_RESALE_COMMON_PVT.Insert_resale_line_mapping(
568: p_api_version => 1
569: ,p_init_msg_list => FND_API.G_FALSE
570: ,p_commit => FND_API.G_FALSE
571: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 585: IF l_line_int_rec.status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED AND

581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
582: END IF;
583: END IF;
584:
585: IF l_line_int_rec.status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED AND
586: l_line_int_rec.tracing_flag = 'F' THEN
587: OZF_RESALE_COMMON_PVT.Create_Utilization(
588: p_api_version => 1.0
589: ,p_init_msg_LIST => FND_API.G_FALSE

Line 587: OZF_RESALE_COMMON_PVT.Create_Utilization(

583: END IF;
584:
585: IF l_line_int_rec.status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED AND
586: l_line_int_rec.tracing_flag = 'F' THEN
587: OZF_RESALE_COMMON_PVT.Create_Utilization(
588: p_api_version => 1.0
589: ,p_init_msg_LIST => FND_API.G_FALSE
590: ,p_commit => FND_API.G_FALSE
591: ,p_validation_level=> FND_API.G_VALID_LEVEL_FULL

Line 645: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_CLOSED

641:
642: -- IF anything is paid, UPDATE batch line status to CLOSEd for each OPEN and duplicated lines.
643: BEGIN
644: UPDATE ozf_resale_lines_int
645: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_CLOSED
646: WHERE resale_batch_id = p_resale_batch_id
647: AND status_code in(OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DUPLICATED, OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED) ;
648:
649: -- UPDATE batch status to CLOSEd -- might change later.

Line 647: AND status_code in(OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DUPLICATED, OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED) ;

643: BEGIN
644: UPDATE ozf_resale_lines_int
645: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_CLOSED
646: WHERE resale_batch_id = p_resale_batch_id
647: AND status_code in(OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DUPLICATED, OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED) ;
648:
649: -- UPDATE batch status to CLOSEd -- might change later.
650: UPDATE ozf_resale_batches
651: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED,

Line 651: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED,

647: AND status_code in(OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DUPLICATED, OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED) ;
648:
649: -- UPDATE batch status to CLOSEd -- might change later.
650: UPDATE ozf_resale_batches
651: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED,
652: paid_amount = l_amount_claimed
653: WHERE resale_batch_id = p_resale_batch_id;
654: EXCEPTION
655: WHEN OTHERS THEN

Line 836: OZF_RESALE_COMMON_PVT.G_ID_TYPE_IFACE,

832: ORG_ID
833: ) SELECT
834: ozf_resale_logs_all_s.nextval,
835: resale_line_int_id,
836: OZF_RESALE_COMMON_PVT.G_ID_TYPE_IFACE,
837: 'OZF_RESALE_PUR_PRICE_MISSING',
838: fnd_message.get_string('OZF','OZF_RESALE_PUR_PRICE_MISSING'),
839: 'PURCHASE_PRICE',
840: NULL,

Line 958: --AND status_code in(OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN, OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DUPLICATED)

954: WHERE order_number = p_order_number
955: AND sold_from_cust_account_id= p_id
956: AND date_ordered = p_date
957: AND status_code = 'OPEN'
958: --AND status_code in(OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN, OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DUPLICATED)
959: AND duplicated_adjustment_id is NULL
960: AND resale_batch_id = p_resale_id
961: AND tracing_flag = 'F';
962:

Line 1095: l_resale_int_rec OZF_RESALE_COMMON_PVT.g_interface_rec_csr%ROWTYPE;

1091: l_dispute_code varchar2(30) := null;
1092: l_status_code varchar2(30);
1093: l_tolerance NUMBER;
1094:
1095: l_resale_int_rec OZF_RESALE_COMMON_PVT.g_interface_rec_csr%ROWTYPE;
1096: l_inventory_level_valid BOOLEAN;
1097:
1098:
1099: BEGIN

Line 1127: OPEN OZF_RESALE_COMMON_PVT.g_interface_rec_csr(l_all_order_set_tbl(i).resale_line_int_id);

1123:
1124: IF l_all_order_set_tbl.exists(1) THEN
1125: For i in 1..l_all_order_set_tbl.LAST LOOP
1126:
1127: OPEN OZF_RESALE_COMMON_PVT.g_interface_rec_csr(l_all_order_set_tbl(i).resale_line_int_id);
1128: FETCH OZF_RESALE_COMMON_PVT.g_interface_rec_csr INTO l_resale_int_rec;
1129: CLOSE OZF_RESALE_COMMON_PVT.g_interface_rec_csr;
1130:
1131: IF OZF_DEBUG_LOW_ON THEN

Line 1128: FETCH OZF_RESALE_COMMON_PVT.g_interface_rec_csr INTO l_resale_int_rec;

1124: IF l_all_order_set_tbl.exists(1) THEN
1125: For i in 1..l_all_order_set_tbl.LAST LOOP
1126:
1127: OPEN OZF_RESALE_COMMON_PVT.g_interface_rec_csr(l_all_order_set_tbl(i).resale_line_int_id);
1128: FETCH OZF_RESALE_COMMON_PVT.g_interface_rec_csr INTO l_resale_int_rec;
1129: CLOSE OZF_RESALE_COMMON_PVT.g_interface_rec_csr;
1130:
1131: IF OZF_DEBUG_LOW_ON THEN
1132: ozf_utility_PVT.debug_message(l_full_name || ' checking int line ' || l_all_order_set_tbl(i).resale_line_int_id);

Line 1129: CLOSE OZF_RESALE_COMMON_PVT.g_interface_rec_csr;

1125: For i in 1..l_all_order_set_tbl.LAST LOOP
1126:
1127: OPEN OZF_RESALE_COMMON_PVT.g_interface_rec_csr(l_all_order_set_tbl(i).resale_line_int_id);
1128: FETCH OZF_RESALE_COMMON_PVT.g_interface_rec_csr INTO l_resale_int_rec;
1129: CLOSE OZF_RESALE_COMMON_PVT.g_interface_rec_csr;
1130:
1131: IF OZF_DEBUG_LOW_ON THEN
1132: ozf_utility_PVT.debug_message(l_full_name || ' checking int line ' || l_all_order_set_tbl(i).resale_line_int_id);
1133: ozf_utility_PVT.debug_message(l_full_name || ' inventory tracking ' || g_inventory_tracking);

Line 1154: OZF_RESALE_COMMON_PVT.Insert_Resale_Log (

1150: IF OZF_DEBUG_LOW_ON THEN
1151: ozf_utility_PVT.debug_message(l_full_name || ' inventory checking not passed!!!');
1152: END IF;
1153:
1154: OZF_RESALE_COMMON_PVT.Insert_Resale_Log (
1155: p_id_value => l_all_order_set_tbl(i).resale_line_int_id,
1156: p_id_type => OZF_RESALE_COMMON_PVT.G_ID_TYPE_IFACE,
1157: p_error_code => 'OZF_RESALE_INV_LEVEL_ERROR',
1158: p_column_name => NULL,

Line 1156: p_id_type => OZF_RESALE_COMMON_PVT.G_ID_TYPE_IFACE,

1152: END IF;
1153:
1154: OZF_RESALE_COMMON_PVT.Insert_Resale_Log (
1155: p_id_value => l_all_order_set_tbl(i).resale_line_int_id,
1156: p_id_type => OZF_RESALE_COMMON_PVT.G_ID_TYPE_IFACE,
1157: p_error_code => 'OZF_RESALE_INV_LEVEL_ERROR',
1158: p_column_name => NULL,
1159: p_column_value => NULL,
1160: x_return_status => l_return_status);

Line 1241: OPEN OZF_RESALE_COMMON_PVT.g_interface_rec_csr(l_order_set_tbl(J).resale_line_int_id);

1237: For J in 1..l_order_set_tbl.LAST LOOP
1238:
1239: -- bug # 6821886 fixed by ateotia (+)
1240: /*-- Bug 4616588 (+)
1241: OPEN OZF_RESALE_COMMON_PVT.g_interface_rec_csr(l_order_set_tbl(J).resale_line_int_id);
1242: FETCH OZF_RESALE_COMMON_PVT.g_interface_rec_csr INTO l_resale_int_rec;
1243: CLOSE OZF_RESALE_COMMON_PVT.g_interface_rec_csr;
1244:
1245: IF g_inventory_tracking = 'T' THEN

Line 1242: FETCH OZF_RESALE_COMMON_PVT.g_interface_rec_csr INTO l_resale_int_rec;

1238:
1239: -- bug # 6821886 fixed by ateotia (+)
1240: /*-- Bug 4616588 (+)
1241: OPEN OZF_RESALE_COMMON_PVT.g_interface_rec_csr(l_order_set_tbl(J).resale_line_int_id);
1242: FETCH OZF_RESALE_COMMON_PVT.g_interface_rec_csr INTO l_resale_int_rec;
1243: CLOSE OZF_RESALE_COMMON_PVT.g_interface_rec_csr;
1244:
1245: IF g_inventory_tracking = 'T' THEN
1246: -- Check inventory level first

Line 1243: CLOSE OZF_RESALE_COMMON_PVT.g_interface_rec_csr;

1239: -- bug # 6821886 fixed by ateotia (+)
1240: /*-- Bug 4616588 (+)
1241: OPEN OZF_RESALE_COMMON_PVT.g_interface_rec_csr(l_order_set_tbl(J).resale_line_int_id);
1242: FETCH OZF_RESALE_COMMON_PVT.g_interface_rec_csr INTO l_resale_int_rec;
1243: CLOSE OZF_RESALE_COMMON_PVT.g_interface_rec_csr;
1244:
1245: IF g_inventory_tracking = 'T' THEN
1246: -- Check inventory level first
1247: OZF_SALES_TRANSACTIONS_PVT.Validate_Inventory_level (

Line 1259: OZF_RESALE_COMMON_PVT.Insert_Resale_Log (

1255: ,x_msg_data => l_msg_data
1256: );
1257:
1258: IF NOT l_inventory_level_valid THEN
1259: OZF_RESALE_COMMON_PVT.Insert_Resale_Log (
1260: p_id_value => l_order_set_tbl(J).resale_line_int_id,
1261: p_id_type => OZF_RESALE_COMMON_PVT.G_ID_TYPE_IFACE,
1262: p_error_code => 'OZF_RESALE_INV_LEVEL_ERROR',
1263: p_column_name => NULL,

Line 1261: p_id_type => OZF_RESALE_COMMON_PVT.G_ID_TYPE_IFACE,

1257:
1258: IF NOT l_inventory_level_valid THEN
1259: OZF_RESALE_COMMON_PVT.Insert_Resale_Log (
1260: p_id_value => l_order_set_tbl(J).resale_line_int_id,
1261: p_id_type => OZF_RESALE_COMMON_PVT.G_ID_TYPE_IFACE,
1262: p_error_code => 'OZF_RESALE_INV_LEVEL_ERROR',
1263: p_column_name => NULL,
1264: p_column_value => NULL,
1265: x_return_status => l_return_status);

Line 1312: OZF_RESALE_COMMON_PVT.Insert_Resale_Log (

1308: END IF;
1309: IF l_header_start_date IS NULL OR
1310: l_request_type_code IS NULL OR
1311: l_header_currency_code is NULL THEN
1312: OZF_RESALE_COMMON_PVT.Insert_Resale_Log (
1313: p_id_value => l_order_set_tbl(J).resale_line_int_id,
1314: p_id_type => OZF_RESALE_COMMON_PVT.G_ID_TYPE_IFACE,
1315: p_error_code => 'OZF_RESALE_AGRM_WNG',
1316: p_column_name => NULL,

Line 1314: p_id_type => OZF_RESALE_COMMON_PVT.G_ID_TYPE_IFACE,

1310: l_request_type_code IS NULL OR
1311: l_header_currency_code is NULL THEN
1312: OZF_RESALE_COMMON_PVT.Insert_Resale_Log (
1313: p_id_value => l_order_set_tbl(J).resale_line_int_id,
1314: p_id_type => OZF_RESALE_COMMON_PVT.G_ID_TYPE_IFACE,
1315: p_error_code => 'OZF_RESALE_AGRM_WNG',
1316: p_column_name => NULL,
1317: p_column_value => NULL,
1318: x_return_status => l_return_status

Line 1328: SET status_code=OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,

1324: END IF;
1325:
1326: BEGIN
1327: UPDATE ozf_resale_lines_int
1328: SET status_code=OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
1329: dispute_code = 'OZF_RESALE_AGRM_WNG',
1330: followup_action_code = 'C',
1331: response_type = 'CA',
1332: response_code = 'N'

Line 1351: OZF_RESALE_COMMON_PVT.Insert_Resale_Log (

1347:
1348: IF l_order_set_tbl(J).date_ordered < l_header_start_date OR
1349: (l_header_end_date is not null AND
1350: l_order_set_tbl(J).date_ordered > l_header_end_date) THEN
1351: OZF_RESALE_COMMON_PVT.Insert_Resale_Log (
1352: p_id_value => l_order_set_tbl(J).resale_line_int_id,
1353: p_id_type => OZF_RESALE_COMMON_PVT.G_ID_TYPE_IFACE,
1354: p_error_code => 'OZF_RESALE_AGRM_RANG_WNG',
1355: p_column_name => NULL,

Line 1353: p_id_type => OZF_RESALE_COMMON_PVT.G_ID_TYPE_IFACE,

1349: (l_header_end_date is not null AND
1350: l_order_set_tbl(J).date_ordered > l_header_end_date) THEN
1351: OZF_RESALE_COMMON_PVT.Insert_Resale_Log (
1352: p_id_value => l_order_set_tbl(J).resale_line_int_id,
1353: p_id_type => OZF_RESALE_COMMON_PVT.G_ID_TYPE_IFACE,
1354: p_error_code => 'OZF_RESALE_AGRM_RANG_WNG',
1355: p_column_name => NULL,
1356: p_column_value => NULL,
1357: x_return_status => l_return_status

Line 1367: SET status_code=OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,

1363: END IF;
1364:
1365: BEGIN
1366: UPDATE ozf_resale_lines_int
1367: SET status_code=OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
1368: dispute_code = 'OZF_RESALE_AGRM_RANG_WNG',
1369: followup_action_code = 'C',
1370: response_type = 'CA',
1371: response_code = 'N'

Line 1388: SET status_code=OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,

1384: END IF;
1385: IF l_order_set_tbl(J).currency_code <> l_header_currency_code THEN
1386: BEGIN
1387: UPDATE ozf_resale_lines_int
1388: SET status_code=OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
1389: dispute_code = 'OZF_RESALE_AGRM_CURRENCY_WNG',
1390: followup_action_code = 'C',
1391: response_type = 'CA',
1392: response_code = 'N'

Line 1427: SET status_code=OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,

1423: NULL;
1424: ELSE
1425: BEGIN
1426: UPDATE ozf_resale_lines_int
1427: SET status_code=OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
1428: dispute_code = 'OZF_RESALE_AGRM_END_CUST_WNG',
1429: followup_action_code = 'C',
1430: response_type = 'CA',
1431: response_code = 'N'

Line 1475: SET status_code=OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,

1471: NULL;
1472: ELSE
1473: BEGIN
1474: UPDATE ozf_resale_lines_int
1475: SET status_code=OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
1476: dispute_code = 'OZF_RESALE_AGRM_RESELL_WNG',
1477: followup_action_code = 'C',
1478: response_type = 'CA',
1479: response_code = 'N'

Line 1493: SET status_code=OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,

1489: END IF;
1490: ELSE
1491: BEGIN
1492: UPDATE ozf_resale_lines_int
1493: SET status_code=OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
1494: dispute_code = 'OZF_RESALE_AGRM_RESELL_WNG',
1495: followup_action_code = 'C',
1496: response_type = 'CA',
1497: response_code = 'N'

Line 1518: SET status_code=OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,

1514: NULL;
1515: ELSE
1516: BEGIN
1517: UPDATE ozf_resale_lines_int
1518: SET status_code=OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
1519: dispute_code = 'OZF_RESALE_AGRM_RESELL_WNG',
1520: followup_action_code = 'C',
1521: response_type = 'CA',
1522: response_code = 'N'

Line 1543: SET status_code=OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,

1539: OZF_UTILITY_PVT.debug_message('In Offer id null' );
1540: END IF;
1541: BEGIN
1542: UPDATE ozf_resale_lines_int
1543: SET status_code=OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
1544: dispute_code = 'OZF_RESALE_AGRM_OFF_NULL',
1545: followup_action_code = 'C',
1546: response_type = 'CA',
1547: response_code = 'N'

Line 1563: SET status_code=OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,

1559: OZF_UTILITY_PVT.debug_message('In Off invoice offer' );
1560: END IF;
1561: BEGIN
1562: UPDATE ozf_resale_lines_int
1563: SET status_code=OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
1564: dispute_code = 'OZF_RESALE_AGRM_OFF_OFF_INV',
1565: followup_action_code = 'C',
1566: response_type = 'CA',
1567: response_code = 'N'

Line 1601: OZF_RESALE_COMMON_PVT.Insert_Resale_Log (

1597: OZF_UTILITY_PVT.debug_message('request line approved max:' || l_request_line_apprv_max_qty );
1598: OZF_UTILITY_PVT.debug_message('request line approved min' || l_request_line_apprv_min_qty );
1599: END IF;
1600: IF l_request_line_id is NULL THEN
1601: OZF_RESALE_COMMON_PVT.Insert_Resale_Log (
1602: p_id_value => l_order_set_tbl(J).resale_line_int_id,
1603: p_id_type => OZF_RESALE_COMMON_PVT.G_ID_TYPE_IFACE,
1604: p_error_code => 'OZF_RESALE_AGRM_PROD_WNG',
1605: p_column_name => 'ITEM_NUMBER',

Line 1603: p_id_type => OZF_RESALE_COMMON_PVT.G_ID_TYPE_IFACE,

1599: END IF;
1600: IF l_request_line_id is NULL THEN
1601: OZF_RESALE_COMMON_PVT.Insert_Resale_Log (
1602: p_id_value => l_order_set_tbl(J).resale_line_int_id,
1603: p_id_type => OZF_RESALE_COMMON_PVT.G_ID_TYPE_IFACE,
1604: p_error_code => 'OZF_RESALE_AGRM_PROD_WNG',
1605: p_column_name => 'ITEM_NUMBER',
1606: p_column_value => l_order_set_tbl(J).item_number,
1607: x_return_status => l_return_status

Line 1617: SET status_code=OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,

1613: END IF;
1614:
1615: BEGIN
1616: UPDATE ozf_resale_lines_int
1617: SET status_code=OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
1618: dispute_code = 'OZF_RESALE_AGRM_LINE_WNG',
1619: followup_action_code = 'C',
1620: response_type = 'CA',
1621: response_code = 'N'

Line 1635: OZF_RESALE_COMMON_PVT.get_available_quantity(

1631:
1632:
1633: /*
1634: -- get current quantity and amount FROM tmp table
1635: OZF_RESALE_COMMON_PVT.get_available_quantity(
1636: p_api_version_number => 1.0,
1637: p_init_msg_list => FND_API.G_FALSE,
1638: p_commit => FND_API.G_FALSE,
1639: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 1686: SET status_code=OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,

1682: NULL, NULL);
1683: IF l_request_line_apprv_max_qty = -99999 THEN
1684: BEGIN
1685: UPDATE ozf_resale_lines_int
1686: SET status_code=OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
1687: dispute_code = 'OZF_SPP_NO_UOM_CONV_MAX',
1688: followup_action_code = 'C',
1689: response_type = 'CA',
1690: response_code = 'N'

Line 1713: SET status_code=OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,

1709: NULL, NULL);
1710: IF l_request_line_apprv_min_qty = -99999 THEN
1711: BEGIN
1712: UPDATE ozf_resale_lines_int
1713: SET status_code=OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
1714: dispute_code = 'OZF_SPP_NO_UOM_CONV_MIN',
1715: followup_action_code = 'C',
1716: response_type = 'CA',
1717: response_code = 'N'

Line 1743: SET status_code=OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,

1739: NULL, NULL);
1740: IF l_current_quantity = -99999 THEN
1741: BEGIN
1742: UPDATE ozf_resale_lines_int
1743: SET status_code=OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
1744: dispute_code = 'OZF_SPP_NO_UOM_CONV_CURR',
1745: followup_action_code = 'C',
1746: response_type = 'CA',
1747: response_code = 'N'

Line 1767: SET status_code=OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,

1763: IF l_request_line_apprv_max_qty is not NULL AND
1764: l_current_quantity + l_used_quantity > l_request_line_apprv_max_qty THEN
1765: BEGIN
1766: UPDATE ozf_resale_lines_int
1767: SET status_code=OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
1768: dispute_code = 'OZF_RESALE_AGRM_QUN_GT_MAX',
1769: followup_action_code = 'C',
1770: response_type = 'CA',
1771: response_code = 'N'

Line 1786: SET status_code=OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,

1782: IF l_request_line_apprv_min_qty is not NULL AND
1783: l_current_quantity + l_used_quantity < l_request_line_apprv_min_qty THEN
1784: BEGIN
1785: UPDATE ozf_resale_lines_int
1786: SET status_code=OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
1787: dispute_code = 'OZF_RESALE_AGRM_QUN_LT_MIN',
1788: followup_action_code = 'C',
1789: response_type = 'CA',
1790: response_code = 'N'

Line 1821: OZF_RESALE_COMMON_PVT.Update_Line_Calculations(

1817:
1818:
1819: -- allowed amount should be based on the request.
1820: -- Update the results of Special Pricing Calculation
1821: OZF_RESALE_COMMON_PVT.Update_Line_Calculations(
1822: p_resale_line_int_rec => l_order_set_tbl(J),
1823: p_unit_price => l_reqeust_line_item_price,
1824: p_line_quantity => l_current_quantity,
1825: p_allowed_amount => l_request_line_apprv_amt,

Line 1905: --status_code in(OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN, OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DUPLICATED)

1901: sold_from_cust_account_id,
1902: date_ordered
1903: FROM ozf_resale_lines_int
1904: WHERE status_code = 'OPEN'
1905: --status_code in(OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN, OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DUPLICATED)
1906: AND duplicated_adjustment_id IS NULL
1907: AND resale_batch_id = p_resale_batch_id
1908: ORDER BY date_ordered;
1909:

Line 1910: l_cust_account_id_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;

1906: AND duplicated_adjustment_id IS NULL
1907: AND resale_batch_id = p_resale_batch_id
1908: ORDER BY date_ordered;
1909:
1910: l_cust_account_id_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
1911: l_order_num_tbl OZF_RESALE_COMMON_PVT.varchar_tbl_type;
1912: l_order_date_tbl OZF_RESALE_COMMON_PVT.date_tbl_type;
1913:
1914: l_report_start_date DATE;

Line 1911: l_order_num_tbl OZF_RESALE_COMMON_PVT.varchar_tbl_type;

1907: AND resale_batch_id = p_resale_batch_id
1908: ORDER BY date_ordered;
1909:
1910: l_cust_account_id_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
1911: l_order_num_tbl OZF_RESALE_COMMON_PVT.varchar_tbl_type;
1912: l_order_date_tbl OZF_RESALE_COMMON_PVT.date_tbl_type;
1913:
1914: l_report_start_date DATE;
1915: l_report_end_date DATE;

Line 1912: l_order_date_tbl OZF_RESALE_COMMON_PVT.date_tbl_type;

1908: ORDER BY date_ordered;
1909:
1910: l_cust_account_id_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
1911: l_order_num_tbl OZF_RESALE_COMMON_PVT.varchar_tbl_type;
1912: l_order_date_tbl OZF_RESALE_COMMON_PVT.date_tbl_type;
1913:
1914: l_report_start_date DATE;
1915: l_report_end_date DATE;
1916:

Line 1944: OZF_RESALE_COMMON_PVT.Delete_Log(

1940: -- Initialize API return status to sucess
1941: x_return_status := FND_API.G_RET_STS_SUCCESS;
1942:
1943: -- Delete the logs for the current batch
1944: OZF_RESALE_COMMON_PVT.Delete_Log(
1945: p_api_version => 1.0
1946: ,p_init_msg_list => FND_API.G_FALSE
1947: ,p_commit => FND_API.G_FALSE
1948: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 1970: OPEN OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr;

1966:
1967:
1968: -- Bug 4616588 (+)
1969: -- Check whether there is a need to do inventory_verification
1970: OPEN OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr;
1971: FETCH OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr INTO g_inventory_tracking;
1972: CLOSE OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr;
1973:
1974: -- populates the temp tables

Line 1971: FETCH OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr INTO g_inventory_tracking;

1967:
1968: -- Bug 4616588 (+)
1969: -- Check whether there is a need to do inventory_verification
1970: OPEN OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr;
1971: FETCH OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr INTO g_inventory_tracking;
1972: CLOSE OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr;
1973:
1974: -- populates the temp tables
1975: IF g_inventory_tracking = 'T' THEN

Line 1972: CLOSE OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr;

1968: -- Bug 4616588 (+)
1969: -- Check whether there is a need to do inventory_verification
1970: OPEN OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr;
1971: FETCH OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr INTO g_inventory_tracking;
1972: CLOSE OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr;
1973:
1974: -- populates the temp tables
1975: IF g_inventory_tracking = 'T' THEN
1976: OZF_SALES_TRANSACTIONS_PVT.Initiate_Inventory_tmp (

Line 2020: set status_code =OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,

2016:
2017: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2018: BEGIN
2019: update ozf_resale_lines_int
2020: set status_code =OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,
2021: dispute_code = 'OZF_PROC_PRIC_RESLT_ERR',
2022: followup_action_code = 'C',
2023: response_type = 'CA',
2024: response_code = 'N'

Line 2025: where status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN

2021: dispute_code = 'OZF_PROC_PRIC_RESLT_ERR',
2022: followup_action_code = 'C',
2023: response_type = 'CA',
2024: response_code = 'N'
2025: where status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN
2026: and order_number = l_order_num_tbl(i)
2027: and sold_from_cust_account_id =l_cust_account_id_tbl(i)
2028: and date_ordered = l_order_date_tbl(i)
2029: and resale_batch_id = p_resale_batch_id;

Line 2044: OZF_RESALE_COMMON_PVT.Update_Batch_Calculations (

2040: END LOOP; -- END LOOP for l_order_num_tbl
2041: END IF;
2042:
2043: -- Update Chargeback header with processing detail
2044: OZF_RESALE_COMMON_PVT.Update_Batch_Calculations (
2045: p_api_version => 1.0
2046: ,p_init_msg_list => FND_API.G_FALSE
2047: ,p_commit => FND_API.G_FALSE
2048: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL