DBA Data[Home] [Help]

APPS.OKS_K_ACTIONS_PVT dependencies on FND_MESSAGE

Line 90: fnd_message.set_name('OKS','OKS_K_VERSION_UPD_FAILED');

86: x_return_status := OKC_CVM_PVT.update_minor_version(p_chr_id => p_chr_id);
87:
88: IF x_return_status <> G_RET_STS_SUCCESS THEN
89: l_sql_err := SQLERRM;
90: fnd_message.set_name('OKS','OKS_K_VERSION_UPD_FAILED');
91: fnd_message.set_token ('ERROR_MESSAGE', l_sql_err);
92:
93: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
94: fnd_log.STRING (fnd_log.level_statement, g_module ||l_api_name,

Line 91: fnd_message.set_token ('ERROR_MESSAGE', l_sql_err);

87:
88: IF x_return_status <> G_RET_STS_SUCCESS THEN
89: l_sql_err := SQLERRM;
90: fnd_message.set_name('OKS','OKS_K_VERSION_UPD_FAILED');
91: fnd_message.set_token ('ERROR_MESSAGE', l_sql_err);
92:
93: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
94: fnd_log.STRING (fnd_log.level_statement, g_module ||l_api_name,
95: '1111:Reminder Suppress Flag Update Failed - l_sql_err:'||l_sql_err);

Line 98: x_msg_data := fnd_message.get;

94: fnd_log.STRING (fnd_log.level_statement, g_module ||l_api_name,
95: '1111:Reminder Suppress Flag Update Failed - l_sql_err:'||l_sql_err);
96: END IF;
97:
98: x_msg_data := fnd_message.get;
99: x_return_status := g_ret_sts_error;
100: x_msg_count := 1;
101:
102: END IF;

Line 581: fnd_message.set_name(G_APP_NAME,'OKS_SUBMIT_MAX_QA_ERROR');

577: END IF;
578:
579: -- if the number of contracts exceed 6 then throw an error
580: IF NVL(l_chr_id_tbl.COUNT,0) > 6 THEN
581: fnd_message.set_name(G_APP_NAME,'OKS_SUBMIT_MAX_QA_ERROR');
582: fnd_msg_pub.add;
583: x_return_status := G_RET_STS_ERROR ;
584: RETURN;
585: END IF;

Line 611: FND_MESSAGE.SET_NAME('OKS','OKS_CP_ERROR');

607: UPDATE OKS_K_HEADERS_B
608: SET PROCESS_REQUEST_ID = l_request_id
609: WHERE chr_id = l_chr_id_tbl(i);
610: ELSE
611: FND_MESSAGE.SET_NAME('OKS','OKS_CP_ERROR');
612: FND_MESSAGE.SET_TOKEN('SQL_ERROR',SQLERRM);
613: FND_MSG_PUB.ADD;
614: x_return_status := G_RET_STS_ERROR ;
615: END IF;

Line 612: FND_MESSAGE.SET_TOKEN('SQL_ERROR',SQLERRM);

608: SET PROCESS_REQUEST_ID = l_request_id
609: WHERE chr_id = l_chr_id_tbl(i);
610: ELSE
611: FND_MESSAGE.SET_NAME('OKS','OKS_CP_ERROR');
612: FND_MESSAGE.SET_TOKEN('SQL_ERROR',SQLERRM);
613: FND_MSG_PUB.ADD;
614: x_return_status := G_RET_STS_ERROR ;
615: END IF;
616:

Line 1528: fnd_message.set_name('OKS','OKS_JTF_NOTES_FAILED');

1524: END IF;
1525:
1526: --- If any errors happen abort API
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

Line 1529: x_msg_data := fnd_message.get;

1525:
1526: --- If any errors happen abort API
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');

Line 1533: 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;
1536: RAISE fnd_api.g_exc_error;
1537: END IF;

Line 1534: 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;
1536: RAISE fnd_api.g_exc_error;
1537: END IF;
1538:

Line 1545: fnd_message.set_name('OKS','OKS_FORECAST_UPDATE_FAILED');

1541: /* Added by sjanakir FP for Bug# 7147899 */
1542: IF (p_est_percent IS NOT NULL AND p_est_date IS NULL AND l_old_est_rev_date IS NULL) OR
1543: (p_est_date IS NOT NULL AND p_est_percent IS NULL AND l_old_est_rev_percent IS NULL)
1544: THEN
1545: fnd_message.set_name('OKS','OKS_FORECAST_UPDATE_FAILED');
1546: x_msg_data:= fnd_message.get;
1547: x_return_status := g_ret_sts_error;
1548: x_msg_count := 1;
1549:

Line 1546: x_msg_data:= fnd_message.get;

1542: IF (p_est_percent IS NOT NULL AND p_est_date IS NULL AND l_old_est_rev_date IS NULL) OR
1543: (p_est_date IS NOT NULL AND p_est_percent IS NULL AND l_old_est_rev_percent IS NULL)
1544: THEN
1545: fnd_message.set_name('OKS','OKS_FORECAST_UPDATE_FAILED');
1546: x_msg_data:= fnd_message.get;
1547: x_return_status := g_ret_sts_error;
1548: x_msg_count := 1;
1549:
1550: ELSE

Line 1589: fnd_message.set_name('OKS','OKS_FOREACST_FOLLOWUP_ERROR');

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);
1591:
1592: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1593: THEN

Line 1590: fnd_message.set_token ('ERROR_MESSAGE', l_sql_err);

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);
1591:
1592: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1593: THEN
1594: fnd_log.STRING (fnd_log.level_statement,

Line 1600: x_msg_data:= fnd_message.get;

1596: l_api_name,
1597: '221a:Forecast and Follow Up update failed - l_sql_err:'||l_sql_err);
1598: END IF;
1599:
1600: x_msg_data:= fnd_message.get;
1601: x_return_status := g_ret_sts_error;
1602: x_msg_count := 1;
1603: end if;
1604: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

Line 1676: fnd_message.set_name('OKS','OKS_K_VERSION_UPD_FAILED');

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);
1678:
1679: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1680: THEN

Line 1677: fnd_message.set_token ('ERROR_MESSAGE', l_sql_err);

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);
1678:
1679: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1680: THEN
1681: fnd_log.STRING (fnd_log.level_statement,

Line 1687: x_msg_data:= fnd_message.get;

1683: l_api_name,
1684: '225a:Follow Up update failed - l_sql_err:'||l_sql_err);
1685: END IF;
1686:
1687: x_msg_data:= fnd_message.get;
1688: x_return_status := g_ret_sts_error;
1689: x_msg_count := 1;
1690: end if;
1691: */

Line 1695: fnd_message.set_name('OKS','OKS_K_VERSION_UPD_FAILED');

1691: */
1692: x_return_status := OKC_CVM_PVT.update_minor_version(p_chr_id => p_chr_id);
1693: IF x_return_status <> G_RET_STS_SUCCESS THEN
1694: l_sql_err := SQLERRM;
1695: fnd_message.set_name('OKS','OKS_K_VERSION_UPD_FAILED');
1696: fnd_message.set_token ('ERROR_MESSAGE', l_sql_err);
1697:
1698: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1699: fnd_log.STRING (fnd_log.level_statement, g_module ||l_api_name,

Line 1696: fnd_message.set_token ('ERROR_MESSAGE', l_sql_err);

1692: x_return_status := OKC_CVM_PVT.update_minor_version(p_chr_id => p_chr_id);
1693: IF x_return_status <> G_RET_STS_SUCCESS THEN
1694: l_sql_err := SQLERRM;
1695: fnd_message.set_name('OKS','OKS_K_VERSION_UPD_FAILED');
1696: fnd_message.set_token ('ERROR_MESSAGE', l_sql_err);
1697:
1698: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1699: fnd_log.STRING (fnd_log.level_statement, g_module ||l_api_name,
1700: '225a:Follow Up update failed - l_sql_err:'||l_sql_err);

Line 1703: x_msg_data:= fnd_message.get;

1699: fnd_log.STRING (fnd_log.level_statement, g_module ||l_api_name,
1700: '225a:Follow Up update failed - l_sql_err:'||l_sql_err);
1701: END IF;
1702:
1703: x_msg_data:= fnd_message.get;
1704: x_return_status := g_ret_sts_error;
1705: x_msg_count := 1;
1706: END IF;
1707: