DBA Data[Home] [Help]

APPS.OZF_THRESHOLD_PVT dependencies on FND_GLOBAL

Line 69: --l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10)||p_message_text;

65: fnd_message.set_name('OZF', 'OZF_THRESHOLD_CHILDSUBJ');
66: l_strChildSubject := fnd_message.get;
67:
68: -- fnd_message.set_name('OZF', 'OZF_NOTIFY_HEADERLINE');
69: --l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10)||p_message_text;
70: l_strBody := p_message_text;
71: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');
72: --l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
73: l_strBody := l_strBody ||fnd_message.get ;

Line 72: --l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;

68: -- fnd_message.set_name('OZF', 'OZF_NOTIFY_HEADERLINE');
69: --l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10)||p_message_text;
70: l_strBody := p_message_text;
71: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');
72: --l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
73: l_strBody := l_strBody ||fnd_message.get ;
74: ozf_utility_pvt.send_wf_standalone_message(
75: p_subject => l_strSubject
76: ,p_body => l_strBody

Line 1219: l_message := l_owner_table(i).message_text|| fnd_global.local_chr(10);

1215: l_counter := 1;
1216:
1217: IF l_owner_table(i).remove_flag = 'F' THEN
1218: --l_message := l_owner_table(i).message_text;
1219: l_message := l_owner_table(i).message_text|| fnd_global.local_chr(10);
1220: l_notify_table(l_count).owner := l_owner_table(i).owner;
1221: l_notify_table(l_count).parent_owner :=l_owner_table(i).parent_owner;
1222: l_parent_owner_id := l_owner_table(i).parent_owner;
1223: l_owner_table(i).remove_flag := 'T';

Line 1227: --l_message := l_message || fnd_global.local_chr(10)|| l_owner_table(j).message_text || '. ' || fnd_global.local_chr(10);

1223: l_owner_table(i).remove_flag := 'T';
1224:
1225: FOR j IN NVL(l_owner_table.FIRST, 1) .. NVL(l_owner_table.LAST, 0) LOOP
1226: IF j <> i AND l_owner_table(j).remove_flag = 'F' AND l_parent_owner_id = l_owner_table(j).parent_owner THEN
1227: --l_message := l_message || fnd_global.local_chr(10)|| l_owner_table(j).message_text || '. ' || fnd_global.local_chr(10);
1228: l_message := l_message || l_owner_table(j).message_text || fnd_global.local_chr(10);
1229: l_owner_table(j).remove_flag := 'T';
1230:
1231: --restricting 15 messages to notification -bug 5390527

Line 1228: l_message := l_message || l_owner_table(j).message_text || fnd_global.local_chr(10);

1224:
1225: FOR j IN NVL(l_owner_table.FIRST, 1) .. NVL(l_owner_table.LAST, 0) LOOP
1226: IF j <> i AND l_owner_table(j).remove_flag = 'F' AND l_parent_owner_id = l_owner_table(j).parent_owner THEN
1227: --l_message := l_message || fnd_global.local_chr(10)|| l_owner_table(j).message_text || '. ' || fnd_global.local_chr(10);
1228: l_message := l_message || l_owner_table(j).message_text || fnd_global.local_chr(10);
1229: l_owner_table(j).remove_flag := 'T';
1230:
1231: --restricting 15 messages to notification -bug 5390527
1232: l_counter := l_counter+1;