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 55: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

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

Line 56: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 61: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 66: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 104: WHEN FND_API.G_EXC_ERROR THEN

100: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.ActionNotAllowedException '||
101: ' Contract cannot be published since it is not in entered status');
102: END IF;
103: x_return_status := G_RET_STS_ACTION_NOT_ALWD;
104: WHEN FND_API.G_EXC_ERROR THEN
105: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
106: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
107: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name||' with ERROR status');
108: END IF;

Line 113: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

109:
110: x_return_status := G_RET_STS_ERROR ;
111: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
112:
113: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
114: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
115: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
116: G_MODULE||l_api_name,
117: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name||' with Unexpected Error status');

Line 198: ,p_init_msg_list => FND_API.G_FALSE

194: END IF;
195:
196: OKS_RENEW_CONTRACT_PVT.get_user_name(
197: p_api_version => '1'
198: ,p_init_msg_list => FND_API.G_FALSE
199: ,x_return_status => l_return_status
200: ,x_msg_count => l_msg_count
201: ,x_msg_data => l_msg_data
202: ,p_chr_id => p_chr_id

Line 257: WHEN FND_API.G_EXC_ERROR THEN

253:
254: commit work;
255:
256: EXCEPTION
257: WHEN FND_API.G_EXC_ERROR THEN
258: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
259: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
260: G_MODULE||l_api_name,
261: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

263:
264: x_return_status := G_RET_STS_ERROR ;
265: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
266:
267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
268: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
269: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
270: G_MODULE||l_api_name,
271: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 354: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

350:
351: -- bug 5329334
352: -- should loop thru l_msg_tbl(l_count).error_status to check if there are any qa errors
353:
354: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
355: x_return_status :=l_return_status;
356: RETURN;
357: END IF;
358:

Line 393: WHEN FND_API.G_EXC_ERROR THEN

389: fnd_file.put_line(FND_FILE.LOG,'x_return_status : '||x_return_status);
390: fnd_file.put_line(FND_FILE.LOG,' ');
391:
392: EXCEPTION
393: WHEN FND_API.G_EXC_ERROR THEN
394: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
395: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
396: G_MODULE||l_api_name,
397: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 403: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

399:
400: x_return_status := G_RET_STS_ERROR ;
401: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
402:
403: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
404: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
405: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
406: G_MODULE||l_api_name,
407: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

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

470: '100: p_contract_list : '||p_contract_list);
471: END IF;
472:
473: -- Standard call to check for call compatibility.
474: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
476: END IF;
477:
478: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

471: END IF;
472:
473: -- Standard call to check for call compatibility.
474: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
476: END IF;
477:
478: -- Initialize message list if p_init_msg_list is set to TRUE.
479: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 479: IF FND_API.to_Boolean( p_init_msg_list ) THEN

475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
476: END IF;
477:
478: -- Initialize message list if p_init_msg_list is set to TRUE.
479: IF FND_API.to_Boolean( p_init_msg_list ) THEN
480: FND_MSG_PUB.initialize;
481: END IF;
482:
483: -- Initialize API return status to success

Line 484: x_return_status := FND_API.G_RET_STS_SUCCESS;

480: FND_MSG_PUB.initialize;
481: END IF;
482:
483: -- Initialize API return status to success
484: x_return_status := FND_API.G_RET_STS_SUCCESS;
485:
486: -- set context to multi org
487: mo_global.init('OKC');
488:

Line 604: WHEN FND_API.G_EXC_ERROR THEN

600: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
601: END IF;
602:
603: EXCEPTION
604: WHEN FND_API.G_EXC_ERROR THEN
605: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
606: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
607: G_MODULE||l_api_name,
608: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 614: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

610:
611: x_return_status := G_RET_STS_ERROR ;
612: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
613:
614: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
615: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
616: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
617: G_MODULE||l_api_name,
618: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 756: x_return_status := FND_API.G_RET_STS_SUCCESS;

752:
753: BEGIN
754:
755: -- Initialize API return status to success
756: x_return_status := FND_API.G_RET_STS_SUCCESS;
757:
758: -- set context to multi org
759: mo_global.init('OKC');
760:

Line 870: WHEN FND_API.G_EXC_ERROR THEN

866: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
867: END IF;
868:
869: EXCEPTION
870: WHEN FND_API.G_EXC_ERROR THEN
871: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
872: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
873: G_MODULE||l_api_name,
874: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 879: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

875: END IF;
876:
877: x_return_status := G_RET_STS_ERROR ;
878:
879: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
880: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
881: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
882: G_MODULE||l_api_name,
883: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 928: x_return_status := FND_API.G_RET_STS_SUCCESS;

