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 OZF_UTILITY_PVT

Line 56: OZF_UTILITY_PVT.debug_message('Entering ams_threshold_notify.Start_process : ');

52: l_strBody VARCHAR2(2000);
53:
54: BEGIN
55: IF G_DEBUG THEN
56: OZF_UTILITY_PVT.debug_message('Entering ams_threshold_notify.Start_process : ');
57: END IF;
58:
59:
60: -- Initialize API return status to SUCCESS

Line 74: ozf_utility_pvt.send_wf_standalone_message(

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
78: ,x_notif_id => l_notification_id

Line 88: ozf_utility_pvt.send_wf_standalone_message(

84: END IF;
85:
86:
87: IF p_parent_owner_id <>0 THEN
88: ozf_utility_pvt.send_wf_standalone_message(
89: p_subject => l_strChildSubject
90: ,p_body => l_strBody
91: ,p_send_to_res_id => p_parent_owner_id
92: ,x_notif_id => l_notification_id

Line 155: ozf_utility_pvt.debug_message(' threshold Id is :'||p_object_id );

151: l_parameter_list := WF_PARAMETER_LIST_T();
152:
153:
154: IF G_DEBUG THEN
155: ozf_utility_pvt.debug_message(' threshold Id is :'||p_object_id );
156: END IF;
157:
158: wf_event.AddParameterToList(p_name => 'P_THRESH_ID',
159: p_value => p_object_id,

Line 163: ozf_utility_pvt.debug_message('Item Key is :'||l_item_key);

159: p_value => p_object_id,
160: p_parameterlist => l_parameter_list);
161:
162: IF G_DEBUG THEN
163: ozf_utility_pvt.debug_message('Item Key is :'||l_item_key);
164: END IF;
165:
166: wf_event.raise( p_event_name =>'oracle.apps.ozf.fund.threshold.reach',
167: p_event_key => l_item_key,

Line 174: ozf_utility_pvt.debug_message('Exception in raising business event');

170:
171: EXCEPTION
172: WHEN OTHERS THEN
173: RAISE Fnd_Api.g_exc_error;
174: ozf_utility_pvt.debug_message('Exception in raising business event');
175: END;
176:
177:
178: -----------------------------------------------------------------------

Line 263: --OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

259: -- FND_MSG_PUB.initialize;
260: -- END IF;
261:
262: -- Debug Message
263: --OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
264:
265:
266: -- Initialize API return status to SUCCESS
267: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 347: --OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

343: END IF; --for main IF/elsifs
344:
345: x_result := l_commit_amt;
346:
347: --OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
348:
349: -- Standard call to get message count and if count is 1, get message info.
350: FND_MSG_PUB.Count_And_Get
351: (p_count => x_msg_count,

Line 473: --OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

469: FND_MSG_PUB.initialize;
470: END IF;
471:
472: -- Debug Message
473: --OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
474:
475:
476: -- Initialize API return status to SUCCESS
477: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 553: --OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

549: ELSE
550: x_result := 0;
551: END IF;
552:
553: --OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
554:
555: -- Standard call to get message count and if count is 1, get message info.
556: FND_MSG_PUB.Count_And_Get
557: (p_count => x_msg_count,

Line 632: --OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

628: FND_MSG_PUB.initialize;
629: END IF;
630:
631: -- Debug Message
632: --OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
633:
634:
635: -- Initialize API return status to SUCCESS
636: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 664: --OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

660: END IF;
661:
662: END IF; -- for main IF/ELSIF
663:
664: --OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
665:
666: -- Standard call to get message count and if count is 1, get message info.
667: FND_MSG_PUB.Count_And_Get
668: (p_count => x_msg_count,

Line 775: --OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

771: FND_MSG_PUB.initialize;
772: END IF;
773:
774: -- Debug Message
775: --OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
776:
777:
778: -- Initialize API return status to SUCCESS
779: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 822: OZF_UTILITY_PVT.debug_message('Private API: Notified day' || l_notify_freq_days || ' end ' ||x_result );

818: x_result := ('NOT NOTIFY');
819: END IF;
820:
821: IF G_DEBUG THEN
822: OZF_UTILITY_PVT.debug_message('Private API: Notified day' || l_notify_freq_days || ' end ' ||x_result );
823: END IF;
824:
825: -- Standard call to get message count and if count is 1, get message info.
826: FND_MSG_PUB.Count_And_Get

Line 1028: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

1024: SAVEPOINT VALIDATE_THRESHOLD_RULE_PVT;
1025:
1026: -- Debug Message
1027: IF G_DEBUG THEN
1028: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1029: END IF;
1030:
1031: -- Initialize API return status to SUCCESS
1032: -- x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1054: OZF_UTILITY_PVT.debug_message('Value limit: ' || l_value_limit);

1050: budget.value_limit,
1051: 'OFFLINE',
1052: l_value_limit);
1053: IF G_DEBUG THEN
1054: OZF_UTILITY_PVT.debug_message('Value limit: ' || l_value_limit);
1055: END IF;
1056:
1057: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1058: RAISE FND_API.G_EXC_ERROR;

Line 1073: OZF_UTILITY_PVT.debug_message('Base limit: ' || l_base_line_amt);

1069: budget.percent_amt,
1070: budget.base_line,
1071: l_base_line_amt);
1072: IF G_DEBUG THEN
1073: OZF_UTILITY_PVT.debug_message('Base limit: ' || l_base_line_amt);
1074: END IF;
1075:
1076: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1077: RAISE FND_API.G_EXC_ERROR;

Line 1091: OZF_UTILITY_PVT.debug_message('Operator: ' || l_operation_result);

1087: l_base_line_amt,
1088: budget.operator_code,
1089: l_operation_result);
1090: IF G_DEBUG THEN
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');

Line 1131: OZF_UTILITY_PVT.debug_message('Notify result: ' || l_notification_result );

1127: RAISE FND_API.G_EXC_ERROR;
1128: END IF;
1129: --l_notification_result will drive write_to_log
1130: IF G_DEBUG THEN
1131: OZF_UTILITY_PVT.debug_message('Notify result: ' || l_notification_result );
1132: END IF;
1133:
1134: --Get lookup meaning
1135:

Line 1136: l_period_meaning := ozf_utility_pvt.get_lookup_meaning('AMS_TRIGGER_FREQUENCY_TYPE'

1132: END IF;
1133:
1134: --Get lookup meaning
1135:
1136: l_period_meaning := ozf_utility_pvt.get_lookup_meaning('AMS_TRIGGER_FREQUENCY_TYPE'
1137: ,budget.frequency_period);
1138:
1139: IF l_notification_result = 'NOTIFY' THEN
1140: -- raise business event.

Line 1162: OZF_Utility_PVT.create_log(l_return_status,

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,
1165: l_message,
1166: 1,

Line 1254: OZF_Utility_PVT.create_log(x_return_status =>l_return_status,

1250: FETCH c_log_seq INTO l_log_id;
1251: CLOSE c_log_seq;
1252:
1253: /* No need to store all the combined messages in log table -bug 5390527
1254: OZF_Utility_PVT.create_log(x_return_status =>l_return_status,
1255: p_arc_log_used_by =>'FTHO',
1256: p_log_used_by_id => l_notify_table(i).owner,
1257: p_msg_data =>l_notify_table(i).message_text,
1258: p_msg_level =>1,

Line 1268: OZF_UTILITY_PVT.debug_message('Call workflow: ' || l_return_status );

1264: p_notification_creat_date => SYSDATE,
1265: p_activity_log_id => l_log_id
1266: );*/
1267: IF G_DEBUG THEN
1268: OZF_UTILITY_PVT.debug_message('Call workflow: ' || l_return_status );
1269: END IF;
1270:
1271: start_process(l_api_version_number,
1272: l_Msg_Count,

Line 1289: OZF_UTILITY_PVT.debug_message('PUBLIC API: ' || l_api_name || 'END');

1285: END IF;
1286:
1287:
1288: IF G_DEBUG THEN
1289: OZF_UTILITY_PVT.debug_message('PUBLIC API: ' || l_api_name || 'END');
1290: END IF;
1291: x_retcode := 0;
1292:
1293: ozf_utility_pvt.write_conc_log(l_msg_data);

Line 1293: ozf_utility_pvt.write_conc_log(l_msg_data);

1289: OZF_UTILITY_PVT.debug_message('PUBLIC API: ' || l_api_name || 'END');
1290: END IF;
1291: x_retcode := 0;
1292:
1293: ozf_utility_pvt.write_conc_log(l_msg_data);
1294: OZF_UTILITY_PVT.debug_message( 'End of Budget Threshold ........ ');
1295: OZF_UTILITY_PVT.debug_message( 'Start of Quota Threshold ........ ');
1296:
1297: FND_FILE.PUT_LINE(FND_FILE.LOG, 'End of Budget Threshold ........ ');

Line 1294: OZF_UTILITY_PVT.debug_message( 'End of Budget Threshold ........ ');

1290: END IF;
1291: x_retcode := 0;
1292:
1293: ozf_utility_pvt.write_conc_log(l_msg_data);
1294: OZF_UTILITY_PVT.debug_message( 'End of Budget Threshold ........ ');
1295: OZF_UTILITY_PVT.debug_message( 'Start of Quota Threshold ........ ');
1296:
1297: FND_FILE.PUT_LINE(FND_FILE.LOG, 'End of Budget Threshold ........ ');
1298: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Start of Quota Threshold ........ ');

Line 1295: OZF_UTILITY_PVT.debug_message( 'Start of Quota Threshold ........ ');

1291: x_retcode := 0;
1292:
1293: ozf_utility_pvt.write_conc_log(l_msg_data);
1294: OZF_UTILITY_PVT.debug_message( 'End of Budget Threshold ........ ');
1295: OZF_UTILITY_PVT.debug_message( 'Start of Quota Threshold ........ ');
1296:
1297: FND_FILE.PUT_LINE(FND_FILE.LOG, 'End of Budget Threshold ........ ');
1298: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Start of Quota Threshold ........ ');
1299: OZF_QUOTA_THRESHOLD_PVT.validate_quota_threshold(

Line 1310: OZF_UTILITY_PVT.debug_message( 'End of Quota Threshold ........ ');

1306: RAISE FND_API.G_EXC_ERROR;
1307: END IF;
1308: COMMIT;
1309: FND_FILE.PUT_LINE(FND_FILE.LOG, 'End of Quota Threshold ........ ');
1310: OZF_UTILITY_PVT.debug_message( 'End of Quota Threshold ........ ');
1311: EXCEPTION
1312:
1313: WHEN FND_API.G_EXC_ERROR THEN
1314: ROLLBACK TO VALIDATE_THRESHOLD_RULE_PVT;

Line 1318: ozf_utility_pvt.write_conc_log(x_errbuf);

1314: ROLLBACK TO VALIDATE_THRESHOLD_RULE_PVT;
1315: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception G_EXC_ERROR '||l_api_name);
1316: x_retcode := 1;
1317: x_errbuf := l_msg_data;
1318: ozf_utility_pvt.write_conc_log(x_errbuf);
1319:
1320: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1321: ROLLBACK TO VALIDATE_THRESHOLD_RULE_PVT;
1322: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception G_EXC_UNEXPECTED_ERROR '||l_api_name);

Line 1325: ozf_utility_pvt.write_conc_log(x_errbuf);

1321: ROLLBACK TO VALIDATE_THRESHOLD_RULE_PVT;
1322: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception G_EXC_UNEXPECTED_ERROR '||l_api_name);
1323: x_retcode := 1;
1324: x_errbuf := l_msg_data;
1325: ozf_utility_pvt.write_conc_log(x_errbuf);
1326:
1327: WHEN OTHERS THEN
1328: ROLLBACK TO VALIDATE_THRESHOLD_RULE_PVT;
1329: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception OTHERS '||l_api_name);

Line 1332: ozf_utility_pvt.write_conc_log(x_errbuf);

1328: ROLLBACK TO VALIDATE_THRESHOLD_RULE_PVT;
1329: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception OTHERS '||l_api_name);
1330: x_retcode := 1;
1331: x_errbuf := l_msg_data;
1332: ozf_utility_pvt.write_conc_log(x_errbuf);
1333: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error : ' || SQLCODE||SQLERRM);
1334: END validate_threshold;
1335:
1336: END Ozf_Threshold_Pvt;