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.OKC_REP_CONTRACT_PROCESS_PVT dependencies on OKC_API

Line 86: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

82: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION ,
83: G_MODULE||l_api_name,
84: 'Invalid Contract Id: '|| p_contract_id);
85: END IF;
86: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
87: p_msg_name => G_INVALID_CONTRACT_ID_MSG,
88: p_token1 => G_CONTRACT_ID_TOKEN,
89: p_token1_value => to_char(p_contract_id));
90: RAISE FND_API.G_EXC_ERROR;

Line 117: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

113: 'OKC_REP_UTIL_PVT.change_contract_status return status is: '
114: || x_return_status);
115: END IF;
116: -----------------------------------------------------
117: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
118: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
119: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
120: RAISE OKC_API.G_EXCEPTION_ERROR;
121: END IF;

Line 118: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

114: || x_return_status);
115: END IF;
116: -----------------------------------------------------
117: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
118: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
119: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
120: RAISE OKC_API.G_EXCEPTION_ERROR;
121: END IF;
122: --------------------------------------------------------

Line 119: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

115: END IF;
116: -----------------------------------------------------
117: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
118: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
119: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
120: RAISE OKC_API.G_EXCEPTION_ERROR;
121: END IF;
122: --------------------------------------------------------
123:

Line 120: RAISE OKC_API.G_EXCEPTION_ERROR;

116: -----------------------------------------------------
117: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
118: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
119: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
120: RAISE OKC_API.G_EXCEPTION_ERROR;
121: END IF;
122: --------------------------------------------------------
123:
124:

Line 147: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

143: 'OKC_REP_UTIL_PVT.add_approval_hist_record return status is: '
144: || x_return_status);
145: END IF;
146: -------------------------------------------------------
147: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
148: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
149: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
150: RAISE OKC_API.G_EXCEPTION_ERROR;
151: END IF;

Line 148: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

144: || x_return_status);
145: END IF;
146: -------------------------------------------------------
147: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
148: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
149: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
150: RAISE OKC_API.G_EXCEPTION_ERROR;
151: END IF;
152: --------------------------------------------------------

Line 149: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

145: END IF;
146: -------------------------------------------------------
147: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
148: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
149: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
150: RAISE OKC_API.G_EXCEPTION_ERROR;
151: END IF;
152: --------------------------------------------------------
153: -- Get the user key

Line 150: RAISE OKC_API.G_EXCEPTION_ERROR;

146: -------------------------------------------------------
147: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
148: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
149: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
150: RAISE OKC_API.G_EXCEPTION_ERROR;
151: END IF;
152: --------------------------------------------------------
153: -- Get the user key
154: l_user_key := l_contract_number || ':' || l_wf_sequence;

Line 281: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

277: --close cursors
278: IF (contract_csr%ISOPEN) THEN
279: CLOSE contract_csr ;
280: END IF;
281: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
282: p_msg_name => G_UNEXPECTED_ERROR,
283: p_token1 => G_SQLCODE_TOKEN,
284: p_token1_value => sqlcode,
285: p_token2 => G_SQLERRM_TOKEN,

Line 402: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

398: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
399: g_module || l_api_name,
400: 'Leaving delete_contacts because of EXCEPTION: ' || sqlerrm);
401: END IF;
402: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
403: p_msg_name => G_UNEXPECTED_ERROR,
404: p_token1 => G_SQLCODE_TOKEN,
405: p_token1_value => sqlcode,
406: p_token2 => G_SQLERRM_TOKEN,

Line 521: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

517: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
518: g_module || l_api_name,
519: 'Leaving delete_parties because of EXCEPTION: ' || sqlerrm);
520: END IF;
521: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
522: p_msg_name => G_UNEXPECTED_ERROR,
523: p_token1 => G_SQLCODE_TOKEN,
524: p_token1_value => sqlcode,
525: p_token2 => G_SQLERRM_TOKEN,

Line 605: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

601: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION ,
602: G_MODULE||l_api_name,
603: 'Invalid Contract Id: '|| p_contract_id);
604: END IF;
605: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
606: p_msg_name => G_INVALID_CONTRACT_ID_MSG,
607: p_token1 => G_CONTRACT_ID_TOKEN,
608: p_token1_value => to_char(p_contract_id));
609: RAISE FND_API.G_EXC_ERROR;

Line 678: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

674: --close cursors
675: IF (contract_csr%ISOPEN) THEN
676: CLOSE contract_csr ;
677: END IF;
678: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
679: p_msg_name => G_UNEXPECTED_ERROR,
680: p_token1 => G_SQLCODE_TOKEN,
681: p_token1_value => sqlcode,
682: p_token2 => G_SQLERRM_TOKEN,

Line 797: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

793: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
794: g_module || l_api_name,
795: 'Leaving delete_related_contracts because of EXCEPTION: ' || sqlerrm);
796: END IF;
797: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
798: p_msg_name => G_UNEXPECTED_ERROR,
799: p_token1 => G_SQLCODE_TOKEN,
800: p_token1_value => sqlcode,
801: p_token2 => G_SQLERRM_TOKEN,

Line 915: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

911: x_success => x_success, -- return param. 'T' or 'F'
912: x_errcode => x_errcode );
913: -----------------------------------------------------
914: IF (x_success = 'F' AND x_errcode < 0 ) THEN
915: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
916: ELSIF (x_success = 'F' AND x_errcode > 0) THEN
917: RAISE OKC_API.G_EXCEPTION_ERROR;
918: END IF;
919: --------------------------------------------------------

Line 917: RAISE OKC_API.G_EXCEPTION_ERROR;

913: -----------------------------------------------------
914: IF (x_success = 'F' AND x_errcode < 0 ) THEN
915: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
916: ELSIF (x_success = 'F' AND x_errcode > 0) THEN
917: RAISE OKC_API.G_EXCEPTION_ERROR;
918: END IF;
919: --------------------------------------------------------
920: END LOOP;
921: -- Standard check of p_commit

Line 978: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

974: END IF;
975: IF (acl_csr%ISOPEN) THEN
976: CLOSE acl_csr ;
977: END IF;
978: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
979: p_msg_name => G_UNEXPECTED_ERROR,
980: p_token1 => G_SQLCODE_TOKEN,
981: p_token1_value => sqlcode,
982: p_token2 => G_SQLERRM_TOKEN,

Line 1104: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

1100: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1101: g_module || l_api_name,
1102: 'Leaving delete_status_history because of EXCEPTION: ' || sqlerrm);
1103: END IF;
1104: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1105: p_msg_name => G_UNEXPECTED_ERROR,
1106: p_token1 => G_SQLCODE_TOKEN,
1107: p_token1_value => sqlcode,
1108: p_token2 => G_SQLERRM_TOKEN,

Line 1233: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

1229: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1230: g_module || l_api_name,
1231: 'Leaving delete_approval_history because of EXCEPTION: ' || sqlerrm);
1232: END IF;
1233: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1234: p_msg_name => G_UNEXPECTED_ERROR,
1235: p_token1 => G_SQLCODE_TOKEN,
1236: p_token1_value => sqlcode,
1237: p_token2 => G_SQLERRM_TOKEN,

Line 1359: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

1355: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1356: g_module || l_api_name,
1357: 'Leaving delete_bookmarks because of EXCEPTION: ' || sqlerrm);
1358: END IF;
1359: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1360: p_msg_name => G_UNEXPECTED_ERROR,
1361: p_token1 => G_SQLCODE_TOKEN,
1362: p_token1_value => sqlcode,
1363: p_token2 => G_SQLERRM_TOKEN,

Line 1431: Okc_Api.Set_Message(G_FND_APP,G_UNABLE_TO_RESERVE_REC);

1427:
1428: IF (lock_csr%ISOPEN) THEN
1429: CLOSE lock_csr;
1430: END IF;
1431: Okc_Api.Set_Message(G_FND_APP,G_UNABLE_TO_RESERVE_REC);
1432: RETURN(FND_API.G_RET_STS_ERROR );
1433: END;
1434:
1435: IF ( l_row_notfound ) THEN

Line 1444: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_DELETED);

1440: l_row_notfound := lchk_csr%NOTFOUND;
1441: CLOSE lchk_csr;
1442:
1443: IF (l_row_notfound) THEN
1444: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_DELETED);
1445: ELSIF l_object_version_number > p_object_version_number THEN
1446: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_CHANGED);
1447: ELSIF l_object_version_number = -1 THEN
1448: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line 1446: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_CHANGED);

1442:
1443: IF (l_row_notfound) THEN
1444: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_DELETED);
1445: ELSIF l_object_version_number > p_object_version_number THEN
1446: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_CHANGED);
1447: ELSIF l_object_version_number = -1 THEN
1448: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1449: ELSE -- it can be the only above condition. It can happen after restore version
1450: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_CHANGED);

Line 1448: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

1444: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_DELETED);
1445: ELSIF l_object_version_number > p_object_version_number THEN
1446: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_CHANGED);
1447: ELSIF l_object_version_number = -1 THEN
1448: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1449: ELSE -- it can be the only above condition. It can happen after restore version
1450: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_CHANGED);
1451: END IF;
1452: ELSE

Line 1450: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_CHANGED);

1446: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_CHANGED);
1447: ELSIF l_object_version_number = -1 THEN
1448: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1449: ELSE -- it can be the only above condition. It can happen after restore version
1450: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_CHANGED);
1451: END IF;
1452: ELSE
1453: l_return_status :=FND_API.G_RET_STS_SUCCESS;
1454: END IF;

Line 1480: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

1476: g_module || l_api_name,
1477: 'Leaving Function Lock_Contract_Header because of EXCEPTION: '||sqlerrm);
1478: END IF;
1479:
1480: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1481: p_msg_name => G_UNEXPECTED_ERROR,
1482: p_token1 => G_SQLCODE_TOKEN,
1483: p_token1_value => sqlcode,
1484: p_token2 => G_SQLERRM_TOKEN,

Line 1568: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

1564: g_module || l_api_name,
1565: 'Leaving Lock_Contract_Header because of EXCEPTION: '||sqlerrm);
1566: END IF;
1567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1568: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1569: p_msg_name => G_UNEXPECTED_ERROR,
1570: p_token1 => G_SQLCODE_TOKEN,
1571: p_token1_value => sqlcode,
1572: p_token2 => G_SQLERRM_TOKEN,

Line 1666: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1662: 'OKC_REP_CONTRACT_PROCESS_PVT.Lock_Contract_Header return status is: '
1663: || x_return_status);
1664: END IF;
1665: -----------------------------------------------------
1666: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1667: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1668: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1669: RAISE OKC_API.G_EXCEPTION_ERROR;
1670: END IF;

Line 1667: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1663: || x_return_status);
1664: END IF;
1665: -----------------------------------------------------
1666: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1667: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1668: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1669: RAISE OKC_API.G_EXCEPTION_ERROR;
1670: END IF;
1671: -----------------------------------------------------

Line 1668: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1664: END IF;
1665: -----------------------------------------------------
1666: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1667: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1668: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1669: RAISE OKC_API.G_EXCEPTION_ERROR;
1670: END IF;
1671: -----------------------------------------------------
1672:

Line 1669: RAISE OKC_API.G_EXCEPTION_ERROR;

1665: -----------------------------------------------------
1666: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1667: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1668: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1669: RAISE OKC_API.G_EXCEPTION_ERROR;
1670: END IF;
1671: -----------------------------------------------------
1672:
1673: -- The contract version

Line 1683: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

1679: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION ,
1680: G_MODULE||l_api_name,
1681: 'Invalid Contract Id: '|| p_contract_id);
1682: END IF;
1683: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1684: p_msg_name => G_INVALID_CONTRACT_ID_MSG,
1685: p_token1 => G_CONTRACT_ID_TOKEN,
1686: p_token1_value => to_char(p_contract_id));
1687: RAISE FND_API.G_EXC_ERROR;

Line 1711: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1707: 'OKC_REP_CONTRACT_PROCESS_PVT.delete_contacts return status is: '
1708: || x_return_status);
1709: END IF;
1710: -----------------------------------------------------
1711: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1712: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1713: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1714: RAISE OKC_API.G_EXCEPTION_ERROR;
1715: END IF;

Line 1712: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1708: || x_return_status);
1709: END IF;
1710: -----------------------------------------------------
1711: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1712: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1713: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1714: RAISE OKC_API.G_EXCEPTION_ERROR;
1715: END IF;
1716: -----------------------------------------------------

Line 1713: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1709: END IF;
1710: -----------------------------------------------------
1711: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1712: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1713: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1714: RAISE OKC_API.G_EXCEPTION_ERROR;
1715: END IF;
1716: -----------------------------------------------------
1717:

Line 1714: RAISE OKC_API.G_EXCEPTION_ERROR;

1710: -----------------------------------------------------
1711: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1712: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1713: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1714: RAISE OKC_API.G_EXCEPTION_ERROR;
1715: END IF;
1716: -----------------------------------------------------
1717:
1718:

Line 1737: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1733: 'OKC_REP_CONTRACT_PROCESS_PVT.delete_parties return status is: '
1734: || x_return_status);
1735: END IF;
1736: -----------------------------------------------------
1737: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1738: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1739: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1740: RAISE OKC_API.G_EXCEPTION_ERROR;
1741: END IF;

Line 1738: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1734: || x_return_status);
1735: END IF;
1736: -----------------------------------------------------
1737: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1738: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1739: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1740: RAISE OKC_API.G_EXCEPTION_ERROR;
1741: END IF;
1742: --------------------------------------------------------

Line 1739: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1735: END IF;
1736: -----------------------------------------------------
1737: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1738: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1739: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1740: RAISE OKC_API.G_EXCEPTION_ERROR;
1741: END IF;
1742: --------------------------------------------------------
1743:

Line 1740: RAISE OKC_API.G_EXCEPTION_ERROR;

1736: -----------------------------------------------------
1737: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1738: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1739: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1740: RAISE OKC_API.G_EXCEPTION_ERROR;
1741: END IF;
1742: --------------------------------------------------------
1743:
1744:

Line 1763: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1759: 'OKC_REP_CONTRACT_PROCESS_PVT.delete_risks return status is: '
1760: || x_return_status);
1761: END IF;
1762: -----------------------------------------------------
1763: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1764: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1765: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1766: RAISE OKC_API.G_EXCEPTION_ERROR;
1767: END IF;

Line 1764: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1760: || x_return_status);
1761: END IF;
1762: -----------------------------------------------------
1763: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1764: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1765: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1766: RAISE OKC_API.G_EXCEPTION_ERROR;
1767: END IF;
1768: --------------------------------------------------------

Line 1765: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1761: END IF;
1762: -----------------------------------------------------
1763: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1764: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1765: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1766: RAISE OKC_API.G_EXCEPTION_ERROR;
1767: END IF;
1768: --------------------------------------------------------
1769:

Line 1766: RAISE OKC_API.G_EXCEPTION_ERROR;

1762: -----------------------------------------------------
1763: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1764: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1765: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1766: RAISE OKC_API.G_EXCEPTION_ERROR;
1767: END IF;
1768: --------------------------------------------------------
1769:
1770:

Line 1789: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1785: 'OKC_REP_CONTRACT_PROCESS_PVT.delete_ACL return status is: '
1786: || x_return_status);
1787: END IF;
1788: -----------------------------------------------------
1789: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1790: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1791: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1792: RAISE OKC_API.G_EXCEPTION_ERROR;
1793: END IF;

Line 1790: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1786: || x_return_status);
1787: END IF;
1788: -----------------------------------------------------
1789: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1790: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1791: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1792: RAISE OKC_API.G_EXCEPTION_ERROR;
1793: END IF;
1794: --------------------------------------------------------

Line 1791: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1787: END IF;
1788: -----------------------------------------------------
1789: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1790: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1791: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1792: RAISE OKC_API.G_EXCEPTION_ERROR;
1793: END IF;
1794: --------------------------------------------------------
1795:

Line 1792: RAISE OKC_API.G_EXCEPTION_ERROR;

1788: -----------------------------------------------------
1789: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1790: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1791: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1792: RAISE OKC_API.G_EXCEPTION_ERROR;
1793: END IF;
1794: --------------------------------------------------------
1795:
1796:

