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_OFFER_ADJ_PVT dependencies on OZF_UTILITY_PVT

Line 135: ozf_utility_pvt.debug_message('in getEndDate :-Adjustment Id:'||p_offerAdjustmentId || '-List Line Id:' || p_listLineId);

131: WHERE a.list_header_id = h.list_header_id
132: and a.list_header_id = l.list_header_id
133: and l.list_line_id = p_listLineId
134: and a.offer_adjustment_id = p_offerAdjustmentId;
135: ozf_utility_pvt.debug_message('in getEndDate :-Adjustment Id:'||p_offerAdjustmentId || '-List Line Id:' || p_listLineId);
136:
137: l_allDtNull := 'N';
138: IF (l_lineStDt is null) THEN
139: IF (l_headerStDt is null) THEN

Line 1255: OZF_UTILITY_PVT.debug_message('l_custom_setup_id: ' || l_custom_setup_id);

1251: OPEN c_get_offer_hdr(x_modifier_line_tbl(1).list_header_id);
1252: FETCH c_get_offer_hdr INTO l_custom_setup_id;
1253: CLOSE c_get_offer_hdr;
1254:
1255: OZF_UTILITY_PVT.debug_message('l_custom_setup_id: ' || l_custom_setup_id);
1256:
1257: IF l_custom_setup_id = 118 THEN
1258: OPEN c_get_sdr_hdr(x_modifier_line_tbl(1).list_header_id);
1259: FETCH c_get_sdr_hdr INTO l_SDR_hdr_pub_rec.request_header_id

Line 1321: OZF_UTILITY_PVT.debug_message('x_modifier_line_tbl(i).start_date_active ' || x_modifier_line_tbl(i).start_date_active);

1317: l_SDR_lines_tbl(i).attribute14 := l_get_sdr_line.attribute14;
1318: l_SDR_lines_tbl(i).attribute15 := l_get_sdr_line.attribute15;
1319: l_SDR_lines_tbl(i).vendor_approved_flag := l_get_sdr_line.vendor_approved_flag;
1320: l_SDR_lines_tbl(i).vendor_item_code := l_get_sdr_line.vendor_item_code;
1321: OZF_UTILITY_PVT.debug_message('x_modifier_line_tbl(i).start_date_active ' || x_modifier_line_tbl(i).start_date_active);
1322: OZF_UTILITY_PVT.debug_message('x_modifier_line_tbl(i).end_date_active ' || x_modifier_line_tbl(i).end_date_active);
1323: OZF_UTILITY_PVT.debug_message('l_start_date_active ' || l_start_date_active);
1324: OZF_UTILITY_PVT.debug_message('l_end_date_active ' || l_end_date_active);
1325: l_SDR_lines_tbl(i).start_date := TRUNC(NVL(x_modifier_line_tbl(i).start_date_active,l_start_date_active));

Line 1322: OZF_UTILITY_PVT.debug_message('x_modifier_line_tbl(i).end_date_active ' || x_modifier_line_tbl(i).end_date_active);

1318: l_SDR_lines_tbl(i).attribute15 := l_get_sdr_line.attribute15;
1319: l_SDR_lines_tbl(i).vendor_approved_flag := l_get_sdr_line.vendor_approved_flag;
1320: l_SDR_lines_tbl(i).vendor_item_code := l_get_sdr_line.vendor_item_code;
1321: OZF_UTILITY_PVT.debug_message('x_modifier_line_tbl(i).start_date_active ' || x_modifier_line_tbl(i).start_date_active);
1322: OZF_UTILITY_PVT.debug_message('x_modifier_line_tbl(i).end_date_active ' || x_modifier_line_tbl(i).end_date_active);
1323: OZF_UTILITY_PVT.debug_message('l_start_date_active ' || l_start_date_active);
1324: OZF_UTILITY_PVT.debug_message('l_end_date_active ' || l_end_date_active);
1325: l_SDR_lines_tbl(i).start_date := TRUNC(NVL(x_modifier_line_tbl(i).start_date_active,l_start_date_active));
1326: l_SDR_lines_tbl(i).end_date := TRUNC(NVL(x_modifier_line_tbl(i).end_date_active,l_end_date_active));

Line 1323: OZF_UTILITY_PVT.debug_message('l_start_date_active ' || l_start_date_active);

1319: l_SDR_lines_tbl(i).vendor_approved_flag := l_get_sdr_line.vendor_approved_flag;
1320: l_SDR_lines_tbl(i).vendor_item_code := l_get_sdr_line.vendor_item_code;
1321: OZF_UTILITY_PVT.debug_message('x_modifier_line_tbl(i).start_date_active ' || x_modifier_line_tbl(i).start_date_active);
1322: OZF_UTILITY_PVT.debug_message('x_modifier_line_tbl(i).end_date_active ' || x_modifier_line_tbl(i).end_date_active);
1323: OZF_UTILITY_PVT.debug_message('l_start_date_active ' || l_start_date_active);
1324: OZF_UTILITY_PVT.debug_message('l_end_date_active ' || l_end_date_active);
1325: l_SDR_lines_tbl(i).start_date := TRUNC(NVL(x_modifier_line_tbl(i).start_date_active,l_start_date_active));
1326: l_SDR_lines_tbl(i).end_date := TRUNC(NVL(x_modifier_line_tbl(i).end_date_active,l_end_date_active));
1327: l_SDR_lines_tbl(i).end_customer_price_type := l_get_sdr_line.end_customer_price_type;

Line 1324: OZF_UTILITY_PVT.debug_message('l_end_date_active ' || l_end_date_active);

1320: l_SDR_lines_tbl(i).vendor_item_code := l_get_sdr_line.vendor_item_code;
1321: OZF_UTILITY_PVT.debug_message('x_modifier_line_tbl(i).start_date_active ' || x_modifier_line_tbl(i).start_date_active);
1322: OZF_UTILITY_PVT.debug_message('x_modifier_line_tbl(i).end_date_active ' || x_modifier_line_tbl(i).end_date_active);
1323: OZF_UTILITY_PVT.debug_message('l_start_date_active ' || l_start_date_active);
1324: OZF_UTILITY_PVT.debug_message('l_end_date_active ' || l_end_date_active);
1325: l_SDR_lines_tbl(i).start_date := TRUNC(NVL(x_modifier_line_tbl(i).start_date_active,l_start_date_active));
1326: l_SDR_lines_tbl(i).end_date := TRUNC(NVL(x_modifier_line_tbl(i).end_date_active,l_end_date_active));
1327: l_SDR_lines_tbl(i).end_customer_price_type := l_get_sdr_line.end_customer_price_type;
1328: l_SDR_lines_tbl(i).end_customer_tolerance_type := l_get_sdr_line.end_customer_tolerance_type;

Line 1357: OZF_UTILITY_PVT.debug_message('update_sd_Request x_return_status ' || x_return_status);

1353: p_SDR_lines_tbl => l_SDR_lines_tbl,
1354: p_SDR_cust_tbl => l_SDR_cust_tbl
1355: );
1356:
1357: OZF_UTILITY_PVT.debug_message('update_sd_Request x_return_status ' || x_return_status);
1358: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1359: RAISE FND_API.G_EXC_ERROR;
1360: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1385: OZF_UTILITY_PVT.debug_message('process_modifiers x_return_status ' || x_return_status);

1381: x_pricing_attr_tbl => v_pricing_attr_tbl,
1382: x_pricing_attr_val_tbl => v_pricing_attr_val_tbl
1383: );
1384:
1385: OZF_UTILITY_PVT.debug_message('process_modifiers x_return_status ' || x_return_status);
1386: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1387: RAISE FND_API.G_EXC_ERROR;
1388: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1389: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1530: OZF_Utility_PVT.Error_Message(p_message_name => 'INVALID_ADJUSTMENT_LINE');

1526: -- check if list_line_id is passed in, in case not, get the list_line_id from the offer_adjustment_line_id, if cannot be located
1527: -- raise error
1528:
1529: IF p_offerAdjustmentLineId IS NULL OR p_offerAdjustmentLineId = FND_API.G_MISS_NUM THEN
1530: OZF_Utility_PVT.Error_Message(p_message_name => 'INVALID_ADJUSTMENT_LINE');
1531: x_return_status := FND_API.g_ret_sts_error;
1532: RETURN;
1533: END IF;
1534: /*

Line 1539: OZF_Utility_PVT.Error_Message(p_message_name => 'INVALID_LIST_LINE');

1535: IF (p_listLineId IS NULL OR p_listLineId = FND_API.G_MISS_NUM) THEN
1536: OPEN c_listLineId(cp_offerAdjustmentLineId => p_offerAdjustmentLineId);
1537: FETCH c_listLineId INTO l_listLineId;
1538: IF c_listLineId%NOTFOUND THEN
1539: OZF_Utility_PVT.Error_Message(p_message_name => 'INVALID_LIST_LINE');
1540: x_return_status := FND_API.g_ret_sts_error;
1541: CLOSE c_listLineId;
1542: RETURN;
1543: END IF;

Line 1933: OZF_Utility_PVT.Error_Message(p_message_name => 'INVALID_ADJUSTMENT_LINE');

1929: x_return_status := FND_API.G_RET_STS_SUCCESS;
1930: -- check if list_line_id is passed in, in case not, get the list_line_id from the offer_adjustment_line_id, if cannot be located
1931: -- raise error
1932: /*IF p_offerAdjustmentLineId IS NULL OR p_offerAdjustmentLineId = FND_API.G_MISS_NUM THEN
1933: OZF_Utility_PVT.Error_Message(p_message_name => 'INVALID_ADJUSTMENT_LINE');
1934: x_return_status := FND_API.g_ret_sts_error;
1935: RETURN;
1936: END IF;
1937: */

Line 2132: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_ADJLINE_ENDDATE_LT_SYSDATE');

2128:
2129: IF l_endDate IS NOT NULL AND l_endDate <> FND_API.G_MISS_DATE THEN
2130: CASE
2131: WHEN l_endDate < TRUNC(sysdate) THEN
2132: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_ADJLINE_ENDDATE_LT_SYSDATE');
2133: x_return_status := FND_API.g_ret_sts_error;
2134: RETURN;
2135: WHEN l_endDate < TRUNC(px_modifier_line_rec.start_date_active) THEN
2136: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_ADJLINE_ENDDATE_LT_EFFDATE');

Line 2136: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_ADJLINE_ENDDATE_LT_EFFDATE');

2132: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_ADJLINE_ENDDATE_LT_SYSDATE');
2133: x_return_status := FND_API.g_ret_sts_error;
2134: RETURN;
2135: WHEN l_endDate < TRUNC(px_modifier_line_rec.start_date_active) THEN
2136: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_ADJLINE_ENDDATE_LT_EFFDATE');
2137: x_return_status := FND_API.g_ret_sts_error;
2138: RETURN;
2139: WHEN l_offEndDate IS NOT NULL AND l_offEndDate <> FND_API.G_MISS_DATE
2140: AND l_endDate > l_offEndDate THEN

Line 2141: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_ADJLINE_ENDDATE_MT_OFFDATE');

2137: x_return_status := FND_API.g_ret_sts_error;
2138: RETURN;
2139: WHEN l_offEndDate IS NOT NULL AND l_offEndDate <> FND_API.G_MISS_DATE
2140: AND l_endDate > l_offEndDate THEN
2141: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_ADJLINE_ENDDATE_MT_OFFDATE');
2142: x_return_status := FND_API.g_ret_sts_error;
2143: RETURN;
2144: ELSE
2145: px_modifier_line_rec.end_date_active := l_endDate;

Line 2731: ozf_utility_pvt.debug_message('before populateTdUpdLines :'||x_return_status);

2727: -- populate end date lines
2728: -- process end date lines
2729: -- end date line
2730: x_return_status := FND_API.G_RET_STS_SUCCESS;
2731: ozf_utility_pvt.debug_message('before populateTdUpdLines :'||x_return_status);
2732: populateTdUpdLines
2733: (
2734: x_modifier_line_rec => l_modifier_line_tbl(1)
2735: , p_listLineId => p_listLineId

Line 2740: ozf_utility_pvt.debug_message('after populateTdUpdLines :'||x_return_status);

2736: ,x_return_status => x_return_status
2737: ,x_msg_count => x_msg_count
2738: ,x_msg_data => x_msg_data
2739: );
2740: ozf_utility_pvt.debug_message('after populateTdUpdLines :'||x_return_status);
2741: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2742: RAISE FND_API.G_EXC_ERROR;
2743: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2744: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2746: ozf_utility_pvt.debug_message('before processTdUpdLines :'||x_return_status);

2742: RAISE FND_API.G_EXC_ERROR;
2743: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2744: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2745: END IF;
2746: ozf_utility_pvt.debug_message('before processTdUpdLines :'||x_return_status);
2747:
2748: processTdUpdLines
2749: (
2750: px_modifier_line_rec => l_modifier_line_tbl(1)

Line 2757: ozf_utility_pvt.debug_message('after processTdUpdLines :'||x_return_status);

2753: ,x_return_status => x_return_status
2754: ,x_msg_count => x_msg_count
2755: ,x_msg_data => x_msg_data
2756: );
2757: ozf_utility_pvt.debug_message('after processTdUpdLines :'||x_return_status);
2758: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2759: RAISE FND_API.G_EXC_ERROR;
2760: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2763: ozf_utility_pvt.debug_message('before process_qp_list_lines :'||x_return_status);

2759: RAISE FND_API.G_EXC_ERROR;
2760: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2762: END IF;
2763: ozf_utility_pvt.debug_message('before process_qp_list_lines :'||x_return_status);
2764: ozf_offer_pvt.process_qp_list_lines
2765: (
2766: x_return_status => x_return_status
2767: ,x_msg_count => x_msg_count

Line 2775: ozf_utility_pvt.debug_message('after process_qp_list_lines :'||x_return_status);

2771: ,p_list_header_id => l_modifier_line_tbl(1).list_header_id
2772: ,x_modifier_line_tbl => lx_modifier_tbl --QP_MODIFIERS_PUB.modifiers_tbl_type
2773: ,x_error_location => l_errorLocation
2774: );
2775: ozf_utility_pvt.debug_message('after process_qp_list_lines :'||x_return_status);
2776: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2777: RAISE FND_API.G_EXC_ERROR;
2778: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2779: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2805: ozf_utility_pvt.debug_message('before endDateTdLine :'||x_return_status);

2801: l_modifier_tbl QP_MODIFIERS_PUB.modifiers_tbl_type;
2802: l_listLineId number;
2803: BEGIN
2804: x_return_status := FND_API.G_RET_STS_SUCCESS;
2805: ozf_utility_pvt.debug_message('before endDateTdLine :'||x_return_status);
2806: endDateTdLine
2807: (
2808: x_return_status => x_return_status
2809: ,x_msg_count => x_msg_count

Line 2814: ozf_utility_pvt.debug_message('after endDateTdLine :'||x_return_status);

2810: ,x_msg_data => x_msg_data
2811: ,p_offerAdjustmentId => p_offerAdjustmentId
2812: , p_listLineId => p_listLineId
2813: );
2814: ozf_utility_pvt.debug_message('after endDateTdLine :'||x_return_status);
2815: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2816: RAISE FND_API.G_EXC_ERROR;
2817: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2818: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2820: ozf_utility_pvt.debug_message('before copyTdLine :'||x_return_status);

2816: RAISE FND_API.G_EXC_ERROR;
2817: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2818: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2819: END IF;
2820: ozf_utility_pvt.debug_message('before copyTdLine :'||x_return_status);
2821: copyTdLine
2822: (
2823: x_return_status => x_return_status
2824: ,x_msg_count => x_msg_count

Line 2831: ozf_utility_pvt.debug_message('after copyTdLine :'||x_return_status);

2827: , p_listLineId => p_listLineId
2828: , x_listLineId => l_listLineId
2829: , x_modifier_tbl => l_modifier_tbl
2830: );
2831: ozf_utility_pvt.debug_message('after copyTdLine :'||x_return_status);
2832:
2833: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2834: RAISE FND_API.G_EXC_ERROR;
2835: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2838: ozf_utility_pvt.debug_message('before relateTdLine :'||x_return_status);

2834: RAISE FND_API.G_EXC_ERROR;
2835: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2836: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2837: END IF;
2838: ozf_utility_pvt.debug_message('before relateTdLine :'||x_return_status);
2839: relateTdLines
2840: (
2841: x_return_status => x_return_status
2842: ,x_msg_count => x_msg_count

Line 2848: ozf_utility_pvt.debug_message('after relateTdLine :'||x_return_status);

2844: ,p_offerAdjustmentId => p_offerAdjustmentId
2845: , p_listLineId => p_listLineId
2846: , p_modifier_tbl => l_modifier_tbl
2847: );
2848: ozf_utility_pvt.debug_message('after relateTdLine :'||x_return_status);
2849: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2850: RAISE FND_API.G_EXC_ERROR;
2851: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2882: ozf_utility_pvt.debug_message('before process old td line discounts :'||x_return_status);

2878: -- relate list_lines
2879: x_return_status := FND_API.G_RET_STS_SUCCESS;
2880: FOR l_adjLines in c_adjLines(cp_offerAdjustmentId => p_offerAdjustmentId) LOOP
2881: --dbms_output.put_line('Processiung :'||l_adjLines.list_line_id);
2882: ozf_utility_pvt.debug_message('before process old td line discounts :'||x_return_status);
2883:
2884: processOldTdLine
2885: (
2886: x_return_status => x_return_status

Line 2892: ozf_utility_pvt.debug_message('after process old td line discounts :'||x_return_status);

2888: ,x_msg_data => x_msg_data
2889: ,p_offerAdjustmentId => p_offerAdjustmentId
2890: , p_listLineId => l_adjLines.list_line_id
2891: );
2892: ozf_utility_pvt.debug_message('after process old td line discounts :'||x_return_status);
2893: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2894: RAISE FND_API.G_EXC_ERROR;
2895: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2896: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2922: ozf_utility_pvt.debug_message('before process old td discounts :'||x_return_status);

2918: OPEN c_offerType(cp_offerAdjustmentId => p_offerAdjustmentId);
2919: FETCH c_offerType INTO l_offerType;
2920: CLOSE c_offerType;
2921: IF l_offerType.offer_type = 'DEAL' THEN
2922: ozf_utility_pvt.debug_message('before process old td discounts :'||x_return_status);
2923: process_old_td_discount
2924: (
2925: x_return_status => x_return_status
2926: , x_msg_count => x_msg_count

Line 2930: ozf_utility_pvt.debug_message('after process old td discounts :'||x_return_status);

2926: , x_msg_count => x_msg_count
2927: , x_msg_data => x_msg_data
2928: , p_offerAdjustmentId => p_offerAdjustmentId
2929: );
2930: ozf_utility_pvt.debug_message('after process old td discounts :'||x_return_status);
2931: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2932: RAISE FND_API.G_EXC_ERROR;
2933: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3653: ozf_utility_pvt.debug_message('p_SDR_hdr_pub_rec.org_id '|| p_SDR_hdr_pub_rec.org_id);

