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

Line 134: okl_api.end_activity(

130: x_msg_out VARCHAR2(2000);
131:
132: BEGIN
133:
134: okl_api.end_activity(
135: X_msg_count => x_msg_count,
136: X_msg_data => x_msg_data
137: );
138:

Line 357: okl_api.set_message(

353: IF rulv_csr%ISOPEN THEN
354: CLOSE rulv_csr;
355: END IF;
356: x_return_status := OKC_API.G_RET_STS_ERROR;
357: okl_api.set_message(
358: G_APP_NAME,
359: G_OKL_RULE_ERROR
360: );
361:

Line 364: okl_api.set_message(

360: );
361:
362: WHEN OTHERS THEN
363: x_return_status := OKC_API.G_RET_STS_ERROR;
364: okl_api.set_message(
365: G_APP_NAME,
366: G_UNEXPECTED_ERROR,
367: 'OKL_SQLCODE',
368: SQLCODE,

Line 437: okl_api.set_message(

433: IF party_csr%ISOPEN THEN
434: CLOSE party_csr;
435: END IF;
436:
437: okl_api.set_message(
438: G_APP_NAME,
439: G_OKL_PARTY_ROLE_ERROR
440: );
441:

Line 444: okl_api.set_message(

440: );
441:
442: WHEN OTHERS THEN
443: x_return_status := OKC_API.G_RET_STS_ERROR;
444: okl_api.set_message(
445: G_APP_NAME,
446: G_UNEXPECTED_ERROR,
447: 'OKL_SQLCODE',
448: SQLCODE,

Line 512: okl_api.set_message(

508: IF header_csr%ISOPEN THEN
509: CLOSE header_csr;
510: END IF;
511: x_return_status := OKC_API.G_RET_STS_ERROR;
512: okl_api.set_message(
513: G_APP_NAME,
514: G_OKL_NO_CONTRACT_HEADER
515: );
516: WHEN OTHERS THEN

Line 518: okl_api.set_message(

514: G_OKL_NO_CONTRACT_HEADER
515: );
516: WHEN OTHERS THEN
517: x_return_status := OKC_API.G_RET_STS_ERROR;
518: okl_api.set_message(
519: G_APP_NAME,
520: G_UNEXPECTED_ERROR,
521: 'OKL_SQLCODE',
522: SQLCODE,

Line 562: x_return_status := OKL_API.G_RET_STS_SUCCESS;

558: IF (G_DEBUG_ENABLED = 'Y') THEN
559: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
560: END IF;
561:
562: x_return_status := OKL_API.G_RET_STS_SUCCESS;
563: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
564: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
565: END IF;
566:

Line 580: okl_api.set_message(

576:
577: EXCEPTION
578: WHEN OTHERS THEN
579: x_return_status := OKC_API.G_RET_STS_ERROR;
580: okl_api.set_message(
581: G_APP_NAME,
582: G_UNEXPECTED_ERROR,
583: 'OKL_SQLCODE',
584: SQLCODE,

Line 621: x_return_status := OKL_API.G_RET_STS_SUCCESS;

617: BEGIN
618: IF (G_DEBUG_ENABLED = 'Y') THEN
619: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
620: END IF;
621: x_return_status := OKL_API.G_RET_STS_SUCCESS;
622: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
623: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
624: END IF;
625:

Line 647: x_return_status := OKL_API.G_RET_STS_ERROR;

643: IF cust_acc_csr%ISOPEN THEN
644: CLOSE cust_acc_csr;
645: END IF;
646:
647: x_return_status := OKL_API.G_RET_STS_ERROR;
648:
649: okl_api.set_message(
650: G_APP_NAME,
651: G_OKL_RULE_ERROR

Line 649: okl_api.set_message(

645: END IF;
646:
647: x_return_status := OKL_API.G_RET_STS_ERROR;
648:
649: okl_api.set_message(
650: G_APP_NAME,
651: G_OKL_RULE_ERROR
652: );
653:

Line 656: okl_api.set_message(

652: );
653:
654: WHEN OTHERS THEN
655: x_return_status := OKC_API.G_RET_STS_ERROR;
656: okl_api.set_message(
657: G_APP_NAME,
658: G_UNEXPECTED_ERROR,
659: 'OKL_SQLCODE',
660: SQLCODE,

Line 696: x_return_status := OKL_API.G_RET_STS_SUCCESS;

692: BEGIN
693: IF (G_DEBUG_ENABLED = 'Y') THEN
694: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
695: END IF;
696: x_return_status := OKL_API.G_RET_STS_SUCCESS;
697: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
698: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
699: END IF;
700:

Line 722: x_return_status := OKL_API.G_RET_STS_ERROR;

718: IF bill_to_csr%ISOPEN THEN
719: CLOSE bill_to_csr;
720: END IF;
721:
722: x_return_status := OKL_API.G_RET_STS_ERROR;
723:
724: okl_api.set_message(
725: G_APP_NAME,
726: G_OKL_RULE_ERROR

Line 724: okl_api.set_message(

720: END IF;
721:
722: x_return_status := OKL_API.G_RET_STS_ERROR;
723:
724: okl_api.set_message(
725: G_APP_NAME,
726: G_OKL_RULE_ERROR
727: );
728:

Line 731: okl_api.set_message(

727: );
728:
729: WHEN OTHERS THEN
730: x_return_status := OKC_API.G_RET_STS_ERROR;
731: okl_api.set_message(
732: G_APP_NAME,
733: G_UNEXPECTED_ERROR,
734: 'OKL_SQLCODE',
735: SQLCODE,

Line 811: okl_api.set_message(

807:
808: OPEN qcl_csr ('DEFAULT QA CHECK LIST');
809: FETCH qcl_csr INTO l_qcl_id;
810: IF qcl_csr%NOTFOUND THEN
811: okl_api.set_message(
812: G_APP_NAME,
813: G_INVALID_VALUE,
814: 'COL_NAME',
815: 'QA CCHECK NAME'

Line 828: okl_api.set_message(

824:
825: OPEN wf_csr('OKCAUKAP');
826: FETCH wf_csr INTO l_pdf_id;
827: IF wf_csr%NOTFOUND THEN
828: okl_api.set_message(
829: G_APP_NAME,
830: G_INVALID_VALUE,
831: 'COL_NAME',
832: 'WORKFLOW NAME'

Line 844: okl_api.set_message(

840: /* use rule_id instead
841: OPEN ra_rule_csr('IMMEDIATE');
842: FETCH ra_rule_csr INTO l_rule_id;
843: IF ra_rule_csr%NOTFOUND THEN
844: okl_api.set_message(
845: G_APP_NAME,
846: G_INVALID_VALUE,
847: 'COL_NAME',
848: 'ACCOUNTING RULE TYPE'

Line 860: okl_api.set_message(

856: /* use rule_id instead
857: OPEN ra_rule_csr('ARREARS INVOICE');
858: FETCH ra_rule_csr INTO l_rule_id;
859: IF ra_rule_csr%NOTFOUND THEN
860: okl_api.set_message(
861: G_APP_NAME,
862: G_INVALID_VALUE,
863: 'COL_NAME',
864: 'INVOICE RULE TYPE'

Line 951: okl_api.set_message(

947: x_return_status := OKC_API.G_RET_STS_ERROR;
948:
949: WHEN OTHERS THEN
950: x_return_status := OKC_API.G_RET_STS_ERROR;
951: okl_api.set_message(
952: G_APP_NAME,
953: G_UNEXPECTED_ERROR,
954: 'OKL_SQLCODE',
955: SQLCODE,

Line 1059: okl_api.set_message(

1055: /* use rule_id instead
1056: OPEN ra_rule_csr('IMMEDIATE');
1057: FETCH ra_rule_csr INTO l_rule_id;
1058: IF ra_rule_csr%NOTFOUND THEN
1059: okl_api.set_message(
1060: G_APP_NAME,
1061: G_INVALID_VALUE,
1062: 'COL_NAME',
1063: 'ACCOUNTING RULE TYPE'

Line 1076: okl_api.set_message(

1072: /* use rule_id instead
1073: OPEN ra_rule_csr('ARREARS INVOICE');
1074: FETCH ra_rule_csr INTO l_rule_id;
1075: IF ra_rule_csr%NOTFOUND THEN
1076: okl_api.set_message(
1077: G_APP_NAME,
1078: G_INVALID_VALUE,
1079: 'COL_NAME',
1080: 'INVOICE RULE TYPE'

Line 1234: okl_api.set_message(

1230: x_return_status := OKC_API.G_RET_STS_ERROR;
1231:
1232: WHEN OTHERS THEN
1233: x_return_status := OKC_API.G_RET_STS_ERROR;
1234: okl_api.set_message(
1235: G_APP_NAME,
1236: G_UNEXPECTED_ERROR,
1237: 'OKL_SQLCODE',
1238: SQLCODE,

Line 1330: okl_api.set_message(

1326: x_return_status := OKC_API.G_RET_STS_ERROR;
1327:
1328: WHEN OTHERS THEN
1329: x_return_status := OKC_API.G_RET_STS_ERROR;
1330: okl_api.set_message(
1331: G_APP_NAME,
1332: G_UNEXPECTED_ERROR,
1333: 'OKL_SQLCODE',
1334: SQLCODE,

Line 1398: okl_api.set_message(

1394: IF top_csr%ISOPEN THEN
1395: CLOSE top_csr;
1396: END IF;
1397: x_return_status := OKC_API.G_RET_STS_ERROR;
1398: okl_api.set_message(
1399: G_APP_NAME,
1400: G_OKL_NO_TOP_LINE,
1401: 'LINE_NUM',
1402: p_link_asset_line_no

Line 1406: okl_api.set_message(

1402: p_link_asset_line_no
1403: );
1404: WHEN OTHERS THEN
1405: x_return_status := OKC_API.G_RET_STS_ERROR;
1406: okl_api.set_message(
1407: G_APP_NAME,
1408: G_UNEXPECTED_ERROR,
1409: 'OKL_SQLCODE',
1410: SQLCODE,

Line 1434: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1430: x_msg_data OUT NOCOPY VARCHAR2,
1431: p_okl_usage_line_id IN OKC_K_LINES_V.ID%TYPE,
1432: p_oks_usage_line_id IN OKC_K_LINES_V.ID%TYPE) is
1433:
1434: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1435: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_COUNTER_INSTANCE';
1436: l_api_version CONSTANT NUMBER := 1.0;
1437:
1438:

Line 1535: --p_init_msg_list => OKL_API.G_FALSE,

1531: ---------------------------------------------------------------------
1532: --call the csi api to update counter
1533: /*--CS_COUNTERS_PUB.UPDATE_COUNTER
1534: --(p_api_version => 1.0,
1535: --p_init_msg_list => OKL_API.G_FALSE,
1536: --p_commit => OKL_API.G_FALSE,
1537: --x_return_status => x_return_status,
1538: --x_msg_count => x_msg_count,
1539: --x_msg_data => x_msg_data,

Line 1536: --p_commit => OKL_API.G_FALSE,

1532: --call the csi api to update counter
1533: /*--CS_COUNTERS_PUB.UPDATE_COUNTER
1534: --(p_api_version => 1.0,
1535: --p_init_msg_list => OKL_API.G_FALSE,
1536: --p_commit => OKL_API.G_FALSE,
1537: --x_return_status => x_return_status,
1538: --x_msg_count => x_msg_count,
1539: --x_msg_data => x_msg_data,
1540: --p_ctr_id => l_ctr_rec.counter_id,

Line 1543: --p_cascade_upd_to_instances => OKL_API.G_FALSE,

1539: --x_msg_data => x_msg_data,
1540: --p_ctr_id => l_ctr_rec.counter_id,
1541: --p_object_version_number => l_ctr_rec.object_version_number,
1542: --p_ctr_rec => l_csi_ctr_rec,
1543: --p_cascade_upd_to_instances => OKL_API.G_FALSE,
1544: --x_object_version_number => l_object_version_number);
1545: */
1546: CSI_COUNTER_PUB.update_counter(
1547: p_api_version => 1.0

Line 1548: ,p_init_msg_list => OKL_API.G_FALSE

1544: --x_object_version_number => l_object_version_number);
1545: */
1546: CSI_COUNTER_PUB.update_counter(
1547: p_api_version => 1.0
1548: ,p_init_msg_list => OKL_API.G_FALSE
1549: ,p_commit => OKL_API.G_FALSE
1550: ,p_validation_level => fnd_api.g_valid_level_full
1551: ,p_counter_instance_rec => l_counter_instance_rec
1552: ,P_ctr_properties_tbl => l_ctr_properties_tbl

Line 1549: ,p_commit => OKL_API.G_FALSE

1545: */
1546: CSI_COUNTER_PUB.update_counter(
1547: p_api_version => 1.0
1548: ,p_init_msg_list => OKL_API.G_FALSE
1549: ,p_commit => OKL_API.G_FALSE
1550: ,p_validation_level => fnd_api.g_valid_level_full
1551: ,p_counter_instance_rec => l_counter_instance_rec
1552: ,P_ctr_properties_tbl => l_ctr_properties_tbl
1553: ,P_counter_relationships_tbl => l_counter_relationships_tbl

Line 1560: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

1556: ,x_return_status => x_return_status
1557: ,x_msg_count => x_msg_count
1558: ,x_msg_data => x_msg_data
1559: );
1560: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
1561: RAISE ctr_exception;
1562: END IF;
1563:
1564: End Loop;

Line 1998: okl_api.set_message(

1994: END IF;
1995:
1996: -- check the presence of All lines in proper structure
1997: IF (l_link_asset_count = 0) THEN
1998: okl_api.set_message(
1999: G_APP_NAME,
2000: G_OKL_NO_LINK_ASSET_LINE
2001: );
2002: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2006: okl_api.set_message(

2002: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2003: END IF;
2004:
2005: IF (l_ib_count = 0) THEN
2006: okl_api.set_message(
2007: G_APP_NAME,
2008: G_OKL_NO_IB_LINE
2009: );
2010: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2014: okl_api.set_message(

2010: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2011: END IF;
2012:
2013: IF (l_counter_count = 0) THEN
2014: okl_api.set_message(
2015: G_APP_NAME,
2016: G_OKL_NO_COUNTER_INSTANCE
2017: );
2018: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2059: okl_api.set_message(

2055:
2056: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
2057:
2058: IF (l_usage_count = 0) THEN
2059: okl_api.set_message(
2060: G_APP_NAME,
2061: G_OKL_NO_USAGE_LINE
2062: );
2063: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2191: okl_api.set_message(

2187: x_return_status := OKC_API.G_RET_STS_ERROR;
2188:
2189: WHEN OTHERS THEN
2190: x_return_status := OKC_API.G_RET_STS_ERROR;
2191: okl_api.set_message(
2192: G_APP_NAME,
2193: G_UNEXPECTED_ERROR,
2194: 'OKL_SQLCODE',
2195: SQLCODE,

Line 2245: okl_api.set_message(

2241: OPEN item_csr(p_okl_usage_line_id);
2242: FETCH item_csr INTO l_item_line_id;
2243:
2244: IF item_csr%NOTFOUND THEN
2245: okl_api.set_message(
2246: G_APP_NAME,
2247: G_OKL_NO_ITEM_LINK
2248: );
2249: RAISE oks_line_failed;

Line 2302: okl_api.set_message(

2298: x_return_status := OKC_API.G_RET_STS_ERROR;
2299:
2300: WHEN OTHERS THEN
2301: x_return_status := OKC_API.G_RET_STS_ERROR;
2302: okl_api.set_message(
2303: G_APP_NAME,
2304: G_UNEXPECTED_ERROR,
2305: 'OKL_SQLCODE',
2306: SQLCODE,