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 623: RAISE fnd_api.g_exc_unexpected_error;

619: IF( p_move_order_header_id IS NULL AND
620: p_transaction_header_id IS NULL ) THEN
621:
622: if (g_trace_on = 1) then log_event('Error- mo hdr id and txn hdr id are null'); END IF;
623: RAISE fnd_api.g_exc_unexpected_error;
624:
625: END IF;
626:
627: IF(p_move_order_header_id IS NOT NULL) THEN

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

764: , p_child_line_id => mmtt_rec.transaction_Temp_id
765: , p_lot_control_code => l_lot_control_code
766: , p_serial_control_code => l_serial_control_code);
767: if (g_trace_on = 1) then log_event('returning from update_parent_mmtt:'||l_return_status); end if;
768: if (l_return_status <> fnd_api.g_ret_sts_success) then
769: RAISE fnd_api.g_exc_unexpected_error;
770: end if;
771: -- if (g_trace_on = 1) then log_event('PATCHSET J-- BULK PICKING --END'); end if;
772: end if;

Line 769: RAISE fnd_api.g_exc_unexpected_error;

765: , p_lot_control_code => l_lot_control_code
766: , p_serial_control_code => l_serial_control_code);
767: if (g_trace_on = 1) then log_event('returning from update_parent_mmtt:'||l_return_status); end if;
768: if (l_return_status <> fnd_api.g_ret_sts_success) then
769: RAISE fnd_api.g_exc_unexpected_error;
770: end if;
771: -- if (g_trace_on = 1) then log_event('PATCHSET J-- BULK PICKING --END'); end if;
772: end if;
773:

Line 1269: RAISE fnd_api.g_exc_unexpected_error;

1265: END IF;
1266: EXCEPTION
1267: WHEN OTHERS THEN
1268: if (g_trace_on = 1) then log_event(' Error occurred in create_wct proc'||Sqlerrm); END IF;
1269: RAISE fnd_api.g_exc_unexpected_error;
1270: END create_wct;
1271:
1272:
1273:

Line 2529: l_api_return_status := fnd_api.g_ret_sts_success;

2525: l_lpn_rec.lpn_id := prev_lpn;
2526: l_lpn_rec.gross_weight := NVL(l_lpn_wt_from_db,0) + fin_wt;
2527: l_lpn_rec.gross_weight_uom_code := NVL(l_wt_uom_from_db,gr_wt_uom_code);
2528:
2529: l_api_return_status := fnd_api.g_ret_sts_success;
2530: wms_container_pvt.modify_lpn
2531: ( p_api_version => 1.0
2532: , p_init_msg_list => fnd_api.g_false
2533: , p_commit => fnd_api.g_false

Line 2532: , p_init_msg_list => fnd_api.g_false

2528:
2529: l_api_return_status := fnd_api.g_ret_sts_success;
2530: wms_container_pvt.modify_lpn
2531: ( p_api_version => 1.0
2532: , p_init_msg_list => fnd_api.g_false
2533: , p_commit => fnd_api.g_false
2534: , p_validation_level => fnd_api.g_valid_level_full
2535: , x_return_status => l_api_return_status
2536: , x_msg_count => l_msg_count

Line 2533: , p_commit => fnd_api.g_false

2529: l_api_return_status := fnd_api.g_ret_sts_success;
2530: wms_container_pvt.modify_lpn
2531: ( p_api_version => 1.0
2532: , p_init_msg_list => fnd_api.g_false
2533: , p_commit => fnd_api.g_false
2534: , p_validation_level => fnd_api.g_valid_level_full
2535: , x_return_status => l_api_return_status
2536: , x_msg_count => l_msg_count
2537: , x_msg_data => l_msg_data

Line 2534: , p_validation_level => fnd_api.g_valid_level_full

2530: wms_container_pvt.modify_lpn
2531: ( p_api_version => 1.0
2532: , p_init_msg_list => fnd_api.g_false
2533: , p_commit => fnd_api.g_false
2534: , p_validation_level => fnd_api.g_valid_level_full
2535: , x_return_status => l_api_return_status
2536: , x_msg_count => l_msg_count
2537: , x_msg_data => l_msg_data
2538: , p_lpn => l_lpn_rec

Line 2542: IF l_api_return_status <> fnd_api.g_ret_sts_success

2538: , p_lpn => l_lpn_rec
2539: , p_caller => 'WMS_LPNMGMT'
2540: );
2541:
2542: IF l_api_return_status <> fnd_api.g_ret_sts_success
2543: THEN
2544: IF g_trace_on = 1 THEN
2545: log_event('Error from wms_container_pvt.modify_lpn: ' || l_msg_data);
2546: END IF;

Line 2547: RAISE FND_API.G_EXC_ERROR;

2543: THEN
2544: IF g_trace_on = 1 THEN
2545: log_event('Error from wms_container_pvt.modify_lpn: ' || l_msg_data);
2546: END IF;
2547: RAISE FND_API.G_EXC_ERROR;
2548: ELSE
2549: IF g_trace_on = 1 THEN
2550: log_event('LPN gross weight updated');
2551: END IF;

Line 2634: l_api_return_status := fnd_api.g_ret_sts_success;

2630: l_lpn_rec.lpn_id := prev_lpn;
2631: l_lpn_rec.gross_weight := NVL(l_lpn_wt_from_db,0) + fin_wt;
2632: l_lpn_rec.gross_weight_uom_code := NVL(l_wt_uom_from_db,gr_wt_uom_code);
2633:
2634: l_api_return_status := fnd_api.g_ret_sts_success;
2635: wms_container_pvt.modify_lpn
2636: ( p_api_version => 1.0
2637: , p_init_msg_list => fnd_api.g_false
2638: , p_commit => fnd_api.g_false

Line 2637: , p_init_msg_list => fnd_api.g_false

2633:
2634: l_api_return_status := fnd_api.g_ret_sts_success;
2635: wms_container_pvt.modify_lpn
2636: ( p_api_version => 1.0
2637: , p_init_msg_list => fnd_api.g_false
2638: , p_commit => fnd_api.g_false
2639: , p_validation_level => fnd_api.g_valid_level_full
2640: , x_return_status => l_api_return_status
2641: , x_msg_count => l_msg_count

Line 2638: , p_commit => fnd_api.g_false

2634: l_api_return_status := fnd_api.g_ret_sts_success;
2635: wms_container_pvt.modify_lpn
2636: ( p_api_version => 1.0
2637: , p_init_msg_list => fnd_api.g_false
2638: , p_commit => fnd_api.g_false
2639: , p_validation_level => fnd_api.g_valid_level_full
2640: , x_return_status => l_api_return_status
2641: , x_msg_count => l_msg_count
2642: , x_msg_data => l_msg_data

Line 2639: , p_validation_level => fnd_api.g_valid_level_full

2635: wms_container_pvt.modify_lpn
2636: ( p_api_version => 1.0
2637: , p_init_msg_list => fnd_api.g_false
2638: , p_commit => fnd_api.g_false
2639: , p_validation_level => fnd_api.g_valid_level_full
2640: , x_return_status => l_api_return_status
2641: , x_msg_count => l_msg_count
2642: , x_msg_data => l_msg_data
2643: , p_lpn => l_lpn_rec

Line 2647: IF l_api_return_status <> fnd_api.g_ret_sts_success

2643: , p_lpn => l_lpn_rec
2644: , p_caller => 'WMS_LPNMGMT'
2645: );
2646:
2647: IF l_api_return_status <> fnd_api.g_ret_sts_success
2648: THEN
2649: IF g_trace_on = 1 THEN
2650: log_event('Error from wms_container_pvt.modify_lpn: ' || l_msg_data);
2651: END IF;

Line 2652: RAISE FND_API.G_EXC_ERROR;

2648: THEN
2649: IF g_trace_on = 1 THEN
2650: log_event('Error from wms_container_pvt.modify_lpn: ' || l_msg_data);
2651: END IF;
2652: RAISE FND_API.G_EXC_ERROR;
2653: ELSE
2654: IF g_trace_on = 1 THEN
2655: log_event('LPN gross weight updated');
2656: END IF;

Line 2811: l_return_status := fnd_api.g_ret_sts_success;

2807: WHEN others THEN
2808: par_lpn_id := NULL;
2809: END;
2810:
2811: l_return_status := fnd_api.g_ret_sts_success;
2812:
2813: IF par_lpn_id IS NULL THEN
2814:
2815:

Line 2817: p_validation_level => fnd_api.g_valid_level_none,

2813: IF par_lpn_id IS NULL THEN
2814:
2815:
2816: wms_container_pub.generate_lpn( p_api_version => 1.0,
2817: p_validation_level => fnd_api.g_valid_level_none,
2818: x_return_status => l_return_status,
2819: x_msg_count => l_msg_count,
2820: x_msg_data => l_msg_data,
2821: p_organization_id => p_organization_id,

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

2836: END IF;
2837:
2838:
2839:
2840: IF( l_return_status <> fnd_api.g_ret_sts_success ) THEN
2841:
2842: if (g_trace_on = 1) then log_event('ERROR generating the lpns '||l_return_status); END IF;
2843: RAISE fnd_api.g_exc_unexpected_error;
2844:

Line 2843: RAISE fnd_api.g_exc_unexpected_error;

2839:
2840: IF( l_return_status <> fnd_api.g_ret_sts_success ) THEN
2841:
2842: if (g_trace_on = 1) then log_event('ERROR generating the lpns '||l_return_status); END IF;
2843: RAISE fnd_api.g_exc_unexpected_error;
2844:
2845: ELSE
2846: UPDATE wms_cartonization_temp
2847: SET

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

2862: if (g_trace_on = 1) then log_event('updated WMS_PACKAGING_HIST for package_id '||cart_id); END IF;
2863:
2864:
2865:
2866: END IF; -- l_return_status <> fnd_api.g_ret_sts_success
2867:
2868: END IF;--cart_id IS NOT NULL
2869:
2870: END LOOP;

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

3095:
3096:
3097: PROCEDURE assigntts(
3098: p_api_version IN NUMBER
3099: , p_init_msg_list IN VARCHAR2 :=fnd_api.g_false
3100: , p_commit IN VARCHAR2 :=fnd_api.g_false
3101: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
3102: , x_return_status OUT NOCOPY VARCHAR2
3103: , x_msg_count OUT NOCOPY NUMBER

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

3096:
3097: PROCEDURE assigntts(
3098: p_api_version IN NUMBER
3099: , p_init_msg_list IN VARCHAR2 :=fnd_api.g_false
3100: , p_commit IN VARCHAR2 :=fnd_api.g_false
3101: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
3102: , x_return_status OUT NOCOPY VARCHAR2
3103: , x_msg_count OUT NOCOPY NUMBER
3104: , x_msg_data OUT NOCOPY VARCHAR2

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

3097: PROCEDURE assigntts(
3098: p_api_version IN NUMBER
3099: , p_init_msg_list IN VARCHAR2 :=fnd_api.g_false
3100: , p_commit IN VARCHAR2 :=fnd_api.g_false
3101: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
3102: , x_return_status OUT NOCOPY VARCHAR2
3103: , x_msg_count OUT NOCOPY NUMBER
3104: , x_msg_data OUT NOCOPY VARCHAR2
3105: , p_move_order_header_id IN NUMBER

Line 3129: x_return_status := fnd_api.g_ret_sts_success;

3125: l_msg_data VARCHAR2(2000);
3126: l_api_name VARCHAR2(30) := 'assignTTs';
3127: BEGIN
3128: -- Initialize API return status to success
3129: x_return_status := fnd_api.g_ret_sts_success;
3130: IF p_move_order_header_id <> -1 THEN
3131: OPEN c_tasks;
3132: ELSE OPEN c_tasks_con;
3133: END IF;

Line 3151: IF l_return_status <> fnd_api.g_ret_sts_success THEN

3147: , x_msg_count => l_msg_count
3148: , x_msg_data => l_msg_data
3149: );
3150:
3151: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3152: x_return_status := fnd_api.g_ret_sts_error;
3153: END IF;
3154: END LOOP;
3155: IF p_move_order_header_id <> -1 THEN

Line 3152: x_return_status := fnd_api.g_ret_sts_error;

3148: , x_msg_data => l_msg_data
3149: );
3150:
3151: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3152: x_return_status := fnd_api.g_ret_sts_error;
3153: END IF;
3154: END LOOP;
3155: IF p_move_order_header_id <> -1 THEN
3156: CLOSE c_tasks;

Line 3162: x_return_status := fnd_api.g_ret_sts_unexp_error;

3158: CLOSE c_tasks_con;
3159: END IF;
3160: EXCEPTION
3161: WHEN OTHERS THEN
3162: x_return_status := fnd_api.g_ret_sts_unexp_error;
3163: END assigntts;
3164:
3165:
3166: -- Stop level

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

3167: -- if specified as zero - cartonizes till the levels setup
3168:
3169: PROCEDURE cartonize(
3170: p_api_version IN NUMBER,
3171: p_init_msg_list IN VARCHAR2 :=fnd_api.g_false,
3172: p_commit IN VARCHAR2 :=fnd_api.g_false,
3173: p_validation_level IN NUMBER :=fnd_api.g_valid_level_full,
3174: x_return_status OUT NOCOPY VARCHAR2,
3175: x_msg_count OUT NOCOPY NUMBER,

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

3168:
3169: PROCEDURE cartonize(
3170: p_api_version IN NUMBER,
3171: p_init_msg_list IN VARCHAR2 :=fnd_api.g_false,
3172: p_commit IN VARCHAR2 :=fnd_api.g_false,
3173: p_validation_level IN NUMBER :=fnd_api.g_valid_level_full,
3174: x_return_status OUT NOCOPY VARCHAR2,
3175: x_msg_count OUT NOCOPY NUMBER,
3176: x_msg_data OUT NOCOPY VARCHAR2,

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

3169: PROCEDURE cartonize(
3170: p_api_version IN NUMBER,
3171: p_init_msg_list IN VARCHAR2 :=fnd_api.g_false,
3172: p_commit IN VARCHAR2 :=fnd_api.g_false,
3173: p_validation_level IN NUMBER :=fnd_api.g_valid_level_full,
3174: x_return_status OUT NOCOPY VARCHAR2,
3175: x_msg_count OUT NOCOPY NUMBER,
3176: x_msg_data OUT NOCOPY VARCHAR2,
3177: p_out_bound IN VARCHAR2,

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

3211: v_sec_left_tr_quant NUMBER; --invconv kkillams
3212: v_sublvlctrl VARCHAR2(1) := '2';
3213: --Bug 2720653 fix
3214: --l_lpn_id_tbl inv_label.transaction_id_rec_type;
3215: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
3216: l_msg_count NUMBER;
3217: l_msg_data VARCHAR2(400);
3218: l_progress VARCHAR2(10);
3219: l_label_status VARCHAR2(500);

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

3384:
3385: error_code := 'CARTONIZE 10';
3386:
3387: SAVEPOINT cartonize_pub;
3388: IF (NOT fnd_api.compatible_api_call ( l_api_version,
3389: p_api_version,
3390: l_api_name,
3391: g_pkg_name )) THEN
3392: RAISE fnd_api.g_exc_error;

Line 3392: RAISE fnd_api.g_exc_error;

3388: IF (NOT fnd_api.compatible_api_call ( l_api_version,
3389: p_api_version,
3390: l_api_name,
3391: g_pkg_name )) THEN
3392: RAISE fnd_api.g_exc_error;
3393: END IF;
3394:
3395: IF (fnd_api.to_boolean ( p_init_msg_list )) THEN
3396: fnd_msg_pub.initialize;

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

3391: g_pkg_name )) THEN
3392: RAISE fnd_api.g_exc_error;
3393: END IF;
3394:
3395: IF (fnd_api.to_boolean ( p_init_msg_list )) THEN
3396: fnd_msg_pub.initialize;
3397: END IF;
3398:
3399: x_return_status := fnd_api.g_ret_sts_success;

Line 3399: x_return_status := fnd_api.g_ret_sts_success;

3395: IF (fnd_api.to_boolean ( p_init_msg_list )) THEN
3396: fnd_msg_pub.initialize;
3397: END IF;
3398:
3399: x_return_status := fnd_api.g_ret_sts_success;
3400:
3401: --setting the global variable for trace
3402: g_trace_on := fnd_profile.value('INV_DEBUG_TRACE');
3403:

Line 3620: RAISE fnd_api.g_exc_error;

3616:
3617: IF ( p_move_order_header_id = 0) THEN
3618: error_code := 'CARTONIZE 20';
3619: if (g_trace_on = 1) then log_event(' error move order header id '||p_move_order_header_id); END IF;
3620: RAISE fnd_api.g_exc_error;
3621: END IF;
3622:
3623: -- changed for patchset J bulk picking -----------
3624: -- change for concurrent bulk picking program ------

Line 3660: IF l_return_status <> fnd_api.g_ret_sts_success THEN

3656: x_return_status => l_return_status,
3657: x_msg_count => l_msg_count,
3658: x_msg_data => l_msg_data);
3659:
3660: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3661: error_code := 'CARTONIZE 40';
3662: -- insert the message into the stack
3663: if (g_trace_on = 1) then log_event(' Task type assignment failed'); END IF;
3664: END IF;

Line 3666: l_return_status := fnd_api.g_ret_sts_success;

3662: -- insert the message into the stack
3663: if (g_trace_on = 1) then log_event(' Task type assignment failed'); END IF;
3664: END IF;
3665:
3666: l_return_status := fnd_api.g_ret_sts_success;
3667: END IF; -- end the in line branching
3668:
3669: IF (p_move_order_header_id <> -1 ) THEN
3670: if (g_trace_on = 1) then log_event(' calling wms_rule_pvt.assign_operation_plan for OP assignment' ); END IF;

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 45';
3680: -- insert the message into the stack
3681: if (g_trace_on = 1) then log_event(' Operation plan assignment failed'); END IF;
3682: END IF;

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

4020: -- p_org_id =>v1.organization_id);
4021: --log_event('validate_cont ret '|| l_valid_container);
4022: --Bug 2478970 fix
4023:
4024: IF( (v_return_status = fnd_api.g_ret_sts_success) AND
4025: (v_qty_per_cont > 0) AND
4026: (v_container_item_id IS NOT NULL) AND
4027: (v_container_item_id > 0) ) THEN
4028:

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

4066:
4067:
4068: v_prev_item_id := v1.inventory_item_id;
4069:
4070: IF( (v_return_status = fnd_api.g_ret_sts_success ) AND
4071: (v_qty IS NOT NULL) AND
4072: (v_qty > 0) AND
4073: (v_container_item_id IS NOT NULL) AND
4074: (v_container_item_id > 0) ) THEN

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

4090: if (g_trace_on = 1) then log_event('qty per container is '||v_qty_per_cont); END IF;
4091:
4092: --#chk1
4093:
4094: IF( (v_return_status <> fnd_api.g_ret_sts_success ) OR
4095: (v_qty_per_cont IS NULL) OR
4096: (v_qty IS NULL) OR
4097: (v_container_item_id IS NULL) OR
4098: (v_qty <= 0) OR

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

4285: END IF;
4286:
4287:
4288: /* Condition #3 */
4289: IF ( v_return_status <> FND_API.g_ret_sts_success OR
4290: v_qty_per_cont IS NULL OR
4291: v_qty_per_cont <= 0 OR
4292: v_container_item_id IS NULL OR
4293: v_tr_qty_per_cont IS NULL OR

Line 4675: RAISE fnd_api.g_exc_unexpected_error;

4671: IF( packaging_mode IN (wms_cartnzn_pub.int_bp_pkg_mode,
4672: wms_cartnzn_pub.mob_bP_pkg_mode ,
4673: wms_cartnzn_pub.prepack_pkg_mode) ) THEN
4674: if (g_trace_on = 1) then log_event('erroring out since the mode is bulk pack '); END IF;
4675: RAISE fnd_api.g_exc_unexpected_error;
4676: ELSE
4677: if (g_trace_on = 1) then log_event('not erroring out since the mode is Pick release '); END IF;
4678: RAISE fnd_api.g_exc_error;
4679: END IF;

Line 4678: RAISE fnd_api.g_exc_error;

4674: if (g_trace_on = 1) then log_event('erroring out since the mode is bulk pack '); END IF;
4675: RAISE fnd_api.g_exc_unexpected_error;
4676: ELSE
4677: if (g_trace_on = 1) then log_event('not erroring out since the mode is Pick release '); END IF;
4678: RAISE fnd_api.g_exc_error;
4679: END IF;
4680: END ;
4681:
4682:

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

4709: x_return_status => l_return_status,
4710: x_msg_count => x_msg_count,
4711: x_msg_data => x_msg_data,
4712: p_move_order_header_id => p_move_order_header_id);
4713: IF(l_return_status <> fnd_api.g_ret_sts_success ) THEN
4714: -- we don't want to exit if there is any error here, for example data error or something
4715: if (g_trace_on = 1) then log_event(' consolidate_bulk_tasks_for_so returns '||l_return_status); END IF;
4716: END IF;
4717: if (g_trace_on = 1) then log_event(' calling ins_wct_rows_into_mmtt after consolidation'); END IF;

Line 4735: IF l_return_status <> fnd_api.g_ret_sts_success THEN

4731: x_return_status => l_return_status,
4732: x_msg_count => l_msg_count,
4733: x_msg_data => l_msg_data);
4734:
4735: IF l_return_status <> fnd_api.g_ret_sts_success THEN
4736: error_code := 'CARTONIZE 40.1';
4737: if (g_trace_on = 1) then log_event(' Task type assignment failed'); END IF;
4738: END IF;
4739: -- if (g_trace_on = 1) then log_event('PATCHSET J-- BULK PICKING --END'); end if;

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

4748: END IF;
4749: ----- end of changed for patchset J bulk picking -----------
4750:
4751:
4752: IF(l_return_status <> fnd_api.g_ret_sts_success ) THEN
4753: --Push the message into the stack
4754: if (g_trace_on = 1) then log_event(' consolidate_bulk_tasks returns '||l_return_status); END IF;
4755: END IF;
4756:

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

4761: x_msg_count => x_msg_count,
4762: x_msg_data => x_msg_data,
4763: p_move_order_header_id => p_move_order_header_id);
4764:
4765: IF(l_return_status <> fnd_api.g_ret_sts_success ) THEN
4766: --Push the message into the stack
4767: if (g_trace_on = 1) then log_event(' split_tasks returns '||l_return_status); END IF;
4768: END IF;
4769:

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

4780: p_move_order_header_id => p_move_order_header_id,
4781: p_ps_mode => null,
4782: p_grouping_rule_id => null,
4783: p_allow_partial_pick => null);
4784: IF(l_return_status <> fnd_api.g_ret_sts_success ) THEN
4785: --Push the message into the stack
4786: if (g_trace_on = 1) then log_event(' assign_pick_slip_number returns '||l_return_status); END IF;
4787: END IF;
4788: END IF;

Line 4862: l_return_status := fnd_api.g_ret_sts_success;

4858: IF( packaging_mode = wms_cartnzn_pub.PR_pKG_mode OR
4859: packaging_mode = wms_cartnzn_pub.mfg_PR_pKG_mode) THEN
4860: if (g_trace_on = 1) then log_event('wms_cartnzn_pub before inv_label.print_label '); END IF;
4861:
4862: l_return_status := fnd_api.g_ret_sts_success;
4863:
4864: inv_label.print_label
4865: (x_return_status => l_return_status
4866: , x_msg_count => l_msg_count

Line 4876: IF l_return_status <> fnd_api.g_ret_sts_success THEN

4872: , p_transaction_id => lpns_generated_tb
4873: );
4874: if (g_trace_on = 1) then log_event('wms_cartnzn_pub after inv_label.print_label '); END IF;
4875:
4876: IF l_return_status <> fnd_api.g_ret_sts_success THEN
4877: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_PRINT_LAB_FAIL'); -- MSGTBD
4878: FND_MSG_PUB.ADD;
4879:
4880: --IF( packaging_mode IN (2,3,4) ) THEN

Line 4897: x_return_status := fnd_api.g_ret_sts_error;

4893: IF( packaging_mode IN (wms_cartnzn_pub.int_bp_pkg_mode,
4894: wms_cartnzn_pub.mob_bP_pkg_mode ,
4895: wms_cartnzn_pub.prepack_pkg_mode)) THEN
4896: if (g_trace_on = 1) then log_event('erroring out since the mode is bulk pack '); END IF;
4897: x_return_status := fnd_api.g_ret_sts_error;
4898: END IF;
4899:
4900: END IF;
4901:

Line 4911: WHEN fnd_api.g_exc_error THEN

4907:
4908:
4909: EXCEPTION
4910:
4911: WHEN fnd_api.g_exc_error THEN
4912: if (g_trace_on = 1) then log_event('Rolling back to savepoint cartonize_pub'); END IF;
4913: ROLLBACK TO cartonize_pub;
4914: x_return_status := fnd_api.g_ret_sts_success;
4915:

Line 4914: x_return_status := fnd_api.g_ret_sts_success;

4910:
4911: WHEN fnd_api.g_exc_error THEN
4912: if (g_trace_on = 1) then log_event('Rolling back to savepoint cartonize_pub'); END IF;
4913: ROLLBACK TO cartonize_pub;
4914: x_return_status := fnd_api.g_ret_sts_success;
4915:
4916: FND_MESSAGE.SET_NAME('WMS', 'WMS_CARTONIZATION_ERROR');
4917: FND_MESSAGE.SET_TOKEN('ERROR_CODE', ERROR_CODE);
4918: FND_MSG_PUB.ADD;

Line 4945: WHEN fnd_api.g_exc_unexpected_error THEN

4941: IF wct_rows%isopen THEN
4942: CLOSE wct_rows;
4943: END IF;
4944:
4945: WHEN fnd_api.g_exc_unexpected_error THEN
4946: if (g_trace_on = 1) then log_event('Rolling back to savepoint cartonize_pub'); END IF;
4947: ROLLBACK TO cartonize_pub;
4948: x_return_status := fnd_api.g_ret_sts_unexp_error;
4949:

Line 4948: x_return_status := fnd_api.g_ret_sts_unexp_error;

4944:
4945: WHEN fnd_api.g_exc_unexpected_error THEN
4946: if (g_trace_on = 1) then log_event('Rolling back to savepoint cartonize_pub'); END IF;
4947: ROLLBACK TO cartonize_pub;
4948: x_return_status := fnd_api.g_ret_sts_unexp_error;
4949:
4950: FND_MESSAGE.SET_NAME('WMS', 'WMS_CARTONIZATION_ERROR');
4951: FND_MESSAGE.SET_TOKEN('ERROR_CODE', ERROR_CODE);
4952: FND_MSG_PUB.ADD;

Line 4967: x_return_status := fnd_api.g_ret_sts_unexp_error;

4963:
4964: WHEN OTHERS THEN
4965: ROLLBACK TO cartonize_pub;
4966: if (g_trace_on = 1) then log_event('Rolling back to savepoint cartonize_pub'); END IF;
4967: x_return_status := fnd_api.g_ret_sts_unexp_error;
4968:
4969: ERROR_MSG := Sqlerrm;
4970:
4971: FND_MESSAGE.SET_NAME('WMS', 'WMS_CARTONIZATION_ERROR');

Line 5224: RAISE fnd_api.g_exc_error;

5220:
5221: ELSE
5222: --Bug 3296177 code should never come here
5223: if (g_trace_on = 1) THEN log_event('ERROR:INS_MMTT with mtl_material_transactions_temp'); end if;
5224: RAISE fnd_api.g_exc_error;
5225: --SELECT * INTO v1 FROM mtl_material_transactions_temp WHERE
5226: --transaction_temp_id = p_transaction_temp_id;
5227:
5228: END IF;

Line 5280: RAISE fnd_api.g_exc_error;

5276:
5277:
5278: IF (table_name = 'mtl_material_transactions_temp') THEN
5279:
5280: RAISE fnd_api.g_exc_error;
5281: --wms_task_dispatch_engine.insert_mmtt
5282: --(l_mmtt_rec => v1);
5283:
5284: ELSE

Line 5352: p_commit =>fnd_api.g_false,

5348: dbms_output.put_line(mlid);*/
5349:
5350:
5351: cartonize( p_api_version => 1.0,
5352: p_commit =>fnd_api.g_false,
5353: p_out_bound => 'N',
5354: p_org_id => 1884,
5355: x_return_status => x_return_status,
5356: x_msg_count => x_msg_count,

Line 5719: x_return_status := fnd_api.g_ret_sts_success;

5715: BEGIN
5716: error_code := 'INS_WCT_ROWS_TO_MMTT';
5717: if (g_trace_on = 1) then log_event(' Entered insert wct rows to mmtt'||p_m_o_h_id); END IF;
5718: -- Initialize API return status to success
5719: x_return_status := fnd_api.g_ret_sts_success;
5720:
5721: IF( p_outbound IS NOT NULL AND p_outbound = 'N') THEN
5722: if (g_trace_on = 1) then log_event(' open bpack_rows'); END IF;
5723: OPEN bpack_rows;

Line 5841: RAISE fnd_api.g_exc_unexpected_error;

5837:
5838: if (g_trace_on = 1) then log_event(' inserting row into mmtt for temp id :'||v1.transaction_temp_id); END IF;
5839: wms_task_dispatch_engine.insert_mmtt(l_mmtt_rec => v1);
5840: ELSE
5841: RAISE fnd_api.g_exc_unexpected_error;
5842:
5843: END IF;
5844: END IF;
5845:

Line 5872: RAISE fnd_api.g_exc_unexpected_error;

5868: --l_msg := Sqlerrm;
5869: if (g_trace_on = 1) then log_event('SQL Error Message ' || SQLERRM); END IF;
5870: if (g_trace_on = 1) then log_event('SQL Error Code ' || SQLCODE); END IF;
5871: if (g_trace_on = 1) then log_event('error OCCURRED IN INSERTING WCT ROWS BACK TO MMTT'); END IF;
5872: RAISE fnd_api.g_exc_unexpected_error;
5873:
5874:
5875: END ins_wct_rows_into_mmtt;
5876:

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

5944: v_sec_left_tr_quant NUMBER;
5945: v_sublvlctrl VARCHAR2(1) := '2';
5946: --Bug 2720653 fix
5947: --l_lpn_id_tbl inv_label.transaction_id_rec_type;
5948: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
5949: l_msg_count NUMBER;
5950: l_msg_data VARCHAR2(400);
5951: l_progress VARCHAR2(10);
5952: l_label_status VARCHAR2(500);

Line 6158: RAISE fnd_api.g_exc_unexpected_error;

6154: IF NOT INV_CACHE.set_item_rec(v1.organization_id, v1.inventory_item_id) THEN
6155: IF (g_trace_on = 1) THEN
6156: log_event('Inventory Cache Set Item Rec Failed');
6157: END IF;
6158: RAISE fnd_api.g_exc_unexpected_error;
6159: END IF;
6160:
6161: l_revision_code := inv_cache.item_rec.revision_qty_control_code;
6162: l_lot_code := inv_cache.item_rec.lot_control_code;

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

6335: x_return_status => v_return_status);
6336:
6337: l_valid_container := 'Y'; --Undoing 2478970 fix
6338:
6339: IF( (v_return_status = fnd_api.g_ret_sts_success) AND
6340: (v_qty_per_cont > 0) AND
6341: (v_container_item_id IS NOT NULL) AND
6342: (v_container_item_id > 0) ) THEN
6343:

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

6376: END IF;
6377:
6378: v_prev_item_id := v1.inventory_item_id;
6379:
6380: IF( (v_return_status = fnd_api.g_ret_sts_success ) AND
6381: (v_qty IS NOT NULL) AND
6382: (v_qty > 0) AND
6383: (v_container_item_id IS NOT NULL) AND
6384: (v_container_item_id > 0) ) THEN

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

6400: log_event('qty per container is '||v_qty_per_cont);
6401: END IF;
6402: --#chk1
6403:
6404: IF( (v_return_status <> fnd_api.g_ret_sts_success ) OR
6405: (v_qty_per_cont IS NULL) OR
6406: (v_qty IS NULL) OR
6407: (v_container_item_id IS NULL) OR
6408: (v_qty <= 0) OR

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

6564: END IF;
6565: END IF;
6566:
6567: -- Condition #
6568: IF (v_return_status <> FND_API.g_ret_sts_success OR
6569: v_qty_per_cont IS NULL OR
6570: v_qty_per_cont <= 0 OR
6571: v_container_item_id IS NULL OR
6572: v_tr_qty_per_cont IS NULL OR

Line 6730: x_return_status := fnd_api.g_ret_sts_success;

6726: IF (g_trace_on = 1) THEN
6727: log_event('out of the loops :)');
6728: END IF;
6729:
6730: x_return_status := fnd_api.g_ret_sts_success;
6731: EXCEPTION
6732: WHEN OTHERS THEN
6733: log_event('SQLERRM : '|| SQLERRM);
6734: log_event('SQLCODE : '|| SQLCODE);

Line 6887: IF l_return_status <> fnd_api.g_ret_sts_success THEN

6883: IF (g_trace_on = 1) THEN
6884: log_event(' Task type assignment returned with status :' ||l_return_status);
6885: END IF;
6886:
6887: IF l_return_status <> fnd_api.g_ret_sts_success THEN
6888: log_event(' Task type assignment failed');
6889: END IF;
6890: */ -- bug 10202064
6891:

Line 6892: l_return_status := fnd_api.g_ret_sts_success;

6888: log_event(' Task type assignment failed');
6889: END IF;
6890: */ -- bug 10202064
6891:
6892: l_return_status := fnd_api.g_ret_sts_success;
6893:
6894: IF (p_move_order_header_id <> -1 ) THEN
6895:
6896: log_event('Calling wms_rule_pvt.assign_operation_plan for Operation Plan assignment' );

Line 6905: IF l_return_status <> fnd_api.g_ret_sts_success THEN

6901: , x_return_status => l_return_status
6902: , x_msg_count => l_msg_count
6903: , x_msg_data => l_msg_data);
6904:
6905: IF l_return_status <> fnd_api.g_ret_sts_success THEN
6906: error_code := 'CARTONIZE 45';
6907: -- insert the message into the stack
6908: log_event(' Operation plan assignment failed');
6909: ELSE

Line 7094: RAISE fnd_api.g_exc_error;

7090: WHEN OTHERS THEN
7091: IF (g_trace_on = 1) THEN
7092: log_event('not erroring out since the mode is Pick release ');
7093: END IF;
7094: RAISE fnd_api.g_exc_error;
7095: END;
7096:
7097: DELETE wms_cartonization_temp
7098: WHERE transaction_header_id < 0;

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

7136: x_msg_count => x_msg_count,
7137: x_msg_data => x_msg_data,
7138: p_move_order_header_id => p_move_order_header_id);
7139:
7140: IF(l_return_status <> fnd_api.g_ret_sts_success ) THEN
7141: -- we don't want to exit if there is any error here, for example data error or something
7142: IF (g_trace_on = 1) THEN log_event(' consolidate_bulk_tasks_for_so returns '||l_return_status); END IF;
7143: END IF;
7144: IF (g_trace_on = 1) THEN log_event(' calling ins_wct_rows_into_mmtt after consolidation'); END IF;

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

7152: -- since the return value is not set up inside above procedure, so no need to check it
7153: -- but above procedure will throw unexpected error in case of errors, so this API will capture the
7154: -- error.
7155:
7156: IF(l_return_status <> fnd_api.g_ret_sts_success ) THEN
7157: --Push the message into the stack
7158: IF (g_trace_on = 1) THEN log_event(' consolidate_bulk_tasks returns '||l_return_status); END IF;
7159: END IF;
7160:

Line 7172: IF l_return_status <> fnd_api.g_ret_sts_success THEN

7168: x_return_status => l_return_status,
7169: x_msg_count => l_msg_count,
7170: x_msg_data => l_msg_data);
7171:
7172: IF l_return_status <> fnd_api.g_ret_sts_success THEN
7173: error_code := 'CARTONIZE 40.1';
7174: if (g_trace_on = 1) then log_event(' Task type assignment failed'); END IF;
7175: END IF;
7176: -- end bug 10202064

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

7185: x_msg_data => x_msg_data,
7186: p_move_order_header_id => p_move_order_header_id
7187: );
7188:
7189: IF(l_return_status <> fnd_api.g_ret_sts_success ) THEN
7190: --Push the message into the stack
7191: IF (g_trace_on = 1) THEN log_event(' split_tasks returns '||l_return_status); END IF;
7192: END IF;
7193: END IF;

Line 7203: l_return_status := fnd_api.g_ret_sts_success;

7199: IF packaging_mode = wms_cartnzn_pub.PR_pKG_mode THEN
7200: IF (g_trace_on = 1) THEN
7201: log_event('wms_cartnzn_pub before inv_label.print_label ');
7202: END IF;
7203: l_return_status := fnd_api.g_ret_sts_success;
7204:
7205: inv_label.print_label
7206: (
7207: x_return_status => l_return_status

Line 7221: IF l_return_status <> fnd_api.g_ret_sts_success THEN

7217: IF (g_trace_on = 1) THEN
7218: log_event('wms_cartnzn_pub after inv_label.print_label ');
7219: END IF;
7220:
7221: IF l_return_status <> fnd_api.g_ret_sts_success THEN
7222: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_PRINT_LAB_FAIL'); -- MSGTBD
7223: FND_MSG_PUB.ADD;
7224: IF (g_trace_on = 1) THEN
7225: log_event('wms_cartnzn_pub inv_label.print_label FAILED;'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'));

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

7279: v_sublvlctrl VARCHAR2(1) := g_sublvlctrl; --Bug#7168367.Get form global variable.
7280: l_header_id NUMBER := NULL;
7281: --Bug 2720653 fix
7282: --l_lpn_id_tbl inv_label.transaction_id_rec_type;
7283: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
7284: l_msg_count NUMBER;
7285: l_msg_data VARCHAR2(400);
7286: l_progress VARCHAR2(10);
7287: l_label_status VARCHAR2(500);

Line 7685: WHEN fnd_api.g_exc_error THEN

7681: AND container_item_id = -99999;
7682: END IF;
7683:
7684: EXCEPTION
7685: WHEN fnd_api.g_exc_error THEN
7686: if (g_trace_on = 1) then log_event('Rolling back to savepoint cartonize_pub'); END IF;
7687: ROLLBACK TO cartonize_pub;
7688: x_return_status := fnd_api.g_ret_sts_success;
7689: FND_MESSAGE.SET_NAME('WMS', 'WMS_CARTONIZATION_ERROR');

Line 7688: x_return_status := fnd_api.g_ret_sts_success;

7684: EXCEPTION
7685: WHEN fnd_api.g_exc_error THEN
7686: if (g_trace_on = 1) then log_event('Rolling back to savepoint cartonize_pub'); END IF;
7687: ROLLBACK TO cartonize_pub;
7688: x_return_status := fnd_api.g_ret_sts_success;
7689: FND_MESSAGE.SET_NAME('WMS', 'WMS_CARTONIZATION_ERROR');
7690: FND_MESSAGE.SET_TOKEN('ERROR_CODE', ERROR_CODE);
7691: FND_MSG_PUB.ADD;
7692: IF (g_trace_on = 1) THEN log_event('EXCEPTION occurred from ERROR_CODE:'||error_code); END IF;

Line 7703: WHEN fnd_api.g_exc_unexpected_error THEN

7699: IF wct_rows%isopen THEN
7700: CLOSE wct_rows;
7701: END IF;
7702:
7703: WHEN fnd_api.g_exc_unexpected_error THEN
7704: if (g_trace_on = 1) then log_event('Exception occurred from SQLERRM:'||SQLERRM); END IF;
7705: if (g_trace_on = 1) then log_event('Exception occurred from SQLCODE:'||SQLCODE); END IF;
7706: if (g_trace_on = 1) then log_event('Rolling back to savepoint cartonize_pub'); END IF;
7707: ROLLBACK TO cartonize_pub;

Line 7708: x_return_status := fnd_api.g_ret_sts_unexp_error;

7704: if (g_trace_on = 1) then log_event('Exception occurred from SQLERRM:'||SQLERRM); END IF;
7705: if (g_trace_on = 1) then log_event('Exception occurred from SQLCODE:'||SQLCODE); END IF;
7706: if (g_trace_on = 1) then log_event('Rolling back to savepoint cartonize_pub'); END IF;
7707: ROLLBACK TO cartonize_pub;
7708: x_return_status := fnd_api.g_ret_sts_unexp_error;
7709:
7710: FND_MESSAGE.SET_NAME('WMS', 'WMS_CARTONIZATION_ERROR');
7711: FND_MESSAGE.SET_TOKEN('ERROR_CODE', ERROR_CODE);
7712: FND_MSG_PUB.ADD;

Line 7728: x_return_status := fnd_api.g_ret_sts_unexp_error;

7724: ROLLBACK TO cartonize_pub;
7725: if (g_trace_on = 1) then log_event('Rolling back to savepoint cartonize_pub'); END IF;
7726: if (g_trace_on = 1) then log_event('Exception occurred from SQLERRM:'||SQLERRM); END IF;
7727: if (g_trace_on = 1) then log_event('Exception occurred from SQLCODE:'||SQLCODE); END IF;
7728: x_return_status := fnd_api.g_ret_sts_unexp_error;
7729: ERROR_MSG := Sqlerrm;
7730: FND_MESSAGE.SET_NAME('WMS', 'WMS_CARTONIZATION_ERROR');
7731: FND_MESSAGE.SET_TOKEN('ERROR_CODE', ERROR_CODE);
7732: FND_MSG_PUB.ADD;

Line 8008: x_return_status := fnd_api.g_ret_sts_unexp_error ;

8004: IF l_return_status = 'E' THEN
8005: IF (g_trace_on = 1) THEN
8006: log_event('API WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping returned Error' );
8007: END IF;
8008: x_return_status := fnd_api.g_ret_sts_unexp_error ;
8009: RETURN;
8010: END IF;
8011:
8012: FOR i IN l_del_det_id_tab.FIRST .. l_del_det_id_tab.LAST

Line 8070: x_return_status := fnd_api.g_ret_sts_unexp_error ;

8066: WHEN OTHERS THEN
8067: IF (g_trace_on = 1) THEN
8068: log_event('OTHERS Exception !!! .' );
8069: END IF;
8070: x_return_status := fnd_api.g_ret_sts_unexp_error ;
8071: END ;
8072: END LOOP ; -- Pick slip cursor.
8073: IF Pick_slip_cur%ISOPEN THEN
8074: CLOSE Pick_slip_cur;

Line 8081: x_return_status := fnd_api.g_ret_sts_success;

8077: END IF;
8078: IF (g_trace_on = 1) THEN
8079: log_event('Done with all pick slip numbers ' );
8080: END IF;
8081: x_return_status := fnd_api.g_ret_sts_success;
8082: IF (g_trace_on = 1) THEN
8083: log_event('Cartonize_pick_slip finished normally.');
8084: END IF;
8085: EXCEPTION

Line 8090: x_return_status := fnd_api.g_ret_sts_unexp_error ;

8086: WHEN OTHERS THEN
8087: IF (g_trace_on = 1) THEN
8088: log_event('Error in cartonize_pick_clip () :'||SQLERRM);
8089: END IF;
8090: x_return_status := fnd_api.g_ret_sts_unexp_error ;
8091: END cartonize_pick_slip;
8092:
8093:
8094: PROCEDURE cartonize_customer_logic

Line 8388: x_return_status := fnd_api.g_ret_sts_unexp_error ;

8384: END IF;
8385:
8386: EXCEPTION
8387: WHEN L_INVALID_CARTONIZATION THEN
8388: x_return_status := fnd_api.g_ret_sts_unexp_error ;
8389: IF (g_trace_on = 1) THEN
8390: log_event('Unable to cartonize, ROLLING BACK to CUSTOMER_LOGIC_SP and exiting from cartonize_customer_logic');
8391: END IF;
8392: ROLLBACK TO CUSTOMER_LOGIC_SP;

Line 8395: x_return_status := fnd_api.g_ret_sts_unexp_error ;

8391: END IF;
8392: ROLLBACK TO CUSTOMER_LOGIC_SP;
8393: WHEN OTHERS THEN
8394:
8395: x_return_status := fnd_api.g_ret_sts_unexp_error ;
8396: IF (g_trace_on = 1) THEN
8397: log_event('Unexpected error in cartonize_customer_logic(), rolling back to CUSTOMER_LOGIC_SP');
8398: log_event('SQLCODE : ' || SQLCODE);
8399: log_event('SQLERRM : ' || SQLERRM);