DBA Data[Home] [Help]

APPS.OZF_QUOTA_THRESHOLD_PVT dependencies on FND_GLOBAL

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

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

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

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

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

879: l_notify_table(l_count).parent_owner :=l_owner_table(i).parent_owner;
880: l_parent_owner_id := l_owner_table(i).parent_owner;
881: FOR j IN NVL(l_owner_table.FIRST, 1) .. NVL(l_owner_table.LAST, 0) LOOP
882: IF j <> i AND l_owner_table(j).remove_flag = 'F' AND l_parent_owner_id = l_owner_table(j).parent_owner THEN
883: l_message := l_message || fnd_global.local_chr(10)|| l_owner_table(j).message_text || '. ' || fnd_global.local_chr(10);
884: l_owner_table(j).remove_flag := 'T';
885: END IF;
886: END LOOP;
887: l_notify_table(l_count).message_text := l_message;