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 1145: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'i='||i || '->kle_id='|| p_table(i).kle_id);

1141: NULL;
1142: FOR i IN p_table.first..p_table.last
1143: LOOP
1144: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1145: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'i='||i || '->kle_id='|| p_table(i).kle_id);
1146: END IF;
1147: FOR j IN p_table(i).l_payment_details.first..p_table(i).l_payment_details.last
1148: LOOP
1149: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

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

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

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

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

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

1149: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1150: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-->j=' || j );
1151: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'------>start_date=' || p_table(i).l_payment_details(j).start_date);
1152: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'------>number_of_periods=' || p_table(i).l_payment_details(j).number_of_periods);
1153: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'------>stub_days=' || p_table(i).l_payment_details(j).stub_days);
1154: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'------>stub_amount=' || p_table(i).l_payment_details(j).stub_amount);
1155: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'------>advance_or_arrears=' || p_table(i).l_payment_details(j).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).l_payment_details(j).stub_amount);

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

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

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

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

1164: IF (p_table.COUNT > 0) THEN
1165: FOR i IN p_table.first..p_table.last
1166: LOOP
1167: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1168: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'i='||i || '->kle_id='|| p_table(i).kle_id);
1169: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'start_date=' || p_table(i).start_date);
1170: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'number_of_periods=' || p_table(i).number_of_periods);
1171: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'stub_days=' || p_table(i).stub_days);
1172: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'stub_amount=' || p_table(i).stub_amount);

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

1165: FOR i IN p_table.first..p_table.last
1166: LOOP
1167: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1168: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'i='||i || '->kle_id='|| p_table(i).kle_id);
1169: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'start_date=' || p_table(i).start_date);
1170: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'number_of_periods=' || p_table(i).number_of_periods);
1171: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'stub_days=' || p_table(i).stub_days);
1172: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'stub_amount=' || p_table(i).stub_amount);
1173: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'advance_or_arrears=' || p_table(i).advance_or_arrears);

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

1166: LOOP
1167: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1168: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'i='||i || '->kle_id='|| p_table(i).kle_id);
1169: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'start_date=' || p_table(i).start_date);
1170: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'number_of_periods=' || p_table(i).number_of_periods);
1171: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'stub_days=' || p_table(i).stub_days);
1172: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'stub_amount=' || p_table(i).stub_amount);
1173: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'advance_or_arrears=' || p_table(i).advance_or_arrears);
1174: END IF;

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

1167: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1168: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'i='||i || '->kle_id='|| p_table(i).kle_id);
1169: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'start_date=' || p_table(i).start_date);
1170: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'number_of_periods=' || p_table(i).number_of_periods);
1171: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'stub_days=' || p_table(i).stub_days);
1172: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'stub_amount=' || p_table(i).stub_amount);
1173: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'advance_or_arrears=' || p_table(i).advance_or_arrears);
1174: END IF;
1175: END LOOP;

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

1168: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'i='||i || '->kle_id='|| p_table(i).kle_id);
1169: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'start_date=' || p_table(i).start_date);
1170: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'number_of_periods=' || p_table(i).number_of_periods);
1171: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'stub_days=' || p_table(i).stub_days);
1172: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'stub_amount=' || p_table(i).stub_amount);
1173: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'advance_or_arrears=' || p_table(i).advance_or_arrears);
1174: END IF;
1175: END LOOP;
1176: END IF;

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

1169: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'start_date=' || p_table(i).start_date);
1170: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'number_of_periods=' || p_table(i).number_of_periods);
1171: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'stub_days=' || p_table(i).stub_days);
1172: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'stub_amount=' || p_table(i).stub_amount);
1173: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'advance_or_arrears=' || p_table(i).advance_or_arrears);
1174: END IF;
1175: END LOOP;
1176: END IF;
1177: END;

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

1182: OPEN l_payment_lines_csr;
1183: LOOP
1184: FETCH l_payment_lines_csr BULK COLLECT INTO l_payment_table2 LIMIT l_limit;
1185: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1186: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_payment_table2.count=' || l_payment_table2.COUNT);
1187: END IF;
1188: IF (l_payment_table2.COUNT > 0) THEN
1189: FOR i IN l_payment_table2.FIRST..l_payment_table2.LAST
1190: LOOP

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

1196: END IF;
1197: END LOOP;
1198: CLOSE l_payment_lines_csr;
1199: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1200: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_payment_table_counter=' || l_payment_table_counter);
1201: END IF;
1202: print_payment_orig_table(l_payment_table);
1203:
1204: IF (l_payment_table.COUNT > 0) THEN

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

1234: END IF;
1235: END LOOP;
1236:
1237: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1238: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Now Printing l_pmnt_tab...');
1239: END IF;
1240: print_tab(l_pmnt_tab);
1241:
1242: -- Check only if there are at least two asset lines

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

1243: IF (l_pmnt_tab.COUNT > 1) THEN
1244:
1245: l_num_schedules := l_pmnt_tab(1).l_payment_details.COUNT;
1246: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1247: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_num_schedules=' || l_num_schedules);
1248: END IF;
1249: FOR i IN 2..l_pmnt_tab.LAST
1250: LOOP
1251: IF (l_num_schedules <> l_pmnt_tab(i).l_payment_details.COUNT) THEN

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

1583: p_kle_id IN NUMBER) RETURN NUMBER IS
1584: l_tot_amount NUMBER := 0;
1585: BEGIN
1586: IF (G_DEBUG_ENABLED = 'Y') THEN
1587: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
1588: END IF;
1589: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1590: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1591: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In tot_unsched_prin_payment: 0...');

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

1587: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
1588: END IF;
1589: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1590: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1591: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In tot_unsched_prin_payment: 0...');
1592: END IF;
1593: --print('In tot_unsched_prin_payment: p_chr_id= ' || p_chr_id || ' p_kle_id=' || p_kle_id);
1594: FOR l_pmnt_strm_check_rec2 IN l_pmnt_strm_check2('LALEVL','LASLH','UNSCHEDULED_PRINCIPAL_PAYMENT', p_chr_id)
1595: LOOP

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

1617: -- initialize return status
1618: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1619:
1620: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1621: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In Check Payment Type...');
1622: END IF;
1623:
1624: Okl_K_Rate_Params_Pvt.get_product(
1625: p_api_version => 1,

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

1630: p_khr_id => p_chr_id,
1631: x_pdt_parameter_rec => x_pdt_parameter_rec);
1632:
1633: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1634: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In Check Payment Type:After get_product...x_return_status='||x_return_status);
1635: END IF;
1636: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
1637: Okc_Api.set_message(
1638: p_app_name => G_APP_NAME,

Line 1650: 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);

1646: l_interest_calculation_basis := x_pdt_parameter_rec.interest_calculation_basis;
1647: l_revenue_recognition_method := x_pdt_parameter_rec.revenue_recognition_method;
1648:
1649: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1650: 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);
1651: END IF;
1652: FOR l_pmnt_strm_hdr_rec IN l_pmnt_strm_hdr ( 'LALEVL', 'LASLH', p_chr_id )
1653: LOOP
1654:

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

1660: l_payment_in_advance := TRUE;
1661: l_rent_payment_in_advance := TRUE;
1662: END IF;
1663: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1664: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Before assigning l_rent_start_date....');
1665: END IF;
1666: l_rent_start_date := Fnd_Date.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);
1667: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1668: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_rent_start_date=' || l_rent_start_date);

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

1664: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Before assigning l_rent_start_date....');
1665: END IF;
1666: l_rent_start_date := Fnd_Date.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);
1667: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1668: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_rent_start_date=' || l_rent_start_date);
1669: END IF;
1670: l_rent_periods := l_pmnt_lns_in_hdr_rec.rule_information3;
1671: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1672: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_rent_periods=' || l_rent_periods);

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

1668: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_rent_start_date=' || l_rent_start_date);
1669: END IF;
1670: l_rent_periods := l_pmnt_lns_in_hdr_rec.rule_information3;
1671: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1672: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_rent_periods=' || l_rent_periods);
1673: END IF;
1674: ELSIF ( l_pmnt_strm_hdr_rec.stream_type_purpose = 'PRINCIPAL_PAYMENT' ) THEN
1675: l_principal_payment_found := TRUE;
1676: IF (NVL(l_pmnt_lns_in_hdr_rec.rule_information10,'N') = 'N') THEN

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

1678: l_prin_payment_in_advance := TRUE;
1679: END IF;
1680: l_principal_start_date := Fnd_Date.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);
1681: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1682: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_principal_start_date=' || l_principal_start_date);
1683: END IF;
1684: l_principal_periods := l_pmnt_lns_in_hdr_rec.rule_information3;
1685: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1686: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_principal_periods=' || l_principal_periods);

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

