DBA Data[Home] [Help]

APPS.OKC_XPRT_IMPORT_TEMPLATE_PVT dependencies on FND_MESSAGE

Line 1480: FND_MESSAGE.set_name('OKC','OKC_XPRT_QST_VSET_ERROR');

1476: OPEN csr_qst_name;
1477: FETCH csr_qst_name INTO l_question_name;
1478: CLOSE csr_qst_name;
1479: -- Get the error details
1480: FND_MESSAGE.set_name('OKC','OKC_XPRT_QST_VSET_ERROR');
1481: FND_MESSAGE.set_token('QUESTION_NAME',l_question_name);
1482: FND_MESSAGE.set_token('SQL_ERR',SQLERRM);
1483: l_error_message := FND_MESSAGE.get;
1484: -- Write to Concurrent Log File

Line 1481: FND_MESSAGE.set_token('QUESTION_NAME',l_question_name);

1477: FETCH csr_qst_name INTO l_question_name;
1478: CLOSE csr_qst_name;
1479: -- Get the error details
1480: FND_MESSAGE.set_name('OKC','OKC_XPRT_QST_VSET_ERROR');
1481: FND_MESSAGE.set_token('QUESTION_NAME',l_question_name);
1482: FND_MESSAGE.set_token('SQL_ERR',SQLERRM);
1483: l_error_message := FND_MESSAGE.get;
1484: -- Write to Concurrent Log File
1485: fnd_file.put_line(FND_FILE.LOG,l_error_message);

Line 1482: FND_MESSAGE.set_token('SQL_ERR',SQLERRM);

1478: CLOSE csr_qst_name;
1479: -- Get the error details
1480: FND_MESSAGE.set_name('OKC','OKC_XPRT_QST_VSET_ERROR');
1481: FND_MESSAGE.set_token('QUESTION_NAME',l_question_name);
1482: FND_MESSAGE.set_token('SQL_ERR',SQLERRM);
1483: l_error_message := FND_MESSAGE.get;
1484: -- Write to Concurrent Log File
1485: fnd_file.put_line(FND_FILE.LOG,l_error_message);
1486: -- Write to Debug Log

Line 1483: l_error_message := FND_MESSAGE.get;

1479: -- Get the error details
1480: FND_MESSAGE.set_name('OKC','OKC_XPRT_QST_VSET_ERROR');
1481: FND_MESSAGE.set_token('QUESTION_NAME',l_question_name);
1482: FND_MESSAGE.set_token('SQL_ERR',SQLERRM);
1483: l_error_message := FND_MESSAGE.get;
1484: -- Write to Concurrent Log File
1485: fnd_file.put_line(FND_FILE.LOG,l_error_message);
1486: -- Write to Debug Log
1487: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1525: FND_MESSAGE.set_name('OKC','OKC_XPRT_QST_VSET_SEQ_ERROR');

1521: OPEN csr_qst_name;
1522: FETCH csr_qst_name INTO l_question_name;
1523: CLOSE csr_qst_name;
1524: -- Get the error details
1525: FND_MESSAGE.set_name('OKC','OKC_XPRT_QST_VSET_SEQ_ERROR');
1526: FND_MESSAGE.set_token('QUESTION_NAME',l_question_name);
1527: FND_MESSAGE.set_token('SQL_ERR',SQLERRM);
1528: l_error_message := FND_MESSAGE.get;
1529: -- Write to Concurrent Log File

Line 1526: FND_MESSAGE.set_token('QUESTION_NAME',l_question_name);

1522: FETCH csr_qst_name INTO l_question_name;
1523: CLOSE csr_qst_name;
1524: -- Get the error details
1525: FND_MESSAGE.set_name('OKC','OKC_XPRT_QST_VSET_SEQ_ERROR');
1526: FND_MESSAGE.set_token('QUESTION_NAME',l_question_name);
1527: FND_MESSAGE.set_token('SQL_ERR',SQLERRM);
1528: l_error_message := FND_MESSAGE.get;
1529: -- Write to Concurrent Log File
1530: fnd_file.put_line(FND_FILE.LOG,l_error_message);

Line 1527: FND_MESSAGE.set_token('SQL_ERR',SQLERRM);

1523: CLOSE csr_qst_name;
1524: -- Get the error details
1525: FND_MESSAGE.set_name('OKC','OKC_XPRT_QST_VSET_SEQ_ERROR');
1526: FND_MESSAGE.set_token('QUESTION_NAME',l_question_name);
1527: FND_MESSAGE.set_token('SQL_ERR',SQLERRM);
1528: l_error_message := FND_MESSAGE.get;
1529: -- Write to Concurrent Log File
1530: fnd_file.put_line(FND_FILE.LOG,l_error_message);
1531: -- Write to Debug Log

Line 1528: l_error_message := FND_MESSAGE.get;

1524: -- Get the error details
1525: FND_MESSAGE.set_name('OKC','OKC_XPRT_QST_VSET_SEQ_ERROR');
1526: FND_MESSAGE.set_token('QUESTION_NAME',l_question_name);
1527: FND_MESSAGE.set_token('SQL_ERR',SQLERRM);
1528: l_error_message := FND_MESSAGE.get;
1529: -- Write to Concurrent Log File
1530: fnd_file.put_line(FND_FILE.LOG,l_error_message);
1531: -- Write to Debug Log
1532: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1559: FND_MESSAGE.set_name('OKC','OKC_XPRT_QST_VSET_NOVAL');

1555: OPEN csr_qst_name;
1556: FETCH csr_qst_name INTO l_question_name;
1557: CLOSE csr_qst_name;
1558: -- Get the error details
1559: FND_MESSAGE.set_name('OKC','OKC_XPRT_QST_VSET_NOVAL');
1560: FND_MESSAGE.set_token('QUESTION_NAME',l_question_name);
1561: l_error_message := FND_MESSAGE.get;
1562: -- Write to Concurrent Log File
1563: fnd_file.put_line(FND_FILE.LOG,l_error_message);

Line 1560: FND_MESSAGE.set_token('QUESTION_NAME',l_question_name);

1556: FETCH csr_qst_name INTO l_question_name;
1557: CLOSE csr_qst_name;
1558: -- Get the error details
1559: FND_MESSAGE.set_name('OKC','OKC_XPRT_QST_VSET_NOVAL');
1560: FND_MESSAGE.set_token('QUESTION_NAME',l_question_name);
1561: l_error_message := FND_MESSAGE.get;
1562: -- Write to Concurrent Log File
1563: fnd_file.put_line(FND_FILE.LOG,l_error_message);
1564: -- Write to Debug Log

Line 1561: l_error_message := FND_MESSAGE.get;

1557: CLOSE csr_qst_name;
1558: -- Get the error details
1559: FND_MESSAGE.set_name('OKC','OKC_XPRT_QST_VSET_NOVAL');
1560: FND_MESSAGE.set_token('QUESTION_NAME',l_question_name);
1561: l_error_message := FND_MESSAGE.get;
1562: -- Write to Concurrent Log File
1563: fnd_file.put_line(FND_FILE.LOG,l_error_message);
1564: -- Write to Debug Log
1565: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1587: FND_MESSAGE.set_name('OKC','OKC_XPRT_QST_VSET_INVALID');

1583: FETCH csr_qst_name INTO l_question_name;
1584: CLOSE csr_qst_name;
1585:
1586: -- Get the error details
1587: FND_MESSAGE.set_name('OKC','OKC_XPRT_QST_VSET_INVALID');
1588: FND_MESSAGE.set_token('QUESTION_NAME',l_question_name);
1589: l_error_message := FND_MESSAGE.get;
1590: -- Write to Concurrent Log File
1591: fnd_file.put_line(FND_FILE.LOG,l_error_message);

Line 1588: FND_MESSAGE.set_token('QUESTION_NAME',l_question_name);

1584: CLOSE csr_qst_name;
1585:
1586: -- Get the error details
1587: FND_MESSAGE.set_name('OKC','OKC_XPRT_QST_VSET_INVALID');
1588: FND_MESSAGE.set_token('QUESTION_NAME',l_question_name);
1589: l_error_message := FND_MESSAGE.get;
1590: -- Write to Concurrent Log File
1591: fnd_file.put_line(FND_FILE.LOG,l_error_message);
1592: -- Write to Debug Log

Line 1589: l_error_message := FND_MESSAGE.get;

1585:
1586: -- Get the error details
1587: FND_MESSAGE.set_name('OKC','OKC_XPRT_QST_VSET_INVALID');
1588: FND_MESSAGE.set_token('QUESTION_NAME',l_question_name);
1589: l_error_message := FND_MESSAGE.get;
1590: -- Write to Concurrent Log File
1591: fnd_file.put_line(FND_FILE.LOG,l_error_message);
1592: -- Write to Debug Log
1593: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1992: FND_MESSAGE.set_name('OKC','OKC_EXPRT_ART_MODEL_TITLE');

1988:
1989: x_return_status := G_RET_STS_SUCCESS;
1990:
1991: -- Get the Clause Model Name
1992: FND_MESSAGE.set_name('OKC','OKC_EXPRT_ART_MODEL_TITLE');
1993: FND_MESSAGE.set_token('ORG_NAME',G_ORGANIZATION_NAME);
1994: FND_MESSAGE.set_token('INTENT_MEANING',okc_util.decode_lookup('OKC_ARTICLE_INTENT',p_intent));
1995: l_clause_model_name := FND_MESSAGE.get;
1996:

Line 1993: FND_MESSAGE.set_token('ORG_NAME',G_ORGANIZATION_NAME);

1989: x_return_status := G_RET_STS_SUCCESS;
1990:
1991: -- Get the Clause Model Name
1992: FND_MESSAGE.set_name('OKC','OKC_EXPRT_ART_MODEL_TITLE');
1993: FND_MESSAGE.set_token('ORG_NAME',G_ORGANIZATION_NAME);
1994: FND_MESSAGE.set_token('INTENT_MEANING',okc_util.decode_lookup('OKC_ARTICLE_INTENT',p_intent));
1995: l_clause_model_name := FND_MESSAGE.get;
1996:
1997:

Line 1994: FND_MESSAGE.set_token('INTENT_MEANING',okc_util.decode_lookup('OKC_ARTICLE_INTENT',p_intent));

1990:
1991: -- Get the Clause Model Name
1992: FND_MESSAGE.set_name('OKC','OKC_EXPRT_ART_MODEL_TITLE');
1993: FND_MESSAGE.set_token('ORG_NAME',G_ORGANIZATION_NAME);
1994: FND_MESSAGE.set_token('INTENT_MEANING',okc_util.decode_lookup('OKC_ARTICLE_INTENT',p_intent));
1995: l_clause_model_name := FND_MESSAGE.get;
1996:
1997:
1998: -- Put the Name in the description Column of cz_ps_nodes

Line 1995: l_clause_model_name := FND_MESSAGE.get;

1991: -- Get the Clause Model Name
1992: FND_MESSAGE.set_name('OKC','OKC_EXPRT_ART_MODEL_TITLE');
1993: FND_MESSAGE.set_token('ORG_NAME',G_ORGANIZATION_NAME);
1994: FND_MESSAGE.set_token('INTENT_MEANING',okc_util.decode_lookup('OKC_ARTICLE_INTENT',p_intent));
1995: l_clause_model_name := FND_MESSAGE.get;
1996:
1997:
1998: -- Put the Name in the description Column of cz_ps_nodes
1999:

Line 2520: FND_MESSAGE.set_name('OKC','OKC_XPRT_INVALID_TEMPLATE');

2516: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2517: G_MODULE||l_api_name,
2518: '110: Invalid Template Id: '||p_template_id);
2519: END IF;
2520: FND_MESSAGE.set_name('OKC','OKC_XPRT_INVALID_TEMPLATE');
2521: RAISE FND_API.G_EXC_ERROR;
2522: END IF;
2523:
2524: CLOSE csr_template_dtls;

Line 2586: FND_MESSAGE.set_name('OKC','OKC_XPRT_TMPL_FOLDER_DESC');

2582: IF csr_template_folder%NOTFOUND THEN
2583: -- Create template folder for Org and Intent
2584:
2585: -- Generate Folder Description
2586: FND_MESSAGE.set_name('OKC','OKC_XPRT_TMPL_FOLDER_DESC');
2587: FND_MESSAGE.set_token('ORGANIZATION_NAME',G_ORGANIZATION_NAME);
2588: FND_MESSAGE.set_token('INTENT',okc_util.decode_lookup('OKC_ARTICLE_INTENT',l_intent));
2589: l_folder_desc := FND_MESSAGE.get;
2590:

Line 2587: FND_MESSAGE.set_token('ORGANIZATION_NAME',G_ORGANIZATION_NAME);

2583: -- Create template folder for Org and Intent
2584:
2585: -- Generate Folder Description
2586: FND_MESSAGE.set_name('OKC','OKC_XPRT_TMPL_FOLDER_DESC');
2587: FND_MESSAGE.set_token('ORGANIZATION_NAME',G_ORGANIZATION_NAME);
2588: FND_MESSAGE.set_token('INTENT',okc_util.decode_lookup('OKC_ARTICLE_INTENT',l_intent));
2589: l_folder_desc := FND_MESSAGE.get;
2590:
2591: -- folder does not exits so create the folder

Line 2588: FND_MESSAGE.set_token('INTENT',okc_util.decode_lookup('OKC_ARTICLE_INTENT',l_intent));

2584:
2585: -- Generate Folder Description
2586: FND_MESSAGE.set_name('OKC','OKC_XPRT_TMPL_FOLDER_DESC');
2587: FND_MESSAGE.set_token('ORGANIZATION_NAME',G_ORGANIZATION_NAME);
2588: FND_MESSAGE.set_token('INTENT',okc_util.decode_lookup('OKC_ARTICLE_INTENT',l_intent));
2589: l_folder_desc := FND_MESSAGE.get;
2590:
2591: -- folder does not exits so create the folder
2592: OKC_XPRT_CZ_INT_PVT.create_rp_folder(

Line 2589: l_folder_desc := FND_MESSAGE.get;

2585: -- Generate Folder Description
2586: FND_MESSAGE.set_name('OKC','OKC_XPRT_TMPL_FOLDER_DESC');
2587: FND_MESSAGE.set_token('ORGANIZATION_NAME',G_ORGANIZATION_NAME);
2588: FND_MESSAGE.set_token('INTENT',okc_util.decode_lookup('OKC_ARTICLE_INTENT',l_intent));
2589: l_folder_desc := FND_MESSAGE.get;
2590:
2591: -- folder does not exits so create the folder
2592: OKC_XPRT_CZ_INT_PVT.create_rp_folder(
2593: p_api_version => l_api_version,