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 10491: , last_updated_by = fnd_global.user_id

10487: -- Bug5659809: update last_update_date and last_update_by as well
10488: UPDATE wms_license_plate_numbers
10489: SET lpn_context = wms_container_pub.lpn_context_packing
10490: , last_update_date = SYSDATE
10491: , last_updated_by = fnd_global.user_id
10492: WHERE lpn_id = l_to_lpn_id;
10493: END IF;
10494:
10495: l_progress := '650';

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

10582: END IF;
10583: ELSIF(l_msg_count = 1) THEN
10584: IF (l_debug = 1) THEN
10585: mydebug('Not Successful');
10586: mydebug(REPLACE(x_msg_data, fnd_global.local_chr(0), ' '));
10587: END IF;
10588: ELSE
10589: IF (l_debug = 1) THEN
10590: mydebug('Not Successful2');

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

10593: FOR i IN 1 .. l_msg_count LOOP
10594: x_msg_data := fnd_msg_pub.get(i, 'F');
10595:
10596: IF (l_debug = 1) THEN
10597: mydebug(REPLACE(x_msg_data, fnd_global.local_chr(0), ' '));
10598: END IF;
10599: END LOOP;
10600: END IF;
10601:

Line 11279: , last_updated_by = fnd_global.user_id

11275: UPDATE wms_license_plate_numbers
11276: SET subinventory_code = l_transfer_sub
11277: , locator_id = l_transfer_loc
11278: , last_update_date = SYSDATE
11279: , last_updated_by = fnd_global.user_id
11280: WHERE lpn_id = l_content_lpn_id
11281: AND organization_id = l_org_id;
11282: END IF;
11283:

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

13573: END IF;
13574: ELSIF(l_msg_count = 1) THEN
13575: IF (l_debug = 1) THEN
13576: mydebug('check_pack_lpn: Not Successful');
13577: mydebug(REPLACE(x_msg_data, fnd_global.local_chr(0), ' '));
13578: END IF;
13579: ELSE
13580: IF (l_debug = 1) THEN
13581: mydebug('check_pack_lpn: Not Successful2');

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

13584: FOR i IN 1 .. l_msg_count LOOP
13585: x_msg_data := fnd_msg_pub.get(i, 'F');
13586:
13587: IF (l_debug = 1) THEN
13588: mydebug(REPLACE(x_msg_data, fnd_global.local_chr(0), ' '));
13589: END IF;
13590: END LOOP;
13591: END IF;
13592: