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 382: OZF_RESALE_COMMON_PVT.Delete_Log(

378: -- R12 MOAC Enhancement (-)
379:
380:
381: -- Delete logs from previous runs
382: OZF_RESALE_COMMON_PVT.Delete_Log(
383: p_api_version => 1.0
384: ,p_init_msg_list => FND_API.G_FALSE
385: ,p_commit => FND_API.G_FALSE
386: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

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

432: END IF;
433: --
434: -- Final Checking of mandatory items
435: IF l_resale_batch_rec.batch_type IS NULL THEN
436: l_resale_batch_rec.batch_type := ozf_resale_common_pvt.G_TRACING;
437: END IF;
438: IF l_resale_batch_rec.status_code IS NULL THEN
439: l_resale_batch_rec.status_code := g_batch_open;
440: END IF;

Line 512: x_batch_status := OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED;

508: EXCEPTION
509: WHEN FND_API.G_EXC_ERROR THEN
510: --ROLLBACK TO resale_pre_process;
511: x_return_status := FND_API.G_RET_STS_ERROR;
512: x_batch_status := OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED;
513: Update ozf_resale_batches
514: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED
515: WHERE resale_batch_id = p_batch_id;
516:

Line 514: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED

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

Line 525: x_batch_status := OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED;

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

Line 527: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED

523: --ROLLBACK TO resale_pre_process;
524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
525: x_batch_status := OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED;
526: Update ozf_resale_batches
527: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED
528: WHERE resale_batch_id = p_batch_id;
529:
530: -- Standard call to get message count and if count=1, get the message
531: FND_MSG_PUB.Count_And_Get (

Line 538: x_batch_status := OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED;

534: p_data => x_msg_data);
535: WHEN OTHERS THEN
536: --ROLLBACK TO resale_pre_process;
537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
538: x_batch_status := OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED;
539: Update ozf_resale_batches
540: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED
541: WHERE resale_batch_id = p_batch_id;
542:

Line 540: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED

536: --ROLLBACK TO resale_pre_process;
537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
538: x_batch_status := OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED;
539: Update ozf_resale_batches
540: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED
541: WHERE resale_batch_id = p_batch_id;
542:
543: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
544: THEN

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

1082: -- -----------------------------------------------------------------
1083: IF px_resale_batch_rec.transaction_type_code IS NULL THEN
1084: -- derive if null based on batch type (will happen when loaded from WebADI)
1085: IF px_resale_batch_rec.batch_type IS NOT NULL THEN
1086: IF px_resale_batch_rec.batch_type = OZF_RESALE_COMMON_PVT.G_CHARGEBACK THEN
1087: l_resale_batch_rec.transaction_type_code := g_req_for_credit;
1088: ELSIF px_resale_batch_rec.batch_type = OZF_RESALE_COMMON_PVT.G_SPECIAL_PRICING THEN
1089: l_resale_batch_rec.transaction_type_code := g_resale;
1090: ELSIF px_resale_batch_rec.batch_type = OZF_RESALE_COMMON_PVT.G_TRACING THEN

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

1084: -- derive if null based on batch type (will happen when loaded from WebADI)
1085: IF px_resale_batch_rec.batch_type IS NOT NULL THEN
1086: IF px_resale_batch_rec.batch_type = OZF_RESALE_COMMON_PVT.G_CHARGEBACK THEN
1087: l_resale_batch_rec.transaction_type_code := g_req_for_credit;
1088: ELSIF px_resale_batch_rec.batch_type = OZF_RESALE_COMMON_PVT.G_SPECIAL_PRICING THEN
1089: l_resale_batch_rec.transaction_type_code := g_resale;
1090: ELSIF px_resale_batch_rec.batch_type = OZF_RESALE_COMMON_PVT.G_TRACING THEN
1091: l_resale_batch_rec.transaction_type_code := g_product_transfer;
1092: END IF;

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

1086: IF px_resale_batch_rec.batch_type = OZF_RESALE_COMMON_PVT.G_CHARGEBACK THEN
1087: l_resale_batch_rec.transaction_type_code := g_req_for_credit;
1088: ELSIF px_resale_batch_rec.batch_type = OZF_RESALE_COMMON_PVT.G_SPECIAL_PRICING THEN
1089: l_resale_batch_rec.transaction_type_code := g_resale;
1090: ELSIF px_resale_batch_rec.batch_type = OZF_RESALE_COMMON_PVT.G_TRACING THEN
1091: l_resale_batch_rec.transaction_type_code := g_product_transfer;
1092: END IF;
1093: END IF;
1094: IF OZF_DEBUG_LOW_ON THEN

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

1099: -- Batch Type Defaulting
1100: -- -----------------------------------------------------------------
1101: IF px_resale_batch_rec.batch_type IS NULL THEN
1102: IF px_resale_batch_rec.transaction_type_code = g_req_for_credit THEN
1103: l_resale_batch_rec.batch_type := OZF_RESALE_COMMON_PVT.G_CHARGEBACK;
1104: ELSIF px_resale_batch_rec.transaction_type_code = g_resale THEN
1105: l_resale_batch_rec.batch_type := OZF_RESALE_COMMON_PVT.G_SPECIAL_PRICING;
1106: ELSIF px_resale_batch_rec.transaction_type_code = g_product_transfer THEN
1107: l_resale_batch_rec.batch_type := OZF_RESALE_COMMON_PVT.G_TRACING;

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

1101: IF px_resale_batch_rec.batch_type IS NULL THEN
1102: IF px_resale_batch_rec.transaction_type_code = g_req_for_credit THEN
1103: l_resale_batch_rec.batch_type := OZF_RESALE_COMMON_PVT.G_CHARGEBACK;
1104: ELSIF px_resale_batch_rec.transaction_type_code = g_resale THEN
1105: l_resale_batch_rec.batch_type := OZF_RESALE_COMMON_PVT.G_SPECIAL_PRICING;
1106: ELSIF px_resale_batch_rec.transaction_type_code = g_product_transfer THEN
1107: l_resale_batch_rec.batch_type := OZF_RESALE_COMMON_PVT.G_TRACING;
1108: END IF;
1109: END IF;

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

1103: l_resale_batch_rec.batch_type := OZF_RESALE_COMMON_PVT.G_CHARGEBACK;
1104: ELSIF px_resale_batch_rec.transaction_type_code = g_resale THEN
1105: l_resale_batch_rec.batch_type := OZF_RESALE_COMMON_PVT.G_SPECIAL_PRICING;
1106: ELSIF px_resale_batch_rec.transaction_type_code = g_product_transfer THEN
1107: l_resale_batch_rec.batch_type := OZF_RESALE_COMMON_PVT.G_TRACING;
1108: END IF;
1109: END IF;
1110: IF OZF_DEBUG_LOW_ON THEN
1111: ozf_utility_pvt.debug_message ( 'transaction_type_code is '|| l_resale_batch_rec.transaction_type_code);

Line 2085: OPEN OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr;

2081: x_return_status := FND_API.G_RET_STS_SUCCESS;
2082:
2083: -- Inventory Tracking Flag
2084:
2085: OPEN OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr;
2086: FETCH OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr INTO g_inventory_tracking_flag;
2087: CLOSE OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr;
2088: IF g_inventory_tracking_flag IS NULL THEN
2089: g_inventory_tracking_flag := 'F';

Line 2086: FETCH OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr INTO g_inventory_tracking_flag;

2082:
2083: -- Inventory Tracking Flag
2084:
2085: OPEN OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr;
2086: FETCH OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr INTO g_inventory_tracking_flag;
2087: CLOSE OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr;
2088: IF g_inventory_tracking_flag IS NULL THEN
2089: g_inventory_tracking_flag := 'F';
2090: END IF;

Line 2087: CLOSE OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr;

2083: -- Inventory Tracking Flag
2084:
2085: OPEN OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr;
2086: FETCH OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr INTO g_inventory_tracking_flag;
2087: CLOSE OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr;
2088: IF g_inventory_tracking_flag IS NULL THEN
2089: g_inventory_tracking_flag := 'F';
2090: END IF;
2091:

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

2109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2110: END IF;
2111:
2112: IF p_line_count > 0 THEN
2113: OPEN OZF_RESALE_COMMON_PVT.g_batch_type_csr(px_line_record.resale_batch_id(1));
2114: FETCH OZF_RESALE_COMMON_PVT.g_batch_type_csr INTO l_batch_type;
2115: CLOSE OZF_RESALE_COMMON_PVT.g_batch_type_csr;
2116:
2117: FOR i IN 1 .. p_line_count

Line 2114: FETCH OZF_RESALE_COMMON_PVT.g_batch_type_csr INTO l_batch_type;

2110: END IF;
2111:
2112: IF p_line_count > 0 THEN
2113: OPEN OZF_RESALE_COMMON_PVT.g_batch_type_csr(px_line_record.resale_batch_id(1));
2114: FETCH OZF_RESALE_COMMON_PVT.g_batch_type_csr INTO l_batch_type;
2115: CLOSE OZF_RESALE_COMMON_PVT.g_batch_type_csr;
2116:
2117: FOR i IN 1 .. p_line_count
2118: LOOP

Line 2115: CLOSE OZF_RESALE_COMMON_PVT.g_batch_type_csr;

2111:
2112: IF p_line_count > 0 THEN
2113: OPEN OZF_RESALE_COMMON_PVT.g_batch_type_csr(px_line_record.resale_batch_id(1));
2114: FETCH OZF_RESALE_COMMON_PVT.g_batch_type_csr INTO l_batch_type;
2115: CLOSE OZF_RESALE_COMMON_PVT.g_batch_type_csr;
2116:
2117: FOR i IN 1 .. p_line_count
2118: LOOP
2119:

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

2213: IF OZF_DEBUG_LOW_ON THEN
2214: ozf_utility_pvt.debug_message('order_category' || px_line_record.order_category(i));
2215: END IF;
2216:
2217: OPEN OZF_RESALE_COMMON_PVT.g_batch_type_csr(px_line_record.resale_batch_id(i));
2218: FETCH OZF_RESALE_COMMON_PVT.g_batch_type_csr INTO l_batch_type;
2219: CLOSE OZF_RESALE_COMMON_PVT.g_batch_type_csr;
2220:
2221: IF l_batch_type = 'TP_ACCRUAL' THEN

Line 2218: FETCH OZF_RESALE_COMMON_PVT.g_batch_type_csr INTO l_batch_type;

2214: ozf_utility_pvt.debug_message('order_category' || px_line_record.order_category(i));
2215: END IF;
2216:
2217: OPEN OZF_RESALE_COMMON_PVT.g_batch_type_csr(px_line_record.resale_batch_id(i));
2218: FETCH OZF_RESALE_COMMON_PVT.g_batch_type_csr INTO l_batch_type;
2219: CLOSE OZF_RESALE_COMMON_PVT.g_batch_type_csr;
2220:
2221: IF l_batch_type = 'TP_ACCRUAL' THEN
2222: 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 2219: CLOSE OZF_RESALE_COMMON_PVT.g_batch_type_csr;

2215: END IF;
2216:
2217: OPEN OZF_RESALE_COMMON_PVT.g_batch_type_csr(px_line_record.resale_batch_id(i));
2218: FETCH OZF_RESALE_COMMON_PVT.g_batch_type_csr INTO l_batch_type;
2219: CLOSE OZF_RESALE_COMMON_PVT.g_batch_type_csr;
2220:
2221: IF l_batch_type = 'TP_ACCRUAL' THEN
2222: 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
2223: px_line_record.price_list_id(i) := FND_PROFILE.value('OZF_TP_ACCRUAL_PRICE_LIST');

Line 2778: OPEN OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;

2774: IF px_line_record.purchase_price(i) IS NOT NULL THEN
2775: IF l_functional_currency <> px_line_record.currency_code(i) THEN
2776: IF px_line_record.exchange_rate(i) IS NULL THEN
2777: IF px_line_record.exchange_rate_type(i) IS NULL THEN
2778: OPEN OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
2779: FETCH OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr INTO px_line_record.exchange_rate_type(i);
2780: CLOSE OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
2781: END IF;
2782: OZF_UTILITY_PVT.Convert_Currency(

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

2775: IF l_functional_currency <> px_line_record.currency_code(i) THEN
2776: IF px_line_record.exchange_rate(i) IS NULL THEN
2777: IF px_line_record.exchange_rate_type(i) IS NULL THEN
2778: OPEN OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
2779: FETCH OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr INTO px_line_record.exchange_rate_type(i);
2780: CLOSE OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
2781: END IF;
2782: OZF_UTILITY_PVT.Convert_Currency(
2783: p_from_currency => px_line_record.currency_code(i)

Line 2780: CLOSE OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;

2776: IF px_line_record.exchange_rate(i) IS NULL THEN
2777: IF px_line_record.exchange_rate_type(i) IS NULL THEN
2778: OPEN OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
2779: FETCH OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr INTO px_line_record.exchange_rate_type(i);
2780: CLOSE OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
2781: END IF;
2782: OZF_UTILITY_PVT.Convert_Currency(
2783: p_from_currency => px_line_record.currency_code(i)
2784: ,p_to_currency => l_functional_currency

Line 4176: OPEN OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;

4172: ELSE
4173: IF l_converted_currency <> px_currency_tbl(i) THEN
4174: IF px_exchange_rate_tbl(i) IS NULL THEN
4175: IF px_rate_type_tbl(i) IS NULL THEN
4176: OPEN OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
4177: FETCH OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr INTO px_rate_type_tbl(i);
4178: CLOSE OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
4179: END IF;
4180:

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

4173: IF l_converted_currency <> px_currency_tbl(i) THEN
4174: IF px_exchange_rate_tbl(i) IS NULL THEN
4175: IF px_rate_type_tbl(i) IS NULL THEN
4176: OPEN OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
4177: FETCH OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr INTO px_rate_type_tbl(i);
4178: CLOSE OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
4179: END IF;
4180:
4181: IF OZF_DEBUG_LOW_ON THEN

Line 4178: CLOSE OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;

4174: IF px_exchange_rate_tbl(i) IS NULL THEN
4175: IF px_rate_type_tbl(i) IS NULL THEN
4176: OPEN OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
4177: FETCH OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr INTO px_rate_type_tbl(i);
4178: CLOSE OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
4179: END IF;
4180:
4181: IF OZF_DEBUG_LOW_ON THEN
4182: ozf_utility_pvt.debug_message('Exchange Rate Type ('|| i ||') '|| px_rate_type_tbl(i));

Line 4254: OPEN OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;

4250: IF px_internal_price_tbl.exists(i) AND px_internal_price_tbl(i) IS NOT NULL THEN
4251: IF l_functional_currency <> px_currency_tbl(i) THEN
4252: IF px_exchange_rate_tbl(i) IS NULL THEN
4253: IF px_rate_type_tbl(i) IS NULL THEN
4254: OPEN OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
4255: FETCH OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr INTO px_rate_type_tbl(i);
4256: CLOSE OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
4257: END IF;
4258: OZF_UTILITY_PVT.Convert_Currency(

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

4251: IF l_functional_currency <> px_currency_tbl(i) THEN
4252: IF px_exchange_rate_tbl(i) IS NULL THEN
4253: IF px_rate_type_tbl(i) IS NULL THEN
4254: OPEN OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
4255: FETCH OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr INTO px_rate_type_tbl(i);
4256: CLOSE OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
4257: END IF;
4258: OZF_UTILITY_PVT.Convert_Currency(
4259: p_from_currency => px_currency_tbl(i)

Line 4256: CLOSE OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;

4252: IF px_exchange_rate_tbl(i) IS NULL THEN
4253: IF px_rate_type_tbl(i) IS NULL THEN
4254: OPEN OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
4255: FETCH OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr INTO px_rate_type_tbl(i);
4256: CLOSE OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
4257: END IF;
4258: OZF_UTILITY_PVT.Convert_Currency(
4259: p_from_currency => px_currency_tbl(i)
4260: ,p_to_currency => l_functional_currency

Line 8645: OPEN OZF_RESALE_COMMON_PVT.gc_batch_org_id(p_id_value);

8641: SELECT ozf_resale_logs_all_s.nextval into l_log_id from dual;
8642:
8643: -- julou bug 6317120. get org_id from table
8644: IF p_id_type = 'BATCH' THEN
8645: OPEN OZF_RESALE_COMMON_PVT.gc_batch_org_id(p_id_value);
8646: FETCH OZF_RESALE_COMMON_PVT.gc_batch_org_id INTO l_org_id;
8647: CLOSE OZF_RESALE_COMMON_PVT.gc_batch_org_id;
8648: ELSIF p_id_type = 'LINE' THEN
8649: OPEN OZF_RESALE_COMMON_PVT.gc_line_org_id(p_id_value);

Line 8646: FETCH OZF_RESALE_COMMON_PVT.gc_batch_org_id INTO l_org_id;

8642:
8643: -- julou bug 6317120. get org_id from table
8644: IF p_id_type = 'BATCH' THEN
8645: OPEN OZF_RESALE_COMMON_PVT.gc_batch_org_id(p_id_value);
8646: FETCH OZF_RESALE_COMMON_PVT.gc_batch_org_id INTO l_org_id;
8647: CLOSE OZF_RESALE_COMMON_PVT.gc_batch_org_id;
8648: ELSIF p_id_type = 'LINE' THEN
8649: OPEN OZF_RESALE_COMMON_PVT.gc_line_org_id(p_id_value);
8650: FETCH OZF_RESALE_COMMON_PVT.gc_line_org_id INTO l_org_id;

Line 8647: CLOSE OZF_RESALE_COMMON_PVT.gc_batch_org_id;

8643: -- julou bug 6317120. get org_id from table
8644: IF p_id_type = 'BATCH' THEN
8645: OPEN OZF_RESALE_COMMON_PVT.gc_batch_org_id(p_id_value);
8646: FETCH OZF_RESALE_COMMON_PVT.gc_batch_org_id INTO l_org_id;
8647: CLOSE OZF_RESALE_COMMON_PVT.gc_batch_org_id;
8648: ELSIF p_id_type = 'LINE' THEN
8649: OPEN OZF_RESALE_COMMON_PVT.gc_line_org_id(p_id_value);
8650: FETCH OZF_RESALE_COMMON_PVT.gc_line_org_id INTO l_org_id;
8651: CLOSE OZF_RESALE_COMMON_PVT.gc_line_org_id;

Line 8649: OPEN OZF_RESALE_COMMON_PVT.gc_line_org_id(p_id_value);

8645: OPEN OZF_RESALE_COMMON_PVT.gc_batch_org_id(p_id_value);
8646: FETCH OZF_RESALE_COMMON_PVT.gc_batch_org_id INTO l_org_id;
8647: CLOSE OZF_RESALE_COMMON_PVT.gc_batch_org_id;
8648: ELSIF p_id_type = 'LINE' THEN
8649: OPEN OZF_RESALE_COMMON_PVT.gc_line_org_id(p_id_value);
8650: FETCH OZF_RESALE_COMMON_PVT.gc_line_org_id INTO l_org_id;
8651: CLOSE OZF_RESALE_COMMON_PVT.gc_line_org_id;
8652: ELSIF p_id_type = 'IFACE' THEN
8653: OPEN OZF_RESALE_COMMON_PVT.gc_iface_org_id(p_id_value);

Line 8650: FETCH OZF_RESALE_COMMON_PVT.gc_line_org_id INTO l_org_id;

8646: FETCH OZF_RESALE_COMMON_PVT.gc_batch_org_id INTO l_org_id;
8647: CLOSE OZF_RESALE_COMMON_PVT.gc_batch_org_id;
8648: ELSIF p_id_type = 'LINE' THEN
8649: OPEN OZF_RESALE_COMMON_PVT.gc_line_org_id(p_id_value);
8650: FETCH OZF_RESALE_COMMON_PVT.gc_line_org_id INTO l_org_id;
8651: CLOSE OZF_RESALE_COMMON_PVT.gc_line_org_id;
8652: ELSIF p_id_type = 'IFACE' THEN
8653: OPEN OZF_RESALE_COMMON_PVT.gc_iface_org_id(p_id_value);
8654: FETCH OZF_RESALE_COMMON_PVT.gc_iface_org_id INTO l_org_id;

Line 8651: CLOSE OZF_RESALE_COMMON_PVT.gc_line_org_id;

8647: CLOSE OZF_RESALE_COMMON_PVT.gc_batch_org_id;
8648: ELSIF p_id_type = 'LINE' THEN
8649: OPEN OZF_RESALE_COMMON_PVT.gc_line_org_id(p_id_value);
8650: FETCH OZF_RESALE_COMMON_PVT.gc_line_org_id INTO l_org_id;
8651: CLOSE OZF_RESALE_COMMON_PVT.gc_line_org_id;
8652: ELSIF p_id_type = 'IFACE' THEN
8653: OPEN OZF_RESALE_COMMON_PVT.gc_iface_org_id(p_id_value);
8654: FETCH OZF_RESALE_COMMON_PVT.gc_iface_org_id INTO l_org_id;
8655: CLOSE OZF_RESALE_COMMON_PVT.gc_iface_org_id;

Line 8653: OPEN OZF_RESALE_COMMON_PVT.gc_iface_org_id(p_id_value);

8649: OPEN OZF_RESALE_COMMON_PVT.gc_line_org_id(p_id_value);
8650: FETCH OZF_RESALE_COMMON_PVT.gc_line_org_id INTO l_org_id;
8651: CLOSE OZF_RESALE_COMMON_PVT.gc_line_org_id;
8652: ELSIF p_id_type = 'IFACE' THEN
8653: OPEN OZF_RESALE_COMMON_PVT.gc_iface_org_id(p_id_value);
8654: FETCH OZF_RESALE_COMMON_PVT.gc_iface_org_id INTO l_org_id;
8655: CLOSE OZF_RESALE_COMMON_PVT.gc_iface_org_id;
8656: END IF;
8657:

Line 8654: FETCH OZF_RESALE_COMMON_PVT.gc_iface_org_id INTO l_org_id;

8650: FETCH OZF_RESALE_COMMON_PVT.gc_line_org_id INTO l_org_id;
8651: CLOSE OZF_RESALE_COMMON_PVT.gc_line_org_id;
8652: ELSIF p_id_type = 'IFACE' THEN
8653: OPEN OZF_RESALE_COMMON_PVT.gc_iface_org_id(p_id_value);
8654: FETCH OZF_RESALE_COMMON_PVT.gc_iface_org_id INTO l_org_id;
8655: CLOSE OZF_RESALE_COMMON_PVT.gc_iface_org_id;
8656: END IF;
8657:
8658: OZF_RESALE_LOGS_PKG.Insert_Row(

Line 8655: CLOSE OZF_RESALE_COMMON_PVT.gc_iface_org_id;

8651: CLOSE OZF_RESALE_COMMON_PVT.gc_line_org_id;
8652: ELSIF p_id_type = 'IFACE' THEN
8653: OPEN OZF_RESALE_COMMON_PVT.gc_iface_org_id(p_id_value);
8654: FETCH OZF_RESALE_COMMON_PVT.gc_iface_org_id INTO l_org_id;
8655: CLOSE OZF_RESALE_COMMON_PVT.gc_iface_org_id;
8656: END IF;
8657:
8658: OZF_RESALE_LOGS_PKG.Insert_Row(
8659: px_resale_log_id => l_log_id,

Line 8666: --px_org_id => OZF_RESALE_COMMON_PVT.g_org_id

8662: p_error_code => p_error_code,
8663: p_error_message => fnd_message.get_string('OZF',p_error_code),
8664: p_column_name => p_column_name,
8665: p_column_value => p_column_value,
8666: --px_org_id => OZF_RESALE_COMMON_PVT.g_org_id
8667: px_org_id => l_org_id
8668: );
8669: EXCEPTION
8670: WHEN OTHERS THEN