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

Line 175: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

171: x_loading_status := 'CN_SALESREP_NOT_FOUND';
172: IF (p_show_message = FND_API.G_TRUE) THEN
173: -- Error, check the msg level and add an error message to the
174: -- API message list
175: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
176: THEN
177: FND_MESSAGE.SET_NAME ('CN', 'CN_SALESREP_NOT_FOUND');
178: FND_MSG_PUB.Add;
179: END IF;

Line 178: FND_MSG_PUB.Add;

174: -- API message list
175: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
176: THEN
177: FND_MESSAGE.SET_NAME ('CN', 'CN_SALESREP_NOT_FOUND');
178: FND_MSG_PUB.Add;
179: END IF;
180: END IF;
181: WHEN too_many_rows THEN
182: x_salesrep_id := NULL;

Line 188: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

184: x_loading_status := 'CN_SALESREP_TOO_MANY_ROWS';
185: IF (p_show_message = FND_API.G_TRUE) THEN
186: -- Error, check the msg level and add an error message to the
187: -- API message list
188: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
189: THEN
190: FND_MESSAGE.SET_NAME ('CN', 'CN_SALESREP_TOO_MANY_ROWS');
191: FND_MSG_PUB.Add;
192: END IF;

Line 191: FND_MSG_PUB.Add;

187: -- API message list
188: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
189: THEN
190: FND_MESSAGE.SET_NAME ('CN', 'CN_SALESREP_TOO_MANY_ROWS');
191: FND_MSG_PUB.Add;
192: END IF;
193: END IF;
194: END chk_and_get_salesrep_id;
195:

Line 264: FND_MSG_PUB.initialize;

260: --
261: -- Initialize message list if p_init_msg_list is set to TRUE.
262: --
263: IF FND_API.to_Boolean( p_init_msg_list ) THEN
264: FND_MSG_PUB.initialize;
265: END IF;
266:
267:
268: --

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

321: IF get_pay_group_id_cur%ROWCOUNT <> 1
322: THEN
323:
324: --Error condition
325: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
326: THEN
327: fnd_message.set_name('CN', 'CN_INVALID_PAY_GROUP');
328: fnd_message.set_token('PAY_GROUP_NAME', l_paygroup_assign_rec.pay_group_name);
329: fnd_msg_pub.add;

Line 329: fnd_msg_pub.add;

325: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
326: THEN
327: fnd_message.set_name('CN', 'CN_INVALID_PAY_GROUP');
328: fnd_message.set_token('PAY_GROUP_NAME', l_paygroup_assign_rec.pay_group_name);
329: fnd_msg_pub.add;
330: END IF;
331:
332: x_loading_status := 'CN_INVALID_PAY_GROUP';
333: CLOSE get_pay_group_id_cur;

Line 602: FND_MSG_PUB.Count_And_Get

598: --
599: -- Standard call to get message count and if count is 1, get message info.
600: --
601:
602: FND_MSG_PUB.Count_And_Get
603: (
604: p_count => x_msg_count ,
605: p_data => x_msg_data ,
606: p_encoded => FND_API.G_FALSE

Line 613: FND_MSG_PUB.Count_And_Get

609: EXCEPTION
610: WHEN FND_API.G_EXC_ERROR THEN
611: ROLLBACK TO Assign_salesreps;
612: x_return_status := FND_API.G_RET_STS_ERROR ;
613: FND_MSG_PUB.Count_And_Get
614: (
615: p_count => x_msg_count ,
616: p_data => x_msg_data ,
617: p_encoded => FND_API.G_FALSE

Line 623: FND_MSG_PUB.Count_And_Get

619: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
620: ROLLBACK TO Assign_salesreps;
621: x_loading_status := 'UNEXPECTED_ERR';
622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
623: FND_MSG_PUB.Count_And_Get
624: (
625: p_count => x_msg_count ,
626: p_data => x_msg_data ,
627: p_encoded => FND_API.G_FALSE

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

629: WHEN OTHERS THEN
630: ROLLBACK TO Assign_salesreps;
631: x_loading_status := 'UNEXPECTED_ERR';
632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
633: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
634: THEN
635: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
636: END IF;
637: FND_MSG_PUB.Count_And_Get

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

631: x_loading_status := 'UNEXPECTED_ERR';
632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
633: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
634: THEN
635: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
636: END IF;
637: FND_MSG_PUB.Count_And_Get
638: (
639: p_count => x_msg_count ,

Line 637: FND_MSG_PUB.Count_And_Get

633: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
634: THEN
635: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
636: END IF;
637: FND_MSG_PUB.Count_And_Get
638: (
639: p_count => x_msg_count ,
640: p_data => x_msg_data ,
641: p_encoded => FND_API.G_FALSE

Line 732: FND_MSG_PUB.initialize;

728: --
729: -- Initialize message list if p_init_msg_list is set to TRUE.
730: --
731: IF FND_API.to_Boolean( p_init_msg_list ) THEN
732: FND_MSG_PUB.initialize;
733: END IF;
734:
735:
736: --

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

764: 'cn.plsql.cn_srp_paygroup_pub.update_srp_assignment.error',
765: true);
766: end if;
767:
768: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
769: FND_MESSAGE.SET_NAME ('FND' , 'FND_MO_OU_CANNOT_UPDATE');
770: FND_MSG_PUB.Add;
771: END IF;
772:

Line 770: FND_MSG_PUB.Add;

766: end if;
767:
768: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
769: FND_MESSAGE.SET_NAME ('FND' , 'FND_MO_OU_CANNOT_UPDATE');
770: FND_MSG_PUB.Add;
771: END IF;
772:
773: RAISE FND_API.G_EXC_ERROR ;
774: end if;

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

809: IF get_pay_group_id_cur%ROWCOUNT <> 1
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_PAY_GROUP');
816: fnd_message.set_token('PAY_GROUP_NAME',
817: l_old_paygroup_assign_rec.pay_group_name);

Line 818: fnd_msg_pub.add;

814: THEN
815: fnd_message.set_name('CN', 'CN_INVALID_PAY_GROUP');
816: fnd_message.set_token('PAY_GROUP_NAME',
817: l_old_paygroup_assign_rec.pay_group_name);
818: fnd_msg_pub.add;
819: END IF;
820:
821: x_loading_status := 'CN_INVALID_PAY_GROUP';
822: CLOSE get_pay_group_id_cur;

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

861: IF get_pay_group_id_cur%ROWCOUNT <> 1
862: THEN
863:
864: --Error condition
865: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
866: THEN
867: fnd_message.set_name('CN', 'CN_INVALID_PAY_GROUP');
868: fnd_message.set_token('PAY_GROUP_NAME', l_paygroup_assign_rec.pay_group_name);
869: fnd_msg_pub.add;

Line 869: fnd_msg_pub.add;

865: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
866: THEN
867: fnd_message.set_name('CN', 'CN_INVALID_PAY_GROUP');
868: fnd_message.set_token('PAY_GROUP_NAME', l_paygroup_assign_rec.pay_group_name);
869: fnd_msg_pub.add;
870: END IF;
871:
872: x_loading_status := 'CN_INVALID_PAY_GROUP';
873: CLOSE get_pay_group_id_cur;

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

982: FETCH get_srp_pay_group_id_cur INTO l_srp_pay_group_id;
983:
984: IF get_srp_pay_group_id_cur%rowcount = 0
985: THEN
986: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
987: THEN
988: fnd_message.set_name('CN', 'CN_INVALID_SRP_PGRP_ASGN');
989: fnd_message.set_token('EMPLOYEE_TYPE',
990: l_old_paygroup_assign_rec.employee_type);

Line 993: fnd_msg_pub.add;

989: fnd_message.set_token('EMPLOYEE_TYPE',
990: l_old_paygroup_assign_rec.employee_type);
991: fnd_message.set_token('EMPLOYEE_NUMBER',
992: l_old_paygroup_assign_rec.employee_number);
993: fnd_msg_pub.add;
994: END IF;
995: x_loading_status := 'CN_INVALID_SRP_PGRP_ASGN';
996: CLOSE get_srp_pay_group_id_cur;
997: RAISE FND_API.G_EXC_ERROR;

Line 1216: FND_MSG_PUB.Count_And_Get

1212: --
1213: -- Standard call to get message count and if count is 1, get message info.
1214: --
1215:
1216: FND_MSG_PUB.Count_And_Get
1217: (
1218: p_count => x_msg_count ,
1219: p_data => x_msg_data ,
1220: p_encoded => FND_API.G_FALSE

Line 1227: FND_MSG_PUB.Count_And_Get

1223: EXCEPTION
1224: WHEN FND_API.G_EXC_ERROR THEN
1225: ROLLBACK TO update_srp_assignment;
1226: x_return_status := FND_API.G_RET_STS_ERROR ;
1227: FND_MSG_PUB.Count_And_Get
1228: (
1229: p_count => x_msg_count ,
1230: p_data => x_msg_data ,
1231: p_encoded => FND_API.G_FALSE

Line 1237: FND_MSG_PUB.Count_And_Get

1233: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1234: ROLLBACK TO update_srp_assignment;
1235: x_loading_status := 'UNEXPECTED_ERR';
1236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1237: FND_MSG_PUB.Count_And_Get
1238: (
1239: p_count => x_msg_count ,
1240: p_data => x_msg_data ,
1241: p_encoded => FND_API.G_FALSE

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

1243: WHEN OTHERS THEN
1244: ROLLBACK TO update_srp_assignment;
1245: x_loading_status := 'UNEXPECTED_ERR';
1246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1247: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1248: THEN
1249: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1250: END IF;
1251: FND_MSG_PUB.Count_And_Get

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

1245: x_loading_status := 'UNEXPECTED_ERR';
1246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1247: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1248: THEN
1249: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1250: END IF;
1251: FND_MSG_PUB.Count_And_Get
1252: (
1253: p_count => x_msg_count ,

Line 1251: FND_MSG_PUB.Count_And_Get

1247: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1248: THEN
1249: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1250: END IF;
1251: FND_MSG_PUB.Count_And_Get
1252: (
1253: p_count => x_msg_count ,
1254: p_data => x_msg_data ,
1255: p_encoded => FND_API.G_FALSE

Line 1316: FND_MSG_PUB.initialize;

1312: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1313: END IF;
1314: -- Initialize message list if p_init_msg_list is set to TRUE.
1315: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1316: FND_MSG_PUB.initialize;
1317: END IF;
1318: -- Initialize API return status to success
1319: x_return_status := FND_API.G_RET_STS_SUCCESS;
1320: x_loading_status := 'CN_INSERTED';

Line 1418: FND_MSG_PUB.Count_And_Get

1414: IF FND_API.To_Boolean( p_commit ) THEN
1415: COMMIT WORK;
1416: END IF;
1417: -- Standard call to get message count and if count is 1, get message info.
1418: FND_MSG_PUB.Count_And_Get
1419: (
1420: p_count => x_msg_count ,
1421: p_data => x_msg_data ,
1422: p_encoded => FND_API.G_FALSE

Line 1428: FND_MSG_PUB.Count_And_Get

1424: EXCEPTION
1425: WHEN FND_API.G_EXC_ERROR THEN
1426: ROLLBACK TO Create_Mass_Asgn_Srp_Pay;
1427: x_return_status := FND_API.G_RET_STS_ERROR ;
1428: FND_MSG_PUB.Count_And_Get
1429: (
1430: p_count => x_msg_count ,
1431: p_data => x_msg_data ,
1432: p_encoded => FND_API.G_FALSE

Line 1438: FND_MSG_PUB.Count_And_Get

1434: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1435: ROLLBACK TO Create_Mass_Asgn_Srp_Pay;
1436: x_loading_status := 'UNEXPECTED_ERR';
1437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1438: FND_MSG_PUB.Count_And_Get
1439: (
1440: p_count => x_msg_count ,
1441: p_data => x_msg_data ,
1442: p_encoded => FND_API.G_FALSE

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

1444: WHEN OTHERS THEN
1445: ROLLBACK TO Create_Mass_Asgn_Srp_Pay;
1446: x_loading_status := 'UNEXPECTED_ERR';
1447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1448: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1449: THEN
1450: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1451: END IF;
1452: FND_MSG_PUB.Count_And_Get

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

1446: x_loading_status := 'UNEXPECTED_ERR';
1447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1448: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1449: THEN
1450: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1451: END IF;
1452: FND_MSG_PUB.Count_And_Get
1453: (
1454: p_count => x_msg_count ,

Line 1452: FND_MSG_PUB.Count_And_Get

1448: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1449: THEN
1450: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1451: END IF;
1452: FND_MSG_PUB.Count_And_Get
1453: (
1454: p_count => x_msg_count ,
1455: p_data => x_msg_data ,
1456: p_encoded => FND_API.G_FALSE

Line 1555: FND_MSG_PUB.initialize;

1551: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1552: END IF;
1553: -- Initialize message list if p_init_msg_list is set to TRUE.
1554: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1555: FND_MSG_PUB.initialize;
1556: END IF;
1557: -- Initialize API return status to success
1558: x_return_status := FND_API.G_RET_STS_SUCCESS;
1559: x_loading_status := 'CN_UPDATED';

Line 1801: FND_MSG_PUB.Count_And_Get

1797: IF FND_API.To_Boolean( p_commit ) THEN
1798: COMMIT WORK;
1799: END IF;
1800: -- Standard call to get message count and if count is 1, get message info.
1801: FND_MSG_PUB.Count_And_Get
1802: (
1803: p_count => x_msg_count ,
1804: p_data => x_msg_data ,
1805: p_encoded => FND_API.G_FALSE

Line 1812: FND_MSG_PUB.Count_And_Get

1808: EXCEPTION
1809: WHEN FND_API.G_EXC_ERROR THEN
1810: ROLLBACK TO Update_Mass_Asgn_Srp_Pay;
1811: x_return_status := FND_API.G_RET_STS_ERROR ;
1812: FND_MSG_PUB.Count_And_Get
1813: (
1814: p_count => x_msg_count ,
1815: p_data => x_msg_data ,
1816: p_encoded => FND_API.G_FALSE

Line 1822: FND_MSG_PUB.Count_And_Get

1818: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1819: ROLLBACK TO Update_Mass_Asgn_Srp_Pay;
1820: x_loading_status := 'UNEXPECTED_ERR';
1821: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1822: FND_MSG_PUB.Count_And_Get
1823: (
1824: p_count => x_msg_count ,
1825: p_data => x_msg_data ,
1826: p_encoded => FND_API.G_FALSE

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

1828: WHEN OTHERS THEN
1829: ROLLBACK TO Update_Mass_Asgn_Srp_Pay;
1830: x_loading_status := 'UNEXPECTED_ERR';
1831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1832: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1833: THEN
1834: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1835: END IF;
1836: FND_MSG_PUB.Count_And_Get

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

1830: x_loading_status := 'UNEXPECTED_ERR';
1831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1832: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1833: THEN
1834: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1835: END IF;
1836: FND_MSG_PUB.Count_And_Get
1837: (
1838: p_count => x_msg_count ,

Line 1836: FND_MSG_PUB.Count_And_Get

1832: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1833: THEN
1834: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1835: END IF;
1836: FND_MSG_PUB.Count_And_Get
1837: (
1838: p_count => x_msg_count ,
1839: p_data => x_msg_data ,
1840: p_encoded => FND_API.G_FALSE