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.OKS_K_ACTIONS_PVT dependencies on FND_API

Line 14: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;

10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_MODULE CONSTANT VARCHAR2(250) := 'oks.plsql.'||g_pkg_name||'.';
12: G_APPLICATION_ID CONSTANT NUMBER :=515; -- OKS Application
13:
14: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
15: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
16:
17: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
18: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

Line 15: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;

11: G_MODULE CONSTANT VARCHAR2(250) := 'oks.plsql.'||g_pkg_name||'.';
12: G_APPLICATION_ID CONSTANT NUMBER :=515; -- OKS Application
13:
14: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
15: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
16:
17: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
18: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
19: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

Line 17: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

13:
14: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
15: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
16:
17: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
18: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
19: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
20:
21: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_UNEXPECTED_ERROR';

Line 18: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

14: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
15: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
16:
17: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
18: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
19: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
20:
21: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_UNEXPECTED_ERROR';
22: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';

Line 19: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

15: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
16:
17: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
18: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
19: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
20:
21: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_UNEXPECTED_ERROR';
22: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
23: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';

Line 56: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

52: G_MODULE||l_api_name,
53: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
54: END IF;
55: -- Standard call to check for call compatibility.
56: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
57: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
58: END IF;
59:
60:

Line 57: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

53: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
54: END IF;
55: -- Standard call to check for call compatibility.
56: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
57: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
58: END IF;
59:
60:
61: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 62: IF FND_API.to_Boolean( p_init_msg_list ) THEN

58: END IF;
59:
60:
61: -- Initialize message list if p_init_msg_list is set to TRUE.
62: IF FND_API.to_Boolean( p_init_msg_list ) THEN
63: FND_MSG_PUB.initialize;
64: END IF;
65:
66: -- Initialize API return status to success

Line 67: x_return_status := FND_API.G_RET_STS_SUCCESS;

63: FND_MSG_PUB.initialize;
64: END IF;
65:
66: -- Initialize API return status to success
67: x_return_status := FND_API.G_RET_STS_SUCCESS;
68:
69: -- check if the contract is valid for setting reminders
70: IF validateForRenewalAction (p_chr_id,'RMDR') = 'Y' THEN
71: update oks_k_headers_b

Line 133: WHEN FND_API.G_EXC_ERROR THEN

129: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.ActionNotAllowedException '||
130: ' Contract cannot be published since it is not in entered status');
131: END IF;
132: x_return_status := G_RET_STS_ACTION_NOT_ALWD;
133: WHEN FND_API.G_EXC_ERROR THEN
134: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
135: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
136: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name||' with ERROR status');
137: END IF;

Line 142: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

138:
139: x_return_status := G_RET_STS_ERROR ;
140: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
141:
142: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
143: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
144: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
145: G_MODULE||l_api_name,
146: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name||' with Unexpected Error status');

Line 227: ,p_init_msg_list => FND_API.G_FALSE

223: END IF;
224:
225: OKS_RENEW_CONTRACT_PVT.get_user_name(
226: p_api_version => '1'
227: ,p_init_msg_list => FND_API.G_FALSE
228: ,x_return_status => l_return_status
229: ,x_msg_count => l_msg_count
230: ,x_msg_data => l_msg_data
231: ,p_chr_id => p_chr_id

Line 286: WHEN FND_API.G_EXC_ERROR THEN

282:
283: commit work;
284:
285: EXCEPTION
286: WHEN FND_API.G_EXC_ERROR THEN
287: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
288: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
289: G_MODULE||l_api_name,
290: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

292:
293: x_return_status := G_RET_STS_ERROR ;
294: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
295:
296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
297: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
298: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
299: G_MODULE||l_api_name,
300: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 383: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

379:
380: -- bug 5329334
381: -- should loop thru l_msg_tbl(l_count).error_status to check if there are any qa errors
382:
383: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
384: x_return_status :=l_return_status;
385: RETURN;
386: END IF;
387:

Line 422: WHEN FND_API.G_EXC_ERROR THEN

418: fnd_file.put_line(FND_FILE.LOG,'x_return_status : '||x_return_status);
419: fnd_file.put_line(FND_FILE.LOG,' ');
420:
421: EXCEPTION
422: WHEN FND_API.G_EXC_ERROR THEN
423: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
424: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
425: G_MODULE||l_api_name,
426: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 432: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

428:
429: x_return_status := G_RET_STS_ERROR ;
430: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
431:
432: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
433: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
434: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
435: G_MODULE||l_api_name,
436: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 503: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

499: '100: p_contract_list : '||p_contract_list);
500: END IF;
501:
502: -- Standard call to check for call compatibility.
503: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
505: END IF;
506:
507: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

500: END IF;
501:
502: -- Standard call to check for call compatibility.
503: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
505: END IF;
506:
507: -- Initialize message list if p_init_msg_list is set to TRUE.
508: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 508: IF FND_API.to_Boolean( p_init_msg_list ) THEN

504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
505: END IF;
506:
507: -- Initialize message list if p_init_msg_list is set to TRUE.
508: IF FND_API.to_Boolean( p_init_msg_list ) THEN
509: FND_MSG_PUB.initialize;
510: END IF;
511:
512: -- Initialize API return status to success

Line 513: x_return_status := FND_API.G_RET_STS_SUCCESS;

509: FND_MSG_PUB.initialize;
510: END IF;
511:
512: -- Initialize API return status to success
513: x_return_status := FND_API.G_RET_STS_SUCCESS;
514:
515: -- set context to multi org
516: mo_global.init('OKC');
517:

Line 633: WHEN FND_API.G_EXC_ERROR THEN

629: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
630: END IF;
631:
632: EXCEPTION
633: WHEN FND_API.G_EXC_ERROR THEN
634: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
635: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
636: G_MODULE||l_api_name,
637: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 643: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

639:
640: x_return_status := G_RET_STS_ERROR ;
641: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
642:
643: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
644: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
645: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
646: G_MODULE||l_api_name,
647: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 785: x_return_status := FND_API.G_RET_STS_SUCCESS;

781:
782: BEGIN
783:
784: -- Initialize API return status to success
785: x_return_status := FND_API.G_RET_STS_SUCCESS;
786:
787: -- set context to multi org
788: mo_global.init('OKC');
789:

Line 899: WHEN FND_API.G_EXC_ERROR THEN

895: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
896: END IF;
897:
898: EXCEPTION
899: WHEN FND_API.G_EXC_ERROR THEN
900: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
901: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
902: G_MODULE||l_api_name,
903: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 908: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

904: END IF;
905:
906: x_return_status := G_RET_STS_ERROR ;
907:
908: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
909: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
910: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
911: G_MODULE||l_api_name,
912: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 957: x_return_status := FND_API.G_RET_STS_SUCCESS;

953: '301: p_email_id : '||p_email_id);
954: END IF;
955:
956: -- Initialize API return status to success
957: x_return_status := FND_API.G_RET_STS_SUCCESS;
958:
959: -- set context to multi org
960: mo_global.init('OKC');
961:

Line 976: WHEN FND_API.G_EXC_ERROR THEN

972: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
973: END IF;
974:
975: EXCEPTION
976: WHEN FND_API.G_EXC_ERROR THEN
977: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
978: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
979: G_MODULE||l_api_name,
980: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 985: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

981: END IF;
982:
983: x_return_status := G_RET_STS_ERROR ;
984:
985: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
986: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
987: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
988: G_MODULE||l_api_name,
989: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 1034: x_return_status := FND_API.G_RET_STS_SUCCESS;

1030: '401: p_email_id : '||p_email_id);
1031: END IF;
1032:
1033: -- Initialize API return status to success
1034: x_return_status := FND_API.G_RET_STS_SUCCESS;
1035:
1036: -- set context to multi org
1037: mo_global.init('OKC');
1038:

Line 1059: WHEN FND_API.G_EXC_ERROR THEN

1055: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1056: END IF;
1057:
1058: EXCEPTION
1059: WHEN FND_API.G_EXC_ERROR THEN
1060: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1061: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1062: G_MODULE||l_api_name,
1063: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 1068: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1064: END IF;
1065:
1066: x_return_status := G_RET_STS_ERROR ;
1067:
1068: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1069: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1070: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1071: G_MODULE||l_api_name,
1072: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 1152: ,p_init_msg_list => FND_API.G_FALSE

1148: END IF;
1149:
1150: OKS_RENEW_CONTRACT_PVT.get_user_name(
1151: p_api_version => '1'
1152: ,p_init_msg_list => FND_API.G_FALSE
1153: ,x_return_status => l_return_status
1154: ,x_msg_count => l_msg_count
1155: ,x_msg_data => l_msg_data
1156: ,p_chr_id => p_chr_id

Line 1212: WHEN FND_API.G_EXC_ERROR THEN

1208:
1209: commit work;
1210:
1211: EXCEPTION
1212: WHEN FND_API.G_EXC_ERROR THEN
1213: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1214: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1215: G_MODULE||l_api_name,
1216: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 1222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1218:
1219: x_return_status := G_RET_STS_ERROR ;
1220: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1221:
1222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1223: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1224: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1225: G_MODULE||l_api_name,
1226: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 1309: x_return_status := fnd_api.g_ret_sts_success;

1305: -- set context to multi org
1306: mo_global.init ('OKC');
1307:
1308: -- Initialize API return status to success
1309: x_return_status := fnd_api.g_ret_sts_success;
1310:
1311: DBMS_TRANSACTION.SAVEPOINT(l_api_name);
1312:
1313: -- Printing input paramter values

Line 1433: p_init_msg_list => FND_API.G_TRUE,

1429: OKS_CHANGE_STATUS_PVT.UPDATE_HEADER_STATUS(
1430: x_return_status => x_return_status,
1431: x_msg_data => x_msg_data,
1432: x_msg_count => x_msg_count,
1433: p_init_msg_list => FND_API.G_TRUE,
1434: p_id => p_chr_id,
1435: p_new_sts_code => p_status_code,
1436: p_canc_reason_code => p_reason_code,
1437: p_old_sts_code => l_old_status_code,

Line 1461: RAISE fnd_api.g_exc_unexpected_error;

1457: END IF;
1458:
1459: --- If any errors happen abort API
1460: IF (NVL(x_return_status,'U') = g_ret_sts_unexp_error) THEN
1461: RAISE fnd_api.g_exc_unexpected_error;
1462: ELSIF (x_return_status = g_ret_sts_error) THEN
1463: RAISE fnd_api.g_exc_error;
1464: END IF;
1465: --OKS_CHANGE_STATUS_PVT.UPDATE_HEADER_STATUS API already updated minor version

Line 1463: RAISE fnd_api.g_exc_error;

1459: --- If any errors happen abort API
1460: IF (NVL(x_return_status,'U') = g_ret_sts_unexp_error) THEN
1461: RAISE fnd_api.g_exc_unexpected_error;
1462: ELSIF (x_return_status = g_ret_sts_error) THEN
1463: RAISE fnd_api.g_exc_error;
1464: END IF;
1465: --OKS_CHANGE_STATUS_PVT.UPDATE_HEADER_STATUS API already updated minor version
1466: l_minor_version_updated := 'T';
1467:

Line 1531: RAISE fnd_api.g_exc_unexpected_error;

1527: IF (NVL(x_return_status,'U') = g_ret_sts_unexp_error) THEN
1528: fnd_message.set_name('OKS','OKS_JTF_NOTES_FAILED');
1529: x_msg_data := fnd_message.get;
1530: x_msg_count := 1;
1531: RAISE fnd_api.g_exc_unexpected_error;
1532: ELSIF (x_return_status = g_ret_sts_error) THEN
1533: fnd_message.set_name('OKS','OKS_JTF_NOTES_FAILED');
1534: x_msg_data := fnd_message.get;
1535: x_msg_count := 1;

Line 1536: RAISE fnd_api.g_exc_error;

1532: ELSIF (x_return_status = g_ret_sts_error) THEN
1533: fnd_message.set_name('OKS','OKS_JTF_NOTES_FAILED');
1534: x_msg_data := fnd_message.get;
1535: x_msg_count := 1;
1536: RAISE fnd_api.g_exc_error;
1537: END IF;
1538:
1539: END IF;--end Update jtf Notes
1540:

Line 1586: x_return_status := fnd_api.g_ret_sts_success;

1582: last_update_login = FND_GLOBAL.LOGIN_ID
1583: where okcb.id = p_chr_id;
1584:
1585: if(SQL%ROWCOUNT =1) then
1586: x_return_status := fnd_api.g_ret_sts_success;
1587: else
1588: l_sql_err := SQLERRM;
1589: fnd_message.set_name('OKS','OKS_FOREACST_FOLLOWUP_ERROR');
1590: fnd_message.set_token ('ERROR_MESSAGE', l_sql_err);

Line 1614: RAISE fnd_api.g_exc_unexpected_error;

1610: END IF;
1611:
1612: --- If any errors happen abort API
1613: IF (NVL(x_return_status,'U') = g_ret_sts_unexp_error) THEN
1614: RAISE fnd_api.g_exc_unexpected_error;
1615: ELSIF (x_return_status = g_ret_sts_error) THEN
1616: RAISE fnd_api.g_exc_error;
1617: END IF;
1618:

Line 1616: RAISE fnd_api.g_exc_error;

1612: --- If any errors happen abort API
1613: IF (NVL(x_return_status,'U') = g_ret_sts_unexp_error) THEN
1614: RAISE fnd_api.g_exc_unexpected_error;
1615: ELSIF (x_return_status = g_ret_sts_error) THEN
1616: RAISE fnd_api.g_exc_error;
1617: END IF;
1618:
1619: end if;--end Update Follow Up Action and Date
1620:

Line 1649: RAISE fnd_api.g_exc_unexpected_error;

1645:
1646:
1647: --- If any errors happen abort API
1648: IF (NVL(x_return_status,'U') = g_ret_sts_unexp_error) THEN
1649: RAISE fnd_api.g_exc_unexpected_error;
1650: ELSIF (x_return_status = g_ret_sts_error) THEN
1651: RAISE fnd_api.g_exc_error;
1652: END IF;
1653:

Line 1651: RAISE fnd_api.g_exc_error;

1647: --- If any errors happen abort API
1648: IF (NVL(x_return_status,'U') = g_ret_sts_unexp_error) THEN
1649: RAISE fnd_api.g_exc_unexpected_error;
1650: ELSIF (x_return_status = g_ret_sts_error) THEN
1651: RAISE fnd_api.g_exc_error;
1652: END IF;
1653:
1654: END IF; --End: Update Renewal Notes - kkolukul
1655:

Line 1673: x_return_status := fnd_api.g_ret_sts_success;

1669: Set minor_version = minor_version + 1
1670: Where chr_id = p_chr_id;
1671:
1672: if(SQL%ROWCOUNT =1) then
1673: x_return_status := fnd_api.g_ret_sts_success;
1674: else
1675: l_sql_err := SQLERRM;
1676: fnd_message.set_name('OKS','OKS_K_VERSION_UPD_FAILED');
1677: fnd_message.set_token ('ERROR_MESSAGE', l_sql_err);

Line 1719: RAISE fnd_api.g_exc_unexpected_error;

1715: END IF;
1716:
1717: --- If any errors happen abort API
1718: IF (NVL(x_return_status,'U') = g_ret_sts_unexp_error) THEN
1719: RAISE fnd_api.g_exc_unexpected_error;
1720: ELSIF (x_return_status = g_ret_sts_error) THEN
1721: RAISE fnd_api.g_exc_error;
1722: END IF;
1723: end if;--end update minor version

Line 1721: RAISE fnd_api.g_exc_error;

1717: --- If any errors happen abort API
1718: IF (NVL(x_return_status,'U') = g_ret_sts_unexp_error) THEN
1719: RAISE fnd_api.g_exc_unexpected_error;
1720: ELSIF (x_return_status = g_ret_sts_error) THEN
1721: RAISE fnd_api.g_exc_error;
1722: END IF;
1723: end if;--end update minor version
1724:
1725: commit work;

Line 1743: WHEN fnd_api.g_exc_error THEN

1739: /* Added by sjanakir FP for Bug# 7147899 */
1740: END IF;
1741:
1742: EXCEPTION
1743: WHEN fnd_api.g_exc_error THEN
1744: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
1745:
1746: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1747: fnd_log.STRING (fnd_log.level_statement,

Line 1763: WHEN fnd_api.g_exc_unexpected_error THEN

1759: fnd_msg_pub.count_and_get (p_encoded => 'F',
1760: p_count => x_msg_count,
1761: p_data => x_msg_data
1762: );
1763: WHEN fnd_api.g_exc_unexpected_error THEN
1764: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
1765:
1766: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1767: fnd_log.STRING (fnd_log.level_statement,