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_RULE_PVT dependencies on FND_MSG_PUB

Line 49: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

45:
46: /* if l_ruleset_rec.module_type = 'REVCLS' THEN
47:
48: IF p_rule_rec.revenue_class_id is NULL THEN
49: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
50: FND_MESSAGE.Set_Name('CN', 'CN_INVALID_REVENUE_CLASS');
51: FND_MSG_PUB.Add;
52: END IF;
53: x_loading_status := 'CN_INVALID_REVENUE_CLASS';

Line 51: FND_MSG_PUB.Add;

47:
48: IF p_rule_rec.revenue_class_id is NULL THEN
49: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
50: FND_MESSAGE.Set_Name('CN', 'CN_INVALID_REVENUE_CLASS');
51: FND_MSG_PUB.Add;
52: END IF;
53: x_loading_status := 'CN_INVALID_REVENUE_CLASS';
54: RAISE FND_API.G_EXC_ERROR ;
55: END IF;

Line 60: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

56: null;
57: else
58: IF p_rule_rec.expense_ccid is NULL OR
59: p_rule_rec.liability_ccid IS NULL THEN
60: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
61: FND_MESSAGE.Set_Name('CN', 'CN_INVALID_ACCOUNT_CODE');
62: FND_MSG_PUB.Add;
63: END IF;
64: x_loading_status := 'CN_INVALID_ACCOUNT_CODE';

Line 62: FND_MSG_PUB.Add;

58: IF p_rule_rec.expense_ccid is NULL OR
59: p_rule_rec.liability_ccid IS NULL THEN
60: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
61: FND_MESSAGE.Set_Name('CN', 'CN_INVALID_ACCOUNT_CODE');
62: FND_MSG_PUB.Add;
63: END IF;
64: x_loading_status := 'CN_INVALID_ACCOUNT_CODE';
65: RAISE FND_API.G_EXC_ERROR ;
66: END IF;

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

79: x_loading_status := 'UNEXPECTED_ERR';
80: WHEN OTHERS THEN
81: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
82: x_loading_status := 'UNEXPECTED_ERR';
83: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
84: THEN
85: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
86: END IF;
87:

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

81: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
82: x_loading_status := 'UNEXPECTED_ERR';
83: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
84: THEN
85: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
86: END IF;
87:
88: END valid_rule;
89: --=============================================================================

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

141:
142: IF l_check_siblings_rec.cnt > 0
143: THEN
144: --Error condition
145: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
146: THEN
147: fnd_message.set_name('CN', 'CN_DUPLICATE_RULE_NAME');
148: fnd_msg_pub.add;
149: END IF;

Line 148: fnd_msg_pub.add;

144: --Error condition
145: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
146: THEN
147: fnd_message.set_name('CN', 'CN_DUPLICATE_RULE_NAME');
148: fnd_msg_pub.add;
149: END IF;
150: x_loading_status := 'CN_DUPLICATE_RULE_NAME';
151: RAISE FND_API.G_EXC_ERROR;
152: ELSE

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

159: l_current_parent_rule_id := l_check_parents_rec.parent_rule_id;
160: IF l_check_parents_rec.name = p_rule_name
161: THEN
162: --Error condition
163: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
164: THEN
165: fnd_message.set_name('CN', 'CN_DUPLICATE_RULE_NAME');
166: fnd_msg_pub.add;
167: END IF;

Line 166: fnd_msg_pub.add;

162: --Error condition
163: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
164: THEN
165: fnd_message.set_name('CN', 'CN_DUPLICATE_RULE_NAME');
166: fnd_msg_pub.add;
167: END IF;
168: x_loading_status := 'CN_DUPLICATE_RULE_NAME';
169: RAISE FND_API.G_EXC_ERROR;
170: END IF;

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

180: RETURN fnd_api.g_true;
181:
182: WHEN OTHERS THEN
183: x_loading_status := 'UNEXPECTED_ERR';
184: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
185: THEN
186: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
187: END IF;
188: RETURN fnd_api.g_true;

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

182: WHEN OTHERS THEN
183: x_loading_status := 'UNEXPECTED_ERR';
184: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
185: THEN
186: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
187: END IF;
188: RETURN fnd_api.g_true;
189: END;
190: --=============================================================================

Line 262: FND_MSG_PUB.initialize;

258:
259: -- Initialize message list if p_init_msg_list is set to TRUE.
260: IF FND_API.to_Boolean( p_init_msg_list )
261: THEN
262: FND_MSG_PUB.initialize;
263: END IF;
264:
265: -- Initialize API return status to success
266: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

325:
326: IF l_count = 0
327: THEN
328: --Error condition
329: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
330: THEN
331: fnd_message.set_name('CN', 'CN_INVALID_RULESET');
332: fnd_msg_pub.add;
333: END IF;

Line 332: fnd_msg_pub.add;

328: --Error condition
329: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
330: THEN
331: fnd_message.set_name('CN', 'CN_INVALID_RULESET');
332: fnd_msg_pub.add;
333: END IF;
334: x_loading_status := 'CN_INVALID_RULESET';
335: RAISE FND_API.G_EXC_ERROR;
336: END IF;

Line 359: /*IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

355: x_loading_status,
356: x_loading_status) = fnd_api.g_true
357: THEN
358: --Error condition
359: /*IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
360: THEN
361: fnd_message.set_name('CN', 'CN_INVALID_RULE_NAME');
362: fnd_msg_pub.add;
363: END IF;

Line 362: fnd_msg_pub.add;

358: --Error condition
359: /*IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
360: THEN
361: fnd_message.set_name('CN', 'CN_INVALID_RULE_NAME');
362: fnd_msg_pub.add;
363: END IF;
364: */
365: x_loading_status := 'CN_INVALID_RULE_NAME';
366: RAISE FND_API.G_EXC_ERROR;

