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.INV_RULE_GEN_PVT dependencies on FND_GLOBAL

Line 147: debug('insert rule: fnd_global.user_id '||fnd_global.user_id);

143: debug('Procedure Save_to_mtl_picking_rules');
144: If l_inv_rule_id is null then
145: select mtl_inv_picking_rules_s.nextval into l_inv_Rule_id from dual;
146: debug('insert rule: rule_id '||l_inv_rule_id);
147: debug('insert rule: fnd_global.user_id '||fnd_global.user_id);
148: Insert into mtl_inv_picking_rules
149: (
150: INV_RULE_ID
151: , SHELF_DAYS

Line 194: , fnd_global.user_id

190: , p_mtl_picking_rule_rec.wms_rule_id
191: , p_mtl_picking_rule_rec.wms_strategy_id
192: , p_mtl_picking_rule_rec.apply_to_source
193: , sysdate
194: , fnd_global.user_id
195: , sysdate
196: , fnd_global.user_id
197: , fnd_global.login_id
198: , null

Line 196: , fnd_global.user_id

192: , p_mtl_picking_rule_rec.apply_to_source
193: , sysdate
194: , fnd_global.user_id
195: , sysdate
196: , fnd_global.user_id
197: , fnd_global.login_id
198: , null
199: , null
200: , null

Line 197: , fnd_global.login_id

193: , sysdate
194: , fnd_global.user_id
195: , sysdate
196: , fnd_global.user_id
197: , fnd_global.login_id
198: , null
199: , null
200: , null
201: );

Line 223: , LAST_UPDATED_BY = fnd_global.user_id

219: , WMS_RULE_ID = p_mtl_picking_rule_rec.wms_rule_id
220: , WMS_STRATEGY_ID = NULL /* p_mtl_picking_rule_rec.wms_strategy_id */
221: , APPLY_TO_SOURCE = p_mtl_picking_rule_rec.apply_to_source
222: , LAST_UPDATE_DATE = sysdate
223: , LAST_UPDATED_BY = fnd_global.user_id
224: , LAST_UPDATE_LOGIN = fnd_global.login_id
225: where inv_rule_id = l_inv_rule_id;
226: end if;
227: EXCEPTION

Line 224: , LAST_UPDATE_LOGIN = fnd_global.login_id

220: , WMS_STRATEGY_ID = NULL /* p_mtl_picking_rule_rec.wms_strategy_id */
221: , APPLY_TO_SOURCE = p_mtl_picking_rule_rec.apply_to_source
222: , LAST_UPDATE_DATE = sysdate
223: , LAST_UPDATED_BY = fnd_global.user_id
224: , LAST_UPDATE_LOGIN = fnd_global.login_id
225: where inv_rule_id = l_inv_rule_id;
226: end if;
227: EXCEPTION
228: WHEN FND_API.G_EXC_ERROR THEN

Line 284: X_Created_By => fnd_global.user_id,

280: X_Enabled_Flag => l_picking_rule_rec.Enabled_Flag,
281: X_min_pick_tasks_flag => 'N',
282: X_User_Defined_Flag => 'Y',
283: X_Creation_Date => sysdate,
284: X_Created_By => fnd_global.user_id,
285: X_Last_Update_Date => sysdate,
286: X_Last_Updated_By => fnd_global.user_id,
287: X_Last_Update_Login => fnd_global.login_id,
288: X_Type_header_id => null,

Line 286: X_Last_Updated_By => fnd_global.user_id,

282: X_User_Defined_Flag => 'Y',
283: X_Creation_Date => sysdate,
284: X_Created_By => fnd_global.user_id,
285: X_Last_Update_Date => sysdate,
286: X_Last_Updated_By => fnd_global.user_id,
287: X_Last_Update_Login => fnd_global.login_id,
288: X_Type_header_id => null,
289: X_Rule_Weight => null,
290: X_Attribute1 => null,

Line 287: X_Last_Update_Login => fnd_global.login_id,

283: X_Creation_Date => sysdate,
284: X_Created_By => fnd_global.user_id,
285: X_Last_Update_Date => sysdate,
286: X_Last_Updated_By => fnd_global.user_id,
287: X_Last_Update_Login => fnd_global.login_id,
288: X_Type_header_id => null,
289: X_Rule_Weight => null,
290: X_Attribute1 => null,
291: X_Attribute2 => null,

Line 327: X_Last_Updated_By => fnd_global.user_id,

323: X_Qty_Function_Parameter_Id => 10009,
324: X_Enabled_Flag => l_picking_rule_rec.Enabled_Flag,
325: X_User_Defined_Flag => 'Y',
326: X_min_pick_tasks_flag => 'N',
327: X_Last_Updated_By => fnd_global.user_id,
328: X_Last_Update_Date => sysdate,
329: X_Last_Update_Login => fnd_global.user_id,
330: X_Type_header_id => null,
331: X_Rule_Weight => null,

Line 329: X_Last_Update_Login => fnd_global.user_id,

325: X_User_Defined_Flag => 'Y',
326: X_min_pick_tasks_flag => 'N',
327: X_Last_Updated_By => fnd_global.user_id,
328: X_Last_Update_Date => sysdate,
329: X_Last_Update_Login => fnd_global.user_id,
330: X_Type_header_id => null,
331: X_Rule_Weight => null,
332: X_Attribute1 => null,
333: X_Attribute2 => null,

Line 352: l_picking_rule_rec.created_by := fnd_global.user_id;

348: X_Allocation_mode_id => l_Allocation_mode_id
349: );
350: end if;
351:
352: l_picking_rule_rec.created_by := fnd_global.user_id;
353: l_picking_rule_rec.last_updated_by := fnd_global.user_id;
354: l_picking_rule_rec.last_update_login := fnd_global.login_id;
355: l_picking_rule_rec.creation_date := sysdate;
356: l_picking_rule_rec.last_update_date := sysdate;

Line 353: l_picking_rule_rec.last_updated_by := fnd_global.user_id;

349: );
350: end if;
351:
352: l_picking_rule_rec.created_by := fnd_global.user_id;
353: l_picking_rule_rec.last_updated_by := fnd_global.user_id;
354: l_picking_rule_rec.last_update_login := fnd_global.login_id;
355: l_picking_rule_rec.creation_date := sysdate;
356: l_picking_rule_rec.last_update_date := sysdate;
357:

Line 354: l_picking_rule_rec.last_update_login := fnd_global.login_id;

350: end if;
351:
352: l_picking_rule_rec.created_by := fnd_global.user_id;
353: l_picking_rule_rec.last_updated_by := fnd_global.user_id;
354: l_picking_rule_rec.last_update_login := fnd_global.login_id;
355: l_picking_rule_rec.creation_date := sysdate;
356: l_picking_rule_rec.last_update_date := sysdate;
357:
358: p_mtl_picking_rule_rec := l_picking_rule_rec;

Line 613: X_Last_Updated_By => fnd_global.user_id,

609: wms_RESTRICTIONS_PKG.Insert_Row(
610: X_Rowid => l_Row_Id,
611: X_Rule_Id => l_picking_rule_rec.WMS_Rule_Id,
612: X_Sequence_Number => l_Sequence_Number,
613: X_Last_Updated_By => fnd_global.user_id,
614: X_Last_Update_Date => sysdate,
615: X_Created_By => fnd_global.user_id,
616: X_Creation_Date => sysdate,
617: X_Last_Update_Login => fnd_global.login_id,

Line 615: X_Created_By => fnd_global.user_id,

611: X_Rule_Id => l_picking_rule_rec.WMS_Rule_Id,
612: X_Sequence_Number => l_Sequence_Number,
613: X_Last_Updated_By => fnd_global.user_id,
614: X_Last_Update_Date => sysdate,
615: X_Created_By => fnd_global.user_id,
616: X_Creation_Date => sysdate,
617: X_Last_Update_Login => fnd_global.login_id,
618: X_Parameter_Id => l_Parameter_Id,
619: X_Operator_Code => l_Operator_Code,

Line 617: X_Last_Update_Login => fnd_global.login_id,

613: X_Last_Updated_By => fnd_global.user_id,
614: X_Last_Update_Date => sysdate,
615: X_Created_By => fnd_global.user_id,
616: X_Creation_Date => sysdate,
617: X_Last_Update_Login => fnd_global.login_id,
618: X_Parameter_Id => l_Parameter_Id,
619: X_Operator_Code => l_Operator_Code,
620: X_Operand_Type_Code => l_Operand_Type_Code,
621: X_Operand_Constant_Number=> l_Operand_Constant_Number,

Line 769: X_CREATED_BY => fnd_global.user_id,

765: X_ROWID => l_ROW_ID,
766: X_CONSISTENCY_ID => l_CONSISTENCY_ID,
767: X_RULE_ID => l_picking_rule_rec.WMS_RULE_ID,
768: X_CREATION_DATE => sysdate,
769: X_CREATED_BY => fnd_global.user_id,
770: X_LAST_UPDATE_DATE => sysdate,
771: X_LAST_UPDATED_BY => fnd_global.user_id,
772: X_LAST_UPDATE_LOGIN => fnd_global.login_id,
773: X_PARAMETER_ID => l_parameter_id,

Line 771: X_LAST_UPDATED_BY => fnd_global.user_id,

767: X_RULE_ID => l_picking_rule_rec.WMS_RULE_ID,
768: X_CREATION_DATE => sysdate,
769: X_CREATED_BY => fnd_global.user_id,
770: X_LAST_UPDATE_DATE => sysdate,
771: X_LAST_UPDATED_BY => fnd_global.user_id,
772: X_LAST_UPDATE_LOGIN => fnd_global.login_id,
773: X_PARAMETER_ID => l_parameter_id,
774: X_ATTRIBUTE_CATEGORY => '',
775: X_ATTRIBUTE1 => '',

Line 772: X_LAST_UPDATE_LOGIN => fnd_global.login_id,

768: X_CREATION_DATE => sysdate,
769: X_CREATED_BY => fnd_global.user_id,
770: X_LAST_UPDATE_DATE => sysdate,
771: X_LAST_UPDATED_BY => fnd_global.user_id,
772: X_LAST_UPDATE_LOGIN => fnd_global.login_id,
773: X_PARAMETER_ID => l_parameter_id,
774: X_ATTRIBUTE_CATEGORY => '',
775: X_ATTRIBUTE1 => '',
776: X_ATTRIBUTE2 => '',

Line 1002: X_Created_By => fnd_global.user_id,

998: X_Rule_Id => p_mtl_picking_rule_rec.WMS_Rule_Id,
999: X_Sequence_Number => l_Sequence,
1000: X_Parameter_Id => l_Parameter_Id,
1001: X_Order_Code => l_Order_Code,
1002: X_Created_By => fnd_global.user_id,
1003: X_Creation_Date => sysdate,
1004: X_Last_Updated_By => fnd_global.user_id,
1005: X_Last_Update_Date => sysdate,
1006: X_Last_Update_Login => fnd_global.login_id,

Line 1004: X_Last_Updated_By => fnd_global.user_id,

1000: X_Parameter_Id => l_Parameter_Id,
1001: X_Order_Code => l_Order_Code,
1002: X_Created_By => fnd_global.user_id,
1003: X_Creation_Date => sysdate,
1004: X_Last_Updated_By => fnd_global.user_id,
1005: X_Last_Update_Date => sysdate,
1006: X_Last_Update_Login => fnd_global.login_id,
1007: X_Attribute1 => null,
1008: X_Attribute2 => null,

Line 1006: X_Last_Update_Login => fnd_global.login_id,

1002: X_Created_By => fnd_global.user_id,
1003: X_Creation_Date => sysdate,
1004: X_Last_Updated_By => fnd_global.user_id,
1005: X_Last_Update_Date => sysdate,
1006: X_Last_Update_Login => fnd_global.login_id,
1007: X_Attribute1 => null,
1008: X_Attribute2 => null,
1009: X_Attribute3 => null,
1010: X_Attribute4 => null,

Line 1156: , X_Created_By => fnd_global.user_id

1152: , X_Name => l_strategy_name
1153: , X_Description => l_strategy_name
1154: , X_Enabled_Flag => 'Y'
1155: , X_User_Defined_Flag => 'Y'
1156: , X_Created_By => fnd_global.user_id
1157: , X_Creation_Date => SYSDATE
1158: , X_Last_Updated_By => fnd_global.user_id
1159: , X_Last_Update_Date => SYSDATE
1160: , X_Last_Update_Login => fnd_global.login_id

Line 1158: , X_Last_Updated_By => fnd_global.user_id

1154: , X_Enabled_Flag => 'Y'
1155: , X_User_Defined_Flag => 'Y'
1156: , X_Created_By => fnd_global.user_id
1157: , X_Creation_Date => SYSDATE
1158: , X_Last_Updated_By => fnd_global.user_id
1159: , X_Last_Update_Date => SYSDATE
1160: , X_Last_Update_Login => fnd_global.login_id
1161: , X_Attribute1 => null
1162: , X_Attribute2 => null

Line 1160: , X_Last_Update_Login => fnd_global.login_id

1156: , X_Created_By => fnd_global.user_id
1157: , X_Creation_Date => SYSDATE
1158: , X_Last_Updated_By => fnd_global.user_id
1159: , X_Last_Update_Date => SYSDATE
1160: , X_Last_Update_Login => fnd_global.login_id
1161: , X_Attribute1 => null
1162: , X_Attribute2 => null
1163: , X_Attribute3 => null
1164: , X_Attribute4 => null

Line 1189: , X_Created_By => fnd_global.user_id

1185: , X_Rule_Id => p_mtl_picking_rule_rec.wms_Rule_Id
1186: , X_Partial_Success_Allowed_Flag=> p_mtl_picking_rule_rec.Partial_Allowed_Flag
1187: , X_Effective_From => null
1188: , X_Effective_To => null
1189: , X_Created_By => fnd_global.user_id
1190: , X_Creation_Date => sysdate
1191: , X_Last_Updated_By => fnd_global.user_id
1192: , X_Last_Update_Date => sysdate
1193: , X_Last_Update_Login => fnd_global.login_id

Line 1191: , X_Last_Updated_By => fnd_global.user_id

1187: , X_Effective_From => null
1188: , X_Effective_To => null
1189: , X_Created_By => fnd_global.user_id
1190: , X_Creation_Date => sysdate
1191: , X_Last_Updated_By => fnd_global.user_id
1192: , X_Last_Update_Date => sysdate
1193: , X_Last_Update_Login => fnd_global.login_id
1194: , X_Attribute1 => null
1195: , X_Attribute2 => null

Line 1193: , X_Last_Update_Login => fnd_global.login_id

1189: , X_Created_By => fnd_global.user_id
1190: , X_Creation_Date => sysdate
1191: , X_Last_Updated_By => fnd_global.user_id
1192: , X_Last_Update_Date => sysdate
1193: , X_Last_Update_Login => fnd_global.login_id
1194: , X_Attribute1 => null
1195: , X_Attribute2 => null
1196: , X_Attribute3 => null
1197: , X_Attribute4 => null

Line 1256: X_Last_Updated_By => fnd_global.user_id,

1252: X_Name => p_mtl_picking_rule_rec.name,
1253: X_Description => p_mtl_picking_rule_rec.name,
1254: X_Enabled_Flag => p_mtl_picking_rule_rec.enabled_flag,
1255: X_User_Defined_Flag => 'Y',
1256: X_Last_Updated_By => fnd_global.user_id,
1257: X_Last_Update_Date => sysdate,
1258: X_Last_Update_Login => fnd_global.user_id,
1259: X_Attribute1 => null,
1260: X_Attribute2 => null,

Line 1258: X_Last_Update_Login => fnd_global.user_id,

1254: X_Enabled_Flag => p_mtl_picking_rule_rec.enabled_flag,
1255: X_User_Defined_Flag => 'Y',
1256: X_Last_Updated_By => fnd_global.user_id,
1257: X_Last_Update_Date => sysdate,
1258: X_Last_Update_Login => fnd_global.user_id,
1259: X_Attribute1 => null,
1260: X_Attribute2 => null,
1261: X_Attribute3 => null,
1262: X_Attribute4 => null,