1682: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_principal_start_date=' || l_principal_start_date);
1683: END IF;
1684: l_principal_periods := l_pmnt_lns_in_hdr_rec.rule_information3;
1685: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1686: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_principal_periods=' || l_principal_periods);
1687: END IF;
1688: ELSIF ( l_pmnt_strm_hdr_rec.stream_type_purpose = 'LOAN_PAYMENT' ) THEN
1689: l_loan_start_date := Fnd_Date.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);
1690: l_loan_periods := l_hdrrl_rec.rule_information3;

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

1690: l_loan_periods := l_hdrrl_rec.rule_information3;
1691: ELSIF ( l_pmnt_strm_hdr_rec.stream_type_purpose = 'VARIABLE_INTEREST_SCHEDULE' ) THEN
1692: l_var_int_schedule_defined := TRUE;
1693: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1694: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Before assigning l_variable_start_date....');
1695: END IF;
1696: l_variable_start_date := Fnd_Date.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);
1697: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1698: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_variable_start_date = ' || l_variable_start_date);

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

1694: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Before assigning l_variable_start_date....');
1695: END IF;
1696: l_variable_start_date := Fnd_Date.canonical_to_date(l_pmnt_lns_in_hdr_rec.rule_information2);
1697: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1698: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_variable_start_date = ' || l_variable_start_date);
1699: END IF;
1700: l_variable_periods := l_pmnt_lns_in_hdr_rec.rule_information3;
1701: IF (NVL(l_pmnt_lns_in_hdr_rec.rule_information10,'N') = 'N') THEN
1702: l_payment_in_advance := TRUE;

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

1725: END LOOP;
1726: END LOOP;
1727:
1728: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1729: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In Check Payment Type:Before first check...x_return_status='||x_return_status);
1730: END IF;
1731: -- Both RENT and PRINCIPAL_PAYMENT not allowed
1732: IF (l_rent_payment_found AND l_principal_payment_found) THEN
1733: Okl_Api.set_message(

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

1735: p_msg_name => 'OKL_LA_VAR_RATE_PAYMENT');
1736: x_return_status := Okl_Api.G_RET_STS_ERROR;
1737: END IF;
1738: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1739: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In Check Payment Type:Before second check...x_return_status='||x_return_status);
1740: END IF;
1741: -- If payment in advance, check rate delays > print lead days
1742: IF (l_payment_in_advance) THEN
1743: NULL; -- Todo: AKP

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

1770: x_return_status := Okl_Api.G_RET_STS_ERROR;
1771: END IF;
1772: END IF;
1773: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1774: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In Check Payment Type:Before rate_delay_csr...');
1775: END IF;
1776: -- get rate delay (rule group/rule)
1777: OPEN rate_delay_csr(p_chr_id);
1778: FETCH rate_delay_csr INTO l_rate_delay;

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

1778: FETCH rate_delay_csr INTO l_rate_delay;
1779: CLOSE rate_delay_csr;
1780:
1781: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1782: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In Check Payment Type:Before print_lead_csr...');
1783: END IF;
1784: -- get cust print lead days
1785: OPEN cust_print_lead_days_csr(p_chr_id);
1786: FETCH cust_print_lead_days_csr INTO l_cust_print_lead_days;

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

1812: END IF;
1813: -- udhenuko End bug#6786775
1814:
1815: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1816: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In Check Payment Type:Before third check...x_return_status='||x_return_status);
1817: END IF;
1818: -- If Principal payment is defined, check if base_rate defined
1819: IF (l_principal_payment_found) THEN
1820: --print('Yes, Principal payment found: Checking base rate...');

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

1844: END IF;
1845: END IF;
1846:
1847: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1848: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In Check Payment Type:Before fourth check...x_return_status='||x_return_status);
1849: END IF;
1850: -- Bug 4674139
1851: -- Check if variable interest schedule is defined for LOAN FLOAT
1852: IF (l_deal_type = 'LOAN' AND

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

1855: (l_deal_type = 'LOAN-REVOLVING' AND
1856: l_interest_calculation_basis = 'FLOAT' ) THEN
1857: IF NOT(l_var_int_schedule_defined) THEN
1858: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1859: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Var Int Schedule Not Defined...');
1860: END IF;
1861: Okl_Api.set_message(
1862: p_app_name => G_APP_NAME,
1863: p_msg_name => 'OKL_LA_VAR_SCHEDULED_ALLOWED');

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

1863: p_msg_name => 'OKL_LA_VAR_SCHEDULED_ALLOWED');
1864: x_return_status := Okl_Api.G_RET_STS_ERROR;
1865: ELSE
1866: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1867: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Var Int Schedule Defined...');
1868: END IF;
1869: END IF;
1870: ELSE -- Bug 4742650 (Do not allow var int sched for other type of contracts)
1871: IF (l_var_int_schedule_defined) THEN

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

