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_COMMON_PVT

Line 470: -- p_resale_line_int_rec IN OZF_RESALE_COMMON_PVT.g_interface_rec_csr%rowtype,

466: -- This procedure process the pricing call result for third party accrual.
467: -- It creates resale lines and accruals based on the discount information.
468: --
469: -- PARAMETERS
470: -- p_resale_line_int_rec IN OZF_RESALE_COMMON_PVT.g_interface_rec_csr%rowtype,
471: -- p_resale_line_rec IN OZF_RESALE_LINES_ALL%rowtype,
472: -- p_line_result_rec IN OZF_ORDER_PRICE_PVT.LINE_REC_TYPE,
473: -- p_header_id IN NUMBER,
474: -- p_resale_batch_id IN NUMBER,

Line 492: p_resale_line_int_rec IN OZF_RESALE_COMMON_PVT.g_interface_rec_csr%rowtype,

488:
489:
490:
491: PROCEDURE Process_One_Line(
492: p_resale_line_int_rec IN OZF_RESALE_COMMON_PVT.g_interface_rec_csr%rowtype,
493: p_resale_line_rec IN OZF_RESALE_LINES%rowtype,
494: p_line_result_rec IN OZF_ORDER_PRICE_PVT.LINE_REC_TYPE,
495: p_header_id IN NUMBER,
496: p_resale_batch_id IN NUMBER,

Line 517: l_resale_line_int_rec OZF_RESALE_COMMON_PVT.g_interface_rec_csr%rowtype := p_resale_line_int_rec;

513: l_msg_data VARCHAR2(2000);
514: l_msg_count NUMBER;
515: l_return_status VARCHAR2(30);
516:
517: l_resale_line_int_rec OZF_RESALE_COMMON_PVT.g_interface_rec_csr%rowtype := p_resale_line_int_rec;
518:
519: l_use_fund_staging_tables VARCHAR2(1):= 'T';
520: l_budget_count NUMBER := 0;
521: ozf_funds_old_rectype OZF_UTILITY_PVT.ozf_funds_all_b_rectype;

Line 583: AND b.batch_type = OZF_RESALE_COMMON_PVT.G_CHARGEBACK

579: WHERE a.resale_line_id = p_line_id
580: AND a.resale_batch_id = p_batch_id
581: AND a.line_agreement_flag = 'T'
582: AND a.resale_batch_id = b.resale_batch_id
583: AND b.batch_type = OZF_RESALE_COMMON_PVT.G_CHARGEBACK
584: AND rownum = 1;
585: */
586: l_log_id NUMBER;
587:

Line 665: OZF_RESALE_COMMON_PVT.Insert_resale_line(

661: -- create a resale line record, if it's FROM iface
662: IF p_caller_type = 'IFACE' THEN
663: -- Bug 14194884 - TPA In Draft Mode ER : Skipping creation of resale lines, line mappings and sales transactions in case of DRAFT mode
664: IF p_run_mode <> 'DRAFT' THEN
665: OZF_RESALE_COMMON_PVT.Insert_resale_line(
666: p_api_version => 1
667: ,p_init_msg_list => FND_API.G_FALSE
668: ,p_commit => FND_API.G_FALSE
669: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 682: OZF_RESALE_COMMON_PVT.Insert_Resale_Line_Mapping(

678: ozf_utility_pvt.error_message('OZF_INS_RESALE_LINE_WRG');
679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
680: END IF;
681:
682: OZF_RESALE_COMMON_PVT.Insert_Resale_Line_Mapping(
683: p_api_version => 1
684: ,p_init_msg_list => FND_API.G_FALSE
685: ,p_commit => FND_API.G_FALSE
686: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 699: OZF_RESALE_COMMON_PVT.Create_Sales_Transaction(

695: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
697: END IF;
698:
699: OZF_RESALE_COMMON_PVT.Create_Sales_Transaction(
700: p_api_version => 1
701: ,p_init_msg_list => FND_API.G_FALSE
702: ,p_commit => FND_API.G_FALSE
703: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 909: OPEN OZF_RESALE_COMMON_PVT.g_adjustment_id_csr;

905: END IF;
906: END IF;
907: -- R12 Volumn Offer Enhancement (-)
908:
909: OPEN OZF_RESALE_COMMON_PVT.g_adjustment_id_csr;
910: FETCH OZF_RESALE_COMMON_PVT.g_adjustment_id_csr INTO l_adjustment_rec.resale_adjustment_id;
911: CLOSE OZF_RESALE_COMMON_PVT.g_adjustment_id_csr;
912:
913: l_adjustment_rec.resale_batch_id := p_resale_batch_id;

Line 910: FETCH OZF_RESALE_COMMON_PVT.g_adjustment_id_csr INTO l_adjustment_rec.resale_adjustment_id;

906: END IF;
907: -- R12 Volumn Offer Enhancement (-)
908:
909: OPEN OZF_RESALE_COMMON_PVT.g_adjustment_id_csr;
910: FETCH OZF_RESALE_COMMON_PVT.g_adjustment_id_csr INTO l_adjustment_rec.resale_adjustment_id;
911: CLOSE OZF_RESALE_COMMON_PVT.g_adjustment_id_csr;
912:
913: l_adjustment_rec.resale_batch_id := p_resale_batch_id;
914: l_adjustment_rec.resale_line_id := l_line_id;

Line 911: CLOSE OZF_RESALE_COMMON_PVT.g_adjustment_id_csr;

907: -- R12 Volumn Offer Enhancement (-)
908:
909: OPEN OZF_RESALE_COMMON_PVT.g_adjustment_id_csr;
910: FETCH OZF_RESALE_COMMON_PVT.g_adjustment_id_csr INTO l_adjustment_rec.resale_adjustment_id;
911: CLOSE OZF_RESALE_COMMON_PVT.g_adjustment_id_csr;
912:
913: l_adjustment_rec.resale_batch_id := p_resale_batch_id;
914: l_adjustment_rec.resale_line_id := l_line_id;
915: l_adjustment_rec.list_header_id := l_ldets_tbl(k).list_header_id;

Line 1240: OPEN OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;

1236:
1237: --nirprasa,12.2 remove currency conversion b/w order and offer currency
1238: IF p_line_result_rec.currency_code <> l_act_budgets_rec.request_currency THEN
1239: -- get convert type
1240: OPEN OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
1241: FETCH OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr INTO l_exchange_type;
1242: CLOSE OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
1243:
1244: OZF_UTILITY_PVT.convert_currency(

Line 1241: FETCH OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr INTO l_exchange_type;

1237: --nirprasa,12.2 remove currency conversion b/w order and offer currency
1238: IF p_line_result_rec.currency_code <> l_act_budgets_rec.request_currency THEN
1239: -- get convert type
1240: OPEN OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
1241: FETCH OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr INTO l_exchange_type;
1242: CLOSE OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
1243:
1244: OZF_UTILITY_PVT.convert_currency(
1245: p_from_currency => p_line_result_rec.currency_code

Line 1242: CLOSE OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;

1238: IF p_line_result_rec.currency_code <> l_act_budgets_rec.request_currency THEN
1239: -- get convert type
1240: OPEN OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
1241: FETCH OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr INTO l_exchange_type;
1242: CLOSE OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
1243:
1244: OZF_UTILITY_PVT.convert_currency(
1245: p_from_currency => p_line_result_rec.currency_code
1246: ,p_to_currency => l_act_budgets_rec.request_currency

Line 1273: OPEN OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;

1269: IF l_ldets_tbl(k).list_line_type_code = 'PLL' THEN
1270: l_act_budgets_rec.parent_src_apprvd_amt := l_act_budgets_rec.request_amount;
1271: IF p_line_result_rec.currency_code <> l_act_budgets_rec.parent_src_curr THEN
1272: -- get convert type
1273: OPEN OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
1274: FETCH OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr INTO l_exchange_type;
1275: CLOSE OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
1276:
1277: OZF_UTILITY_PVT.convert_currency(

Line 1274: FETCH OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr INTO l_exchange_type;

1270: l_act_budgets_rec.parent_src_apprvd_amt := l_act_budgets_rec.request_amount;
1271: IF p_line_result_rec.currency_code <> l_act_budgets_rec.parent_src_curr THEN
1272: -- get convert type
1273: OPEN OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
1274: FETCH OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr INTO l_exchange_type;
1275: CLOSE OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
1276:
1277: OZF_UTILITY_PVT.convert_currency(
1278: p_FROM_currency => p_line_result_rec.currency_code

Line 1275: CLOSE OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;

1271: IF p_line_result_rec.currency_code <> l_act_budgets_rec.parent_src_curr THEN
1272: -- get convert type
1273: OPEN OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
1274: FETCH OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr INTO l_exchange_type;
1275: CLOSE OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
1276:
1277: OZF_UTILITY_PVT.convert_currency(
1278: p_FROM_currency => p_line_result_rec.currency_code
1279: ,p_to_currency => l_act_budgets_rec.parent_src_curr

Line 1346: OZF_RESALE_COMMON_PVT.Create_Draft_Utilization(

1342:
1343: -- Bug 14194884 - TPA In Draft Mode ER : Call new procedure to create DRAFT utilizations in case of DRAFT mode.
1344: IF p_run_mode = 'DRAFT' THEN
1345:
1346: OZF_RESALE_COMMON_PVT.Create_Draft_Utilization(
1347: p_api_version => 1
1348: ,p_init_msg_list => FND_API.G_FALSE
1349: ,p_commit => FND_API.G_FALSE
1350: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 1371: OZF_RESALE_COMMON_PVT.Create_Adj_and_Utilization(

1367: END IF;
1368:
1369: ELSE -- IF p_run_mode = 'DRAFT' THEN
1370:
1371: OZF_RESALE_COMMON_PVT.Create_Adj_and_Utilization(
1372: p_api_version => 1
1373: ,p_init_msg_list => FND_API.G_FALSE
1374: ,p_commit => FND_API.G_FALSE
1375: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 1513: p_resale_line_int_rec IN OZF_RESALE_COMMON_PVT.g_interface_rec_csr%rowtype,

1509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1510: END process_one_line;
1511:
1512: PROCEDURE Process_One_Line(
1513: p_resale_line_int_rec IN OZF_RESALE_COMMON_PVT.g_interface_rec_csr%rowtype,
1514: p_resale_line_rec IN OZF_RESALE_LINES%rowtype,
1515: p_line_result_rec IN OZF_ORDER_PRICE_PVT.LINE_REC_TYPE,
1516: p_header_id IN NUMBER,
1517: p_resale_batch_id IN NUMBER,

Line 1552: p_resale_line_int_rec IN OZF_RESALE_COMMON_PVT.g_interface_rec_csr%rowtype,

1548: x_draft_accrual_tbl => l_draft_accrual_tbl
1549: );
1550: END Process_One_Line;
1551: PROCEDURE Process_One_Line(
1552: p_resale_line_int_rec IN OZF_RESALE_COMMON_PVT.g_interface_rec_csr%rowtype,
1553: p_resale_line_rec IN OZF_RESALE_LINES%rowtype,
1554: p_line_result_rec IN OZF_ORDER_PRICE_PVT.LINE_REC_TYPE,
1555: p_header_id IN NUMBER,
1556: p_resale_batch_id IN NUMBER,

Line 1653: l_resale_int_rec OZF_RESALE_COMMON_PVT.g_interface_rec_csr%rowtype;

1649: SELECT *
1650: FROM ozf_resale_lines
1651: WHERE resale_line_id = p_id;
1652:
1653: l_resale_int_rec OZF_RESALE_COMMON_PVT.g_interface_rec_csr%rowtype;
1654: l_resale_rec OZF_RESALE_LINES%rowtype;
1655:
1656: l_header_id NUMBER;
1657: l_line_id NUMBER;

Line 1820: OPEN OZF_RESALE_COMMON_PVT.g_log_id_csr;

1816: END IF;
1817:
1818: FOR i in 1..p_line_tbl.LAST LOOP
1819: BEGIN
1820: OPEN OZF_RESALE_COMMON_PVT.g_log_id_csr;
1821: FETCH OZF_RESALE_COMMON_PVT.g_log_id_csr INTO l_log_id;
1822: CLOSE OZF_RESALE_COMMON_PVT.g_log_id_csr;
1823:
1824: -- julou bug 6317120. get org_id from table

Line 1821: FETCH OZF_RESALE_COMMON_PVT.g_log_id_csr INTO l_log_id;

1817:
1818: FOR i in 1..p_line_tbl.LAST LOOP
1819: BEGIN
1820: OPEN OZF_RESALE_COMMON_PVT.g_log_id_csr;
1821: FETCH OZF_RESALE_COMMON_PVT.g_log_id_csr INTO l_log_id;
1822: CLOSE OZF_RESALE_COMMON_PVT.g_log_id_csr;
1823:
1824: -- julou bug 6317120. get org_id from table
1825: IF l_id_type = 'LINE' THEN

Line 1822: CLOSE OZF_RESALE_COMMON_PVT.g_log_id_csr;

1818: FOR i in 1..p_line_tbl.LAST LOOP
1819: BEGIN
1820: OPEN OZF_RESALE_COMMON_PVT.g_log_id_csr;
1821: FETCH OZF_RESALE_COMMON_PVT.g_log_id_csr INTO l_log_id;
1822: CLOSE OZF_RESALE_COMMON_PVT.g_log_id_csr;
1823:
1824: -- julou bug 6317120. get org_id from table
1825: IF l_id_type = 'LINE' THEN
1826: OPEN OZF_RESALE_COMMON_PVT.gc_line_org_id(p_line_tbl(i).chargeback_int_id);

Line 1826: OPEN OZF_RESALE_COMMON_PVT.gc_line_org_id(p_line_tbl(i).chargeback_int_id);

1822: CLOSE OZF_RESALE_COMMON_PVT.g_log_id_csr;
1823:
1824: -- julou bug 6317120. get org_id from table
1825: IF l_id_type = 'LINE' THEN
1826: OPEN OZF_RESALE_COMMON_PVT.gc_line_org_id(p_line_tbl(i).chargeback_int_id);
1827: FETCH OZF_RESALE_COMMON_PVT.gc_line_org_id INTO l_org_id;
1828: CLOSE OZF_RESALE_COMMON_PVT.gc_line_org_id;
1829: ELSIF l_id_type = 'IFACE' THEN
1830: OPEN OZF_RESALE_COMMON_PVT.gc_iface_org_id(p_line_tbl(i).chargeback_int_id);

Line 1827: FETCH OZF_RESALE_COMMON_PVT.gc_line_org_id INTO l_org_id;

1823:
1824: -- julou bug 6317120. get org_id from table
1825: IF l_id_type = 'LINE' THEN
1826: OPEN OZF_RESALE_COMMON_PVT.gc_line_org_id(p_line_tbl(i).chargeback_int_id);
1827: FETCH OZF_RESALE_COMMON_PVT.gc_line_org_id INTO l_org_id;
1828: CLOSE OZF_RESALE_COMMON_PVT.gc_line_org_id;
1829: ELSIF l_id_type = 'IFACE' THEN
1830: OPEN OZF_RESALE_COMMON_PVT.gc_iface_org_id(p_line_tbl(i).chargeback_int_id);
1831: FETCH OZF_RESALE_COMMON_PVT.gc_iface_org_id INTO l_org_id;

Line 1828: CLOSE OZF_RESALE_COMMON_PVT.gc_line_org_id;

1824: -- julou bug 6317120. get org_id from table
1825: IF l_id_type = 'LINE' THEN
1826: OPEN OZF_RESALE_COMMON_PVT.gc_line_org_id(p_line_tbl(i).chargeback_int_id);
1827: FETCH OZF_RESALE_COMMON_PVT.gc_line_org_id INTO l_org_id;
1828: CLOSE OZF_RESALE_COMMON_PVT.gc_line_org_id;
1829: ELSIF l_id_type = 'IFACE' THEN
1830: OPEN OZF_RESALE_COMMON_PVT.gc_iface_org_id(p_line_tbl(i).chargeback_int_id);
1831: FETCH OZF_RESALE_COMMON_PVT.gc_iface_org_id INTO l_org_id;
1832: CLOSE OZF_RESALE_COMMON_PVT.gc_iface_org_id;

Line 1830: OPEN OZF_RESALE_COMMON_PVT.gc_iface_org_id(p_line_tbl(i).chargeback_int_id);

1826: OPEN OZF_RESALE_COMMON_PVT.gc_line_org_id(p_line_tbl(i).chargeback_int_id);
1827: FETCH OZF_RESALE_COMMON_PVT.gc_line_org_id INTO l_org_id;
1828: CLOSE OZF_RESALE_COMMON_PVT.gc_line_org_id;
1829: ELSIF l_id_type = 'IFACE' THEN
1830: OPEN OZF_RESALE_COMMON_PVT.gc_iface_org_id(p_line_tbl(i).chargeback_int_id);
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:

Line 1831: FETCH OZF_RESALE_COMMON_PVT.gc_iface_org_id INTO l_org_id;

1827: FETCH OZF_RESALE_COMMON_PVT.gc_line_org_id INTO l_org_id;
1828: CLOSE OZF_RESALE_COMMON_PVT.gc_line_org_id;
1829: ELSIF l_id_type = 'IFACE' THEN
1830: OPEN OZF_RESALE_COMMON_PVT.gc_iface_org_id(p_line_tbl(i).chargeback_int_id);
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(

Line 1832: CLOSE OZF_RESALE_COMMON_PVT.gc_iface_org_id;

1828: CLOSE OZF_RESALE_COMMON_PVT.gc_line_org_id;
1829: ELSIF l_id_type = 'IFACE' THEN
1830: OPEN OZF_RESALE_COMMON_PVT.gc_iface_org_id(p_line_tbl(i).chargeback_int_id);
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,

Line 1843: --px_org_id => OZF_RESALE_COMMON_PVT.g_org_id

1839: p_error_code => p_line_tbl(i).pricing_status_code,
1840: p_error_message => p_line_tbl(i).pricing_status_text,
1841: p_column_name => NULL,
1842: p_column_value => NULL,
1843: --px_org_id => OZF_RESALE_COMMON_PVT.g_org_id
1844: px_org_id => l_org_id
1845: );
1846: EXCEPTION
1847: WHEN OTHERS THEN

Line 1879: OPEN OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr;

1875: --AMITAMKU Fix for Bug 16038553
1876: -- l_create_order_header := l_dup_line_count IS NULL;
1877:
1878: -- Check whether there is a need to do inventory_verification
1879: OPEN OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr;
1880: FETCH OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr INTO l_inventory_tracking;
1881: CLOSE OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr;
1882:
1883: /*

Line 1880: FETCH OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr INTO l_inventory_tracking;

1876: -- l_create_order_header := l_dup_line_count IS NULL;
1877:
1878: -- Check whether there is a need to do inventory_verification
1879: OPEN OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr;
1880: FETCH OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr INTO l_inventory_tracking;
1881: CLOSE OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr;
1882:
1883: /*
1884: For Bug#9447673 SSD IDSM ER - Restricting the

Line 1881: CLOSE OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr;

1877:
1878: -- Check whether there is a need to do inventory_verification
1879: OPEN OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr;
1880: FETCH OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr INTO l_inventory_tracking;
1881: CLOSE OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr;
1882:
1883: /*
1884: For Bug#9447673 SSD IDSM ER - Restricting the
1885: Initiate inventory flow for Direct order only

Line 1946: OPEN OZF_RESALE_COMMON_PVT.g_interface_rec_csr(p_line_tbl(i).chargeback_int_id);

1942:
1943: IF p_caller_type = 'IFACE' THEN
1944: -- Process interface data
1945:
1946: OPEN OZF_RESALE_COMMON_PVT.g_interface_rec_csr(p_line_tbl(i).chargeback_int_id);
1947: FETCH OZF_RESALE_COMMON_PVT.g_interface_rec_csr INTO l_resale_int_rec;
1948: CLOSE OZF_RESALE_COMMON_PVT.g_interface_rec_csr;
1949:
1950: -- Bug 4380203 (+)

Line 1947: FETCH OZF_RESALE_COMMON_PVT.g_interface_rec_csr INTO l_resale_int_rec;

1943: IF p_caller_type = 'IFACE' THEN
1944: -- Process interface data
1945:
1946: OPEN OZF_RESALE_COMMON_PVT.g_interface_rec_csr(p_line_tbl(i).chargeback_int_id);
1947: FETCH OZF_RESALE_COMMON_PVT.g_interface_rec_csr INTO l_resale_int_rec;
1948: CLOSE OZF_RESALE_COMMON_PVT.g_interface_rec_csr;
1949:
1950: -- Bug 4380203 (+)
1951:

Line 1948: CLOSE OZF_RESALE_COMMON_PVT.g_interface_rec_csr;

1944: -- Process interface data
1945:
1946: OPEN OZF_RESALE_COMMON_PVT.g_interface_rec_csr(p_line_tbl(i).chargeback_int_id);
1947: FETCH OZF_RESALE_COMMON_PVT.g_interface_rec_csr INTO l_resale_int_rec;
1948: CLOSE OZF_RESALE_COMMON_PVT.g_interface_rec_csr;
1949:
1950: -- Bug 4380203 (+)
1951:
1952: -- Check inventory level FOR thIS order.

Line 1984: /* OZF_RESALE_COMMON_PVT.Insert_Resale_Log (

1980: OZF_UTILITY_PVT.debug_message(l_api_name||' >> Did not pass inventory checking');
1981: END IF;
1982: --
1983: -- Fux for bug Bug 14584673 : Added exception block at the end of the loop to log all type of errors at one place.
1984: /* OZF_RESALE_COMMON_PVT.Insert_Resale_Log (
1985: p_id_value => l_resale_int_rec.resale_line_int_id,
1986: p_id_type => 'IFACE',
1987: p_error_code => 'OZF_RESALE_INV_LEVEL_ERROR',
1988: p_column_name => NULL,

Line 2028: OZF_RESALE_COMMON_PVT.Insert_Resale_Header(

2024:
2025: --AMITAMKU Fix for Bug 16038553
2026: -- IF l_create_order_header THEN
2027:
2028: OZF_RESALE_COMMON_PVT.Insert_Resale_Header(
2029: p_api_version => 1
2030: ,p_init_msg_list => FND_API.G_FALSE
2031: ,p_commit => FND_API.G_FALSE
2032: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 2204: OZF_RESALE_COMMON_PVT.Insert_Resale_Log (

2200: l_dispute_code := l_resale_int_rec.dispute_code;
2201: IF l_dispute_code IS NULL THEN
2202: l_dispute_code := 'OZF_PRIC_RESULT_ERR' ;
2203: END IF;
2204: OZF_RESALE_COMMON_PVT.Insert_Resale_Log (
2205: p_id_value => l_resale_int_rec.resale_line_int_id,
2206: p_id_type => 'IFACE',
2207: p_error_code => l_dispute_code,
2208: p_column_name => NULL,

Line 2404: x_fund_update_status VARCHAR2(30) := OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED;

2400: l_org_id NUMBER;
2401: -- end bug 6317120
2402: l_ozf_act_budgets_tbl OZF_UTILITY_PVT.ozf_act_budgets_table;
2403: l_ozf_funds_new_tbl OZF_UTILITY_PVT.ozf_funds_table;
2404: x_fund_update_status VARCHAR2(30) := OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED;
2405: x_budget_update_status VARCHAR2(30) := OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED;
2406: BEGIN
2407: -- Standard BEGIN of API savepoint
2408: SAVEPOINT Process_Resale_Order;

Line 2405: x_budget_update_status VARCHAR2(30) := OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED;

2401: -- end bug 6317120
2402: l_ozf_act_budgets_tbl OZF_UTILITY_PVT.ozf_act_budgets_table;
2403: l_ozf_funds_new_tbl OZF_UTILITY_PVT.ozf_funds_table;
2404: x_fund_update_status VARCHAR2(30) := OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED;
2405: x_budget_update_status VARCHAR2(30) := OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED;
2406: BEGIN
2407: -- Standard BEGIN of API savepoint
2408: SAVEPOINT Process_Resale_Order;
2409: -- Standard call to check for call compatibility.

Line 2555: AND resale_id_type = OZF_RESALE_COMMON_PVT.G_ID_TYPE_LINE;

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
2558: ozf_utility_pvt.error_message('OZF_DEL_RESALE_LOG_WRG');
2559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2839: OPEN OZF_RESALE_COMMON_PVT.g_log_id_csr;

2835:
2836: FOR p in 1..l_order_set_tbl.LAST
2837: LOOP
2838: BEGIN
2839: OPEN OZF_RESALE_COMMON_PVT.g_log_id_csr;
2840: FETCH OZF_RESALE_COMMON_PVT.g_log_id_csr INTO l_log_id;
2841: CLOSE OZF_RESALE_COMMON_PVT.g_log_id_csr;
2842:
2843: -- julou bug 6317120. get org_id from table

Line 2840: FETCH OZF_RESALE_COMMON_PVT.g_log_id_csr INTO l_log_id;

2836: FOR p in 1..l_order_set_tbl.LAST
2837: LOOP
2838: BEGIN
2839: OPEN OZF_RESALE_COMMON_PVT.g_log_id_csr;
2840: FETCH OZF_RESALE_COMMON_PVT.g_log_id_csr INTO l_log_id;
2841: CLOSE OZF_RESALE_COMMON_PVT.g_log_id_csr;
2842:
2843: -- julou bug 6317120. get org_id from table
2844: OPEN OZF_RESALE_COMMON_PVT.gc_line_org_id(l_order_set_tbl(p).resale_line_id);

Line 2841: CLOSE OZF_RESALE_COMMON_PVT.g_log_id_csr;

2837: LOOP
2838: BEGIN
2839: OPEN OZF_RESALE_COMMON_PVT.g_log_id_csr;
2840: FETCH OZF_RESALE_COMMON_PVT.g_log_id_csr INTO l_log_id;
2841: CLOSE OZF_RESALE_COMMON_PVT.g_log_id_csr;
2842:
2843: -- julou bug 6317120. get org_id from table
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;

Line 2844: OPEN OZF_RESALE_COMMON_PVT.gc_line_org_id(l_order_set_tbl(p).resale_line_id);

2840: FETCH OZF_RESALE_COMMON_PVT.g_log_id_csr INTO l_log_id;
2841: CLOSE OZF_RESALE_COMMON_PVT.g_log_id_csr;
2842:
2843: -- julou bug 6317120. get org_id from table
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(

Line 2845: FETCH OZF_RESALE_COMMON_PVT.gc_line_org_id INTO l_org_id;

2841: CLOSE OZF_RESALE_COMMON_PVT.g_log_id_csr;
2842:
2843: -- julou bug 6317120. get org_id from table
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,

Line 2846: CLOSE OZF_RESALE_COMMON_PVT.gc_line_org_id;

2842:
2843: -- julou bug 6317120. get org_id from table
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,

Line 2851: p_resale_id_type => OZF_RESALE_COMMON_PVT.G_ID_TYPE_LINE,

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',
2853: p_error_message => fnd_message.get_string('OZF','OZF_GET_ORDER_PRIC_ERR'),
2854: p_column_name => NULL,
2855: p_column_value => NULL,

Line 2856: --px_org_id => OZF_RESALE_COMMON_PVT.g_org_id

2852: p_error_code => 'OZF_GET_ORDER_PRIC_ERR',
2853: p_error_message => fnd_message.get_string('OZF','OZF_GET_ORDER_PRIC_ERR'),
2854: p_column_name => NULL,
2855: p_column_value => NULL,
2856: --px_org_id => OZF_RESALE_COMMON_PVT.g_org_id
2857: px_org_id => l_org_id
2858: );
2859: EXCEPTION
2860: WHEN OTHERS THEN

Line 2906: OPEN OZF_RESALE_COMMON_PVT.g_log_id_csr;

2902: END IF;
2903: FOR i in 1..l_order_set_tbl.LAST
2904: LOOP
2905: BEGIN
2906: OPEN OZF_RESALE_COMMON_PVT.g_log_id_csr;
2907: FETCH OZF_RESALE_COMMON_PVT.g_log_id_csr INTO l_log_id;
2908: CLOSE OZF_RESALE_COMMON_PVT.g_log_id_csr;
2909:
2910: -- julou bug 6317120. get org_id from table

Line 2907: FETCH OZF_RESALE_COMMON_PVT.g_log_id_csr INTO l_log_id;

2903: FOR i in 1..l_order_set_tbl.LAST
2904: LOOP
2905: BEGIN
2906: OPEN OZF_RESALE_COMMON_PVT.g_log_id_csr;
2907: FETCH OZF_RESALE_COMMON_PVT.g_log_id_csr INTO l_log_id;
2908: CLOSE OZF_RESALE_COMMON_PVT.g_log_id_csr;
2909:
2910: -- julou bug 6317120. get org_id from table
2911: OPEN OZF_RESALE_COMMON_PVT.gc_line_org_id(l_order_set_tbl(i).resale_line_id);

Line 2908: CLOSE OZF_RESALE_COMMON_PVT.g_log_id_csr;

2904: LOOP
2905: BEGIN
2906: OPEN OZF_RESALE_COMMON_PVT.g_log_id_csr;
2907: FETCH OZF_RESALE_COMMON_PVT.g_log_id_csr INTO l_log_id;
2908: CLOSE OZF_RESALE_COMMON_PVT.g_log_id_csr;
2909:
2910: -- julou bug 6317120. get org_id from table
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;

Line 2911: OPEN OZF_RESALE_COMMON_PVT.gc_line_org_id(l_order_set_tbl(i).resale_line_id);

2907: FETCH OZF_RESALE_COMMON_PVT.g_log_id_csr INTO l_log_id;
2908: CLOSE OZF_RESALE_COMMON_PVT.g_log_id_csr;
2909:
2910: -- julou bug 6317120. get org_id from table
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(

Line 2912: FETCH OZF_RESALE_COMMON_PVT.gc_line_org_id INTO l_org_id;

2908: CLOSE OZF_RESALE_COMMON_PVT.g_log_id_csr;
2909:
2910: -- julou bug 6317120. get org_id from table
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,

Line 2913: CLOSE OZF_RESALE_COMMON_PVT.gc_line_org_id;

2909:
2910: -- julou bug 6317120. get org_id from table
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,

Line 2918: p_resale_id_type => OZF_RESALE_COMMON_PVT.G_ID_TYPE_LINE,

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',
2920: p_error_message => fnd_message.get_string('OZF','OZF_PROC_PRIC_RESLT_ERR'),
2921: p_column_name => NULL,
2922: p_column_value => NULL,

Line 2923: --px_org_id => OZF_RESALE_COMMON_PVT.g_org_id

2919: p_error_code => 'OZF_PROC_PRIC_RESLT_ERR',
2920: p_error_message => fnd_message.get_string('OZF','OZF_PROC_PRIC_RESLT_ERR'),
2921: p_column_name => NULL,
2922: p_column_value => NULL,
2923: --px_org_id => OZF_RESALE_COMMON_PVT.g_org_id
2924: px_org_id => l_org_id
2925: );
2926: EXCEPTION
2927: WHEN OTHERS THEN

Line 3242: WHERE status_code=OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN

3238: SELECT distinct order_NUMBER,
3239: bill_to_cust_account_id,
3240: date_ordered
3241: FROM ozf_resale_lines_int
3242: WHERE status_code=OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN
3243: AND direct_customer_flag = 'F'
3244: AND resale_batch_id = p_resale_batch_id
3245: ORDER BY date_ordered;
3246:

Line 3260: AND status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN

3256: WHERE order_NUMBER = p_num
3257: AND bill_to_cust_account_id = p_name
3258: AND date_ordered = p_date
3259: AND direct_customer_flag ='F'
3260: AND status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN
3261: AND resale_batch_id = p_resale_batch_id;
3262:
3263: TYPE interface_tbl_type is TABLE OF OZF_RESALE_COMMON_PVT.g_interface_rec_csr%rowtype INDEX BY binary_integer;
3264:

Line 3263: TYPE interface_tbl_type is TABLE OF OZF_RESALE_COMMON_PVT.g_interface_rec_csr%rowtype INDEX BY binary_integer;

3259: AND direct_customer_flag ='F'
3260: AND status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN
3261: AND resale_batch_id = p_resale_batch_id;
3262:
3263: TYPE interface_tbl_type is TABLE OF OZF_RESALE_COMMON_PVT.g_interface_rec_csr%rowtype INDEX BY binary_integer;
3264:
3265: l_resale_int_tbl interface_tbl_type;
3266:
3267: l_header_id NUMBER;

Line 3369: OZF_RESALE_COMMON_PVT.Insert_resale_header(

3365: FOR k in 1..l_resale_int_tbl.LAST LOOP
3366:
3367: -- Create an order header for the order_NUMBER;
3368: IF k = 1 THEN
3369: OZF_RESALE_COMMON_PVT.Insert_resale_header(
3370: p_api_version => 1
3371: ,p_init_msg_list => FND_API.G_FALSE
3372: ,p_commit => FND_API.G_FALSE
3373: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 3385: OZF_RESALE_COMMON_PVT.Insert_resale_line(

3381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3382: END IF;
3383: END IF;
3384:
3385: OZF_RESALE_COMMON_PVT.Insert_resale_line(
3386: p_api_version => 1
3387: ,p_init_msg_list => FND_API.G_FALSE
3388: ,p_commit => FND_API.G_FALSE
3389: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 3406: SET status_code= OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_CLOSED

3402: END LOOP;
3403:
3404: BEGIN
3405: UPDATE ozf_resale_lines_int
3406: SET status_code= OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_CLOSED
3407: WHERE direct_customer_flag ='F'
3408: AND status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN
3409: AND resale_batch_id = p_resale_batch_id;
3410: EXCEPTION

Line 3408: AND status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN

3404: BEGIN
3405: UPDATE ozf_resale_lines_int
3406: SET status_code= OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_CLOSED
3407: WHERE direct_customer_flag ='F'
3408: AND status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN
3409: AND resale_batch_id = p_resale_batch_id;
3410: EXCEPTION
3411: WHEN OTHERS THEN
3412: ozf_utility_pvt.error_message('OZF_UPD_RESALE_INT_WRG');

Line 3646: x_fund_update_status VARCHAR2(30) := OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED;

3642: -- end bug 6317120
3643: l_ozf_act_budgets_tbl OZF_UTILITY_PVT.ozf_act_budgets_table;
3644: l_ozf_funds_new_tbl OZF_UTILITY_PVT.ozf_funds_table;
3645: l_ozf_draft_accrual_tbl ozf_draft_accrual_tbl_type;
3646: x_fund_update_status VARCHAR2(30) := OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED;
3647: x_budget_update_status VARCHAR2(30) := OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED;
3648: l_ozf_draft_accrual_rec ozf_draft_accrual_rec_type;
3649: BEGIN
3650: -- Standard BEGIN of API savepoint

Line 3647: x_budget_update_status VARCHAR2(30) := OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED;

3643: l_ozf_act_budgets_tbl OZF_UTILITY_PVT.ozf_act_budgets_table;
3644: l_ozf_funds_new_tbl OZF_UTILITY_PVT.ozf_funds_table;
3645: l_ozf_draft_accrual_tbl ozf_draft_accrual_tbl_type;
3646: x_fund_update_status VARCHAR2(30) := OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED;
3647: x_budget_update_status VARCHAR2(30) := OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED;
3648: l_ozf_draft_accrual_rec ozf_draft_accrual_rec_type;
3649: BEGIN
3650: -- Standard BEGIN of API savepoint
3651: SAVEPOINT Process_Order;

Line 3724: OZF_RESALE_COMMON_PVT.Update_Duplicates (

3720: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
3721:
3722: --AMITAMKU Bug 14685303 - Added call of this procedure to check if the duplicates of the existing lines
3723: --If duplicate lines are found, then the status is updated as DUPLICATED
3724: OZF_RESALE_COMMON_PVT.Update_Duplicates (
3725: p_api_version => 1
3726: ,p_init_msg_LIST => FND_API.G_FALSE
3727: ,p_commit => FND_API.G_FALSE
3728: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 3730: ,p_resale_batch_type => OZF_RESALE_COMMON_PVT.G_TP_ACCRUAL

3726: ,p_init_msg_LIST => FND_API.G_FALSE
3727: ,p_commit => FND_API.G_FALSE
3728: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
3729: ,p_resale_batch_id => p_resale_batch_id
3730: ,p_resale_batch_type => OZF_RESALE_COMMON_PVT.G_TP_ACCRUAL
3731: ,p_batch_status => l_batch_status
3732: ,x_batch_status => l_new_batch_status
3733: ,x_return_status => l_return_status
3734: ,x_msg_data => l_msg_data

Line 4182: OPEN OZF_RESALE_COMMON_PVT.g_log_id_csr;

4178:
4179: FOR p in 1..l_order_set_tbl.LAST
4180: LOOP
4181: BEGIN
4182: OPEN OZF_RESALE_COMMON_PVT.g_log_id_csr;
4183: FETCH OZF_RESALE_COMMON_PVT.g_log_id_csr INTO l_log_id;
4184: CLOSE OZF_RESALE_COMMON_PVT.g_log_id_csr;
4185:
4186: -- julou bug 6317120. get org_id from table

Line 4183: FETCH OZF_RESALE_COMMON_PVT.g_log_id_csr INTO l_log_id;

4179: FOR p in 1..l_order_set_tbl.LAST
4180: LOOP
4181: BEGIN
4182: OPEN OZF_RESALE_COMMON_PVT.g_log_id_csr;
4183: FETCH OZF_RESALE_COMMON_PVT.g_log_id_csr INTO l_log_id;
4184: CLOSE OZF_RESALE_COMMON_PVT.g_log_id_csr;
4185:
4186: -- julou bug 6317120. get org_id from table
4187: OPEN OZF_RESALE_COMMON_PVT.gc_iface_org_id(l_order_set_tbl(p).resale_line_int_id);

Line 4184: CLOSE OZF_RESALE_COMMON_PVT.g_log_id_csr;

4180: LOOP
4181: BEGIN
4182: OPEN OZF_RESALE_COMMON_PVT.g_log_id_csr;
4183: FETCH OZF_RESALE_COMMON_PVT.g_log_id_csr INTO l_log_id;
4184: CLOSE OZF_RESALE_COMMON_PVT.g_log_id_csr;
4185:
4186: -- julou bug 6317120. get org_id from table
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;

Line 4187: OPEN OZF_RESALE_COMMON_PVT.gc_iface_org_id(l_order_set_tbl(p).resale_line_int_id);

4183: FETCH OZF_RESALE_COMMON_PVT.g_log_id_csr INTO l_log_id;
4184: CLOSE OZF_RESALE_COMMON_PVT.g_log_id_csr;
4185:
4186: -- julou bug 6317120. get org_id from table
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(

Line 4188: FETCH OZF_RESALE_COMMON_PVT.gc_iface_org_id INTO l_org_id;

4184: CLOSE OZF_RESALE_COMMON_PVT.g_log_id_csr;
4185:
4186: -- julou bug 6317120. get org_id from table
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,

Line 4189: CLOSE OZF_RESALE_COMMON_PVT.gc_iface_org_id;

4185:
4186: -- julou bug 6317120. get org_id from table
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,

Line 4199: --px_org_id => OZF_RESALE_COMMON_PVT.g_org_id

4195: p_error_code => 'OZF_GET_ORDER_PRIC_ERR',
4196: p_error_message => FND_MESSAGE.get_string('OZF','OZF_GET_ORDER_PRIC_ERR'),
4197: p_column_name => NULL,
4198: p_column_value => NULL,
4199: --px_org_id => OZF_RESALE_COMMON_PVT.g_org_id
4200: px_org_id => l_org_id
4201: );
4202: EXCEPTION
4203: WHEN OTHERS THEN

Line 4243: OPEN OZF_RESALE_COMMON_PVT.g_log_id_csr;

4239: -- );
4240:
4241: FOR p in 1..l_order_set_tbl.LAST LOOP
4242: BEGIN
4243: OPEN OZF_RESALE_COMMON_PVT.g_log_id_csr;
4244: FETCH OZF_RESALE_COMMON_PVT.g_log_id_csr INTO l_log_id;
4245: CLOSE OZF_RESALE_COMMON_PVT.g_log_id_csr;
4246:
4247: -- julou bug 6317120. get org_id from table

Line 4244: FETCH OZF_RESALE_COMMON_PVT.g_log_id_csr INTO l_log_id;

4240:
4241: FOR p in 1..l_order_set_tbl.LAST LOOP
4242: BEGIN
4243: OPEN OZF_RESALE_COMMON_PVT.g_log_id_csr;
4244: FETCH OZF_RESALE_COMMON_PVT.g_log_id_csr INTO l_log_id;
4245: CLOSE OZF_RESALE_COMMON_PVT.g_log_id_csr;
4246:
4247: -- julou bug 6317120. get org_id from table
4248: OPEN OZF_RESALE_COMMON_PVT.gc_iface_org_id(l_order_set_tbl(p).resale_line_int_id);

Line 4245: CLOSE OZF_RESALE_COMMON_PVT.g_log_id_csr;

4241: FOR p in 1..l_order_set_tbl.LAST LOOP
4242: BEGIN
4243: OPEN OZF_RESALE_COMMON_PVT.g_log_id_csr;
4244: FETCH OZF_RESALE_COMMON_PVT.g_log_id_csr INTO l_log_id;
4245: CLOSE OZF_RESALE_COMMON_PVT.g_log_id_csr;
4246:
4247: -- julou bug 6317120. get org_id from table
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;

Line 4248: OPEN OZF_RESALE_COMMON_PVT.gc_iface_org_id(l_order_set_tbl(p).resale_line_int_id);

4244: FETCH OZF_RESALE_COMMON_PVT.g_log_id_csr INTO l_log_id;
4245: CLOSE OZF_RESALE_COMMON_PVT.g_log_id_csr;
4246:
4247: -- julou bug 6317120. get org_id from table
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(

Line 4249: FETCH OZF_RESALE_COMMON_PVT.gc_iface_org_id INTO l_org_id;

4245: CLOSE OZF_RESALE_COMMON_PVT.g_log_id_csr;
4246:
4247: -- julou bug 6317120. get org_id from table
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,

Line 4250: CLOSE OZF_RESALE_COMMON_PVT.gc_iface_org_id;

4246:
4247: -- julou bug 6317120. get org_id from table
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,

Line 4260: --px_org_id => OZF_RESALE_COMMON_PVT.g_org_id

4256: p_error_code => 'OZF_PRIC_RESULT_ERR',
4257: p_error_message => FND_MESSAGE.get_string('OZF','OZF_PRIC_RESULT_ERR'),
4258: p_column_name => NULL,
4259: p_column_value => NULL,
4260: --px_org_id => OZF_RESALE_COMMON_PVT.g_org_id
4261: px_org_id => l_org_id
4262: );
4263: EXCEPTION
4264: WHEN OTHERS THEN

Line 4485: l_batch_status := OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED;

4481: OZF_UTILITY_PVT.debug_message('x_budget_update_status: ' || x_budget_update_status);
4482: OZF_UTILITY_PVT.debug_message('Updated batch status to Pending Accruals');
4483: END IF;
4484: ELSE
4485: l_batch_status := OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED;
4486: END IF;
4487: END IF; -- IF l_run_mode = 'FINAL' THEN
4488: ELSE -- IF l_order_num_tbl.EXISTS(1) THEN
4489:

Line 4684: l_sold_from_cust_id_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;

4680: WHERE resale_batch_id IS NULL
4681: AND request_id = p_id
4682: AND org_id = l_org_id; -- nepanda : Fix for bug # 15900683
4683:
4684: l_sold_from_cust_id_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
4685:
4686: -- bug # 7375849 fixed by ateotia (+)
4687: --l_sold_from_cust_name_tbl OZF_RESALE_COMMON_PVT.varchar_tbl_type;
4688: TYPE varchar_tbl_type IS TABLE OF VARCHAR2(360) INDEX BY BINARY_INTEGER;

Line 4687: --l_sold_from_cust_name_tbl OZF_RESALE_COMMON_PVT.varchar_tbl_type;

4683:
4684: l_sold_from_cust_id_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
4685:
4686: -- bug # 7375849 fixed by ateotia (+)
4687: --l_sold_from_cust_name_tbl OZF_RESALE_COMMON_PVT.varchar_tbl_type;
4688: TYPE varchar_tbl_type IS TABLE OF VARCHAR2(360) INDEX BY BINARY_INTEGER;
4689: l_sold_from_cust_name_tbl varchar_tbl_type;
4690: -- bug # 7375849 fixed by ateotia (-)
4691:

Line 4692: l_org_id_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;

4688: TYPE varchar_tbl_type IS TABLE OF VARCHAR2(360) INDEX BY BINARY_INTEGER;
4689: l_sold_from_cust_name_tbl varchar_tbl_type;
4690: -- bug # 7375849 fixed by ateotia (-)
4691:
4692: l_org_id_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
4693: l_currency_code_tbl OZF_RESALE_COMMON_PVT.varchar_tbl_type;
4694:
4695: CURSOR party_id_csr(p_id number)IS
4696: SELECT hca.party_id

Line 4693: l_currency_code_tbl OZF_RESALE_COMMON_PVT.varchar_tbl_type;

4689: l_sold_from_cust_name_tbl varchar_tbl_type;
4690: -- bug # 7375849 fixed by ateotia (-)
4691:
4692: l_org_id_tbl OZF_RESALE_COMMON_PVT.number_tbl_type;
4693: l_currency_code_tbl OZF_RESALE_COMMON_PVT.varchar_tbl_type;
4694:
4695: CURSOR party_id_csr(p_id number)IS
4696: SELECT hca.party_id
4697: -- bug # 7375849 fixed by ateotia (+)

Line 4774: l_resale_line_int_id_tbl OZF_RESALE_COMMON_PVT.number_tbl_type; */

4770: -- TPA iN Draft Mode - start
4771: -- Fix for Bug 14584673
4772: /*CURSOR csr_resale_lines_int_tmp_dtls IS
4773: SELECT resale_line_int_id FROM OZF_RESALE_LINES_INT_ALL_TEMP ;
4774: l_resale_line_int_id_tbl OZF_RESALE_COMMON_PVT.number_tbl_type; */
4775:
4776: l_status VARCHAR2(5);
4777: l_industry VARCHAR2(5);
4778: l_schema VARCHAR2(30);

Line 4992: p_batch_type => OZF_RESALE_COMMON_PVT.G_TP_ACCRUAL,

4988: p_program_update_date => SYSdate,
4989: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,
4990: p_created_from => l_created_from,
4991: p_batch_number => l_resale_batch_number,
4992: p_batch_type => OZF_RESALE_COMMON_PVT.G_TP_ACCRUAL,
4993: p_batch_count => NULL,
4994: p_year => NULL,
4995: p_month => NULL,
4996: p_report_date => trunc(sysdate),

Line 4999: p_status_code => OZF_RESALE_COMMON_PVT.G_BATCH_NEW,

4995: p_month => NULL,
4996: p_report_date => trunc(sysdate),
4997: p_report_start_date => trunc(l_start_date),
4998: p_report_end_date => trunc(l_end_date),
4999: p_status_code => OZF_RESALE_COMMON_PVT.G_BATCH_NEW,
5000: p_data_source_code => l_data_source_code,
5001: p_reference_type => NULL,
5002: p_reference_number => NULL,
5003: p_comments => NULL,