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

Line 248: OZF_Utility_PVT.debug_message(l_full_name||': start');

244: --------------------- initialize -----------------------
245: SAVEPOINT Check_Create_Line_Hist;
246:
247: IF OZF_DEBUG_HIGH_ON THEN
248: OZF_Utility_PVT.debug_message(l_full_name||': start');
249: END IF;
250:
251: IF FND_API.to_boolean(p_init_msg_list) THEN
252: FND_MSG_PUB.initialize;

Line 359: OZF_Utility_PVT.debug_message(l_full_name||': p_mode should be CREATE, UPDATE, or DELETE');

355: x_create_hist_flag := 'Y';
356: END IF;
357: ELSE
358: IF OZF_DEBUG_HIGH_ON THEN
359: OZF_Utility_PVT.debug_message(l_full_name||': p_mode should be CREATE, UPDATE, or DELETE');
360: END IF;
361: RAISE FND_API.g_exc_error;
362: END IF;
363:

Line 372: OZF_Utility_PVT.debug_message(l_full_name ||': end');

368: p_data => x_msg_data
369: );
370:
371: IF OZF_DEBUG_HIGH_ON THEN
372: OZF_Utility_PVT.debug_message(l_full_name ||': end');
373: END IF;
374:
375: EXCEPTION
376: WHEN FND_API.g_exc_error THEN

