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 722: l_trohdr_rec.created_by := fnd_global.user_id;

718: IF (p_transaction_type_id <> fnd_api.g_miss_num) THEN
719: l_txn_type_id := p_transaction_type_id;
720: END IF;
721:
722: l_trohdr_rec.created_by := fnd_global.user_id;
723: l_trohdr_rec.creation_date := SYSDATE;
724: l_trohdr_rec.date_required := SYSDATE;
725: l_trohdr_rec.from_subinventory_code := p_sub;
726: l_trohdr_rec.header_status := inv_globals.g_to_status_preapproved;

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

723: l_trohdr_rec.creation_date := SYSDATE;
724: l_trohdr_rec.date_required := SYSDATE;
725: l_trohdr_rec.from_subinventory_code := p_sub;
726: l_trohdr_rec.header_status := inv_globals.g_to_status_preapproved;
727: l_trohdr_rec.last_updated_by := fnd_global.user_id;
728: l_trohdr_rec.last_update_date := SYSDATE;
729: l_trohdr_rec.last_update_login := fnd_global.user_id;
730: l_trohdr_rec.organization_id := l_org_id;
731: l_trohdr_rec.status_date := SYSDATE;

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

725: l_trohdr_rec.from_subinventory_code := p_sub;
726: l_trohdr_rec.header_status := inv_globals.g_to_status_preapproved;
727: l_trohdr_rec.last_updated_by := fnd_global.user_id;
728: l_trohdr_rec.last_update_date := SYSDATE;
729: l_trohdr_rec.last_update_login := fnd_global.user_id;
730: l_trohdr_rec.organization_id := l_org_id;
731: l_trohdr_rec.status_date := SYSDATE;
732: l_trohdr_rec.to_subinventory_code := NULL;
733: l_trohdr_rec.move_order_type := inv_globals.g_move_order_put_away;

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

734: l_trohdr_rec.db_flag := fnd_api.g_true;
735: l_trohdr_rec.operation := inv_globals.g_opr_create;
736: l_line_num := l_line_num + 1;
737: l_trolin_tbl(l_order_count).header_id := l_trohdr_rec.header_id;
738: l_trolin_tbl(l_order_count).created_by := fnd_global.user_id;
739: l_trolin_tbl(l_order_count).creation_date := SYSDATE;
740: l_trolin_tbl(l_order_count).date_required := SYSDATE;
741: l_trolin_tbl(l_order_count).from_subinventory_code := p_sub;
742: l_trolin_tbl(l_order_count).from_locator_id := p_loc;

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

740: l_trolin_tbl(l_order_count).date_required := SYSDATE;
741: l_trolin_tbl(l_order_count).from_subinventory_code := p_sub;
742: l_trolin_tbl(l_order_count).from_locator_id := p_loc;
743: l_trolin_tbl(l_order_count).inventory_item_id := l_inventory_item_id;
744: l_trolin_tbl(l_order_count).last_updated_by := fnd_global.user_id;
745: l_trolin_tbl(l_order_count).last_update_date := SYSDATE;
746: l_trolin_tbl(l_order_count).last_updated_by := fnd_global.user_id;
747: l_trolin_tbl(l_order_count).last_update_date := SYSDATE;
748: l_trolin_tbl(l_order_count).last_update_login := fnd_global.login_id;

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

742: l_trolin_tbl(l_order_count).from_locator_id := p_loc;
743: l_trolin_tbl(l_order_count).inventory_item_id := l_inventory_item_id;
744: l_trolin_tbl(l_order_count).last_updated_by := fnd_global.user_id;
745: l_trolin_tbl(l_order_count).last_update_date := SYSDATE;
746: l_trolin_tbl(l_order_count).last_updated_by := fnd_global.user_id;
747: l_trolin_tbl(l_order_count).last_update_date := SYSDATE;
748: l_trolin_tbl(l_order_count).last_update_login := fnd_global.login_id;
749: l_trolin_tbl(l_order_count).line_id := fnd_api.g_miss_num;
750: l_trolin_tbl(l_order_count).line_number := l_line_num;

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

744: l_trolin_tbl(l_order_count).last_updated_by := fnd_global.user_id;
745: l_trolin_tbl(l_order_count).last_update_date := SYSDATE;
746: l_trolin_tbl(l_order_count).last_updated_by := fnd_global.user_id;
747: l_trolin_tbl(l_order_count).last_update_date := SYSDATE;
748: l_trolin_tbl(l_order_count).last_update_login := fnd_global.login_id;
749: l_trolin_tbl(l_order_count).line_id := fnd_api.g_miss_num;
750: l_trolin_tbl(l_order_count).line_number := l_line_num;
751: l_trolin_tbl(l_order_count).line_status := inv_globals.g_to_status_preapproved;
752: l_trolin_tbl(l_order_count).organization_id := l_org_id;

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

816: END IF;
817: ELSIF(l_msg_count = 1) THEN
818: IF (l_debug = 1) THEN
819: mydebug('create_mo: Not Successful');
820: mydebug('create_mo: ' || REPLACE(l_msg_data, fnd_global.local_chr(0), ' '));
821: END IF;
822: ELSE
823: IF (l_debug = 1) THEN
824: mydebug('create_mo: Not Successful2');

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

827: FOR i IN 1 .. l_msg_count LOOP
828: l_msg_data := fnd_msg_pub.get(i, 'F');
829:
830: IF (l_debug = 1) THEN
831: mydebug('create_mo: ' || REPLACE(l_msg_data, fnd_global.local_chr(0), ' '));
832: END IF;
833: END LOOP;
834: END IF;
835:

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

1627: END IF;
1628: ELSIF(l_msg_count = 1) THEN
1629: IF (l_debug = 1) THEN
1630: mydebug('suggestions_pub: Not Successful');
1631: mydebug('suggestions_pub: ' || REPLACE(l_msg_data, fnd_global.local_chr(0), ' '));
1632: END IF;
1633: ELSE
1634: IF (l_debug = 1) THEN
1635: mydebug('suggestions_pub: Not Successful2');

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

1638: FOR i IN 1 .. l_msg_count LOOP
1639: l_msg_data := fnd_msg_pub.get(i, 'F');
1640:
1641: IF (l_debug = 1) THEN
1642: mydebug('suggestions_pub: ' || REPLACE(l_msg_data, fnd_global.local_chr(0), ' '));
1643: END IF;
1644: END LOOP;
1645: END IF;
1646:

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

2081: END IF;
2082: ELSIF(l_msg_count = 1) THEN
2083: IF (l_debug = 1) THEN
2084: mydebug('suggestions_pub: Not Successful');
2085: mydebug('suggestions_pub: ' || REPLACE(l_msg_data, fnd_global.local_chr(0), ' '));
2086: END IF;
2087: ELSE
2088: IF (l_debug = 1) THEN
2089: mydebug('suggestions_pub: Not Successful2');

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

2092: FOR i IN 1 .. l_msg_count LOOP
2093: l_msg_data := fnd_msg_pub.get(i, 'F');
2094:
2095: IF (l_debug = 1) THEN
2096: mydebug('suggestions_pub: ' || REPLACE(l_msg_data, fnd_global.local_chr(0), ' '));
2097: END IF;
2098: END LOOP;
2099: END IF;
2100:

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

4126: END IF;
4127: ELSIF(x_msg_count = 1) THEN
4128: IF (l_debug = 1) THEN
4129: mydebug('complete_putaway: Not Successful');
4130: mydebug('complete_putaway: ' || REPLACE(x_msg_data, fnd_global.local_chr(0), ' '));
4131: END IF;
4132: ELSE
4133: IF (l_debug = 1) THEN
4134: mydebug('complete_putaway: Not Successful2');

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

4137: FOR i IN 1 .. x_msg_count LOOP
4138: x_msg_data := fnd_msg_pub.get(i, 'F');
4139:
4140: IF (l_debug = 1) THEN
4141: mydebug('complete_putaway: ' || REPLACE(x_msg_data, fnd_global.local_chr(0), ' '));
4142: END IF;
4143: END LOOP;
4144: END IF;
4145:

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

7885: END IF;
7886: ELSIF(l_msg_count = 1) THEN
7887: IF (l_debug = 1) THEN
7888: mydebug('create_mo_lpn: Not Successful');
7889: mydebug('create_mo_lpn: ' || REPLACE(l_msg_data, fnd_global.local_chr(0), ' '));
7890: END IF;
7891: ELSE
7892: IF (l_debug = 1) THEN
7893: mydebug('create_mo_lpn: Not Successful2');

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

7896: FOR i IN 1 .. l_msg_count LOOP
7897: l_msg_data := fnd_msg_pub.get(i, 'F');
7898:
7899: IF (l_debug = 1) THEN
7900: mydebug('create_mo_lpn: ' || REPLACE(l_msg_data, fnd_global.local_chr(0), ' '));
7901: END IF;
7902: END LOOP;
7903: END IF;
7904:

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

9510: END IF;
9511: ELSIF(x_msg_count = 1) THEN
9512: IF (l_debug = 1) THEN
9513: mydebug('Not Successful');
9514: mydebug('Error message: ' || REPLACE(x_msg_data, fnd_global.local_chr(0), ' '));
9515: END IF;
9516: ELSE
9517: IF (l_debug = 1) THEN
9518: mydebug('Not Successful2');

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

9521: FOR i IN 1 .. x_msg_count LOOP
9522: x_msg_data := fnd_msg_pub.get(i, 'F');
9523:
9524: IF (l_debug = 1) THEN
9525: mydebug('Error messages: ' || REPLACE(x_msg_data, fnd_global.local_chr(0), ' '));
9526: END IF;
9527: END LOOP;
9528: END IF;
9529: