DBA Data[Home] [Help]

APPS.AHL_PRD_PRINT_PVT dependencies on FND_GLOBAL

Line 1569: l_user_id := to_number(fnd_global.USER_ID);

1565: );
1566: END IF;
1567: --End Basic Validations.
1568:
1569: l_user_id := to_number(fnd_global.USER_ID);
1570: l_login_id := to_number(fnd_global.LOGIN_ID);
1571:
1572: IF (p_operation_flag = 'C' ) THEN
1573:

Line 1570: l_login_id := to_number(fnd_global.LOGIN_ID);

1566: END IF;
1567: --End Basic Validations.
1568:
1569: l_user_id := to_number(fnd_global.USER_ID);
1570: l_login_id := to_number(fnd_global.LOGIN_ID);
1571:
1572: IF (p_operation_flag = 'C' ) THEN
1573:
1574: IF (l_log_statement >= l_log_current_level)THEN

Line 3151: dbms_lob.write(l_merged_lob, length(fnd_global.user_id),length(l_merged_lob)+1, fnd_global.user_id);

3147: '),length(l_merged_lob)+1, '
3148: ');
3149: dbms_lob.write(l_merged_lob, length(''),length(l_merged_lob)+1, '');
3150: dbms_lob.write(l_merged_lob, length(''),length(l_merged_lob)+1, '');
3151: dbms_lob.write(l_merged_lob, length(fnd_global.user_id),length(l_merged_lob)+1, fnd_global.user_id);
3152: dbms_lob.write(l_merged_lob, length('
'),length(l_merged_lob)+1, '
');
3153: dbms_lob.write(l_merged_lob, length(''),length(l_merged_lob)+1, '');
3154: dummy := DBMS_XMLGEN.CONVERT(fnd_global.user_name);
3155: dbms_lob.write(l_merged_lob, length(dummy),length(l_merged_lob)+1, dummy);

Line 3154: dummy := DBMS_XMLGEN.CONVERT(fnd_global.user_name);

3150: dbms_lob.write(l_merged_lob, length(''),length(l_merged_lob)+1, '');
3151: dbms_lob.write(l_merged_lob, length(fnd_global.user_id),length(l_merged_lob)+1, fnd_global.user_id);
3152: dbms_lob.write(l_merged_lob, length('
'),length(l_merged_lob)+1, '
');
3153: dbms_lob.write(l_merged_lob, length(''),length(l_merged_lob)+1, '');
3154: dummy := DBMS_XMLGEN.CONVERT(fnd_global.user_name);
3155: dbms_lob.write(l_merged_lob, length(dummy),length(l_merged_lob)+1, dummy);
3156: dbms_lob.write(l_merged_lob, length('
'),length(l_merged_lob)+1, '
');
3157: dbms_lob.write(l_merged_lob, length(''),length(l_merged_lob)+1, '');
3158: dbms_lob.write(l_merged_lob, length(TO_CHAR(sysdate,'YYYY-MM-DD')||'T'||TO_CHAR(sysdate, 'hh24:mi:ss')),length(l_merged_lob)+1, TO_CHAR(sysdate,'YYYY-MM-DD')||'T'||TO_CHAR(sysdate, 'hh24:mi:ss'));

Line 4028: l_conc_request_id := fnd_global.conc_request_id;

4024: l_enigma_request_id VARCHAR2(240);
4025: l_err_update_status VARCHAR2(30);
4026:
4027: BEGIN
4028: l_conc_request_id := fnd_global.conc_request_id;
4029: fnd_file.put_line(FND_FILE.LOG,'Start time:' || to_char(sysdate, 'Month DD, YYYY HH24:MI:SS'));
4030: fnd_file.put_line(FND_FILE.LOG,'Entered AHL_PRD_PRINT_PVT.Generate_JCG_Request: cc id : ' || l_conc_request_id );
4031: fnd_file.new_line(FND_FILE.LOG,1);
4032: -- initialize return status.

Line 4035: fnd_global.apps_initialize(p_user_id, p_resp_id , 867/*APPLICATION ID for AHL constant */);

4031: fnd_file.new_line(FND_FILE.LOG,1);
4032: -- initialize return status.
4033: retcode := 0;
4034: l_return_status := FND_API.G_RET_STS_SUCCESS;
4035: fnd_global.apps_initialize(p_user_id, p_resp_id , 867/*APPLICATION ID for AHL constant */);
4036: mo_global.init('AHL');
4037:
4038: OPEN get_jcg_details(p_jcg_id);
4039: FETCH get_jcg_details INTO l_jcg_id,l_object_type_code,l_object_id,l_split_flag;

Line 4117: p_CONCURRENT_REQUEST_ID => l_conc_request_id --fnd_global.conc_request_id

4113: p_file_location => NULL,
4114: p_split_flag => l_split_flag,
4115: p_xml_data_filename => l_xml_file_name,
4116: p_error_message => NULL,
4117: p_CONCURRENT_REQUEST_ID => l_conc_request_id --fnd_global.conc_request_id
4118: );
4119: l_msg_count := FND_MSG_PUB.Count_Msg;
4120: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4121: retcode := 2; -- error based only on return status

Line 4142: --'JCG'-- fnd_global.user_name

4138: l_xml_file_name := FND_PROFILE.VALUE('AHL_ENIGMA_JCG_XML_FILEPATH') ||'/' ||l_xml_file_name;
4139:
4140: /*l_xmldocument := ''||
4141: ''|| + l_xml_file_name ||''||
4142: --'JCG'-- fnd_global.user_name
4143: fnd_global.user_name
4144: || '
';
4145:
4146: fnd_file.put_line(FND_FILE.LOG,'Event Data : ' || l_xmldocument);

Line 4143: fnd_global.user_name

4139:
4140: /*l_xmldocument := ''||
4141: ''|| + l_xml_file_name ||''||
4142: --'JCG'-- fnd_global.user_name
4143: fnd_global.user_name
4144: || '
';
4145:
4146: fnd_file.put_line(FND_FILE.LOG,'Event Data : ' || l_xmldocument);
4147: fnd_file.new_line(FND_FILE.LOG,1);

Line 4172: ' || fnd_global.user_name ||'

4168:
4169:
4170: ' || l_enigma_request_id ||'
4171: '|| l_xml_file_name ||'
4172: ' || fnd_global.user_name ||'
4173:

4174:

4175: ';
4176: /* invoke BPEL process AhlTestJCGHandlerService - populate from profile*/

Line 4307: l_user_id := FND_GLOBAL.USER_ID;

4303: IF FND_API.To_Boolean(p_init_msg_list) THEN
4304: FND_MSG_PUB.Initialize;
4305: END IF;
4306:
4307: l_user_id := FND_GLOBAL.USER_ID;
4308: l_resp_id := FND_GLOBAL.RESP_ID;
4309:
4310: IF (l_log_statement >= l_log_current_level)THEN
4311: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 4308: l_resp_id := FND_GLOBAL.RESP_ID;

4304: FND_MSG_PUB.Initialize;
4305: END IF;
4306:
4307: l_user_id := FND_GLOBAL.USER_ID;
4308: l_resp_id := FND_GLOBAL.RESP_ID;
4309:
4310: IF (l_log_statement >= l_log_current_level)THEN
4311: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4312: 'Starting process'

Line 4321: 'Firing cocurrent rquest for: User name : ' || FND_GLOBAL.USER_NAME || ': Resp Name : ' || FND_GLOBAL.RESP_NAME

4317: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4318: 'Firing cocurrent rquest for: l_user_id : ' || l_user_id || ': l_resp_id : ' || l_resp_id
4319: );
4320: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4321: 'Firing cocurrent rquest for: User name : ' || FND_GLOBAL.USER_NAME || ': Resp Name : ' || FND_GLOBAL.RESP_NAME
4322: );
4323: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4324: 'Firing cocurrent rquest for: p_split_flag : ' || p_split_flag
4325: );

Line 4512: fnd_global.apps_initialize(l_user_id, l_resp_id , 867);

4508: l_jcg_id := to_number(substr(p_request_id,1,instr(p_request_id,':',1,1)-1));
4509: l_user_id := to_number((substr(p_request_id,instr(p_request_id,':',1,1)+1,(instr(p_request_id,':',1,2) - instr(p_request_id,':',1,1))-1)));
4510: l_resp_id := to_number(substr(p_request_id,instr(p_request_id,':',1,2)+1));
4511: -- set application context for user that initiated request
4512: fnd_global.apps_initialize(l_user_id, l_resp_id , 867);
4513: mo_global.init('AHL');
4514:
4515: l_log_current_level := FND_LOG.g_current_runtime_level;
4516: l_log_statement := FND_LOG.level_statement;

Line 4795: fnd_global.apps_initialize(l_user_id, l_resp_id , 867);

4791: l_jcg_id := to_number(substr(p_request_id,1,instr(p_request_id,':',1,1)-1));
4792: l_user_id := to_number((substr(p_request_id,instr(p_request_id,':',1,1)+1,(instr(p_request_id,':',1,2) - instr(p_request_id,':',1,1))-1)));
4793: l_resp_id := to_number(substr(p_request_id,instr(p_request_id,':',1,2)+1));
4794: -- set application context for user that initiated request
4795: fnd_global.apps_initialize(l_user_id, l_resp_id , 867);
4796: mo_global.init('AHL');
4797:
4798: l_log_current_level := FND_LOG.g_current_runtime_level;
4799: l_log_statement := FND_LOG.level_statement;