DBA Data[Home] [Help]

APPS.WMS_TASK_DISPATCH_GEN dependencies on FND_GLOBAL

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

1819: END IF;
1820: ELSIF(l_msg_cnt = 1) THEN
1821: IF (l_debug = 1) THEN
1822: mydebug('complete_pick: Not Successful');
1823: mydebug(REPLACE(l_msg_data, fnd_global.local_chr(0), ' '));
1824: END IF;
1825: ELSE
1826: IF (l_debug = 1) THEN
1827: mydebug('complete_pick: Not Successful2');

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

1830: FOR i IN 1 .. l_msg_cnt LOOP
1831: l_msg_data := fnd_msg_pub.get(i, 'F');
1832:
1833: IF (l_debug = 1) THEN
1834: mydebug(REPLACE(l_msg_data, fnd_global.local_chr(0), ' '));
1835: END IF;
1836: END LOOP;
1837: END IF;
1838:

Line 5034: , last_updated_by = fnd_global.user_id

5030: -- Bug5659809: update last_update_date and last_update_by as well
5031: UPDATE wms_license_plate_numbers
5032: SET lpn_context = wms_container_pub.lpn_context_packing
5033: , last_update_date = SYSDATE
5034: , last_updated_by = fnd_global.user_id
5035: WHERE lpn_id = p_lpn;
5036: END IF;
5037: -- end 2769358
5038:

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

5262: END IF;
5263: ELSIF(l_msg_cnt = 1) THEN
5264: IF (l_debug = 1) THEN
5265: mydebug('load_pick: Not Successful');
5266: mydebug(REPLACE(l_msg_data, fnd_global.local_chr(0), ' '));
5267: END IF;
5268: ELSE
5269: IF (l_debug = 1) THEN
5270: mydebug('load_pick: Not Successful2');

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

5273: FOR i IN 1 .. l_msg_cnt LOOP
5274: l_msg_data := fnd_msg_pub.get(i, 'F');
5275:
5276: IF (l_debug = 1) THEN
5277: mydebug(REPLACE(l_msg_data, fnd_global.local_chr(0), ' '));
5278: END IF;
5279: END LOOP;
5280: END IF;
5281:

Line 5351: , last_updated_by = fnd_global.user_id

5347: -- Bug5659809: update last_update_date and last_update_by as well
5348: UPDATE wms_license_plate_numbers
5349: SET lpn_context = wms_container_pub.lpn_context_packing
5350: , last_update_date = SYSDATE
5351: , last_updated_by = fnd_global.user_id
5352: WHERE lpn_id = l_to_lpn_id;
5353: -- END IF;
5354:
5355: IF p_is_lot_control = 'true'

Line 5439: , last_updated_by = fnd_global.user_id

5435: -- Bug5659809: update last_update_date and last_update_by as well
5436: UPDATE wms_license_plate_numbers
5437: SET lpn_context = wms_container_pub.lpn_context_packing
5438: , last_update_date = SYSDATE
5439: , last_updated_by = fnd_global.user_id
5440: WHERE lpn_id = l_content_lpn_id;
5441: END IF;
5442:
5443: -- end bug fix 2769358

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

6189: END IF;
6190: ELSIF(l_msg_cnt = 1) THEN
6191: IF (l_debug = 1) THEN
6192: mydebug('insert_mmtt_pack: Not Successful');
6193: mydebug(REPLACE(l_msg_data, fnd_global.local_chr(0), ' '));
6194: END IF;
6195: ELSE
6196: IF (l_debug = 1) THEN
6197: mydebug('insert_mmtt_pack: Not Successful2');

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

6200: FOR i IN 1 .. l_msg_cnt LOOP
6201: l_msg_data := fnd_msg_pub.get(i, 'F');
6202:
6203: IF (l_debug = 1) THEN
6204: mydebug(REPLACE(l_msg_data, fnd_global.local_chr(0), ' '));
6205: END IF;
6206: END LOOP;
6207: END IF;
6208:

Line 8139: , last_updated_by = fnd_global.user_id

8135: -- Bug5659809: update last_update_date and last_update_by as well
8136: UPDATE wms_license_plate_numbers
8137: SET lpn_context = wms_container_pub.lpn_context_packing
8138: , last_update_date = SYSDATE
8139: , last_updated_by = fnd_global.user_id
8140: WHERE lpn_id = pick_to_lpn_rec.lpn_id;
8141:
8142: IF (l_debug = 1) THEN
8143: mydebug('validate_pick_to_lpn: Drop LPN is pre-generated, no checking required.');

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

9192: END IF;
9193: ELSIF(l_msg_cnt = 1) THEN
9194: IF (l_debug = 1) THEN
9195: mydebug('multiple_pick: Not Successful');
9196: mydebug(REPLACE(l_msg_data, fnd_global.local_chr(0), ' '));
9197: END IF;
9198: ELSE
9199: IF (l_debug = 1) THEN
9200: mydebug('multiple_pick: Not Successful2');

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

9203: FOR i IN 1 .. l_msg_cnt LOOP
9204: l_msg_data := fnd_msg_pub.get(i, 'F');
9205:
9206: IF (l_debug = 1) THEN
9207: mydebug(REPLACE(l_msg_data, fnd_global.local_chr(0), ' '));
9208: END IF;
9209: END LOOP;
9210: END IF;
9211:

Line 10465: , last_updated_by = fnd_global.user_id

10461: -- Bug5659809: update last_update_date and last_update_by as well
10462: UPDATE wms_license_plate_numbers
10463: SET lpn_context = wms_container_pub.lpn_context_packing
10464: , last_update_date = SYSDATE
10465: , last_updated_by = fnd_global.user_id
10466: WHERE lpn_id = l_to_lpn_id;
10467: END IF;
10468:
10469: l_progress := '650';

Line 10560: mydebug(REPLACE(x_msg_data, fnd_global.local_chr(0), ' '));

10556: END IF;
10557: ELSIF(l_msg_count = 1) THEN
10558: IF (l_debug = 1) THEN
10559: mydebug('Not Successful');
10560: mydebug(REPLACE(x_msg_data, fnd_global.local_chr(0), ' '));
10561: END IF;
10562: ELSE
10563: IF (l_debug = 1) THEN
10564: mydebug('Not Successful2');

Line 10571: mydebug(REPLACE(x_msg_data, fnd_global.local_chr(0), ' '));

10567: FOR i IN 1 .. l_msg_count LOOP
10568: x_msg_data := fnd_msg_pub.get(i, 'F');
10569:
10570: IF (l_debug = 1) THEN
10571: mydebug(REPLACE(x_msg_data, fnd_global.local_chr(0), ' '));
10572: END IF;
10573: END LOOP;
10574: END IF;
10575:

Line 11208: , last_updated_by = fnd_global.user_id

11204: UPDATE wms_license_plate_numbers
11205: SET subinventory_code = l_transfer_sub
11206: , locator_id = l_transfer_loc
11207: , last_update_date = SYSDATE
11208: , last_updated_by = fnd_global.user_id
11209: WHERE lpn_id = l_content_lpn_id
11210: AND organization_id = l_org_id;
11211: END IF;
11212:

Line 13324: mydebug(REPLACE(x_msg_data, fnd_global.local_chr(0), ' '));

13320: END IF;
13321: ELSIF(l_msg_count = 1) THEN
13322: IF (l_debug = 1) THEN
13323: mydebug('check_pack_lpn: Not Successful');
13324: mydebug(REPLACE(x_msg_data, fnd_global.local_chr(0), ' '));
13325: END IF;
13326: ELSE
13327: IF (l_debug = 1) THEN
13328: mydebug('check_pack_lpn: Not Successful2');

Line 13335: mydebug(REPLACE(x_msg_data, fnd_global.local_chr(0), ' '));

13331: FOR i IN 1 .. l_msg_count LOOP
13332: x_msg_data := fnd_msg_pub.get(i, 'F');
13333:
13334: IF (l_debug = 1) THEN
13335: mydebug(REPLACE(x_msg_data, fnd_global.local_chr(0), ' '));
13336: END IF;
13337: END LOOP;
13338: END IF;
13339: