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.PO_REQCHANGEREQUESTWF_PVT dependencies on FND_LOG

Line 20: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

16: g_tolerances_tbl po_co_tolerances_grp.tolerances_tbl_type;
17:
18: -- Logging Static Variables
19: G_CURRENT_RUNTIME_LEVEL NUMBER;
20: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
21: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
22: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
23: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
24: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

Line 21: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

17:
18: -- Logging Static Variables
19: G_CURRENT_RUNTIME_LEVEL NUMBER;
20: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
21: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
22: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
23: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
24: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
25: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

Line 22: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

18: -- Logging Static Variables
19: G_CURRENT_RUNTIME_LEVEL NUMBER;
20: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
21: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
22: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
23: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
24: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
25: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
26: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'po.plsql.PO_REQCHANGEREQUESTWF_PVT';

Line 23: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

19: G_CURRENT_RUNTIME_LEVEL NUMBER;
20: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
21: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
22: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
23: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
24: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
25: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
26: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'po.plsql.PO_REQCHANGEREQUESTWF_PVT';
27:

Line 24: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

20: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
21: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
22: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
23: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
24: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
25: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
26: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'po.plsql.PO_REQCHANGEREQUESTWF_PVT';
27:
28: /*************************************************************************

Line 25: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

21: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
22: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
23: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
24: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
25: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
26: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'po.plsql.PO_REQCHANGEREQUESTWF_PVT';
27:
28: /*************************************************************************
29: * Private Procedure: StartPOChangeWF

Line 4509: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

4505: -------------------------------------------------------------------
4506: --Add by Xiao and Eric for IL PO Notification on Mar-30-2009, End
4507: begin
4508:
4509: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4510:
4511: IF (g_fnd_debug = 'Y') THEN
4512: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4513: FND_LOG.string(log_level => G_LEVEL_STATEMENT,

Line 4512: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

4508:
4509: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4510:
4511: IF (g_fnd_debug = 'Y') THEN
4512: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4513: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
4514: module => G_MODULE_NAME||'.'||l_procedure_name,
4515: message => l_procedure_name||'.begin' || '-p_change_request_group_id: ' || to_char(p_change_request_group_id));
4516:

Line 4513: FND_LOG.string(log_level => G_LEVEL_STATEMENT,

4509: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4510:
4511: IF (g_fnd_debug = 'Y') THEN
4512: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4513: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
4514: module => G_MODULE_NAME||'.'||l_procedure_name,
4515: message => l_procedure_name||'.begin' || '-p_change_request_group_id: ' || to_char(p_change_request_group_id));
4516:
4517: FND_LOG.string(log_level => G_LEVEL_STATEMENT,

Line 4517: FND_LOG.string(log_level => G_LEVEL_STATEMENT,

4513: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
4514: module => G_MODULE_NAME||'.'||l_procedure_name,
4515: message => l_procedure_name||'.begin' || '-p_change_request_group_id: ' || to_char(p_change_request_group_id));
4516:
4517: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
4518: module => G_MODULE_NAME||'.'||l_procedure_name,
4519: message => 'Parameters: '||'-p_change_request_group_id: ' || to_char(p_change_request_group_id) || '-p_item_key: ' || p_item_key || '-p_process: ' || p_process );
4520:
4521: FND_LOG.string(log_level => G_LEVEL_STATEMENT,

Line 4521: FND_LOG.string(log_level => G_LEVEL_STATEMENT,

4517: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
4518: module => G_MODULE_NAME||'.'||l_procedure_name,
4519: message => 'Parameters: '||'-p_change_request_group_id: ' || to_char(p_change_request_group_id) || '-p_item_key: ' || p_item_key || '-p_process: ' || p_process );
4520:
4521: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
4522: module => G_MODULE_NAME||'.'||l_procedure_name,
4523: message => '-p_forward_from_username:'||p_forward_from_username || '-p_user_id:' ||to_char(p_user_id) || '-p_responsibility_id:' || to_char(p_responsibility_id) || '-p_application_id:' || to_char(p_application_id) );
4524:
4525: END IF;

Line 4574: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

4570:
4571: x_progress :='StartPOChangeWF:003';
4572:
4573: IF (g_fnd_debug = 'Y') THEN
4574: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4575: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
4576: module => G_MODULE_NAME||'.'||l_procedure_name,
4577: message => 'change_request_group_id:' ||to_char(p_change_request_group_id) || '-before creating workflow');
4578: END IF;

Line 4575: FND_LOG.string(log_level => G_LEVEL_STATEMENT,

4571: x_progress :='StartPOChangeWF:003';
4572:
4573: IF (g_fnd_debug = 'Y') THEN
4574: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4575: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
4576: module => G_MODULE_NAME||'.'||l_procedure_name,
4577: message => 'change_request_group_id:' ||to_char(p_change_request_group_id) || '-before creating workflow');
4578: END IF;
4579: END IF;

Line 4587: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

4583: process => p_process);
4584: x_progress :='StartPOChangeWF:004';
4585:
4586: IF (g_fnd_debug = 'Y') THEN
4587: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4588: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
4589: module => G_MODULE_NAME||'.'||l_procedure_name,
4590: message => 'change_request_group_id:' ||to_char(p_change_request_group_id) || '-after creating workflow');
4591: END IF;

Line 4588: FND_LOG.string(log_level => G_LEVEL_STATEMENT,

4584: x_progress :='StartPOChangeWF:004';
4585:
4586: IF (g_fnd_debug = 'Y') THEN
4587: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4588: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
4589: module => G_MODULE_NAME||'.'||l_procedure_name,
4590: message => 'change_request_group_id:' ||to_char(p_change_request_group_id) || '-after creating workflow');
4591: END IF;
4592: END IF;

Line 4608: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

4604: into l_requisition_num, l_parent_item_type, l_parent_item_key, l_req_header_id;
4605: close get_parent_info_csr;
4606:
4607: IF (g_fnd_debug = 'Y') THEN
4608: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4609: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
4610: module => G_MODULE_NAME ||l_procedure_name,
4611: message => 'change_request_group_id:' ||to_char(p_change_request_group_id)|| '-l_req_header_id:'||to_char(l_req_header_id) );
4612: END IF;

Line 4609: FND_LOG.string(log_level => G_LEVEL_STATEMENT,

4605: close get_parent_info_csr;
4606:
4607: IF (g_fnd_debug = 'Y') THEN
4608: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4609: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
4610: module => G_MODULE_NAME ||l_procedure_name,
4611: message => 'change_request_group_id:' ||to_char(p_change_request_group_id)|| '-l_req_header_id:'||to_char(l_req_header_id) );
4612: END IF;
4613: END IF;

Line 4775: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

4771: itemkey => l_inform_item_key,
4772: aname => 'NOTE');
4773:
4774: IF (g_fnd_debug = 'Y') THEN
4775: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4776: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
4777: module => G_MODULE_NAME||'.'||l_procedure_name,
4778: message => 'l_responder_user_id => ' ||l_responder_user_id || 'l_responder_resp_id => ' || l_responder_resp_id || ' l_responder_appl_id => ' ||l_responder_appl_id );
4779: FND_LOG.string(log_level => G_LEVEL_STATEMENT,

Line 4776: FND_LOG.string(log_level => G_LEVEL_STATEMENT,

4772: aname => 'NOTE');
4773:
4774: IF (g_fnd_debug = 'Y') THEN
4775: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4776: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
4777: module => G_MODULE_NAME||'.'||l_procedure_name,
4778: message => 'l_responder_user_id => ' ||l_responder_user_id || 'l_responder_resp_id => ' || l_responder_resp_id || ' l_responder_appl_id => ' ||l_responder_appl_id );
4779: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
4780: module => G_MODULE_NAME||'.'||l_procedure_name,

Line 4779: FND_LOG.string(log_level => G_LEVEL_STATEMENT,

4775: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4776: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
4777: module => G_MODULE_NAME||'.'||l_procedure_name,
4778: message => 'l_responder_user_id => ' ||l_responder_user_id || 'l_responder_resp_id => ' || l_responder_resp_id || ' l_responder_appl_id => ' ||l_responder_appl_id );
4779: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
4780: module => G_MODULE_NAME||'.'||l_procedure_name,
4781: message => 'l_note => ' ||l_note );
4782: END IF;
4783: END IF;

Line 4810: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

4806:
4807: /* Bug# 3431902 - Need to set the Parent Child relationship between processes */
4808:
4809: IF (g_fnd_debug = 'Y') THEN
4810: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4811: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
4812: module => G_MODULE_NAME||'.'||l_procedure_name,
4813: message => 'change_request_group_id:' ||to_char(p_change_request_group_id)||'-before setting the parent-child relationship.');
4814: END IF;

Line 4811: FND_LOG.string(log_level => G_LEVEL_STATEMENT,

4807: /* Bug# 3431902 - Need to set the Parent Child relationship between processes */
4808:
4809: IF (g_fnd_debug = 'Y') THEN
4810: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4811: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
4812: module => G_MODULE_NAME||'.'||l_procedure_name,
4813: message => 'change_request_group_id:' ||to_char(p_change_request_group_id)||'-before setting the parent-child relationship.');
4814: END IF;
4815: END IF;

Line 4824: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

4820: parent_itemkey => l_parent_item_key,
4821: parent_context => NULL);
4822:
4823: IF (g_fnd_debug = 'Y') THEN
4824: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4825: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
4826: module => G_MODULE_NAME||'.'||l_procedure_name,
4827: message => 'change_request_group_id:' ||to_char(p_change_request_group_id) ||'-after setting the parent-child relationship.');
4828:

Line 4825: FND_LOG.string(log_level => G_LEVEL_STATEMENT,

4821: parent_context => NULL);
4822:
4823: IF (g_fnd_debug = 'Y') THEN
4824: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4825: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
4826: module => G_MODULE_NAME||'.'||l_procedure_name,
4827: message => 'change_request_group_id:' ||to_char(p_change_request_group_id) ||'-after setting the parent-child relationship.');
4828:
4829: FND_LOG.string(log_level => G_LEVEL_STATEMENT,

Line 4829: FND_LOG.string(log_level => G_LEVEL_STATEMENT,

4825: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
4826: module => G_MODULE_NAME||'.'||l_procedure_name,
4827: message => 'change_request_group_id:' ||to_char(p_change_request_group_id) ||'-after setting the parent-child relationship.');
4828:
4829: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
4830: module => G_MODULE_NAME||'.'||l_procedure_name,
4831: message => 'change_request_group_id:' ||to_char(p_change_request_group_id)||'-before kicking off workflow');
4832: END IF;
4833: END IF;

