APPS.OZF_NET_ACCRUAL_ENGINE_PVT dependencies on OZF_UTILITY_PVT

Line 291: ozf_utility_pvt.write_conc_log('Number of Market Eligibilites: '||l_no_groups);

287: CLOSE c_no_groups;
288:
289: IF G_DEBUG_LOW
290: THEN
291: ozf_utility_pvt.write_conc_log('Number of Market Eligibilites: '||l_no_groups);
292: END IF;
293:
294: IF l_no_groups > 0
295: THEN

Line 371: ozf_utility_pvt.write_conc_log('1:'||substr(x_party_stmt,945,250));

367:
368: IF G_DEBUG_LOW
369: THEN
370: --
371: ozf_utility_pvt.write_conc_log('1:'||substr(x_party_stmt,945,250));
372: ozf_utility_pvt.write_conc_log('2:'||substr(x_party_stmt,1195,250));
373: ozf_utility_pvt.write_conc_log('3:'||substr(x_party_stmt,1445,250));
374: --
375: END IF;

Line 372: ozf_utility_pvt.write_conc_log('2:'||substr(x_party_stmt,1195,250));

368: IF G_DEBUG_LOW
369: THEN
370: --
371: ozf_utility_pvt.write_conc_log('1:'||substr(x_party_stmt,945,250));
372: ozf_utility_pvt.write_conc_log('2:'||substr(x_party_stmt,1195,250));
373: ozf_utility_pvt.write_conc_log('3:'||substr(x_party_stmt,1445,250));
374: --
375: END IF;
376:

Line 373: ozf_utility_pvt.write_conc_log('3:'||substr(x_party_stmt,1445,250));

369: THEN
370: --
371: ozf_utility_pvt.write_conc_log('1:'||substr(x_party_stmt,945,250));
372: ozf_utility_pvt.write_conc_log('2:'||substr(x_party_stmt,1195,250));
373: ozf_utility_pvt.write_conc_log('3:'||substr(x_party_stmt,1445,250));
374: --
375: END IF;
376:
377: EXCEPTION

Line 434: ozf_utility_pvt.write_conc_log('-- Refresh_Parties (+)');

430: FND_DSQL.add_text(' decode(site_use_code,''BILL_TO'',''CUSTOMER'',''SHIP_TO'',''CUSTOMER'',substr(site_use_code,0,INSTR(site_use_code,'':'')-1)) qualifier_context');
431: FND_DSQL.add_text(' FROM (');
432:
433:
434: ozf_utility_pvt.write_conc_log('-- Refresh_Parties (+)');
435:
436: /* refresh parties would get all the parties for the offer_id and add to FND_DSQL*/
437: refresh_parties(p_offer_id => p_offer_id,
438: p_calling_from_den => 'Y',

Line 444: ozf_utility_pvt.write_conc_log('-- Refresh_Parties (-) With Status: ' || x_return_status );

440: x_msg_count => x_msg_count,
441: x_msg_data => x_msg_data,
442: x_party_stmt => l_stmt_offer);
443:
444: ozf_utility_pvt.write_conc_log('-- Refresh_Parties (-) With Status: ' || x_return_status );
445:
446: IF x_return_status = FND_API.g_ret_sts_unexp_error
447: THEN
448: RAISE FND_API.g_exc_unexpected_error;

Line 481: ozf_utility_pvt.write_conc_log(l_stmt_debug);

477: EXCEPTION
478: WHEN OTHERS THEN
479: x_return_status := FND_API.g_ret_sts_unexp_error;
480:
481: ozf_utility_pvt.write_conc_log(l_stmt_debug);
482: ozf_utility_pvt.write_conc_log(SQLERRM);
483:
484: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
485: THEN

Line 482: ozf_utility_pvt.write_conc_log(SQLERRM);

478: WHEN OTHERS THEN
479: x_return_status := FND_API.g_ret_sts_unexp_error;
480:
481: ozf_utility_pvt.write_conc_log(l_stmt_debug);
482: ozf_utility_pvt.write_conc_log(SQLERRM);
483:
484: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
485: THEN
486: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 587: ozf_utility_pvt.write_conc_log('Functional Area for category: ' || l_func_area_id);

583: l_func_area_id := get_func_area(l_product.product_id);
584:
585: IF G_DEBUG_LOW THEN
586: --
587: ozf_utility_pvt.write_conc_log('Functional Area for category: ' || l_func_area_id);
588: ozf_utility_pvt.write_conc_log('Off_Discount_Product_Id:' || l_product.off_discount_product_id);
589: --
590: END IF;
591: --

Line 588: ozf_utility_pvt.write_conc_log('Off_Discount_Product_Id:' || l_product.off_discount_product_id);

584:
585: IF G_DEBUG_LOW THEN
586: --
587: ozf_utility_pvt.write_conc_log('Functional Area for category: ' || l_func_area_id);
588: ozf_utility_pvt.write_conc_log('Off_Discount_Product_Id:' || l_product.off_discount_product_id);
589: --
590: END IF;
591: --
592: END IF;

Line 696: ozf_utility_pvt.write_conc_log(l_stmt_debug);

692: EXCEPTION
693: WHEN OTHERS THEN
694: x_return_status := FND_API.g_ret_sts_unexp_error;
695:
696: ozf_utility_pvt.write_conc_log(l_stmt_debug);
697: ozf_utility_pvt.write_conc_log(SQLERRM);
698:
699: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
700: THEN

Line 697: ozf_utility_pvt.write_conc_log(SQLERRM);

693: WHEN OTHERS THEN
694: x_return_status := FND_API.g_ret_sts_unexp_error;
695:
696: ozf_utility_pvt.write_conc_log(l_stmt_debug);
697: ozf_utility_pvt.write_conc_log(SQLERRM);
698:
699: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
700: THEN
701: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 751: ozf_utility_pvt.write_conc_log(l_api_name);

747: BEGIN
748: x_return_status := FND_API.g_ret_sts_success;
749:
750: l_org_id := fnd_profile.value('QP_ORGANIZATION_ID');
751: ozf_utility_pvt.write_conc_log(l_api_name);
752:
753: FOR l_product IN c_product
754: LOOP
755: --

Line 769: ozf_utility_pvt.write_conc_log('off_discount_product_id:' || l_product.off_discount_product_id);

765: LOOP
766: --
767: -- IF G_DEBUG_LOW THEN
768: --
769: ozf_utility_pvt.write_conc_log('off_discount_product_id:' || l_product.off_discount_product_id);
770: ozf_utility_pvt.write_conc_log('Functional Area for category: ' || l_func_area_id);
771: --
772: -- END IF;
773:

Line 770: ozf_utility_pvt.write_conc_log('Functional Area for category: ' || l_func_area_id);

766: --
767: -- IF G_DEBUG_LOW THEN
768: --
769: ozf_utility_pvt.write_conc_log('off_discount_product_id:' || l_product.off_discount_product_id);
770: ozf_utility_pvt.write_conc_log('Functional Area for category: ' || l_func_area_id);
771: --
772: -- END IF;
773:
774: FND_DSQL.init;

Line 847: ozf_utility_pvt.write_conc_log(l_stmt_debug);

843: EXCEPTION
844: WHEN OTHERS THEN
845: x_return_status := FND_API.g_ret_sts_unexp_error;
846:
847: ozf_utility_pvt.write_conc_log(l_stmt_debug);
848: ozf_utility_pvt.write_conc_log(SQLERRM);
849:
850: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
851: THEN

Line 848: ozf_utility_pvt.write_conc_log(SQLERRM);

844: WHEN OTHERS THEN
845: x_return_status := FND_API.g_ret_sts_unexp_error;
846:
847: ozf_utility_pvt.write_conc_log(l_stmt_debug);
848: ozf_utility_pvt.write_conc_log(SQLERRM);
849:
850: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
851: THEN
852: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 983: ozf_utility_pvt.write_conc_log('Product belongs to a Category on the Offer');

979: l_max_accrual:= l_line_accrual;
980: END IF;
981:
982: -- IF G_DEBUG_LOW THEN
983: ozf_utility_pvt.write_conc_log('Product belongs to a Category on the Offer');
984: ozf_utility_pvt.write_conc_log('ItmId/Qty/Amt/VolType/DiscType/disc/VolQual?');
985: ozf_utility_pvt.write_conc_log(p_product_id || '/' ||
986: p_quantity || '/' ||
987: p_line_amt || '/' ||

Line 984: ozf_utility_pvt.write_conc_log('ItmId/Qty/Amt/VolType/DiscType/disc/VolQual?');

980: END IF;
981:
982: -- IF G_DEBUG_LOW THEN
983: ozf_utility_pvt.write_conc_log('Product belongs to a Category on the Offer');
984: ozf_utility_pvt.write_conc_log('ItmId/Qty/Amt/VolType/DiscType/disc/VolQual?');
985: ozf_utility_pvt.write_conc_log(p_product_id || '/' ||
986: p_quantity || '/' ||
987: p_line_amt || '/' ||
988: l_discount_for_cat.volume_type || '/' ||

Line 985: ozf_utility_pvt.write_conc_log(p_product_id || '/' ||

981:
982: -- IF G_DEBUG_LOW THEN
983: ozf_utility_pvt.write_conc_log('Product belongs to a Category on the Offer');
984: ozf_utility_pvt.write_conc_log('ItmId/Qty/Amt/VolType/DiscType/disc/VolQual?');
985: ozf_utility_pvt.write_conc_log(p_product_id || '/' ||
986: p_quantity || '/' ||
987: p_line_amt || '/' ||
988: l_discount_for_cat.volume_type || '/' ||
989: l_discount_for_cat.discount_type || '/' ||

Line 1000: ozf_utility_pvt.write_conc_log('l_volume_qualified '||l_volume_qualified);

996: ELSE
997: -- discount for the item exists. take this value as accrualed discount
998: FOR l_discount_for_item IN c_discount_for_item
999: LOOP
1000: ozf_utility_pvt.write_conc_log('l_volume_qualified '||l_volume_qualified);
1001: ozf_utility_pvt.write_conc_log('l_discount_for_item.volume_from '|| l_discount_for_item.volume_from);
1002: ozf_utility_pvt.write_conc_log('l_discount_for_item.volume_to '|| l_discount_for_item.volume_to);
1003: ozf_utility_pvt.write_conc_log('l_discount_for_item.volume_type '|| l_discount_for_item.volume_type);
1004: ozf_utility_pvt.write_conc_log('p_line_amt '|| p_line_amt);

Line 1001: ozf_utility_pvt.write_conc_log('l_discount_for_item.volume_from '|| l_discount_for_item.volume_from);

997: -- discount for the item exists. take this value as accrualed discount
998: FOR l_discount_for_item IN c_discount_for_item
999: LOOP
1000: ozf_utility_pvt.write_conc_log('l_volume_qualified '||l_volume_qualified);
1001: ozf_utility_pvt.write_conc_log('l_discount_for_item.volume_from '|| l_discount_for_item.volume_from);
1002: ozf_utility_pvt.write_conc_log('l_discount_for_item.volume_to '|| l_discount_for_item.volume_to);
1003: ozf_utility_pvt.write_conc_log('l_discount_for_item.volume_type '|| l_discount_for_item.volume_type);
1004: ozf_utility_pvt.write_conc_log('p_line_amt '|| p_line_amt);
1005: ozf_utility_pvt.write_conc_log('l_discount_for_item.discount '|| l_discount_for_item.discount);

Line 1002: ozf_utility_pvt.write_conc_log('l_discount_for_item.volume_to '|| l_discount_for_item.volume_to);

998: FOR l_discount_for_item IN c_discount_for_item
999: LOOP
1000: ozf_utility_pvt.write_conc_log('l_volume_qualified '||l_volume_qualified);
1001: ozf_utility_pvt.write_conc_log('l_discount_for_item.volume_from '|| l_discount_for_item.volume_from);
1002: ozf_utility_pvt.write_conc_log('l_discount_for_item.volume_to '|| l_discount_for_item.volume_to);
1003: ozf_utility_pvt.write_conc_log('l_discount_for_item.volume_type '|| l_discount_for_item.volume_type);
1004: ozf_utility_pvt.write_conc_log('p_line_amt '|| p_line_amt);
1005: ozf_utility_pvt.write_conc_log('l_discount_for_item.discount '|| l_discount_for_item.discount);
1006: ozf_utility_pvt.write_conc_log('l_discount_for_item.discount_type '|| l_discount_for_item.discount_type);

Line 1003: ozf_utility_pvt.write_conc_log('l_discount_for_item.volume_type '|| l_discount_for_item.volume_type);

999: LOOP
1000: ozf_utility_pvt.write_conc_log('l_volume_qualified '||l_volume_qualified);
1001: ozf_utility_pvt.write_conc_log('l_discount_for_item.volume_from '|| l_discount_for_item.volume_from);
1002: ozf_utility_pvt.write_conc_log('l_discount_for_item.volume_to '|| l_discount_for_item.volume_to);
1003: ozf_utility_pvt.write_conc_log('l_discount_for_item.volume_type '|| l_discount_for_item.volume_type);
1004: ozf_utility_pvt.write_conc_log('p_line_amt '|| p_line_amt);
1005: ozf_utility_pvt.write_conc_log('l_discount_for_item.discount '|| l_discount_for_item.discount);
1006: ozf_utility_pvt.write_conc_log('l_discount_for_item.discount_type '|| l_discount_for_item.discount_type);
1007: --

Line 1004: ozf_utility_pvt.write_conc_log('p_line_amt '|| p_line_amt);

1000: ozf_utility_pvt.write_conc_log('l_volume_qualified '||l_volume_qualified);
1001: ozf_utility_pvt.write_conc_log('l_discount_for_item.volume_from '|| l_discount_for_item.volume_from);
1002: ozf_utility_pvt.write_conc_log('l_discount_for_item.volume_to '|| l_discount_for_item.volume_to);
1003: ozf_utility_pvt.write_conc_log('l_discount_for_item.volume_type '|| l_discount_for_item.volume_type);
1004: ozf_utility_pvt.write_conc_log('p_line_amt '|| p_line_amt);
1005: ozf_utility_pvt.write_conc_log('l_discount_for_item.discount '|| l_discount_for_item.discount);
1006: ozf_utility_pvt.write_conc_log('l_discount_for_item.discount_type '|| l_discount_for_item.discount_type);
1007: --
1008: l_line_accrual := 0;

Line 1005: ozf_utility_pvt.write_conc_log('l_discount_for_item.discount '|| l_discount_for_item.discount);

1001: ozf_utility_pvt.write_conc_log('l_discount_for_item.volume_from '|| l_discount_for_item.volume_from);
1002: ozf_utility_pvt.write_conc_log('l_discount_for_item.volume_to '|| l_discount_for_item.volume_to);
1003: ozf_utility_pvt.write_conc_log('l_discount_for_item.volume_type '|| l_discount_for_item.volume_type);
1004: ozf_utility_pvt.write_conc_log('p_line_amt '|| p_line_amt);
1005: ozf_utility_pvt.write_conc_log('l_discount_for_item.discount '|| l_discount_for_item.discount);
1006: ozf_utility_pvt.write_conc_log('l_discount_for_item.discount_type '|| l_discount_for_item.discount_type);
1007: --
1008: l_line_accrual := 0;
1009: l_volume_qualified := 'N';

Line 1006: ozf_utility_pvt.write_conc_log('l_discount_for_item.discount_type '|| l_discount_for_item.discount_type);

1002: ozf_utility_pvt.write_conc_log('l_discount_for_item.volume_to '|| l_discount_for_item.volume_to);
1003: ozf_utility_pvt.write_conc_log('l_discount_for_item.volume_type '|| l_discount_for_item.volume_type);
1004: ozf_utility_pvt.write_conc_log('p_line_amt '|| p_line_amt);
1005: ozf_utility_pvt.write_conc_log('l_discount_for_item.discount '|| l_discount_for_item.discount);
1006: ozf_utility_pvt.write_conc_log('l_discount_for_item.discount_type '|| l_discount_for_item.discount_type);
1007: --
1008: l_line_accrual := 0;
1009: l_volume_qualified := 'N';
1010: -- check if order satisfies amt/qty requirement

Line 1075: ozf_utility_pvt.write_conc_log('ItmId/Qty/Amt/VolType/DiscType/disc/VolQual?/MaxAccr');

1071: --
1072: END IF;
1073:
1074: IF G_DEBUG_LOW THEN
1075: ozf_utility_pvt.write_conc_log('ItmId/Qty/Amt/VolType/DiscType/disc/VolQual?/MaxAccr');
1076: ozf_utility_pvt.write_conc_log(p_product_id || '/' ||
1077: p_quantity || '/' ||
1078: p_line_amt || '/' ||
1079: l_discount_for_item.volume_type || '/' ||

Line 1076: ozf_utility_pvt.write_conc_log(p_product_id || '/' ||

1072: END IF;
1073:
1074: IF G_DEBUG_LOW THEN
1075: ozf_utility_pvt.write_conc_log('ItmId/Qty/Amt/VolType/DiscType/disc/VolQual?/MaxAccr');
1076: ozf_utility_pvt.write_conc_log(p_product_id || '/' ||
1077: p_quantity || '/' ||
1078: p_line_amt || '/' ||
1079: l_discount_for_item.volume_type || '/' ||
1080: l_discount_for_item.discount_type || '/' ||

Line 1153: ozf_utility_pvt.write_conc_log('Statement is : ' || l_stmt);

1149: l_stmt := l_stmt || ' AND b.product_id = epdhv.parent_id ';
1150: l_stmt := l_stmt || ' AND epdhv.parent_id = c.category_id';
1151:
1152: IF G_DEBUG_LOW THEN
1153: ozf_utility_pvt.write_conc_log('Statement is : ' || l_stmt);
1154: ozf_utility_pvt.write_conc_log('Bind var is : ' || p_product_id);
1155: END IF;
1156:
1157: EXECUTE IMMEDIATE l_stmt INTO l_discount, l_category_id USING p_offer_id, p_product_id, p_org_id;

Line 1154: ozf_utility_pvt.write_conc_log('Bind var is : ' || p_product_id);

1150: l_stmt := l_stmt || ' AND epdhv.parent_id = c.category_id';
1151:
1152: IF G_DEBUG_LOW THEN
1153: ozf_utility_pvt.write_conc_log('Statement is : ' || l_stmt);
1154: ozf_utility_pvt.write_conc_log('Bind var is : ' || p_product_id);
1155: END IF;
1156:
1157: EXECUTE IMMEDIATE l_stmt INTO l_discount, l_category_id USING p_offer_id, p_product_id, p_org_id;
1158:

Line 1160: ozf_utility_pvt.write_conc_log('Discount : ' || l_discount);

1156:
1157: EXECUTE IMMEDIATE l_stmt INTO l_discount, l_category_id USING p_offer_id, p_product_id, p_org_id;
1158:
1159: IF G_DEBUG_LOW THEN
1160: ozf_utility_pvt.write_conc_log('Discount : ' || l_discount);
1161: ozf_utility_pvt.write_conc_log('Category_Id : ' || l_category_id);
1162: END IF;
1163:
1164: IF ( l_discount IS NOT NULL AND l_category_id IS NOT NULL )

Line 1161: ozf_utility_pvt.write_conc_log('Category_Id : ' || l_category_id);

1157: EXECUTE IMMEDIATE l_stmt INTO l_discount, l_category_id USING p_offer_id, p_product_id, p_org_id;
1158:
1159: IF G_DEBUG_LOW THEN
1160: ozf_utility_pvt.write_conc_log('Discount : ' || l_discount);
1161: ozf_utility_pvt.write_conc_log('Category_Id : ' || l_category_id);
1162: END IF;
1163:
1164: IF ( l_discount IS NOT NULL AND l_category_id IS NOT NULL )
1165: THEN

Line 1174: ozf_utility_pvt.write_conc_log('accrual for order line:'||l_acc_amt_order);

1170: FETCH c_maximum_compensation INTO l_max_compensation;
1171: CLOSE c_maximum_compensation;
1172:
1173: IF G_DEBUG_LOW THEN
1174: ozf_utility_pvt.write_conc_log('accrual for order line:'||l_acc_amt_order);
1175: ozf_utility_pvt.write_conc_log('max compensation:'||l_max_compensation);
1176: END IF;
1177:
1178: FOR i IN c_existing_accruals

Line 1175: ozf_utility_pvt.write_conc_log('max compensation:'||l_max_compensation);

1171: CLOSE c_maximum_compensation;
1172:
1173: IF G_DEBUG_LOW THEN
1174: ozf_utility_pvt.write_conc_log('accrual for order line:'||l_acc_amt_order);
1175: ozf_utility_pvt.write_conc_log('max compensation:'||l_max_compensation);
1176: END IF;
1177:
1178: FOR i IN c_existing_accruals
1179: LOOP

Line 1228: ozf_utility_pvt.write_conc_log('Writing exception log for offer ' || p_act_budgets_rec.act_budget_used_by_id);

1224:
1225: l_na_conc_exception_id NUMBER;
1226: l_pk_exist NUMBER;
1227: BEGIN
1228: ozf_utility_pvt.write_conc_log('Writing exception log for offer ' || p_act_budgets_rec.act_budget_used_by_id);
1229: LOOP
1230: l_pk_exist := NULL;
1231:
1232: OPEN c_na_conc_exception_id;

Line 1323: ozf_utility_pvt.write_conc_log('Processing exception Id = ' || l_exception_rec.na_conc_exception_id);

1319: LOOP
1320: --
1321: IF G_DEBUG_LOW
1322: THEN
1323: ozf_utility_pvt.write_conc_log('Processing exception Id = ' || l_exception_rec.na_conc_exception_id);
1324: END IF;
1325:
1326: l_return_status := FND_API.g_ret_sts_success; -- bug 3655853
1327:

Line 1367: ozf_utility_pvt.write_conc_log('Exception_id - Status: ' || l_exception_rec.na_conc_exception_id

1363: ,x_utilized_amount => l_utilized_amount);
1364:
1365: IF G_DEBUG_LOW
1366: THEN
1367: ozf_utility_pvt.write_conc_log('Exception_id - Status: ' || l_exception_rec.na_conc_exception_id
1368: || ' - '
1369: || l_return_status);
1370: ozf_utility_pvt.write_conc_log('Utilization Amount Created: ' || l_utilized_amount);
1371: END IF;

Line 1370: ozf_utility_pvt.write_conc_log('Utilization Amount Created: ' || l_utilized_amount);

1366: THEN
1367: ozf_utility_pvt.write_conc_log('Exception_id - Status: ' || l_exception_rec.na_conc_exception_id
1368: || ' - '
1369: || l_return_status);
1370: ozf_utility_pvt.write_conc_log('Utilization Amount Created: ' || l_utilized_amount);
1371: END IF;
1372:
1373: IF l_return_status = FND_API.g_ret_sts_success
1374: THEN

Line 1728: ozf_utility_pvt.write_conc_log('-- Start Processing : ' || to_char(sysdate,'MM/DD/YYYY:HH:MM:SS'));

1724: -- initialize multi org
1725: MO_GLOBAL.init('OZF');
1726: MO_GLOBAL.set_policy_context('M',null);
1727:
1728: ozf_utility_pvt.write_conc_log('-- Start Processing : ' || to_char(sysdate,'MM/DD/YYYY:HH:MM:SS'));
1729:
1730: ozf_utility_pvt.write_conc_log('-- Process_Exceptions (+) ');
1731: --
1732: process_exceptions();

Line 1730: ozf_utility_pvt.write_conc_log('-- Process_Exceptions (+) ');

1726: MO_GLOBAL.set_policy_context('M',null);
1727:
1728: ozf_utility_pvt.write_conc_log('-- Start Processing : ' || to_char(sysdate,'MM/DD/YYYY:HH:MM:SS'));
1729:
1730: ozf_utility_pvt.write_conc_log('-- Process_Exceptions (+) ');
1731: --
1732: process_exceptions();
1733: --
1734: ozf_utility_pvt.write_conc_log('-- Process_Exceptions (-) ');

Line 1734: ozf_utility_pvt.write_conc_log('-- Process_Exceptions (-) ');

1730: ozf_utility_pvt.write_conc_log('-- Process_Exceptions (+) ');
1731: --
1732: process_exceptions();
1733: --
1734: ozf_utility_pvt.write_conc_log('-- Process_Exceptions (-) ');
1735: --
1736: l_date_from_input := TRUNC(TO_DATE(p_as_of_date, 'YYYY/MM/DD HH24:MI:SS'));
1737: ozf_utility_pvt.write_conc_log('-- Date Converted : ' || l_date_from_input);
1738:

Line 1737: ozf_utility_pvt.write_conc_log('-- Date Converted : ' || l_date_from_input);

1733: --
1734: ozf_utility_pvt.write_conc_log('-- Process_Exceptions (-) ');
1735: --
1736: l_date_from_input := TRUNC(TO_DATE(p_as_of_date, 'YYYY/MM/DD HH24:MI:SS'));
1737: ozf_utility_pvt.write_conc_log('-- Date Converted : ' || l_date_from_input);
1738:
1739: IF (l_date_from_input IS NULL)
1740: OR
1741: (TRUNC(l_date_from_input) >= TRUNC(SYSDATE))

Line 1757: ozf_utility_pvt.write_conc_log('OZF: Process Net Accrual In Batch Mode: '||l_orig_batch_mode);

1753: THEN
1754: l_orig_batch_mode := 'NO';
1755: END IF;
1756:
1757: ozf_utility_pvt.write_conc_log('OZF: Process Net Accrual In Batch Mode: '||l_orig_batch_mode);
1758: ozf_utility_pvt.write_conc_log('QP: Item Validation Organization: '||l_org_id);
1759:
1760: ozf_utility_pvt.write_conc_log('-- Start Processing Net Accrual Offers (+) ');
1761:

Line 1758: ozf_utility_pvt.write_conc_log('QP: Item Validation Organization: '||l_org_id);

1754: l_orig_batch_mode := 'NO';
1755: END IF;
1756:
1757: ozf_utility_pvt.write_conc_log('OZF: Process Net Accrual In Batch Mode: '||l_orig_batch_mode);
1758: ozf_utility_pvt.write_conc_log('QP: Item Validation Organization: '||l_org_id);
1759:
1760: ozf_utility_pvt.write_conc_log('-- Start Processing Net Accrual Offers (+) ');
1761:
1762: ----------------------------------------------------

Line 1760: ozf_utility_pvt.write_conc_log('-- Start Processing Net Accrual Offers (+) ');

1756:
1757: ozf_utility_pvt.write_conc_log('OZF: Process Net Accrual In Batch Mode: '||l_orig_batch_mode);
1758: ozf_utility_pvt.write_conc_log('QP: Item Validation Organization: '||l_org_id);
1759:
1760: ozf_utility_pvt.write_conc_log('-- Start Processing Net Accrual Offers (+) ');
1761:
1762: ----------------------------------------------------
1763: FOR l_net_accrual_offers IN c_net_accrual_offers
1764: LOOP

Line 1768: ozf_utility_pvt.write_conc_log('-----------------------------------------');

1764: LOOP
1765: --
1766: l_return_status := FND_API.g_ret_sts_success;
1767:
1768: ozf_utility_pvt.write_conc_log('-----------------------------------------');
1769: ozf_utility_pvt.write_conc_log('--');
1770: ozf_utility_pvt.write_conc_log('-------- Processing Offer: '|| l_net_accrual_offers.offer_name);
1771: ozf_utility_pvt.write_conc_log(' Offer_Id / List_Header_Id / Custom_Setup_Id / Orig_Org_Id: '
1772: || l_net_accrual_offers.offer_id || ' / '

Line 1769: ozf_utility_pvt.write_conc_log('--');

1765: --
1766: l_return_status := FND_API.g_ret_sts_success;
1767:
1768: ozf_utility_pvt.write_conc_log('-----------------------------------------');
1769: ozf_utility_pvt.write_conc_log('--');
1770: ozf_utility_pvt.write_conc_log('-------- Processing Offer: '|| l_net_accrual_offers.offer_name);
1771: ozf_utility_pvt.write_conc_log(' Offer_Id / List_Header_Id / Custom_Setup_Id / Orig_Org_Id: '
1772: || l_net_accrual_offers.offer_id || ' / '
1773: || l_net_accrual_offers.qp_list_header_id || ' / '

Line 1770: ozf_utility_pvt.write_conc_log('-------- Processing Offer: '|| l_net_accrual_offers.offer_name);

1766: l_return_status := FND_API.g_ret_sts_success;
1767:
1768: ozf_utility_pvt.write_conc_log('-----------------------------------------');
1769: ozf_utility_pvt.write_conc_log('--');
1770: ozf_utility_pvt.write_conc_log('-------- Processing Offer: '|| l_net_accrual_offers.offer_name);
1771: ozf_utility_pvt.write_conc_log(' Offer_Id / List_Header_Id / Custom_Setup_Id / Orig_Org_Id: '
1772: || l_net_accrual_offers.offer_id || ' / '
1773: || l_net_accrual_offers.qp_list_header_id || ' / '
1774: || l_net_accrual_offers.custom_setup_id || ' / '

Line 1771: ozf_utility_pvt.write_conc_log(' Offer_Id / List_Header_Id / Custom_Setup_Id / Orig_Org_Id: '

1767:
1768: ozf_utility_pvt.write_conc_log('-----------------------------------------');
1769: ozf_utility_pvt.write_conc_log('--');
1770: ozf_utility_pvt.write_conc_log('-------- Processing Offer: '|| l_net_accrual_offers.offer_name);
1771: ozf_utility_pvt.write_conc_log(' Offer_Id / List_Header_Id / Custom_Setup_Id / Orig_Org_Id: '
1772: || l_net_accrual_offers.offer_id || ' / '
1773: || l_net_accrual_offers.qp_list_header_id || ' / '
1774: || l_net_accrual_offers.custom_setup_id || ' / '
1775: || l_net_accrual_offers.orig_org_id );

Line 1776: ozf_utility_pvt.write_conc_log('--');

1772: || l_net_accrual_offers.offer_id || ' / '
1773: || l_net_accrual_offers.qp_list_header_id || ' / '
1774: || l_net_accrual_offers.custom_setup_id || ' / '
1775: || l_net_accrual_offers.orig_org_id );
1776: ozf_utility_pvt.write_conc_log('--');
1777:
1778: -------- Derive Program Start and End Date Range ----------
1779: l_latest_comp_date := l_net_accrual_offers.latest_na_completion_date;
1780: l_start_date := l_net_accrual_offers.start_date_active;

Line 1794: ozf_utility_pvt.write_conc_log('Accrual Start Period: '||to_char(l_start_date,'MM/DD/YY HH:MI:SS AM'));

1790: THEN
1791: l_end_date := l_as_of_date;
1792: END IF;
1793:
1794: ozf_utility_pvt.write_conc_log('Accrual Start Period: '||to_char(l_start_date,'MM/DD/YY HH:MI:SS AM'));
1795: ozf_utility_pvt.write_conc_log('Accrual End Date: ' ||to_char(l_end_date,'MM/DD/YY HH:MI:SS AM'));
1796: ozf_utility_pvt.write_conc_log('Resale Line Processed: ' || l_idsm_line_processed);
1797:
1798: IF l_start_date > l_end_date

Line 1795: ozf_utility_pvt.write_conc_log('Accrual End Date: ' ||to_char(l_end_date,'MM/DD/YY HH:MI:SS AM'));

1791: l_end_date := l_as_of_date;
1792: END IF;
1793:
1794: ozf_utility_pvt.write_conc_log('Accrual Start Period: '||to_char(l_start_date,'MM/DD/YY HH:MI:SS AM'));
1795: ozf_utility_pvt.write_conc_log('Accrual End Date: ' ||to_char(l_end_date,'MM/DD/YY HH:MI:SS AM'));
1796: ozf_utility_pvt.write_conc_log('Resale Line Processed: ' || l_idsm_line_processed);
1797:
1798: IF l_start_date > l_end_date
1799: THEN

Line 1796: ozf_utility_pvt.write_conc_log('Resale Line Processed: ' || l_idsm_line_processed);

1792: END IF;
1793:
1794: ozf_utility_pvt.write_conc_log('Accrual Start Period: '||to_char(l_start_date,'MM/DD/YY HH:MI:SS AM'));
1795: ozf_utility_pvt.write_conc_log('Accrual End Date: ' ||to_char(l_end_date,'MM/DD/YY HH:MI:SS AM'));
1796: ozf_utility_pvt.write_conc_log('Resale Line Processed: ' || l_idsm_line_processed);
1797:
1798: IF l_start_date > l_end_date
1799: THEN
1800: -- This offer has been completely processed. Skip OM, Continue Process IDSM.

Line 1801: ozf_utility_pvt.write_conc_log('This Offer has been completely processed for OM. Skipping to IDSM. ');

1797:
1798: IF l_start_date > l_end_date
1799: THEN
1800: -- This offer has been completely processed. Skip OM, Continue Process IDSM.
1801: ozf_utility_pvt.write_conc_log('This Offer has been completely processed for OM. Skipping to IDSM. ');
1802: GOTO IDSM;
1803: END IF;
1804: --------------------------------------------------------------
1805:

Line 1838: ozf_utility_pvt.write_conc_log('-- No country qualifiers provided for PRM Offer. Not Processing it ..');

1834: THEN
1835: -- No countries defined for a PRM Offer
1836: -- No point processing this offer. Skip it offer
1837: -- If implementation is correct, this will never happen
1838: ozf_utility_pvt.write_conc_log('-- No country qualifiers provided for PRM Offer. Not Processing it ..');
1839: GOTO NEXT_OFFER;
1840: END IF;
1841: --
1842: IF G_DEBUG_LOW

Line 1847: ozf_utility_pvt.write_conc_log('Country Code: '|| l_terr_countries_tbl(c) );

1843: THEN
1844: --
1845: FOR c IN l_terr_countries_tbl.FIRST..l_terr_countries_tbl.LAST
1846: LOOP
1847: ozf_utility_pvt.write_conc_log('Country Code: '|| l_terr_countries_tbl(c) );
1848: END LOOP;
1849: --
1850: END IF;
1851: --

Line 1857: ozf_utility_pvt.write_conc_log('Populate_Customers (+)');

1853: --
1854: -- For all other Offers, populate the ozf_na_customers_temp denom table
1855: --
1856:
1857: ozf_utility_pvt.write_conc_log('Populate_Customers (+)');
1858:
1859: populate_customers(l_net_accrual_offers.offer_id
1860: ,l_return_status
1861: ,l_msg_count

Line 1864: ozf_utility_pvt.write_conc_log('Populate_Customers (-) With Status: ' ||l_return_status);

1860: ,l_return_status
1861: ,l_msg_count
1862: ,l_msg_data);
1863:
1864: ozf_utility_pvt.write_conc_log('Populate_Customers (-) With Status: ' ||l_return_status);
1865:
1866: IF l_return_status = Fnd_Api.g_ret_sts_error
1867: THEN
1868: RAISE Fnd_Api.g_exc_error;

Line 1881: ozf_utility_pvt.write_conc_log('Populate_Prod_Line (+)');

1877: --------------- Denorm Products ----------------------
1878: IF l_net_accrual_offers.tier_level = 'LINE'
1879: THEN
1880: --
1881: ozf_utility_pvt.write_conc_log('Populate_Prod_Line (+)');
1882:
1883: populate_prod_line(l_net_accrual_offers.offer_id
1884: ,l_return_status
1885: ,l_msg_count

Line 1888: ozf_utility_pvt.write_conc_log('Populate_Prod_Line (-) With Status: '||l_return_status);

1884: ,l_return_status
1885: ,l_msg_count
1886: ,l_msg_data);
1887:
1888: ozf_utility_pvt.write_conc_log('Populate_Prod_Line (-) With Status: '||l_return_status);
1889: --
1890: ELSIF l_net_accrual_offers.tier_level = 'HEADER'
1891: THEN
1892: --

Line 1893: ozf_utility_pvt.write_conc_log('Populate_Prod_Tier (+)');

1889: --
1890: ELSIF l_net_accrual_offers.tier_level = 'HEADER'
1891: THEN
1892: --
1893: ozf_utility_pvt.write_conc_log('Populate_Prod_Tier (+)');
1894:
1895: populate_prod_tier(l_net_accrual_offers.offer_id
1896: ,l_return_status
1897: ,l_msg_count

Line 1900: ozf_utility_pvt.write_conc_log('Populate_Prod_Tier (-) With Status: '||l_return_status);

1896: ,l_return_status
1897: ,l_msg_count
1898: ,l_msg_data);
1899:
1900: ozf_utility_pvt.write_conc_log('Populate_Prod_Tier (-) With Status: '||l_return_status);
1901: --
1902: END IF;
1903: ---------------------------------------------------------
1904:

Line 1912: ozf_utility_pvt.write_conc_log('-- Start Processing Orders -- ');

1908: RAISE Fnd_Api.g_exc_unexpected_error;
1909: END IF;
1910:
1911: --------------- Start Processing Orders ------------------------
1912: ozf_utility_pvt.write_conc_log('-- Start Processing Orders -- ');
1913:
1914: --------------- Start Processing OM lines ------------------------
1915: IF l_net_accrual_offers.sales_method_flag IS NULL OR l_net_accrual_offers.sales_method_flag = 'D' THEN
1916: --

Line 1917: ozf_utility_pvt.write_conc_log('Processing OM lines');

1913:
1914: --------------- Start Processing OM lines ------------------------
1915: IF l_net_accrual_offers.sales_method_flag IS NULL OR l_net_accrual_offers.sales_method_flag = 'D' THEN
1916: --
1917: ozf_utility_pvt.write_conc_log('Processing OM lines');
1918: l_order_line_tbl.delete;
1919: l_accrual_amount := 0;
1920:
1921: OPEN c_order_line(l_start_date, l_end_date, l_offer_org_id);

Line 1931: ozf_utility_pvt.write_conc_log('No Data found in c_order_line CURSOR');

1927: -- To handle NO DATA FOUND for c_order_line CURSOR
1928: IF l_order_line_tbl.FIRST IS NULL
1929: THEN
1930: --
1931: ozf_utility_pvt.write_conc_log('No Data found in c_order_line CURSOR');
1932: EXIT;
1933: --
1934: END IF;
1935: --

Line 1948: ozf_utility_pvt.write_conc_log('Order Line_Id: '||l_order_line_tbl(i).line_id);

1944:
1945: l_return_status := FND_API.g_ret_sts_success;
1946:
1947: IF G_DEBUG_LOW THEN
1948: ozf_utility_pvt.write_conc_log('Order Line_Id: '||l_order_line_tbl(i).line_id);
1949: END IF;
1950:
1951: l_line_amount := ( NVL(l_order_line_tbl(i).shipped_quantity,l_order_line_tbl(i).fulfilled_quantity)
1952: * l_order_line_tbl(i).unit_selling_price );

Line 2008: ozf_utility_pvt.write_conc_log('Did Customer qualify: '||l_customer_qualified);

2004: --
2005: END IF; -- Done qualfiying the customer
2006:
2007: IF G_DEBUG_LOW THEN
2008: ozf_utility_pvt.write_conc_log('Did Customer qualify: '||l_customer_qualified);
2009: END IF;
2010:
2011: -- Fetch Currency Code on the Order
2012: l_order_curr_code := l_order_line_tbl(i).transactional_curr_code ;

Line 2013: ozf_utility_pvt.write_conc_log('l_order_curr_code: '|| l_order_curr_code);

2009: END IF;
2010:
2011: -- Fetch Currency Code on the Order
2012: l_order_curr_code := l_order_line_tbl(i).transactional_curr_code ;
2013: ozf_utility_pvt.write_conc_log('l_order_curr_code: '|| l_order_curr_code);
2014: ozf_utility_pvt.write_conc_log('l_net_accrual_offers.fund_request_curr_code: '|| l_net_accrual_offers.fund_request_curr_code);
2015:
2016: IF l_customer_qualified = 'Y'
2017: THEN

Line 2014: ozf_utility_pvt.write_conc_log('l_net_accrual_offers.fund_request_curr_code: '|| l_net_accrual_offers.fund_request_curr_code);

2010:
2011: -- Fetch Currency Code on the Order
2012: l_order_curr_code := l_order_line_tbl(i).transactional_curr_code ;
2013: ozf_utility_pvt.write_conc_log('l_order_curr_code: '|| l_order_curr_code);
2014: ozf_utility_pvt.write_conc_log('l_net_accrual_offers.fund_request_curr_code: '|| l_net_accrual_offers.fund_request_curr_code);
2015:
2016: IF l_customer_qualified = 'Y'
2017: THEN
2018: --

Line 2025: ozf_utility_pvt.write_conc_log('l_order_line_tbl(i).org_id: '|| l_order_line_tbl(i).org_id);

2021: --
2022: l_new_amount := 0;
2023:
2024: --Added for bug 7030415
2025: ozf_utility_pvt.write_conc_log('l_order_line_tbl(i).org_id: '|| l_order_line_tbl(i).org_id);
2026: IF l_batch_mode = 'YES' THEN
2027: OPEN c_get_conversion_type(l_order_line_tbl(i).org_id);
2028: FETCH c_get_conversion_type INTO l_exchange_rate_type;
2029: CLOSE c_get_conversion_type;

Line 2030: ozf_utility_pvt.write_conc_log('l_exchange_rate_type: '|| l_exchange_rate_type);

2026: IF l_batch_mode = 'YES' THEN
2027: OPEN c_get_conversion_type(l_order_line_tbl(i).org_id);
2028: FETCH c_get_conversion_type INTO l_exchange_rate_type;
2029: CLOSE c_get_conversion_type;
2030: ozf_utility_pvt.write_conc_log('l_exchange_rate_type: '|| l_exchange_rate_type);
2031: ozf_utility_pvt.write_conc_log('l_line_amount: '|| l_line_amount);
2032: END IF;
2033:
2034: ozf_utility_pvt.convert_currency(x_return_status => l_return_status

Line 2031: ozf_utility_pvt.write_conc_log('l_line_amount: '|| l_line_amount);

2027: OPEN c_get_conversion_type(l_order_line_tbl(i).org_id);
2028: FETCH c_get_conversion_type INTO l_exchange_rate_type;
2029: CLOSE c_get_conversion_type;
2030: ozf_utility_pvt.write_conc_log('l_exchange_rate_type: '|| l_exchange_rate_type);
2031: ozf_utility_pvt.write_conc_log('l_line_amount: '|| l_line_amount);
2032: END IF;
2033:
2034: ozf_utility_pvt.convert_currency(x_return_status => l_return_status
2035: ,p_from_currency => l_order_curr_code

Line 2034: ozf_utility_pvt.convert_currency(x_return_status => l_return_status

2030: ozf_utility_pvt.write_conc_log('l_exchange_rate_type: '|| l_exchange_rate_type);
2031: ozf_utility_pvt.write_conc_log('l_line_amount: '|| l_line_amount);
2032: END IF;
2033:
2034: ozf_utility_pvt.convert_currency(x_return_status => l_return_status
2035: ,p_from_currency => l_order_curr_code
2036: ,p_to_currency => l_net_accrual_offers.fund_request_curr_code
2037: ,p_conv_type => l_exchange_rate_type
2038: ,p_conv_date => l_order_line_tbl(i).conv_date

Line 2043: ozf_utility_pvt.write_conc_log('l_line_amount converted : '|| l_line_amount);

2039: ,p_from_amount => l_line_amount
2040: ,x_to_amount => l_new_amount
2041: ,x_rate => l_rate);
2042: l_line_amount := l_new_amount;
2043: ozf_utility_pvt.write_conc_log('l_line_amount converted : '|| l_line_amount);
2044:
2045: IF l_return_status = Fnd_Api.g_ret_sts_error
2046: THEN
2047: ozf_utility_pvt.write_conc_log('Exp Error from Convert_Currency: ' || l_return_status);

Line 2047: ozf_utility_pvt.write_conc_log('Exp Error from Convert_Currency: ' || l_return_status);

2043: ozf_utility_pvt.write_conc_log('l_line_amount converted : '|| l_line_amount);
2044:
2045: IF l_return_status = Fnd_Api.g_ret_sts_error
2046: THEN
2047: ozf_utility_pvt.write_conc_log('Exp Error from Convert_Currency: ' || l_return_status);
2048: RAISE Fnd_Api.g_exc_error;
2049: ELSIF l_return_status = Fnd_Api.g_ret_sts_unexp_error
2050: THEN
2051: ozf_utility_pvt.write_conc_log('Unexp Error from Convert_Currency: ' || l_return_status);

Line 2051: ozf_utility_pvt.write_conc_log('Unexp Error from Convert_Currency: ' || l_return_status);

2047: ozf_utility_pvt.write_conc_log('Exp Error from Convert_Currency: ' || l_return_status);
2048: RAISE Fnd_Api.g_exc_error;
2049: ELSIF l_return_status = Fnd_Api.g_ret_sts_unexp_error
2050: THEN
2051: ozf_utility_pvt.write_conc_log('Unexp Error from Convert_Currency: ' || l_return_status);
2052: RAISE Fnd_Api.g_exc_unexpected_error;
2053: END IF;
2054: --
2055: END IF;

Line 2062: ozf_utility_pvt.write_conc_log('Pv_Referral_Comp_Pub.Get_Beneficiary (+)');

2058: IF l_net_accrual_offers.custom_setup_id = 105
2059: THEN
2060: --
2061: IF G_DEBUG_LOW THEN
2062: ozf_utility_pvt.write_conc_log('Pv_Referral_Comp_Pub.Get_Beneficiary (+)');
2063: END IF;
2064: pv_referral_comp_pub.get_beneficiary (p_api_version => 1.0,
2065: p_init_msg_list => FND_API.g_true,
2066: p_commit => FND_API.g_false,

Line 2077: ozf_utility_pvt.write_conc_log('Pv_Referral_Comp_Pub.Get_Beneficiary (-) With Status: '||l_return_status);

2073: x_return_status => l_return_status,
2074: x_msg_count => l_msg_count,
2075: x_msg_data => l_msg_data);
2076: IF G_DEBUG_LOW THEN
2077: ozf_utility_pvt.write_conc_log('Pv_Referral_Comp_Pub.Get_Beneficiary (-) With Status: '||l_return_status);
2078: ozf_utility_pvt.write_conc_log('l_benificiary_id / l_referral_id: '||l_beneficiary_id || ' / ' || l_referral_id);
2079: END IF;
2080:
2081: IF l_return_status = Fnd_Api.g_ret_sts_error

Line 2078: ozf_utility_pvt.write_conc_log('l_benificiary_id / l_referral_id: '||l_beneficiary_id || ' / ' || l_referral_id);

2074: x_msg_count => l_msg_count,
2075: x_msg_data => l_msg_data);
2076: IF G_DEBUG_LOW THEN
2077: ozf_utility_pvt.write_conc_log('Pv_Referral_Comp_Pub.Get_Beneficiary (-) With Status: '||l_return_status);
2078: ozf_utility_pvt.write_conc_log('l_benificiary_id / l_referral_id: '||l_beneficiary_id || ' / ' || l_referral_id);
2079: END IF;
2080:
2081: IF l_return_status = Fnd_Api.g_ret_sts_error
2082: THEN

Line 2083: ozf_utility_pvt.write_conc_log('Exp Error from Get_Beneficiary: ' || l_return_status);

2079: END IF;
2080:
2081: IF l_return_status = Fnd_Api.g_ret_sts_error
2082: THEN
2083: ozf_utility_pvt.write_conc_log('Exp Error from Get_Beneficiary: ' || l_return_status);
2084: RAISE Fnd_Api.g_exc_error;
2085: ELSIF l_return_status = Fnd_Api.g_ret_sts_unexp_error
2086: THEN
2087: ozf_utility_pvt.write_conc_log('Unexp Error from Get_Beneficiary: ' || l_return_status);

Line 2087: ozf_utility_pvt.write_conc_log('Unexp Error from Get_Beneficiary: ' || l_return_status);

2083: ozf_utility_pvt.write_conc_log('Exp Error from Get_Beneficiary: ' || l_return_status);
2084: RAISE Fnd_Api.g_exc_error;
2085: ELSIF l_return_status = Fnd_Api.g_ret_sts_unexp_error
2086: THEN
2087: ozf_utility_pvt.write_conc_log('Unexp Error from Get_Beneficiary: ' || l_return_status);
2088: RAISE Fnd_Api.g_exc_unexpected_error;
2089: END IF;
2090: --
2091:

Line 2096: ozf_utility_pvt.write_conc_log('Get_Pv_Accrual_Amount (+)');

2092: IF ( l_beneficiary_id IS NOT NULL )
2093: THEN
2094: --------------------------- Derive Accrual Amount -------------------------
2095: IF G_DEBUG_LOW THEN
2096: ozf_utility_pvt.write_conc_log('Get_Pv_Accrual_Amount (+)');
2097: END IF;
2098:
2099: l_line_acc_amount := get_pv_accrual_amount(p_product_id => l_order_line_tbl(i).inventory_item_id
2100: ,p_line_amt => l_line_amount

Line 2107: ozf_utility_pvt.write_conc_log('Get_Pv_Accrual_Amount (-) With l_line_acc_amount: '|| l_line_acc_amount);

2103: ,p_list_hdr_id => l_net_accrual_offers.qp_list_header_id
2104: ,p_referral_id => l_referral_id
2105: ,p_order_hdr_id => l_order_line_tbl(i).header_id);
2106: IF G_DEBUG_LOW THEN
2107: ozf_utility_pvt.write_conc_log('Get_Pv_Accrual_Amount (-) With l_line_acc_amount: '|| l_line_acc_amount);
2108: END IF;
2109: --
2110: ELSE
2111: --

Line 2112: ozf_utility_pvt.write_conc_log('No Beneficiary derived from PV_Referral_Comp_Pub. Utilization will not be created');

2108: END IF;
2109: --
2110: ELSE
2111: --
2112: ozf_utility_pvt.write_conc_log('No Beneficiary derived from PV_Referral_Comp_Pub. Utilization will not be created');
2113: --
2114: END IF;
2115: --
2116: l_utilization_type := 'LEAD_ACCRUAL';

Line 2123: ozf_utility_pvt.write_conc_log('Get_Accrualed_Amount (+)');

2119: ELSE
2120: --
2121: --------------------------- Derive Accrual Amount -------------------------
2122: -- IF G_DEBUG_LOW THEN
2123: ozf_utility_pvt.write_conc_log('Get_Accrualed_Amount (+)');
2124: -- END IF;
2125: l_line_acc_amount := get_accrualed_amount(p_product_id => l_order_line_tbl(i).inventory_item_id
2126: ,p_line_amt => l_line_amount
2127: ,p_quantity => l_order_line_tbl(i).pricing_quantity

Line 2130: ozf_utility_pvt.write_conc_log('Get_Accrualed_Amount (-) With l_line_acc_amount: '|| l_line_acc_amount);

2126: ,p_line_amt => l_line_amount
2127: ,p_quantity => l_order_line_tbl(i).pricing_quantity
2128: ,p_uom => l_order_line_tbl(i).pricing_quantity_uom);
2129: -- IF G_DEBUG_LOW THEN
2130: ozf_utility_pvt.write_conc_log('Get_Accrualed_Amount (-) With l_line_acc_amount: '|| l_line_acc_amount);
2131: -- END IF;
2132: --
2133:
2134: --

Line 2167: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id);

2163: l_act_budgets_rec.status_code := 'APPROVED';
2164: l_act_budgets_rec.approved_amount := l_line_acc_amount;
2165: l_act_budgets_rec.approved_in_currency := l_net_accrual_offers.fund_request_curr_code;
2166: l_act_budgets_rec.approval_date := SYSDATE;
2167: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id);
2168: l_act_budgets_rec.justification := 'NA: ' || TO_CHAR(SYSDATE, 'MM/DD/YYYY');
2169: l_act_budgets_rec.transfer_type := 'UTILIZED';
2170: l_act_budgets_rec.requester_id := l_net_accrual_offers.owner_id;
2171:

Line 2199: ozf_utility_pvt.write_conc_log('Req Curr/Req Amt/Util Amt: ' || l_act_budgets_rec.request_currency || '/' || l_act_budgets_rec.request_amount || '/' || l_utilized_amount);

2195: ,x_act_budget_id => l_act_budget_id
2196: ,x_utilized_amount => l_utilized_amount);
2197: --
2198: IF G_DEBUG_LOW THEN
2199: ozf_utility_pvt.write_conc_log('Req Curr/Req Amt/Util Amt: ' || l_act_budgets_rec.request_currency || '/' || l_act_budgets_rec.request_amount || '/' || l_utilized_amount);
2200: END IF;
2201:
2202: IF l_return_status = Fnd_Api.g_ret_sts_error
2203: THEN

Line 2204: ozf_utility_pvt.write_conc_log('Exp Error: Process_Act_Budgets: line_id ( '||l_order_line_tbl(i).line_id

2200: END IF;
2201:
2202: IF l_return_status = Fnd_Api.g_ret_sts_error
2203: THEN
2204: ozf_utility_pvt.write_conc_log('Exp Error: Process_Act_Budgets: line_id ( '||l_order_line_tbl(i).line_id
2205: || ' ) Error: '||l_msg_data);
2206: log_exception(l_act_budgets_rec, l_act_util_rec);
2207: ELSIF l_return_status = Fnd_Api.g_ret_sts_unexp_error
2208: THEN

Line 2209: ozf_utility_pvt.write_conc_log('UnExp Error: Process_Act_Budgets: line_id ( '||l_order_line_tbl(i).line_id

2205: || ' ) Error: '||l_msg_data);
2206: log_exception(l_act_budgets_rec, l_act_util_rec);
2207: ELSIF l_return_status = Fnd_Api.g_ret_sts_unexp_error
2208: THEN
2209: ozf_utility_pvt.write_conc_log('UnExp Error: Process_Act_Budgets: line_id ( '||l_order_line_tbl(i).line_id
2210: || ' ) Error: '||l_msg_data);
2211: log_exception(l_act_budgets_rec, l_act_util_rec);
2212: END IF;
2213:

Line 2273: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id);

2269: l_act_budgets_rec.status_code := 'APPROVED';
2270: l_act_budgets_rec.approved_amount := l_accrual_amount;
2271: l_act_budgets_rec.approved_in_currency := l_net_accrual_offers.fund_request_curr_code;
2272: l_act_budgets_rec.approval_date := SYSDATE;
2273: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id);
2274: l_act_budgets_rec.justification := 'NA: ' || TO_CHAR(SYSDATE, 'MM/DD/YYYY');
2275: l_act_budgets_rec.transfer_type := 'UTILIZED';
2276: l_act_budgets_rec.requester_id := l_net_accrual_offers.owner_id;
2277:

Line 2294: ozf_utility_pvt.write_conc_log('Req Curr/Req Amt/Util Amt: ' || l_act_budgets_rec.request_currency || '/' || l_act_budgets_rec.request_amount || '/' || l_utilized_amount);

2290: ,x_act_budget_id => l_act_budget_id
2291: ,x_utilized_amount => l_utilized_amount);
2292:
2293: IF G_DEBUG_LOW THEN
2294: ozf_utility_pvt.write_conc_log('Req Curr/Req Amt/Util Amt: ' || l_act_budgets_rec.request_currency || '/' || l_act_budgets_rec.request_amount || '/' || l_utilized_amount);
2295: END IF;
2296:
2297: IF l_return_status = Fnd_Api.g_ret_sts_error
2298: THEN

Line 2299: ozf_utility_pvt.write_conc_log('Exp Error: Process_Act_Budgets Error: '||l_msg_data );

2295: END IF;
2296:
2297: IF l_return_status = Fnd_Api.g_ret_sts_error
2298: THEN
2299: ozf_utility_pvt.write_conc_log('Exp Error: Process_Act_Budgets Error: '||l_msg_data );
2300: log_exception(l_act_budgets_rec, l_act_util_rec);
2301: ELSIF l_return_status = Fnd_Api.g_ret_sts_unexp_error
2302: THEN
2303: ozf_utility_pvt.write_conc_log('UnExp Error: Process_Act_Budgets Error: '||l_msg_data );

Line 2303: ozf_utility_pvt.write_conc_log('UnExp Error: Process_Act_Budgets Error: '||l_msg_data );

2299: ozf_utility_pvt.write_conc_log('Exp Error: Process_Act_Budgets Error: '||l_msg_data );
2300: log_exception(l_act_budgets_rec, l_act_util_rec);
2301: ELSIF l_return_status = Fnd_Api.g_ret_sts_unexp_error
2302: THEN
2303: ozf_utility_pvt.write_conc_log('UnExp Error: Process_Act_Budgets Error: '||l_msg_data );
2304: log_exception(l_act_budgets_rec, l_act_util_rec);
2305: END IF;
2306:
2307: l_utilized_amount := 0;

Line 2319: ozf_utility_pvt.write_conc_log('-- Done Processing Orders -- ');

2315: END IF; -- end l_batch_mode = 'YES'
2316: --
2317: END IF; -- End OM lines
2318:
2319: ozf_utility_pvt.write_conc_log('-- Done Processing Orders -- ');
2320:
2321: --------------- Done Processing Orders ------------------------
2322:
2323: ozf_utility_pvt.write_conc_log('-- Start Processing Deduction Rules -- ');

Line 2323: ozf_utility_pvt.write_conc_log('-- Start Processing Deduction Rules -- ');

2319: ozf_utility_pvt.write_conc_log('-- Done Processing Orders -- ');
2320:
2321: --------------- Done Processing Orders ------------------------
2322:
2323: ozf_utility_pvt.write_conc_log('-- Start Processing Deduction Rules -- ');
2324:
2325: FOR l_na_rule_line IN c_na_rule_lines(l_net_accrual_offers.na_rule_header_id)
2326: LOOP
2327: --

Line 2334: ozf_utility_pvt.write_conc_log('Name / Type / Id / Org : '||

2330: OPEN c_na_deduction_rule(l_na_rule_line.na_deduction_rule_id);
2331: FETCH c_na_deduction_rule INTO l_na_deduction_rule;
2332: CLOSE c_na_deduction_rule;
2333:
2334: ozf_utility_pvt.write_conc_log('Name / Type / Id / Org : '||
2335: l_na_deduction_rule.name || ' / ' ||
2336: l_na_deduction_rule.transaction_type_code || ' / ' ||
2337: l_na_deduction_rule.deduction_identifier_id || ' / ' ||
2338: l_na_deduction_rule.deduction_identifier_org_id );

Line 2373: ozf_utility_pvt.write_conc_log('No Data found in c_ar_trx_line_details CURSOR');

2369: -- To handle NO DATA FOUND for c_ar_trx_line CURSOR
2370: IF l_ar_trx_line_tbl.FIRST IS NULL
2371: THEN
2372: --
2373: ozf_utility_pvt.write_conc_log('No Data found in c_ar_trx_line_details CURSOR');
2374: EXIT;
2375: --
2376: END IF;
2377: -- Exit after finishing processing is before END LOOP

Line 2387: ozf_utility_pvt.write_conc_log('Cust_Trx_Line_Id / Customer Qualifier ? : ' ||

2383: l_customer_qualified := validate_customer(l_ar_trx_line_tbl(i).bill_to_site_use_id,
2384: l_ar_trx_line_tbl(i).ship_to_site_use_id,
2385: l_ar_trx_line_tbl(i).sold_to_customer_id);
2386:
2387: ozf_utility_pvt.write_conc_log('Cust_Trx_Line_Id / Customer Qualifier ? : ' ||
2388: l_ar_trx_line_tbl(i).customer_trx_line_id || '/' ||l_customer_qualified );
2389:
2390: IF l_customer_qualified = 'Y'
2391: THEN

Line 2406: ozf_utility_pvt.convert_currency(

2402: --only those records are picked for which the org_id=l_na_deduction_rule.deduction_identifier_org_id
2403: OPEN c_get_conversion_type(l_na_deduction_rule.deduction_identifier_org_id);
2404: FETCH c_get_conversion_type INTO l_exchange_rate_type;
2405: CLOSE c_get_conversion_type;
2406: ozf_utility_pvt.convert_currency(
2407: x_return_status => l_return_status
2408: ,p_from_currency => l_ar_trx_line_tbl(i).invoice_currency_code
2409: ,p_to_currency => l_net_accrual_offers.fund_request_curr_code
2410: ,p_conv_type => l_exchange_rate_type

Line 2419: ozf_utility_pvt.write_conc_log('Convert currency ' || l_return_status);

2415: l_ar_trx_line_tbl(i).extended_amount := l_new_amount;
2416:
2417: IF l_return_status = Fnd_Api.g_ret_sts_error
2418: THEN
2419: ozf_utility_pvt.write_conc_log('Convert currency ' || l_return_status);
2420: RAISE Fnd_Api.g_exc_error;
2421: ELSIF l_return_status = Fnd_Api.g_ret_sts_unexp_error
2422: THEN
2423: ozf_utility_pvt.write_conc_log('Convert currency ' || l_return_status);

Line 2423: ozf_utility_pvt.write_conc_log('Convert currency ' || l_return_status);

2419: ozf_utility_pvt.write_conc_log('Convert currency ' || l_return_status);
2420: RAISE Fnd_Api.g_exc_error;
2421: ELSIF l_return_status = Fnd_Api.g_ret_sts_unexp_error
2422: THEN
2423: ozf_utility_pvt.write_conc_log('Convert currency ' || l_return_status);
2424: RAISE Fnd_Api.g_exc_unexpected_error;
2425: END IF;
2426: --
2427: END IF;

Line 2452: ozf_utility_pvt.write_conc_log('Sign of the Credit Memo : '||l_sign);

2448: END IF;
2449:
2450: IF G_DEBUG_LOW
2451: THEN
2452: ozf_utility_pvt.write_conc_log('Sign of the Credit Memo : '||l_sign);
2453: ozf_utility_pvt.write_conc_log('quantity_credited : '||l_ar_trx_line_tbl(i).quantity_credited );
2454: END IF;
2455:
2456: -- Always send positive values for calculation

Line 2453: ozf_utility_pvt.write_conc_log('quantity_credited : '||l_ar_trx_line_tbl(i).quantity_credited );

2449:
2450: IF G_DEBUG_LOW
2451: THEN
2452: ozf_utility_pvt.write_conc_log('Sign of the Credit Memo : '||l_sign);
2453: ozf_utility_pvt.write_conc_log('quantity_credited : '||l_ar_trx_line_tbl(i).quantity_credited );
2454: END IF;
2455:
2456: -- Always send positive values for calculation
2457: l_ar_dedu_line_amt := get_accrualed_amount(

Line 2484: ozf_utility_pvt.write_conc_log('l_ar_dedu_line_amt (A) : '||l_ar_dedu_line_amt);

2480: -- l_existing_util_amt will return as 0 if no utilziations already exist
2481: -- since the cursor c_get_util_amt has a NVL
2482:
2483: IF G_DEBUG_LOW THEN
2484: ozf_utility_pvt.write_conc_log('l_ar_dedu_line_amt (A) : '||l_ar_dedu_line_amt);
2485: ozf_utility_pvt.write_conc_log('l_existing_util_amt (B) : '||l_existing_util_amt);
2486: ozf_utility_pvt.write_conc_log('(A) - (B) : '|| (l_ar_dedu_line_amt - l_existing_util_amt));
2487: END IF;
2488:

Line 2485: ozf_utility_pvt.write_conc_log('l_existing_util_amt (B) : '||l_existing_util_amt);

2481: -- since the cursor c_get_util_amt has a NVL
2482:
2483: IF G_DEBUG_LOW THEN
2484: ozf_utility_pvt.write_conc_log('l_ar_dedu_line_amt (A) : '||l_ar_dedu_line_amt);
2485: ozf_utility_pvt.write_conc_log('l_existing_util_amt (B) : '||l_existing_util_amt);
2486: ozf_utility_pvt.write_conc_log('(A) - (B) : '|| (l_ar_dedu_line_amt - l_existing_util_amt));
2487: END IF;
2488:
2489: -- If utilizations do not exist l_existing_util_amt will be 0

Line 2486: ozf_utility_pvt.write_conc_log('(A) - (B) : '|| (l_ar_dedu_line_amt - l_existing_util_amt));

2482:
2483: IF G_DEBUG_LOW THEN
2484: ozf_utility_pvt.write_conc_log('l_ar_dedu_line_amt (A) : '||l_ar_dedu_line_amt);
2485: ozf_utility_pvt.write_conc_log('l_existing_util_amt (B) : '||l_existing_util_amt);
2486: ozf_utility_pvt.write_conc_log('(A) - (B) : '|| (l_ar_dedu_line_amt - l_existing_util_amt));
2487: END IF;
2488:
2489: -- If utilizations do not exist l_existing_util_amt will be 0
2490: -- A - B will be = A

Line 2509: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id);

2505: l_act_budgets_rec.status_code := 'APPROVED';
2506: l_act_budgets_rec.approved_amount := l_ar_dedu_line_amt;
2507: l_act_budgets_rec.approved_in_currency := l_net_accrual_offers.fund_request_curr_code;
2508: l_act_budgets_rec.approval_date := SYSDATE;
2509: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id);
2510: l_act_budgets_rec.justification := 'NA: AR DEDUCTION' || TO_CHAR(SYSDATE, 'MM/DD/YYYY');
2511: l_act_budgets_rec.transfer_type := 'UTILIZED';
2512: l_act_budgets_rec.requester_id := l_net_accrual_offers.owner_id;
2513:

Line 2539: ozf_utility_pvt.write_conc_log('Req Curr/Req Amt/Util Amt: ' || l_act_budgets_rec.request_currency || '/' || l_act_budgets_rec.request_amount || '/' || l_utilized_amount);

2535: ,x_act_budget_id => l_act_budget_id
2536: ,x_utilized_amount => l_utilized_amount);
2537:
2538: IF G_DEBUG_LOW THEN
2539: ozf_utility_pvt.write_conc_log('Req Curr/Req Amt/Util Amt: ' || l_act_budgets_rec.request_currency || '/' || l_act_budgets_rec.request_amount || '/' || l_utilized_amount);
2540: END IF;
2541:
2542: l_utilized_amount := 0;
2543:

Line 2546: ozf_utility_pvt.write_conc_log('Msg from Budget API: '||l_msg_data);

2542: l_utilized_amount := 0;
2543:
2544: IF l_return_status = Fnd_Api.g_ret_sts_error
2545: THEN
2546: ozf_utility_pvt.write_conc_log('Msg from Budget API: '||l_msg_data);
2547: log_exception(l_act_budgets_rec, l_act_util_rec);
2548: ELSIF l_return_status = Fnd_Api.g_ret_sts_unexp_error
2549: THEN
2550: ozf_utility_pvt.write_conc_log('Msg from Budget API: '||l_msg_data);

Line 2550: ozf_utility_pvt.write_conc_log('Msg from Budget API: '||l_msg_data);

2546: ozf_utility_pvt.write_conc_log('Msg from Budget API: '||l_msg_data);
2547: log_exception(l_act_budgets_rec, l_act_util_rec);
2548: ELSIF l_return_status = Fnd_Api.g_ret_sts_unexp_error
2549: THEN
2550: ozf_utility_pvt.write_conc_log('Msg from Budget API: '||l_msg_data);
2551: log_exception(l_act_budgets_rec, l_act_util_rec);
2552: END IF;
2553: --
2554: END IF; -- End Amount <> 0

Line 2592: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id);

2588: l_act_budgets_rec.status_code := 'APPROVED';
2589: l_act_budgets_rec.approved_amount := l_ar_dedu_amount;
2590: l_act_budgets_rec.approved_in_currency := l_net_accrual_offers.fund_request_curr_code;
2591: l_act_budgets_rec.approval_date := SYSDATE;
2592: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id);
2593: l_act_budgets_rec.justification := 'NA: AR DEDUCTION' || TO_CHAR(SYSDATE, 'MM/DD/YYYY');
2594: l_act_budgets_rec.transfer_type := 'UTILIZED';
2595: l_act_budgets_rec.requester_id := l_net_accrual_offers.owner_id;
2596:

Line 2603: ozf_utility_pvt.write_conc_log('Accrual log: AR Deduction BATCH_MODE = Y');

2599: l_act_util_rec.adjustment_date := SYSDATE;
2600: l_act_util_rec.gl_date := SYSDATE;
2601:
2602: IF G_DEBUG_LOW THEN
2603: ozf_utility_pvt.write_conc_log('Accrual log: AR Deduction BATCH_MODE = Y');
2604: ozf_utility_pvt.write_conc_log('Offer PK: '||l_net_accrual_offers.qp_list_header_id);
2605: ozf_utility_pvt.write_conc_log('Custom Setup Id: '||l_net_accrual_offers.custom_setup_id);
2606: ozf_utility_pvt.write_conc_log('Deduction Curr Code: '||l_net_accrual_offers.fund_request_curr_code);
2607: ozf_utility_pvt.write_conc_log('Deduction Amount: '||l_act_budgets_rec.request_amount);

Line 2604: ozf_utility_pvt.write_conc_log('Offer PK: '||l_net_accrual_offers.qp_list_header_id);

2600: l_act_util_rec.gl_date := SYSDATE;
2601:
2602: IF G_DEBUG_LOW THEN
2603: ozf_utility_pvt.write_conc_log('Accrual log: AR Deduction BATCH_MODE = Y');
2604: ozf_utility_pvt.write_conc_log('Offer PK: '||l_net_accrual_offers.qp_list_header_id);
2605: ozf_utility_pvt.write_conc_log('Custom Setup Id: '||l_net_accrual_offers.custom_setup_id);
2606: ozf_utility_pvt.write_conc_log('Deduction Curr Code: '||l_net_accrual_offers.fund_request_curr_code);
2607: ozf_utility_pvt.write_conc_log('Deduction Amount: '||l_act_budgets_rec.request_amount);
2608: ozf_utility_pvt.write_conc_log('Cust Acct Id: '||l_act_util_rec.cust_account_id);

Line 2605: ozf_utility_pvt.write_conc_log('Custom Setup Id: '||l_net_accrual_offers.custom_setup_id);

2601:
2602: IF G_DEBUG_LOW THEN
2603: ozf_utility_pvt.write_conc_log('Accrual log: AR Deduction BATCH_MODE = Y');
2604: ozf_utility_pvt.write_conc_log('Offer PK: '||l_net_accrual_offers.qp_list_header_id);
2605: ozf_utility_pvt.write_conc_log('Custom Setup Id: '||l_net_accrual_offers.custom_setup_id);
2606: ozf_utility_pvt.write_conc_log('Deduction Curr Code: '||l_net_accrual_offers.fund_request_curr_code);
2607: ozf_utility_pvt.write_conc_log('Deduction Amount: '||l_act_budgets_rec.request_amount);
2608: ozf_utility_pvt.write_conc_log('Cust Acct Id: '||l_act_util_rec.cust_account_id);
2609: END IF;

Line 2606: ozf_utility_pvt.write_conc_log('Deduction Curr Code: '||l_net_accrual_offers.fund_request_curr_code);

2602: IF G_DEBUG_LOW THEN
2603: ozf_utility_pvt.write_conc_log('Accrual log: AR Deduction BATCH_MODE = Y');
2604: ozf_utility_pvt.write_conc_log('Offer PK: '||l_net_accrual_offers.qp_list_header_id);
2605: ozf_utility_pvt.write_conc_log('Custom Setup Id: '||l_net_accrual_offers.custom_setup_id);
2606: ozf_utility_pvt.write_conc_log('Deduction Curr Code: '||l_net_accrual_offers.fund_request_curr_code);
2607: ozf_utility_pvt.write_conc_log('Deduction Amount: '||l_act_budgets_rec.request_amount);
2608: ozf_utility_pvt.write_conc_log('Cust Acct Id: '||l_act_util_rec.cust_account_id);
2609: END IF;
2610:

Line 2607: ozf_utility_pvt.write_conc_log('Deduction Amount: '||l_act_budgets_rec.request_amount);

2603: ozf_utility_pvt.write_conc_log('Accrual log: AR Deduction BATCH_MODE = Y');
2604: ozf_utility_pvt.write_conc_log('Offer PK: '||l_net_accrual_offers.qp_list_header_id);
2605: ozf_utility_pvt.write_conc_log('Custom Setup Id: '||l_net_accrual_offers.custom_setup_id);
2606: ozf_utility_pvt.write_conc_log('Deduction Curr Code: '||l_net_accrual_offers.fund_request_curr_code);
2607: ozf_utility_pvt.write_conc_log('Deduction Amount: '||l_act_budgets_rec.request_amount);
2608: ozf_utility_pvt.write_conc_log('Cust Acct Id: '||l_act_util_rec.cust_account_id);
2609: END IF;
2610:
2611: ozf_fund_adjustment_pvt.process_act_budgets(

Line 2608: ozf_utility_pvt.write_conc_log('Cust Acct Id: '||l_act_util_rec.cust_account_id);

2604: ozf_utility_pvt.write_conc_log('Offer PK: '||l_net_accrual_offers.qp_list_header_id);
2605: ozf_utility_pvt.write_conc_log('Custom Setup Id: '||l_net_accrual_offers.custom_setup_id);
2606: ozf_utility_pvt.write_conc_log('Deduction Curr Code: '||l_net_accrual_offers.fund_request_curr_code);
2607: ozf_utility_pvt.write_conc_log('Deduction Amount: '||l_act_budgets_rec.request_amount);
2608: ozf_utility_pvt.write_conc_log('Cust Acct Id: '||l_act_util_rec.cust_account_id);
2609: END IF;
2610:
2611: ozf_fund_adjustment_pvt.process_act_budgets(
2612: x_return_status => l_return_status

Line 2621: ozf_utility_pvt.write_conc_log('Req Curr/Req Amt/Util Amt: ' || l_act_budgets_rec.request_currency || '/' || l_act_budgets_rec.request_amount || '/' || l_utilized_amount);

2617: ,x_act_budget_id => l_act_budget_id
2618: ,x_utilized_amount => l_utilized_amount);
2619:
2620: IF G_DEBUG_LOW THEN
2621: ozf_utility_pvt.write_conc_log('Req Curr/Req Amt/Util Amt: ' || l_act_budgets_rec.request_currency || '/' || l_act_budgets_rec.request_amount || '/' || l_utilized_amount);
2622: END IF;
2623:
2624: l_utilized_amount := 0;
2625:

Line 2659: ozf_utility_pvt.write_conc_log('No Data found in c_return_line CURSOR');

2655: -- To handle NO DATA FOUND for c_return_line CURSOR
2656: IF l_return_line_tbl.FIRST IS NULL
2657: THEN
2658: --
2659: ozf_utility_pvt.write_conc_log('No Data found in c_return_line CURSOR');
2660: EXIT;
2661: --
2662: END IF;
2663: --

Line 2740: ozf_utility_pvt.convert_currency(

2736: OPEN c_get_conversion_type(l_return_line_tbl(i).org_id);
2737: FETCH c_get_conversion_type INTO l_exchange_rate_type;
2738: CLOSE c_get_conversion_type;
2739:
2740: ozf_utility_pvt.convert_currency(
2741: x_return_status => l_return_status
2742: ,p_from_currency => l_order_curr_code
2743: ,p_to_currency => l_net_accrual_offers.fund_request_curr_code
2744: ,p_conv_type => l_exchange_rate_type

Line 2753: ozf_utility_pvt.write_conc_log('Convert currency ' || l_return_status);

2749: l_line_amount := l_new_amount;
2750:
2751: IF l_return_status = Fnd_Api.g_ret_sts_error
2752: THEN
2753: ozf_utility_pvt.write_conc_log('Convert currency ' || l_return_status);
2754: RAISE Fnd_Api.g_exc_error;
2755: ELSIF l_return_status = Fnd_Api.g_ret_sts_unexp_error
2756: THEN
2757: ozf_utility_pvt.write_conc_log('Convert currency ' || l_return_status);

Line 2757: ozf_utility_pvt.write_conc_log('Convert currency ' || l_return_status);

2753: ozf_utility_pvt.write_conc_log('Convert currency ' || l_return_status);
2754: RAISE Fnd_Api.g_exc_error;
2755: ELSIF l_return_status = Fnd_Api.g_ret_sts_unexp_error
2756: THEN
2757: ozf_utility_pvt.write_conc_log('Convert currency ' || l_return_status);
2758: RAISE Fnd_Api.g_exc_unexpected_error;
2759: END IF;
2760: --
2761: END IF;

Line 2817: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id);

2813: l_act_budgets_rec.status_code := 'APPROVED';
2814: l_act_budgets_rec.approved_amount := l_om_dedu_line_amt;
2815: l_act_budgets_rec.approved_in_currency := l_net_accrual_offers.fund_request_curr_code;
2816: l_act_budgets_rec.approval_date := SYSDATE;
2817: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id);
2818: l_act_budgets_rec.justification := 'NA: OM Deduction' || TO_CHAR(SYSDATE, 'MON-DD-YYYY');
2819: l_act_budgets_rec.transfer_type := 'UTILIZED';
2820: l_act_budgets_rec.requester_id := l_net_accrual_offers.owner_id;
2821:

Line 2849: ozf_utility_pvt.write_conc_log('Req Curr/Req Amt/Util Amt: ' || l_act_budgets_rec.request_currency || '/' || l_act_budgets_rec.request_amount || '/' || l_utilized_amount);

2845: ,x_act_budget_id => l_act_budget_id
2846: ,x_utilized_amount => l_utilized_amount);
2847:
2848: IF G_DEBUG_LOW THEN
2849: ozf_utility_pvt.write_conc_log('Req Curr/Req Amt/Util Amt: ' || l_act_budgets_rec.request_currency || '/' || l_act_budgets_rec.request_amount || '/' || l_utilized_amount);
2850: END IF;
2851:
2852: l_utilized_amount := 0;
2853:

Line 2855: ozf_utility_pvt.write_conc_log('Msg from Budget API: '||l_msg_data);

2851:
2852: l_utilized_amount := 0;
2853:
2854: IF l_return_status = Fnd_Api.g_ret_sts_error THEN
2855: ozf_utility_pvt.write_conc_log('Msg from Budget API: '||l_msg_data);
2856: log_exception(l_act_budgets_rec, l_act_util_rec);
2857: ELSIF l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
2858: ozf_utility_pvt.write_conc_log('Msg from Budget API: '||l_msg_data);
2859: log_exception(l_act_budgets_rec, l_act_util_rec);

Line 2858: ozf_utility_pvt.write_conc_log('Msg from Budget API: '||l_msg_data);

2854: IF l_return_status = Fnd_Api.g_ret_sts_error THEN
2855: ozf_utility_pvt.write_conc_log('Msg from Budget API: '||l_msg_data);
2856: log_exception(l_act_budgets_rec, l_act_util_rec);
2857: ELSIF l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
2858: ozf_utility_pvt.write_conc_log('Msg from Budget API: '||l_msg_data);
2859: log_exception(l_act_budgets_rec, l_act_util_rec);
2860: END IF;
2861: --
2862: END IF; -- end amount <> 0

Line 2903: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id);

2899: l_act_budgets_rec.status_code := 'APPROVED';
2900: l_act_budgets_rec.approved_amount := l_om_dedu_amount;
2901: l_act_budgets_rec.approved_in_currency := l_net_accrual_offers.fund_request_curr_code;
2902: l_act_budgets_rec.approval_date := SYSDATE;
2903: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id);
2904: l_act_budgets_rec.justification := 'NA: ' || TO_CHAR(SYSDATE, 'MON-DD-YYYY');
2905: l_act_budgets_rec.transfer_type := 'UTILIZED';
2906: l_act_budgets_rec.requester_id := l_net_accrual_offers.owner_id;
2907:

Line 2923: ozf_utility_pvt.write_conc_log('Req Curr/Req Amt/Util Amt: ' || l_act_budgets_rec.request_currency || '/' || l_act_budgets_rec.request_amount || '/' || l_utilized_amount);

2919: ,x_act_budget_id => l_act_budget_id
2920: ,x_utilized_amount => l_utilized_amount);
2921:
2922: IF G_DEBUG_LOW THEN
2923: ozf_utility_pvt.write_conc_log('Req Curr/Req Amt/Util Amt: ' || l_act_budgets_rec.request_currency || '/' || l_act_budgets_rec.request_amount || '/' || l_utilized_amount);
2924: END IF;
2925:
2926: l_utilized_amount := 0;
2927:

Line 2929: ozf_utility_pvt.write_conc_log('Msg from Budget API: '||l_msg_data);

2925:
2926: l_utilized_amount := 0;
2927:
2928: IF l_return_status = Fnd_Api.g_ret_sts_error THEN
2929: ozf_utility_pvt.write_conc_log('Msg from Budget API: '||l_msg_data);
2930: log_exception(l_act_budgets_rec, l_act_util_rec);
2931: ELSIF l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
2932: ozf_utility_pvt.write_conc_log('Msg from Budget API: '||l_msg_data);
2933: log_exception(l_act_budgets_rec, l_act_util_rec);

Line 2932: ozf_utility_pvt.write_conc_log('Msg from Budget API: '||l_msg_data);

2928: IF l_return_status = Fnd_Api.g_ret_sts_error THEN
2929: ozf_utility_pvt.write_conc_log('Msg from Budget API: '||l_msg_data);
2930: log_exception(l_act_budgets_rec, l_act_util_rec);
2931: ELSIF l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
2932: ozf_utility_pvt.write_conc_log('Msg from Budget API: '||l_msg_data);
2933: log_exception(l_act_budgets_rec, l_act_util_rec);
2934: END IF;
2935:
2936: l_act_budgets_rec := NULL;

Line 2971: ozf_utility_pvt.convert_currency(

2967: --Added for bug 7030415
2968: OPEN c_get_conversion_type(l_tm_line.org_id);
2969: FETCH c_get_conversion_type INTO l_exchange_rate_type;
2970: CLOSE c_get_conversion_type;
2971: ozf_utility_pvt.convert_currency(
2972: x_return_status => l_return_status
2973: ,p_from_currency => l_tm_line.currency_code
2974: ,p_to_currency => l_net_accrual_offers.fund_request_curr_code
2975: ,p_conv_type => l_exchange_rate_type

Line 2984: ozf_utility_pvt.write_conc_log('Convert currency ' || l_return_status);

2980: --
2981: IF l_return_status = Fnd_Api.g_ret_sts_error
2982: THEN
2983: --
2984: ozf_utility_pvt.write_conc_log('Convert currency ' || l_return_status);
2985: RAISE Fnd_Api.g_exc_error;
2986: --
2987: ELSIF l_return_status = Fnd_Api.g_ret_sts_unexp_error
2988: THEN

Line 2990: ozf_utility_pvt.write_conc_log('Convert currency ' || l_return_status);

2986: --
2987: ELSIF l_return_status = Fnd_Api.g_ret_sts_unexp_error
2988: THEN
2989: --
2990: ozf_utility_pvt.write_conc_log('Convert currency ' || l_return_status);
2991: RAISE Fnd_Api.g_exc_unexpected_error;
2992: --
2993: END IF;
2994: --

Line 3028: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id);

3024: l_act_budgets_rec.status_code := 'APPROVED';
3025: l_act_budgets_rec.approved_amount := -1 * l_tm_dedu_amount;
3026: l_act_budgets_rec.approved_in_currency := l_net_accrual_offers.fund_request_curr_code;
3027: l_act_budgets_rec.approval_date := SYSDATE;
3028: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id);
3029: l_act_budgets_rec.justification := 'NA: TM DEDUCTION' || TO_CHAR(SYSDATE, 'MON-DD-YYYY');
3030: l_act_budgets_rec.transfer_type := 'UTILIZED';
3031: l_act_budgets_rec.requester_id := l_net_accrual_offers.owner_id;
3032:

Line 3040: ozf_utility_pvt.write_conc_log('Accrual log: TM Deduction BATCH_MODE = Y');

3036: l_act_util_rec.utilization_type := 'ACCRUAL';
3037: l_act_util_rec.adjustment_date := SYSDATE;
3038: l_act_util_rec.gl_date := SYSDATE;
3039:
3040: ozf_utility_pvt.write_conc_log('Accrual log: TM Deduction BATCH_MODE = Y');
3041: ozf_utility_pvt.write_conc_log('Offer PK: '||l_net_accrual_offers.qp_list_header_id);
3042: ozf_utility_pvt.write_conc_log('Custom Setup Id: '||l_net_accrual_offers.custom_setup_id);
3043: ozf_utility_pvt.write_conc_log('Deduction Curr Code: '||l_net_accrual_offers.fund_request_curr_code);
3044: ozf_utility_pvt.write_conc_log('Deduction Amount: '||l_act_budgets_rec.request_amount);

Line 3041: ozf_utility_pvt.write_conc_log('Offer PK: '||l_net_accrual_offers.qp_list_header_id);

3037: l_act_util_rec.adjustment_date := SYSDATE;
3038: l_act_util_rec.gl_date := SYSDATE;
3039:
3040: ozf_utility_pvt.write_conc_log('Accrual log: TM Deduction BATCH_MODE = Y');
3041: ozf_utility_pvt.write_conc_log('Offer PK: '||l_net_accrual_offers.qp_list_header_id);
3042: ozf_utility_pvt.write_conc_log('Custom Setup Id: '||l_net_accrual_offers.custom_setup_id);
3043: ozf_utility_pvt.write_conc_log('Deduction Curr Code: '||l_net_accrual_offers.fund_request_curr_code);
3044: ozf_utility_pvt.write_conc_log('Deduction Amount: '||l_act_budgets_rec.request_amount);
3045: ozf_utility_pvt.write_conc_log('Cust Acct Id: '||l_act_util_rec.cust_account_id);

Line 3042: ozf_utility_pvt.write_conc_log('Custom Setup Id: '||l_net_accrual_offers.custom_setup_id);

3038: l_act_util_rec.gl_date := SYSDATE;
3039:
3040: ozf_utility_pvt.write_conc_log('Accrual log: TM Deduction BATCH_MODE = Y');
3041: ozf_utility_pvt.write_conc_log('Offer PK: '||l_net_accrual_offers.qp_list_header_id);
3042: ozf_utility_pvt.write_conc_log('Custom Setup Id: '||l_net_accrual_offers.custom_setup_id);
3043: ozf_utility_pvt.write_conc_log('Deduction Curr Code: '||l_net_accrual_offers.fund_request_curr_code);
3044: ozf_utility_pvt.write_conc_log('Deduction Amount: '||l_act_budgets_rec.request_amount);
3045: ozf_utility_pvt.write_conc_log('Cust Acct Id: '||l_act_util_rec.cust_account_id);
3046:

Line 3043: ozf_utility_pvt.write_conc_log('Deduction Curr Code: '||l_net_accrual_offers.fund_request_curr_code);

3039:
3040: ozf_utility_pvt.write_conc_log('Accrual log: TM Deduction BATCH_MODE = Y');
3041: ozf_utility_pvt.write_conc_log('Offer PK: '||l_net_accrual_offers.qp_list_header_id);
3042: ozf_utility_pvt.write_conc_log('Custom Setup Id: '||l_net_accrual_offers.custom_setup_id);
3043: ozf_utility_pvt.write_conc_log('Deduction Curr Code: '||l_net_accrual_offers.fund_request_curr_code);
3044: ozf_utility_pvt.write_conc_log('Deduction Amount: '||l_act_budgets_rec.request_amount);
3045: ozf_utility_pvt.write_conc_log('Cust Acct Id: '||l_act_util_rec.cust_account_id);
3046:
3047: IF l_act_budgets_rec.request_amount <> 0

Line 3044: ozf_utility_pvt.write_conc_log('Deduction Amount: '||l_act_budgets_rec.request_amount);

3040: ozf_utility_pvt.write_conc_log('Accrual log: TM Deduction BATCH_MODE = Y');
3041: ozf_utility_pvt.write_conc_log('Offer PK: '||l_net_accrual_offers.qp_list_header_id);
3042: ozf_utility_pvt.write_conc_log('Custom Setup Id: '||l_net_accrual_offers.custom_setup_id);
3043: ozf_utility_pvt.write_conc_log('Deduction Curr Code: '||l_net_accrual_offers.fund_request_curr_code);
3044: ozf_utility_pvt.write_conc_log('Deduction Amount: '||l_act_budgets_rec.request_amount);
3045: ozf_utility_pvt.write_conc_log('Cust Acct Id: '||l_act_util_rec.cust_account_id);
3046:
3047: IF l_act_budgets_rec.request_amount <> 0
3048: THEN -- bug 3463302. dont create utilization if zero amount

Line 3045: ozf_utility_pvt.write_conc_log('Cust Acct Id: '||l_act_util_rec.cust_account_id);

3041: ozf_utility_pvt.write_conc_log('Offer PK: '||l_net_accrual_offers.qp_list_header_id);
3042: ozf_utility_pvt.write_conc_log('Custom Setup Id: '||l_net_accrual_offers.custom_setup_id);
3043: ozf_utility_pvt.write_conc_log('Deduction Curr Code: '||l_net_accrual_offers.fund_request_curr_code);
3044: ozf_utility_pvt.write_conc_log('Deduction Amount: '||l_act_budgets_rec.request_amount);
3045: ozf_utility_pvt.write_conc_log('Cust Acct Id: '||l_act_util_rec.cust_account_id);
3046:
3047: IF l_act_budgets_rec.request_amount <> 0
3048: THEN -- bug 3463302. dont create utilization if zero amount
3049: ozf_fund_adjustment_pvt.process_act_budgets(x_return_status => l_return_status

Line 3058: ozf_utility_pvt.write_conc_log('Req Curr/Req Amt/Util Amt: ' || l_act_budgets_rec.request_currency || '/' || l_act_budgets_rec.request_amount || '/' || l_utilized_amount);

3054: ,x_act_budget_id => l_act_budget_id
3055: ,x_utilized_amount => l_utilized_amount);
3056:
3057: IF G_DEBUG_LOW THEN
3058: ozf_utility_pvt.write_conc_log('Req Curr/Req Amt/Util Amt: ' || l_act_budgets_rec.request_currency || '/' || l_act_budgets_rec.request_amount || '/' || l_utilized_amount);
3059: END IF;
3060: l_utilized_amount := 0;
3061: ozf_utility_pvt.write_conc_log('Msg from Budget API: '||l_msg_data);
3062: IF l_return_status = Fnd_Api.g_ret_sts_error THEN

Line 3061: ozf_utility_pvt.write_conc_log('Msg from Budget API: '||l_msg_data);

3057: IF G_DEBUG_LOW THEN
3058: ozf_utility_pvt.write_conc_log('Req Curr/Req Amt/Util Amt: ' || l_act_budgets_rec.request_currency || '/' || l_act_budgets_rec.request_amount || '/' || l_utilized_amount);
3059: END IF;
3060: l_utilized_amount := 0;
3061: ozf_utility_pvt.write_conc_log('Msg from Budget API: '||l_msg_data);
3062: IF l_return_status = Fnd_Api.g_ret_sts_error THEN
3063: log_exception(l_act_budgets_rec, l_act_util_rec);
3064: ELSIF l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
3065: log_exception(l_act_budgets_rec, l_act_util_rec);

Line 3075: ozf_utility_pvt.write_conc_log('-- Done Processing Deduction Rules -- ');

3071: END IF;
3072: END IF;
3073: END LOOP; -- end l_na_rule_line
3074:
3075: ozf_utility_pvt.write_conc_log('-- Done Processing Deduction Rules -- ');
3076: ozf_utility_pvt.write_conc_log('--------------------------------------');
3077:
3078: IF l_net_accrual_offers.latest_na_completion_date IS NULL OR l_net_accrual_offers.latest_na_completion_date < l_as_of_date THEN
3079: UPDATE ozf_offers

Line 3076: ozf_utility_pvt.write_conc_log('--------------------------------------');

3072: END IF;
3073: END LOOP; -- end l_na_rule_line
3074:
3075: ozf_utility_pvt.write_conc_log('-- Done Processing Deduction Rules -- ');
3076: ozf_utility_pvt.write_conc_log('--------------------------------------');
3077:
3078: IF l_net_accrual_offers.latest_na_completion_date IS NULL OR l_net_accrual_offers.latest_na_completion_date < l_as_of_date THEN
3079: UPDATE ozf_offers
3080: SET latest_na_completion_date = l_as_of_date

Line 3088: ozf_utility_pvt.write_conc_log('Start Processing IDSM Lines');

3084: <>
3085: --------------- Start Processing IDSM lines ------------------------
3086: IF l_net_accrual_offers.sales_method_flag IS NULL OR l_net_accrual_offers.sales_method_flag = 'I' THEN
3087: --
3088: ozf_utility_pvt.write_conc_log('Start Processing IDSM Lines');
3089: l_idsm_line_tbl.delete;
3090: l_accrual_amount := 0;
3091:
3092: OPEN c_idsm_line(l_net_accrual_offers.start_date_active, l_net_accrual_offers.end_date_active, l_offer_org_id, l_net_accrual_offers.resale_line_id_processed);

Line 3102: ozf_utility_pvt.write_conc_log('No Data found in c_idsm_line CURSOR');

3098: -- To handle NO DATA FOUND for c_idsm_line CURSOR
3099: IF l_idsm_line_tbl.FIRST IS NULL
3100: THEN
3101: --
3102: ozf_utility_pvt.write_conc_log('No Data found in c_idsm_line CURSOR');
3103: EXIT;
3104: --
3105: END IF;
3106: --

Line 3121: ozf_utility_pvt.write_conc_log('Resale Line_Id: ' || l_idsm_line_tbl(i).line_id);

3117:
3118: l_idsm_line_processed := l_idsm_line_tbl(i).line_id;
3119:
3120: IF G_DEBUG_LOW THEN
3121: ozf_utility_pvt.write_conc_log('Resale Line_Id: ' || l_idsm_line_tbl(i).line_id);
3122: END IF;
3123:
3124: l_line_amount := ( NVL(l_idsm_line_tbl(i).shipped_quantity,l_idsm_line_tbl(i).fulfilled_quantity)
3125: * l_idsm_line_tbl(i).unit_selling_price );

Line 3181: ozf_utility_pvt.write_conc_log('Did Customer qualify: ' || l_customer_qualified);

3177: --
3178: END IF; -- Done qualfiying the customer
3179:
3180: IF G_DEBUG_LOW THEN
3181: ozf_utility_pvt.write_conc_log('Did Customer qualify: ' || l_customer_qualified);
3182: END IF;
3183:
3184: -- Fetch Currency Code on the IDSM
3185: l_order_curr_code := l_idsm_line_tbl(i).transactional_curr_code ;

Line 3198: ozf_utility_pvt.convert_currency(x_return_status => l_return_status

3194: --Added for bug 7030415
3195: OPEN c_get_conversion_type(l_idsm_line_tbl(i).org_id);
3196: FETCH c_get_conversion_type INTO l_exchange_rate_type;
3197: CLOSE c_get_conversion_type;
3198: ozf_utility_pvt.convert_currency(x_return_status => l_return_status
3199: ,p_from_currency => l_order_curr_code
3200: ,p_to_currency => l_net_accrual_offers.fund_request_curr_code
3201: ,p_conv_type => l_exchange_rate_type
3202: ,p_conv_date => l_idsm_line_tbl(i).conv_date

Line 3210: ozf_utility_pvt.write_conc_log('Exp Error from Convert_Currency: ' || l_return_status);

3206: l_line_amount := l_new_amount;
3207:
3208: IF l_return_status = Fnd_Api.g_ret_sts_error
3209: THEN
3210: ozf_utility_pvt.write_conc_log('Exp Error from Convert_Currency: ' || l_return_status);
3211: RAISE Fnd_Api.g_exc_error;
3212: ELSIF l_return_status = Fnd_Api.g_ret_sts_unexp_error
3213: THEN
3214: ozf_utility_pvt.write_conc_log('Unexp Error from Convert_Currency: ' || l_return_status);

Line 3214: ozf_utility_pvt.write_conc_log('Unexp Error from Convert_Currency: ' || l_return_status);

3210: ozf_utility_pvt.write_conc_log('Exp Error from Convert_Currency: ' || l_return_status);
3211: RAISE Fnd_Api.g_exc_error;
3212: ELSIF l_return_status = Fnd_Api.g_ret_sts_unexp_error
3213: THEN
3214: ozf_utility_pvt.write_conc_log('Unexp Error from Convert_Currency: ' || l_return_status);
3215: RAISE Fnd_Api.g_exc_unexpected_error;
3216: END IF;
3217: --
3218: END IF;

Line 3225: ozf_utility_pvt.write_conc_log('Pv_Referral_Comp_Pub.Get_Beneficiary (+)');

3221: IF l_net_accrual_offers.custom_setup_id = 105
3222: THEN
3223: --
3224: IF G_DEBUG_LOW THEN
3225: ozf_utility_pvt.write_conc_log('Pv_Referral_Comp_Pub.Get_Beneficiary (+)');
3226: END IF;
3227: pv_referral_comp_pub.get_beneficiary (p_api_version => 1.0,
3228: p_init_msg_list => FND_API.g_true,
3229: p_commit => FND_API.g_false,

Line 3240: ozf_utility_pvt.write_conc_log('Pv_Referral_Comp_Pub.Get_Beneficiary (-) With Status: ' || l_return_status);

3236: x_return_status => l_return_status,
3237: x_msg_count => l_msg_count,
3238: x_msg_data => l_msg_data);
3239: IF G_DEBUG_LOW THEN
3240: ozf_utility_pvt.write_conc_log('Pv_Referral_Comp_Pub.Get_Beneficiary (-) With Status: ' || l_return_status);
3241: ozf_utility_pvt.write_conc_log('l_benificiary_id / l_referral_id: ' || l_beneficiary_id || ' / ' || l_referral_id);
3242: END IF;
3243:
3244: IF l_return_status = Fnd_Api.g_ret_sts_error

Line 3241: ozf_utility_pvt.write_conc_log('l_benificiary_id / l_referral_id: ' || l_beneficiary_id || ' / ' || l_referral_id);

3237: x_msg_count => l_msg_count,
3238: x_msg_data => l_msg_data);
3239: IF G_DEBUG_LOW THEN
3240: ozf_utility_pvt.write_conc_log('Pv_Referral_Comp_Pub.Get_Beneficiary (-) With Status: ' || l_return_status);
3241: ozf_utility_pvt.write_conc_log('l_benificiary_id / l_referral_id: ' || l_beneficiary_id || ' / ' || l_referral_id);
3242: END IF;
3243:
3244: IF l_return_status = Fnd_Api.g_ret_sts_error
3245: THEN

Line 3246: ozf_utility_pvt.write_conc_log('Exp Error from Get_Beneficiary: ' || l_return_status);

3242: END IF;
3243:
3244: IF l_return_status = Fnd_Api.g_ret_sts_error
3245: THEN
3246: ozf_utility_pvt.write_conc_log('Exp Error from Get_Beneficiary: ' || l_return_status);
3247: RAISE Fnd_Api.g_exc_error;
3248: ELSIF l_return_status = Fnd_Api.g_ret_sts_unexp_error
3249: THEN
3250: ozf_utility_pvt.write_conc_log('Unexp Error from Get_Beneficiary: ' || l_return_status);

Line 3250: ozf_utility_pvt.write_conc_log('Unexp Error from Get_Beneficiary: ' || l_return_status);

3246: ozf_utility_pvt.write_conc_log('Exp Error from Get_Beneficiary: ' || l_return_status);
3247: RAISE Fnd_Api.g_exc_error;
3248: ELSIF l_return_status = Fnd_Api.g_ret_sts_unexp_error
3249: THEN
3250: ozf_utility_pvt.write_conc_log('Unexp Error from Get_Beneficiary: ' || l_return_status);
3251: RAISE Fnd_Api.g_exc_unexpected_error;
3252: END IF;
3253: --
3254:

Line 3259: ozf_utility_pvt.write_conc_log('Get_Pv_Accrual_Amount (+)');

3255: IF ( l_beneficiary_id IS NOT NULL )
3256: THEN
3257: --------------------------- Derive Accrual Amount -------------------------
3258: IF G_DEBUG_LOW THEN
3259: ozf_utility_pvt.write_conc_log('Get_Pv_Accrual_Amount (+)');
3260: END IF;
3261:
3262: l_line_acc_amount := get_pv_accrual_amount(p_product_id => l_idsm_line_tbl(i).inventory_item_id
3263: ,p_line_amt => l_line_amount

Line 3270: ozf_utility_pvt.write_conc_log('Get_Pv_Accrual_Amount (-) With l_line_acc_amount: ' || l_line_acc_amount);

3266: ,p_list_hdr_id => l_net_accrual_offers.qp_list_header_id
3267: ,p_referral_id => l_referral_id
3268: ,p_order_hdr_id => l_idsm_line_tbl(i).header_id);
3269: IF G_DEBUG_LOW THEN
3270: ozf_utility_pvt.write_conc_log('Get_Pv_Accrual_Amount (-) With l_line_acc_amount: ' || l_line_acc_amount);
3271: END IF;
3272: --
3273: ELSE
3274: --

Line 3275: ozf_utility_pvt.write_conc_log('No Beneficiary derived from PV_Referral_Comp_Pub. Utilization will not be created');

3271: END IF;
3272: --
3273: ELSE
3274: --
3275: ozf_utility_pvt.write_conc_log('No Beneficiary derived from PV_Referral_Comp_Pub. Utilization will not be created');
3276: --
3277: END IF;
3278: --
3279: l_utilization_type := 'LEAD_ACCRUAL';

Line 3286: ozf_utility_pvt.write_conc_log('Get_Accrualed_Amount (+)');

3282: ELSE
3283: --
3284: --------------------------- Derive Accrual Amount -------------------------
3285: IF G_DEBUG_LOW THEN
3286: ozf_utility_pvt.write_conc_log('Get_Accrualed_Amount (+)');
3287: END IF;
3288: l_line_acc_amount := get_accrualed_amount(p_product_id => l_idsm_line_tbl(i).inventory_item_id
3289: ,p_line_amt => l_line_amount
3290: ,p_quantity => l_idsm_line_tbl(i).pricing_quantity

Line 3293: ozf_utility_pvt.write_conc_log('Get_Accrualed_Amount (-) With l_line_acc_amount: ' || l_line_acc_amount);

3289: ,p_line_amt => l_line_amount
3290: ,p_quantity => l_idsm_line_tbl(i).pricing_quantity
3291: ,p_uom => l_idsm_line_tbl(i).pricing_quantity_uom);
3292: IF G_DEBUG_LOW THEN
3293: ozf_utility_pvt.write_conc_log('Get_Accrualed_Amount (-) With l_line_acc_amount: ' || l_line_acc_amount);
3294: END IF;
3295: --
3296:
3297: --

Line 3330: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id);

3326: l_act_budgets_rec.status_code := 'APPROVED';
3327: l_act_budgets_rec.approved_amount := l_line_acc_amount;
3328: l_act_budgets_rec.approved_in_currency := l_net_accrual_offers.fund_request_curr_code;
3329: l_act_budgets_rec.approval_date := SYSDATE;
3330: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id);
3331: l_act_budgets_rec.justification := 'NA: ' || TO_CHAR(SYSDATE, 'MM/DD/YYYY');
3332: l_act_budgets_rec.transfer_type := 'UTILIZED';
3333: l_act_budgets_rec.requester_id := l_net_accrual_offers.owner_id;
3334:

Line 3362: ozf_utility_pvt.write_conc_log('Req Curr/Req Amt/Util Amt: ' || l_act_budgets_rec.request_currency || '/' || l_act_budgets_rec.request_amount || '/' || l_utilized_amount);

3358: ,x_act_budget_id => l_act_budget_id
3359: ,x_utilized_amount => l_utilized_amount);
3360: --
3361: IF G_DEBUG_LOW THEN
3362: ozf_utility_pvt.write_conc_log('Req Curr/Req Amt/Util Amt: ' || l_act_budgets_rec.request_currency || '/' || l_act_budgets_rec.request_amount || '/' || l_utilized_amount);
3363: END IF;
3364:
3365: IF l_return_status = Fnd_Api.g_ret_sts_error
3366: THEN

Line 3367: ozf_utility_pvt.write_conc_log('Exp Error: Process_Act_Budgets: Resale line_id ( ' || l_idsm_line_tbl(i).line_id

3363: END IF;
3364:
3365: IF l_return_status = Fnd_Api.g_ret_sts_error
3366: THEN
3367: ozf_utility_pvt.write_conc_log('Exp Error: Process_Act_Budgets: Resale line_id ( ' || l_idsm_line_tbl(i).line_id
3368: || ' ) Error: ' || l_msg_data);
3369: log_exception(l_act_budgets_rec, l_act_util_rec);
3370: ELSIF l_return_status = Fnd_Api.g_ret_sts_unexp_error
3371: THEN

Line 3372: ozf_utility_pvt.write_conc_log('UnExp Error: Process_Act_Budgets: Resale line_id ( ' || l_idsm_line_tbl(i).line_id

3368: || ' ) Error: ' || l_msg_data);
3369: log_exception(l_act_budgets_rec, l_act_util_rec);
3370: ELSIF l_return_status = Fnd_Api.g_ret_sts_unexp_error
3371: THEN
3372: ozf_utility_pvt.write_conc_log('UnExp Error: Process_Act_Budgets: Resale line_id ( ' || l_idsm_line_tbl(i).line_id
3373: || ' ) Error: ' || l_msg_data);
3374: log_exception(l_act_budgets_rec, l_act_util_rec);
3375: END IF;
3376:

Line 3436: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id);

3432: l_act_budgets_rec.status_code := 'APPROVED';
3433: l_act_budgets_rec.approved_amount := l_accrual_amount;
3434: l_act_budgets_rec.approved_in_currency := l_net_accrual_offers.fund_request_curr_code;
3435: l_act_budgets_rec.approval_date := SYSDATE;
3436: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id);
3437: l_act_budgets_rec.justification := 'NA: ' || TO_CHAR(SYSDATE, 'MM/DD/YYYY');
3438: l_act_budgets_rec.transfer_type := 'UTILIZED';
3439: l_act_budgets_rec.requester_id := l_net_accrual_offers.owner_id;
3440:

Line 3457: ozf_utility_pvt.write_conc_log('Req Curr/Req Amt/Util Amt: ' || l_act_budgets_rec.request_currency || '/' || l_act_budgets_rec.request_amount || '/' || l_utilized_amount);

3453: ,x_act_budget_id => l_act_budget_id
3454: ,x_utilized_amount => l_utilized_amount);
3455:
3456: IF G_DEBUG_LOW THEN
3457: ozf_utility_pvt.write_conc_log('Req Curr/Req Amt/Util Amt: ' || l_act_budgets_rec.request_currency || '/' || l_act_budgets_rec.request_amount || '/' || l_utilized_amount);
3458: END IF;
3459:
3460: IF l_return_status = Fnd_Api.g_ret_sts_error
3461: THEN

Line 3462: ozf_utility_pvt.write_conc_log('Exp Error: Process_Act_Budgets Error: ' || l_msg_data );

3458: END IF;
3459:
3460: IF l_return_status = Fnd_Api.g_ret_sts_error
3461: THEN
3462: ozf_utility_pvt.write_conc_log('Exp Error: Process_Act_Budgets Error: ' || l_msg_data );
3463: log_exception(l_act_budgets_rec, l_act_util_rec);
3464: ELSIF l_return_status = Fnd_Api.g_ret_sts_unexp_error
3465: THEN
3466: ozf_utility_pvt.write_conc_log('UnExp Error: Process_Act_Budgets Error: ' || l_msg_data );

Line 3466: ozf_utility_pvt.write_conc_log('UnExp Error: Process_Act_Budgets Error: ' || l_msg_data );

3462: ozf_utility_pvt.write_conc_log('Exp Error: Process_Act_Budgets Error: ' || l_msg_data );
3463: log_exception(l_act_budgets_rec, l_act_util_rec);
3464: ELSIF l_return_status = Fnd_Api.g_ret_sts_unexp_error
3465: THEN
3466: ozf_utility_pvt.write_conc_log('UnExp Error: Process_Act_Budgets Error: ' || l_msg_data );
3467: log_exception(l_act_budgets_rec, l_act_util_rec);
3468: END IF;
3469:
3470: l_utilized_amount := 0;

Line 3493: ozf_utility_pvt.write_conc_log('-- Done -- ' || to_char(sysdate,'MM/DD/YYYY:HH:MM:SS'));

3489: DELETE FROM ozf_na_products_temp;
3490:
3491: END LOOP;
3492:
3493: ozf_utility_pvt.write_conc_log('-- Done -- ' || to_char(sysdate,'MM/DD/YYYY:HH:MM:SS'));
3494:
3495:
3496: Fnd_Msg_Pub.Count_AND_Get(p_count => l_msg_count,
3497: p_data => l_msg_data,

Line 3502: WHEN OZF_Utility_PVT.resource_locked THEN

3498: p_encoded => Fnd_Api.G_FALSE);
3499:
3500: EXCEPTION
3501:
3502: WHEN OZF_Utility_PVT.resource_locked THEN
3503: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
3504:
3505: WHEN FND_API.G_EXC_ERROR THEN
3506: ROLLBACK TO net_accrual_engine;

Line 3503: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');

3499:
3500: EXCEPTION
3501:
3502: WHEN OZF_Utility_PVT.resource_locked THEN
3503: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
3504:
3505: WHEN FND_API.G_EXC_ERROR THEN
3506: ROLLBACK TO net_accrual_engine;
3507: -- Standard call to get message count and if count=1, get the message