DBA Data[Home] [Help]

APPS.IEM_REROUTE_PUB dependencies on FND_PROFILE

Line 82: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),

78: p_init_msg_list=>'F' ,
79: p_commit=>'F' ,
80: p_message_id=>p_msgid,
81: p_agent_id=>p_agent_id,
82: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
83: p_CREATION_DATE =>SYSDATE,
84: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
85: p_LAST_UPDATE_DATE =>SYSDATE,
86: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,

Line 84: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),

80: p_message_id=>p_msgid,
81: p_agent_id=>p_agent_id,
82: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
83: p_CREATION_DATE =>SYSDATE,
84: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
85: p_LAST_UPDATE_DATE =>SYSDATE,
86: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,
87: p_ATTRIBUTE1 =>null,
88: p_ATTRIBUTE2 =>null,

Line 86: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,

82: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
83: p_CREATION_DATE =>SYSDATE,
84: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
85: p_LAST_UPDATE_DATE =>SYSDATE,
86: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,
87: p_ATTRIBUTE1 =>null,
88: p_ATTRIBUTE2 =>null,
89: p_ATTRIBUTE3 =>null,
90: p_ATTRIBUTE4 =>null,

Line 112: l_resource_id:=FND_PROFILE.VALUE_SPECIFIC('IEM_SRVR_ARES') ;

108: -- Check to See whether the message is transfered to same bin or different
109: IF p_class_id is null then
110: -- Create Interaction
111: l_interaction_rec.start_date_time := sysdate;
112: l_resource_id:=FND_PROFILE.VALUE_SPECIFIC('IEM_SRVR_ARES') ;
113: IF l_resource_id is NULL THEN
114: raise NO_DEFAULT_RESOURCE_ID;
115: END IF;
116: l_interaction_rec.resource_id:=l_resource_id ;

Line 121: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),

117: l_interaction_rec.party_id := p_customer_id;
118: l_interaction_rec.handler_id := 680; -- IEM APPL_ID
119: l_interaction_rec.parent_id := p_interaction_id;
120: JTF_IH_PUB.Open_Interaction( p_api_version => 1.0,
121: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
122: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
123: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
124: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
125: x_return_status => l_ret_status,

Line 122: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),

118: l_interaction_rec.handler_id := 680; -- IEM APPL_ID
119: l_interaction_rec.parent_id := p_interaction_id;
120: JTF_IH_PUB.Open_Interaction( p_api_version => 1.0,
121: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
122: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
123: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
124: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
125: x_return_status => l_ret_status,
126: x_msg_count => l_msg_count,

Line 123: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),

119: l_interaction_rec.parent_id := p_interaction_id;
120: JTF_IH_PUB.Open_Interaction( p_api_version => 1.0,
121: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
122: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
123: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
124: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
125: x_return_status => l_ret_status,
126: x_msg_count => l_msg_count,
127: x_msg_data => l_msg_data,

Line 124: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),

120: JTF_IH_PUB.Open_Interaction( p_api_version => 1.0,
121: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
122: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
123: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
124: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
125: x_return_status => l_ret_status,
126: x_msg_count => l_msg_count,
127: x_msg_data => l_msg_data,
128: x_interaction_id => l_interaction_id,

Line 155: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),

151: EXCEPTION WHEN OTHERS THEN
152: NULL;
153: END;
154: JTF_IH_PUB.Add_Activity(p_api_version => 1.0,
155: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
156: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
157: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
158: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
159: x_return_status => l_ret_status,

Line 156: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),

152: NULL;
153: END;
154: JTF_IH_PUB.Add_Activity(p_api_version => 1.0,
155: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
156: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
157: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
158: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
159: x_return_status => l_ret_status,
160: x_msg_count => l_msg_count,

Line 157: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),

153: END;
154: JTF_IH_PUB.Add_Activity(p_api_version => 1.0,
155: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
156: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
157: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
158: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
159: x_return_status => l_ret_status,
160: x_msg_count => l_msg_count,
161: x_msg_data => l_msg_data,

Line 158: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),

154: JTF_IH_PUB.Add_Activity(p_api_version => 1.0,
155: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
156: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
157: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
158: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
159: x_return_status => l_ret_status,
160: x_msg_count => l_msg_count,
161: x_msg_data => l_msg_data,
162: p_activity_rec => l_activity_rec,

Line 368: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),

364: p_init_msg_list=>'F' ,
365: p_commit=>'F' ,
366: p_message_id=>p_msgid,
367: p_agent_id=>p_agent_id,
368: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
369: p_CREATION_DATE =>SYSDATE,
370: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
371: p_LAST_UPDATE_DATE =>SYSDATE,
372: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,

Line 370: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),

366: p_message_id=>p_msgid,
367: p_agent_id=>p_agent_id,
368: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
369: p_CREATION_DATE =>SYSDATE,
370: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
371: p_LAST_UPDATE_DATE =>SYSDATE,
372: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,
373: p_ATTRIBUTE1 =>null,
374: p_ATTRIBUTE2 =>null,

Line 372: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,

368: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
369: p_CREATION_DATE =>SYSDATE,
370: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
371: p_LAST_UPDATE_DATE =>SYSDATE,
372: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,
373: p_ATTRIBUTE1 =>null,
374: p_ATTRIBUTE2 =>null,
375: p_ATTRIBUTE3 =>null,
376: p_ATTRIBUTE4 =>null,