DBA Data[Home] [Help]

APPS.EGO_PUB_FWK_PK dependencies on FND_GLOBAL

Line 202: ,FND_GLOBAL.USER_ID

198: ,pk5_value(i)
199: ,user_entered(i)
200: ,entity_type_id(i)
201: ,SYSDATE
202: ,FND_GLOBAL.USER_ID
203: ,SYSDATE
204: ,FND_GLOBAL.USER_ID
205: ,FND_GLOBAL.LOGIN_ID
206: );

Line 204: ,FND_GLOBAL.USER_ID

200: ,entity_type_id(i)
201: ,SYSDATE
202: ,FND_GLOBAL.USER_ID
203: ,SYSDATE
204: ,FND_GLOBAL.USER_ID
205: ,FND_GLOBAL.LOGIN_ID
206: );
207: EGO_COMMON_PVT.WRITE_DIAGNOSTIC ( p_log_level => FND_LOG.LEVEL_STATEMENT
208: ,p_module => 'EGO_PUB_FWK_PK.add_derived_entities'

Line 205: ,FND_GLOBAL.LOGIN_ID

201: ,SYSDATE
202: ,FND_GLOBAL.USER_ID
203: ,SYSDATE
204: ,FND_GLOBAL.USER_ID
205: ,FND_GLOBAL.LOGIN_ID
206: );
207: EGO_COMMON_PVT.WRITE_DIAGNOSTIC ( p_log_level => FND_LOG.LEVEL_STATEMENT
208: ,p_module => 'EGO_PUB_FWK_PK.add_derived_entities'
209: ,p_message => 'lStmtNum=' || to_char(l_stmt_num)

Line 342: ,FND_GLOBAL.USER_ID

338: ,Pk5_Value
339: ,User_Entered
340: ,Entity_Type_Id
341: ,SYSDATE
342: ,FND_GLOBAL.USER_ID
343: ,SYSDATE
344: ,FND_GLOBAL.USER_ID
345: ,FND_GLOBAL.LOGIN_ID
346: ,1

Line 344: ,FND_GLOBAL.USER_ID

340: ,Entity_Type_Id
341: ,SYSDATE
342: ,FND_GLOBAL.USER_ID
343: ,SYSDATE
344: ,FND_GLOBAL.USER_ID
345: ,FND_GLOBAL.LOGIN_ID
346: ,1
347: FROM Ego_Publication_Batch_GT
348: WHERE Batch_Id = p_batch_id;

Line 345: ,FND_GLOBAL.LOGIN_ID

341: ,SYSDATE
342: ,FND_GLOBAL.USER_ID
343: ,SYSDATE
344: ,FND_GLOBAL.USER_ID
345: ,FND_GLOBAL.LOGIN_ID
346: ,1
347: FROM Ego_Publication_Batch_GT
348: WHERE Batch_Id = p_batch_id;
349: EGO_COMMON_PVT.WRITE_DIAGNOSTIC ( p_log_level => FND_LOG.LEVEL_STATEMENT

Line 406: ,FND_GLOBAL.USER_ID

402: ,t_system_code(i)
403: ,t_batch_ent_obj_id(i)
404: ,C_IN_PROCESS
405: ,SYSDATE
406: ,FND_GLOBAL.USER_ID
407: ,SYSDATE
408: ,FND_GLOBAL.USER_ID
409: ,FND_GLOBAL.LOGIN_ID
410: ,1

Line 408: ,FND_GLOBAL.USER_ID

404: ,C_IN_PROCESS
405: ,SYSDATE
406: ,FND_GLOBAL.USER_ID
407: ,SYSDATE
408: ,FND_GLOBAL.USER_ID
409: ,FND_GLOBAL.LOGIN_ID
410: ,1
411: );
412: EGO_COMMON_PVT.WRITE_DIAGNOSTIC ( p_log_level => FND_LOG.LEVEL_STATEMENT

Line 409: ,FND_GLOBAL.LOGIN_ID

405: ,SYSDATE
406: ,FND_GLOBAL.USER_ID
407: ,SYSDATE
408: ,FND_GLOBAL.USER_ID
409: ,FND_GLOBAL.LOGIN_ID
410: ,1
411: );
412: EGO_COMMON_PVT.WRITE_DIAGNOSTIC ( p_log_level => FND_LOG.LEVEL_STATEMENT
413: ,p_module => 'EGO_PUB_FWK_PK.process_entities'

Line 1247: ,FND_GLOBAL.USER_ID

1243: ,t_system_code(i)
1244: ,t_status(i)
1245: ,t_message(i)
1246: ,SYSDATE
1247: ,FND_GLOBAL.USER_ID
1248: ,SYSDATE
1249: ,FND_GLOBAL.USER_ID
1250: ,FND_GLOBAL.LOGIN_ID
1251: );

Line 1249: ,FND_GLOBAL.USER_ID

1245: ,t_message(i)
1246: ,SYSDATE
1247: ,FND_GLOBAL.USER_ID
1248: ,SYSDATE
1249: ,FND_GLOBAL.USER_ID
1250: ,FND_GLOBAL.LOGIN_ID
1251: );
1252: EGO_COMMON_PVT.WRITE_DIAGNOSTIC ( p_log_level => FND_LOG.LEVEL_STATEMENT
1253: ,p_module => 'EGO_PUB_FWK_PK.Update_Pub_Status'

Line 1250: ,FND_GLOBAL.LOGIN_ID

1246: ,SYSDATE
1247: ,FND_GLOBAL.USER_ID
1248: ,SYSDATE
1249: ,FND_GLOBAL.USER_ID
1250: ,FND_GLOBAL.LOGIN_ID
1251: );
1252: EGO_COMMON_PVT.WRITE_DIAGNOSTIC ( p_log_level => FND_LOG.LEVEL_STATEMENT
1253: ,p_module => 'EGO_PUB_FWK_PK.Update_Pub_Status'
1254: ,p_message => 'lStmtNum=' || to_char(l_stmt_num)

Line 1970: l_user_id := FND_GLOBAL.user_id;

1966: ,p_message => 'check user has the resp or not ');
1967:
1968: -- check the user has the responsiblity
1969: begin
1970: l_user_id := FND_GLOBAL.user_id;
1971: l_resp_id := FND_GLOBAL.resp_id;
1972: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
1973: ,p_module => l_module_name
1974: ,p_message => 'user_id :' || l_user_id || ', resp_id: ' || l_resp_id);

