eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_QUOTA_THRESHOLD_PVT dependencies on FND_MESSAGE

Line 64: fnd_message.set_name('OZF', 'OZF_THRESHOLD_SUBJECT');

60:
61: -- Initialize API return status to SUCCESS
62: x_return_status := FND_API.G_RET_STS_SUCCESS;
63:
64: fnd_message.set_name('OZF', 'OZF_THRESHOLD_SUBJECT');
65: l_strSubject := fnd_message.get;
66: fnd_message.set_name('OZF', 'OZF_THRESHOLD_CHILDSUBJ');
67: l_strChildSubject := fnd_message.get;
68:

Line 65: l_strSubject := fnd_message.get;

61: -- Initialize API return status to SUCCESS
62: x_return_status := FND_API.G_RET_STS_SUCCESS;
63:
64: fnd_message.set_name('OZF', 'OZF_THRESHOLD_SUBJECT');
65: l_strSubject := fnd_message.get;
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');

Line 66: fnd_message.set_name('OZF', 'OZF_THRESHOLD_CHILDSUBJ');

62: x_return_status := FND_API.G_RET_STS_SUCCESS;
63:
64: fnd_message.set_name('OZF', 'OZF_THRESHOLD_SUBJECT');
65: l_strSubject := fnd_message.get;
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;

Line 67: l_strChildSubject := fnd_message.get;

63:
64: fnd_message.set_name('OZF', 'OZF_THRESHOLD_SUBJECT');
65: l_strSubject := fnd_message.get;
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;

Line 69: -- fnd_message.set_name('OZF', 'OZF_NOTIFY_HEADERLINE');

65: l_strSubject := fnd_message.get;
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 ;

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 72: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');

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:
75: ozf_utility_pvt.send_wf_standalone_message(
76: p_subject => l_strSubject

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 783: fnd_message.set_name ('OZF', 'OZF_THRESHOLD_LESS');

779: IF l_notification_result = 'NOTIFY' THEN
780:
781: --Get operator meaning.
782: IF budget.operator_code = '0' THEN
783: fnd_message.set_name ('OZF', 'OZF_THRESHOLD_LESS');
784: l_operator_meaning := fnd_message.get;
785: ELSIF budget.operator_code = '1' THEN
786: fnd_message.set_name ('OZF', 'OZF_THRESHOLD_EQUAL');
787: l_operator_meaning := fnd_message.get;

Line 784: l_operator_meaning := fnd_message.get;

780:
781: --Get operator meaning.
782: IF budget.operator_code = '0' THEN
783: fnd_message.set_name ('OZF', 'OZF_THRESHOLD_LESS');
784: l_operator_meaning := fnd_message.get;
785: ELSIF budget.operator_code = '1' THEN
786: fnd_message.set_name ('OZF', 'OZF_THRESHOLD_EQUAL');
787: l_operator_meaning := fnd_message.get;
788: ELSE

Line 786: fnd_message.set_name ('OZF', 'OZF_THRESHOLD_EQUAL');

782: IF budget.operator_code = '0' THEN
783: fnd_message.set_name ('OZF', 'OZF_THRESHOLD_LESS');
784: l_operator_meaning := fnd_message.get;
785: ELSIF budget.operator_code = '1' THEN
786: fnd_message.set_name ('OZF', 'OZF_THRESHOLD_EQUAL');
787: l_operator_meaning := fnd_message.get;
788: ELSE
789: fnd_message.set_name ('OZF', 'OZF_THRESHOLD_LARGER');
790: l_operator_meaning := fnd_message.get;

Line 787: l_operator_meaning := fnd_message.get;

783: fnd_message.set_name ('OZF', 'OZF_THRESHOLD_LESS');
784: l_operator_meaning := fnd_message.get;
785: ELSIF budget.operator_code = '1' THEN
786: fnd_message.set_name ('OZF', 'OZF_THRESHOLD_EQUAL');
787: l_operator_meaning := fnd_message.get;
788: ELSE
789: fnd_message.set_name ('OZF', 'OZF_THRESHOLD_LARGER');
790: l_operator_meaning := fnd_message.get;
791: END IF;

Line 789: fnd_message.set_name ('OZF', 'OZF_THRESHOLD_LARGER');

785: ELSIF budget.operator_code = '1' THEN
786: fnd_message.set_name ('OZF', 'OZF_THRESHOLD_EQUAL');
787: l_operator_meaning := fnd_message.get;
788: ELSE
789: fnd_message.set_name ('OZF', 'OZF_THRESHOLD_LARGER');
790: l_operator_meaning := fnd_message.get;
791: END IF;
792:
793: OPEN c_budget_name(budget.budget_id);

Line 790: l_operator_meaning := fnd_message.get;

786: fnd_message.set_name ('OZF', 'OZF_THRESHOLD_EQUAL');
787: l_operator_meaning := fnd_message.get;
788: ELSE
789: fnd_message.set_name ('OZF', 'OZF_THRESHOLD_LARGER');
790: l_operator_meaning := fnd_message.get;
791: END IF;
792:
793: OPEN c_budget_name(budget.budget_id);
794: FETCH c_budget_name INTO l_budget_name;

Line 807: fnd_message.set_name ('OZF', 'OZF_WF_NTF_QUOTA_THRESHOLD_FYI');

803: IF budget.comparison_type = 'PERCENT' then
804: OPEN c_baseline_name(budget.base_line);
805: FETCH c_baseline_name INTO l_baseline_name;
806: CLOSE c_baseline_name;
807: fnd_message.set_name ('OZF', 'OZF_WF_NTF_QUOTA_THRESHOLD_FYI');
808: fnd_message.set_token ('BUDGET_NAME', l_budget_name, FALSE);
809: fnd_message.set_token ('VALUE_LIMIT', l_valuelimit_name, FALSE);
810: fnd_message.set_token ('OPERATOR', l_operator_meaning, FALSE);
811: fnd_message.set_token ('PERCENT_AMOUNT', budget.percent_amt, FALSE);

Line 808: fnd_message.set_token ('BUDGET_NAME', l_budget_name, FALSE);

804: OPEN c_baseline_name(budget.base_line);
805: FETCH c_baseline_name INTO l_baseline_name;
806: CLOSE c_baseline_name;
807: fnd_message.set_name ('OZF', 'OZF_WF_NTF_QUOTA_THRESHOLD_FYI');
808: fnd_message.set_token ('BUDGET_NAME', l_budget_name, FALSE);
809: fnd_message.set_token ('VALUE_LIMIT', l_valuelimit_name, FALSE);
810: fnd_message.set_token ('OPERATOR', l_operator_meaning, FALSE);
811: fnd_message.set_token ('PERCENT_AMOUNT', budget.percent_amt, FALSE);
812: fnd_message.set_token ('BASE_LINE', l_baseline_name, FALSE);

Line 809: fnd_message.set_token ('VALUE_LIMIT', l_valuelimit_name, FALSE);

805: FETCH c_baseline_name INTO l_baseline_name;
806: CLOSE c_baseline_name;
807: fnd_message.set_name ('OZF', 'OZF_WF_NTF_QUOTA_THRESHOLD_FYI');
808: fnd_message.set_token ('BUDGET_NAME', l_budget_name, FALSE);
809: fnd_message.set_token ('VALUE_LIMIT', l_valuelimit_name, FALSE);
810: fnd_message.set_token ('OPERATOR', l_operator_meaning, FALSE);
811: fnd_message.set_token ('PERCENT_AMOUNT', budget.percent_amt, FALSE);
812: fnd_message.set_token ('BASE_LINE', l_baseline_name, FALSE);
813: fnd_message.set_token ('DATE', l_today_date, FALSE);

Line 810: fnd_message.set_token ('OPERATOR', l_operator_meaning, FALSE);

806: CLOSE c_baseline_name;
807: fnd_message.set_name ('OZF', 'OZF_WF_NTF_QUOTA_THRESHOLD_FYI');
808: fnd_message.set_token ('BUDGET_NAME', l_budget_name, FALSE);
809: fnd_message.set_token ('VALUE_LIMIT', l_valuelimit_name, FALSE);
810: fnd_message.set_token ('OPERATOR', l_operator_meaning, FALSE);
811: fnd_message.set_token ('PERCENT_AMOUNT', budget.percent_amt, FALSE);
812: fnd_message.set_token ('BASE_LINE', l_baseline_name, FALSE);
813: fnd_message.set_token ('DATE', l_today_date, FALSE);
814: l_message := fnd_message.get;

Line 811: fnd_message.set_token ('PERCENT_AMOUNT', budget.percent_amt, FALSE);

807: fnd_message.set_name ('OZF', 'OZF_WF_NTF_QUOTA_THRESHOLD_FYI');
808: fnd_message.set_token ('BUDGET_NAME', l_budget_name, FALSE);
809: fnd_message.set_token ('VALUE_LIMIT', l_valuelimit_name, FALSE);
810: fnd_message.set_token ('OPERATOR', l_operator_meaning, FALSE);
811: fnd_message.set_token ('PERCENT_AMOUNT', budget.percent_amt, FALSE);
812: fnd_message.set_token ('BASE_LINE', l_baseline_name, FALSE);
813: fnd_message.set_token ('DATE', l_today_date, FALSE);
814: l_message := fnd_message.get;
815: ELSE

Line 812: fnd_message.set_token ('BASE_LINE', l_baseline_name, FALSE);

808: fnd_message.set_token ('BUDGET_NAME', l_budget_name, FALSE);
809: fnd_message.set_token ('VALUE_LIMIT', l_valuelimit_name, FALSE);
810: fnd_message.set_token ('OPERATOR', l_operator_meaning, FALSE);
811: fnd_message.set_token ('PERCENT_AMOUNT', budget.percent_amt, FALSE);
812: fnd_message.set_token ('BASE_LINE', l_baseline_name, FALSE);
813: fnd_message.set_token ('DATE', l_today_date, FALSE);
814: l_message := fnd_message.get;
815: ELSE
816: fnd_message.set_name ('OZF', 'OZF_WF_NTF_QUOTA_THRS_CONS_FYI');

Line 813: fnd_message.set_token ('DATE', l_today_date, FALSE);

809: fnd_message.set_token ('VALUE_LIMIT', l_valuelimit_name, FALSE);
810: fnd_message.set_token ('OPERATOR', l_operator_meaning, FALSE);
811: fnd_message.set_token ('PERCENT_AMOUNT', budget.percent_amt, FALSE);
812: fnd_message.set_token ('BASE_LINE', l_baseline_name, FALSE);
813: fnd_message.set_token ('DATE', l_today_date, FALSE);
814: l_message := fnd_message.get;
815: ELSE
816: fnd_message.set_name ('OZF', 'OZF_WF_NTF_QUOTA_THRS_CONS_FYI');
817: fnd_message.set_token ('BUDGET_NAME', l_budget_name, FALSE);

Line 814: l_message := fnd_message.get;

810: fnd_message.set_token ('OPERATOR', l_operator_meaning, FALSE);
811: fnd_message.set_token ('PERCENT_AMOUNT', budget.percent_amt, FALSE);
812: fnd_message.set_token ('BASE_LINE', l_baseline_name, FALSE);
813: fnd_message.set_token ('DATE', l_today_date, FALSE);
814: l_message := fnd_message.get;
815: ELSE
816: fnd_message.set_name ('OZF', 'OZF_WF_NTF_QUOTA_THRS_CONS_FYI');
817: fnd_message.set_token ('BUDGET_NAME', l_budget_name, FALSE);
818: fnd_message.set_token ('VALUE_LIMIT', l_valuelimit_name, FALSE);

Line 816: fnd_message.set_name ('OZF', 'OZF_WF_NTF_QUOTA_THRS_CONS_FYI');

812: fnd_message.set_token ('BASE_LINE', l_baseline_name, FALSE);
813: fnd_message.set_token ('DATE', l_today_date, FALSE);
814: l_message := fnd_message.get;
815: ELSE
816: fnd_message.set_name ('OZF', 'OZF_WF_NTF_QUOTA_THRS_CONS_FYI');
817: fnd_message.set_token ('BUDGET_NAME', l_budget_name, FALSE);
818: fnd_message.set_token ('VALUE_LIMIT', l_valuelimit_name, FALSE);
819: fnd_message.set_token ('OPERATOR', l_operator_meaning, FALSE);
820: fnd_message.set_token ('PERCENT_AMOUNT', budget.percent_amt, FALSE);

Line 817: fnd_message.set_token ('BUDGET_NAME', l_budget_name, FALSE);

813: fnd_message.set_token ('DATE', l_today_date, FALSE);
814: l_message := fnd_message.get;
815: ELSE
816: fnd_message.set_name ('OZF', 'OZF_WF_NTF_QUOTA_THRS_CONS_FYI');
817: fnd_message.set_token ('BUDGET_NAME', l_budget_name, FALSE);
818: fnd_message.set_token ('VALUE_LIMIT', l_valuelimit_name, FALSE);
819: fnd_message.set_token ('OPERATOR', l_operator_meaning, FALSE);
820: fnd_message.set_token ('PERCENT_AMOUNT', budget.percent_amt, FALSE);
821: fnd_message.set_token ('DATE', l_today_date, FALSE);

Line 818: fnd_message.set_token ('VALUE_LIMIT', l_valuelimit_name, FALSE);

814: l_message := fnd_message.get;
815: ELSE
816: fnd_message.set_name ('OZF', 'OZF_WF_NTF_QUOTA_THRS_CONS_FYI');
817: fnd_message.set_token ('BUDGET_NAME', l_budget_name, FALSE);
818: fnd_message.set_token ('VALUE_LIMIT', l_valuelimit_name, FALSE);
819: fnd_message.set_token ('OPERATOR', l_operator_meaning, FALSE);
820: fnd_message.set_token ('PERCENT_AMOUNT', budget.percent_amt, FALSE);
821: fnd_message.set_token ('DATE', l_today_date, FALSE);
822: l_message := fnd_message.get;

Line 819: fnd_message.set_token ('OPERATOR', l_operator_meaning, FALSE);

815: ELSE
816: fnd_message.set_name ('OZF', 'OZF_WF_NTF_QUOTA_THRS_CONS_FYI');
817: fnd_message.set_token ('BUDGET_NAME', l_budget_name, FALSE);
818: fnd_message.set_token ('VALUE_LIMIT', l_valuelimit_name, FALSE);
819: fnd_message.set_token ('OPERATOR', l_operator_meaning, FALSE);
820: fnd_message.set_token ('PERCENT_AMOUNT', budget.percent_amt, FALSE);
821: fnd_message.set_token ('DATE', l_today_date, FALSE);
822: l_message := fnd_message.get;
823: END IF;

Line 820: fnd_message.set_token ('PERCENT_AMOUNT', budget.percent_amt, FALSE);

816: fnd_message.set_name ('OZF', 'OZF_WF_NTF_QUOTA_THRS_CONS_FYI');
817: fnd_message.set_token ('BUDGET_NAME', l_budget_name, FALSE);
818: fnd_message.set_token ('VALUE_LIMIT', l_valuelimit_name, FALSE);
819: fnd_message.set_token ('OPERATOR', l_operator_meaning, FALSE);
820: fnd_message.set_token ('PERCENT_AMOUNT', budget.percent_amt, FALSE);
821: fnd_message.set_token ('DATE', l_today_date, FALSE);
822: l_message := fnd_message.get;
823: END IF;
824:

Line 821: fnd_message.set_token ('DATE', l_today_date, FALSE);

817: fnd_message.set_token ('BUDGET_NAME', l_budget_name, FALSE);
818: fnd_message.set_token ('VALUE_LIMIT', l_valuelimit_name, FALSE);
819: fnd_message.set_token ('OPERATOR', l_operator_meaning, FALSE);
820: fnd_message.set_token ('PERCENT_AMOUNT', budget.percent_amt, FALSE);
821: fnd_message.set_token ('DATE', l_today_date, FALSE);
822: l_message := fnd_message.get;
823: END IF;
824:
825:

Line 822: l_message := fnd_message.get;

818: fnd_message.set_token ('VALUE_LIMIT', l_valuelimit_name, FALSE);
819: fnd_message.set_token ('OPERATOR', l_operator_meaning, FALSE);
820: fnd_message.set_token ('PERCENT_AMOUNT', budget.percent_amt, FALSE);
821: fnd_message.set_token ('DATE', l_today_date, FALSE);
822: l_message := fnd_message.get;
823: END IF;
824:
825:
826: OZF_Utility_PVT.create_log(l_return_status,