DBA Data[Home] [Help]

APPS.OKC_PO_MOD_PKG dependencies on FND_MSG_PUB

Line 39: FOR i IN 1 .. fnd_msg_pub.count_msg

35: PROCEDURE read_message (x_message IN OUT NOCOPY VARCHAR2)
36: IS
37: l_message VARCHAR2 (2000);
38: BEGIN
39: FOR i IN 1 .. fnd_msg_pub.count_msg
40: LOOP
41: l_message := fnd_msg_pub.get (i, p_encoded => fnd_api.g_false);
42:
43: IF (LENGTH (l_message) + LENGTH (Nvl(x_message,' '))) <= 2500

Line 41: l_message := fnd_msg_pub.get (i, p_encoded => fnd_api.g_false);

37: l_message VARCHAR2 (2000);
38: BEGIN
39: FOR i IN 1 .. fnd_msg_pub.count_msg
40: LOOP
41: l_message := fnd_msg_pub.get (i, p_encoded => fnd_api.g_false);
42:
43: IF (LENGTH (l_message) + LENGTH (Nvl(x_message,' '))) <= 2500
44: THEN
45: x_message := x_message || l_message;

Line 132: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => l_msg_count, p_data => l_msg_data );

128: END IF;
129:
130: ROLLBACK TO g_clause_default_section_GRP;
131: x_return_status := G_RET_STS_ERROR ;
132: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => l_msg_count, p_data => l_msg_data );
133:
134: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
135: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
136: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving update_variable_values: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

Line 141: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => l_msg_count, p_data => l_msg_data );

137: END IF;
138:
139: ROLLBACK TO g_clause_default_section_GRP;
140: x_return_status := G_RET_STS_UNEXP_ERROR ;
141: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => l_msg_count, p_data => l_msg_data );
142:
143: WHEN OTHERS THEN
144: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
145: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving update_variable_values because of EXCEPTION: '||sqlerrm);

Line 150: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

146: END IF;
147:
148: ROLLBACK TO g_clause_default_section_GRP;
149: x_return_status := G_RET_STS_UNEXP_ERROR ;
150: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
151: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
152: END IF;
153: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => l_msg_count, p_data => l_msg_data );
154:

Line 151: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

147:
148: ROLLBACK TO g_clause_default_section_GRP;
149: x_return_status := G_RET_STS_UNEXP_ERROR ;
150: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
151: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
152: END IF;
153: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => l_msg_count, p_data => l_msg_data );
154:
155: END get_clause_default_section;

Line 153: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => l_msg_count, p_data => l_msg_data );

149: x_return_status := G_RET_STS_UNEXP_ERROR ;
150: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
151: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
152: END IF;
153: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => l_msg_count, p_data => l_msg_data );
154:
155: END get_clause_default_section;
156:
157: PROCEDURE upd_mulmod_clause_changes(p_init_msg_list IN Varchar2 default FND_API.G_FALSE,

Line 449: FOR i IN 1 .. fnd_msg_pub.count_msg

445: --x_return_status := l_return_status;
446: x_updated_yn:= l_updated_yn;
447:
448: /*Update messages in the Concurrent Program Log*/
449: FOR i IN 1 .. fnd_msg_pub.count_msg
450: LOOP
451: l_message := fnd_msg_pub.get (i, p_encoded => fnd_api.g_false);
452: FND_FILE.put_line (FND_FILE.LOG, substrb('OKC' || ': ' || l_message, 1, 2000));
453: END LOOP;

Line 451: l_message := fnd_msg_pub.get (i, p_encoded => fnd_api.g_false);

447:
448: /*Update messages in the Concurrent Program Log*/
449: FOR i IN 1 .. fnd_msg_pub.count_msg
450: LOOP
451: l_message := fnd_msg_pub.get (i, p_encoded => fnd_api.g_false);
452: FND_FILE.put_line (FND_FILE.LOG, substrb('OKC' || ': ' || l_message, 1, 2000));
453: END LOOP;
454:
455: EXCEPTION

Line 495: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => l_msg_count, p_data => l_msg_data );

491: END IF;
492:
493: ROLLBACK TO g_upd_clause_changes_GRP;
494: x_return_status := G_RET_STS_UNEXP_ERROR ;
495: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => l_msg_count, p_data => l_msg_data );
496:
497: WHEN OTHERS THEN
498: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
499: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving update_variable_values because of EXCEPTION: '||sqlerrm);

Line 504: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

500: END IF;
501:
502: ROLLBACK TO g_upd_clause_changes_GRP;
503: x_return_status := G_RET_STS_UNEXP_ERROR ;
504: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
505: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
506: END IF;
507: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => l_msg_count, p_data => l_msg_data );
508:

Line 505: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

501:
502: ROLLBACK TO g_upd_clause_changes_GRP;
503: x_return_status := G_RET_STS_UNEXP_ERROR ;
504: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
505: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
506: END IF;
507: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => l_msg_count, p_data => l_msg_data );
508:
509: END upd_mulmod_clause_changes;

Line 507: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => l_msg_count, p_data => l_msg_data );

503: x_return_status := G_RET_STS_UNEXP_ERROR ;
504: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
505: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
506: END IF;
507: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => l_msg_count, p_data => l_msg_data );
508:
509: END upd_mulmod_clause_changes;
510:
511: PROCEDURE delete_mulmod_clause_changes(p_multi_mod_req_id IN NUMBER,

Line 528: FND_MSG_PUB.initialize;

524: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entered delete_mulmod_clause_changes');
525: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'200: p_multi_mod_req_id ' || p_multi_mod_req_id);
526: END IF;
527:
528: FND_MSG_PUB.initialize;
529:
530: -- Standard Start of API savepoint
531: SAVEPOINT g_del_clause_changes_GRP;
532:

Line 552: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => l_msg_count, p_data => l_msg_data );

548: END IF;
549:
550: ROLLBACK TO g_del_clause_changes_GRP;
551: x_return_status := G_RET_STS_ERROR ;
552: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => l_msg_count, p_data => l_msg_data );
553:
554: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
555: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
556: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving delete_mulmod_clause_changes: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

Line 561: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => l_msg_count, p_data => l_msg_data );

557: END IF;
558:
559: ROLLBACK TO g_del_clause_changes_GRP;
560: x_return_status := G_RET_STS_UNEXP_ERROR ;
561: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => l_msg_count, p_data => l_msg_data );
562:
563: WHEN OTHERS THEN
564: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
565: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving delete_mulmod_clause_changes because of EXCEPTION: '||sqlerrm);

Line 570: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

566: END IF;
567:
568: ROLLBACK TO g_del_clause_changes_GRP;
569: x_return_status := G_RET_STS_UNEXP_ERROR ;
570: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
571: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
572: END IF;
573: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => l_msg_count, p_data => l_msg_data );
574:

Line 571: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

567:
568: ROLLBACK TO g_del_clause_changes_GRP;
569: x_return_status := G_RET_STS_UNEXP_ERROR ;
570: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
571: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
572: END IF;
573: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => l_msg_count, p_data => l_msg_data );
574:
575: END delete_mulmod_clause_changes;

Line 573: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => l_msg_count, p_data => l_msg_data );

569: x_return_status := G_RET_STS_UNEXP_ERROR ;
570: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
571: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
572: END IF;
573: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => l_msg_count, p_data => l_msg_data );
574:
575: END delete_mulmod_clause_changes;
576:
577: FUNCTION is_clause_change_requested(p_multi_mod_req_id IN NUMBER)