DBA Data[Home] [Help]

APPS.OKS_K_ACTIONS_PVT dependencies on FND_MSG_PUB

Line 63: FND_MSG_PUB.initialize;

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
67: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 115: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

111: END IF;
112:
113:
114: -- Standard call to get message count and if count is 1, get message info.
115: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
116:
117: -- end debug log
118: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
119: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 126: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

122: END IF;
123:
124: EXCEPTION
125: WHEN ActionNotAllowedException THEN
126: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
127: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
128: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
129: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.ActionNotAllowedException '||
130: ' Contract cannot be published since it is not in entered status');

Line 140: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

136: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name||' with ERROR status');
137: END IF;
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 ,

Line 150: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

146: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name||' with Unexpected Error status');
147: END IF;
148:
149: x_return_status := G_RET_STS_UNEXP_ERROR ;
150: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
151:
152: WHEN OTHERS THEN
153: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
154: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 158: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

154: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
155: G_MODULE||l_api_name,
156: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name ||' with unexpected error');
157: END IF;
158: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
159: END setRemindersYn;
160:
161: PROCEDURE send_email
162: (p_chr_id IN NUMBER

Line 294: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

290: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
291: END IF;
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 ,

Line 304: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

300: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
301: END IF;
302:
303: x_return_status := G_RET_STS_UNEXP_ERROR ;
304: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
305:
306: WHEN OTHERS THEN
307: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
308: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 312: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

308: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
309: G_MODULE||l_api_name,
310: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
311: END IF;
312: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
313:
314:
315: END send_email;
316:

Line 430: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

426: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
427: END IF;
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 ,

Line 440: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

436: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
437: END IF;
438:
439: x_return_status := G_RET_STS_UNEXP_ERROR ;
440: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
441:
442: WHEN OTHERS THEN
443: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
444: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 448: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

444: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
445: G_MODULE||l_api_name,
446: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
447: END IF;
448: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
449:
450:
451: END;
452:

Line 509: FND_MSG_PUB.initialize;

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
513: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 582: fnd_msg_pub.add;

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;
586:

Line 613: FND_MSG_PUB.ADD;

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:
617: x_cp_request_id := l_request_id;

Line 623: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

619: commit work;
620:
621:
622: -- Standard call to get message count and if count is 1, get message info.
623: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
624:
625: -- end debug log
626: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
627: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 641: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

637: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
638: END IF;
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 ,

Line 651: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

647: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
648: END IF;
649:
650: x_return_status := G_RET_STS_UNEXP_ERROR ;
651: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
652:
653: WHEN OTHERS THEN
654: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
655: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 659: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

655: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
656: G_MODULE||l_api_name,
657: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
658: END IF;
659: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
660: END launch_qa_report;
661:
662:
663: /*

Line 1220: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

1216: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1217: END IF;
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 ,

Line 1230: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

1226: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1227: END IF;
1228:
1229: x_return_status := G_RET_STS_UNEXP_ERROR ;
1230: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1231:
1232: WHEN OTHERS THEN
1233: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1234: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 1238: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

1234: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1235: G_MODULE||l_api_name,
1236: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1237: END IF;
1238: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1239:
1240:
1241: END send_email;
1242:

Line 1759: fnd_msg_pub.count_and_get (p_encoded => 'F',

1755: END IF;
1756:
1757: x_return_status := g_ret_sts_error;
1758:
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

Line 1779: fnd_msg_pub.count_and_get (p_encoded => 'F',

1775: END IF;
1776:
1777: x_return_status := g_ret_sts_unexp_error;
1778:
1779: fnd_msg_pub.count_and_get (p_encoded => 'F',
1780: p_count => x_msg_count,
1781: p_data => x_msg_data
1782: );
1783:

Line 1801: fnd_msg_pub.add_exc_msg (g_pkg_name,

1797: SQLCODE ||
1798: ', sqlerrm = ' ||
1799: SQLERRM
1800: );
1801: fnd_msg_pub.add_exc_msg (g_pkg_name,
1802: l_api_name,
1803: SUBSTR (SQLERRM,
1804: 1,
1805: 240

Line 1810: fnd_msg_pub.count_and_get (p_encoded => 'F',

1806: )
1807: );
1808: END IF;
1809:
1810: fnd_msg_pub.count_and_get (p_encoded => 'F',
1811: p_count => x_msg_count,
1812: p_data => x_msg_data
1813: );
1814: x_return_status := g_ret_sts_unexp_error;