1876: END IF;
1877: END IF;
1878:
1879: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1880: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In Check Payment Type:Before fifth check...x_return_status='||x_return_status);
1881: END IF;
1882: -- Bug 4886871
1883: -- Check if variable interest schedule is same as loan payment schedule
1884: /*

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

1917: LOOP
1918: l_contract_start_date := l_cnt_start_date.start_date;
1919: END LOOP;
1920: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1921: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_contract_start_date=' || l_contract_start_date);
1922: END IF;
1923: IF (l_variable_start_date <> l_contract_start_date) THEN
1924: OKL_API.set_message(
1925: p_app_name => G_APP_NAME,

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

1928: END IF;
1929: END IF;
1930:
1931: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1932: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In Check Payment Type:Before sixth check...x_return_status='||x_return_status);
1933: END IF;
1934: -- Check same payment date for all assets (RENT currently)
1935: -- Commented this check from here and copied from check_variable_rate_old
1936: /*

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

2096: /*IF (l_deal_type = 'LOAN' AND
2097: l_interest_calculation_basis = 'REAMORT') THEN */
2098:
2099: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2100: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In Check Payment Type:Before seventh check...x_return_status='||x_return_status);
2101: END IF;
2102: --FOR l_pmnt_strm_check_rec IN l_pmnt_strm_check('LALEVL','LASLH','PRINCIPAL_PAYMENT',p_chr_id)
2103: FOR l_pmnt_strm_check_rec IN l_pmnt_strm_check('LALEVL','LASLH','PRINCIPAL_PAYMENT', p_chr_id)
2104: LOOP

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

2153: l_capitalize_down_payment_yn := r.capitalize_down_payment_yn;
2154: END LOOP;
2155:
2156: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2157: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_asset_number=' || l_asset_number || ' l_capital_amount=' || l_capital_amount);
2158: END IF;
2159: -- 5264170
2160: IF l_ste_code NOT IN ('CANCELLED','TERMINATED','HOLD','EXPIRED') THEN
2161: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

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

2158: END IF;
2159: -- 5264170
2160: IF l_ste_code NOT IN ('CANCELLED','TERMINATED','HOLD','EXPIRED') THEN
2161: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2162: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tot_principal_payment=' || l_tot_principal_payment);
2163: END IF;
2164: -- Now get total unscheduled principal payment for this line, if any
2165: -- 4887014
2166: l_tot_unsched_prin_payment :=

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

2166: l_tot_unsched_prin_payment :=
2167: tot_unsched_prin_payment(l_return_status, -- 4907390
2168: p_chr_id, l_curr_cle_id);
2169: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2170: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tot_unsched_prin_payment=' || l_tot_unsched_prin_payment);
2171: END IF;
2172:
2173: -- gboomina Bug 6401848 - Start
2174: -- 4898747

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

2182: p_accounting_method => 'NET',
2183: x_subsidy_amount => l_net_subsidy_amount);
2184:
2185: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2186: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_net_subsidy_amount=' || l_net_subsidy_amount);
2187: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_return_status=' || l_return_status);
2188: END IF;
2189: -- Fix for Bug 7131756
2190: l_non_cap_down_payment_amount := 0;

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

2183: x_subsidy_amount => l_net_subsidy_amount);
2184:
2185: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2186: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_net_subsidy_amount=' || l_net_subsidy_amount);
2187: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_return_status=' || l_return_status);
2188: END IF;
2189: -- Fix for Bug 7131756
2190: l_non_cap_down_payment_amount := 0;
2191: IF (l_capitalize_down_payment_yn = 'N') THEN

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

2211:
2212: END LOOP;
2213:
2214: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2215: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Before get_pricing_engine...x_return_status='||x_return_status);
2216: END IF;
2217: Okl_Streams_Util.get_pricing_engine(p_khr_id => p_chr_id,
2218: x_pricing_engine => l_pricing_engine,
2219: x_return_status => l_return_status);

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

2222: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2223: END IF;
2224:
2225: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2226: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In Check Payment Type:Before eighth check...x_return_status='||x_return_status);
2227: END IF;
2228: IF (l_deal_type IN ('LEASEOP', 'LEASEST', 'LEASEDF') ) AND
2229: (l_interest_Calculation_basis IN ('FIXED', 'REAMORT', 'FLOAT_FACTORS'))
2230: THEN

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

2253: END IF;
2254: END IF;
2255:
2256: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2257: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In Check Payment Type:Before ninth check...x_return_status='||x_return_status);
2258: END IF;
2259: IF (((l_deal_type = 'LOAN') AND
2260: (l_interest_Calculation_basis IN
2261: ('FIXED', 'FLOAT', 'CATCHUP/CLEANUP'))) OR

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

2300: /*END IF;*/
2301: END IF;
2302:
2303: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2304: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In Check Payment Type:Before tenth check...x_return_status='||x_return_status);
2305: END IF;
2306: IF ((l_deal_type = 'LOAN-REVONVING' ) AND
2307: (l_interest_Calculation_basis = 'FLOAT'))
2308: THEN

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

2322: END IF;
2323: END IF;
2324:
2325: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2326: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Before exitting: x_return_status=' || x_return_status);
2327: END IF;
2328: IF x_return_status = Okl_Api.G_RET_STS_SUCCESS THEN
2329: Okl_Api.set_message(
2330: p_app_name => G_APP_NAME,

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

2381: l_return_status VARCHAR2(1);
2382:
2383: BEGIN
2384: IF (G_DEBUG_ENABLED = 'Y') THEN
2385: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
2386: END IF;
2387: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
2388:
2389: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

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

2386: END IF;
2387: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
2388:
2389: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2390: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Before calling validate_k_rate_params...');
2391: END IF;
2392: Okl_K_Rate_Params_Pvt.validate_k_rate_params(
2393: p_api_version => 1,
2394: p_init_msg_list => Okl_Api.G_FALSE,

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

2398: p_khr_id => p_chr_id,
2399: p_validate_flag => 'F');
2400:
2401: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2402: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After validate_k_rate_params x_return_status=' || x_return_status);
2403: END IF;
2404: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
2405: --RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2406: --RAISE OKL_API.G_EXCEPTION_HALT_VALIDATION;

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

2411: check_payment_type(
2412: x_return_status => l_return_status,
2413: p_chr_id => p_chr_id);
2414: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2415: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After check_payment_type l_return_status=' || l_return_status);
2416: END IF;
2417:
2418: IF (l_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
2419: --RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

11181: lx_pool_status okl_subsidy_pools_b.decision_status_code%TYPE;
11182: lx_pool_balance okl_subsidy_pools_b.total_subsidy_amount%TYPE;
11183: lv_subsidy_amount okl_k_lines.subsidy_override_amount%TYPE;
11184: -- sjalasut, added local variables to support logging
11185: l_module CONSTANT fnd_log_messages.MODULE%TYPE := 'okl.plsql.OKL_QA_DATA_INTEGRITY.CHECK_SUBSIDIES_ERRORS';
11186: l_debug_enabled VARCHAR2(10);
11187: is_debug_statement_on BOOLEAN;
11188:
11189:

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

11192:
11193: -- check if debug is enabled
11194: l_debug_enabled := Okl_Debug_Pub.check_log_enabled;
11195: -- check for logging on STATEMENT level
11196: is_debug_statement_on := Okl_Debug_Pub.check_log_on(l_module,Fnd_Log.LEVEL_STATEMENT);
11197:
11198: Okl_Subsidy_Process_Pvt.is_contract_subsidized(
11199: p_api_version => 1.0,
11200: p_init_msg_list => p_init_msg_list,

Line 11283: Okl_Debug_Pub.log_debug(Fnd_Log.LEVEL_STATEMENT,

11279: ,x_sub_pool_curr_code => lx_sub_pool_curr_code);
11280: IF(lv_subsidy_pool_applicable_yn = 'Y')THEN
11281: -- write to log
11282: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
11283: Okl_Debug_Pub.log_debug(Fnd_Log.LEVEL_STATEMENT,
11284: l_module,
11285: 'subsidy '|| l_subsidy_id || ' is attached to subsidy pool '|| lx_subsidy_pool_id
11286: );
11287: END IF; -- end of NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on

Line 11347: Okl_Debug_Pub.log_debug(Fnd_Log.LEVEL_STATEMENT,

11343: ,x_msg_count => x_msg_count
11344: ,x_msg_data => x_msg_data);
11345: -- write to log
11346: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
11347: Okl_Debug_Pub.log_debug(Fnd_Log.LEVEL_STATEMENT,
11348: l_module,
11349: 'okl_asset_subsidy_pvt.is_balance_valid_after_add returned with '|| x_return_status||' x_msg_data '||x_msg_data
11350: );
11351: END IF; -- end of NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on