177: l_plan_element_id := p_plan_element_old.org_id;
178: l_temp_new := 'CN_DELETED_OBJECTS';
179: END IF;
180: l_note_msg := fnd_message.get;
181: jtf_notes_pub.create_note
182: (p_api_version => 1.0,
183: x_return_status => x_return_status,
184: x_msg_count => x_msg_count,
185: x_msg_data => x_msg_data,
199: fnd_message.set_token('PE_NAME_NEW', p_plan_element_new.NAME);
200: l_plan_element_id := p_plan_element_new.quota_id;
201: l_note_msg := fnd_message.get;
202: l_consolidated_note := l_note_msg || fnd_global.local_chr(10);
203: /* jtf_notes_pub.create_note
204: (p_api_version => 1.0,
205: x_return_status => x_return_status,
206: x_msg_count => x_msg_count,
207: x_msg_data => x_msg_data,
220: fnd_message.set_token('PE_START_NEW', p_plan_element_new.start_date);
221: l_plan_element_id := p_plan_element_new.quota_id;
222: l_note_msg := fnd_message.get;
223: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
224: /* jtf_notes_pub.create_note
225: (p_api_version => 1.0,
226: x_return_status => x_return_status,
227: x_msg_count => x_msg_count,
228: x_msg_data => x_msg_data,
250: END IF;
251: l_plan_element_id := p_plan_element_new.quota_id;
252: l_note_msg := fnd_message.get;
253: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
254: /* jtf_notes_pub.create_note
255: (p_api_version => 1.0,
256: x_return_status => x_return_status,
257: x_msg_count => x_msg_count,
258: x_msg_data => x_msg_data,
269: fnd_message.set_name ('CN','CNR12_NOTE_PE_DESC_UPDATE');
270: l_plan_element_id := p_plan_element_new.quota_id;
271: l_note_msg := fnd_message.get;
272: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
273: /* jtf_notes_pub.create_note
274: (p_api_version => 1.0,
275: x_return_status => x_return_status,
276: x_msg_count => x_msg_count,
277: x_msg_data => x_msg_data,
297: fnd_message.set_token('PE_OLD_INTERVAL', l_temp_old);
298: fnd_message.set_token('PE_NEW_INTERVAL', l_temp_new);
299: l_note_msg := fnd_message.get;
300: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
301: /* jtf_notes_pub.create_note
302: (p_api_version => 1.0,
303: x_return_status => x_return_status,
304: x_msg_count => x_msg_count,
305: x_msg_data => x_msg_data,
321: fnd_message.set_token('PE_OLD_FOR', l_temp_1);
322: fnd_message.set_token('PE_NEW_FOR', l_temp_2);
323: l_note_msg := fnd_message.get;
324: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
325: /* jtf_notes_pub.create_note
326: (p_api_version => 1.0,
327: x_return_status => x_return_status,
328: x_msg_count => x_msg_count,
329: x_msg_data => x_msg_data,
365: fnd_message.set_token('FORMULA_TYPE_NEW', l_temp_2);
366: fnd_message.set_token('FORMULA_NAME_NEW', l_temp_new);
367: l_note_msg := fnd_message.get;
368: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
369: /* jtf_notes_pub.create_note
370: (p_api_version => 1.0,
371: x_return_status => x_return_status,
372: x_msg_count => x_msg_count,
373: x_msg_data => x_msg_data,
387: fnd_message.set_token('PAYGRP_NEW', p_plan_element_new.payment_group_code);
388: l_plan_element_id := p_plan_element_new.quota_id;
389: l_note_msg := fnd_message.get;
390: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
391: /* jtf_notes_pub.create_note
392: (p_api_version => 1.0,
393: x_return_status => x_return_status,
394: x_msg_count => x_msg_count,
395: x_msg_data => x_msg_data,
415: fnd_message.set_token('PE_NEW_CREDIT', l_temp_new);
416: l_plan_element_id := p_plan_element_new.quota_id;
417: l_note_msg := fnd_message.get;
418: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
419: /* jtf_notes_pub.create_note
420: (p_api_version => 1.0,
421: x_return_status => x_return_status,
422: x_msg_count => x_msg_count,
423: x_msg_data => x_msg_data,
443: fnd_message.set_token('PE_NEW_PAYEE', l_temp_new);
444: l_plan_element_id := p_plan_element_new.quota_id;
445: l_note_msg := fnd_message.get;
446: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
447: /* jtf_notes_pub.create_note
448: (p_api_version => 1.0,
449: x_return_status => x_return_status,
450: x_msg_count => x_msg_count,
451: x_msg_data => x_msg_data,
473: fnd_message.set_token('PE_NEW_LIA', l_temp_new);
474: l_plan_element_id := p_plan_element_new.quota_id;
475: l_note_msg := fnd_message.get;
476: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
477: /* jtf_notes_pub.create_note
478: (p_api_version => 1.0,
479: x_return_status => x_return_status,
480: x_msg_count => x_msg_count,
481: x_msg_data => x_msg_data,
503: fnd_message.set_token('PE_EXP_NEW', l_temp_new);
504: l_plan_element_id := p_plan_element_new.quota_id;
505: l_note_msg := fnd_message.get;
506: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
507: /* jtf_notes_pub.create_note
508: (p_api_version => 1.0,
509: x_return_status => x_return_status,
510: x_msg_count => x_msg_count,
511: x_msg_data => x_msg_data,
527: fnd_message.set_token('PE_CR_ROLL_NEW', l_temp_new);
528: l_plan_element_id := p_plan_element_new.quota_id;
529: l_note_msg := fnd_message.get;
530: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
531: /* jtf_notes_pub.create_note
532: (p_api_version => 1.0,
533: x_return_status => x_return_status,
534: x_msg_count => x_msg_count,
535: x_msg_data => x_msg_data,
548: fnd_message.set_token('NEW_VAL', p_plan_element_new.target);
549: l_plan_element_id := p_plan_element_new.quota_id;
550: l_note_msg := fnd_message.get;
551: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
552: /* jtf_notes_pub.create_note
553: (p_api_version => 1.0,
554: x_return_status => x_return_status,
555: x_msg_count => x_msg_count,
556: x_msg_data => x_msg_data,
569: fnd_message.set_token('NEW_VAL', p_plan_element_new.payment_amount);
570: l_plan_element_id := p_plan_element_new.quota_id;
571: l_note_msg := fnd_message.get;
572: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
573: /* jtf_notes_pub.create_note
574: (p_api_version => 1.0,
575: x_return_status => x_return_status,
576: x_msg_count => x_msg_count,
577: x_msg_data => x_msg_data,
590: fnd_message.set_token('NEW_VAL', p_plan_element_new.performance_goal);
591: l_plan_element_id := p_plan_element_new.quota_id;
592: l_note_msg := fnd_message.get;
593: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
594: /* jtf_notes_pub.create_note
595: (p_api_version => 1.0,
596: x_return_status => x_return_status,
597: x_msg_count => x_msg_count,
598: x_msg_data => x_msg_data,
605: );*/
606: END IF;
607:
608: IF LENGTH(l_consolidated_note) > 1 THEN
609: jtf_notes_pub.create_note (p_api_version => 1.0,
610: x_return_status => x_return_status,
611: x_msg_count => x_msg_count,
612: x_msg_data => x_msg_data,
613: p_source_object_id => l_plan_element_id,