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_THRESHOLD_PVT dependencies on FND_MESSAGE

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

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

Line 64: l_strSubject := fnd_message.get;

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

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

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

Line 66: l_strChildSubject := fnd_message.get;

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

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

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

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

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

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 73: l_strBody := l_strBody ||fnd_message.get ;

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
77: ,p_send_to_res_id => p_owner_id

Line 1095: fnd_message.set_name ('OZF', 'OZF_THRESHOLD_LESS');

1091: OZF_UTILITY_PVT.debug_message('Operator: ' || l_operation_result);
1092: END IF;
1093: --Get operator meaning.
1094: IF budget.operator_code = '0' THEN
1095: fnd_message.set_name ('OZF', 'OZF_THRESHOLD_LESS');
1096: l_operator_meaning := fnd_message.get;
1097: ELSIF budget.operator_code = '1' THEN
1098: fnd_message.set_name ('OZF', 'OZF_THRESHOLD_EQUAL');
1099: l_operator_meaning := fnd_message.get;

Line 1096: l_operator_meaning := fnd_message.get;

1092: END IF;
1093: --Get operator meaning.
1094: IF budget.operator_code = '0' THEN
1095: fnd_message.set_name ('OZF', 'OZF_THRESHOLD_LESS');
1096: l_operator_meaning := fnd_message.get;
1097: ELSIF budget.operator_code = '1' THEN
1098: fnd_message.set_name ('OZF', 'OZF_THRESHOLD_EQUAL');
1099: l_operator_meaning := fnd_message.get;
1100: ELSE

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

1094: IF budget.operator_code = '0' THEN
1095: fnd_message.set_name ('OZF', 'OZF_THRESHOLD_LESS');
1096: l_operator_meaning := fnd_message.get;
1097: ELSIF budget.operator_code = '1' THEN
1098: fnd_message.set_name ('OZF', 'OZF_THRESHOLD_EQUAL');
1099: l_operator_meaning := fnd_message.get;
1100: ELSE
1101: fnd_message.set_name ('OZF', 'OZF_THRESHOLD_LARGER');
1102: l_operator_meaning := fnd_message.get;

Line 1099: l_operator_meaning := fnd_message.get;

1095: fnd_message.set_name ('OZF', 'OZF_THRESHOLD_LESS');
1096: l_operator_meaning := fnd_message.get;
1097: ELSIF budget.operator_code = '1' THEN
1098: fnd_message.set_name ('OZF', 'OZF_THRESHOLD_EQUAL');
1099: l_operator_meaning := fnd_message.get;
1100: ELSE
1101: fnd_message.set_name ('OZF', 'OZF_THRESHOLD_LARGER');
1102: l_operator_meaning := fnd_message.get;
1103: END IF;

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

1097: ELSIF budget.operator_code = '1' THEN
1098: fnd_message.set_name ('OZF', 'OZF_THRESHOLD_EQUAL');
1099: l_operator_meaning := fnd_message.get;
1100: ELSE
1101: fnd_message.set_name ('OZF', 'OZF_THRESHOLD_LARGER');
1102: l_operator_meaning := fnd_message.get;
1103: END IF;
1104:
1105: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1102: l_operator_meaning := fnd_message.get;

1098: fnd_message.set_name ('OZF', 'OZF_THRESHOLD_EQUAL');
1099: l_operator_meaning := fnd_message.get;
1100: ELSE
1101: fnd_message.set_name ('OZF', 'OZF_THRESHOLD_LARGER');
1102: l_operator_meaning := fnd_message.get;
1103: END IF;
1104:
1105: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1106: RAISE FND_API.G_EXC_ERROR;

Line 1152: fnd_message.set_name ('OZF', 'OZF_WF_NTF_THRESHOLD_FYI');

1148: CLOSE c_valuelimit_name;
1149:
1150: select to_char(sysdate, 'dd-Mon-yyyy' ) into l_today_date from dual;
1151:
1152: fnd_message.set_name ('OZF', 'OZF_WF_NTF_THRESHOLD_FYI');
1153: fnd_message.set_token ('BUDGET_NAME', l_budget_name, FALSE);
1154: fnd_message.set_token ('VALUE_LIMIT', l_valuelimit_name, FALSE);
1155: fnd_message.set_token ('OPERATOR', l_operator_meaning, FALSE);
1156: fnd_message.set_token ('PERCENT_AMOUNT', budget.percent_amt, FALSE);

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

1149:
1150: select to_char(sysdate, 'dd-Mon-yyyy' ) into l_today_date from dual;
1151:
1152: fnd_message.set_name ('OZF', 'OZF_WF_NTF_THRESHOLD_FYI');
1153: fnd_message.set_token ('BUDGET_NAME', l_budget_name, FALSE);
1154: fnd_message.set_token ('VALUE_LIMIT', l_valuelimit_name, FALSE);
1155: fnd_message.set_token ('OPERATOR', l_operator_meaning, FALSE);
1156: fnd_message.set_token ('PERCENT_AMOUNT', budget.percent_amt, FALSE);
1157: fnd_message.set_token ('BASE_LINE', budget.base_line, FALSE);

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

1150: select to_char(sysdate, 'dd-Mon-yyyy' ) into l_today_date from dual;
1151:
1152: fnd_message.set_name ('OZF', 'OZF_WF_NTF_THRESHOLD_FYI');
1153: fnd_message.set_token ('BUDGET_NAME', l_budget_name, FALSE);
1154: fnd_message.set_token ('VALUE_LIMIT', l_valuelimit_name, FALSE);
1155: fnd_message.set_token ('OPERATOR', l_operator_meaning, FALSE);
1156: fnd_message.set_token ('PERCENT_AMOUNT', budget.percent_amt, FALSE);
1157: fnd_message.set_token ('BASE_LINE', budget.base_line, FALSE);
1158: fnd_message.set_token ('DATE', l_today_date, FALSE);

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

1151:
1152: fnd_message.set_name ('OZF', 'OZF_WF_NTF_THRESHOLD_FYI');
1153: fnd_message.set_token ('BUDGET_NAME', l_budget_name, FALSE);
1154: fnd_message.set_token ('VALUE_LIMIT', l_valuelimit_name, FALSE);
1155: fnd_message.set_token ('OPERATOR', l_operator_meaning, FALSE);
1156: fnd_message.set_token ('PERCENT_AMOUNT', budget.percent_amt, FALSE);
1157: fnd_message.set_token ('BASE_LINE', budget.base_line, FALSE);
1158: fnd_message.set_token ('DATE', l_today_date, FALSE);
1159:

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

1152: fnd_message.set_name ('OZF', 'OZF_WF_NTF_THRESHOLD_FYI');
1153: fnd_message.set_token ('BUDGET_NAME', l_budget_name, FALSE);
1154: fnd_message.set_token ('VALUE_LIMIT', l_valuelimit_name, FALSE);
1155: fnd_message.set_token ('OPERATOR', l_operator_meaning, FALSE);
1156: fnd_message.set_token ('PERCENT_AMOUNT', budget.percent_amt, FALSE);
1157: fnd_message.set_token ('BASE_LINE', budget.base_line, FALSE);
1158: fnd_message.set_token ('DATE', l_today_date, FALSE);
1159:
1160: l_message := fnd_message.get;

Line 1157: fnd_message.set_token ('BASE_LINE', budget.base_line, FALSE);

1153: fnd_message.set_token ('BUDGET_NAME', l_budget_name, FALSE);
1154: fnd_message.set_token ('VALUE_LIMIT', l_valuelimit_name, FALSE);
1155: fnd_message.set_token ('OPERATOR', l_operator_meaning, FALSE);
1156: fnd_message.set_token ('PERCENT_AMOUNT', budget.percent_amt, FALSE);
1157: fnd_message.set_token ('BASE_LINE', budget.base_line, FALSE);
1158: fnd_message.set_token ('DATE', l_today_date, FALSE);
1159:
1160: l_message := fnd_message.get;
1161:

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

1154: fnd_message.set_token ('VALUE_LIMIT', l_valuelimit_name, FALSE);
1155: fnd_message.set_token ('OPERATOR', l_operator_meaning, FALSE);
1156: fnd_message.set_token ('PERCENT_AMOUNT', budget.percent_amt, FALSE);
1157: fnd_message.set_token ('BASE_LINE', budget.base_line, FALSE);
1158: fnd_message.set_token ('DATE', l_today_date, FALSE);
1159:
1160: l_message := fnd_message.get;
1161:
1162: OZF_Utility_PVT.create_log(l_return_status,

Line 1160: l_message := fnd_message.get;

1156: fnd_message.set_token ('PERCENT_AMOUNT', budget.percent_amt, FALSE);
1157: fnd_message.set_token ('BASE_LINE', budget.base_line, FALSE);
1158: fnd_message.set_token ('DATE', l_today_date, FALSE);
1159:
1160: l_message := fnd_message.get;
1161:
1162: OZF_Utility_PVT.create_log(l_return_status,
1163: 'FTHO',
1164: budget.threshold_rule_id,