APPS.OZF_GL_INTERFACE_PVT dependencies on OZF_UTILITY_PVT

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

247: -- Initialize API return status to sucess
248: x_return_status := FND_API.G_RET_STS_SUCCESS;
249:
250: IF OZF_DEBUG_LOW_ON THEN
251: OZF_Utility_PVT.debug_message('p_account_type : '||p_account_type);
252: OZF_Utility_PVT.debug_message('p_source_table : '||p_source_table);
253: OZF_Utility_PVT.debug_message('p_source_id : '||p_source_id);
254: END IF;
255: l_acct_gen_tbl := acct_gen_tbl();

Line 252: OZF_Utility_PVT.debug_message('p_source_table : '||p_source_table);

248: x_return_status := FND_API.G_RET_STS_SUCCESS;
249:
250: IF OZF_DEBUG_LOW_ON THEN
251: OZF_Utility_PVT.debug_message('p_account_type : '||p_account_type);
252: OZF_Utility_PVT.debug_message('p_source_table : '||p_source_table);
253: OZF_Utility_PVT.debug_message('p_source_id : '||p_source_id);
254: END IF;
255: l_acct_gen_tbl := acct_gen_tbl();
256:

Line 253: OZF_Utility_PVT.debug_message('p_source_id : '||p_source_id);

249:
250: IF OZF_DEBUG_LOW_ON THEN
251: OZF_Utility_PVT.debug_message('p_account_type : '||p_account_type);
252: OZF_Utility_PVT.debug_message('p_source_table : '||p_source_table);
253: OZF_Utility_PVT.debug_message('p_source_id : '||p_source_id);
254: END IF;
255: l_acct_gen_tbl := acct_gen_tbl();
256:
257: --ER#9382547 ChRM-SLA Uptake

Line 383: OZF_Utility_PVT.debug_message('l_acct_gen_tbl.count Before calling account generator API : '||l_acct_gen_tbl.count);

379:
380: x_cc_id_tbl := CC_ID_TBL();
381:
382: IF OZF_DEBUG_LOW_ON THEN
383: OZF_Utility_PVT.debug_message('l_acct_gen_tbl.count Before calling account generator API : '||l_acct_gen_tbl.count);
384: END IF;
385:
386: FOR i in 1..l_acct_gen_tbl.count LOOP
387:

Line 416: OZF_Utility_PVT.debug_message('Before Calling Account Generator API');

412: l_order_id := null;
413: END IF;
414:
415: IF OZF_DEBUG_LOW_ON THEN
416: OZF_Utility_PVT.debug_message('Before Calling Account Generator API');
417: OZF_Utility_PVT.debug_message('p_event_type:' || p_event_type);
418: END IF;
419: -- Fix for Bug#13891326 -- Commented the code. Fix for Bug#13721874
420: /*IF (p_event_type IS NOT NULL and p_event_type = 'SETTLE_BY_AP_DEBIT') THEN

Line 417: OZF_Utility_PVT.debug_message('p_event_type:' || p_event_type);

413: END IF;
414:
415: IF OZF_DEBUG_LOW_ON THEN
416: OZF_Utility_PVT.debug_message('Before Calling Account Generator API');
417: OZF_Utility_PVT.debug_message('p_event_type:' || p_event_type);
418: END IF;
419: -- Fix for Bug#13891326 -- Commented the code. Fix for Bug#13721874
420: /*IF (p_event_type IS NOT NULL and p_event_type = 'SETTLE_BY_AP_DEBIT') THEN
421: IF(l_acct_gen_tbl(i).amount is not null and l_acct_gen_tbl(i).amount > 0) THEN

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

466: END IF;
467: x_return_status := FND_API.g_ret_sts_unexp_error;
468: END;
469: IF OZF_DEBUG_HIGH_ON THEN
470: OZF_UTILITY_PVT.debug_message('St and Id '||x_return_status||'-'||l_ccid);
471: END IF;
472: IF x_return_status = FND_API.g_ret_sts_error OR
473: x_return_status = FND_API.g_ret_sts_unexp_error
474: THEN

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

695: l_taxfor VARCHAR2(2);
696:
697: BEGIN
698: IF OZF_DEBUG_HIGH_ON THEN
699: OZF_UTILITY_PVT.debug_message('Get_Account_Type_Code procedure');
700: END IF;
701: IF p_event_type_code = 'ACCRUAL_CREATION' OR
702: p_event_type_code = 'ACCRUAL_ADJUSTMENT' THEN
703: IF p_event_type = 'DR' THEN

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

838: where claim_id = cv_claim_id;
839:
840: BEGIN
841: IF OZF_DEBUG_HIGH_ON THEN
842: OZF_UTILITY_PVT.debug_message('Get_Account_Description procedure');
843: END IF;
844: get_ae_category (p_source_table => p_gl_rec.source_table,
845: p_source_id => p_gl_rec.source_id,
846: x_ae_category => l_ae_category,

Line 963: OZF_UTILITY_PVT.debug_message('get_acctg_accounts procedure');

959:
960:
961: BEGIN
962: IF OZF_DEBUG_HIGH_ON THEN
963: OZF_UTILITY_PVT.debug_message('get_acctg_accounts procedure');
964: OZF_UTILITY_PVT.debug_message('l_source_object_class:' || l_source_object_class);
965: END IF;
966:
967: G_CLAIM_ID := p_gl_rec.source_id;

Line 964: OZF_UTILITY_PVT.debug_message('l_source_object_class:' || l_source_object_class);

960:
961: BEGIN
962: IF OZF_DEBUG_HIGH_ON THEN
963: OZF_UTILITY_PVT.debug_message('get_acctg_accounts procedure');
964: OZF_UTILITY_PVT.debug_message('l_source_object_class:' || l_source_object_class);
965: END IF;
966:
967: G_CLAIM_ID := p_gl_rec.source_id;
968:

Line 999: OZF_UTILITY_PVT.debug_message('p_gl_rec.source_table:' || p_gl_rec.source_table);

995: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
996: END IF;
997:
998: IF OZF_DEBUG_HIGH_ON THEN
999: OZF_UTILITY_PVT.debug_message('p_gl_rec.source_table:' || p_gl_rec.source_table);
1000: OZF_UTILITY_PVT.debug_message('l_cr_account_type_code:' || l_cr_account_type_code );
1001: OZF_UTILITY_PVT.debug_message('l_dr_account_type_code:' || l_dr_account_type_code);
1002: END IF;
1003:

Line 1000: OZF_UTILITY_PVT.debug_message('l_cr_account_type_code:' || l_cr_account_type_code );

996: END IF;
997:
998: IF OZF_DEBUG_HIGH_ON THEN
999: OZF_UTILITY_PVT.debug_message('p_gl_rec.source_table:' || p_gl_rec.source_table);
1000: OZF_UTILITY_PVT.debug_message('l_cr_account_type_code:' || l_cr_account_type_code );
1001: OZF_UTILITY_PVT.debug_message('l_dr_account_type_code:' || l_dr_account_type_code);
1002: END IF;
1003:
1004: IF (upper(p_gl_rec.source_table) = 'OZF_FUNDS_UTILIZED_ALL_B') THEN

Line 1001: OZF_UTILITY_PVT.debug_message('l_dr_account_type_code:' || l_dr_account_type_code);

997:
998: IF OZF_DEBUG_HIGH_ON THEN
999: OZF_UTILITY_PVT.debug_message('p_gl_rec.source_table:' || p_gl_rec.source_table);
1000: OZF_UTILITY_PVT.debug_message('l_cr_account_type_code:' || l_cr_account_type_code );
1001: OZF_UTILITY_PVT.debug_message('l_dr_account_type_code:' || l_dr_account_type_code);
1002: END IF;
1003:
1004: IF (upper(p_gl_rec.source_table) = 'OZF_FUNDS_UTILIZED_ALL_B') THEN
1005:

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

1003:
1004: IF (upper(p_gl_rec.source_table) = 'OZF_FUNDS_UTILIZED_ALL_B') THEN
1005:
1006: IF OZF_DEBUG_HIGH_ON THEN
1007: OZF_UTILITY_PVT.debug_message('Getting GL Account for debiting');
1008: END IF;
1009: -- get accounts from account generator for debiting
1010:
1011: -- For Paid Adjustment we will call the account generatot for Accrual Liability account for DR only as the

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

1051: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1052: END IF;
1053:
1054: IF OZF_DEBUG_HIGH_ON THEN
1055: OZF_UTILITY_PVT.debug_message('Getting GL Account for crediting');
1056: END IF;
1057: -- get accounts from account generator for crediting
1058:
1059: Get_GL_Account(

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

1071: IF x_return_status = FND_API.g_ret_sts_error THEN
1072: RAISE FND_API.G_EXC_ERROR;
1073: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1074: IF OZF_DEBUG_HIGH_ON THEN
1075: OZF_UTILITY_PVT.debug_message('Unexp Error in getting CR account');
1076: END IF;
1077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1078: END IF;
1079: END IF;

Line 1083: OZF_UTILITY_PVT.debug_message('l_source_object_class:' || l_source_object_class);

1079: END IF;
1080: ELSIF(upper(p_gl_rec.source_table) = 'OZF_CLAIMS_ALL') THEN
1081:
1082: IF OZF_DEBUG_HIGH_ON THEN
1083: OZF_UTILITY_PVT.debug_message('l_source_object_class:' || l_source_object_class);
1084: END IF;
1085:
1086: IF (p_gl_rec.event_type_code IN ('SETTLE_BY_CREDIT_MEMO','SETTLE_BY_AR_AP_NETTING','SETTLE_BY_ACCOUNTING_ONLY',
1087: 'SETTLE_BY_AR_CUSTOM')

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

1087: 'SETTLE_BY_AR_CUSTOM')
1088: OR (p_gl_rec.event_type_code IN ('SETTLE_BY_AP_CUSTOM','SETTLE_BY_AP_INVOICE','SETTLE_BY_AP_DEBIT')
1089: AND (l_source_object_class IS NULL OR l_source_object_class <> 'SD_SUPPLIER'))) THEN
1090: IF OZF_DEBUG_HIGH_ON THEN
1091: OZF_UTILITY_PVT.debug_message('Getting GL Account for debiting');
1092: END IF;
1093: -- get accounts from account generator for debiting
1094: Get_GL_Account(
1095: p_api_version => 1.0,

Line 1109: OZF_UTILITY_PVT.debug_message('Unexp Error in getting DR account');

1105: IF x_return_status = FND_API.g_ret_sts_error THEN
1106: RAISE FND_API.G_EXC_ERROR;
1107: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1108: IF OZF_DEBUG_HIGH_ON THEN
1109: OZF_UTILITY_PVT.debug_message('Unexp Error in getting DR account');
1110: END IF;
1111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1112: END IF;
1113: ELSIF(p_gl_rec.event_type_code IN ('SETTLE_BY_DEBIT_MEMO')

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

1113: ELSIF(p_gl_rec.event_type_code IN ('SETTLE_BY_DEBIT_MEMO')
1114: OR (p_gl_rec.event_type_code IN ('SETTLE_BY_AP_CUSTOM','SETTLE_BY_AP_INVOICE','SETTLE_BY_AP_DEBIT')
1115: AND (l_source_object_class IS NOT NULL AND l_source_object_class = 'SD_SUPPLIER'))) THEN
1116: IF OZF_DEBUG_HIGH_ON THEN
1117: OZF_UTILITY_PVT.debug_message('Getting GL Account for crediting');
1118: END IF;
1119: -- get accounts from account generator for crediting
1120: Get_GL_Account(
1121: p_api_version => 1.0,

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

1133: IF x_return_status = FND_API.g_ret_sts_error THEN
1134: RAISE FND_API.G_EXC_ERROR;
1135: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1136: IF OZF_DEBUG_HIGH_ON THEN
1137: OZF_UTILITY_PVT.debug_message('Unexp Error in getting CR account');
1138: END IF;
1139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1140: END IF;
1141: END IF;

Line 1143: OZF_UTILITY_PVT.debug_message('After Get_gl_account');

1139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1140: END IF;
1141: END IF;
1142: END IF;
1143: OZF_UTILITY_PVT.debug_message('After Get_gl_account');
1144: -- for accruals and accrual adjustments
1145: IF upper(p_gl_rec.source_table) = 'OZF_FUNDS_UTILIZED_ALL_B' THEN
1146: IF p_gl_rec.event_type_code = 'ACCRUAL_CREATION' OR
1147: p_gl_rec.event_type_code = 'ACCRUAL_ADJUSTMENT' THEN

Line 1150: OZF_UTILITY_PVT.debug_message('l_dr_cc_id_tbl(1).code_combination_id:' || l_dr_cc_id_tbl(1).code_combination_id);

1146: IF p_gl_rec.event_type_code = 'ACCRUAL_CREATION' OR
1147: p_gl_rec.event_type_code = 'ACCRUAL_ADJUSTMENT' THEN
1148:
1149: IF OZF_DEBUG_LOW_ON THEN
1150: OZF_UTILITY_PVT.debug_message('l_dr_cc_id_tbl(1).code_combination_id:' || l_dr_cc_id_tbl(1).code_combination_id);
1151: OZF_UTILITY_PVT.debug_message('l_cr_cc_id_tbl(1).code_combination_id:' || l_cr_cc_id_tbl(1).code_combination_id);
1152: END IF;
1153: x_actg_tbl(1).CODE_COMBINATION_ID := l_dr_cc_id_tbl(1).code_combination_id;
1154: x_actg_tbl(1).ACCOUNT_TYPE := 'EXPENSE ACCOUNT';

Line 1151: OZF_UTILITY_PVT.debug_message('l_cr_cc_id_tbl(1).code_combination_id:' || l_cr_cc_id_tbl(1).code_combination_id);

1147: p_gl_rec.event_type_code = 'ACCRUAL_ADJUSTMENT' THEN
1148:
1149: IF OZF_DEBUG_LOW_ON THEN
1150: OZF_UTILITY_PVT.debug_message('l_dr_cc_id_tbl(1).code_combination_id:' || l_dr_cc_id_tbl(1).code_combination_id);
1151: OZF_UTILITY_PVT.debug_message('l_cr_cc_id_tbl(1).code_combination_id:' || l_cr_cc_id_tbl(1).code_combination_id);
1152: END IF;
1153: x_actg_tbl(1).CODE_COMBINATION_ID := l_dr_cc_id_tbl(1).code_combination_id;
1154: x_actg_tbl(1).ACCOUNT_TYPE := 'EXPENSE ACCOUNT';
1155: x_actg_tbl(2).CODE_COMBINATION_ID := l_cr_cc_id_tbl(1).code_combination_id;

Line 1181: OZF_UTILITY_PVT.debug_message('l_dr_cc_id_tbl(i).line_util_id:' || l_dr_cc_id_tbl(i).line_util_id);

1177: THEN
1178: -- debit line -- accrual liability
1179: FOR i in 1..l_dr_cc_id_tbl.count LOOP
1180: IF OZF_DEBUG_LOW_ON THEN
1181: OZF_UTILITY_PVT.debug_message('l_dr_cc_id_tbl(i).line_util_id:' || l_dr_cc_id_tbl(i).line_util_id);
1182: OZF_UTILITY_PVT.debug_message('l_dr_cc_id_tbl(i).code_combination_id:' || l_dr_cc_id_tbl(i).code_combination_id);
1183: END IF;
1184: x_actg_tbl(l_dr_cc_id_tbl(i).line_util_id).CODE_COMBINATION_ID := l_dr_cc_id_tbl(i).code_combination_id;
1185: x_actg_tbl(l_dr_cc_id_tbl(i).line_util_id).ACCOUNT_TYPE := 'ACCRUAL_LIABILITY';

Line 1182: OZF_UTILITY_PVT.debug_message('l_dr_cc_id_tbl(i).code_combination_id:' || l_dr_cc_id_tbl(i).code_combination_id);

1178: -- debit line -- accrual liability
1179: FOR i in 1..l_dr_cc_id_tbl.count LOOP
1180: IF OZF_DEBUG_LOW_ON THEN
1181: OZF_UTILITY_PVT.debug_message('l_dr_cc_id_tbl(i).line_util_id:' || l_dr_cc_id_tbl(i).line_util_id);
1182: OZF_UTILITY_PVT.debug_message('l_dr_cc_id_tbl(i).code_combination_id:' || l_dr_cc_id_tbl(i).code_combination_id);
1183: END IF;
1184: x_actg_tbl(l_dr_cc_id_tbl(i).line_util_id).CODE_COMBINATION_ID := l_dr_cc_id_tbl(i).code_combination_id;
1185: x_actg_tbl(l_dr_cc_id_tbl(i).line_util_id).ACCOUNT_TYPE := 'ACCRUAL_LIABILITY';
1186: END LOOP;

Line 1221: OZF_UTILITY_PVT.debug_message('sqlerrm:'|| sqlerrm);

1217: x_return_status := FND_API.G_RET_STS_ERROR;
1218: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1220: WHEN OTHERS THEN
1221: OZF_UTILITY_PVT.debug_message('sqlerrm:'|| sqlerrm);
1222: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1223: FND_MESSAGE.set_name('OZF', 'OZF_GL_LINE_AMOUNT_CALC_ERROR');
1224: FND_MSG_PUB.add;
1225: END IF;

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

1461: x_period_name => l_period_name,
1462: x_return_status => x_return_status);
1463:
1464: IF OZF_DEBUG_HIGH_ON THEN
1465: OZF_UTILITY_PVT.debug_message('AE Category'||l_ae_category);
1466: END IF;
1467: IF x_return_status = FND_API.g_ret_sts_error THEN
1468: RAISE FND_API.G_EXC_ERROR;
1469: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

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

1608: -- ae lines
1609: x_ae_line_tbl := OZF_ae_line_PVT.ae_line_tbl_type();
1610: l_num_lines := l_amount_tbl.count;
1611: IF OZF_DEBUG_HIGH_ON THEN
1612: OZF_UTILITY_PVT.debug_message('Number of Lines: ' || l_num_lines);
1613: END IF;
1614: FOR i in 1..l_num_lines LOOP
1615: x_ae_line_tbl.extend;
1616: x_ae_line_tbl(i) := null;

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

1613: END IF;
1614: FOR i in 1..l_num_lines LOOP
1615: x_ae_line_tbl.extend;
1616: x_ae_line_tbl(i) := null;
1617: --OZF_UTILITY_PVT.debug_message('Line Number before entering: ' || x_ae_line_tbl(i).ae_line_number);
1618: --if x_ae_line_tbl(i).ae_line_type_code = FND_API.G_MISS_CHAR then
1619: --OZF_UTILITY_PVT.debug_message('Line Type Code before entering - miss char: ' || x_ae_line_tbl(i).ae_line_type_code);
1620: --else
1621: --OZF_UTILITY_PVT.debug_message('Line Type Code before entering: ' || x_ae_line_tbl(i).ae_line_type_code);

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

1615: x_ae_line_tbl.extend;
1616: x_ae_line_tbl(i) := null;
1617: --OZF_UTILITY_PVT.debug_message('Line Number before entering: ' || x_ae_line_tbl(i).ae_line_number);
1618: --if x_ae_line_tbl(i).ae_line_type_code = FND_API.G_MISS_CHAR then
1619: --OZF_UTILITY_PVT.debug_message('Line Type Code before entering - miss char: ' || x_ae_line_tbl(i).ae_line_type_code);
1620: --else
1621: --OZF_UTILITY_PVT.debug_message('Line Type Code before entering: ' || x_ae_line_tbl(i).ae_line_type_code);
1622: --end if;
1623: --OZF_UTILITY_PVT.debug_message('Line Type Code assigned value: ' || x_amount_tbl(i).line_type_code);

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

1617: --OZF_UTILITY_PVT.debug_message('Line Number before entering: ' || x_ae_line_tbl(i).ae_line_number);
1618: --if x_ae_line_tbl(i).ae_line_type_code = FND_API.G_MISS_CHAR then
1619: --OZF_UTILITY_PVT.debug_message('Line Type Code before entering - miss char: ' || x_ae_line_tbl(i).ae_line_type_code);
1620: --else
1621: --OZF_UTILITY_PVT.debug_message('Line Type Code before entering: ' || x_ae_line_tbl(i).ae_line_type_code);
1622: --end if;
1623: --OZF_UTILITY_PVT.debug_message('Line Type Code assigned value: ' || x_amount_tbl(i).line_type_code);
1624: --OZF_UTILITY_PVT.debug_message('Processing Line: ' || i);
1625:

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

1619: --OZF_UTILITY_PVT.debug_message('Line Type Code before entering - miss char: ' || x_ae_line_tbl(i).ae_line_type_code);
1620: --else
1621: --OZF_UTILITY_PVT.debug_message('Line Type Code before entering: ' || x_ae_line_tbl(i).ae_line_type_code);
1622: --end if;
1623: --OZF_UTILITY_PVT.debug_message('Line Type Code assigned value: ' || x_amount_tbl(i).line_type_code);
1624: --OZF_UTILITY_PVT.debug_message('Processing Line: ' || i);
1625:
1626: -- Fix for Bug 7430768
1627: -- Fix for Bug 8274064, This will only valid for -ve adjustment for claims

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

1620: --else
1621: --OZF_UTILITY_PVT.debug_message('Line Type Code before entering: ' || x_ae_line_tbl(i).ae_line_type_code);
1622: --end if;
1623: --OZF_UTILITY_PVT.debug_message('Line Type Code assigned value: ' || x_amount_tbl(i).line_type_code);
1624: --OZF_UTILITY_PVT.debug_message('Processing Line: ' || i);
1625:
1626: -- Fix for Bug 7430768
1627: -- Fix for Bug 8274064, This will only valid for -ve adjustment for claims
1628: -- Fix for Bug 8666602

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

1664: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1665: RAISE FND_API.g_exc_unexpected_error;
1666: END IF;
1667:
1668: --OZF_UTILITY_PVT.debug_message('Line Number after entering: ' || x_ae_line_tbl(i).ae_line_number);
1669: --if x_ae_line_tbl(i).ae_line_type_code = FND_API.G_MISS_CHAR then
1670: --OZF_UTILITY_PVT.debug_message('Line Type Code after entering - miss char: ' || x_ae_line_tbl(i).ae_line_type_code);
1671: --else
1672: --OZF_UTILITY_PVT.debug_message('Line Type Code after entering: ' || x_ae_line_tbl(i).ae_line_type_code);

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

1666: END IF;
1667:
1668: --OZF_UTILITY_PVT.debug_message('Line Number after entering: ' || x_ae_line_tbl(i).ae_line_number);
1669: --if x_ae_line_tbl(i).ae_line_type_code = FND_API.G_MISS_CHAR then
1670: --OZF_UTILITY_PVT.debug_message('Line Type Code after entering - miss char: ' || x_ae_line_tbl(i).ae_line_type_code);
1671: --else
1672: --OZF_UTILITY_PVT.debug_message('Line Type Code after entering: ' || x_ae_line_tbl(i).ae_line_type_code);
1673: --end if;
1674: END LOOP;

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

1668: --OZF_UTILITY_PVT.debug_message('Line Number after entering: ' || x_ae_line_tbl(i).ae_line_number);
1669: --if x_ae_line_tbl(i).ae_line_type_code = FND_API.G_MISS_CHAR then
1670: --OZF_UTILITY_PVT.debug_message('Line Type Code after entering - miss char: ' || x_ae_line_tbl(i).ae_line_type_code);
1671: --else
1672: --OZF_UTILITY_PVT.debug_message('Line Type Code after entering: ' || x_ae_line_tbl(i).ae_line_type_code);
1673: --end if;
1674: END LOOP;
1675: --x_ae_line_tbl := l_ae_line_tbl;
1676:

Line 2016: l_revenue_acct := OZF_UTILITY_PVT.get_revenue_account(p_utilization_id => p_utilization_id

2012: CLOSE c_util_details;
2013:
2014: --//Fix for Bug 14498604
2015: IF p_gl_rec.event_type_code = 'INVOICE_DISCOUNT' THEN
2016: l_revenue_acct := OZF_UTILITY_PVT.get_revenue_account(p_utilization_id => p_utilization_id
2017: ,p_org_id => l_org_id);
2018: IF l_revenue_acct IS NULL THEN
2019: IF OZF_DEBUG_LOW_ON THEN
2020: OZF_Utility_PVT.debug_message('OZF_UTILITY_PVT.get_revenue_account() Call :- Revenue Account is Null ');

Line 2020: OZF_Utility_PVT.debug_message('OZF_UTILITY_PVT.get_revenue_account() Call :- Revenue Account is Null ');

2016: l_revenue_acct := OZF_UTILITY_PVT.get_revenue_account(p_utilization_id => p_utilization_id
2017: ,p_org_id => l_org_id);
2018: IF l_revenue_acct IS NULL THEN
2019: IF OZF_DEBUG_LOW_ON THEN
2020: OZF_Utility_PVT.debug_message('OZF_UTILITY_PVT.get_revenue_account() Call :- Revenue Account is Null ');
2021: END IF;
2022: RAISE FND_API.G_EXC_ERROR;
2023: END IF;
2024: END IF;

Line 2028: OZF_Utility_PVT.debug_message('Adjustment Type: '||l_adjustment_type);

2024: END IF;
2025:
2026:
2027: IF OZF_DEBUG_LOW_ON THEN
2028: OZF_Utility_PVT.debug_message('Adjustment Type: '||l_adjustment_type);
2029: END IF;
2030:
2031:
2032: l_actg_profile := NVL(fnd_profile.value('OZF_USE_ACCOUNT_GENERATOR'),'N');

Line 2048: OZF_Utility_PVT.debug_message('Account Generator Profile Value: '||l_actg_flag);

2044: END IF;
2045: END IF;
2046:
2047: IF OZF_DEBUG_LOW_ON THEN
2048: OZF_Utility_PVT.debug_message('Account Generator Profile Value: '||l_actg_flag);
2049: END IF;
2050: IF(l_actg_flag = 'Y') THEN
2051: get_acctg_accounts(
2052: p_gl_rec => p_gl_rec,

Line 2062: OZF_Utility_PVT.debug_message('Number of Record l_actg_tbl.count : '||l_actg_tbl.count);

2058: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
2059: RAISE FND_API.g_exc_unexpected_error;
2060: END IF;
2061: IF OZF_DEBUG_LOW_ON THEN
2062: OZF_Utility_PVT.debug_message('Number of Record l_actg_tbl.count : '||l_actg_tbl.count);
2063: END IF;
2064:
2065: --Populate TM SLA Accrual extract table
2066: IF(l_actg_tbl.count > 0) THEN

Line 2078: OZF_Utility_PVT.debug_message('After Loop l_actg_accrual_ccid:'|| l_actg_accrual_ccid);

2074: END IF;
2075: END IF;
2076:
2077: IF OZF_DEBUG_LOW_ON THEN
2078: OZF_Utility_PVT.debug_message('After Loop l_actg_accrual_ccid:'|| l_actg_accrual_ccid);
2079: OZF_Utility_PVT.debug_message('After Loop l_actg_expense_ccid'|| l_actg_expense_ccid);
2080: END IF;
2081:
2082: END IF;

Line 2079: OZF_Utility_PVT.debug_message('After Loop l_actg_expense_ccid'|| l_actg_expense_ccid);

2075: END IF;
2076:
2077: IF OZF_DEBUG_LOW_ON THEN
2078: OZF_Utility_PVT.debug_message('After Loop l_actg_accrual_ccid:'|| l_actg_accrual_ccid);
2079: OZF_Utility_PVT.debug_message('After Loop l_actg_expense_ccid'|| l_actg_expense_ccid);
2080: END IF;
2081:
2082: END IF;
2083:

Line 2085: OZF_Utility_PVT.debug_message('--------- Create_SLA_Accrual_Extract ----------');

2081:
2082: END IF;
2083:
2084: IF OZF_DEBUG_LOW_ON THEN
2085: OZF_Utility_PVT.debug_message('--------- Create_SLA_Accrual_Extract ----------');
2086: OZF_Utility_PVT.debug_message('utilization_id : '||p_utilization_id);
2087: OZF_Utility_PVT.debug_message('event_type_code : '||p_event_type_code);
2088: END IF;
2089:

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

2082: END IF;
2083:
2084: IF OZF_DEBUG_LOW_ON THEN
2085: OZF_Utility_PVT.debug_message('--------- Create_SLA_Accrual_Extract ----------');
2086: OZF_Utility_PVT.debug_message('utilization_id : '||p_utilization_id);
2087: OZF_Utility_PVT.debug_message('event_type_code : '||p_event_type_code);
2088: END IF;
2089:
2090:

Line 2087: OZF_Utility_PVT.debug_message('event_type_code : '||p_event_type_code);

2083:
2084: IF OZF_DEBUG_LOW_ON THEN
2085: OZF_Utility_PVT.debug_message('--------- Create_SLA_Accrual_Extract ----------');
2086: OZF_Utility_PVT.debug_message('utilization_id : '||p_utilization_id);
2087: OZF_Utility_PVT.debug_message('event_type_code : '||p_event_type_code);
2088: END IF;
2089:
2090:
2091:

Line 2175: ozf_utility_pvt.write_conc_log('duplicate event raised for accrual');

2171: WHEN DUP_VAL_ON_INDEX THEN --bug 13517522 - raise and catch error if duplicate value is inserted for column UTILIZATION_ID
2172: ROLLBACK TO Create_SLA_Accrual_Extract;
2173: x_return_status := FND_API.G_RET_STS_SUCCESS;
2174:
2175: ozf_utility_pvt.write_conc_log('duplicate event raised for accrual');
2176: ozf_utility_pvt.debug_message('duplicate event raised for accrual');
2177:
2178: WHEN FND_API.G_EXC_ERROR THEN
2179: ROLLBACK TO Create_SLA_Accrual_Extract;

Line 2176: ozf_utility_pvt.debug_message('duplicate event raised for accrual');

2172: ROLLBACK TO Create_SLA_Accrual_Extract;
2173: x_return_status := FND_API.G_RET_STS_SUCCESS;
2174:
2175: ozf_utility_pvt.write_conc_log('duplicate event raised for accrual');
2176: ozf_utility_pvt.debug_message('duplicate event raised for accrual');
2177:
2178: WHEN FND_API.G_EXC_ERROR THEN
2179: ROLLBACK TO Create_SLA_Accrual_Extract;
2180: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2369: OZF_Utility_PVT.debug_message('Number of Claim Line Utils: ' || l_count_claim_utils);

2365: FETCH c_count_claim_utils INTO l_count_claim_utils;
2366: CLOSE c_count_claim_utils;
2367:
2368: IF OZF_DEBUG_LOW_ON THEN
2369: OZF_Utility_PVT.debug_message('Number of Claim Line Utils: ' || l_count_claim_utils);
2370: END IF;
2371:
2372: -- If Association is there then raise the event
2373: IF(l_count_claim_utils > 0) THEN

Line 2376: OZF_Utility_PVT.debug_message('--------- Create_SLA_Claim_Extract ----------');

2372: -- If Association is there then raise the event
2373: IF(l_count_claim_utils > 0) THEN
2374:
2375: IF OZF_DEBUG_LOW_ON THEN
2376: OZF_Utility_PVT.debug_message('--------- Create_SLA_Claim_Extract ----------');
2377: OZF_Utility_PVT.debug_message('Claim_ID : '||p_claim_id);
2378: OZF_Utility_PVT.debug_message('event_type_code : '||p_event_type_code);
2379: END IF;
2380: --ER:13069257

Line 2377: OZF_Utility_PVT.debug_message('Claim_ID : '||p_claim_id);

2373: IF(l_count_claim_utils > 0) THEN
2374:
2375: IF OZF_DEBUG_LOW_ON THEN
2376: OZF_Utility_PVT.debug_message('--------- Create_SLA_Claim_Extract ----------');
2377: OZF_Utility_PVT.debug_message('Claim_ID : '||p_claim_id);
2378: OZF_Utility_PVT.debug_message('event_type_code : '||p_event_type_code);
2379: END IF;
2380: --ER:13069257
2381:

Line 2378: OZF_Utility_PVT.debug_message('event_type_code : '||p_event_type_code);

2374:
2375: IF OZF_DEBUG_LOW_ON THEN
2376: OZF_Utility_PVT.debug_message('--------- Create_SLA_Claim_Extract ----------');
2377: OZF_Utility_PVT.debug_message('Claim_ID : '||p_claim_id);
2378: OZF_Utility_PVT.debug_message('event_type_code : '||p_event_type_code);
2379: END IF;
2380: --ER:13069257
2381:
2382: l_actg_flag := NVL(fnd_profile.value('OZF_USE_ACCOUNT_GENERATOR'),'N');

Line 2385: OZF_Utility_PVT.debug_message('Account Generator Profile Value: '||l_actg_flag);

2381:
2382: l_actg_flag := NVL(fnd_profile.value('OZF_USE_ACCOUNT_GENERATOR'),'N');
2383:
2384: IF OZF_DEBUG_LOW_ON THEN
2385: OZF_Utility_PVT.debug_message('Account Generator Profile Value: '||l_actg_flag);
2386: END IF;
2387:
2388: /*If the value of OZF:Use Account Generator Workflow is set as YES then call the account generator otherwise not*/
2389:

Line 2417: OZF_Utility_PVT.debug_message('l_gl_date : '||l_gl_date);

2413: CLOSE c_hr_operating_unit;
2414:
2415:
2416: IF OZF_DEBUG_LOW_ON THEN
2417: OZF_Utility_PVT.debug_message('l_gl_date : '||l_gl_date);
2418: OZF_Utility_PVT.debug_message('l_org_id : '||l_org_id);
2419: OZF_Utility_PVT.debug_message('l_claim_date : '||l_claim_date);
2420: END IF;
2421:

Line 2418: OZF_Utility_PVT.debug_message('l_org_id : '||l_org_id);

2414:
2415:
2416: IF OZF_DEBUG_LOW_ON THEN
2417: OZF_Utility_PVT.debug_message('l_gl_date : '||l_gl_date);
2418: OZF_Utility_PVT.debug_message('l_org_id : '||l_org_id);
2419: OZF_Utility_PVT.debug_message('l_claim_date : '||l_claim_date);
2420: END IF;
2421:
2422: --//Fix for Bug 16215152

Line 2419: OZF_Utility_PVT.debug_message('l_claim_date : '||l_claim_date);

2415:
2416: IF OZF_DEBUG_LOW_ON THEN
2417: OZF_Utility_PVT.debug_message('l_gl_date : '||l_gl_date);
2418: OZF_Utility_PVT.debug_message('l_org_id : '||l_org_id);
2419: OZF_Utility_PVT.debug_message('l_claim_date : '||l_claim_date);
2420: END IF;
2421:
2422: --//Fix for Bug 16215152
2423: IF p_event_type_code = 'CLAIM_SETTLEMENT_REVERSAL' THEN

Line 2469: OZF_Utility_PVT.debug_message('l_xla_event_id : '||l_xla_event_id);

2465:
2466: x_xla_event_id := l_xla_event_id;
2467:
2468: IF OZF_DEBUG_LOW_ON THEN
2469: OZF_Utility_PVT.debug_message('l_xla_event_id : '||l_xla_event_id);
2470: OZF_Utility_PVT.debug_message('p_event_type_code : '||p_event_type_code);
2471: END IF;
2472:
2473:

Line 2470: OZF_Utility_PVT.debug_message('p_event_type_code : '||p_event_type_code);

2466: x_xla_event_id := l_xla_event_id;
2467:
2468: IF OZF_DEBUG_LOW_ON THEN
2469: OZF_Utility_PVT.debug_message('l_xla_event_id : '||l_xla_event_id);
2470: OZF_Utility_PVT.debug_message('p_event_type_code : '||p_event_type_code);
2471: END IF;
2472:
2473:
2474: IF (p_event_type_code IS NOT NULL AND p_event_type_code = 'CLAIM_SETTLEMENT_REVERSAL') THEN

Line 2481: OZF_Utility_PVT.debug_message('l_related_event_id : '||l_related_event_id);

2477: FETCH c_get_parent_event_id INTO l_related_event_id,l_parent_header_id;
2478: CLOSE c_get_parent_event_id;
2479:
2480: IF OZF_DEBUG_LOW_ON THEN
2481: OZF_Utility_PVT.debug_message('l_related_event_id : '||l_related_event_id);
2482: OZF_Utility_PVT.debug_message('l_parent_header_id : '||l_parent_header_id);
2483: END IF;
2484:
2485: --update parent's reversal_event_id with the reversal event

Line 2482: OZF_Utility_PVT.debug_message('l_parent_header_id : '||l_parent_header_id);

2478: CLOSE c_get_parent_event_id;
2479:
2480: IF OZF_DEBUG_LOW_ON THEN
2481: OZF_Utility_PVT.debug_message('l_related_event_id : '||l_related_event_id);
2482: OZF_Utility_PVT.debug_message('l_parent_header_id : '||l_parent_header_id);
2483: END IF;
2484:
2485: --update parent's reversal_event_id with the reversal event
2486: UPDATE ozf_xla_claim_headers

Line 2495: OZF_Utility_PVT.debug_message('l_reversal_flag : '||l_reversal_flag);

2491:
2492: END IF;
2493:
2494: IF OZF_DEBUG_LOW_ON THEN
2495: OZF_Utility_PVT.debug_message('l_reversal_flag : '||l_reversal_flag);
2496: END IF;
2497:
2498: OPEN c_xla_claims_header_seq;
2499: FETCH c_xla_claims_header_seq INTO l_xla_claim_hed_seq;

Line 2541: OZF_Utility_PVT.debug_message('Before Inserting l_actg_tbl.count:' || l_actg_tbl.count);

2537: l_actg_claim_acc_ccid := null;
2538: l_actg_claim_exp_ccid := null;
2539:
2540: IF OZF_DEBUG_LOW_ON THEN
2541: OZF_Utility_PVT.debug_message('Before Inserting l_actg_tbl.count:' || l_actg_tbl.count);
2542: END IF;
2543:
2544: IF(l_actg_tbl.count > 0) THEN
2545: IF p_event_type_code IN ('SETTLE_BY_CREDIT_MEMO','SETTLE_BY_AR_AP_NETTING','SETTLE_BY_ACCOUNTING_ONLY',

Line 2615: ozf_utility_pvt.write_conc_log('duplicate event raised for Claim Settlement');

2611: --amitamku fix for bug 16073366 - corrected the savepoint name
2612: ROLLBACK TO Create_SLA_Claim_Extract;
2613: x_return_status := FND_API.G_RET_STS_SUCCESS;
2614:
2615: ozf_utility_pvt.write_conc_log('duplicate event raised for Claim Settlement');
2616: ozf_utility_pvt.debug_message('duplicate event raised for Claim Settlement');
2617:
2618: WHEN FND_API.G_EXC_ERROR THEN
2619: ROLLBACK TO Create_SLA_Claim_Extract;

Line 2616: ozf_utility_pvt.debug_message('duplicate event raised for Claim Settlement');

2612: ROLLBACK TO Create_SLA_Claim_Extract;
2613: x_return_status := FND_API.G_RET_STS_SUCCESS;
2614:
2615: ozf_utility_pvt.write_conc_log('duplicate event raised for Claim Settlement');
2616: ozf_utility_pvt.debug_message('duplicate event raised for Claim Settlement');
2617:
2618: WHEN FND_API.G_EXC_ERROR THEN
2619: ROLLBACK TO Create_SLA_Claim_Extract;
2620: x_return_status := FND_API.G_RET_STS_ERROR;

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

2742: -- Initialize API return status to sucess
2743: x_return_status := FND_API.G_RET_STS_SUCCESS;
2744:
2745: IF OZF_DEBUG_LOW_ON THEN
2746: OZF_Utility_PVT.debug_message('--------- create_gl_entry ----------');
2747: OZF_Utility_PVT.debug_message('event_type_code : '||p_gl_rec.event_type_code);
2748: OZF_Utility_PVT.debug_message('source_id : '||p_gl_rec.source_id);
2749: OZF_Utility_PVT.debug_message('source_table : '||p_gl_rec.source_table);
2750: END IF;

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

2743: x_return_status := FND_API.G_RET_STS_SUCCESS;
2744:
2745: IF OZF_DEBUG_LOW_ON THEN
2746: OZF_Utility_PVT.debug_message('--------- create_gl_entry ----------');
2747: OZF_Utility_PVT.debug_message('event_type_code : '||p_gl_rec.event_type_code);
2748: OZF_Utility_PVT.debug_message('source_id : '||p_gl_rec.source_id);
2749: OZF_Utility_PVT.debug_message('source_table : '||p_gl_rec.source_table);
2750: END IF;
2751:

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

2744:
2745: IF OZF_DEBUG_LOW_ON THEN
2746: OZF_Utility_PVT.debug_message('--------- create_gl_entry ----------');
2747: OZF_Utility_PVT.debug_message('event_type_code : '||p_gl_rec.event_type_code);
2748: OZF_Utility_PVT.debug_message('source_id : '||p_gl_rec.source_id);
2749: OZF_Utility_PVT.debug_message('source_table : '||p_gl_rec.source_table);
2750: END IF;
2751:
2752:

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

2745: IF OZF_DEBUG_LOW_ON THEN
2746: OZF_Utility_PVT.debug_message('--------- create_gl_entry ----------');
2747: OZF_Utility_PVT.debug_message('event_type_code : '||p_gl_rec.event_type_code);
2748: OZF_Utility_PVT.debug_message('source_id : '||p_gl_rec.source_id);
2749: OZF_Utility_PVT.debug_message('source_table : '||p_gl_rec.source_table);
2750: END IF;
2751:
2752:
2753: --//ER#9382547 ChRM-SLA Uptake

Line 2790: OZF_Utility_PVT.debug_message('Inside null : '||l_post_to_gl);

2786: CLOSE accrual_gl_posting_csr;
2787:
2788:
2789: IF l_post_to_gl = 'X' THEN --ninarasi fix for bug 13793109
2790: OZF_Utility_PVT.debug_message('Inside null : '||l_post_to_gl);
2791: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2792: FND_MESSAGE.set_name('OZF', 'OZF_GL_NO_SYSPARAM');
2793: FND_MSG_PUB.add;
2794: END IF;

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

2802: CLOSE offer_type_csr;
2803: END IF;
2804:
2805: IF OZF_DEBUG_LOW_ON THEN
2806: OZF_Utility_PVT.debug_message('SYSPARAM: Post to GL is ' || l_post_to_gl);
2807: OZF_Utility_PVT.debug_message('SYSPARAM: Post to Offinvoice is ' || l_off_inv_gl);
2808: END IF;
2809:
2810: -- check if event type is off_invoice. create gl entries only when system

Line 2807: OZF_Utility_PVT.debug_message('SYSPARAM: Post to Offinvoice is ' || l_off_inv_gl);

2803: END IF;
2804:
2805: IF OZF_DEBUG_LOW_ON THEN
2806: OZF_Utility_PVT.debug_message('SYSPARAM: Post to GL is ' || l_post_to_gl);
2807: OZF_Utility_PVT.debug_message('SYSPARAM: Post to Offinvoice is ' || l_off_inv_gl);
2808: END IF;
2809:
2810: -- check if event type is off_invoice. create gl entries only when system
2811: -- parameters requires so

Line 2815: OZF_Utility_PVT.debug_message('GL posting for Off Invoice is not required when gl_acct_for_offinv_flag is not checked.');

2811: -- parameters requires so
2812: IF p_gl_rec.event_type_code = 'INVOICE_DISCOUNT' AND l_off_inv_gl = 'F' THEN --ninarasi fix for bug 14210080
2813: l_post_to_gl := 'F';
2814: IF OZF_DEBUG_LOW_ON THEN
2815: OZF_Utility_PVT.debug_message('GL posting for Off Invoice is not required when gl_acct_for_offinv_flag is not checked.');
2816: END IF;
2817: OZF_Utility_PVT.write_conc_log('GL posting for Off Invoice is not required when gl_acct_for_offinv_flag is not checked.');
2818: END IF;
2819:

Line 2817: OZF_Utility_PVT.write_conc_log('GL posting for Off Invoice is not required when gl_acct_for_offinv_flag is not checked.');

2813: l_post_to_gl := 'F';
2814: IF OZF_DEBUG_LOW_ON THEN
2815: OZF_Utility_PVT.debug_message('GL posting for Off Invoice is not required when gl_acct_for_offinv_flag is not checked.');
2816: END IF;
2817: OZF_Utility_PVT.write_conc_log('GL posting for Off Invoice is not required when gl_acct_for_offinv_flag is not checked.');
2818: END IF;
2819:
2820: --//Bugfix 10037158
2821: IF UPPER(p_gl_rec.source_table) = 'OZF_FUNDS_UTILIZED_ALL_B' AND l_offer_type = 'TERMS' THEN

Line 2824: OZF_Utility_PVT.debug_message('GL posting for Terms Upgrade Offer is not required.');

2820: --//Bugfix 10037158
2821: IF UPPER(p_gl_rec.source_table) = 'OZF_FUNDS_UTILIZED_ALL_B' AND l_offer_type = 'TERMS' THEN
2822: l_post_to_gl := 'F';
2823: IF OZF_DEBUG_LOW_ON THEN
2824: OZF_Utility_PVT.debug_message('GL posting for Terms Upgrade Offer is not required.');
2825: END IF;
2826: END IF;
2827:
2828: -- Fix for Bug 13596344

Line 2837: OZF_Utility_PVT.write_conc_log('GL Posting for $0 accruals is not required.');

2833: --ninarasi fix for bug 13054588
2834: IF l_post_to_gl <> 'F' AND l_utiz_amount = 0 THEN
2835: l_post_to_gl := 'F';
2836: IF OZF_DEBUG_LOW_ON THEN
2837: OZF_Utility_PVT.write_conc_log('GL Posting for $0 accruals is not required.');
2838: END IF;
2839: END IF;
2840:
2841:

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

2849:
2850: IF l_asso_amount = 0 THEN
2851: l_post_to_gl := 'F';
2852: IF OZF_DEBUG_LOW_ON THEN
2853: OZF_Utility_PVT.debug_message('Claim has no earnings associated');
2854: END IF;
2855: END IF;
2856: END IF;
2857: */

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

2860: --//ER#9382547 ChRM-SLA Uptake
2861: -- Here we check the post to General ledger flag from system parameter.
2862: -- If it us cheked and based on the source table we trigger SLA event and
2863: -- create the extract table for accrual and claim settlement
2864: OZF_Utility_PVT.debug_message('SYSPARAM: Post to GL is ' || l_post_to_gl);
2865: OZF_Utility_PVT.debug_message('Source Table : ' || p_gl_rec.source_table);
2866: IF l_post_to_gl = 'T' THEN
2867: IF UPPER(p_gl_rec.source_table) = 'OZF_FUNDS_UTILIZED_ALL_B' THEN
2868:

Line 2865: OZF_Utility_PVT.debug_message('Source Table : ' || p_gl_rec.source_table);

2861: -- Here we check the post to General ledger flag from system parameter.
2862: -- If it us cheked and based on the source table we trigger SLA event and
2863: -- create the extract table for accrual and claim settlement
2864: OZF_Utility_PVT.debug_message('SYSPARAM: Post to GL is ' || l_post_to_gl);
2865: OZF_Utility_PVT.debug_message('Source Table : ' || p_gl_rec.source_table);
2866: IF l_post_to_gl = 'T' THEN
2867: IF UPPER(p_gl_rec.source_table) = 'OZF_FUNDS_UTILIZED_ALL_B' THEN
2868:
2869: OZF_Utility_PVT.write_conc_log('Before Calling Create_SLA_Accrual_Extract');

Line 2869: OZF_Utility_PVT.write_conc_log('Before Calling Create_SLA_Accrual_Extract');

2865: OZF_Utility_PVT.debug_message('Source Table : ' || p_gl_rec.source_table);
2866: IF l_post_to_gl = 'T' THEN
2867: IF UPPER(p_gl_rec.source_table) = 'OZF_FUNDS_UTILIZED_ALL_B' THEN
2868:
2869: OZF_Utility_PVT.write_conc_log('Before Calling Create_SLA_Accrual_Extract');
2870: Create_SLA_Accrual_Extract (
2871: p_api_version => 1.0
2872: ,p_init_msg_list => FND_API.G_FALSE
2873: ,p_commit => FND_API.G_FALSE

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

2983: -- Create account event lines
2984: FOR i in 1..l_AE_LINE_Tbl.count LOOP
2985: l_AE_LINE_Tbl(i).ae_header_id := l_ae_header_id;
2986: IF OZF_DEBUG_HIGH_ON THEN
2987: OZF_UTILITY_PVT.debug_message('Line Number before calling api: ' ||
2988: l_ae_line_tbl(i).ae_line_number);
2989: END IF;
2990: END LOOP;
2991:

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

3008:
3009: END IF; -- if l_acctng_entries = 'T'
3010:
3011: IF OZF_DEBUG_LOW_ON THEN
3012: OZF_Utility_PVT.debug_message('Accounting event: id = '||l_accounting_event_id);
3013: END IF;
3014: */
3015: --//End Skipping Existing code for GL Interfacing
3016:

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

3200: -- Create account event lines
3201: FOR i in 1..l_AE_LINE_Tbl.count LOOP
3202: l_AE_LINE_Tbl(i).ae_header_id := l_ae_header_id;
3203: IF OZF_DEBUG_HIGH_ON THEN
3204: OZF_UTILITY_PVT.debug_message('Line Number before calling api: ' ||
3205: l_ae_line_tbl(i).ae_line_number);
3206: END IF;
3207: END LOOP;
3208:

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

3462: -- Initialize API return status to sucess
3463: x_return_status := FND_API.G_RET_STS_SUCCESS;
3464:
3465: IF OZF_DEBUG_LOW_ON THEN
3466: OZF_Utility_PVT.debug_message('--------- Revert_GL_Entry ----------');
3467: OZF_Utility_PVT.debug_message('claim_id : '||p_claim_id);
3468: END IF;
3469:
3470: OPEN get_accounting_event_csr( p_claim_id );

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

3463: x_return_status := FND_API.G_RET_STS_SUCCESS;
3464:
3465: IF OZF_DEBUG_LOW_ON THEN
3466: OZF_Utility_PVT.debug_message('--------- Revert_GL_Entry ----------');
3467: OZF_Utility_PVT.debug_message('claim_id : '||p_claim_id);
3468: END IF;
3469:
3470: OPEN get_accounting_event_csr( p_claim_id );
3471: FETCH get_accounting_event_csr INTO l_accounting_event_id

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

3480: CLOSE get_accounting_event_csr;
3481:
3482: IF l_accounting_event_id IS NULL OR l_accounting_event_id = FND_API.G_MISS_NUM THEN
3483: IF OZF_DEBUG_LOW_ON THEN
3484: OZF_Utility_PVT.debug_message('There is no accounting event for the source. Return to the caller.');
3485: END IF;
3486:
3487: RETURN;
3488: END IF;

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

3487: RETURN;
3488: END IF;
3489:
3490: IF OZF_DEBUG_LOW_ON THEN
3491: OZF_Utility_PVT.debug_message('Found matching event id : '||l_accounting_event_id);
3492: END IF;
3493:
3494: OPEN get_ae_header_csr( l_accounting_event_id );
3495: FETCH get_ae_header_csr INTO l_ae_header_id

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

3504: , l_aeh_object_version_num;
3505: CLOSE get_ae_header_csr;
3506:
3507: IF OZF_DEBUG_LOW_ON THEN
3508: OZF_Utility_PVT.debug_message('Found matching header id : '||l_ae_header_id);
3509: END IF;
3510:
3511: IF l_gl_transfer_yn = 'Y' THEN
3512: -- Create reverse entries in the SLA

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

3510:
3511: IF l_gl_transfer_yn = 'Y' THEN
3512: -- Create reverse entries in the SLA
3513: IF OZF_DEBUG_LOW_ON THEN
3514: OZF_Utility_PVT.debug_message('Transferred to GL, create reverse entries');
3515: END IF;
3516:
3517: -- First create accounting event for the reversal event
3518: /*OZF_ACCTNG_EVENTS_PVT.Create_Acctng_Events(

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

3533: END IF;
3534:
3535:
3536: IF OZF_DEBUG_LOW_ON THEN
3537: OZF_Utility_PVT.debug_message('Created new accounting event');
3538: END IF;
3539:
3540: -- Create a new header for reversal entries
3541: l_ae_header_rec.gl_transfer_flag := 'N';

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

3573: END IF;
3574:
3575:
3576: IF OZF_DEBUG_LOW_ON THEN
3577: OZF_Utility_PVT.debug_message('Created new accounting header');
3578: END IF;
3579:
3580: -- Create new lines for the reverse entries, by switching credit/debit amounts
3581: k := 1;

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

3650: END IF;
3651:
3652:
3653: IF OZF_DEBUG_LOW_ON THEN
3654: OZF_Utility_PVT.debug_message('Created new accounting lines with reversed amounts');
3655: END IF;
3656:
3657: -- Finally, mark original header as reversed
3658: UPDATE ozf_ae_headers_all

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

3660: WHERE ae_header_id = l_ae_header_id;
3661: ELSE
3662: -- Delete SLA entries not transferred to GL
3663: IF OZF_DEBUG_LOW_ON THEN
3664: OZF_Utility_PVT.debug_message('Not transferred to GL, delete SLA entries');
3665: END IF;
3666: --//Bugfix :7297267
3667: OPEN get_ae_lines_csr( l_ae_header_id );
3668: LOOP

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

3669: FETCH get_ae_lines_csr INTO l_ae_line_id, l_ael_object_version_num;
3670: EXIT WHEN get_ae_lines_csr%notfound;
3671:
3672: IF OZF_DEBUG_HIGH_ON THEN
3673: OZF_UTILITY_PVT.debug_message('Delting SLA line, line_id:' || l_ae_line_id);
3674: END IF;
3675:
3676: -- Delete SLA lines not transferred
3677: /*OZF_AE_LINE_PVT.Delete_Ae_Line(

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

3694: END LOOP;
3695: CLOSE get_ae_lines_csr;
3696:
3697: IF OZF_DEBUG_LOW_ON THEN
3698: OZF_Utility_PVT.debug_message('Deleted lines');
3699: END IF;
3700:
3701: -- Delete SLA header not transferred
3702: /*OZF_AE_HEADER_PVT.Delete_Ae_Header(

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

3717: END IF;
3718:
3719:
3720: IF OZF_DEBUG_LOW_ON THEN
3721: OZF_Utility_PVT.debug_message('Deleted header');
3722: END IF;
3723:
3724: -- Delete SLA accounting event not transferred
3725: /*OZF_ACCTNG_EVENTS_PVT.Delete_Acctng_Events(

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

3740: END IF;
3741:
3742:
3743: IF OZF_DEBUG_LOW_ON THEN
3744: OZF_Utility_PVT.debug_message('Deleted header');
3745: OZF_Utility_PVT.debug_message('Accounting entries successfully reverted.');
3746: END IF;
3747:
3748: END IF;

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

3741:
3742:
3743: IF OZF_DEBUG_LOW_ON THEN
3744: OZF_Utility_PVT.debug_message('Deleted header');
3745: OZF_Utility_PVT.debug_message('Accounting entries successfully reverted.');
3746: END IF;
3747:
3748: END IF;
3749:

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

3867: -- Initialize API return status to sucess
3868: x_return_status := FND_API.G_RET_STS_SUCCESS;
3869:
3870: IF OZF_DEBUG_LOW_ON THEN
3871: OZF_Utility_PVT.debug_message('--------- Post_Accrual_To_GL ----------');
3872: OZF_Utility_PVT.debug_message('utilization_id : '||p_utilization_id);
3873: OZF_Utility_PVT.debug_message('utilization_type : '|| p_event_type_code);
3874: OZF_Utility_PVT.debug_message('debit_cc_id : '||p_dr_code_combination_id);
3875: OZF_Utility_PVT.debug_message('credit_cc_id : '||p_cr_code_combination_id);

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

3868: x_return_status := FND_API.G_RET_STS_SUCCESS;
3869:
3870: IF OZF_DEBUG_LOW_ON THEN
3871: OZF_Utility_PVT.debug_message('--------- Post_Accrual_To_GL ----------');
3872: OZF_Utility_PVT.debug_message('utilization_id : '||p_utilization_id);
3873: OZF_Utility_PVT.debug_message('utilization_type : '|| p_event_type_code);
3874: OZF_Utility_PVT.debug_message('debit_cc_id : '||p_dr_code_combination_id);
3875: OZF_Utility_PVT.debug_message('credit_cc_id : '||p_cr_code_combination_id);
3876: END IF;

Line 3873: OZF_Utility_PVT.debug_message('utilization_type : '|| p_event_type_code);

3869:
3870: IF OZF_DEBUG_LOW_ON THEN
3871: OZF_Utility_PVT.debug_message('--------- Post_Accrual_To_GL ----------');
3872: OZF_Utility_PVT.debug_message('utilization_id : '||p_utilization_id);
3873: OZF_Utility_PVT.debug_message('utilization_type : '|| p_event_type_code);
3874: OZF_Utility_PVT.debug_message('debit_cc_id : '||p_dr_code_combination_id);
3875: OZF_Utility_PVT.debug_message('credit_cc_id : '||p_cr_code_combination_id);
3876: END IF;
3877:

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

3870: IF OZF_DEBUG_LOW_ON THEN
3871: OZF_Utility_PVT.debug_message('--------- Post_Accrual_To_GL ----------');
3872: OZF_Utility_PVT.debug_message('utilization_id : '||p_utilization_id);
3873: OZF_Utility_PVT.debug_message('utilization_type : '|| p_event_type_code);
3874: OZF_Utility_PVT.debug_message('debit_cc_id : '||p_dr_code_combination_id);
3875: OZF_Utility_PVT.debug_message('credit_cc_id : '||p_cr_code_combination_id);
3876: END IF;
3877:
3878: -- Get the Skip Account Generator Flaf

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

3871: OZF_Utility_PVT.debug_message('--------- Post_Accrual_To_GL ----------');
3872: OZF_Utility_PVT.debug_message('utilization_id : '||p_utilization_id);
3873: OZF_Utility_PVT.debug_message('utilization_type : '|| p_event_type_code);
3874: OZF_Utility_PVT.debug_message('debit_cc_id : '||p_dr_code_combination_id);
3875: OZF_Utility_PVT.debug_message('credit_cc_id : '||p_cr_code_combination_id);
3876: END IF;
3877:
3878: -- Get the Skip Account Generator Flaf
3879: --ER 13069257

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

4033: -- Initialize API return status to sucess
4034: x_return_status := FND_API.G_RET_STS_SUCCESS;
4035:
4036: IF OZF_DEBUG_LOW_ON THEN
4037: OZF_Utility_PVT.debug_message('--------- Post_Claim_To_GL ----------');
4038: OZF_Utility_PVT.debug_message('claim_id : '||p_claim_id);
4039: OZF_Utility_PVT.debug_message('settlement method : '||p_settlement_method);
4040: END IF;
4041:

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

4034: x_return_status := FND_API.G_RET_STS_SUCCESS;
4035:
4036: IF OZF_DEBUG_LOW_ON THEN
4037: OZF_Utility_PVT.debug_message('--------- Post_Claim_To_GL ----------');
4038: OZF_Utility_PVT.debug_message('claim_id : '||p_claim_id);
4039: OZF_Utility_PVT.debug_message('settlement method : '||p_settlement_method);
4040: END IF;
4041:
4042: OPEN taxfor_csr(p_claim_id);

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

4035:
4036: IF OZF_DEBUG_LOW_ON THEN
4037: OZF_Utility_PVT.debug_message('--------- Post_Claim_To_GL ----------');
4038: OZF_Utility_PVT.debug_message('claim_id : '||p_claim_id);
4039: OZF_Utility_PVT.debug_message('settlement method : '||p_settlement_method);
4040: END IF;
4041:
4042: OPEN taxfor_csr(p_claim_id);
4043: FETCH taxfor_csr INTO l_taxfor;