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.FND_SVC_COMPONENT dependencies on FND_SVC_COMPONENT

Line 1: PACKAGE BODY FND_SVC_COMPONENT AS

1: PACKAGE BODY FND_SVC_COMPONENT AS
2: /* $Header: AFSVCMPB.pls 120.4 2006/05/03 07:45:32 nravindr ship $ */
3:
4: ------------------------------------------------------------------------------
5: -- **** PRIVATE VARIABLE - NOT FOR CUSTOMER USE ******

Line 89: l_component_name fnd_svc_components.component_name%TYPE;

85: l_event_params fnd_svc_comp_requests.event_params%TYPE;
86: l_event_frequency fnd_svc_comp_requests.event_frequency%TYPE;
87: l_requested_by_user fnd_svc_comp_requests.requested_by_user%TYPE;
88:
89: l_component_name fnd_svc_components.component_name%TYPE;
90: l_component_type fnd_svc_components.component_type%TYPE;
91: l_component_status fnd_svc_components.component_status%TYPE;
92: l_container_type fnd_svc_components.container_type%TYPE;
93: l_container_name fnd_svc_components.standalone_container_name%TYPE;

Line 90: l_component_type fnd_svc_components.component_type%TYPE;

86: l_event_frequency fnd_svc_comp_requests.event_frequency%TYPE;
87: l_requested_by_user fnd_svc_comp_requests.requested_by_user%TYPE;
88:
89: l_component_name fnd_svc_components.component_name%TYPE;
90: l_component_type fnd_svc_components.component_type%TYPE;
91: l_component_status fnd_svc_components.component_status%TYPE;
92: l_container_type fnd_svc_components.container_type%TYPE;
93: l_container_name fnd_svc_components.standalone_container_name%TYPE;
94:

Line 91: l_component_status fnd_svc_components.component_status%TYPE;

87: l_requested_by_user fnd_svc_comp_requests.requested_by_user%TYPE;
88:
89: l_component_name fnd_svc_components.component_name%TYPE;
90: l_component_type fnd_svc_components.component_type%TYPE;
91: l_component_status fnd_svc_components.component_status%TYPE;
92: l_container_type fnd_svc_components.container_type%TYPE;
93: l_container_name fnd_svc_components.standalone_container_name%TYPE;
94:
95: l_request_history_id fnd_svc_comp_requests_h.request_history_id%TYPE;

Line 92: l_container_type fnd_svc_components.container_type%TYPE;

88:
89: l_component_name fnd_svc_components.component_name%TYPE;
90: l_component_type fnd_svc_components.component_type%TYPE;
91: l_component_status fnd_svc_components.component_status%TYPE;
92: l_container_type fnd_svc_components.container_type%TYPE;
93: l_container_name fnd_svc_components.standalone_container_name%TYPE;
94:
95: l_request_history_id fnd_svc_comp_requests_h.request_history_id%TYPE;
96: l_rowid VARCHAR2(64);

Line 93: l_container_name fnd_svc_components.standalone_container_name%TYPE;

89: l_component_name fnd_svc_components.component_name%TYPE;
90: l_component_type fnd_svc_components.component_type%TYPE;
91: l_component_status fnd_svc_components.component_status%TYPE;
92: l_container_type fnd_svc_components.container_type%TYPE;
93: l_container_name fnd_svc_components.standalone_container_name%TYPE;
94:
95: l_request_history_id fnd_svc_comp_requests_h.request_history_id%TYPE;
96: l_rowid VARCHAR2(64);
97: l_Status varchar2(30) := FND_SVC_COMPONENT.pv_adminStatusCompleted;

Line 97: l_Status varchar2(30) := FND_SVC_COMPONENT.pv_adminStatusCompleted;

93: l_container_name fnd_svc_components.standalone_container_name%TYPE;
94:
95: l_request_history_id fnd_svc_comp_requests_h.request_history_id%TYPE;
96: l_rowid VARCHAR2(64);
97: l_Status varchar2(30) := FND_SVC_COMPONENT.pv_adminStatusCompleted;
98:
99: l_ErrorMsg VARCHAR2 (4000);
100: l_RetCode NUMBER := 0;
101:

Line 117: FROM fnd_svc_comp_requests a, fnd_svc_components b

113: SELECT a.component_id, event_name, event_params, event_frequency, requested_by_user, component_name,
114: component_status, component_type, container_type, standalone_container_name
115: INTO l_component_id, l_event_name, l_event_params, l_event_frequency, l_requested_by_user,
116: l_component_name, l_component_status, l_component_type, l_container_type, l_container_name
117: FROM fnd_svc_comp_requests a, fnd_svc_components b
118: WHERE component_request_id = p_component_request_id and
119: a.component_id = b.component_id;
120:
121: IF l_container_type = pv_Container_Type_GSM THEN

Line 124: FROM fnd_svc_components_v

120:
121: IF l_container_type = pv_Container_Type_GSM THEN
122: SELECT concurrent_queue_name
123: INTO l_container_name
124: FROM fnd_svc_components_v
125: WHERE component_id = l_component_id;
126: END IF;
127:
128: EXCEPTION

Line 139: 'wf.plsql.FND_SVC_COMPONENT.EXECUTE_REQUEST.request_lookup_failed',

135: -- getting executed. Donot do anything, return
136: -- With the deletion of request, job for future will anyway be deleted
137: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then
138: wf_log_pkg.STRING(wf_log_pkg.LEVEL_ERROR,
139: 'wf.plsql.FND_SVC_COMPONENT.EXECUTE_REQUEST.request_lookup_failed',
140: 'Could not get request info, SQLCODE: '||SQLCODE);
141: end if;
142: return;
143: END;

Line 147: 'wf.plsql.FND_SVC_COMPONENT.EXECUTE_REQUEST.executing',

143: END;
144:
145: if (wf_log_pkg.level_exception >= fnd_log.g_current_runtime_level) then
146: wf_log_pkg.STRING (wf_log_pkg.LEVEL_EXCEPTION,
147: 'wf.plsql.FND_SVC_COMPONENT.EXECUTE_REQUEST.executing',
148: 'Request Type: '||l_event_name||
149: ', Job no.: '||l_job_id||
150: ', Component_id: '||l_Component_id);
151: end if;

Line 153: if l_event_name = FND_SVC_COMPONENT.pv_Event_Suspend then

149: ', Job no.: '||l_job_id||
150: ', Component_id: '||l_Component_id);
151: end if;
152:
153: if l_event_name = FND_SVC_COMPONENT.pv_Event_Suspend then
154:
155: FND_SVC_COMPONENT.Suspend_Component(l_Component_id, l_RetCode, l_ErrorMsg);
156:
157: elsif l_event_name = FND_SVC_COMPONENT.pv_Event_Resume then

Line 155: FND_SVC_COMPONENT.Suspend_Component(l_Component_id, l_RetCode, l_ErrorMsg);

151: end if;
152:
153: if l_event_name = FND_SVC_COMPONENT.pv_Event_Suspend then
154:
155: FND_SVC_COMPONENT.Suspend_Component(l_Component_id, l_RetCode, l_ErrorMsg);
156:
157: elsif l_event_name = FND_SVC_COMPONENT.pv_Event_Resume then
158:
159: FND_SVC_COMPONENT.Resume_Component(l_Component_id, l_RetCode, l_ErrorMsg);

Line 157: elsif l_event_name = FND_SVC_COMPONENT.pv_Event_Resume then

153: if l_event_name = FND_SVC_COMPONENT.pv_Event_Suspend then
154:
155: FND_SVC_COMPONENT.Suspend_Component(l_Component_id, l_RetCode, l_ErrorMsg);
156:
157: elsif l_event_name = FND_SVC_COMPONENT.pv_Event_Resume then
158:
159: FND_SVC_COMPONENT.Resume_Component(l_Component_id, l_RetCode, l_ErrorMsg);
160:
161: elsif l_event_name = FND_SVC_COMPONENT.pv_Event_Stop then

Line 159: FND_SVC_COMPONENT.Resume_Component(l_Component_id, l_RetCode, l_ErrorMsg);

155: FND_SVC_COMPONENT.Suspend_Component(l_Component_id, l_RetCode, l_ErrorMsg);
156:
157: elsif l_event_name = FND_SVC_COMPONENT.pv_Event_Resume then
158:
159: FND_SVC_COMPONENT.Resume_Component(l_Component_id, l_RetCode, l_ErrorMsg);
160:
161: elsif l_event_name = FND_SVC_COMPONENT.pv_Event_Stop then
162:
163: FND_SVC_COMPONENT.Stop_Component(l_Component_id, l_RetCode, l_ErrorMsg);

Line 161: elsif l_event_name = FND_SVC_COMPONENT.pv_Event_Stop then

157: elsif l_event_name = FND_SVC_COMPONENT.pv_Event_Resume then
158:
159: FND_SVC_COMPONENT.Resume_Component(l_Component_id, l_RetCode, l_ErrorMsg);
160:
161: elsif l_event_name = FND_SVC_COMPONENT.pv_Event_Stop then
162:
163: FND_SVC_COMPONENT.Stop_Component(l_Component_id, l_RetCode, l_ErrorMsg);
164:
165: elsif l_event_name = FND_SVC_COMPONENT.pv_Event_Start then

Line 163: FND_SVC_COMPONENT.Stop_Component(l_Component_id, l_RetCode, l_ErrorMsg);

159: FND_SVC_COMPONENT.Resume_Component(l_Component_id, l_RetCode, l_ErrorMsg);
160:
161: elsif l_event_name = FND_SVC_COMPONENT.pv_Event_Stop then
162:
163: FND_SVC_COMPONENT.Stop_Component(l_Component_id, l_RetCode, l_ErrorMsg);
164:
165: elsif l_event_name = FND_SVC_COMPONENT.pv_Event_Start then
166:
167: FND_SVC_COMPONENT.Start_Component(l_Component_id, l_RetCode, l_ErrorMsg);

Line 165: elsif l_event_name = FND_SVC_COMPONENT.pv_Event_Start then

161: elsif l_event_name = FND_SVC_COMPONENT.pv_Event_Stop then
162:
163: FND_SVC_COMPONENT.Stop_Component(l_Component_id, l_RetCode, l_ErrorMsg);
164:
165: elsif l_event_name = FND_SVC_COMPONENT.pv_Event_Start then
166:
167: FND_SVC_COMPONENT.Start_Component(l_Component_id, l_RetCode, l_ErrorMsg);
168:
169: elsif l_event_name = FND_SVC_COMPONENT.pv_Event_Refresh then

Line 167: FND_SVC_COMPONENT.Start_Component(l_Component_id, l_RetCode, l_ErrorMsg);

163: FND_SVC_COMPONENT.Stop_Component(l_Component_id, l_RetCode, l_ErrorMsg);
164:
165: elsif l_event_name = FND_SVC_COMPONENT.pv_Event_Start then
166:
167: FND_SVC_COMPONENT.Start_Component(l_Component_id, l_RetCode, l_ErrorMsg);
168:
169: elsif l_event_name = FND_SVC_COMPONENT.pv_Event_Refresh then
170:
171: FND_SVC_COMPONENT.Refresh_Component(l_Component_id, l_event_params, l_RetCode, l_ErrorMsg);

Line 169: elsif l_event_name = FND_SVC_COMPONENT.pv_Event_Refresh then

165: elsif l_event_name = FND_SVC_COMPONENT.pv_Event_Start then
166:
167: FND_SVC_COMPONENT.Start_Component(l_Component_id, l_RetCode, l_ErrorMsg);
168:
169: elsif l_event_name = FND_SVC_COMPONENT.pv_Event_Refresh then
170:
171: FND_SVC_COMPONENT.Refresh_Component(l_Component_id, l_event_params, l_RetCode, l_ErrorMsg);
172:
173: else

Line 171: FND_SVC_COMPONENT.Refresh_Component(l_Component_id, l_event_params, l_RetCode, l_ErrorMsg);

167: FND_SVC_COMPONENT.Start_Component(l_Component_id, l_RetCode, l_ErrorMsg);
168:
169: elsif l_event_name = FND_SVC_COMPONENT.pv_Event_Refresh then
170:
171: FND_SVC_COMPONENT.Refresh_Component(l_Component_id, l_event_params, l_RetCode, l_ErrorMsg);
172:
173: else
174:
175: FND_SVC_COMPONENT.Generic_Operation (l_Component_id, l_event_name, l_event_params, l_RetCode, l_ErrorMsg);

Line 175: FND_SVC_COMPONENT.Generic_Operation (l_Component_id, l_event_name, l_event_params, l_RetCode, l_ErrorMsg);

171: FND_SVC_COMPONENT.Refresh_Component(l_Component_id, l_event_params, l_RetCode, l_ErrorMsg);
172:
173: else
174:
175: FND_SVC_COMPONENT.Generic_Operation (l_Component_id, l_event_name, l_event_params, l_RetCode, l_ErrorMsg);
176:
177: end if;
178:
179: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

Line 181: 'wf.plsql.FND_SVC_COMPONENT.EXECUTE_REQUEST.executed',

177: end if;
178:
179: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
180: wf_log_pkg.STRING (wf_log_pkg.LEVEL_STATEMENT,
181: 'wf.plsql.FND_SVC_COMPONENT.EXECUTE_REQUEST.executed',
182: 'After component control operation, Return code: '||l_RetCode);
183: end if;
184:
185: if l_RetCode = FND_SVC_COMPONENT.pv_retInvalidComponentState then

Line 185: if l_RetCode = FND_SVC_COMPONENT.pv_retInvalidComponentState then

181: 'wf.plsql.FND_SVC_COMPONENT.EXECUTE_REQUEST.executed',
182: 'After component control operation, Return code: '||l_RetCode);
183: end if;
184:
185: if l_RetCode = FND_SVC_COMPONENT.pv_retInvalidComponentState then
186:
187: -- SKIPPED
188: l_Status := FND_SVC_COMPONENT.pv_adminStatusSkipped;
189:

Line 188: l_Status := FND_SVC_COMPONENT.pv_adminStatusSkipped;

184:
185: if l_RetCode = FND_SVC_COMPONENT.pv_retInvalidComponentState then
186:
187: -- SKIPPED
188: l_Status := FND_SVC_COMPONENT.pv_adminStatusSkipped;
189:
190: elsif l_RetCode <> 0 then -- Container not running or other SQL error
191:
192: -- ERRORED

Line 193: l_Status := FND_SVC_COMPONENT.pv_adminStatusErrored;

189:
190: elsif l_RetCode <> 0 then -- Container not running or other SQL error
191:
192: -- ERRORED
193: l_Status := FND_SVC_COMPONENT.pv_adminStatusErrored;
194:
195: end if;
196:
197: --

Line 205: 'wf.plsql.FND_SVC_COMPONENT.EXECUTE_REQUEST.frequency',

201: l_event_frequency = 0) THEN
202:
203: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
204: wf_log_pkg.STRING (wf_log_pkg.LEVEL_STATEMENT,
205: 'wf.plsql.FND_SVC_COMPONENT.EXECUTE_REQUEST.frequency',
206: 'Frequency is null, removing job');
207: end if;
208:
209: Delete_Request(p_component_request_id => p_component_request_id);

Line 219: 'wf.plsql.FND_SVC_COMPONENT.EXECUTE_REQUEST.request_audit',

215: --
216:
217: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
218: wf_log_pkg.STRING (wf_log_pkg.LEVEL_STATEMENT,
219: 'wf.plsql.FND_SVC_COMPONENT.EXECUTE_REQUEST.request_audit',
220: 'Request audited with status: '||l_Status);
221: end if;
222:
223: SELECT fnd_svc_comp_requests_h_s.nextval INTO l_request_history_id FROM dual;

Line 252: 'wf.plsql.FND_SVC_COMPONENT.EXECUTE_REQUEST.error',

248: -- Can come here only because of some SQL error in FND_SVC_COMP_REQUESTS_H_PKG.Insert_Row
249: -- Still we need to commit;
250: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then
251: wf_log_pkg.STRING (wf_log_pkg.LEVEL_ERROR,
252: 'wf.plsql.FND_SVC_COMPONENT.EXECUTE_REQUEST.error',
253: 'Unhandled error, SQLCODE: '||SQLCODE);
254: end if;
255: commit;
256:

Line 270: FROM fnd_svc_components c

266:
267: CURSOR c_Components
268: IS
269: SELECT c.component_status
270: FROM fnd_svc_components c
271: WHERE c.component_type = NVL(p_component_type, c.component_type);
272:
273: BEGIN
274: --

Line 327: l_customization_level fnd_svc_components.customization_level%TYPE;

323:
324: l_rowid VARCHAR2(64);
325: l_component_parameter_id fnd_svc_comp_param_vals.component_parameter_id%TYPE;
326:
327: l_customization_level fnd_svc_components.customization_level%TYPE;
328: l_created_by NUMBER;
329: l_last_updated_by NUMBER;
330: l_last_update_login NUMBER;
331:

Line 352: FROM fnd_svc_components

348: -- Retrieve common data from component
349: --
350: SELECT customization_level, created_by, last_updated_by, last_update_login
351: INTO l_customization_level, l_created_by, l_last_updated_by, l_last_update_login
352: FROM fnd_svc_components
353: WHERE component_id = p_component_id;
354:
355: --
356: -- Insert parameter value

Line 409: 'wf.plsql.FND_SVC_COMPONENT.Get_Container_Status.begin',

405: BEGIN
406:
407: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
408: WF_LOG_PKG.STRING (WF_LOG_PKG.LEVEL_PROCEDURE,
409: 'wf.plsql.FND_SVC_COMPONENT.Get_Container_Status.begin',
410: 'p_container_type: '||p_container_type||
411: ', p_container_name:'||p_container_name);
412: end if;
413:

Line 475: 'wf.plsql.FND_SVC_COMPONENT.Name_Container_Session.begin',

471: BEGIN
472:
473: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
474: WF_LOG_PKG.STRING (WF_LOG_PKG.LEVEL_PROCEDURE,
475: 'wf.plsql.FND_SVC_COMPONENT.Name_Container_Session.begin',
476: 'p_container_type: '||p_container_type||
477: ', p_container_name:'||p_container_name);
478: end if;
479:

Line 531: l_CurrentStatus fnd_svc_components.component_status%TYPE;

527:
528:
529: Function Get_Current_Status(p_Component_Id in NUMBER) return varchar2
530: is
531: l_CurrentStatus fnd_svc_components.component_status%TYPE;
532: begin
533: select component_status into l_CurrentStatus
534: from fnd_svc_components where component_id = p_Component_Id;
535:

Line 534: from fnd_svc_components where component_id = p_Component_Id;

530: is
531: l_CurrentStatus fnd_svc_components.component_status%TYPE;
532: begin
533: select component_status into l_CurrentStatus
534: from fnd_svc_components where component_id = p_Component_Id;
535:
536: return l_CurrentStatus;
537:
538: EXCEPTION

Line 553: l_CurrentStatus fnd_svc_components.component_status%TYPE;

549: p_errbuf OUT NOCOPY VARCHAR2)
550: is
551:
552: l_isValid boolean := false;
553: l_CurrentStatus fnd_svc_components.component_status%TYPE;
554:
555: begin
556:
557: p_retcode := 0;

Line 561: 'wf.plsql.FND_SVC_COMPONENT.IS_OPERATION_VALID.begin',

557: p_retcode := 0;
558:
559: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
560: WF_LOG_PKG.STRING (WF_LOG_PKG.LEVEL_PROCEDURE,
561: 'wf.plsql.FND_SVC_COMPONENT.IS_OPERATION_VALID.begin',
562: 'p_Component_Id: '||p_Component_Id||
563: ', p_Control_Operation:'||p_Control_Operation);
564: end if;
565:

Line 568: if p_Control_Operation = FND_SVC_COMPONENT.pv_opStart then

564: end if;
565:
566: l_CurrentStatus := Get_Current_Status (p_Component_Id => p_Component_Id);
567:
568: if p_Control_Operation = FND_SVC_COMPONENT.pv_opStart then
569:
570: if l_CurrentStatus in (FND_SVC_COMPONENT.pv_Status_Stopped,
571: FND_SVC_COMPONENT.pv_Status_Stopped_Error,
572: FND_SVC_COMPONENT.pv_Status_Deactivated_User,

Line 570: if l_CurrentStatus in (FND_SVC_COMPONENT.pv_Status_Stopped,

566: l_CurrentStatus := Get_Current_Status (p_Component_Id => p_Component_Id);
567:
568: if p_Control_Operation = FND_SVC_COMPONENT.pv_opStart then
569:
570: if l_CurrentStatus in (FND_SVC_COMPONENT.pv_Status_Stopped,
571: FND_SVC_COMPONENT.pv_Status_Stopped_Error,
572: FND_SVC_COMPONENT.pv_Status_Deactivated_User,
573: FND_SVC_COMPONENT.pv_Status_Deactivated_System) then
574: l_isValid := true;

Line 571: FND_SVC_COMPONENT.pv_Status_Stopped_Error,

567:
568: if p_Control_Operation = FND_SVC_COMPONENT.pv_opStart then
569:
570: if l_CurrentStatus in (FND_SVC_COMPONENT.pv_Status_Stopped,
571: FND_SVC_COMPONENT.pv_Status_Stopped_Error,
572: FND_SVC_COMPONENT.pv_Status_Deactivated_User,
573: FND_SVC_COMPONENT.pv_Status_Deactivated_System) then
574: l_isValid := true;
575: else

Line 572: FND_SVC_COMPONENT.pv_Status_Deactivated_User,

568: if p_Control_Operation = FND_SVC_COMPONENT.pv_opStart then
569:
570: if l_CurrentStatus in (FND_SVC_COMPONENT.pv_Status_Stopped,
571: FND_SVC_COMPONENT.pv_Status_Stopped_Error,
572: FND_SVC_COMPONENT.pv_Status_Deactivated_User,
573: FND_SVC_COMPONENT.pv_Status_Deactivated_System) then
574: l_isValid := true;
575: else
576: l_isValid := false;

Line 573: FND_SVC_COMPONENT.pv_Status_Deactivated_System) then

569:
570: if l_CurrentStatus in (FND_SVC_COMPONENT.pv_Status_Stopped,
571: FND_SVC_COMPONENT.pv_Status_Stopped_Error,
572: FND_SVC_COMPONENT.pv_Status_Deactivated_User,
573: FND_SVC_COMPONENT.pv_Status_Deactivated_System) then
574: l_isValid := true;
575: else
576: l_isValid := false;
577: end if;

Line 579: elsif p_Control_Operation = FND_SVC_COMPONENT.pv_opStop then

575: else
576: l_isValid := false;
577: end if;
578:
579: elsif p_Control_Operation = FND_SVC_COMPONENT.pv_opStop then
580:
581: if l_CurrentStatus not in (FND_SVC_COMPONENT.pv_Status_Stopped,
582: FND_SVC_COMPONENT.pv_Status_Stopped_Error,
583: FND_SVC_COMPONENT.pv_Status_Not_Configured,

Line 581: if l_CurrentStatus not in (FND_SVC_COMPONENT.pv_Status_Stopped,

577: end if;
578:
579: elsif p_Control_Operation = FND_SVC_COMPONENT.pv_opStop then
580:
581: if l_CurrentStatus not in (FND_SVC_COMPONENT.pv_Status_Stopped,
582: FND_SVC_COMPONENT.pv_Status_Stopped_Error,
583: FND_SVC_COMPONENT.pv_Status_Not_Configured,
584: FND_SVC_COMPONENT.pv_Status_Deactivated_User,
585: FND_SVC_COMPONENT.pv_Status_Deactivated_System) then

Line 582: FND_SVC_COMPONENT.pv_Status_Stopped_Error,

578:
579: elsif p_Control_Operation = FND_SVC_COMPONENT.pv_opStop then
580:
581: if l_CurrentStatus not in (FND_SVC_COMPONENT.pv_Status_Stopped,
582: FND_SVC_COMPONENT.pv_Status_Stopped_Error,
583: FND_SVC_COMPONENT.pv_Status_Not_Configured,
584: FND_SVC_COMPONENT.pv_Status_Deactivated_User,
585: FND_SVC_COMPONENT.pv_Status_Deactivated_System) then
586: l_isValid := true;

Line 583: FND_SVC_COMPONENT.pv_Status_Not_Configured,

579: elsif p_Control_Operation = FND_SVC_COMPONENT.pv_opStop then
580:
581: if l_CurrentStatus not in (FND_SVC_COMPONENT.pv_Status_Stopped,
582: FND_SVC_COMPONENT.pv_Status_Stopped_Error,
583: FND_SVC_COMPONENT.pv_Status_Not_Configured,
584: FND_SVC_COMPONENT.pv_Status_Deactivated_User,
585: FND_SVC_COMPONENT.pv_Status_Deactivated_System) then
586: l_isValid := true;
587: else

Line 584: FND_SVC_COMPONENT.pv_Status_Deactivated_User,

580:
581: if l_CurrentStatus not in (FND_SVC_COMPONENT.pv_Status_Stopped,
582: FND_SVC_COMPONENT.pv_Status_Stopped_Error,
583: FND_SVC_COMPONENT.pv_Status_Not_Configured,
584: FND_SVC_COMPONENT.pv_Status_Deactivated_User,
585: FND_SVC_COMPONENT.pv_Status_Deactivated_System) then
586: l_isValid := true;
587: else
588: l_isValid := false;

Line 585: FND_SVC_COMPONENT.pv_Status_Deactivated_System) then

581: if l_CurrentStatus not in (FND_SVC_COMPONENT.pv_Status_Stopped,
582: FND_SVC_COMPONENT.pv_Status_Stopped_Error,
583: FND_SVC_COMPONENT.pv_Status_Not_Configured,
584: FND_SVC_COMPONENT.pv_Status_Deactivated_User,
585: FND_SVC_COMPONENT.pv_Status_Deactivated_System) then
586: l_isValid := true;
587: else
588: l_isValid := false;
589: end if;

Line 591: elsif p_Control_Operation = FND_SVC_COMPONENT.pv_opSuspend then

587: else
588: l_isValid := false;
589: end if;
590:
591: elsif p_Control_Operation = FND_SVC_COMPONENT.pv_opSuspend then
592:
593: if l_CurrentStatus = FND_SVC_COMPONENT.pv_Status_Running then
594: l_isValid := true;
595: else

Line 593: if l_CurrentStatus = FND_SVC_COMPONENT.pv_Status_Running then

589: end if;
590:
591: elsif p_Control_Operation = FND_SVC_COMPONENT.pv_opSuspend then
592:
593: if l_CurrentStatus = FND_SVC_COMPONENT.pv_Status_Running then
594: l_isValid := true;
595: else
596: l_isValid := false;
597: end if;

Line 599: elsif p_Control_Operation = FND_SVC_COMPONENT.pv_opResume then

595: else
596: l_isValid := false;
597: end if;
598:
599: elsif p_Control_Operation = FND_SVC_COMPONENT.pv_opResume then
600:
601: if l_CurrentStatus = FND_SVC_COMPONENT.pv_Status_Suspended then
602: l_isValid := true;
603: else

Line 601: if l_CurrentStatus = FND_SVC_COMPONENT.pv_Status_Suspended then

597: end if;
598:
599: elsif p_Control_Operation = FND_SVC_COMPONENT.pv_opResume then
600:
601: if l_CurrentStatus = FND_SVC_COMPONENT.pv_Status_Suspended then
602: l_isValid := true;
603: else
604: l_isValid := false;
605: end if;

Line 607: elsif p_Control_Operation = FND_SVC_COMPONENT.pv_opUpdate then

603: else
604: l_isValid := false;
605: end if;
606:
607: elsif p_Control_Operation = FND_SVC_COMPONENT.pv_opUpdate then
608:
609: if l_CurrentStatus in (FND_SVC_COMPONENT.pv_Status_Stopped,
610: FND_SVC_COMPONENT.pv_Status_Stopped_Error,
611: FND_SVC_COMPONENT.pv_Status_Not_Configured,

Line 609: if l_CurrentStatus in (FND_SVC_COMPONENT.pv_Status_Stopped,

605: end if;
606:
607: elsif p_Control_Operation = FND_SVC_COMPONENT.pv_opUpdate then
608:
609: if l_CurrentStatus in (FND_SVC_COMPONENT.pv_Status_Stopped,
610: FND_SVC_COMPONENT.pv_Status_Stopped_Error,
611: FND_SVC_COMPONENT.pv_Status_Not_Configured,
612: FND_SVC_COMPONENT.pv_Status_Deactivated_User,
613: FND_SVC_COMPONENT.pv_Status_Deactivated_System) then

Line 610: FND_SVC_COMPONENT.pv_Status_Stopped_Error,

606:
607: elsif p_Control_Operation = FND_SVC_COMPONENT.pv_opUpdate then
608:
609: if l_CurrentStatus in (FND_SVC_COMPONENT.pv_Status_Stopped,
610: FND_SVC_COMPONENT.pv_Status_Stopped_Error,
611: FND_SVC_COMPONENT.pv_Status_Not_Configured,
612: FND_SVC_COMPONENT.pv_Status_Deactivated_User,
613: FND_SVC_COMPONENT.pv_Status_Deactivated_System) then
614: l_isValid := true;

Line 611: FND_SVC_COMPONENT.pv_Status_Not_Configured,

607: elsif p_Control_Operation = FND_SVC_COMPONENT.pv_opUpdate then
608:
609: if l_CurrentStatus in (FND_SVC_COMPONENT.pv_Status_Stopped,
610: FND_SVC_COMPONENT.pv_Status_Stopped_Error,
611: FND_SVC_COMPONENT.pv_Status_Not_Configured,
612: FND_SVC_COMPONENT.pv_Status_Deactivated_User,
613: FND_SVC_COMPONENT.pv_Status_Deactivated_System) then
614: l_isValid := true;
615: else

Line 612: FND_SVC_COMPONENT.pv_Status_Deactivated_User,

608:
609: if l_CurrentStatus in (FND_SVC_COMPONENT.pv_Status_Stopped,
610: FND_SVC_COMPONENT.pv_Status_Stopped_Error,
611: FND_SVC_COMPONENT.pv_Status_Not_Configured,
612: FND_SVC_COMPONENT.pv_Status_Deactivated_User,
613: FND_SVC_COMPONENT.pv_Status_Deactivated_System) then
614: l_isValid := true;
615: else
616: l_isValid := false;

Line 613: FND_SVC_COMPONENT.pv_Status_Deactivated_System) then

609: if l_CurrentStatus in (FND_SVC_COMPONENT.pv_Status_Stopped,
610: FND_SVC_COMPONENT.pv_Status_Stopped_Error,
611: FND_SVC_COMPONENT.pv_Status_Not_Configured,
612: FND_SVC_COMPONENT.pv_Status_Deactivated_User,
613: FND_SVC_COMPONENT.pv_Status_Deactivated_System) then
614: l_isValid := true;
615: else
616: l_isValid := false;
617: end if;

Line 619: elsif p_Control_Operation = FND_SVC_COMPONENT.pv_opDelete then

615: else
616: l_isValid := false;
617: end if;
618:
619: elsif p_Control_Operation = FND_SVC_COMPONENT.pv_opDelete then
620:
621: if l_CurrentStatus in (FND_SVC_COMPONENT.pv_Status_Stopped,
622: FND_SVC_COMPONENT.pv_Status_Stopped_Error,
623: FND_SVC_COMPONENT.pv_Status_Not_Configured,

Line 621: if l_CurrentStatus in (FND_SVC_COMPONENT.pv_Status_Stopped,

617: end if;
618:
619: elsif p_Control_Operation = FND_SVC_COMPONENT.pv_opDelete then
620:
621: if l_CurrentStatus in (FND_SVC_COMPONENT.pv_Status_Stopped,
622: FND_SVC_COMPONENT.pv_Status_Stopped_Error,
623: FND_SVC_COMPONENT.pv_Status_Not_Configured,
624: FND_SVC_COMPONENT.pv_Status_Deactivated_User,
625: FND_SVC_COMPONENT.pv_Status_Deactivated_System) then

Line 622: FND_SVC_COMPONENT.pv_Status_Stopped_Error,

618:
619: elsif p_Control_Operation = FND_SVC_COMPONENT.pv_opDelete then
620:
621: if l_CurrentStatus in (FND_SVC_COMPONENT.pv_Status_Stopped,
622: FND_SVC_COMPONENT.pv_Status_Stopped_Error,
623: FND_SVC_COMPONENT.pv_Status_Not_Configured,
624: FND_SVC_COMPONENT.pv_Status_Deactivated_User,
625: FND_SVC_COMPONENT.pv_Status_Deactivated_System) then
626: l_isValid := true;

Line 623: FND_SVC_COMPONENT.pv_Status_Not_Configured,

619: elsif p_Control_Operation = FND_SVC_COMPONENT.pv_opDelete then
620:
621: if l_CurrentStatus in (FND_SVC_COMPONENT.pv_Status_Stopped,
622: FND_SVC_COMPONENT.pv_Status_Stopped_Error,
623: FND_SVC_COMPONENT.pv_Status_Not_Configured,
624: FND_SVC_COMPONENT.pv_Status_Deactivated_User,
625: FND_SVC_COMPONENT.pv_Status_Deactivated_System) then
626: l_isValid := true;
627: else

Line 624: FND_SVC_COMPONENT.pv_Status_Deactivated_User,

620:
621: if l_CurrentStatus in (FND_SVC_COMPONENT.pv_Status_Stopped,
622: FND_SVC_COMPONENT.pv_Status_Stopped_Error,
623: FND_SVC_COMPONENT.pv_Status_Not_Configured,
624: FND_SVC_COMPONENT.pv_Status_Deactivated_User,
625: FND_SVC_COMPONENT.pv_Status_Deactivated_System) then
626: l_isValid := true;
627: else
628: l_isValid := false;

Line 625: FND_SVC_COMPONENT.pv_Status_Deactivated_System) then

621: if l_CurrentStatus in (FND_SVC_COMPONENT.pv_Status_Stopped,
622: FND_SVC_COMPONENT.pv_Status_Stopped_Error,
623: FND_SVC_COMPONENT.pv_Status_Not_Configured,
624: FND_SVC_COMPONENT.pv_Status_Deactivated_User,
625: FND_SVC_COMPONENT.pv_Status_Deactivated_System) then
626: l_isValid := true;
627: else
628: l_isValid := false;
629: end if;

Line 631: elsif p_Control_Operation = FND_SVC_COMPONENT.pv_opGeneric or

627: else
628: l_isValid := false;
629: end if;
630:
631: elsif p_Control_Operation = FND_SVC_COMPONENT.pv_opGeneric or
632: p_Control_Operation = FND_SVC_COMPONENT.pv_opRefresh then
633:
634: -- Generic operation
635:

Line 632: p_Control_Operation = FND_SVC_COMPONENT.pv_opRefresh then

628: l_isValid := false;
629: end if;
630:
631: elsif p_Control_Operation = FND_SVC_COMPONENT.pv_opGeneric or
632: p_Control_Operation = FND_SVC_COMPONENT.pv_opRefresh then
633:
634: -- Generic operation
635:
636: if l_CurrentStatus = FND_SVC_COMPONENT.pv_Status_Running then

Line 636: if l_CurrentStatus = FND_SVC_COMPONENT.pv_Status_Running then

632: p_Control_Operation = FND_SVC_COMPONENT.pv_opRefresh then
633:
634: -- Generic operation
635:
636: if l_CurrentStatus = FND_SVC_COMPONENT.pv_Status_Running then
637: l_isValid := true;
638: else
639: l_isValid := false;
640: end if;

Line 652: 'wf.plsql.FND_SVC_COMPONENT.VALIDATE_OPERATION.invalid_event',

648: p_retCode := pv_retInvalidComponentState;
649: p_errbuf := WF_CORE.TRANSLATE ('SVC_COMP_INVALID_EVENT');
650: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then
651: WF_LOG_PKG.STRING (WF_LOG_PKG.LEVEL_ERROR,
652: 'wf.plsql.FND_SVC_COMPONENT.VALIDATE_OPERATION.invalid_event',
653: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
654: end if;
655: END IF;
656:

Line 669: 'wf.plsql.FND_SVC_COMPONENT.VALIDATE_OPERATION.error',

665: p_errbuf := 'Other non-SQL error';
666: END IF;
667: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then
668: WF_LOG_PKG.STRING (WF_LOG_PKG.LEVEL_ERROR,
669: 'wf.plsql.FND_SVC_COMPONENT.VALIDATE_OPERATION.error',
670: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
671: end if;
672:
673: end Validate_Operation;

Line 680: l_Standalone_Container_Name fnd_svc_components.standalone_container_name%TYPE;

676: p_Container_Type out nocopy varchar2,
677: p_Container_Name out nocopy varchar2)
678: is
679: l_Concurrent_Queue_Name fnd_concurrent_queues.concurrent_queue_name%TYPE;
680: l_Standalone_Container_Name fnd_svc_components.standalone_container_name%TYPE;
681: begin
682: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
683: WF_LOG_PKG.STRING (WF_LOG_PKG.LEVEL_PROCEDURE,
684: 'wf.plsql.FND_SVC_COMPONENT.GET_CONTAINER_INFO.begin',

Line 684: 'wf.plsql.FND_SVC_COMPONENT.GET_CONTAINER_INFO.begin',

680: l_Standalone_Container_Name fnd_svc_components.standalone_container_name%TYPE;
681: begin
682: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
683: WF_LOG_PKG.STRING (WF_LOG_PKG.LEVEL_PROCEDURE,
684: 'wf.plsql.FND_SVC_COMPONENT.GET_CONTAINER_INFO.begin',
685: 'p_Component_Id: '||p_Component_Id);
686: end if;
687:
688: select container_type, concurrent_queue_name, standalone_container_name

Line 690: from fnd_svc_components_v where component_id = p_Component_Id;

686: end if;
687:
688: select container_type, concurrent_queue_name, standalone_container_name
689: into p_Container_Type, l_Concurrent_Queue_Name, l_Standalone_Container_Name
690: from fnd_svc_components_v where component_id = p_Component_Id;
691:
692: if (p_Container_Type = FND_SVC_COMPONENT.pv_Container_Type_GSM) then
693: p_Container_Name := l_Concurrent_Queue_Name;
694: else

Line 692: if (p_Container_Type = FND_SVC_COMPONENT.pv_Container_Type_GSM) then

688: select container_type, concurrent_queue_name, standalone_container_name
689: into p_Container_Type, l_Concurrent_Queue_Name, l_Standalone_Container_Name
690: from fnd_svc_components_v where component_id = p_Component_Id;
691:
692: if (p_Container_Type = FND_SVC_COMPONENT.pv_Container_Type_GSM) then
693: p_Container_Name := l_Concurrent_Queue_Name;
694: else
695: p_Container_Name := l_Standalone_Container_Name;
696: END IF;

Line 707: -- the FND_SVC_COMPONENTS table and to raise a System Alert if necessary.

703:
704: --
705: -- Update_Status
706: -- Procedure to update the status of the given Service Component in
707: -- the FND_SVC_COMPONENTS table and to raise a System Alert if necessary.
708: -- If the component staus is either STOPPED_ERROR or DEACTIVATED_SYSTEM
709: -- then a System Alert is raised with the pre-defined message.
710: -- For more information, refer Bug 3786007.
711: --

Line 725: l_component_name fnd_svc_components.component_name%TYPE;

721: p_Status_Info IN VARCHAR2,
722: p_Last_Updated_By IN NUMBER,
723: p_Last_Update_Login IN NUMBER)
724: is
725: l_component_name fnd_svc_components.component_name%TYPE;
726:
727: begin
728: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
729: WF_LOG_PKG.STRING (WF_LOG_PKG.LEVEL_PROCEDURE,

Line 730: 'wf.plsql.FND_SVC_COMPONENT.UPDATE_STATUS.begin',

726:
727: begin
728: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
729: WF_LOG_PKG.STRING (WF_LOG_PKG.LEVEL_PROCEDURE,
730: 'wf.plsql.FND_SVC_COMPONENT.UPDATE_STATUS.begin',
731: 'p_Component_Id: '||p_Component_Id
732: ||' p_Status: '||p_Status);
733: end if;
734:

Line 735: UPDATE FND_SVC_COMPONENTS

731: 'p_Component_Id: '||p_Component_Id
732: ||' p_Status: '||p_Status);
733: end if;
734:
735: UPDATE FND_SVC_COMPONENTS
736: SET component_status = p_Status,
737: component_status_info = decode(p_Status_Info, null, component_status_info,
738: 'NULL', null, substrb(p_Status_Info,1,1996)),
739: last_update_date = sysdate,

Line 760: FROM fnd_svc_components

756: end if;
757:
758: SELECT TRIM(component_name)
759: INTO l_component_name
760: FROM fnd_svc_components
761: WHERE component_id = p_Component_Id;
762:
763: WF_LOG_PKG.SET_TOKEN('COMPONENT_NAME', l_component_name);
764: WF_LOG_PKG.SET_TOKEN('ERROR_CONTEXT', nvl(p_Status_Info,'Not provided.'));

Line 787: l_Container_Type fnd_svc_components.container_type%TYPE;

783: (p_Component_Name IN VARCHAR2)
784: RETURN VARCHAR2
785: is
786: l_Component_Id fnd_svc_comp_requests.component_id%TYPE;
787: l_Container_Type fnd_svc_components.container_type%TYPE;
788: l_Container_Name fnd_svc_components.standalone_container_name%TYPE;
789: l_Current_Status fnd_svc_components.component_status%TYPE;
790:
791: begin

Line 788: l_Container_Name fnd_svc_components.standalone_container_name%TYPE;

784: RETURN VARCHAR2
785: is
786: l_Component_Id fnd_svc_comp_requests.component_id%TYPE;
787: l_Container_Type fnd_svc_components.container_type%TYPE;
788: l_Container_Name fnd_svc_components.standalone_container_name%TYPE;
789: l_Current_Status fnd_svc_components.component_status%TYPE;
790:
791: begin
792: -- Get the Component Id

Line 789: l_Current_Status fnd_svc_components.component_status%TYPE;

785: is
786: l_Component_Id fnd_svc_comp_requests.component_id%TYPE;
787: l_Container_Type fnd_svc_components.container_type%TYPE;
788: l_Container_Name fnd_svc_components.standalone_container_name%TYPE;
789: l_Current_Status fnd_svc_components.component_status%TYPE;
790:
791: begin
792: -- Get the Component Id
793: SELECT component_id

Line 795: FROM fnd_svc_components

791: begin
792: -- Get the Component Id
793: SELECT component_id
794: INTO l_Component_Id
795: FROM fnd_svc_components
796: WHERE component_name = p_component_Name;
797:
798: -- Get Container Type and Name
799: Get_Container_Info(p_Component_Id => l_Component_Id,

Line 829: 'wf.plsql.FND_SVC_COMPONENT.RAISE_CONTROL_EVENT.begin',

825: begin
826:
827: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
828: WF_LOG_PKG.STRING (WF_LOG_PKG.LEVEL_PROCEDURE,
829: 'wf.plsql.FND_SVC_COMPONENT.RAISE_CONTROL_EVENT.begin',
830: 'p_Component_Id: '||p_Component_Id||
831: ', p_Control_Operation:'||p_Control_Operation);
832: end if;
833:

Line 859: l_Container_Type fnd_svc_components.container_type%TYPE;

855: p_retcode OUT NOCOPY NUMBER,
856: p_errbuf OUT NOCOPY VARCHAR2)
857: is
858:
859: l_Container_Type fnd_svc_components.container_type%TYPE;
860: l_Container_Name fnd_svc_components.standalone_container_name%TYPE;
861: l_CPID number;
862: l_Container_Status fnd_svc_components.component_status%TYPE;
863:

Line 860: l_Container_Name fnd_svc_components.standalone_container_name%TYPE;

856: p_errbuf OUT NOCOPY VARCHAR2)
857: is
858:
859: l_Container_Type fnd_svc_components.container_type%TYPE;
860: l_Container_Name fnd_svc_components.standalone_container_name%TYPE;
861: l_CPID number;
862: l_Container_Status fnd_svc_components.component_status%TYPE;
863:
864: begin

Line 862: l_Container_Status fnd_svc_components.component_status%TYPE;

858:
859: l_Container_Type fnd_svc_components.container_type%TYPE;
860: l_Container_Name fnd_svc_components.standalone_container_name%TYPE;
861: l_CPID number;
862: l_Container_Status fnd_svc_components.component_status%TYPE;
863:
864: begin
865: p_retcode := 0;
866:

Line 869: 'wf.plsql.FND_SVC_COMPONENT.START_COMPONENT.begin',

865: p_retcode := 0;
866:
867: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
868: WF_LOG_PKG.STRING (WF_LOG_PKG.LEVEL_PROCEDURE,
869: 'wf.plsql.FND_SVC_COMPONENT.START_COMPONENT.begin',
870: 'p_Component_Id: '||p_Component_Id);
871: end if;
872:
873: Validate_Operation

Line 875: p_Control_Operation => FND_SVC_COMPONENT.pv_opStart,

871: end if;
872:
873: Validate_Operation
874: (p_Component_Id => p_Component_Id,
875: p_Control_Operation => FND_SVC_COMPONENT.pv_opStart,
876: p_retcode => p_retcode,
877: p_errbuf => p_errbuf);
878:
879: if p_retcode <> 0 then

Line 913: 'wf.plsql.FND_SVC_COMPONENT.START_COMPONENT.container_not_running',

909: p_errbuf := WF_CORE.TRANSLATE ('SVC_CONTAINER_NOT_RUNNING');
910:
911: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then
912: WF_LOG_PKG.STRING (WF_LOG_PKG.LEVEL_ERROR,
913: 'wf.plsql.FND_SVC_COMPONENT.START_COMPONENT.container_not_running',
914: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
915: end if;
916:
917: when others then

Line 928: 'wf.plsql.FND_SVC_COMPONENT.START_COMPONENT.error',

924: END IF;
925:
926: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then
927: WF_LOG_PKG.STRING (WF_LOG_PKG.LEVEL_ERROR,
928: 'wf.plsql.FND_SVC_COMPONENT.START_COMPONENT.error',
929: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
930: end if;
931:
932: End Start_Component;

Line 939: l_Container_Type fnd_svc_components.container_type%TYPE;

935: p_retcode OUT NOCOPY NUMBER,
936: p_errbuf OUT NOCOPY VARCHAR2)
937: is
938:
939: l_Container_Type fnd_svc_components.container_type%TYPE;
940: l_Container_Name fnd_svc_components.standalone_container_name%TYPE;
941: l_CPID number;
942: l_Container_Status fnd_svc_components.component_status%TYPE;
943:

Line 940: l_Container_Name fnd_svc_components.standalone_container_name%TYPE;

936: p_errbuf OUT NOCOPY VARCHAR2)
937: is
938:
939: l_Container_Type fnd_svc_components.container_type%TYPE;
940: l_Container_Name fnd_svc_components.standalone_container_name%TYPE;
941: l_CPID number;
942: l_Container_Status fnd_svc_components.component_status%TYPE;
943:
944: begin

Line 942: l_Container_Status fnd_svc_components.component_status%TYPE;

938:
939: l_Container_Type fnd_svc_components.container_type%TYPE;
940: l_Container_Name fnd_svc_components.standalone_container_name%TYPE;
941: l_CPID number;
942: l_Container_Status fnd_svc_components.component_status%TYPE;
943:
944: begin
945: p_retcode := 0;
946:

Line 949: 'wf.plsql.FND_SVC_COMPONENT.STOP_COMPONENT.begin',

945: p_retcode := 0;
946:
947: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
948: WF_LOG_PKG.STRING (WF_LOG_PKG.LEVEL_PROCEDURE,
949: 'wf.plsql.FND_SVC_COMPONENT.STOP_COMPONENT.begin',
950: 'p_Component_Id: '||p_Component_Id);
951: end if;
952:
953: Validate_Operation

Line 955: p_Control_Operation => FND_SVC_COMPONENT.pv_opStop,

951: end if;
952:
953: Validate_Operation
954: (p_Component_Id => p_Component_Id,
955: p_Control_Operation => FND_SVC_COMPONENT.pv_opStop,
956: p_retcode => p_retcode,
957: p_errbuf => p_errbuf);
958:
959: if p_retcode <> 0 then

Line 985: if (FND_SVC_COMPONENT.pv_callerContext = FND_SVC_COMPONENT.pv_CallerContextUser) then

981: p_CPID => l_CPID);
982:
983: /**********
984:
985: if (FND_SVC_COMPONENT.pv_callerContext = FND_SVC_COMPONENT.pv_CallerContextUser) then
986:
987: -- Deactivate the automatic adapter in case user stops it.
988:
989: if (XDP_ADAPTER_CORE_DB.Is_Adapter_Automatic(p_ChannelName)) then

Line 1006: 'wf.plsql.FND_SVC_COMPONENT.STOP_COMPONENT.container_not_running',

1002: p_errbuf := WF_CORE.TRANSLATE ('SVC_CONTAINER_NOT_RUNNING');
1003:
1004: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then
1005: WF_LOG_PKG.STRING (WF_LOG_PKG.LEVEL_ERROR,
1006: 'wf.plsql.FND_SVC_COMPONENT.STOP_COMPONENT.container_not_running',
1007: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
1008: end if;
1009:
1010: when others then

Line 1020: 'wf.plsql.FND_SVC_COMPONENT.STOP_COMPONENT.error',

1016: p_errbuf := 'Other non-SQL error';
1017: END IF;
1018: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then
1019: WF_LOG_PKG.STRING (WF_LOG_PKG.LEVEL_ERROR,
1020: 'wf.plsql.FND_SVC_COMPONENT.STOP_COMPONENT.error',
1021: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
1022: end if;
1023:
1024: end Stop_Component;

Line 1031: l_Container_Type fnd_svc_components.container_type%TYPE;

1027: p_retcode OUT NOCOPY NUMBER,
1028: p_errbuf OUT NOCOPY VARCHAR2)
1029: is
1030:
1031: l_Container_Type fnd_svc_components.container_type%TYPE;
1032: l_Container_Name fnd_svc_components.standalone_container_name%TYPE;
1033: l_CPID number;
1034: l_Container_Status fnd_svc_components.component_status%TYPE;
1035:

Line 1032: l_Container_Name fnd_svc_components.standalone_container_name%TYPE;

1028: p_errbuf OUT NOCOPY VARCHAR2)
1029: is
1030:
1031: l_Container_Type fnd_svc_components.container_type%TYPE;
1032: l_Container_Name fnd_svc_components.standalone_container_name%TYPE;
1033: l_CPID number;
1034: l_Container_Status fnd_svc_components.component_status%TYPE;
1035:
1036: begin

Line 1034: l_Container_Status fnd_svc_components.component_status%TYPE;

1030:
1031: l_Container_Type fnd_svc_components.container_type%TYPE;
1032: l_Container_Name fnd_svc_components.standalone_container_name%TYPE;
1033: l_CPID number;
1034: l_Container_Status fnd_svc_components.component_status%TYPE;
1035:
1036: begin
1037: p_retcode := 0;
1038:

Line 1041: 'wf.plsql.FND_SVC_COMPONENT.SUSPEND_COMPONENT.begin',

1037: p_retcode := 0;
1038:
1039: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
1040: WF_LOG_PKG.STRING (WF_LOG_PKG.LEVEL_PROCEDURE,
1041: 'wf.plsql.FND_SVC_COMPONENT.SUSPEND_COMPONENT.begin',
1042: 'p_Component_Id: '||p_Component_Id);
1043: end if;
1044:
1045: Validate_Operation

Line 1047: p_Control_Operation => FND_SVC_COMPONENT.pv_opSuspend,

1043: end if;
1044:
1045: Validate_Operation
1046: (p_Component_Id => p_Component_Id,
1047: p_Control_Operation => FND_SVC_COMPONENT.pv_opSuspend,
1048: p_retcode => p_retcode,
1049: p_errbuf => p_errbuf);
1050:
1051: if p_retcode <> 0 then

Line 1082: 'wf.plsql.FND_SVC_COMPONENT.SUSPEND_COMPONENT.container_not_running',

1078: p_retCode := pv_retContainerNotRunning;
1079: p_errbuf := WF_CORE.TRANSLATE ('SVC_CONTAINER_NOT_RUNNING');
1080: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then
1081: WF_LOG_PKG.STRING (WF_LOG_PKG.LEVEL_ERROR,
1082: 'wf.plsql.FND_SVC_COMPONENT.SUSPEND_COMPONENT.container_not_running',
1083: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
1084: end if;
1085:
1086: when others then

Line 1097: 'wf.plsql.FND_SVC_COMPONENT.SUSPEND_COMPONENT.error',

1093: END IF;
1094:
1095: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then
1096: WF_LOG_PKG.STRING (WF_LOG_PKG.LEVEL_ERROR,
1097: 'wf.plsql.FND_SVC_COMPONENT.SUSPEND_COMPONENT.error',
1098: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
1099: end if;
1100:
1101: end Suspend_Component;

Line 1108: l_Container_Type fnd_svc_components.container_type%TYPE;

1104: p_retcode OUT NOCOPY NUMBER,
1105: p_errbuf OUT NOCOPY VARCHAR2)
1106: is
1107:
1108: l_Container_Type fnd_svc_components.container_type%TYPE;
1109: l_Container_Name fnd_svc_components.standalone_container_name%TYPE;
1110: l_CPID number;
1111: l_Container_Status fnd_svc_components.component_status%TYPE;
1112:

Line 1109: l_Container_Name fnd_svc_components.standalone_container_name%TYPE;

1105: p_errbuf OUT NOCOPY VARCHAR2)
1106: is
1107:
1108: l_Container_Type fnd_svc_components.container_type%TYPE;
1109: l_Container_Name fnd_svc_components.standalone_container_name%TYPE;
1110: l_CPID number;
1111: l_Container_Status fnd_svc_components.component_status%TYPE;
1112:
1113: begin

Line 1111: l_Container_Status fnd_svc_components.component_status%TYPE;

1107:
1108: l_Container_Type fnd_svc_components.container_type%TYPE;
1109: l_Container_Name fnd_svc_components.standalone_container_name%TYPE;
1110: l_CPID number;
1111: l_Container_Status fnd_svc_components.component_status%TYPE;
1112:
1113: begin
1114: p_retcode := 0;
1115:

Line 1118: 'wf.plsql.FND_SVC_COMPONENT.RESUME_COMPONENT.begin',

1114: p_retcode := 0;
1115:
1116: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
1117: WF_LOG_PKG.STRING (WF_LOG_PKG.LEVEL_PROCEDURE,
1118: 'wf.plsql.FND_SVC_COMPONENT.RESUME_COMPONENT.begin',
1119: 'p_Component_Id: '||p_Component_Id);
1120: end if;
1121:
1122: Validate_Operation

Line 1124: p_Control_Operation => FND_SVC_COMPONENT.pv_opResume,

1120: end if;
1121:
1122: Validate_Operation
1123: (p_Component_Id => p_Component_Id,
1124: p_Control_Operation => FND_SVC_COMPONENT.pv_opResume,
1125: p_retcode => p_retcode,
1126: p_errbuf => p_errbuf);
1127:
1128: if p_retcode <> 0 then

Line 1160: 'wf.plsql.FND_SVC_COMPONENT.RESUME_COMPONENT.container_not_running',

1156: p_errbuf := WF_CORE.TRANSLATE ('SVC_CONTAINER_NOT_RUNNING');
1157:
1158: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then
1159: WF_LOG_PKG.STRING (WF_LOG_PKG.LEVEL_ERROR,
1160: 'wf.plsql.FND_SVC_COMPONENT.RESUME_COMPONENT.container_not_running',
1161: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
1162: end if;
1163:
1164: when others then

Line 1175: 'wf.plsql.FND_SVC_COMPONENT.RESUME_COMPONENT.error',

1171: END IF;
1172:
1173: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then
1174: WF_LOG_PKG.STRING (WF_LOG_PKG.LEVEL_ERROR,
1175: 'wf.plsql.FND_SVC_COMPONENT.RESUME_COMPONENT.error',
1176: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
1177: end if;
1178:
1179: end Resume_Component;

Line 1187: l_Container_Type fnd_svc_components.container_type%TYPE;

1183: p_retcode OUT NOCOPY NUMBER,
1184: p_errbuf OUT NOCOPY VARCHAR2)
1185: is
1186:
1187: l_Container_Type fnd_svc_components.container_type%TYPE;
1188: l_Container_Name fnd_svc_components.standalone_container_name%TYPE;
1189: l_CPID number;
1190: l_Container_Status fnd_svc_components.component_status%TYPE;
1191:

Line 1188: l_Container_Name fnd_svc_components.standalone_container_name%TYPE;

1184: p_errbuf OUT NOCOPY VARCHAR2)
1185: is
1186:
1187: l_Container_Type fnd_svc_components.container_type%TYPE;
1188: l_Container_Name fnd_svc_components.standalone_container_name%TYPE;
1189: l_CPID number;
1190: l_Container_Status fnd_svc_components.component_status%TYPE;
1191:
1192: begin

Line 1190: l_Container_Status fnd_svc_components.component_status%TYPE;

1186:
1187: l_Container_Type fnd_svc_components.container_type%TYPE;
1188: l_Container_Name fnd_svc_components.standalone_container_name%TYPE;
1189: l_CPID number;
1190: l_Container_Status fnd_svc_components.component_status%TYPE;
1191:
1192: begin
1193: p_retcode := 0;
1194:

Line 1197: 'wf.plsql.FND_SVC_COMPONENT.REFRESH_COMPONENT.begin',

1193: p_retcode := 0;
1194:
1195: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
1196: WF_LOG_PKG.STRING (WF_LOG_PKG.LEVEL_PROCEDURE,
1197: 'wf.plsql.FND_SVC_COMPONENT.REFRESH_COMPONENT.begin',
1198: 'p_Component_Id: '||p_Component_Id);
1199: end if;
1200:
1201: Validate_Operation

Line 1203: p_Control_Operation => FND_SVC_COMPONENT.pv_opRefresh,

1199: end if;
1200:
1201: Validate_Operation
1202: (p_Component_Id => p_Component_Id,
1203: p_Control_Operation => FND_SVC_COMPONENT.pv_opRefresh,
1204: p_retcode => p_retcode,
1205: p_errbuf => p_errbuf);
1206:
1207: if p_retcode <> 0 then

Line 1238: 'wf.plsql.FND_SVC_COMPONENT.REFRESH_COMPONENT.container_not_running',

1234: p_errbuf := WF_CORE.TRANSLATE ('SVC_CONTAINER_NOT_RUNNING');
1235:
1236: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then
1237: WF_LOG_PKG.STRING (WF_LOG_PKG.LEVEL_ERROR,
1238: 'wf.plsql.FND_SVC_COMPONENT.REFRESH_COMPONENT.container_not_running',
1239: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
1240: end if;
1241:
1242: when others then

Line 1253: 'wf.plsql.FND_SVC_COMPONENT.REFRESH_COMPONENT.error',

1249: END IF;
1250:
1251: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then
1252: WF_LOG_PKG.STRING (WF_LOG_PKG.LEVEL_ERROR,
1253: 'wf.plsql.FND_SVC_COMPONENT.REFRESH_COMPONENT.error',
1254: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
1255: end if;
1256:
1257: end Refresh_Component;

Line 1266: l_Container_Type fnd_svc_components.container_type%TYPE;

1262: p_retcode OUT NOCOPY NUMBER,
1263: p_errbuf OUT NOCOPY VARCHAR2)
1264: is
1265:
1266: l_Container_Type fnd_svc_components.container_type%TYPE;
1267: l_Container_Name fnd_svc_components.standalone_container_name%TYPE;
1268: l_CPID number;
1269: l_Container_Status fnd_svc_components.component_status%TYPE;
1270:

Line 1267: l_Container_Name fnd_svc_components.standalone_container_name%TYPE;

1263: p_errbuf OUT NOCOPY VARCHAR2)
1264: is
1265:
1266: l_Container_Type fnd_svc_components.container_type%TYPE;
1267: l_Container_Name fnd_svc_components.standalone_container_name%TYPE;
1268: l_CPID number;
1269: l_Container_Status fnd_svc_components.component_status%TYPE;
1270:
1271: begin

Line 1269: l_Container_Status fnd_svc_components.component_status%TYPE;

1265:
1266: l_Container_Type fnd_svc_components.container_type%TYPE;
1267: l_Container_Name fnd_svc_components.standalone_container_name%TYPE;
1268: l_CPID number;
1269: l_Container_Status fnd_svc_components.component_status%TYPE;
1270:
1271: begin
1272: p_retcode := 0;
1273:

Line 1276: 'wf.plsql.FND_SVC_COMPONENT.GENERIC_OPERATION.begin',

1272: p_retcode := 0;
1273:
1274: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
1275: WF_LOG_PKG.STRING (WF_LOG_PKG.LEVEL_PROCEDURE,
1276: 'wf.plsql.FND_SVC_COMPONENT.GENERIC_OPERATION.begin',
1277: 'p_Component_Id: '||p_Component_Id);
1278: end if;
1279:
1280: Validate_Operation

Line 1282: p_Control_Operation => FND_SVC_COMPONENT.pv_opGeneric,

1278: end if;
1279:
1280: Validate_Operation
1281: (p_Component_Id => p_Component_Id,
1282: p_Control_Operation => FND_SVC_COMPONENT.pv_opGeneric,
1283: p_retcode => p_retcode,
1284: p_errbuf => p_errbuf);
1285:
1286: if p_retcode <> 0 then

Line 1317: 'wf.plsql.FND_SVC_COMPONENT.GENERIC_OPERATION.container_not_running',

1313: p_errbuf := WF_CORE.TRANSLATE ('SVC_CONTAINER_NOT_RUNNING');
1314:
1315: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then
1316: WF_LOG_PKG.STRING (WF_LOG_PKG.LEVEL_ERROR,
1317: 'wf.plsql.FND_SVC_COMPONENT.GENERIC_OPERATION.container_not_running',
1318: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
1319: end if;
1320:
1321: when others then

Line 1332: 'wf.plsql.FND_SVC_COMPONENT.GENERIC_OPERATION.error',

1328: END IF;
1329:
1330: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then
1331: WF_LOG_PKG.STRING (WF_LOG_PKG.LEVEL_ERROR,
1332: 'wf.plsql.FND_SVC_COMPONENT.GENERIC_OPERATION.error',
1333: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
1334: end if;
1335:
1336: end Generic_Operation;

Line 1365: from FND_SVC_COMPONENTS

1361: is
1362: PRAGMA AUTONOMOUS_TRANSACTION;
1363: cursor c_Get_Running_Components_Conc (ConcQId number, ApplId number) is
1364: select component_id
1365: from FND_SVC_COMPONENTS
1366: where component_status not in (FND_SVC_COMPONENT.pv_Status_Stopped,
1367: FND_SVC_COMPONENT.pv_Status_Stopped_Error,
1368: FND_SVC_COMPONENT.pv_Status_Not_Configured,
1369: FND_SVC_COMPONENT.pv_Status_Deactivated_User,

Line 1366: where component_status not in (FND_SVC_COMPONENT.pv_Status_Stopped,

1362: PRAGMA AUTONOMOUS_TRANSACTION;
1363: cursor c_Get_Running_Components_Conc (ConcQId number, ApplId number) is
1364: select component_id
1365: from FND_SVC_COMPONENTS
1366: where component_status not in (FND_SVC_COMPONENT.pv_Status_Stopped,
1367: FND_SVC_COMPONENT.pv_Status_Stopped_Error,
1368: FND_SVC_COMPONENT.pv_Status_Not_Configured,
1369: FND_SVC_COMPONENT.pv_Status_Deactivated_User,
1370: FND_SVC_COMPONENT.pv_Status_Deactivated_System)

Line 1367: FND_SVC_COMPONENT.pv_Status_Stopped_Error,

1363: cursor c_Get_Running_Components_Conc (ConcQId number, ApplId number) is
1364: select component_id
1365: from FND_SVC_COMPONENTS
1366: where component_status not in (FND_SVC_COMPONENT.pv_Status_Stopped,
1367: FND_SVC_COMPONENT.pv_Status_Stopped_Error,
1368: FND_SVC_COMPONENT.pv_Status_Not_Configured,
1369: FND_SVC_COMPONENT.pv_Status_Deactivated_User,
1370: FND_SVC_COMPONENT.pv_Status_Deactivated_System)
1371: and container_type = pv_Container_Type_GSM

Line 1368: FND_SVC_COMPONENT.pv_Status_Not_Configured,

1364: select component_id
1365: from FND_SVC_COMPONENTS
1366: where component_status not in (FND_SVC_COMPONENT.pv_Status_Stopped,
1367: FND_SVC_COMPONENT.pv_Status_Stopped_Error,
1368: FND_SVC_COMPONENT.pv_Status_Not_Configured,
1369: FND_SVC_COMPONENT.pv_Status_Deactivated_User,
1370: FND_SVC_COMPONENT.pv_Status_Deactivated_System)
1371: and container_type = pv_Container_Type_GSM
1372: and concurrent_queue_id = ConcQId

Line 1369: FND_SVC_COMPONENT.pv_Status_Deactivated_User,

1365: from FND_SVC_COMPONENTS
1366: where component_status not in (FND_SVC_COMPONENT.pv_Status_Stopped,
1367: FND_SVC_COMPONENT.pv_Status_Stopped_Error,
1368: FND_SVC_COMPONENT.pv_Status_Not_Configured,
1369: FND_SVC_COMPONENT.pv_Status_Deactivated_User,
1370: FND_SVC_COMPONENT.pv_Status_Deactivated_System)
1371: and container_type = pv_Container_Type_GSM
1372: and concurrent_queue_id = ConcQId
1373: and application_id = ApplId;

Line 1370: FND_SVC_COMPONENT.pv_Status_Deactivated_System)

1366: where component_status not in (FND_SVC_COMPONENT.pv_Status_Stopped,
1367: FND_SVC_COMPONENT.pv_Status_Stopped_Error,
1368: FND_SVC_COMPONENT.pv_Status_Not_Configured,
1369: FND_SVC_COMPONENT.pv_Status_Deactivated_User,
1370: FND_SVC_COMPONENT.pv_Status_Deactivated_System)
1371: and container_type = pv_Container_Type_GSM
1372: and concurrent_queue_id = ConcQId
1373: and application_id = ApplId;
1374:

Line 1377: from FND_SVC_COMPONENTS

1373: and application_id = ApplId;
1374:
1375: cursor c_Get_Running_Components_Std (StdContainerName varchar2) is
1376: select component_id
1377: from FND_SVC_COMPONENTS
1378: where component_status not in (FND_SVC_COMPONENT.pv_Status_Stopped,
1379: FND_SVC_COMPONENT.pv_Status_Stopped_Error,
1380: FND_SVC_COMPONENT.pv_Status_Not_Configured,
1381: FND_SVC_COMPONENT.pv_Status_Deactivated_User,

Line 1378: where component_status not in (FND_SVC_COMPONENT.pv_Status_Stopped,

1374:
1375: cursor c_Get_Running_Components_Std (StdContainerName varchar2) is
1376: select component_id
1377: from FND_SVC_COMPONENTS
1378: where component_status not in (FND_SVC_COMPONENT.pv_Status_Stopped,
1379: FND_SVC_COMPONENT.pv_Status_Stopped_Error,
1380: FND_SVC_COMPONENT.pv_Status_Not_Configured,
1381: FND_SVC_COMPONENT.pv_Status_Deactivated_User,
1382: FND_SVC_COMPONENT.pv_Status_Deactivated_System)

Line 1379: FND_SVC_COMPONENT.pv_Status_Stopped_Error,

1375: cursor c_Get_Running_Components_Std (StdContainerName varchar2) is
1376: select component_id
1377: from FND_SVC_COMPONENTS
1378: where component_status not in (FND_SVC_COMPONENT.pv_Status_Stopped,
1379: FND_SVC_COMPONENT.pv_Status_Stopped_Error,
1380: FND_SVC_COMPONENT.pv_Status_Not_Configured,
1381: FND_SVC_COMPONENT.pv_Status_Deactivated_User,
1382: FND_SVC_COMPONENT.pv_Status_Deactivated_System)
1383: and container_type = pv_Container_Type_Servlet

Line 1380: FND_SVC_COMPONENT.pv_Status_Not_Configured,

1376: select component_id
1377: from FND_SVC_COMPONENTS
1378: where component_status not in (FND_SVC_COMPONENT.pv_Status_Stopped,
1379: FND_SVC_COMPONENT.pv_Status_Stopped_Error,
1380: FND_SVC_COMPONENT.pv_Status_Not_Configured,
1381: FND_SVC_COMPONENT.pv_Status_Deactivated_User,
1382: FND_SVC_COMPONENT.pv_Status_Deactivated_System)
1383: and container_type = pv_Container_Type_Servlet
1384: and standalone_container_name = StdContainerName;

Line 1381: FND_SVC_COMPONENT.pv_Status_Deactivated_User,

1377: from FND_SVC_COMPONENTS
1378: where component_status not in (FND_SVC_COMPONENT.pv_Status_Stopped,
1379: FND_SVC_COMPONENT.pv_Status_Stopped_Error,
1380: FND_SVC_COMPONENT.pv_Status_Not_Configured,
1381: FND_SVC_COMPONENT.pv_Status_Deactivated_User,
1382: FND_SVC_COMPONENT.pv_Status_Deactivated_System)
1383: and container_type = pv_Container_Type_Servlet
1384: and standalone_container_name = StdContainerName;
1385:

Line 1382: FND_SVC_COMPONENT.pv_Status_Deactivated_System)

1378: where component_status not in (FND_SVC_COMPONENT.pv_Status_Stopped,
1379: FND_SVC_COMPONENT.pv_Status_Stopped_Error,
1380: FND_SVC_COMPONENT.pv_Status_Not_Configured,
1381: FND_SVC_COMPONENT.pv_Status_Deactivated_User,
1382: FND_SVC_COMPONENT.pv_Status_Deactivated_System)
1383: and container_type = pv_Container_Type_Servlet
1384: and standalone_container_name = StdContainerName;
1385:
1386: l_appl_id number;

Line 1393: 'wf.plsql.FND_SVC_COMPONENT.RESET_CONTAINER_COMPONENTS.begin',

1389: begin
1390:
1391: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
1392: WF_LOG_PKG.STRING (WF_LOG_PKG.LEVEL_PROCEDURE,
1393: 'wf.plsql.FND_SVC_COMPONENT.RESET_CONTAINER_COMPONENTS.begin',
1394: 'Container Type: '||p_container_type||' Container Name: '||p_container_name);
1395: end if;
1396:
1397: if (p_Container_Type = FND_SVC_COMPONENT.pv_Container_Type_GSM) then

Line 1397: if (p_Container_Type = FND_SVC_COMPONENT.pv_Container_Type_GSM) then

1393: 'wf.plsql.FND_SVC_COMPONENT.RESET_CONTAINER_COMPONENTS.begin',
1394: 'Container Type: '||p_container_type||' Container Name: '||p_container_name);
1395: end if;
1396:
1397: if (p_Container_Type = FND_SVC_COMPONENT.pv_Container_Type_GSM) then
1398:
1399: Get_ConcQ_ID (ConcQName => p_container_name,
1400: ApplId => l_appl_id, ConcQId => l_concurrent_queue_id);
1401:

Line 1405: p_Status => FND_SVC_COMPONENT.pv_Status_Stopped_Error,

1401:
1402: FOR r_conc IN c_Get_Running_Components_Conc (l_concurrent_queue_id, l_appl_id) LOOP
1403:
1404: Update_Status (p_Component_Id => r_conc.component_id,
1405: p_Status => FND_SVC_COMPONENT.pv_Status_Stopped_Error,
1406: p_Status_Info => 'Status has been reset because the Service Component did not stop gracefully.'); -- TODO MLS??
1407:
1408: END LOOP;
1409:

Line 1410: update FND_SVC_COMPONENTS

1406: p_Status_Info => 'Status has been reset because the Service Component did not stop gracefully.'); -- TODO MLS??
1407:
1408: END LOOP;
1409:
1410: update FND_SVC_COMPONENTS
1411: set component_status = FND_SVC_COMPONENT.pv_Status_Stopped_Error where
1412: component_status = FND_SVC_COMPONENT.pv_Status_Deactivated_System and
1413: concurrent_queue_id = l_concurrent_queue_id and
1414: application_id = l_appl_id and

Line 1411: set component_status = FND_SVC_COMPONENT.pv_Status_Stopped_Error where

1407:
1408: END LOOP;
1409:
1410: update FND_SVC_COMPONENTS
1411: set component_status = FND_SVC_COMPONENT.pv_Status_Stopped_Error where
1412: component_status = FND_SVC_COMPONENT.pv_Status_Deactivated_System and
1413: concurrent_queue_id = l_concurrent_queue_id and
1414: application_id = l_appl_id and
1415: container_type = pv_Container_Type_GSM;

Line 1412: component_status = FND_SVC_COMPONENT.pv_Status_Deactivated_System and

1408: END LOOP;
1409:
1410: update FND_SVC_COMPONENTS
1411: set component_status = FND_SVC_COMPONENT.pv_Status_Stopped_Error where
1412: component_status = FND_SVC_COMPONENT.pv_Status_Deactivated_System and
1413: concurrent_queue_id = l_concurrent_queue_id and
1414: application_id = l_appl_id and
1415: container_type = pv_Container_Type_GSM;
1416:

Line 1422: p_Status => FND_SVC_COMPONENT.pv_Status_Stopped_Error,

1418:
1419: FOR r_std IN c_Get_Running_Components_Std (p_container_name) LOOP
1420:
1421: Update_Status (p_Component_Id => r_std.component_id,
1422: p_Status => FND_SVC_COMPONENT.pv_Status_Stopped_Error,
1423: p_Status_Info => 'Status has been reset because the Service Component did not stop gracefully.'); -- TODO MLS??
1424: END LOOP;
1425:
1426: update FND_SVC_COMPONENTS

Line 1426: update FND_SVC_COMPONENTS

1422: p_Status => FND_SVC_COMPONENT.pv_Status_Stopped_Error,
1423: p_Status_Info => 'Status has been reset because the Service Component did not stop gracefully.'); -- TODO MLS??
1424: END LOOP;
1425:
1426: update FND_SVC_COMPONENTS
1427: set component_status = FND_SVC_COMPONENT.pv_Status_Stopped_Error where
1428: component_status = FND_SVC_COMPONENT.pv_Status_Deactivated_System and
1429: standalone_container_name = p_container_name and
1430: container_type = pv_Container_Type_Servlet;

Line 1427: set component_status = FND_SVC_COMPONENT.pv_Status_Stopped_Error where

1423: p_Status_Info => 'Status has been reset because the Service Component did not stop gracefully.'); -- TODO MLS??
1424: END LOOP;
1425:
1426: update FND_SVC_COMPONENTS
1427: set component_status = FND_SVC_COMPONENT.pv_Status_Stopped_Error where
1428: component_status = FND_SVC_COMPONENT.pv_Status_Deactivated_System and
1429: standalone_container_name = p_container_name and
1430: container_type = pv_Container_Type_Servlet;
1431:

Line 1428: component_status = FND_SVC_COMPONENT.pv_Status_Deactivated_System and

1424: END LOOP;
1425:
1426: update FND_SVC_COMPONENTS
1427: set component_status = FND_SVC_COMPONENT.pv_Status_Stopped_Error where
1428: component_status = FND_SVC_COMPONENT.pv_Status_Deactivated_System and
1429: standalone_container_name = p_container_name and
1430: container_type = pv_Container_Type_Servlet;
1431:
1432: end if;

Line 1472: l_Container_Status fnd_svc_components.component_status%TYPE;

1468: p_errbuf OUT NOCOPY VARCHAR2)
1469: is
1470:
1471: l_CPID number;
1472: l_Container_Status fnd_svc_components.component_status%TYPE;
1473:
1474: begin
1475: p_retcode := 0;
1476:

Line 1479: 'wf.plsql.FND_SVC_COMPONENT.REFRESH_COMPONENT_CONTAINER.begin',

1475: p_retcode := 0;
1476:
1477: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
1478: WF_LOG_PKG.STRING (WF_LOG_PKG.LEVEL_PROCEDURE,
1479: 'wf.plsql.FND_SVC_COMPONENT.REFRESH_COMPONENT_CONTAINER.begin',
1480: 'p_container_name: '||p_container_name);
1481: end if;
1482:
1483: Get_Container_Status (p_container_type => p_container_type

Line 1505: 'wf.plsql.FND_SVC_COMPONENT.REFRESH_COMPONENT_CONTAINER.container_not_running',

1501: p_errbuf := WF_CORE.TRANSLATE ('SVC_CONTAINER_NOT_RUNNING');
1502:
1503: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then
1504: WF_LOG_PKG.STRING (WF_LOG_PKG.LEVEL_ERROR,
1505: 'wf.plsql.FND_SVC_COMPONENT.REFRESH_COMPONENT_CONTAINER.container_not_running',
1506: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
1507: end if;
1508:
1509: when others then

Line 1520: 'wf.plsql.FND_SVC_COMPONENT.REFRESH_COMPONENT_CONTAINER.error',

1516: END IF;
1517:
1518: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then
1519: WF_LOG_PKG.STRING (WF_LOG_PKG.LEVEL_ERROR,
1520: 'wf.plsql.FND_SVC_COMPONENT.REFRESH_COMPONENT_CONTAINER.error',
1521: 'Error code: '||p_retCode||' ,Error desc: '||p_errbuf);
1522: end if;
1523:
1524: end Refresh_Container;

Line 1532: l_Container_Status fnd_svc_components.component_status%TYPE;

1528: , p_container_name IN VARCHAR2)
1529: IS
1530:
1531: l_CPID number;
1532: l_Container_Status fnd_svc_components.component_status%TYPE;
1533:
1534: begin
1535:
1536: Get_Container_Status (p_container_type => p_container_Type

Line 1563: from FND_SVC_COMPONENTS

1559:
1560: cursor c_Get_Distinct_Containers is
1561:
1562: select distinct standalone_container_name container_name, container_type
1563: from FND_SVC_COMPONENTS
1564: where container_type = pv_Container_Type_Servlet and standalone_container_name is not null
1565:
1566: union
1567:

Line 1569: from FND_SVC_COMPONENTS_V

1565:
1566: union
1567:
1568: select distinct concurrent_queue_name container_name, container_type
1569: from FND_SVC_COMPONENTS_V
1570: where container_type = pv_Container_Type_GSM and concurrent_queue_name is not null;
1571:
1572: begin
1573:

Line 1591: fnd_svc_component.pv_system_guid := hextoraw(wf_core.translate('WF_SYSTEM_GUID'));

1587:
1588: ---------------------------------------------------------------------------
1589: -- Set pkg level private variables
1590: begin
1591: fnd_svc_component.pv_system_guid := hextoraw(wf_core.translate('WF_SYSTEM_GUID'));
1592: fnd_svc_component.pv_schema_name := wf_core.translate('WF_SCHEMA');
1593:
1594: fnd_svc_component.pv_last_agent_name := ' ';
1595: fnd_svc_component.pv_last_queue_name := ' ';

Line 1592: fnd_svc_component.pv_schema_name := wf_core.translate('WF_SCHEMA');

1588: ---------------------------------------------------------------------------
1589: -- Set pkg level private variables
1590: begin
1591: fnd_svc_component.pv_system_guid := hextoraw(wf_core.translate('WF_SYSTEM_GUID'));
1592: fnd_svc_component.pv_schema_name := wf_core.translate('WF_SCHEMA');
1593:
1594: fnd_svc_component.pv_last_agent_name := ' ';
1595: fnd_svc_component.pv_last_queue_name := ' ';
1596: fnd_svc_component.pv_last_recipients := ' ';

Line 1594: fnd_svc_component.pv_last_agent_name := ' ';

1590: begin
1591: fnd_svc_component.pv_system_guid := hextoraw(wf_core.translate('WF_SYSTEM_GUID'));
1592: fnd_svc_component.pv_schema_name := wf_core.translate('WF_SCHEMA');
1593:
1594: fnd_svc_component.pv_last_agent_name := ' ';
1595: fnd_svc_component.pv_last_queue_name := ' ';
1596: fnd_svc_component.pv_last_recipients := ' ';
1597: pv_install_mode := wf_core.translate('WF_INSTALL');
1598: ---------------------------------------------------------------------------

Line 1595: fnd_svc_component.pv_last_queue_name := ' ';

1591: fnd_svc_component.pv_system_guid := hextoraw(wf_core.translate('WF_SYSTEM_GUID'));
1592: fnd_svc_component.pv_schema_name := wf_core.translate('WF_SCHEMA');
1593:
1594: fnd_svc_component.pv_last_agent_name := ' ';
1595: fnd_svc_component.pv_last_queue_name := ' ';
1596: fnd_svc_component.pv_last_recipients := ' ';
1597: pv_install_mode := wf_core.translate('WF_INSTALL');
1598: ---------------------------------------------------------------------------
1599: END FND_SVC_COMPONENT;

Line 1596: fnd_svc_component.pv_last_recipients := ' ';

1592: fnd_svc_component.pv_schema_name := wf_core.translate('WF_SCHEMA');
1593:
1594: fnd_svc_component.pv_last_agent_name := ' ';
1595: fnd_svc_component.pv_last_queue_name := ' ';
1596: fnd_svc_component.pv_last_recipients := ' ';
1597: pv_install_mode := wf_core.translate('WF_INSTALL');
1598: ---------------------------------------------------------------------------
1599: END FND_SVC_COMPONENT;

Line 1599: END FND_SVC_COMPONENT;

1595: fnd_svc_component.pv_last_queue_name := ' ';
1596: fnd_svc_component.pv_last_recipients := ' ';
1597: pv_install_mode := wf_core.translate('WF_INSTALL');
1598: ---------------------------------------------------------------------------
1599: END FND_SVC_COMPONENT;