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

Line 1283: ozf_utility_PVT.debug_message('winner count:' || l_gen_return_Rec.terr_id.count );

1279: RAISE FND_API.g_exc_unexpected_error;
1280: END IF;
1281:
1282: IF OZF_DEBUG_HIGH_ON THEN
1283: ozf_utility_PVT.debug_message('winner count:' || l_gen_return_Rec.terr_id.count );
1284: END IF;
1285: IF (l_gen_return_Rec.terr_id.LAST >= 1) THEN
1286:
1287: -- For the list of winners, we need to do two things.

Line 1298: ozf_utility_PVT.debug_message('winner :'||i||' resource_id:' || l_gen_return_Rec.resource_id(i) );

1294: l_access_list(i).arc_act_access_to_object := G_CLAIM_OBJECT_TYPE;
1295: l_access_list(i).user_or_role_id := l_gen_return_Rec.RESOURCE_ID(i);
1296:
1297: IF OZF_DEBUG_HIGH_ON THEN
1298: ozf_utility_PVT.debug_message('winner :'||i||' resource_id:' || l_gen_return_Rec.resource_id(i) );
1299: ozf_utility_PVT.debug_message('winner :'||i||' type:' || l_gen_return_Rec.resource_type(i) );
1300: ozf_utility_PVT.debug_message('winner :'||i||' group_id:' || l_gen_return_Rec.group_id(i) );
1301: END IF;
1302:

Line 1299: ozf_utility_PVT.debug_message('winner :'||i||' type:' || l_gen_return_Rec.resource_type(i) );

1295: l_access_list(i).user_or_role_id := l_gen_return_Rec.RESOURCE_ID(i);
1296:
1297: IF OZF_DEBUG_HIGH_ON THEN
1298: ozf_utility_PVT.debug_message('winner :'||i||' resource_id:' || l_gen_return_Rec.resource_id(i) );
1299: ozf_utility_PVT.debug_message('winner :'||i||' type:' || l_gen_return_Rec.resource_type(i) );
1300: ozf_utility_PVT.debug_message('winner :'||i||' group_id:' || l_gen_return_Rec.group_id(i) );
1301: END IF;
1302:
1303: l_access_list(i).admin_flag := 'N';

Line 1300: ozf_utility_PVT.debug_message('winner :'||i||' group_id:' || l_gen_return_Rec.group_id(i) );

1296:
1297: IF OZF_DEBUG_HIGH_ON THEN
1298: ozf_utility_PVT.debug_message('winner :'||i||' resource_id:' || l_gen_return_Rec.resource_id(i) );
1299: ozf_utility_PVT.debug_message('winner :'||i||' type:' || l_gen_return_Rec.resource_type(i) );
1300: ozf_utility_PVT.debug_message('winner :'||i||' group_id:' || l_gen_return_Rec.group_id(i) );
1301: END IF;
1302:
1303: l_access_list(i).admin_flag := 'N';
1304: l_access_list(i).owner_flag := 'N';

Line 1370: ozf_utility_PVT.debug_message('l_group_member_list :'||i||' category:' || l_group_member_list(i).category );

1366: ---pick one person from the group to be the owner.
1367: l_access_list_index := l_access_list.LAST;
1368: For i in 1..l_group_member_list.LAST LOOP
1369: IF OZF_DEBUG_HIGH_ON THEN
1370: ozf_utility_PVT.debug_message('l_group_member_list :'||i||' category:' || l_group_member_list(i).category );
1371: ozf_utility_PVT.debug_message('l_group_member_list :'||i||' resource_id:' || l_group_member_list(i).resource_id );
1372: END IF;
1373:
1374: IF l_group_member_list(i).category = G_EMPLOYEE_CAT THEN

Line 1371: ozf_utility_PVT.debug_message('l_group_member_list :'||i||' resource_id:' || l_group_member_list(i).resource_id );

1367: l_access_list_index := l_access_list.LAST;
1368: For i in 1..l_group_member_list.LAST LOOP
1369: IF OZF_DEBUG_HIGH_ON THEN
1370: ozf_utility_PVT.debug_message('l_group_member_list :'||i||' category:' || l_group_member_list(i).category );
1371: ozf_utility_PVT.debug_message('l_group_member_list :'||i||' resource_id:' || l_group_member_list(i).resource_id );
1372: END IF;
1373:
1374: IF l_group_member_list(i).category = G_EMPLOYEE_CAT THEN
1375: x_owner_id := l_group_member_list(i).resource_id;

Line 1384: ozf_utility_PVT.debug_message('end of assign');

1380: l_access_list(l_access_list_index).owner_flag := 'Y';
1381: l_access_list(l_access_list_index).arc_user_or_role_type := 'USER';
1382:
1383: IF OZF_DEBUG_HIGH_ON THEN
1384: ozf_utility_PVT.debug_message('end of assign');
1385: END IF;
1386: exit;
1387: END IF;
1388: END LOOP;

Line 1805: ozf_utility_PVT.debug_message('rate_type:'||l_exchange_rate_type);

1801: l_exchange_rate_date := SYSDATE;
1802: END IF;
1803:
1804: IF OZF_DEBUG_HIGH_ON THEN
1805: ozf_utility_PVT.debug_message('rate_type:'||l_exchange_rate_type);
1806: ozf_utility_PVT.debug_message('l_exchange_rate_date:'||l_exchange_rate_date);
1807: ozf_utility_PVT.debug_message('l_exchange_rate:'||l_exchange_rate);
1808: END IF;
1809:

Line 1806: ozf_utility_PVT.debug_message('l_exchange_rate_date:'||l_exchange_rate_date);

1802: END IF;
1803:
1804: IF OZF_DEBUG_HIGH_ON THEN
1805: ozf_utility_PVT.debug_message('rate_type:'||l_exchange_rate_type);
1806: ozf_utility_PVT.debug_message('l_exchange_rate_date:'||l_exchange_rate_date);
1807: ozf_utility_PVT.debug_message('l_exchange_rate:'||l_exchange_rate);
1808: END IF;
1809:
1810: IF (l_amount <> 0) THEN

Line 1807: ozf_utility_PVT.debug_message('l_exchange_rate:'||l_exchange_rate);

1803:
1804: IF OZF_DEBUG_HIGH_ON THEN
1805: ozf_utility_PVT.debug_message('rate_type:'||l_exchange_rate_type);
1806: ozf_utility_PVT.debug_message('l_exchange_rate_date:'||l_exchange_rate_date);
1807: ozf_utility_PVT.debug_message('l_exchange_rate:'||l_exchange_rate);
1808: END IF;
1809:
1810: IF (l_amount <> 0) THEN
1811: OZF_UTILITY_PVT.Convert_Currency(

Line 1811: OZF_UTILITY_PVT.Convert_Currency(

1807: ozf_utility_PVT.debug_message('l_exchange_rate:'||l_exchange_rate);
1808: END IF;
1809:
1810: IF (l_amount <> 0) THEN
1811: OZF_UTILITY_PVT.Convert_Currency(
1812: P_SET_OF_BOOKS_ID => l_set_of_books_id,
1813: P_FROM_CURRENCY => l_currency_code,
1814: P_CONVERSION_DATE => l_exchange_rate_date,
1815: P_CONVERSION_TYPE => l_exchange_rate_type,

Line 1835: l_acctd_amount := OZF_UTILITY_PVT.CurrRound(l_acctd_amount, l_functional_currency_code);

1831: l_acctd_amount := l_amount;
1832: END IF;
1833: --Round off the amount and acctd_amount according to the currency.
1834: --As threshold amounts are stored in functional currency, we need to round off by functional currency code.
1835: l_acctd_amount := OZF_UTILITY_PVT.CurrRound(l_acctd_amount, l_functional_currency_code);
1836: ELSE --else of IF (l_claim.currency_code <> l_functional_currency_code)
1837: l_acctd_amount := l_amount;
1838: l_exchange_rate_type := null;
1839: l_exchange_rate_date := null;

Line 2096: OZF_Utility_PVT.debug_message('Start :' || l_api_name);

2092:
2093: x_return_status := FND_API.G_RET_STS_SUCCESS;
2094:
2095: IF OZF_DEBUG_HIGH_ON THEN
2096: OZF_Utility_PVT.debug_message('Start :' || l_api_name);
2097: END IF;
2098:
2099: -- Start of Fix for Bug#16301558
2100: OPEN csr_customer_for_acc (p_offer_id);

Line 2109: OZF_Utility_PVT.debug_message('Claim Customer Account ID:' ||l_claim_cust_account_id );

2105: FETCH csr_customer_for_claim INTO l_claim_cust_account_id;
2106: CLOSE csr_customer_for_claim;
2107:
2108: IF OZF_DEBUG_HIGH_ON THEN
2109: OZF_Utility_PVT.debug_message('Claim Customer Account ID:' ||l_claim_cust_account_id );
2110: OZF_Utility_PVT.debug_message('Accrual Customer Account ID:' ||l_acc_cust_account_id );
2111: END IF;
2112:
2113: IF (l_acc_cust_account_id IS NULL OR l_claim_cust_account_id <> l_acc_cust_account_id) THEN

Line 2110: OZF_Utility_PVT.debug_message('Accrual Customer Account ID:' ||l_acc_cust_account_id );

2106: CLOSE csr_customer_for_claim;
2107:
2108: IF OZF_DEBUG_HIGH_ON THEN
2109: OZF_Utility_PVT.debug_message('Claim Customer Account ID:' ||l_claim_cust_account_id );
2110: OZF_Utility_PVT.debug_message('Accrual Customer Account ID:' ||l_acc_cust_account_id );
2111: END IF;
2112:
2113: IF (l_acc_cust_account_id IS NULL OR l_claim_cust_account_id <> l_acc_cust_account_id) THEN
2114: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

Line 2152: OZF_Utility_PVT.debug_message('Claim lines created l_claim_line_id =' || l_claim_line_id);

2148: RAISE FND_API.g_exc_error;
2149: END IF;
2150:
2151: IF OZF_DEBUG_HIGH_ON THEN
2152: OZF_Utility_PVT.debug_message('Claim lines created l_claim_line_id =' || l_claim_line_id);
2153: OZF_Utility_PVT.debug_message('l_funds_util_flt.claim_line_id =' || l_funds_util_flt.claim_line_id);
2154: OZF_Utility_PVT.debug_message('l_funds_util_flt.activity_type =' || l_funds_util_flt.activity_type);
2155: OZF_Utility_PVT.debug_message('l_funds_util_flt.activity_id =' || l_funds_util_flt.activity_id);
2156: OZF_Utility_PVT.debug_message('l_funds_util_flt.product_level_type =' || l_funds_util_flt.product_level_type);

Line 2153: OZF_Utility_PVT.debug_message('l_funds_util_flt.claim_line_id =' || l_funds_util_flt.claim_line_id);

2149: END IF;
2150:
2151: IF OZF_DEBUG_HIGH_ON THEN
2152: OZF_Utility_PVT.debug_message('Claim lines created l_claim_line_id =' || l_claim_line_id);
2153: OZF_Utility_PVT.debug_message('l_funds_util_flt.claim_line_id =' || l_funds_util_flt.claim_line_id);
2154: OZF_Utility_PVT.debug_message('l_funds_util_flt.activity_type =' || l_funds_util_flt.activity_type);
2155: OZF_Utility_PVT.debug_message('l_funds_util_flt.activity_id =' || l_funds_util_flt.activity_id);
2156: OZF_Utility_PVT.debug_message('l_funds_util_flt.product_level_type =' || l_funds_util_flt.product_level_type);
2157: OZF_Utility_PVT.debug_message('l_funds_util_flt.product_id =' || l_funds_util_flt.product_id);

Line 2154: OZF_Utility_PVT.debug_message('l_funds_util_flt.activity_type =' || l_funds_util_flt.activity_type);

2150:
2151: IF OZF_DEBUG_HIGH_ON THEN
2152: OZF_Utility_PVT.debug_message('Claim lines created l_claim_line_id =' || l_claim_line_id);
2153: OZF_Utility_PVT.debug_message('l_funds_util_flt.claim_line_id =' || l_funds_util_flt.claim_line_id);
2154: OZF_Utility_PVT.debug_message('l_funds_util_flt.activity_type =' || l_funds_util_flt.activity_type);
2155: OZF_Utility_PVT.debug_message('l_funds_util_flt.activity_id =' || l_funds_util_flt.activity_id);
2156: OZF_Utility_PVT.debug_message('l_funds_util_flt.product_level_type =' || l_funds_util_flt.product_level_type);
2157: OZF_Utility_PVT.debug_message('l_funds_util_flt.product_id =' || l_funds_util_flt.product_id);
2158: OZF_Utility_PVT.debug_message('l_funds_util_flt.total_amount =' || l_funds_util_flt.total_amount);

Line 2155: OZF_Utility_PVT.debug_message('l_funds_util_flt.activity_id =' || l_funds_util_flt.activity_id);

2151: IF OZF_DEBUG_HIGH_ON THEN
2152: OZF_Utility_PVT.debug_message('Claim lines created l_claim_line_id =' || l_claim_line_id);
2153: OZF_Utility_PVT.debug_message('l_funds_util_flt.claim_line_id =' || l_funds_util_flt.claim_line_id);
2154: OZF_Utility_PVT.debug_message('l_funds_util_flt.activity_type =' || l_funds_util_flt.activity_type);
2155: OZF_Utility_PVT.debug_message('l_funds_util_flt.activity_id =' || l_funds_util_flt.activity_id);
2156: OZF_Utility_PVT.debug_message('l_funds_util_flt.product_level_type =' || l_funds_util_flt.product_level_type);
2157: OZF_Utility_PVT.debug_message('l_funds_util_flt.product_id =' || l_funds_util_flt.product_id);
2158: OZF_Utility_PVT.debug_message('l_funds_util_flt.total_amount =' || l_funds_util_flt.total_amount);
2159: END IF;

Line 2156: OZF_Utility_PVT.debug_message('l_funds_util_flt.product_level_type =' || l_funds_util_flt.product_level_type);

2152: OZF_Utility_PVT.debug_message('Claim lines created l_claim_line_id =' || l_claim_line_id);
2153: OZF_Utility_PVT.debug_message('l_funds_util_flt.claim_line_id =' || l_funds_util_flt.claim_line_id);
2154: OZF_Utility_PVT.debug_message('l_funds_util_flt.activity_type =' || l_funds_util_flt.activity_type);
2155: OZF_Utility_PVT.debug_message('l_funds_util_flt.activity_id =' || l_funds_util_flt.activity_id);
2156: OZF_Utility_PVT.debug_message('l_funds_util_flt.product_level_type =' || l_funds_util_flt.product_level_type);
2157: OZF_Utility_PVT.debug_message('l_funds_util_flt.product_id =' || l_funds_util_flt.product_id);
2158: OZF_Utility_PVT.debug_message('l_funds_util_flt.total_amount =' || l_funds_util_flt.total_amount);
2159: END IF;
2160:

Line 2157: OZF_Utility_PVT.debug_message('l_funds_util_flt.product_id =' || l_funds_util_flt.product_id);

2153: OZF_Utility_PVT.debug_message('l_funds_util_flt.claim_line_id =' || l_funds_util_flt.claim_line_id);
2154: OZF_Utility_PVT.debug_message('l_funds_util_flt.activity_type =' || l_funds_util_flt.activity_type);
2155: OZF_Utility_PVT.debug_message('l_funds_util_flt.activity_id =' || l_funds_util_flt.activity_id);
2156: OZF_Utility_PVT.debug_message('l_funds_util_flt.product_level_type =' || l_funds_util_flt.product_level_type);
2157: OZF_Utility_PVT.debug_message('l_funds_util_flt.product_id =' || l_funds_util_flt.product_id);
2158: OZF_Utility_PVT.debug_message('l_funds_util_flt.total_amount =' || l_funds_util_flt.total_amount);
2159: END IF;
2160:
2161: OPEN csr_claim_line(l_claim_line_id);

Line 2158: OZF_Utility_PVT.debug_message('l_funds_util_flt.total_amount =' || l_funds_util_flt.total_amount);

2154: OZF_Utility_PVT.debug_message('l_funds_util_flt.activity_type =' || l_funds_util_flt.activity_type);
2155: OZF_Utility_PVT.debug_message('l_funds_util_flt.activity_id =' || l_funds_util_flt.activity_id);
2156: OZF_Utility_PVT.debug_message('l_funds_util_flt.product_level_type =' || l_funds_util_flt.product_level_type);
2157: OZF_Utility_PVT.debug_message('l_funds_util_flt.product_id =' || l_funds_util_flt.product_id);
2158: OZF_Utility_PVT.debug_message('l_funds_util_flt.total_amount =' || l_funds_util_flt.total_amount);
2159: END IF;
2160:
2161: OPEN csr_claim_line(l_claim_line_id);
2162: FETCH csr_claim_line INTO l_funds_util_flt.claim_line_id

Line 4075: ozf_utility_PVT.debug_message('legal_entity_id:'||l_claim.legal_entity_id);

4071: l_claim.legal_entity_id := FND_PROFILE.VALUE('OZF_DEFAULT_LE_FOR_CLAIM');
4072: END IF;
4073:
4074: IF OZF_DEBUG_HIGH_ON THEN
4075: ozf_utility_PVT.debug_message('legal_entity_id:'||l_claim.legal_entity_id);
4076: END IF;
4077:
4078: -- BUG 4600325 is fixed.
4079: IF l_claim.legal_entity_id is NULL OR

Line 4195: l_claim.user_status_id := to_number( ozf_utility_pvt.GET_DEFAULT_USER_STATUS(

4191: l_claim.user_status_id = FND_API.G_MISS_NUM) THEN
4192:
4193: -- Commented for Rule Based Settlement
4194: /*IF (l_claim.offer_id IS NOT NULL AND l_claim.claim_class = 'CLAIM') THEN
4195: l_claim.user_status_id := to_number( ozf_utility_pvt.GET_DEFAULT_USER_STATUS(
4196: P_STATUS_TYPE=> G_CLAIM_STATUS,
4197: P_STATUS_CODE=> 'OPEN'
4198: )
4199: );

Line 4203: l_claim.user_status_id := to_number( ozf_utility_pvt.GET_DEFAULT_USER_STATUS(

4199: );
4200:
4201: ELSE
4202: */
4203: l_claim.user_status_id := to_number( ozf_utility_pvt.GET_DEFAULT_USER_STATUS(
4204: P_STATUS_TYPE=> G_CLAIM_STATUS,
4205: P_STATUS_CODE=> G_INIT_STATUS
4206: )
4207: );

Line 4327: l_access_list(l_last_index).user_or_role_id := OZF_UTILITY_PVT.get_resource_id(FND_GLOBAL.user_id) ;

4323: END IF;
4324:
4325: IF l_claim.created_from = 'MASS_CREATE' THEN
4326: l_access_list(l_last_index).arc_act_access_to_object := G_CLAIM_OBJECT_TYPE;
4327: l_access_list(l_last_index).user_or_role_id := OZF_UTILITY_PVT.get_resource_id(FND_GLOBAL.user_id) ;
4328: l_access_list(l_last_index).arc_user_or_role_type := 'USER';
4329: l_access_list(l_last_index).admin_flag := 'Y';
4330: l_access_list(l_last_index).owner_flag := 'N';
4331: l_access_list(l_last_index).act_access_to_object_id := l_claim_id;

Line 4418: OZF_UTILITY_PVT.Convert_Currency(

4414:
4415: --This API call is introduced only to populate the exchange rate.
4416: IF l_claim.exchange_rate IS NULL OR
4417: l_claim.exchange_rate = FND_API.G_MISS_NUM THEN
4418: OZF_UTILITY_PVT.Convert_Currency(
4419: P_SET_OF_BOOKS_ID => l_claim.set_of_books_id,
4420: P_FROM_CURRENCY => l_claim.currency_code,
4421: P_CONVERSION_DATE => l_claim.exchange_rate_date,
4422: P_CONVERSION_TYPE => l_claim.exchange_rate_type,

Line 4447: ozf_utility_PVT.debug_message('rate_type:'||l_claim.exchange_rate_type);

4443: END IF;
4444: */
4445:
4446: IF OZF_DEBUG_HIGH_ON THEN
4447: ozf_utility_PVT.debug_message('rate_type:'||l_claim.exchange_rate_type);
4448: END IF;
4449:
4450: IF (l_claim.amount <> 0 )THEN
4451: --Bug# 7319828 fixed by ateotia(+)

Line 4453: OZF_UTILITY_PVT.Convert_Currency(

4449:
4450: IF (l_claim.amount <> 0 )THEN
4451: --Bug# 7319828 fixed by ateotia(+)
4452: --IF (l_convert_acctd_amount = 'T') THEN
4453: OZF_UTILITY_PVT.Convert_Currency(
4454: P_SET_OF_BOOKS_ID => l_claim.set_of_books_id,
4455: P_FROM_CURRENCY => l_claim.currency_code,
4456: P_CONVERSION_DATE => l_claim.exchange_rate_date,
4457: P_CONVERSION_TYPE => l_claim.exchange_rate_type,

Line 4479: l_claim.amount := OZF_UTILITY_PVT.CurrRound(l_claim.amount, l_claim.currency_code);

4475: l_claim.acctd_amount_remaining := l_claim.amount;
4476: END IF;
4477:
4478: -- We need to round the amount and account_amount according to the currency.
4479: l_claim.amount := OZF_UTILITY_PVT.CurrRound(l_claim.amount, l_claim.currency_code);
4480: l_claim.amount_remaining := OZF_UTILITY_PVT.CurrRound(l_claim.amount_remaining, l_claim.currency_code);
4481: --Bug# 7319828 fixed by ateotia(+)
4482: --IF (l_convert_acctd_amount = 'T') THEN
4483: l_claim.acctd_amount := OZF_UTILITY_PVT.CurrRound(l_claim.acctd_amount,l_functional_currency_code);

Line 4480: l_claim.amount_remaining := OZF_UTILITY_PVT.CurrRound(l_claim.amount_remaining, l_claim.currency_code);

4476: END IF;
4477:
4478: -- We need to round the amount and account_amount according to the currency.
4479: l_claim.amount := OZF_UTILITY_PVT.CurrRound(l_claim.amount, l_claim.currency_code);
4480: l_claim.amount_remaining := OZF_UTILITY_PVT.CurrRound(l_claim.amount_remaining, l_claim.currency_code);
4481: --Bug# 7319828 fixed by ateotia(+)
4482: --IF (l_convert_acctd_amount = 'T') THEN
4483: l_claim.acctd_amount := OZF_UTILITY_PVT.CurrRound(l_claim.acctd_amount,l_functional_currency_code);
4484: l_claim.acctd_amount_remaining := OZF_UTILITY_PVT.CurrRound(l_claim.acctd_amount_remaining, l_functional_currency_code);

Line 4483: l_claim.acctd_amount := OZF_UTILITY_PVT.CurrRound(l_claim.acctd_amount,l_functional_currency_code);

4479: l_claim.amount := OZF_UTILITY_PVT.CurrRound(l_claim.amount, l_claim.currency_code);
4480: l_claim.amount_remaining := OZF_UTILITY_PVT.CurrRound(l_claim.amount_remaining, l_claim.currency_code);
4481: --Bug# 7319828 fixed by ateotia(+)
4482: --IF (l_convert_acctd_amount = 'T') THEN
4483: l_claim.acctd_amount := OZF_UTILITY_PVT.CurrRound(l_claim.acctd_amount,l_functional_currency_code);
4484: l_claim.acctd_amount_remaining := OZF_UTILITY_PVT.CurrRound(l_claim.acctd_amount_remaining, l_functional_currency_code);
4485: --END IF;
4486: --Bug# 7319828 fixed by ateotia(-)
4487:

Line 4484: l_claim.acctd_amount_remaining := OZF_UTILITY_PVT.CurrRound(l_claim.acctd_amount_remaining, l_functional_currency_code);

4480: l_claim.amount_remaining := OZF_UTILITY_PVT.CurrRound(l_claim.amount_remaining, l_claim.currency_code);
4481: --Bug# 7319828 fixed by ateotia(+)
4482: --IF (l_convert_acctd_amount = 'T') THEN
4483: l_claim.acctd_amount := OZF_UTILITY_PVT.CurrRound(l_claim.acctd_amount,l_functional_currency_code);
4484: l_claim.acctd_amount_remaining := OZF_UTILITY_PVT.CurrRound(l_claim.acctd_amount_remaining, l_functional_currency_code);
4485: --END IF;
4486: --Bug# 7319828 fixed by ateotia(-)
4487:
4488: --Default the Claim_id only if the in coming claim_id is null.

Line 4539: ozf_utility_PVT.debug_message('l_attribute:'||l_attribute);

4535:
4536: l_attribute := FND_PROFILE.Value(L_ATTRIBUTE_PAD);
4537:
4538: IF OZF_DEBUG_HIGH_ON THEN
4539: ozf_utility_PVT.debug_message('l_attribute:'||l_attribute);
4540: END IF;
4541:
4542: IF l_attribute = 'ATTRIBUTE1' THEN
4543: l_claim.pre_auth_deduction_number := l_claim.DEDUCTION_ATTRIBUTE1;

Line 4575: ozf_utility_PVT.debug_message('l_claim.pre_auth_deduction_number:'||l_claim.pre_auth_deduction_number);

4571: l_claim.pre_auth_deduction_number := l_claim.DEDUCTION_ATTRIBUTE15;
4572: END IF;
4573:
4574: IF OZF_DEBUG_HIGH_ON THEN
4575: ozf_utility_PVT.debug_message('l_claim.pre_auth_deduction_number:'||l_claim.pre_auth_deduction_number);
4576: END IF;
4577:
4578: END IF;
4579:

Line 4598: ozf_utility_PVT.debug_message('Case Sensitive: l_claim.offer_id:'||l_claim.offer_id);

4594: IF (l_pad_ref_norm IS NOT NULL AND l_claim.claim_class = 'DEDUCTION') THEN
4595: OPEN csr_offer_id (l_pad_ref_norm);
4596: FETCH csr_offer_id INTO l_claim.offer_id;
4597: IF OZF_DEBUG_HIGH_ON THEN
4598: ozf_utility_PVT.debug_message('Case Sensitive: l_claim.offer_id:'||l_claim.offer_id);
4599: END IF;
4600: CLOSE csr_offer_id;
4601:
4602: -- Check for case insensitive - Bug 8924230

Line 4608: ozf_utility_PVT.debug_message('Case Insensitive: l_claim.offer_id:'||l_claim.offer_id);

4604: OPEN csr_offer_id_ignoreCase (l_pad_ref_norm);
4605: FETCH csr_offer_id_ignoreCase INTO l_claim.offer_id;
4606: CLOSE csr_offer_id_ignoreCase;
4607: IF OZF_DEBUG_HIGH_ON THEN
4608: ozf_utility_PVT.debug_message('Case Insensitive: l_claim.offer_id:'||l_claim.offer_id);
4609: END IF;
4610: END IF;
4611: END IF;
4612:

Line 4618: ozf_utility_pvt.GET_DEFAULT_USER_STATUS(

4614: IF(l_claim.offer_id IS NOT NULL) THEN
4615:
4616: l_claim.status_code := 'OPEN';
4617: l_claim.USER_STATUS_ID := to_number(
4618: ozf_utility_pvt.GET_DEFAULT_USER_STATUS(
4619: P_STATUS_TYPE=> 'OZF_CLAIM_STATUS',
4620: P_STATUS_CODE=> 'OPEN'
4621: ));
4622:

Line 4654: ozf_utility_PVT.debug_message('Before Insert : l_claim.offer_id:'||l_claim.offer_id);

4650: l_claim.APPLIED_RECEIPT_NUMBER := l_claim.RECEIPT_NUMBER;
4651:
4652: -- End Bug:2781186 ---------------------------------------------------------------------------
4653: IF OZF_DEBUG_HIGH_ON THEN
4654: ozf_utility_PVT.debug_message('Before Insert : l_claim.offer_id:'||l_claim.offer_id);
4655: END IF;
4656:
4657: BEGIN
4658: OZF_claims_PKG.Insert_Row(

Line 5018: ozf_utility_PVT.debug_message('After Insert : l_claim.offer_id:'||l_claim.offer_id);

5014:
5015: --===============================================================================================================================
5016:
5017: IF OZF_DEBUG_HIGH_ON THEN
5018: ozf_utility_PVT.debug_message('After Insert : l_claim.offer_id:'||l_claim.offer_id);
5019: ozf_utility_PVT.debug_message('After Insert : l_claim.claim_class:'||l_claim.claim_class);
5020: END IF;
5021:
5022: -- Added For Rule Based Enhancement

Line 5019: ozf_utility_PVT.debug_message('After Insert : l_claim.claim_class:'||l_claim.claim_class);

5015: --===============================================================================================================================
5016:
5017: IF OZF_DEBUG_HIGH_ON THEN
5018: ozf_utility_PVT.debug_message('After Insert : l_claim.offer_id:'||l_claim.offer_id);
5019: ozf_utility_PVT.debug_message('After Insert : l_claim.claim_class:'||l_claim.claim_class);
5020: END IF;
5021:
5022: -- Added For Rule Based Enhancement
5023: --Fix for ER#9453443

Line 5028: ozf_utility_PVT.debug_message('Create Caim Line And Association');

5024: IF (l_claim.offer_id IS NOT NULL AND l_claim.claim_class = 'CLAIM') THEN
5025:
5026:
5027: IF OZF_DEBUG_HIGH_ON THEN
5028: ozf_utility_PVT.debug_message('Create Caim Line And Association');
5029: ozf_utility_PVT.debug_message('Before Asso API l_claim.claim_id :' || l_claim.claim_id);
5030: ozf_utility_PVT.debug_message('Before Asso API l_claim.offer_id :' || l_claim.offer_id);
5031: ozf_utility_PVT.debug_message('Before Asso API l_claim.amount :' || l_claim.amount);
5032: ozf_utility_PVT.debug_message('Before Asso API l_claim.acctd_amount :' || l_claim.acctd_amount);

Line 5029: ozf_utility_PVT.debug_message('Before Asso API l_claim.claim_id :' || l_claim.claim_id);

5025:
5026:
5027: IF OZF_DEBUG_HIGH_ON THEN
5028: ozf_utility_PVT.debug_message('Create Caim Line And Association');
5029: ozf_utility_PVT.debug_message('Before Asso API l_claim.claim_id :' || l_claim.claim_id);
5030: ozf_utility_PVT.debug_message('Before Asso API l_claim.offer_id :' || l_claim.offer_id);
5031: ozf_utility_PVT.debug_message('Before Asso API l_claim.amount :' || l_claim.amount);
5032: ozf_utility_PVT.debug_message('Before Asso API l_claim.acctd_amount :' || l_claim.acctd_amount);
5033: ozf_utility_PVT.debug_message('Before Asso API l_claim.payment_method :' || l_claim.payment_method);

Line 5030: ozf_utility_PVT.debug_message('Before Asso API l_claim.offer_id :' || l_claim.offer_id);

5026:
5027: IF OZF_DEBUG_HIGH_ON THEN
5028: ozf_utility_PVT.debug_message('Create Caim Line And Association');
5029: ozf_utility_PVT.debug_message('Before Asso API l_claim.claim_id :' || l_claim.claim_id);
5030: ozf_utility_PVT.debug_message('Before Asso API l_claim.offer_id :' || l_claim.offer_id);
5031: ozf_utility_PVT.debug_message('Before Asso API l_claim.amount :' || l_claim.amount);
5032: ozf_utility_PVT.debug_message('Before Asso API l_claim.acctd_amount :' || l_claim.acctd_amount);
5033: ozf_utility_PVT.debug_message('Before Asso API l_claim.payment_method :' || l_claim.payment_method);
5034: ozf_utility_PVT.debug_message('Before Asso API l_claim.claim_class :' || l_claim.claim_class);

Line 5031: ozf_utility_PVT.debug_message('Before Asso API l_claim.amount :' || l_claim.amount);

5027: IF OZF_DEBUG_HIGH_ON THEN
5028: ozf_utility_PVT.debug_message('Create Caim Line And Association');
5029: ozf_utility_PVT.debug_message('Before Asso API l_claim.claim_id :' || l_claim.claim_id);
5030: ozf_utility_PVT.debug_message('Before Asso API l_claim.offer_id :' || l_claim.offer_id);
5031: ozf_utility_PVT.debug_message('Before Asso API l_claim.amount :' || l_claim.amount);
5032: ozf_utility_PVT.debug_message('Before Asso API l_claim.acctd_amount :' || l_claim.acctd_amount);
5033: ozf_utility_PVT.debug_message('Before Asso API l_claim.payment_method :' || l_claim.payment_method);
5034: ozf_utility_PVT.debug_message('Before Asso API l_claim.claim_class :' || l_claim.claim_class);
5035: ozf_utility_PVT.debug_message('Before Asso API l_claim.cust_account_id :' || l_claim.cust_account_id);

Line 5032: ozf_utility_PVT.debug_message('Before Asso API l_claim.acctd_amount :' || l_claim.acctd_amount);

5028: ozf_utility_PVT.debug_message('Create Caim Line And Association');
5029: ozf_utility_PVT.debug_message('Before Asso API l_claim.claim_id :' || l_claim.claim_id);
5030: ozf_utility_PVT.debug_message('Before Asso API l_claim.offer_id :' || l_claim.offer_id);
5031: ozf_utility_PVT.debug_message('Before Asso API l_claim.amount :' || l_claim.amount);
5032: ozf_utility_PVT.debug_message('Before Asso API l_claim.acctd_amount :' || l_claim.acctd_amount);
5033: ozf_utility_PVT.debug_message('Before Asso API l_claim.payment_method :' || l_claim.payment_method);
5034: ozf_utility_PVT.debug_message('Before Asso API l_claim.claim_class :' || l_claim.claim_class);
5035: ozf_utility_PVT.debug_message('Before Asso API l_claim.cust_account_id :' || l_claim.cust_account_id);
5036: ozf_utility_PVT.debug_message('Before Asso API l_claim.cust_billto_acct_site_id :' || l_claim.cust_billto_acct_site_id);

Line 5033: ozf_utility_PVT.debug_message('Before Asso API l_claim.payment_method :' || l_claim.payment_method);

5029: ozf_utility_PVT.debug_message('Before Asso API l_claim.claim_id :' || l_claim.claim_id);
5030: ozf_utility_PVT.debug_message('Before Asso API l_claim.offer_id :' || l_claim.offer_id);
5031: ozf_utility_PVT.debug_message('Before Asso API l_claim.amount :' || l_claim.amount);
5032: ozf_utility_PVT.debug_message('Before Asso API l_claim.acctd_amount :' || l_claim.acctd_amount);
5033: ozf_utility_PVT.debug_message('Before Asso API l_claim.payment_method :' || l_claim.payment_method);
5034: ozf_utility_PVT.debug_message('Before Asso API l_claim.claim_class :' || l_claim.claim_class);
5035: ozf_utility_PVT.debug_message('Before Asso API l_claim.cust_account_id :' || l_claim.cust_account_id);
5036: ozf_utility_PVT.debug_message('Before Asso API l_claim.cust_billto_acct_site_id :' || l_claim.cust_billto_acct_site_id);
5037: END IF;

Line 5034: ozf_utility_PVT.debug_message('Before Asso API l_claim.claim_class :' || l_claim.claim_class);

5030: ozf_utility_PVT.debug_message('Before Asso API l_claim.offer_id :' || l_claim.offer_id);
5031: ozf_utility_PVT.debug_message('Before Asso API l_claim.amount :' || l_claim.amount);
5032: ozf_utility_PVT.debug_message('Before Asso API l_claim.acctd_amount :' || l_claim.acctd_amount);
5033: ozf_utility_PVT.debug_message('Before Asso API l_claim.payment_method :' || l_claim.payment_method);
5034: ozf_utility_PVT.debug_message('Before Asso API l_claim.claim_class :' || l_claim.claim_class);
5035: ozf_utility_PVT.debug_message('Before Asso API l_claim.cust_account_id :' || l_claim.cust_account_id);
5036: ozf_utility_PVT.debug_message('Before Asso API l_claim.cust_billto_acct_site_id :' || l_claim.cust_billto_acct_site_id);
5037: END IF;
5038: -- API to create claim line and Association

Line 5035: ozf_utility_PVT.debug_message('Before Asso API l_claim.cust_account_id :' || l_claim.cust_account_id);

5031: ozf_utility_PVT.debug_message('Before Asso API l_claim.amount :' || l_claim.amount);
5032: ozf_utility_PVT.debug_message('Before Asso API l_claim.acctd_amount :' || l_claim.acctd_amount);
5033: ozf_utility_PVT.debug_message('Before Asso API l_claim.payment_method :' || l_claim.payment_method);
5034: ozf_utility_PVT.debug_message('Before Asso API l_claim.claim_class :' || l_claim.claim_class);
5035: ozf_utility_PVT.debug_message('Before Asso API l_claim.cust_account_id :' || l_claim.cust_account_id);
5036: ozf_utility_PVT.debug_message('Before Asso API l_claim.cust_billto_acct_site_id :' || l_claim.cust_billto_acct_site_id);
5037: END IF;
5038: -- API to create claim line and Association
5039: Create_Claim_Association(

Line 5036: ozf_utility_PVT.debug_message('Before Asso API l_claim.cust_billto_acct_site_id :' || l_claim.cust_billto_acct_site_id);

5032: ozf_utility_PVT.debug_message('Before Asso API l_claim.acctd_amount :' || l_claim.acctd_amount);
5033: ozf_utility_PVT.debug_message('Before Asso API l_claim.payment_method :' || l_claim.payment_method);
5034: ozf_utility_PVT.debug_message('Before Asso API l_claim.claim_class :' || l_claim.claim_class);
5035: ozf_utility_PVT.debug_message('Before Asso API l_claim.cust_account_id :' || l_claim.cust_account_id);
5036: ozf_utility_PVT.debug_message('Before Asso API l_claim.cust_billto_acct_site_id :' || l_claim.cust_billto_acct_site_id);
5037: END IF;
5038: -- API to create claim line and Association
5039: Create_Claim_Association(
5040: p_api_version => 1.0

Line 5061: OZF_Utility_PVT.debug_message('Return Status from Association =' || l_return_status);

5057:
5058: -- Initiate the Settlement for Claim
5059:
5060: IF OZF_DEBUG_HIGH_ON THEN
5061: OZF_Utility_PVT.debug_message('Return Status from Association =' || l_return_status);
5062: END IF;
5063:
5064:
5065: l_claim.object_version_number := 1.0;

Line 5092: OZF_Utility_PVT.debug_message('Payment Method =' || l_claim.payment_method );

5088: END IF;
5089:
5090:
5091: IF OZF_DEBUG_HIGH_ON THEN
5092: OZF_Utility_PVT.debug_message('Payment Method =' || l_claim.payment_method );
5093: OZF_Utility_PVT.debug_message('Vendor ID =' || l_claim.vendor_id );
5094: OZF_Utility_PVT.debug_message('Vendor Site ID =' || l_claim.vendor_site_id );
5095: END IF;
5096:

Line 5093: OZF_Utility_PVT.debug_message('Vendor ID =' || l_claim.vendor_id );

5089:
5090:
5091: IF OZF_DEBUG_HIGH_ON THEN
5092: OZF_Utility_PVT.debug_message('Payment Method =' || l_claim.payment_method );
5093: OZF_Utility_PVT.debug_message('Vendor ID =' || l_claim.vendor_id );
5094: OZF_Utility_PVT.debug_message('Vendor Site ID =' || l_claim.vendor_site_id );
5095: END IF;
5096:
5097: IF (l_claim.payment_method IS NOT NULL AND l_claim.payment_method <> FND_API.G_MISS_CHAR) THEN

Line 5094: OZF_Utility_PVT.debug_message('Vendor Site ID =' || l_claim.vendor_site_id );

5090:
5091: IF OZF_DEBUG_HIGH_ON THEN
5092: OZF_Utility_PVT.debug_message('Payment Method =' || l_claim.payment_method );
5093: OZF_Utility_PVT.debug_message('Vendor ID =' || l_claim.vendor_id );
5094: OZF_Utility_PVT.debug_message('Vendor Site ID =' || l_claim.vendor_site_id );
5095: END IF;
5096:
5097: IF (l_claim.payment_method IS NOT NULL AND l_claim.payment_method <> FND_API.G_MISS_CHAR) THEN
5098:

Line 5101: ozf_utility_pvt.GET_DEFAULT_USER_STATUS(

5097: IF (l_claim.payment_method IS NOT NULL AND l_claim.payment_method <> FND_API.G_MISS_CHAR) THEN
5098:
5099: -- Added for Bug 16301542
5100: /*l_claim.USER_STATUS_ID := to_number(
5101: ozf_utility_pvt.GET_DEFAULT_USER_STATUS(
5102: P_STATUS_TYPE=> 'OZF_CLAIM_STATUS',
5103: P_STATUS_CODE=> 'CLOSED'
5104: ));
5105: */

Line 5191: -- x_dependent_object_tbl OUT ozf_utility_pvt.dependent_objects_tbl_type

5187: --
5188: -- PARAMETERS
5189: -- p_object_id IN NUMBER,
5190: -- p_object_version_number IN NUMBER,
5191: -- x_dependent_object_tbl OUT ozf_utility_pvt.dependent_objects_tbl_type
5192: --
5193: -- We will only delete claim with status of NEW. At this stage, all dependent objects
5194: -- are deleteable and we don't have to worry about split and duplications.
5195: -- Also noted, we have not implemented Attachments and NOTES so far. Nor have I found

Line 6429: ozf_utility_PVT.debug_message('New1: l_claim.pre_auth_deduction_number:'||l_claim.pre_auth_deduction_number);

6425: -- Initialize API return status to sucess
6426: x_return_status := FND_API.G_RET_STS_SUCCESS;
6427:
6428: IF OZF_DEBUG_HIGH_ON THEN
6429: ozf_utility_PVT.debug_message('New1: l_claim.pre_auth_deduction_number:'||l_claim.pre_auth_deduction_number);
6430: ozf_utility_PVT.debug_message('New1: l_claim.customer_ref_number'||l_claim.customer_ref_number);
6431: OZF_Utility_PVT.debug_message('New1: l_claim.offer_id'||l_claim.offer_id);
6432: END IF;
6433:

Line 6430: ozf_utility_PVT.debug_message('New1: l_claim.customer_ref_number'||l_claim.customer_ref_number);

6426: x_return_status := FND_API.G_RET_STS_SUCCESS;
6427:
6428: IF OZF_DEBUG_HIGH_ON THEN
6429: ozf_utility_PVT.debug_message('New1: l_claim.pre_auth_deduction_number:'||l_claim.pre_auth_deduction_number);
6430: ozf_utility_PVT.debug_message('New1: l_claim.customer_ref_number'||l_claim.customer_ref_number);
6431: OZF_Utility_PVT.debug_message('New1: l_claim.offer_id'||l_claim.offer_id);
6432: END IF;
6433:
6434: -- Varify object_version_number

Line 6431: OZF_Utility_PVT.debug_message('New1: l_claim.offer_id'||l_claim.offer_id);

6427:
6428: IF OZF_DEBUG_HIGH_ON THEN
6429: ozf_utility_PVT.debug_message('New1: l_claim.pre_auth_deduction_number:'||l_claim.pre_auth_deduction_number);
6430: ozf_utility_PVT.debug_message('New1: l_claim.customer_ref_number'||l_claim.customer_ref_number);
6431: OZF_Utility_PVT.debug_message('New1: l_claim.offer_id'||l_claim.offer_id);
6432: END IF;
6433:
6434: -- Varify object_version_number
6435: IF (l_claim.object_version_number is NULL or

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

6485: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
6486: P_Commit => FND_API.G_FALSE,
6487: P_object_id => p_claim.claim_id,
6488: P_object_type => G_CLAIM_OBJECT_TYPE,
6489: P_user_id => OZF_UTILITY_PVT.get_resource_id(NVL(FND_GLOBAL.user_id,-1)),
6490: X_Return_Status => l_return_status,
6491: X_Msg_Count => l_msg_count,
6492: X_Msg_Data => l_msg_data,
6493: X_access => l_access);

Line 6517: l_claim.user_status_id := to_number( ozf_utility_pvt.GET_DEFAULT_USER_STATUS(

6513: OPEN user_status_id_csr(l_claim.claim_id);
6514: FETCH user_status_id_csr INTO l_claim.user_status_id;
6515: CLOSE user_status_id_csr;
6516: ELSE
6517: l_claim.user_status_id := to_number( ozf_utility_pvt.GET_DEFAULT_USER_STATUS(
6518: P_STATUS_TYPE=> G_CLAIM_STATUS,
6519: P_STATUS_CODE=> l_claim.status_code
6520: )
6521: );

Line 6554: --ozf_utility_PVT.debug_message('Claim is either in pending close or pending approval');

6550: */
6551:
6552: --ninarasi fix for bug 13395562
6553: IF (l_old_status_code = 'PENDING_CLOSE' AND l_claim.status_code = 'CLOSED' AND l_payment_status <> 'PAID') OR (l_old_status_code = 'PENDING_APPROVAL' AND l_claim.status_code = 'CLOSED' AND l_claim.approved_by IS NULL) THEN
6554: --ozf_utility_PVT.debug_message('Claim is either in pending close or pending approval');
6555: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6556: FND_MESSAGE.Set_Name('OZF', 'OZF_CLAIM_UPDATE_ERROR');
6557: FND_MSG_PUB.ADD;
6558: END IF;

Line 6605: l_claim.amount := OZF_UTILITY_PVT.CurrRound(l_claim.amount, l_claim.currency_code);

6601: l_claim := l_complete_claim;
6602:
6603: -- check amount first, throw any error if amount for deduction is changed.
6604: -- round the amount first
6605: l_claim.amount := OZF_UTILITY_PVT.CurrRound(l_claim.amount, l_claim.currency_code);
6606: l_claim.amount_adjusted := OZF_UTILITY_PVT.CurrRound(l_claim.amount_adjusted, l_claim.currency_code);
6607: l_claim.amount_settled := OZF_UTILITY_PVT.CurrRound(l_claim.amount_settled, l_claim.currency_code);
6608: l_claim.amount_remaining := OZF_UTILITY_PVT.CurrRound(l_claim.amount_remaining, l_claim.currency_code);
6609: -- l_claim.acctd_amount := OZF_UTILITY_PVT.CurrRound(l_claim.acctd_amount, l_claim.currency_code);

Line 6606: l_claim.amount_adjusted := OZF_UTILITY_PVT.CurrRound(l_claim.amount_adjusted, l_claim.currency_code);

6602:
6603: -- check amount first, throw any error if amount for deduction is changed.
6604: -- round the amount first
6605: l_claim.amount := OZF_UTILITY_PVT.CurrRound(l_claim.amount, l_claim.currency_code);
6606: l_claim.amount_adjusted := OZF_UTILITY_PVT.CurrRound(l_claim.amount_adjusted, l_claim.currency_code);
6607: l_claim.amount_settled := OZF_UTILITY_PVT.CurrRound(l_claim.amount_settled, l_claim.currency_code);
6608: l_claim.amount_remaining := OZF_UTILITY_PVT.CurrRound(l_claim.amount_remaining, l_claim.currency_code);
6609: -- l_claim.acctd_amount := OZF_UTILITY_PVT.CurrRound(l_claim.acctd_amount, l_claim.currency_code);
6610: -- l_claim.acctd_amount_remaining := OZF_UTILITY_PVT.CurrRound(l_claim.acctd_amount_remaining, l_claim.currency_code);

Line 6607: l_claim.amount_settled := OZF_UTILITY_PVT.CurrRound(l_claim.amount_settled, l_claim.currency_code);

6603: -- check amount first, throw any error if amount for deduction is changed.
6604: -- round the amount first
6605: l_claim.amount := OZF_UTILITY_PVT.CurrRound(l_claim.amount, l_claim.currency_code);
6606: l_claim.amount_adjusted := OZF_UTILITY_PVT.CurrRound(l_claim.amount_adjusted, l_claim.currency_code);
6607: l_claim.amount_settled := OZF_UTILITY_PVT.CurrRound(l_claim.amount_settled, l_claim.currency_code);
6608: l_claim.amount_remaining := OZF_UTILITY_PVT.CurrRound(l_claim.amount_remaining, l_claim.currency_code);
6609: -- l_claim.acctd_amount := OZF_UTILITY_PVT.CurrRound(l_claim.acctd_amount, l_claim.currency_code);
6610: -- l_claim.acctd_amount_remaining := OZF_UTILITY_PVT.CurrRound(l_claim.acctd_amount_remaining, l_claim.currency_code);
6611:

Line 6608: l_claim.amount_remaining := OZF_UTILITY_PVT.CurrRound(l_claim.amount_remaining, l_claim.currency_code);

6604: -- round the amount first
6605: l_claim.amount := OZF_UTILITY_PVT.CurrRound(l_claim.amount, l_claim.currency_code);
6606: l_claim.amount_adjusted := OZF_UTILITY_PVT.CurrRound(l_claim.amount_adjusted, l_claim.currency_code);
6607: l_claim.amount_settled := OZF_UTILITY_PVT.CurrRound(l_claim.amount_settled, l_claim.currency_code);
6608: l_claim.amount_remaining := OZF_UTILITY_PVT.CurrRound(l_claim.amount_remaining, l_claim.currency_code);
6609: -- l_claim.acctd_amount := OZF_UTILITY_PVT.CurrRound(l_claim.acctd_amount, l_claim.currency_code);
6610: -- l_claim.acctd_amount_remaining := OZF_UTILITY_PVT.CurrRound(l_claim.acctd_amount_remaining, l_claim.currency_code);
6611:
6612: -- Calculate currency conversions if amount is changed

Line 6609: -- l_claim.acctd_amount := OZF_UTILITY_PVT.CurrRound(l_claim.acctd_amount, l_claim.currency_code);

6605: l_claim.amount := OZF_UTILITY_PVT.CurrRound(l_claim.amount, l_claim.currency_code);
6606: l_claim.amount_adjusted := OZF_UTILITY_PVT.CurrRound(l_claim.amount_adjusted, l_claim.currency_code);
6607: l_claim.amount_settled := OZF_UTILITY_PVT.CurrRound(l_claim.amount_settled, l_claim.currency_code);
6608: l_claim.amount_remaining := OZF_UTILITY_PVT.CurrRound(l_claim.amount_remaining, l_claim.currency_code);
6609: -- l_claim.acctd_amount := OZF_UTILITY_PVT.CurrRound(l_claim.acctd_amount, l_claim.currency_code);
6610: -- l_claim.acctd_amount_remaining := OZF_UTILITY_PVT.CurrRound(l_claim.acctd_amount_remaining, l_claim.currency_code);
6611:
6612: -- Calculate currency conversions if amount is changed
6613: -- Added For ER#9453443

Line 6610: -- l_claim.acctd_amount_remaining := OZF_UTILITY_PVT.CurrRound(l_claim.acctd_amount_remaining, l_claim.currency_code);

6606: l_claim.amount_adjusted := OZF_UTILITY_PVT.CurrRound(l_claim.amount_adjusted, l_claim.currency_code);
6607: l_claim.amount_settled := OZF_UTILITY_PVT.CurrRound(l_claim.amount_settled, l_claim.currency_code);
6608: l_claim.amount_remaining := OZF_UTILITY_PVT.CurrRound(l_claim.amount_remaining, l_claim.currency_code);
6609: -- l_claim.acctd_amount := OZF_UTILITY_PVT.CurrRound(l_claim.acctd_amount, l_claim.currency_code);
6610: -- l_claim.acctd_amount_remaining := OZF_UTILITY_PVT.CurrRound(l_claim.acctd_amount_remaining, l_claim.currency_code);
6611:
6612: -- Calculate currency conversions if amount is changed
6613: -- Added For ER#9453443
6614: IF(l_claim.offer_id IS NULL or l_claim.offer_id = FND_API.g_miss_num) THEN

Line 6631: ozf_utility_PVT.debug_message('New1: l_amount_changed:'||l_amount_changed);

6627: END IF;
6628: END IF;
6629:
6630: /*IF OZF_DEBUG_HIGH_ON THEN
6631: ozf_utility_PVT.debug_message('New1: l_amount_changed:'||l_amount_changed);
6632: ozf_utility_PVT.debug_message('New1: l_exchange_changed'||l_exchange_changed);
6633: END IF;
6634: */
6635:

Line 6632: ozf_utility_PVT.debug_message('New1: l_exchange_changed'||l_exchange_changed);

6628: END IF;
6629:
6630: /*IF OZF_DEBUG_HIGH_ON THEN
6631: ozf_utility_PVT.debug_message('New1: l_amount_changed:'||l_amount_changed);
6632: ozf_utility_PVT.debug_message('New1: l_exchange_changed'||l_exchange_changed);
6633: END IF;
6634: */
6635:
6636:

Line 6702: l_claim.user_status_id := to_number( ozf_utility_pvt.GET_DEFAULT_USER_STATUS(

6698: -- default user_status_id.
6699: IF l_old_status_code <> l_claim.status_code AND
6700: l_old_user_status_id = l_claim.user_status_id THEN
6701:
6702: l_claim.user_status_id := to_number( ozf_utility_pvt.GET_DEFAULT_USER_STATUS(
6703: P_STATUS_TYPE=> G_CLAIM_STATUS,
6704: P_STATUS_CODE=> l_claim.status_code)
6705: );
6706: END IF;

Line 6949: OZF_UTILITY_PVT.Convert_Currency(

6945: IF l_claim.exchange_rate = l_claim_old_rec.exchange_rate AND
6946: l_claim.exchange_rate_type = l_claim_old_rec.exchange_rate_type THEN
6947: --Only Exchange Rate Date has been updated.
6948: --Calculate New Exchange Rate.
6949: OZF_UTILITY_PVT.Convert_Currency(
6950: P_SET_OF_BOOKS_ID => l_claim.set_of_books_id,
6951: P_FROM_CURRENCY => l_claim.currency_code,
6952: P_CONVERSION_DATE => l_claim.exchange_rate_date,
6953: P_CONVERSION_TYPE => l_claim.exchange_rate_type,

Line 7032: OZF_UTILITY_PVT.Convert_Currency(

7028: END IF;
7029:
7030:
7031: -- Convert amount now
7032: OZF_UTILITY_PVT.Convert_Currency(
7033: P_SET_OF_BOOKS_ID => l_claim.set_of_books_id,
7034: P_FROM_CURRENCY => l_claim.currency_code,
7035: P_CONVERSION_DATE => l_claim.exchange_rate_date,
7036: P_CONVERSION_TYPE => l_claim.exchange_rate_type,

Line 7052: l_claim.acctd_amount := OZF_UTILITY_PVT.CurrRound(l_claim.acctd_amount,l_functional_currency_code);

7048: l_claim.exchange_rate := l_rate;
7049: l_claim.ACCTD_AMOUNT := l_acc_amount;
7050:
7051: -- We need to round the amount and account_amount according to the currency.
7052: l_claim.acctd_amount := OZF_UTILITY_PVT.CurrRound(l_claim.acctd_amount,l_functional_currency_code);
7053:
7054: -- get claim_lines_sum
7055: OPEN claim_currency_amount_sum_csr(l_claim.claim_id);
7056: FETCH claim_currency_amount_sum_csr INTO l_claim_lines_sum;

Line 7064: --l_claim_lines_sum := OZF_UTILITY_PVT.CurrRound(l_claim_lines_sum, l_functional_currency_code);

7060: l_claim_lines_sum := 0;
7061: ELSE
7062: -- [BEGIN FIX 04/29/02] mchang: claim_currency_amount in claim lines is stored as claim currency code
7063: -- not functional currency code.
7064: --l_claim_lines_sum := OZF_UTILITY_PVT.CurrRound(l_claim_lines_sum, l_functional_currency_code);
7065: l_claim_lines_sum := OZF_UTILITY_PVT.CurrRound(l_claim_lines_sum, l_claim.currency_code);
7066: -- [END FIX 04/29/02] mchang:
7067: END IF;
7068:

Line 7065: l_claim_lines_sum := OZF_UTILITY_PVT.CurrRound(l_claim_lines_sum, l_claim.currency_code);

7061: ELSE
7062: -- [BEGIN FIX 04/29/02] mchang: claim_currency_amount in claim lines is stored as claim currency code
7063: -- not functional currency code.
7064: --l_claim_lines_sum := OZF_UTILITY_PVT.CurrRound(l_claim_lines_sum, l_functional_currency_code);
7065: l_claim_lines_sum := OZF_UTILITY_PVT.CurrRound(l_claim_lines_sum, l_claim.currency_code);
7066: -- [END FIX 04/29/02] mchang:
7067: END IF;
7068:
7069: -- if amount_adjusted = amount then change the status to cancell;

Line 7073: l_claim.user_status_id := to_number( ozf_utility_pvt.GET_DEFAULT_USER_STATUS(

7069: -- if amount_adjusted = amount then change the status to cancell;
7070: -- This will happen if we split all the amount of a claim to its children.
7071: IF l_claim.amount = l_claim.amount_adjusted THEN
7072: l_claim.status_code := G_CANCELLED_STATUS;
7073: l_claim.user_status_id := to_number( ozf_utility_pvt.GET_DEFAULT_USER_STATUS(
7074: P_STATUS_TYPE=> G_CLAIM_STATUS,
7075: P_STATUS_CODE=> G_CANCELLED_STATUS
7076: )
7077: );

Line 7091: OZF_Utility_PVT.debug_message('UC:STEP 0: Before amount_remaining:'||l_claim.amount_remaining);

7087: l_tax_amount := 0;
7088: END IF;
7089:
7090: IF OZF_DEBUG_HIGH_ON THEN
7091: OZF_Utility_PVT.debug_message('UC:STEP 0: Before amount_remaining:'||l_claim.amount_remaining);
7092: END IF;
7093: l_claim.amount_remaining := l_claim.amount - l_claim.amount_adjusted - l_claim.amount_settled- l_tax_amount;
7094:
7095: IF OZF_DEBUG_HIGH_ON THEN

Line 7096: OZF_Utility_PVT.debug_message('UC:STEP 1: After amount_remaining:'||l_claim.amount_remaining);

7092: END IF;
7093: l_claim.amount_remaining := l_claim.amount - l_claim.amount_adjusted - l_claim.amount_settled- l_tax_amount;
7094:
7095: IF OZF_DEBUG_HIGH_ON THEN
7096: OZF_Utility_PVT.debug_message('UC:STEP 1: After amount_remaining:'||l_claim.amount_remaining);
7097: OZF_Utility_PVT.debug_message('UC:STEP 2: amount_adjusted:'||l_claim.amount_adjusted);
7098: OZF_Utility_PVT.debug_message('UC:STEP 3: amount_settled:'||l_claim.amount_settled);
7099: OZF_Utility_PVT.debug_message('UC:STEP 4: l_tax_amount:'||l_tax_amount);
7100: OZF_Utility_PVT.debug_message('UC:STEP 2: lines_sum: '||l_claim_lines_sum );

Line 7097: OZF_Utility_PVT.debug_message('UC:STEP 2: amount_adjusted:'||l_claim.amount_adjusted);

7093: l_claim.amount_remaining := l_claim.amount - l_claim.amount_adjusted - l_claim.amount_settled- l_tax_amount;
7094:
7095: IF OZF_DEBUG_HIGH_ON THEN
7096: OZF_Utility_PVT.debug_message('UC:STEP 1: After amount_remaining:'||l_claim.amount_remaining);
7097: OZF_Utility_PVT.debug_message('UC:STEP 2: amount_adjusted:'||l_claim.amount_adjusted);
7098: OZF_Utility_PVT.debug_message('UC:STEP 3: amount_settled:'||l_claim.amount_settled);
7099: OZF_Utility_PVT.debug_message('UC:STEP 4: l_tax_amount:'||l_tax_amount);
7100: OZF_Utility_PVT.debug_message('UC:STEP 2: lines_sum: '||l_claim_lines_sum );
7101: END IF;

Line 7098: OZF_Utility_PVT.debug_message('UC:STEP 3: amount_settled:'||l_claim.amount_settled);

7094:
7095: IF OZF_DEBUG_HIGH_ON THEN
7096: OZF_Utility_PVT.debug_message('UC:STEP 1: After amount_remaining:'||l_claim.amount_remaining);
7097: OZF_Utility_PVT.debug_message('UC:STEP 2: amount_adjusted:'||l_claim.amount_adjusted);
7098: OZF_Utility_PVT.debug_message('UC:STEP 3: amount_settled:'||l_claim.amount_settled);
7099: OZF_Utility_PVT.debug_message('UC:STEP 4: l_tax_amount:'||l_tax_amount);
7100: OZF_Utility_PVT.debug_message('UC:STEP 2: lines_sum: '||l_claim_lines_sum );
7101: END IF;
7102: -- Raise an error if amount_remaining < claim_lines_sum

Line 7099: OZF_Utility_PVT.debug_message('UC:STEP 4: l_tax_amount:'||l_tax_amount);

7095: IF OZF_DEBUG_HIGH_ON THEN
7096: OZF_Utility_PVT.debug_message('UC:STEP 1: After amount_remaining:'||l_claim.amount_remaining);
7097: OZF_Utility_PVT.debug_message('UC:STEP 2: amount_adjusted:'||l_claim.amount_adjusted);
7098: OZF_Utility_PVT.debug_message('UC:STEP 3: amount_settled:'||l_claim.amount_settled);
7099: OZF_Utility_PVT.debug_message('UC:STEP 4: l_tax_amount:'||l_tax_amount);
7100: OZF_Utility_PVT.debug_message('UC:STEP 2: lines_sum: '||l_claim_lines_sum );
7101: END IF;
7102: -- Raise an error if amount_remaining < claim_lines_sum
7103: -- [BEGIN FIX 04/29/02] mchang: Add ABS function for claim and line amount checking in case of overpayment.

Line 7100: OZF_Utility_PVT.debug_message('UC:STEP 2: lines_sum: '||l_claim_lines_sum );

7096: OZF_Utility_PVT.debug_message('UC:STEP 1: After amount_remaining:'||l_claim.amount_remaining);
7097: OZF_Utility_PVT.debug_message('UC:STEP 2: amount_adjusted:'||l_claim.amount_adjusted);
7098: OZF_Utility_PVT.debug_message('UC:STEP 3: amount_settled:'||l_claim.amount_settled);
7099: OZF_Utility_PVT.debug_message('UC:STEP 4: l_tax_amount:'||l_tax_amount);
7100: OZF_Utility_PVT.debug_message('UC:STEP 2: lines_sum: '||l_claim_lines_sum );
7101: END IF;
7102: -- Raise an error if amount_remaining < claim_lines_sum
7103: -- [BEGIN FIX 04/29/02] mchang: Add ABS function for claim and line amount checking in case of overpayment.
7104: -- [BEGIN FIX 05/08/02] mchang: the amount_remaining checking is not doing when claim status is from PENDING_CLOSE to CLOSED.

Line 7125: OZF_UTILITY_PVT.Convert_Currency(

7121: END IF; --End of relaxation.
7122:
7123: -- convert amount_remaing.
7124: l_acc_amount := null;
7125: OZF_UTILITY_PVT.Convert_Currency(
7126: P_SET_OF_BOOKS_ID => l_claim.set_of_books_id,
7127: P_FROM_CURRENCY => l_claim.currency_code,
7128: P_CONVERSION_DATE => l_claim.exchange_rate_date,
7129: P_CONVERSION_TYPE => l_claim.exchange_rate_type,

Line 7143: l_claim.amount_remaining := OZF_UTILITY_PVT.CurrRound(l_claim.amount_remaining, l_claim.currency_code);

7139: RAISE FND_API.g_exc_unexpected_error;
7140: END IF;
7141: l_claim.ACCTD_AMOUNT_REMAINING := l_acc_amount;
7142:
7143: l_claim.amount_remaining := OZF_UTILITY_PVT.CurrRound(l_claim.amount_remaining, l_claim.currency_code);
7144: l_claim.acctd_amount_remaining := OZF_UTILITY_PVT.CurrRound(l_claim.acctd_amount_remaining,l_functional_currency_code);
7145:
7146: IF OZF_DEBUG_HIGH_ON THEN
7147: OZF_Utility_PVT.debug_message('UC:AJ STEP 11: After amount_remaining:'||l_claim.amount_remaining);

Line 7144: l_claim.acctd_amount_remaining := OZF_UTILITY_PVT.CurrRound(l_claim.acctd_amount_remaining,l_functional_currency_code);

7140: END IF;
7141: l_claim.ACCTD_AMOUNT_REMAINING := l_acc_amount;
7142:
7143: l_claim.amount_remaining := OZF_UTILITY_PVT.CurrRound(l_claim.amount_remaining, l_claim.currency_code);
7144: l_claim.acctd_amount_remaining := OZF_UTILITY_PVT.CurrRound(l_claim.acctd_amount_remaining,l_functional_currency_code);
7145:
7146: IF OZF_DEBUG_HIGH_ON THEN
7147: OZF_Utility_PVT.debug_message('UC:AJ STEP 11: After amount_remaining:'||l_claim.amount_remaining);
7148: END IF;

Line 7147: OZF_Utility_PVT.debug_message('UC:AJ STEP 11: After amount_remaining:'||l_claim.amount_remaining);

7143: l_claim.amount_remaining := OZF_UTILITY_PVT.CurrRound(l_claim.amount_remaining, l_claim.currency_code);
7144: l_claim.acctd_amount_remaining := OZF_UTILITY_PVT.CurrRound(l_claim.acctd_amount_remaining,l_functional_currency_code);
7145:
7146: IF OZF_DEBUG_HIGH_ON THEN
7147: OZF_Utility_PVT.debug_message('UC:AJ STEP 11: After amount_remaining:'||l_claim.amount_remaining);
7148: END IF;
7149:
7150: -- convert amount_settled.
7151: l_acc_amount := null;

Line 7152: OZF_UTILITY_PVT.Convert_Currency(

7148: END IF;
7149:
7150: -- convert amount_settled.
7151: l_acc_amount := null;
7152: OZF_UTILITY_PVT.Convert_Currency(
7153: P_SET_OF_BOOKS_ID => l_claim.set_of_books_id,
7154: P_FROM_CURRENCY => l_claim.currency_code,
7155: P_CONVERSION_DATE => l_claim.exchange_rate_date,
7156: P_CONVERSION_TYPE => l_claim.exchange_rate_type,

Line 7170: l_claim.acctd_amount_settled := OZF_UTILITY_PVT.CurrRound(l_claim.acctd_amount_settled,l_functional_currency_code);

7166: RAISE FND_API.g_exc_unexpected_error;
7167: END IF;
7168: l_claim.ACCTD_amount_settled := l_acc_amount;
7169:
7170: l_claim.acctd_amount_settled := OZF_UTILITY_PVT.CurrRound(l_claim.acctd_amount_settled,l_functional_currency_code);
7171:
7172: -- convert amount_adjusted.
7173: l_acc_amount := null;
7174: OZF_UTILITY_PVT.Convert_Currency(

Line 7174: OZF_UTILITY_PVT.Convert_Currency(

7170: l_claim.acctd_amount_settled := OZF_UTILITY_PVT.CurrRound(l_claim.acctd_amount_settled,l_functional_currency_code);
7171:
7172: -- convert amount_adjusted.
7173: l_acc_amount := null;
7174: OZF_UTILITY_PVT.Convert_Currency(
7175: P_SET_OF_BOOKS_ID => l_claim.set_of_books_id,
7176: P_FROM_CURRENCY => l_claim.currency_code,
7177: P_CONVERSION_DATE => l_claim.exchange_rate_date,
7178: P_CONVERSION_TYPE => l_claim.exchange_rate_type,

Line 7192: l_claim.acctd_amount_adjusted := OZF_UTILITY_PVT.CurrRound(l_claim.acctd_amount_adjusted,l_functional_currency_code);

7188: RAISE FND_API.g_exc_unexpected_error;
7189: END IF;
7190: l_claim.ACCTD_amount_adjusted := l_acc_amount;
7191:
7192: l_claim.acctd_amount_adjusted := OZF_UTILITY_PVT.CurrRound(l_claim.acctd_amount_adjusted,l_functional_currency_code);
7193: END IF;
7194:
7195: -- If the cust_account_id has changed, we need to change the followings accordingly.
7196: -- Days due and others

Line 7252: OZF_Utility_PVT.debug_message('l_claim.offer_id :' || l_claim.offer_id);

7248:
7249: --Fix for ER#9453443
7250: -- Delete the claim line if the offer is removed from claim detail page
7251: IF OZF_DEBUG_HIGH_ON THEN
7252: OZF_Utility_PVT.debug_message('l_claim.offer_id :' || l_claim.offer_id);
7253: OZF_Utility_PVT.debug_message('l_old_offer_id :' || l_old_offer_id);
7254: OZF_Utility_PVT.debug_message('New1: l_claim.settled_from11'||l_claim.settled_from);
7255: END IF;
7256: IF (l_claim.offer_id IS NULL AND l_old_offer_id IS NOT NULL AND l_claim.claim_class IN ('CLAIM','DEDUCTION')) THEN

Line 7253: OZF_Utility_PVT.debug_message('l_old_offer_id :' || l_old_offer_id);

7249: --Fix for ER#9453443
7250: -- Delete the claim line if the offer is removed from claim detail page
7251: IF OZF_DEBUG_HIGH_ON THEN
7252: OZF_Utility_PVT.debug_message('l_claim.offer_id :' || l_claim.offer_id);
7253: OZF_Utility_PVT.debug_message('l_old_offer_id :' || l_old_offer_id);
7254: OZF_Utility_PVT.debug_message('New1: l_claim.settled_from11'||l_claim.settled_from);
7255: END IF;
7256: IF (l_claim.offer_id IS NULL AND l_old_offer_id IS NOT NULL AND l_claim.claim_class IN ('CLAIM','DEDUCTION')) THEN
7257:

Line 7254: OZF_Utility_PVT.debug_message('New1: l_claim.settled_from11'||l_claim.settled_from);

7250: -- Delete the claim line if the offer is removed from claim detail page
7251: IF OZF_DEBUG_HIGH_ON THEN
7252: OZF_Utility_PVT.debug_message('l_claim.offer_id :' || l_claim.offer_id);
7253: OZF_Utility_PVT.debug_message('l_old_offer_id :' || l_old_offer_id);
7254: OZF_Utility_PVT.debug_message('New1: l_claim.settled_from11'||l_claim.settled_from);
7255: END IF;
7256: IF (l_claim.offer_id IS NULL AND l_old_offer_id IS NOT NULL AND l_claim.claim_class IN ('CLAIM','DEDUCTION')) THEN
7257:
7258: IF (l_claim.claim_class ='DEDUCTION') THEN

Line 7264: OZF_Utility_PVT.debug_message('Delete claim line');

7260: l_claim.pre_auth_deduction_normalized := NULL;
7261: END IF;
7262:
7263: IF OZF_DEBUG_HIGH_ON THEN
7264: OZF_Utility_PVT.debug_message('Delete claim line');
7265: END IF;
7266: l_ind :=1;
7267: OPEN claim_line_id_csr(l_claim.claim_id);
7268: LOOP

Line 7301: OZF_Utility_PVT.debug_message('l_claim.offer_id1 :' || l_claim.offer_id);

7297: END IF;
7298:
7299:
7300: IF OZF_DEBUG_HIGH_ON THEN
7301: OZF_Utility_PVT.debug_message('l_claim.offer_id1 :' || l_claim.offer_id);
7302: OZF_Utility_PVT.debug_message('l_old_offer_id1 :' || l_old_offer_id);
7303: OZF_Utility_PVT.debug_message('New1: l_claim.settled_from22'||l_claim.settled_from);
7304: END IF;
7305: -- Added the Check for settled_from for bug fix 9814130

Line 7302: OZF_Utility_PVT.debug_message('l_old_offer_id1 :' || l_old_offer_id);

7298:
7299:
7300: IF OZF_DEBUG_HIGH_ON THEN
7301: OZF_Utility_PVT.debug_message('l_claim.offer_id1 :' || l_claim.offer_id);
7302: OZF_Utility_PVT.debug_message('l_old_offer_id1 :' || l_old_offer_id);
7303: OZF_Utility_PVT.debug_message('New1: l_claim.settled_from22'||l_claim.settled_from);
7304: END IF;
7305: -- Added the Check for settled_from for bug fix 9814130
7306: IF ((l_claim.offer_id IS NOT NULL AND l_claim.offer_id <> FND_API.G_MISS_NUM)

Line 7303: OZF_Utility_PVT.debug_message('New1: l_claim.settled_from22'||l_claim.settled_from);

7299:
7300: IF OZF_DEBUG_HIGH_ON THEN
7301: OZF_Utility_PVT.debug_message('l_claim.offer_id1 :' || l_claim.offer_id);
7302: OZF_Utility_PVT.debug_message('l_old_offer_id1 :' || l_old_offer_id);
7303: OZF_Utility_PVT.debug_message('New1: l_claim.settled_from22'||l_claim.settled_from);
7304: END IF;
7305: -- Added the Check for settled_from for bug fix 9814130
7306: IF ((l_claim.offer_id IS NOT NULL AND l_claim.offer_id <> FND_API.G_MISS_NUM)
7307: AND(

Line 7323: OZF_Utility_PVT.debug_message('Caim Line Exists :');

7319: CLOSE claim_line_count_csr;
7320: IF (l_claim.claim_class = 'CLAIM') THEN
7321: IF (l_claim_line_count <> 0)THEN
7322: IF OZF_DEBUG_HIGH_ON THEN
7323: OZF_Utility_PVT.debug_message('Caim Line Exists :');
7324: END IF;
7325: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7326: FND_MESSAGE.Set_Name('OZF','OZF_CLAIM_LINE_EXISTS');
7327: FND_MSG_PUB.Add;

Line 7340: OZF_Utility_PVT.debug_message('COUNT=1');

7336: FETCH claim_invoice_csr INTO l_invoice_count;
7337: CLOSE claim_invoice_csr;
7338: IF(l_invoice_count = 1) THEN
7339: IF OZF_DEBUG_HIGH_ON THEN
7340: OZF_Utility_PVT.debug_message('COUNT=1');
7341: END IF;
7342: l_ind :=1;
7343: OPEN claim_line_id_csr(l_claim.claim_id);
7344: LOOP

Line 7374: OZF_Utility_PVT.debug_message('COUNT >1 And raise error');

7370: END IF;
7371: END IF; -- End of delete claim line
7372: ELSE
7373: IF OZF_DEBUG_HIGH_ON THEN
7374: OZF_Utility_PVT.debug_message('COUNT >1 And raise error');
7375: END IF;
7376: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7377: FND_MESSAGE.Set_Name('OZF','OZF_DED_LINE_UPDATED');
7378: FND_MSG_PUB.Add;

Line 7388: OZF_Utility_PVT.debug_message('Caim Line Does not Exists :');

7384: END IF; --IF (l_claim.claim_class IN ('CLAIM', 'DEDUCTION')) THEN
7385: END IF; --IF ((l_claim.offer_id IS NOT NULL AND l_claim.offer_id <> FND_API.G_MISS_NUM) ...
7386:
7387: IF OZF_DEBUG_HIGH_ON THEN
7388: OZF_Utility_PVT.debug_message('Caim Line Does not Exists :');
7389: OZF_Utility_PVT.debug_message('Before Asso API l_claim.claim_id :' || l_claim.claim_id);
7390: OZF_Utility_PVT.debug_message('Before Asso API l_claim.offer_id :' || l_claim.offer_id);
7391: OZF_Utility_PVT.debug_message('Before Asso API l_claim.amount :' || l_claim.amount);
7392: OZF_Utility_PVT.debug_message('Before Asso API l_claim.acctd_amount :' || l_claim.acctd_amount);

Line 7389: OZF_Utility_PVT.debug_message('Before Asso API l_claim.claim_id :' || l_claim.claim_id);

7385: END IF; --IF ((l_claim.offer_id IS NOT NULL AND l_claim.offer_id <> FND_API.G_MISS_NUM) ...
7386:
7387: IF OZF_DEBUG_HIGH_ON THEN
7388: OZF_Utility_PVT.debug_message('Caim Line Does not Exists :');
7389: OZF_Utility_PVT.debug_message('Before Asso API l_claim.claim_id :' || l_claim.claim_id);
7390: OZF_Utility_PVT.debug_message('Before Asso API l_claim.offer_id :' || l_claim.offer_id);
7391: OZF_Utility_PVT.debug_message('Before Asso API l_claim.amount :' || l_claim.amount);
7392: OZF_Utility_PVT.debug_message('Before Asso API l_claim.acctd_amount :' || l_claim.acctd_amount);
7393: OZF_Utility_PVT.debug_message('Before Asso API l_claim.payment_method :' || l_claim.payment_method);

Line 7390: OZF_Utility_PVT.debug_message('Before Asso API l_claim.offer_id :' || l_claim.offer_id);

7386:
7387: IF OZF_DEBUG_HIGH_ON THEN
7388: OZF_Utility_PVT.debug_message('Caim Line Does not Exists :');
7389: OZF_Utility_PVT.debug_message('Before Asso API l_claim.claim_id :' || l_claim.claim_id);
7390: OZF_Utility_PVT.debug_message('Before Asso API l_claim.offer_id :' || l_claim.offer_id);
7391: OZF_Utility_PVT.debug_message('Before Asso API l_claim.amount :' || l_claim.amount);
7392: OZF_Utility_PVT.debug_message('Before Asso API l_claim.acctd_amount :' || l_claim.acctd_amount);
7393: OZF_Utility_PVT.debug_message('Before Asso API l_claim.payment_method :' || l_claim.payment_method);
7394: OZF_Utility_PVT.debug_message('Before Asso API l_claim.claim_class :' || l_claim.claim_class);

Line 7391: OZF_Utility_PVT.debug_message('Before Asso API l_claim.amount :' || l_claim.amount);

7387: IF OZF_DEBUG_HIGH_ON THEN
7388: OZF_Utility_PVT.debug_message('Caim Line Does not Exists :');
7389: OZF_Utility_PVT.debug_message('Before Asso API l_claim.claim_id :' || l_claim.claim_id);
7390: OZF_Utility_PVT.debug_message('Before Asso API l_claim.offer_id :' || l_claim.offer_id);
7391: OZF_Utility_PVT.debug_message('Before Asso API l_claim.amount :' || l_claim.amount);
7392: OZF_Utility_PVT.debug_message('Before Asso API l_claim.acctd_amount :' || l_claim.acctd_amount);
7393: OZF_Utility_PVT.debug_message('Before Asso API l_claim.payment_method :' || l_claim.payment_method);
7394: OZF_Utility_PVT.debug_message('Before Asso API l_claim.claim_class :' || l_claim.claim_class);
7395: OZF_Utility_PVT.debug_message('Before Asso API l_claim.cust_account_id :' || l_claim.cust_account_id);

Line 7392: OZF_Utility_PVT.debug_message('Before Asso API l_claim.acctd_amount :' || l_claim.acctd_amount);

7388: OZF_Utility_PVT.debug_message('Caim Line Does not Exists :');
7389: OZF_Utility_PVT.debug_message('Before Asso API l_claim.claim_id :' || l_claim.claim_id);
7390: OZF_Utility_PVT.debug_message('Before Asso API l_claim.offer_id :' || l_claim.offer_id);
7391: OZF_Utility_PVT.debug_message('Before Asso API l_claim.amount :' || l_claim.amount);
7392: OZF_Utility_PVT.debug_message('Before Asso API l_claim.acctd_amount :' || l_claim.acctd_amount);
7393: OZF_Utility_PVT.debug_message('Before Asso API l_claim.payment_method :' || l_claim.payment_method);
7394: OZF_Utility_PVT.debug_message('Before Asso API l_claim.claim_class :' || l_claim.claim_class);
7395: OZF_Utility_PVT.debug_message('Before Asso API l_claim.cust_account_id :' || l_claim.cust_account_id);
7396: OZF_Utility_PVT.debug_message('Before Asso API l_claim.cust_billto_acct_site_id :' || l_claim.cust_billto_acct_site_id);

Line 7393: OZF_Utility_PVT.debug_message('Before Asso API l_claim.payment_method :' || l_claim.payment_method);

7389: OZF_Utility_PVT.debug_message('Before Asso API l_claim.claim_id :' || l_claim.claim_id);
7390: OZF_Utility_PVT.debug_message('Before Asso API l_claim.offer_id :' || l_claim.offer_id);
7391: OZF_Utility_PVT.debug_message('Before Asso API l_claim.amount :' || l_claim.amount);
7392: OZF_Utility_PVT.debug_message('Before Asso API l_claim.acctd_amount :' || l_claim.acctd_amount);
7393: OZF_Utility_PVT.debug_message('Before Asso API l_claim.payment_method :' || l_claim.payment_method);
7394: OZF_Utility_PVT.debug_message('Before Asso API l_claim.claim_class :' || l_claim.claim_class);
7395: OZF_Utility_PVT.debug_message('Before Asso API l_claim.cust_account_id :' || l_claim.cust_account_id);
7396: OZF_Utility_PVT.debug_message('Before Asso API l_claim.cust_billto_acct_site_id :' || l_claim.cust_billto_acct_site_id);
7397: END IF;

Line 7394: OZF_Utility_PVT.debug_message('Before Asso API l_claim.claim_class :' || l_claim.claim_class);

7390: OZF_Utility_PVT.debug_message('Before Asso API l_claim.offer_id :' || l_claim.offer_id);
7391: OZF_Utility_PVT.debug_message('Before Asso API l_claim.amount :' || l_claim.amount);
7392: OZF_Utility_PVT.debug_message('Before Asso API l_claim.acctd_amount :' || l_claim.acctd_amount);
7393: OZF_Utility_PVT.debug_message('Before Asso API l_claim.payment_method :' || l_claim.payment_method);
7394: OZF_Utility_PVT.debug_message('Before Asso API l_claim.claim_class :' || l_claim.claim_class);
7395: OZF_Utility_PVT.debug_message('Before Asso API l_claim.cust_account_id :' || l_claim.cust_account_id);
7396: OZF_Utility_PVT.debug_message('Before Asso API l_claim.cust_billto_acct_site_id :' || l_claim.cust_billto_acct_site_id);
7397: END IF;
7398:

Line 7395: OZF_Utility_PVT.debug_message('Before Asso API l_claim.cust_account_id :' || l_claim.cust_account_id);

7391: OZF_Utility_PVT.debug_message('Before Asso API l_claim.amount :' || l_claim.amount);
7392: OZF_Utility_PVT.debug_message('Before Asso API l_claim.acctd_amount :' || l_claim.acctd_amount);
7393: OZF_Utility_PVT.debug_message('Before Asso API l_claim.payment_method :' || l_claim.payment_method);
7394: OZF_Utility_PVT.debug_message('Before Asso API l_claim.claim_class :' || l_claim.claim_class);
7395: OZF_Utility_PVT.debug_message('Before Asso API l_claim.cust_account_id :' || l_claim.cust_account_id);
7396: OZF_Utility_PVT.debug_message('Before Asso API l_claim.cust_billto_acct_site_id :' || l_claim.cust_billto_acct_site_id);
7397: END IF;
7398:
7399: -- Added For ER#9453443

Line 7396: OZF_Utility_PVT.debug_message('Before Asso API l_claim.cust_billto_acct_site_id :' || l_claim.cust_billto_acct_site_id);

7392: OZF_Utility_PVT.debug_message('Before Asso API l_claim.acctd_amount :' || l_claim.acctd_amount);
7393: OZF_Utility_PVT.debug_message('Before Asso API l_claim.payment_method :' || l_claim.payment_method);
7394: OZF_Utility_PVT.debug_message('Before Asso API l_claim.claim_class :' || l_claim.claim_class);
7395: OZF_Utility_PVT.debug_message('Before Asso API l_claim.cust_account_id :' || l_claim.cust_account_id);
7396: OZF_Utility_PVT.debug_message('Before Asso API l_claim.cust_billto_acct_site_id :' || l_claim.cust_billto_acct_site_id);
7397: END IF;
7398:
7399: -- Added For ER#9453443
7400: IF(l_claim.offer_id IS NOT NULL AND G_INIT_STATUS = 'NEW') THEN

Line 7433: OZF_Utility_PVT.debug_message('l_offer_code =' || l_offer_code);

7429: FETCH csr_offer_code INTO l_offer_code;
7430: CLOSE csr_offer_code;
7431:
7432: IF OZF_DEBUG_HIGH_ON THEN
7433: OZF_Utility_PVT.debug_message('l_offer_code =' || l_offer_code);
7434: END IF;
7435:
7436: IF (l_offer_code IS NOT NULL) THEN
7437: l_claim.pre_auth_deduction_number := l_offer_code;

Line 7444: OZF_Utility_PVT.debug_message('l_return status from Claim Association =' || l_return_status);

7440: END IF;
7441: END IF; -- End of offer code comparision
7442:
7443: IF OZF_DEBUG_HIGH_ON THEN
7444: OZF_Utility_PVT.debug_message('l_return status from Claim Association =' || l_return_status);
7445: OZF_Utility_PVT.debug_message('Claim Payment Method Given =' || l_claim.payment_method);
7446: OZF_Utility_PVT.debug_message('Claim ID =' || l_claim.claim_id);
7447: END IF;
7448:

Line 7445: OZF_Utility_PVT.debug_message('Claim Payment Method Given =' || l_claim.payment_method);

7441: END IF; -- End of offer code comparision
7442:
7443: IF OZF_DEBUG_HIGH_ON THEN
7444: OZF_Utility_PVT.debug_message('l_return status from Claim Association =' || l_return_status);
7445: OZF_Utility_PVT.debug_message('Claim Payment Method Given =' || l_claim.payment_method);
7446: OZF_Utility_PVT.debug_message('Claim ID =' || l_claim.claim_id);
7447: END IF;
7448:
7449: OPEN csr_claim_line_offr (l_claim.claim_id);

Line 7446: OZF_Utility_PVT.debug_message('Claim ID =' || l_claim.claim_id);

7442:
7443: IF OZF_DEBUG_HIGH_ON THEN
7444: OZF_Utility_PVT.debug_message('l_return status from Claim Association =' || l_return_status);
7445: OZF_Utility_PVT.debug_message('Claim Payment Method Given =' || l_claim.payment_method);
7446: OZF_Utility_PVT.debug_message('Claim ID =' || l_claim.claim_id);
7447: END IF;
7448:
7449: OPEN csr_claim_line_offr (l_claim.claim_id);
7450: FETCH csr_claim_line_offr INTO l_activity_id;

Line 7454: OZF_Utility_PVT.debug_message('l_activity_id =' || l_activity_id);

7450: FETCH csr_claim_line_offr INTO l_activity_id;
7451: CLOSE csr_claim_line_offr;
7452:
7453: IF OZF_DEBUG_HIGH_ON THEN
7454: OZF_Utility_PVT.debug_message('l_activity_id =' || l_activity_id);
7455: OZF_Utility_PVT.debug_message('l_claim.offer_id =' || l_claim.offer_id);
7456: OZF_Utility_PVT.debug_message('l_claim.claim_class =' || l_claim.claim_class);
7457: END IF;
7458:

Line 7455: OZF_Utility_PVT.debug_message('l_claim.offer_id =' || l_claim.offer_id);

7451: CLOSE csr_claim_line_offr;
7452:
7453: IF OZF_DEBUG_HIGH_ON THEN
7454: OZF_Utility_PVT.debug_message('l_activity_id =' || l_activity_id);
7455: OZF_Utility_PVT.debug_message('l_claim.offer_id =' || l_claim.offer_id);
7456: OZF_Utility_PVT.debug_message('l_claim.claim_class =' || l_claim.claim_class);
7457: END IF;
7458:
7459: -- For Deduction the payment method should be credit memo only.

Line 7456: OZF_Utility_PVT.debug_message('l_claim.claim_class =' || l_claim.claim_class);

7452:
7453: IF OZF_DEBUG_HIGH_ON THEN
7454: OZF_Utility_PVT.debug_message('l_activity_id =' || l_activity_id);
7455: OZF_Utility_PVT.debug_message('l_claim.offer_id =' || l_claim.offer_id);
7456: OZF_Utility_PVT.debug_message('l_claim.claim_class =' || l_claim.claim_class);
7457: END IF;
7458:
7459: -- For Deduction the payment method should be credit memo only.
7460: IF (l_claim.offer_id IS NOT NULL AND l_claim.offer_id <> FND_API.G_MISS_NUM

Line 7465: ozf_utility_pvt.GET_DEFAULT_USER_STATUS(

7461: AND l_claim.claim_class = 'DEDUCTION') THEN
7462: l_claim.payment_method := 'CREDIT_MEMO';
7463: -- Fix for Bug 9706115
7464: l_claim.USER_STATUS_ID := to_number(
7465: ozf_utility_pvt.GET_DEFAULT_USER_STATUS(
7466: P_STATUS_TYPE=> 'OZF_CLAIM_STATUS',
7467: P_STATUS_CODE=> 'CLOSED'
7468: ));
7469: l_claim.status_code := 'CLOSED';

Line 7481: OZF_Utility_PVT.debug_message('Before Payment Detail');

7477: IF ((l_claim.payment_method IS NULL OR l_claim.payment_method = FND_API.G_MISS_CHAR
7478: OR l_claim.payment_method ='') AND l_claim.claim_class = 'CLAIM') THEN
7479: -- Get the Payment Detail
7480: IF OZF_DEBUG_HIGH_ON THEN
7481: OZF_Utility_PVT.debug_message('Before Payment Detail');
7482: END IF;
7483:
7484: OZF_CLAIM_ACCRUAL_PVT.Get_Payment_Detail
7485: (

Line 7495: OZF_Utility_PVT.debug_message('return status from get_payment_details: ' || l_return_status);

7491: x_return_status => l_return_status
7492: );
7493:
7494: IF OZF_DEBUG_HIGH_ON THEN
7495: OZF_Utility_PVT.debug_message('return status from get_payment_details: ' || l_return_status);
7496: OZF_Utility_PVT.debug_message('l_payment_method from get_payment_detail:' || l_payment_method);
7497: OZF_Utility_PVT.debug_message('l_vendor_id from get_payment_details:' || l_vendor_id);
7498: OZF_Utility_PVT.debug_message('l_vendor_site_id from get_payment_details:' || l_vendor_site_id);
7499: END IF;

Line 7496: OZF_Utility_PVT.debug_message('l_payment_method from get_payment_detail:' || l_payment_method);

7492: );
7493:
7494: IF OZF_DEBUG_HIGH_ON THEN
7495: OZF_Utility_PVT.debug_message('return status from get_payment_details: ' || l_return_status);
7496: OZF_Utility_PVT.debug_message('l_payment_method from get_payment_detail:' || l_payment_method);
7497: OZF_Utility_PVT.debug_message('l_vendor_id from get_payment_details:' || l_vendor_id);
7498: OZF_Utility_PVT.debug_message('l_vendor_site_id from get_payment_details:' || l_vendor_site_id);
7499: END IF;
7500:

Line 7497: OZF_Utility_PVT.debug_message('l_vendor_id from get_payment_details:' || l_vendor_id);

7493:
7494: IF OZF_DEBUG_HIGH_ON THEN
7495: OZF_Utility_PVT.debug_message('return status from get_payment_details: ' || l_return_status);
7496: OZF_Utility_PVT.debug_message('l_payment_method from get_payment_detail:' || l_payment_method);
7497: OZF_Utility_PVT.debug_message('l_vendor_id from get_payment_details:' || l_vendor_id);
7498: OZF_Utility_PVT.debug_message('l_vendor_site_id from get_payment_details:' || l_vendor_site_id);
7499: END IF;
7500:
7501:

Line 7498: OZF_Utility_PVT.debug_message('l_vendor_site_id from get_payment_details:' || l_vendor_site_id);

7494: IF OZF_DEBUG_HIGH_ON THEN
7495: OZF_Utility_PVT.debug_message('return status from get_payment_details: ' || l_return_status);
7496: OZF_Utility_PVT.debug_message('l_payment_method from get_payment_detail:' || l_payment_method);
7497: OZF_Utility_PVT.debug_message('l_vendor_id from get_payment_details:' || l_vendor_id);
7498: OZF_Utility_PVT.debug_message('l_vendor_site_id from get_payment_details:' || l_vendor_site_id);
7499: END IF;
7500:
7501:
7502: IF(l_return_status = FND_API.G_RET_STS_SUCCESS ) THEN

Line 7520: ozf_utility_pvt.GET_DEFAULT_USER_STATUS(

7516: /* Fix for Bug 16301542
7517: IF (l_claim.payment_method IS NOT NULL AND l_claim.payment_method <> FND_API.G_MISS_CHAR) THEN
7518:
7519: l_claim.USER_STATUS_ID := to_number(
7520: ozf_utility_pvt.GET_DEFAULT_USER_STATUS(
7521: P_STATUS_TYPE=> 'OZF_CLAIM_STATUS',
7522: P_STATUS_CODE=> 'CLOSED'
7523: ));
7524: l_claim.status_code := 'CLOSED';

Line 7528: ozf_utility_pvt.GET_DEFAULT_USER_STATUS(

7524: l_claim.status_code := 'CLOSED';
7525: l_prev_status_code := l_claim.status_code;
7526: ELSE
7527: l_claim.USER_STATUS_ID := to_number(
7528: ozf_utility_pvt.GET_DEFAULT_USER_STATUS(
7529: P_STATUS_TYPE=> 'OZF_CLAIM_STATUS',
7530: P_STATUS_CODE=> 'OPEN'
7531: ));
7532:

Line 8017: ozf_utility_PVT.debug_message('Before create access');

8013: END IF;
8014: END IF;
8015:
8016: IF OZF_DEBUG_HIGH_ON THEN
8017: ozf_utility_PVT.debug_message('Before create access');
8018: END IF;
8019:
8020: IF l_owner_changed THEN
8021: IF l_access_list.count > 0 THEN

Line 8098: OZF_UTILITY_PVT.debug_message('G_TPM_PROCESS_ENABLED is YES');

8094: RAISE FND_API.g_exc_unexpected_error;
8095: END IF;
8096:
8097: IF OZF_DEBUG_HIGH_ON THEN
8098: OZF_UTILITY_PVT.debug_message('G_TPM_PROCESS_ENABLED is YES');
8099: OZF_UTILITY_PVT.debug_message('l_claim_rec2.claim_class :'|| l_claim_rec2.claim_class);
8100: OZF_UTILITY_PVT.debug_message('l_claim_rec2.split_from_claim_id :'|| l_claim_rec2.split_from_claim_id);
8101: OZF_UTILITY_PVT.debug_message('l_claim_rec2.status_code :'|| l_claim_rec2.status_code);
8102: OZF_UTILITY_PVT.debug_message('l_claim_rec2.history_event :'|| l_claim_rec2.history_event);

Line 8099: OZF_UTILITY_PVT.debug_message('l_claim_rec2.claim_class :'|| l_claim_rec2.claim_class);

8095: END IF;
8096:
8097: IF OZF_DEBUG_HIGH_ON THEN
8098: OZF_UTILITY_PVT.debug_message('G_TPM_PROCESS_ENABLED is YES');
8099: OZF_UTILITY_PVT.debug_message('l_claim_rec2.claim_class :'|| l_claim_rec2.claim_class);
8100: OZF_UTILITY_PVT.debug_message('l_claim_rec2.split_from_claim_id :'|| l_claim_rec2.split_from_claim_id);
8101: OZF_UTILITY_PVT.debug_message('l_claim_rec2.status_code :'|| l_claim_rec2.status_code);
8102: OZF_UTILITY_PVT.debug_message('l_claim_rec2.history_event :'|| l_claim_rec2.history_event);
8103: OZF_UTILITY_PVT.debug_message('l_claim_rec2.payment_method :'|| l_claim_rec2.payment_method);

Line 8100: OZF_UTILITY_PVT.debug_message('l_claim_rec2.split_from_claim_id :'|| l_claim_rec2.split_from_claim_id);

8096:
8097: IF OZF_DEBUG_HIGH_ON THEN
8098: OZF_UTILITY_PVT.debug_message('G_TPM_PROCESS_ENABLED is YES');
8099: OZF_UTILITY_PVT.debug_message('l_claim_rec2.claim_class :'|| l_claim_rec2.claim_class);
8100: OZF_UTILITY_PVT.debug_message('l_claim_rec2.split_from_claim_id :'|| l_claim_rec2.split_from_claim_id);
8101: OZF_UTILITY_PVT.debug_message('l_claim_rec2.status_code :'|| l_claim_rec2.status_code);
8102: OZF_UTILITY_PVT.debug_message('l_claim_rec2.history_event :'|| l_claim_rec2.history_event);
8103: OZF_UTILITY_PVT.debug_message('l_claim_rec2.payment_method :'|| l_claim_rec2.payment_method);
8104: END IF;

Line 8101: OZF_UTILITY_PVT.debug_message('l_claim_rec2.status_code :'|| l_claim_rec2.status_code);

8097: IF OZF_DEBUG_HIGH_ON THEN
8098: OZF_UTILITY_PVT.debug_message('G_TPM_PROCESS_ENABLED is YES');
8099: OZF_UTILITY_PVT.debug_message('l_claim_rec2.claim_class :'|| l_claim_rec2.claim_class);
8100: OZF_UTILITY_PVT.debug_message('l_claim_rec2.split_from_claim_id :'|| l_claim_rec2.split_from_claim_id);
8101: OZF_UTILITY_PVT.debug_message('l_claim_rec2.status_code :'|| l_claim_rec2.status_code);
8102: OZF_UTILITY_PVT.debug_message('l_claim_rec2.history_event :'|| l_claim_rec2.history_event);
8103: OZF_UTILITY_PVT.debug_message('l_claim_rec2.payment_method :'|| l_claim_rec2.payment_method);
8104: END IF;
8105:

Line 8102: OZF_UTILITY_PVT.debug_message('l_claim_rec2.history_event :'|| l_claim_rec2.history_event);

8098: OZF_UTILITY_PVT.debug_message('G_TPM_PROCESS_ENABLED is YES');
8099: OZF_UTILITY_PVT.debug_message('l_claim_rec2.claim_class :'|| l_claim_rec2.claim_class);
8100: OZF_UTILITY_PVT.debug_message('l_claim_rec2.split_from_claim_id :'|| l_claim_rec2.split_from_claim_id);
8101: OZF_UTILITY_PVT.debug_message('l_claim_rec2.status_code :'|| l_claim_rec2.status_code);
8102: OZF_UTILITY_PVT.debug_message('l_claim_rec2.history_event :'|| l_claim_rec2.history_event);
8103: OZF_UTILITY_PVT.debug_message('l_claim_rec2.payment_method :'|| l_claim_rec2.payment_method);
8104: END IF;
8105:
8106: IF((l_claim_rec2.claim_class = 'DEDUCTION' AND l_claim_rec2.split_from_claim_id is null

Line 8103: OZF_UTILITY_PVT.debug_message('l_claim_rec2.payment_method :'|| l_claim_rec2.payment_method);

8099: OZF_UTILITY_PVT.debug_message('l_claim_rec2.claim_class :'|| l_claim_rec2.claim_class);
8100: OZF_UTILITY_PVT.debug_message('l_claim_rec2.split_from_claim_id :'|| l_claim_rec2.split_from_claim_id);
8101: OZF_UTILITY_PVT.debug_message('l_claim_rec2.status_code :'|| l_claim_rec2.status_code);
8102: OZF_UTILITY_PVT.debug_message('l_claim_rec2.history_event :'|| l_claim_rec2.history_event);
8103: OZF_UTILITY_PVT.debug_message('l_claim_rec2.payment_method :'|| l_claim_rec2.payment_method);
8104: END IF;
8105:
8106: IF((l_claim_rec2.claim_class = 'DEDUCTION' AND l_claim_rec2.split_from_claim_id is null
8107: AND (l_claim_rec2.status_code <> 'PENDING_CLOSE' AND l_claim_rec2.status_code <> 'CANCELLED'))

Line 8537: ozf_utility_PVT.debug_message('claim date: ' || l_claim.claim_date);

8533: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_DUE_DATE_ERR');
8534: FND_MSG_PUB.add;
8535: END IF;
8536: IF OZF_DEBUG_HIGH_ON THEN
8537: ozf_utility_PVT.debug_message('claim date: ' || l_claim.claim_date);
8538: ozf_utility_PVT.debug_message('due date: ' || l_claim.DUE_DATE);
8539: END IF;
8540: RAISE FND_API.G_EXC_ERROR;
8541: END IF;

Line 8538: ozf_utility_PVT.debug_message('due date: ' || l_claim.DUE_DATE);

8534: FND_MSG_PUB.add;
8535: END IF;
8536: IF OZF_DEBUG_HIGH_ON THEN
8537: ozf_utility_PVT.debug_message('claim date: ' || l_claim.claim_date);
8538: ozf_utility_PVT.debug_message('due date: ' || l_claim.DUE_DATE);
8539: END IF;
8540: RAISE FND_API.G_EXC_ERROR;
8541: END IF;
8542:

Line 8847: ozf_utility_PVT.debug_message('Claim Type Org: ' || l_claim_type_org_id);

8843: FETCH claim_type_org_csr INTO l_claim_type_org_id;
8844: CLOSE claim_type_org_csr;
8845:
8846: IF OZF_DEBUG_HIGH_ON THEN
8847: ozf_utility_PVT.debug_message('Claim Type Org: ' || l_claim_type_org_id);
8848: ozf_utility_PVT.debug_message('Claim Org: ' || l_claim.org_id);
8849: END IF;
8850:
8851: IF (l_claim_type_org_id <> l_claim.org_id) THEN

Line 8848: ozf_utility_PVT.debug_message('Claim Org: ' || l_claim.org_id);

8844: CLOSE claim_type_org_csr;
8845:
8846: IF OZF_DEBUG_HIGH_ON THEN
8847: ozf_utility_PVT.debug_message('Claim Type Org: ' || l_claim_type_org_id);
8848: ozf_utility_PVT.debug_message('Claim Org: ' || l_claim.org_id);
8849: END IF;
8850:
8851: IF (l_claim_type_org_id <> l_claim.org_id) THEN
8852: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 8873: ozf_utility_PVT.debug_message('Claim Reason Org: ' || l_claim_reason_org_id);

8869: FETCH claim_reason_org_csr INTO l_claim_reason_org_id;
8870: CLOSE claim_reason_org_csr;
8871:
8872: IF OZF_DEBUG_HIGH_ON THEN
8873: ozf_utility_PVT.debug_message('Claim Reason Org: ' || l_claim_reason_org_id);
8874: ozf_utility_PVT.debug_message('Claim Org: ' || l_claim.org_id);
8875: END IF;
8876:
8877: IF (l_claim_reason_org_id <> l_claim.org_id) THEN

Line 8874: ozf_utility_PVT.debug_message('Claim Org: ' || l_claim.org_id);

8870: CLOSE claim_reason_org_csr;
8871:
8872: IF OZF_DEBUG_HIGH_ON THEN
8873: ozf_utility_PVT.debug_message('Claim Reason Org: ' || l_claim_reason_org_id);
8874: ozf_utility_PVT.debug_message('Claim Org: ' || l_claim.org_id);
8875: END IF;
8876:
8877: IF (l_claim_reason_org_id <> l_claim.org_id) THEN
8878: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN