DBA Data[Home] [Help]

APPS.WMS_TASK_DISPATCH_PUT_AWAY dependencies on FND_GLOBAL

Line 268: l_trolin_tbl(l_order_count).created_by := fnd_global.user_id;

264:
265: --Increment by 1
266: l_line_num := l_line_num + 1;
267: l_trolin_tbl(l_order_count).header_id := p_header_id;
268: l_trolin_tbl(l_order_count).created_by := fnd_global.user_id;
269: l_trolin_tbl(l_order_count).creation_date := SYSDATE;
270: l_trolin_tbl(l_order_count).date_required := SYSDATE;
271: l_trolin_tbl(l_order_count).from_subinventory_code := NULL;
272: l_trolin_tbl(l_order_count).inventory_item_id := p_inventory_item_id;

Line 273: l_trolin_tbl(l_order_count).last_updated_by := fnd_global.user_id;

269: l_trolin_tbl(l_order_count).creation_date := SYSDATE;
270: l_trolin_tbl(l_order_count).date_required := SYSDATE;
271: l_trolin_tbl(l_order_count).from_subinventory_code := NULL;
272: l_trolin_tbl(l_order_count).inventory_item_id := p_inventory_item_id;
273: l_trolin_tbl(l_order_count).last_updated_by := fnd_global.user_id;
274: l_trolin_tbl(l_order_count).last_update_date := SYSDATE;
275: l_trolin_tbl(l_order_count).last_update_login := fnd_global.login_id;
276: l_trolin_tbl(l_order_count).line_id := fnd_api.g_miss_num;
277: l_trolin_tbl(l_order_count).line_number := l_line_num;

Line 275: l_trolin_tbl(l_order_count).last_update_login := fnd_global.login_id;

271: l_trolin_tbl(l_order_count).from_subinventory_code := NULL;
272: l_trolin_tbl(l_order_count).inventory_item_id := p_inventory_item_id;
273: l_trolin_tbl(l_order_count).last_updated_by := fnd_global.user_id;
274: l_trolin_tbl(l_order_count).last_update_date := SYSDATE;
275: l_trolin_tbl(l_order_count).last_update_login := fnd_global.login_id;
276: l_trolin_tbl(l_order_count).line_id := fnd_api.g_miss_num;
277: l_trolin_tbl(l_order_count).line_number := l_line_num;
278: l_trolin_tbl(l_order_count).line_status := inv_globals.g_to_status_preapproved;
279: l_trolin_tbl(l_order_count).organization_id := p_org_id;

Line 397: mydebug(REPLACE(l_msg_data, fnd_global.local_chr(0), ' '));

393: END IF;
394: ELSIF(l_msg_count = 1) THEN
395: IF (l_debug = 1) THEN
396: mydebug('create_mo_line: Not Successful');
397: mydebug(REPLACE(l_msg_data, fnd_global.local_chr(0), ' '));
398: END IF;
399: ELSE
400: IF (l_debug = 1) THEN
401: mydebug('create_mo_line: Not Successful2');

Line 408: mydebug('create_mo_line: ' || REPLACE(l_msg_data, fnd_global.local_chr(0), ' '));

404: FOR i IN 1 .. l_msg_count LOOP
405: l_msg_data := fnd_msg_pub.get(i, 'F');
406:
407: IF (l_debug = 1) THEN
408: mydebug('create_mo_line: ' || REPLACE(l_msg_data, fnd_global.local_chr(0), ' '));
409: END IF;
410: END LOOP;
411: END IF;
412:

Line 598: l_trohdr_rec.created_by := fnd_global.user_id;

594: IF (p_transaction_type_id <> fnd_api.g_miss_num) THEN
595: l_txn_type_id := p_transaction_type_id;
596: END IF;
597:
598: l_trohdr_rec.created_by := fnd_global.user_id;
599: l_trohdr_rec.creation_date := SYSDATE;
600: l_trohdr_rec.date_required := SYSDATE;
601: l_trohdr_rec.from_subinventory_code := p_sub;
602: l_trohdr_rec.header_status := inv_globals.g_to_status_preapproved;

Line 603: l_trohdr_rec.last_updated_by := fnd_global.user_id;

599: l_trohdr_rec.creation_date := SYSDATE;
600: l_trohdr_rec.date_required := SYSDATE;
601: l_trohdr_rec.from_subinventory_code := p_sub;
602: l_trohdr_rec.header_status := inv_globals.g_to_status_preapproved;
603: l_trohdr_rec.last_updated_by := fnd_global.user_id;
604: l_trohdr_rec.last_update_date := SYSDATE;
605: l_trohdr_rec.last_update_login := fnd_global.user_id;
606: l_trohdr_rec.organization_id := l_org_id;
607: l_trohdr_rec.status_date := SYSDATE;

Line 605: l_trohdr_rec.last_update_login := fnd_global.user_id;

601: l_trohdr_rec.from_subinventory_code := p_sub;
602: l_trohdr_rec.header_status := inv_globals.g_to_status_preapproved;
603: l_trohdr_rec.last_updated_by := fnd_global.user_id;
604: l_trohdr_rec.last_update_date := SYSDATE;
605: l_trohdr_rec.last_update_login := fnd_global.user_id;
606: l_trohdr_rec.organization_id := l_org_id;
607: l_trohdr_rec.status_date := SYSDATE;
608: l_trohdr_rec.to_subinventory_code := NULL;
609: l_trohdr_rec.move_order_type := inv_globals.g_move_order_put_away;

Line 614: l_trolin_tbl(l_order_count).created_by := fnd_global.user_id;

610: l_trohdr_rec.db_flag := fnd_api.g_true;
611: l_trohdr_rec.operation := inv_globals.g_opr_create;
612: l_line_num := l_line_num + 1;
613: l_trolin_tbl(l_order_count).header_id := l_trohdr_rec.header_id;
614: l_trolin_tbl(l_order_count).created_by := fnd_global.user_id;
615: l_trolin_tbl(l_order_count).creation_date := SYSDATE;
616: l_trolin_tbl(l_order_count).date_required := SYSDATE;
617: l_trolin_tbl(l_order_count).from_subinventory_code := p_sub;
618: l_trolin_tbl(l_order_count).from_locator_id := p_loc;

Line 620: l_trolin_tbl(l_order_count).last_updated_by := fnd_global.user_id;

616: l_trolin_tbl(l_order_count).date_required := SYSDATE;
617: l_trolin_tbl(l_order_count).from_subinventory_code := p_sub;
618: l_trolin_tbl(l_order_count).from_locator_id := p_loc;
619: l_trolin_tbl(l_order_count).inventory_item_id := l_inventory_item_id;
620: l_trolin_tbl(l_order_count).last_updated_by := fnd_global.user_id;
621: l_trolin_tbl(l_order_count).last_update_date := SYSDATE;
622: l_trolin_tbl(l_order_count).last_updated_by := fnd_global.user_id;
623: l_trolin_tbl(l_order_count).last_update_date := SYSDATE;
624: l_trolin_tbl(l_order_count).last_update_login := fnd_global.login_id;

Line 622: l_trolin_tbl(l_order_count).last_updated_by := fnd_global.user_id;

618: l_trolin_tbl(l_order_count).from_locator_id := p_loc;
619: l_trolin_tbl(l_order_count).inventory_item_id := l_inventory_item_id;
620: l_trolin_tbl(l_order_count).last_updated_by := fnd_global.user_id;
621: l_trolin_tbl(l_order_count).last_update_date := SYSDATE;
622: l_trolin_tbl(l_order_count).last_updated_by := fnd_global.user_id;
623: l_trolin_tbl(l_order_count).last_update_date := SYSDATE;
624: l_trolin_tbl(l_order_count).last_update_login := fnd_global.login_id;
625: l_trolin_tbl(l_order_count).line_id := fnd_api.g_miss_num;
626: l_trolin_tbl(l_order_count).line_number := l_line_num;

Line 624: l_trolin_tbl(l_order_count).last_update_login := fnd_global.login_id;

620: l_trolin_tbl(l_order_count).last_updated_by := fnd_global.user_id;
621: l_trolin_tbl(l_order_count).last_update_date := SYSDATE;
622: l_trolin_tbl(l_order_count).last_updated_by := fnd_global.user_id;
623: l_trolin_tbl(l_order_count).last_update_date := SYSDATE;
624: l_trolin_tbl(l_order_count).last_update_login := fnd_global.login_id;
625: l_trolin_tbl(l_order_count).line_id := fnd_api.g_miss_num;
626: l_trolin_tbl(l_order_count).line_number := l_line_num;
627: l_trolin_tbl(l_order_count).line_status := inv_globals.g_to_status_preapproved;
628: l_trolin_tbl(l_order_count).organization_id := l_org_id;

Line 696: mydebug('create_mo: ' || REPLACE(l_msg_data, fnd_global.local_chr(0), ' '));

692: END IF;
693: ELSIF(l_msg_count = 1) THEN
694: IF (l_debug = 1) THEN
695: mydebug('create_mo: Not Successful');
696: mydebug('create_mo: ' || REPLACE(l_msg_data, fnd_global.local_chr(0), ' '));
697: END IF;
698: ELSE
699: IF (l_debug = 1) THEN
700: mydebug('create_mo: Not Successful2');

Line 707: mydebug('create_mo: ' || REPLACE(l_msg_data, fnd_global.local_chr(0), ' '));

703: FOR i IN 1 .. l_msg_count LOOP
704: l_msg_data := fnd_msg_pub.get(i, 'F');
705:
706: IF (l_debug = 1) THEN
707: mydebug('create_mo: ' || REPLACE(l_msg_data, fnd_global.local_chr(0), ' '));
708: END IF;
709: END LOOP;
710: END IF;
711:

Line 1486: mydebug('suggestions_pub: ' || REPLACE(l_msg_data, fnd_global.local_chr(0), ' '));

1482: END IF;
1483: ELSIF(l_msg_count = 1) THEN
1484: IF (l_debug = 1) THEN
1485: mydebug('suggestions_pub: Not Successful');
1486: mydebug('suggestions_pub: ' || REPLACE(l_msg_data, fnd_global.local_chr(0), ' '));
1487: END IF;
1488: ELSE
1489: IF (l_debug = 1) THEN
1490: mydebug('suggestions_pub: Not Successful2');

Line 1497: mydebug('suggestions_pub: ' || REPLACE(l_msg_data, fnd_global.local_chr(0), ' '));

1493: FOR i IN 1 .. l_msg_count LOOP
1494: l_msg_data := fnd_msg_pub.get(i, 'F');
1495:
1496: IF (l_debug = 1) THEN
1497: mydebug('suggestions_pub: ' || REPLACE(l_msg_data, fnd_global.local_chr(0), ' '));
1498: END IF;
1499: END LOOP;
1500: END IF;
1501:

Line 1934: mydebug('suggestions_pub: ' || REPLACE(l_msg_data, fnd_global.local_chr(0), ' '));

1930: END IF;
1931: ELSIF(l_msg_count = 1) THEN
1932: IF (l_debug = 1) THEN
1933: mydebug('suggestions_pub: Not Successful');
1934: mydebug('suggestions_pub: ' || REPLACE(l_msg_data, fnd_global.local_chr(0), ' '));
1935: END IF;
1936: ELSE
1937: IF (l_debug = 1) THEN
1938: mydebug('suggestions_pub: Not Successful2');

Line 1945: mydebug('suggestions_pub: ' || REPLACE(l_msg_data, fnd_global.local_chr(0), ' '));

1941: FOR i IN 1 .. l_msg_count LOOP
1942: l_msg_data := fnd_msg_pub.get(i, 'F');
1943:
1944: IF (l_debug = 1) THEN
1945: mydebug('suggestions_pub: ' || REPLACE(l_msg_data, fnd_global.local_chr(0), ' '));
1946: END IF;
1947: END LOOP;
1948: END IF;
1949:

Line 3925: mydebug('complete_putaway: ' || REPLACE(x_msg_data, fnd_global.local_chr(0), ' '));

3921: END IF;
3922: ELSIF(x_msg_count = 1) THEN
3923: IF (l_debug = 1) THEN
3924: mydebug('complete_putaway: Not Successful');
3925: mydebug('complete_putaway: ' || REPLACE(x_msg_data, fnd_global.local_chr(0), ' '));
3926: END IF;
3927: ELSE
3928: IF (l_debug = 1) THEN
3929: mydebug('complete_putaway: Not Successful2');

Line 3936: mydebug('complete_putaway: ' || REPLACE(x_msg_data, fnd_global.local_chr(0), ' '));

3932: FOR i IN 1 .. x_msg_count LOOP
3933: x_msg_data := fnd_msg_pub.get(i, 'F');
3934:
3935: IF (l_debug = 1) THEN
3936: mydebug('complete_putaway: ' || REPLACE(x_msg_data, fnd_global.local_chr(0), ' '));
3937: END IF;
3938: END LOOP;
3939: END IF;
3940:

Line 7552: mydebug('create_mo_lpn: ' || REPLACE(l_msg_data, fnd_global.local_chr(0), ' '));

7548: END IF;
7549: ELSIF(l_msg_count = 1) THEN
7550: IF (l_debug = 1) THEN
7551: mydebug('create_mo_lpn: Not Successful');
7552: mydebug('create_mo_lpn: ' || REPLACE(l_msg_data, fnd_global.local_chr(0), ' '));
7553: END IF;
7554: ELSE
7555: IF (l_debug = 1) THEN
7556: mydebug('create_mo_lpn: Not Successful2');

Line 7563: mydebug('create_mo_lpn: ' || REPLACE(l_msg_data, fnd_global.local_chr(0), ' '));

7559: FOR i IN 1 .. l_msg_count LOOP
7560: l_msg_data := fnd_msg_pub.get(i, 'F');
7561:
7562: IF (l_debug = 1) THEN
7563: mydebug('create_mo_lpn: ' || REPLACE(l_msg_data, fnd_global.local_chr(0), ' '));
7564: END IF;
7565: END LOOP;
7566: END IF;
7567:

Line 9157: mydebug('Error message: ' || REPLACE(x_msg_data, fnd_global.local_chr(0), ' '));

9153: END IF;
9154: ELSIF(x_msg_count = 1) THEN
9155: IF (l_debug = 1) THEN
9156: mydebug('Not Successful');
9157: mydebug('Error message: ' || REPLACE(x_msg_data, fnd_global.local_chr(0), ' '));
9158: END IF;
9159: ELSE
9160: IF (l_debug = 1) THEN
9161: mydebug('Not Successful2');

Line 9168: mydebug('Error messages: ' || REPLACE(x_msg_data, fnd_global.local_chr(0), ' '));

9164: FOR i IN 1 .. x_msg_count LOOP
9165: x_msg_data := fnd_msg_pub.get(i, 'F');
9166:
9167: IF (l_debug = 1) THEN
9168: mydebug('Error messages: ' || REPLACE(x_msg_data, fnd_global.local_chr(0), ' '));
9169: END IF;
9170: END LOOP;
9171: END IF;
9172: