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_PROCESS_STREAMS_PVT dependencies on OKL_API

Line 225: IF (p_reporting_streams = OKL_API.G_TRUE)

221: l_stmv_rec.date_working := SYSDATE ;
222: l_stmv_rec.transaction_number := p_transaction_number;
223: l_stmv_rec.comments := null;
224: -- smahapat 11/10/02 multi-gaap -- addition
225: IF (p_reporting_streams = OKL_API.G_TRUE)
226: THEN
227: l_stmv_rec.purpose_code := G_PURPOSE_CODE_REPORT;
228: END IF;
229: -- smahapat addition end

Line 233: IF( rules_data_csr.RULE_INFORMATION2 IS NOT NULL and rules_data_csr.RULE_INFORMATION2 <> OKL_API.G_MISS_CHAR)

229: -- smahapat addition end
230:
231: FOR rules_data_csr in rules_csr('LALEVL', 'SLL', p_khr_id, l_slh_id)
232: LOOP
233: IF( rules_data_csr.RULE_INFORMATION2 IS NOT NULL and rules_data_csr.RULE_INFORMATION2 <> OKL_API.G_MISS_CHAR)
234: THEN
235: -- Get all the Rules for this rule group
236: l_frequency := rules_data_csr.object1_id1 ;
237: l_date_start := FND_DATE.CANONICAL_TO_DATE(rules_data_csr.RULE_INFORMATION2);

Line 337: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

333: END LOOP;
334: EXCEPTION
335: WHEN G_EXCEPTION_ERROR THEN
336: x_return_status := G_RET_STS_ERROR;
337: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
338: p_msg_name => G_UNEXPECTED_ERROR,
339: p_token1 => G_SQLCODE_TOKEN,
340: p_token1_value => SQLCODE,
341: p_token2 => G_SQLERRM_TOKEN,

Line 345: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

341: p_token2 => G_SQLERRM_TOKEN,
342: p_token2_value => SQLERRM );
343: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
344: x_return_status := G_RET_STS_UNEXP_ERROR;
345: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
346: p_msg_name => G_UNEXPECTED_ERROR,
347: p_token1 => G_SQLCODE_TOKEN,
348: p_token1_value => SQLCODE,
349: p_token2 => G_SQLERRM_TOKEN,

Line 353: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

349: p_token2 => G_SQLERRM_TOKEN,
350: p_token2_value => SQLERRM );
351: WHEN OTHERS THEN
352: x_return_status := G_RET_STS_UNEXP_ERROR;
353: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
354: p_msg_name => G_UNEXPECTED_ERROR,
355: p_token1 => G_SQLCODE_TOKEN,
356: p_token1_value => SQLCODE,
357: p_token2 => G_SQLERRM_TOKEN,

Line 453: IF (p_reporting_streams = OKL_API.G_TRUE)

449: l_stmv_rec.date_working := SYSDATE ;
450: l_stmv_rec.transaction_number := p_transaction_number;
451: l_stmv_rec.comments := null;
452: -- smahapat 11/10/02 multi-gaap -- addition
453: IF (p_reporting_streams = OKL_API.G_TRUE)
454: THEN
455: l_stmv_rec.purpose_code := G_PURPOSE_CODE_REPORT;
456: END IF;
457: -- smahapat addition end

Line 461: IF( rules_data_csr.RULE_INFORMATION2 IS NOT NULL and rules_data_csr.RULE_INFORMATION2 <> OKL_API.G_MISS_CHAR)

457: -- smahapat addition end
458:
459: FOR rules_data_csr in rules_csr('LALEVL', 'SLL', p_khr_id, l_slh_id)
460: LOOP
461: IF( rules_data_csr.RULE_INFORMATION2 IS NOT NULL and rules_data_csr.RULE_INFORMATION2 <> OKL_API.G_MISS_CHAR)
462: THEN
463: -- Get all the Rules for this rule group
464: l_frequency := rules_data_csr.object1_id1 ;
465: l_date_start := FND_DATE.CANONICAL_TO_DATE(rules_data_csr.RULE_INFORMATION2);

Line 568: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

564: END LOOP;
565: EXCEPTION
566: WHEN G_EXCEPTION_ERROR THEN
567: x_return_status := G_RET_STS_ERROR;
568: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
569: p_msg_name => G_UNEXPECTED_ERROR,
570: p_token1 => G_SQLCODE_TOKEN,
571: p_token1_value => SQLCODE,
572: p_token2 => G_SQLERRM_TOKEN,

Line 576: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

572: p_token2 => G_SQLERRM_TOKEN,
573: p_token2_value => SQLERRM );
574: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
575: x_return_status := G_RET_STS_UNEXP_ERROR;
576: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
577: p_msg_name => G_UNEXPECTED_ERROR,
578: p_token1 => G_SQLCODE_TOKEN,
579: p_token1_value => SQLCODE,
580: p_token2 => G_SQLERRM_TOKEN,

Line 584: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

580: p_token2 => G_SQLERRM_TOKEN,
581: p_token2_value => SQLERRM );
582: WHEN OTHERS THEN
583: x_return_status := G_RET_STS_UNEXP_ERROR;
584: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
585: p_msg_name => G_UNEXPECTED_ERROR,
586: p_token1 => G_SQLCODE_TOKEN,
587: p_token1_value => SQLCODE,
588: p_token2 => G_SQLERRM_TOKEN,

Line 964: l_reporting_streams VARCHAR2(1) := OKL_API.G_FALSE;

960: SIFB.ID = SFEB.SIF_ID AND
961: transaction_number = p_trx_number AND
962: SFE_TYPE = 'SFB' ORDER BY FEE_INDEX_NUMBER;
963:
964: l_reporting_streams VARCHAR2(1) := OKL_API.G_FALSE;
965: l_process_yn VARCHAR2(1) := OKL_API.G_TRUE;
966: l_chk_subsidy VARCHAR2(1) := 'x';
967: -- smahapat addition end
968: yield_csr yield_data_csr%ROWTYPE;

Line 965: l_process_yn VARCHAR2(1) := OKL_API.G_TRUE;

961: transaction_number = p_trx_number AND
962: SFE_TYPE = 'SFB' ORDER BY FEE_INDEX_NUMBER;
963:
964: l_reporting_streams VARCHAR2(1) := OKL_API.G_FALSE;
965: l_process_yn VARCHAR2(1) := OKL_API.G_TRUE;
966: l_chk_subsidy VARCHAR2(1) := 'x';
967: -- smahapat addition end
968: yield_csr yield_data_csr%ROWTYPE;
969: stream_csr stream_data_csr%ROWTYPE;

Line 1029: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;

1025: l_first_rec CHAR := 'T';
1026:
1027: G_RND_DIFF_LOOKUP_TYPE CONSTANT fnd_lookups.lookup_type%TYPE := 'OKL_STRM_APPLY_ROUNDING_DIFF';
1028: G_NO_MATCH_REC CONSTANT VARCHAR2(30) := 'OKL_LLA_NO_MATCHING_RECORD';
1029: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
1030: -- Bug 4196515: End
1031:
1032: --Added by kthiruva on 15-May-2005 for Streams Performance
1033: --Bug 4346646-Start of Changes

Line 1053: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,

1049: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inside procedure process_stream_results');
1050: END IF;
1051:
1052:
1053: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
1054: p_pkg_name => 'OKL_PROCESS_STREAMS_PVT',
1055: p_init_msg_list => p_init_msg_list,
1056: l_api_version => l_api_version,
1057: p_api_version => p_api_version,

Line 1129: l_reporting_streams := OKL_API.G_TRUE;

1125: FOR reporting_streams_data IN reporting_streams_csr(p_transaction_number)
1126: LOOP
1127: IF (reporting_streams_data.purpose_code = G_PURPOSE_CODE_REPORT)
1128: THEN
1129: l_reporting_streams := OKL_API.G_TRUE;
1130: END IF;
1131: END LOOP;
1132:
1133: -- Bug 4196515: Start

Line 1152: IF (l_reporting_streams = OKL_API.G_TRUE)

1148: l_stmv_rec.say_code := G_STREAM_ACTIVITY_WORK;
1149: l_stmv_rec.active_yn := G_STREAM_ACTIVE_YN;
1150: l_stmv_rec.date_working := SYSDATE ;
1151: l_stmv_rec.comments := l_comments ;
1152: IF (l_reporting_streams = OKL_API.G_TRUE)
1153: THEN
1154: l_stmv_rec.purpose_code := G_PURPOSE_CODE_REPORT;
1155: END IF;
1156: l_khr_id := TO_CHAR(stream_csr.khr_id);

Line 1266: IF (l_reporting_streams = OKL_API.G_TRUE)

1262: l_stmv_tbl(i) := l_stmv_rec ;
1263: --Bug 4346646 - End of Changes
1264:
1265: -- smahapat 11/10/02 multi-gaap -- addition
1266: IF (l_reporting_streams = OKL_API.G_TRUE)
1267: THEN
1268: l_stmv_rec.purpose_code := G_PURPOSE_CODE_REPORT;
1269: END IF;
1270: -- smahapat addition end

Line 1450: IF (l_reporting_streams = OKL_API.G_TRUE) THEN

1446:
1447: --start smahapat bugfix# 2790695
1448: --Generate accrual streams for service lines
1449: lx_pdt_parameter_rec := NULL;
1450: IF (l_reporting_streams = OKL_API.G_TRUE) THEN
1451: OPEN reporting_product_csr(p_transaction_number);
1452: FETCH reporting_product_csr INTO reporting_product_rec;
1453: CLOSE reporting_product_csr;
1454: --Added by kthiruva for Debug Logging

Line 1474: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1470: --Added by kthiruva for Debug Logging
1471: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1472: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to OKL_SETUPPRODUCTS_PVT.Getpdt_parameters, return status is :'|| x_return_status);
1473: END IF;
1474: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1475: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1476: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1477: RAISE OKL_API.G_EXCEPTION_ERROR;
1478: END IF;

Line 1475: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1471: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1472: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to OKL_SETUPPRODUCTS_PVT.Getpdt_parameters, return status is :'|| x_return_status);
1473: END IF;
1474: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1475: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1476: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1477: RAISE OKL_API.G_EXCEPTION_ERROR;
1478: END IF;
1479: END IF;

Line 1476: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

1472: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to OKL_SETUPPRODUCTS_PVT.Getpdt_parameters, return status is :'|| x_return_status);
1473: END IF;
1474: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1475: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1476: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1477: RAISE OKL_API.G_EXCEPTION_ERROR;
1478: END IF;
1479: END IF;
1480:

Line 1477: RAISE OKL_API.G_EXCEPTION_ERROR;

1473: END IF;
1474: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1475: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1476: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1477: RAISE OKL_API.G_EXCEPTION_ERROR;
1478: END IF;
1479: END IF;
1480:
1481: --Added by kthiruva for ESG Performance Improvement on 03-May-2005

Line 1498: p_compute_irr => OKL_API.G_FALSE,

1494: okl_stream_generator_pub.GENERATE_STREAMS(
1495: p_api_version => p_api_version,
1496: p_init_msg_list => p_init_msg_list,
1497: p_khr_id => l_khr_id,
1498: p_compute_irr => OKL_API.G_FALSE,
1499: p_generation_type => 'SERVICE_LINES',
1500: p_reporting_book_class => lx_pdt_parameter_rec.deal_type,
1501: x_pre_tax_irr => x_pre_tax_irr,
1502: x_return_status => x_return_status,

Line 1531: p_compute_irr => OKL_API.G_FALSE,

1527: okl_stream_generator_pub.GENERATE_STREAMS(
1528: p_api_version => p_api_version,
1529: p_init_msg_list => p_init_msg_list,
1530: p_khr_id => l_khr_id,
1531: p_compute_irr => OKL_API.G_FALSE,
1532: p_generation_type => 'RESIDUAL VALUE',
1533: p_reporting_book_class => lx_pdt_parameter_rec.deal_type,
1534: x_pre_tax_irr => x_pre_tax_irr,
1535: x_return_status => x_return_status,

Line 1618: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

1614: x_msg_data => x_msg_data,
1615: p_chr_id => l_khr_id,
1616: p_trx_number => p_transaction_number);
1617:
1618: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1619: RAISE OKL_API.G_EXCEPTION_ERROR;
1620: ELSIF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
1621: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1622: END IF;

Line 1619: RAISE OKL_API.G_EXCEPTION_ERROR;

1615: p_chr_id => l_khr_id,
1616: p_trx_number => p_transaction_number);
1617:
1618: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1619: RAISE OKL_API.G_EXCEPTION_ERROR;
1620: ELSIF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
1621: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1622: END IF;
1623: --end srsreeni for bug 5699923

Line 1620: ELSIF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

1616: p_trx_number => p_transaction_number);
1617:
1618: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1619: RAISE OKL_API.G_EXCEPTION_ERROR;
1620: ELSIF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
1621: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1622: END IF;
1623: --end srsreeni for bug 5699923
1624:

Line 1621: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1617:
1618: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1619: RAISE OKL_API.G_EXCEPTION_ERROR;
1620: ELSIF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
1621: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1622: END IF;
1623: --end srsreeni for bug 5699923
1624:
1625: -- Start of wraper code generated automatically by Debug code generator for OKL_LA_STREAM_PVT.process_streams

Line 1714: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)

1710: END;
1711: END IF;
1712: -- End of wraper code generated automatically by Debug code generator for OKL_SIF_RETS_PUB.update_sif_rets
1713:
1714: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)
1715: THEN
1716: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1717: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1718: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1716: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1712: -- End of wraper code generated automatically by Debug code generator for OKL_SIF_RETS_PUB.update_sif_rets
1713:
1714: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)
1715: THEN
1716: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1717: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1718: RAISE OKL_API.G_EXCEPTION_ERROR;
1719: END IF;
1720: END LOOP;

Line 1717: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1713:
1714: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)
1715: THEN
1716: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1717: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1718: RAISE OKL_API.G_EXCEPTION_ERROR;
1719: END IF;
1720: END LOOP;
1721: -- update the status in the In bound Interface Tables

Line 1718: RAISE OKL_API.G_EXCEPTION_ERROR;

1714: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)
1715: THEN
1716: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1717: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1718: RAISE OKL_API.G_EXCEPTION_ERROR;
1719: END IF;
1720: END LOOP;
1721: -- update the status in the In bound Interface Tables
1722: lp_sifv_rec.date_processed := to_date(to_char(SYSDATE,'YYYYMMDD HH24MISS'), 'YYYYMMDD HH24MISS');

Line 1768: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

1764:
1765: END IF;
1766: -- Bug 4196515: Emd
1767:
1768: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1769: x_msg_data => x_msg_data);
1770:
1771: EXCEPTION
1772: WHEN G_EXCEPTION_ERROR

Line 1778: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

1774: IF(stream_data_csr%ISOPEN)
1775: THEN
1776: CLOSE stream_data_csr;
1777: END IF;
1778: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1779: p_pkg_name => G_PKG_NAME,
1780: p_exc_name => G_EXC_NAME_ERROR,
1781: x_msg_count => x_msg_count,
1782: x_msg_data => x_msg_data,

Line 1789: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

1785: IF(stream_data_csr%ISOPEN)
1786: THEN
1787: CLOSE stream_data_csr;
1788: END IF;
1789: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1790: p_pkg_name => G_PKG_NAME,
1791: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
1792: x_msg_count => x_msg_count,
1793: x_msg_data => x_msg_data,

Line 1800: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

1796: IF(stream_data_csr%ISOPEN)
1797: THEN
1798: CLOSE stream_data_csr;
1799: END IF;
1800: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1801: p_pkg_name => G_PKG_NAME,
1802: p_exc_name => G_EXC_NAME_OTHERS,
1803: x_msg_count => x_msg_count,
1804: x_msg_data => x_msg_data,

Line 1878: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

1874: x_return_status := G_RET_STS_UNEXP_ERROR;
1875: WHEN OTHERS THEN
1876: x_return_status := G_RET_STS_UNEXP_ERROR;
1877: -- store SQL error message on message stack for caller
1878: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1879: p_msg_name => G_UNEXPECTED_ERROR,
1880: p_token1 => G_SQLCODE_TOKEN,
1881: p_token1_value => sqlcode,
1882: p_token2 => G_SQLERRM_TOKEN,

Line 2093: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2089: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPSRB.pls call OKL_SIF_RETS_PUB.update_sif_rets ');
2090: END;
2091: END IF;
2092: -- End of wraper code generated automatically by Debug code generator for OKL_SIF_RETS_PUB.update_sif_rets
2093: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2094: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2095: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2096: RAISE OKL_API.G_EXCEPTION_ERROR;
2097: END IF;

Line 2094: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2090: END;
2091: END IF;
2092: -- End of wraper code generated automatically by Debug code generator for OKL_SIF_RETS_PUB.update_sif_rets
2093: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2094: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2095: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2096: RAISE OKL_API.G_EXCEPTION_ERROR;
2097: END IF;
2098: END LOOP;

Line 2095: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

2091: END IF;
2092: -- End of wraper code generated automatically by Debug code generator for OKL_SIF_RETS_PUB.update_sif_rets
2093: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2094: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2095: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2096: RAISE OKL_API.G_EXCEPTION_ERROR;
2097: END IF;
2098: END LOOP;
2099: -- update the status in the In bound Interface Tables

Line 2096: RAISE OKL_API.G_EXCEPTION_ERROR;

2092: -- End of wraper code generated automatically by Debug code generator for OKL_SIF_RETS_PUB.update_sif_rets
2093: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2094: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2095: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2096: RAISE OKL_API.G_EXCEPTION_ERROR;
2097: END IF;
2098: END LOOP;
2099: -- update the status in the In bound Interface Tables
2100: FOR sif_data in sif_data_csr(p_transaction_number)

Line 2230: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,

2226: WHERE
2227:
2228: SIFB.TRANSACTION_NUMBER = p_trx_number;
2229: BEGIN
2230: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
2231: p_pkg_name => 'OKL_PROCESS_STREAMS_PVT',
2232: p_init_msg_list => p_init_msg_list,
2233: l_api_version => l_api_version,
2234: p_api_version => p_api_version,

Line 2358: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

2354: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
2355: RAISE G_EXCEPTION_ERROR;
2356: END IF;
2357: x_return_status := l_return_status;
2358: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
2359: x_msg_data => x_msg_data);
2360: EXCEPTION
2361: WHEN G_EXCEPTION_ERROR THEN
2362: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

Line 2362: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

2358: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
2359: x_msg_data => x_msg_data);
2360: EXCEPTION
2361: WHEN G_EXCEPTION_ERROR THEN
2362: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
2363: p_pkg_name => G_PKG_NAME,
2364: p_exc_name => G_EXC_NAME_ERROR,
2365: x_msg_count => x_msg_count,
2366: x_msg_data => x_msg_data,

Line 2369: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

2365: x_msg_count => x_msg_count,
2366: x_msg_data => x_msg_data,
2367: p_api_type => '_PVT');
2368: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
2369: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
2370: p_pkg_name => G_PKG_NAME,
2371: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
2372: x_msg_count => x_msg_count,
2373: x_msg_data => x_msg_data,

Line 2376: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

2372: x_msg_count => x_msg_count,
2373: x_msg_data => x_msg_data,
2374: p_api_type => '_PVT');
2375: WHEN OTHERS THEN
2376: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
2377: p_pkg_name => G_PKG_NAME,
2378: p_exc_name => G_EXC_NAME_OTHERS,
2379: x_msg_count => x_msg_count,
2380: x_msg_data => x_msg_data,

Line 2472: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,

2468: OKL_STREAM_INTERFACES SIFB
2469: WHERE
2470: SIFB.TRANSACTION_NUMBER = p_trx_number;
2471: BEGIN
2472: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
2473: p_pkg_name => 'OKL_PROCESS_STREAMS_PVT',
2474: p_init_msg_list => p_init_msg_list,
2475: l_api_version => l_api_version,
2476: p_api_version => p_api_version,

Line 2605: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

2601: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
2602: RAISE G_EXCEPTION_ERROR;
2603: END IF;
2604: x_return_status := l_return_status;
2605: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
2606: x_msg_data => x_msg_data);
2607: EXCEPTION
2608: WHEN G_EXCEPTION_ERROR THEN
2609: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

Line 2609: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

2605: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
2606: x_msg_data => x_msg_data);
2607: EXCEPTION
2608: WHEN G_EXCEPTION_ERROR THEN
2609: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
2610: p_pkg_name => G_PKG_NAME,
2611: p_exc_name => G_EXC_NAME_ERROR,
2612: x_msg_count => x_msg_count,
2613: x_msg_data => x_msg_data,

Line 2616: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

2612: x_msg_count => x_msg_count,
2613: x_msg_data => x_msg_data,
2614: p_api_type => '_PVT');
2615: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
2616: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
2617: p_pkg_name => G_PKG_NAME,
2618: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
2619: x_msg_count => x_msg_count,
2620: x_msg_data => x_msg_data,

Line 2624: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

2620: x_msg_data => x_msg_data,
2621: p_api_type => '_PVT');
2622: WHEN OTHERS THEN
2623:
2624: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
2625: p_pkg_name => G_PKG_NAME,
2626: p_exc_name => G_EXC_NAME_OTHERS,
2627: x_msg_count => x_msg_count,
2628: x_msg_data => x_msg_data,

Line 2789: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,

2785: l_stub_days NUMBER;
2786: --kthiruva - End of Changes for VR build
2787:
2788: BEGIN
2789: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
2790: p_pkg_name => 'OKL_PROCESS_STREAMS_PVT',
2791: p_init_msg_list => p_init_msg_list,
2792: l_api_version => l_api_version,
2793: p_api_version => p_api_version,

Line 2968: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

2964: RAISE G_EXCEPTION_ERROR;
2965: END IF;
2966: END IF;
2967: x_return_status := l_return_status;
2968: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
2969: x_msg_data => x_msg_data);
2970: EXCEPTION
2971: WHEN G_EXCEPTION_ERROR THEN
2972: --Added by kthiruva on 02-Dec-2005

Line 2990: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

2986: THEN
2987: CLOSE get_freq_csr;
2988: END IF;
2989: --Bug 4878162 - End of Changes
2990: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
2991: p_pkg_name => G_PKG_NAME,
2992: p_exc_name => G_EXC_NAME_ERROR,
2993: x_msg_count => x_msg_count,
2994: x_msg_data => x_msg_data,

Line 3015: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

3011: THEN
3012: CLOSE get_freq_csr;
3013: END IF;
3014: --Bug 4878162 - End of Changes
3015: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
3016: p_pkg_name => G_PKG_NAME,
3017: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
3018: x_msg_count => x_msg_count,
3019: x_msg_data => x_msg_data,

Line 3040: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

3036: THEN
3037: CLOSE get_freq_csr;
3038: END IF;
3039: --Bug 4878162 - End of Changes
3040: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
3041: p_pkg_name => G_PKG_NAME,
3042: p_exc_name => G_EXC_NAME_OTHERS,
3043: x_msg_count => x_msg_count,
3044: x_msg_data => x_msg_data,

Line 3276: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,

3272: level_indx_count NUMBER := 1;
3273: asset_indx_number NUMBER ;
3274:
3275: BEGIN
3276: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
3277: p_pkg_name => 'OKL_PROCESS_STREAMS_PVT',
3278: p_init_msg_list => p_init_msg_list,
3279: l_api_version => l_api_version,
3280: p_api_version => p_api_version,

Line 3487: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

3483: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
3484: RAISE G_EXCEPTION_ERROR;
3485: END IF;
3486: x_return_status := l_return_status;
3487: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
3488: x_msg_data => x_msg_data);
3489: EXCEPTION
3490: WHEN G_EXCEPTION_ERROR THEN
3491: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

Line 3491: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

3487: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
3488: x_msg_data => x_msg_data);
3489: EXCEPTION
3490: WHEN G_EXCEPTION_ERROR THEN
3491: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
3492: p_pkg_name => G_PKG_NAME,
3493: p_exc_name => G_EXC_NAME_ERROR,
3494: x_msg_count => x_msg_count,
3495: x_msg_data => x_msg_data,

Line 3498: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

3494: x_msg_count => x_msg_count,
3495: x_msg_data => x_msg_data,
3496: p_api_type => '_PVT');
3497: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
3498: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
3499: p_pkg_name => G_PKG_NAME,
3500: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
3501: x_msg_count => x_msg_count,
3502: x_msg_data => x_msg_data,

Line 3505: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

3501: x_msg_count => x_msg_count,
3502: x_msg_data => x_msg_data,
3503: p_api_type => '_PVT');
3504: WHEN OTHERS THEN
3505: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
3506: p_pkg_name => G_PKG_NAME,
3507: p_exc_name => G_EXC_NAME_OTHERS,
3508: x_msg_count => x_msg_count,
3509: x_msg_data => x_msg_data,