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 OZF_UTILITY_PVT

Line 35: -- ozf_utility_pvt.send_wf_standalone_message

31: -- PROCEDURE
32: -- start_process
33: --
34: -- Sends notification to budget owner by calling the procedure
35: -- ozf_utility_pvt.send_wf_standalone_message
36:
37: -----------------------------------------------------------------------
38: PROCEDURE start_process(
39: p_api_version_number IN NUMBER

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

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

Line 75: ozf_utility_pvt.send_wf_standalone_message(

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

Line 89: ozf_utility_pvt.send_wf_standalone_message(

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

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

373: --SAVEPOINT validate_quota_threshold;
374:
375: -- Debug Message
376: IF G_DEBUG THEN
377: OZF_UTILITY_PVT.debug_message('Private QUOTA API: ' || l_api_name || ' start');
378: END IF;
379: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inside quota api ....... ' );
380: OPEN c_trans_seq;
381: FETCH c_trans_seq INTO l_trans_id;

Line 488: OZF_UTILITY_PVT.debug_message('l_operation_result: ' || l_operation_result);

484: l_base_line_amt,
485: budget.operator_code,
486: l_operation_result);
487: IF G_DEBUG THEN
488: OZF_UTILITY_PVT.debug_message('l_operation_result: ' || l_operation_result);
489: END IF;
490: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_operation_result :' || l_operation_result );
491:
492: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

589: l_base_line_amt,
590: budget.operator_code,
591: l_operation_result);
592: IF G_DEBUG THEN
593: OZF_UTILITY_PVT.debug_message('Operator: ' || l_operation_result);
594: END IF;
595: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_operation_result :' || l_operation_result );
596:
597: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

709: l_base_line_amt,
710: budget.operator_code,
711: l_operation_result);
712: IF G_DEBUG THEN
713: OZF_UTILITY_PVT.debug_message('Operator: ' || l_operation_result);
714: END IF;
715: FND_FILE.PUT_LINE(FND_FILE.LOG,'budget.operator_code :' || budget.operator_code );
716: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_operation_result :' || l_operation_result );
717:

Line 739: OZF_UTILITY_PVT.debug_message(' budget.alert_type:' || budget.alert_type);

735: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
736: RAISE FND_API.G_EXC_ERROR;
737: END IF;
738: l_operation_result_notify := 'VIOLATED';
739: OZF_UTILITY_PVT.debug_message(' budget.alert_type:' || budget.alert_type);
740: OZF_UTILITY_PVT.debug_message(' l_alert_no:' ||l_alert_no );
741: FND_FILE.PUT_LINE(FND_FILE.LOG,' budget.alert_type:' || budget.alert_type);
742: FND_FILE.PUT_LINE(FND_FILE.LOG,' l_alert_no:' ||l_alert_no );
743: END IF;

Line 740: OZF_UTILITY_PVT.debug_message(' l_alert_no:' ||l_alert_no );

736: RAISE FND_API.G_EXC_ERROR;
737: END IF;
738: l_operation_result_notify := 'VIOLATED';
739: OZF_UTILITY_PVT.debug_message(' budget.alert_type:' || budget.alert_type);
740: OZF_UTILITY_PVT.debug_message(' l_alert_no:' ||l_alert_no );
741: FND_FILE.PUT_LINE(FND_FILE.LOG,' budget.alert_type:' || budget.alert_type);
742: FND_FILE.PUT_LINE(FND_FILE.LOG,' l_alert_no:' ||l_alert_no );
743: END IF;
744: END LOOP;

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

767: END IF;
768: FND_FILE.PUT_LINE(FND_FILE.LOG,' l_notification_result : ' || l_notification_result);
769: --l_notification_result will drive write_to_log
770: IF G_DEBUG THEN
771: OZF_UTILITY_PVT.debug_message('Notify result: ' || l_notification_result );
772: END IF;
773:
774: --Get lookup meaning
775:

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

772: END IF;
773:
774: --Get lookup meaning
775:
776: l_period_meaning := ozf_utility_pvt.get_lookup_meaning('AMS_TRIGGER_FREQUENCY_TYPE'
777: ,budget.frequency_period);
778:
779: IF l_notification_result = 'NOTIFY' THEN
780:

Line 826: OZF_Utility_PVT.create_log(l_return_status,

822: l_message := fnd_message.get;
823: END IF;
824:
825:
826: OZF_Utility_PVT.create_log(l_return_status,
827: 'FTHO',
828: budget.threshold_rule_id,
829: l_message,
830: 1,

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

898: OPEN c_log_seq;
899: FETCH c_log_seq INTO l_log_id;
900: CLOSE c_log_seq;
901:
902: OZF_Utility_PVT.create_log(x_return_status =>l_return_status,
903: p_arc_log_used_by =>'FTHO',
904: p_log_used_by_id => l_notify_table(i).owner,
905: p_msg_data =>l_notify_table(i).message_text,
906: p_msg_level =>1,

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

912: p_notification_creat_date => SYSDATE,
913: p_activity_log_id => l_log_id
914: );
915: IF G_DEBUG THEN
916: OZF_UTILITY_PVT.debug_message('Call workflow: ' || l_return_status );
917: END IF;
918:
919: start_process(l_api_version_number,
920: l_Msg_Count,

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

935:
936: COMMIT;
937:
938: IF G_DEBUG THEN
939: OZF_UTILITY_PVT.debug_message('PUBLIC QUOTA API: ' || l_api_name || 'END');
940: END IF;
941: x_retcode := 0;
942:
943: ozf_utility_pvt.write_conc_log(l_msg_data);

Line 943: ozf_utility_pvt.write_conc_log(l_msg_data);

939: OZF_UTILITY_PVT.debug_message('PUBLIC QUOTA API: ' || l_api_name || 'END');
940: END IF;
941: x_retcode := 0;
942:
943: ozf_utility_pvt.write_conc_log(l_msg_data);
944:
945: FND_FILE.PUT_LINE(FND_FILE.LOG,'End of quota validation : ' );
946: -- RAISE FND_API.G_EXC_ERROR;
947: EXCEPTION

Line 954: ozf_utility_pvt.write_conc_log(l_msg_data);

950: --ROLLBACK TO validate_quota_threshold;
951: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception G_EXC_ERROR '||l_api_name);
952: x_retcode := 1;
953: x_errbuf := substr(l_msg_data,1,1000);
954: ozf_utility_pvt.write_conc_log(l_msg_data);
955:
956: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
957: --ROLLBACK TO validate_quota_threshold;
958: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception G_EXC_UNEXPECTED_ERROR '||l_api_name);

Line 961: ozf_utility_pvt.write_conc_log(l_msg_data);

957: --ROLLBACK TO validate_quota_threshold;
958: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception G_EXC_UNEXPECTED_ERROR '||l_api_name);
959: x_retcode := 1;
960: x_errbuf := substr(l_msg_data,1,1000);
961: ozf_utility_pvt.write_conc_log(l_msg_data);
962:
963: WHEN OTHERS THEN
964: --ROLLBACK TO validate_quota_threshold;
965: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception OTHERS '||l_api_name);

Line 969: ozf_utility_pvt.write_conc_log(l_msg_data);

965: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception OTHERS '||l_api_name);
966: x_retcode := 1;
967: x_errbuf := substr(l_msg_data,1,1000);
968: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error : ' || SQLCODE||SQLERRM);
969: ozf_utility_pvt.write_conc_log(l_msg_data);
970:
971: END validate_quota_threshold;
972:
973: -----------------------------------------------------------------------

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

1009: FND_MSG_PUB.initialize;
1010: END IF;
1011:
1012: -- Debug Message
1013: --OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1014:
1015: -- Initialize API return status to SUCCESS
1016: x_return_status := FND_API.G_RET_STS_SUCCESS;
1017:

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

1040: END IF;
1041:
1042: END IF; -- for main IF/ELSIF
1043:
1044: --OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1045:
1046: -- Standard call to get message count and if count is 1, get message info.
1047: FND_MSG_PUB.Count_And_Get
1048: (p_count => x_msg_count,

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

1151: FND_MSG_PUB.initialize;
1152: END IF;
1153:
1154: -- Debug Message
1155: --OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1156:
1157:
1158: -- Initialize API return status to SUCCESS
1159: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1197: x_result := ('NOT NOTIFY');
1198: END IF;
1199:
1200: IF G_DEBUG THEN
1201: OZF_UTILITY_PVT.debug_message('Private API: Notified day' || l_notify_freq_days || ' end ' ||x_result );
1202: END IF;
1203:
1204: -- Standard call to get message count and if count is 1, get message info.
1205: FND_MSG_PUB.Count_And_Get

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

1286: THEN
1287: FND_MSG_PUB.initialize;
1288: END IF;
1289:
1290: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');
1291:
1292: FND_FILE.PUT_LINE(FND_FILE.LOG,' p_resource_id: '|| p_resource_id);
1293: FND_FILE.PUT_LINE(FND_FILE.LOG,' p_alert_for: '|| p_alert_for);
1294: FND_FILE.PUT_LINE(FND_FILE.LOG,' p_product_attribute: '|| p_product_attribute);

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

1579: END;
1580: END IF;
1581:
1582:
1583: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1584:
1585: -- Standard call to get message count and if count is 1, get message info.
1586: FND_MSG_PUB.Count_And_Get
1587: (p_count => x_msg_count,