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_PVT dependencies on FND_MESSAGE

Line 167: FND_MESSAGE.Set_Name('CN', 'CN_SRP_PMT_PLAN_EXIST');

163: (p_srp_pmt_plan_id IS NULL));
164:
165: IF l_dummy > 0 THEN
166: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
167: FND_MESSAGE.Set_Name('CN', 'CN_SRP_PMT_PLAN_EXIST');
168: FND_MSG_PUB.Add;
169: END IF;
170: x_loading_status := 'CN_SRP_PMT_PLAN_EXIST';
171: RAISE FND_API.G_EXC_ERROR ;

Line 186: FND_MESSAGE.SET_NAME('CN','SRP_MUST_ACTIVATE_REP');

182: AND org_id = p_org_id;
183:
184: IF l_srp_start_date IS NULL THEN
185: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
186: FND_MESSAGE.SET_NAME('CN','SRP_MUST_ACTIVATE_REP');
187: FND_MSG_PUB.Add;
188: END IF;
189: x_loading_status := 'SRP_MUST_ACTIVATE_REP';
190: RAISE FND_API.G_EXC_ERROR ;

Line 234: FND_MESSAGE.SET_NAME ('CN' , 'CN_SPP_PRDS_NI_SRP_PRDS');

230: ) -- end of IF
231:
232: THEN
233: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
234: FND_MESSAGE.SET_NAME ('CN' , 'CN_SPP_PRDS_NI_SRP_PRDS');
235: FND_MSG_PUB.Add;
236: END IF;
237: x_loading_status := 'CN_SPP_PRDS_NI_SRP_PRDS';
238: RAISE FND_API.G_EXC_ERROR ;

Line 274: FND_MESSAGE.SET_NAME ('CN' , 'CN_SPP_PRDS_NI_PMT_PRDS');

270:
271:
272: THEN
273: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
274: FND_MESSAGE.SET_NAME ('CN' , 'CN_SPP_PRDS_NI_PMT_PRDS');
275: FND_MSG_PUB.Add;
276: END IF;
277: x_loading_status := 'CN_SPP_PRDS_NI_PMT_PRDS';
278: RAISE FND_API.G_EXC_ERROR ;

Line 319: FND_MESSAGE.SET_NAME ('CN' , 'CN_SRP_PMT_PLAN_OVERLAPS');

315: AND cspp.pmt_plan_id = cpp.pmt_plan_id;
316:
317: IF l_dummy > 0 then
318: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
319: FND_MESSAGE.SET_NAME ('CN' , 'CN_SRP_PMT_PLAN_OVERLAPS');
320: FND_MSG_PUB.Add;
321: END IF;
322: x_loading_status := 'CN_SRP_PMT_PLAN_OVERLAPS';
323: RAISE FND_API.G_EXC_ERROR ;

Line 346: FND_MESSAGE.SET_NAME ('CN' , 'CN_SRPPP_CT_MISMATCH');

342:
343: IF l_dummy2 = 1 THEN
344: IF l_dummy = 0 THEN
345: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
346: FND_MESSAGE.SET_NAME ('CN' , 'CN_SRPPP_CT_MISMATCH');
347: FND_MSG_PUB.Add;
348: END IF;
349: x_loading_status := 'CN_SRPPP_CT_MISMATCH';
350: RAISE FND_API.G_EXC_ERROR;

Line 358: FND_MESSAGE.SET_NAME ('CN' , 'CN_SPP_MIN_MAX_NULL');

354:
355: -- either min amount or max amount needs to be populated
356: IF (p_minimum_amount IS NULL AND p_maximum_amount IS NULL) THEN
357: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
358: FND_MESSAGE.SET_NAME ('CN' , 'CN_SPP_MIN_MAX_NULL');
359: FND_MSG_PUB.Add;
360: END IF;
361: x_loading_status := 'CN_SPP_MIN_MAX_NULL';
362: RAISE FND_API.G_EXC_ERROR ;

Line 369: FND_MESSAGE.SET_NAME ('CN' , 'CN_SPP_MAX_LT_MIN');

365: -- Check Max amount must > Min amount
366: IF (p_maximum_amount < p_minimum_amount)
367: THEN
368: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
369: FND_MESSAGE.SET_NAME ('CN' , 'CN_SPP_MAX_LT_MIN');
370: FND_MSG_PUB.Add;
371: END IF;
372: x_loading_status := 'CN_SPP_MAX_LT_MIN';
373: RAISE FND_API.G_EXC_ERROR ;

Line 571: FND_MESSAGE.Set_Name('CN', 'CN_SRP_PP_NO_DEL');

567: CLOSE get_paid_del_payruns;
568:
569: IF paid_del_payruns_row.estatus = 'ERROR' then
570: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
571: FND_MESSAGE.Set_Name('CN', 'CN_SRP_PP_NO_DEL');
572: FND_MSG_PUB.Add;
573: END IF;
574: ELSE
575: OPEN get_adj_del_payruns;

Line 581: FND_MESSAGE.Set_Name('CN', 'CN_SRP_PP_NO_DEL_ADJ');

577: CLOSE get_adj_del_payruns;
578:
579: IF adj_del_payruns_row.estatus = 'ERROR' then
580: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
581: FND_MESSAGE.Set_Name('CN', 'CN_SRP_PP_NO_DEL_ADJ');
582: FND_MSG_PUB.Add;
583: END IF;
584: /* ELSE
585: -- With latest update this should never be called as even if unpaid paysheets

Line 607: FND_MESSAGE.Set_Name('CN', 'CN_SRP_PP_NO_UPD');

603: CLOSE get_paid_upd_payruns;
604:
605: IF paid_upd_payruns_row.estatus = 'ERROR' then
606: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
607: FND_MESSAGE.Set_Name('CN', 'CN_SRP_PP_NO_UPD');
608: FND_MSG_PUB.Add;
609: END IF;
610: ELSE
611: OPEN get_adj_upd_payruns;

Line 617: FND_MESSAGE.Set_Name('CN', 'CN_SRP_PP_NO_UPD');

613: CLOSE get_adj_upd_payruns;
614:
615: IF adj_upd_payruns_row.estatus = 'ERROR' then
616: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
617: FND_MESSAGE.Set_Name('CN', 'CN_SRP_PP_NO_UPD');
618: FND_MSG_PUB.Add;
619: END IF;
620: /* ELSE
621: -- With latest update this should never be called as even if unpaid paysheets

Line 696: FND_MESSAGE.SET_NAME ('CN' , 'CN_SRP_PMT_PLAN_USED');

692: );
693:
694: IF l_dummy > 0 then
695: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
696: FND_MESSAGE.SET_NAME ('CN' , 'CN_SRP_PMT_PLAN_USED');
697: FND_MSG_PUB.Add;
698: END IF;
699: x_loading_status := 'CN_SRP_PMT_PLAN_USED';
700: RAISE FND_API.G_EXC_ERROR ;

Line 736: FND_MESSAGE.SET_NAME ('CN' , 'CN_SPP_CANNOT_SHORTEN_ED');

732: );
733:
734: IF l_dummy > 0 THEN
735: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
736: FND_MESSAGE.SET_NAME ('CN' , 'CN_SPP_CANNOT_SHORTEN_ED');
737: FND_MSG_PUB.Add;
738: END IF;
739: x_loading_status := 'CN_SPP_CANNOT_SHORTEN_ED';
740: RAISE FND_API.G_EXC_ERROR ;

Line 766: FND_MESSAGE.SET_NAME ('CN' , 'CN_SPP_UPDATE_NOT_ALLOWED');

762: );
763: IF l_dummy > 0 THEN
764: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
765: THEN
766: FND_MESSAGE.SET_NAME ('CN' , 'CN_SPP_UPDATE_NOT_ALLOWED');
767: FND_MSG_PUB.Add;
768: END IF;
769: x_loading_status := 'CN_SPP_UPDATE_NOT_ALLOWED';
770: RAISE FND_API.G_EXC_ERROR ;

Line 802: fnd_message.set_name('CN', 'CN_SPP_UPD_NOTE');

798: x_msg IN OUT nocopy VARCHAR2) IS
799:
800: l_note_msg VARCHAR2(240);
801: BEGIN
802: fnd_message.set_name('CN', 'CN_SPP_UPD_NOTE');
803: fnd_message.set_token('FIELD', cn_api.get_lkup_meaning(p_field, 'CN_NOTE_FIELDS'));
804: fnd_message.set_token('OLD', p_old_value);
805: fnd_message.set_token('NEW', p_new_value);
806: l_note_msg := fnd_message.get;

Line 803: fnd_message.set_token('FIELD', cn_api.get_lkup_meaning(p_field, 'CN_NOTE_FIELDS'));

799:
800: l_note_msg VARCHAR2(240);
801: BEGIN
802: fnd_message.set_name('CN', 'CN_SPP_UPD_NOTE');
803: fnd_message.set_token('FIELD', cn_api.get_lkup_meaning(p_field, 'CN_NOTE_FIELDS'));
804: fnd_message.set_token('OLD', p_old_value);
805: fnd_message.set_token('NEW', p_new_value);
806: l_note_msg := fnd_message.get;
807:

Line 804: fnd_message.set_token('OLD', p_old_value);

800: l_note_msg VARCHAR2(240);
801: BEGIN
802: fnd_message.set_name('CN', 'CN_SPP_UPD_NOTE');
803: fnd_message.set_token('FIELD', cn_api.get_lkup_meaning(p_field, 'CN_NOTE_FIELDS'));
804: fnd_message.set_token('OLD', p_old_value);
805: fnd_message.set_token('NEW', p_new_value);
806: l_note_msg := fnd_message.get;
807:
808: IF x_msg IS NOT NULL THEN

Line 805: fnd_message.set_token('NEW', p_new_value);

801: BEGIN
802: fnd_message.set_name('CN', 'CN_SPP_UPD_NOTE');
803: fnd_message.set_token('FIELD', cn_api.get_lkup_meaning(p_field, 'CN_NOTE_FIELDS'));
804: fnd_message.set_token('OLD', p_old_value);
805: fnd_message.set_token('NEW', p_new_value);
806: l_note_msg := fnd_message.get;
807:
808: IF x_msg IS NOT NULL THEN
809: x_msg := x_msg || fnd_global.local_chr(10);

Line 806: l_note_msg := fnd_message.get;

802: fnd_message.set_name('CN', 'CN_SPP_UPD_NOTE');
803: fnd_message.set_token('FIELD', cn_api.get_lkup_meaning(p_field, 'CN_NOTE_FIELDS'));
804: fnd_message.set_token('OLD', p_old_value);
805: fnd_message.set_token('NEW', p_new_value);
806: l_note_msg := fnd_message.get;
807:
808: IF x_msg IS NOT NULL THEN
809: x_msg := x_msg || fnd_global.local_chr(10);
810: END IF;

Line 998: l_note_msg := fnd_message.get_string('CN', 'CN_SPP_CRE_NOTE');

994: OPEN get_role_name;
995: FETCH get_role_name INTO l_role_name;
996: CLOSE get_role_name;
997:
998: l_note_msg := fnd_message.get_string('CN', 'CN_SPP_CRE_NOTE');
999: l_note_msg := l_note_msg || l_name || ', ' || l_role_name || ', ' ||
1000: p_pmt_plan_assign_rec.start_date || ', ' ||
1001: p_pmt_plan_assign_rec.end_date || ', ' ||
1002: p_pmt_plan_assign_rec.minimum_amount || ', ' ||

Line 1142: fnd_message.set_name('CN', 'CN_INVALID_OBJECT_VERSION');

1138: p_pmt_plan_assign_rec.object_version_number) THEN
1139:
1140: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1141: THEN
1142: fnd_message.set_name('CN', 'CN_INVALID_OBJECT_VERSION');
1143: fnd_msg_pub.add;
1144: END IF;
1145:
1146: x_loading_status := 'CN_INVALID_OBJECT_VERSION';

Line 1155: fnd_message.set_name('CN', 'CN_CANNOT_UPDATE_LOCK');

1151: -- can't change lock flag from Y to N
1152: IF l_oldrec.lock_flag = 'Y' AND p_pmt_plan_assign_rec.lock_flag = 'N' THEN
1153: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1154: THEN
1155: fnd_message.set_name('CN', 'CN_CANNOT_UPDATE_LOCK');
1156: fnd_msg_pub.add;
1157: END IF;
1158: x_loading_status := 'CN_CANNOT_UPDATE_LOCK';
1159: RAISE FND_API.G_EXC_ERROR;

Line 1167: fnd_message.set_name('CN', 'CN_CANNOT_UPDATE_LOCK');

1163: IF l_oldrec.lock_flag = 'N' AND p_pmt_plan_assign_rec.lock_flag = 'Y' AND
1164: p_pmt_plan_assign_rec.role_pmt_plan_id IS NULL THEN
1165: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1166: THEN
1167: fnd_message.set_name('CN', 'CN_CANNOT_UPDATE_LOCK');
1168: fnd_msg_pub.add;
1169: END IF;
1170: x_loading_status := 'CN_CANNOT_UPDATE_LOCK';
1171: RAISE FND_API.G_EXC_ERROR;

Line 1461: FND_MESSAGE.Set_Name('CN', 'CN_SRP_PMT_PLAN_LOCKED');

1457: CLOSE spp_csr;
1458: /*
1459: IF (NVL(l_spp_rec.lock_flag, 'N') = 'Y') THEN
1460: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1461: FND_MESSAGE.Set_Name('CN', 'CN_SRP_PMT_PLAN_LOCKED');
1462: FND_MSG_PUB.Add;
1463: END IF;
1464: x_loading_status := 'CN_SRP_PMT_PLAN_LOCKED';
1465: RAISE FND_API.G_EXC_ERROR ;

Line 1589: l_note_msg := fnd_message.get_string('CN', 'CN_SPP_DEL_NOTE');

1585: OPEN spp_info_cur;
1586: FETCH spp_info_cur INTO spp_info;
1587: CLOSE spp_info_cur;
1588:
1589: l_note_msg := fnd_message.get_string('CN', 'CN_SPP_DEL_NOTE');
1590: l_note_msg := l_note_msg || spp_info.name || ', ' ||
1591: spp_info.role_name || ', ' ||
1592: spp_info.start_date || ', ' ||
1593: spp_info.end_date || ', ' ||

Line 2112: FND_MESSAGE.Set_Name('CN', 'CN_SPP_UPDATE_NOT_ALLOWED');

2108: x_loading_status := l_loading_status;
2109:
2110: ELSE
2111: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2112: FND_MESSAGE.Set_Name('CN', 'CN_SPP_UPDATE_NOT_ALLOWED');
2113: FND_MSG_PUB.Add;
2114: END IF;
2115: RAISE FND_API.G_EXC_ERROR;
2116: END IF;

Line 2377: -- FND_MESSAGE.SET_NAME ('CN' , 'CN_SRP_PMT_PLAN_USED');

2373: );
2374:
2375: IF l_dummy > 0 then
2376: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2377: -- FND_MESSAGE.SET_NAME ('CN' , 'CN_SRP_PMT_PLAN_USED');
2378: -- FND_MSG_PUB.Add;
2379: update cn_srp_pmt_plans set srp_role_id = null, role_pmt_plan_id = null
2380: where srp_pmt_plan_id = l_srp_pmt_plan_id;
2381: