340: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_CREATE');
341: fnd_message.set_token('FORMULA_NAME', l_formula_name);
342: l_note_msg := fnd_message.get;
343:
344: jtf_notes_pub.create_note
345: (p_api_version => 1.0,
346: x_return_status => x_return_status,
347: x_msg_count => x_msg_count,
348: x_msg_data => x_msg_data,
364: l_note_msg := fnd_message.get;
365:
366: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
367: /*
368: jtf_notes_pub.create_note
369: (p_api_version => 1.0,
370: x_return_status => x_return_status,
371: x_msg_count => x_msg_count,
372: x_msg_data => x_msg_data,
390: l_note_msg := fnd_message.get;
391:
392: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
393: /*
394: jtf_notes_pub.create_note
395: (p_api_version => 1.0,
396: x_return_status => x_return_status,
397: x_msg_count => x_msg_count,
398: x_msg_data => x_msg_data,
407: END IF;
408:
409: -- Consolidated all Formula Details changes notes in one Note
410: IF LENGTH(l_consolidated_note) > 1 THEN
411: jtf_notes_pub.create_note
412: (p_api_version => 1.0,
413: x_return_status => x_return_status,
414: x_msg_count => x_msg_count,
415: x_msg_data => x_msg_data,
431: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_PERF_CREATE');
432: fnd_message.set_token('PERF_MEASURE', l_perf_measure_name);
433: l_note_msg := fnd_message.get;
434:
435: jtf_notes_pub.create_note
436: (p_api_version => 1.0,
437: x_return_status => x_return_status,
438: x_msg_count => x_msg_count,
439: x_msg_data => x_msg_data,
863: l_note_msg := fnd_message.get;
864:
865: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
866: /*
867: jtf_notes_pub.create_note
868: (p_api_version => 1.0,
869: x_return_status => x_return_status,
870: x_msg_count => x_msg_count,
871: x_msg_data => x_msg_data,
892: l_note_msg := fnd_message.get;
893:
894: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
895: /*
896: jtf_notes_pub.create_note
897: (p_api_version => 1.0,
898: x_return_status => x_return_status,
899: x_msg_count => x_msg_count,
900: x_msg_data => x_msg_data,
915: l_note_msg := fnd_message.get;
916:
917: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
918: /*
919: jtf_notes_pub.create_note
920: (p_api_version => 1.0,
921: x_return_status => x_return_status,
922: x_msg_count => x_msg_count,
923: x_msg_data => x_msg_data,
949: l_note_msg := fnd_message.get;
950:
951: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
952: /*
953: jtf_notes_pub.create_note
954: (p_api_version => 1.0,
955: x_return_status => x_return_status,
956: x_msg_count => x_msg_count,
957: x_msg_data => x_msg_data,
975: l_note_msg := fnd_message.get;
976:
977: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
978: /*
979: jtf_notes_pub.create_note
980: (p_api_version => 1.0,
981: x_return_status => x_return_status,
982: x_msg_count => x_msg_count,
983: x_msg_data => x_msg_data,
1001: l_note_msg := fnd_message.get;
1002:
1003: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
1004: /*
1005: jtf_notes_pub.create_note
1006: (p_api_version => 1.0,
1007: x_return_status => x_return_status,
1008: x_msg_count => x_msg_count,
1009: x_msg_data => x_msg_data,
1027: l_note_msg := fnd_message.get;
1028:
1029: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
1030: /*
1031: jtf_notes_pub.create_note
1032: (p_api_version => 1.0,
1033: x_return_status => x_return_status,
1034: x_msg_count => x_msg_count,
1035: x_msg_data => x_msg_data,
1043: */
1044: END IF;
1045: -- Consolidated all Formula Details changes notes in one Note
1046: IF LENGTH(l_consolidated_note) > 1 THEN
1047: jtf_notes_pub.create_note
1048: (p_api_version => 1.0,
1049: x_return_status => x_return_status,
1050: x_msg_count => x_msg_count,
1051: x_msg_data => x_msg_data,
1078: l_note_msg := fnd_message.get;
1079: END IF;
1080: l_consolidated_exp_note := l_consolidated_exp_note || l_note_msg || fnd_global.local_chr(10);
1081: /*
1082: jtf_notes_pub.create_note
1083: (p_api_version => 1.0,
1084: x_return_status => x_return_status,
1085: x_msg_count => x_msg_count,
1086: x_msg_data => x_msg_data,
1101: l_note_msg := fnd_message.get;
1102:
1103: l_consolidated_exp_note := l_consolidated_exp_note || l_note_msg || fnd_global.local_chr(10);
1104: /*
1105: jtf_notes_pub.create_note
1106: (p_api_version => 1.0,
1107: x_return_status => x_return_status,
1108: x_msg_count => x_msg_count,
1109: x_msg_data => x_msg_data,
1139: END IF;
1140:
1141: l_consolidated_exp_note := l_consolidated_exp_note || l_note_msg || fnd_global.local_chr(10);
1142: /*
1143: jtf_notes_pub.create_note
1144: (p_api_version => 1.0,
1145: x_return_status => x_return_status,
1146: x_msg_count => x_msg_count,
1147: x_msg_data => x_msg_data,
1162: l_note_msg := fnd_message.get;
1163:
1164: l_consolidated_exp_note := l_consolidated_exp_note || l_note_msg || fnd_global.local_chr(10);
1165: /*
1166: jtf_notes_pub.create_note
1167: (p_api_version => 1.0,
1168: x_return_status => x_return_status,
1169: x_msg_count => x_msg_count,
1170: x_msg_data => x_msg_data,
1179: END IF;
1180:
1181: -- Consolidated all Output Expressions in one Note.
1182: IF LENGTH(l_consolidated_exp_note) > 1 THEN
1183: jtf_notes_pub.create_note
1184: (p_api_version => 1.0,
1185: x_return_status => x_return_status,
1186: x_msg_count => x_msg_count,
1187: x_msg_data => x_msg_data,
1214: fnd_message.set_token('PERF_MEASURE', l_perf_measure_name);
1215: l_note_msg := fnd_message.get;
1216: END IF;
1217:
1218: jtf_notes_pub.create_note
1219: (p_api_version => 1.0,
1220: x_return_status => x_return_status,
1221: x_msg_count => x_msg_count,
1222: x_msg_data => x_msg_data,
1233: fnd_message.set_name('CN', 'CNR12_NOTE_FORMULA_PERF_DELETE');
1234: fnd_message.set_token('PERF_MEASURE', l_perf_measure_name_old);
1235: l_note_msg := fnd_message.get;
1236:
1237: jtf_notes_pub.create_note
1238: (p_api_version => 1.0,
1239: x_return_status => x_return_status,
1240: x_msg_count => x_msg_count,
1241: x_msg_data => x_msg_data,
1547: IF (p_org_id <> -999) THEN
1548: fnd_message.set_name ('CN', 'CNR12_NOTE_FORMULA_DELETE');
1549: fnd_message.set_token ('FORMULA', l_formula_name);
1550: l_note_msg := fnd_message.get;
1551: jtf_notes_pub.create_note
1552: (p_api_version => 1.0,
1553: x_return_status => x_return_status,
1554: x_msg_count => x_msg_count,
1555: x_msg_data => x_msg_data,