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

Line 402: OZF_Utility_PVT.debug_message('p_account_type : '||p_account_type);

398: -- Initialize API return status to sucess
399: x_return_status := FND_API.G_RET_STS_SUCCESS;
400:
401: IF OZF_DEBUG_LOW_ON THEN
402: OZF_Utility_PVT.debug_message('p_account_type : '||p_account_type);
403: END IF;
404:
405: l_acct_gen_tbl := acct_gen_tbl();
406: IF upper(p_source_table) = 'OZF_FUNDS_UTILIZED_ALL_B' THEN

Line 639: ozf_utility_pvt.write_conc_log ('l_org_id ' || l_org_id);

635:
636: --Bugfix - 7431334 (Start)
637: l_org_id := get_org_id(p_source_id => p_source_id,
638: p_source_table => upper(p_source_table));
639: ozf_utility_pvt.write_conc_log ('l_org_id ' || l_org_id);
640:
641: OPEN get_om_profle(l_org_id);
642: FETCH get_om_profle INTO l_oe_disc_dtls_on_invoice;
643: CLOSE get_om_profle;

Line 646: ozf_utility_pvt.write_conc_log ('l_oe_disc_dtls_on_invoice ' || l_oe_disc_dtls_on_invoice);

642: FETCH get_om_profle INTO l_oe_disc_dtls_on_invoice;
643: CLOSE get_om_profle;
644:
645: l_oe_disc_dtls_on_invoice := NVL(l_oe_disc_dtls_on_invoice,'N');
646: ozf_utility_pvt.write_conc_log ('l_oe_disc_dtls_on_invoice ' || l_oe_disc_dtls_on_invoice);
647: --Bugfix - 7431334 (End)
648:
649: IF fnd_profile.value('OE_DISCOUNT_DETAILS_ON_INVOICE') = 'Y' THEN
650: OPEN get_revenue_acct_csr2(p_source_id);

Line 788: OZF_UTILITY_PVT.debug_message('St and Id '||x_return_status||'-'||l_ccid);

784: END IF;
785: x_return_status := FND_API.g_ret_sts_unexp_error;
786: END;
787: IF OZF_DEBUG_HIGH_ON THEN
788: OZF_UTILITY_PVT.debug_message('St and Id '||x_return_status||'-'||l_ccid);
789: END IF;
790: IF x_return_status = FND_API.g_ret_sts_error OR
791: x_return_status = FND_API.g_ret_sts_unexp_error
792: THEN

Line 1016: OZF_UTILITY_PVT.debug_message('Get_Account_Type_Code procedure');

1012: l_taxfor VARCHAR2(2);
1013:
1014: BEGIN
1015: IF OZF_DEBUG_HIGH_ON THEN
1016: OZF_UTILITY_PVT.debug_message('Get_Account_Type_Code procedure');
1017: END IF;
1018: IF p_event_type_code = 'ACCRUAL' OR
1019: p_event_type_code = 'ACCRUAL_ADJUSTMENT' THEN
1020: IF p_adjustment_type = 'P' THEN

Line 1193: OZF_UTILITY_PVT.debug_message('Get_Account_Description procedure');

