DBA Data[Home] [Help]

APPS.CN_RULEATTRIBUTE_PUB dependencies on FND_MSG_PUB

Line 97: FND_MSG_PUB.initialize;

93:
94: -- Initialize message list if p_init_msg_list is set to TRUE.
95: IF FND_API.to_Boolean( p_init_msg_list )
96: THEN
97: FND_MSG_PUB.initialize;
98: END IF;
99:
100: -- Initialize API return status to success
101: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

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

Line 251: fnd_msg_pub.add;

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

Line 426: FND_MSG_PUB.Count_And_Get

422: COMMIT WORK;
423: END IF;
424:
425: -- Standard call to get message count and if count is 1, get message info.
426: FND_MSG_PUB.Count_And_Get
427: (p_count => x_msg_count,
428: p_data => x_msg_data
429: );
430: EXCEPTION

Line 434: FND_MSG_PUB.Count_And_Get

430: EXCEPTION
431: WHEN FND_API.G_EXC_ERROR THEN
432: ROLLBACK TO Create_RuleAttribute;
433: x_return_status := FND_API.G_RET_STS_ERROR ;
434: FND_MSG_PUB.Count_And_Get
435: (p_count => x_msg_count,
436: p_data => x_msg_data,
437: p_encoded => fnd_api.g_false
438: );

Line 443: FND_MSG_PUB.Count_And_Get

439: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
440: ROLLBACK TO Create_RuleAttribute;
441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
442: x_loading_status := 'UNEXPECTED_ERR';
443: FND_MSG_PUB.Count_And_Get
444: (p_count => x_msg_count,
445: p_data => x_msg_data,
446: p_encoded => fnd_api.g_false
447: );

Line 452: IF FND_MSG_PUB.Check_Msg_Level

448: WHEN OTHERS THEN
449: ROLLBACK TO Create_RuleAttribute;
450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
451: x_loading_status := 'UNEXPECTED_ERR';
452: IF FND_MSG_PUB.Check_Msg_Level
453: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
454: THEN
455: FND_MSG_PUB.Add_Exc_Msg
456: (G_PKG_NAME,l_api_name);

Line 453: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

449: ROLLBACK TO Create_RuleAttribute;
450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
451: x_loading_status := 'UNEXPECTED_ERR';
452: IF FND_MSG_PUB.Check_Msg_Level
453: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
454: THEN
455: FND_MSG_PUB.Add_Exc_Msg
456: (G_PKG_NAME,l_api_name);
457: END IF;

Line 455: FND_MSG_PUB.Add_Exc_Msg

451: x_loading_status := 'UNEXPECTED_ERR';
452: IF FND_MSG_PUB.Check_Msg_Level
453: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
454: THEN
455: FND_MSG_PUB.Add_Exc_Msg
456: (G_PKG_NAME,l_api_name);
457: END IF;
458: FND_MSG_PUB.Count_And_Get
459: (p_count => x_msg_count,

Line 458: FND_MSG_PUB.Count_And_Get

454: THEN
455: FND_MSG_PUB.Add_Exc_Msg
456: (G_PKG_NAME,l_api_name);
457: END IF;
458: FND_MSG_PUB.Count_And_Get
459: (p_count => x_msg_count,
460: p_data => x_msg_data,
461: p_encoded => fnd_api.g_false
462: );

Line 569: FND_MSG_PUB.initialize;

565:
566: -- Initialize message list if p_init_msg_list is set to TRUE.
567: IF FND_API.to_Boolean( p_init_msg_list )
568: THEN
569: FND_MSG_PUB.initialize;
570: END IF;
571:
572: -- Initialize API return status to success
573: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

780:
781: IF l_count <> 1
782: THEN
783: --Error condition
784: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
785: THEN
786: fnd_message.set_name('CN', 'CN_INVALID_RULESET');
787: fnd_msg_pub.add;
788: END IF;

Line 787: fnd_msg_pub.add;

783: --Error condition
784: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
785: THEN
786: fnd_message.set_name('CN', 'CN_INVALID_RULESET');
787: fnd_msg_pub.add;
788: END IF;
789: x_loading_status := 'CN_INVALID_RULESET';
790: RAISE FND_API.G_EXC_ERROR;
791: ELSE

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

808:
809: IF l_count <> 1
810: THEN
811: --Error condition
812: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
813: THEN
814: fnd_message.set_name('CN', 'CN_INVALID_RULESET');
815: fnd_msg_pub.add;
816: END IF;

Line 815: fnd_msg_pub.add;

811: --Error condition
812: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
813: THEN
814: fnd_message.set_name('CN', 'CN_INVALID_RULESET');
815: fnd_msg_pub.add;
816: END IF;
817: x_loading_status := 'CN_INVALID_RULESET';
818: RAISE FND_API.G_EXC_ERROR;
819: ELSE

Line 1030: FND_MSG_PUB.Count_And_Get

1026: COMMIT WORK;
1027: END IF;
1028:
1029: -- Standard call to get message count and if count is 1, get message info.
1030: FND_MSG_PUB.Count_And_Get
1031: (p_count => x_msg_count,
1032: p_data => x_msg_data
1033: );
1034: EXCEPTION

Line 1038: FND_MSG_PUB.Count_And_Get

1034: EXCEPTION
1035: WHEN FND_API.G_EXC_ERROR THEN
1036: ROLLBACK TO Update_RuleAttribute;
1037: x_return_status := FND_API.G_RET_STS_ERROR ;
1038: FND_MSG_PUB.Count_And_Get
1039: (p_count => x_msg_count,
1040: p_data => x_msg_data,
1041: p_encoded => fnd_api.g_false
1042: );

Line 1047: FND_MSG_PUB.Count_And_Get

1043: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1044: ROLLBACK TO Update_RuleAttribute;
1045: x_loading_status := 'UNEXPECTED_ERR';
1046: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1047: FND_MSG_PUB.Count_And_Get
1048: (p_count => x_msg_count,
1049: p_data => x_msg_data,
1050: p_encoded => fnd_api.g_false
1051: );

Line 1056: IF FND_MSG_PUB.Check_Msg_Level

1052: WHEN OTHERS THEN
1053: ROLLBACK TO Update_RuleAttribute;
1054: x_loading_status := 'UNEXPECTED_ERR';
1055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1056: IF FND_MSG_PUB.Check_Msg_Level
1057: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1058: THEN
1059: FND_MSG_PUB.Add_Exc_Msg
1060: (G_PKG_NAME,

Line 1057: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1053: ROLLBACK TO Update_RuleAttribute;
1054: x_loading_status := 'UNEXPECTED_ERR';
1055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1056: IF FND_MSG_PUB.Check_Msg_Level
1057: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1058: THEN
1059: FND_MSG_PUB.Add_Exc_Msg
1060: (G_PKG_NAME,
1061: l_api_name

Line 1059: FND_MSG_PUB.Add_Exc_Msg

1055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1056: IF FND_MSG_PUB.Check_Msg_Level
1057: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1058: THEN
1059: FND_MSG_PUB.Add_Exc_Msg
1060: (G_PKG_NAME,
1061: l_api_name
1062: );
1063: END IF;

Line 1064: FND_MSG_PUB.Count_And_Get

1060: (G_PKG_NAME,
1061: l_api_name
1062: );
1063: END IF;
1064: FND_MSG_PUB.Count_And_Get
1065: (p_count => x_msg_count,
1066: p_data => x_msg_data,
1067: p_encoded => fnd_api.g_false
1068: );

Line 1172: FND_MSG_PUB.initialize;

1168:
1169: -- Initialize message list if p_init_msg_list is set to TRUE.
1170: IF FND_API.to_Boolean( p_init_msg_list )
1171: THEN
1172: FND_MSG_PUB.initialize;
1173: END IF;
1174:
1175: -- Initialize API return status to success
1176: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1316:
1317: IF l_count <> 1
1318: THEN
1319: --Error condition
1320: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1321: THEN
1322: fnd_message.set_name('CN', 'CN_INVALID_RULESET');
1323: fnd_msg_pub.add;
1324: END IF;

Line 1323: fnd_msg_pub.add;

1319: --Error condition
1320: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1321: THEN
1322: fnd_message.set_name('CN', 'CN_INVALID_RULESET');
1323: fnd_msg_pub.add;
1324: END IF;
1325: x_loading_status := 'CN_INVALID_RULESET';
1326: RAISE FND_API.G_EXC_ERROR;
1327: ELSE

Line 1518: FND_MSG_PUB.Count_And_Get

1514: COMMIT WORK;
1515: END IF;
1516:
1517: -- Standard call to get message count and if count is 1, get message info.
1518: FND_MSG_PUB.Count_And_Get
1519: (p_count => x_msg_count,
1520: p_data => x_msg_data
1521: );
1522: EXCEPTION

Line 1526: FND_MSG_PUB.Count_And_Get

1522: EXCEPTION
1523: WHEN FND_API.G_EXC_ERROR THEN
1524: ROLLBACK TO Delete_RuleAttribute;
1525: x_return_status := FND_API.G_RET_STS_ERROR ;
1526: FND_MSG_PUB.Count_And_Get
1527: (p_count => x_msg_count,
1528: p_data => x_msg_data
1529: );
1530: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1534: FND_MSG_PUB.Count_And_Get

1530: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1531: ROLLBACK TO Delete_RuleAttribute;
1532: x_loading_status := 'UNEXPECTED_ERR';
1533: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1534: FND_MSG_PUB.Count_And_Get
1535: (p_count => x_msg_count,
1536: p_data => x_msg_data,
1537: p_encoded => fnd_api.g_false
1538: );

Line 1543: IF FND_MSG_PUB.Check_Msg_Level

1539: WHEN OTHERS THEN
1540: ROLLBACK TO Delete_RuleAttribute;
1541: x_loading_status := 'UNEXPECTED_ERR';
1542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1543: IF FND_MSG_PUB.Check_Msg_Level
1544: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1545: THEN
1546: FND_MSG_PUB.Add_Exc_Msg
1547: (G_PKG_NAME,

Line 1544: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1540: ROLLBACK TO Delete_RuleAttribute;
1541: x_loading_status := 'UNEXPECTED_ERR';
1542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1543: IF FND_MSG_PUB.Check_Msg_Level
1544: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1545: THEN
1546: FND_MSG_PUB.Add_Exc_Msg
1547: (G_PKG_NAME,
1548: l_api_name

Line 1546: FND_MSG_PUB.Add_Exc_Msg

1542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1543: IF FND_MSG_PUB.Check_Msg_Level
1544: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1545: THEN
1546: FND_MSG_PUB.Add_Exc_Msg
1547: (G_PKG_NAME,
1548: l_api_name
1549: );
1550: END IF;

Line 1551: FND_MSG_PUB.Count_And_Get

1547: (G_PKG_NAME,
1548: l_api_name
1549: );
1550: END IF;
1551: FND_MSG_PUB.Count_And_Get
1552: (p_count => x_msg_count,
1553: p_data => x_msg_data,
1554: p_encoded => fnd_api.g_false
1555: );