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.OKL_QA_DATA_INTEGRITY dependencies on FND_LOG

Line 1127: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'i='||i || '->kle_id='|| p_table(i).kle_id);

1123: NULL;
1124: FOR i IN p_table.first..p_table.last
1125: LOOP
1126: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1127: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'i='||i || '->kle_id='|| p_table(i).kle_id);
1128: END IF;
1129: FOR j IN p_table(i).l_payment_details.first..p_table(i).l_payment_details.last
1130: LOOP
1131: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 1132: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-->j=' || j );

1128: END IF;
1129: FOR j IN p_table(i).l_payment_details.first..p_table(i).l_payment_details.last
1130: LOOP
1131: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1132: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-->j=' || j );
1133: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'------>start_date=' || p_table(i).l_payment_details(j).start_date);
1134: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'------>number_of_periods=' || p_table(i).l_payment_details(j).number_of_periods);
1135: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'------>stub_days=' || p_table(i).l_payment_details(j).stub_days);
1136: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'------>stub_amount=' || p_table(i).l_payment_details(j).stub_amount);

Line 1133: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'------>start_date=' || p_table(i).l_payment_details(j).start_date);

1129: FOR j IN p_table(i).l_payment_details.first..p_table(i).l_payment_details.last
1130: LOOP
1131: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1132: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-->j=' || j );
1133: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'------>start_date=' || p_table(i).l_payment_details(j).start_date);
1134: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'------>number_of_periods=' || p_table(i).l_payment_details(j).number_of_periods);
1135: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'------>stub_days=' || p_table(i).l_payment_details(j).stub_days);
1136: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'------>stub_amount=' || p_table(i).l_payment_details(j).stub_amount);
1137: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'------>advance_or_arrears=' || p_table(i).l_payment_details(j).advance_or_arrears);

Line 1134: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'------>number_of_periods=' || p_table(i).l_payment_details(j).number_of_periods);

1130: LOOP
1131: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1132: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-->j=' || j );
1133: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'------>start_date=' || p_table(i).l_payment_details(j).start_date);
1134: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'------>number_of_periods=' || p_table(i).l_payment_details(j).number_of_periods);
1135: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'------>stub_days=' || p_table(i).l_payment_details(j).stub_days);
1136: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'------>stub_amount=' || p_table(i).l_payment_details(j).stub_amount);
1137: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'------>advance_or_arrears=' || p_table(i).l_payment_details(j).advance_or_arrears);
1138: END IF;

Line 1135: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'------>stub_days=' || p_table(i).l_payment_details(j).stub_days);

1131: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1132: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-->j=' || j );
1133: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'------>start_date=' || p_table(i).l_payment_details(j).start_date);
1134: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'------>number_of_periods=' || p_table(i).l_payment_details(j).number_of_periods);
1135: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'------>stub_days=' || p_table(i).l_payment_details(j).stub_days);
1136: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'------>stub_amount=' || p_table(i).l_payment_details(j).stub_amount);
1137: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'------>advance_or_arrears=' || p_table(i).l_payment_details(j).advance_or_arrears);
1138: END IF;
1139: END LOOP;

Line 1136: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'------>stub_amount=' || p_table(i).l_payment_details(j).stub_amount);

1132: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-->j=' || j );
1133: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'------>start_date=' || p_table(i).l_payment_details(j).start_date);
1134: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'------>number_of_periods=' || p_table(i).l_payment_details(j).number_of_periods);
1135: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'------>stub_days=' || p_table(i).l_payment_details(j).stub_days);
1136: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'------>stub_amount=' || p_table(i).l_payment_details(j).stub_amount);
1137: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'------>advance_or_arrears=' || p_table(i).l_payment_details(j).advance_or_arrears);
1138: END IF;
1139: END LOOP;
1140: END LOOP;

Line 1137: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'------>advance_or_arrears=' || p_table(i).l_payment_details(j).advance_or_arrears);

1133: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'------>start_date=' || p_table(i).l_payment_details(j).start_date);
1134: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'------>number_of_periods=' || p_table(i).l_payment_details(j).number_of_periods);
1135: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'------>stub_days=' || p_table(i).l_payment_details(j).stub_days);
1136: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'------>stub_amount=' || p_table(i).l_payment_details(j).stub_amount);
1137: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'------>advance_or_arrears=' || p_table(i).l_payment_details(j).advance_or_arrears);
1138: END IF;
1139: END LOOP;
1140: END LOOP;
1141: END;

Line 1150: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'i='||i || '->kle_id='|| p_table(i).kle_id);

1146: IF (p_table.COUNT > 0) THEN
1147: FOR i IN p_table.first..p_table.last
1148: LOOP
1149: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1150: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'i='||i || '->kle_id='|| p_table(i).kle_id);
1151: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'start_date=' || p_table(i).start_date);
1152: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'number_of_periods=' || p_table(i).number_of_periods);
1153: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'stub_days=' || p_table(i).stub_days);
1154: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'stub_amount=' || p_table(i).stub_amount);

Line 1151: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'start_date=' || p_table(i).start_date);

1147: FOR i IN p_table.first..p_table.last
1148: LOOP
1149: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1150: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'i='||i || '->kle_id='|| p_table(i).kle_id);
1151: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'start_date=' || p_table(i).start_date);
1152: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'number_of_periods=' || p_table(i).number_of_periods);
1153: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'stub_days=' || p_table(i).stub_days);
1154: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'stub_amount=' || p_table(i).stub_amount);
1155: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'advance_or_arrears=' || p_table(i).advance_or_arrears);

Line 1152: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'number_of_periods=' || p_table(i).number_of_periods);

1148: LOOP
1149: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1150: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'i='||i || '->kle_id='|| p_table(i).kle_id);
1151: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'start_date=' || p_table(i).start_date);
1152: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'number_of_periods=' || p_table(i).number_of_periods);
1153: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'stub_days=' || p_table(i).stub_days);
1154: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'stub_amount=' || p_table(i).stub_amount);
1155: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'advance_or_arrears=' || p_table(i).advance_or_arrears);
1156: END IF;

Line 1153: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'stub_days=' || p_table(i).stub_days);

1149: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1150: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'i='||i || '->kle_id='|| p_table(i).kle_id);
1151: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'start_date=' || p_table(i).start_date);
1152: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'number_of_periods=' || p_table(i).number_of_periods);
1153: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'stub_days=' || p_table(i).stub_days);
1154: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'stub_amount=' || p_table(i).stub_amount);
1155: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'advance_or_arrears=' || p_table(i).advance_or_arrears);
1156: END IF;
1157: END LOOP;

Line 1154: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'stub_amount=' || p_table(i).stub_amount);

1150: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'i='||i || '->kle_id='|| p_table(i).kle_id);
1151: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'start_date=' || p_table(i).start_date);
1152: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'number_of_periods=' || p_table(i).number_of_periods);
1153: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'stub_days=' || p_table(i).stub_days);
1154: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'stub_amount=' || p_table(i).stub_amount);
1155: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'advance_or_arrears=' || p_table(i).advance_or_arrears);
1156: END IF;
1157: END LOOP;
1158: END IF;

Line 1155: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'advance_or_arrears=' || p_table(i).advance_or_arrears);

1151: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'start_date=' || p_table(i).start_date);
1152: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'number_of_periods=' || p_table(i).number_of_periods);
1153: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'stub_days=' || p_table(i).stub_days);
1154: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'stub_amount=' || p_table(i).stub_amount);
1155: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'advance_or_arrears=' || p_table(i).advance_or_arrears);
1156: END IF;
1157: END LOOP;
1158: END IF;
1159: END;

Line 1168: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_payment_table2.count=' || l_payment_table2.COUNT);

1164: OPEN l_payment_lines_csr;
1165: LOOP
1166: FETCH l_payment_lines_csr BULK COLLECT INTO l_payment_table2 LIMIT l_limit;
1167: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1168: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_payment_table2.count=' || l_payment_table2.COUNT);
1169: END IF;
1170: IF (l_payment_table2.COUNT > 0) THEN
1171: FOR i IN l_payment_table2.FIRST..l_payment_table2.LAST
1172: LOOP

Line 1182: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_payment_table_counter=' || l_payment_table_counter);

1178: END IF;
1179: END LOOP;
1180: CLOSE l_payment_lines_csr;
1181: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1182: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_payment_table_counter=' || l_payment_table_counter);
1183: END IF;
1184: print_payment_orig_table(l_payment_table);
1185:
1186: IF (l_payment_table.COUNT > 0) THEN

Line 1220: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Now Printing l_pmnt_tab...');

1216: END IF;
1217: END LOOP;
1218:
1219: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1220: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Now Printing l_pmnt_tab...');
1221: END IF;
1222: print_tab(l_pmnt_tab);
1223:
1224: -- Check only if there are at least two asset lines

Line 1229: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_num_schedules=' || l_num_schedules);

1225: IF (l_pmnt_tab.COUNT > 1) THEN
1226:
1227: l_num_schedules := l_pmnt_tab(1).l_payment_details.COUNT;
1228: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1229: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_num_schedules=' || l_num_schedules);
1230: END IF;
1231: FOR i IN 2..l_pmnt_tab.LAST
1232: LOOP
1233: IF (l_num_schedules <> l_pmnt_tab(i).l_payment_details.COUNT) THEN

Line 1613: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

1609: p_kle_id IN NUMBER) RETURN NUMBER IS
1610: l_tot_amount NUMBER := 0;
1611: BEGIN
1612: IF (G_DEBUG_ENABLED = 'Y') THEN
1613: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
1614: END IF;
1615: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1616: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1617: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In tot_unsched_prin_payment: 0...');

Line 1617: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In tot_unsched_prin_payment: 0...');

1613: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
1614: END IF;
1615: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1616: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1617: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In tot_unsched_prin_payment: 0...');
1618: END IF;
1619: --print('In tot_unsched_prin_payment: p_chr_id= ' || p_chr_id || ' p_kle_id=' || p_kle_id);
1620: FOR l_pmnt_strm_check_rec2 IN l_pmnt_strm_check2('LALEVL','LASLH','UNSCHEDULED_PRINCIPAL_PAYMENT', p_chr_id)
1621: LOOP

Line 1647: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In Check Payment Type...');

1643: -- initialize return status
1644: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1645:
1646: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1647: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In Check Payment Type...');
1648: END IF;
1649:
1650: Okl_K_Rate_Params_Pvt.get_product(
1651: p_api_version => 1,

Line 1660: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In Check Payment Type:After get_product...x_return_status='||x_return_status);

1656: p_khr_id => p_chr_id,
1657: x_pdt_parameter_rec => x_pdt_parameter_rec);
1658:
1659: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1660: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In Check Payment Type:After get_product...x_return_status='||x_return_status);
1661: END IF;
1662: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1663: Okc_Api.set_message(
1664: p_app_name => G_APP_NAME,

Line 1684: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In Check Payment Type:Before l_pmnt_strm_hdr_rec...x_return_status='||x_return_status);

1680: l_contract_end_date := l_cnt_start_date.end_date;
1681: END LOOP;
1682:
1683: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1684: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In Check Payment Type:Before l_pmnt_strm_hdr_rec...x_return_status='||x_return_status);
1685: END IF;
1686: FOR l_pmnt_strm_hdr_rec IN l_pmnt_strm_hdr ( 'LALEVL', 'LASLH', p_chr_id )
1687: LOOP
1688:

Line 1700: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Before assigning l_rent_start_date....');

1696: --Added by bkatraga for bug 14111538
1697: l_stream_type_name := l_pmnt_strm_hdr_rec.name;
1698: END IF;
1699: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1700: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Before assigning l_rent_start_date....');
1701: END IF;
1702: l_rent_start_date := Fnd_Date.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);
1703: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1704: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_rent_start_date=' || l_rent_start_date);

Line 1704: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_rent_start_date=' || l_rent_start_date);

1700: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Before assigning l_rent_start_date....');
1701: END IF;
1702: l_rent_start_date := Fnd_Date.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);
1703: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1704: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_rent_start_date=' || l_rent_start_date);
1705: END IF;
1706: l_rent_periods := l_pmnt_lns_in_hdr_rec.rule_information3;
1707: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1708: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_rent_periods=' || l_rent_periods);

Line 1708: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_rent_periods=' || l_rent_periods);

1704: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_rent_start_date=' || l_rent_start_date);
1705: END IF;
1706: l_rent_periods := l_pmnt_lns_in_hdr_rec.rule_information3;
1707: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1708: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_rent_periods=' || l_rent_periods);
1709: END IF;
1710:
1711: --Added by bkatraga for bug 13478101
1712: IF(l_pmnt_lns_in_hdr_rec.rule_information6 = 0 OR l_pmnt_lns_in_hdr_rec.rule_information8 = 0) THEN

Line 1728: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_principal_start_date=' || l_principal_start_date);

1724: l_stream_type_name := l_pmnt_strm_hdr_rec.name;
1725: END IF;
1726: l_principal_start_date := Fnd_Date.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);
1727: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1728: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_principal_start_date=' || l_principal_start_date);
1729: END IF;
1730: l_principal_periods := l_pmnt_lns_in_hdr_rec.rule_information3;
1731: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1732: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_principal_periods=' || l_principal_periods);

Line 1732: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_principal_periods=' || l_principal_periods);

1728: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_principal_start_date=' || l_principal_start_date);
1729: END IF;
1730: l_principal_periods := l_pmnt_lns_in_hdr_rec.rule_information3;
1731: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1732: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_principal_periods=' || l_principal_periods);
1733: END IF;
1734: ELSIF ( l_pmnt_strm_hdr_rec.stream_type_purpose = 'LOAN_PAYMENT' ) THEN
1735: l_loan_start_date := Fnd_Date.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);
1736: l_loan_periods := l_hdrrl_rec.rule_information3;

Line 1740: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Before assigning l_variable_start_date....');

1736: l_loan_periods := l_hdrrl_rec.rule_information3;
1737: ELSIF ( l_pmnt_strm_hdr_rec.stream_type_purpose = 'VARIABLE_INTEREST_SCHEDULE' ) THEN
1738: l_var_int_schedule_defined := TRUE;
1739: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1740: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Before assigning l_variable_start_date....');
1741: END IF;
1742:
1743: --Added IF clause by bkatraga for bug 13478101
1744: IF(l_variable_start_date IS NULL) THEN

Line 1749: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_variable_start_date = ' || l_variable_start_date);

1745: l_variable_start_date := Fnd_Date.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);
1746: END IF;
1747:
1748: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1749: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_variable_start_date = ' || l_variable_start_date);
1750: END IF;
1751: l_variable_periods := l_pmnt_lns_in_hdr_rec.rule_information3;
1752: IF (NVL(l_pmnt_lns_in_hdr_rec.rule_information10,'N') = 'N') THEN
1753: l_payment_in_advance := TRUE;

Line 1854: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In Check Payment Type:Before first check...x_return_status='||x_return_status);

1850: END IF;
1851: --end bkatraga
1852:
1853: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1854: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In Check Payment Type:Before first check...x_return_status='||x_return_status);
1855: END IF;
1856: -- Both RENT and PRINCIPAL_PAYMENT not allowed
1857: IF (l_rent_payment_found AND l_principal_payment_found) THEN
1858: Okl_Api.set_message(

Line 1864: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In Check Payment Type:Before second check...x_return_status='||x_return_status);

1860: p_msg_name => 'OKL_LA_VAR_RATE_PAYMENT');
1861: x_return_status := Okl_Api.G_RET_STS_ERROR;
1862: END IF;
1863: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1864: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In Check Payment Type:Before second check...x_return_status='||x_return_status);
1865: END IF;
1866: -- If payment in advance, check rate delays > print lead days
1867: IF (l_payment_in_advance) THEN
1868: NULL; -- Todo: AKP

Line 1898: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In Check Payment Type:Before rate_delay_csr...');

1894: x_return_status := Okl_Api.G_RET_STS_ERROR;
1895: END IF;
1896: END IF;
1897: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1898: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In Check Payment Type:Before rate_delay_csr...');
1899: END IF;
1900: -- get rate delay (rule group/rule)
1901: OPEN rate_delay_csr(p_chr_id);
1902: FETCH rate_delay_csr INTO l_rate_delay;

Line 1906: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In Check Payment Type:Before print_lead_csr...');

1902: FETCH rate_delay_csr INTO l_rate_delay;
1903: CLOSE rate_delay_csr;
1904:
1905: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1906: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In Check Payment Type:Before print_lead_csr...');
1907: END IF;
1908: -- get cust print lead days
1909: OPEN cust_print_lead_days_csr(p_chr_id);
1910: FETCH cust_print_lead_days_csr INTO l_cust_print_lead_days;

Line 1940: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In Check Payment Type:Before third check...x_return_status='||x_return_status);

1936: END IF;
1937: -- udhenuko End bug#6786775
1938:
1939: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1940: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In Check Payment Type:Before third check...x_return_status='||x_return_status);
1941: END IF;
1942: -- If Principal payment is defined, check if base_rate defined
1943: IF (l_principal_payment_found) THEN
1944: --print('Yes, Principal payment found: Checking base rate...');

Line 1972: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In Check Payment Type:Before fourth check...x_return_status='||x_return_status);

1968: END IF;
1969: END IF;
1970:
1971: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1972: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In Check Payment Type:Before fourth check...x_return_status='||x_return_status);
1973: END IF;
1974: -- Bug 4674139
1975: -- Check if variable interest schedule is defined for LOAN FLOAT
1976: IF (l_deal_type = 'LOAN' AND

Line 1983: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Var Int Schedule Not Defined...');

1979: (l_deal_type = 'LOAN-REVOLVING' AND
1980: l_interest_calculation_basis = 'FLOAT' ) THEN
1981: IF NOT(l_var_int_schedule_defined) THEN
1982: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1983: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Var Int Schedule Not Defined...');
1984: END IF;
1985: Okl_Api.set_message(
1986: p_app_name => G_APP_NAME,
1987: p_msg_name => 'OKL_LA_VAR_SCHEDULED_ALLOWED');

Line 1991: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Var Int Schedule Defined...');

1987: p_msg_name => 'OKL_LA_VAR_SCHEDULED_ALLOWED');
1988: x_return_status := Okl_Api.G_RET_STS_ERROR;
1989: ELSE
1990: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1991: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Var Int Schedule Defined...');
1992: END IF;
1993: END IF;
1994: ELSE -- Bug 4742650 (Do not allow var int sched for other type of contracts)
1995: IF (l_var_int_schedule_defined) THEN

Line 2004: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In Check Payment Type:Before fifth check...x_return_status='||x_return_status);

2000: END IF;
2001: END IF;
2002:
2003: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2004: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In Check Payment Type:Before fifth check...x_return_status='||x_return_status);
2005: END IF;
2006: -- Bug 4886871
2007: -- Check if variable interest schedule is same as loan payment schedule
2008: /*

Line 2049: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_contract_start_date=' || l_contract_start_date);

2045: l_contract_start_date := l_cnt_start_date.start_date;
2046: END LOOP;
2047: */
2048: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2049: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_contract_start_date=' || l_contract_start_date);
2050: END IF;
2051: IF (l_variable_start_date <> l_contract_start_date) THEN
2052: OKL_API.set_message(
2053: p_app_name => G_APP_NAME,

Line 2060: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In Check Payment Type:Before sixth check...x_return_status='||x_return_status);

2056: END IF;
2057: END IF;
2058:
2059: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2060: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In Check Payment Type:Before sixth check...x_return_status='||x_return_status);
2061: END IF;
2062: -- Check same payment date for all assets (RENT currently)
2063: -- Commented this check from here and copied from check_variable_rate_old
2064: /*

Line 2228: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In Check Payment Type:Before seventh check...x_return_status='||x_return_status);

2224: /*IF (l_deal_type = 'LOAN' AND
2225: l_interest_calculation_basis = 'REAMORT') THEN */
2226:
2227: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2228: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In Check Payment Type:Before seventh check...x_return_status='||x_return_status);
2229: END IF;
2230: --FOR l_pmnt_strm_check_rec IN l_pmnt_strm_check('LALEVL','LASLH','PRINCIPAL_PAYMENT',p_chr_id)
2231: FOR l_pmnt_strm_check_rec IN l_pmnt_strm_check('LALEVL','LASLH','PRINCIPAL_PAYMENT', p_chr_id)
2232: LOOP

Line 2285: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_asset_number=' || l_asset_number || ' l_capital_amount=' || l_capital_amount);

2281: l_capitalize_down_payment_yn := r.capitalize_down_payment_yn;
2282: END LOOP;
2283:
2284: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2285: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_asset_number=' || l_asset_number || ' l_capital_amount=' || l_capital_amount);
2286: END IF;
2287: -- 5264170
2288: IF l_ste_code NOT IN ('CANCELLED','TERMINATED','HOLD','EXPIRED') THEN
2289: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 2290: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tot_principal_payment=' || l_tot_principal_payment);

2286: END IF;
2287: -- 5264170
2288: IF l_ste_code NOT IN ('CANCELLED','TERMINATED','HOLD','EXPIRED') THEN
2289: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2290: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tot_principal_payment=' || l_tot_principal_payment);
2291: END IF;
2292: -- Now get total unscheduled principal payment for this line, if any
2293: -- 4887014
2294: l_tot_unsched_prin_payment :=

Line 2298: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tot_unsched_prin_payment=' || l_tot_unsched_prin_payment);

2294: l_tot_unsched_prin_payment :=
2295: tot_unsched_prin_payment(l_return_status, -- 4907390
2296: p_chr_id, l_curr_cle_id);
2297: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2298: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tot_unsched_prin_payment=' || l_tot_unsched_prin_payment);
2299: END IF;
2300:
2301: -- gboomina Bug 6401848 - Start
2302: -- 4898747

Line 2314: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_net_subsidy_amount=' || l_net_subsidy_amount);

2310: p_accounting_method => 'NET',
2311: x_subsidy_amount => l_net_subsidy_amount);
2312:
2313: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2314: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_net_subsidy_amount=' || l_net_subsidy_amount);
2315: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_return_status=' || l_return_status);
2316: END IF;
2317: -- Fix for Bug 7131756
2318: l_non_cap_down_payment_amount := 0;

Line 2315: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_return_status=' || l_return_status);

2311: x_subsidy_amount => l_net_subsidy_amount);
2312:
2313: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2314: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_net_subsidy_amount=' || l_net_subsidy_amount);
2315: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_return_status=' || l_return_status);
2316: END IF;
2317: -- Fix for Bug 7131756
2318: l_non_cap_down_payment_amount := 0;
2319: IF (l_capitalize_down_payment_yn = 'N') THEN

Line 2343: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Before get_pricing_engine...x_return_status='||x_return_status);

2339:
2340: END LOOP;
2341:
2342: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2343: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Before get_pricing_engine...x_return_status='||x_return_status);
2344: END IF;
2345: Okl_Streams_Util.get_pricing_engine(p_khr_id => p_chr_id,
2346: x_pricing_engine => l_pricing_engine,
2347: x_return_status => l_return_status);

Line 2354: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In Check Payment Type:Before eighth check...x_return_status='||x_return_status);

2350: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2351: END IF;
2352:
2353: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2354: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In Check Payment Type:Before eighth check...x_return_status='||x_return_status);
2355: END IF;
2356: IF (l_deal_type IN ('LEASEOP', 'LEASEST', 'LEASEDF') ) AND
2357: (l_interest_Calculation_basis IN ('FIXED', 'REAMORT', 'FLOAT_FACTORS'))
2358: THEN

Line 2385: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In Check Payment Type:Before ninth check...x_return_status='||x_return_status);

2381: END IF;
2382: END IF;
2383:
2384: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2385: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In Check Payment Type:Before ninth check...x_return_status='||x_return_status);
2386: END IF;
2387: IF (((l_deal_type = 'LOAN') AND
2388: (l_interest_Calculation_basis IN
2389: ('FIXED', 'FLOAT', 'CATCHUP/CLEANUP'))) OR

Line 2432: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In Check Payment Type:Before tenth check...x_return_status='||x_return_status);

2428: /*END IF;*/
2429: END IF;
2430:
2431: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2432: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In Check Payment Type:Before tenth check...x_return_status='||x_return_status);
2433: END IF;
2434: IF ((l_deal_type = 'LOAN-REVONVING' ) AND
2435: (l_interest_Calculation_basis = 'FLOAT'))
2436: THEN

Line 2474: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Before exitting: x_return_status=' || x_return_status);

2470: END IF;
2471: END IF;
2472:
2473: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2474: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Before exitting: x_return_status=' || x_return_status);
2475: END IF;
2476:
2477: --Bug# 13002041: Moved this to check_variable_rate procedure
2478: /* IF x_return_status = Okl_Api.G_RET_STS_SUCCESS THEN

Line 2535: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

2531: l_return_status VARCHAR2(1);
2532:
2533: BEGIN
2534: IF (G_DEBUG_ENABLED = 'Y') THEN
2535: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
2536: END IF;
2537: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
2538:
2539: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 2540: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Before calling validate_k_rate_params...');

2536: END IF;
2537: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
2538:
2539: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2540: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Before calling validate_k_rate_params...');
2541: END IF;
2542: Okl_K_Rate_Params_Pvt.validate_k_rate_params(
2543: p_api_version => 1,
2544: p_init_msg_list => Okl_Api.G_FALSE,

Line 2552: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After validate_k_rate_params x_return_status=' || x_return_status);

2548: p_khr_id => p_chr_id,
2549: p_validate_flag => 'F');
2550:
2551: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2552: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After validate_k_rate_params x_return_status=' || x_return_status);
2553: END IF;
2554: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
2555: --RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2556: --RAISE OKL_API.G_EXCEPTION_HALT_VALIDATION;

Line 2565: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After check_payment_type l_return_status=' || l_return_status);

2561: check_payment_type(
2562: x_return_status => l_return_status,
2563: p_chr_id => p_chr_id);
2564: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2565: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After check_payment_type l_return_status=' || l_return_status);
2566: END IF;
2567:
2568: IF (l_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
2569: --RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 11608: l_module CONSTANT fnd_log_messages.MODULE%TYPE := 'okl.plsql.OKL_QA_DATA_INTEGRITY.CHECK_SUBSIDIES_ERRORS';

11604: lx_pool_status okl_subsidy_pools_b.decision_status_code%TYPE;
11605: lx_pool_balance okl_subsidy_pools_b.total_subsidy_amount%TYPE;
11606: lv_subsidy_amount okl_k_lines.subsidy_override_amount%TYPE;
11607: -- sjalasut, added local variables to support logging
11608: l_module CONSTANT fnd_log_messages.MODULE%TYPE := 'okl.plsql.OKL_QA_DATA_INTEGRITY.CHECK_SUBSIDIES_ERRORS';
11609: l_debug_enabled VARCHAR2(10);
11610: is_debug_statement_on BOOLEAN;
11611:
11612:

Line 11619: is_debug_statement_on := Okl_Debug_Pub.check_log_on(l_module,Fnd_Log.LEVEL_STATEMENT);

11615:
11616: -- check if debug is enabled
11617: l_debug_enabled := Okl_Debug_Pub.check_log_enabled;
11618: -- check for logging on STATEMENT level
11619: is_debug_statement_on := Okl_Debug_Pub.check_log_on(l_module,Fnd_Log.LEVEL_STATEMENT);
11620:
11621: Okl_Subsidy_Process_Pvt.is_contract_subsidized(
11622: p_api_version => 1.0,
11623: p_init_msg_list => p_init_msg_list,

Line 11706: Okl_Debug_Pub.log_debug(Fnd_Log.LEVEL_STATEMENT,

11702: ,x_sub_pool_curr_code => lx_sub_pool_curr_code);
11703: IF(lv_subsidy_pool_applicable_yn = 'Y')THEN
11704: -- write to log
11705: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
11706: Okl_Debug_Pub.log_debug(Fnd_Log.LEVEL_STATEMENT,
11707: l_module,
11708: 'subsidy '|| l_subsidy_id || ' is attached to subsidy pool '|| lx_subsidy_pool_id
11709: );
11710: END IF; -- end of NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on

Line 11770: Okl_Debug_Pub.log_debug(Fnd_Log.LEVEL_STATEMENT,

11766: ,x_msg_count => x_msg_count
11767: ,x_msg_data => x_msg_data);
11768: -- write to log
11769: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
11770: Okl_Debug_Pub.log_debug(Fnd_Log.LEVEL_STATEMENT,
11771: l_module,
11772: 'okl_asset_subsidy_pvt.is_balance_valid_after_add returned with '|| x_return_status||' x_msg_data '||x_msg_data
11773: );
11774: END IF; -- end of NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on