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.

[Home] [Help]

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 570: FND_MESSAGE.Set_Name('CN', 'CN_SRP_PP_NO_DEL');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 805: l_note_msg := fnd_message.get;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2082: x_loading_status := l_loading_status;
2083:
2084: ELSE
2085: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2086: FND_MESSAGE.Set_Name('CN', 'CN_SPP_UPDATE_NOT_ALLOWED');
2087: FND_MSG_PUB.Add;
2088: END IF;
2089: RAISE FND_API.G_EXC_ERROR;
2090: END IF;

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

2347: );
2348:
2349: IF l_dummy > 0 then
2350: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2351: -- FND_MESSAGE.SET_NAME ('CN' , 'CN_SRP_PMT_PLAN_USED');
2352: -- FND_MSG_PUB.Add;
2353: update cn_srp_pmt_plans set srp_role_id = null, role_pmt_plan_id = null
2354: where srp_pmt_plan_id = l_srp_pmt_plan_id;
2355: