eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_SCA_CRRULEATTR_PVT dependencies on FND_MSG_PUB

Line 119: -- FND_MSG_PUB.initialize;

115: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
116: -- END IF;
117: -- -- Initialize message list if p_init_msg_list is set to TRUE.
118: -- IF FND_API.to_Boolean( p_init_msg_list ) THEN
119: -- FND_MSG_PUB.initialize;
120: -- END IF;
121: -- -- Initialize API return status to success
122: -- x_return_status := FND_API.G_RET_STS_SUCCESS;
123: -- -- API body

Line 214: -- FND_MSG_PUB.Count_And_Get

210: -- IF FND_API.To_Boolean( p_commit ) THEN
211: -- COMMIT WORK;
212: -- END IF;
213: -- -- Standard call to get message count and if count is 1, get message info.
214: -- FND_MSG_PUB.Count_And_Get
215: -- (p_count => x_msg_count ,
216: -- p_data => x_msg_data ,
217: -- p_encoded => FND_API.G_FALSE );
218: -- EXCEPTION

Line 222: -- FND_MSG_PUB.Count_And_Get

218: -- EXCEPTION
219: -- WHEN FND_API.G_EXC_ERROR THEN
220: -- ROLLBACK TO Get_Credit_Rule_Attr;
221: -- x_return_status := FND_API.G_RET_STS_ERROR ;
222: -- FND_MSG_PUB.Count_And_Get
223: -- (p_count => x_msg_count ,
224: -- p_data => x_msg_data ,
225: -- p_encoded => FND_API.G_FALSE );
226: -- WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 229: -- FND_MSG_PUB.Count_And_Get

225: -- p_encoded => FND_API.G_FALSE );
226: -- WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
227: -- ROLLBACK TO Get_Credit_Rule_Attr;
228: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
229: -- FND_MSG_PUB.Count_And_Get
230: -- (p_count => x_msg_count ,
231: -- p_data => x_msg_data ,
232: -- p_encoded => FND_API.G_FALSE );
233: -- WHEN OTHERS THEN

Line 236: -- IF FND_MSG_PUB.Check_Msg_Level

232: -- p_encoded => FND_API.G_FALSE );
233: -- WHEN OTHERS THEN
234: -- ROLLBACK TO Get_Credit_Rule_Attr;
235: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
236: -- IF FND_MSG_PUB.Check_Msg_Level
237: -- (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
238: -- THEN
239: -- FND_MSG_PUB.Add_Exc_Msg
240: -- (G_PKG_NAME ,

Line 237: -- (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

233: -- WHEN OTHERS THEN
234: -- ROLLBACK TO Get_Credit_Rule_Attr;
235: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
236: -- IF FND_MSG_PUB.Check_Msg_Level
237: -- (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
238: -- THEN
239: -- FND_MSG_PUB.Add_Exc_Msg
240: -- (G_PKG_NAME ,
241: -- l_api_name );

Line 239: -- FND_MSG_PUB.Add_Exc_Msg

235: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
236: -- IF FND_MSG_PUB.Check_Msg_Level
237: -- (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
238: -- THEN
239: -- FND_MSG_PUB.Add_Exc_Msg
240: -- (G_PKG_NAME ,
241: -- l_api_name );
242: -- END IF;
243: -- FND_MSG_PUB.Count_And_Get

Line 243: -- FND_MSG_PUB.Count_And_Get

239: -- FND_MSG_PUB.Add_Exc_Msg
240: -- (G_PKG_NAME ,
241: -- l_api_name );
242: -- END IF;
243: -- FND_MSG_PUB.Count_And_Get
244: -- (p_count => x_msg_count ,
245: -- p_data => x_msg_data ,
246: -- p_encoded => FND_API.G_FALSE );
247: -- END Get_Credit_Rule_Attr;

Line 315: FND_MSG_PUB.initialize;

311:
312: -- Initialize message list if p_init_msg_list is set to TRUE.
313:
314: IF FND_API.to_Boolean( p_init_msg_list ) THEN
315: FND_MSG_PUB.initialize;
316: END IF;
317:
318: l_credit_rule_attr_rec := p_credit_rule_attr_rec;
319: -- Initialize API return status to success

Line 334: fnd_msg_pub.add;

330: l_value_set_id := l_credit_rule_attr_rec.value_set_id;
331:
332: IF (l_credit_rule_attr_rec.source_column IS NULL AND l_credit_rule_attr_rec.transaction_source = 'CN') THEN
333: fnd_message.set_name('CN', 'CN_REQ_PAR_MISSING');
334: fnd_msg_pub.add;
335: RAISE FND_API.G_EXC_ERROR;
336: END IF;
337:
338: IF l_credit_rule_attr_rec.user_name IS NULL

Line 355: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

351: and ( SRC_COLUMN_NAME = l_credit_rule_attr_rec.destination_column OR upper(USER_COLUMN_NAME) = upper(trim(l_credit_rule_attr_rec.user_name)));
352:
353: IF (l_count <> 0) THEN
354: --Error condition
355: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
356: THEN
357: fnd_message.set_name('CN', 'CN_SCA_RULE_ATTRIBUTE_EXISTS');
358: fnd_msg_pub.add;
359: END IF;

Line 358: fnd_msg_pub.add;

354: --Error condition
355: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
356: THEN
357: fnd_message.set_name('CN', 'CN_SCA_RULE_ATTRIBUTE_EXISTS');
358: fnd_msg_pub.add;
359: END IF;
360:
361:
362: RAISE FND_API.G_EXC_ERROR;

Line 419: FND_MSG_PUB.Count_And_Get

415:
416:
417: -- Standard call to get message count and if count is 1, get message info.
418:
419: FND_MSG_PUB.Count_And_Get
420: (
421: p_count => x_msg_count ,
422: p_data => x_msg_data ,
423: p_encoded => FND_API.G_FALSE

Line 430: FND_MSG_PUB.Count_And_Get

426: EXCEPTION
427: WHEN FND_API.G_EXC_ERROR THEN
428: ROLLBACK TO Create_Credit_RuleAttr;
429: x_return_status := FND_API.G_RET_STS_ERROR ;
430: FND_MSG_PUB.Count_And_Get
431: (
432: p_count => x_msg_count ,
433: p_data => x_msg_data ,
434: p_encoded => FND_API.G_FALSE

Line 441: fnd_msg_pub.ADD;

437: ROLLBACK TO Create_Credit_RuleAttr;
438: IF SQLCODE = '-1'
439: THEN
440: fnd_message.set_name('CN', 'CN_SCA_RULE_ATTRIBUTES_UNIQUE');
441: fnd_msg_pub.ADD;
442: RAISE fnd_api.g_exc_error;
443: END IF;
444: --x_loading_status := 'UNEXPECTED_ERR';
445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 446: FND_MSG_PUB.Count_And_Get

442: RAISE fnd_api.g_exc_error;
443: END IF;
444: --x_loading_status := 'UNEXPECTED_ERR';
445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
446: FND_MSG_PUB.Count_And_Get
447: (
448: p_count => x_msg_count ,
449: p_data => x_msg_data ,
450: p_encoded => FND_API.G_FALSE

Line 456: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

452: WHEN OTHERS THEN
453: ROLLBACK TO Create_Credit_RuleAttr;
454: --x_loading_status := 'UNEXPECTED_ERR';
455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
456: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
457: THEN
458: FND_MSG_PUB.Add_Exc_Msg( L_PKG_NAME ,l_api_name );
459: END IF;
460: FND_MSG_PUB.Count_And_Get

Line 458: FND_MSG_PUB.Add_Exc_Msg( L_PKG_NAME ,l_api_name );

454: --x_loading_status := 'UNEXPECTED_ERR';
455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
456: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
457: THEN
458: FND_MSG_PUB.Add_Exc_Msg( L_PKG_NAME ,l_api_name );
459: END IF;
460: FND_MSG_PUB.Count_And_Get
461: (
462: p_count => x_msg_count ,

Line 460: FND_MSG_PUB.Count_And_Get

456: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
457: THEN
458: FND_MSG_PUB.Add_Exc_Msg( L_PKG_NAME ,l_api_name );
459: END IF;
460: FND_MSG_PUB.Count_And_Get
461: (
462: p_count => x_msg_count ,
463: p_data => x_msg_data ,
464: p_encoded => FND_API.G_FALSE

Line 539: FND_MSG_PUB.initialize;

535:
536: -- Initialize message list if p_init_msg_list is set to TRUE.
537:
538: IF FND_API.to_Boolean( p_init_msg_list ) THEN
539: FND_MSG_PUB.initialize;
540: END IF;
541:
542: -- Initialize API return status to success
543: l_credit_rule_attr_rec := p_credit_rule_attr_rec;

Line 559: fnd_msg_pub.add;

555: -- and TRX_SRC_COLUMN_NAME = p_old_credit_rule_attr_rec.source_column;
556:
557: IF l_old_ovn <> p_credit_rule_attr_rec.object_version_number THEN
558: fnd_message.set_name('CN', 'CN_RECORD_CHANGED');
559: fnd_msg_pub.add;
560: raise fnd_api.g_exc_error;
561: END IF;
562:
563: --OPEN get_value_set_id;

Line 580: fnd_msg_pub.add;

576: END IF;
577:
578: IF (l_credit_rule_attr_rec.source_column IS NULL AND l_credit_rule_attr_rec.transaction_source = 'CN'AND (l_credit_rule_attr_rec.enable_flag <> 'N' OR l_value_set_id IS NOT NULL OR l_credit_rule_attr_rec.user_name IS NOT NULL )) THEN
579: fnd_message.set_name('CN', 'CN_REQ_PAR_MISSING');
580: fnd_msg_pub.add;
581: RAISE FND_API.G_EXC_ERROR;
582: END IF;
583:
584:

Line 604: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

600: set sca_mapping_status = 'UNSYNC'
601: where org_id = p_org_id; -- MOAC Change
602: END IF;
603: ELSE
604: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
605: THEN
606: fnd_message.set_name('CN', 'CN_SCA_RULE_COND_EXISTS');
607: fnd_msg_pub.add;
608: END IF;

Line 607: fnd_msg_pub.add;

603: ELSE
604: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
605: THEN
606: fnd_message.set_name('CN', 'CN_SCA_RULE_COND_EXISTS');
607: fnd_msg_pub.add;
608: END IF;
609:
610: RAISE FND_API.G_EXC_ERROR;
611: END IF;

Line 626: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

622: and upper(USER_COLUMN_NAME) = upper(trim(l_credit_rule_attr_rec.user_name));
623:
624: IF (l_count <> 0) THEN
625: --Error condition
626: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
627: THEN
628: fnd_message.set_name('CN', 'CN_SCA_RULE_ATTRIBUTE_EXISTS');
629: fnd_msg_pub.add;
630: END IF;

Line 629: fnd_msg_pub.add;

625: --Error condition
626: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
627: THEN
628: fnd_message.set_name('CN', 'CN_SCA_RULE_ATTRIBUTE_EXISTS');
629: fnd_msg_pub.add;
630: END IF;
631:
632:
633: RAISE FND_API.G_EXC_ERROR;

Line 692: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

688: set sca_mapping_status = 'UNSYNC'
689: where org_id = p_org_id;
690: END IF;
691: ELSE
692: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
693: THEN
694: fnd_message.set_name('CN', 'CN_SCA_RULE_COND_EXISTS');
695: fnd_msg_pub.add;
696: END IF;

Line 695: fnd_msg_pub.add;

691: ELSE
692: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
693: THEN
694: fnd_message.set_name('CN', 'CN_SCA_RULE_COND_EXISTS');
695: fnd_msg_pub.add;
696: END IF;
697:
698: RAISE FND_API.G_EXC_ERROR;
699: END IF;

Line 715: FND_MSG_PUB.Count_And_Get

711:
712:
713: -- Standard call to get message count and if count is 1, get message info.
714:
715: FND_MSG_PUB.Count_And_Get
716: (
717: p_count => x_msg_count ,
718: p_data => x_msg_data ,
719: p_encoded => FND_API.G_FALSE

Line 725: FND_MSG_PUB.Count_And_Get

721: EXCEPTION
722: WHEN FND_API.G_EXC_ERROR THEN
723: ROLLBACK TO Update_Credit_RuleAttr;
724: x_return_status := FND_API.G_RET_STS_ERROR ;
725: FND_MSG_PUB.Count_And_Get
726: (
727: p_count => x_msg_count ,
728: p_data => x_msg_data ,
729: p_encoded => FND_API.G_FALSE

Line 735: FND_MSG_PUB.Count_And_Get

731: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
732: ROLLBACK TO Update_Credit_RuleAttr;
733: --x_loading_status := 'UNEXPECTED_ERR';
734: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
735: FND_MSG_PUB.Count_And_Get
736: (
737: p_count => x_msg_count ,
738: p_data => x_msg_data ,
739: p_encoded => FND_API.G_FALSE

Line 745: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

741: WHEN OTHERS THEN
742: ROLLBACK TO Update_Credit_RuleAttr;
743: -- x_loading_status := 'UNEXPECTED_ERR';
744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
745: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
746: THEN
747: FND_MSG_PUB.Add_Exc_Msg( L_PKG_NAME ,l_api_name );
748: END IF;
749: FND_MSG_PUB.Count_And_Get

Line 747: FND_MSG_PUB.Add_Exc_Msg( L_PKG_NAME ,l_api_name );

743: -- x_loading_status := 'UNEXPECTED_ERR';
744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
745: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
746: THEN
747: FND_MSG_PUB.Add_Exc_Msg( L_PKG_NAME ,l_api_name );
748: END IF;
749: FND_MSG_PUB.Count_And_Get
750: (
751: p_count => x_msg_count ,

Line 749: FND_MSG_PUB.Count_And_Get

745: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
746: THEN
747: FND_MSG_PUB.Add_Exc_Msg( L_PKG_NAME ,l_api_name );
748: END IF;
749: FND_MSG_PUB.Count_And_Get
750: (
751: p_count => x_msg_count ,
752: p_data => x_msg_data ,
753: p_encoded => FND_API.G_FALSE

Line 806: FND_MSG_PUB.initialize;

802:
803: -- Initialize message list if p_init_msg_list is set to TRUE.
804:
805: IF FND_API.to_Boolean( p_init_msg_list ) THEN
806: FND_MSG_PUB.initialize;
807: END IF;
808:
809:
810: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 821: fnd_msg_pub.add;

817: AND ORG_ID = p_org_id; -- MOAC Change
818:
819: IF l_count = 0 THEN
820: fnd_message.set_name('CN', 'CN_NORECORD_GENERATE');
821: fnd_msg_pub.add;
822: raise fnd_api.g_exc_error;
823: ELSE
824:
825:

Line 844: fnd_msg_pub.add;

840: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
841: x_return_status := l_return_status;
842: fnd_message.set_name('CN', 'CN_GENERATION_FAILED');
843:
844: fnd_msg_pub.add;
845: RAISE FND_API.G_EXC_ERROR;
846: -- x_loading_status := l_loading_status;
847:
848: ELSE

Line 866: FND_MSG_PUB.Count_And_Get

862:
863:
864: -- Standard call to get message count and if count is 1, get message info.
865:
866: FND_MSG_PUB.Count_And_Get
867: (
868: p_count => x_msg_count ,
869: p_data => x_msg_data ,
870: p_encoded => FND_API.G_FALSE

Line 876: FND_MSG_PUB.Count_And_Get

872: EXCEPTION
873: WHEN FND_API.G_EXC_ERROR THEN
874: --ROLLBACK TO Generate_Package;
875: x_return_status := FND_API.G_RET_STS_ERROR ;
876: FND_MSG_PUB.Count_And_Get
877: (
878: p_count => x_msg_count ,
879: p_data => x_msg_data ,
880: p_encoded => FND_API.G_FALSE

Line 885: FND_MSG_PUB.Count_And_Get

881: );
882: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
883: --ROLLBACK TO Generate_Package;
884: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
885: FND_MSG_PUB.Count_And_Get
886: (
887: p_count => x_msg_count ,
888: p_data => x_msg_data ,
889: p_encoded => FND_API.G_FALSE

Line 894: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

890: );
891: WHEN OTHERS THEN
892: --ROLLBACK TO Generate_Package;
893: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
894: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
895: THEN
896: FND_MSG_PUB.Add_Exc_Msg( L_PKG_NAME ,l_api_name );
897: END IF;
898: FND_MSG_PUB.Count_And_Get

Line 896: FND_MSG_PUB.Add_Exc_Msg( L_PKG_NAME ,l_api_name );

892: --ROLLBACK TO Generate_Package;
893: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
894: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
895: THEN
896: FND_MSG_PUB.Add_Exc_Msg( L_PKG_NAME ,l_api_name );
897: END IF;
898: FND_MSG_PUB.Count_And_Get
899: (
900: p_count => x_msg_count ,

Line 898: FND_MSG_PUB.Count_And_Get

894: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
895: THEN
896: FND_MSG_PUB.Add_Exc_Msg( L_PKG_NAME ,l_api_name );
897: END IF;
898: FND_MSG_PUB.Count_And_Get
899: (
900: p_count => x_msg_count ,
901: p_data => x_msg_data ,
902: p_encoded => FND_API.G_FALSE