eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_CARTNZN_PUB dependencies on FND_API

Line 718: RAISE fnd_api.g_exc_unexpected_error;

714: IF( p_move_order_header_id IS NULL AND
715: p_transaction_header_id IS NULL ) THEN
716:
717: if (g_trace_on = 1) then log_event('Error- mo hdr id and txn hdr id are null'); END IF;
718: RAISE fnd_api.g_exc_unexpected_error;
719:
720: END IF;
721:
722: IF(p_move_order_header_id IS NOT NULL) THEN

Line 863: if (l_return_status <> fnd_api.g_ret_sts_success) then

859: , p_child_line_id => mmtt_rec.transaction_Temp_id
860: , p_lot_control_code => l_lot_control_code
861: , p_serial_control_code => l_serial_control_code);
862: if (g_trace_on = 1) then log_event('returning from update_parent_mmtt:'||l_return_status); end if;
863: if (l_return_status <> fnd_api.g_ret_sts_success) then
864: RAISE fnd_api.g_exc_unexpected_error;
865: end if;
866: -- if (g_trace_on = 1) then log_event('PATCHSET J-- BULK PICKING --END'); end if;
867: end if;

Line 864: RAISE fnd_api.g_exc_unexpected_error;

860: , p_lot_control_code => l_lot_control_code
861: , p_serial_control_code => l_serial_control_code);
862: if (g_trace_on = 1) then log_event('returning from update_parent_mmtt:'||l_return_status); end if;
863: if (l_return_status <> fnd_api.g_ret_sts_success) then
864: RAISE fnd_api.g_exc_unexpected_error;
865: end if;
866: -- if (g_trace_on = 1) then log_event('PATCHSET J-- BULK PICKING --END'); end if;
867: end if;
868:

Line 1362: RAISE fnd_api.g_exc_unexpected_error;

1358: END IF;
1359: EXCEPTION
1360: WHEN OTHERS THEN
1361: if (g_trace_on = 1) then log_event(' Error occurred in create_wct proc'||Sqlerrm); END IF;
1362: RAISE fnd_api.g_exc_unexpected_error;
1363: END create_wct;
1364:
1365:
1366:

Line 2554: l_api_return_status := fnd_api.g_ret_sts_success;

