DBA Data[Home] [Help]

APPS.OKS_K_ACTIONS_PVT dependencies on FND_MSG_PUB

Line 62: FND_MSG_PUB.initialize;

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

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

82: END IF;
83:
84:
85: -- Standard call to get message count and if count is 1, get message info.
86: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
87:
88: -- end debug log
89: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
90: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

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

93: END IF;
94:
95: EXCEPTION
96: WHEN ActionNotAllowedException THEN
97: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
98: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
99: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
100: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.ActionNotAllowedException '||
101: ' Contract cannot be published since it is not in entered status');

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

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

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

117: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name||' with Unexpected Error status');
118: END IF;
119:
120: x_return_status := G_RET_STS_UNEXP_ERROR ;
121: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
122:
123: WHEN OTHERS THEN
124: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
125: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

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

125: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
126: G_MODULE||l_api_name,
127: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name ||' with unexpected error');
128: END IF;
129: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
130: END setRemindersYn;
131:
132: PROCEDURE send_email
133: (p_chr_id IN NUMBER

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

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

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

271: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
272: END IF;
273:
274: x_return_status := G_RET_STS_UNEXP_ERROR ;
275: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
276:
277: WHEN OTHERS THEN
278: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
279: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

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

279: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
280: G_MODULE||l_api_name,
281: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
282: END IF;
283: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
284:
285:
286: END send_email;
287:

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

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

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

407: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
408: END IF;
409:
410: x_return_status := G_RET_STS_UNEXP_ERROR ;
411: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
412:
413: WHEN OTHERS THEN
414: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
415: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

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

415: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
416: G_MODULE||l_api_name,
417: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
418: END IF;
419: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
420:
421:
422: END;
423:

Line 480: FND_MSG_PUB.initialize;

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

Line 553: fnd_msg_pub.add;

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

Line 584: FND_MSG_PUB.ADD;

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

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

590: commit work;
591:
592:
593: -- Standard call to get message count and if count is 1, get message info.
594: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
595:
596: -- end debug log
597: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
598: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

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

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

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

618: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
619: END IF;
620:
621: x_return_status := G_RET_STS_UNEXP_ERROR ;
622: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
623:
624: WHEN OTHERS THEN
625: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
626: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

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

626: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
627: G_MODULE||l_api_name,
628: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
629: END IF;
630: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
631: END launch_qa_report;
632:
633:
634: /*

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

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

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

1197: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1198: END IF;
1199:
1200: x_return_status := G_RET_STS_UNEXP_ERROR ;
1201: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1202:
1203: WHEN OTHERS THEN
1204: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1205: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

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

1205: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1206: G_MODULE||l_api_name,
1207: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1208: END IF;
1209: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1210:
1211:
1212: END send_email;
1213:

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

1679: END IF;
1680:
1681: x_return_status := g_ret_sts_error;
1682:
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

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

1699: END IF;
1700:
1701: x_return_status := g_ret_sts_unexp_error;
1702:
1703: fnd_msg_pub.count_and_get (p_encoded => 'F',
1704: p_count => x_msg_count,
1705: p_data => x_msg_data
1706: );
1707:

Line 1725: fnd_msg_pub.add_exc_msg (g_pkg_name,

1721: SQLCODE ||
1722: ', sqlerrm = ' ||
1723: SQLERRM
1724: );
1725: fnd_msg_pub.add_exc_msg (g_pkg_name,
1726: l_api_name,
1727: SUBSTR (SQLERRM,
1728: 1,
1729: 240

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

1730: )
1731: );
1732: END IF;
1733:
1734: fnd_msg_pub.count_and_get (p_encoded => 'F',
1735: p_count => x_msg_count,
1736: p_data => x_msg_data
1737: );
1738: x_return_status := g_ret_sts_unexp_error;