DBA Data[Home] [Help]

APPS.FLM_KANBAN_CONSOLIDATION dependencies on FND_GLOBAL

Line 128: FND_GLOBAL.USER_ID,

124: )
125: Values
126: (
127: sysdate,
128: FND_GLOBAL.USER_ID,
129: sysdate,
130: FND_GLOBAL.USER_ID,
131: p_buyer_Id,
132: p_interface_Source_Code,

Line 130: FND_GLOBAL.USER_ID,

126: (
127: sysdate,
128: FND_GLOBAL.USER_ID,
129: sysdate,
130: FND_GLOBAL.USER_ID,
131: p_buyer_Id,
132: p_interface_Source_Code,
133: p_requisition_type,
134: p_approval,

Line 169: l_Kanban_Card_Rec_Tbl(l_order_count).Last_Updated_By := FND_GLOBAL.USER_ID;

165: l_Kanban_Card_Rec_Tbl(l_order_count).Supply_Status := INV_Kanban_PVT.G_Supply_Status_Empty;
166: l_Kanban_Card_Rec_Tbl(l_order_count).Current_Replnsh_Cycle_Id := l_Current_Replenish_Cycle_Id;
167: l_Kanban_Card_Rec_Tbl(l_order_count).replenishment_count := nvl(l_Kanban_Card_Rec_Tbl(l_order_count).replenishment_count,0)+1;
168: l_Kanban_Card_Rec_Tbl(l_order_count).Last_Update_Date := SYSDATE;
169: l_Kanban_Card_Rec_Tbl(l_order_count).Last_Updated_By := FND_GLOBAL.USER_ID;
170: fnd_file.put_line(fnd_file.log,'after card upd');
171: Update Mtl_Kanban_Cards
172: Set Supply_Status = INV_Kanban_PVT.G_Supply_Status_Empty,
173: Current_Replnsh_Cycle_Id = l_Current_Replenish_Cycle_Id,

Line 176: Last_Updated_By = FND_GLOBAL.USER_ID

172: Set Supply_Status = INV_Kanban_PVT.G_Supply_Status_Empty,
173: Current_Replnsh_Cycle_Id = l_Current_Replenish_Cycle_Id,
174: replenishment_count = nvl(replenishment_count,0)+1,
175: Last_Update_Date = SYSDATE,
176: Last_Updated_By = FND_GLOBAL.USER_ID
177: Where Kanban_Card_Id = l_Kanban_Card_Rec_Tbl(l_order_count).Kanban_card_Id;
178:
179: INV_KanbanCard_PKG.Insert_Activity_For_Card(l_Kanban_Card_Rec_Tbl(l_order_count));
180: fnd_file.put_line(fnd_file.log,'after card activity');

Line 226: l_trohdr_rec.created_by := FND_GLOBAL.USER_ID;

222: begin
223: fnd_file.put_line(fnd_file.log,'Create_Transfer_Order');
224: l_Kanban_Card_Rec_Tbl := p_kanban_card_rec_tbl;
225: l_Current_Replenish_Cycle_Id := Get_Next_Replenish_Cycle_Id;
226: l_trohdr_rec.created_by := FND_GLOBAL.USER_ID;
227: l_trohdr_rec.creation_date := sysdate;
228: l_trohdr_rec.date_required := p_need_by_date;
229: l_trohdr_rec.from_subinventory_code := l_Kanban_Card_Rec_Tbl(1).source_subinventory;
230: -- l_trohdr_rec.header_id := l_header_id;

Line 232: l_trohdr_rec.last_updated_by := FND_GLOBAL.USER_ID;

228: l_trohdr_rec.date_required := p_need_by_date;
229: l_trohdr_rec.from_subinventory_code := l_Kanban_Card_Rec_Tbl(1).source_subinventory;
230: -- l_trohdr_rec.header_id := l_header_id;
231: l_trohdr_rec.header_status := INV_Globals.G_TO_STATUS_PREAPPROVED;
232: l_trohdr_rec.last_updated_by := FND_GLOBAL.USER_ID;
233: l_trohdr_rec.last_update_date := sysdate;
234: l_trohdr_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
235: l_trohdr_rec.organization_id := l_Kanban_Card_Rec_Tbl(1).organization_id;
236: -- l_trohdr_rec.request_number := to_char(l_header_id);

Line 234: l_trohdr_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

230: -- l_trohdr_rec.header_id := l_header_id;
231: l_trohdr_rec.header_status := INV_Globals.G_TO_STATUS_PREAPPROVED;
232: l_trohdr_rec.last_updated_by := FND_GLOBAL.USER_ID;
233: l_trohdr_rec.last_update_date := sysdate;
234: l_trohdr_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
235: l_trohdr_rec.organization_id := l_Kanban_Card_Rec_Tbl(1).organization_id;
236: -- l_trohdr_rec.request_number := to_char(l_header_id);
237: l_trohdr_rec.status_date := sysdate;
238: l_trohdr_rec.to_subinventory_code := l_Kanban_Card_Rec_Tbl(1).subinventory_name;

Line 290: l_trolin_tbl(l_order_count).created_by := FND_GLOBAL.USER_ID;

286: end if;
287: end if;
288:
289: l_line_num := l_line_num + 1;
290: l_trolin_tbl(l_order_count).created_by := FND_GLOBAL.USER_ID;
291: l_trolin_tbl(l_order_count).creation_date := sysdate;
292: l_trolin_tbl(l_order_count).date_required := p_need_by_date;
293: l_trolin_tbl(l_order_count).from_locator_id := l_Kanban_Card_Rec_Tbl(l_order_count).source_locator_id;
294: l_trolin_tbl(l_order_count).from_subinventory_code := l_Kanban_Card_Rec_Tbl(l_order_count).source_subinventory;

Line 296: l_trolin_tbl(l_order_count).last_updated_by := FND_GLOBAL.USER_ID;

292: l_trolin_tbl(l_order_count).date_required := p_need_by_date;
293: l_trolin_tbl(l_order_count).from_locator_id := l_Kanban_Card_Rec_Tbl(l_order_count).source_locator_id;
294: l_trolin_tbl(l_order_count).from_subinventory_code := l_Kanban_Card_Rec_Tbl(l_order_count).source_subinventory;
295: l_trolin_tbl(l_order_count).inventory_item_id := l_Kanban_Card_Rec_Tbl(l_order_count).inventory_item_id;
296: l_trolin_tbl(l_order_count).last_updated_by := FND_GLOBAL.USER_ID;
297: l_trolin_tbl(l_order_count).last_update_date := sysdate;
298: l_trolin_tbl(l_order_count).last_update_login := FND_GLOBAL.LOGIN_ID;
299: l_trolin_tbl(l_order_count).line_id := FND_API.G_MISS_NUM;
300: l_trolin_tbl(l_order_count).line_number := l_line_num;

Line 298: l_trolin_tbl(l_order_count).last_update_login := FND_GLOBAL.LOGIN_ID;

294: l_trolin_tbl(l_order_count).from_subinventory_code := l_Kanban_Card_Rec_Tbl(l_order_count).source_subinventory;
295: l_trolin_tbl(l_order_count).inventory_item_id := l_Kanban_Card_Rec_Tbl(l_order_count).inventory_item_id;
296: l_trolin_tbl(l_order_count).last_updated_by := FND_GLOBAL.USER_ID;
297: l_trolin_tbl(l_order_count).last_update_date := sysdate;
298: l_trolin_tbl(l_order_count).last_update_login := FND_GLOBAL.LOGIN_ID;
299: l_trolin_tbl(l_order_count).line_id := FND_API.G_MISS_NUM;
300: l_trolin_tbl(l_order_count).line_number := l_line_num;
301: l_trolin_tbl(l_order_count).line_status := INV_Globals.G_TO_STATUS_PREAPPROVED;
302: l_trolin_tbl(l_order_count).organization_id := l_Kanban_Card_Rec_Tbl(l_order_count).organization_id;

Line 389: l_Kanban_Card_Rec_Tbl(l_order_count).Last_Updated_By := FND_GLOBAL.USER_ID;

385: l_Kanban_Card_Rec_Tbl(l_order_count).Supply_Status := INV_Kanban_PVT.G_Supply_Status_InProcess;
386: l_Kanban_Card_Rec_Tbl(l_order_count).Current_Replnsh_Cycle_Id := l_Current_Replenish_Cycle_Id;
387: l_Kanban_Card_Rec_Tbl(l_order_count).replenishment_count := nvl(l_Kanban_Card_Rec_Tbl(l_order_count).replenishment_count,0)+1;
388: l_Kanban_Card_Rec_Tbl(l_order_count).Last_Update_Date := SYSDATE;
389: l_Kanban_Card_Rec_Tbl(l_order_count).Last_Updated_By := FND_GLOBAL.USER_ID;
390:
391: Update Mtl_Kanban_Cards
392: Set Supply_Status = INV_Kanban_PVT.G_Supply_Status_InProcess,
393: Current_Replnsh_Cycle_Id = l_Current_Replenish_Cycle_Id,

Line 396: Last_Updated_By = FND_GLOBAL.USER_ID

392: Set Supply_Status = INV_Kanban_PVT.G_Supply_Status_InProcess,
393: Current_Replnsh_Cycle_Id = l_Current_Replenish_Cycle_Id,
394: replenishment_count = nvl(replenishment_count,0)+1,
395: Last_Update_Date = SYSDATE,
396: Last_Updated_By = FND_GLOBAL.USER_ID
397: Where Kanban_Card_Id = l_Kanban_Card_Rec_Tbl(l_order_count).Kanban_card_Id;
398:
399: INV_KanbanCard_PKG.Insert_Activity_For_Card(l_Kanban_Card_Rec_Tbl(l_order_count));
400:

Line 601: where user_id = FND_GLOBAL.USER_ID;

597:
598: select employee_id
599: into l_buyer_id
600: from fnd_user
601: where user_id = FND_GLOBAL.USER_ID;
602:
603: If l_kanban_card_Rec_Tbl(1).source_type = INV_Kanban_PVT.G_Source_Type_InterOrg then
604: l_source_type_code := 'INVENTORY';
605: l_Requisition_type := 'INTERNAL';

Line 656: FND_MESSAGE.SET_TOKEN('USERID',to_char(FND_GLOBAL.USER_ID));

652: elsif l_sql_stmt_no = 50 then
653: FND_MESSAGE.SET_NAME('INV','INV_INT_REVCODE');
654: elsif l_sql_stmt_no = 60 then
655: FND_MESSAGE.SET_NAME('FND','CONC-FDWHOAMI INVALID USERID');
656: FND_MESSAGE.SET_TOKEN('USERID',to_char(FND_GLOBAL.USER_ID));
657: end if;
658: FND_MSG_PUB.Add;
659: fnd_file.put_line(fnd_file.log,'Error in Create_Replenishment'||'( stmt_num: '||l_sql_stmt_no||') '||fnd_message.get);
660: fnd_file.put_line(fnd_file.log,'Error in Create_Replenishment'||'( stmt_num: '||l_sql_stmt_no||') '||sqlerrm(sqlcode));