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_LOG

Line 137: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then

133: -- This is really weird, request is getting executed and
134: -- request is not there? Maybe, request got deleted and job is still
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;

Line 145: if (wf_log_pkg.level_exception >= fnd_log.g_current_runtime_level) then

141: end if;
142: return;
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||

Line 179: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

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
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;

Line 203: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

199: --
200: IF (l_event_frequency is NULL OR
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;

Line 217: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

213: --
214: -- Audit the request history
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;

Line 250: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then

246: EXCEPTION
247: WHEN OTHERS THEN
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;

Line 407: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

403: -- Action will be set to ACTIVE in start and null when Container is stopping
404:
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);

Line 473: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

469: l_module_name gv$session.module%TYPE;
470:
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);

Line 559: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

555: begin
556:
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);

Line 650: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then

646:
647: if not l_isValid then
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;

Line 667: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then

663: else
664: p_retCode := pv_retOtherComponentError;
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;

Line 682: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

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',
685: 'p_Component_Id: '||p_Component_Id);
686: end if;

Line 728: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

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,
730: 'wf.plsql.FND_SVC_COMPONENT.UPDATE_STATUS.begin',
731: 'p_Component_Id: '||p_Component_Id
732: ||' p_Status: '||p_Status);

Line 827: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

823: is
824: l_event_paramlist wf_parameter_list_t;
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);

Line 867: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

863:
864: 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;

Line 911: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then

907: when e_ContainerNotRunning then
908: p_retCode := pv_retContainerNotRunning;
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;

Line 926: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then

922: p_retCode := pv_retOtherComponentError;
923: p_errbuf := 'Other non-SQL 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;

Line 947: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

943:
944: 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;

Line 1004: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then

1000: when e_ContainerNotRunning then
1001: p_retCode := pv_retContainerNotRunning;
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;

Line 1018: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then

1014: else
1015: p_retCode := pv_retOtherComponentError;
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;

Line 1039: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

1035:
1036: 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;

Line 1080: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then

1076:
1077: when e_ContainerNotRunning then
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;

Line 1095: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then

1091: p_retCode := pv_retOtherComponentError;
1092: p_errbuf := 'Other non-SQL 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;

Line 1116: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

1112:
1113: 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;

Line 1158: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then

1154: when e_ContainerNotRunning then
1155: p_retCode := pv_retContainerNotRunning;
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;

Line 1173: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then

1169: p_retCode := pv_retOtherComponentError;
1170: p_errbuf := 'Other non-SQL 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;

Line 1195: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

1191:
1192: 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;

Line 1236: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then

1232: when e_ContainerNotRunning then
1233: p_retCode := pv_retContainerNotRunning;
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;

Line 1251: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then

1247: p_retCode := pv_retOtherComponentError;
1248: p_errbuf := 'Other non-SQL 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;

Line 1274: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

1270:
1271: 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;

Line 1315: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then

1311: when e_ContainerNotRunning then
1312: p_retCode := pv_retContainerNotRunning;
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;

Line 1330: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then

1326: p_retCode := pv_retOtherComponentError;
1327: p_errbuf := 'Other non-SQL 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;

Line 1391: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

1387: l_concurrent_queue_id number;
1388:
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;

Line 1477: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

1473:
1474: 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;

Line 1503: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then

1499: when e_ContainerNotRunning then
1500: p_retCode := pv_retContainerNotRunning;
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;

Line 1518: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then

1514: p_retCode := pv_retOtherComponentError;
1515: p_errbuf := 'Other non-SQL 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;