1189: where claim_id = cv_claim_id;
1190:
1191: BEGIN
1192: IF OZF_DEBUG_HIGH_ON THEN
1193: OZF_UTILITY_PVT.debug_message('Get_Account_Description procedure');
1194: END IF;
1195: get_ae_category (p_source_table => p_gl_rec.source_table,
1196: p_source_id => p_gl_rec.source_id,
1197: x_ae_category => l_ae_category,

Line 1329: OZF_UTILITY_PVT.debug_message('Get_Line_Amount procedure');

1325: l_prod_cr_cc_id_tbl_2 CC_ID_TBL := CC_ID_TBL();
1326:
1327: BEGIN
1328: IF OZF_DEBUG_HIGH_ON THEN
1329: OZF_UTILITY_PVT.debug_message('Get_Line_Amount procedure');
1330: END IF;
1331:
1332: G_CLAIM_ID := p_gl_rec.source_id;
1333:

Line 1359: OZF_UTILITY_PVT.debug_message('Getting GL Account for debiting');

1355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1356: END IF;
1357:
1358: IF OZF_DEBUG_HIGH_ON THEN
1359: OZF_UTILITY_PVT.debug_message('Getting GL Account for debiting');
1360: END IF;
1361: -- get accounts from account generator for debiting
1362: Get_GL_Account(
1363: p_api_version => 1.0,

Line 1380: OZF_UTILITY_PVT.debug_message('Getting GL Account for crediting');

1376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1377: END IF;
1378:
1379: IF OZF_DEBUG_HIGH_ON THEN
1380: OZF_UTILITY_PVT.debug_message('Getting GL Account for crediting');
1381: END IF;
1382: -- get accounts from account generator for crediting
1383: Get_GL_Account(
1384: p_api_version => 1.0,

Line 1399: OZF_UTILITY_PVT.debug_message('Unexp Error in getting CR account');

1395: IF x_return_status = FND_API.g_ret_sts_error THEN
1396: RAISE FND_API.G_EXC_ERROR;
1397: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1398: IF OZF_DEBUG_HIGH_ON THEN
1399: OZF_UTILITY_PVT.debug_message('Unexp Error in getting CR account');
1400: END IF;
1401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1402: END IF;
1403:

Line 1435: OZF_UTILITY_PVT.debug_message('Getting GL Account for reverse debiting');

1431: FETCH get_product_line_csr INTO l_claim_line_util_id;
1432: EXIT WHEN get_product_line_csr%notfound;
1433:
1434: IF OZF_DEBUG_HIGH_ON THEN
1435: OZF_UTILITY_PVT.debug_message('Getting GL Account for reverse debiting');
1436: END IF;
1437: -- get accounts from account generator for debiting
1438: Get_GL_Account(
1439: p_api_version => 1.0,

Line 1457: OZF_UTILITY_PVT.debug_message('Getting GL Account for reverse crediting');

1453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1454: END IF;
1455:
1456: IF OZF_DEBUG_HIGH_ON THEN
1457: OZF_UTILITY_PVT.debug_message('Getting GL Account for reverse crediting');
1458: END IF;
1459: -- get accounts from account generator for crediting
1460: Get_GL_Account(
1461: p_api_version => 1.0,

Line 1479: OZF_UTILITY_PVT.debug_message('Getting GL Account for product debiting');

1475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1476: END IF;
1477:
1478: IF OZF_DEBUG_HIGH_ON THEN
1479: OZF_UTILITY_PVT.debug_message('Getting GL Account for product debiting');
1480: END IF;
1481: -- get accounts from account generator for debiting
1482: Get_GL_Account(
1483: p_api_version => 1.0,

Line 1501: OZF_UTILITY_PVT.debug_message('Getting GL Account for product crediting');

1497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1498: END IF;
1499:
1500: IF OZF_DEBUG_HIGH_ON THEN
1501: OZF_UTILITY_PVT.debug_message('Getting GL Account for product crediting');
1502: END IF;
1503: -- get accounts from account generator for crediting
1504: Get_GL_Account(
1505: p_api_version => 1.0,

Line 2011: OZF_UTILITY_PVT.debug_message('AE Category'||l_ae_category);

2007: x_period_name => l_period_name,
2008: x_return_status => x_return_status);
2009:
2010: IF OZF_DEBUG_HIGH_ON THEN
2011: OZF_UTILITY_PVT.debug_message('AE Category'||l_ae_category);
2012: END IF;
2013: IF x_return_status = FND_API.g_ret_sts_error THEN
2014: RAISE FND_API.G_EXC_ERROR;
2015: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 2156: OZF_UTILITY_PVT.debug_message('Number of Lines: ' || l_num_lines);

2152: -- ae lines
2153: x_ae_line_tbl := OZF_ae_line_PVT.ae_line_tbl_type();
2154: l_num_lines := l_amount_tbl.count;
2155: IF OZF_DEBUG_HIGH_ON THEN
2156: OZF_UTILITY_PVT.debug_message('Number of Lines: ' || l_num_lines);
2157: END IF;
2158: FOR i in 1..l_num_lines LOOP
2159: x_ae_line_tbl.extend;
2160: x_ae_line_tbl(i) := null;

Line 2161: --OZF_UTILITY_PVT.debug_message('Line Number before entering: ' || x_ae_line_tbl(i).ae_line_number);

2157: END IF;
2158: FOR i in 1..l_num_lines LOOP
2159: x_ae_line_tbl.extend;
2160: x_ae_line_tbl(i) := null;
2161: --OZF_UTILITY_PVT.debug_message('Line Number before entering: ' || x_ae_line_tbl(i).ae_line_number);
2162: --if x_ae_line_tbl(i).ae_line_type_code = FND_API.G_MISS_CHAR then
2163: --OZF_UTILITY_PVT.debug_message('Line Type Code before entering - miss char: ' || x_ae_line_tbl(i).ae_line_type_code);
2164: --else
2165: --OZF_UTILITY_PVT.debug_message('Line Type Code before entering: ' || x_ae_line_tbl(i).ae_line_type_code);

Line 2163: --OZF_UTILITY_PVT.debug_message('Line Type Code before entering - miss char: ' || x_ae_line_tbl(i).ae_line_type_code);

2159: x_ae_line_tbl.extend;
2160: x_ae_line_tbl(i) := null;
2161: --OZF_UTILITY_PVT.debug_message('Line Number before entering: ' || x_ae_line_tbl(i).ae_line_number);
2162: --if x_ae_line_tbl(i).ae_line_type_code = FND_API.G_MISS_CHAR then
2163: --OZF_UTILITY_PVT.debug_message('Line Type Code before entering - miss char: ' || x_ae_line_tbl(i).ae_line_type_code);
2164: --else
2165: --OZF_UTILITY_PVT.debug_message('Line Type Code before entering: ' || x_ae_line_tbl(i).ae_line_type_code);
2166: --end if;
2167: --OZF_UTILITY_PVT.debug_message('Line Type Code assigned value: ' || x_amount_tbl(i).line_type_code);

Line 2165: --OZF_UTILITY_PVT.debug_message('Line Type Code before entering: ' || x_ae_line_tbl(i).ae_line_type_code);

2161: --OZF_UTILITY_PVT.debug_message('Line Number before entering: ' || x_ae_line_tbl(i).ae_line_number);
2162: --if x_ae_line_tbl(i).ae_line_type_code = FND_API.G_MISS_CHAR then
2163: --OZF_UTILITY_PVT.debug_message('Line Type Code before entering - miss char: ' || x_ae_line_tbl(i).ae_line_type_code);
2164: --else
2165: --OZF_UTILITY_PVT.debug_message('Line Type Code before entering: ' || x_ae_line_tbl(i).ae_line_type_code);
2166: --end if;
2167: --OZF_UTILITY_PVT.debug_message('Line Type Code assigned value: ' || x_amount_tbl(i).line_type_code);
2168: --OZF_UTILITY_PVT.debug_message('Processing Line: ' || i);
2169:

Line 2167: --OZF_UTILITY_PVT.debug_message('Line Type Code assigned value: ' || x_amount_tbl(i).line_type_code);

2163: --OZF_UTILITY_PVT.debug_message('Line Type Code before entering - miss char: ' || x_ae_line_tbl(i).ae_line_type_code);
2164: --else
2165: --OZF_UTILITY_PVT.debug_message('Line Type Code before entering: ' || x_ae_line_tbl(i).ae_line_type_code);
2166: --end if;
2167: --OZF_UTILITY_PVT.debug_message('Line Type Code assigned value: ' || x_amount_tbl(i).line_type_code);
2168: --OZF_UTILITY_PVT.debug_message('Processing Line: ' || i);
2169:
2170: -- Fix for Bug 7430768
2171: IF (upper(p_gl_rec.source_table) = 'OZF_CLAIMS_ALL' AND p_gl_rec.event_type_code = 'SETTLE_BY_OTHER'

Line 2168: --OZF_UTILITY_PVT.debug_message('Processing Line: ' || i);

2164: --else
2165: --OZF_UTILITY_PVT.debug_message('Line Type Code before entering: ' || x_ae_line_tbl(i).ae_line_type_code);
2166: --end if;
2167: --OZF_UTILITY_PVT.debug_message('Line Type Code assigned value: ' || x_amount_tbl(i).line_type_code);
2168: --OZF_UTILITY_PVT.debug_message('Processing Line: ' || i);
2169:
2170: -- Fix for Bug 7430768
2171: IF (upper(p_gl_rec.source_table) = 'OZF_CLAIMS_ALL' AND p_gl_rec.event_type_code = 'SETTLE_BY_OTHER'
2172: AND p_gl_rec.adjustment_type = 'N') THEN

Line 2210: --OZF_UTILITY_PVT.debug_message('Line Number after entering: ' || x_ae_line_tbl(i).ae_line_number);

2206: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
2207: RAISE FND_API.g_exc_unexpected_error;
2208: END IF;
2209:
2210: --OZF_UTILITY_PVT.debug_message('Line Number after entering: ' || x_ae_line_tbl(i).ae_line_number);
2211: --if x_ae_line_tbl(i).ae_line_type_code = FND_API.G_MISS_CHAR then
2212: --OZF_UTILITY_PVT.debug_message('Line Type Code after entering - miss char: ' || x_ae_line_tbl(i).ae_line_type_code);
2213: --else
2214: --OZF_UTILITY_PVT.debug_message('Line Type Code after entering: ' || x_ae_line_tbl(i).ae_line_type_code);

Line 2212: --OZF_UTILITY_PVT.debug_message('Line Type Code after entering - miss char: ' || x_ae_line_tbl(i).ae_line_type_code);

2208: END IF;
2209:
2210: --OZF_UTILITY_PVT.debug_message('Line Number after entering: ' || x_ae_line_tbl(i).ae_line_number);
2211: --if x_ae_line_tbl(i).ae_line_type_code = FND_API.G_MISS_CHAR then
2212: --OZF_UTILITY_PVT.debug_message('Line Type Code after entering - miss char: ' || x_ae_line_tbl(i).ae_line_type_code);
2213: --else
2214: --OZF_UTILITY_PVT.debug_message('Line Type Code after entering: ' || x_ae_line_tbl(i).ae_line_type_code);
2215: --end if;
2216: END LOOP;

Line 2214: --OZF_UTILITY_PVT.debug_message('Line Type Code after entering: ' || x_ae_line_tbl(i).ae_line_type_code);

2210: --OZF_UTILITY_PVT.debug_message('Line Number after entering: ' || x_ae_line_tbl(i).ae_line_number);
2211: --if x_ae_line_tbl(i).ae_line_type_code = FND_API.G_MISS_CHAR then
2212: --OZF_UTILITY_PVT.debug_message('Line Type Code after entering - miss char: ' || x_ae_line_tbl(i).ae_line_type_code);
2213: --else
2214: --OZF_UTILITY_PVT.debug_message('Line Type Code after entering: ' || x_ae_line_tbl(i).ae_line_type_code);
2215: --end if;
2216: END LOOP;
2217: --x_ae_line_tbl := l_ae_line_tbl;
2218:

Line 2549: OZF_Utility_PVT.debug_message('--------- create_gl_entry ----------');

2545: -- Initialize API return status to sucess
2546: x_return_status := FND_API.G_RET_STS_SUCCESS;
2547:
2548: IF OZF_DEBUG_LOW_ON THEN
2549: OZF_Utility_PVT.debug_message('--------- create_gl_entry ----------');
2550: OZF_Utility_PVT.debug_message('event_type_code : '||p_gl_rec.event_type_code);
2551: OZF_Utility_PVT.debug_message('event_status_code : '||p_gl_rec.event_status_code);
2552: OZF_Utility_PVT.debug_message('source_id : '||p_gl_rec.source_id);
2553: OZF_Utility_PVT.debug_message('source_table : '||p_gl_rec.source_table);

Line 2550: OZF_Utility_PVT.debug_message('event_type_code : '||p_gl_rec.event_type_code);

2546: x_return_status := FND_API.G_RET_STS_SUCCESS;
2547:
2548: IF OZF_DEBUG_LOW_ON THEN
2549: OZF_Utility_PVT.debug_message('--------- create_gl_entry ----------');
2550: OZF_Utility_PVT.debug_message('event_type_code : '||p_gl_rec.event_type_code);
2551: OZF_Utility_PVT.debug_message('event_status_code : '||p_gl_rec.event_status_code);
2552: OZF_Utility_PVT.debug_message('source_id : '||p_gl_rec.source_id);
2553: OZF_Utility_PVT.debug_message('source_table : '||p_gl_rec.source_table);
2554: OZF_Utility_PVT.debug_message('adjustment_type : '||p_gl_rec.adjustment_type);

Line 2551: OZF_Utility_PVT.debug_message('event_status_code : '||p_gl_rec.event_status_code);

2547:
2548: IF OZF_DEBUG_LOW_ON THEN
2549: OZF_Utility_PVT.debug_message('--------- create_gl_entry ----------');
2550: OZF_Utility_PVT.debug_message('event_type_code : '||p_gl_rec.event_type_code);
2551: OZF_Utility_PVT.debug_message('event_status_code : '||p_gl_rec.event_status_code);
2552: OZF_Utility_PVT.debug_message('source_id : '||p_gl_rec.source_id);
2553: OZF_Utility_PVT.debug_message('source_table : '||p_gl_rec.source_table);
2554: OZF_Utility_PVT.debug_message('adjustment_type : '||p_gl_rec.adjustment_type);
2555: END IF;

Line 2552: OZF_Utility_PVT.debug_message('source_id : '||p_gl_rec.source_id);

2548: IF OZF_DEBUG_LOW_ON THEN
2549: OZF_Utility_PVT.debug_message('--------- create_gl_entry ----------');
2550: OZF_Utility_PVT.debug_message('event_type_code : '||p_gl_rec.event_type_code);
2551: OZF_Utility_PVT.debug_message('event_status_code : '||p_gl_rec.event_status_code);
2552: OZF_Utility_PVT.debug_message('source_id : '||p_gl_rec.source_id);
2553: OZF_Utility_PVT.debug_message('source_table : '||p_gl_rec.source_table);
2554: OZF_Utility_PVT.debug_message('adjustment_type : '||p_gl_rec.adjustment_type);
2555: END IF;
2556:

Line 2553: OZF_Utility_PVT.debug_message('source_table : '||p_gl_rec.source_table);

2549: OZF_Utility_PVT.debug_message('--------- create_gl_entry ----------');
2550: OZF_Utility_PVT.debug_message('event_type_code : '||p_gl_rec.event_type_code);
2551: OZF_Utility_PVT.debug_message('event_status_code : '||p_gl_rec.event_status_code);
2552: OZF_Utility_PVT.debug_message('source_id : '||p_gl_rec.source_id);
2553: OZF_Utility_PVT.debug_message('source_table : '||p_gl_rec.source_table);
2554: OZF_Utility_PVT.debug_message('adjustment_type : '||p_gl_rec.adjustment_type);
2555: END IF;
2556:
2557: -- [BEGIN OF BUG 4039894 FIXING]

Line 2554: OZF_Utility_PVT.debug_message('adjustment_type : '||p_gl_rec.adjustment_type);

2550: OZF_Utility_PVT.debug_message('event_type_code : '||p_gl_rec.event_type_code);
2551: OZF_Utility_PVT.debug_message('event_status_code : '||p_gl_rec.event_status_code);
2552: OZF_Utility_PVT.debug_message('source_id : '||p_gl_rec.source_id);
2553: OZF_Utility_PVT.debug_message('source_table : '||p_gl_rec.source_table);
2554: OZF_Utility_PVT.debug_message('adjustment_type : '||p_gl_rec.adjustment_type);
2555: END IF;
2556:
2557: -- [BEGIN OF BUG 4039894 FIXING]
2558: -- Avoid GL entry creation if posting was done before for utilization.

Line 2590: OZF_Utility_PVT.debug_message('SYSPARAM: Post to GL is ' || l_post_to_gl);

2586: CLOSE accrual_gl_posting_csr;
2587: END IF;
2588:
2589: IF OZF_DEBUG_LOW_ON THEN
2590: OZF_Utility_PVT.debug_message('SYSPARAM: Post to GL is ' || l_post_to_gl);
2591: END IF;
2592:
2593: -- check if event type is off_invoice. create gl entries only when system
2594: -- parameters requires so

Line 2599: OZF_Utility_PVT.debug_message('GL posting for Off Invoice is not required.');

2595: IF p_gl_rec.event_type_code = 'OFF_INVOICE' THEN
2596: IF l_off_inv_gl IS NULL OR l_off_inv_gl = 'F' THEN
2597: l_post_to_gl := 'F';
2598: IF OZF_DEBUG_LOW_ON THEN
2599: OZF_Utility_PVT.debug_message('GL posting for Off Invoice is not required.');
2600: END IF;
2601: END IF;
2602: END IF;
2603:

Line 2613: OZF_Utility_PVT.debug_message('Claim has no earnings associated');

2609:
2610: IF l_asso_amount = 0 THEN
2611: l_post_to_gl := 'F';
2612: IF OZF_DEBUG_LOW_ON THEN
2613: OZF_Utility_PVT.debug_message('Claim has no earnings associated');
2614: END IF;
2615: END IF;
2616: END IF;
2617:

Line 2691: OZF_UTILITY_PVT.debug_message('Line Number before calling api: ' ||

2687: -- Create account event lines
2688: FOR i in 1..l_AE_LINE_Tbl.count LOOP
2689: l_AE_LINE_Tbl(i).ae_header_id := l_ae_header_id;
2690: IF OZF_DEBUG_HIGH_ON THEN
2691: OZF_UTILITY_PVT.debug_message('Line Number before calling api: ' ||
2692: l_ae_line_tbl(i).ae_line_number);
2693: END IF;
2694: END LOOP;
2695:

Line 2716: OZF_Utility_PVT.debug_message('Accounting event: id = '||l_accounting_event_id);

2712:
2713: END IF; -- if l_acctng_entries = 'T'
2714:
2715: IF OZF_DEBUG_LOW_ON THEN
2716: OZF_Utility_PVT.debug_message('Accounting event: id = '||l_accounting_event_id);
2717: END IF;
2718:
2719: -- pass accounting event id
2720: x_event_id := l_accounting_event_id;

Line 2907: OZF_UTILITY_PVT.debug_message('Line Number before calling api: ' ||

2903: -- Create account event lines
2904: FOR i in 1..l_AE_LINE_Tbl.count LOOP
2905: l_AE_LINE_Tbl(i).ae_header_id := l_ae_header_id;
2906: IF OZF_DEBUG_HIGH_ON THEN
2907: OZF_UTILITY_PVT.debug_message('Line Number before calling api: ' ||
2908: l_ae_line_tbl(i).ae_line_number);
2909: END IF;
2910: END LOOP;
2911:

Line 3159: OZF_Utility_PVT.debug_message('--------- Revert_GL_Entry ----------');

3155: -- Initialize API return status to sucess
3156: x_return_status := FND_API.G_RET_STS_SUCCESS;
3157:
3158: IF OZF_DEBUG_LOW_ON THEN
3159: OZF_Utility_PVT.debug_message('--------- Revert_GL_Entry ----------');
3160: OZF_Utility_PVT.debug_message('claim_id : '||p_claim_id);
3161: END IF;
3162:
3163: OPEN get_accounting_event_csr( p_claim_id );

Line 3160: OZF_Utility_PVT.debug_message('claim_id : '||p_claim_id);

3156: x_return_status := FND_API.G_RET_STS_SUCCESS;
3157:
3158: IF OZF_DEBUG_LOW_ON THEN
3159: OZF_Utility_PVT.debug_message('--------- Revert_GL_Entry ----------');
3160: OZF_Utility_PVT.debug_message('claim_id : '||p_claim_id);
3161: END IF;
3162:
3163: OPEN get_accounting_event_csr( p_claim_id );
3164: FETCH get_accounting_event_csr INTO l_accounting_event_id

Line 3177: OZF_Utility_PVT.debug_message('There is no accounting event for the source. Return to the caller.');

3173: CLOSE get_accounting_event_csr;
3174:
3175: IF l_accounting_event_id IS NULL OR l_accounting_event_id = FND_API.G_MISS_NUM THEN
3176: IF OZF_DEBUG_LOW_ON THEN
3177: OZF_Utility_PVT.debug_message('There is no accounting event for the source. Return to the caller.');
3178: END IF;
3179:
3180: RETURN;
3181: END IF;

Line 3184: OZF_Utility_PVT.debug_message('Found matching event id : '||l_accounting_event_id);

3180: RETURN;
3181: END IF;
3182:
3183: IF OZF_DEBUG_LOW_ON THEN
3184: OZF_Utility_PVT.debug_message('Found matching event id : '||l_accounting_event_id);
3185: END IF;
3186:
3187: OPEN get_ae_header_csr( l_accounting_event_id );
3188: FETCH get_ae_header_csr INTO l_ae_header_id

Line 3201: OZF_Utility_PVT.debug_message('Found matching header id : '||l_ae_header_id);

3197: , l_aeh_object_version_num;
3198: CLOSE get_ae_header_csr;
3199:
3200: IF OZF_DEBUG_LOW_ON THEN
3201: OZF_Utility_PVT.debug_message('Found matching header id : '||l_ae_header_id);
3202: END IF;
3203:
3204: IF l_gl_transfer_yn = 'Y' THEN
3205: -- Create reverse entries in the SLA

Line 3207: OZF_Utility_PVT.debug_message('Transferred to GL, create reverse entries');

3203:
3204: IF l_gl_transfer_yn = 'Y' THEN
3205: -- Create reverse entries in the SLA
3206: IF OZF_DEBUG_LOW_ON THEN
3207: OZF_Utility_PVT.debug_message('Transferred to GL, create reverse entries');
3208: END IF;
3209:
3210: -- First create accounting event for the reversal event
3211: OZF_ACCTNG_EVENTS_PVT.Create_Acctng_Events(

Line 3229: OZF_Utility_PVT.debug_message('Created new accounting event');

3225: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3226: END IF;
3227:
3228: IF OZF_DEBUG_LOW_ON THEN
3229: OZF_Utility_PVT.debug_message('Created new accounting event');
3230: END IF;
3231:
3232: -- Create a new header for reversal entries
3233: l_ae_header_rec.gl_transfer_flag := 'N';

Line 3268: OZF_Utility_PVT.debug_message('Created new accounting header');

3264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3265: END IF;
3266:
3267: IF OZF_DEBUG_LOW_ON THEN
3268: OZF_Utility_PVT.debug_message('Created new accounting header');
3269: END IF;
3270:
3271: -- Create new lines for the reverse entries, by switching credit/debit amounts
3272: k := 1;

Line 3337: OZF_Utility_PVT.debug_message('Created new accounting lines with reversed amounts');

3333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3334: END IF;
3335:
3336: IF OZF_DEBUG_LOW_ON THEN
3337: OZF_Utility_PVT.debug_message('Created new accounting lines with reversed amounts');
3338: END IF;
3339:
3340: -- Finally, mark original header as reversed
3341: UPDATE ozf_ae_headers_all

Line 3347: OZF_Utility_PVT.debug_message('Not transferred to GL, delete SLA entries');

3343: WHERE ae_header_id = l_ae_header_id;
3344: ELSE
3345: -- Delete SLA entries not transferred to GL
3346: IF OZF_DEBUG_LOW_ON THEN
3347: OZF_Utility_PVT.debug_message('Not transferred to GL, delete SLA entries');
3348: END IF;
3349: --//Bugfix :7297267
3350: OPEN get_ae_lines_csr( l_ae_header_id );
3351: LOOP

Line 3356: OZF_UTILITY_PVT.debug_message('Delting SLA line, line_id:' || l_ae_line_id);

3352: FETCH get_ae_lines_csr INTO l_ae_line_id, l_ael_object_version_num;
3353: EXIT WHEN get_ae_lines_csr%notfound;
3354:
3355: IF OZF_DEBUG_HIGH_ON THEN
3356: OZF_UTILITY_PVT.debug_message('Delting SLA line, line_id:' || l_ae_line_id);
3357: END IF;
3358:
3359: -- Delete SLA lines not transferred
3360: OZF_AE_LINE_PVT.Delete_Ae_Line(

Line 3380: OZF_Utility_PVT.debug_message('Deleted lines');

3376: END LOOP;
3377: CLOSE get_ae_lines_csr;
3378:
3379: IF OZF_DEBUG_LOW_ON THEN
3380: OZF_Utility_PVT.debug_message('Deleted lines');
3381: END IF;
3382:
3383: -- Delete SLA header not transferred
3384: OZF_AE_HEADER_PVT.Delete_Ae_Header(

Line 3402: OZF_Utility_PVT.debug_message('Deleted header');

3398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3399: END IF;
3400:
3401: IF OZF_DEBUG_LOW_ON THEN
3402: OZF_Utility_PVT.debug_message('Deleted header');
3403: END IF;
3404:
3405: -- Delete SLA accounting event not transferred
3406: OZF_ACCTNG_EVENTS_PVT.Delete_Acctng_Events(

Line 3424: OZF_Utility_PVT.debug_message('Deleted header');

3420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3421: END IF;
3422:
3423: IF OZF_DEBUG_LOW_ON THEN
3424: OZF_Utility_PVT.debug_message('Deleted header');
3425: OZF_Utility_PVT.debug_message('Accounting entries successfully reverted.');
3426: END IF;
3427:
3428: END IF;

Line 3425: OZF_Utility_PVT.debug_message('Accounting entries successfully reverted.');

3421: END IF;
3422:
3423: IF OZF_DEBUG_LOW_ON THEN
3424: OZF_Utility_PVT.debug_message('Deleted header');
3425: OZF_Utility_PVT.debug_message('Accounting entries successfully reverted.');
3426: END IF;
3427:
3428: END IF;
3429:

Line 3554: OZF_Utility_PVT.debug_message('--------- Post_Accrual_To_GL ----------');

3550: -- Initialize API return status to sucess
3551: x_return_status := FND_API.G_RET_STS_SUCCESS;
3552:
3553: IF OZF_DEBUG_LOW_ON THEN
3554: OZF_Utility_PVT.debug_message('--------- Post_Accrual_To_GL ----------');
3555: OZF_Utility_PVT.debug_message('utilization_id : '||p_utilization_id);
3556: OZF_Utility_PVT.debug_message('utilization_type : '||p_utilization_type);
3557: OZF_Utility_PVT.debug_message('adjustment_type : '||p_adjustment_type);
3558: OZF_Utility_PVT.debug_message('debit_cc_id : '||p_dr_code_combination_id);

Line 3555: OZF_Utility_PVT.debug_message('utilization_id : '||p_utilization_id);

3551: x_return_status := FND_API.G_RET_STS_SUCCESS;
3552:
3553: IF OZF_DEBUG_LOW_ON THEN
3554: OZF_Utility_PVT.debug_message('--------- Post_Accrual_To_GL ----------');
3555: OZF_Utility_PVT.debug_message('utilization_id : '||p_utilization_id);
3556: OZF_Utility_PVT.debug_message('utilization_type : '||p_utilization_type);
3557: OZF_Utility_PVT.debug_message('adjustment_type : '||p_adjustment_type);
3558: OZF_Utility_PVT.debug_message('debit_cc_id : '||p_dr_code_combination_id);
3559: OZF_Utility_PVT.debug_message('credit_cc_id : '||p_cr_code_combination_id);

Line 3556: OZF_Utility_PVT.debug_message('utilization_type : '||p_utilization_type);

3552:
3553: IF OZF_DEBUG_LOW_ON THEN
3554: OZF_Utility_PVT.debug_message('--------- Post_Accrual_To_GL ----------');
3555: OZF_Utility_PVT.debug_message('utilization_id : '||p_utilization_id);
3556: OZF_Utility_PVT.debug_message('utilization_type : '||p_utilization_type);
3557: OZF_Utility_PVT.debug_message('adjustment_type : '||p_adjustment_type);
3558: OZF_Utility_PVT.debug_message('debit_cc_id : '||p_dr_code_combination_id);
3559: OZF_Utility_PVT.debug_message('credit_cc_id : '||p_cr_code_combination_id);
3560: OZF_Utility_PVT.debug_message('skip_acc_gen_flag : '||p_skip_acct_gen_flag);

Line 3557: OZF_Utility_PVT.debug_message('adjustment_type : '||p_adjustment_type);

3553: IF OZF_DEBUG_LOW_ON THEN
3554: OZF_Utility_PVT.debug_message('--------- Post_Accrual_To_GL ----------');
3555: OZF_Utility_PVT.debug_message('utilization_id : '||p_utilization_id);
3556: OZF_Utility_PVT.debug_message('utilization_type : '||p_utilization_type);
3557: OZF_Utility_PVT.debug_message('adjustment_type : '||p_adjustment_type);
3558: OZF_Utility_PVT.debug_message('debit_cc_id : '||p_dr_code_combination_id);
3559: OZF_Utility_PVT.debug_message('credit_cc_id : '||p_cr_code_combination_id);
3560: OZF_Utility_PVT.debug_message('skip_acc_gen_flag : '||p_skip_acct_gen_flag);
3561: END IF;

Line 3558: OZF_Utility_PVT.debug_message('debit_cc_id : '||p_dr_code_combination_id);

3554: OZF_Utility_PVT.debug_message('--------- Post_Accrual_To_GL ----------');
3555: OZF_Utility_PVT.debug_message('utilization_id : '||p_utilization_id);
3556: OZF_Utility_PVT.debug_message('utilization_type : '||p_utilization_type);
3557: OZF_Utility_PVT.debug_message('adjustment_type : '||p_adjustment_type);
3558: OZF_Utility_PVT.debug_message('debit_cc_id : '||p_dr_code_combination_id);
3559: OZF_Utility_PVT.debug_message('credit_cc_id : '||p_cr_code_combination_id);
3560: OZF_Utility_PVT.debug_message('skip_acc_gen_flag : '||p_skip_acct_gen_flag);
3561: END IF;
3562:

Line 3559: OZF_Utility_PVT.debug_message('credit_cc_id : '||p_cr_code_combination_id);

3555: OZF_Utility_PVT.debug_message('utilization_id : '||p_utilization_id);
3556: OZF_Utility_PVT.debug_message('utilization_type : '||p_utilization_type);
3557: OZF_Utility_PVT.debug_message('adjustment_type : '||p_adjustment_type);
3558: OZF_Utility_PVT.debug_message('debit_cc_id : '||p_dr_code_combination_id);
3559: OZF_Utility_PVT.debug_message('credit_cc_id : '||p_cr_code_combination_id);
3560: OZF_Utility_PVT.debug_message('skip_acc_gen_flag : '||p_skip_acct_gen_flag);
3561: END IF;
3562:
3563: -- construct gl interface record

Line 3560: OZF_Utility_PVT.debug_message('skip_acc_gen_flag : '||p_skip_acct_gen_flag);

3556: OZF_Utility_PVT.debug_message('utilization_type : '||p_utilization_type);
3557: OZF_Utility_PVT.debug_message('adjustment_type : '||p_adjustment_type);
3558: OZF_Utility_PVT.debug_message('debit_cc_id : '||p_dr_code_combination_id);
3559: OZF_Utility_PVT.debug_message('credit_cc_id : '||p_cr_code_combination_id);
3560: OZF_Utility_PVT.debug_message('skip_acc_gen_flag : '||p_skip_acct_gen_flag);
3561: END IF;
3562:
3563: -- construct gl interface record
3564: l_gl_rec.event_type_code := p_utilization_type;

Line 3708: OZF_Utility_PVT.debug_message('--------- Post_Claim_To_GL ----------');

3704: -- Initialize API return status to sucess
3705: x_return_status := FND_API.G_RET_STS_SUCCESS;
3706:
3707: IF OZF_DEBUG_LOW_ON THEN
3708: OZF_Utility_PVT.debug_message('--------- Post_Claim_To_GL ----------');
3709: OZF_Utility_PVT.debug_message('claim_id : '||p_claim_id);
3710: OZF_Utility_PVT.debug_message('claim_class : '||p_claim_class);
3711: OZF_Utility_PVT.debug_message('settlement method : '||p_settlement_method);
3712: END IF;

Line 3709: OZF_Utility_PVT.debug_message('claim_id : '||p_claim_id);

3705: x_return_status := FND_API.G_RET_STS_SUCCESS;
3706:
3707: IF OZF_DEBUG_LOW_ON THEN
3708: OZF_Utility_PVT.debug_message('--------- Post_Claim_To_GL ----------');
3709: OZF_Utility_PVT.debug_message('claim_id : '||p_claim_id);
3710: OZF_Utility_PVT.debug_message('claim_class : '||p_claim_class);
3711: OZF_Utility_PVT.debug_message('settlement method : '||p_settlement_method);
3712: END IF;
3713:

Line 3710: OZF_Utility_PVT.debug_message('claim_class : '||p_claim_class);

3706:
3707: IF OZF_DEBUG_LOW_ON THEN
3708: OZF_Utility_PVT.debug_message('--------- Post_Claim_To_GL ----------');
3709: OZF_Utility_PVT.debug_message('claim_id : '||p_claim_id);
3710: OZF_Utility_PVT.debug_message('claim_class : '||p_claim_class);
3711: OZF_Utility_PVT.debug_message('settlement method : '||p_settlement_method);
3712: END IF;
3713:
3714: -- construct gl interface record

Line 3711: OZF_Utility_PVT.debug_message('settlement method : '||p_settlement_method);

3707: IF OZF_DEBUG_LOW_ON THEN
3708: OZF_Utility_PVT.debug_message('--------- Post_Claim_To_GL ----------');
3709: OZF_Utility_PVT.debug_message('claim_id : '||p_claim_id);
3710: OZF_Utility_PVT.debug_message('claim_class : '||p_claim_class);
3711: OZF_Utility_PVT.debug_message('settlement method : '||p_settlement_method);
3712: END IF;
3713:
3714: -- construct gl interface record
3715: -- R12.1 Enhancement : GL rec for Accounting only