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.

[Home] [Help]

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 1017: l_reporting_streams VARCHAR2(1) := OKL_API.G_FALSE;

1013: SIFB.ID = SFEB.SIF_ID AND
1014: transaction_number = p_trx_number AND
1015: SFE_TYPE = 'SFB' ORDER BY FEE_INDEX_NUMBER;
1016:
1017: l_reporting_streams VARCHAR2(1) := OKL_API.G_FALSE;
1018: l_process_yn VARCHAR2(1) := OKL_API.G_TRUE;
1019: l_chk_subsidy VARCHAR2(1) := 'x';
1020: -- smahapat addition end
1021: yield_csr yield_data_csr%ROWTYPE;

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

1014: transaction_number = p_trx_number AND
1015: SFE_TYPE = 'SFB' ORDER BY FEE_INDEX_NUMBER;
1016:
1017: l_reporting_streams VARCHAR2(1) := OKL_API.G_FALSE;
1018: l_process_yn VARCHAR2(1) := OKL_API.G_TRUE;
1019: l_chk_subsidy VARCHAR2(1) := 'x';
1020: -- smahapat addition end
1021: yield_csr yield_data_csr%ROWTYPE;
1022: stream_csr stream_data_csr%ROWTYPE;

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

1078: l_first_rec CHAR := 'T';
1079:
1080: G_RND_DIFF_LOOKUP_TYPE CONSTANT fnd_lookups.lookup_type%TYPE := 'OKL_STRM_APPLY_ROUNDING_DIFF';
1081: G_NO_MATCH_REC CONSTANT VARCHAR2(30) := 'OKL_LLA_NO_MATCHING_RECORD';
1082: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
1083: -- Bug 4196515: End
1084:
1085: --Added by kthiruva on 15-May-2005 for Streams Performance
1086: --Bug 4346646-Start of Changes

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

1102: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inside procedure process_stream_results');
1103: END IF;
1104:
1105:
1106: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
1107: p_pkg_name => 'OKL_PROCESS_STREAMS_PVT',
1108: p_init_msg_list => p_init_msg_list,
1109: l_api_version => l_api_version,
1110: p_api_version => p_api_version,

Line 1182: l_reporting_streams := OKL_API.G_TRUE;

1178: FOR reporting_streams_data IN reporting_streams_csr(p_transaction_number)
1179: LOOP
1180: IF (reporting_streams_data.purpose_code = G_PURPOSE_CODE_REPORT)
1181: THEN
1182: l_reporting_streams := OKL_API.G_TRUE;
1183: END IF;
1184: END LOOP;
1185:
1186: -- Bug 4196515: Start

Line 1205: IF (l_reporting_streams = OKL_API.G_TRUE)

1201: l_stmv_rec.say_code := G_STREAM_ACTIVITY_WORK;
1202: l_stmv_rec.active_yn := G_STREAM_ACTIVE_YN;
1203: l_stmv_rec.date_working := SYSDATE ;
1204: l_stmv_rec.comments := l_comments ;
1205: IF (l_reporting_streams = OKL_API.G_TRUE)
1206: THEN
1207: l_stmv_rec.purpose_code := G_PURPOSE_CODE_REPORT;
1208: END IF;
1209: l_khr_id := TO_CHAR(stream_csr.khr_id);

Line 1319: IF (l_reporting_streams = OKL_API.G_TRUE)

1315: l_stmv_tbl(i) := l_stmv_rec ;
1316: --Bug 4346646 - End of Changes
1317:
1318: -- smahapat 11/10/02 multi-gaap -- addition
1319: IF (l_reporting_streams = OKL_API.G_TRUE)
1320: THEN
1321: l_stmv_rec.purpose_code := G_PURPOSE_CODE_REPORT;
1322: END IF;
1323: -- smahapat addition end

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

1499:
1500: --start smahapat bugfix# 2790695
1501: --Generate accrual streams for service lines
1502: lx_pdt_parameter_rec := NULL;
1503: IF (l_reporting_streams = OKL_API.G_TRUE) THEN
1504: OPEN reporting_product_csr(p_transaction_number);
1505: FETCH reporting_product_csr INTO reporting_product_rec;
1506: CLOSE reporting_product_csr;
1507: --Added by kthiruva for Debug Logging

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

1523: --Added by kthiruva for Debug Logging
1524: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1525: 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);
1526: END IF;
1527: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1528: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1529: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1530: RAISE OKL_API.G_EXCEPTION_ERROR;
1531: END IF;

Line 1528: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1524: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1525: 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);
1526: END IF;
1527: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1528: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1529: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1530: RAISE OKL_API.G_EXCEPTION_ERROR;
1531: END IF;
1532: END IF;

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

1525: 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);
1526: END IF;
1527: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1528: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1529: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1530: RAISE OKL_API.G_EXCEPTION_ERROR;
1531: END IF;
1532: END IF;
1533:

Line 1530: RAISE OKL_API.G_EXCEPTION_ERROR;

1526: END IF;
1527: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1528: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1529: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1530: RAISE OKL_API.G_EXCEPTION_ERROR;
1531: END IF;
1532: END IF;
1533:
1534: --Added by kthiruva for ESG Performance Improvement on 03-May-2005

Line 1551: p_compute_irr => OKL_API.G_FALSE,

1547: okl_stream_generator_pub.GENERATE_STREAMS(
1548: p_api_version => p_api_version,
1549: p_init_msg_list => p_init_msg_list,
1550: p_khr_id => l_khr_id,
1551: p_compute_irr => OKL_API.G_FALSE,
1552: p_generation_type => 'SERVICE_LINES',
1553: p_reporting_book_class => lx_pdt_parameter_rec.deal_type,
1554: x_pre_tax_irr => x_pre_tax_irr,
1555: x_return_status => x_return_status,

Line 1584: p_compute_irr => OKL_API.G_FALSE,

1580: okl_stream_generator_pub.GENERATE_STREAMS(
1581: p_api_version => p_api_version,
1582: p_init_msg_list => p_init_msg_list,
1583: p_khr_id => l_khr_id,
1584: p_compute_irr => OKL_API.G_FALSE,
1585: p_generation_type => 'RESIDUAL VALUE',
1586: p_reporting_book_class => lx_pdt_parameter_rec.deal_type,
1587: x_pre_tax_irr => x_pre_tax_irr,
1588: x_return_status => x_return_status,

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

1667: x_msg_data => x_msg_data,
1668: p_chr_id => l_khr_id,
1669: p_trx_number => p_transaction_number);
1670:
1671: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1672: RAISE OKL_API.G_EXCEPTION_ERROR;
1673: ELSIF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
1674: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1675: END IF;

Line 1672: RAISE OKL_API.G_EXCEPTION_ERROR;

1668: p_chr_id => l_khr_id,
1669: p_trx_number => p_transaction_number);
1670:
1671: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1672: RAISE OKL_API.G_EXCEPTION_ERROR;
1673: ELSIF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
1674: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1675: END IF;
1676: --end srsreeni for bug 5699923

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

1669: p_trx_number => p_transaction_number);
1670:
1671: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1672: RAISE OKL_API.G_EXCEPTION_ERROR;
1673: ELSIF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
1674: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1675: END IF;
1676: --end srsreeni for bug 5699923
1677:

Line 1674: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1670:
1671: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1672: RAISE OKL_API.G_EXCEPTION_ERROR;
1673: ELSIF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
1674: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1675: END IF;
1676: --end srsreeni for bug 5699923
1677:
1678: -- Start of wraper code generated automatically by Debug code generator for OKL_LA_STREAM_PVT.process_streams

Line 1767: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)

1763: END;
1764: END IF;
1765: -- End of wraper code generated automatically by Debug code generator for OKL_SIF_RETS_PUB.update_sif_rets
1766:
1767: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)
1768: THEN
1769: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1770: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1771: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1769: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1765: -- End of wraper code generated automatically by Debug code generator for OKL_SIF_RETS_PUB.update_sif_rets
1766:
1767: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)
1768: THEN
1769: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1770: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1771: RAISE OKL_API.G_EXCEPTION_ERROR;
1772: END IF;
1773: END LOOP;

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

1766:
1767: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)
1768: THEN
1769: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1770: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1771: RAISE OKL_API.G_EXCEPTION_ERROR;
1772: END IF;
1773: END LOOP;
1774: -- update the status in the In bound Interface Tables

Line 1771: RAISE OKL_API.G_EXCEPTION_ERROR;

1767: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)
1768: THEN
1769: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1770: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1771: RAISE OKL_API.G_EXCEPTION_ERROR;
1772: END IF;
1773: END LOOP;
1774: -- update the status in the In bound Interface Tables
1775: lp_sifv_rec.date_processed := to_date(to_char(SYSDATE,'YYYYMMDD HH24MISS'), 'YYYYMMDD HH24MISS');

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

1817:
1818: END IF;
1819: -- Bug 4196515: Emd
1820:
1821: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1822: x_msg_data => x_msg_data);
1823:
1824: EXCEPTION
1825: WHEN G_EXCEPTION_ERROR

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

1827: IF(stream_data_csr%ISOPEN)
1828: THEN
1829: CLOSE stream_data_csr;
1830: END IF;
1831: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1832: p_pkg_name => G_PKG_NAME,
1833: p_exc_name => G_EXC_NAME_ERROR,
1834: x_msg_count => x_msg_count,
1835: x_msg_data => x_msg_data,

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

1838: IF(stream_data_csr%ISOPEN)
1839: THEN
1840: CLOSE stream_data_csr;
1841: END IF;
1842: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1843: p_pkg_name => G_PKG_NAME,
1844: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
1845: x_msg_count => x_msg_count,
1846: x_msg_data => x_msg_data,

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

1849: IF(stream_data_csr%ISOPEN)
1850: THEN
1851: CLOSE stream_data_csr;
1852: END IF;
1853: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1854: p_pkg_name => G_PKG_NAME,
1855: p_exc_name => G_EXC_NAME_OTHERS,
1856: x_msg_count => x_msg_count,
1857: x_msg_data => x_msg_data,

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

1927: x_return_status := G_RET_STS_UNEXP_ERROR;
1928: WHEN OTHERS THEN
1929: x_return_status := G_RET_STS_UNEXP_ERROR;
1930: -- store SQL error message on message stack for caller
1931: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1932: p_msg_name => G_UNEXPECTED_ERROR,
1933: p_token1 => G_SQLCODE_TOKEN,
1934: p_token1_value => sqlcode,
1935: p_token2 => G_SQLERRM_TOKEN,

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

2142: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPSRB.pls call OKL_SIF_RETS_PUB.update_sif_rets ');
2143: END;
2144: END IF;
2145: -- End of wraper code generated automatically by Debug code generator for OKL_SIF_RETS_PUB.update_sif_rets
2146: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2147: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2148: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2149: RAISE OKL_API.G_EXCEPTION_ERROR;
2150: END IF;

Line 2147: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2143: END;
2144: END IF;
2145: -- End of wraper code generated automatically by Debug code generator for OKL_SIF_RETS_PUB.update_sif_rets
2146: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2147: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2148: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2149: RAISE OKL_API.G_EXCEPTION_ERROR;
2150: END IF;
2151: END LOOP;

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

2144: END IF;
2145: -- End of wraper code generated automatically by Debug code generator for OKL_SIF_RETS_PUB.update_sif_rets
2146: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2147: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2148: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2149: RAISE OKL_API.G_EXCEPTION_ERROR;
2150: END IF;
2151: END LOOP;
2152: -- update the status in the In bound Interface Tables

Line 2149: RAISE OKL_API.G_EXCEPTION_ERROR;

2145: -- End of wraper code generated automatically by Debug code generator for OKL_SIF_RETS_PUB.update_sif_rets
2146: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2147: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2148: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2149: RAISE OKL_API.G_EXCEPTION_ERROR;
2150: END IF;
2151: END LOOP;
2152: -- update the status in the In bound Interface Tables
2153: FOR sif_data in sif_data_csr(p_transaction_number)

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

2279: WHERE
2280:
2281: SIFB.TRANSACTION_NUMBER = p_trx_number;
2282: BEGIN
2283: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
2284: p_pkg_name => 'OKL_PROCESS_STREAMS_PVT',
2285: p_init_msg_list => p_init_msg_list,
2286: l_api_version => l_api_version,
2287: p_api_version => p_api_version,

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

2407: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
2408: RAISE G_EXCEPTION_ERROR;
2409: END IF;
2410: x_return_status := l_return_status;
2411: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
2412: x_msg_data => x_msg_data);
2413: EXCEPTION
2414: WHEN G_EXCEPTION_ERROR THEN
2415: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

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

2411: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
2412: x_msg_data => x_msg_data);
2413: EXCEPTION
2414: WHEN G_EXCEPTION_ERROR THEN
2415: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
2416: p_pkg_name => G_PKG_NAME,
2417: p_exc_name => G_EXC_NAME_ERROR,
2418: x_msg_count => x_msg_count,
2419: x_msg_data => x_msg_data,

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

2418: x_msg_count => x_msg_count,
2419: x_msg_data => x_msg_data,
2420: p_api_type => '_PVT');
2421: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
2422: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
2423: p_pkg_name => G_PKG_NAME,
2424: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
2425: x_msg_count => x_msg_count,
2426: x_msg_data => x_msg_data,

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

2425: x_msg_count => x_msg_count,
2426: x_msg_data => x_msg_data,
2427: p_api_type => '_PVT');
2428: WHEN OTHERS THEN
2429: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
2430: p_pkg_name => G_PKG_NAME,
2431: p_exc_name => G_EXC_NAME_OTHERS,
2432: x_msg_count => x_msg_count,
2433: x_msg_data => x_msg_data,

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

2521: OKL_STREAM_INTERFACES SIFB
2522: WHERE
2523: SIFB.TRANSACTION_NUMBER = p_trx_number;
2524: BEGIN
2525: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
2526: p_pkg_name => 'OKL_PROCESS_STREAMS_PVT',
2527: p_init_msg_list => p_init_msg_list,
2528: l_api_version => l_api_version,
2529: p_api_version => p_api_version,

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

2654: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
2655: RAISE G_EXCEPTION_ERROR;
2656: END IF;
2657: x_return_status := l_return_status;
2658: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
2659: x_msg_data => x_msg_data);
2660: EXCEPTION
2661: WHEN G_EXCEPTION_ERROR THEN
2662: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

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

2658: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
2659: x_msg_data => x_msg_data);
2660: EXCEPTION
2661: WHEN G_EXCEPTION_ERROR THEN
2662: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
2663: p_pkg_name => G_PKG_NAME,
2664: p_exc_name => G_EXC_NAME_ERROR,
2665: x_msg_count => x_msg_count,
2666: x_msg_data => x_msg_data,

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

2665: x_msg_count => x_msg_count,
2666: x_msg_data => x_msg_data,
2667: p_api_type => '_PVT');
2668: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
2669: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
2670: p_pkg_name => G_PKG_NAME,
2671: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
2672: x_msg_count => x_msg_count,
2673: x_msg_data => x_msg_data,

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

2673: x_msg_data => x_msg_data,
2674: p_api_type => '_PVT');
2675: WHEN OTHERS THEN
2676:
2677: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
2678: p_pkg_name => G_PKG_NAME,
2679: p_exc_name => G_EXC_NAME_OTHERS,
2680: x_msg_count => x_msg_count,
2681: x_msg_data => x_msg_data,

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

2838: l_stub_days NUMBER;
2839: --kthiruva - End of Changes for VR build
2840:
2841: BEGIN
2842: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
2843: p_pkg_name => 'OKL_PROCESS_STREAMS_PVT',
2844: p_init_msg_list => p_init_msg_list,
2845: l_api_version => l_api_version,
2846: p_api_version => p_api_version,

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

3017: RAISE G_EXCEPTION_ERROR;
3018: END IF;
3019: END IF;
3020: x_return_status := l_return_status;
3021: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
3022: x_msg_data => x_msg_data);
3023: EXCEPTION
3024: WHEN G_EXCEPTION_ERROR THEN
3025: --Added by kthiruva on 02-Dec-2005

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

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

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

3064: THEN
3065: CLOSE get_freq_csr;
3066: END IF;
3067: --Bug 4878162 - End of Changes
3068: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
3069: p_pkg_name => G_PKG_NAME,
3070: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
3071: x_msg_count => x_msg_count,
3072: x_msg_data => x_msg_data,

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

3089: THEN
3090: CLOSE get_freq_csr;
3091: END IF;
3092: --Bug 4878162 - End of Changes
3093: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
3094: p_pkg_name => G_PKG_NAME,
3095: p_exc_name => G_EXC_NAME_OTHERS,
3096: x_msg_count => x_msg_count,
3097: x_msg_data => x_msg_data,

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

3349: l_child_trx_id NUMBER;
3350: --end bkatraga
3351:
3352: BEGIN
3353: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
3354: p_pkg_name => 'OKL_PROCESS_STREAMS_PVT',
3355: p_init_msg_list => p_init_msg_list,
3356: l_api_version => l_api_version,
3357: p_api_version => p_api_version,

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

3506: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
3507: RAISE G_EXCEPTION_ERROR;
3508: END IF;
3509: x_return_status := l_return_status;
3510: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
3511: x_msg_data => x_msg_data);
3512: EXCEPTION
3513: WHEN G_EXCEPTION_ERROR THEN
3514: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

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

3510: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
3511: x_msg_data => x_msg_data);
3512: EXCEPTION
3513: WHEN G_EXCEPTION_ERROR THEN
3514: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
3515: p_pkg_name => G_PKG_NAME,
3516: p_exc_name => G_EXC_NAME_ERROR,
3517: x_msg_count => x_msg_count,
3518: x_msg_data => x_msg_data,

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

3517: x_msg_count => x_msg_count,
3518: x_msg_data => x_msg_data,
3519: p_api_type => '_PVT');
3520: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
3521: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
3522: p_pkg_name => G_PKG_NAME,
3523: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
3524: x_msg_count => x_msg_count,
3525: x_msg_data => x_msg_data,

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

3524: x_msg_count => x_msg_count,
3525: x_msg_data => x_msg_data,
3526: p_api_type => '_PVT');
3527: WHEN OTHERS THEN
3528: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
3529: p_pkg_name => G_PKG_NAME,
3530: p_exc_name => G_EXC_NAME_OTHERS,
3531: x_msg_count => x_msg_count,
3532: x_msg_data => x_msg_data,