DBA Data[Home] [Help]

APPS.BIX_ALERT dependencies on FND_MESSAGE

Line 171: FND_MESSAGE.SET_NAME('BIX', 'BIX_ABANDON_CALL_RATE');

167: := p_target_Level_Short_Name;
168: -- l_period_set_name := p_time_period;
169: -- l_period_name := p_time_period;
170: l_report := 'BIXACAB0';
171: FND_MESSAGE.SET_NAME('BIX', 'BIX_ABANDON_CALL_RATE');
172: l_msg_subject := FND_MESSAGE.GET;
173: IF l_msg_subject is NULL then
174: l_msg_subject := 'Abandon Call Rate PMF Notification';
175: END IF;

Line 172: l_msg_subject := FND_MESSAGE.GET;

168: -- l_period_set_name := p_time_period;
169: -- l_period_name := p_time_period;
170: l_report := 'BIXACAB0';
171: FND_MESSAGE.SET_NAME('BIX', 'BIX_ABANDON_CALL_RATE');
172: l_msg_subject := FND_MESSAGE.GET;
173: IF l_msg_subject is NULL then
174: l_msg_subject := 'Abandon Call Rate PMF Notification';
175: END IF;
176: l_organization_id := -1;

Line 261: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE1');

257: cr_t.range2_low AND cr_t.range2_High
258: AND l_actual BETWEEN
259: cr_t.range1_low AND cr_t.range1_High
260: THEN
261: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE1');
262: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
263: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
264: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
265: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

Line 262: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);

258: AND l_actual BETWEEN
259: cr_t.range1_low AND cr_t.range1_High
260: THEN
261: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE1');
262: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
263: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
264: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
265: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
266: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

Line 263: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);

259: cr_t.range1_low AND cr_t.range1_High
260: THEN
261: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE1');
262: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
263: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
264: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
265: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
266: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
267: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

Line 264: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);

260: THEN
261: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE1');
262: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
263: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
264: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
265: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
266: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
267: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
268: l_message := FND_MESSAGE.GET;

Line 265: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

261: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE1');
262: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
263: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
264: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
265: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
266: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
267: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
268: l_message := FND_MESSAGE.GET;
269: l_notify_resp := cr_t.Notify_Resp1_short_name;

Line 266: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

262: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
263: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
264: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
265: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
266: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
267: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
268: l_message := FND_MESSAGE.GET;
269: l_notify_resp := cr_t.Notify_Resp1_short_name;
270: l_responsibility_id := cr_t.Notify_Resp1_ID;

Line 267: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

263: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
264: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
265: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
266: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
267: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
268: l_message := FND_MESSAGE.GET;
269: l_notify_resp := cr_t.Notify_Resp1_short_name;
270: l_responsibility_id := cr_t.Notify_Resp1_ID;
271: --dbms_output.put_line('In First Range');

Line 268: l_message := FND_MESSAGE.GET;

264: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
265: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
266: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
267: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
268: l_message := FND_MESSAGE.GET;
269: l_notify_resp := cr_t.Notify_Resp1_short_name;
270: l_responsibility_id := cr_t.Notify_Resp1_ID;
271: --dbms_output.put_line('In First Range');
272: -- Check if actual is within the second range

Line 278: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE2');

274: cr_t.range1_low AND cr_t.range1_High
275: AND l_actual BETWEEN
276: cr_t.range2_low AND cr_t.range2_High
277: THEN
278: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE2');
279: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
280: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
281: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
282: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

Line 279: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);

275: AND l_actual BETWEEN
276: cr_t.range2_low AND cr_t.range2_High
277: THEN
278: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE2');
279: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
280: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
281: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
282: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
283: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

Line 280: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);

276: cr_t.range2_low AND cr_t.range2_High
277: THEN
278: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE2');
279: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
280: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
281: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
282: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
283: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
284: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

Line 281: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);

277: THEN
278: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE2');
279: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
280: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
281: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
282: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
283: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
284: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
285: l_message := FND_MESSAGE.GET;

Line 282: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

278: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE2');
279: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
280: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
281: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
282: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
283: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
284: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
285: l_message := FND_MESSAGE.GET;
286: l_notify_resp := cr_t.Notify_Resp1_short_name;

Line 283: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

279: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
280: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
281: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
282: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
283: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
284: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
285: l_message := FND_MESSAGE.GET;
286: l_notify_resp := cr_t.Notify_Resp1_short_name;
287: l_responsibility_id := cr_t.Notify_Resp1_ID;

Line 284: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

280: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
281: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
282: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
283: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
284: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
285: l_message := FND_MESSAGE.GET;
286: l_notify_resp := cr_t.Notify_Resp1_short_name;
287: l_responsibility_id := cr_t.Notify_Resp1_ID;
288: --dbms_output.put_line('In Second Range');

Line 285: l_message := FND_MESSAGE.GET;

281: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
282: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
283: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
284: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
285: l_message := FND_MESSAGE.GET;
286: l_notify_resp := cr_t.Notify_Resp1_short_name;
287: l_responsibility_id := cr_t.Notify_Resp1_ID;
288: --dbms_output.put_line('In Second Range');
289: -- Check if actual is within the third range

Line 296: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE3');

292: cr_t.range2_low AND cr_t.range2_High
293: AND l_actual BETWEEN
294: cr_t.range3_low AND cr_t.range3_High
295: THEN
296: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE3');
297: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
298: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
299: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
300: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

Line 297: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);

293: AND l_actual BETWEEN
294: cr_t.range3_low AND cr_t.range3_High
295: THEN
296: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE3');
297: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
298: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
299: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
300: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
301: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

Line 298: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);

294: cr_t.range3_low AND cr_t.range3_High
295: THEN
296: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE3');
297: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
298: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
299: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
300: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
301: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
302: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

Line 299: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);

295: THEN
296: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE3');
297: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
298: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
299: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
300: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
301: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
302: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
303: l_message := FND_MESSAGE.GET;

Line 300: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

296: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE3');
297: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
298: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
299: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
300: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
301: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
302: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
303: l_message := FND_MESSAGE.GET;
304: l_notify_resp := cr_t.Notify_Resp2_short_name;

Line 301: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

297: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
298: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
299: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
300: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
301: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
302: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
303: l_message := FND_MESSAGE.GET;
304: l_notify_resp := cr_t.Notify_Resp2_short_name;
305: l_responsibility_id := cr_t.Notify_Resp2_ID;

Line 302: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

298: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
299: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
300: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
301: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
302: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
303: l_message := FND_MESSAGE.GET;
304: l_notify_resp := cr_t.Notify_Resp2_short_name;
305: l_responsibility_id := cr_t.Notify_Resp2_ID;
306: --dbms_output.put_line('In Third Range');

Line 303: l_message := FND_MESSAGE.GET;

299: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
300: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
301: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
302: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
303: l_message := FND_MESSAGE.GET;
304: l_notify_resp := cr_t.Notify_Resp2_short_name;
305: l_responsibility_id := cr_t.Notify_Resp2_ID;
306: --dbms_output.put_line('In Third Range');
307: -- Check if actual is outside the third range

Line 312: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_OFFRANGE');

308: ELSIF l_actual NOT BETWEEN
309: cr_t.range3_low AND cr_t.range3_High
310: AND l_actual > l_target
311: THEN
312: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_OFFRANGE');
313: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
314: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
315: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
316: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

Line 313: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);

309: cr_t.range3_low AND cr_t.range3_High
310: AND l_actual > l_target
311: THEN
312: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_OFFRANGE');
313: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
314: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
315: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
316: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
317: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

Line 314: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);

310: AND l_actual > l_target
311: THEN
312: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_OFFRANGE');
313: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
314: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
315: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
316: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
317: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
318: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

Line 315: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);

311: THEN
312: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_OFFRANGE');
313: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
314: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
315: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
316: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
317: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
318: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
319: l_message := FND_MESSAGE.GET;

Line 316: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

312: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_OFFRANGE');
313: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
314: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
315: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
316: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
317: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
318: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
319: l_message := FND_MESSAGE.GET;
320: l_notify_resp := cr_t.Notify_Resp3_short_name;

Line 317: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

313: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
314: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
315: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
316: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
317: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
318: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
319: l_message := FND_MESSAGE.GET;
320: l_notify_resp := cr_t.Notify_Resp3_short_name;
321: l_responsibility_id := cr_t.Notify_Resp3_ID;

Line 318: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

314: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
315: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
316: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
317: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
318: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
319: l_message := FND_MESSAGE.GET;
320: l_notify_resp := cr_t.Notify_Resp3_short_name;
321: l_responsibility_id := cr_t.Notify_Resp3_ID;
322: --dbms_output.put_line('Out of Third Range');

Line 319: l_message := FND_MESSAGE.GET;

315: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
316: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
317: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
318: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
319: l_message := FND_MESSAGE.GET;
320: l_notify_resp := cr_t.Notify_Resp3_short_name;
321: l_responsibility_id := cr_t.Notify_Resp3_ID;
322: --dbms_output.put_line('Out of Third Range');
323: ELSIF l_actual < l_target

Line 325: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_EXRANGE');

321: l_responsibility_id := cr_t.Notify_Resp3_ID;
322: --dbms_output.put_line('Out of Third Range');
323: ELSIF l_actual < l_target
324: THEN
325: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_EXRANGE');
326: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
327: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
328: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
329: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

Line 326: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);

322: --dbms_output.put_line('Out of Third Range');
323: ELSIF l_actual < l_target
324: THEN
325: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_EXRANGE');
326: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
327: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
328: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
329: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
330: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

Line 327: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);

323: ELSIF l_actual < l_target
324: THEN
325: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_EXRANGE');
326: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
327: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
328: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
329: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
330: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
331: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

Line 328: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);

324: THEN
325: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_EXRANGE');
326: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
327: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
328: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
329: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
330: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
331: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
332: l_message := FND_MESSAGE.GET;

Line 329: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

325: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_EXRANGE');
326: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
327: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
328: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
329: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
330: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
331: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
332: l_message := FND_MESSAGE.GET;
333: l_notify_resp := cr_t.Notify_Resp3_short_name;

Line 330: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

326: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
327: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
328: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
329: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
330: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
331: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
332: l_message := FND_MESSAGE.GET;
333: l_notify_resp := cr_t.Notify_Resp3_short_name;
334: l_responsibility_id := cr_t.Notify_Resp3_ID;

Line 331: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

327: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
328: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
329: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
330: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
331: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
332: l_message := FND_MESSAGE.GET;
333: l_notify_resp := cr_t.Notify_Resp3_short_name;
334: l_responsibility_id := cr_t.Notify_Resp3_ID;
335: --dbms_output.put_line('less than First Range');

Line 332: l_message := FND_MESSAGE.GET;

328: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
329: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
330: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
331: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
332: l_message := FND_MESSAGE.GET;
333: l_notify_resp := cr_t.Notify_Resp3_short_name;
334: l_responsibility_id := cr_t.Notify_Resp3_ID;
335: --dbms_output.put_line('less than First Range');
336: END IF;

Line 340: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_INRANGE');

336: END IF;
337:
338: -- We're on target!!
339: ELSE
340: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_INRANGE');
341: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
342: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
343: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
344: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

Line 341: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);

337:
338: -- We're on target!!
339: ELSE
340: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_INRANGE');
341: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
342: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
343: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
344: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
345: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

Line 342: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);

338: -- We're on target!!
339: ELSE
340: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_INRANGE');
341: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
342: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
343: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
344: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
345: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
346: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

Line 343: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);

339: ELSE
340: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_INRANGE');
341: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
342: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
343: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
344: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
345: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
346: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
347: l_message := FND_MESSAGE.GET;

Line 344: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

340: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_INRANGE');
341: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
342: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
343: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
344: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
345: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
346: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
347: l_message := FND_MESSAGE.GET;
348: l_notify_resp := cr_t.Notify_Resp1_short_name;

Line 345: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

341: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
342: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
343: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
344: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
345: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
346: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
347: l_message := FND_MESSAGE.GET;
348: l_notify_resp := cr_t.Notify_Resp1_short_name;
349: l_responsibility_id := cr_t.Notify_Resp1_ID;

Line 346: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

342: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
343: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
344: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
345: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
346: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
347: l_message := FND_MESSAGE.GET;
348: l_notify_resp := cr_t.Notify_Resp1_short_name;
349: l_responsibility_id := cr_t.Notify_Resp1_ID;
350: END IF;

Line 347: l_message := FND_MESSAGE.GET;

343: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
344: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
345: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
346: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
347: l_message := FND_MESSAGE.GET;
348: l_notify_resp := cr_t.Notify_Resp1_short_name;
349: l_responsibility_id := cr_t.Notify_Resp1_ID;
350: END IF;
351: /*

Line 452: FND_MESSAGE.SET_NAME('BIX', 'BIX_SERVICE_LEVEL');

448: -- l_period_set_name := p_time_period;
449: -- l_period_name := p_time_period;
450: l_report := 'BIXSLVL0';
451: -- Get translated subject for notification
452: FND_MESSAGE.SET_NAME('BIX', 'BIX_SERVICE_LEVEL');
453: l_msg_subject := FND_MESSAGE.GET;
454: IF l_msg_subject is NULL then
455: l_msg_subject := 'Service Level PMF Notification';
456: END IF;

Line 453: l_msg_subject := FND_MESSAGE.GET;

449: -- l_period_name := p_time_period;
450: l_report := 'BIXSLVL0';
451: -- Get translated subject for notification
452: FND_MESSAGE.SET_NAME('BIX', 'BIX_SERVICE_LEVEL');
453: l_msg_subject := FND_MESSAGE.GET;
454: IF l_msg_subject is NULL then
455: l_msg_subject := 'Service Level PMF Notification';
456: END IF;
457: l_organization_id := -1;

Line 520: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE1');

516: cr_t.range2_low AND cr_t.range2_High
517: AND l_actual BETWEEN
518: cr_t.range1_low AND cr_t.range1_High
519: THEN
520: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE1');
521: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
522: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
523: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
524: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

Line 521: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);

517: AND l_actual BETWEEN
518: cr_t.range1_low AND cr_t.range1_High
519: THEN
520: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE1');
521: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
522: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
523: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
524: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
525: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

Line 522: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);

518: cr_t.range1_low AND cr_t.range1_High
519: THEN
520: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE1');
521: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
522: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
523: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
524: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
525: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
526: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

Line 523: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);

519: THEN
520: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE1');
521: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
522: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
523: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
524: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
525: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
526: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
527: l_message := FND_MESSAGE.GET;

Line 524: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

520: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE1');
521: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
522: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
523: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
524: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
525: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
526: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
527: l_message := FND_MESSAGE.GET;
528: l_notify_resp := cr_t.Notify_Resp1_short_name;

Line 525: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

521: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
522: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
523: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
524: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
525: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
526: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
527: l_message := FND_MESSAGE.GET;
528: l_notify_resp := cr_t.Notify_Resp1_short_name;
529: l_responsibility_id := cr_t.Notify_Resp1_ID;

Line 526: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

522: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
523: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
524: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
525: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
526: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
527: l_message := FND_MESSAGE.GET;
528: l_notify_resp := cr_t.Notify_Resp1_short_name;
529: l_responsibility_id := cr_t.Notify_Resp1_ID;
530: -- dbms_output.put_line('In First Range' || l_message);

Line 527: l_message := FND_MESSAGE.GET;

523: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
524: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
525: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
526: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
527: l_message := FND_MESSAGE.GET;
528: l_notify_resp := cr_t.Notify_Resp1_short_name;
529: l_responsibility_id := cr_t.Notify_Resp1_ID;
530: -- dbms_output.put_line('In First Range' || l_message);
531: -- Check if actual is within the second range

Line 537: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE2');

533: cr_t.range1_low AND cr_t.range1_High
534: AND l_actual BETWEEN
535: cr_t.range2_low AND cr_t.range2_High
536: THEN
537: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE2');
538: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
539: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
540: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
541: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

Line 538: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);

534: AND l_actual BETWEEN
535: cr_t.range2_low AND cr_t.range2_High
536: THEN
537: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE2');
538: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
539: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
540: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
541: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
542: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

Line 539: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);

535: cr_t.range2_low AND cr_t.range2_High
536: THEN
537: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE2');
538: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
539: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
540: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
541: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
542: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
543: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

Line 540: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);

536: THEN
537: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE2');
538: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
539: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
540: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
541: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
542: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
543: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
544: l_message := FND_MESSAGE.GET;

Line 541: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

537: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE2');
538: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
539: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
540: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
541: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
542: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
543: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
544: l_message := FND_MESSAGE.GET;
545: l_notify_resp := cr_t.Notify_Resp1_short_name;

Line 542: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

538: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
539: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
540: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
541: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
542: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
543: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
544: l_message := FND_MESSAGE.GET;
545: l_notify_resp := cr_t.Notify_Resp1_short_name;
546: l_responsibility_id := cr_t.Notify_Resp1_ID;

Line 543: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

539: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
540: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
541: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
542: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
543: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
544: l_message := FND_MESSAGE.GET;
545: l_notify_resp := cr_t.Notify_Resp1_short_name;
546: l_responsibility_id := cr_t.Notify_Resp1_ID;
547: --dbms_output.put_line('In Second Range');

Line 544: l_message := FND_MESSAGE.GET;

540: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
541: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
542: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
543: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
544: l_message := FND_MESSAGE.GET;
545: l_notify_resp := cr_t.Notify_Resp1_short_name;
546: l_responsibility_id := cr_t.Notify_Resp1_ID;
547: --dbms_output.put_line('In Second Range');
548: -- Check if actual is within the third range

Line 554: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE3');

550: cr_t.range2_low AND cr_t.range2_High
551: AND l_actual BETWEEN
552: cr_t.range3_low AND cr_t.range3_High
553: THEN
554: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE3');
555: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
556: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
557: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
558: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

Line 555: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);

551: AND l_actual BETWEEN
552: cr_t.range3_low AND cr_t.range3_High
553: THEN
554: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE3');
555: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
556: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
557: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
558: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
559: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

Line 556: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);

552: cr_t.range3_low AND cr_t.range3_High
553: THEN
554: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE3');
555: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
556: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
557: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
558: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
559: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
560: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

Line 557: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);

553: THEN
554: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE3');
555: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
556: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
557: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
558: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
559: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
560: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
561: l_message := FND_MESSAGE.GET;

Line 558: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

554: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE3');
555: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
556: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
557: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
558: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
559: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
560: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
561: l_message := FND_MESSAGE.GET;
562: l_notify_resp := cr_t.Notify_Resp2_short_name;

Line 559: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

555: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
556: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
557: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
558: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
559: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
560: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
561: l_message := FND_MESSAGE.GET;
562: l_notify_resp := cr_t.Notify_Resp2_short_name;
563: l_responsibility_id := cr_t.Notify_Resp2_ID;

Line 560: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

556: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
557: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
558: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
559: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
560: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
561: l_message := FND_MESSAGE.GET;
562: l_notify_resp := cr_t.Notify_Resp2_short_name;
563: l_responsibility_id := cr_t.Notify_Resp2_ID;
564: --dbms_output.put_line('In Third Range');

Line 561: l_message := FND_MESSAGE.GET;

557: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
558: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
559: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
560: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
561: l_message := FND_MESSAGE.GET;
562: l_notify_resp := cr_t.Notify_Resp2_short_name;
563: l_responsibility_id := cr_t.Notify_Resp2_ID;
564: --dbms_output.put_line('In Third Range');
565: -- Check if actual is outside the third range

Line 570: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_OFFRANGE');

566: ELSIF l_actual NOT BETWEEN
567: cr_t.range3_low AND cr_t.range3_High
568: AND l_actual < l_target
569: THEN
570: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_OFFRANGE');
571: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
572: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
573: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
574: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

Line 571: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);

567: cr_t.range3_low AND cr_t.range3_High
568: AND l_actual < l_target
569: THEN
570: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_OFFRANGE');
571: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
572: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
573: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
574: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
575: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

Line 572: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);

568: AND l_actual < l_target
569: THEN
570: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_OFFRANGE');
571: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
572: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
573: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
574: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
575: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
576: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

Line 573: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);

569: THEN
570: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_OFFRANGE');
571: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
572: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
573: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
574: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
575: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
576: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
577: l_message := FND_MESSAGE.GET;

Line 574: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

570: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_OFFRANGE');
571: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
572: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
573: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
574: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
575: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
576: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
577: l_message := FND_MESSAGE.GET;
578: l_notify_resp := cr_t.Notify_Resp3_short_name;

Line 575: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

571: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
572: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
573: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
574: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
575: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
576: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
577: l_message := FND_MESSAGE.GET;
578: l_notify_resp := cr_t.Notify_Resp3_short_name;
579: l_responsibility_id := cr_t.Notify_Resp3_ID;

Line 576: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

572: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
573: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
574: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
575: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
576: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
577: l_message := FND_MESSAGE.GET;
578: l_notify_resp := cr_t.Notify_Resp3_short_name;
579: l_responsibility_id := cr_t.Notify_Resp3_ID;
580: --dbms_output.put_line('Out of Third Range');

Line 577: l_message := FND_MESSAGE.GET;

573: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
574: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
575: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
576: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
577: l_message := FND_MESSAGE.GET;
578: l_notify_resp := cr_t.Notify_Resp3_short_name;
579: l_responsibility_id := cr_t.Notify_Resp3_ID;
580: --dbms_output.put_line('Out of Third Range');
581: ELSIF l_actual > l_target

Line 583: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_EXRANGE');

579: l_responsibility_id := cr_t.Notify_Resp3_ID;
580: --dbms_output.put_line('Out of Third Range');
581: ELSIF l_actual > l_target
582: THEN
583: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_EXRANGE');
584: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
585: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
586: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
587: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

Line 584: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);

580: --dbms_output.put_line('Out of Third Range');
581: ELSIF l_actual > l_target
582: THEN
583: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_EXRANGE');
584: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
585: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
586: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
587: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
588: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

Line 585: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);

581: ELSIF l_actual > l_target
582: THEN
583: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_EXRANGE');
584: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
585: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
586: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
587: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
588: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
589: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

Line 586: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);

582: THEN
583: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_EXRANGE');
584: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
585: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
586: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
587: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
588: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
589: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
590: l_message := FND_MESSAGE.GET;

Line 587: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

583: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_EXRANGE');
584: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
585: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
586: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
587: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
588: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
589: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
590: l_message := FND_MESSAGE.GET;
591: l_notify_resp := cr_t.Notify_Resp3_short_name;

Line 588: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

584: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
585: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
586: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
587: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
588: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
589: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
590: l_message := FND_MESSAGE.GET;
591: l_notify_resp := cr_t.Notify_Resp3_short_name;
592: l_responsibility_id := cr_t.Notify_Resp3_ID;

Line 589: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

585: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
586: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
587: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
588: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
589: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
590: l_message := FND_MESSAGE.GET;
591: l_notify_resp := cr_t.Notify_Resp3_short_name;
592: l_responsibility_id := cr_t.Notify_Resp3_ID;
593: --dbms_output.put_line('less than First Range');

Line 590: l_message := FND_MESSAGE.GET;

586: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
587: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
588: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
589: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
590: l_message := FND_MESSAGE.GET;
591: l_notify_resp := cr_t.Notify_Resp3_short_name;
592: l_responsibility_id := cr_t.Notify_Resp3_ID;
593: --dbms_output.put_line('less than First Range');
594: END IF;

Line 598: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_INRANGE');

594: END IF;
595:
596: -- We're on target!!
597: ELSE
598: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_INRANGE');
599: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
600: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
601: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
602: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

Line 599: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);

595:
596: -- We're on target!!
597: ELSE
598: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_INRANGE');
599: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
600: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
601: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
602: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
603: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

Line 600: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);

596: -- We're on target!!
597: ELSE
598: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_INRANGE');
599: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
600: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
601: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
602: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
603: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
604: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

Line 601: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);

597: ELSE
598: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_INRANGE');
599: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
600: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
601: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
602: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
603: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
604: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
605: l_message := FND_MESSAGE.GET;

Line 602: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

598: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_INRANGE');
599: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
600: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
601: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
602: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
603: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
604: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
605: l_message := FND_MESSAGE.GET;
606: l_notify_resp := cr_t.Notify_Resp1_short_name;

Line 603: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

599: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
600: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
601: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
602: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
603: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
604: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
605: l_message := FND_MESSAGE.GET;
606: l_notify_resp := cr_t.Notify_Resp1_short_name;
607: l_responsibility_id := cr_t.Notify_Resp1_ID;

Line 604: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

600: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
601: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
602: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
603: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
604: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
605: l_message := FND_MESSAGE.GET;
606: l_notify_resp := cr_t.Notify_Resp1_short_name;
607: l_responsibility_id := cr_t.Notify_Resp1_ID;
608: END IF;

Line 605: l_message := FND_MESSAGE.GET;

601: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
602: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
603: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
604: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
605: l_message := FND_MESSAGE.GET;
606: l_notify_resp := cr_t.Notify_Resp1_short_name;
607: l_responsibility_id := cr_t.Notify_Resp1_ID;
608: END IF;
609: --dbms_output.put_line('Calling Corrective Action');

Line 708: -- Get translated subject from fnd message dictionary

704: := p_target_Level_Short_Name;
705: -- l_period_set_name := p_time_period;
706: -- l_period_name := p_time_period;
707: l_report := 'BIXASPB0';
708: -- Get translated subject from fnd message dictionary
709: FND_MESSAGE.SET_NAME('BIX','BIX_AVG_SPEED_ANSWER');
710: -- l_msg_subject := 'Average Speed to Answer PMF Notification';
711: l_msg_subject := FND_MESSAGE.GET;
712: l_organization_id := -1;

Line 709: FND_MESSAGE.SET_NAME('BIX','BIX_AVG_SPEED_ANSWER');

705: -- l_period_set_name := p_time_period;
706: -- l_period_name := p_time_period;
707: l_report := 'BIXASPB0';
708: -- Get translated subject from fnd message dictionary
709: FND_MESSAGE.SET_NAME('BIX','BIX_AVG_SPEED_ANSWER');
710: -- l_msg_subject := 'Average Speed to Answer PMF Notification';
711: l_msg_subject := FND_MESSAGE.GET;
712: l_organization_id := -1;
713: -- Get the workflow process

Line 711: l_msg_subject := FND_MESSAGE.GET;

707: l_report := 'BIXASPB0';
708: -- Get translated subject from fnd message dictionary
709: FND_MESSAGE.SET_NAME('BIX','BIX_AVG_SPEED_ANSWER');
710: -- l_msg_subject := 'Average Speed to Answer PMF Notification';
711: l_msg_subject := FND_MESSAGE.GET;
712: l_organization_id := -1;
713: -- Get the workflow process
714: SELECT workflow_item_type, workflow_process_short_name
715: INTO l_workflow_item_type, l_workflow_process

Line 776: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE1');

772: cr_t.range2_low AND cr_t.range2_High
773: AND l_actual BETWEEN
774: cr_t.range1_low AND cr_t.range1_High
775: THEN
776: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE1');
777: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
778: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
779: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
780: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

Line 777: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);

773: AND l_actual BETWEEN
774: cr_t.range1_low AND cr_t.range1_High
775: THEN
776: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE1');
777: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
778: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
779: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
780: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
781: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

Line 778: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);

774: cr_t.range1_low AND cr_t.range1_High
775: THEN
776: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE1');
777: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
778: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
779: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
780: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
781: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
782: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

Line 779: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);

775: THEN
776: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE1');
777: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
778: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
779: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
780: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
781: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
782: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
783: l_message := FND_MESSAGE.GET;

Line 780: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

776: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE1');
777: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
778: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
779: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
780: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
781: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
782: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
783: l_message := FND_MESSAGE.GET;
784: /*

Line 781: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

777: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
778: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
779: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
780: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
781: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
782: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
783: l_message := FND_MESSAGE.GET;
784: /*
785: l_message := 'Hey! Something is wrong!'||' '||

Line 782: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

778: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
779: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
780: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
781: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
782: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
783: l_message := FND_MESSAGE.GET;
784: /*
785: l_message := 'Hey! Something is wrong!'||' '||
786: 'Target Level: '||cr_t.target_level_name||' '||

Line 783: l_message := FND_MESSAGE.GET;

779: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
780: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
781: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
782: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
783: l_message := FND_MESSAGE.GET;
784: /*
785: l_message := 'Hey! Something is wrong!'||' '||
786: 'Target Level: '||cr_t.target_level_name||' '||
787: 'Business Plan: '||cr_t.plan_name||' '|| ' for '||

Line 801: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE2');

797: cr_t.range1_low AND cr_t.range1_High
798: AND l_actual BETWEEN
799: cr_t.range2_low AND cr_t.range2_High
800: THEN
801: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE2');
802: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
803: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
804: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
805: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

Line 802: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);

798: AND l_actual BETWEEN
799: cr_t.range2_low AND cr_t.range2_High
800: THEN
801: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE2');
802: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
803: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
804: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
805: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
806: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

Line 803: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);

799: cr_t.range2_low AND cr_t.range2_High
800: THEN
801: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE2');
802: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
803: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
804: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
805: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
806: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
807: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

Line 804: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);

800: THEN
801: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE2');
802: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
803: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
804: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
805: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
806: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
807: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
808: l_message := FND_MESSAGE.GET;

Line 805: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

801: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE2');
802: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
803: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
804: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
805: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
806: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
807: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
808: l_message := FND_MESSAGE.GET;
809: /*

Line 806: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

802: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
803: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
804: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
805: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
806: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
807: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
808: l_message := FND_MESSAGE.GET;
809: /*
810: l_message := 'Hey! Something is wrong!'||' '||

Line 807: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

803: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
804: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
805: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
806: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
807: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
808: l_message := FND_MESSAGE.GET;
809: /*
810: l_message := 'Hey! Something is wrong!'||' '||
811: 'Target Level: '||cr_t.target_level_name||' '||

Line 808: l_message := FND_MESSAGE.GET;

804: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
805: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
806: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
807: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
808: l_message := FND_MESSAGE.GET;
809: /*
810: l_message := 'Hey! Something is wrong!'||' '||
811: 'Target Level: '||cr_t.target_level_name||' '||
812: 'Business Plan: '||cr_t.plan_name||' '|| ' for '||

Line 826: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE3');

822: cr_t.range2_low AND cr_t.range2_High
823: AND l_actual BETWEEN
824: cr_t.range3_low AND cr_t.range3_High
825: THEN
826: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE3');
827: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
828: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
829: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
830: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

Line 827: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);

823: AND l_actual BETWEEN
824: cr_t.range3_low AND cr_t.range3_High
825: THEN
826: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE3');
827: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
828: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
829: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
830: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
831: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

Line 828: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);

824: cr_t.range3_low AND cr_t.range3_High
825: THEN
826: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE3');
827: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
828: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
829: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
830: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
831: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
832: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

Line 829: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);

825: THEN
826: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE3');
827: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
828: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
829: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
830: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
831: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
832: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
833: l_message := FND_MESSAGE.GET;

Line 830: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

826: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE3');
827: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
828: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
829: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
830: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
831: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
832: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
833: l_message := FND_MESSAGE.GET;
834: /*

Line 831: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

827: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
828: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
829: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
830: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
831: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
832: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
833: l_message := FND_MESSAGE.GET;
834: /*
835: l_message := 'Hey! Something is VERY wrong!'||' '||

Line 832: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

828: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
829: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
830: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
831: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
832: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
833: l_message := FND_MESSAGE.GET;
834: /*
835: l_message := 'Hey! Something is VERY wrong!'||' '||
836: 'Target Level: '||cr_t.target_level_name||' '||

Line 833: l_message := FND_MESSAGE.GET;

829: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
830: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
831: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
832: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
833: l_message := FND_MESSAGE.GET;
834: /*
835: l_message := 'Hey! Something is VERY wrong!'||' '||
836: 'Target Level: '||cr_t.target_level_name||' '||
837: 'Business Plan: '||cr_t.plan_name||' '|| ' for '||

Line 850: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_OFFRANGE');

846: ELSIF l_actual NOT BETWEEN
847: cr_t.range3_low AND cr_t.range3_High
848: AND l_actual > l_target
849: THEN
850: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_OFFRANGE');
851: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
852: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
853: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
854: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

Line 851: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);

847: cr_t.range3_low AND cr_t.range3_High
848: AND l_actual > l_target
849: THEN
850: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_OFFRANGE');
851: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
852: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
853: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
854: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
855: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

Line 852: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);

848: AND l_actual > l_target
849: THEN
850: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_OFFRANGE');
851: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
852: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
853: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
854: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
855: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
856: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

Line 853: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);

849: THEN
850: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_OFFRANGE');
851: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
852: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
853: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
854: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
855: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
856: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
857: l_message := FND_MESSAGE.GET;

Line 854: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

850: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_OFFRANGE');
851: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
852: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
853: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
854: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
855: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
856: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
857: l_message := FND_MESSAGE.GET;
858: /*

Line 855: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

851: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
852: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
853: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
854: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
855: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
856: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
857: l_message := FND_MESSAGE.GET;
858: /*
859: l_message := 'Hey! Something is VERY VERY wrong!'||' '||

Line 856: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

852: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
853: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
854: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
855: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
856: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
857: l_message := FND_MESSAGE.GET;
858: /*
859: l_message := 'Hey! Something is VERY VERY wrong!'||' '||
860: 'Target Level: '||cr_t.target_level_name||' '||

Line 857: l_message := FND_MESSAGE.GET;

853: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
854: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
855: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
856: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
857: l_message := FND_MESSAGE.GET;
858: /*
859: l_message := 'Hey! Something is VERY VERY wrong!'||' '||
860: 'Target Level: '||cr_t.target_level_name||' '||
861: 'Business Plan: '||cr_t.plan_name||' '|| ' for '||

Line 871: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_EXRANGE');

867: l_responsibility_id := cr_t.Notify_Resp3_ID;
868: --dbms_output.put_line('Out of Third Range');
869: ELSIF l_actual < l_target
870: THEN
871: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_EXRANGE');
872: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
873: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
874: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
875: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

Line 872: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);

868: --dbms_output.put_line('Out of Third Range');
869: ELSIF l_actual < l_target
870: THEN
871: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_EXRANGE');
872: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
873: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
874: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
875: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
876: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

Line 873: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);

869: ELSIF l_actual < l_target
870: THEN
871: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_EXRANGE');
872: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
873: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
874: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
875: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
876: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
877: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

Line 874: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);

870: THEN
871: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_EXRANGE');
872: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
873: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
874: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
875: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
876: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
877: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
878: l_message := FND_MESSAGE.GET;

Line 875: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

871: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_EXRANGE');
872: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
873: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
874: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
875: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
876: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
877: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
878: l_message := FND_MESSAGE.GET;
879: /*

Line 876: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

872: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
873: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
874: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
875: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
876: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
877: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
878: l_message := FND_MESSAGE.GET;
879: /*
880: l_message := 'Excellent '||' '||

Line 877: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

873: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
874: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
875: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
876: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
877: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
878: l_message := FND_MESSAGE.GET;
879: /*
880: l_message := 'Excellent '||' '||
881: 'Target Level: '||cr_t.target_level_name||' '||

Line 878: l_message := FND_MESSAGE.GET;

874: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
875: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
876: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
877: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
878: l_message := FND_MESSAGE.GET;
879: /*
880: l_message := 'Excellent '||' '||
881: 'Target Level: '||cr_t.target_level_name||' '||
882: 'Business Plan: '||cr_t.plan_name||' '|| ' for '||

Line 894: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_INRANGE');

890: END IF;
891:
892: -- We're on target!!
893: ELSE
894: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_INRANGE');
895: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
896: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
897: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
898: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

Line 895: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);

891:
892: -- We're on target!!
893: ELSE
894: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_INRANGE');
895: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
896: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
897: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
898: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
899: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

Line 896: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);

892: -- We're on target!!
893: ELSE
894: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_INRANGE');
895: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
896: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
897: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
898: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
899: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
900: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

Line 897: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);

893: ELSE
894: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_INRANGE');
895: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
896: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
897: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
898: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
899: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
900: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
901: l_message := FND_MESSAGE.GET;

Line 898: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

894: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_INRANGE');
895: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
896: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
897: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
898: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
899: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
900: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
901: l_message := FND_MESSAGE.GET;
902: /*

Line 899: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

895: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
896: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
897: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
898: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
899: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
900: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
901: l_message := FND_MESSAGE.GET;
902: /*
903: l_message := 'Good job!!'||' '||

Line 900: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

896: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
897: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
898: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
899: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
900: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
901: l_message := FND_MESSAGE.GET;
902: /*
903: l_message := 'Good job!!'||' '||
904: 'Target Level: '||cr_t.target_level_name||' '||

Line 901: l_message := FND_MESSAGE.GET;

897: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
898: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
899: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
900: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
901: l_message := FND_MESSAGE.GET;
902: /*
903: l_message := 'Good job!!'||' '||
904: 'Target Level: '||cr_t.target_level_name||' '||
905: 'Business Plan: '||cr_t.plan_name||' '|| ' for '||

Line 1015: FND_MESSAGE.SET_NAME('BIX','BIX_OCCUPANCY_RATE');

1011: -- l_period_set_name := p_time_period;
1012: -- l_period_name := p_time_period;
1013: l_report := 'BIXOCCM0';
1014: /* get translated subject for notification */
1015: FND_MESSAGE.SET_NAME('BIX','BIX_OCCUPANCY_RATE');
1016: l_msg_subject := FND_MESSAGE.GET;
1017: if l_msg_subject is NULL THEN
1018: l_msg_subject := 'Occupancy Rate PMF Notification';
1019: end if;

Line 1016: l_msg_subject := FND_MESSAGE.GET;

1012: -- l_period_name := p_time_period;
1013: l_report := 'BIXOCCM0';
1014: /* get translated subject for notification */
1015: FND_MESSAGE.SET_NAME('BIX','BIX_OCCUPANCY_RATE');
1016: l_msg_subject := FND_MESSAGE.GET;
1017: if l_msg_subject is NULL THEN
1018: l_msg_subject := 'Occupancy Rate PMF Notification';
1019: end if;
1020: l_organization_id := -1;

Line 1084: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE1');

1080: cr_t.range2_low AND cr_t.range2_High
1081: AND l_actual BETWEEN
1082: cr_t.range1_low AND cr_t.range1_High
1083: THEN
1084: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE1');
1085: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1086: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1087: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1088: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

Line 1085: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);

1081: AND l_actual BETWEEN
1082: cr_t.range1_low AND cr_t.range1_High
1083: THEN
1084: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE1');
1085: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1086: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1087: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1088: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1089: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

Line 1086: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);

1082: cr_t.range1_low AND cr_t.range1_High
1083: THEN
1084: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE1');
1085: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1086: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1087: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1088: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1089: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1090: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

Line 1087: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);

1083: THEN
1084: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE1');
1085: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1086: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1087: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1088: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1089: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1090: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1091: l_message := FND_MESSAGE.GET;

Line 1088: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

1084: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE1');
1085: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1086: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1087: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1088: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1089: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1090: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1091: l_message := FND_MESSAGE.GET;
1092: /*

Line 1089: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

1085: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1086: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1087: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1088: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1089: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1090: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1091: l_message := FND_MESSAGE.GET;
1092: /*
1093: l_message := 'Hey! Something is wrong!'||' '||

Line 1090: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

1086: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1087: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1088: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1089: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1090: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1091: l_message := FND_MESSAGE.GET;
1092: /*
1093: l_message := 'Hey! Something is wrong!'||' '||
1094: 'Target Level: '||cr_t.target_level_name||' '||

Line 1091: l_message := FND_MESSAGE.GET;

1087: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1088: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1089: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1090: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1091: l_message := FND_MESSAGE.GET;
1092: /*
1093: l_message := 'Hey! Something is wrong!'||' '||
1094: 'Target Level: '||cr_t.target_level_name||' '||
1095: 'Business Plan: '||cr_t.plan_name||' '|| ' for '||

Line 1109: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE2');

1105: cr_t.range1_low AND cr_t.range1_High
1106: AND l_actual BETWEEN
1107: cr_t.range2_low AND cr_t.range2_High
1108: THEN
1109: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE2');
1110: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1111: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1112: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1113: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

Line 1110: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);

1106: AND l_actual BETWEEN
1107: cr_t.range2_low AND cr_t.range2_High
1108: THEN
1109: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE2');
1110: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1111: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1112: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1113: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1114: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

Line 1111: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);

1107: cr_t.range2_low AND cr_t.range2_High
1108: THEN
1109: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE2');
1110: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1111: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1112: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1113: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1114: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1115: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

Line 1112: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);

1108: THEN
1109: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE2');
1110: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1111: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1112: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1113: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1114: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1115: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1116: l_message := FND_MESSAGE.GET;

Line 1113: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

1109: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE2');
1110: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1111: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1112: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1113: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1114: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1115: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1116: l_message := FND_MESSAGE.GET;
1117: /*

Line 1114: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

1110: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1111: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1112: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1113: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1114: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1115: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1116: l_message := FND_MESSAGE.GET;
1117: /*
1118: l_message := 'Hey! Something is wrong!'||' '||

Line 1115: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

1111: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1112: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1113: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1114: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1115: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1116: l_message := FND_MESSAGE.GET;
1117: /*
1118: l_message := 'Hey! Something is wrong!'||' '||
1119: 'Target Level: '||cr_t.target_level_name||' '||

Line 1116: l_message := FND_MESSAGE.GET;

1112: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1113: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1114: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1115: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1116: l_message := FND_MESSAGE.GET;
1117: /*
1118: l_message := 'Hey! Something is wrong!'||' '||
1119: 'Target Level: '||cr_t.target_level_name||' '||
1120: 'Business Plan: '||cr_t.plan_name||' '|| ' for '||

Line 1135: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE3');

1131: cr_t.range2_low AND cr_t.range2_High
1132: AND l_actual BETWEEN
1133: cr_t.range3_low AND cr_t.range3_High
1134: THEN
1135: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE3');
1136: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1137: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1138: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1139: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

Line 1136: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);

1132: AND l_actual BETWEEN
1133: cr_t.range3_low AND cr_t.range3_High
1134: THEN
1135: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE3');
1136: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1137: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1138: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1139: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1140: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

Line 1137: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);

1133: cr_t.range3_low AND cr_t.range3_High
1134: THEN
1135: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE3');
1136: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1137: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1138: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1139: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1140: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1141: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

Line 1138: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);

1134: THEN
1135: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE3');
1136: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1137: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1138: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1139: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1140: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1141: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1142: l_message := FND_MESSAGE.GET;

Line 1139: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

1135: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE3');
1136: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1137: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1138: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1139: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1140: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1141: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1142: l_message := FND_MESSAGE.GET;
1143: /*

Line 1140: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

1136: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1137: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1138: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1139: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1140: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1141: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1142: l_message := FND_MESSAGE.GET;
1143: /*
1144: l_message := 'Hey! Something is VERY wrong!'||' '||

Line 1141: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

1137: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1138: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1139: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1140: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1141: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1142: l_message := FND_MESSAGE.GET;
1143: /*
1144: l_message := 'Hey! Something is VERY wrong!'||' '||
1145: 'Target Level: '||cr_t.target_level_name||' '||

Line 1142: l_message := FND_MESSAGE.GET;

1138: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1139: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1140: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1141: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1142: l_message := FND_MESSAGE.GET;
1143: /*
1144: l_message := 'Hey! Something is VERY wrong!'||' '||
1145: 'Target Level: '||cr_t.target_level_name||' '||
1146: 'Business Plan: '||cr_t.plan_name||' '|| ' for '||

Line 1159: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_OFFRANGE');

1155: ELSIF l_actual NOT BETWEEN
1156: cr_t.range3_low AND cr_t.range3_High
1157: AND l_actual < l_target
1158: THEN
1159: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_OFFRANGE');
1160: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1161: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1162: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1163: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

Line 1160: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);

1156: cr_t.range3_low AND cr_t.range3_High
1157: AND l_actual < l_target
1158: THEN
1159: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_OFFRANGE');
1160: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1161: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1162: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1163: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1164: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

Line 1161: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);

1157: AND l_actual < l_target
1158: THEN
1159: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_OFFRANGE');
1160: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1161: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1162: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1163: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1164: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1165: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

Line 1162: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);

1158: THEN
1159: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_OFFRANGE');
1160: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1161: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1162: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1163: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1164: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1165: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1166: l_message := FND_MESSAGE.GET;

Line 1163: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

1159: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_OFFRANGE');
1160: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1161: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1162: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1163: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1164: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1165: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1166: l_message := FND_MESSAGE.GET;
1167: /*

Line 1164: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

1160: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1161: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1162: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1163: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1164: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1165: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1166: l_message := FND_MESSAGE.GET;
1167: /*
1168: l_message := 'Hey! Something is VERY VERY wrong!'||' '||

Line 1165: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

1161: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1162: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1163: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1164: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1165: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1166: l_message := FND_MESSAGE.GET;
1167: /*
1168: l_message := 'Hey! Something is VERY VERY wrong!'||' '||
1169: 'Target Level: '||cr_t.target_level_name||' '||

Line 1166: l_message := FND_MESSAGE.GET;

1162: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1163: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1164: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1165: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1166: l_message := FND_MESSAGE.GET;
1167: /*
1168: l_message := 'Hey! Something is VERY VERY wrong!'||' '||
1169: 'Target Level: '||cr_t.target_level_name||' '||
1170: 'Business Plan: '||cr_t.plan_name||' '|| ' for '||

Line 1180: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_EXRANGE');

1176: l_responsibility_id := cr_t.Notify_Resp3_ID;
1177: --dbms_output.put_line('Out of Third Range');
1178: ELSIF l_actual > l_target
1179: THEN
1180: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_EXRANGE');
1181: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1182: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1183: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1184: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

Line 1181: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);

1177: --dbms_output.put_line('Out of Third Range');
1178: ELSIF l_actual > l_target
1179: THEN
1180: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_EXRANGE');
1181: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1182: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1183: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1184: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1185: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

Line 1182: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);

1178: ELSIF l_actual > l_target
1179: THEN
1180: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_EXRANGE');
1181: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1182: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1183: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1184: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1185: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1186: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

Line 1183: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);

1179: THEN
1180: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_EXRANGE');
1181: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1182: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1183: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1184: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1185: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1186: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1187: l_message := FND_MESSAGE.GET;

Line 1184: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

1180: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_EXRANGE');
1181: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1182: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1183: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1184: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1185: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1186: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1187: l_message := FND_MESSAGE.GET;
1188: /*

Line 1185: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

1181: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1182: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1183: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1184: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1185: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1186: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1187: l_message := FND_MESSAGE.GET;
1188: /*
1189: l_message := 'Excellent '||' '||

Line 1186: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

1182: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1183: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1184: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1185: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1186: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1187: l_message := FND_MESSAGE.GET;
1188: /*
1189: l_message := 'Excellent '||' '||
1190: 'Target Level: '||cr_t.target_level_name||' '||

Line 1187: l_message := FND_MESSAGE.GET;

1183: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1184: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1185: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1186: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1187: l_message := FND_MESSAGE.GET;
1188: /*
1189: l_message := 'Excellent '||' '||
1190: 'Target Level: '||cr_t.target_level_name||' '||
1191: 'Business Plan: '||cr_t.plan_name||' '|| ' for '||

Line 1203: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_INRANGE');

1199: END IF;
1200:
1201: -- We're on target!!
1202: ELSE
1203: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_INRANGE');
1204: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1205: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1206: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1207: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

Line 1204: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);

1200:
1201: -- We're on target!!
1202: ELSE
1203: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_INRANGE');
1204: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1205: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1206: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1207: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1208: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

Line 1205: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);

1201: -- We're on target!!
1202: ELSE
1203: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_INRANGE');
1204: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1205: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1206: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1207: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1208: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1209: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

Line 1206: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);

1202: ELSE
1203: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_INRANGE');
1204: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1205: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1206: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1207: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1208: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1209: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1210: l_message := FND_MESSAGE.GET;

Line 1207: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

1203: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_INRANGE');
1204: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1205: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1206: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1207: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1208: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1209: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1210: l_message := FND_MESSAGE.GET;
1211: /*

Line 1208: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

1204: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1205: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1206: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1207: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1208: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1209: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1210: l_message := FND_MESSAGE.GET;
1211: /*
1212: l_message := 'Good job!!'||' '||

Line 1209: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

1205: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1206: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1207: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1208: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1209: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1210: l_message := FND_MESSAGE.GET;
1211: /*
1212: l_message := 'Good job!!'||' '||
1213: 'Target Level: '||cr_t.target_level_name||' '||

Line 1210: l_message := FND_MESSAGE.GET;

1206: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1207: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1208: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1209: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1210: l_message := FND_MESSAGE.GET;
1211: /*
1212: l_message := 'Good job!!'||' '||
1213: 'Target Level: '||cr_t.target_level_name||' '||
1214: 'Business Plan: '||cr_t.plan_name||' '|| ' for '||

Line 1320: FND_MESSAGE.SET_NAME('BIX', 'BIX_AVG_TALK_TIME');

1316: := p_target_Level_Short_Name;
1317: -- l_period_set_name := p_time_period;
1318: -- l_period_name := p_time_period;
1319: l_report := 'BIXATLK0';
1320: FND_MESSAGE.SET_NAME('BIX', 'BIX_AVG_TALK_TIME');
1321: l_msg_subject := FND_MESSAGE.GET;
1322: IF l_msg_subject is NULL then
1323: l_msg_subject := 'Average Talk Time PMF Notification';
1324: END IF;

Line 1321: l_msg_subject := FND_MESSAGE.GET;

1317: -- l_period_set_name := p_time_period;
1318: -- l_period_name := p_time_period;
1319: l_report := 'BIXATLK0';
1320: FND_MESSAGE.SET_NAME('BIX', 'BIX_AVG_TALK_TIME');
1321: l_msg_subject := FND_MESSAGE.GET;
1322: IF l_msg_subject is NULL then
1323: l_msg_subject := 'Average Talk Time PMF Notification';
1324: END IF;
1325: l_organization_id := -1;

Line 1389: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE1');

1385: cr_t.range2_low AND cr_t.range2_High
1386: AND l_actual BETWEEN
1387: cr_t.range1_low AND cr_t.range1_High
1388: THEN
1389: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE1');
1390: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1391: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1392: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1393: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

Line 1390: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);

1386: AND l_actual BETWEEN
1387: cr_t.range1_low AND cr_t.range1_High
1388: THEN
1389: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE1');
1390: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1391: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1392: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1393: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1394: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

Line 1391: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);

1387: cr_t.range1_low AND cr_t.range1_High
1388: THEN
1389: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE1');
1390: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1391: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1392: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1393: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1394: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1395: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

Line 1392: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);

1388: THEN
1389: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE1');
1390: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1391: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1392: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1393: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1394: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1395: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1396: l_message := FND_MESSAGE.GET;

Line 1393: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

1389: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE1');
1390: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1391: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1392: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1393: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1394: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1395: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1396: l_message := FND_MESSAGE.GET;
1397: l_notify_resp := cr_t.Notify_Resp1_short_name;

Line 1394: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

1390: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1391: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1392: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1393: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1394: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1395: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1396: l_message := FND_MESSAGE.GET;
1397: l_notify_resp := cr_t.Notify_Resp1_short_name;
1398: l_responsibility_id := cr_t.Notify_Resp1_ID;

Line 1395: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

1391: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1392: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1393: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1394: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1395: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1396: l_message := FND_MESSAGE.GET;
1397: l_notify_resp := cr_t.Notify_Resp1_short_name;
1398: l_responsibility_id := cr_t.Notify_Resp1_ID;
1399: -- dbms_output.put_line('In First Range' || l_message);

Line 1396: l_message := FND_MESSAGE.GET;

1392: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1393: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1394: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1395: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1396: l_message := FND_MESSAGE.GET;
1397: l_notify_resp := cr_t.Notify_Resp1_short_name;
1398: l_responsibility_id := cr_t.Notify_Resp1_ID;
1399: -- dbms_output.put_line('In First Range' || l_message);
1400: -- Check if actual is within the second range

Line 1406: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE2');

1402: cr_t.range1_low AND cr_t.range1_High
1403: AND l_actual BETWEEN
1404: cr_t.range2_low AND cr_t.range2_High
1405: THEN
1406: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE2');
1407: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1408: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1409: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1410: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

Line 1407: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);

1403: AND l_actual BETWEEN
1404: cr_t.range2_low AND cr_t.range2_High
1405: THEN
1406: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE2');
1407: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1408: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1409: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1410: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1411: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

Line 1408: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);

1404: cr_t.range2_low AND cr_t.range2_High
1405: THEN
1406: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE2');
1407: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1408: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1409: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1410: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1411: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1412: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

Line 1409: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);

1405: THEN
1406: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE2');
1407: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1408: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1409: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1410: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1411: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1412: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1413: l_message := FND_MESSAGE.GET;

Line 1410: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

1406: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE2');
1407: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1408: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1409: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1410: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1411: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1412: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1413: l_message := FND_MESSAGE.GET;
1414: l_notify_resp := cr_t.Notify_Resp1_short_name;

Line 1411: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

1407: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1408: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1409: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1410: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1411: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1412: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1413: l_message := FND_MESSAGE.GET;
1414: l_notify_resp := cr_t.Notify_Resp1_short_name;
1415: l_responsibility_id := cr_t.Notify_Resp1_ID;

Line 1412: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

1408: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1409: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1410: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1411: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1412: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1413: l_message := FND_MESSAGE.GET;
1414: l_notify_resp := cr_t.Notify_Resp1_short_name;
1415: l_responsibility_id := cr_t.Notify_Resp1_ID;
1416: --dbms_output.put_line('In Second Range');

Line 1413: l_message := FND_MESSAGE.GET;

1409: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1410: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1411: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1412: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1413: l_message := FND_MESSAGE.GET;
1414: l_notify_resp := cr_t.Notify_Resp1_short_name;
1415: l_responsibility_id := cr_t.Notify_Resp1_ID;
1416: --dbms_output.put_line('In Second Range');
1417: -- Check if actual is within the third range

Line 1423: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE3');

1419: cr_t.range2_low AND cr_t.range2_High
1420: AND l_actual BETWEEN
1421: cr_t.range3_low AND cr_t.range3_High
1422: THEN
1423: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE3');
1424: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1425: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1426: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1427: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

Line 1424: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);

1420: AND l_actual BETWEEN
1421: cr_t.range3_low AND cr_t.range3_High
1422: THEN
1423: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE3');
1424: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1425: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1426: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1427: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1428: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

Line 1425: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);

1421: cr_t.range3_low AND cr_t.range3_High
1422: THEN
1423: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE3');
1424: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1425: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1426: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1427: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1428: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1429: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

Line 1426: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);

1422: THEN
1423: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE3');
1424: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1425: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1426: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1427: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1428: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1429: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1430: l_message := FND_MESSAGE.GET;

Line 1427: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

1423: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE3');
1424: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1425: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1426: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1427: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1428: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1429: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1430: l_message := FND_MESSAGE.GET;
1431: l_notify_resp := cr_t.Notify_Resp2_short_name;

Line 1428: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

1424: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1425: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1426: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1427: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1428: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1429: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1430: l_message := FND_MESSAGE.GET;
1431: l_notify_resp := cr_t.Notify_Resp2_short_name;
1432: l_responsibility_id := cr_t.Notify_Resp2_ID;

Line 1429: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

1425: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1426: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1427: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1428: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1429: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1430: l_message := FND_MESSAGE.GET;
1431: l_notify_resp := cr_t.Notify_Resp2_short_name;
1432: l_responsibility_id := cr_t.Notify_Resp2_ID;
1433: --dbms_output.put_line('In Third Range');

Line 1430: l_message := FND_MESSAGE.GET;

1426: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1427: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1428: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1429: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1430: l_message := FND_MESSAGE.GET;
1431: l_notify_resp := cr_t.Notify_Resp2_short_name;
1432: l_responsibility_id := cr_t.Notify_Resp2_ID;
1433: --dbms_output.put_line('In Third Range');
1434: -- Check if actual is outside the third range

Line 1439: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_OFFRANGE');

1435: ELSIF l_actual NOT BETWEEN
1436: cr_t.range3_low AND cr_t.range3_High
1437: AND l_actual > l_target
1438: THEN
1439: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_OFFRANGE');
1440: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1441: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1442: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1443: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

Line 1440: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);

1436: cr_t.range3_low AND cr_t.range3_High
1437: AND l_actual > l_target
1438: THEN
1439: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_OFFRANGE');
1440: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1441: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1442: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1443: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1444: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

Line 1441: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);

1437: AND l_actual > l_target
1438: THEN
1439: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_OFFRANGE');
1440: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1441: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1442: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1443: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1444: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1445: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

Line 1442: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);

1438: THEN
1439: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_OFFRANGE');
1440: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1441: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1442: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1443: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1444: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1445: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1446: l_message := FND_MESSAGE.GET;

Line 1443: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

1439: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_OFFRANGE');
1440: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1441: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1442: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1443: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1444: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1445: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1446: l_message := FND_MESSAGE.GET;
1447: l_notify_resp := cr_t.Notify_Resp3_short_name;

Line 1444: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

1440: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1441: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1442: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1443: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1444: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1445: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1446: l_message := FND_MESSAGE.GET;
1447: l_notify_resp := cr_t.Notify_Resp3_short_name;
1448: l_responsibility_id := cr_t.Notify_Resp3_ID;

Line 1445: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

1441: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1442: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1443: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1444: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1445: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1446: l_message := FND_MESSAGE.GET;
1447: l_notify_resp := cr_t.Notify_Resp3_short_name;
1448: l_responsibility_id := cr_t.Notify_Resp3_ID;
1449: --dbms_output.put_line('Out of Third Range');

Line 1446: l_message := FND_MESSAGE.GET;

1442: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1443: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1444: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1445: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1446: l_message := FND_MESSAGE.GET;
1447: l_notify_resp := cr_t.Notify_Resp3_short_name;
1448: l_responsibility_id := cr_t.Notify_Resp3_ID;
1449: --dbms_output.put_line('Out of Third Range');
1450: ELSIF l_actual < l_target

Line 1452: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_EXRANGE');

1448: l_responsibility_id := cr_t.Notify_Resp3_ID;
1449: --dbms_output.put_line('Out of Third Range');
1450: ELSIF l_actual < l_target
1451: THEN
1452: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_EXRANGE');
1453: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1454: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1455: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1456: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

Line 1453: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);

1449: --dbms_output.put_line('Out of Third Range');
1450: ELSIF l_actual < l_target
1451: THEN
1452: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_EXRANGE');
1453: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1454: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1455: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1456: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1457: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

Line 1454: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);

1450: ELSIF l_actual < l_target
1451: THEN
1452: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_EXRANGE');
1453: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1454: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1455: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1456: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1457: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1458: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

Line 1455: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);

1451: THEN
1452: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_EXRANGE');
1453: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1454: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1455: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1456: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1457: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1458: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1459: l_message := FND_MESSAGE.GET;

Line 1456: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

1452: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_EXRANGE');
1453: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1454: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1455: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1456: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1457: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1458: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1459: l_message := FND_MESSAGE.GET;
1460: l_notify_resp := cr_t.Notify_Resp3_short_name;

Line 1457: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

1453: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1454: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1455: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1456: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1457: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1458: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1459: l_message := FND_MESSAGE.GET;
1460: l_notify_resp := cr_t.Notify_Resp3_short_name;
1461: l_responsibility_id := cr_t.Notify_Resp3_ID;

Line 1458: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

1454: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1455: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1456: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1457: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1458: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1459: l_message := FND_MESSAGE.GET;
1460: l_notify_resp := cr_t.Notify_Resp3_short_name;
1461: l_responsibility_id := cr_t.Notify_Resp3_ID;
1462: --dbms_output.put_line('less than First Range');

Line 1459: l_message := FND_MESSAGE.GET;

1455: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1456: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1457: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1458: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1459: l_message := FND_MESSAGE.GET;
1460: l_notify_resp := cr_t.Notify_Resp3_short_name;
1461: l_responsibility_id := cr_t.Notify_Resp3_ID;
1462: --dbms_output.put_line('less than First Range');
1463: END IF;

Line 1467: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_INRANGE');

1463: END IF;
1464:
1465: -- We're on target!!
1466: ELSE
1467: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_INRANGE');
1468: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1469: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1470: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1471: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

Line 1468: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);

1464:
1465: -- We're on target!!
1466: ELSE
1467: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_INRANGE');
1468: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1469: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1470: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1471: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1472: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

Line 1469: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);

1465: -- We're on target!!
1466: ELSE
1467: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_INRANGE');
1468: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1469: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1470: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1471: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1472: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1473: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

Line 1470: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);

1466: ELSE
1467: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_INRANGE');
1468: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1469: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1470: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1471: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1472: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1473: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1474: l_message := FND_MESSAGE.GET;

Line 1471: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

1467: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_INRANGE');
1468: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1469: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1470: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1471: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1472: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1473: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1474: l_message := FND_MESSAGE.GET;
1475: l_notify_resp := cr_t.Notify_Resp1_short_name;

Line 1472: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

1468: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1469: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1470: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1471: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1472: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1473: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1474: l_message := FND_MESSAGE.GET;
1475: l_notify_resp := cr_t.Notify_Resp1_short_name;
1476: l_responsibility_id := cr_t.Notify_Resp1_ID;

Line 1473: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

1469: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1470: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1471: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1472: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1473: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1474: l_message := FND_MESSAGE.GET;
1475: l_notify_resp := cr_t.Notify_Resp1_short_name;
1476: l_responsibility_id := cr_t.Notify_Resp1_ID;
1477: END IF;

Line 1474: l_message := FND_MESSAGE.GET;

1470: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1471: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1472: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1473: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1474: l_message := FND_MESSAGE.GET;
1475: l_notify_resp := cr_t.Notify_Resp1_short_name;
1476: l_responsibility_id := cr_t.Notify_Resp1_ID;
1477: END IF;
1478: /*

Line 1579: FND_MESSAGE.SET_NAME('BIX', 'BIX_AVG_WAIT_TO_ABANDON');

1575: := p_target_Level_Short_Name;
1576: -- l_period_set_name := p_time_period;
1577: -- l_period_name := p_time_period;
1578: l_report := 'BIXWABC0';
1579: FND_MESSAGE.SET_NAME('BIX', 'BIX_AVG_WAIT_TO_ABANDON');
1580: l_msg_subject := FND_MESSAGE.GET;
1581: IF l_msg_subject is NULL then
1582: l_msg_subject := 'Average Wait Time to Abandon PMF Notification';
1583: END IF;

Line 1580: l_msg_subject := FND_MESSAGE.GET;

1576: -- l_period_set_name := p_time_period;
1577: -- l_period_name := p_time_period;
1578: l_report := 'BIXWABC0';
1579: FND_MESSAGE.SET_NAME('BIX', 'BIX_AVG_WAIT_TO_ABANDON');
1580: l_msg_subject := FND_MESSAGE.GET;
1581: IF l_msg_subject is NULL then
1582: l_msg_subject := 'Average Wait Time to Abandon PMF Notification';
1583: END IF;
1584: l_organization_id := -1;

Line 1650: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE1');

1646: cr_t.range2_low AND cr_t.range2_High
1647: AND l_actual BETWEEN
1648: cr_t.range1_low AND cr_t.range1_High
1649: THEN
1650: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE1');
1651: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1652: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1653: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1654: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

Line 1651: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);

1647: AND l_actual BETWEEN
1648: cr_t.range1_low AND cr_t.range1_High
1649: THEN
1650: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE1');
1651: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1652: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1653: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1654: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1655: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

Line 1652: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);

1648: cr_t.range1_low AND cr_t.range1_High
1649: THEN
1650: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE1');
1651: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1652: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1653: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1654: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1655: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1656: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

Line 1653: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);

1649: THEN
1650: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE1');
1651: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1652: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1653: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1654: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1655: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1656: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1657: l_message := FND_MESSAGE.GET;

Line 1654: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

1650: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE1');
1651: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1652: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1653: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1654: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1655: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1656: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1657: l_message := FND_MESSAGE.GET;
1658: l_notify_resp := cr_t.Notify_Resp1_short_name;

Line 1655: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

1651: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1652: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1653: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1654: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1655: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1656: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1657: l_message := FND_MESSAGE.GET;
1658: l_notify_resp := cr_t.Notify_Resp1_short_name;
1659: l_responsibility_id := cr_t.Notify_Resp1_ID;

Line 1656: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

1652: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1653: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1654: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1655: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1656: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1657: l_message := FND_MESSAGE.GET;
1658: l_notify_resp := cr_t.Notify_Resp1_short_name;
1659: l_responsibility_id := cr_t.Notify_Resp1_ID;
1660: -- dbms_output.put_line('In First Range' || l_message);

Line 1657: l_message := FND_MESSAGE.GET;

1653: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1654: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1655: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1656: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1657: l_message := FND_MESSAGE.GET;
1658: l_notify_resp := cr_t.Notify_Resp1_short_name;
1659: l_responsibility_id := cr_t.Notify_Resp1_ID;
1660: -- dbms_output.put_line('In First Range' || l_message);
1661: -- Check if actual is within the second range

Line 1667: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE2');

1663: cr_t.range1_low AND cr_t.range1_High
1664: AND l_actual BETWEEN
1665: cr_t.range2_low AND cr_t.range2_High
1666: THEN
1667: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE2');
1668: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1669: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1670: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1671: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

Line 1668: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);

1664: AND l_actual BETWEEN
1665: cr_t.range2_low AND cr_t.range2_High
1666: THEN
1667: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE2');
1668: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1669: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1670: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1671: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1672: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

Line 1669: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);

1665: cr_t.range2_low AND cr_t.range2_High
1666: THEN
1667: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE2');
1668: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1669: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1670: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1671: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1672: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1673: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

Line 1670: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);

1666: THEN
1667: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE2');
1668: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1669: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1670: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1671: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1672: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1673: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1674: l_message := FND_MESSAGE.GET;

Line 1671: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

1667: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE2');
1668: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1669: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1670: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1671: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1672: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1673: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1674: l_message := FND_MESSAGE.GET;
1675: l_notify_resp := cr_t.Notify_Resp1_short_name;

Line 1672: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

1668: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1669: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1670: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1671: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1672: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1673: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1674: l_message := FND_MESSAGE.GET;
1675: l_notify_resp := cr_t.Notify_Resp1_short_name;
1676: l_responsibility_id := cr_t.Notify_Resp1_ID;

Line 1673: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

1669: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1670: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1671: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1672: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1673: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1674: l_message := FND_MESSAGE.GET;
1675: l_notify_resp := cr_t.Notify_Resp1_short_name;
1676: l_responsibility_id := cr_t.Notify_Resp1_ID;
1677: --dbms_output.put_line('In Second Range');

Line 1674: l_message := FND_MESSAGE.GET;

1670: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1671: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1672: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1673: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1674: l_message := FND_MESSAGE.GET;
1675: l_notify_resp := cr_t.Notify_Resp1_short_name;
1676: l_responsibility_id := cr_t.Notify_Resp1_ID;
1677: --dbms_output.put_line('In Second Range');
1678: -- Check if actual is within the third range

Line 1685: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE3');

1681: cr_t.range2_low AND cr_t.range2_High
1682: AND l_actual BETWEEN
1683: cr_t.range3_low AND cr_t.range3_High
1684: THEN
1685: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE3');
1686: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1687: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1688: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1689: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

Line 1686: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);

1682: AND l_actual BETWEEN
1683: cr_t.range3_low AND cr_t.range3_High
1684: THEN
1685: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE3');
1686: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1687: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1688: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1689: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1690: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

Line 1687: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);

1683: cr_t.range3_low AND cr_t.range3_High
1684: THEN
1685: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE3');
1686: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1687: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1688: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1689: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1690: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1691: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

Line 1688: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);

1684: THEN
1685: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE3');
1686: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1687: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1688: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1689: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1690: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1691: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1692: l_message := FND_MESSAGE.GET;

Line 1689: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

1685: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE3');
1686: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1687: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1688: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1689: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1690: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1691: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1692: l_message := FND_MESSAGE.GET;
1693: l_notify_resp := cr_t.Notify_Resp2_short_name;

Line 1690: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

1686: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1687: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1688: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1689: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1690: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1691: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1692: l_message := FND_MESSAGE.GET;
1693: l_notify_resp := cr_t.Notify_Resp2_short_name;
1694: l_responsibility_id := cr_t.Notify_Resp2_ID;

Line 1691: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

1687: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1688: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1689: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1690: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1691: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1692: l_message := FND_MESSAGE.GET;
1693: l_notify_resp := cr_t.Notify_Resp2_short_name;
1694: l_responsibility_id := cr_t.Notify_Resp2_ID;
1695: --dbms_output.put_line('In Third Range');

Line 1692: l_message := FND_MESSAGE.GET;

1688: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1689: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1690: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1691: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1692: l_message := FND_MESSAGE.GET;
1693: l_notify_resp := cr_t.Notify_Resp2_short_name;
1694: l_responsibility_id := cr_t.Notify_Resp2_ID;
1695: --dbms_output.put_line('In Third Range');
1696: -- Check if actual is outside the third range

Line 1701: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_OFFRANGE');

1697: ELSIF l_actual NOT BETWEEN
1698: cr_t.range3_low AND cr_t.range3_High
1699: AND l_actual > l_target
1700: THEN
1701: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_OFFRANGE');
1702: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1703: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1704: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1705: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

Line 1702: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);

1698: cr_t.range3_low AND cr_t.range3_High
1699: AND l_actual > l_target
1700: THEN
1701: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_OFFRANGE');
1702: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1703: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1704: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1705: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1706: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

Line 1703: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);

1699: AND l_actual > l_target
1700: THEN
1701: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_OFFRANGE');
1702: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1703: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1704: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1705: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1706: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1707: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

Line 1704: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);

1700: THEN
1701: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_OFFRANGE');
1702: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1703: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1704: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1705: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1706: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1707: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1708: l_message := FND_MESSAGE.GET;

Line 1705: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

1701: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_OFFRANGE');
1702: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1703: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1704: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1705: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1706: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1707: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1708: l_message := FND_MESSAGE.GET;
1709: l_notify_resp := cr_t.Notify_Resp3_short_name;

Line 1706: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

1702: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1703: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1704: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1705: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1706: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1707: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1708: l_message := FND_MESSAGE.GET;
1709: l_notify_resp := cr_t.Notify_Resp3_short_name;
1710: l_responsibility_id := cr_t.Notify_Resp3_ID;

Line 1707: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

1703: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1704: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1705: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1706: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1707: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1708: l_message := FND_MESSAGE.GET;
1709: l_notify_resp := cr_t.Notify_Resp3_short_name;
1710: l_responsibility_id := cr_t.Notify_Resp3_ID;
1711: --dbms_output.put_line('Out of Third Range');

Line 1708: l_message := FND_MESSAGE.GET;

1704: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1705: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1706: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1707: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1708: l_message := FND_MESSAGE.GET;
1709: l_notify_resp := cr_t.Notify_Resp3_short_name;
1710: l_responsibility_id := cr_t.Notify_Resp3_ID;
1711: --dbms_output.put_line('Out of Third Range');
1712: ELSIF l_actual < l_target

Line 1714: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_EXRANGE');

1710: l_responsibility_id := cr_t.Notify_Resp3_ID;
1711: --dbms_output.put_line('Out of Third Range');
1712: ELSIF l_actual < l_target
1713: THEN
1714: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_EXRANGE');
1715: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1716: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1717: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1718: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

Line 1715: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);

1711: --dbms_output.put_line('Out of Third Range');
1712: ELSIF l_actual < l_target
1713: THEN
1714: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_EXRANGE');
1715: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1716: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1717: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1718: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1719: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

Line 1716: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);

1712: ELSIF l_actual < l_target
1713: THEN
1714: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_EXRANGE');
1715: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1716: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1717: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1718: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1719: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1720: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

Line 1717: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);

1713: THEN
1714: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_EXRANGE');
1715: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1716: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1717: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1718: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1719: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1720: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1721: l_message := FND_MESSAGE.GET;

Line 1718: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

1714: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_EXRANGE');
1715: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1716: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1717: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1718: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1719: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1720: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1721: l_message := FND_MESSAGE.GET;
1722: l_notify_resp := cr_t.Notify_Resp3_short_name;

Line 1719: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

1715: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1716: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1717: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1718: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1719: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1720: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1721: l_message := FND_MESSAGE.GET;
1722: l_notify_resp := cr_t.Notify_Resp3_short_name;
1723: l_responsibility_id := cr_t.Notify_Resp3_ID;

Line 1720: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

1716: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1717: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1718: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1719: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1720: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1721: l_message := FND_MESSAGE.GET;
1722: l_notify_resp := cr_t.Notify_Resp3_short_name;
1723: l_responsibility_id := cr_t.Notify_Resp3_ID;
1724:

Line 1721: l_message := FND_MESSAGE.GET;

1717: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1718: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1719: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1720: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1721: l_message := FND_MESSAGE.GET;
1722: l_notify_resp := cr_t.Notify_Resp3_short_name;
1723: l_responsibility_id := cr_t.Notify_Resp3_ID;
1724:
1725: --dbms_output.put_line('less than First Range');

Line 1730: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_INRANGE');

1726: END IF;
1727:
1728: -- We're on target!!
1729: ELSE
1730: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_INRANGE');
1731: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1732: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1733: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1734: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

Line 1731: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);

1727:
1728: -- We're on target!!
1729: ELSE
1730: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_INRANGE');
1731: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1732: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1733: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1734: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1735: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

Line 1732: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);

1728: -- We're on target!!
1729: ELSE
1730: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_INRANGE');
1731: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1732: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1733: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1734: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1735: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1736: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

Line 1733: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);

1729: ELSE
1730: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_INRANGE');
1731: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1732: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1733: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1734: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1735: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1736: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1737: l_message := FND_MESSAGE.GET;

Line 1734: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

1730: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_INRANGE');
1731: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1732: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1733: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1734: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1735: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1736: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1737: l_message := FND_MESSAGE.GET;
1738: l_notify_resp := cr_t.Notify_Resp1_short_name;

Line 1735: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

1731: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1732: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1733: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1734: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1735: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1736: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1737: l_message := FND_MESSAGE.GET;
1738: l_notify_resp := cr_t.Notify_Resp1_short_name;
1739: l_responsibility_id := cr_t.Notify_Resp1_ID;

Line 1736: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

1732: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1733: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1734: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1735: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1736: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1737: l_message := FND_MESSAGE.GET;
1738: l_notify_resp := cr_t.Notify_Resp1_short_name;
1739: l_responsibility_id := cr_t.Notify_Resp1_ID;
1740: END IF;

Line 1737: l_message := FND_MESSAGE.GET;

1733: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1734: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1735: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1736: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1737: l_message := FND_MESSAGE.GET;
1738: l_notify_resp := cr_t.Notify_Resp1_short_name;
1739: l_responsibility_id := cr_t.Notify_Resp1_ID;
1740: END IF;
1741: /*

Line 1842: FND_MESSAGE.SET_NAME('BIX', 'BIX_UTIL_RATE');

1838: := p_target_Level_Short_Name;
1839: -- l_period_set_name := p_time_period;
1840: -- l_period_name := p_time_period;
1841: l_report := 'BIXUTLM0';
1842: FND_MESSAGE.SET_NAME('BIX', 'BIX_UTIL_RATE');
1843: l_msg_subject := FND_MESSAGE.GET;
1844: IF l_msg_subject is NULL then
1845: l_msg_subject := 'Utilization Rate PMF Notification';
1846: END IF;

Line 1843: l_msg_subject := FND_MESSAGE.GET;

1839: -- l_period_set_name := p_time_period;
1840: -- l_period_name := p_time_period;
1841: l_report := 'BIXUTLM0';
1842: FND_MESSAGE.SET_NAME('BIX', 'BIX_UTIL_RATE');
1843: l_msg_subject := FND_MESSAGE.GET;
1844: IF l_msg_subject is NULL then
1845: l_msg_subject := 'Utilization Rate PMF Notification';
1846: END IF;
1847: --dbms_output.put_line('In First Range' || l_message);

Line 1914: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE1');

1910: cr_t.range2_low AND cr_t.range2_High
1911: AND l_actual BETWEEN
1912: cr_t.range1_low AND cr_t.range1_High
1913: THEN
1914: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE1');
1915: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1916: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1917: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1918: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

Line 1915: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);

1911: AND l_actual BETWEEN
1912: cr_t.range1_low AND cr_t.range1_High
1913: THEN
1914: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE1');
1915: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1916: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1917: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1918: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1919: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

Line 1916: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);

1912: cr_t.range1_low AND cr_t.range1_High
1913: THEN
1914: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE1');
1915: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1916: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1917: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1918: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1919: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1920: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

Line 1917: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);

1913: THEN
1914: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE1');
1915: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1916: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1917: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1918: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1919: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1920: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1921: l_message := FND_MESSAGE.GET;

Line 1918: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

1914: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE1');
1915: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1916: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1917: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1918: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1919: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1920: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1921: l_message := FND_MESSAGE.GET;
1922: l_notify_resp := cr_t.Notify_Resp1_short_name;

Line 1919: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

1915: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1916: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1917: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1918: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1919: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1920: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1921: l_message := FND_MESSAGE.GET;
1922: l_notify_resp := cr_t.Notify_Resp1_short_name;
1923: l_responsibility_id := cr_t.Notify_Resp1_ID;

Line 1920: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

1916: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1917: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1918: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1919: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1920: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1921: l_message := FND_MESSAGE.GET;
1922: l_notify_resp := cr_t.Notify_Resp1_short_name;
1923: l_responsibility_id := cr_t.Notify_Resp1_ID;
1924: -- dbms_output.put_line('In First Range' || l_message);

Line 1921: l_message := FND_MESSAGE.GET;

1917: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1918: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1919: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1920: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1921: l_message := FND_MESSAGE.GET;
1922: l_notify_resp := cr_t.Notify_Resp1_short_name;
1923: l_responsibility_id := cr_t.Notify_Resp1_ID;
1924: -- dbms_output.put_line('In First Range' || l_message);
1925: -- Check if actual is within the second range

Line 1931: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE2');

1927: cr_t.range1_low AND cr_t.range1_High
1928: AND l_actual BETWEEN
1929: cr_t.range2_low AND cr_t.range2_High
1930: THEN
1931: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE2');
1932: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1933: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1934: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1935: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

Line 1932: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);

1928: AND l_actual BETWEEN
1929: cr_t.range2_low AND cr_t.range2_High
1930: THEN
1931: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE2');
1932: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1933: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1934: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1935: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1936: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

Line 1933: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);

1929: cr_t.range2_low AND cr_t.range2_High
1930: THEN
1931: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE2');
1932: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1933: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1934: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1935: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1936: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1937: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

Line 1934: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);

1930: THEN
1931: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE2');
1932: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1933: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1934: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1935: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1936: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1937: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1938: l_message := FND_MESSAGE.GET;

Line 1935: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

1931: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE2');
1932: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1933: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1934: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1935: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1936: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1937: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1938: l_message := FND_MESSAGE.GET;
1939: l_notify_resp := cr_t.Notify_Resp1_short_name;

Line 1936: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

1932: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1933: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1934: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1935: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1936: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1937: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1938: l_message := FND_MESSAGE.GET;
1939: l_notify_resp := cr_t.Notify_Resp1_short_name;
1940: l_responsibility_id := cr_t.Notify_Resp1_ID;

Line 1937: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

1933: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1934: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1935: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1936: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1937: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1938: l_message := FND_MESSAGE.GET;
1939: l_notify_resp := cr_t.Notify_Resp1_short_name;
1940: l_responsibility_id := cr_t.Notify_Resp1_ID;
1941: --dbms_output.put_line('In Second Range');

Line 1938: l_message := FND_MESSAGE.GET;

1934: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1935: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1936: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1937: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1938: l_message := FND_MESSAGE.GET;
1939: l_notify_resp := cr_t.Notify_Resp1_short_name;
1940: l_responsibility_id := cr_t.Notify_Resp1_ID;
1941: --dbms_output.put_line('In Second Range');
1942: -- Check if actual is within the third range

Line 1949: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE3');

1945: cr_t.range2_low AND cr_t.range2_High
1946: AND l_actual BETWEEN
1947: cr_t.range3_low AND cr_t.range3_High
1948: THEN
1949: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE3');
1950: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1951: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1952: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1953: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

Line 1950: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);

1946: AND l_actual BETWEEN
1947: cr_t.range3_low AND cr_t.range3_High
1948: THEN
1949: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE3');
1950: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1951: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1952: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1953: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1954: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

Line 1951: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);

1947: cr_t.range3_low AND cr_t.range3_High
1948: THEN
1949: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE3');
1950: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1951: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1952: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1953: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1954: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1955: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

Line 1952: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);

1948: THEN
1949: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE3');
1950: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1951: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1952: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1953: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1954: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1955: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1956: l_message := FND_MESSAGE.GET;

Line 1953: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

1949: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE3');
1950: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1951: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1952: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1953: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1954: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1955: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1956: l_message := FND_MESSAGE.GET;
1957: l_notify_resp := cr_t.Notify_Resp2_short_name;

Line 1954: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

1950: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1951: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1952: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1953: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1954: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1955: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1956: l_message := FND_MESSAGE.GET;
1957: l_notify_resp := cr_t.Notify_Resp2_short_name;
1958: l_responsibility_id := cr_t.Notify_Resp2_ID;

Line 1955: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

1951: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1952: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1953: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1954: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1955: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1956: l_message := FND_MESSAGE.GET;
1957: l_notify_resp := cr_t.Notify_Resp2_short_name;
1958: l_responsibility_id := cr_t.Notify_Resp2_ID;
1959: --dbms_output.put_line('In Third Range');

Line 1956: l_message := FND_MESSAGE.GET;

1952: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1953: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1954: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1955: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1956: l_message := FND_MESSAGE.GET;
1957: l_notify_resp := cr_t.Notify_Resp2_short_name;
1958: l_responsibility_id := cr_t.Notify_Resp2_ID;
1959: --dbms_output.put_line('In Third Range');
1960: -- Check if actual is outside the third range

Line 1965: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_OFFRANGE');

1961: ELSIF l_actual NOT BETWEEN
1962: cr_t.range3_low AND cr_t.range3_High
1963: AND l_actual < l_target
1964: THEN
1965: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_OFFRANGE');
1966: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1967: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1968: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1969: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

Line 1966: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);

1962: cr_t.range3_low AND cr_t.range3_High
1963: AND l_actual < l_target
1964: THEN
1965: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_OFFRANGE');
1966: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1967: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1968: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1969: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1970: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

Line 1967: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);

1963: AND l_actual < l_target
1964: THEN
1965: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_OFFRANGE');
1966: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1967: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1968: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1969: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1970: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1971: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

Line 1968: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);

1964: THEN
1965: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_OFFRANGE');
1966: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1967: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1968: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1969: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1970: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1971: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1972: l_message := FND_MESSAGE.GET;

Line 1969: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

1965: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_OFFRANGE');
1966: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1967: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1968: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1969: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1970: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1971: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1972: l_message := FND_MESSAGE.GET;
1973: l_notify_resp := cr_t.Notify_Resp3_short_name;

Line 1970: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

1966: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1967: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1968: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1969: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1970: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1971: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1972: l_message := FND_MESSAGE.GET;
1973: l_notify_resp := cr_t.Notify_Resp3_short_name;
1974: l_responsibility_id := cr_t.Notify_Resp3_ID;

Line 1971: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

1967: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1968: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1969: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1970: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1971: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1972: l_message := FND_MESSAGE.GET;
1973: l_notify_resp := cr_t.Notify_Resp3_short_name;
1974: l_responsibility_id := cr_t.Notify_Resp3_ID;
1975: --dbms_output.put_line('Out of Third Range');

Line 1972: l_message := FND_MESSAGE.GET;

1968: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1969: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1970: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1971: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1972: l_message := FND_MESSAGE.GET;
1973: l_notify_resp := cr_t.Notify_Resp3_short_name;
1974: l_responsibility_id := cr_t.Notify_Resp3_ID;
1975: --dbms_output.put_line('Out of Third Range');
1976: ELSIF l_actual > l_target

Line 1978: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_EXRANGE');

1974: l_responsibility_id := cr_t.Notify_Resp3_ID;
1975: --dbms_output.put_line('Out of Third Range');
1976: ELSIF l_actual > l_target
1977: THEN
1978: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_EXRANGE');
1979: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1980: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1981: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1982: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

Line 1979: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);

1975: --dbms_output.put_line('Out of Third Range');
1976: ELSIF l_actual > l_target
1977: THEN
1978: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_EXRANGE');
1979: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1980: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1981: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1982: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1983: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

Line 1980: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);

1976: ELSIF l_actual > l_target
1977: THEN
1978: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_EXRANGE');
1979: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1980: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1981: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1982: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1983: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1984: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

Line 1981: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);

1977: THEN
1978: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_EXRANGE');
1979: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1980: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1981: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1982: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1983: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1984: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1985: l_message := FND_MESSAGE.GET;

Line 1982: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

1978: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_EXRANGE');
1979: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1980: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1981: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1982: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1983: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1984: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1985: l_message := FND_MESSAGE.GET;
1986: l_notify_resp := cr_t.Notify_Resp3_short_name;

Line 1983: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

1979: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1980: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1981: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1982: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1983: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1984: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1985: l_message := FND_MESSAGE.GET;
1986: l_notify_resp := cr_t.Notify_Resp3_short_name;
1987: l_responsibility_id := cr_t.Notify_Resp3_ID;

Line 1984: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

1980: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1981: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1982: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1983: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1984: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1985: l_message := FND_MESSAGE.GET;
1986: l_notify_resp := cr_t.Notify_Resp3_short_name;
1987: l_responsibility_id := cr_t.Notify_Resp3_ID;
1988: --dbms_output.put_line('less than First Range');

Line 1985: l_message := FND_MESSAGE.GET;

1981: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1982: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1983: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1984: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
1985: l_message := FND_MESSAGE.GET;
1986: l_notify_resp := cr_t.Notify_Resp3_short_name;
1987: l_responsibility_id := cr_t.Notify_Resp3_ID;
1988: --dbms_output.put_line('less than First Range');
1989: END IF;

Line 1993: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_INRANGE');

1989: END IF;
1990:
1991: -- We're on target!!
1992: ELSE
1993: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_INRANGE');
1994: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1995: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1996: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1997: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

Line 1994: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);

1990:
1991: -- We're on target!!
1992: ELSE
1993: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_INRANGE');
1994: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1995: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1996: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1997: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1998: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

Line 1995: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);

1991: -- We're on target!!
1992: ELSE
1993: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_INRANGE');
1994: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1995: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1996: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1997: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1998: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1999: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

Line 1996: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);

1992: ELSE
1993: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_INRANGE');
1994: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1995: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1996: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1997: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1998: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1999: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
2000: l_message := FND_MESSAGE.GET;

Line 1997: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

1993: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_INRANGE');
1994: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1995: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1996: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1997: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1998: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1999: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
2000: l_message := FND_MESSAGE.GET;
2001: l_notify_resp := cr_t.Notify_Resp1_short_name;

Line 1998: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

1994: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
1995: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1996: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1997: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1998: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1999: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
2000: l_message := FND_MESSAGE.GET;
2001: l_notify_resp := cr_t.Notify_Resp1_short_name;
2002: l_responsibility_id := cr_t.Notify_Resp1_ID;

Line 1999: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

1995: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
1996: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1997: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1998: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1999: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
2000: l_message := FND_MESSAGE.GET;
2001: l_notify_resp := cr_t.Notify_Resp1_short_name;
2002: l_responsibility_id := cr_t.Notify_Resp1_ID;
2003: END IF;

Line 2000: l_message := FND_MESSAGE.GET;

1996: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
1997: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
1998: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
1999: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
2000: l_message := FND_MESSAGE.GET;
2001: l_notify_resp := cr_t.Notify_Resp1_short_name;
2002: l_responsibility_id := cr_t.Notify_Resp1_ID;
2003: END IF;
2004:

Line 2105: FND_MESSAGE.SET_NAME('BIX', 'BIX_CALLS_ANSWERED');

2101: := p_target_Level_Short_Name;
2102: -- l_period_set_name := p_time_period;
2103: -- l_period_name := p_time_period;
2104: l_report := 'BIXANCT0';
2105: FND_MESSAGE.SET_NAME('BIX', 'BIX_CALLS_ANSWERED');
2106: l_msg_subject := FND_MESSAGE.GET;
2107: IF l_msg_subject is NULL then
2108: l_msg_subject := 'Calls Answered PMF Notification';
2109: END IF;

Line 2106: l_msg_subject := FND_MESSAGE.GET;

2102: -- l_period_set_name := p_time_period;
2103: -- l_period_name := p_time_period;
2104: l_report := 'BIXANCT0';
2105: FND_MESSAGE.SET_NAME('BIX', 'BIX_CALLS_ANSWERED');
2106: l_msg_subject := FND_MESSAGE.GET;
2107: IF l_msg_subject is NULL then
2108: l_msg_subject := 'Calls Answered PMF Notification';
2109: END IF;
2110: l_organization_id := -1;

Line 2166: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE1');

2162: cr_t.range2_low AND cr_t.range2_High
2163: AND l_actual BETWEEN
2164: cr_t.range1_low AND cr_t.range1_High
2165: THEN
2166: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE1');
2167: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
2168: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
2169: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
2170: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

Line 2167: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);

2163: AND l_actual BETWEEN
2164: cr_t.range1_low AND cr_t.range1_High
2165: THEN
2166: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE1');
2167: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
2168: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
2169: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
2170: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
2171: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

Line 2168: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);

2164: cr_t.range1_low AND cr_t.range1_High
2165: THEN
2166: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE1');
2167: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
2168: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
2169: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
2170: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
2171: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
2172: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

Line 2169: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);

2165: THEN
2166: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE1');
2167: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
2168: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
2169: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
2170: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
2171: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
2172: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
2173: l_message := FND_MESSAGE.GET;

Line 2170: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

2166: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE1');
2167: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
2168: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
2169: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
2170: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
2171: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
2172: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
2173: l_message := FND_MESSAGE.GET;
2174: l_notify_resp := cr_t.Notify_Resp1_short_name;

Line 2171: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

2167: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
2168: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
2169: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
2170: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
2171: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
2172: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
2173: l_message := FND_MESSAGE.GET;
2174: l_notify_resp := cr_t.Notify_Resp1_short_name;
2175: l_responsibility_id := cr_t.Notify_Resp1_ID;

Line 2172: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

2168: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
2169: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
2170: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
2171: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
2172: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
2173: l_message := FND_MESSAGE.GET;
2174: l_notify_resp := cr_t.Notify_Resp1_short_name;
2175: l_responsibility_id := cr_t.Notify_Resp1_ID;
2176: --dbms_output.put_line('In First Range');

Line 2173: l_message := FND_MESSAGE.GET;

2169: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
2170: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
2171: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
2172: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
2173: l_message := FND_MESSAGE.GET;
2174: l_notify_resp := cr_t.Notify_Resp1_short_name;
2175: l_responsibility_id := cr_t.Notify_Resp1_ID;
2176: --dbms_output.put_line('In First Range');
2177: -- Check if actual is within the second range

Line 2183: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE2');

2179: cr_t.range1_low AND cr_t.range1_High
2180: AND l_actual BETWEEN
2181: cr_t.range2_low AND cr_t.range2_High
2182: THEN
2183: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE2');
2184: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
2185: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
2186: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
2187: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

Line 2184: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);

2180: AND l_actual BETWEEN
2181: cr_t.range2_low AND cr_t.range2_High
2182: THEN
2183: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE2');
2184: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
2185: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
2186: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
2187: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
2188: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

Line 2185: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);

2181: cr_t.range2_low AND cr_t.range2_High
2182: THEN
2183: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE2');
2184: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
2185: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
2186: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
2187: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
2188: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
2189: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

Line 2186: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);

2182: THEN
2183: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE2');
2184: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
2185: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
2186: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
2187: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
2188: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
2189: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
2190: l_message := FND_MESSAGE.GET;

Line 2187: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

2183: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE2');
2184: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
2185: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
2186: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
2187: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
2188: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
2189: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
2190: l_message := FND_MESSAGE.GET;
2191: l_notify_resp := cr_t.Notify_Resp1_short_name;

Line 2188: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

2184: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
2185: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
2186: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
2187: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
2188: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
2189: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
2190: l_message := FND_MESSAGE.GET;
2191: l_notify_resp := cr_t.Notify_Resp1_short_name;
2192: l_responsibility_id := cr_t.Notify_Resp1_ID;

Line 2189: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

2185: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
2186: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
2187: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
2188: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
2189: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
2190: l_message := FND_MESSAGE.GET;
2191: l_notify_resp := cr_t.Notify_Resp1_short_name;
2192: l_responsibility_id := cr_t.Notify_Resp1_ID;
2193: --dbms_output.put_line('In Second Range');

Line 2190: l_message := FND_MESSAGE.GET;

2186: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
2187: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
2188: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
2189: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
2190: l_message := FND_MESSAGE.GET;
2191: l_notify_resp := cr_t.Notify_Resp1_short_name;
2192: l_responsibility_id := cr_t.Notify_Resp1_ID;
2193: --dbms_output.put_line('In Second Range');
2194: -- Check if actual is within the third range

Line 2200: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE3');

2196: cr_t.range2_low AND cr_t.range2_High
2197: AND l_actual BETWEEN
2198: cr_t.range3_low AND cr_t.range3_High
2199: THEN
2200: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE3');
2201: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
2202: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
2203: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
2204: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

Line 2201: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);

2197: AND l_actual BETWEEN
2198: cr_t.range3_low AND cr_t.range3_High
2199: THEN
2200: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE3');
2201: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
2202: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
2203: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
2204: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
2205: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

Line 2202: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);

2198: cr_t.range3_low AND cr_t.range3_High
2199: THEN
2200: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE3');
2201: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
2202: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
2203: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
2204: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
2205: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
2206: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

Line 2203: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);

2199: THEN
2200: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE3');
2201: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
2202: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
2203: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
2204: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
2205: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
2206: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
2207: l_message := FND_MESSAGE.GET;

Line 2204: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

2200: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_RANGE3');
2201: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
2202: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
2203: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
2204: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
2205: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
2206: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
2207: l_message := FND_MESSAGE.GET;
2208: l_notify_resp := cr_t.Notify_Resp2_short_name;

Line 2205: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

2201: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
2202: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
2203: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
2204: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
2205: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
2206: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
2207: l_message := FND_MESSAGE.GET;
2208: l_notify_resp := cr_t.Notify_Resp2_short_name;
2209: l_responsibility_id := cr_t.Notify_Resp2_ID;

Line 2206: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

2202: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
2203: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
2204: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
2205: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
2206: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
2207: l_message := FND_MESSAGE.GET;
2208: l_notify_resp := cr_t.Notify_Resp2_short_name;
2209: l_responsibility_id := cr_t.Notify_Resp2_ID;
2210: --dbms_output.put_line('In Third Range');

Line 2207: l_message := FND_MESSAGE.GET;

2203: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
2204: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
2205: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
2206: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
2207: l_message := FND_MESSAGE.GET;
2208: l_notify_resp := cr_t.Notify_Resp2_short_name;
2209: l_responsibility_id := cr_t.Notify_Resp2_ID;
2210: --dbms_output.put_line('In Third Range');
2211: -- Check if actual is outside the third range

Line 2216: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_OFFRANGE');

2212: ELSIF l_actual NOT BETWEEN
2213: cr_t.range3_low AND cr_t.range3_High
2214: AND l_actual > l_target
2215: THEN
2216: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_OFFRANGE');
2217: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
2218: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
2219: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
2220: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

Line 2217: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);

2213: cr_t.range3_low AND cr_t.range3_High
2214: AND l_actual > l_target
2215: THEN
2216: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_OFFRANGE');
2217: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
2218: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
2219: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
2220: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
2221: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

Line 2218: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);

2214: AND l_actual > l_target
2215: THEN
2216: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_OFFRANGE');
2217: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
2218: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
2219: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
2220: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
2221: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
2222: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

Line 2219: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);

2215: THEN
2216: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_OFFRANGE');
2217: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
2218: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
2219: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
2220: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
2221: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
2222: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
2223: l_message := FND_MESSAGE.GET;

Line 2220: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

2216: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_OFFRANGE');
2217: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
2218: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
2219: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
2220: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
2221: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
2222: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
2223: l_message := FND_MESSAGE.GET;
2224: l_notify_resp := cr_t.Notify_Resp3_short_name;

Line 2221: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

2217: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
2218: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
2219: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
2220: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
2221: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
2222: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
2223: l_message := FND_MESSAGE.GET;
2224: l_notify_resp := cr_t.Notify_Resp3_short_name;
2225: l_responsibility_id := cr_t.Notify_Resp3_ID;

Line 2222: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

2218: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
2219: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
2220: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
2221: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
2222: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
2223: l_message := FND_MESSAGE.GET;
2224: l_notify_resp := cr_t.Notify_Resp3_short_name;
2225: l_responsibility_id := cr_t.Notify_Resp3_ID;
2226: --dbms_output.put_line('Out of Third Range');

Line 2223: l_message := FND_MESSAGE.GET;

2219: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
2220: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
2221: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
2222: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
2223: l_message := FND_MESSAGE.GET;
2224: l_notify_resp := cr_t.Notify_Resp3_short_name;
2225: l_responsibility_id := cr_t.Notify_Resp3_ID;
2226: --dbms_output.put_line('Out of Third Range');
2227: ELSIF l_actual < l_target

Line 2229: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_EXRANGE');

2225: l_responsibility_id := cr_t.Notify_Resp3_ID;
2226: --dbms_output.put_line('Out of Third Range');
2227: ELSIF l_actual < l_target
2228: THEN
2229: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_EXRANGE');
2230: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
2231: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
2232: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
2233: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

Line 2230: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);

2226: --dbms_output.put_line('Out of Third Range');
2227: ELSIF l_actual < l_target
2228: THEN
2229: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_EXRANGE');
2230: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
2231: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
2232: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
2233: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
2234: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

Line 2231: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);

2227: ELSIF l_actual < l_target
2228: THEN
2229: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_EXRANGE');
2230: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
2231: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
2232: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
2233: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
2234: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
2235: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

Line 2232: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);

2228: THEN
2229: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_EXRANGE');
2230: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
2231: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
2232: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
2233: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
2234: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
2235: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
2236: l_message := FND_MESSAGE.GET;

Line 2233: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

2229: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_EXRANGE');
2230: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
2231: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
2232: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
2233: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
2234: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
2235: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
2236: l_message := FND_MESSAGE.GET;
2237: l_notify_resp := cr_t.Notify_Resp3_short_name;

Line 2234: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

2230: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
2231: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
2232: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
2233: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
2234: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
2235: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
2236: l_message := FND_MESSAGE.GET;
2237: l_notify_resp := cr_t.Notify_Resp3_short_name;
2238: l_responsibility_id := cr_t.Notify_Resp3_ID;

Line 2235: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

2231: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
2232: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
2233: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
2234: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
2235: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
2236: l_message := FND_MESSAGE.GET;
2237: l_notify_resp := cr_t.Notify_Resp3_short_name;
2238: l_responsibility_id := cr_t.Notify_Resp3_ID;
2239: END IF;

Line 2236: l_message := FND_MESSAGE.GET;

2232: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
2233: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
2234: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
2235: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
2236: l_message := FND_MESSAGE.GET;
2237: l_notify_resp := cr_t.Notify_Resp3_short_name;
2238: l_responsibility_id := cr_t.Notify_Resp3_ID;
2239: END IF;
2240: -- We're on target!!

Line 2242: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_INRANGE');

2238: l_responsibility_id := cr_t.Notify_Resp3_ID;
2239: END IF;
2240: -- We're on target!!
2241: ELSE
2242: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_INRANGE');
2243: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
2244: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
2245: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
2246: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

Line 2243: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);

2239: END IF;
2240: -- We're on target!!
2241: ELSE
2242: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_INRANGE');
2243: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
2244: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
2245: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
2246: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
2247: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

Line 2244: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);

2240: -- We're on target!!
2241: ELSE
2242: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_INRANGE');
2243: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
2244: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
2245: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
2246: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
2247: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
2248: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

Line 2245: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);

2241: ELSE
2242: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_INRANGE');
2243: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
2244: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
2245: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
2246: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
2247: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
2248: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
2249: l_message := FND_MESSAGE.GET;

Line 2246: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);

2242: FND_MESSAGE.SET_NAME('BIX', 'BIX_PMF_INRANGE');
2243: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
2244: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
2245: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
2246: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
2247: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
2248: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
2249: l_message := FND_MESSAGE.GET;
2250: l_notify_resp := cr_t.Notify_Resp1_short_name;

Line 2247: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);

2243: FND_MESSAGE.SET_TOKEN('BIX_TARGET_NAME', cr_t.target_level_name);
2244: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
2245: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
2246: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
2247: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
2248: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
2249: l_message := FND_MESSAGE.GET;
2250: l_notify_resp := cr_t.Notify_Resp1_short_name;
2251: l_responsibility_id := cr_t.Notify_Resp1_ID;

Line 2248: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);

2244: FND_MESSAGE.SET_TOKEN('BIX_CENTER', l_center);
2245: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
2246: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
2247: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
2248: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
2249: l_message := FND_MESSAGE.GET;
2250: l_notify_resp := cr_t.Notify_Resp1_short_name;
2251: l_responsibility_id := cr_t.Notify_Resp1_ID;
2252: END IF;

Line 2249: l_message := FND_MESSAGE.GET;

2245: FND_MESSAGE.SET_TOKEN('BIX_TARGET', l_target);
2246: FND_MESSAGE.SET_TOKEN('BIX_ACTUAL', l_actual);
2247: FND_MESSAGE.SET_TOKEN('BIX_PLAN', cr_t.plan_name);
2248: FND_MESSAGE.SET_TOKEN('BIX_TIME', cr_a.month);
2249: l_message := FND_MESSAGE.GET;
2250: l_notify_resp := cr_t.Notify_Resp1_short_name;
2251: l_responsibility_id := cr_t.Notify_Resp1_ID;
2252: END IF;
2253: Start_Corrective_Action