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 4349: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

4345: l_document_type_disp varchar2(200);
4346:
4347: begin
4348:
4349: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4350:
4351: IF (g_fnd_debug = 'Y') THEN
4352: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4353: FND_LOG.string(log_level => G_LEVEL_STATEMENT,

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

4348:
4349: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4350:
4351: IF (g_fnd_debug = 'Y') THEN
4352: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4353: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
4354: module => G_MODULE_NAME||'.'||l_procedure_name,
4355: message => l_procedure_name||'.begin' || '-p_change_request_group_id: ' || to_char(p_change_request_group_id));
4356:

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

4349: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4350:
4351: IF (g_fnd_debug = 'Y') THEN
4352: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4353: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
4354: module => G_MODULE_NAME||'.'||l_procedure_name,
4355: message => l_procedure_name||'.begin' || '-p_change_request_group_id: ' || to_char(p_change_request_group_id));
4356:
4357: FND_LOG.string(log_level => G_LEVEL_STATEMENT,

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

4353: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
4354: module => G_MODULE_NAME||'.'||l_procedure_name,
4355: message => l_procedure_name||'.begin' || '-p_change_request_group_id: ' || to_char(p_change_request_group_id));
4356:
4357: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
4358: module => G_MODULE_NAME||'.'||l_procedure_name,
4359: message => 'Parameters: '||'-p_change_request_group_id: ' || to_char(p_change_request_group_id) || '-p_item_key: ' || p_item_key || '-p_process: ' || p_process );
4360:
4361: FND_LOG.string(log_level => G_LEVEL_STATEMENT,

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

4357: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
4358: module => G_MODULE_NAME||'.'||l_procedure_name,
4359: message => 'Parameters: '||'-p_change_request_group_id: ' || to_char(p_change_request_group_id) || '-p_item_key: ' || p_item_key || '-p_process: ' || p_process );
4360:
4361: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
4362: module => G_MODULE_NAME||'.'||l_procedure_name,
4363: 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) );
4364:
4365: END IF;

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

4410:
4411: x_progress :='StartPOChangeWF:003';
4412:
4413: IF (g_fnd_debug = 'Y') THEN
4414: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4415: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
4416: module => G_MODULE_NAME||'.'||l_procedure_name,
4417: message => 'change_request_group_id:' ||to_char(p_change_request_group_id) || '-before creating workflow');
4418: END IF;

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

4411: x_progress :='StartPOChangeWF:003';
4412:
4413: IF (g_fnd_debug = 'Y') THEN
4414: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4415: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
4416: module => G_MODULE_NAME||'.'||l_procedure_name,
4417: message => 'change_request_group_id:' ||to_char(p_change_request_group_id) || '-before creating workflow');
4418: END IF;
4419: END IF;

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

4423: process => p_process);
4424: x_progress :='StartPOChangeWF:004';
4425:
4426: IF (g_fnd_debug = 'Y') THEN
4427: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4428: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
4429: module => G_MODULE_NAME||'.'||l_procedure_name,
4430: message => 'change_request_group_id:' ||to_char(p_change_request_group_id) || '-after creating workflow');
4431: END IF;

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

4424: x_progress :='StartPOChangeWF:004';
4425:
4426: IF (g_fnd_debug = 'Y') THEN
4427: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4428: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
4429: module => G_MODULE_NAME||'.'||l_procedure_name,
4430: message => 'change_request_group_id:' ||to_char(p_change_request_group_id) || '-after creating workflow');
4431: END IF;
4432: END IF;

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

4444: into l_requisition_num, l_parent_item_type, l_parent_item_key, l_req_header_id;
4445: close get_parent_info_csr;
4446:
4447: IF (g_fnd_debug = 'Y') THEN
4448: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4449: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
4450: module => G_MODULE_NAME ||l_procedure_name,
4451: message => 'change_request_group_id:' ||to_char(p_change_request_group_id)|| '-l_req_header_id:'||to_char(l_req_header_id) );
4452: END IF;

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

4445: close get_parent_info_csr;
4446:
4447: IF (g_fnd_debug = 'Y') THEN
4448: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4449: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
4450: module => G_MODULE_NAME ||l_procedure_name,
4451: message => 'change_request_group_id:' ||to_char(p_change_request_group_id)|| '-l_req_header_id:'||to_char(l_req_header_id) );
4452: END IF;
4453: END IF;

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

4591: fnd_global.resp_appl_id);
4592:
4593:
4594: IF (g_fnd_debug = 'Y') THEN
4595: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4596: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
4597: module => G_MODULE_NAME||'.'||l_procedure_name,
4598: 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 );
4599: END IF;

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

4592:
4593:
4594: IF (g_fnd_debug = 'Y') THEN
4595: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4596: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
4597: module => G_MODULE_NAME||'.'||l_procedure_name,
4598: 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 );
4599: END IF;
4600: END IF;

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

4618:
4619: /* Bug# 3431902 - Need to set the Parent Child relationship between processes */
4620:
4621: IF (g_fnd_debug = 'Y') THEN
4622: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4623: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
4624: module => G_MODULE_NAME||'.'||l_procedure_name,
4625: message => 'change_request_group_id:' ||to_char(p_change_request_group_id)||'-before setting the parent-child relationship.');
4626: END IF;

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

4619: /* Bug# 3431902 - Need to set the Parent Child relationship between processes */
4620:
4621: IF (g_fnd_debug = 'Y') THEN
4622: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4623: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
4624: module => G_MODULE_NAME||'.'||l_procedure_name,
4625: message => 'change_request_group_id:' ||to_char(p_change_request_group_id)||'-before setting the parent-child relationship.');
4626: END IF;
4627: END IF;

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

4632: parent_itemkey => l_parent_item_key,
4633: parent_context => NULL);
4634:
4635: IF (g_fnd_debug = 'Y') THEN
4636: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4637: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
4638: module => G_MODULE_NAME||'.'||l_procedure_name,
4639: message => 'change_request_group_id:' ||to_char(p_change_request_group_id) ||'-after setting the parent-child relationship.');
4640:

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

4633: parent_context => NULL);
4634:
4635: IF (g_fnd_debug = 'Y') THEN
4636: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4637: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
4638: module => G_MODULE_NAME||'.'||l_procedure_name,
4639: message => 'change_request_group_id:' ||to_char(p_change_request_group_id) ||'-after setting the parent-child relationship.');
4640:
4641: FND_LOG.string(log_level => G_LEVEL_STATEMENT,

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

4637: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
4638: module => G_MODULE_NAME||'.'||l_procedure_name,
4639: message => 'change_request_group_id:' ||to_char(p_change_request_group_id) ||'-after setting the parent-child relationship.');
4640:
4641: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
4642: module => G_MODULE_NAME||'.'||l_procedure_name,
4643: message => 'change_request_group_id:' ||to_char(p_change_request_group_id)||'-before kicking off workflow');
4644: END IF;
4645: END IF;

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

4649: wf_engine.StartProcess(itemtype => item_type,
4650: itemkey => item_key);
4651:
4652: IF (g_fnd_debug = 'Y') THEN
4653: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4654: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
4655: module => G_MODULE_NAME||'.'||l_procedure_name,
4656: message => 'change_request_group_id:' ||to_char(p_change_request_group_id) ||'-after kicking off workflow');
4657: END IF;

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

4650: itemkey => item_key);
4651:
4652: IF (g_fnd_debug = 'Y') THEN
4653: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4654: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
4655: module => G_MODULE_NAME||'.'||l_procedure_name,
4656: message => 'change_request_group_id:' ||to_char(p_change_request_group_id) ||'-after kicking off workflow');
4657: END IF;
4658: END IF;

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

4667:
4668: -- commit;
4669:
4670: IF (g_fnd_debug = 'Y') THEN
4671: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4672: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
4673: module => G_MODULE_NAME||'.'||l_procedure_name ,
4674: message => l_procedure_name||'.end'||'-change_request_group_id:' ||to_char(p_change_request_group_id));
4675: END IF;

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

4668: -- commit;
4669:
4670: IF (g_fnd_debug = 'Y') THEN
4671: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4672: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
4673: module => G_MODULE_NAME||'.'||l_procedure_name ,
4674: message => l_procedure_name||'.end'||'-change_request_group_id:' ||to_char(p_change_request_group_id));
4675: END IF;
4676: END IF;

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

4677:
4678: EXCEPTION
4679: WHEN OTHERS THEN
4680: IF (g_fnd_debug = 'Y') THEN
4681: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4682: FND_LOG.string(log_level => G_LEVEL_EXCEPTION,
4683: module => G_MODULE_NAME||'.'||l_procedure_name,
4684: message => l_procedure_name||'-'|| x_progress|| ' ' || sqlerrm);
4685: END IF;

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

4678: EXCEPTION
4679: WHEN OTHERS THEN
4680: IF (g_fnd_debug = 'Y') THEN
4681: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4682: FND_LOG.string(log_level => G_LEVEL_EXCEPTION,
4683: module => G_MODULE_NAME||'.'||l_procedure_name,
4684: message => l_procedure_name||'-'|| x_progress|| ' ' || sqlerrm);
4685: END IF;
4686: END IF;

Line 9094: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

9090: where pcr2.change_request_group_id=l_change_request_group_id
9091: and pcr.change_request_id=pcr2.parent_change_request_id
9092: and pcr.wf_item_type is not null;
9093: begin
9094: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
9095:
9096: IF (g_fnd_debug = 'Y') THEN
9097: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
9098: FND_LOG.string(log_level => G_LEVEL_STATEMENT,

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

9093: begin
9094: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
9095:
9096: IF (g_fnd_debug = 'Y') THEN
9097: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
9098: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
9099: module => G_MODULE_NAME||'.'||l_procedure_name,
9100: message => l_procedure_name||'.begin'||'-change_request_group_id:' ||to_char(p_change_request_group_id) );
9101: FND_LOG.string(log_level => G_LEVEL_STATEMENT,

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

9094: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
9095:
9096: IF (g_fnd_debug = 'Y') THEN
9097: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
9098: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
9099: module => G_MODULE_NAME||'.'||l_procedure_name,
9100: message => l_procedure_name||'.begin'||'-change_request_group_id:' ||to_char(p_change_request_group_id) );
9101: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
9102: module => G_MODULE_NAME||'.'||l_procedure_name,

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

9097: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
9098: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
9099: module => G_MODULE_NAME||'.'||l_procedure_name,
9100: message => l_procedure_name||'.begin'||'-change_request_group_id:' ||to_char(p_change_request_group_id) );
9101: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
9102: module => G_MODULE_NAME||'.'||l_procedure_name,
9103: message => 'Parameters:'||'-p_change_request_group_id:'||to_char(p_change_request_group_id) || '-p_api_version:' || to_char(p_api_version) );
9104: END IF;
9105:

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

9107:
9108: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
9109: l_api_name, g_pkg_name) THEN
9110: IF (g_fnd_debug = 'Y') THEN
9111: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
9112: FND_LOG.string(log_level => G_LEVEL_EXCEPTION,
9113: module => G_MODULE_NAME||'.'||l_procedure_name,
9114: message => 'api is not compatible');
9115: END IF;

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

9108: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
9109: l_api_name, g_pkg_name) THEN
9110: IF (g_fnd_debug = 'Y') THEN
9111: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
9112: FND_LOG.string(log_level => G_LEVEL_EXCEPTION,
9113: module => G_MODULE_NAME||'.'||l_procedure_name,
9114: message => 'api is not compatible');
9115: END IF;
9116: END IF;

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

9145: END;
9146:
9147: x_progress:='004';
9148: IF (g_fnd_debug = 'Y') THEN
9149: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
9150: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
9151: module => G_MODULE_NAME||'.'||l_procedure_name,
9152: message => 'change_request_group_id:' ||to_char(p_change_request_group_id)||'-is_parent_wf_available:' || l_parent_wf_available );
9153:

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

9146:
9147: x_progress:='004';
9148: IF (g_fnd_debug = 'Y') THEN
9149: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
9150: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
9151: module => G_MODULE_NAME||'.'||l_procedure_name,
9152: message => 'change_request_group_id:' ||to_char(p_change_request_group_id)||'-is_parent_wf_available:' || l_parent_wf_available );
9153:
9154: END IF;

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

9186:
9187: x_progress:='006';
9188:
9189: IF (g_fnd_debug = 'Y') THEN
9190: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
9191: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
9192: module => G_MODULE_NAME||'.'||l_procedure_name ,
9193: message => 'change_request_group_id:' ||to_char(p_change_request_group_id)||' getting ids from session since parent wf is not available' );
9194:

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

9187: x_progress:='006';
9188:
9189: IF (g_fnd_debug = 'Y') THEN
9190: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
9191: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
9192: module => G_MODULE_NAME||'.'||l_procedure_name ,
9193: message => 'change_request_group_id:' ||to_char(p_change_request_group_id)||' getting ids from session since parent wf is not available' );
9194:
9195: END IF;

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

9202:
9203: x_progress:='007';
9204:
9205: IF (g_fnd_debug = 'Y') THEN
9206: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
9207: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
9208: module => G_MODULE_NAME||'.'||l_procedure_name,
9209: message => l_procedure_name||'.end'|| '-change_request_group_id:' ||to_char(p_change_request_group_id));
9210: END IF;

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

9203: x_progress:='007';
9204:
9205: IF (g_fnd_debug = 'Y') THEN
9206: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
9207: FND_LOG.string(log_level => G_LEVEL_STATEMENT,
9208: module => G_MODULE_NAME||'.'||l_procedure_name,
9209: message => l_procedure_name||'.end'|| '-change_request_group_id:' ||to_char(p_change_request_group_id));
9210: END IF;
9211: END IF;

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

9212:
9213: EXCEPTION
9214: when others then
9215: x_return_status := FND_API.g_ret_sts_unexp_error;
9216: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
9217: FND_LOG.string(log_level => G_LEVEL_EXCEPTION,
9218: module => G_MODULE_NAME||'.'||l_procedure_name,
9219: message => 'x_progress:'||x_progress||'-sqlerrm:'||sqlerrm);
9220: END IF;

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

9213: EXCEPTION
9214: when others then
9215: x_return_status := FND_API.g_ret_sts_unexp_error;
9216: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
9217: FND_LOG.string(log_level => G_LEVEL_EXCEPTION,
9218: module => G_MODULE_NAME||'.'||l_procedure_name,
9219: message => 'x_progress:'||x_progress||'-sqlerrm:'||sqlerrm);
9220: END IF;
9221: end Process_Buyer_Response;