DBA Data[Home] [Help]

APPS.CN_RULE_PUB dependencies on FND_MSG_PUB

Line 106: FND_MSG_PUB.initialize;

102:
103: -- Initialize message list if p_init_msg_list is set to TRUE.
104: IF FND_API.to_Boolean( p_init_msg_list )
105: THEN
106: FND_MSG_PUB.initialize;
107: END IF;
108:
109: -- Initialize API return status to success
110: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

242:
243: IF l_count = 0
244: THEN
245: --Error condition
246: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
247: THEN
248: fnd_message.set_name('CN', 'CN_INVALID_RULESET');
249: fnd_msg_pub.add;
250: END IF;

Line 249: fnd_msg_pub.add;

245: --Error condition
246: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
247: THEN
248: fnd_message.set_name('CN', 'CN_INVALID_RULESET');
249: fnd_msg_pub.add;
250: END IF;
251: x_loading_status := 'CN_INVALID_RULESET';
252: RAISE FND_API.G_EXC_ERROR;
253: ELSE

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

272:
273: IF l_count = 0
274: THEN
275: --Error condition
276: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
277: THEN
278: fnd_message.set_name('CN', 'CN_INVALID_REVENUE_CLASS');
279: fnd_msg_pub.add;
280: END IF;

Line 279: fnd_msg_pub.add;

275: --Error condition
276: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
277: THEN
278: fnd_message.set_name('CN', 'CN_INVALID_REVENUE_CLASS');
279: fnd_msg_pub.add;
280: END IF;
281: x_loading_status := 'CN_INVALID_REVENUE_CLASS';
282: RAISE FND_API.G_EXC_ERROR;
283: ELSE

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

299:
300: IF l_count = 0
301: THEN
302: --Error condition
303: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
304: THEN
305: fnd_message.set_name('CN', 'CN_INVALID_EXPENSE_AC');
306: fnd_msg_pub.add;
307: END IF;

Line 306: fnd_msg_pub.add;

302: --Error condition
303: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
304: THEN
305: fnd_message.set_name('CN', 'CN_INVALID_EXPENSE_AC');
306: fnd_msg_pub.add;
307: END IF;
308: x_loading_status := 'CN_INVALID_EXPENSE_AC';
309: RAISE FND_API.G_EXC_ERROR;
310: ELSE

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

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

Line 330: fnd_msg_pub.add;

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

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

347:
348: IF l_count = 0
349: THEN
350: --Error condition
351: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
352: THEN
353: fnd_message.set_name('CN', 'CN_INVALID_PARENT_RULE');
354: fnd_msg_pub.add;
355: END IF;

Line 354: fnd_msg_pub.add;

350: --Error condition
351: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
352: THEN
353: fnd_message.set_name('CN', 'CN_INVALID_PARENT_RULE');
354: fnd_msg_pub.add;
355: END IF;
356: x_loading_status := 'CN_INVALID_PARENT_RULE';
357: RAISE FND_API.G_EXC_ERROR;
358:

Line 543: FND_MSG_PUB.Count_And_Get

539: COMMIT WORK;
540: END IF;
541:
542: -- Standard call to get message count and if count is 1, get message info.
543: FND_MSG_PUB.Count_And_Get
544: (p_count => x_msg_count,
545: p_data => x_msg_data
546: );
547: EXCEPTION

Line 551: FND_MSG_PUB.Count_And_Get

547: EXCEPTION
548: WHEN FND_API.G_EXC_ERROR THEN
549: ROLLBACK TO Create_Rule;
550: x_return_status := FND_API.G_RET_STS_ERROR ;
551: FND_MSG_PUB.Count_And_Get
552: (p_count => x_msg_count,
553: p_data => x_msg_data,
554: p_encoded => fnd_api.g_false
555: );

Line 560: FND_MSG_PUB.Count_And_Get

556: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
557: ROLLBACK TO Create_Rule;
558: x_loading_status := 'UNEXPECTED_ERR';
559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
560: FND_MSG_PUB.Count_And_Get
561: (p_count => x_msg_count,
562: p_data => x_msg_data,
563: p_encoded => fnd_api.g_false
564: );

Line 569: IF FND_MSG_PUB.Check_Msg_Level

565: WHEN OTHERS THEN
566: ROLLBACK TO Create_Rule;
567: x_loading_status := 'UNEXPECTED_ERR';
568: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
569: IF FND_MSG_PUB.Check_Msg_Level
570: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
571: THEN
572: FND_MSG_PUB.Add_Exc_Msg
573: (G_PKG_NAME, l_api_name);

Line 570: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

566: ROLLBACK TO Create_Rule;
567: x_loading_status := 'UNEXPECTED_ERR';
568: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
569: IF FND_MSG_PUB.Check_Msg_Level
570: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
571: THEN
572: FND_MSG_PUB.Add_Exc_Msg
573: (G_PKG_NAME, l_api_name);
574: END IF;

Line 572: FND_MSG_PUB.Add_Exc_Msg

568: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
569: IF FND_MSG_PUB.Check_Msg_Level
570: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
571: THEN
572: FND_MSG_PUB.Add_Exc_Msg
573: (G_PKG_NAME, l_api_name);
574: END IF;
575: FND_MSG_PUB.Count_And_Get
576: (p_count => x_msg_count,

Line 575: FND_MSG_PUB.Count_And_Get

571: THEN
572: FND_MSG_PUB.Add_Exc_Msg
573: (G_PKG_NAME, l_api_name);
574: END IF;
575: FND_MSG_PUB.Count_And_Get
576: (p_count => x_msg_count,
577: p_data => x_msg_data,
578: p_encoded => fnd_api.g_false
579: );

Line 685: FND_MSG_PUB.initialize;

681:
682: -- Initialize message list if p_init_msg_list is set to TRUE.
683: IF FND_API.to_Boolean( p_init_msg_list )
684: THEN
685: FND_MSG_PUB.initialize;
686: END IF;
687:
688: -- Initialize API return status to success
689: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

851: AND end_date = l_old_rule_rec.end_date;
852: IF l_count = 0
853: THEN
854: --Error condition
855: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
856: THEN
857: fnd_message.set_name('CN', 'CN_INVALID_RULESET');
858: fnd_msg_pub.add;
859: END IF;

Line 858: fnd_msg_pub.add;

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

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

877: AND end_date = l_rule_rec.end_date;
878: IF l_count = 0
879: THEN
880: --Error condition
881: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
882: THEN
883: fnd_message.set_name('CN', 'CN_INVALID_RULESET');
884: fnd_msg_pub.add;
885: END IF;

Line 884: fnd_msg_pub.add;

880: --Error condition
881: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
882: THEN
883: fnd_message.set_name('CN', 'CN_INVALID_RULESET');
884: fnd_msg_pub.add;
885: END IF;
886: x_loading_status := 'CN_INVALID_RULESET';
887: RAISE FND_API.G_EXC_ERROR;
888: ELSE

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

904:
905: IF l_count = 0
906: THEN
907: --Error condition
908: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
909: THEN
910: fnd_message.set_name('CN', 'CN_INVALID_RULE');
911: fnd_msg_pub.add;
912: END IF;

Line 911: fnd_msg_pub.add;

907: --Error condition
908: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
909: THEN
910: fnd_message.set_name('CN', 'CN_INVALID_RULE');
911: fnd_msg_pub.add;
912: END IF;
913: x_loading_status := 'CN_INVALID_RULE';
914: RAISE FND_API.G_EXC_ERROR;
915: END IF;

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

924:
925: IF l_count = 0
926: THEN
927: --Error condition
928: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
929: THEN
930: fnd_message.set_name('CN', 'CN_INVALID_RULE');
931: fnd_msg_pub.add;
932: END IF;

Line 931: fnd_msg_pub.add;

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

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

945:
946: IF l_count = 0
947: THEN
948: --Error condition
949: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
950: THEN
951: fnd_message.set_name('CN', 'CN_INVALID_REVENUE_CLASS');
952: fnd_msg_pub.add;
953: END IF;

Line 952: fnd_msg_pub.add;

948: --Error condition
949: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
950: THEN
951: fnd_message.set_name('CN', 'CN_INVALID_REVENUE_CLASS');
952: fnd_msg_pub.add;
953: END IF;
954: x_loading_status := 'CN_INVALID_REVENUE_CLASS';
955: RAISE FND_API.G_EXC_ERROR;
956: ELSE

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

971:
972: IF l_count = 0
973: THEN
974: --Error condition
975: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
976: THEN
977: fnd_message.set_name('CN', 'CN_INVALID_EXPENSE_CCID');
978: fnd_msg_pub.add;
979: END IF;

Line 978: fnd_msg_pub.add;

974: --Error condition
975: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
976: THEN
977: fnd_message.set_name('CN', 'CN_INVALID_EXPENSE_CCID');
978: fnd_msg_pub.add;
979: END IF;
980: x_loading_status := 'CN_INVALID_EXPENSE_CCID';
981: RAISE FND_API.G_EXC_ERROR;
982: ELSE

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

994:
995: IF l_count = 0
996: THEN
997: --Error condition
998: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
999: THEN
1000: fnd_message.set_name('CN', 'CN_INVALID_LIABILITY_CCID');
1001: fnd_msg_pub.add;
1002: END IF;

Line 1001: fnd_msg_pub.add;

997: --Error condition
998: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
999: THEN
1000: fnd_message.set_name('CN', 'CN_INVALID_LIABILITY_CCID');
1001: fnd_msg_pub.add;
1002: END IF;
1003: x_loading_status := 'CN_INVALID_LIABILITY_CCID';
1004: RAISE FND_API.G_EXC_ERROR;
1005: ELSE

Line 1208: FND_MSG_PUB.Count_And_Get

1204: COMMIT WORK;
1205: END IF;
1206:
1207: -- Standard call to get message count and if count is 1, get message info.
1208: FND_MSG_PUB.Count_And_Get
1209: (p_count => x_msg_count,
1210: p_data => x_msg_data
1211: );
1212: EXCEPTION

Line 1216: FND_MSG_PUB.Count_And_Get

1212: EXCEPTION
1213: WHEN FND_API.G_EXC_ERROR THEN
1214: ROLLBACK TO Update_Rule;
1215: x_return_status := FND_API.G_RET_STS_ERROR ;
1216: FND_MSG_PUB.Count_And_Get
1217: (p_count => x_msg_count,
1218: p_data => x_msg_data,
1219: p_encoded => fnd_api.g_false
1220: );

Line 1225: FND_MSG_PUB.Count_And_Get

1221: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1222: ROLLBACK TO Update_Rule;
1223: x_loading_status := 'UNEXPECTED_ERR';
1224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1225: FND_MSG_PUB.Count_And_Get
1226: (p_count => x_msg_count,
1227: p_data => x_msg_data,
1228: p_encoded => fnd_api.g_false
1229: );

Line 1234: IF FND_MSG_PUB.Check_Msg_Level

1230: WHEN OTHERS THEN
1231: ROLLBACK TO Update_Rule;
1232: x_loading_status := 'UNEXPECTED_ERR';
1233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1234: IF FND_MSG_PUB.Check_Msg_Level
1235: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1236: THEN
1237: FND_MSG_PUB.Add_Exc_Msg
1238: (G_PKG_NAME, l_api_name);

Line 1235: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1231: ROLLBACK TO Update_Rule;
1232: x_loading_status := 'UNEXPECTED_ERR';
1233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1234: IF FND_MSG_PUB.Check_Msg_Level
1235: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1236: THEN
1237: FND_MSG_PUB.Add_Exc_Msg
1238: (G_PKG_NAME, l_api_name);
1239: END IF;

Line 1237: FND_MSG_PUB.Add_Exc_Msg

1233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1234: IF FND_MSG_PUB.Check_Msg_Level
1235: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1236: THEN
1237: FND_MSG_PUB.Add_Exc_Msg
1238: (G_PKG_NAME, l_api_name);
1239: END IF;
1240: FND_MSG_PUB.Count_And_Get
1241: (p_count => x_msg_count,

Line 1240: FND_MSG_PUB.Count_And_Get

1236: THEN
1237: FND_MSG_PUB.Add_Exc_Msg
1238: (G_PKG_NAME, l_api_name);
1239: END IF;
1240: FND_MSG_PUB.Count_And_Get
1241: (p_count => x_msg_count,
1242: p_data => x_msg_data,
1243: p_encoded => fnd_api.g_false
1244: );

Line 1339: FND_MSG_PUB.initialize;

1335:
1336: -- Initialize message list if p_init_msg_list is set to TRUE.
1337: IF FND_API.to_Boolean( p_init_msg_list )
1338: THEN
1339: FND_MSG_PUB.initialize;
1340: END IF;
1341:
1342: -- Initialize API return status to success
1343: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1427:
1428: IF l_count = 0
1429: THEN
1430: --Error condition
1431: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1432: THEN
1433: fnd_message.set_name('CN', 'CN_INVALID_RULESET');
1434: fnd_msg_pub.add;
1435: END IF;

Line 1434: fnd_msg_pub.add;

1430: --Error condition
1431: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1432: THEN
1433: fnd_message.set_name('CN', 'CN_INVALID_RULESET');
1434: fnd_msg_pub.add;
1435: END IF;
1436:
1437: x_loading_status := 'CN_INVALID_RULESET';
1438: RAISE FND_API.G_EXC_ERROR;

Line 1611: FND_MSG_PUB.Count_And_Get

1607: COMMIT WORK;
1608: END IF;
1609:
1610: -- Standard call to get message count and if count is 1, get message info.
1611: FND_MSG_PUB.Count_And_Get
1612: (p_count => x_msg_count,
1613: p_data => x_msg_data
1614: );
1615: EXCEPTION

Line 1619: FND_MSG_PUB.Count_And_Get

1615: EXCEPTION
1616: WHEN FND_API.G_EXC_ERROR THEN
1617: ROLLBACK TO Delete_Rule;
1618: x_return_status := FND_API.G_RET_STS_ERROR ;
1619: FND_MSG_PUB.Count_And_Get
1620: (p_count => x_msg_count,
1621: p_data => x_msg_data,
1622: p_encoded => fnd_api.g_false
1623: );

Line 1628: FND_MSG_PUB.Count_And_Get

1624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1625: ROLLBACK TO Delete_Rule;
1626: x_loading_status := 'UNEXPECTED_ERR';
1627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1628: FND_MSG_PUB.Count_And_Get
1629: (p_count => x_msg_count,
1630: p_data => x_msg_data,
1631: p_encoded => fnd_api.g_false
1632: );

Line 1637: IF FND_MSG_PUB.Check_Msg_Level

1633: WHEN OTHERS THEN
1634: ROLLBACK TO Delete_Rule;
1635: x_loading_status := 'UNEXPECTED_ERR';
1636: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1637: IF FND_MSG_PUB.Check_Msg_Level
1638: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1639: THEN
1640: FND_MSG_PUB.Add_Exc_Msg
1641: (G_PKG_NAME, l_api_name );

Line 1638: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1634: ROLLBACK TO Delete_Rule;
1635: x_loading_status := 'UNEXPECTED_ERR';
1636: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1637: IF FND_MSG_PUB.Check_Msg_Level
1638: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1639: THEN
1640: FND_MSG_PUB.Add_Exc_Msg
1641: (G_PKG_NAME, l_api_name );
1642: END IF;

Line 1640: FND_MSG_PUB.Add_Exc_Msg

1636: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1637: IF FND_MSG_PUB.Check_Msg_Level
1638: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1639: THEN
1640: FND_MSG_PUB.Add_Exc_Msg
1641: (G_PKG_NAME, l_api_name );
1642: END IF;
1643: FND_MSG_PUB.Count_And_Get
1644: (p_count => x_msg_count,

Line 1643: FND_MSG_PUB.Count_And_Get

1639: THEN
1640: FND_MSG_PUB.Add_Exc_Msg
1641: (G_PKG_NAME, l_api_name );
1642: END IF;
1643: FND_MSG_PUB.Count_And_Get
1644: (p_count => x_msg_count,
1645: p_data => x_msg_data,
1646: p_encoded => fnd_api.g_false
1647: );