Line 1815: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1811: 'OKC_REP_CONTRACT_PROCESS_PVT.delete_related_contracts return status is: '
1812: || x_return_status);
1813: END IF;
1814: -----------------------------------------------------
1815: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1816: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1817: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1818: RAISE OKC_API.G_EXCEPTION_ERROR;
1819: END IF;

Line 1816: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1812: || x_return_status);
1813: END IF;
1814: -----------------------------------------------------
1815: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1816: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1817: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1818: RAISE OKC_API.G_EXCEPTION_ERROR;
1819: END IF;
1820: --------------------------------------------------------

Line 1817: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1813: END IF;
1814: -----------------------------------------------------
1815: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1816: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1817: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1818: RAISE OKC_API.G_EXCEPTION_ERROR;
1819: END IF;
1820: --------------------------------------------------------
1821:

Line 1818: RAISE OKC_API.G_EXCEPTION_ERROR;

1814: -----------------------------------------------------
1815: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1816: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1817: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1818: RAISE OKC_API.G_EXCEPTION_ERROR;
1819: END IF;
1820: --------------------------------------------------------
1821:
1822:

Line 1842: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1838: 'OKC_REP_CONTRACT_PROCESS_PVT.delete_status_history return status is: '
1839: || x_return_status);
1840: END IF;
1841: -----------------------------------------------------
1842: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1843: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1844: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1845: RAISE OKC_API.G_EXCEPTION_ERROR;
1846: END IF;

Line 1843: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1839: || x_return_status);
1840: END IF;
1841: -----------------------------------------------------
1842: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1843: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1844: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1845: RAISE OKC_API.G_EXCEPTION_ERROR;
1846: END IF;
1847: --------------------------------------------------------

Line 1844: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1840: END IF;
1841: -----------------------------------------------------
1842: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1843: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1844: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1845: RAISE OKC_API.G_EXCEPTION_ERROR;
1846: END IF;
1847: --------------------------------------------------------
1848:

Line 1845: RAISE OKC_API.G_EXCEPTION_ERROR;

1841: -----------------------------------------------------
1842: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1843: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1844: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1845: RAISE OKC_API.G_EXCEPTION_ERROR;
1846: END IF;
1847: --------------------------------------------------------
1848:
1849:

Line 1869: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1865: 'OKC_REP_CONTRACT_PROCESS_PVT.delete_approval_history return status is: '
1866: || x_return_status);
1867: END IF;
1868: -----------------------------------------------------
1869: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1870: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1871: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1872: RAISE OKC_API.G_EXCEPTION_ERROR;
1873: END IF;

Line 1870: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1866: || x_return_status);
1867: END IF;
1868: -----------------------------------------------------
1869: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1870: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1871: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1872: RAISE OKC_API.G_EXCEPTION_ERROR;
1873: END IF;
1874: --------------------------------------------------------

Line 1871: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1867: END IF;
1868: -----------------------------------------------------
1869: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1870: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1871: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1872: RAISE OKC_API.G_EXCEPTION_ERROR;
1873: END IF;
1874: --------------------------------------------------------
1875:

Line 1872: RAISE OKC_API.G_EXCEPTION_ERROR;

1868: -----------------------------------------------------
1869: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1870: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1871: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1872: RAISE OKC_API.G_EXCEPTION_ERROR;
1873: END IF;
1874: --------------------------------------------------------
1875:
1876:

Line 1896: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1892: 'OKC_REP_CONTRACT_PROCESS_PVT.delete_bookmarks return status is: '
1893: || x_return_status);
1894: END IF;
1895: -----------------------------------------------------
1896: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1897: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1898: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1899: RAISE OKC_API.G_EXCEPTION_ERROR;
1900: END IF;

Line 1897: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1893: || x_return_status);
1894: END IF;
1895: -----------------------------------------------------
1896: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1897: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1898: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1899: RAISE OKC_API.G_EXCEPTION_ERROR;
1900: END IF;
1901: --------------------------------------------------------

Line 1898: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1894: END IF;
1895: -----------------------------------------------------
1896: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1897: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1898: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1899: RAISE OKC_API.G_EXCEPTION_ERROR;
1900: END IF;
1901: --------------------------------------------------------
1902:

Line 1899: RAISE OKC_API.G_EXCEPTION_ERROR;

1895: -----------------------------------------------------
1896: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1897: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1898: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1899: RAISE OKC_API.G_EXCEPTION_ERROR;
1900: END IF;
1901: --------------------------------------------------------
1902:
1903: END IF; -- (contract_rec.contract_version_num = 1)

Line 1926: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1922: 'OKC_CONTRACT_DOCS_GRP.Delete_Ver_Attachments return status is : '
1923: || x_return_status);
1924: END IF;
1925: -----------------------------------------------------
1926: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1927: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1928: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1929: RAISE OKC_API.G_EXCEPTION_ERROR;
1930: END IF;

Line 1927: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1923: || x_return_status);
1924: END IF;
1925: -----------------------------------------------------
1926: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1927: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1928: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1929: RAISE OKC_API.G_EXCEPTION_ERROR;
1930: END IF;
1931: --------------------------------------------------------

Line 1928: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1924: END IF;
1925: -----------------------------------------------------
1926: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1927: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1928: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1929: RAISE OKC_API.G_EXCEPTION_ERROR;
1930: END IF;
1931: --------------------------------------------------------
1932:

Line 1929: RAISE OKC_API.G_EXCEPTION_ERROR;

1925: -----------------------------------------------------
1926: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1927: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1928: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1929: RAISE OKC_API.G_EXCEPTION_ERROR;
1930: END IF;
1931: --------------------------------------------------------
1932:
1933: IF (contract_rec.contract_version_num > 1) THEN

Line 1957: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1953: || x_return_status);
1954: END IF;
1955:
1956: -----------------------------------------------------
1957: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1958: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1959: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1960: RAISE OKC_API.G_EXCEPTION_ERROR;
1961: END IF;

Line 1958: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1954: END IF;
1955:
1956: -----------------------------------------------------
1957: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1958: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1959: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1960: RAISE OKC_API.G_EXCEPTION_ERROR;
1961: END IF;
1962: --------------------------------------------------------

Line 1959: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1955:
1956: -----------------------------------------------------
1957: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1958: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1959: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1960: RAISE OKC_API.G_EXCEPTION_ERROR;
1961: END IF;
1962: --------------------------------------------------------
1963:

Line 1960: RAISE OKC_API.G_EXCEPTION_ERROR;

1956: -----------------------------------------------------
1957: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1958: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1959: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1960: RAISE OKC_API.G_EXCEPTION_ERROR;
1961: END IF;
1962: --------------------------------------------------------
1963:
1964: END IF;

Line 1983: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1979: p_doc_type => contract_rec.contract_type,
1980: p_doc_id => p_contract_id
1981: );
1982: --------------------------------------------
1983: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1984: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1985: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1986: RAISE OKC_API.G_EXCEPTION_ERROR;
1987: END IF;

Line 1984: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1980: p_doc_id => p_contract_id
1981: );
1982: --------------------------------------------
1983: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1984: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1985: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1986: RAISE OKC_API.G_EXCEPTION_ERROR;
1987: END IF;
1988:

Line 1985: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1981: );
1982: --------------------------------------------
1983: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1984: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1985: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1986: RAISE OKC_API.G_EXCEPTION_ERROR;
1987: END IF;
1988:
1989: ELSE

Line 1986: RAISE OKC_API.G_EXCEPTION_ERROR;

1982: --------------------------------------------
1983: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1984: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1985: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1986: RAISE OKC_API.G_EXCEPTION_ERROR;
1987: END IF;
1988:
1989: ELSE
1990:

Line 2002: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1998: p_doc_id => p_contract_id,
1999: p_version_number => contract_rec.contract_version_num - 1
2000: );
2001: --------------------------------------------
2002: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2003: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2004: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2005: RAISE OKC_API.G_EXCEPTION_ERROR;
2006: END IF;

Line 2003: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1999: p_version_number => contract_rec.contract_version_num - 1
2000: );
2001: --------------------------------------------
2002: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2003: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2004: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2005: RAISE OKC_API.G_EXCEPTION_ERROR;
2006: END IF;
2007: -- Deletes the previous version's terms details in the history table

Line 2004: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

2000: );
2001: --------------------------------------------
2002: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2003: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2004: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2005: RAISE OKC_API.G_EXCEPTION_ERROR;
2006: END IF;
2007: -- Deletes the previous version's terms details in the history table
2008: OKC_TERMS_VERSION_PVT.Delete_Doc_Version(

Line 2005: RAISE OKC_API.G_EXCEPTION_ERROR;

2001: --------------------------------------------
2002: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2003: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2004: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2005: RAISE OKC_API.G_EXCEPTION_ERROR;
2006: END IF;
2007: -- Deletes the previous version's terms details in the history table
2008: OKC_TERMS_VERSION_PVT.Delete_Doc_Version(
2009: x_return_status => x_return_status,

Line 2015: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2011: p_doc_id => p_contract_id,
2012: p_version_number => contract_rec.contract_version_num - 1
2013: );
2014: --------------------------------------------
2015: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2016: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2017: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2018: RAISE OKC_API.G_EXCEPTION_ERROR;
2019: END IF;

Line 2016: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2012: p_version_number => contract_rec.contract_version_num - 1
2013: );
2014: --------------------------------------------
2015: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2016: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2017: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2018: RAISE OKC_API.G_EXCEPTION_ERROR;
2019: END IF;
2020:

Line 2017: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

2013: );
2014: --------------------------------------------
2015: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2016: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2017: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2018: RAISE OKC_API.G_EXCEPTION_ERROR;
2019: END IF;
2020:
2021: -- Changes for Bug# 6902073 Ends

Line 2018: RAISE OKC_API.G_EXCEPTION_ERROR;

2014: --------------------------------------------
2015: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2016: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2017: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2018: RAISE OKC_API.G_EXCEPTION_ERROR;
2019: END IF;
2020:
2021: -- Changes for Bug# 6902073 Ends
2022: END IF;

Line 2078: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2074: || x_return_status);
2075: END IF;
2076:
2077: -----------------------------------------------------
2078: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2079: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2080: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2081: RAISE OKC_API.G_EXCEPTION_ERROR;
2082: END IF;

Line 2079: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2075: END IF;
2076:
2077: -----------------------------------------------------
2078: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2079: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2080: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2081: RAISE OKC_API.G_EXCEPTION_ERROR;
2082: END IF;
2083: --------------------------------------------------------

Line 2080: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

2076:
2077: -----------------------------------------------------
2078: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2079: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2080: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2081: RAISE OKC_API.G_EXCEPTION_ERROR;
2082: END IF;
2083: --------------------------------------------------------
2084:

Line 2081: RAISE OKC_API.G_EXCEPTION_ERROR;

2077: -----------------------------------------------------
2078: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2079: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2080: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2081: RAISE OKC_API.G_EXCEPTION_ERROR;
2082: END IF;
2083: --------------------------------------------------------
2084:
2085:

Line 2290: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

2286: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2287: g_module || l_api_name,
2288: 'Leaving delete_contract because of EXCEPTION: ' || sqlerrm);
2289: END IF;
2290: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2291: p_msg_name => G_UNEXPECTED_ERROR,
2292: p_token1 => G_SQLCODE_TOKEN,
2293: p_token1_value => sqlcode,
2294: p_token2 => G_SQLERRM_TOKEN,

Line 2469: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

2465: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2466: g_module || l_api_name,
2467: 'Leaving copy_contacts because of EXCEPTION: ' || sqlerrm);
2468: END IF;
2469: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2470: p_msg_name => G_UNEXPECTED_ERROR,
2471: p_token1 => G_SQLCODE_TOKEN,
2472: p_token1_value => sqlcode,
2473: p_token2 => G_SQLERRM_TOKEN,

Line 2639: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

2635: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2636: g_module || l_api_name,
2637: 'Leaving copy_parties because of EXCEPTION: ' || sqlerrm);
2638: END IF;
2639: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2640: p_msg_name => G_UNEXPECTED_ERROR,
2641: p_token1 => G_SQLCODE_TOKEN,
2642: p_token1_value => sqlcode,
2643: p_token2 => G_SQLERRM_TOKEN,

Line 2751: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

2747: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION ,
2748: G_MODULE||l_api_name,
2749: 'Invalid Contract Id: '|| p_source_contract_id);
2750: END IF;
2751: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2752: p_msg_name => G_INVALID_CONTRACT_ID_MSG,
2753: p_token1 => G_CONTRACT_ID_TOKEN,
2754: p_token1_value => to_char(p_source_contract_id));
2755: RAISE FND_API.G_EXC_ERROR;

Line 2878: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

2874: --close cursors
2875: IF (contract_csr%ISOPEN) THEN
2876: CLOSE contract_csr ;
2877: END IF;
2878: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2879: p_msg_name => G_UNEXPECTED_ERROR,
2880: p_token1 => G_SQLCODE_TOKEN,
2881: p_token1_value => sqlcode,
2882: p_token2 => G_SQLERRM_TOKEN,

Line 3013: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3009: x_success => x_success, -- return param. 'T' or 'F'
3010: x_errorcode => x_errorcode );
3011: -----------------------------------------------------
3012: IF (x_success = 'F' AND x_errorcode < 0 ) THEN
3013: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3014: ELSIF (x_success = 'F' AND x_errorcode > 0) THEN
3015: RAISE OKC_API.G_EXCEPTION_ERROR;
3016: END IF;
3017: --------------------------------------------------------

Line 3015: RAISE OKC_API.G_EXCEPTION_ERROR;

3011: -----------------------------------------------------
3012: IF (x_success = 'F' AND x_errorcode < 0 ) THEN
3013: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3014: ELSIF (x_success = 'F' AND x_errorcode > 0) THEN
3015: RAISE OKC_API.G_EXCEPTION_ERROR;
3016: END IF;
3017: --------------------------------------------------------
3018: END LOOP;
3019: -- Standard check of p_commit

Line 3066: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

3062: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
3063: g_module || l_api_name,
3064: 'Leaving copy_ACL because of EXCEPTION: ' || sqlerrm);
3065: END IF;
3066: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
3067: p_msg_name => G_UNEXPECTED_ERROR,
3068: p_token1 => G_SQLCODE_TOKEN,
3069: p_token1_value => sqlcode,
3070: p_token2 => G_SQLERRM_TOKEN,

Line 3191: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

3187: 'OKC_REP_CONTRACT_PROCESS_PVT.copy_parties return status is: '
3188: || x_return_status);
3189: END IF;
3190: ----------------------------------------------------
3191: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3192: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3193: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3194: RAISE OKC_API.G_EXCEPTION_ERROR;
3195: END IF;

Line 3192: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3188: || x_return_status);
3189: END IF;
3190: ----------------------------------------------------
3191: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3192: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3193: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3194: RAISE OKC_API.G_EXCEPTION_ERROR;
3195: END IF;
3196: --------------------------------------------------------

Line 3193: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

3189: END IF;
3190: ----------------------------------------------------
3191: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3192: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3193: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3194: RAISE OKC_API.G_EXCEPTION_ERROR;
3195: END IF;
3196: --------------------------------------------------------
3197:

Line 3194: RAISE OKC_API.G_EXCEPTION_ERROR;

3190: ----------------------------------------------------
3191: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3192: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3193: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3194: RAISE OKC_API.G_EXCEPTION_ERROR;
3195: END IF;
3196: --------------------------------------------------------
3197:
3198:

Line 3218: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

3214: 'OKC_REP_CONTRACT_PROCESS_PVT.copy_contacts return status is: '
3215: || x_return_status);
3216: END IF;
3217: -----------------------------------------------------
3218: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3219: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3220: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3221: RAISE OKC_API.G_EXCEPTION_ERROR;
3222: END IF;

Line 3219: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3215: || x_return_status);
3216: END IF;
3217: -----------------------------------------------------
3218: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3219: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3220: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3221: RAISE OKC_API.G_EXCEPTION_ERROR;
3222: END IF;
3223: -----------------------------------------------------

Line 3220: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

3216: END IF;
3217: -----------------------------------------------------
3218: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3219: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3220: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3221: RAISE OKC_API.G_EXCEPTION_ERROR;
3222: END IF;
3223: -----------------------------------------------------
3224:

Line 3221: RAISE OKC_API.G_EXCEPTION_ERROR;

3217: -----------------------------------------------------
3218: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3219: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3220: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3221: RAISE OKC_API.G_EXCEPTION_ERROR;
3222: END IF;
3223: -----------------------------------------------------
3224:
3225: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3244: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

3240: 'OKC_REP_CONTRACT_PROCESS_PVT.copy_risks return status is: '
3241: || x_return_status);
3242: END IF;
3243: -----------------------------------------------------
3244: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3245: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3246: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3247: RAISE OKC_API.G_EXCEPTION_ERROR;
3248: END IF;

Line 3245: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3241: || x_return_status);
3242: END IF;
3243: -----------------------------------------------------
3244: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3245: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3246: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3247: RAISE OKC_API.G_EXCEPTION_ERROR;
3248: END IF;
3249: --------------------------------------------------------

Line 3246: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

3242: END IF;
3243: -----------------------------------------------------
3244: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3245: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3246: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3247: RAISE OKC_API.G_EXCEPTION_ERROR;
3248: END IF;
3249: --------------------------------------------------------
3250:

Line 3247: RAISE OKC_API.G_EXCEPTION_ERROR;

3243: -----------------------------------------------------
3244: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3245: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3246: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3247: RAISE OKC_API.G_EXCEPTION_ERROR;
3248: END IF;
3249: --------------------------------------------------------
3250:
3251: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3270: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

3266: 'OKC_REP_CONTRACT_PROCESS_PVT.copy_ACL return status is: '
3267: || x_return_status);
3268: END IF;
3269: -----------------------------------------------------
3270: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3271: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3272: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3273: RAISE OKC_API.G_EXCEPTION_ERROR;
3274: END IF;

Line 3271: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3267: || x_return_status);
3268: END IF;
3269: -----------------------------------------------------
3270: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3271: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3272: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3273: RAISE OKC_API.G_EXCEPTION_ERROR;
3274: END IF;
3275: -----------------------------------------------------

Line 3272: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

3268: END IF;
3269: -----------------------------------------------------
3270: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3271: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3272: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3273: RAISE OKC_API.G_EXCEPTION_ERROR;
3274: END IF;
3275: -----------------------------------------------------
3276: -- Get contract_type of source contract, required for deliverables and documents APIs

Line 3273: RAISE OKC_API.G_EXCEPTION_ERROR;

3269: -----------------------------------------------------
3270: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3271: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3272: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3273: RAISE OKC_API.G_EXCEPTION_ERROR;
3274: END IF;
3275: -----------------------------------------------------
3276: -- Get contract_type of source contract, required for deliverables and documents APIs
3277: OPEN source_contract_csr;

Line 3285: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

3281: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION ,
3282: G_MODULE||l_api_name,
3283: 'Invalid Contract Id: '|| p_source_contract_id);
3284: END IF;
3285: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
3286: p_msg_name => G_INVALID_CONTRACT_ID_MSG,
3287: p_token1 => G_CONTRACT_ID_TOKEN,
3288: p_token1_value => to_char(p_source_contract_id));
3289: RAISE FND_API.G_EXC_ERROR;

Line 3325: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

3321: 'OKC_CONTRACT_DOCS_GRP.Copy_Attachments return status is : '
3322: || x_return_status);
3323: END IF;
3324: -----------------------------------------------------
3325: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3326: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3327: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3328: RAISE OKC_API.G_EXCEPTION_ERROR;
3329: END IF;

Line 3326: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3322: || x_return_status);
3323: END IF;
3324: -----------------------------------------------------
3325: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3326: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3327: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3328: RAISE OKC_API.G_EXCEPTION_ERROR;
3329: END IF;
3330: --------------------------------------------------------

Line 3327: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

3323: END IF;
3324: -----------------------------------------------------
3325: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3326: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3327: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3328: RAISE OKC_API.G_EXCEPTION_ERROR;
3329: END IF;
3330: --------------------------------------------------------
3331:

Line 3328: RAISE OKC_API.G_EXCEPTION_ERROR;

3324: -----------------------------------------------------
3325: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3326: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3327: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3328: RAISE OKC_API.G_EXCEPTION_ERROR;
3329: END IF;
3330: --------------------------------------------------------
3331:
3332: -- Repository Enhancement 12.1(For Duplicate Action)

Line 3361: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

3357: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3358: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: Finished OKC_TERMS_COPY_PVT.copy_tc, return status : '||x_return_status);
3359: END IF;
3360:
3361: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3362: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3363: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3364: RAISE OKC_API.G_EXCEPTION_ERROR;
3365: END IF;

Line 3362: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3358: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'600: Finished OKC_TERMS_COPY_PVT.copy_tc, return status : '||x_return_status);
3359: END IF;
3360:
3361: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3362: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3363: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3364: RAISE OKC_API.G_EXCEPTION_ERROR;
3365: END IF;
3366: -- Repository Enhancement 12.1 ends(For Duplicate Action)

Line 3363: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

3359: END IF;
3360:
3361: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3362: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3363: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3364: RAISE OKC_API.G_EXCEPTION_ERROR;
3365: END IF;
3366: -- Repository Enhancement 12.1 ends(For Duplicate Action)
3367:

Line 3364: RAISE OKC_API.G_EXCEPTION_ERROR;

3360:
3361: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3362: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3363: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3364: RAISE OKC_API.G_EXCEPTION_ERROR;
3365: END IF;
3366: -- Repository Enhancement 12.1 ends(For Duplicate Action)
3367:
3368:

Line 3396: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

3392: 'OKC_DELIVERABLE_PROCESS_PVT.copy_deliverables return status is : '
3393: || x_return_status);
3394: END IF;
3395: -----------------------------------------------------
3396: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3397: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3398: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3399: RAISE OKC_API.G_EXCEPTION_ERROR;
3400: END IF;

Line 3397: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3393: || x_return_status);
3394: END IF;
3395: -----------------------------------------------------
3396: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3397: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3398: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3399: RAISE OKC_API.G_EXCEPTION_ERROR;
3400: END IF;
3401: --------------------------------------------------------

Line 3398: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

3394: END IF;
3395: -----------------------------------------------------
3396: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3397: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3398: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3399: RAISE OKC_API.G_EXCEPTION_ERROR;
3400: END IF;
3401: --------------------------------------------------------
3402:

Line 3399: RAISE OKC_API.G_EXCEPTION_ERROR;

3395: -----------------------------------------------------
3396: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3397: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3398: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3399: RAISE OKC_API.G_EXCEPTION_ERROR;
3400: END IF;
3401: --------------------------------------------------------
3402:
3403: -- close open cursors

Line 3468: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

3464: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
3465: g_module || l_api_name,
3466: 'Leaving copy_contract_details because of EXCEPTION: ' || sqlerrm);
3467: END IF;
3468: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
3469: p_msg_name => G_UNEXPECTED_ERROR,
3470: p_token1 => G_SQLCODE_TOKEN,
3471: p_token1_value => sqlcode,
3472: p_token2 => G_SQLERRM_TOKEN,

Line 3579: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

3575: 'OKC_REP_CONTRACT_PROCESS_PVT.Lock_Contract_Header return status is: '
3576: || x_return_status);
3577: END IF;
3578: -----------------------------------------------------
3579: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3580: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3581: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3582: RAISE OKC_API.G_EXCEPTION_ERROR;
3583: END IF;

Line 3580: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3576: || x_return_status);
3577: END IF;
3578: -----------------------------------------------------
3579: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3580: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3581: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3582: RAISE OKC_API.G_EXCEPTION_ERROR;
3583: END IF;
3584: -----------------------------------------------------

Line 3581: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

3577: END IF;
3578: -----------------------------------------------------
3579: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3580: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3581: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3582: RAISE OKC_API.G_EXCEPTION_ERROR;
3583: END IF;
3584: -----------------------------------------------------
3585:

Line 3582: RAISE OKC_API.G_EXCEPTION_ERROR;

3578: -----------------------------------------------------
3579: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3580: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3581: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3582: RAISE OKC_API.G_EXCEPTION_ERROR;
3583: END IF;
3584: -----------------------------------------------------
3585:
3586: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3725: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

3721: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION ,
3722: G_MODULE||l_api_name,
3723: 'Invalid Contract Id: '|| p_contract_id);
3724: END IF;
3725: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
3726: p_msg_name => G_INVALID_CONTRACT_ID_MSG,
3727: p_token1 => G_CONTRACT_ID_TOKEN,
3728: p_token1_value => to_char(p_contract_id));
3729: RAISE FND_API.G_EXC_ERROR;

Line 3756: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

3752: 'OKC_CONTRACT_DOCS_GRP.Version_Attachments return status is : '
3753: || x_return_status);
3754: END IF;
3755: -----------------------------------------------------
3756: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3757: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3758: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3759: RAISE OKC_API.G_EXCEPTION_ERROR;
3760: END IF;

Line 3757: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3753: || x_return_status);
3754: END IF;
3755: -----------------------------------------------------
3756: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3757: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3758: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3759: RAISE OKC_API.G_EXCEPTION_ERROR;
3760: END IF;
3761: --------------------------------------------------------

Line 3758: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

3754: END IF;
3755: -----------------------------------------------------
3756: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3757: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3758: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3759: RAISE OKC_API.G_EXCEPTION_ERROR;
3760: END IF;
3761: --------------------------------------------------------
3762:

Line 3759: RAISE OKC_API.G_EXCEPTION_ERROR;

3755: -----------------------------------------------------
3756: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3757: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3758: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3759: RAISE OKC_API.G_EXCEPTION_ERROR;
3760: END IF;
3761: --------------------------------------------------------
3762:
3763: -- Repository Enhancement 12.1 (For Create New Version Action)

Line 3794: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

3790: p_doc_id => p_contract_id,
3791: p_version_number => contract_rec.contract_version_num
3792: );
3793: --------------------------------------------
3794: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3796: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3797: RAISE FND_API.G_EXC_ERROR ;
3798: END IF;

Line 3796: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

3792: );
3793: --------------------------------------------
3794: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3796: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3797: RAISE FND_API.G_EXC_ERROR ;
3798: END IF;
3799:
3800: ELSIF l_contract_source = 'ATTACHED' THEN

Line 3816: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

3812: p_doc_id => p_contract_id,
3813: p_major_version => contract_rec.contract_version_num
3814: );
3815: --------------------------------------------
3816: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3817: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3818: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3819: RAISE FND_API.G_EXC_ERROR ;
3820: END IF;

Line 3818: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

3814: );
3815: --------------------------------------------
3816: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3817: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3818: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3819: RAISE FND_API.G_EXC_ERROR ;
3820: END IF;
3821:
3822: END IF;

Line 3852: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

3848: 'OKC_DELIVERABLE_PROCESS_PVT.version_deliverables return status is : '
3849: || x_return_status);
3850: END IF;
3851: -----------------------------------------------------
3852: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3853: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3854: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3855: RAISE OKC_API.G_EXCEPTION_ERROR;
3856: END IF;

Line 3853: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3849: || x_return_status);
3850: END IF;
3851: -----------------------------------------------------
3852: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3853: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3854: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3855: RAISE OKC_API.G_EXCEPTION_ERROR;
3856: END IF;
3857: --------------------------------------------------------

Line 3854: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

3850: END IF;
3851: -----------------------------------------------------
3852: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3853: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3854: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3855: RAISE OKC_API.G_EXCEPTION_ERROR;
3856: END IF;
3857: --------------------------------------------------------
3858: END IF; -- contract_rec.contract_status_code <> G_STATUS_SIGNED

Line 3855: RAISE OKC_API.G_EXCEPTION_ERROR;

3851: -----------------------------------------------------
3852: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3853: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3854: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3855: RAISE OKC_API.G_EXCEPTION_ERROR;
3856: END IF;
3857: --------------------------------------------------------
3858: END IF; -- contract_rec.contract_status_code <> G_STATUS_SIGNED
3859:

Line 3880: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

3876: 'OKC_DELIVERABLE_PROCESS_PVT.clear_amendment_operation return status is : '
3877: || x_return_status);
3878: END IF;
3879: -----------------------------------------------------
3880: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3881: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3882: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3883: RAISE OKC_API.G_EXCEPTION_ERROR;
3884: END IF;

Line 3881: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3877: || x_return_status);
3878: END IF;
3879: -----------------------------------------------------
3880: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3881: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3882: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3883: RAISE OKC_API.G_EXCEPTION_ERROR;
3884: END IF;
3885: --------------------------------------------------------

Line 3882: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

3878: END IF;
3879: -----------------------------------------------------
3880: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3881: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3882: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3883: RAISE OKC_API.G_EXCEPTION_ERROR;
3884: END IF;
3885: --------------------------------------------------------
3886:

Line 3883: RAISE OKC_API.G_EXCEPTION_ERROR;

3879: -----------------------------------------------------
3880: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3881: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3882: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3883: RAISE OKC_API.G_EXCEPTION_ERROR;
3884: END IF;
3885: --------------------------------------------------------
3886:
3887:

Line 3958: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

3954: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
3955: g_module || l_api_name,
3956: 'Leaving version_contract_details because of EXCEPTION: ' || sqlerrm);
3957: END IF;
3958: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
3959: p_msg_name => G_UNEXPECTED_ERROR,
3960: p_token1 => G_SQLCODE_TOKEN,
3961: p_token1_value => sqlcode,
3962: p_token2 => G_SQLERRM_TOKEN,

Line 4066: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

4062: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION ,
4063: G_MODULE||l_api_name,
4064: 'Invalid Contract Id: '|| p_contract_id);
4065: END IF;
4066: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
4067: p_msg_name => G_INVALID_CONTRACT_ID_MSG,
4068: p_token1 => G_CONTRACT_ID_TOKEN,
4069: p_token1_value => to_char(p_contract_id));
4070: RAISE FND_API.G_EXC_ERROR;

Line 4091: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

4087: 'OKC_REP_CONTRACT_PROCESS_PVT.Lock_Contract_Header return status is: '
4088: || x_return_status);
4089: END IF;
4090: -----------------------------------------------------
4091: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4092: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4093: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4094: RAISE OKC_API.G_EXCEPTION_ERROR;
4095: END IF;

Line 4092: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4088: || x_return_status);
4089: END IF;
4090: -----------------------------------------------------
4091: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4092: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4093: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4094: RAISE OKC_API.G_EXCEPTION_ERROR;
4095: END IF;
4096: -----------------------------------------------------

Line 4093: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

4089: END IF;
4090: -----------------------------------------------------
4091: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4092: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4093: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4094: RAISE OKC_API.G_EXCEPTION_ERROR;
4095: END IF;
4096: -----------------------------------------------------
4097:

Line 4094: RAISE OKC_API.G_EXCEPTION_ERROR;

4090: -----------------------------------------------------
4091: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4092: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4093: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4094: RAISE OKC_API.G_EXCEPTION_ERROR;
4095: END IF;
4096: -----------------------------------------------------
4097:
4098: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 4120: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

4116: g_module || l_api_name,
4117: 'Completed OKC_REP_UTIL_PVT.change_contract_status with return status: ' || x_return_status);
4118: END IF;
4119: -----------------------------------------------------
4120: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4121: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4122: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4123: RAISE OKC_API.G_EXCEPTION_ERROR;
4124: END IF;

Line 4121: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4117: 'Completed OKC_REP_UTIL_PVT.change_contract_status with return status: ' || x_return_status);
4118: END IF;
4119: -----------------------------------------------------
4120: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4121: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4122: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4123: RAISE OKC_API.G_EXCEPTION_ERROR;
4124: END IF;
4125: ------------------------------------------------------

Line 4122: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

4118: END IF;
4119: -----------------------------------------------------
4120: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4121: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4122: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4123: RAISE OKC_API.G_EXCEPTION_ERROR;
4124: END IF;
4125: ------------------------------------------------------
4126:

Line 4123: RAISE OKC_API.G_EXCEPTION_ERROR;

4119: -----------------------------------------------------
4120: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4121: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4122: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4123: RAISE OKC_API.G_EXCEPTION_ERROR;
4124: END IF;
4125: ------------------------------------------------------
4126:
4127: -- We need to first version the deliverables

Line 4148: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

4144: 'OKC_DELIVERABLE_PROCESS_PVT.version_deliverables return status is : '
4145: || x_return_status);
4146: END IF;
4147: -----------------------------------------------------
4148: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4149: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4150: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4151: RAISE OKC_API.G_EXCEPTION_ERROR;
4152: END IF;

Line 4149: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4145: || x_return_status);
4146: END IF;
4147: -----------------------------------------------------
4148: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4149: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4150: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4151: RAISE OKC_API.G_EXCEPTION_ERROR;
4152: END IF;
4153: --------------------------------------------------------

Line 4150: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

4146: END IF;
4147: -----------------------------------------------------
4148: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4149: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4150: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4151: RAISE OKC_API.G_EXCEPTION_ERROR;
4152: END IF;
4153: --------------------------------------------------------
4154:

Line 4151: RAISE OKC_API.G_EXCEPTION_ERROR;

4147: -----------------------------------------------------
4148: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4149: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4150: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4151: RAISE OKC_API.G_EXCEPTION_ERROR;
4152: END IF;
4153: --------------------------------------------------------
4154:
4155: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 4200: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

4196: 'OKC_DELIVERABLE_PROCESS_PVT.activateDeliverables return status is : '
4197: || x_return_status);
4198: END IF;
4199: -----------------------------------------------------
4200: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4201: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4202: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4203: RAISE OKC_API.G_EXCEPTION_ERROR;
4204: END IF;

Line 4201: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4197: || x_return_status);
4198: END IF;
4199: -----------------------------------------------------
4200: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4201: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4202: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4203: RAISE OKC_API.G_EXCEPTION_ERROR;
4204: END IF;
4205: --------------------------------------------------------

Line 4202: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

4198: END IF;
4199: -----------------------------------------------------
4200: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4201: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4202: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4203: RAISE OKC_API.G_EXCEPTION_ERROR;
4204: END IF;
4205: --------------------------------------------------------
4206:

Line 4203: RAISE OKC_API.G_EXCEPTION_ERROR;

4199: -----------------------------------------------------
4200: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4201: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4202: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4203: RAISE OKC_API.G_EXCEPTION_ERROR;
4204: END IF;
4205: --------------------------------------------------------
4206:
4207: -- Checking if we need to call deliverable's APIs for synch-ing

Line 4219: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

4215: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION ,
4216: G_MODULE||l_api_name,
4217: 'Invalid Contract Id: '|| p_contract_id);
4218: END IF;
4219: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
4220: p_msg_name => G_INVALID_CONTRACT_ID_MSG,
4221: p_token1 => G_CONTRACT_ID_TOKEN,
4222: p_token1_value => to_char(p_contract_id));
4223: RAISE FND_API.G_EXC_ERROR;

Line 4276: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

4272: 'OKC_DELIVERABLE_PROCESS_PVT.updateDeliverables return status is : '
4273: || x_return_status);
4274: END IF;
4275: -----------------------------------------------------
4276: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4277: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4278: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4279: RAISE OKC_API.G_EXCEPTION_ERROR;
4280: END IF;

Line 4277: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4273: || x_return_status);
4274: END IF;
4275: -----------------------------------------------------
4276: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4277: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4278: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4279: RAISE OKC_API.G_EXCEPTION_ERROR;
4280: END IF;
4281: --------------------------------------------------------

Line 4278: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

4274: END IF;
4275: -----------------------------------------------------
4276: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4277: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4278: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4279: RAISE OKC_API.G_EXCEPTION_ERROR;
4280: END IF;
4281: --------------------------------------------------------
4282: END IF; -- expiration date comparision

Line 4279: RAISE OKC_API.G_EXCEPTION_ERROR;

4275: -----------------------------------------------------
4276: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4277: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4278: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4279: RAISE OKC_API.G_EXCEPTION_ERROR;
4280: END IF;
4281: --------------------------------------------------------
4282: END IF; -- expiration date comparision
4283: -- Disable prev. version deliverables

Line 4305: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

4301: 'OKC_DELIVERABLE_PROCESS_PVT.disableDeliverables return status is : '
4302: || x_return_status);
4303: END IF;
4304: -----------------------------------------------------
4305: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4306: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4307: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4308: RAISE OKC_API.G_EXCEPTION_ERROR;
4309: END IF;

Line 4306: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4302: || x_return_status);
4303: END IF;
4304: -----------------------------------------------------
4305: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4306: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4307: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4308: RAISE OKC_API.G_EXCEPTION_ERROR;
4309: END IF;
4310: --------------------------------------------------------

Line 4307: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

4303: END IF;
4304: -----------------------------------------------------
4305: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4306: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4307: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4308: RAISE OKC_API.G_EXCEPTION_ERROR;
4309: END IF;
4310: --------------------------------------------------------
4311: END IF; -- (l_sync_flag = 'Y')

Line 4308: RAISE OKC_API.G_EXCEPTION_ERROR;

4304: -----------------------------------------------------
4305: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4306: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4307: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4308: RAISE OKC_API.G_EXCEPTION_ERROR;
4309: END IF;
4310: --------------------------------------------------------
4311: END IF; -- (l_sync_flag = 'Y')
4312: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 4381: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

4377: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
4378: g_module || l_api_name,
4379: 'Leaving sign_contract because of EXCEPTION: ' || sqlerrm);
4380: END IF;
4381: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
4382: p_msg_name => G_UNEXPECTED_ERROR,
4383: p_token1 => G_SQLCODE_TOKEN,
4384: p_token1_value => sqlcode,
4385: p_token2 => G_SQLERRM_TOKEN,

Line 4484: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

4480: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION ,
4481: G_MODULE||l_api_name,
4482: 'Invalid Contract Id: '|| p_contract_id);
4483: END IF;
4484: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
4485: p_msg_name => G_INVALID_CONTRACT_ID_MSG,
4486: p_token1 => G_CONTRACT_ID_TOKEN,
4487: p_token1_value => to_char(p_contract_id));
4488: RAISE FND_API.G_EXC_ERROR;

Line 4509: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

4505: 'OKC_REP_CONTRACT_PROCESS_PVT.Lock_Contract_Header return status is: '
4506: || x_return_status);
4507: END IF;
4508: -----------------------------------------------------
4509: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4510: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4511: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4512: RAISE OKC_API.G_EXCEPTION_ERROR;
4513: END IF;

Line 4510: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4506: || x_return_status);
4507: END IF;
4508: -----------------------------------------------------
4509: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4510: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4511: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4512: RAISE OKC_API.G_EXCEPTION_ERROR;
4513: END IF;
4514: -----------------------------------------------------

Line 4511: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

4507: END IF;
4508: -----------------------------------------------------
4509: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4510: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4511: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4512: RAISE OKC_API.G_EXCEPTION_ERROR;
4513: END IF;
4514: -----------------------------------------------------
4515: IF (trunc(p_termination_date) <= trunc(sysdate)) THEN

Line 4512: RAISE OKC_API.G_EXCEPTION_ERROR;

4508: -----------------------------------------------------
4509: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4510: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4511: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4512: RAISE OKC_API.G_EXCEPTION_ERROR;
4513: END IF;
4514: -----------------------------------------------------
4515: IF (trunc(p_termination_date) <= trunc(sysdate)) THEN
4516: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 4539: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

4535: g_module || l_api_name,
4536: 'Completed OKC_REP_UTIL_PVT.change_contract_status with return status: ' || x_return_status);
4537: END IF;
4538: -----------------------------------------------------
4539: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4540: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4541: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4542: RAISE OKC_API.G_EXCEPTION_ERROR;
4543: END IF;

Line 4540: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4536: 'Completed OKC_REP_UTIL_PVT.change_contract_status with return status: ' || x_return_status);
4537: END IF;
4538: -----------------------------------------------------
4539: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4540: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4541: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4542: RAISE OKC_API.G_EXCEPTION_ERROR;
4543: END IF;
4544: ------------------------------------------------------

Line 4541: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

4537: END IF;
4538: -----------------------------------------------------
4539: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4540: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4541: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4542: RAISE OKC_API.G_EXCEPTION_ERROR;
4543: END IF;
4544: ------------------------------------------------------
4545:

Line 4542: RAISE OKC_API.G_EXCEPTION_ERROR;

4538: -----------------------------------------------------
4539: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4540: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4541: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4542: RAISE OKC_API.G_EXCEPTION_ERROR;
4543: END IF;
4544: ------------------------------------------------------
4545:
4546: END IF; -- (p_termination_date <= sysdate)

Line 4579: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

4575: 'OKC_DELIVERABLE_PROCESS_PVT.activateCloseOutDeliverables return status is : '
4576: || x_return_status);
4577: END IF;
4578: -----------------------------------------------------
4579: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4580: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4581: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4582: RAISE OKC_API.G_EXCEPTION_ERROR;
4583: END IF;

Line 4580: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4576: || x_return_status);
4577: END IF;
4578: -----------------------------------------------------
4579: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4580: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4581: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4582: RAISE OKC_API.G_EXCEPTION_ERROR;
4583: END IF;
4584: --------------------------------------------------------

Line 4581: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

4577: END IF;
4578: -----------------------------------------------------
4579: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4580: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4581: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4582: RAISE OKC_API.G_EXCEPTION_ERROR;
4583: END IF;
4584: --------------------------------------------------------
4585: ELSE

Line 4582: RAISE OKC_API.G_EXCEPTION_ERROR;

4578: -----------------------------------------------------
4579: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4580: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4581: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4582: RAISE OKC_API.G_EXCEPTION_ERROR;
4583: END IF;
4584: --------------------------------------------------------
4585: ELSE
4586: IF (trunc(contract_rec.termination_date) <> trunc(p_termination_date)) THEN

Line 4612: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

4608: 'OKC_DELIVERABLE_PROCESS_PVT.updateDeliverables return status is : '
4609: || x_return_status);
4610: END IF;
4611: -----------------------------------------------------
4612: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4613: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4614: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4615: RAISE OKC_API.G_EXCEPTION_ERROR;
4616: END IF;

Line 4613: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

4609: || x_return_status);
4610: END IF;
4611: -----------------------------------------------------
4612: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4613: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4614: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4615: RAISE OKC_API.G_EXCEPTION_ERROR;
4616: END IF;
4617: --------------------------------------------------------

Line 4614: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

4610: END IF;
4611: -----------------------------------------------------
4612: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4613: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4614: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4615: RAISE OKC_API.G_EXCEPTION_ERROR;
4616: END IF;
4617: --------------------------------------------------------
4618: END IF; -- contract_rec.termination_date <> p_termination_date

Line 4615: RAISE OKC_API.G_EXCEPTION_ERROR;

4611: -----------------------------------------------------
4612: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4613: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4614: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4615: RAISE OKC_API.G_EXCEPTION_ERROR;
4616: END IF;
4617: --------------------------------------------------------
4618: END IF; -- contract_rec.termination_date <> p_termination_date
4619: END IF; -- contract_rec.termination_date = null

Line 4678: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

4674: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
4675: g_module || l_api_name,
4676: 'Leaving terminate_contract because of EXCEPTION: ' || sqlerrm);
4677: END IF;
4678: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
4679: p_msg_name => G_UNEXPECTED_ERROR,
4680: p_token1 => G_SQLCODE_TOKEN,
4681: p_token1_value => sqlcode,
4682: p_token2 => G_SQLERRM_TOKEN,

Line 5113: Okc_Api.Set_Message(

5109: FND_LOG.LEVEL_EXCEPTION,
5110: g_module || l_api_name,
5111: 'Leaving repository_notifier because of EXCEPTION: ' || sqlerrm);
5112: END IF;
5113: Okc_Api.Set_Message(
5114: p_app_name => G_APP_NAME,
5115: p_msg_name => G_UNEXPECTED_ERROR,
5116: p_token1 => G_SQLCODE_TOKEN,
5117: p_token1_value => SQLCODE,

Line 5217: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

5213: G_MODULE||l_api_name,
5214: 'Invalid Contract Id: '|| p_contract_id);
5215: END IF;
5216: CLOSE contract_csr;
5217: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
5218: p_msg_name => G_INVALID_CONTRACT_ID_MSG,
5219: p_token1 => G_CONTRACT_ID_TOKEN,
5220: p_token1_value => to_char(p_contract_id));
5221: RAISE FND_API.G_EXC_ERROR;

Line 5245: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

5241:
5242: ELSE
5243:
5244: -- Show an error message
5245: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
5246: p_msg_name => G_CANEL_APPROVAL_ERROR_MSG,
5247: p_token1 => G_CONTRACT_NUM_TOKEN,
5248: p_token1_value => l_contract_number);
5249: RAISE FND_API.G_EXC_ERROR;

Line 5277: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

5273: 'OKC_REP_UTIL_PVT.change_contract_status return status is: '
5274: || x_return_status);
5275: END IF;
5276: -----------------------------------------------------
5277: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5278: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5279: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
5280: RAISE OKC_API.G_EXCEPTION_ERROR;
5281: END IF;

Line 5278: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

5274: || x_return_status);
5275: END IF;
5276: -----------------------------------------------------
5277: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5278: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5279: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
5280: RAISE OKC_API.G_EXCEPTION_ERROR;
5281: END IF;
5282: --------------------------------------------------------

Line 5279: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

5275: END IF;
5276: -----------------------------------------------------
5277: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5278: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5279: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
5280: RAISE OKC_API.G_EXCEPTION_ERROR;
5281: END IF;
5282: --------------------------------------------------------
5283:

Line 5280: RAISE OKC_API.G_EXCEPTION_ERROR;

5276: -----------------------------------------------------
5277: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5278: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5279: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
5280: RAISE OKC_API.G_EXCEPTION_ERROR;
5281: END IF;
5282: --------------------------------------------------------
5283:
5284:

Line 5308: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

5304: 'OKC_REP_UTIL_PVT.add_approval_hist_record return status is: '
5305: || x_return_status);
5306: END IF;
5307: -------------------------------------------------------
5308: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5309: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5310: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
5311: RAISE OKC_API.G_EXCEPTION_ERROR;
5312: END IF;

Line 5309: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

5305: || x_return_status);
5306: END IF;
5307: -------------------------------------------------------
5308: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5309: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5310: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
5311: RAISE OKC_API.G_EXCEPTION_ERROR;
5312: END IF;
5313: --------------------------------------------------------

Line 5310: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

5306: END IF;
5307: -------------------------------------------------------
5308: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5309: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5310: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
5311: RAISE OKC_API.G_EXCEPTION_ERROR;
5312: END IF;
5313: --------------------------------------------------------
5314:

Line 5311: RAISE OKC_API.G_EXCEPTION_ERROR;

5307: -------------------------------------------------------
5308: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
5309: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5310: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
5311: RAISE OKC_API.G_EXCEPTION_ERROR;
5312: END IF;
5313: --------------------------------------------------------
5314:
5315: COMMIT WORK;

Line 5370: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

5366: --close cursors
5367: IF (contract_csr%ISOPEN) THEN
5368: CLOSE contract_csr ;
5369: END IF;
5370: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
5371: p_msg_name => G_UNEXPECTED_ERROR,
5372: p_token1 => G_SQLCODE_TOKEN,
5373: p_token1_value => sqlcode,
5374: p_token2 => G_SQLERRM_TOKEN,

Line 5573: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

5569: IF l_row_notfound THEN
5570: NULL; -- dups do not exist.
5571: ELSE
5572: -- Show duplicate Contract number error message
5573: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
5574: p_msg_name => G_INVALID_CONTRACT_NUMBER_MSG);
5575: RAISE FND_API.G_EXC_ERROR;
5576:
5577: END IF;

Line 5652: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

5648: IF (l_get_sob_csr%ISOPEN) THEN
5649: CLOSE l_get_sob_csr ;
5650: END IF;
5651:
5652: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
5653: p_msg_name => G_UNEXPECTED_ERROR,
5654: p_token1 => G_SQLCODE_TOKEN,
5655: p_token1_value => sqlcode,
5656: p_token2 => G_SQLERRM_TOKEN,