Line 1971: l_resp_id := FND_GLOBAL.resp_id;

1967:
1968: -- check the user has the responsiblity
1969: begin
1970: l_user_id := FND_GLOBAL.user_id;
1971: l_resp_id := FND_GLOBAL.resp_id;
1972: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
1973: ,p_module => l_module_name
1974: ,p_message => 'user_id :' || l_user_id || ', resp_id: ' || l_resp_id);
1975:

Line 2622: l_user_id := FND_GLOBAL.user_id;

2618: l_event_data varchar2(3000);
2619:
2620: BEGIN
2621: l_batch_id := p_batch_id;
2622: l_user_id := FND_GLOBAL.user_id;
2623: x_return_status := FND_API.G_RET_STS_SUCCESS;
2624:
2625: /*
2626: * check current user equals the batch creator, batch in draft status!!

Line 2853: l_user_name := fnd_profile.value('USERNAME');--FND_GLOBAL.user_name;

2849: ,p_value => 'getAGDetails'
2850: ,p_ParameterList => l_parameter_List);
2851: end if;
2852:
2853: l_user_name := fnd_profile.value('USERNAME');--FND_GLOBAL.user_name;
2854: l_passwd_mod := 'EGO' ; -- to avoid compliance failure when arcs in
2855: l_passwd_mod := lower(l_passwd_mod) || '.syncservice';
2856:
2857: wf_event.AddParameterToList(p_name => 'WFBES_SOAP_USERNAME'

Line 3028: l_user_id := FND_GLOBAL.user_id;

3024: return ;
3025: end if;
3026:
3027: -- initialize these local varialbes
3028: l_user_id := FND_GLOBAL.user_id;
3029: l_resp_id := FND_GLOBAL.resp_id;
3030: l_login_id := FND_GLOBAL.login_id;
3031:
3032: -- remove duplicated entities

Line 3029: l_resp_id := FND_GLOBAL.resp_id;

3025: end if;
3026:
3027: -- initialize these local varialbes
3028: l_user_id := FND_GLOBAL.user_id;
3029: l_resp_id := FND_GLOBAL.resp_id;
3030: l_login_id := FND_GLOBAL.login_id;
3031:
3032: -- remove duplicated entities
3033: l_batch_entities := removeDupEntities(p_batch_type, p_batch_entities);

Line 3030: l_login_id := FND_GLOBAL.login_id;

3026:
3027: -- initialize these local varialbes
3028: l_user_id := FND_GLOBAL.user_id;
3029: l_resp_id := FND_GLOBAL.resp_id;
3030: l_login_id := FND_GLOBAL.login_id;
3031:
3032: -- remove duplicated entities
3033: l_batch_entities := removeDupEntities(p_batch_type, p_batch_entities);
3034: -- entities should be valid

Line 3506: if (l_creator_id <> FND_GLOBAL.user_id) then

3502: else
3503: raise no_data_found;
3504: end if;
3505:
3506: if (l_creator_id <> FND_GLOBAL.user_id) then
3507: raise EGO_PUB_BATCH_NOT_CREATOR;
3508: end if;
3509:
3510: select status_code into l_status

Line 3915: l_user_id := FND_GLOBAL.user_id;

3911: end if;
3912:
3913:
3914: -- the publish history use attribute group's function name
3915: l_user_id := FND_GLOBAL.user_id;
3916: hasPublishSyncPriv(l_user_id, C_BATCH_ENTITY_AG,
3917: x_return_status, x_msg_count, x_msg_data);
3918: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
3919: return ;