APPS.FND_CP_GSM_IPC dependencies on FND_LOG

Line 407: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

403:
404: pragma AUTONOMOUS_TRANSACTION;
405:
406: begin
407: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
408: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
409: 'fnd.plsql.FND_CP_GSM_IPC.Init_Service',
410: 'Enter procedure - Handle = '||to_char(Handle));
411: end if;

Line 408: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

404: pragma AUTONOMOUS_TRANSACTION;
405:
406: begin
407: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
408: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
409: 'fnd.plsql.FND_CP_GSM_IPC.Init_Service',
410: 'Enter procedure - Handle = '||to_char(Handle));
411: end if;
412: Update_Status ( Handle, 'Running');

Line 414: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

410: 'Enter procedure - Handle = '||to_char(Handle));
411: end if;
412: Update_Status ( Handle, 'Running');
413:
414: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
415: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
416: 'fnd.plsql.FND_CP_GSM_IPC.Init_Service',
417: 'Handle ' ||to_char(Handle)||': status updated to running');
418: end if;

Line 415: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

411: end if;
412: Update_Status ( Handle, 'Running');
413:
414: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
415: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
416: 'fnd.plsql.FND_CP_GSM_IPC.Init_Service',
417: 'Handle ' ||to_char(Handle)||': status updated to running');
418: end if;
419: dq_opts.consumer_name := 'FNDCPGSMIPC_Service_'|| to_char(Handle);

Line 443: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

439: WHERE S.AUDSID = USERENV('SESSIONID')
440: AND P.Addr = S.Paddr
441: and rownum <= 1; /* Probably not necessary */
442:
443: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
444: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
445: 'fnd.plsql.FND_CP_GSM_IPC.Init_Service',
446: 'Handle ' ||to_char(Handle)||': pid='||to_char(p_id)||', spid='||osp_id||', audsid='||to_char(s_id));
447: end if;

Line 444: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

440: AND P.Addr = S.Paddr
441: and rownum <= 1; /* Probably not necessary */
442:
443: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
444: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
445: 'fnd.plsql.FND_CP_GSM_IPC.Init_Service',
446: 'Handle ' ||to_char(Handle)||': pid='||to_char(p_id)||', spid='||osp_id||', audsid='||to_char(s_id));
447: end if;
448:

Line 466: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

462: from fnd_concurrent_processes
463: where concurrent_process_id = Handle)
464: AND PROCESS_STATUS_CODE = 'A';
465:
466: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
467: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
468: 'fnd.plsql.FND_CP_GSM_IPC.Init_Service',
469: 'Handle ' ||to_char(Handle)||': sqlnet_string='|| sqlnet_str);
470: end if;

Line 467: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

463: where concurrent_process_id = Handle)
464: AND PROCESS_STATUS_CODE = 'A';
465:
466: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
467: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
468: 'fnd.plsql.FND_CP_GSM_IPC.Init_Service',
469: 'Handle ' ||to_char(Handle)||': sqlnet_string='|| sqlnet_str);
470: end if;
471:

Line 484: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

480: last_update_date = sysdate,
481: last_updated_by = 4
482: where CONCURRENT_PROCESS_ID = Handle;
483:
484: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
485: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
486: 'fnd.plsql.FND_CP_GSM_IPC.Init_Service',
487: 'Handle ' ||to_char(Handle)||': fnd_concurrent_processes updated');
488: end if;

Line 485: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

481: last_updated_by = 4
482: where CONCURRENT_PROCESS_ID = Handle;
483:
484: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
485: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
486: 'fnd.plsql.FND_CP_GSM_IPC.Init_Service',
487: 'Handle ' ||to_char(Handle)||': fnd_concurrent_processes updated');
488: end if;
489:

Line 497: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

493: WHERE Q.Application_ID = P.Queue_Application_ID
494: And Q.Concurrent_queue_ID = P.Concurrent_Queue_ID
495: And P.Concurrent_Process_Id = Handle;
496:
497: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
498: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
499: 'fnd.plsql.FND_CP_GSM_IPC.Init_Service',
500: 'Handle ' ||to_char(Handle)||': Concurrent_Queue_Name='||service_name||', Resource_Consumer_Group='||que_rcg||', Diagnostic_level='||diag_level);
501: end if;

Line 498: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

494: And Q.Concurrent_queue_ID = P.Concurrent_Queue_ID
495: And P.Concurrent_Process_Id = Handle;
496:
497: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
498: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
499: 'fnd.plsql.FND_CP_GSM_IPC.Init_Service',
500: 'Handle ' ||to_char(Handle)||': Concurrent_Queue_Name='||service_name||', Resource_Consumer_Group='||que_rcg||', Diagnostic_level='||diag_level);
501: end if;
502:

Line 528: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

524: exception
525: when others then null;
526: end;
527:
528: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
529: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
530: 'fnd.plsql.FND_CP_GSM_IPC.Init_Service',
531: 'Handle ' ||to_char(Handle)||': Work completed successfully, commiting');
532: end if;

Line 529: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

525: when others then null;
526: end;
527:
528: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
529: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
530: 'fnd.plsql.FND_CP_GSM_IPC.Init_Service',
531: 'Handle ' ||to_char(Handle)||': Work completed successfully, commiting');
532: end if;
533: