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

Line 368: OZF_RESALE_COMMON_PVT.Delete_Log(

364: -- R12 MOAC Enhancement (-)
365:
366:
367: -- Delete logs from previous runs
368: OZF_RESALE_COMMON_PVT.Delete_Log(
369: p_api_version => 1.0
370: ,p_init_msg_list => FND_API.G_FALSE
371: ,p_commit => FND_API.G_FALSE
372: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 422: l_resale_batch_rec.batch_type := ozf_resale_common_pvt.G_TRACING;

418: END IF;
419: --
420: -- Final Checking of mandatory items
421: IF l_resale_batch_rec.batch_type IS NULL THEN
422: l_resale_batch_rec.batch_type := ozf_resale_common_pvt.G_TRACING;
423: END IF;
424: IF l_resale_batch_rec.status_code IS NULL THEN
425: l_resale_batch_rec.status_code := g_batch_open;
426: END IF;

Line 498: x_batch_status := OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED;

494: EXCEPTION
495: WHEN FND_API.G_EXC_ERROR THEN
496: --ROLLBACK TO resale_pre_process;
497: x_return_status := FND_API.G_RET_STS_ERROR;
498: x_batch_status := OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED;
499: Update ozf_resale_batches
500: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED
501: WHERE resale_batch_id = p_batch_id;
502:

Line 500: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED

496: --ROLLBACK TO resale_pre_process;
497: x_return_status := FND_API.G_RET_STS_ERROR;
498: x_batch_status := OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED;
499: Update ozf_resale_batches
500: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED
501: WHERE resale_batch_id = p_batch_id;
502:
503: -- Standard call to get message count and if count=1, get the message
504: FND_MSG_PUB.Count_And_Get (

Line 511: x_batch_status := OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED;

507: p_data => x_msg_data);
508: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
509: --ROLLBACK TO resale_pre_process;
510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
511: x_batch_status := OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED;
512: Update ozf_resale_batches
513: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED
514: WHERE resale_batch_id = p_batch_id;
515:

Line 513: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED

509: --ROLLBACK TO resale_pre_process;
510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
511: x_batch_status := OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED;
512: Update ozf_resale_batches
513: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED
514: WHERE resale_batch_id = p_batch_id;
515:
516: -- Standard call to get message count and if count=1, get the message
517: FND_MSG_PUB.Count_And_Get (

Line 524: x_batch_status := OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED;

520: p_data => x_msg_data);
521: WHEN OTHERS THEN
522: --ROLLBACK TO resale_pre_process;
523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
524: x_batch_status := OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED;
525: Update ozf_resale_batches
526: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED
527: WHERE resale_batch_id = p_batch_id;
528:

Line 526: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED

522: --ROLLBACK TO resale_pre_process;
523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
524: x_batch_status := OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED;
525: Update ozf_resale_batches
526: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED
527: WHERE resale_batch_id = p_batch_id;
528:
529: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
530: THEN

Line 1067: IF px_resale_batch_rec.batch_type = OZF_RESALE_COMMON_PVT.G_CHARGEBACK THEN

1063: -- -----------------------------------------------------------------
1064: IF px_resale_batch_rec.transaction_type_code IS NULL THEN
1065: -- derive if null based on batch type (will happen when loaded from WebADI)
1066: IF px_resale_batch_rec.batch_type IS NOT NULL THEN
1067: IF px_resale_batch_rec.batch_type = OZF_RESALE_COMMON_PVT.G_CHARGEBACK THEN
1068: l_resale_batch_rec.transaction_type_code := g_req_for_credit;
1069: ELSIF px_resale_batch_rec.batch_type = OZF_RESALE_COMMON_PVT.G_SPECIAL_PRICING THEN
1070: l_resale_batch_rec.transaction_type_code := g_resale;
1071: ELSIF px_resale_batch_rec.batch_type = OZF_RESALE_COMMON_PVT.G_TRACING THEN

Line 1069: ELSIF px_resale_batch_rec.batch_type = OZF_RESALE_COMMON_PVT.G_SPECIAL_PRICING THEN

1065: -- derive if null based on batch type (will happen when loaded from WebADI)
1066: IF px_resale_batch_rec.batch_type IS NOT NULL THEN
1067: IF px_resale_batch_rec.batch_type = OZF_RESALE_COMMON_PVT.G_CHARGEBACK THEN
1068: l_resale_batch_rec.transaction_type_code := g_req_for_credit;
1069: ELSIF px_resale_batch_rec.batch_type = OZF_RESALE_COMMON_PVT.G_SPECIAL_PRICING THEN
1070: l_resale_batch_rec.transaction_type_code := g_resale;
1071: ELSIF px_resale_batch_rec.batch_type = OZF_RESALE_COMMON_PVT.G_TRACING THEN
1072: l_resale_batch_rec.transaction_type_code := g_product_transfer;
1073: END IF;

Line 1071: ELSIF px_resale_batch_rec.batch_type = OZF_RESALE_COMMON_PVT.G_TRACING THEN

1067: IF px_resale_batch_rec.batch_type = OZF_RESALE_COMMON_PVT.G_CHARGEBACK THEN
1068: l_resale_batch_rec.transaction_type_code := g_req_for_credit;
1069: ELSIF px_resale_batch_rec.batch_type = OZF_RESALE_COMMON_PVT.G_SPECIAL_PRICING THEN
1070: l_resale_batch_rec.transaction_type_code := g_resale;
1071: ELSIF px_resale_batch_rec.batch_type = OZF_RESALE_COMMON_PVT.G_TRACING THEN
1072: l_resale_batch_rec.transaction_type_code := g_product_transfer;
1073: END IF;
1074: END IF;
1075: IF OZF_DEBUG_LOW_ON THEN

Line 1084: l_resale_batch_rec.batch_type := OZF_RESALE_COMMON_PVT.G_CHARGEBACK;

1080: -- Batch Type Defaulting
1081: -- -----------------------------------------------------------------
1082: IF px_resale_batch_rec.batch_type IS NULL THEN
1083: IF px_resale_batch_rec.transaction_type_code = g_req_for_credit THEN
1084: l_resale_batch_rec.batch_type := OZF_RESALE_COMMON_PVT.G_CHARGEBACK;
1085: ELSIF px_resale_batch_rec.transaction_type_code = g_resale THEN
1086: l_resale_batch_rec.batch_type := OZF_RESALE_COMMON_PVT.G_SPECIAL_PRICING;
1087: ELSIF px_resale_batch_rec.transaction_type_code = g_product_transfer THEN
1088: l_resale_batch_rec.batch_type := OZF_RESALE_COMMON_PVT.G_TRACING;

Line 1086: l_resale_batch_rec.batch_type := OZF_RESALE_COMMON_PVT.G_SPECIAL_PRICING;

1082: IF px_resale_batch_rec.batch_type IS NULL THEN
1083: IF px_resale_batch_rec.transaction_type_code = g_req_for_credit THEN
1084: l_resale_batch_rec.batch_type := OZF_RESALE_COMMON_PVT.G_CHARGEBACK;
1085: ELSIF px_resale_batch_rec.transaction_type_code = g_resale THEN
1086: l_resale_batch_rec.batch_type := OZF_RESALE_COMMON_PVT.G_SPECIAL_PRICING;
1087: ELSIF px_resale_batch_rec.transaction_type_code = g_product_transfer THEN
1088: l_resale_batch_rec.batch_type := OZF_RESALE_COMMON_PVT.G_TRACING;
1089: END IF;
1090: END IF;

Line 1088: l_resale_batch_rec.batch_type := OZF_RESALE_COMMON_PVT.G_TRACING;

1084: l_resale_batch_rec.batch_type := OZF_RESALE_COMMON_PVT.G_CHARGEBACK;
1085: ELSIF px_resale_batch_rec.transaction_type_code = g_resale THEN
1086: l_resale_batch_rec.batch_type := OZF_RESALE_COMMON_PVT.G_SPECIAL_PRICING;
1087: ELSIF px_resale_batch_rec.transaction_type_code = g_product_transfer THEN
1088: l_resale_batch_rec.batch_type := OZF_RESALE_COMMON_PVT.G_TRACING;
1089: END IF;
1090: END IF;
1091: IF OZF_DEBUG_LOW_ON THEN
1092: ozf_utility_pvt.debug_message ( 'transaction_type_code is '|| l_resale_batch_rec.transaction_type_code);

Line 2026: OPEN OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr;

2022: x_return_status := FND_API.G_RET_STS_SUCCESS;
2023:
2024: -- Inventory Tracking Flag
2025:
2026: OPEN OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr;
2027: FETCH OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr INTO g_inventory_tracking_flag;
2028: CLOSE OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr;
2029: IF g_inventory_tracking_flag IS NULL THEN
2030: g_inventory_tracking_flag := 'F';

Line 2027: FETCH OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr INTO g_inventory_tracking_flag;

2023:
2024: -- Inventory Tracking Flag
2025:
2026: OPEN OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr;
2027: FETCH OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr INTO g_inventory_tracking_flag;
2028: CLOSE OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr;
2029: IF g_inventory_tracking_flag IS NULL THEN
2030: g_inventory_tracking_flag := 'F';
2031: END IF;

Line 2028: CLOSE OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr;

2024: -- Inventory Tracking Flag
2025:
2026: OPEN OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr;
2027: FETCH OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr INTO g_inventory_tracking_flag;
2028: CLOSE OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr;
2029: IF g_inventory_tracking_flag IS NULL THEN
2030: g_inventory_tracking_flag := 'F';
2031: END IF;
2032:

Line 2054: OPEN OZF_RESALE_COMMON_PVT.g_batch_type_csr(px_line_record.resale_batch_id(1));

2050: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2051: END IF;
2052:
2053: IF p_line_count > 0 THEN
2054: OPEN OZF_RESALE_COMMON_PVT.g_batch_type_csr(px_line_record.resale_batch_id(1));
2055: FETCH OZF_RESALE_COMMON_PVT.g_batch_type_csr INTO l_batch_type;
2056: CLOSE OZF_RESALE_COMMON_PVT.g_batch_type_csr;
2057:
2058: FOR i IN 1 .. p_line_count

Line 2055: FETCH OZF_RESALE_COMMON_PVT.g_batch_type_csr INTO l_batch_type;

2051: END IF;
2052:
2053: IF p_line_count > 0 THEN
2054: OPEN OZF_RESALE_COMMON_PVT.g_batch_type_csr(px_line_record.resale_batch_id(1));
2055: FETCH OZF_RESALE_COMMON_PVT.g_batch_type_csr INTO l_batch_type;
2056: CLOSE OZF_RESALE_COMMON_PVT.g_batch_type_csr;
2057:
2058: FOR i IN 1 .. p_line_count
2059: LOOP

Line 2056: CLOSE OZF_RESALE_COMMON_PVT.g_batch_type_csr;

2052:
2053: IF p_line_count > 0 THEN
2054: OPEN OZF_RESALE_COMMON_PVT.g_batch_type_csr(px_line_record.resale_batch_id(1));
2055: FETCH OZF_RESALE_COMMON_PVT.g_batch_type_csr INTO l_batch_type;
2056: CLOSE OZF_RESALE_COMMON_PVT.g_batch_type_csr;
2057:
2058: FOR i IN 1 .. p_line_count
2059: LOOP
2060:

Line 2135: OPEN OZF_RESALE_COMMON_PVT.g_batch_type_csr(px_line_record.resale_batch_id(i));

2131: IF OZF_DEBUG_LOW_ON THEN
2132: ozf_utility_pvt.debug_message('order_category' || px_line_record.order_category(i));
2133: END IF;
2134:
2135: OPEN OZF_RESALE_COMMON_PVT.g_batch_type_csr(px_line_record.resale_batch_id(i));
2136: FETCH OZF_RESALE_COMMON_PVT.g_batch_type_csr INTO l_batch_type;
2137: CLOSE OZF_RESALE_COMMON_PVT.g_batch_type_csr;
2138:
2139: IF l_batch_type = 'TP_ACCRUAL' THEN

Line 2136: FETCH OZF_RESALE_COMMON_PVT.g_batch_type_csr INTO l_batch_type;

2132: ozf_utility_pvt.debug_message('order_category' || px_line_record.order_category(i));
2133: END IF;
2134:
2135: OPEN OZF_RESALE_COMMON_PVT.g_batch_type_csr(px_line_record.resale_batch_id(i));
2136: FETCH OZF_RESALE_COMMON_PVT.g_batch_type_csr INTO l_batch_type;
2137: CLOSE OZF_RESALE_COMMON_PVT.g_batch_type_csr;
2138:
2139: IF l_batch_type = 'TP_ACCRUAL' THEN
2140: IF px_line_record.agreement_type(i) IS NULL AND px_line_record.agreement_id(i) IS NULL AND px_line_record.price_list_id(i) IS NULL THEN

Line 2137: CLOSE OZF_RESALE_COMMON_PVT.g_batch_type_csr;

2133: END IF;
2134:
2135: OPEN OZF_RESALE_COMMON_PVT.g_batch_type_csr(px_line_record.resale_batch_id(i));
2136: FETCH OZF_RESALE_COMMON_PVT.g_batch_type_csr INTO l_batch_type;
2137: CLOSE OZF_RESALE_COMMON_PVT.g_batch_type_csr;
2138:
2139: IF l_batch_type = 'TP_ACCRUAL' THEN
2140: IF px_line_record.agreement_type(i) IS NULL AND px_line_record.agreement_id(i) IS NULL AND px_line_record.price_list_id(i) IS NULL THEN
2141: px_line_record.price_list_id(i) := FND_PROFILE.value('OZF_TP_ACCRUAL_PRICE_LIST');

Line 2643: OPEN OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;

2639: IF px_line_record.purchase_price(i) IS NOT NULL THEN
2640: IF l_functional_currency <> px_line_record.currency_code(i) THEN
2641: IF px_line_record.exchange_rate(i) IS NULL THEN
2642: IF px_line_record.exchange_rate_type(i) IS NULL THEN
2643: OPEN OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
2644: FETCH OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr INTO px_line_record.exchange_rate_type(i);
2645: CLOSE OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
2646: END IF;
2647: OZF_UTILITY_PVT.Convert_Currency(

Line 2644: FETCH OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr INTO px_line_record.exchange_rate_type(i);

2640: IF l_functional_currency <> px_line_record.currency_code(i) THEN
2641: IF px_line_record.exchange_rate(i) IS NULL THEN
2642: IF px_line_record.exchange_rate_type(i) IS NULL THEN
2643: OPEN OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
2644: FETCH OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr INTO px_line_record.exchange_rate_type(i);
2645: CLOSE OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
2646: END IF;
2647: OZF_UTILITY_PVT.Convert_Currency(
2648: p_from_currency => px_line_record.currency_code(i)

Line 2645: CLOSE OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;

2641: IF px_line_record.exchange_rate(i) IS NULL THEN
2642: IF px_line_record.exchange_rate_type(i) IS NULL THEN
2643: OPEN OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
2644: FETCH OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr INTO px_line_record.exchange_rate_type(i);
2645: CLOSE OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
2646: END IF;
2647: OZF_UTILITY_PVT.Convert_Currency(
2648: p_from_currency => px_line_record.currency_code(i)
2649: ,p_to_currency => l_functional_currency

Line 3848: OPEN OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;

3844: ELSE
3845: IF l_converted_currency <> px_currency_tbl(i) THEN
3846: IF px_exchange_rate_tbl(i) IS NULL THEN
3847: IF px_rate_type_tbl(i) IS NULL THEN
3848: OPEN OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
3849: FETCH OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr INTO px_rate_type_tbl(i);
3850: CLOSE OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
3851: END IF;
3852:

Line 3849: FETCH OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr INTO px_rate_type_tbl(i);

3845: IF l_converted_currency <> px_currency_tbl(i) THEN
3846: IF px_exchange_rate_tbl(i) IS NULL THEN
3847: IF px_rate_type_tbl(i) IS NULL THEN
3848: OPEN OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
3849: FETCH OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr INTO px_rate_type_tbl(i);
3850: CLOSE OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
3851: END IF;
3852:
3853: IF OZF_DEBUG_LOW_ON THEN

Line 3850: CLOSE OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;

3846: IF px_exchange_rate_tbl(i) IS NULL THEN
3847: IF px_rate_type_tbl(i) IS NULL THEN
3848: OPEN OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
3849: FETCH OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr INTO px_rate_type_tbl(i);
3850: CLOSE OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
3851: END IF;
3852:
3853: IF OZF_DEBUG_LOW_ON THEN
3854: ozf_utility_pvt.debug_message('Exchange Rate Type ('|| i ||') '|| px_rate_type_tbl(i));

Line 3926: OPEN OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;

3922: IF px_internal_price_tbl.exists(i) AND px_internal_price_tbl(i) IS NOT NULL THEN
3923: IF l_functional_currency <> px_currency_tbl(i) THEN
3924: IF px_exchange_rate_tbl(i) IS NULL THEN
3925: IF px_rate_type_tbl(i) IS NULL THEN
3926: OPEN OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
3927: FETCH OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr INTO px_rate_type_tbl(i);
3928: CLOSE OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
3929: END IF;
3930: OZF_UTILITY_PVT.Convert_Currency(

Line 3927: FETCH OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr INTO px_rate_type_tbl(i);

3923: IF l_functional_currency <> px_currency_tbl(i) THEN
3924: IF px_exchange_rate_tbl(i) IS NULL THEN
3925: IF px_rate_type_tbl(i) IS NULL THEN
3926: OPEN OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
3927: FETCH OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr INTO px_rate_type_tbl(i);
3928: CLOSE OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
3929: END IF;
3930: OZF_UTILITY_PVT.Convert_Currency(
3931: p_from_currency => px_currency_tbl(i)

Line 3928: CLOSE OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;

3924: IF px_exchange_rate_tbl(i) IS NULL THEN
3925: IF px_rate_type_tbl(i) IS NULL THEN
3926: OPEN OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
3927: FETCH OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr INTO px_rate_type_tbl(i);
3928: CLOSE OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
3929: END IF;
3930: OZF_UTILITY_PVT.Convert_Currency(
3931: p_from_currency => px_currency_tbl(i)
3932: ,p_to_currency => l_functional_currency

Line 8134: OPEN OZF_RESALE_COMMON_PVT.gc_batch_org_id(p_id_value);

8130: SELECT ozf_resale_logs_all_s.nextval into l_log_id from dual;
8131:
8132: -- julou bug 6317120. get org_id from table
8133: IF p_id_type = 'BATCH' THEN
8134: OPEN OZF_RESALE_COMMON_PVT.gc_batch_org_id(p_id_value);
8135: FETCH OZF_RESALE_COMMON_PVT.gc_batch_org_id INTO l_org_id;
8136: CLOSE OZF_RESALE_COMMON_PVT.gc_batch_org_id;
8137: ELSIF p_id_type = 'LINE' THEN
8138: OPEN OZF_RESALE_COMMON_PVT.gc_line_org_id(p_id_value);

Line 8135: FETCH OZF_RESALE_COMMON_PVT.gc_batch_org_id INTO l_org_id;

8131:
8132: -- julou bug 6317120. get org_id from table
8133: IF p_id_type = 'BATCH' THEN
8134: OPEN OZF_RESALE_COMMON_PVT.gc_batch_org_id(p_id_value);
8135: FETCH OZF_RESALE_COMMON_PVT.gc_batch_org_id INTO l_org_id;
8136: CLOSE OZF_RESALE_COMMON_PVT.gc_batch_org_id;
8137: ELSIF p_id_type = 'LINE' THEN
8138: OPEN OZF_RESALE_COMMON_PVT.gc_line_org_id(p_id_value);
8139: FETCH OZF_RESALE_COMMON_PVT.gc_line_org_id INTO l_org_id;

Line 8136: CLOSE OZF_RESALE_COMMON_PVT.gc_batch_org_id;

8132: -- julou bug 6317120. get org_id from table
8133: IF p_id_type = 'BATCH' THEN
8134: OPEN OZF_RESALE_COMMON_PVT.gc_batch_org_id(p_id_value);
8135: FETCH OZF_RESALE_COMMON_PVT.gc_batch_org_id INTO l_org_id;
8136: CLOSE OZF_RESALE_COMMON_PVT.gc_batch_org_id;
8137: ELSIF p_id_type = 'LINE' THEN
8138: OPEN OZF_RESALE_COMMON_PVT.gc_line_org_id(p_id_value);
8139: FETCH OZF_RESALE_COMMON_PVT.gc_line_org_id INTO l_org_id;
8140: CLOSE OZF_RESALE_COMMON_PVT.gc_line_org_id;

Line 8138: OPEN OZF_RESALE_COMMON_PVT.gc_line_org_id(p_id_value);

8134: OPEN OZF_RESALE_COMMON_PVT.gc_batch_org_id(p_id_value);
8135: FETCH OZF_RESALE_COMMON_PVT.gc_batch_org_id INTO l_org_id;
8136: CLOSE OZF_RESALE_COMMON_PVT.gc_batch_org_id;
8137: ELSIF p_id_type = 'LINE' THEN
8138: OPEN OZF_RESALE_COMMON_PVT.gc_line_org_id(p_id_value);
8139: FETCH OZF_RESALE_COMMON_PVT.gc_line_org_id INTO l_org_id;
8140: CLOSE OZF_RESALE_COMMON_PVT.gc_line_org_id;
8141: ELSIF p_id_type = 'IFACE' THEN
8142: OPEN OZF_RESALE_COMMON_PVT.gc_iface_org_id(p_id_value);

Line 8139: FETCH OZF_RESALE_COMMON_PVT.gc_line_org_id INTO l_org_id;

8135: FETCH OZF_RESALE_COMMON_PVT.gc_batch_org_id INTO l_org_id;
8136: CLOSE OZF_RESALE_COMMON_PVT.gc_batch_org_id;
8137: ELSIF p_id_type = 'LINE' THEN
8138: OPEN OZF_RESALE_COMMON_PVT.gc_line_org_id(p_id_value);
8139: FETCH OZF_RESALE_COMMON_PVT.gc_line_org_id INTO l_org_id;
8140: CLOSE OZF_RESALE_COMMON_PVT.gc_line_org_id;
8141: ELSIF p_id_type = 'IFACE' THEN
8142: OPEN OZF_RESALE_COMMON_PVT.gc_iface_org_id(p_id_value);
8143: FETCH OZF_RESALE_COMMON_PVT.gc_iface_org_id INTO l_org_id;

Line 8140: CLOSE OZF_RESALE_COMMON_PVT.gc_line_org_id;

8136: CLOSE OZF_RESALE_COMMON_PVT.gc_batch_org_id;
8137: ELSIF p_id_type = 'LINE' THEN
8138: OPEN OZF_RESALE_COMMON_PVT.gc_line_org_id(p_id_value);
8139: FETCH OZF_RESALE_COMMON_PVT.gc_line_org_id INTO l_org_id;
8140: CLOSE OZF_RESALE_COMMON_PVT.gc_line_org_id;
8141: ELSIF p_id_type = 'IFACE' THEN
8142: OPEN OZF_RESALE_COMMON_PVT.gc_iface_org_id(p_id_value);
8143: FETCH OZF_RESALE_COMMON_PVT.gc_iface_org_id INTO l_org_id;
8144: CLOSE OZF_RESALE_COMMON_PVT.gc_iface_org_id;

Line 8142: OPEN OZF_RESALE_COMMON_PVT.gc_iface_org_id(p_id_value);

8138: OPEN OZF_RESALE_COMMON_PVT.gc_line_org_id(p_id_value);
8139: FETCH OZF_RESALE_COMMON_PVT.gc_line_org_id INTO l_org_id;
8140: CLOSE OZF_RESALE_COMMON_PVT.gc_line_org_id;
8141: ELSIF p_id_type = 'IFACE' THEN
8142: OPEN OZF_RESALE_COMMON_PVT.gc_iface_org_id(p_id_value);
8143: FETCH OZF_RESALE_COMMON_PVT.gc_iface_org_id INTO l_org_id;
8144: CLOSE OZF_RESALE_COMMON_PVT.gc_iface_org_id;
8145: END IF;
8146:

Line 8143: FETCH OZF_RESALE_COMMON_PVT.gc_iface_org_id INTO l_org_id;

8139: FETCH OZF_RESALE_COMMON_PVT.gc_line_org_id INTO l_org_id;
8140: CLOSE OZF_RESALE_COMMON_PVT.gc_line_org_id;
8141: ELSIF p_id_type = 'IFACE' THEN
8142: OPEN OZF_RESALE_COMMON_PVT.gc_iface_org_id(p_id_value);
8143: FETCH OZF_RESALE_COMMON_PVT.gc_iface_org_id INTO l_org_id;
8144: CLOSE OZF_RESALE_COMMON_PVT.gc_iface_org_id;
8145: END IF;
8146:
8147: OZF_RESALE_LOGS_PKG.Insert_Row(

Line 8144: CLOSE OZF_RESALE_COMMON_PVT.gc_iface_org_id;

8140: CLOSE OZF_RESALE_COMMON_PVT.gc_line_org_id;
8141: ELSIF p_id_type = 'IFACE' THEN
8142: OPEN OZF_RESALE_COMMON_PVT.gc_iface_org_id(p_id_value);
8143: FETCH OZF_RESALE_COMMON_PVT.gc_iface_org_id INTO l_org_id;
8144: CLOSE OZF_RESALE_COMMON_PVT.gc_iface_org_id;
8145: END IF;
8146:
8147: OZF_RESALE_LOGS_PKG.Insert_Row(
8148: px_resale_log_id => l_log_id,

Line 8155: --px_org_id => OZF_RESALE_COMMON_PVT.g_org_id

8151: p_error_code => p_error_code,
8152: p_error_message => fnd_message.get_string('OZF',p_error_code),
8153: p_column_name => p_column_name,
8154: p_column_value => p_column_value,
8155: --px_org_id => OZF_RESALE_COMMON_PVT.g_org_id
8156: px_org_id => l_org_id
8157: );
8158: EXCEPTION
8159: WHEN OTHERS THEN