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_AM_BAL_WRITEOFF_PVT dependencies on FND_LOG

Line 476: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

472: get_khr_details_rec get_khr_details_csr%ROWTYPE;
473:
474: BEGIN
475:
476: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
477: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
478: 'OKL_AM_BAL_WRITEOFF_PVT.populate_khr_prg.',
479: 'Begin(+)');
480: END IF;

Line 477: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

473:
474: BEGIN
475:
476: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
477: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
478: 'OKL_AM_BAL_WRITEOFF_PVT.populate_khr_prg.',
479: 'Begin(+)');
480: END IF;
481:

Line 502: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

498: -- Set return values
499: x_return_status := l_return_status;
500: x_khr_rec := l_khr_rec;
501:
502: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
503: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
504: 'OKL_AM_BAL_WRITEOFF_PVT.populate_khr_prg.',
505: 'End(-)');
506: END IF;

Line 503: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

499: x_return_status := l_return_status;
500: x_khr_rec := l_khr_rec;
501:
502: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
503: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
504: 'OKL_AM_BAL_WRITEOFF_PVT.populate_khr_prg.',
505: 'End(-)');
506: END IF;
507:

Line 523: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

519: p_token2_value => SQLERRM);
520:
521: x_return_status := G_RET_STS_UNEXP_ERROR;
522:
523: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
524: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
525: 'OKL_AM_BAL_WRITEOFF_PVT.populate_khr_prg.',
526: 'EXP - OTHERS');
527: END IF;

Line 524: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

520:
521: x_return_status := G_RET_STS_UNEXP_ERROR;
522:
523: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
524: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
525: 'OKL_AM_BAL_WRITEOFF_PVT.populate_khr_prg.',
526: 'EXP - OTHERS');
527: END IF;
528:

Line 576: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

572: l_tsu_code VARCHAR2(300);
573:
574: BEGIN
575:
576: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
577: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
578: 'OKL_AM_BAL_WRITEOFF_PVT.validate_khr_prg.',
579: 'Begin(+)');
580: END IF;

Line 577: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

573:
574: BEGIN
575:
576: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
577: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
578: 'OKL_AM_BAL_WRITEOFF_PVT.validate_khr_prg.',
579: 'Begin(+)');
580: END IF;
581:

Line 681: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

677:
678: -- Set return values
679: x_return_status := l_return_status;
680:
681: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
682: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
683: 'OKL_AM_BAL_WRITEOFF_PVT.validate_khr_prg.',
684: 'End(-)');
685: END IF;

Line 682: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

678: -- Set return values
679: x_return_status := l_return_status;
680:
681: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
682: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
683: 'OKL_AM_BAL_WRITEOFF_PVT.validate_khr_prg.',
684: 'End(-)');
685: END IF;
686:

Line 693: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

689: WHEN G_EXCEPTION_ERROR THEN
690: ROLLBACK TO validate_khr_trx;
691: x_return_status := G_RET_STS_ERROR;
692:
693: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
694: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
695: 'OKL_AM_BAL_WRITEOFF_PVT.validate_khr_prg.',
696: 'EXP - G_EXCEPTION_ERROR');
697: END IF;

Line 694: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

690: ROLLBACK TO validate_khr_trx;
691: x_return_status := G_RET_STS_ERROR;
692:
693: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
694: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
695: 'OKL_AM_BAL_WRITEOFF_PVT.validate_khr_prg.',
696: 'EXP - G_EXCEPTION_ERROR');
697: END IF;
698:

Line 703: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

699: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
700: ROLLBACK TO validate_khr_trx;
701: x_return_status := G_RET_STS_UNEXP_ERROR;
702:
703: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
704: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
705: 'OKL_AM_BAL_WRITEOFF_PVT.validate_khr_prg.',
706: 'EXP - G_EXCEPTION_UNEXPECTED_ERROR');
707: END IF;

Line 704: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

700: ROLLBACK TO validate_khr_trx;
701: x_return_status := G_RET_STS_UNEXP_ERROR;
702:
703: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
704: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
705: 'OKL_AM_BAL_WRITEOFF_PVT.validate_khr_prg.',
706: 'EXP - G_EXCEPTION_UNEXPECTED_ERROR');
707: END IF;
708:

Line 722: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

718: p_token2_value => SQLERRM);
719:
720: x_return_status := G_RET_STS_UNEXP_ERROR;
721:
722: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
723: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
724: 'OKL_AM_BAL_WRITEOFF_PVT.validate_khr_prg.',
725: 'EXP - OTHERS');
726: END IF;

Line 723: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

719:
720: x_return_status := G_RET_STS_UNEXP_ERROR;
721:
722: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
723: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
724: 'OKL_AM_BAL_WRITEOFF_PVT.validate_khr_prg.',
725: 'EXP - OTHERS');
726: END IF;
727:

Line 932: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

928: -- if total balance amount within the tolerance limit then
929: -- close balances
930: -- end if
931:
932: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
933: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
934: 'OKL_AM_BAL_WRITEOFF_PVT.write_off_balances.',
935: 'Begin(+)');
936: END IF;

Line 933: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

929: -- close balances
930: -- end if
931:
932: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
933: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
934: 'OKL_AM_BAL_WRITEOFF_PVT.write_off_balances.',
935: 'Begin(+)');
936: END IF;
937:

Line 1013: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1009: p_msg_name => 'OKL_AM_TOL_AMT',
1010: p_token1 => 'PROFILE_NAME',
1011: p_token1_value => l_tol_profile_name);
1012:
1013: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1014: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1015: 'OKL_AM_BAL_WRITEOFF_PVT.write_off_balances.',
1016: 'NO TOLERANCE');
1017: END IF;

Line 1014: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1010: p_token1 => 'PROFILE_NAME',
1011: p_token1_value => l_tol_profile_name);
1012:
1013: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1014: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1015: 'OKL_AM_BAL_WRITEOFF_PVT.write_off_balances.',
1016: 'NO TOLERANCE');
1017: END IF;
1018:

Line 1040: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1036: p_msg_name => 'OKL_AM_PRODUCT_ID_ERROR',
1037: p_token1 => 'CONTRACT_NUMBER',
1038: p_token1_value=> p_khr_rec.contract_number);
1039:
1040: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1041: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1042: 'OKL_AM_BAL_WRITEOFF_PVT.write_off_balances.',
1043: 'product_id_error = '||l_return_status );
1044: END IF;

Line 1041: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1037: p_token1 => 'CONTRACT_NUMBER',
1038: p_token1_value=> p_khr_rec.contract_number);
1039:
1040: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1041: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1042: 'OKL_AM_BAL_WRITEOFF_PVT.write_off_balances.',
1043: 'product_id_error = '||l_return_status );
1044: END IF;
1045:

Line 1075: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1071: p_msg_name => 'OKL_AM_NO_TRX_TYPE_FOUND',
1072: p_token1 => 'TRY_NAME',
1073: p_token1_value => l_trans_meaning);
1074:
1075: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1076: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1077: 'OKL_AM_BAL_WRITEOFF_PVT.write_off_balances.',
1078: 'balance_writeoff_trn_error = '||l_return_status );
1079: END IF;

Line 1076: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1072: p_token1 => 'TRY_NAME',
1073: p_token1_value => l_trans_meaning);
1074:
1075: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1076: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1077: 'OKL_AM_BAL_WRITEOFF_PVT.write_off_balances.',
1078: 'balance_writeoff_trn_error = '||l_return_status );
1079: END IF;
1080:

Line 1125: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1121: p_msg_name => 'OKL_AM_ERR_ACC_ENT',
1122: p_token1 => 'TRX_TYPE',
1123: p_token1_value => l_trans_meaning);
1124:
1125: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1126: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1127: 'OKL_AM_BAL_WRITEOFF_PVT.write_off_balances.',
1128: 'currency_conv_error = '||l_return_status );
1129: END IF;

Line 1126: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1122: p_token1 => 'TRX_TYPE',
1123: p_token1_value => l_trans_meaning);
1124:
1125: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1126: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1127: 'OKL_AM_BAL_WRITEOFF_PVT.write_off_balances.',
1128: 'currency_conv_error = '||l_return_status );
1129: END IF;
1130:

Line 1166: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1162: p_msg_name => 'OKL_AM_ERR_ADJST_BAL');
1163:
1164: END IF;
1165:
1166: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1167: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1168: 'OKL_AM_BAL_WRITEOFF_PVT.write_off_balances.',
1169: 'OKL_TRX_CONTRACTS_PUB.create_trx_contracts = '||l_return_status );
1170: END IF;

Line 1167: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1163:
1164: END IF;
1165:
1166: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1167: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1168: 'OKL_AM_BAL_WRITEOFF_PVT.write_off_balances.',
1169: 'OKL_TRX_CONTRACTS_PUB.create_trx_contracts = '||l_return_status );
1170: END IF;
1171:

Line 1209: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1205: p_msg_name => 'OKL_AM_ERR_ADJST_BAL');
1206:
1207: END IF;
1208:
1209: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1210: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1211: 'OKL_AM_BAL_WRITEOFF_PVT.write_off_balances.',
1212: 'OKL_TRX_AR_ADJSTS_PUB.insert_trx_ar_adjsts = '||l_return_status );
1213: END IF;

Line 1210: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1206:
1207: END IF;
1208:
1209: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1210: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1211: 'OKL_AM_BAL_WRITEOFF_PVT.write_off_balances.',
1212: 'OKL_TRX_AR_ADJSTS_PUB.insert_trx_ar_adjsts = '||l_return_status );
1213: END IF;
1214:

Line 1265: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1261: OKL_API.set_message( p_app_name => G_APP_NAME,
1262: p_msg_name => 'OKL_AM_ERR_ADJST_BAL');
1263: END IF;
1264:
1265: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1266: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1267: 'OKL_AM_BAL_WRITEOFF_PVT.write_off_balances.',
1268: 'OKL_TRX_AR_ADJSTS_PUB.insert_txl_adjsts_lns = '||l_return_status );
1269: END IF;

Line 1266: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1262: p_msg_name => 'OKL_AM_ERR_ADJST_BAL');
1263: END IF;
1264:
1265: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1266: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1267: 'OKL_AM_BAL_WRITEOFF_PVT.write_off_balances.',
1268: 'OKL_TRX_AR_ADJSTS_PUB.insert_txl_adjsts_lns = '||l_return_status );
1269: END IF;
1270:

Line 1330: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1326: p_msg_name => 'OKL_AM_ERR_ADJST_BAL');
1327:
1328: END IF;
1329:
1330: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1331: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1332: 'OKL_AM_BAL_WRITEOFF_PVT.write_off_balances.',
1333: 'OKL_ACC_CALL_PVT.okl_populate_acc_gen = '||l_return_status );
1334: END IF;

Line 1331: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1327:
1328: END IF;
1329:
1330: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1331: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1332: 'OKL_AM_BAL_WRITEOFF_PVT.write_off_balances.',
1333: 'OKL_ACC_CALL_PVT.okl_populate_acc_gen = '||l_return_status );
1334: END IF;
1335:

Line 1436: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1432: p_msg_name => 'OKL_AM_CODE_CMB_ERROR',
1433: p_token1 => 'CONTRACT_NUMBER',
1434: p_token1_value=> p_khr_rec.contract_number);
1435:
1436: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1437: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1438: 'OKL_AM_BAL_WRITEOFF_PVT.write_off_balances.',
1439: 'code_comb_err = '||l_return_status );
1440: END IF;

Line 1437: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1433: p_token1 => 'CONTRACT_NUMBER',
1434: p_token1_value=> p_khr_rec.contract_number);
1435:
1436: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1437: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1438: 'OKL_AM_BAL_WRITEOFF_PVT.write_off_balances.',
1439: 'code_comb_err = '||l_return_status );
1440: END IF;
1441:

Line 1475: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1471: OKL_API.set_message( p_app_name => G_APP_NAME,
1472: p_msg_name => 'OKL_AM_ERR_ADJST_BAL');
1473: END IF;
1474:
1475: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1476: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1477: 'OKL_AM_BAL_WRITEOFF_PVT.write_off_balances.',
1478: 'OKL_TXL_ADJSTS_LNS_PUB.update_txl_adjsts_lns = '||l_return_status );
1479: END IF;

Line 1476: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1472: p_msg_name => 'OKL_AM_ERR_ADJST_BAL');
1473: END IF;
1474:
1475: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1476: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1477: 'OKL_AM_BAL_WRITEOFF_PVT.write_off_balances.',
1478: 'OKL_TXL_ADJSTS_LNS_PUB.update_txl_adjsts_lns = '||l_return_status );
1479: END IF;
1480:

Line 1519: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1515: p_token2_value => ajlv_id_tbl(i).stream_meaning);
1516: END LOOP;
1517: ELSE --(cannot close all balances since tolerance amt is less)
1518:
1519: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1520: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1521: 'OKL_AM_BAL_WRITEOFF_PVT.write_off_balances.',
1522: 'cannot_close_bal = '||'E' );
1523: END IF;

Line 1520: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1516: END LOOP;
1517: ELSE --(cannot close all balances since tolerance amt is less)
1518:
1519: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1520: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1521: 'OKL_AM_BAL_WRITEOFF_PVT.write_off_balances.',
1522: 'cannot_close_bal = '||'E' );
1523: END IF;
1524:

Line 1552: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1548: RAISE OKL_API.G_EXCEPTION_ERROR;
1549: END IF;
1550: ELSE
1551:
1552: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1553: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1554: 'OKL_AM_BAL_WRITEOFF_PVT.write_off_balances.',
1555: 'no_balance = '||'E' );
1556: END IF;

Line 1553: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1549: END IF;
1550: ELSE
1551:
1552: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1553: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1554: 'OKL_AM_BAL_WRITEOFF_PVT.write_off_balances.',
1555: 'no_balance = '||'E' );
1556: END IF;
1557:

Line 1570: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1566:
1567: -- End Activity
1568: OKL_API.end_activity (x_msg_count, x_msg_data);
1569:
1570: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1571: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1572: 'OKL_AM_BAL_WRITEOFF_PVT.write_off_balances.',
1573: 'End(-)');
1574: END IF;

Line 1571: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1567: -- End Activity
1568: OKL_API.end_activity (x_msg_count, x_msg_data);
1569:
1570: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1571: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1572: 'OKL_AM_BAL_WRITEOFF_PVT.write_off_balances.',
1573: 'End(-)');
1574: END IF;
1575:

Line 1596: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1592: x_msg_count => x_msg_count,
1593: x_msg_data => x_msg_data,
1594: p_api_type => '_PVT');
1595:
1596: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1597: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1598: 'OKL_AM_BAL_WRITEOFF_PVT.write_off_balances.',
1599: 'EXP - ERROR');
1600: END IF;

Line 1597: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1593: x_msg_data => x_msg_data,
1594: p_api_type => '_PVT');
1595:
1596: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1597: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1598: 'OKL_AM_BAL_WRITEOFF_PVT.write_off_balances.',
1599: 'EXP - ERROR');
1600: END IF;
1601:

Line 1622: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1618: x_msg_count => x_msg_count,
1619: x_msg_data => x_msg_data,
1620: p_api_type => '_PVT');
1621:
1622: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1623: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1624: 'OKL_AM_BAL_WRITEOFF_PVT.write_off_balances.',
1625: 'EXP - UNEXCP ERROR');
1626: END IF;

Line 1623: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1619: x_msg_data => x_msg_data,
1620: p_api_type => '_PVT');
1621:
1622: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1623: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1624: 'OKL_AM_BAL_WRITEOFF_PVT.write_off_balances.',
1625: 'EXP - UNEXCP ERROR');
1626: END IF;
1627:

Line 1647: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1643: x_msg_count => x_msg_count,
1644: x_msg_data => x_msg_data,
1645: p_api_type => '_PVT');
1646:
1647: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1648: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1649: 'OKL_AM_BAL_WRITEOFF_PVT.write_off_balances.',
1650: 'EXP - OTHERS');
1651: END IF;

Line 1648: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1644: x_msg_data => x_msg_data,
1645: p_api_type => '_PVT');
1646:
1647: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1648: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1649: 'OKL_AM_BAL_WRITEOFF_PVT.write_off_balances.',
1650: 'EXP - OTHERS');
1651: END IF;
1652:

Line 1701: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1697: G_EXCEPTION EXCEPTION;
1698:
1699: BEGIN
1700:
1701: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1702: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1703: 'OKL_AM_BAL_WRITEOFF_PVT.do_write_off_balances.',
1704: 'Begin(+)');
1705: END IF;

Line 1702: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1698:
1699: BEGIN
1700:
1701: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1702: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1703: 'OKL_AM_BAL_WRITEOFF_PVT.do_write_off_balances.',
1704: 'Begin(+)');
1705: END IF;
1706:

Line 1734: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1730: p_khr_rec => p_khr_rec,
1731: x_khr_rec => l_khr_rec,
1732: x_return_status => l_return_status);
1733:
1734: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1735: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1736: 'OKL_AM_BAL_WRITEOFF_PVT.do_write_off_balances.',
1737: 'populate_khr_prg = '||l_return_status );
1738: END IF;

Line 1735: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1731: x_khr_rec => l_khr_rec,
1732: x_return_status => l_return_status);
1733:
1734: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1735: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1736: 'OKL_AM_BAL_WRITEOFF_PVT.do_write_off_balances.',
1737: 'populate_khr_prg = '||l_return_status );
1738: END IF;
1739:

Line 1757: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1753: p_khr_rec => l_khr_rec,
1754: p_control_flag => p_control_flag,
1755: x_return_status => l_return_status);
1756:
1757: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1758: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1759: 'OKL_AM_BAL_WRITEOFF_PVT.do_write_off_balances.',
1760: 'validate_khr_prg = '||l_return_status );
1761: END IF;

Line 1758: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1754: p_control_flag => p_control_flag,
1755: x_return_status => l_return_status);
1756:
1757: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1758: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1759: 'OKL_AM_BAL_WRITEOFF_PVT.do_write_off_balances.',
1760: 'validate_khr_prg = '||l_return_status );
1761: END IF;
1762:

Line 1781: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1777: p_khr_rec => l_khr_rec,
1778: p_sys_date => l_sys_date,
1779: p_control_flag => p_control_flag);
1780:
1781: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1782: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1783: 'OKL_AM_BAL_WRITEOFF_PVT.do_write_off_balances.',
1784: 'write_off_balances = '||l_return_status );
1785: END IF;

Line 1782: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1778: p_sys_date => l_sys_date,
1779: p_control_flag => p_control_flag);
1780:
1781: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1782: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1783: 'OKL_AM_BAL_WRITEOFF_PVT.do_write_off_balances.',
1784: 'write_off_balances = '||l_return_status );
1785: END IF;
1786:

Line 1809: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1805:
1806: -- End Activity
1807: OKL_API.end_activity (x_msg_count, x_msg_data);
1808:
1809: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1810: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1811: 'OKL_AM_BAL_WRITEOFF_PVT.do_write_off_balances.',
1812: 'End(-)');
1813: END IF;

Line 1810: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1806: -- End Activity
1807: OKL_API.end_activity (x_msg_count, x_msg_data);
1808:
1809: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1810: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1811: 'OKL_AM_BAL_WRITEOFF_PVT.do_write_off_balances.',
1812: 'End(-)');
1813: END IF;
1814:

Line 1834: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1830: x_msg_count => x_msg_count,
1831: x_msg_data => x_msg_data,
1832: p_api_type => '_PVT');
1833:
1834: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1835: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1836: 'OKL_AM_BAL_WRITEOFF_PVT.do_write_off_balances.',
1837: 'EXP - G_EXCEPTION_ERROR');
1838: END IF;

Line 1835: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1831: x_msg_data => x_msg_data,
1832: p_api_type => '_PVT');
1833:
1834: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1835: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1836: 'OKL_AM_BAL_WRITEOFF_PVT.do_write_off_balances.',
1837: 'EXP - G_EXCEPTION_ERROR');
1838: END IF;
1839:

Line 1857: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1853: x_msg_count => x_msg_count,
1854: x_msg_data => x_msg_data,
1855: p_api_type => '_PVT');
1856:
1857: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1858: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1859: 'OKL_AM_BAL_WRITEOFF_PVT.do_write_off_balances.',
1860: 'EXP - G_EXCEPTION_UNEXPECTED_ERROR');
1861: END IF;

Line 1858: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1854: x_msg_data => x_msg_data,
1855: p_api_type => '_PVT');
1856:
1857: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1858: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1859: 'OKL_AM_BAL_WRITEOFF_PVT.do_write_off_balances.',
1860: 'EXP - G_EXCEPTION_UNEXPECTED_ERROR');
1861: END IF;
1862:

Line 1880: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1876: x_msg_count => x_msg_count,
1877: x_msg_data => x_msg_data,
1878: p_api_type => '_PVT');
1879:
1880: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1881: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1882: 'OKL_AM_BAL_WRITEOFF_PVT.do_write_off_balances.',
1883: 'EXP - OTHERS');
1884: END IF;

Line 1881: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1877: x_msg_data => x_msg_data,
1878: p_api_type => '_PVT');
1879:
1880: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1881: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1882: 'OKL_AM_BAL_WRITEOFF_PVT.do_write_off_balances.',
1883: 'EXP - OTHERS');
1884: END IF;
1885: