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;
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;
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);
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);
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);
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;
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;
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;
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');
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
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);
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);
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);
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;
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;
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;
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');
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
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);
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);
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);
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;
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;
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;
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');
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
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);
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);
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);
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;
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;
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;
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');
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
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);
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);
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);
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;
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;
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;
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');
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;
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);
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);
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);
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;
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;
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;
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;
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: /*
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;
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;
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);
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);
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);
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;
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;
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;
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);
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
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);
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);
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);
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;
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;
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;
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');
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
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);
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);
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);
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;
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;
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;
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');
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
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);
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);
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);
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;
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;
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;
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');
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
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);
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);
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);
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;
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;
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;
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');
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;
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);
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);
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);
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;
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;
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;
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;
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');
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;
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
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
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);
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);
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);
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;
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: /*
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!'||' '||
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||' '||
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 '||
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);
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);
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);
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;
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: /*
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!'||' '||
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||' '||
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 '||
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);
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);
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);
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;
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: /*
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!'||' '||
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||' '||
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 '||
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);
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);
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);
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;
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: /*
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!'||' '||
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||' '||
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 '||
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);
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);
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);
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;
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: /*
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 '||' '||
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||' '||
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 '||
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);
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);
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);
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;
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: /*
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!!'||' '||
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||' '||
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 '||
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;
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;
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);
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);
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);
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;
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: /*
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!'||' '||
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||' '||
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 '||
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);
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);
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);
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;
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: /*
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!'||' '||
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||' '||
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 '||
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);
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);
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);
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;
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: /*
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!'||' '||
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||' '||
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 '||
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);
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);
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);
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;
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: /*
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!'||' '||
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||' '||
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 '||
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);
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);
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);
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;
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: /*
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 '||' '||
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||' '||
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 '||
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);
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);
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);
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;
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: /*
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!!'||' '||
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||' '||
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 '||
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;
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;
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);
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);
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);
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;
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;
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;
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);
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
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);
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);
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);
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;
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;
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;
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');
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
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);
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);
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);
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;
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;
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;
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');
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
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);
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);
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);
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;
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;
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;
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');
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
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);
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);
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);
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;
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;
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;
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');
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;
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);
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);
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);
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;
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;
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;
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;
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: /*
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;
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;
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);
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);
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);
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;
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;
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;
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);
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
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);
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);
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);
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;
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;
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;
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');
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
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);
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);
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);
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;
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;
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;
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');
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
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);
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);
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);
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;
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;
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;
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');
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
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);
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);
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);
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;
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;
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;
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:
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');
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);
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);
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);
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;
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;
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;
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;
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: /*
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;
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);
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);
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);
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);
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;
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;
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;
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);
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
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);
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);
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);
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;
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;
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;
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');
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
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);
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);
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);
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;
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;
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;
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');
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
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);
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);
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);
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;
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;
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;
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');
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
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);
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);
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);
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;
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;
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;
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');
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;
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);
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);
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);
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;
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;
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;
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;
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:
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;
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;
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);
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);
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);
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;
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;
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;
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');
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
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);
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);
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);
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;
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;
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;
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');
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
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);
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);
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);
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;
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;
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;
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');
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
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);
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);
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);
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;
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;
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;
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');
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
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);
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);
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);
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;
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;
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;
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;
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!!
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);
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);
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);
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;
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;
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;
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;
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