3649: l_product_cost_currency VARCHAR2(30);
3650:
3651: BEGIN
3652:
3653: ozf_utility_pvt.debug_message('p_SDR_hdr_pub_rec.org_id '|| p_SDR_hdr_pub_rec.org_id);
3654: OPEN c_func_currency(p_SDR_hdr_pub_rec.org_id);
3655: FETCH c_func_currency INTO l_product_cost_currency;
3656: CLOSE c_func_currency;
3657:

Line 3664: ozf_utility_pvt.debug_message('G_ITEM_ORG_ID '|| G_ITEM_ORG_ID);

3660: OPEN c_master_org_id(p_SDR_hdr_pub_rec.org_id);
3661: FETCH c_master_org_id INTO G_ITEM_ORG_ID;
3662: CLOSE c_master_org_id;
3663:
3664: ozf_utility_pvt.debug_message('G_ITEM_ORG_ID '|| G_ITEM_ORG_ID);
3665:
3666: IF nvl(px_modifier_line_tbl.count,0) > 0 THEN
3667: FOR i IN px_modifier_line_tbl.first .. px_modifier_line_tbl.last LOOP
3668: IF px_modifier_line_tbl.exists(i) THEN

Line 3683: ozf_utility_pvt.debug_message('px_SDR_lines_tbl(i).inventory_item_id '|| px_SDR_lines_tbl(i).inventory_item_id);

3679:
3680: px_SDR_lines_tbl(i).product_context := 'PRODUCT' ;
3681: px_SDR_lines_tbl(i).inventory_item_id := px_modifier_line_tbl(i).PRODUCT_ATTR_VAL ;
3682:
3683: ozf_utility_pvt.debug_message('px_SDR_lines_tbl(i).inventory_item_id '|| px_SDR_lines_tbl(i).inventory_item_id);
3684: OPEN c_product_cost(px_SDR_lines_tbl(i).inventory_item_id,G_ITEM_ORG_ID);
3685: FETCH c_product_cost INTO px_SDR_lines_tbl(i).product_cost;
3686: CLOSE c_product_cost;
3687:

Line 3734: ozf_utility_pvt.debug_message('px_SDR_lines_tbl(i).start_date '|| px_SDR_lines_tbl(i).start_date);

3730: px_SDR_lines_tbl(i).start_date := NVL(trunc(px_modifier_line_tbl(i).start_date_active), p_SDR_hdr_pub_rec.request_start_date);
3731: px_SDR_lines_tbl(i).end_date := NVL(trunc(px_modifier_line_tbl(i).end_date_active), p_SDR_hdr_pub_rec.request_end_date);
3732:
3733:
3734: ozf_utility_pvt.debug_message('px_SDR_lines_tbl(i).start_date '|| px_SDR_lines_tbl(i).start_date);
3735: ozf_utility_pvt.debug_message('px_SDR_lines_tbl(i).end_date '|| px_SDR_lines_tbl(i).end_date);
3736: --l_SDR_lines_tbl(i).end_customer_price_type := l_get_sdr_line.end_customer_price_type;
3737: --l_SDR_lines_tbl(i).end_customer_tolerance_type := l_get_sdr_line.end_customer_tolerance_type;
3738: --l_SDR_lines_tbl(i).end_customer_tolerance_value := l_get_sdr_line.end_customer_tolerance_value;

Line 3735: ozf_utility_pvt.debug_message('px_SDR_lines_tbl(i).end_date '|| px_SDR_lines_tbl(i).end_date);

3731: px_SDR_lines_tbl(i).end_date := NVL(trunc(px_modifier_line_tbl(i).end_date_active), p_SDR_hdr_pub_rec.request_end_date);
3732:
3733:
3734: ozf_utility_pvt.debug_message('px_SDR_lines_tbl(i).start_date '|| px_SDR_lines_tbl(i).start_date);
3735: ozf_utility_pvt.debug_message('px_SDR_lines_tbl(i).end_date '|| px_SDR_lines_tbl(i).end_date);
3736: --l_SDR_lines_tbl(i).end_customer_price_type := l_get_sdr_line.end_customer_price_type;
3737: --l_SDR_lines_tbl(i).end_customer_tolerance_type := l_get_sdr_line.end_customer_tolerance_type;
3738: --l_SDR_lines_tbl(i).end_customer_tolerance_value := l_get_sdr_line.end_customer_tolerance_value;
3739: --l_SDR_lines_tbl(i).org_id := l_get_sdr_line.org_id;

Line 3827: ozf_utility_pvt.debug_message('create l_custom_setup_id '||l_custom_setup_id);

3823: -- Populate values for SDR New Line for creation
3824: -- Populate Offer line record with list_line_no = request_line_id - populate_new_sdr_line_rec
3825: --===============================================================
3826:
3827: ozf_utility_pvt.debug_message('create l_custom_setup_id '||l_custom_setup_id);
3828: IF l_custom_setup_id = 118 THEN
3829:
3830: IF l_modifier_line_tbl.exists(1) THEN
3831: populate_sdr_hdr_rec(p_list_header_id => l_modifier_line_tbl(1).list_header_id

Line 3877: OZF_UTILITY_PVT.debug_message('update_sd_Request x_return_status ' || x_return_status);

3873: p_SDR_lines_tbl => l_SDR_lines_tbl,
3874: p_SDR_cust_tbl => l_SDR_cust_tbl
3875: );
3876:
3877: OZF_UTILITY_PVT.debug_message('update_sd_Request x_return_status ' || x_return_status);
3878: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3879: RAISE FND_API.G_EXC_ERROR;
3880: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3881: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4709: ozf_utility_pvt.debug_message('l_dates.list_header_id'|| l_dates.list_header_id);

4705: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4706: END IF;
4707:
4708: IF l_dates.custom_setup_id = 118 THEN
4709: ozf_utility_pvt.debug_message('l_dates.list_header_id'|| l_dates.list_header_id);
4710: IF l_dates.start_date_active IS NOT NULL AND l_dates.start_date_active <> FND_API.G_MISS_DATE THEN
4711: -- if effective date is before start_date of the offer update the start_date of the offer
4712: IF l_dates.effective_date < l_dates.start_date_active THEN
4713: UPDATE ozf_sd_request_headers_all_b

Line 4754: ozf_utility_pvt.debug_message('GR Updated header date:'||x_return_status);

4750: ,x_msg_count => x_msg_count
4751: ,x_msg_data => x_msg_data
4752: ,p_offerAdjustmentId => p_offerAdjustmentId
4753: );
4754: ozf_utility_pvt.debug_message('GR Updated header date:'||x_return_status);
4755: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4756: RAISE FND_API.G_EXC_ERROR;
4757: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4767: ozf_utility_pvt.debug_message('after process old discounts :'||x_return_status);

4763: ,x_msg_count => x_msg_count
4764: ,x_msg_data => x_msg_data
4765: ,p_offerAdjustmentId => p_offerAdjustmentId
4766: );
4767: ozf_utility_pvt.debug_message('after process old discounts :'||x_return_status);
4768: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4769: RAISE FND_API.G_EXC_ERROR;
4770: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4780: ozf_utility_pvt.debug_message('process new products :'||x_return_status);

4776: ,x_msg_count => x_msg_count
4777: ,x_msg_data => x_msg_data
4778: ,p_offerAdjustmentId => p_offerAdjustmentId
4779: );
4780: ozf_utility_pvt.debug_message('process new products :'||x_return_status);
4781: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4782: RAISE FND_API.G_EXC_ERROR;
4783: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4784: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;