DBA Data[Home] [Help]

APPS.OKL_KRP_PVT dependencies on FND_LOG

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

868: x_return_status OUT NOCOPY VARCHAR2,
869: p_lookup_code IN VARCHAR2) IS
870: BEGIN
871: IF (G_DEBUG_ENABLED = 'Y') THEN
872: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
873: END IF;
874: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
875: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_lookup_code=' || p_lookup_code);
876: END IF;

Line 875: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_lookup_code=' || p_lookup_code);

871: IF (G_DEBUG_ENABLED = 'Y') THEN
872: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
873: END IF;
874: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
875: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_lookup_code=' || p_lookup_code);
876: END IF;
877: x_return_status := check_lookup_code('OKL_MONTH_TYPE',
878: p_lookup_code);
879: END validate_days_in_a_month_code;

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

958: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
959: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
960: BEGIN
961: IF (G_DEBUG_ENABLED = 'Y') THEN
962: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
963: END IF;
964: -----------------------------
965: -- Column Level Validation --
966: -----------------------------

Line 984: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After validate_khr_id');

980: RAISE G_EXCEPTION_HALT_VALIDATION;
981: END IF;
982: END IF;
983: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
984: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After validate_khr_id');
985: END IF;
986:
987: -- ***
988: -- parameter_type_code

Line 998: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After validate_parameter_type_code');

994: RAISE G_EXCEPTION_HALT_VALIDATION;
995: END IF;
996: END IF;
997: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
998: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After validate_parameter_type_code');
999: END IF;
1000:
1001: x_return_status := check_lookup_code('OKL_RATE_PARAM_TYPE_CODE',
1002: p_krpv_rec.parameter_type_code);

Line 1015: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After check_lookup_code');

1011: RAISE G_EXCEPTION_HALT_VALIDATION;
1012: END IF;
1013: END IF;
1014: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1015: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After check_lookup_code');
1016: END IF;
1017:
1018: -- ***
1019: -- effective_from_date

Line 1035: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After validate_effective_from_date');

1031: RAISE G_EXCEPTION_HALT_VALIDATION;
1032: END IF;
1033: END IF;
1034: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1035: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After validate_effective_from_date');
1036: END IF;
1037:
1038: --- Interest_basis_code
1039: IF (p_krpv_rec.interest_basis_code is NOT NULL AND

Line 1042: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'interest_basis_code=' || p_krpv_rec.interest_basis_code || ':');

1038: --- Interest_basis_code
1039: IF (p_krpv_rec.interest_basis_code is NOT NULL AND
1040: p_krpv_rec.interest_basis_code <> G_MISS_CHAR) THEN
1041: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1042: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'interest_basis_code=' || p_krpv_rec.interest_basis_code || ':');
1043: END IF;
1044: validate_interest_basis_code( x_return_status,
1045: p_krpv_rec.interest_basis_code);
1046: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

Line 1063: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After validate_interest_basis_code');

1059: END IF;
1060: END IF;
1061:
1062: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1063: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After validate_interest_basis_code');
1064: END IF;
1065: --- Rate_Delay_Code
1066: IF (p_krpv_rec.Rate_Delay_Code is NOT NULL AND
1067: p_krpv_rec.Rate_Delay_Code <> G_MISS_CHAR) THEN

Line 1086: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After validate_rate_delay_code');

1082: END IF;
1083: END IF;
1084: END IF;
1085: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1086: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After validate_rate_delay_code');
1087: END IF;
1088:
1089: --- Compounding_Frequency_Code
1090: IF (p_krpv_rec.Compounding_Frequency_Code is NOT NULL AND

Line 1110: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After validate_compounding_freq_code');

1106: END IF;
1107: END IF;
1108: END IF;
1109: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1110: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After validate_compounding_freq_code');
1111: END IF;
1112:
1113: --- Rate_Change_Frequency
1114: IF (p_krpv_rec.Rate_Change_Frequency_Code is NOT NULL AND

Line 1134: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After validate_rate_change_freq');

1130: END IF;
1131: END IF;
1132: END IF;
1133: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1134: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After validate_rate_change_freq');
1135: END IF;
1136:
1137: --- Principal_Basis_Code
1138: IF (p_krpv_rec.Principal_Basis_Code is NOT NULL AND

Line 1159: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After validate_principal_basis_code');

1155: END IF;
1156: END IF;
1157: END IF;
1158: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1159: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After validate_principal_basis_code');
1160: END IF;
1161:
1162: --- Catchup_Basis_Code
1163: IF (p_krpv_rec.Catchup_Basis_Code is NOT NULL AND

Line 1184: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After validate_catchup_basis_code');

1180: END IF;
1181: END IF;
1182: END IF;
1183: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1184: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After validate_catchup_basis_code');
1185: END IF;
1186:
1187: --- Catchup_Settlement_Code
1188: IF (p_krpv_rec.Catchup_Settlement_Code is NOT NULL AND

Line 1209: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After validate_catchup_settlement_code');

1205: END IF;
1206: END IF;
1207: END IF;
1208: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1209: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After validate_catchup_settlement_code');
1210: END IF;
1211:
1212: --- Conversion_Option_Code
1213: IF (p_krpv_rec.Conversion_Option_Code is NOT NULL AND

Line 1234: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After validate_conversion_option_code');

1230: END IF;
1231: END IF;
1232: END IF;
1233: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1234: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After validate_conversion_option_code');
1235: END IF;
1236:
1237: --- Conversion_Type_Code
1238: IF (p_krpv_rec.Conversion_Type_Code is NOT NULL AND

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

1585: --End of Code Bug# 13951493
1586:
1587: BEGIN
1588: IF (G_DEBUG_ENABLED = 'Y') THEN
1589: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
1590: END IF;
1591: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1592: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In Validate_Record...');
1593: END IF;

Line 1592: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In Validate_Record...');

1588: IF (G_DEBUG_ENABLED = 'Y') THEN
1589: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
1590: END IF;
1591: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1592: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In Validate_Record...');
1593: END IF;
1594: IF (p_deal_type IN ('LEASEDF', 'LEASEOP', 'LEASEST') ) THEN
1595: IF (p_int_calc_basis = 'FIXED' AND p_rev_rec_method = 'STREAMS') THEN
1596:

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

4307: lx_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4308:
4309: BEGIN
4310: IF (G_DEBUG_ENABLED = 'Y') THEN
4311: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
4312: END IF;
4313: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
4314: G_PKG_NAME,
4315: p_init_msg_list,

Line 4328: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In validate_row... p_krpv_tbl.count=' || p_krpv_tbl.count);

4324: RAISE OKC_API.G_EXCEPTION_ERROR;
4325: END IF;
4326: END IF;
4327: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4328: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In validate_row... p_krpv_tbl.count=' || p_krpv_tbl.count);
4329: END IF;
4330: IF (p_krpv_tbl.COUNT > 0) THEN
4331: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4332: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inside ...');

Line 4332: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inside ...');

4328: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In validate_row... p_krpv_tbl.count=' || p_krpv_tbl.count);
4329: END IF;
4330: IF (p_krpv_tbl.COUNT > 0) THEN
4331: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4332: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inside ...');
4333: END IF;
4334: i := p_krpv_tbl.FIRST;
4335: LOOP
4336: l_krpv_rec := p_krpv_tbl(i);

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

4337:
4338: --- Validate all non-missing attributes (Item Level Validation)
4339: l_return_status := Validate_Attributes(l_krpv_rec, p_stack_messages);
4340: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4341: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After validate_attributes...l_return_status='||l_return_status);
4342: END IF;
4343: IF (p_stack_messages = 'N') THEN
4344: --- If any errors happen abort API
4345: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 4353: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Calling validate_record...');

4349: END IF;
4350: END IF;
4351: IF (nvl(p_validate_flag, 'Y') = 'F') THEN
4352: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4353: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Calling validate_record...');
4354: END IF;
4355: lx_return_status := Validate_Record(l_krpv_rec,
4356: p_stack_messages,
4357: p_deal_type,

Line 4361: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After validate_record l_return_status=' || lx_return_status);

4357: p_deal_type,
4358: p_rev_rec_method,
4359: p_int_calc_basis);
4360: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4361: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After validate_record l_return_status=' || lx_return_status);
4362: END IF;
4363:
4364: --Bug# 13002041
4365: IF lx_return_status <> OKC_API.G_RET_STS_SUCCESS THEN