Line 4841: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

4837: wf_engine.StartProcess(itemtype => item_type,
4838: itemkey => item_key);
4839:
4840: IF (g_fnd_debug = 'Y') THEN
4841: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4842: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
4843: module => G_MODULE_NAME||'.'||l_procedure_name,
4844: message => 'change_request_group_id:' ||to_char(p_change_request_group_id) ||'-after kicking off workflow');
4845: END IF;

Line 4842: FND_LOG.string(log_level => G_LEVEL_STATEMENT,

4838: itemkey => item_key);
4839:
4840: IF (g_fnd_debug = 'Y') THEN
4841: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4842: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
4843: module => G_MODULE_NAME||'.'||l_procedure_name,
4844: message => 'change_request_group_id:' ||to_char(p_change_request_group_id) ||'-after kicking off workflow');
4845: END IF;
4846: END IF;

Line 4859: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

4855:
4856: -- commit;
4857:
4858: IF (g_fnd_debug = 'Y') THEN
4859: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4860: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
4861: module => G_MODULE_NAME||'.'||l_procedure_name ,
4862: message => l_procedure_name||'.end'||'-change_request_group_id:' ||to_char(p_change_request_group_id));
4863: END IF;

Line 4860: FND_LOG.string(log_level => G_LEVEL_STATEMENT,

4856: -- commit;
4857:
4858: IF (g_fnd_debug = 'Y') THEN
4859: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4860: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
4861: module => G_MODULE_NAME||'.'||l_procedure_name ,
4862: message => l_procedure_name||'.end'||'-change_request_group_id:' ||to_char(p_change_request_group_id));
4863: END IF;
4864: END IF;

Line 4869: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

4865:
4866: EXCEPTION
4867: WHEN OTHERS THEN
4868: IF (g_fnd_debug = 'Y') THEN
4869: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4870: FND_LOG.string(log_level => G_LEVEL_EXCEPTION,
4871: module => G_MODULE_NAME||'.'||l_procedure_name,
4872: message => l_procedure_name||'-'|| x_progress|| ' ' || sqlerrm);
4873: END IF;

Line 4870: FND_LOG.string(log_level => G_LEVEL_EXCEPTION,

4866: EXCEPTION
4867: WHEN OTHERS THEN
4868: IF (g_fnd_debug = 'Y') THEN
4869: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4870: FND_LOG.string(log_level => G_LEVEL_EXCEPTION,
4871: module => G_MODULE_NAME||'.'||l_procedure_name,
4872: message => l_procedure_name||'-'|| x_progress|| ' ' || sqlerrm);
4873: END IF;
4874: END IF;

Line 9481: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

9477: where pcr2.change_request_group_id=l_change_request_group_id
9478: and pcr.change_request_id=pcr2.parent_change_request_id
9479: and pcr.wf_item_type is not null;
9480: begin
9481: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
9482:
9483: IF (g_fnd_debug = 'Y') THEN
9484: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
9485: FND_LOG.string(log_level => G_LEVEL_STATEMENT,

Line 9484: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

9480: begin
9481: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
9482:
9483: IF (g_fnd_debug = 'Y') THEN
9484: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
9485: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
9486: module => G_MODULE_NAME||'.'||l_procedure_name,
9487: message => l_procedure_name||'.begin'||'-change_request_group_id:' ||to_char(p_change_request_group_id) );
9488: FND_LOG.string(log_level => G_LEVEL_STATEMENT,

Line 9485: FND_LOG.string(log_level => G_LEVEL_STATEMENT,

9481: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
9482:
9483: IF (g_fnd_debug = 'Y') THEN
9484: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
9485: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
9486: module => G_MODULE_NAME||'.'||l_procedure_name,
9487: message => l_procedure_name||'.begin'||'-change_request_group_id:' ||to_char(p_change_request_group_id) );
9488: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
9489: module => G_MODULE_NAME||'.'||l_procedure_name,

Line 9488: FND_LOG.string(log_level => G_LEVEL_STATEMENT,

9484: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
9485: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
9486: module => G_MODULE_NAME||'.'||l_procedure_name,
9487: message => l_procedure_name||'.begin'||'-change_request_group_id:' ||to_char(p_change_request_group_id) );
9488: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
9489: module => G_MODULE_NAME||'.'||l_procedure_name,
9490: message => 'Parameters:'||'-p_change_request_group_id:'||to_char(p_change_request_group_id) || '-p_api_version:' || to_char(p_api_version) );
9491: END IF;
9492:

Line 9498: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

9494:
9495: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
9496: l_api_name, g_pkg_name) THEN
9497: IF (g_fnd_debug = 'Y') THEN
9498: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
9499: FND_LOG.string(log_level => G_LEVEL_EXCEPTION,
9500: module => G_MODULE_NAME||'.'||l_procedure_name,
9501: message => 'api is not compatible');
9502: END IF;

Line 9499: FND_LOG.string(log_level => G_LEVEL_EXCEPTION,

9495: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
9496: l_api_name, g_pkg_name) THEN
9497: IF (g_fnd_debug = 'Y') THEN
9498: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
9499: FND_LOG.string(log_level => G_LEVEL_EXCEPTION,
9500: module => G_MODULE_NAME||'.'||l_procedure_name,
9501: message => 'api is not compatible');
9502: END IF;
9503: END IF;

Line 9536: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

9532: END;
9533:
9534: x_progress:='004';
9535: IF (g_fnd_debug = 'Y') THEN
9536: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
9537: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
9538: module => G_MODULE_NAME||'.'||l_procedure_name,
9539: message => 'change_request_group_id:' ||to_char(p_change_request_group_id)||'-is_parent_wf_available:' || l_parent_wf_available );
9540:

Line 9537: FND_LOG.string(log_level => G_LEVEL_STATEMENT,

9533:
9534: x_progress:='004';
9535: IF (g_fnd_debug = 'Y') THEN
9536: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
9537: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
9538: module => G_MODULE_NAME||'.'||l_procedure_name,
9539: message => 'change_request_group_id:' ||to_char(p_change_request_group_id)||'-is_parent_wf_available:' || l_parent_wf_available );
9540:
9541: END IF;

Line 9577: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

9573:
9574: x_progress:='006';
9575:
9576: IF (g_fnd_debug = 'Y') THEN
9577: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
9578: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
9579: module => G_MODULE_NAME||'.'||l_procedure_name ,
9580: message => 'change_request_group_id:' ||to_char(p_change_request_group_id)||' getting ids from session since parent wf is not available' );
9581:

Line 9578: FND_LOG.string(log_level => G_LEVEL_STATEMENT,

9574: x_progress:='006';
9575:
9576: IF (g_fnd_debug = 'Y') THEN
9577: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
9578: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
9579: module => G_MODULE_NAME||'.'||l_procedure_name ,
9580: message => 'change_request_group_id:' ||to_char(p_change_request_group_id)||' getting ids from session since parent wf is not available' );
9581:
9582: END IF;

Line 9593: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

9589:
9590: x_progress:='007';
9591:
9592: IF (g_fnd_debug = 'Y') THEN
9593: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
9594: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
9595: module => G_MODULE_NAME||'.'||l_procedure_name,
9596: message => l_procedure_name||'.end'|| '-change_request_group_id:' ||to_char(p_change_request_group_id));
9597: END IF;

Line 9594: FND_LOG.string(log_level => G_LEVEL_STATEMENT,

9590: x_progress:='007';
9591:
9592: IF (g_fnd_debug = 'Y') THEN
9593: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
9594: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
9595: module => G_MODULE_NAME||'.'||l_procedure_name,
9596: message => l_procedure_name||'.end'|| '-change_request_group_id:' ||to_char(p_change_request_group_id));
9597: END IF;
9598: END IF;

Line 9603: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

9599:
9600: EXCEPTION
9601: when others then
9602: x_return_status := FND_API.g_ret_sts_unexp_error;
9603: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
9604: FND_LOG.string(log_level => G_LEVEL_EXCEPTION,
9605: module => G_MODULE_NAME||'.'||l_procedure_name,
9606: message => 'x_progress:'||x_progress||'-sqlerrm:'||sqlerrm);
9607: END IF;

Line 9604: FND_LOG.string(log_level => G_LEVEL_EXCEPTION,

9600: EXCEPTION
9601: when others then
9602: x_return_status := FND_API.g_ret_sts_unexp_error;
9603: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
9604: FND_LOG.string(log_level => G_LEVEL_EXCEPTION,
9605: module => G_MODULE_NAME||'.'||l_procedure_name,
9606: message => 'x_progress:'||x_progress||'-sqlerrm:'||sqlerrm);
9607: END IF;
9608: end Process_Buyer_Response;

Line 13695: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

13691: END IF;
13692: EXCEPTION
13693: WHEN OTHERS THEN
13694: IF (g_fnd_debug = 'Y') THEN
13695: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
13696: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
13697: module => G_MODULE_NAME||'.'||'get_req_line_num_chng_grp',
13698: message => 'l_line_id is :' ||to_char(l_line_id));
13699: END IF;

Line 13696: FND_LOG.string(log_level => G_LEVEL_STATEMENT,

13692: EXCEPTION
13693: WHEN OTHERS THEN
13694: IF (g_fnd_debug = 'Y') THEN
13695: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
13696: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
13697: module => G_MODULE_NAME||'.'||'get_req_line_num_chng_grp',
13698: message => 'l_line_id is :' ||to_char(l_line_id));
13699: END IF;
13700: END IF;