DBA Data[Home] [Help]

APPS.OKS_K_ACTIONS_PVT dependencies on FND_MESSAGE

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

548: END IF;
549:
550: -- if the number of contracts exceed 6 then throw an error
551: IF NVL(l_chr_id_tbl.COUNT,0) > 6 THEN
552: fnd_message.set_name(G_APP_NAME,'OKS_SUBMIT_MAX_QA_ERROR');
553: fnd_msg_pub.add;
554: x_return_status := G_RET_STS_ERROR ;
555: RETURN;
556: END IF;

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

578: UPDATE OKS_K_HEADERS_B
579: SET PROCESS_REQUEST_ID = l_request_id
580: WHERE chr_id = l_chr_id_tbl(i);
581: ELSE
582: FND_MESSAGE.SET_NAME('OKS','OKS_CP_ERROR');
583: FND_MESSAGE.SET_TOKEN('SQL_ERROR',SQLERRM);
584: FND_MSG_PUB.ADD;
585: x_return_status := G_RET_STS_ERROR ;
586: END IF;

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

579: SET PROCESS_REQUEST_ID = l_request_id
580: WHERE chr_id = l_chr_id_tbl(i);
581: ELSE
582: FND_MESSAGE.SET_NAME('OKS','OKS_CP_ERROR');
583: FND_MESSAGE.SET_TOKEN('SQL_ERROR',SQLERRM);
584: FND_MSG_PUB.ADD;
585: x_return_status := G_RET_STS_ERROR ;
586: END IF;
587:

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

1494: END IF;
1495:
1496: --- If any errors happen abort API
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

Line 1499: x_msg_data := fnd_message.get;

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

Line 1503: 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;
1506: RAISE fnd_api.g_exc_error;
1507: END IF;

Line 1504: 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;
1506: RAISE fnd_api.g_exc_error;
1507: END IF;
1508:

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

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);
1552:
1553: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1554: THEN

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

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);
1552:
1553: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1554: THEN
1555: fnd_log.STRING (fnd_log.level_statement,

Line 1561: x_msg_data:= fnd_message.get;

1557: l_api_name,
1558: '221a:Forecast and Follow Up update failed - l_sql_err:'||l_sql_err);
1559: END IF;
1560:
1561: x_msg_data:= fnd_message.get;
1562: x_return_status := g_ret_sts_error;
1563: x_msg_count := 1;
1564: end if;
1565: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

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

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);
1604:
1605: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1606: THEN

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

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);
1604:
1605: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1606: THEN
1607: fnd_log.STRING (fnd_log.level_statement,

Line 1613: x_msg_data:= fnd_message.get;

1609: l_api_name,
1610: '225a:Follow Up update failed - l_sql_err:'||l_sql_err);
1611: END IF;
1612:
1613: x_msg_data:= fnd_message.get;
1614: x_return_status := g_ret_sts_error;
1615: x_msg_count := 1;
1616: end if;
1617: */

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

1617: */
1618: x_return_status := OKC_CVM_PVT.update_minor_version(p_chr_id => p_chr_id);
1619: IF x_return_status <> G_RET_STS_SUCCESS THEN
1620: l_sql_err := SQLERRM;
1621: fnd_message.set_name('OKS','OKS_K_VERSION_UPD_FAILED');
1622: fnd_message.set_token ('ERROR_MESSAGE', l_sql_err);
1623:
1624: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1625: fnd_log.STRING (fnd_log.level_statement, g_module ||l_api_name,

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

1618: x_return_status := OKC_CVM_PVT.update_minor_version(p_chr_id => p_chr_id);
1619: IF x_return_status <> G_RET_STS_SUCCESS THEN
1620: l_sql_err := SQLERRM;
1621: fnd_message.set_name('OKS','OKS_K_VERSION_UPD_FAILED');
1622: fnd_message.set_token ('ERROR_MESSAGE', l_sql_err);
1623:
1624: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1625: fnd_log.STRING (fnd_log.level_statement, g_module ||l_api_name,
1626: '225a:Follow Up update failed - l_sql_err:'||l_sql_err);

Line 1629: x_msg_data:= fnd_message.get;

1625: fnd_log.STRING (fnd_log.level_statement, g_module ||l_api_name,
1626: '225a:Follow Up update failed - l_sql_err:'||l_sql_err);
1627: END IF;
1628:
1629: x_msg_data:= fnd_message.get;
1630: x_return_status := g_ret_sts_error;
1631: x_msg_count := 1;
1632: END IF;
1633: