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 657: X_Last_Updated_By => fnd_global.user_id,

653: wms_RESTRICTIONS_PKG.Insert_Row(
654: X_Rowid => l_Row_Id,
655: X_Rule_Id => l_picking_rule_rec.WMS_Rule_Id,
656: X_Sequence_Number => l_Sequence_Number,
657: X_Last_Updated_By => fnd_global.user_id,
658: X_Last_Update_Date => sysdate,
659: X_Created_By => fnd_global.user_id,
660: X_Creation_Date => sysdate,
661: X_Last_Update_Login => fnd_global.login_id,

Line 659: X_Created_By => fnd_global.user_id,

655: X_Rule_Id => l_picking_rule_rec.WMS_Rule_Id,
656: X_Sequence_Number => l_Sequence_Number,
657: X_Last_Updated_By => fnd_global.user_id,
658: X_Last_Update_Date => sysdate,
659: X_Created_By => fnd_global.user_id,
660: X_Creation_Date => sysdate,
661: X_Last_Update_Login => fnd_global.login_id,
662: X_Parameter_Id => l_Parameter_Id,
663: X_Operator_Code => l_Operator_Code,

Line 661: X_Last_Update_Login => fnd_global.login_id,

657: X_Last_Updated_By => fnd_global.user_id,
658: X_Last_Update_Date => sysdate,
659: X_Created_By => fnd_global.user_id,
660: X_Creation_Date => sysdate,
661: X_Last_Update_Login => fnd_global.login_id,
662: X_Parameter_Id => l_Parameter_Id,
663: X_Operator_Code => l_Operator_Code,
664: X_Operand_Type_Code => l_Operand_Type_Code,
665: X_Operand_Constant_Number=> l_Operand_Constant_Number,

Line 813: X_CREATED_BY => fnd_global.user_id,

809: X_ROWID => l_ROW_ID,
810: X_CONSISTENCY_ID => l_CONSISTENCY_ID,
811: X_RULE_ID => l_picking_rule_rec.WMS_RULE_ID,
812: X_CREATION_DATE => sysdate,
813: X_CREATED_BY => fnd_global.user_id,
814: X_LAST_UPDATE_DATE => sysdate,
815: X_LAST_UPDATED_BY => fnd_global.user_id,
816: X_LAST_UPDATE_LOGIN => fnd_global.login_id,
817: X_PARAMETER_ID => l_parameter_id,

Line 815: X_LAST_UPDATED_BY => fnd_global.user_id,

811: X_RULE_ID => l_picking_rule_rec.WMS_RULE_ID,
812: X_CREATION_DATE => sysdate,
813: X_CREATED_BY => fnd_global.user_id,
814: X_LAST_UPDATE_DATE => sysdate,
815: X_LAST_UPDATED_BY => fnd_global.user_id,
816: X_LAST_UPDATE_LOGIN => fnd_global.login_id,
817: X_PARAMETER_ID => l_parameter_id,
818: X_ATTRIBUTE_CATEGORY => '',
819: X_ATTRIBUTE1 => '',

Line 816: X_LAST_UPDATE_LOGIN => fnd_global.login_id,

812: X_CREATION_DATE => sysdate,
813: X_CREATED_BY => fnd_global.user_id,
814: X_LAST_UPDATE_DATE => sysdate,
815: X_LAST_UPDATED_BY => fnd_global.user_id,
816: X_LAST_UPDATE_LOGIN => fnd_global.login_id,
817: X_PARAMETER_ID => l_parameter_id,
818: X_ATTRIBUTE_CATEGORY => '',
819: X_ATTRIBUTE1 => '',
820: X_ATTRIBUTE2 => '',

Line 1046: X_Created_By => fnd_global.user_id,

1042: X_Rule_Id => p_mtl_picking_rule_rec.WMS_Rule_Id,
1043: X_Sequence_Number => l_Sequence,
1044: X_Parameter_Id => l_Parameter_Id,
1045: X_Order_Code => l_Order_Code,
1046: X_Created_By => fnd_global.user_id,
1047: X_Creation_Date => sysdate,
1048: X_Last_Updated_By => fnd_global.user_id,
1049: X_Last_Update_Date => sysdate,
1050: X_Last_Update_Login => fnd_global.login_id,

Line 1048: X_Last_Updated_By => fnd_global.user_id,

1044: X_Parameter_Id => l_Parameter_Id,
1045: X_Order_Code => l_Order_Code,
1046: X_Created_By => fnd_global.user_id,
1047: X_Creation_Date => sysdate,
1048: X_Last_Updated_By => fnd_global.user_id,
1049: X_Last_Update_Date => sysdate,
1050: X_Last_Update_Login => fnd_global.login_id,
1051: X_Attribute1 => null,
1052: X_Attribute2 => null,

Line 1050: X_Last_Update_Login => fnd_global.login_id,

1046: X_Created_By => fnd_global.user_id,
1047: X_Creation_Date => sysdate,
1048: X_Last_Updated_By => fnd_global.user_id,
1049: X_Last_Update_Date => sysdate,
1050: X_Last_Update_Login => fnd_global.login_id,
1051: X_Attribute1 => null,
1052: X_Attribute2 => null,
1053: X_Attribute3 => null,
1054: X_Attribute4 => null,

Line 1200: , X_Created_By => fnd_global.user_id

1196: , X_Name => l_strategy_name
1197: , X_Description => l_strategy_name
1198: , X_Enabled_Flag => 'Y'
1199: , X_User_Defined_Flag => 'Y'
1200: , X_Created_By => fnd_global.user_id
1201: , X_Creation_Date => SYSDATE
1202: , X_Last_Updated_By => fnd_global.user_id
1203: , X_Last_Update_Date => SYSDATE
1204: , X_Last_Update_Login => fnd_global.login_id

Line 1202: , X_Last_Updated_By => fnd_global.user_id

1198: , X_Enabled_Flag => 'Y'
1199: , X_User_Defined_Flag => 'Y'
1200: , X_Created_By => fnd_global.user_id
1201: , X_Creation_Date => SYSDATE
1202: , X_Last_Updated_By => fnd_global.user_id
1203: , X_Last_Update_Date => SYSDATE
1204: , X_Last_Update_Login => fnd_global.login_id
1205: , X_Attribute1 => null
1206: , X_Attribute2 => null

Line 1204: , X_Last_Update_Login => fnd_global.login_id

1200: , X_Created_By => fnd_global.user_id
1201: , X_Creation_Date => SYSDATE
1202: , X_Last_Updated_By => fnd_global.user_id
1203: , X_Last_Update_Date => SYSDATE
1204: , X_Last_Update_Login => fnd_global.login_id
1205: , X_Attribute1 => null
1206: , X_Attribute2 => null
1207: , X_Attribute3 => null
1208: , X_Attribute4 => null

Line 1233: , X_Created_By => fnd_global.user_id

1229: , X_Rule_Id => p_mtl_picking_rule_rec.wms_Rule_Id
1230: , X_Partial_Success_Allowed_Flag=> p_mtl_picking_rule_rec.Partial_Allowed_Flag
1231: , X_Effective_From => null
1232: , X_Effective_To => null
1233: , X_Created_By => fnd_global.user_id
1234: , X_Creation_Date => sysdate
1235: , X_Last_Updated_By => fnd_global.user_id
1236: , X_Last_Update_Date => sysdate
1237: , X_Last_Update_Login => fnd_global.login_id

Line 1235: , X_Last_Updated_By => fnd_global.user_id

1231: , X_Effective_From => null
1232: , X_Effective_To => null
1233: , X_Created_By => fnd_global.user_id
1234: , X_Creation_Date => sysdate
1235: , X_Last_Updated_By => fnd_global.user_id
1236: , X_Last_Update_Date => sysdate
1237: , X_Last_Update_Login => fnd_global.login_id
1238: , X_Attribute1 => null
1239: , X_Attribute2 => null

Line 1237: , X_Last_Update_Login => fnd_global.login_id

1233: , X_Created_By => fnd_global.user_id
1234: , X_Creation_Date => sysdate
1235: , X_Last_Updated_By => fnd_global.user_id
1236: , X_Last_Update_Date => sysdate
1237: , X_Last_Update_Login => fnd_global.login_id
1238: , X_Attribute1 => null
1239: , X_Attribute2 => null
1240: , X_Attribute3 => null
1241: , X_Attribute4 => null

Line 1300: X_Last_Updated_By => fnd_global.user_id,

1296: X_Name => p_mtl_picking_rule_rec.name,
1297: X_Description => p_mtl_picking_rule_rec.name,
1298: X_Enabled_Flag => p_mtl_picking_rule_rec.enabled_flag,
1299: X_User_Defined_Flag => 'Y',
1300: X_Last_Updated_By => fnd_global.user_id,
1301: X_Last_Update_Date => sysdate,
1302: X_Last_Update_Login => fnd_global.user_id,
1303: X_Attribute1 => null,
1304: X_Attribute2 => null,

Line 1302: X_Last_Update_Login => fnd_global.user_id,

1298: X_Enabled_Flag => p_mtl_picking_rule_rec.enabled_flag,
1299: X_User_Defined_Flag => 'Y',
1300: X_Last_Updated_By => fnd_global.user_id,
1301: X_Last_Update_Date => sysdate,
1302: X_Last_Update_Login => fnd_global.user_id,
1303: X_Attribute1 => null,
1304: X_Attribute2 => null,
1305: X_Attribute3 => null,
1306: X_Attribute4 => null,