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

Line 65: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

61: x_loading_status := p_loading_status;
62:
63: for attribute_rec in no_attribute_curs loop
64:
65: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
66: fnd_message.set_name('CN', 'CN_NO_RULE_ATTRIBUTES_DEFINED');
67: fnd_message.set_token('CLASSIFICATION_RULE_NAME', p_name);
68: fnd_message.set_token('RULE_NAME', attribute_rec.name);
69: fnd_msg_pub.add;

Line 69: fnd_msg_pub.add;

65: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
66: fnd_message.set_name('CN', 'CN_NO_RULE_ATTRIBUTES_DEFINED');
67: fnd_message.set_token('CLASSIFICATION_RULE_NAME', p_name);
68: fnd_message.set_token('RULE_NAME', attribute_rec.name);
69: fnd_msg_pub.add;
70: RAISE FND_API.G_EXC_ERROR;
71: END IF;
72:
73: END LOOP;

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

131: RETURN fnd_api.g_true;
132:
133: WHEN OTHERS THEN
134: x_loading_status := 'UNEXPECTED_ERR';
135: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
136: THEN
137: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
138: END IF;
139: RETURN fnd_api.g_true;

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

133: WHEN OTHERS THEN
134: x_loading_status := 'UNEXPECTED_ERR';
135: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
136: THEN
137: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
138: END IF;
139: RETURN fnd_api.g_true;
140:
141: END Check_Sync_Allowed;

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

189:
190: IF l_total_record > 0 THEN
191:
192: --Error condition
193: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
194: THEN
195: fnd_message.set_name('CN', 'CN_CANNOT_CHANGE_TYPE');
196: fnd_msg_pub.add;
197: END IF;

Line 196: fnd_msg_pub.add;

192: --Error condition
193: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
194: THEN
195: fnd_message.set_name('CN', 'CN_CANNOT_CHANGE_TYPE');
196: fnd_msg_pub.add;
197: END IF;
198: x_loading_status := 'CN_CANNOT_TYPE_TYPE';
199: RAISE FND_API.G_EXC_ERROR;
200:

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

213: RETURN fnd_api.g_true;
214:
215: WHEN OTHERS THEN
216: x_loading_status := 'UNEXPECTED_ERR';
217: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
218: THEN
219: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
220: END IF;
221: RETURN fnd_api.g_true;

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

215: WHEN OTHERS THEN
216: x_loading_status := 'UNEXPECTED_ERR';
217: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
218: THEN
219: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
220: END IF;
221: RETURN fnd_api.g_true;
222:
223: END check_update_allowed;

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

267: IF p_start_date > p_end_date
268: THEN
269:
270: --Error condition
271: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
272: THEN
273: fnd_message.set_name('CN', 'CN_INVALID_DATE_RANGE');
274: fnd_msg_pub.add;
275: END IF;

Line 274: fnd_msg_pub.add;

270: --Error condition
271: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
272: THEN
273: fnd_message.set_name('CN', 'CN_INVALID_DATE_RANGE');
274: fnd_msg_pub.add;
275: END IF;
276:
277: x_loading_status := 'CN_INVALID_DATE_RANGE';
278: RAISE FND_API.G_EXC_ERROR;

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

285: IF l_count > 0
286: THEN
287:
288: --Error condition
289: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
290: THEN
291: fnd_message.set_name('CN', 'CN_OVERLAP_RULESETS');
292: fnd_msg_pub.add;
293: END IF;

Line 292: fnd_msg_pub.add;

288: --Error condition
289: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
290: THEN
291: fnd_message.set_name('CN', 'CN_OVERLAP_RULESETS');
292: fnd_msg_pub.add;
293: END IF;
294: CLOSE overlap_check1;
295: x_loading_status := 'CN_OVERLAP_RULESETS';
296: RAISE FND_API.G_EXC_ERROR;

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

304: IF l_count > 0
305: THEN
306:
307: --Error condition
308: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
309: THEN
310: fnd_message.set_name('CN', 'CN_OVERLAP_RULESETS');
311: fnd_msg_pub.add;
312: END IF;

Line 311: fnd_msg_pub.add;

307: --Error condition
308: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
309: THEN
310: fnd_message.set_name('CN', 'CN_OVERLAP_RULESETS');
311: fnd_msg_pub.add;
312: END IF;
313: CLOSE overlap_check1;
314: x_loading_status := 'CN_OVERLAP_RULESETS';
315: RAISE FND_API.G_EXC_ERROR;

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

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

Line 331: fnd_msg_pub.add;

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

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

348: RETURN fnd_api.g_true;
349:
350: WHEN OTHERS THEN
351: x_loading_status := 'UNEXPECTED_ERR';
352: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
353: THEN
354: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
355: END IF;
356: RETURN fnd_api.g_true;

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

350: WHEN OTHERS THEN
351: x_loading_status := 'UNEXPECTED_ERR';
352: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
353: THEN
354: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
355: END IF;
356: RETURN fnd_api.g_true;
357: END check_ruleset_dates;
358:

Line 432: FND_MSG_PUB.initialize;

428:
429: -- Initialize message list if p_init_msg_list is set to TRUE.
430: IF FND_API.to_Boolean( p_init_msg_list )
431: THEN
432: FND_MSG_PUB.initialize;
433: END IF;
434:
435: -- Initialize API return status to success
436: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

491:
492: IF l_count <> 0
493: THEN
494: --Error condition
495: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
496: THEN
497: fnd_message.set_name('CN', 'CN_RULESET_EXISTS');
498: fnd_msg_pub.add;
499: END IF;

Line 498: fnd_msg_pub.add;

494: --Error condition
495: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
496: THEN
497: fnd_message.set_name('CN', 'CN_RULESET_EXISTS');
498: fnd_msg_pub.add;
499: END IF;
500:
501: x_loading_status := 'CN_RULESET_EXISTS';
502: RAISE FND_API.G_EXC_ERROR;

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

523: IF p_ruleset_rec.module_type NOT IN ('REVCLS', 'ACCGEN', 'PECLS')
524: THEN
525:
526: --Error condition
527: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
528: THEN
529: fnd_message.set_name('CN', 'CN_INVALID_RULESET_TYPE');
530: fnd_msg_pub.add;
531: END IF;

Line 530: fnd_msg_pub.add;

526: --Error condition
527: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
528: THEN
529: fnd_message.set_name('CN', 'CN_INVALID_RULESET_TYPE');
530: fnd_msg_pub.add;
531: END IF;
532: x_loading_status := 'CN_INVALID_RULESET_TYPE';
533:
534: RAISE fnd_api.g_exc_error;

Line 567: FND_MSG_PUB.Count_And_Get

563:
564: x_ruleset_id := l_ruleset_id;
565:
566:
567: FND_MSG_PUB.Count_And_Get
568: (
569: p_count => x_msg_count ,
570: p_data => x_msg_data ,
571: p_encoded => FND_API.G_FALSE

Line 577: FND_MSG_PUB.Count_And_Get

573: EXCEPTION
574: WHEN FND_API.G_EXC_ERROR THEN
575: ROLLBACK TO Create_Ruleset;
576: x_return_status := FND_API.G_RET_STS_ERROR ;
577: FND_MSG_PUB.Count_And_Get
578: (
579: p_count => x_msg_count ,
580: p_data => x_msg_data ,
581: p_encoded => FND_API.G_FALSE

Line 587: FND_MSG_PUB.Count_And_Get

583: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
584: ROLLBACK TO Create_Ruleset;
585: x_loading_status := 'UNEXPECTED_ERR';
586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
587: FND_MSG_PUB.Count_And_Get
588: (
589: p_count => x_msg_count ,
590: p_data => x_msg_data ,
591: p_encoded => FND_API.G_FALSE

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

593: WHEN OTHERS THEN
594: ROLLBACK TO Create_Ruleset;
595: x_loading_status := 'UNEXPECTED_ERR';
596: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
597: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
598: THEN
599: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
600: END IF;
601: FND_MSG_PUB.Count_And_Get

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

595: x_loading_status := 'UNEXPECTED_ERR';
596: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
597: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
598: THEN
599: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
600: END IF;
601: FND_MSG_PUB.Count_And_Get
602: (
603: p_count => x_msg_count ,

Line 601: FND_MSG_PUB.Count_And_Get

597: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
598: THEN
599: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
600: END IF;
601: FND_MSG_PUB.Count_And_Get
602: (
603: p_count => x_msg_count ,
604: p_data => x_msg_data ,
605: p_encoded => FND_API.G_FALSE

Line 710: FND_MSG_PUB.initialize;

706:
707: -- Initialize message list if p_init_msg_list is set to TRUE.
708: IF FND_API.to_Boolean( p_init_msg_list )
709: THEN
710: FND_MSG_PUB.initialize;
711: END IF;
712:
713: -- Initialize API return status to success
714: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

795:
796: IF l_count = 0
797: THEN
798: --Error condition
799: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
800: THEN
801: fnd_message.set_name('CN', 'CN_INVALID_RULESET');
802: fnd_msg_pub.add;
803: END IF;

Line 802: fnd_msg_pub.add;

798: --Error condition
799: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
800: THEN
801: fnd_message.set_name('CN', 'CN_INVALID_RULESET');
802: fnd_msg_pub.add;
803: END IF;
804:
805: x_loading_status := 'CN_INVALID_RULESET';
806: RAISE FND_API.G_EXC_ERROR;

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

809: IF p_ruleset_rec.module_type NOT IN ('REVCLS', 'ACCGEN', 'PECLS')
810: THEN
811:
812: --Error condition
813: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
814: THEN
815: fnd_message.set_name('CN', 'CN_INVALID_RULESET_TYPE');
816: fnd_msg_pub.add;
817: END IF;

Line 816: fnd_msg_pub.add;

812: --Error condition
813: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
814: THEN
815: fnd_message.set_name('CN', 'CN_INVALID_RULESET_TYPE');
816: fnd_msg_pub.add;
817: END IF;
818: x_loading_status := 'CN_INVALID_RULESET_TYPE';
819:
820: RAISE fnd_api.g_exc_error;

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

828:
829: IF (l_object_version_number <>
830: p_ruleset_rec.object_version_number) THEN
831:
832: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
833: THEN
834: fnd_message.set_name('CN', 'CN_INVALID_OBJECT_VERSION');
835: fnd_msg_pub.add;
836: END IF;

Line 835: fnd_msg_pub.add;

831:
832: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
833: THEN
834: fnd_message.set_name('CN', 'CN_INVALID_OBJECT_VERSION');
835: fnd_msg_pub.add;
836: END IF;
837:
838: x_loading_status := 'CN_INVALID_OBJECT_VERSION';
839: RAISE FND_API.G_EXC_ERROR;

Line 858: --IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

854: x_loading_status) = fnd_api.g_true
855: THEN
856: RAISE fnd_api.g_exc_error;
857: --Error condition
858: --IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
859: -- THEN
860: -- fnd_message.set_name('CN', 'CN_INVALID_RULESET');
861: -- fnd_msg_pub.add;
862: --END IF;

Line 861: -- fnd_msg_pub.add;

857: --Error condition
858: --IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
859: -- THEN
860: -- fnd_message.set_name('CN', 'CN_INVALID_RULESET');
861: -- fnd_msg_pub.add;
862: --END IF;
863: ----x_loading_status := 'CN_INVALID_RULESET';
864: ----RAISE FND_API.G_EXC_ERROR;
865: END IF;

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

909: --
910: -- check sync allowed.
911: --
912: IF nvl(l_rules,0) = 0 THEN
913: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
914: THEN
915: fnd_message.set_name('CN', 'CN_NO_RULES_DEFINED');
916: fnd_msg_pub.add;
917: END IF;

Line 916: fnd_msg_pub.add;

912: IF nvl(l_rules,0) = 0 THEN
913: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
914: THEN
915: fnd_message.set_name('CN', 'CN_NO_RULES_DEFINED');
916: fnd_msg_pub.add;
917: END IF;
918: x_loading_status := 'CN_NO_RULES_DEFINED';
919: RAISE FND_API.G_EXC_ERROR;
920: END IF;

Line 983: FND_MSG_PUB.Count_And_Get

979: END IF;
980:
981:
982: -- Standard call to get message count and if count is 1, get message info.
983: FND_MSG_PUB.Count_And_Get
984: (
985: p_count => x_msg_count ,
986: p_data => x_msg_data ,
987: p_encoded => FND_API.G_FALSE

Line 995: FND_MSG_PUB.Count_And_Get

991: WHEN FND_API.G_EXC_ERROR THEN
992: ROLLBACK TO Update_Ruleset;
993: x_return_status := FND_API.G_RET_STS_ERROR ;
994:
995: FND_MSG_PUB.Count_And_Get
996: (
997: p_count => x_msg_count ,
998: p_data => x_msg_data ,
999: p_encoded => FND_API.G_FALSE

Line 1005: FND_MSG_PUB.Count_And_Get

1001:
1002: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1003: ROLLBACK TO Update_Ruleset;
1004: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1005: FND_MSG_PUB.Count_And_Get
1006: (
1007: p_count => x_msg_count ,
1008: p_data => x_msg_data ,
1009: p_encoded => FND_API.G_FALSE

Line 1015: IF FND_MSG_PUB.Check_Msg_Level

1011:
1012: WHEN OTHERS THEN
1013: ROLLBACK TO Update_Ruleset;
1014: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1015: IF FND_MSG_PUB.Check_Msg_Level
1016: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1017: THEN
1018: FND_MSG_PUB.Add_Exc_Msg
1019: (G_PKG_NAME,

Line 1016: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1012: WHEN OTHERS THEN
1013: ROLLBACK TO Update_Ruleset;
1014: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1015: IF FND_MSG_PUB.Check_Msg_Level
1016: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1017: THEN
1018: FND_MSG_PUB.Add_Exc_Msg
1019: (G_PKG_NAME,
1020: l_api_name

Line 1018: FND_MSG_PUB.Add_Exc_Msg

1014: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1015: IF FND_MSG_PUB.Check_Msg_Level
1016: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1017: THEN
1018: FND_MSG_PUB.Add_Exc_Msg
1019: (G_PKG_NAME,
1020: l_api_name
1021: );
1022: END IF;

Line 1024: FND_MSG_PUB.Count_And_Get

1020: l_api_name
1021: );
1022: END IF;
1023:
1024: FND_MSG_PUB.Count_And_Get
1025: (
1026: p_count => x_msg_count ,
1027: p_data => x_msg_data ,
1028: p_encoded => FND_API.G_FALSE