924: '301: p_email_id : '||p_email_id);
925: END IF;
926:
927: -- Initialize API return status to success
928: x_return_status := FND_API.G_RET_STS_SUCCESS;
929:
930: -- set context to multi org
931: mo_global.init('OKC');
932:

Line 947: WHEN FND_API.G_EXC_ERROR THEN

943: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
944: END IF;
945:
946: EXCEPTION
947: WHEN FND_API.G_EXC_ERROR THEN
948: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
949: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
950: G_MODULE||l_api_name,
951: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 956: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

952: END IF;
953:
954: x_return_status := G_RET_STS_ERROR ;
955:
956: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
957: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
958: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
959: G_MODULE||l_api_name,
960: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 1005: x_return_status := FND_API.G_RET_STS_SUCCESS;

1001: '401: p_email_id : '||p_email_id);
1002: END IF;
1003:
1004: -- Initialize API return status to success
1005: x_return_status := FND_API.G_RET_STS_SUCCESS;
1006:
1007: -- set context to multi org
1008: mo_global.init('OKC');
1009:

Line 1030: WHEN FND_API.G_EXC_ERROR THEN

1026: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1027: END IF;
1028:
1029: EXCEPTION
1030: WHEN FND_API.G_EXC_ERROR THEN
1031: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1032: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1033: G_MODULE||l_api_name,
1034: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 1039: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1035: END IF;
1036:
1037: x_return_status := G_RET_STS_ERROR ;
1038:
1039: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1040: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1041: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1042: G_MODULE||l_api_name,
1043: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 1123: ,p_init_msg_list => FND_API.G_FALSE

1119: END IF;
1120:
1121: OKS_RENEW_CONTRACT_PVT.get_user_name(
1122: p_api_version => '1'
1123: ,p_init_msg_list => FND_API.G_FALSE
1124: ,x_return_status => l_return_status
1125: ,x_msg_count => l_msg_count
1126: ,x_msg_data => l_msg_data
1127: ,p_chr_id => p_chr_id

Line 1183: WHEN FND_API.G_EXC_ERROR THEN

1179:
1180: commit work;
1181:
1182: EXCEPTION
1183: WHEN FND_API.G_EXC_ERROR THEN
1184: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1185: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1186: G_MODULE||l_api_name,
1187: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 1193: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1189:
1190: x_return_status := G_RET_STS_ERROR ;
1191: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1192:
1193: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1194: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1195: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1196: G_MODULE||l_api_name,
1197: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 1279: x_return_status := fnd_api.g_ret_sts_success;

1275: -- set context to multi org
1276: mo_global.init ('OKC');
1277:
1278: -- Initialize API return status to success
1279: x_return_status := fnd_api.g_ret_sts_success;
1280:
1281: DBMS_TRANSACTION.SAVEPOINT(l_api_name);
1282:
1283: -- Printing input paramter values

Line 1403: p_init_msg_list => FND_API.G_TRUE,

1399: OKS_CHANGE_STATUS_PVT.UPDATE_HEADER_STATUS(
1400: x_return_status => x_return_status,
1401: x_msg_data => x_msg_data,
1402: x_msg_count => x_msg_count,
1403: p_init_msg_list => FND_API.G_TRUE,
1404: p_id => p_chr_id,
1405: p_new_sts_code => p_status_code,
1406: p_canc_reason_code => p_reason_code,
1407: p_old_sts_code => l_old_status_code,

Line 1431: RAISE fnd_api.g_exc_unexpected_error;

1427: END IF;
1428:
1429: --- If any errors happen abort API
1430: IF (NVL(x_return_status,'U') = g_ret_sts_unexp_error) THEN
1431: RAISE fnd_api.g_exc_unexpected_error;
1432: ELSIF (x_return_status = g_ret_sts_error) THEN
1433: RAISE fnd_api.g_exc_error;
1434: END IF;
1435: --OKS_CHANGE_STATUS_PVT.UPDATE_HEADER_STATUS API already updated minor version

Line 1433: RAISE fnd_api.g_exc_error;

1429: --- If any errors happen abort API
1430: IF (NVL(x_return_status,'U') = g_ret_sts_unexp_error) THEN
1431: RAISE fnd_api.g_exc_unexpected_error;
1432: ELSIF (x_return_status = g_ret_sts_error) THEN
1433: RAISE fnd_api.g_exc_error;
1434: END IF;
1435: --OKS_CHANGE_STATUS_PVT.UPDATE_HEADER_STATUS API already updated minor version
1436: l_minor_version_updated := 'T';
1437:

Line 1501: RAISE fnd_api.g_exc_unexpected_error;

1497: IF (NVL(x_return_status,'U') = g_ret_sts_unexp_error) THEN
1498: fnd_message.set_name('OKS','OKS_JTF_NOTES_FAILED');
1499: x_msg_data := fnd_message.get;
1500: x_msg_count := 1;
1501: RAISE fnd_api.g_exc_unexpected_error;
1502: ELSIF (x_return_status = g_ret_sts_error) THEN
1503: fnd_message.set_name('OKS','OKS_JTF_NOTES_FAILED');
1504: x_msg_data := fnd_message.get;
1505: x_msg_count := 1;

Line 1506: RAISE fnd_api.g_exc_error;

1502: ELSIF (x_return_status = g_ret_sts_error) THEN
1503: fnd_message.set_name('OKS','OKS_JTF_NOTES_FAILED');
1504: x_msg_data := fnd_message.get;
1505: x_msg_count := 1;
1506: RAISE fnd_api.g_exc_error;
1507: END IF;
1508:
1509: END IF;--end Update jtf Notes
1510:

Line 1547: x_return_status := fnd_api.g_ret_sts_success;

1543: last_update_login = FND_GLOBAL.LOGIN_ID
1544: where okcb.id = p_chr_id;
1545:
1546: if(SQL%ROWCOUNT =1) then
1547: x_return_status := fnd_api.g_ret_sts_success;
1548: else
1549: l_sql_err := SQLERRM;
1550: fnd_message.set_name('OKS','OKS_FOREACST_FOLLOWUP_ERROR');
1551: fnd_message.set_token ('ERROR_MESSAGE', l_sql_err);

Line 1575: RAISE fnd_api.g_exc_unexpected_error;

1571: END IF;
1572:
1573: --- If any errors happen abort API
1574: IF (NVL(x_return_status,'U') = g_ret_sts_unexp_error) THEN
1575: RAISE fnd_api.g_exc_unexpected_error;
1576: ELSIF (x_return_status = g_ret_sts_error) THEN
1577: RAISE fnd_api.g_exc_error;
1578: END IF;
1579:

Line 1577: RAISE fnd_api.g_exc_error;

1573: --- If any errors happen abort API
1574: IF (NVL(x_return_status,'U') = g_ret_sts_unexp_error) THEN
1575: RAISE fnd_api.g_exc_unexpected_error;
1576: ELSIF (x_return_status = g_ret_sts_error) THEN
1577: RAISE fnd_api.g_exc_error;
1578: END IF;
1579:
1580: end if;--end Update Follow Up Action and Date
1581:

Line 1599: x_return_status := fnd_api.g_ret_sts_success;

1595: Set minor_version = minor_version + 1
1596: Where chr_id = p_chr_id;
1597:
1598: if(SQL%ROWCOUNT =1) then
1599: x_return_status := fnd_api.g_ret_sts_success;
1600: else
1601: l_sql_err := SQLERRM;
1602: fnd_message.set_name('OKS','OKS_K_VERSION_UPD_FAILED');
1603: fnd_message.set_token ('ERROR_MESSAGE', l_sql_err);

Line 1645: RAISE fnd_api.g_exc_unexpected_error;

1641: END IF;
1642:
1643: --- If any errors happen abort API
1644: IF (NVL(x_return_status,'U') = g_ret_sts_unexp_error) THEN
1645: RAISE fnd_api.g_exc_unexpected_error;
1646: ELSIF (x_return_status = g_ret_sts_error) THEN
1647: RAISE fnd_api.g_exc_error;
1648: END IF;
1649: end if;--end update minor version

Line 1647: RAISE fnd_api.g_exc_error;

1643: --- If any errors happen abort API
1644: IF (NVL(x_return_status,'U') = g_ret_sts_unexp_error) THEN
1645: RAISE fnd_api.g_exc_unexpected_error;
1646: ELSIF (x_return_status = g_ret_sts_error) THEN
1647: RAISE fnd_api.g_exc_error;
1648: END IF;
1649: end if;--end update minor version
1650:
1651: commit work;

Line 1667: WHEN fnd_api.g_exc_error THEN

1663: END IF;
1664:
1665:
1666: EXCEPTION
1667: WHEN fnd_api.g_exc_error THEN
1668: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
1669:
1670: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1671: fnd_log.STRING (fnd_log.level_statement,

Line 1687: WHEN fnd_api.g_exc_unexpected_error THEN

1683: fnd_msg_pub.count_and_get (p_encoded => 'F',
1684: p_count => x_msg_count,
1685: p_data => x_msg_data
1686: );
1687: WHEN fnd_api.g_exc_unexpected_error THEN
1688: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
1689:
1690: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1691: fnd_log.STRING (fnd_log.level_statement,