Line 421: FND_MSG_PUB.Count_And_Get

417: COMMIT WORK;
418: END IF;
419:
420: -- Standard call to get message count and if count is 1, get message info.
421: FND_MSG_PUB.Count_And_Get
422: (p_count => x_msg_count,
423: p_data => x_msg_data
424: );
425: EXCEPTION

Line 429: FND_MSG_PUB.Count_And_Get

425: EXCEPTION
426: WHEN FND_API.G_EXC_ERROR THEN
427: ROLLBACK TO Create_Rule;
428: x_return_status := FND_API.G_RET_STS_ERROR ;
429: FND_MSG_PUB.Count_And_Get
430: (p_count => x_msg_count,
431: p_data => x_msg_data,
432: p_encoded => fnd_api.g_false
433: );

Line 438: FND_MSG_PUB.Count_And_Get

434: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
435: ROLLBACK TO Create_Rule;
436: x_loading_status := 'UNEXPECTED_ERR';
437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
438: FND_MSG_PUB.Count_And_Get
439: (p_count => x_msg_count,
440: p_data => x_msg_data,
441: p_encoded => fnd_api.g_false
442: );

Line 447: IF FND_MSG_PUB.Check_Msg_Level

443: WHEN OTHERS THEN
444: ROLLBACK TO Create_Rule;
445: x_loading_status := 'UNEXPECTED_ERR';
446: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
447: IF FND_MSG_PUB.Check_Msg_Level
448: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
449: THEN
450: FND_MSG_PUB.Add_Exc_Msg
451: (G_PKG_NAME, l_api_name);

Line 448: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

444: ROLLBACK TO Create_Rule;
445: x_loading_status := 'UNEXPECTED_ERR';
446: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
447: IF FND_MSG_PUB.Check_Msg_Level
448: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
449: THEN
450: FND_MSG_PUB.Add_Exc_Msg
451: (G_PKG_NAME, l_api_name);
452: END IF;

Line 450: FND_MSG_PUB.Add_Exc_Msg

446: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
447: IF FND_MSG_PUB.Check_Msg_Level
448: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
449: THEN
450: FND_MSG_PUB.Add_Exc_Msg
451: (G_PKG_NAME, l_api_name);
452: END IF;
453: FND_MSG_PUB.Count_And_Get
454: (p_count => x_msg_count,

Line 453: FND_MSG_PUB.Count_And_Get

449: THEN
450: FND_MSG_PUB.Add_Exc_Msg
451: (G_PKG_NAME, l_api_name);
452: END IF;
453: FND_MSG_PUB.Count_And_Get
454: (p_count => x_msg_count,
455: p_data => x_msg_data,
456: p_encoded => fnd_api.g_false
457: );

Line 531: FND_MSG_PUB.initialize;

527:
528: -- Initialize message list if p_init_msg_list is set to TRUE.
529: IF FND_API.to_Boolean( p_init_msg_list )
530: THEN
531: FND_MSG_PUB.initialize;
532: END IF;
533:
534: -- Initialize API return status to success
535: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 547: fnd_msg_pub.add;

543: and org_id = p_old_rule_rec.org_id;
544:
545: if (l_object_version_number <> p_rule_rec.object_version_no) then
546: fnd_message.set_name('CN', 'CN_RECORD_CHANGED');
547: fnd_msg_pub.add;
548: raise fnd_api.g_exc_error;
549: end if;
550:
551: -- end Check for object version number mismatch

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

648:
649: IF l_count = 0
650: THEN
651: --Error condition
652: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
653: THEN
654: fnd_message.set_name('CN', 'CN_INVALID_RULESET');
655: fnd_msg_pub.add;
656: END IF;

Line 655: fnd_msg_pub.add;

651: --Error condition
652: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
653: THEN
654: fnd_message.set_name('CN', 'CN_INVALID_RULESET');
655: fnd_msg_pub.add;
656: END IF;
657: x_loading_status := 'CN_INVALID_RULESET';
658: RAISE FND_API.G_EXC_ERROR;
659: END IF;

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

671: org_id=p_rule_rec.org_id;
672: IF l_count = 0
673: THEN
674: --Error condition
675: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
676: THEN
677: fnd_message.set_name('CN', 'CN_INVALID_RULE');
678: fnd_msg_pub.add;
679: END IF;

Line 678: fnd_msg_pub.add;

674: --Error condition
675: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
676: THEN
677: fnd_message.set_name('CN', 'CN_INVALID_RULE');
678: fnd_msg_pub.add;
679: END IF;
680: x_loading_status := 'CN_INVALID_RULE';
681: RAISE FND_API.G_EXC_ERROR;
682: END IF;

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

690: and org_id=p_rule_rec.org_id;
691: IF l_count = 0
692: THEN
693: --Error condition
694: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
695: THEN
696: fnd_message.set_name('CN', 'CN_INVALID_RULE');
697: fnd_msg_pub.add;
698: END IF;

Line 697: fnd_msg_pub.add;

693: --Error condition
694: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
695: THEN
696: fnd_message.set_name('CN', 'CN_INVALID_RULE');
697: fnd_msg_pub.add;
698: END IF;
699: x_loading_status := 'CN_INVALID_RULE';
700: RAISE FND_API.G_EXC_ERROR;
701: END IF;

Line 714: /* IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

710: x_loading_status,
711: x_loading_status) = fnd_api.g_true
712: THEN
713: --Error condition
714: /* IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
715: THEN
716: fnd_message.set_name('CN', 'CN_INVALID_RULE_NAME');
717: fnd_msg_pub.add;
718: END IF;

Line 717: fnd_msg_pub.add;

713: --Error condition
714: /* IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
715: THEN
716: fnd_message.set_name('CN', 'CN_INVALID_RULE_NAME');
717: fnd_msg_pub.add;
718: END IF;
719: */
720:
721: x_loading_status := 'CN_INVALID_RULE_NAME';

Line 769: FND_MSG_PUB.Count_And_Get

765: COMMIT WORK;
766: END IF;
767:
768: -- Standard call to get message count and if count is 1, get message info.
769: FND_MSG_PUB.Count_And_Get
770: (p_count => x_msg_count,
771: p_data => x_msg_data
772: );
773: EXCEPTION

Line 777: FND_MSG_PUB.Count_And_Get

773: EXCEPTION
774: WHEN FND_API.G_EXC_ERROR THEN
775: ROLLBACK TO Update_Rule;
776: x_return_status := FND_API.G_RET_STS_ERROR ;
777: FND_MSG_PUB.Count_And_Get
778: (p_count => x_msg_count,
779: p_data => x_msg_data,
780: p_encoded => fnd_api.g_false
781: );

Line 786: FND_MSG_PUB.Count_And_Get

782: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
783: ROLLBACK TO Update_Rule;
784: x_loading_status := 'UNEXPECTED_ERR';
785: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
786: FND_MSG_PUB.Count_And_Get
787: (p_count => x_msg_count,
788: p_data => x_msg_data,
789: p_encoded => fnd_api.g_false
790: );

Line 795: IF FND_MSG_PUB.Check_Msg_Level

791: WHEN OTHERS THEN
792: ROLLBACK TO Update_Rule;
793: x_loading_status := 'UNEXPECTED_ERR';
794: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
795: IF FND_MSG_PUB.Check_Msg_Level
796: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
797: THEN
798: FND_MSG_PUB.Add_Exc_Msg
799: (G_PKG_NAME, l_api_name);

Line 796: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

792: ROLLBACK TO Update_Rule;
793: x_loading_status := 'UNEXPECTED_ERR';
794: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
795: IF FND_MSG_PUB.Check_Msg_Level
796: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
797: THEN
798: FND_MSG_PUB.Add_Exc_Msg
799: (G_PKG_NAME, l_api_name);
800: END IF;

Line 798: FND_MSG_PUB.Add_Exc_Msg

794: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
795: IF FND_MSG_PUB.Check_Msg_Level
796: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
797: THEN
798: FND_MSG_PUB.Add_Exc_Msg
799: (G_PKG_NAME, l_api_name);
800: END IF;
801: FND_MSG_PUB.Count_And_Get
802: (p_count => x_msg_count,

Line 801: FND_MSG_PUB.Count_And_Get

797: THEN
798: FND_MSG_PUB.Add_Exc_Msg
799: (G_PKG_NAME, l_api_name);
800: END IF;
801: FND_MSG_PUB.Count_And_Get
802: (p_count => x_msg_count,
803: p_data => x_msg_data,
804: p_encoded => fnd_api.g_false
805: );

Line 880: FND_MSG_PUB.initialize;

876:
877: -- Initialize message list if p_init_msg_list is set to TRUE.
878: IF FND_API.to_Boolean( p_init_msg_list )
879: THEN
880: FND_MSG_PUB.initialize;
881: END IF;
882:
883: -- Initialize API return status to success
884: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

901:
902: IF l_count <> 0
903: THEN
904: --Error condition
905: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
906: THEN
907: fnd_message.set_name('CN', 'CN_ATTRIBUTE_RULE_EXIST');
908: fnd_msg_pub.add;
909: END IF;

Line 908: fnd_msg_pub.add;

904: --Error condition
905: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
906: THEN
907: fnd_message.set_name('CN', 'CN_ATTRIBUTE_RULE_EXIST');
908: fnd_msg_pub.add;
909: END IF;
910:
911: x_loading_status := 'CN_ATTRIBUTE_RULE_EXIST';
912: RAISE FND_API.G_EXC_ERROR;

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

922:
923: IF l_count <> 1
924: THEN
925: --Error condition
926: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
927: THEN
928: fnd_message.set_name('CN', 'CN_INVALID_RULE');
929: fnd_msg_pub.add;
930: END IF;

Line 929: fnd_msg_pub.add;

925: --Error condition
926: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
927: THEN
928: fnd_message.set_name('CN', 'CN_INVALID_RULE');
929: fnd_msg_pub.add;
930: END IF;
931:
932: x_loading_status := 'CN_INVALID_RULE';
933: RAISE FND_API.G_EXC_ERROR;

Line 953: FND_MSG_PUB.Count_And_Get

949: COMMIT WORK;
950: END IF;
951:
952: -- Standard call to get message count and if count is 1, get message info.
953: FND_MSG_PUB.Count_And_Get
954: (p_count => x_msg_count,
955: p_data => x_msg_data
956: );
957: EXCEPTION

Line 961: FND_MSG_PUB.Count_And_Get

957: EXCEPTION
958: WHEN FND_API.G_EXC_ERROR THEN
959: ROLLBACK TO Delete_Rule;
960: x_return_status := FND_API.G_RET_STS_ERROR ;
961: FND_MSG_PUB.Count_And_Get
962: (p_count => x_msg_count,
963: p_data => x_msg_data,
964: p_encoded => fnd_api.g_false
965: );

Line 970: FND_MSG_PUB.Count_And_Get

966: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
967: ROLLBACK TO Delete_Rule;
968: x_loading_status := 'UNEXPECTED_ERR';
969: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
970: FND_MSG_PUB.Count_And_Get
971: (p_count => x_msg_count,
972: p_data => x_msg_data,
973: p_encoded => fnd_api.g_false
974: );

Line 979: IF FND_MSG_PUB.Check_Msg_Level

975: WHEN OTHERS THEN
976: ROLLBACK TO Delete_Rule;
977: x_loading_status := 'UNEXPECTED_ERR';
978: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
979: IF FND_MSG_PUB.Check_Msg_Level
980: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
981: THEN
982: FND_MSG_PUB.Add_Exc_Msg
983: (G_PKG_NAME, l_api_name );

Line 980: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

976: ROLLBACK TO Delete_Rule;
977: x_loading_status := 'UNEXPECTED_ERR';
978: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
979: IF FND_MSG_PUB.Check_Msg_Level
980: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
981: THEN
982: FND_MSG_PUB.Add_Exc_Msg
983: (G_PKG_NAME, l_api_name );
984: END IF;

Line 982: FND_MSG_PUB.Add_Exc_Msg

978: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
979: IF FND_MSG_PUB.Check_Msg_Level
980: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
981: THEN
982: FND_MSG_PUB.Add_Exc_Msg
983: (G_PKG_NAME, l_api_name );
984: END IF;
985: FND_MSG_PUB.Count_And_Get
986: (p_count => x_msg_count,

Line 985: FND_MSG_PUB.Count_And_Get

981: THEN
982: FND_MSG_PUB.Add_Exc_Msg
983: (G_PKG_NAME, l_api_name );
984: END IF;
985: FND_MSG_PUB.Count_And_Get
986: (p_count => x_msg_count,
987: p_data => x_msg_data,
988: p_encoded => fnd_api.g_false
989: );

Line 1074: FND_MSG_PUB.initialize;

1070: --
1071: -- Initialize message list if p_init_msg_list is set to TRUE.
1072: --
1073: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1074: FND_MSG_PUB.initialize;
1075: END IF;
1076:
1077: --
1078: -- Initialize API return status to success

Line 1175: FND_MSG_PUB.Count_And_Get

1171: COMMIT WORK;
1172: END IF;
1173:
1174: -- Get and Count Messages
1175: FND_MSG_PUB.Count_And_Get
1176: (
1177: p_count => x_msg_count ,
1178: p_data => x_msg_data ,
1179: p_encoded => FND_API.G_FALSE

Line 1186: FND_MSG_PUB.Count_And_Get

1182: EXCEPTION
1183: WHEN FND_API.G_EXC_ERROR THEN
1184: ROLLBACK TO Get_rules;
1185: x_return_status := FND_API.G_RET_STS_ERROR ;
1186: FND_MSG_PUB.Count_And_Get
1187: (
1188: p_count => x_msg_count ,
1189: p_data => x_msg_data ,
1190: p_encoded => FND_API.G_FALSE

Line 1196: FND_MSG_PUB.Count_And_Get

1192: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1193: ROLLBACK TO Get_rules;
1194: x_loading_status := 'UNEXPECTED_ERR';
1195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1196: FND_MSG_PUB.Count_And_Get
1197: (
1198: p_count => x_msg_count ,
1199: p_data => x_msg_data ,
1200: p_encoded => FND_API.G_FALSE

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

1202: WHEN OTHERS THEN
1203: ROLLBACK TO Get_rules;
1204: x_loading_status := 'UNEXPECTED_ERR';
1205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1206: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1207: THEN
1208: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1209: END IF;
1210: FND_MSG_PUB.Count_And_Get (

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

1204: x_loading_status := 'UNEXPECTED_ERR';
1205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1206: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1207: THEN
1208: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1209: END IF;
1210: FND_MSG_PUB.Count_And_Get (
1211: p_count => x_msg_count ,
1212: p_data => x_msg_data ,

Line 1210: FND_MSG_PUB.Count_And_Get (

1206: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1207: THEN
1208: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1209: END IF;
1210: FND_MSG_PUB.Count_And_Get (
1211: p_count => x_msg_count ,
1212: p_data => x_msg_data ,
1213: p_encoded => FND_API.G_FALSE
1214: );