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_SD_BATCH_FEED_PVT dependencies on OZF_SD_UTIL_PVT

Line 955: WHEN ((lines.claim_amount_currency_code = l_func_currency) AND (l_func_currency <> l_batch_currency)) THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(lines.claim_amount_currency_code,

951: original_claim_amount,
952: lines.batch_line_id,
953: CASE
954: WHEN (lines.claim_amount_currency_code = l_batch_currency) THEN lines.BATCH_CURR_CLAIM_AMOUNT
955: WHEN ((lines.claim_amount_currency_code = l_func_currency) AND (l_func_currency <> l_batch_currency)) THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(lines.claim_amount_currency_code,
956: l_batch_currency,
957: l_func_currency,
958: (SELECT fu.exchange_rate_type
959: FROM ozf_funds_utilized_all_b fu

Line 966: WHEN (lines.claim_amount_currency_code <> l_func_currency) THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(lines.claim_amount_currency_code,

962: NULL,
963: sysdate,
964: lines.claim_amount)
965:
966: WHEN (lines.claim_amount_currency_code <> l_func_currency) THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(lines.claim_amount_currency_code,
967: l_batch_currency,
968: l_func_currency,
969: (SELECT fu.exchange_rate_type
970: FROM ozf_funds_utilized_all_b fu

Line 1022: ozf_sd_util_pvt.sd_raise_event (l_batch_id, 'RESPONSE', x_return_status);

1018: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::update_data',
1019: 'Batch Id: '||l_batch_id||' and Batch Status: '||l_batch_status);
1020:
1021: --raising business event
1022: ozf_sd_util_pvt.sd_raise_event (l_batch_id, 'RESPONSE', x_return_status);
1023:
1024: IF l_batch_status NOT IN ('WIP','SUBMITTED' ) THEN
1025: UPDATE ozf_sd_batch_lines_int_all
1026: SET processed_flag = 'E',

Line 1373: --For batch Currency Claim Amount 2 step Conversion i.e accrual date to sysdate is taken care by OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY API

1369: WHERE ship_frm_sd_claim_request_id = p_batch_number
1370: AND processed_flag = 'N';
1371:
1372: -- Update status_code,claim amount,batch_curr_claim_amount and quantity_shipped for over approved lines
1373: --For batch Currency Claim Amount 2 step Conversion i.e accrual date to sysdate is taken care by OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY API
1374: UPDATE ozf_sd_batch_lines_all
1375: SET status_code = 'APPROVED',
1376: claim_amount = ozf_utility_pvt.currround(CASE
1377: WHEN((approved_amount is null and quantity_approved is null) OR ( approved_currency_code <> CLAIM_AMOUNT_CURRENCY_CODE ) OR approved_amount < 0 OR (original_claim_amount > 0 and quantity_approved < 0) ) then 0

Line 1407: WHEN ((claim_amount_currency_code = l_func_currency) AND (l_func_currency <> l_batch_currency)) THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(claim_amount_currency_code,

1403: WHEN (quantity_approved is not null and approved_amount is not null AND DISCOUNT_TYPE IN ('NEWPRICE','%')) THEN ((list_price - approved_amount) * quantity_approved)
1404: WHEN (quantity_approved is not null and approved_amount is not null AND DISCOUNT_TYPE IN ('AMT')) THEN ((approved_amount) * quantity_approved)
1405: ELSE 0
1406: END,CLAIM_AMOUNT_CURRENCY_CODE)
1407: WHEN ((claim_amount_currency_code = l_func_currency) AND (l_func_currency <> l_batch_currency)) THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(claim_amount_currency_code,
1408: l_batch_currency,
1409: l_func_currency,
1410: (SELECT fu.exchange_rate_type
1411: FROM ozf_funds_utilized_all_b fu

Line 1431: WHEN (claim_amount_currency_code <> l_func_currency) THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(claim_amount_currency_code,

1427: WHEN (quantity_approved is not null and approved_amount is not null AND DISCOUNT_TYPE IN ('NEWPRICE','%')) THEN ((list_price - approved_amount) * quantity_approved)
1428: WHEN (quantity_approved is not null and approved_amount is not null AND DISCOUNT_TYPE IN ('AMT')) THEN ((approved_amount) * quantity_approved)
1429: END)
1430:
1431: WHEN (claim_amount_currency_code <> l_func_currency) THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(claim_amount_currency_code,
1432: l_batch_currency,
1433: l_func_currency,
1434: (SELECT fu.exchange_rate_type
1435: FROM ozf_funds_utilized_all_b fu

Line 1551: WHEN ((claim_amount_currency_code = l_func_currency) AND (l_func_currency <> l_batch_currency)) THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(claim_amount_currency_code,

1547: WHEN (quantity_approved is not null and approved_amount is not null AND DISCOUNT_TYPE IN ('NEWPRICE','%')) THEN ((list_price - approved_amount) * quantity_approved)
1548: WHEN (quantity_approved is not null and approved_amount is not null AND DISCOUNT_TYPE IN ('AMT')) THEN ((approved_amount) * quantity_approved)
1549: ELSE 0
1550: END,CLAIM_AMOUNT_CURRENCY_CODE))
1551: WHEN ((claim_amount_currency_code = l_func_currency) AND (l_func_currency <> l_batch_currency)) THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(claim_amount_currency_code,
1552: l_batch_currency,
1553: l_func_currency,
1554: (SELECT fu.exchange_rate_type
1555: FROM ozf_funds_utilized_all_b fu

Line 1576: WHEN (claim_amount_currency_code <> l_func_currency) THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(claim_amount_currency_code,

1572: WHEN (quantity_approved is not null and approved_amount is not null AND DISCOUNT_TYPE IN ('AMT')) THEN ((approved_amount) * quantity_approved)
1573: ELSE 0
1574: END,CLAIM_AMOUNT_CURRENCY_CODE))
1575:
1576: WHEN (claim_amount_currency_code <> l_func_currency) THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(claim_amount_currency_code,
1577: l_batch_currency,
1578: l_func_currency,
1579: (SELECT fu.exchange_rate_type
1580: FROM ozf_funds_utilized_all_b fu

Line 1804: WHEN ((claim_amount_currency_code = l_func_currency) AND (l_func_currency <> l_batch_currency)) THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(claim_amount_currency_code,

1800: WHEN (quantity_approved is not null and approved_amount is not null AND DISCOUNT_TYPE IN ('NEWPRICE','%')) THEN ((list_price - approved_amount) * quantity_approved)
1801: WHEN (quantity_approved is not null and approved_amount is not null AND DISCOUNT_TYPE IN ('AMT')) THEN ((approved_amount) * quantity_approved)
1802: ELSE 0
1803: END,CLAIM_AMOUNT_CURRENCY_CODE)
1804: WHEN ((claim_amount_currency_code = l_func_currency) AND (l_func_currency <> l_batch_currency)) THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(claim_amount_currency_code,
1805: l_batch_currency,
1806: l_func_currency,
1807: (SELECT fu.exchange_rate_type
1808: FROM ozf_funds_utilized_all_b fu

Line 1828: WHEN (claim_amount_currency_code <> l_func_currency) THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(claim_amount_currency_code,

1824: WHEN (quantity_approved is not null and approved_amount is not null AND DISCOUNT_TYPE IN ('NEWPRICE','%')) THEN ((list_price - approved_amount) * quantity_approved)
1825: WHEN (quantity_approved is not null and approved_amount is not null AND DISCOUNT_TYPE IN ('AMT')) THEN ((approved_amount) * quantity_approved)
1826: END)
1827:
1828: WHEN (claim_amount_currency_code <> l_func_currency) THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(claim_amount_currency_code,
1829: l_batch_currency,
1830: l_func_currency,
1831: (SELECT fu.exchange_rate_type
1832: FROM ozf_funds_utilized_all_b fu

Line 1914: WHEN ((claim_amount_currency_code = l_func_currency) AND (l_func_currency <> l_batch_currency)) THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(claim_amount_currency_code,

1910: WHEN (quantity_approved is not null and approved_amount is not null AND DISCOUNT_TYPE IN ('NEWPRICE','%')) THEN ((list_price - approved_amount) * quantity_approved)
1911: WHEN (quantity_approved is not null and approved_amount is not null AND DISCOUNT_TYPE IN ('AMT')) THEN ((approved_amount) * quantity_approved)
1912: ELSE 0
1913: END,CLAIM_AMOUNT_CURRENCY_CODE)
1914: WHEN ((claim_amount_currency_code = l_func_currency) AND (l_func_currency <> l_batch_currency)) THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(claim_amount_currency_code,
1915: l_batch_currency,
1916: l_func_currency,
1917: (SELECT fu.exchange_rate_type
1918: FROM ozf_funds_utilized_all_b fu

Line 1938: WHEN (claim_amount_currency_code <> l_func_currency) THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(claim_amount_currency_code,

1934: WHEN (quantity_approved is not null and approved_amount is not null AND DISCOUNT_TYPE IN ('NEWPRICE','%')) THEN ((list_price - approved_amount) * quantity_approved)
1935: WHEN (quantity_approved is not null and approved_amount is not null AND DISCOUNT_TYPE IN ('AMT')) THEN ((approved_amount) * quantity_approved)
1936: END)
1937:
1938: WHEN (claim_amount_currency_code <> l_func_currency) THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(claim_amount_currency_code,
1939: l_batch_currency,
1940: l_func_currency,
1941: (SELECT fu.exchange_rate_type
1942: FROM ozf_funds_utilized_all_b fu

Line 2055: WHEN ((claim_amount_currency_code = l_func_currency) AND (l_func_currency <> l_batch_currency)) THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(claim_amount_currency_code,

2051: WHEN (quantity_approved is not null and approved_amount is not null AND DISCOUNT_TYPE IN ('NEWPRICE','%')) THEN ((list_price - approved_amount) * quantity_approved)
2052: WHEN (quantity_approved is not null and approved_amount is not null AND DISCOUNT_TYPE IN ('AMT')) THEN ((approved_amount) * quantity_approved)
2053: ELSE 0
2054: END,CLAIM_AMOUNT_CURRENCY_CODE))
2055: WHEN ((claim_amount_currency_code = l_func_currency) AND (l_func_currency <> l_batch_currency)) THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(claim_amount_currency_code,
2056: l_batch_currency,
2057: l_func_currency,
2058: (SELECT fu.exchange_rate_type
2059: FROM ozf_funds_utilized_all_b fu

Line 2080: WHEN (claim_amount_currency_code <> l_func_currency) THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(claim_amount_currency_code,

2076: WHEN (quantity_approved is not null and approved_amount is not null AND DISCOUNT_TYPE IN ('AMT')) THEN ((approved_amount) * quantity_approved)
2077: ELSE 0
2078: END,CLAIM_AMOUNT_CURRENCY_CODE))
2079:
2080: WHEN (claim_amount_currency_code <> l_func_currency) THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(claim_amount_currency_code,
2081: l_batch_currency,
2082: l_func_currency,
2083: (SELECT fu.exchange_rate_type
2084: FROM ozf_funds_utilized_all_b fu

Line 2546: WHEN ((claim_amount_currency_code = l_func_currency) AND (l_func_currency <> l_batch_currency)) THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(claim_amount_currency_code,

2542: WHEN (quantity_approved is not null and approved_amount is not null AND DISCOUNT_TYPE IN ('NEWPRICE','%')) THEN ((list_price - approved_amount) * quantity_approved)
2543: WHEN (quantity_approved is not null and approved_amount is not null AND DISCOUNT_TYPE IN ('AMT')) THEN ((approved_amount) * quantity_approved)
2544: ELSE 0
2545: END,CLAIM_AMOUNT_CURRENCY_CODE)
2546: WHEN ((claim_amount_currency_code = l_func_currency) AND (l_func_currency <> l_batch_currency)) THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(claim_amount_currency_code,
2547: l_batch_currency,
2548: l_func_currency,
2549: (SELECT fu.exchange_rate_type
2550: FROM ozf_funds_utilized_all_b fu

Line 2570: WHEN (claim_amount_currency_code <> l_func_currency) THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(claim_amount_currency_code,

2566: WHEN (quantity_approved is not null and approved_amount is not null AND DISCOUNT_TYPE IN ('NEWPRICE','%')) THEN ((list_price - approved_amount) * quantity_approved)
2567: WHEN (quantity_approved is not null and approved_amount is not null AND DISCOUNT_TYPE IN ('AMT')) THEN ((approved_amount) * quantity_approved)
2568: END)
2569:
2570: WHEN (claim_amount_currency_code <> l_func_currency) THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(claim_amount_currency_code,
2571: l_batch_currency,
2572: l_func_currency,
2573: (SELECT fu.exchange_rate_type
2574: FROM ozf_funds_utilized_all_b fu

Line 2709: THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(l_batch_line_tbl_rec.claim_amount_currency_code,

2705: ELSE 0
2706: END,l_batch_line_tbl_rec.CLAIM_AMOUNT_CURRENCY_CODE)
2707: WHEN ((l_batch_line_tbl_rec.claim_amount_currency_code = l_func_currency)
2708: AND (l_func_currency <> l_batch_currency))
2709: THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(l_batch_line_tbl_rec.claim_amount_currency_code,
2710: l_batch_currency,
2711: l_func_currency,
2712: (SELECT fu.exchange_rate_type
2713: FROM ozf_funds_utilized_all_b fu,

Line 2757: THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(l_batch_line_tbl_rec.claim_amount_currency_code,

2753: ELSE 0
2754: END)
2755:
2756: WHEN (l_batch_line_tbl_rec.claim_amount_currency_code <> l_func_currency)
2757: THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(l_batch_line_tbl_rec.claim_amount_currency_code,
2758: l_batch_currency,
2759: l_func_currency,
2760: (SELECT fu.exchange_rate_type
2761: FROM ozf_funds_utilized_all_b fu,

Line 3052: WHEN ((claim_amount_currency_code = l_func_currency) AND (l_func_currency <> l_batch_currency)) THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(claim_amount_currency_code,

3048: WHEN (quantity_approved is not null and approved_amount is not null AND DISCOUNT_TYPE IN ('NEWPRICE','%')) THEN ((list_price - approved_amount) * quantity_approved)
3049: WHEN (quantity_approved is not null and approved_amount is not null AND DISCOUNT_TYPE IN ('AMT')) THEN ((approved_amount) * quantity_approved)
3050: ELSE 0
3051: END,CLAIM_AMOUNT_CURRENCY_CODE)
3052: WHEN ((claim_amount_currency_code = l_func_currency) AND (l_func_currency <> l_batch_currency)) THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(claim_amount_currency_code,
3053: l_batch_currency,
3054: l_func_currency,
3055: (SELECT fu.exchange_rate_type
3056: FROM ozf_funds_utilized_all_b fu

Line 3076: WHEN (claim_amount_currency_code <> l_func_currency) THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(claim_amount_currency_code,

3072: WHEN (quantity_approved is not null and approved_amount is not null AND DISCOUNT_TYPE IN ('NEWPRICE','%')) THEN ((list_price - approved_amount) * quantity_approved)
3073: WHEN (quantity_approved is not null and approved_amount is not null AND DISCOUNT_TYPE IN ('AMT')) THEN ((approved_amount) * quantity_approved)
3074: END)
3075:
3076: WHEN (claim_amount_currency_code <> l_func_currency) THEN OZF_SD_UTIL_PVT.GET_CONVERTED_CURRENCY(claim_amount_currency_code,
3077: l_batch_currency,
3078: l_func_currency,
3079: (SELECT fu.exchange_rate_type
3080: FROM ozf_funds_utilized_all_b fu

Line 3125: ozf_sd_util_pvt.sd_raise_event (l_new_batch_id, 'CREATE', x_return_status);

3121:
3122: ozf_utility_pvt.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'OZF_SD_BATCH_FEED_PVT::CREATE_CHILD_BATCH',
3123: 'Procedure Ends');
3124: --raising business event
3125: ozf_sd_util_pvt.sd_raise_event (l_new_batch_id, 'CREATE', x_return_status);
3126:
3127: PROCESS_COMP_APPR_BATCH(l_new_batch_id, x_return_status, x_msg_data);
3128:
3129: END PROCESS_CHILD_BATCH;

Line 3214: ozf_sd_util_pvt.sd_raise_event (l_new_batch_id, 'CREATE', x_return_status);

3210: AND status_code = 'APPROVED'
3211: AND purge_flag <> 'Y';
3212:
3213: --raising business event
3214: ozf_sd_util_pvt.sd_raise_event (l_new_batch_id, 'CREATE', x_return_status);
3215:
3216: SAVEPOINT BEF_INVOKE_CLM_CHILD_BATCH;
3217:
3218: --Start:Fix for Bug#10628160 - Create a Claim with new custom setup for -ve amount

Line 3273: OZF_SD_UTIL_PVT.CREATE_ADJUSTMENT(l_new_batch_id, 'F', x_return_status, l_msg_count, x_msg_data);

3269: PROCESS_CLAIM(l_new_batch_id, x_return_status, x_msg_data, l_claim_id);
3270:
3271: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN -- If claim is successful
3272:
3273: OZF_SD_UTIL_PVT.CREATE_ADJUSTMENT(l_new_batch_id, 'F', x_return_status, l_msg_count, x_msg_data);
3274:
3275: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN -- If adjustment is successful
3276: --raising business event
3277: ozf_sd_util_pvt.sd_raise_event (l_new_batch_id, 'CLAIM', x_return_status);

Line 3277: ozf_sd_util_pvt.sd_raise_event (l_new_batch_id, 'CLAIM', x_return_status);

3273: OZF_SD_UTIL_PVT.CREATE_ADJUSTMENT(l_new_batch_id, 'F', x_return_status, l_msg_count, x_msg_data);
3274:
3275: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN -- If adjustment is successful
3276: --raising business event
3277: ozf_sd_util_pvt.sd_raise_event (l_new_batch_id, 'CLAIM', x_return_status);
3278: UPDATE ozf_sd_batch_headers_all
3279: SET status_code = 'CLOSED',
3280: claim_id = l_claim_id,
3281: last_update_date = sysdate,

Line 3400: OZF_SD_UTIL_PVT.CREATE_ADJUSTMENT(p_batch_id, 'F', x_return_status, l_msg_count, x_msg_data); -- to pass p_comp_wrt_off

3396: PROCESS_CLAIM(p_batch_id, x_return_status, x_msg_data, l_claim_id);
3397:
3398: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3399:
3400: OZF_SD_UTIL_PVT.CREATE_ADJUSTMENT(p_batch_id, 'F', x_return_status, l_msg_count, x_msg_data); -- to pass p_comp_wrt_off
3401:
3402: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3403: --raising business event
3404: ozf_sd_util_pvt.sd_raise_event (p_batch_id, 'CLAIM', x_return_status);

Line 3404: ozf_sd_util_pvt.sd_raise_event (p_batch_id, 'CLAIM', x_return_status);

3400: OZF_SD_UTIL_PVT.CREATE_ADJUSTMENT(p_batch_id, 'F', x_return_status, l_msg_count, x_msg_data); -- to pass p_comp_wrt_off
3401:
3402: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3403: --raising business event
3404: ozf_sd_util_pvt.sd_raise_event (p_batch_id, 'CLAIM', x_return_status);
3405: UPDATE ozf_sd_batch_headers_all
3406: SET status_code = 'CLOSED',
3407: claim_id = l_claim_id,
3408: last_update_date = sysdate,