2550: l_lpn_rec.lpn_id := prev_lpn;
2551: l_lpn_rec.gross_weight := NVL(l_lpn_wt_from_db,0) + fin_wt;
2552: l_lpn_rec.gross_weight_uom_code := NVL(l_wt_uom_from_db,gr_wt_uom_code);
2553:
2554: l_api_return_status := fnd_api.g_ret_sts_success;
2555: wms_container_pvt.modify_lpn
2556: ( p_api_version => 1.0
2557: , p_init_msg_list => fnd_api.g_false
2558: , p_commit => fnd_api.g_false

Line 2557: , p_init_msg_list => fnd_api.g_false

2553:
2554: l_api_return_status := fnd_api.g_ret_sts_success;
2555: wms_container_pvt.modify_lpn
2556: ( p_api_version => 1.0
2557: , p_init_msg_list => fnd_api.g_false
2558: , p_commit => fnd_api.g_false
2559: , p_validation_level => fnd_api.g_valid_level_full
2560: , x_return_status => l_api_return_status
2561: , x_msg_count => l_msg_count

Line 2558: , p_commit => fnd_api.g_false

2554: l_api_return_status := fnd_api.g_ret_sts_success;
2555: wms_container_pvt.modify_lpn
2556: ( p_api_version => 1.0
2557: , p_init_msg_list => fnd_api.g_false
2558: , p_commit => fnd_api.g_false
2559: , p_validation_level => fnd_api.g_valid_level_full
2560: , x_return_status => l_api_return_status
2561: , x_msg_count => l_msg_count
2562: , x_msg_data => l_msg_data

Line 2559: , p_validation_level => fnd_api.g_valid_level_full

2555: wms_container_pvt.modify_lpn
2556: ( p_api_version => 1.0
2557: , p_init_msg_list => fnd_api.g_false
2558: , p_commit => fnd_api.g_false
2559: , p_validation_level => fnd_api.g_valid_level_full
2560: , x_return_status => l_api_return_status
2561: , x_msg_count => l_msg_count
2562: , x_msg_data => l_msg_data
2563: , p_lpn => l_lpn_rec

Line 2567: IF l_api_return_status <> fnd_api.g_ret_sts_success

2563: , p_lpn => l_lpn_rec
2564: , p_caller => 'WMS_LPNMGMT'
2565: );
2566:
2567: IF l_api_return_status <> fnd_api.g_ret_sts_success
2568: THEN
2569: IF g_trace_on = 1 THEN
2570: log_event('Error from wms_container_pvt.modify_lpn: ' || l_msg_data);
2571: END IF;

Line 2572: RAISE FND_API.G_EXC_ERROR;

2568: THEN
2569: IF g_trace_on = 1 THEN
2570: log_event('Error from wms_container_pvt.modify_lpn: ' || l_msg_data);
2571: END IF;
2572: RAISE FND_API.G_EXC_ERROR;
2573: ELSE
2574: IF g_trace_on = 1 THEN
2575: log_event('LPN gross weight updated');
2576: END IF;

Line 2659: l_api_return_status := fnd_api.g_ret_sts_success;

2655: l_lpn_rec.lpn_id := prev_lpn;
2656: l_lpn_rec.gross_weight := NVL(l_lpn_wt_from_db,0) + fin_wt;
2657: l_lpn_rec.gross_weight_uom_code := NVL(l_wt_uom_from_db,gr_wt_uom_code);
2658:
2659: l_api_return_status := fnd_api.g_ret_sts_success;
2660: wms_container_pvt.modify_lpn
2661: ( p_api_version => 1.0
2662: , p_init_msg_list => fnd_api.g_false
2663: , p_commit => fnd_api.g_false

Line 2662: , p_init_msg_list => fnd_api.g_false

2658:
2659: l_api_return_status := fnd_api.g_ret_sts_success;
2660: wms_container_pvt.modify_lpn
2661: ( p_api_version => 1.0
2662: , p_init_msg_list => fnd_api.g_false
2663: , p_commit => fnd_api.g_false
2664: , p_validation_level => fnd_api.g_valid_level_full
2665: , x_return_status => l_api_return_status
2666: , x_msg_count => l_msg_count

Line 2663: , p_commit => fnd_api.g_false

2659: l_api_return_status := fnd_api.g_ret_sts_success;
2660: wms_container_pvt.modify_lpn
2661: ( p_api_version => 1.0
2662: , p_init_msg_list => fnd_api.g_false
2663: , p_commit => fnd_api.g_false
2664: , p_validation_level => fnd_api.g_valid_level_full
2665: , x_return_status => l_api_return_status
2666: , x_msg_count => l_msg_count
2667: , x_msg_data => l_msg_data

Line 2664: , p_validation_level => fnd_api.g_valid_level_full

2660: wms_container_pvt.modify_lpn
2661: ( p_api_version => 1.0
2662: , p_init_msg_list => fnd_api.g_false
2663: , p_commit => fnd_api.g_false
2664: , p_validation_level => fnd_api.g_valid_level_full
2665: , x_return_status => l_api_return_status
2666: , x_msg_count => l_msg_count
2667: , x_msg_data => l_msg_data
2668: , p_lpn => l_lpn_rec

Line 2672: IF l_api_return_status <> fnd_api.g_ret_sts_success

2668: , p_lpn => l_lpn_rec
2669: , p_caller => 'WMS_LPNMGMT'
2670: );
2671:
2672: IF l_api_return_status <> fnd_api.g_ret_sts_success
2673: THEN
2674: IF g_trace_on = 1 THEN
2675: log_event('Error from wms_container_pvt.modify_lpn: ' || l_msg_data);
2676: END IF;

Line 2677: RAISE FND_API.G_EXC_ERROR;

2673: THEN
2674: IF g_trace_on = 1 THEN
2675: log_event('Error from wms_container_pvt.modify_lpn: ' || l_msg_data);
2676: END IF;
2677: RAISE FND_API.G_EXC_ERROR;
2678: ELSE
2679: IF g_trace_on = 1 THEN
2680: log_event('LPN gross weight updated');
2681: END IF;

Line 2832: l_return_status := fnd_api.g_ret_sts_success;

2828: WHEN others THEN
2829: par_lpn_id := NULL;
2830: END;
2831:
2832: l_return_status := fnd_api.g_ret_sts_success;
2833:
2834: IF par_lpn_id IS NULL THEN
2835:
2836:

Line 2838: p_validation_level => fnd_api.g_valid_level_none,

2834: IF par_lpn_id IS NULL THEN
2835:
2836:
2837: wms_container_pub.generate_lpn( p_api_version => 1.0,
2838: p_validation_level => fnd_api.g_valid_level_none,
2839: x_return_status => l_return_status,
2840: x_msg_count => l_msg_count,
2841: x_msg_data => l_msg_data,
2842: p_organization_id => p_organization_id,

Line 2860: IF( l_return_status <> fnd_api.g_ret_sts_success ) THEN

2856: END IF;
2857:
2858:
2859:
2860: IF( l_return_status <> fnd_api.g_ret_sts_success ) THEN
2861:
2862: if (g_trace_on = 1) then log_event('ERROR generating the lpns '||l_return_status); END IF;
2863: RAISE fnd_api.g_exc_unexpected_error;
2864:

Line 2863: RAISE fnd_api.g_exc_unexpected_error;

2859:
2860: IF( l_return_status <> fnd_api.g_ret_sts_success ) THEN
2861:
2862: if (g_trace_on = 1) then log_event('ERROR generating the lpns '||l_return_status); END IF;
2863: RAISE fnd_api.g_exc_unexpected_error;
2864:
2865: ELSE
2866: UPDATE wms_cartonization_temp
2867: SET

Line 2886: END IF; -- l_return_status <> fnd_api.g_ret_sts_success

2882: if (g_trace_on = 1) then log_event('updated WMS_PACKAGING_HIST for package_id '||cart_id); END IF;
2883:
2884:
2885:
2886: END IF; -- l_return_status <> fnd_api.g_ret_sts_success
2887:
2888: END IF;--cart_id IS NOT NULL
2889:
2890: END LOOP;

Line 3119: , p_init_msg_list IN VARCHAR2 :=fnd_api.g_false

3115:
3116:
3117: PROCEDURE assigntts(
3118: p_api_version IN NUMBER
3119: , p_init_msg_list IN VARCHAR2 :=fnd_api.g_false
3120: , p_commit IN VARCHAR2 :=fnd_api.g_false
3121: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
3122: , x_return_status OUT NOCOPY VARCHAR2
3123: , x_msg_count OUT NOCOPY NUMBER

Line 3120: , p_commit IN VARCHAR2 :=fnd_api.g_false

3116:
3117: PROCEDURE assigntts(
3118: p_api_version IN NUMBER
3119: , p_init_msg_list IN VARCHAR2 :=fnd_api.g_false
3120: , p_commit IN VARCHAR2 :=fnd_api.g_false
3121: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
3122: , x_return_status OUT NOCOPY VARCHAR2
3123: , x_msg_count OUT NOCOPY NUMBER
3124: , x_msg_data OUT NOCOPY VARCHAR2

Line 3121: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full

3117: PROCEDURE assigntts(
3118: p_api_version IN NUMBER
3119: , p_init_msg_list IN VARCHAR2 :=fnd_api.g_false
3120: , p_commit IN VARCHAR2 :=fnd_api.g_false
3121: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
3122: , x_return_status OUT NOCOPY VARCHAR2
3123: , x_msg_count OUT NOCOPY NUMBER
3124: , x_msg_data OUT NOCOPY VARCHAR2
3125: , p_move_order_header_id IN NUMBER

Line 3149: x_return_status := fnd_api.g_ret_sts_success;

3145: l_msg_data VARCHAR2(2000);
3146: l_api_name VARCHAR2(30) := 'assignTTs';
3147: BEGIN
3148: -- Initialize API return status to success
3149: x_return_status := fnd_api.g_ret_sts_success;
3150: IF p_move_order_header_id <> -1 THEN
3151: OPEN c_tasks;
3152: ELSE OPEN c_tasks_con;
3153: END IF;

Line 3171: IF l_return_status <> fnd_api.g_ret_sts_success THEN

3167: , x_msg_count => l_msg_count
3168: , x_msg_data => l_msg_data
3169: );
3170:
3171: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3172: x_return_status := fnd_api.g_ret_sts_error;
3173: END IF;
3174: END LOOP;
3175: IF p_move_order_header_id <> -1 THEN

Line 3172: x_return_status := fnd_api.g_ret_sts_error;

3168: , x_msg_data => l_msg_data
3169: );
3170:
3171: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3172: x_return_status := fnd_api.g_ret_sts_error;
3173: END IF;
3174: END LOOP;
3175: IF p_move_order_header_id <> -1 THEN
3176: CLOSE c_tasks;

Line 3182: x_return_status := fnd_api.g_ret_sts_unexp_error;

3178: CLOSE c_tasks_con;
3179: END IF;
3180: EXCEPTION
3181: WHEN OTHERS THEN
3182: x_return_status := fnd_api.g_ret_sts_unexp_error;
3183: END assigntts;
3184:
3185:
3186: -- Stop level

Line 3191: p_init_msg_list IN VARCHAR2 :=fnd_api.g_false,

3187: -- if specified as zero - cartonizes till the levels setup
3188:
3189: PROCEDURE cartonize(
3190: p_api_version IN NUMBER,
3191: p_init_msg_list IN VARCHAR2 :=fnd_api.g_false,
3192: p_commit IN VARCHAR2 :=fnd_api.g_false,
3193: p_validation_level IN NUMBER :=fnd_api.g_valid_level_full,
3194: x_return_status OUT NOCOPY VARCHAR2,
3195: x_msg_count OUT NOCOPY NUMBER,

Line 3192: p_commit IN VARCHAR2 :=fnd_api.g_false,

3188:
3189: PROCEDURE cartonize(
3190: p_api_version IN NUMBER,
3191: p_init_msg_list IN VARCHAR2 :=fnd_api.g_false,
3192: p_commit IN VARCHAR2 :=fnd_api.g_false,
3193: p_validation_level IN NUMBER :=fnd_api.g_valid_level_full,
3194: x_return_status OUT NOCOPY VARCHAR2,
3195: x_msg_count OUT NOCOPY NUMBER,
3196: x_msg_data OUT NOCOPY VARCHAR2,

Line 3193: p_validation_level IN NUMBER :=fnd_api.g_valid_level_full,

3189: PROCEDURE cartonize(
3190: p_api_version IN NUMBER,
3191: p_init_msg_list IN VARCHAR2 :=fnd_api.g_false,
3192: p_commit IN VARCHAR2 :=fnd_api.g_false,
3193: p_validation_level IN NUMBER :=fnd_api.g_valid_level_full,
3194: x_return_status OUT NOCOPY VARCHAR2,
3195: x_msg_count OUT NOCOPY NUMBER,
3196: x_msg_data OUT NOCOPY VARCHAR2,
3197: p_out_bound IN VARCHAR2,

Line 3235: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

3231: v_sec_left_tr_quant NUMBER; --invconv kkillams
3232: v_sublvlctrl VARCHAR2(1) := '2';
3233: --Bug 2720653 fix
3234: --l_lpn_id_tbl inv_label.transaction_id_rec_type;
3235: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
3236: l_msg_count NUMBER;
3237: l_msg_data VARCHAR2(400);
3238: l_progress VARCHAR2(10);
3239: l_label_status VARCHAR2(500);

Line 3406: IF (NOT fnd_api.compatible_api_call ( l_api_version,

3402:
3403: error_code := 'CARTONIZE 10';
3404:
3405: SAVEPOINT cartonize_pub;
3406: IF (NOT fnd_api.compatible_api_call ( l_api_version,
3407: p_api_version,
3408: l_api_name,
3409: g_pkg_name )) THEN
3410: RAISE fnd_api.g_exc_error;

Line 3410: RAISE fnd_api.g_exc_error;

3406: IF (NOT fnd_api.compatible_api_call ( l_api_version,
3407: p_api_version,
3408: l_api_name,
3409: g_pkg_name )) THEN
3410: RAISE fnd_api.g_exc_error;
3411: END IF;
3412:
3413: IF (fnd_api.to_boolean ( p_init_msg_list )) THEN
3414: fnd_msg_pub.initialize;

Line 3413: IF (fnd_api.to_boolean ( p_init_msg_list )) THEN

3409: g_pkg_name )) THEN
3410: RAISE fnd_api.g_exc_error;
3411: END IF;
3412:
3413: IF (fnd_api.to_boolean ( p_init_msg_list )) THEN
3414: fnd_msg_pub.initialize;
3415: END IF;
3416:
3417: x_return_status := fnd_api.g_ret_sts_success;

Line 3417: x_return_status := fnd_api.g_ret_sts_success;

3413: IF (fnd_api.to_boolean ( p_init_msg_list )) THEN
3414: fnd_msg_pub.initialize;
3415: END IF;
3416:
3417: x_return_status := fnd_api.g_ret_sts_success;
3418:
3419: --setting the global variable for trace
3420: g_trace_on := fnd_profile.value('INV_DEBUG_TRACE');
3421:

Line 3638: RAISE fnd_api.g_exc_error;

3634:
3635: IF ( p_move_order_header_id = 0) THEN
3636: error_code := 'CARTONIZE 20';
3637: if (g_trace_on = 1) then log_event(' error move order header id '||p_move_order_header_id); END IF;
3638: RAISE fnd_api.g_exc_error;
3639: END IF;
3640:
3641: -- changed for patchset J bulk picking -----------
3642: -- change for concurrent bulk picking program ------

Line 3678: IF l_return_status <> fnd_api.g_ret_sts_success THEN

3674: x_return_status => l_return_status,
3675: x_msg_count => l_msg_count,
3676: x_msg_data => l_msg_data);
3677:
3678: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3679: error_code := 'CARTONIZE 40';
3680: -- insert the message into the stack
3681: if (g_trace_on = 1) then log_event(' Task type assignment failed'); END IF;
3682: END IF;

Line 3684: l_return_status := fnd_api.g_ret_sts_success;

3680: -- insert the message into the stack
3681: if (g_trace_on = 1) then log_event(' Task type assignment failed'); END IF;
3682: END IF;
3683:
3684: l_return_status := fnd_api.g_ret_sts_success;
3685: END IF; -- end the in line branching
3686:
3687: IF (p_move_order_header_id <> -1 ) THEN
3688: if (g_trace_on = 1) then log_event(' calling wms_rule_pvt.assign_operation_plan for OP assignment' ); END IF;

Line 3696: IF l_return_status <> fnd_api.g_ret_sts_success THEN

3692: x_return_status => l_return_status,
3693: x_msg_count => l_msg_count,
3694: x_msg_data => l_msg_data);
3695:
3696: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3697: error_code := 'CARTONIZE 45';
3698: -- insert the message into the stack
3699: if (g_trace_on = 1) then log_event(' Operation plan assignment failed'); END IF;
3700: END IF;

Line 4042: IF( (v_return_status = fnd_api.g_ret_sts_success) AND

4038: -- p_org_id =>v1.organization_id);
4039: --log_event('validate_cont ret '|| l_valid_container);
4040: --Bug 2478970 fix
4041:
4042: IF( (v_return_status = fnd_api.g_ret_sts_success) AND
4043: (v_qty_per_cont > 0) AND
4044: (v_container_item_id IS NOT NULL) AND
4045: (v_container_item_id > 0) ) THEN
4046:

Line 4088: IF( (v_return_status = fnd_api.g_ret_sts_success ) AND

4084:
4085:
4086: v_prev_item_id := v1.inventory_item_id;
4087:
4088: IF( (v_return_status = fnd_api.g_ret_sts_success ) AND
4089: (v_qty IS NOT NULL) AND
4090: (v_qty > 0) AND
4091: (v_container_item_id IS NOT NULL) AND
4092: (v_container_item_id > 0) ) THEN

Line 4112: IF( (v_return_status <> fnd_api.g_ret_sts_success ) OR

4108: if (g_trace_on = 1) then log_event('qty per container is '||v_qty_per_cont); END IF;
4109:
4110: --#chk1
4111:
4112: IF( (v_return_status <> fnd_api.g_ret_sts_success ) OR
4113: (v_qty_per_cont IS NULL) OR
4114: (v_qty IS NULL) OR
4115: (v_container_item_id IS NULL) OR
4116: (v_qty <= 0) OR

Line 4296: IF ( v_return_status <> FND_API.g_ret_sts_success OR

4292: END IF;
4293:
4294:
4295: /* Condition #3 */
4296: IF ( v_return_status <> FND_API.g_ret_sts_success OR
4297: v_qty_per_cont IS NULL OR
4298: v_qty_per_cont <= 0 OR
4299: v_container_item_id IS NULL OR
4300: v_tr_qty_per_cont IS NULL OR

Line 4682: RAISE fnd_api.g_exc_unexpected_error;

4678: IF( packaging_mode IN (wms_cartnzn_pub.int_bp_pkg_mode,
4679: wms_cartnzn_pub.mob_bP_pkg_mode ,
4680: wms_cartnzn_pub.prepack_pkg_mode) ) THEN
4681: if (g_trace_on = 1) then log_event('erroring out since the mode is bulk pack '); END IF;
4682: RAISE fnd_api.g_exc_unexpected_error;
4683: ELSE
4684: if (g_trace_on = 1) then log_event('not erroring out since the mode is Pick release '); END IF;
4685: RAISE fnd_api.g_exc_error;
4686: END IF;

Line 4685: RAISE fnd_api.g_exc_error;

4681: if (g_trace_on = 1) then log_event('erroring out since the mode is bulk pack '); END IF;
4682: RAISE fnd_api.g_exc_unexpected_error;
4683: ELSE
4684: if (g_trace_on = 1) then log_event('not erroring out since the mode is Pick release '); END IF;
4685: RAISE fnd_api.g_exc_error;
4686: END IF;
4687: END ;
4688:
4689:

Line 4720: IF(l_return_status <> fnd_api.g_ret_sts_success ) THEN

4716: x_return_status => l_return_status,
4717: x_msg_count => x_msg_count,
4718: x_msg_data => x_msg_data,
4719: p_move_order_header_id => p_move_order_header_id);
4720: IF(l_return_status <> fnd_api.g_ret_sts_success ) THEN
4721: -- we don't want to exit if there is any error here, for example data error or something
4722: if (g_trace_on = 1) then log_event(' consolidate_bulk_tasks_for_so returns '||l_return_status); END IF;
4723: END IF;
4724: if (g_trace_on = 1) then log_event(' calling ins_wct_rows_into_mmtt after consolidation'); END IF;

Line 4742: IF l_return_status <> fnd_api.g_ret_sts_success THEN

4738: x_return_status => l_return_status,
4739: x_msg_count => l_msg_count,
4740: x_msg_data => l_msg_data);
4741:
4742: IF l_return_status <> fnd_api.g_ret_sts_success THEN
4743: error_code := 'CARTONIZE 40.1';
4744: if (g_trace_on = 1) then log_event(' Task type assignment failed'); END IF;
4745: END IF;
4746: -- if (g_trace_on = 1) then log_event('PATCHSET J-- BULK PICKING --END'); end if;

Line 4759: IF(l_return_status <> fnd_api.g_ret_sts_success ) THEN

4755: END IF;
4756: ----- end of changed for patchset J bulk picking -----------
4757:
4758:
4759: IF(l_return_status <> fnd_api.g_ret_sts_success ) THEN
4760: --Push the message into the stack
4761: if (g_trace_on = 1) then log_event(' consolidate_bulk_tasks returns '||l_return_status); END IF;
4762: END IF;
4763:

Line 4772: IF(l_return_status <> fnd_api.g_ret_sts_success ) THEN

4768: x_msg_count => x_msg_count,
4769: x_msg_data => x_msg_data,
4770: p_move_order_header_id => p_move_order_header_id);
4771:
4772: IF(l_return_status <> fnd_api.g_ret_sts_success ) THEN
4773: --Push the message into the stack
4774: if (g_trace_on = 1) then log_event(' split_tasks returns '||l_return_status); END IF;
4775: END IF;
4776:

Line 4791: IF(l_return_status <> fnd_api.g_ret_sts_success ) THEN

4787: p_move_order_header_id => p_move_order_header_id,
4788: p_ps_mode => null,
4789: p_grouping_rule_id => null,
4790: p_allow_partial_pick => null);
4791: IF(l_return_status <> fnd_api.g_ret_sts_success ) THEN
4792: --Push the message into the stack
4793: if (g_trace_on = 1) then log_event(' assign_pick_slip_number returns '||l_return_status); END IF;
4794: END IF;
4795: END IF;

Line 4869: l_return_status := fnd_api.g_ret_sts_success;

4865: IF( packaging_mode = wms_cartnzn_pub.PR_pKG_mode OR
4866: packaging_mode = wms_cartnzn_pub.mfg_PR_pKG_mode) THEN
4867: if (g_trace_on = 1) then log_event('wms_cartnzn_pub before inv_label.print_label '); END IF;
4868:
4869: l_return_status := fnd_api.g_ret_sts_success;
4870:
4871: inv_label.print_label
4872: (x_return_status => l_return_status
4873: , x_msg_count => l_msg_count

Line 4883: IF l_return_status <> fnd_api.g_ret_sts_success THEN

4879: , p_transaction_id => lpns_generated_tb
4880: );
4881: if (g_trace_on = 1) then log_event('wms_cartnzn_pub after inv_label.print_label '); END IF;
4882:
4883: IF l_return_status <> fnd_api.g_ret_sts_success THEN
4884: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_PRINT_LAB_FAIL'); -- MSGTBD
4885: FND_MSG_PUB.ADD;
4886:
4887: --IF( packaging_mode IN (2,3,4) ) THEN

Line 4904: x_return_status := fnd_api.g_ret_sts_error;

4900: IF( packaging_mode IN (wms_cartnzn_pub.int_bp_pkg_mode,
4901: wms_cartnzn_pub.mob_bP_pkg_mode ,
4902: wms_cartnzn_pub.prepack_pkg_mode)) THEN
4903: if (g_trace_on = 1) then log_event('erroring out since the mode is bulk pack '); END IF;
4904: x_return_status := fnd_api.g_ret_sts_error;
4905: END IF;
4906:
4907: END IF;
4908:

Line 4918: WHEN fnd_api.g_exc_error THEN

4914:
4915:
4916: EXCEPTION
4917:
4918: WHEN fnd_api.g_exc_error THEN
4919: if (g_trace_on = 1) then log_event('Rolling back to savepoint cartonize_pub'); END IF;
4920: ROLLBACK TO cartonize_pub;
4921: x_return_status := fnd_api.g_ret_sts_success;
4922:

Line 4921: x_return_status := fnd_api.g_ret_sts_success;

4917:
4918: WHEN fnd_api.g_exc_error THEN
4919: if (g_trace_on = 1) then log_event('Rolling back to savepoint cartonize_pub'); END IF;
4920: ROLLBACK TO cartonize_pub;
4921: x_return_status := fnd_api.g_ret_sts_success;
4922:
4923: FND_MESSAGE.SET_NAME('WMS', 'WMS_CARTONIZATION_ERROR');
4924: FND_MESSAGE.SET_TOKEN('ERROR_CODE', ERROR_CODE);
4925: FND_MSG_PUB.ADD;

Line 4952: WHEN fnd_api.g_exc_unexpected_error THEN

4948: IF wct_rows%isopen THEN
4949: CLOSE wct_rows;
4950: END IF;
4951:
4952: WHEN fnd_api.g_exc_unexpected_error THEN
4953: if (g_trace_on = 1) then log_event('Rolling back to savepoint cartonize_pub'); END IF;
4954: ROLLBACK TO cartonize_pub;
4955: x_return_status := fnd_api.g_ret_sts_unexp_error;
4956:

Line 4955: x_return_status := fnd_api.g_ret_sts_unexp_error;

4951:
4952: WHEN fnd_api.g_exc_unexpected_error THEN
4953: if (g_trace_on = 1) then log_event('Rolling back to savepoint cartonize_pub'); END IF;
4954: ROLLBACK TO cartonize_pub;
4955: x_return_status := fnd_api.g_ret_sts_unexp_error;
4956:
4957: FND_MESSAGE.SET_NAME('WMS', 'WMS_CARTONIZATION_ERROR');
4958: FND_MESSAGE.SET_TOKEN('ERROR_CODE', ERROR_CODE);
4959: FND_MSG_PUB.ADD;

Line 4974: x_return_status := fnd_api.g_ret_sts_unexp_error;

4970:
4971: WHEN OTHERS THEN
4972: ROLLBACK TO cartonize_pub;
4973: if (g_trace_on = 1) then log_event('Rolling back to savepoint cartonize_pub'); END IF;
4974: x_return_status := fnd_api.g_ret_sts_unexp_error;
4975:
4976: ERROR_MSG := Sqlerrm;
4977:
4978: FND_MESSAGE.SET_NAME('WMS', 'WMS_CARTONIZATION_ERROR');

Line 5198: RAISE fnd_api.g_exc_error;

5194:
5195: ELSE
5196: --Bug 3296177 code should never come here
5197: if (g_trace_on = 1) THEN log_event('ERROR:INS_MMTT with mtl_material_transactions_temp'); end if;
5198: RAISE fnd_api.g_exc_error;
5199: --SELECT * INTO v1 FROM mtl_material_transactions_temp WHERE
5200: --transaction_temp_id = p_transaction_temp_id;
5201:
5202: END IF;

Line 5254: RAISE fnd_api.g_exc_error;

5250:
5251:
5252: IF (table_name = 'mtl_material_transactions_temp') THEN
5253:
5254: RAISE fnd_api.g_exc_error;
5255: --wms_task_dispatch_engine.insert_mmtt
5256: --(l_mmtt_rec => v1);
5257:
5258: ELSE

Line 5326: p_commit =>fnd_api.g_false,

5322: dbms_output.put_line(mlid);*/
5323:
5324:
5325: cartonize( p_api_version => 1.0,
5326: p_commit =>fnd_api.g_false,
5327: p_out_bound => 'N',
5328: p_org_id => 1884,
5329: x_return_status => x_return_status,
5330: x_msg_count => x_msg_count,

Line 5683: x_return_status := fnd_api.g_ret_sts_success;

5679: BEGIN
5680: error_code := 'INS_WCT_ROWS_TO_MMTT';
5681: if (g_trace_on = 1) then log_event(' Entered insert wct rows to mmtt'||p_m_o_h_id); END IF;
5682: -- Initialize API return status to success
5683: x_return_status := fnd_api.g_ret_sts_success;
5684:
5685: IF( p_outbound IS NOT NULL AND p_outbound = 'N') THEN
5686: if (g_trace_on = 1) then log_event(' open bpack_rows'); END IF;
5687: OPEN bpack_rows;

Line 5802: RAISE fnd_api.g_exc_unexpected_error;

5798:
5799: if (g_trace_on = 1) then log_event(' inserting row into mmtt for temp id :'||v1.transaction_temp_id); END IF;
5800: wms_task_dispatch_engine.insert_mmtt(l_mmtt_rec => v1);
5801: ELSE
5802: RAISE fnd_api.g_exc_unexpected_error;
5803:
5804: END IF;
5805: END IF;
5806:

Line 5833: RAISE fnd_api.g_exc_unexpected_error;

5829: --l_msg := Sqlerrm;
5830: if (g_trace_on = 1) then log_event('SQL Error Message ' || SQLERRM); END IF;
5831: if (g_trace_on = 1) then log_event('SQL Error Code ' || SQLCODE); END IF;
5832: if (g_trace_on = 1) then log_event('error OCCURRED IN INSERTING WCT ROWS BACK TO MMTT'); END IF;
5833: RAISE fnd_api.g_exc_unexpected_error;
5834:
5835:
5836: END ins_wct_rows_into_mmtt;
5837:

Line 5909: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

5905: v_sec_left_tr_quant NUMBER;
5906: v_sublvlctrl VARCHAR2(1) := '2';
5907: --Bug 2720653 fix
5908: --l_lpn_id_tbl inv_label.transaction_id_rec_type;
5909: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
5910: l_msg_count NUMBER;
5911: l_msg_data VARCHAR2(400);
5912: l_progress VARCHAR2(10);
5913: l_label_status VARCHAR2(500);

Line 6113: RAISE fnd_api.g_exc_unexpected_error;

6109: IF NOT INV_CACHE.set_item_rec(v1.organization_id, v1.inventory_item_id) THEN
6110: IF (g_trace_on = 1) THEN
6111: log_event('Inventory Cache Set Item Rec Failed');
6112: END IF;
6113: RAISE fnd_api.g_exc_unexpected_error;
6114: END IF;
6115:
6116: l_revision_code := inv_cache.item_rec.revision_qty_control_code;
6117: l_lot_code := inv_cache.item_rec.lot_control_code;

Line 6294: IF( (v_return_status = fnd_api.g_ret_sts_success) AND

6290: x_return_status => v_return_status);
6291:
6292: l_valid_container := 'Y'; --Undoing 2478970 fix
6293:
6294: IF( (v_return_status = fnd_api.g_ret_sts_success) AND
6295: (v_qty_per_cont > 0) AND
6296: (v_container_item_id IS NOT NULL) AND
6297: (v_container_item_id > 0) ) THEN
6298:

Line 6335: IF( (v_return_status = fnd_api.g_ret_sts_success ) AND

6331: END IF;
6332:
6333: v_prev_item_id := v1.inventory_item_id;
6334:
6335: IF( (v_return_status = fnd_api.g_ret_sts_success ) AND
6336: (v_qty IS NOT NULL) AND
6337: (v_qty > 0) AND
6338: (v_container_item_id IS NOT NULL) AND
6339: (v_container_item_id > 0) ) THEN

Line 6359: IF( (v_return_status <> fnd_api.g_ret_sts_success ) OR

6355: log_event('qty per container is '||v_qty_per_cont);
6356: END IF;
6357: --#chk1
6358:
6359: IF( (v_return_status <> fnd_api.g_ret_sts_success ) OR
6360: (v_qty_per_cont IS NULL) OR
6361: (v_qty IS NULL) OR
6362: (v_container_item_id IS NULL) OR
6363: (v_qty <= 0) OR

Line 6509: IF (v_return_status <> FND_API.g_ret_sts_success OR

6505: END IF;
6506: END IF;
6507:
6508: -- Condition #
6509: IF (v_return_status <> FND_API.g_ret_sts_success OR
6510: v_qty_per_cont IS NULL OR
6511: v_qty_per_cont <= 0 OR
6512: v_container_item_id IS NULL OR
6513: v_tr_qty_per_cont IS NULL OR

Line 6671: x_return_status := fnd_api.g_ret_sts_success;

6667: IF (g_trace_on = 1) THEN
6668: log_event('out of the loops :)');
6669: END IF;
6670:
6671: x_return_status := fnd_api.g_ret_sts_success;
6672: EXCEPTION
6673: WHEN OTHERS THEN
6674: log_event('SQLERRM : '|| SQLERRM);
6675: log_event('SQLCODE : '|| SQLCODE);

Line 6825: IF l_return_status <> fnd_api.g_ret_sts_success THEN

6821: IF (g_trace_on = 1) THEN
6822: log_event(' Task type assignment returned with status :' ||l_return_status);
6823: END IF;
6824:
6825: IF l_return_status <> fnd_api.g_ret_sts_success THEN
6826: log_event(' Task type assignment failed');
6827: END IF;
6828:
6829: l_return_status := fnd_api.g_ret_sts_success;

Line 6829: l_return_status := fnd_api.g_ret_sts_success;

6825: IF l_return_status <> fnd_api.g_ret_sts_success THEN
6826: log_event(' Task type assignment failed');
6827: END IF;
6828:
6829: l_return_status := fnd_api.g_ret_sts_success;
6830:
6831: IF (p_move_order_header_id <> -1 ) THEN
6832:
6833: log_event('Calling wms_rule_pvt.assign_operation_plan for Operation Plan assignment' );

Line 6842: IF l_return_status <> fnd_api.g_ret_sts_success THEN

6838: , x_return_status => l_return_status
6839: , x_msg_count => l_msg_count
6840: , x_msg_data => l_msg_data);
6841:
6842: IF l_return_status <> fnd_api.g_ret_sts_success THEN
6843: error_code := 'CARTONIZE 45';
6844: -- insert the message into the stack
6845: log_event(' Operation plan assignment failed');
6846: ELSE

Line 7031: RAISE fnd_api.g_exc_error;

7027: WHEN OTHERS THEN
7028: IF (g_trace_on = 1) THEN
7029: log_event('not erroring out since the mode is Pick release ');
7030: END IF;
7031: RAISE fnd_api.g_exc_error;
7032: END;
7033:
7034: DELETE wms_cartonization_temp
7035: WHERE transaction_header_id < 0;

Line 7077: IF(l_return_status <> fnd_api.g_ret_sts_success ) THEN

7073: x_msg_count => x_msg_count,
7074: x_msg_data => x_msg_data,
7075: p_move_order_header_id => p_move_order_header_id);
7076:
7077: IF(l_return_status <> fnd_api.g_ret_sts_success ) THEN
7078: -- we don't want to exit if there is any error here, for example data error or something
7079: IF (g_trace_on = 1) THEN log_event(' consolidate_bulk_tasks_for_so returns '||l_return_status); END IF;
7080: END IF;
7081: IF (g_trace_on = 1) THEN log_event(' calling ins_wct_rows_into_mmtt after consolidation'); END IF;

Line 7093: IF(l_return_status <> fnd_api.g_ret_sts_success ) THEN

7089: -- since the return value is not set up inside above procedure, so no need to check it
7090: -- but above procedure will throw unexpected error in case of errors, so this API will capture the
7091: -- error.
7092:
7093: IF(l_return_status <> fnd_api.g_ret_sts_success ) THEN
7094: --Push the message into the stack
7095: IF (g_trace_on = 1) THEN log_event(' consolidate_bulk_tasks returns '||l_return_status); END IF;
7096: END IF;
7097:

Line 7109: IF(l_return_status <> fnd_api.g_ret_sts_success ) THEN

7105: x_msg_data => x_msg_data,
7106: p_move_order_header_id => p_move_order_header_id
7107: );
7108:
7109: IF(l_return_status <> fnd_api.g_ret_sts_success ) THEN
7110: --Push the message into the stack
7111: IF (g_trace_on = 1) THEN log_event(' split_tasks returns '||l_return_status); END IF;
7112: END IF;
7113: END IF;

Line 7123: l_return_status := fnd_api.g_ret_sts_success;

7119: IF packaging_mode = wms_cartnzn_pub.PR_pKG_mode THEN
7120: IF (g_trace_on = 1) THEN
7121: log_event('wms_cartnzn_pub before inv_label.print_label ');
7122: END IF;
7123: l_return_status := fnd_api.g_ret_sts_success;
7124:
7125: inv_label.print_label
7126: (
7127: x_return_status => l_return_status

Line 7141: IF l_return_status <> fnd_api.g_ret_sts_success THEN

7137: IF (g_trace_on = 1) THEN
7138: log_event('wms_cartnzn_pub after inv_label.print_label ');
7139: END IF;
7140:
7141: IF l_return_status <> fnd_api.g_ret_sts_success THEN
7142: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_PRINT_LAB_FAIL'); -- MSGTBD
7143: FND_MSG_PUB.ADD;
7144: IF (g_trace_on = 1) THEN
7145: log_event('wms_cartnzn_pub inv_label.print_label FAILED;'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'));

Line 7203: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

7199: v_sublvlctrl VARCHAR2(1) := g_sublvlctrl; --Bug#7168367.Get form global variable.
7200: l_header_id NUMBER := NULL;
7201: --Bug 2720653 fix
7202: --l_lpn_id_tbl inv_label.transaction_id_rec_type;
7203: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
7204: l_msg_count NUMBER;
7205: l_msg_data VARCHAR2(400);
7206: l_progress VARCHAR2(10);
7207: l_label_status VARCHAR2(500);

Line 7602: WHEN fnd_api.g_exc_error THEN

7598: AND container_item_id = -99999;
7599: END IF;
7600:
7601: EXCEPTION
7602: WHEN fnd_api.g_exc_error THEN
7603: if (g_trace_on = 1) then log_event('Rolling back to savepoint cartonize_pub'); END IF;
7604: ROLLBACK TO cartonize_pub;
7605: x_return_status := fnd_api.g_ret_sts_success;
7606: FND_MESSAGE.SET_NAME('WMS', 'WMS_CARTONIZATION_ERROR');

Line 7605: x_return_status := fnd_api.g_ret_sts_success;

7601: EXCEPTION
7602: WHEN fnd_api.g_exc_error THEN
7603: if (g_trace_on = 1) then log_event('Rolling back to savepoint cartonize_pub'); END IF;
7604: ROLLBACK TO cartonize_pub;
7605: x_return_status := fnd_api.g_ret_sts_success;
7606: FND_MESSAGE.SET_NAME('WMS', 'WMS_CARTONIZATION_ERROR');
7607: FND_MESSAGE.SET_TOKEN('ERROR_CODE', ERROR_CODE);
7608: FND_MSG_PUB.ADD;
7609: IF (g_trace_on = 1) THEN log_event('EXCEPTION occurred from ERROR_CODE:'||error_code); END IF;

Line 7620: WHEN fnd_api.g_exc_unexpected_error THEN

7616: IF wct_rows%isopen THEN
7617: CLOSE wct_rows;
7618: END IF;
7619:
7620: WHEN fnd_api.g_exc_unexpected_error THEN
7621: if (g_trace_on = 1) then log_event('Exception occurred from SQLERRM:'||SQLERRM); END IF;
7622: if (g_trace_on = 1) then log_event('Exception occurred from SQLCODE:'||SQLCODE); END IF;
7623: if (g_trace_on = 1) then log_event('Rolling back to savepoint cartonize_pub'); END IF;
7624: ROLLBACK TO cartonize_pub;

Line 7625: x_return_status := fnd_api.g_ret_sts_unexp_error;

7621: if (g_trace_on = 1) then log_event('Exception occurred from SQLERRM:'||SQLERRM); END IF;
7622: if (g_trace_on = 1) then log_event('Exception occurred from SQLCODE:'||SQLCODE); END IF;
7623: if (g_trace_on = 1) then log_event('Rolling back to savepoint cartonize_pub'); END IF;
7624: ROLLBACK TO cartonize_pub;
7625: x_return_status := fnd_api.g_ret_sts_unexp_error;
7626:
7627: FND_MESSAGE.SET_NAME('WMS', 'WMS_CARTONIZATION_ERROR');
7628: FND_MESSAGE.SET_TOKEN('ERROR_CODE', ERROR_CODE);
7629: FND_MSG_PUB.ADD;

Line 7645: x_return_status := fnd_api.g_ret_sts_unexp_error;

7641: ROLLBACK TO cartonize_pub;
7642: if (g_trace_on = 1) then log_event('Rolling back to savepoint cartonize_pub'); END IF;
7643: if (g_trace_on = 1) then log_event('Exception occurred from SQLERRM:'||SQLERRM); END IF;
7644: if (g_trace_on = 1) then log_event('Exception occurred from SQLCODE:'||SQLCODE); END IF;
7645: x_return_status := fnd_api.g_ret_sts_unexp_error;
7646: ERROR_MSG := Sqlerrm;
7647: FND_MESSAGE.SET_NAME('WMS', 'WMS_CARTONIZATION_ERROR');
7648: FND_MESSAGE.SET_TOKEN('ERROR_CODE', ERROR_CODE);
7649: FND_MSG_PUB.ADD;

Line 7919: x_return_status := fnd_api.g_ret_sts_unexp_error ;

7915: IF l_return_status = 'E' THEN
7916: IF (g_trace_on = 1) THEN
7917: log_event('API WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping returned Error' );
7918: END IF;
7919: x_return_status := fnd_api.g_ret_sts_unexp_error ;
7920: RETURN;
7921: END IF;
7922:
7923: FOR i IN l_del_det_id_tab.FIRST .. l_del_det_id_tab.LAST

Line 7981: x_return_status := fnd_api.g_ret_sts_unexp_error ;

7977: WHEN OTHERS THEN
7978: IF (g_trace_on = 1) THEN
7979: log_event('OTHERS Exception !!! .' );
7980: END IF;
7981: x_return_status := fnd_api.g_ret_sts_unexp_error ;
7982: END ;
7983: END LOOP ; -- Pick slip cursor.
7984: IF Pick_slip_cur%ISOPEN THEN
7985: CLOSE Pick_slip_cur;

Line 7992: x_return_status := fnd_api.g_ret_sts_success;

7988: END IF;
7989: IF (g_trace_on = 1) THEN
7990: log_event('Done with all pick slip numbers ' );
7991: END IF;
7992: x_return_status := fnd_api.g_ret_sts_success;
7993: IF (g_trace_on = 1) THEN
7994: log_event('Cartonize_pick_slip finished normally.');
7995: END IF;
7996: EXCEPTION

Line 8001: x_return_status := fnd_api.g_ret_sts_unexp_error ;

7997: WHEN OTHERS THEN
7998: IF (g_trace_on = 1) THEN
7999: log_event('Error in cartonize_pick_clip () :'||SQLERRM);
8000: END IF;
8001: x_return_status := fnd_api.g_ret_sts_unexp_error ;
8002: END cartonize_pick_slip;
8003:
8004:
8005: PROCEDURE cartonize_customer_logic

Line 8293: x_return_status := fnd_api.g_ret_sts_unexp_error ;

8289: END IF;
8290:
8291: EXCEPTION
8292: WHEN L_INVALID_CARTONIZATION THEN
8293: x_return_status := fnd_api.g_ret_sts_unexp_error ;
8294: IF (g_trace_on = 1) THEN
8295: log_event('Unable to cartonize, ROLLING BACK to CUSTOMER_LOGIC_SP and exiting from cartonize_customer_logic');
8296: END IF;
8297: ROLLBACK TO CUSTOMER_LOGIC_SP;

Line 8300: x_return_status := fnd_api.g_ret_sts_unexp_error ;

8296: END IF;
8297: ROLLBACK TO CUSTOMER_LOGIC_SP;
8298: WHEN OTHERS THEN
8299:
8300: x_return_status := fnd_api.g_ret_sts_unexp_error ;
8301: IF (g_trace_on = 1) THEN
8302: log_event('Unexpected error in cartonize_customer_logic(), rolling back to CUSTOMER_LOGIC_SP');
8303: log_event('SQLCODE : ' || SQLCODE);
8304: log_event('SQLERRM : ' || SQLERRM);