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

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

63: WHERE name = p_srp_pmt_plans_rec.pmt_plan_name
64: AND org_id = p_srp_pmt_plans_rec.org_id;
65: EXCEPTION
66: WHEN NO_DATA_FOUND THEN
67: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
68: FND_MESSAGE.SET_NAME ('CN' , 'CN_PP_NOT_EXIST');
69: FND_MESSAGE.SET_TOKEN('PP_NAME',p_srp_pmt_plans_rec.pmt_plan_name);
70: FND_MSG_PUB.Add;
71: END IF;

Line 70: FND_MSG_PUB.Add;

66: WHEN NO_DATA_FOUND THEN
67: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
68: FND_MESSAGE.SET_NAME ('CN' , 'CN_PP_NOT_EXIST');
69: FND_MESSAGE.SET_TOKEN('PP_NAME',p_srp_pmt_plans_rec.pmt_plan_name);
70: FND_MSG_PUB.Add;
71: END IF;
72: x_loading_status := 'CN_PP_NOT_EXIST';
73: RAISE FND_API.G_EXC_ERROR ;
74: END;

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

93: WHERE salesrep_id = x_srp_pmt_plans_row.salesrep_id
94: AND org_id = x_srp_pmt_plans_row.org_id;
95: EXCEPTION
96: WHEN NO_DATA_FOUND THEN
97: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
98: FND_MESSAGE.SET_NAME ('CN' , 'CN_SRP_NOT_EXIST');
99: FND_MSG_PUB.Add;
100: END IF;
101: x_loading_status := 'CN_SRP_NOT_EXIST';

Line 99: FND_MSG_PUB.Add;

95: EXCEPTION
96: WHEN NO_DATA_FOUND THEN
97: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
98: FND_MESSAGE.SET_NAME ('CN' , 'CN_SRP_NOT_EXIST');
99: FND_MSG_PUB.Add;
100: END IF;
101: x_loading_status := 'CN_SRP_NOT_EXIST';
102: RAISE FND_API.G_EXC_ERROR ;
103: END;

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

127: x_loading_status := 'UNEXPECTED_ERR';
128: WHEN OTHERS THEN
129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
130: x_loading_status := 'UNEXPECTED_ERR';
131: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
132: THEN
133: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
134: END IF;
135: END chk_existence_get_id;

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

129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
130: x_loading_status := 'UNEXPECTED_ERR';
131: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
132: THEN
133: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
134: END IF;
135: END chk_existence_get_id;
136:
137: --| ----------------------------------------------------------------------+-+

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

202: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
203: RAISE FND_API.G_EXC_ERROR ;
204: ELSIF x_srp_pmt_plans_row.srp_pmt_plan_id IS NOT NULL AND
205: p_action <> 'UPDATE' THEN
206: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
207: FND_MESSAGE.Set_Name('CN', 'CN_SRP_PMT_PLAN_EXIST');
208: FND_MSG_PUB.Add;
209: END IF;
210: x_loading_status := 'CN_SRP_PMT_PLAN_EXIST';

Line 208: FND_MSG_PUB.Add;

204: ELSIF x_srp_pmt_plans_row.srp_pmt_plan_id IS NOT NULL AND
205: p_action <> 'UPDATE' THEN
206: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
207: FND_MESSAGE.Set_Name('CN', 'CN_SRP_PMT_PLAN_EXIST');
208: FND_MSG_PUB.Add;
209: END IF;
210: x_loading_status := 'CN_SRP_PMT_PLAN_EXIST';
211: RAISE FND_API.G_EXC_ERROR ;
212: END IF;

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

250: x_loading_status := 'UNEXPECTED_ERR';
251: WHEN OTHERS THEN
252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
253: x_loading_status := 'UNEXPECTED_ERR';
254: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
255: THEN
256: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
257: END IF;
258: END valid_pp_assign;

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

252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
253: x_loading_status := 'UNEXPECTED_ERR';
254: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
255: THEN
256: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
257: END IF;
258: END valid_pp_assign;
259:
260: --| ----------------------------------------------------------------------+-+

Line 308: FND_MSG_PUB.initialize;

304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
305: END IF;
306: -- Initialize message list if p_init_msg_list is set to TRUE.
307: IF FND_API.to_Boolean( p_init_msg_list ) THEN
308: FND_MSG_PUB.initialize;
309: END IF;
310: -- Initialize API return status to success
311: x_return_status := FND_API.G_RET_STS_SUCCESS;
312: x_loading_status := 'CN_INSERTED';

Line 575: FND_MSG_PUB.Count_And_Get

571: IF FND_API.To_Boolean( p_commit ) THEN
572: COMMIT WORK;
573: END IF;
574: -- Standard call to get message count and if count is 1, get message info.
575: FND_MSG_PUB.Count_And_Get
576: (
577: p_count => x_msg_count ,
578: p_data => x_msg_data ,
579: p_encoded => FND_API.G_FALSE

Line 586: FND_MSG_PUB.Count_And_Get

582: EXCEPTION
583: WHEN FND_API.G_EXC_ERROR THEN
584: ROLLBACK TO Create_Srp_Pmt_Plan ;
585: x_return_status := FND_API.G_RET_STS_ERROR ;
586: FND_MSG_PUB.Count_And_Get
587: (
588: p_count => x_msg_count ,
589: p_data => x_msg_data ,
590: p_encoded => FND_API.G_FALSE

Line 597: FND_MSG_PUB.Count_And_Get

593: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
594: ROLLBACK TO Create_Srp_Pmt_Plan;
595: x_loading_status := 'UNEXPECTED_ERR';
596: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
597: FND_MSG_PUB.Count_And_Get
598: (
599: p_count => x_msg_count ,
600: p_data => x_msg_data ,
601: p_encoded => FND_API.G_FALSE

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

603: WHEN OTHERS THEN
604: ROLLBACK TO Create_Srp_Pmt_Plan;
605: x_loading_status := 'UNEXPECTED_ERR';
606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
607: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
608: THEN
609: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
610: END IF;
611: FND_MSG_PUB.Count_And_Get

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

605: x_loading_status := 'UNEXPECTED_ERR';
606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
607: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
608: THEN
609: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
610: END IF;
611: FND_MSG_PUB.Count_And_Get
612: (
613: p_count => x_msg_count ,

Line 611: FND_MSG_PUB.Count_And_Get

607: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
608: THEN
609: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
610: END IF;
611: FND_MSG_PUB.Count_And_Get
612: (
613: p_count => x_msg_count ,
614: p_data => x_msg_data ,
615: p_encoded => FND_API.G_FALSE

Line 678: FND_MSG_PUB.initialize;

674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
675: END IF;
676: -- Initialize message list if p_init_msg_list is set to TRUE.
677: IF FND_API.to_Boolean( p_init_msg_list ) THEN
678: FND_MSG_PUB.initialize;
679: END IF;
680: -- Initialize API return status to success
681: x_return_status := FND_API.G_RET_STS_SUCCESS;
682: x_loading_status := 'CN_UPDATED';

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

697: 'cn.plsql.cn_srp_pmt_plans_pub.update_srp_pmt_plan.error',
698: true);
699: end if;
700:
701: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
702: FND_MESSAGE.SET_NAME ('FND' , 'FND_MO_OU_CANNOT_UPDATE');
703: FND_MSG_PUB.Add;
704: END IF;
705:

Line 703: FND_MSG_PUB.Add;

699: end if;
700:
701: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
702: FND_MESSAGE.SET_NAME ('FND' , 'FND_MO_OU_CANNOT_UPDATE');
703: FND_MSG_PUB.Add;
704: END IF;
705:
706: RAISE FND_API.G_EXC_ERROR ;
707: end if;

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

751: );
752: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
753: RAISE FND_API.G_EXC_ERROR ;
754: ELSIF l_old_spp_row.srp_pmt_plan_id IS NULL THEN
755: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
756: FND_MESSAGE.Set_Name('CN', 'CN_SRP_PMT_PLAN_NOT_EXIST');
757: FND_MSG_PUB.Add;
758: END IF;
759: x_loading_status := 'CN_SRP_PMT_PLAN_NOT_EXIST';

Line 757: FND_MSG_PUB.Add;

753: RAISE FND_API.G_EXC_ERROR ;
754: ELSIF l_old_spp_row.srp_pmt_plan_id IS NULL THEN
755: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
756: FND_MESSAGE.Set_Name('CN', 'CN_SRP_PMT_PLAN_NOT_EXIST');
757: FND_MSG_PUB.Add;
758: END IF;
759: x_loading_status := 'CN_SRP_PMT_PLAN_NOT_EXIST';
760: RAISE FND_API.G_EXC_ERROR ;
761: END IF;

Line 1008: FND_MSG_PUB.Count_And_Get

1004: IF FND_API.To_Boolean( p_commit ) THEN
1005: COMMIT WORK;
1006: END IF;
1007: -- Standard call to get message count and if count is 1, get message info.
1008: FND_MSG_PUB.Count_And_Get
1009: (
1010: p_count => x_msg_count ,
1011: p_data => x_msg_data ,
1012: p_encoded => FND_API.G_FALSE

Line 1019: FND_MSG_PUB.Count_And_Get

1015: EXCEPTION
1016: WHEN FND_API.G_EXC_ERROR THEN
1017: ROLLBACK TO Update_Srp_Pmt_Plan ;
1018: x_return_status := FND_API.G_RET_STS_ERROR ;
1019: FND_MSG_PUB.Count_And_Get
1020: (
1021: p_count => x_msg_count ,
1022: p_data => x_msg_data ,
1023: p_encoded => FND_API.G_FALSE

Line 1029: FND_MSG_PUB.Count_And_Get

1025: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1026: ROLLBACK TO Update_Srp_Pmt_Plan;
1027: x_loading_status := 'UNEXPECTED_ERR';
1028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1029: FND_MSG_PUB.Count_And_Get
1030: (
1031: p_count => x_msg_count ,
1032: p_data => x_msg_data ,
1033: p_encoded => FND_API.G_FALSE

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

1035: WHEN OTHERS THEN
1036: ROLLBACK TO Update_Srp_Pmt_Plan;
1037: x_loading_status := 'UNEXPECTED_ERR';
1038: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1039: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1040: THEN
1041: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1042: END IF;
1043: FND_MSG_PUB.Count_And_Get

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

1037: x_loading_status := 'UNEXPECTED_ERR';
1038: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1039: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1040: THEN
1041: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1042: END IF;
1043: FND_MSG_PUB.Count_And_Get
1044: (
1045: p_count => x_msg_count ,

Line 1043: FND_MSG_PUB.Count_And_Get

1039: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1040: THEN
1041: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1042: END IF;
1043: FND_MSG_PUB.Count_And_Get
1044: (
1045: p_count => x_msg_count ,
1046: p_data => x_msg_data ,
1047: p_encoded => FND_API.G_FALSE

Line 1101: FND_MSG_PUB.initialize;

1097: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1098: END IF;
1099: -- Initialize message list if p_init_msg_list is set to TRUE.
1100: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1101: FND_MSG_PUB.initialize;
1102: END IF;
1103: -- Initialize API return status to success
1104: x_return_status := FND_API.G_RET_STS_SUCCESS;
1105: x_loading_status := 'CN_DELETED';

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

1157: );
1158: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1159: RAISE FND_API.G_EXC_ERROR ;
1160: ELSIF l_spp_row.srp_pmt_plan_id IS NULL THEN
1161: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1162: FND_MESSAGE.Set_Name('CN', 'CN_SRP_PMT_PLAN_NOT_EXIST');
1163: FND_MSG_PUB.Add;
1164: END IF;
1165: x_loading_status := 'CN_SRP_PMT_PLAN_NOT_EXIST';

Line 1163: FND_MSG_PUB.Add;

1159: RAISE FND_API.G_EXC_ERROR ;
1160: ELSIF l_spp_row.srp_pmt_plan_id IS NULL THEN
1161: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1162: FND_MESSAGE.Set_Name('CN', 'CN_SRP_PMT_PLAN_NOT_EXIST');
1163: FND_MSG_PUB.Add;
1164: END IF;
1165: x_loading_status := 'CN_SRP_PMT_PLAN_NOT_EXIST';
1166: RAISE FND_API.G_EXC_ERROR ;
1167: END IF;

Line 1350: FND_MSG_PUB.Count_And_Get

1346: IF FND_API.To_Boolean( p_commit ) THEN
1347: COMMIT WORK;
1348: END IF;
1349: -- Standard call to get message count and if count is 1, get message info.
1350: FND_MSG_PUB.Count_And_Get
1351: (
1352: p_count => x_msg_count ,
1353: p_data => x_msg_data ,
1354: p_encoded => FND_API.G_FALSE

Line 1361: FND_MSG_PUB.Count_And_Get

1357: EXCEPTION
1358: WHEN FND_API.G_EXC_ERROR THEN
1359: ROLLBACK TO Delete_Srp_Pmt_Plan ;
1360: x_return_status := FND_API.G_RET_STS_ERROR ;
1361: FND_MSG_PUB.Count_And_Get
1362: (
1363: p_count => x_msg_count ,
1364: p_data => x_msg_data ,
1365: p_encoded => FND_API.G_FALSE

Line 1371: FND_MSG_PUB.Count_And_Get

1367: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1368: ROLLBACK TO Delete_Srp_Pmt_Plan;
1369: x_loading_status := 'UNEXPECTED_ERR';
1370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1371: FND_MSG_PUB.Count_And_Get
1372: (
1373: p_count => x_msg_count ,
1374: p_data => x_msg_data ,
1375: p_encoded => FND_API.G_FALSE

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

1377: WHEN OTHERS THEN
1378: ROLLBACK TO Delete_Srp_Pmt_Plan;
1379: x_loading_status := 'UNEXPECTED_ERR';
1380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1381: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1382: THEN
1383: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1384: END IF;
1385: FND_MSG_PUB.Count_And_Get

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

1379: x_loading_status := 'UNEXPECTED_ERR';
1380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1381: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1382: THEN
1383: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1384: END IF;
1385: FND_MSG_PUB.Count_And_Get
1386: (
1387: p_count => x_msg_count ,

Line 1385: FND_MSG_PUB.Count_And_Get

1381: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1382: THEN
1383: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1384: END IF;
1385: FND_MSG_PUB.Count_And_Get
1386: (
1387: p_count => x_msg_count ,
1388: p_data => x_msg_data ,
1389: p_encoded => FND_API.G_FALSE