Line 550: OZF_UTILITY_PVT.Convert_Currency(

546: ELSE
547: OPEN csr_function_currency;
548: FETCH csr_function_currency INTO l_function_currency;
549: CLOSE csr_function_currency;
550: OZF_UTILITY_PVT.Convert_Currency(
551: p_from_currency => l_function_currency
552: ,p_to_currency => l_default_currency
553: ,p_conv_type => l_default_exc_type
554: ,p_conv_rate => 1/l_default_exc_rate -- Bug4437696

Line 679: OZF_Utility_PVT.debug_message(l_full_name||': start');

675: --------------------- initialize -----------------------
676: SAVEPOINT Update_Line_Fm_Claim;
677:
678: IF OZF_DEBUG_HIGH_ON THEN
679: OZF_Utility_PVT.debug_message(l_full_name||': start');
680: END IF;
681:
682: IF FND_API.to_boolean(p_init_msg_list) THEN
683: FND_MSG_PUB.initialize;

Line 829: OZF_Utility_PVT.debug_message('ULFC:STEP 4:'||'line_tbl('||l_line_counter||')'||

825: , l_claim_line_tbl(l_line_counter).claim_currency_amount
826: , l_claim_line_tbl(l_line_counter).tax_code
827: , l_claim_line_tbl(l_line_counter).earnings_associated_flag; --Bug:2781186
828: IF OZF_DEBUG_HIGH_ON THEN
829: OZF_Utility_PVT.debug_message('ULFC:STEP 4:'||'line_tbl('||l_line_counter||')'||
830: l_claim_line_tbl(l_line_counter).claim_currency_amount);
831: END IF;
832: l_line_counter := l_line_counter + 1;
833: EXIT WHEN csr_line_rec_upd%NOTFOUND;

Line 915: OZF_Utility_PVT.debug_message(l_full_name ||': end');

911: p_data => x_msg_data
912: );
913:
914: IF OZF_DEBUG_HIGH_ON THEN
915: OZF_Utility_PVT.debug_message(l_full_name ||': end');
916: END IF;
917:
918: EXCEPTION
919: WHEN FND_API.g_exc_error THEN

Line 1021: OZF_Utility_PVT.debug_message(l_full_name||': start');

1017: --------------------- initialize -----------------------
1018: SAVEPOINT Update_Line_Fm_Claim;
1019:
1020: IF OZF_DEBUG_HIGH_ON THEN
1021: OZF_Utility_PVT.debug_message(l_full_name||': start');
1022: END IF;
1023:
1024: IF FND_API.to_boolean(p_init_msg_list) THEN
1025: FND_MSG_PUB.initialize;

Line 1076: OZF_Utility_PVT.debug_message('line_tbl('||l_line_counter||')'||

1072: , l_claim_line_tbl(l_line_counter).earnings_associated_flag;
1073: EXIT WHEN csr_line_rec_upd%NOTFOUND;
1074:
1075: IF OZF_DEBUG_HIGH_ON THEN
1076: OZF_Utility_PVT.debug_message('line_tbl('||l_line_counter||')'||
1077: l_claim_line_tbl(l_line_counter).claim_currency_amount);
1078: END IF;
1079:
1080: l_line_counter := l_line_counter + 1;

Line 1154: OZF_Utility_PVT.debug_message(l_full_name ||': end');

1150: p_data => x_msg_data
1151: );
1152:
1153: IF OZF_DEBUG_HIGH_ON THEN
1154: OZF_Utility_PVT.debug_message(l_full_name ||': end');
1155: END IF;
1156:
1157: EXCEPTION
1158: WHEN FND_API.g_exc_error THEN

Line 1276: OZF_Utility_PVT.debug_message(l_full_name||': start');

1272: --------------------- initialize -----------------------
1273: SAVEPOINT Create_Claim_Line_Tbl;
1274:
1275: IF OZF_DEBUG_HIGH_ON THEN
1276: OZF_Utility_PVT.debug_message(l_full_name||': start');
1277: END IF;
1278:
1279: IF FND_API.to_boolean(p_init_msg_list) THEN
1280: FND_MSG_PUB.initialize;

Line 1308: , P_user_id => OZF_UTILITY_PVT.get_resource_id(NVL(FND_GLOBAL.user_id,-1))

1304: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1305: , P_Commit => FND_API.G_FALSE
1306: , P_object_id => p_claim_line_tbl(j).claim_id
1307: , P_object_type => G_CLAIM_OBJECT_TYPE
1308: , P_user_id => OZF_UTILITY_PVT.get_resource_id(NVL(FND_GLOBAL.user_id,-1))
1309: , X_Return_Status => l_return_status
1310: , X_Msg_Count => l_msg_count
1311: , X_Msg_Data => l_msg_data
1312: , X_access => l_access);

Line 1378: OZF_Utility_PVT.debug_message('Old Quantity from ra_customer_trx_lines_all is ' || l_inv_quantity);

1374: FETCH c_old_line_qty INTO l_inv_quantity;
1375: CLOSE c_old_line_qty;
1376:
1377: IF OZF_DEBUG_HIGH_ON THEN
1378: OZF_Utility_PVT.debug_message('Old Quantity from ra_customer_trx_lines_all is ' || l_inv_quantity);
1379: OZF_Utility_PVT.debug_message('Current Claim Line Quantity is ' || l_claim_line_tbl(j).quantity);
1380: OZF_Utility_PVT.debug_message('Total Claim Line Quantity for source_object_line_id '|| l_claim_line_tbl(j).source_object_line_id || 'is ' || l_tot_quantity);
1381: END IF;
1382:

Line 1379: OZF_Utility_PVT.debug_message('Current Claim Line Quantity is ' || l_claim_line_tbl(j).quantity);

1375: CLOSE c_old_line_qty;
1376:
1377: IF OZF_DEBUG_HIGH_ON THEN
1378: OZF_Utility_PVT.debug_message('Old Quantity from ra_customer_trx_lines_all is ' || l_inv_quantity);
1379: OZF_Utility_PVT.debug_message('Current Claim Line Quantity is ' || l_claim_line_tbl(j).quantity);
1380: OZF_Utility_PVT.debug_message('Total Claim Line Quantity for source_object_line_id '|| l_claim_line_tbl(j).source_object_line_id || 'is ' || l_tot_quantity);
1381: END IF;
1382:
1383: IF l_inv_quantity < l_tot_quantity THEN

Line 1380: OZF_Utility_PVT.debug_message('Total Claim Line Quantity for source_object_line_id '|| l_claim_line_tbl(j).source_object_line_id || 'is ' || l_tot_quantity);

1376:
1377: IF OZF_DEBUG_HIGH_ON THEN
1378: OZF_Utility_PVT.debug_message('Old Quantity from ra_customer_trx_lines_all is ' || l_inv_quantity);
1379: OZF_Utility_PVT.debug_message('Current Claim Line Quantity is ' || l_claim_line_tbl(j).quantity);
1380: OZF_Utility_PVT.debug_message('Total Claim Line Quantity for source_object_line_id '|| l_claim_line_tbl(j).source_object_line_id || 'is ' || l_tot_quantity);
1381: END IF;
1382:
1383: IF l_inv_quantity < l_tot_quantity THEN
1384: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 1413: OZF_Utility_PVT.debug_message('Before CurrRound :: claim line currency_currency_amount = '||l_claim_line_tbl(j).claim_currency_amount);

1409: x_error_index := j;
1410: RAISE FND_API.g_exc_error;
1411: ELSE
1412: IF OZF_DEBUG_HIGH_ON THEN
1413: OZF_Utility_PVT.debug_message('Before CurrRound :: claim line currency_currency_amount = '||l_claim_line_tbl(j).claim_currency_amount);
1414: OZF_Utility_PVT.debug_message('Before CurrRound :: claim currency code = '||l_currency_code);
1415: END IF;
1416: l_claim_line_tbl(j).claim_currency_amount := OZF_UTILITY_PVT.CurrRound(l_claim_line_tbl(j).claim_currency_amount, l_currency_code);
1417: END IF;

Line 1414: OZF_Utility_PVT.debug_message('Before CurrRound :: claim currency code = '||l_currency_code);

1410: RAISE FND_API.g_exc_error;
1411: ELSE
1412: IF OZF_DEBUG_HIGH_ON THEN
1413: OZF_Utility_PVT.debug_message('Before CurrRound :: claim line currency_currency_amount = '||l_claim_line_tbl(j).claim_currency_amount);
1414: OZF_Utility_PVT.debug_message('Before CurrRound :: claim currency code = '||l_currency_code);
1415: END IF;
1416: l_claim_line_tbl(j).claim_currency_amount := OZF_UTILITY_PVT.CurrRound(l_claim_line_tbl(j).claim_currency_amount, l_currency_code);
1417: END IF;
1418:

Line 1416: l_claim_line_tbl(j).claim_currency_amount := OZF_UTILITY_PVT.CurrRound(l_claim_line_tbl(j).claim_currency_amount, l_currency_code);

1412: IF OZF_DEBUG_HIGH_ON THEN
1413: OZF_Utility_PVT.debug_message('Before CurrRound :: claim line currency_currency_amount = '||l_claim_line_tbl(j).claim_currency_amount);
1414: OZF_Utility_PVT.debug_message('Before CurrRound :: claim currency code = '||l_currency_code);
1415: END IF;
1416: l_claim_line_tbl(j).claim_currency_amount := OZF_UTILITY_PVT.CurrRound(l_claim_line_tbl(j).claim_currency_amount, l_currency_code);
1417: END IF;
1418:
1419: l_create_total_amt := l_create_total_amt + l_claim_line_tbl(j).claim_currency_amount;
1420: l_claim_id := p_claim_line_tbl(j).claim_id;

Line 1434: OZF_Utility_PVT.debug_message('exist_total_amt:' || l_exist_total_amt );

1430: CLOSE c_exist_total_line_amt;
1431:
1432:
1433: IF OZF_DEBUG_HIGH_ON THEN
1434: OZF_Utility_PVT.debug_message('exist_total_amt:' || l_exist_total_amt );
1435: OZF_Utility_PVT.debug_message('create_total_amt:' || l_create_total_amt );
1436: OZF_Utility_PVT.debug_message('claim_amount:' || l_claim_amount );
1437: END IF;
1438: --Check for the sum of line amount sign. It should be same as that claims remaining amount.

Line 1435: OZF_Utility_PVT.debug_message('create_total_amt:' || l_create_total_amt );

1431:
1432:
1433: IF OZF_DEBUG_HIGH_ON THEN
1434: OZF_Utility_PVT.debug_message('exist_total_amt:' || l_exist_total_amt );
1435: OZF_Utility_PVT.debug_message('create_total_amt:' || l_create_total_amt );
1436: OZF_Utility_PVT.debug_message('claim_amount:' || l_claim_amount );
1437: END IF;
1438: --Check for the sum of line amount sign. It should be same as that claims remaining amount.
1439: --Skip the check in case of Subsequent Receipt Application.

Line 1436: OZF_Utility_PVT.debug_message('claim_amount:' || l_claim_amount );

1432:
1433: IF OZF_DEBUG_HIGH_ON THEN
1434: OZF_Utility_PVT.debug_message('exist_total_amt:' || l_exist_total_amt );
1435: OZF_Utility_PVT.debug_message('create_total_amt:' || l_create_total_amt );
1436: OZF_Utility_PVT.debug_message('claim_amount:' || l_claim_amount );
1437: END IF;
1438: --Check for the sum of line amount sign. It should be same as that claims remaining amount.
1439: --Skip the check in case of Subsequent Receipt Application.
1440: IF l_claim_class <> 'GROUP' THEN

Line 1520: OZF_Utility_PVT.debug_message(l_full_name ||': end');

1516: p_data => x_msg_data
1517: );
1518:
1519: IF OZF_DEBUG_HIGH_ON THEN
1520: OZF_Utility_PVT.debug_message(l_full_name ||': end');
1521: END IF;
1522:
1523: EXCEPTION
1524: WHEN FND_API.g_exc_error THEN

Line 1700: OZF_Utility_PVT.debug_message(l_full_name||': start');

1696: --------------------- initialize -----------------------
1697: SAVEPOINT Create_Claim_Line;
1698:
1699: IF OZF_DEBUG_HIGH_ON THEN
1700: OZF_Utility_PVT.debug_message(l_full_name||': start');
1701: END IF;
1702:
1703: IF FND_API.to_boolean(p_init_msg_list) THEN
1704: FND_MSG_PUB.initialize;

Line 1729: , P_user_id => OZF_UTILITY_PVT.get_resource_id(NVL(FND_GLOBAL.user_id,-1))

1725: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1726: , P_Commit => FND_API.G_FALSE
1727: , P_object_id => l_claim_line_rec.claim_id
1728: , P_object_type => G_CLAIM_OBJECT_TYPE
1729: , P_user_id => OZF_UTILITY_PVT.get_resource_id(NVL(FND_GLOBAL.user_id,-1))
1730: , X_Return_Status => l_return_status
1731: , X_Msg_Count => x_msg_count
1732: , X_Msg_Data => x_msg_data
1733: , X_access => l_access);

Line 1856: OZF_UTILITY_PVT.Convert_Currency(

1852: END IF;
1853: IF (l_convert_acctd_amount = 'T') THEN
1854: */
1855: -- Convert ACCTD_AMOUNT
1856: OZF_UTILITY_PVT.Convert_Currency(
1857: P_SET_OF_BOOKS_ID => l_claim_line_rec.set_of_books_id,
1858: P_FROM_CURRENCY => l_claim_currency,
1859: P_CONVERSION_DATE => l_claim_exc_date,
1860: P_CONVERSION_TYPE => l_claim_exc_type,

Line 1911: OZF_Utility_PVT.debug_message(l_full_name ||': validate');

1907: /*-------------------------------------------------------*
1908: | validate |
1909: *-------------------------------------------------------*/
1910: IF OZF_DEBUG_HIGH_ON THEN
1911: OZF_Utility_PVT.debug_message(l_full_name ||': validate');
1912: END IF;
1913:
1914: Validate_Claim_Line(
1915: p_api_version => l_api_version,

Line 1931: l_claim_line_rec.claim_currency_amount := OZF_UTILITY_PVT.CurrRound(l_claim_line_rec.claim_currency_amount, l_claim_currency);

1927: END IF;
1928:
1929: ------------------- amount rounding --------------------
1930: IF l_claim_line_rec.claim_currency_amount IS NOT NULL THEN
1931: l_claim_line_rec.claim_currency_amount := OZF_UTILITY_PVT.CurrRound(l_claim_line_rec.claim_currency_amount, l_claim_currency);
1932: END IF;
1933:
1934: IF l_claim_line_rec.amount IS NOT NULL THEN
1935: l_claim_line_rec.amount := OZF_UTILITY_PVT.CurrRound(l_claim_line_rec.amount, l_claim_line_rec.currency_code);

Line 1935: l_claim_line_rec.amount := OZF_UTILITY_PVT.CurrRound(l_claim_line_rec.amount, l_claim_line_rec.currency_code);

1931: l_claim_line_rec.claim_currency_amount := OZF_UTILITY_PVT.CurrRound(l_claim_line_rec.claim_currency_amount, l_claim_currency);
1932: END IF;
1933:
1934: IF l_claim_line_rec.amount IS NOT NULL THEN
1935: l_claim_line_rec.amount := OZF_UTILITY_PVT.CurrRound(l_claim_line_rec.amount, l_claim_line_rec.currency_code);
1936: END IF;
1937:
1938: --Bug# 7319828 fixed by ateotia(+)
1939: --IF (l_convert_acctd_amount = 'T') THEN

Line 1941: l_claim_line_rec.acctd_amount := OZF_UTILITY_PVT.CurrRound(l_claim_line_rec.acctd_amount, l_functional_currency);

1937:
1938: --Bug# 7319828 fixed by ateotia(+)
1939: --IF (l_convert_acctd_amount = 'T') THEN
1940: IF l_claim_line_rec.acctd_amount IS NOT NULL THEN
1941: l_claim_line_rec.acctd_amount := OZF_UTILITY_PVT.CurrRound(l_claim_line_rec.acctd_amount, l_functional_currency);
1942: END IF;
1943: --END IF;
1944: --Bug# 7319828 fixed by ateotia(-)
1945:

Line 2050: OZF_Utility_PVT.debug_message(l_full_name ||': insert');

2046: /*-------------------------------------------------------*
2047: | insert |
2048: *-------------------------------------------------------*/
2049: IF OZF_DEBUG_HIGH_ON THEN
2050: OZF_Utility_PVT.debug_message(l_full_name ||': insert');
2051: OZF_Utility_PVT.debug_message('l_claim_line_rec.claim_line_id before insert :' || l_claim_line_rec.claim_line_id);
2052: END IF;
2053:
2054:

Line 2051: OZF_Utility_PVT.debug_message('l_claim_line_rec.claim_line_id before insert :' || l_claim_line_rec.claim_line_id);

2047: | insert |
2048: *-------------------------------------------------------*/
2049: IF OZF_DEBUG_HIGH_ON THEN
2050: OZF_Utility_PVT.debug_message(l_full_name ||': insert');
2051: OZF_Utility_PVT.debug_message('l_claim_line_rec.claim_line_id before insert :' || l_claim_line_rec.claim_line_id);
2052: END IF;
2053:
2054:
2055: INSERT INTO ozf_claim_lines_all (

Line 2256: OZF_Utility_PVT.debug_message(l_full_name ||': end');

2252: p_data => x_msg_data
2253: );
2254:
2255: IF OZF_DEBUG_HIGH_ON THEN
2256: OZF_Utility_PVT.debug_message(l_full_name ||': end');
2257: END IF;
2258:
2259: EXCEPTION
2260: WHEN FND_API.g_exc_error THEN

Line 2362: OZF_Utility_PVT.debug_message(l_full_name||': start');

2358: --------------------- initialize -----------------------
2359: SAVEPOINT Delete_Claim_Line_Tbl;
2360:
2361: IF OZF_DEBUG_HIGH_ON THEN
2362: OZF_Utility_PVT.debug_message(l_full_name||': start');
2363: END IF;
2364:
2365: IF FND_API.to_boolean(p_init_msg_list) THEN
2366: FND_MSG_PUB.initialize;

Line 2391: , P_user_id => OZF_UTILITY_PVT.get_resource_id(NVL(FND_GLOBAL.user_id,-1))

2387: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
2388: , P_Commit => FND_API.G_FALSE
2389: , P_object_id => p_claim_line_tbl(j).claim_id
2390: , P_object_type => G_CLAIM_OBJECT_TYPE
2391: , P_user_id => OZF_UTILITY_PVT.get_resource_id(NVL(FND_GLOBAL.user_id,-1))
2392: , X_Return_Status => l_return_status
2393: , X_Msg_Count => l_msg_count
2394: , X_Msg_Data => l_msg_data
2395: , X_access => l_access);

Line 2464: OZF_Utility_PVT.debug_message('l_object_version11:' || l_object_version);

2460: OPEN csr_line_obj_ver(p_claim_line_tbl(i).claim_line_id);
2461: FETCH csr_line_obj_ver INTO l_object_version;
2462: CLOSE csr_line_obj_ver;
2463: IF OZF_DEBUG_HIGH_ON THEN
2464: OZF_Utility_PVT.debug_message('l_object_version11:' || l_object_version);
2465: END IF;
2466: ELSE
2467: l_object_version := p_claim_line_tbl(i).object_version_number;
2468: IF OZF_DEBUG_HIGH_ON THEN

Line 2469: OZF_Utility_PVT.debug_message('l_object_version22:' || l_object_version);

2465: END IF;
2466: ELSE
2467: l_object_version := p_claim_line_tbl(i).object_version_number;
2468: IF OZF_DEBUG_HIGH_ON THEN
2469: OZF_Utility_PVT.debug_message('l_object_version22:' || l_object_version);
2470: END IF;
2471: END IF;
2472:
2473: IF OZF_DEBUG_HIGH_ON THEN

Line 2474: OZF_Utility_PVT.debug_message('l_object_version33:' || l_object_version);

2470: END IF;
2471: END IF;
2472:
2473: IF OZF_DEBUG_HIGH_ON THEN
2474: OZF_Utility_PVT.debug_message('l_object_version33:' || l_object_version);
2475: END IF;
2476: -- Call the delete claim line API
2477: Delete_Claim_Line(
2478: p_api_version => 1.0

Line 2511: OZF_Utility_PVT.debug_message(l_full_name ||': end');

2507: p_data => x_msg_data
2508: );
2509:
2510: IF OZF_DEBUG_HIGH_ON THEN
2511: OZF_Utility_PVT.debug_message(l_full_name ||': end');
2512: END IF;
2513:
2514: EXCEPTION
2515: WHEN FND_API.g_exc_error THEN

Line 2621: OZF_Utility_PVT.debug_message(l_full_name||': start');

2617: --------------------- initialize -----------------------
2618: SAVEPOINT Delete_Claim_Line;
2619:
2620: IF OZF_DEBUG_HIGH_ON THEN
2621: OZF_Utility_PVT.debug_message(l_full_name||': start');
2622: END IF;
2623:
2624: IF FND_API.to_boolean(p_init_msg_list) THEN
2625: FND_MSG_PUB.initialize;

Line 2652: , P_user_id => OZF_UTILITY_PVT.get_resource_id(NVL(FND_GLOBAL.user_id,-1))

2648: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
2649: , P_Commit => FND_API.G_FALSE
2650: , P_object_id => l_claim_id
2651: , P_object_type => G_CLAIM_OBJECT_TYPE
2652: , P_user_id => OZF_UTILITY_PVT.get_resource_id(NVL(FND_GLOBAL.user_id,-1))
2653: , X_Return_Status => l_return_status
2654: , X_Msg_Count => x_msg_count
2655: , X_Msg_Data => x_msg_data
2656: , X_access => l_access);

Line 2723: OZF_Utility_PVT.debug_message(l_full_name ||': delete');

2719: END IF;
2720:
2721: ------------------------ Delete ------------------------
2722: IF OZF_DEBUG_HIGH_ON THEN
2723: OZF_Utility_PVT.debug_message(l_full_name ||': delete');
2724: OZF_Utility_PVT.debug_message(p_claim_line_id ||': delete : p_claim_line_id');
2725: OZF_Utility_PVT.debug_message(p_object_version ||': delete : p_object_version');
2726: END IF;
2727:

Line 2724: OZF_Utility_PVT.debug_message(p_claim_line_id ||': delete : p_claim_line_id');

2720:
2721: ------------------------ Delete ------------------------
2722: IF OZF_DEBUG_HIGH_ON THEN
2723: OZF_Utility_PVT.debug_message(l_full_name ||': delete');
2724: OZF_Utility_PVT.debug_message(p_claim_line_id ||': delete : p_claim_line_id');
2725: OZF_Utility_PVT.debug_message(p_object_version ||': delete : p_object_version');
2726: END IF;
2727:
2728: DELETE FROM ozf_claim_lines_all

Line 2725: OZF_Utility_PVT.debug_message(p_object_version ||': delete : p_object_version');

2721: ------------------------ Delete ------------------------
2722: IF OZF_DEBUG_HIGH_ON THEN
2723: OZF_Utility_PVT.debug_message(l_full_name ||': delete');
2724: OZF_Utility_PVT.debug_message(p_claim_line_id ||': delete : p_claim_line_id');
2725: OZF_Utility_PVT.debug_message(p_object_version ||': delete : p_object_version');
2726: END IF;
2727:
2728: DELETE FROM ozf_claim_lines_all
2729: WHERE claim_line_id = p_claim_line_id

Line 2752: OZF_Utility_PVT.debug_message(l_full_name ||': end');

2748: p_data => x_msg_data
2749: );
2750:
2751: IF OZF_DEBUG_HIGH_ON THEN
2752: OZF_Utility_PVT.debug_message(l_full_name ||': end');
2753: END IF;
2754:
2755: EXCEPTION
2756: WHEN FND_API.g_exc_error THEN

Line 2824: OZF_Utility_PVT.debug_message(l_full_name||': start');

2820:
2821: BEGIN
2822: -------------------- initialize ------------------------
2823: IF OZF_DEBUG_HIGH_ON THEN
2824: OZF_Utility_PVT.debug_message(l_full_name||': start');
2825: END IF;
2826:
2827: IF FND_API.to_boolean(p_init_msg_list) THEN
2828: FND_MSG_PUB.initialize;

Line 2844: OZF_Utility_PVT.debug_message(l_full_name||': lock');

2840: x_return_status := FND_API.g_ret_sts_success;
2841:
2842: ------------------------ lock -------------------------
2843: IF OZF_DEBUG_HIGH_ON THEN
2844: OZF_Utility_PVT.debug_message(l_full_name||': lock');
2845: END IF;
2846:
2847: OPEN c_claim_line;
2848: FETCH c_claim_line INTO l_claim_line_id;

Line 2867: OZF_Utility_PVT.debug_message(l_full_name ||': end');

2863: p_data => x_msg_data
2864: );
2865:
2866: IF OZF_DEBUG_HIGH_ON THEN
2867: OZF_Utility_PVT.debug_message(l_full_name ||': end');
2868: END IF;
2869:
2870: EXCEPTION
2871: WHEN OZF_Utility_PVT.resource_locked THEN

Line 2871: WHEN OZF_Utility_PVT.resource_locked THEN

2867: OZF_Utility_PVT.debug_message(l_full_name ||': end');
2868: END IF;
2869:
2870: EXCEPTION
2871: WHEN OZF_Utility_PVT.resource_locked THEN
2872: x_return_status := FND_API.g_ret_sts_error;
2873: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2874: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCE_LOCKED');
2875: FND_MSG_PUB.add;

Line 3139: OZF_Utility_PVT.debug_message(l_full_name||': start');

3135: --------------------- initialize -----------------------
3136: SAVEPOINT Update_Claim_Line_Tbl;
3137:
3138: IF OZF_DEBUG_HIGH_ON THEN
3139: OZF_Utility_PVT.debug_message(l_full_name||': start');
3140: END IF;
3141:
3142: IF FND_API.to_boolean(p_init_msg_list) THEN
3143: FND_MSG_PUB.initialize;

Line 3170: , P_user_id => OZF_UTILITY_PVT.get_resource_id(NVL(FND_GLOBAL.user_id,-1))

3166: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
3167: , P_Commit => FND_API.G_FALSE
3168: , P_object_id => p_claim_line_tbl(j).claim_id
3169: , P_object_type => G_CLAIM_OBJECT_TYPE
3170: , P_user_id => OZF_UTILITY_PVT.get_resource_id(NVL(FND_GLOBAL.user_id,-1))
3171: , X_Return_Status => l_return_status
3172: , X_Msg_Count => l_msg_count
3173: , X_Msg_Data => l_msg_data
3174: , X_access => l_access);

Line 3250: OZF_Utility_PVT.debug_message('Old Quantity from ra_customer_trx_lines_all is ' || l_inv_quantity);

3246: FETCH c_old_line_qty INTO l_inv_quantity;
3247: CLOSE c_old_line_qty;
3248:
3249: IF OZF_DEBUG_HIGH_ON THEN
3250: OZF_Utility_PVT.debug_message('Old Quantity from ra_customer_trx_lines_all is ' || l_inv_quantity);
3251: OZF_Utility_PVT.debug_message('Current Claim Line Quantity is ' || l_claim_line_tbl(j).quantity);
3252: OZF_Utility_PVT.debug_message('Total Quantity is ' || l_tot_quantity);
3253: END IF;
3254:

Line 3251: OZF_Utility_PVT.debug_message('Current Claim Line Quantity is ' || l_claim_line_tbl(j).quantity);

3247: CLOSE c_old_line_qty;
3248:
3249: IF OZF_DEBUG_HIGH_ON THEN
3250: OZF_Utility_PVT.debug_message('Old Quantity from ra_customer_trx_lines_all is ' || l_inv_quantity);
3251: OZF_Utility_PVT.debug_message('Current Claim Line Quantity is ' || l_claim_line_tbl(j).quantity);
3252: OZF_Utility_PVT.debug_message('Total Quantity is ' || l_tot_quantity);
3253: END IF;
3254:
3255: IF l_inv_quantity < l_tot_quantity THEN

Line 3252: OZF_Utility_PVT.debug_message('Total Quantity is ' || l_tot_quantity);

3248:
3249: IF OZF_DEBUG_HIGH_ON THEN
3250: OZF_Utility_PVT.debug_message('Old Quantity from ra_customer_trx_lines_all is ' || l_inv_quantity);
3251: OZF_Utility_PVT.debug_message('Current Claim Line Quantity is ' || l_claim_line_tbl(j).quantity);
3252: OZF_Utility_PVT.debug_message('Total Quantity is ' || l_tot_quantity);
3253: END IF;
3254:
3255: IF l_inv_quantity < l_tot_quantity THEN
3256: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 3286: OZF_Utility_PVT.debug_message('Before CurrRound :: claim line currency_currency_amount = '||l_claim_line_tbl(j).claim_currency_amount);

3282: x_error_index := j;
3283: RAISE FND_API.g_exc_error;
3284: ELSE
3285: IF OZF_DEBUG_HIGH_ON THEN
3286: OZF_Utility_PVT.debug_message('Before CurrRound :: claim line currency_currency_amount = '||l_claim_line_tbl(j).claim_currency_amount);
3287: OZF_Utility_PVT.debug_message('Before CurrRound :: claim currency code = '||l_currency_code);
3288: END IF;
3289: l_claim_line_tbl(j).claim_currency_amount := OZF_UTILITY_PVT.CurrRound(l_claim_line_tbl(j).claim_currency_amount, l_currency_code);
3290: END IF;

Line 3287: OZF_Utility_PVT.debug_message('Before CurrRound :: claim currency code = '||l_currency_code);

3283: RAISE FND_API.g_exc_error;
3284: ELSE
3285: IF OZF_DEBUG_HIGH_ON THEN
3286: OZF_Utility_PVT.debug_message('Before CurrRound :: claim line currency_currency_amount = '||l_claim_line_tbl(j).claim_currency_amount);
3287: OZF_Utility_PVT.debug_message('Before CurrRound :: claim currency code = '||l_currency_code);
3288: END IF;
3289: l_claim_line_tbl(j).claim_currency_amount := OZF_UTILITY_PVT.CurrRound(l_claim_line_tbl(j).claim_currency_amount, l_currency_code);
3290: END IF;
3291:

Line 3289: l_claim_line_tbl(j).claim_currency_amount := OZF_UTILITY_PVT.CurrRound(l_claim_line_tbl(j).claim_currency_amount, l_currency_code);

3285: IF OZF_DEBUG_HIGH_ON THEN
3286: OZF_Utility_PVT.debug_message('Before CurrRound :: claim line currency_currency_amount = '||l_claim_line_tbl(j).claim_currency_amount);
3287: OZF_Utility_PVT.debug_message('Before CurrRound :: claim currency code = '||l_currency_code);
3288: END IF;
3289: l_claim_line_tbl(j).claim_currency_amount := OZF_UTILITY_PVT.CurrRound(l_claim_line_tbl(j).claim_currency_amount, l_currency_code);
3290: END IF;
3291:
3292: --l_new_upd_total_amt := l_new_upd_total_amt + OZF_UTILITY_PVT.CurrRound(l_claim_line_tbl(j).claim_currency_amount, l_currency_code);
3293: l_new_upd_total_amt := l_new_upd_total_amt + l_claim_line_tbl(j).claim_currency_amount;

Line 3292: --l_new_upd_total_amt := l_new_upd_total_amt + OZF_UTILITY_PVT.CurrRound(l_claim_line_tbl(j).claim_currency_amount, l_currency_code);

3288: END IF;
3289: l_claim_line_tbl(j).claim_currency_amount := OZF_UTILITY_PVT.CurrRound(l_claim_line_tbl(j).claim_currency_amount, l_currency_code);
3290: END IF;
3291:
3292: --l_new_upd_total_amt := l_new_upd_total_amt + OZF_UTILITY_PVT.CurrRound(l_claim_line_tbl(j).claim_currency_amount, l_currency_code);
3293: l_new_upd_total_amt := l_new_upd_total_amt + l_claim_line_tbl(j).claim_currency_amount;
3294:
3295: l_old_upd_total_amt := l_old_upd_total_amt + l_old_line_amt;
3296: --l_claim_id := p_claim_line_tbl(j).claim_id;

Line 3302: OZF_Utility_PVT.debug_message('Sign check :: exist_total_amt:' || l_exist_total_amt );

3298: END LOOP;
3299:
3300:
3301: IF OZF_DEBUG_HIGH_ON THEN
3302: OZF_Utility_PVT.debug_message('Sign check :: exist_total_amt:' || l_exist_total_amt );
3303: OZF_Utility_PVT.debug_message('Sign check :: old_upd_total_amt:' || l_old_upd_total_amt );
3304: OZF_Utility_PVT.debug_message('Sign check :: new_upd_total_amt:' || l_new_upd_total_amt );
3305: OZF_Utility_PVT.debug_message('Sign check :: claim_amount:' || l_claim_amount );
3306: OZF_Utility_PVT.debug_message('l_offer_id:' || l_offer_id );

Line 3303: OZF_Utility_PVT.debug_message('Sign check :: old_upd_total_amt:' || l_old_upd_total_amt );

3299:
3300:
3301: IF OZF_DEBUG_HIGH_ON THEN
3302: OZF_Utility_PVT.debug_message('Sign check :: exist_total_amt:' || l_exist_total_amt );
3303: OZF_Utility_PVT.debug_message('Sign check :: old_upd_total_amt:' || l_old_upd_total_amt );
3304: OZF_Utility_PVT.debug_message('Sign check :: new_upd_total_amt:' || l_new_upd_total_amt );
3305: OZF_Utility_PVT.debug_message('Sign check :: claim_amount:' || l_claim_amount );
3306: OZF_Utility_PVT.debug_message('l_offer_id:' || l_offer_id );
3307: END IF;

Line 3304: OZF_Utility_PVT.debug_message('Sign check :: new_upd_total_amt:' || l_new_upd_total_amt );

3300:
3301: IF OZF_DEBUG_HIGH_ON THEN
3302: OZF_Utility_PVT.debug_message('Sign check :: exist_total_amt:' || l_exist_total_amt );
3303: OZF_Utility_PVT.debug_message('Sign check :: old_upd_total_amt:' || l_old_upd_total_amt );
3304: OZF_Utility_PVT.debug_message('Sign check :: new_upd_total_amt:' || l_new_upd_total_amt );
3305: OZF_Utility_PVT.debug_message('Sign check :: claim_amount:' || l_claim_amount );
3306: OZF_Utility_PVT.debug_message('l_offer_id:' || l_offer_id );
3307: END IF;
3308: --Check for the sum of line amount sign. It should be same as that claims remaining amount.

Line 3305: OZF_Utility_PVT.debug_message('Sign check :: claim_amount:' || l_claim_amount );

3301: IF OZF_DEBUG_HIGH_ON THEN
3302: OZF_Utility_PVT.debug_message('Sign check :: exist_total_amt:' || l_exist_total_amt );
3303: OZF_Utility_PVT.debug_message('Sign check :: old_upd_total_amt:' || l_old_upd_total_amt );
3304: OZF_Utility_PVT.debug_message('Sign check :: new_upd_total_amt:' || l_new_upd_total_amt );
3305: OZF_Utility_PVT.debug_message('Sign check :: claim_amount:' || l_claim_amount );
3306: OZF_Utility_PVT.debug_message('l_offer_id:' || l_offer_id );
3307: END IF;
3308: --Check for the sum of line amount sign. It should be same as that claims remaining amount.
3309: --Skip the check in case of Subsequent Receipt Application.

Line 3306: OZF_Utility_PVT.debug_message('l_offer_id:' || l_offer_id );

3302: OZF_Utility_PVT.debug_message('Sign check :: exist_total_amt:' || l_exist_total_amt );
3303: OZF_Utility_PVT.debug_message('Sign check :: old_upd_total_amt:' || l_old_upd_total_amt );
3304: OZF_Utility_PVT.debug_message('Sign check :: new_upd_total_amt:' || l_new_upd_total_amt );
3305: OZF_Utility_PVT.debug_message('Sign check :: claim_amount:' || l_claim_amount );
3306: OZF_Utility_PVT.debug_message('l_offer_id:' || l_offer_id );
3307: END IF;
3308: --Check for the sum of line amount sign. It should be same as that claims remaining amount.
3309: --Skip the check in case of Subsequent Receipt Application.
3310: --ER#9453443 : Added the Offer ID check

Line 3388: OZF_Utility_PVT.debug_message(l_full_name ||': end');

3384: p_data => x_msg_data
3385: );
3386:
3387: IF OZF_DEBUG_HIGH_ON THEN
3388: OZF_Utility_PVT.debug_message(l_full_name ||': end');
3389: END IF;
3390:
3391: EXCEPTION
3392: WHEN FND_API.g_exc_error THEN

Line 3557: OZF_Utility_PVT.debug_message(l_full_name||': start');

3553: -------------------- initialize -------------------------
3554: SAVEPOINT Update_Claim_Line;
3555:
3556: IF OZF_DEBUG_HIGH_ON THEN
3557: OZF_Utility_PVT.debug_message(l_full_name||': start');
3558: END IF;
3559:
3560: IF FND_API.to_boolean(p_init_msg_list) THEN
3561: FND_MSG_PUB.initialize;

Line 3584: , P_user_id => OZF_UTILITY_PVT.get_resource_id(NVL(FND_GLOBAL.user_id,-1))

3580: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
3581: , P_Commit => FND_API.G_FALSE
3582: , P_object_id => p_claim_line_rec.claim_id
3583: , P_object_type => G_CLAIM_OBJECT_TYPE
3584: , P_user_id => OZF_UTILITY_PVT.get_resource_id(NVL(FND_GLOBAL.user_id,-1))
3585: , X_Return_Status => l_return_status
3586: , X_Msg_Count => x_msg_count
3587: , X_Msg_Data => x_msg_data
3588: , X_access => l_access);

Line 3734: OZF_Utility_PVT.debug_message('l_claim_line_rec.claim_line_id =' ||l_claim_line_rec.claim_line_id);

3730: -- information.
3731: -- Modified for Bug4437696
3732:
3733: IF OZF_DEBUG_HIGH_ON THEN
3734: OZF_Utility_PVT.debug_message('l_claim_line_rec.claim_line_id =' ||l_claim_line_rec.claim_line_id);
3735: END IF;
3736:
3737: OPEN csr_claim_line_util_amt(l_claim_line_rec.claim_line_id);
3738: FETCH csr_claim_line_util_amt INTO l_line_util_acc_amt,l_line_util_sum;

Line 3742: OZF_Utility_PVT.debug_message('l_line_util_acc_amt =' ||l_line_util_acc_amt);

3738: FETCH csr_claim_line_util_amt INTO l_line_util_acc_amt,l_line_util_sum;
3739: CLOSE csr_claim_line_util_amt;
3740:
3741: IF OZF_DEBUG_HIGH_ON THEN
3742: OZF_Utility_PVT.debug_message('l_line_util_acc_amt =' ||l_line_util_acc_amt);
3743: OZF_Utility_PVT.debug_message('l_line_util_sum =' ||l_line_util_sum);
3744: OZF_Utility_PVT.debug_message('l_claim_line_rec.claim_currency_amount =' ||l_claim_line_rec.claim_currency_amount);
3745: END IF;
3746:

Line 3743: OZF_Utility_PVT.debug_message('l_line_util_sum =' ||l_line_util_sum);

3739: CLOSE csr_claim_line_util_amt;
3740:
3741: IF OZF_DEBUG_HIGH_ON THEN
3742: OZF_Utility_PVT.debug_message('l_line_util_acc_amt =' ||l_line_util_acc_amt);
3743: OZF_Utility_PVT.debug_message('l_line_util_sum =' ||l_line_util_sum);
3744: OZF_Utility_PVT.debug_message('l_claim_line_rec.claim_currency_amount =' ||l_claim_line_rec.claim_currency_amount);
3745: END IF;
3746:
3747: IF (p_claim_line_rec.acctd_amount IS NULL OR p_claim_line_rec.acctd_amount = FND_API.g_miss_num) THEN

Line 3744: OZF_Utility_PVT.debug_message('l_claim_line_rec.claim_currency_amount =' ||l_claim_line_rec.claim_currency_amount);

3740:
3741: IF OZF_DEBUG_HIGH_ON THEN
3742: OZF_Utility_PVT.debug_message('l_line_util_acc_amt =' ||l_line_util_acc_amt);
3743: OZF_Utility_PVT.debug_message('l_line_util_sum =' ||l_line_util_sum);
3744: OZF_Utility_PVT.debug_message('l_claim_line_rec.claim_currency_amount =' ||l_claim_line_rec.claim_currency_amount);
3745: END IF;
3746:
3747: IF (p_claim_line_rec.acctd_amount IS NULL OR p_claim_line_rec.acctd_amount = FND_API.g_miss_num) THEN
3748: IF l_claim_line_rec.claim_currency_amount IS NULL THEN

Line 3760: OZF_UTILITY_PVT.Convert_Currency(

3756:
3757: ELSE
3758:
3759: -- Convert ACCTD_AMOUNT
3760: OZF_UTILITY_PVT.Convert_Currency(
3761: P_SET_OF_BOOKS_ID => G_CLAIM_SET_OF_BOOKS_ID,
3762: P_FROM_CURRENCY => G_CLAIM_CURRENCY,
3763: P_CONVERSION_DATE => G_CLAIM_EXC_DATE,
3764: P_CONVERSION_TYPE => G_CLAIM_EXC_TYPE,

Line 3821: l_claim_line_rec.claim_currency_amount := OZF_UTILITY_PVT.CurrRound(l_claim_line_rec.claim_currency_amount, G_CLAIM_CURRENCY);

3817: END IF;
3818:
3819: ------------------- amount rounding --------------------
3820: IF l_claim_line_rec.claim_currency_amount IS NOT NULL THEN
3821: l_claim_line_rec.claim_currency_amount := OZF_UTILITY_PVT.CurrRound(l_claim_line_rec.claim_currency_amount, G_CLAIM_CURRENCY);
3822: END IF;
3823:
3824: IF l_claim_line_rec.amount IS NOT NULL THEN
3825: l_claim_line_rec.amount := OZF_UTILITY_PVT.CurrRound(l_claim_line_rec.amount, l_claim_line_rec.currency_code);

Line 3825: l_claim_line_rec.amount := OZF_UTILITY_PVT.CurrRound(l_claim_line_rec.amount, l_claim_line_rec.currency_code);

3821: l_claim_line_rec.claim_currency_amount := OZF_UTILITY_PVT.CurrRound(l_claim_line_rec.claim_currency_amount, G_CLAIM_CURRENCY);
3822: END IF;
3823:
3824: IF l_claim_line_rec.amount IS NOT NULL THEN
3825: l_claim_line_rec.amount := OZF_UTILITY_PVT.CurrRound(l_claim_line_rec.amount, l_claim_line_rec.currency_code);
3826: END IF;
3827:
3828: IF l_claim_line_rec.acctd_amount IS NOT NULL THEN
3829: l_claim_line_rec.acctd_amount := OZF_UTILITY_PVT.CurrRound(l_claim_line_rec.acctd_amount, l_function_currency);

Line 3829: l_claim_line_rec.acctd_amount := OZF_UTILITY_PVT.CurrRound(l_claim_line_rec.acctd_amount, l_function_currency);

3825: l_claim_line_rec.amount := OZF_UTILITY_PVT.CurrRound(l_claim_line_rec.amount, l_claim_line_rec.currency_code);
3826: END IF;
3827:
3828: IF l_claim_line_rec.acctd_amount IS NOT NULL THEN
3829: l_claim_line_rec.acctd_amount := OZF_UTILITY_PVT.CurrRound(l_claim_line_rec.acctd_amount, l_function_currency);
3830: END IF;
3831:
3832: -------------------- amount checking --------------------------------
3833: IF l_claim_line_rec.claim_currency_amount IS NOT NULL THEN

Line 3881: OZF_Utility_PVT.debug_message('l_offer_id =' ||l_offer_id);

3877: -- PLEASE check with Michelle about this
3878: -- -------------------------------------------------------------------------------------------
3879:
3880: IF OZF_DEBUG_HIGH_ON THEN
3881: OZF_Utility_PVT.debug_message('l_offer_id =' ||l_offer_id);
3882: END IF;
3883: -- ER#9453443 : Added the offer id check
3884: IF p_mode <> OZF_claim_Utility_pvt.G_AUTO_MODE
3885: AND p_mode <> OZF_claim_Utility_pvt.G_REQUEST_MODE

Line 3984: OZF_Utility_PVT.debug_message(' Tax Action =' ||l_claim_line_rec.tax_action);

3980: FETCH c_claim_payment_method INTO l_payment_method;
3981: CLOSE c_claim_payment_method;
3982:
3983: IF OZF_DEBUG_HIGH_ON THEN
3984: OZF_Utility_PVT.debug_message(' Tax Action =' ||l_claim_line_rec.tax_action);
3985: OZF_Utility_PVT.debug_message(' Payment Method =' ||l_payment_method);
3986: END IF;
3987:
3988: IF l_payment_method IS NOT NULL THEN

Line 3985: OZF_Utility_PVT.debug_message(' Payment Method =' ||l_payment_method);

3981: CLOSE c_claim_payment_method;
3982:
3983: IF OZF_DEBUG_HIGH_ON THEN
3984: OZF_Utility_PVT.debug_message(' Tax Action =' ||l_claim_line_rec.tax_action);
3985: OZF_Utility_PVT.debug_message(' Payment Method =' ||l_payment_method);
3986: END IF;
3987:
3988: IF l_payment_method IS NOT NULL THEN
3989:

Line 4012: OZF_Utility_PVT.debug_message(l_full_name ||': update');

4008: --//Bugfix: 8829808
4009: l_object_version_number := l_claim_line_rec.object_version_number + 1;
4010: -------------------------- update --------------------
4011: IF OZF_DEBUG_HIGH_ON THEN
4012: OZF_Utility_PVT.debug_message(l_full_name ||': update');
4013: END IF;
4014:
4015: UPDATE ozf_claim_lines_all SET
4016: object_version_number = l_object_version_number,

Line 4129: OZF_Utility_PVT.debug_message(l_full_name ||': end');

4125: p_data => x_msg_data
4126: );
4127:
4128: IF OZF_DEBUG_HIGH_ON THEN
4129: OZF_Utility_PVT.debug_message(l_full_name ||': end');
4130: END IF;
4131:
4132: EXCEPTION
4133: WHEN FND_API.g_exc_error THEN

Line 4194: OZF_Utility_PVT.debug_message(l_full_name||': start');

4190:
4191: BEGIN
4192: ----------------------- initialize --------------------
4193: IF OZF_DEBUG_HIGH_ON THEN
4194: OZF_Utility_PVT.debug_message(l_full_name||': start');
4195: END IF;
4196:
4197: IF FND_API.to_boolean(p_init_msg_list) THEN
4198: FND_MSG_PUB.initialize;

Line 4214: OZF_Utility_PVT.debug_message(l_full_name||': check items');

4210: x_return_status := FND_API.g_ret_sts_success;
4211:
4212: ---------------------- validate ------------------------
4213: IF OZF_DEBUG_HIGH_ON THEN
4214: OZF_Utility_PVT.debug_message(l_full_name||': check items');
4215: END IF;
4216:
4217: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
4218: Check_Claim_Line_Items(

Line 4232: OZF_Utility_PVT.debug_message(l_full_name||': check record');

4228: END IF;
4229: END IF;
4230:
4231: IF OZF_DEBUG_HIGH_ON THEN
4232: OZF_Utility_PVT.debug_message(l_full_name||': check record');
4233: END IF;
4234:
4235: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
4236: Check_Claim_Line_Record(

Line 4257: OZF_Utility_PVT.debug_message(l_full_name ||': end');

4253: p_data => x_msg_data
4254: );
4255:
4256: IF OZF_DEBUG_HIGH_ON THEN
4257: OZF_Utility_PVT.debug_message(l_full_name ||': end');
4258: END IF;
4259:
4260: EXCEPTION
4261: WHEN FND_API.g_exc_error THEN

Line 4367: IF OZF_Utility_PVT.check_uniqueness(

4363: -- For Create_Claim_Line, when claim_line_id is passed in, we need to
4364: -- check if this claim_line_id is unique.
4365: IF p_validation_mode = JTF_PLSQL_API.g_create AND
4366: p_claim_line_rec.claim_line_id IS NOT NULL THEN
4367: IF OZF_Utility_PVT.check_uniqueness(
4368: 'ozf_claim_lines',
4369: 'claim_line_id = ' || p_claim_line_rec.claim_line_id
4370: ) = FND_API.g_false THEN
4371: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 5572: OZF_Utility_PVT.debug_message(l_full_name||': start');

5568: -------------------- initialize -------------------------
5569: SAVEPOINT split_claim_line;
5570:
5571: IF OZF_DEBUG_HIGH_ON THEN
5572: OZF_Utility_PVT.debug_message(l_full_name||': start');
5573: END IF;
5574:
5575: IF FND_API.to_boolean(p_init_msg_list) THEN
5576: FND_MSG_PUB.initialize;

Line 5785: OZF_Utility_PVT.debug_message('l_claim_line_id'||l_claim_line_id);

5781: AND utilization_id = -1);
5782: END IF; -- product id is null
5783:
5784: IF OZF_DEBUG_LOW_ON THEN
5785: OZF_Utility_PVT.debug_message('l_claim_line_id'||l_claim_line_id);
5786: END IF;
5787:
5788: -- Fix for bug 7658894
5789: OPEN csr_claim_line_util_sum(l_claim_line_id);

Line 5794: OZF_Utility_PVT.debug_message('l_sum_util_amount'||l_sum_util_amount);

5790: FETCH csr_claim_line_util_sum INTO l_sum_util_amount,l_sum_util_acctd_amount;
5791: CLOSE csr_claim_line_util_sum;
5792:
5793: IF OZF_DEBUG_LOW_ON THEN
5794: OZF_Utility_PVT.debug_message('l_sum_util_amount'||l_sum_util_amount);
5795: OZF_Utility_PVT.debug_message('l_sum_util_acctd_amount'||l_sum_util_acctd_amount);
5796: END IF;
5797:
5798: OPEN csr_claim_line_sum(l_claim_line_id);

Line 5795: OZF_Utility_PVT.debug_message('l_sum_util_acctd_amount'||l_sum_util_acctd_amount);

5791: CLOSE csr_claim_line_util_sum;
5792:
5793: IF OZF_DEBUG_LOW_ON THEN
5794: OZF_Utility_PVT.debug_message('l_sum_util_amount'||l_sum_util_amount);
5795: OZF_Utility_PVT.debug_message('l_sum_util_acctd_amount'||l_sum_util_acctd_amount);
5796: END IF;
5797:
5798: OPEN csr_claim_line_sum(l_claim_line_id);
5799: FETCH csr_claim_line_sum INTO l_line_amount,l_line_acctd_amount;

Line 5803: OZF_Utility_PVT.debug_message('l_line_amount'||l_line_amount);

5799: FETCH csr_claim_line_sum INTO l_line_amount,l_line_acctd_amount;
5800: CLOSE csr_claim_line_sum;
5801:
5802: IF OZF_DEBUG_LOW_ON THEN
5803: OZF_Utility_PVT.debug_message('l_line_amount'||l_line_amount);
5804: OZF_Utility_PVT.debug_message('l_sum_util_amount'||l_sum_util_amount);
5805: END IF;
5806:
5807: IF (l_line_amount = l_sum_util_amount) THEN

Line 5804: OZF_Utility_PVT.debug_message('l_sum_util_amount'||l_sum_util_amount);

5800: CLOSE csr_claim_line_sum;
5801:
5802: IF OZF_DEBUG_LOW_ON THEN
5803: OZF_Utility_PVT.debug_message('l_line_amount'||l_line_amount);
5804: OZF_Utility_PVT.debug_message('l_sum_util_amount'||l_sum_util_amount);
5805: END IF;
5806:
5807: IF (l_line_amount = l_sum_util_amount) THEN
5808: update ozf_claim_lines_all

Line 5829: OZF_Utility_PVT.debug_message(l_full_name ||': end');

5825: p_data => x_msg_data
5826: );
5827:
5828: IF OZF_DEBUG_HIGH_ON THEN
5829: OZF_Utility_PVT.debug_message(l_full_name ||': end');
5830: END IF;
5831:
5832: EXCEPTION
5833: WHEN FND_API.g_exc_error THEN

Line 5921: OZF_Utility_PVT.debug_message(l_full_name||': start');

5917: -------------------- initialize -------------------------
5918: SAVEPOINT delete_all_association;
5919:
5920: IF OZF_DEBUG_HIGH_ON THEN
5921: OZF_Utility_PVT.debug_message(l_full_name||': start');
5922: END IF;
5923:
5924: IF FND_API.to_boolean(p_init_msg_list) THEN
5925: FND_MSG_PUB.initialize;

Line 5982: OZF_Utility_PVT.debug_message(l_full_name ||': end');

5978: p_data => x_msg_data
5979: );
5980:
5981: IF OZF_DEBUG_HIGH_ON THEN
5982: OZF_Utility_PVT.debug_message(l_full_name ||': end');
5983: END IF;
5984:
5985: EXCEPTION
5986: WHEN FND_API.g_exc_error THEN