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;
3418:
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
4888: --x_return_status := l_return_status;
4889: --x_msg_data := l_msg_data;
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;
4926:
4927: if (g_trace_on = 1) then log_event('EXCEPTION occurred from ERROR_CODE:'||error_code); END IF;
4928:
4929: fnd_msg_pub.count_and_get
4925: FND_MSG_PUB.ADD;
4926:
4927: if (g_trace_on = 1) then log_event('EXCEPTION occurred from ERROR_CODE:'||error_code); END IF;
4928:
4929: fnd_msg_pub.count_and_get
4930: (
4931: p_count => x_msg_count,
4932: p_data => x_msg_data
4933: );
4939: -- dbms_output.put_line (replace(x_msg_data,chr(0),' '));
4940: -- ELSE
4941: -- dbms_output.put_line ('Not Successful2');
4942: -- For I in 1..x_msg_count LOOP
4943: -- x_msg_data := fnd_msg_pub.get(I,'F');
4944: -- dbms_output.put_line(replace(x_msg_data,chr(0),' '));
4945: -- END LOOP;
4946: -- END IF;
4947:
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;
4960: if (g_trace_on = 1) then log_event('Exception occurred from ERROR_CODE:'||error_code); END IF;
4961: fnd_msg_pub.count_and_get
4962: (
4963: p_count => x_msg_count,
4957: FND_MESSAGE.SET_NAME('WMS', 'WMS_CARTONIZATION_ERROR');
4958: FND_MESSAGE.SET_TOKEN('ERROR_CODE', ERROR_CODE);
4959: FND_MSG_PUB.ADD;
4960: if (g_trace_on = 1) then log_event('Exception occurred from ERROR_CODE:'||error_code); END IF;
4961: fnd_msg_pub.count_and_get
4962: (
4963: p_count => x_msg_count,
4964: p_data => x_msg_data
4965: );
4976: ERROR_MSG := Sqlerrm;
4977:
4978: FND_MESSAGE.SET_NAME('WMS', 'WMS_CARTONIZATION_ERROR');
4979: FND_MESSAGE.SET_TOKEN('ERROR_CODE', ERROR_CODE);
4980: FND_MSG_PUB.ADD;
4981:
4982: if (g_trace_on = 1) then log_event('Exception occurred from ERROR_CODE:'||error_code); END IF;
4983:
4984: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error ) THEN
4980: FND_MSG_PUB.ADD;
4981:
4982: if (g_trace_on = 1) then log_event('Exception occurred from ERROR_CODE:'||error_code); END IF;
4983:
4984: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error ) THEN
4985:
4986: fnd_msg_pub.add_exc_msg
4987: ( g_pkg_name,
4988: l_api_name,
4982: if (g_trace_on = 1) then log_event('Exception occurred from ERROR_CODE:'||error_code); END IF;
4983:
4984: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error ) THEN
4985:
4986: fnd_msg_pub.add_exc_msg
4987: ( g_pkg_name,
4988: l_api_name,
4989: ERROR_MSG
4990: );
4989: ERROR_MSG
4990: );
4991: END IF;
4992:
4993: fnd_msg_pub.count_and_get
4994: (
4995: p_count => x_msg_count,
4996: p_data => x_msg_data
4997: );
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'));
7146: END IF;
7147: 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;
7610: fnd_msg_pub.count_and_get
7611: (
7612: p_count => x_msg_count,
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;
7610: fnd_msg_pub.count_and_get
7611: (
7612: p_count => x_msg_count,
7613: p_data => x_msg_data
7614: );
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;
7630: if (g_trace_on = 1) then log_event('Exception occurred from ERROR_CODE:'||error_code); END IF;
7631: fnd_msg_pub.count_and_get
7632: (
7633: p_count => x_msg_count,
7627: FND_MESSAGE.SET_NAME('WMS', 'WMS_CARTONIZATION_ERROR');
7628: FND_MESSAGE.SET_TOKEN('ERROR_CODE', ERROR_CODE);
7629: FND_MSG_PUB.ADD;
7630: if (g_trace_on = 1) then log_event('Exception occurred from ERROR_CODE:'||error_code); END IF;
7631: fnd_msg_pub.count_and_get
7632: (
7633: p_count => x_msg_count,
7634: p_data => x_msg_data
7635: );
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;
7650: IF (g_trace_on = 1) THEN log_event('Exception occurred from ERROR_CODE:'||error_code); END IF;
7651:
7652: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error ) THEN
7653: fnd_msg_pub.add_exc_msg
7648: FND_MESSAGE.SET_TOKEN('ERROR_CODE', ERROR_CODE);
7649: FND_MSG_PUB.ADD;
7650: IF (g_trace_on = 1) THEN log_event('Exception occurred from ERROR_CODE:'||error_code); END IF;
7651:
7652: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error ) THEN
7653: fnd_msg_pub.add_exc_msg
7654: ( g_pkg_name,
7655: l_api_name,
7656: ERROR_MSG
7649: FND_MSG_PUB.ADD;
7650: IF (g_trace_on = 1) THEN log_event('Exception occurred from ERROR_CODE:'||error_code); END IF;
7651:
7652: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error ) THEN
7653: fnd_msg_pub.add_exc_msg
7654: ( g_pkg_name,
7655: l_api_name,
7656: ERROR_MSG
7657: );
7656: ERROR_MSG
7657: );
7658: END IF;
7659:
7660: fnd_msg_pub.count_and_get
7661: (
7662: p_count => x_msg_count,
7663: p_data => x_msg_data
7664: );