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

Line 170: fnd_message.set_name('CN','CNR12_NOTE_PE_RT_ASGN_CRE');

166: WHERE RATE_SCHEDULE_ID = p_rt_quota_asgn.rate_schedule_id
167: AND ORG_ID = p_rt_quota_asgn.org_id;
168:
169: IF (p_operation = 'create') THEN
170: fnd_message.set_name('CN','CNR12_NOTE_PE_RT_ASGN_CRE');
171: fnd_message.set_token('RT_TAB', l_temp_old);
172: fnd_message.set_token('ST_DT', p_rt_quota_asgn.start_date);
173: fnd_message.set_token('END_DT', p_rt_quota_asgn.end_date);
174: l_plan_element_id := p_rt_quota_asgn.quota_id;

Line 171: fnd_message.set_token('RT_TAB', l_temp_old);

167: AND ORG_ID = p_rt_quota_asgn.org_id;
168:
169: IF (p_operation = 'create') THEN
170: fnd_message.set_name('CN','CNR12_NOTE_PE_RT_ASGN_CRE');
171: fnd_message.set_token('RT_TAB', l_temp_old);
172: fnd_message.set_token('ST_DT', p_rt_quota_asgn.start_date);
173: fnd_message.set_token('END_DT', p_rt_quota_asgn.end_date);
174: l_plan_element_id := p_rt_quota_asgn.quota_id;
175: l_temp_new := 'CN_QUOTAS';

Line 172: fnd_message.set_token('ST_DT', p_rt_quota_asgn.start_date);

168:
169: IF (p_operation = 'create') THEN
170: fnd_message.set_name('CN','CNR12_NOTE_PE_RT_ASGN_CRE');
171: fnd_message.set_token('RT_TAB', l_temp_old);
172: fnd_message.set_token('ST_DT', p_rt_quota_asgn.start_date);
173: fnd_message.set_token('END_DT', p_rt_quota_asgn.end_date);
174: l_plan_element_id := p_rt_quota_asgn.quota_id;
175: l_temp_new := 'CN_QUOTAS';
176: END IF;

Line 173: fnd_message.set_token('END_DT', p_rt_quota_asgn.end_date);

169: IF (p_operation = 'create') THEN
170: fnd_message.set_name('CN','CNR12_NOTE_PE_RT_ASGN_CRE');
171: fnd_message.set_token('RT_TAB', l_temp_old);
172: fnd_message.set_token('ST_DT', p_rt_quota_asgn.start_date);
173: fnd_message.set_token('END_DT', p_rt_quota_asgn.end_date);
174: l_plan_element_id := p_rt_quota_asgn.quota_id;
175: l_temp_new := 'CN_QUOTAS';
176: END IF;
177: IF (p_operation = 'delete') THEN

Line 178: fnd_message.set_name ('CN', 'CNR12_NOTE_PE_RT_ASGN_DEL');

174: l_plan_element_id := p_rt_quota_asgn.quota_id;
175: l_temp_new := 'CN_QUOTAS';
176: END IF;
177: IF (p_operation = 'delete') THEN
178: fnd_message.set_name ('CN', 'CNR12_NOTE_PE_RT_ASGN_DEL');
179: fnd_message.set_token('RT_TAB', l_temp_old);
180: fnd_message.set_token('ST_DATE', p_rt_quota_asgn.start_date);
181: fnd_message.set_token('END_DATE', p_rt_quota_asgn.end_date);
182: l_plan_element_id := p_rt_quota_asgn.quota_id;

Line 179: fnd_message.set_token('RT_TAB', l_temp_old);

175: l_temp_new := 'CN_QUOTAS';
176: END IF;
177: IF (p_operation = 'delete') THEN
178: fnd_message.set_name ('CN', 'CNR12_NOTE_PE_RT_ASGN_DEL');
179: fnd_message.set_token('RT_TAB', l_temp_old);
180: fnd_message.set_token('ST_DATE', p_rt_quota_asgn.start_date);
181: fnd_message.set_token('END_DATE', p_rt_quota_asgn.end_date);
182: l_plan_element_id := p_rt_quota_asgn.quota_id;
183: l_temp_new := 'CN_QUOTAS';

Line 180: fnd_message.set_token('ST_DATE', p_rt_quota_asgn.start_date);

176: END IF;
177: IF (p_operation = 'delete') THEN
178: fnd_message.set_name ('CN', 'CNR12_NOTE_PE_RT_ASGN_DEL');
179: fnd_message.set_token('RT_TAB', l_temp_old);
180: fnd_message.set_token('ST_DATE', p_rt_quota_asgn.start_date);
181: fnd_message.set_token('END_DATE', p_rt_quota_asgn.end_date);
182: l_plan_element_id := p_rt_quota_asgn.quota_id;
183: l_temp_new := 'CN_QUOTAS';
184: END IF;

Line 181: fnd_message.set_token('END_DATE', p_rt_quota_asgn.end_date);

177: IF (p_operation = 'delete') THEN
178: fnd_message.set_name ('CN', 'CNR12_NOTE_PE_RT_ASGN_DEL');
179: fnd_message.set_token('RT_TAB', l_temp_old);
180: fnd_message.set_token('ST_DATE', p_rt_quota_asgn.start_date);
181: fnd_message.set_token('END_DATE', p_rt_quota_asgn.end_date);
182: l_plan_element_id := p_rt_quota_asgn.quota_id;
183: l_temp_new := 'CN_QUOTAS';
184: END IF;
185: IF (p_operation = 'update') THEN

Line 191: fnd_message.set_name('CN','CNR12_NOTE_PE_RT_ASGN_UPD');

187: FROM CN_RATE_SCHEDULES
188: WHERE RATE_SCHEDULE_ID = p_old_rt_quota_asgn.rate_schedule_id
189: AND ORG_ID = p_old_rt_quota_asgn.org_id;
190:
191: fnd_message.set_name('CN','CNR12_NOTE_PE_RT_ASGN_UPD');
192: fnd_message.set_token('OLD_RT_TAB', l_old_rt_name);
193: fnd_message.set_token('OLD_ST_DT', p_old_rt_quota_asgn.start_date);
194: fnd_message.set_token('OLD_END_DT', p_old_rt_quota_asgn.end_date);
195: fnd_message.set_token('NEW_RT_TAB', l_temp_old);

Line 192: fnd_message.set_token('OLD_RT_TAB', l_old_rt_name);

188: WHERE RATE_SCHEDULE_ID = p_old_rt_quota_asgn.rate_schedule_id
189: AND ORG_ID = p_old_rt_quota_asgn.org_id;
190:
191: fnd_message.set_name('CN','CNR12_NOTE_PE_RT_ASGN_UPD');
192: fnd_message.set_token('OLD_RT_TAB', l_old_rt_name);
193: fnd_message.set_token('OLD_ST_DT', p_old_rt_quota_asgn.start_date);
194: fnd_message.set_token('OLD_END_DT', p_old_rt_quota_asgn.end_date);
195: fnd_message.set_token('NEW_RT_TAB', l_temp_old);
196: fnd_message.set_token('NEW_ST_DT', p_rt_quota_asgn.start_date);

Line 193: fnd_message.set_token('OLD_ST_DT', p_old_rt_quota_asgn.start_date);

189: AND ORG_ID = p_old_rt_quota_asgn.org_id;
190:
191: fnd_message.set_name('CN','CNR12_NOTE_PE_RT_ASGN_UPD');
192: fnd_message.set_token('OLD_RT_TAB', l_old_rt_name);
193: fnd_message.set_token('OLD_ST_DT', p_old_rt_quota_asgn.start_date);
194: fnd_message.set_token('OLD_END_DT', p_old_rt_quota_asgn.end_date);
195: fnd_message.set_token('NEW_RT_TAB', l_temp_old);
196: fnd_message.set_token('NEW_ST_DT', p_rt_quota_asgn.start_date);
197: fnd_message.set_token('NEW_END_DT', p_rt_quota_asgn.end_date);

Line 194: fnd_message.set_token('OLD_END_DT', p_old_rt_quota_asgn.end_date);

190:
191: fnd_message.set_name('CN','CNR12_NOTE_PE_RT_ASGN_UPD');
192: fnd_message.set_token('OLD_RT_TAB', l_old_rt_name);
193: fnd_message.set_token('OLD_ST_DT', p_old_rt_quota_asgn.start_date);
194: fnd_message.set_token('OLD_END_DT', p_old_rt_quota_asgn.end_date);
195: fnd_message.set_token('NEW_RT_TAB', l_temp_old);
196: fnd_message.set_token('NEW_ST_DT', p_rt_quota_asgn.start_date);
197: fnd_message.set_token('NEW_END_DT', p_rt_quota_asgn.end_date);
198: l_plan_element_id := p_rt_quota_asgn.quota_id;

Line 195: fnd_message.set_token('NEW_RT_TAB', l_temp_old);

191: fnd_message.set_name('CN','CNR12_NOTE_PE_RT_ASGN_UPD');
192: fnd_message.set_token('OLD_RT_TAB', l_old_rt_name);
193: fnd_message.set_token('OLD_ST_DT', p_old_rt_quota_asgn.start_date);
194: fnd_message.set_token('OLD_END_DT', p_old_rt_quota_asgn.end_date);
195: fnd_message.set_token('NEW_RT_TAB', l_temp_old);
196: fnd_message.set_token('NEW_ST_DT', p_rt_quota_asgn.start_date);
197: fnd_message.set_token('NEW_END_DT', p_rt_quota_asgn.end_date);
198: l_plan_element_id := p_rt_quota_asgn.quota_id;
199: l_temp_new := 'CN_QUOTAS';

Line 196: fnd_message.set_token('NEW_ST_DT', p_rt_quota_asgn.start_date);

192: fnd_message.set_token('OLD_RT_TAB', l_old_rt_name);
193: fnd_message.set_token('OLD_ST_DT', p_old_rt_quota_asgn.start_date);
194: fnd_message.set_token('OLD_END_DT', p_old_rt_quota_asgn.end_date);
195: fnd_message.set_token('NEW_RT_TAB', l_temp_old);
196: fnd_message.set_token('NEW_ST_DT', p_rt_quota_asgn.start_date);
197: fnd_message.set_token('NEW_END_DT', p_rt_quota_asgn.end_date);
198: l_plan_element_id := p_rt_quota_asgn.quota_id;
199: l_temp_new := 'CN_QUOTAS';
200: END IF;

Line 197: fnd_message.set_token('NEW_END_DT', p_rt_quota_asgn.end_date);

193: fnd_message.set_token('OLD_ST_DT', p_old_rt_quota_asgn.start_date);
194: fnd_message.set_token('OLD_END_DT', p_old_rt_quota_asgn.end_date);
195: fnd_message.set_token('NEW_RT_TAB', l_temp_old);
196: fnd_message.set_token('NEW_ST_DT', p_rt_quota_asgn.start_date);
197: fnd_message.set_token('NEW_END_DT', p_rt_quota_asgn.end_date);
198: l_plan_element_id := p_rt_quota_asgn.quota_id;
199: l_temp_new := 'CN_QUOTAS';
200: END IF;
201:

Line 202: l_note_msg := fnd_message.get;

198: l_plan_element_id := p_rt_quota_asgn.quota_id;
199: l_temp_new := 'CN_QUOTAS';
200: END IF;
201:
202: l_note_msg := fnd_message.get;
203: jtf_notes_pub.create_note
204: (p_api_version => 1.0,
205: x_return_status => x_return_status,
206: x_msg_count => x_msg_count,

Line 623: fnd_message.set_name ('CN', 'CN_RECORD_CHANGED');

619:
620: -- 3. check object version number
621: IF l_old_rt_quota_asgn.object_version_number <> p_rt_quota_asgn.object_version_number
622: THEN
623: fnd_message.set_name ('CN', 'CN_RECORD_CHANGED');
624: fnd_msg_pub.ADD;
625: RAISE fnd_api.g_exc_error;
626: END IF;
627:

Line 813: FND_MESSAGE.SET_NAME ('CN' , 'CN_QUOTA_RULE_ASGNED');

809:
810: IF l_temp_count > 0 THEN
811:
812: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
813: FND_MESSAGE.SET_NAME ('CN' , 'CN_QUOTA_RULE_ASGNED');
814: FND_MSG_PUB.Add;
815: END IF;
816: RAISE FND_API.G_EXC_ERROR ;
817: END IF;*/

Line 1219: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');

1215: IF p_rt_quota_asgn.rate_schedule_id IS NULL
1216: THEN
1217: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1218: THEN
1219: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
1220: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('CALC_FORMULA_ID', 'PE_OBJECT_TYPE'));
1221: fnd_msg_pub.ADD;
1222: RAISE fnd_api.g_exc_error;
1223: END IF;

Line 1220: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('CALC_FORMULA_ID', 'PE_OBJECT_TYPE'));

1216: THEN
1217: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1218: THEN
1219: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
1220: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('CALC_FORMULA_ID', 'PE_OBJECT_TYPE'));
1221: fnd_msg_pub.ADD;
1222: RAISE fnd_api.g_exc_error;
1223: END IF;
1224: ELSE

Line 1235: fnd_message.set_name ('CN', 'CN_RATE_SCH_NOT_EXIST');

1231: WHEN NO_DATA_FOUND
1232: THEN
1233: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1234: THEN
1235: fnd_message.set_name ('CN', 'CN_RATE_SCH_NOT_EXIST');
1236: fnd_msg_pub.ADD;
1237: END IF;
1238:
1239: RAISE fnd_api.g_exc_error;

Line 1247: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');

1243: IF p_rt_quota_asgn.quota_id IS NULL
1244: THEN
1245: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1246: THEN
1247: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
1248: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('PE_NAME', 'INPUT_TOKEN'));
1249: fnd_msg_pub.ADD;
1250: RAISE fnd_api.g_exc_error;
1251: END IF;

Line 1248: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('PE_NAME', 'INPUT_TOKEN'));

1244: THEN
1245: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1246: THEN
1247: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
1248: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('PE_NAME', 'INPUT_TOKEN'));
1249: fnd_msg_pub.ADD;
1250: RAISE fnd_api.g_exc_error;
1251: END IF;
1252: ELSE

Line 1263: fnd_message.set_name ('CN', 'CN_INVALID_DATA');

1259: WHEN OTHERS
1260: THEN
1261: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1262: THEN
1263: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
1264: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('PE_NAME', 'INPUT_TOKEN'));
1265: fnd_msg_pub.ADD;
1266: END IF;
1267:

Line 1264: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('PE_NAME', 'INPUT_TOKEN'));

1260: THEN
1261: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1262: THEN
1263: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
1264: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('PE_NAME', 'INPUT_TOKEN'));
1265: fnd_msg_pub.ADD;
1266: END IF;
1267:
1268: RAISE fnd_api.g_exc_error;

Line 1277: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');

1273: THEN
1274: IF l_formula_type = 'FORMULA' THEN
1275: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1276: THEN
1277: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
1278: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('CALC_FORMULA_ID', 'PE_OBJECT_TYPE'));
1279: fnd_msg_pub.ADD;
1280: RAISE fnd_api.g_exc_error;
1281: END IF;

Line 1278: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('CALC_FORMULA_ID', 'PE_OBJECT_TYPE'));

1274: IF l_formula_type = 'FORMULA' THEN
1275: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1276: THEN
1277: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
1278: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('CALC_FORMULA_ID', 'PE_OBJECT_TYPE'));
1279: fnd_msg_pub.ADD;
1280: RAISE fnd_api.g_exc_error;
1281: END IF;
1282: END IF ;

Line 1294: fnd_message.set_name ('CN', 'CN_FORMULA_NOT_EXIST');

1290: WHEN NO_DATA_FOUND
1291: THEN
1292: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1293: THEN
1294: fnd_message.set_name ('CN', 'CN_FORMULA_NOT_EXIST');
1295: fnd_message.set_token ('FORMULA_NAME', p_rt_quota_asgn.calc_formula_id);
1296: fnd_msg_pub.ADD;
1297: END IF;
1298:

Line 1295: fnd_message.set_token ('FORMULA_NAME', p_rt_quota_asgn.calc_formula_id);

1291: THEN
1292: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1293: THEN
1294: fnd_message.set_name ('CN', 'CN_FORMULA_NOT_EXIST');
1295: fnd_message.set_token ('FORMULA_NAME', p_rt_quota_asgn.calc_formula_id);
1296: fnd_msg_pub.ADD;
1297: END IF;
1298:
1299: RAISE fnd_api.g_exc_error;

Line 1307: fnd_message.set_name ('CN', 'CN_INVALID_DATA');

1303: IF (p_rt_quota_asgn.start_date IS NULL)
1304: THEN
1305: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1306: THEN
1307: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
1308: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('START_DATE', 'PE_OBJECT_TYPE'));
1309: fnd_msg_pub.ADD;
1310: END IF;
1311:

Line 1308: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('START_DATE', 'PE_OBJECT_TYPE'));

1304: THEN
1305: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1306: THEN
1307: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
1308: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('START_DATE', 'PE_OBJECT_TYPE'));
1309: fnd_msg_pub.ADD;
1310: END IF;
1311:
1312: RAISE fnd_api.g_exc_error;

Line 1320: fnd_message.set_name ('CN', 'CN_DATE_RANGE_ERROR');

1316: IF (p_rt_quota_asgn.end_date IS NOT NULL) AND (p_rt_quota_asgn.start_date > p_rt_quota_asgn.end_date)
1317: THEN
1318: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1319: THEN
1320: fnd_message.set_name ('CN', 'CN_DATE_RANGE_ERROR');
1321: fnd_msg_pub.ADD;
1322: END IF;
1323:
1324: RAISE fnd_api.g_exc_error;

Line 1357: fnd_message.set_name ('CN', 'CN_DATE_OVERLAP');

1353: IF l_counter > 0
1354: THEN
1355: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1356: THEN
1357: fnd_message.set_name ('CN', 'CN_DATE_OVERLAP');
1358: fnd_msg_pub.ADD;
1359: RAISE fnd_api.g_exc_error;
1360: END IF;
1361: END IF;

Line 1372: fnd_message.set_name ('CN', 'CN_PE_DIMS_NOT_EQUAL');

1368: WHERE rate_schedule_id = p_rt_quota_asgn.rate_schedule_id;
1369: IF l_formula_dim <> l_rate_dim THEN
1370: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1371: THEN
1372: fnd_message.set_name ('CN', 'CN_PE_DIMS_NOT_EQUAL');
1373: fnd_msg_pub.ADD;
1374: RAISE fnd_api.g_exc_error;
1375: END IF;
1376: END IF;