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 1315: FND_MSG_PUB.initialize;

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

Line 1416: FND_MSG_PUB.Count_And_Get

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

Line 1426: FND_MSG_PUB.Count_And_Get

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

Line 1436: FND_MSG_PUB.Count_And_Get

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

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

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

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

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

Line 1450: FND_MSG_PUB.Count_And_Get

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

Line 1551: FND_MSG_PUB.initialize;

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

Line 1793: FND_MSG_PUB.Count_And_Get

1789: IF FND_API.To_Boolean( p_commit ) THEN
1790: COMMIT WORK;
1791: END IF;
1792: -- Standard call to get message count and if count is 1, get message info.
1793: FND_MSG_PUB.Count_And_Get
1794: (
1795: p_count => x_msg_count ,
1796: p_data => x_msg_data ,
1797: p_encoded => FND_API.G_FALSE

Line 1804: FND_MSG_PUB.Count_And_Get

1800: EXCEPTION
1801: WHEN FND_API.G_EXC_ERROR THEN
1802: ROLLBACK TO Update_Mass_Asgn_Srp_Pay;
1803: x_return_status := FND_API.G_RET_STS_ERROR ;
1804: FND_MSG_PUB.Count_And_Get
1805: (
1806: p_count => x_msg_count ,
1807: p_data => x_msg_data ,
1808: p_encoded => FND_API.G_FALSE

Line 1814: FND_MSG_PUB.Count_And_Get

1810: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1811: ROLLBACK TO Update_Mass_Asgn_Srp_Pay;
1812: x_loading_status := 'UNEXPECTED_ERR';
1813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1814: FND_MSG_PUB.Count_And_Get
1815: (
1816: p_count => x_msg_count ,
1817: p_data => x_msg_data ,
1818: p_encoded => FND_API.G_FALSE

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

1820: WHEN OTHERS THEN
1821: ROLLBACK TO Update_Mass_Asgn_Srp_Pay;
1822: x_loading_status := 'UNEXPECTED_ERR';
1823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1824: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1825: THEN
1826: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1827: END IF;
1828: FND_MSG_PUB.Count_And_Get

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

1822: x_loading_status := 'UNEXPECTED_ERR';
1823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1824: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1825: THEN
1826: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1827: END IF;
1828: FND_MSG_PUB.Count_And_Get
1829: (
1830: p_count => x_msg_count ,

Line 1828: FND_MSG_PUB.Count_And_Get

1824: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1825: THEN
1826: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1827: END IF;
1828: FND_MSG_PUB.Count_And_Get
1829: (
1830: p_count => x_msg_count ,
1831: p_data => x_msg_data ,
1832: p_encoded => FND_API.G_FALSE