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.CSE_UTIL_PKG dependencies on CSE_UTIL_PKG

Line 1: PACKAGE BODY CSE_UTIL_PKG as

1: PACKAGE BODY CSE_UTIL_PKG as
2: -- $Header: CSEUTILB.pls 120.11 2006/05/31 07:30:59 brmanesh ship $
3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('CSE_DEBUG_OPTION'),'N');
5:

Line 44: -- CSE_DEBUG_PUB.ADD('API CSE_UTIL_PKG.check_nl_trackable other exception: ' || l_err_text);

40: WHEN OTHERS THEN
41: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
42: fnd_message.set_token('ERR_MSG', sqlerrm);
43: l_err_text := fnd_message.get;
44: -- CSE_DEBUG_PUB.ADD('API CSE_UTIL_PKG.check_nl_trackable other exception: ' || l_err_text);
45: END check_item_trackable;
46:
47: PROCEDURE check_lot_control(
48: p_inventory_item_id IN NUMBER,

Line 119: cse_debug_pub.add('API CSE_UTIL_PKG.check_serial_control other exception: ' || l_err_text);

115: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
116: fnd_message.set_token('ERR_MSG', sqlerrm);
117: l_err_text := fnd_message.get;
118: IF (l_debug = 'Y') THEN
119: cse_debug_pub.add('API CSE_UTIL_PKG.check_serial_control other exception: ' || l_err_text);
120: END IF;
121: raise;
122: END check_serial_control;
123:

Line 205: CSE_UTIL_PKG.Get_Asset_Creation_Code(

201: -- variable_name datatype NOT NULL DEFAULT default_value ;
202: l_asset_creation_code VARCHAR2(1);
203: l_err_text VARCHAR2(2000);
204: BEGIN
205: CSE_UTIL_PKG.Get_Asset_Creation_Code(
206: p_inventory_item_id,
207: l_asset_creation_code);
208: IF l_asset_creation_code NOT IN ('1','Y') OR
209: l_asset_creation_code IS NULL

Line 261: cse_debug_pub.add('API CSE_UTIL_PKG.get_combine_segments Exception: ' || l_err_text);

257:
258: fnd_message.set_name('CSE', 'CSE_DELIMITER_NOT_FOUND');
259: l_err_text := fnd_message.get;
260: IF (l_debug = 'Y') THEN
261: cse_debug_pub.add('API CSE_UTIL_PKG.get_combine_segments Exception: ' || l_err_text);
262: END IF;
263: x_Error_Message := l_err_text;
264: x_Return_Status := FND_API.G_RET_STS_ERROR;
265: -- return;

Line 271: cse_debug_pub.add('API CSE_UTIL_PKG.get_combine_segments other exception: ' || l_err_text);

267: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
268: fnd_message.set_token('ERR_MSG', sqlerrm);
269: l_err_text := fnd_message.get;
270: IF (l_debug = 'Y') THEN
271: cse_debug_pub.add('API CSE_UTIL_PKG.get_combine_segments other exception: ' || l_err_text);
272: END IF;
273: x_Error_Message :=l_err_text;
274: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
275: END get_combine_segments;

Line 317: cse_debug_pub.add('API CSE_UTIL_PKG.get_combine_segments Exception: ' || l_err_text);

313: fnd_message.set_name('CSE', 'CSE_FLEX_SEGMENTS_NOT_FOUND');
314: fnd_message.set_token('COMBINATION_ID',P_Combination_Id);
315: l_err_text := fnd_message.get;
316: IF (l_debug = 'Y') THEN
317: cse_debug_pub.add('API CSE_UTIL_PKG.get_combine_segments Exception: ' || l_err_text);
318: END IF;
319: x_Return_Status := FND_API.G_RET_STS_ERROR;
320: X_Error_Message :=l_err_text;
321: WHEN DLT_NOT_FOUND THEN

Line 325: cse_debug_pub.add('API CSE_UTIL_PKG.get_combine_segments Exception: ' || l_err_text);

321: WHEN DLT_NOT_FOUND THEN
322: fnd_message.set_name('CSE', 'CSE_DELIMITER_NOT_FOUND');
323: l_err_text := fnd_message.get;
324: IF (l_debug = 'Y') THEN
325: cse_debug_pub.add('API CSE_UTIL_PKG.get_combine_segments Exception: ' || l_err_text);
326: END IF;
327: x_Return_Status := FND_API.G_RET_STS_ERROR;
328: X_Error_Message :=l_err_text;
329: WHEN OTHERS THEN

Line 334: cse_debug_pub.add('API CSE_UTIL_PKG.get_combine_segments other exception: ' || l_err_text);

330: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
331: fnd_message.set_token('ERR_MSG', sqlerrm);
332: l_err_text := fnd_message.get;
333: IF (l_debug = 'Y') THEN
334: cse_debug_pub.add('API CSE_UTIL_PKG.get_combine_segments other exception: ' || l_err_text);
335: END IF;
336: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
337: X_Error_Message :=l_err_text;
338: END get_concat_segments;

Line 346: IF (CSE_UTIL_PKG.x_cse_install is NULL)

342: l_eib_installed VARCHAR2(1) := 'N' ;
343: dummy VARCHAR2(40);
344: ret BOOLEAN;
345: BEGIN
346: IF (CSE_UTIL_PKG.x_cse_install is NULL)
347: THEN
348: ret := fnd_installation.get_app_info('CSE',
349: CSE_UTIL_PKG.x_cse_install, dummy, dummy);
350: END IF;

Line 349: CSE_UTIL_PKG.x_cse_install, dummy, dummy);

345: BEGIN
346: IF (CSE_UTIL_PKG.x_cse_install is NULL)
347: THEN
348: ret := fnd_installation.get_app_info('CSE',
349: CSE_UTIL_PKG.x_cse_install, dummy, dummy);
350: END IF;
351:
352: IF (CSE_UTIL_PKG.x_cse_install = 'I')
353: THEN

Line 352: IF (CSE_UTIL_PKG.x_cse_install = 'I')

348: ret := fnd_installation.get_app_info('CSE',
349: CSE_UTIL_PKG.x_cse_install, dummy, dummy);
350: END IF;
351:
352: IF (CSE_UTIL_PKG.x_cse_install = 'I')
353: THEN
354: l_eib_installed := 'Y';
355: ELSE
356: l_eib_installed := 'N';

Line 412: l_Api_Name CONSTANT VARCHAR2(50) :='CSE_UTIL_PKG.GET_DESTINATION_INSTANCE';

408: X_Instance_Rec OUT NOCOPY csi_datastructures_pub.Instance_Rec,
409: X_Return_Status OUT NOCOPY VARCHAR2,
410: X_Error_Message OUT NOCOPY VARCHAR2) IS
411:
412: l_Api_Name CONSTANT VARCHAR2(50) :='CSE_UTIL_PKG.GET_DESTINATION_INSTANCE';
413: l_Active_Rec_Count NUMBER:=0;
414: l_Zero_Exp_Rec_Count NUMBER:=0;
415: l_Point_Active_Rec VARCHAR2(1) DEFAULT FND_API.G_FALSE;
416: l_Point_Zero_Exp_Rec VARCHAR2(1) DEFAULT FND_API.G_FALSE;

Line 1272: -- CSE_DEBUG_PUB.ADD('API CSE_UTIL_PKG.check_top_assembly others exception: ' || l_err_text);

1268: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
1269: fnd_message.set_token('ERR_MSG', sqlerrm);
1270: x_return_status := fnd_api.g_ret_sts_unexp_error;
1271: x_error_message := fnd_message.get;
1272: -- CSE_DEBUG_PUB.ADD('API CSE_UTIL_PKG.check_top_assembly others exception: ' || l_err_text);
1273: END check_if_top_assembly;
1274:
1275: ------------------------------------------------------------------------------
1276: ---

Line 1378: cse_util_pkg.write_log('Call get item instance details');

1374: l_instance_rec.instance_id := p_instance_id ;
1375: i:= 0;
1376: j := 0;
1377: k := 0;
1378: cse_util_pkg.write_log('Call get item instance details');
1379: csi_item_instance_pub.get_item_instance_details(
1380: p_api_version => l_api_version,
1381: p_commit => l_commit,
1382: p_init_msg_list => l_init_msg_list,

Line 1404: cse_util_pkg.write_log('Return Status : '|| l_return_status);

1400: x_return_status => l_return_status,
1401: x_msg_count => l_Msg_Count,
1402: x_msg_data => l_Msg_Data );
1403:
1404: cse_util_pkg.write_log('Return Status : '|| l_return_status);
1405:
1406:
1407: IF l_return_status = fnd_api.g_ret_sts_error
1408: THEN

Line 1420: cse_util_pkg.write_log('Instance Rec after calling get inst dtls :'||l_instance_rec.instance_id);

1416: END LOOP;
1417: RAISE e_error;
1418: END IF ;
1419: ---Populate Instnace Details table with objcet(top assembly) instance details
1420: cse_util_pkg.write_log('Instance Rec after calling get inst dtls :'||l_instance_rec.instance_id);
1421: i:= 1;
1422: x_inst_dtls_tbl(i) := l_instance_rec ;
1423:
1424: cse_util_pkg.write_log('Count :' || x_inst_dtls_tbl.COUNT);

Line 1424: cse_util_pkg.write_log('Count :' || x_inst_dtls_tbl.COUNT);

1420: cse_util_pkg.write_log('Instance Rec after calling get inst dtls :'||l_instance_rec.instance_id);
1421: i:= 1;
1422: x_inst_dtls_tbl(i) := l_instance_rec ;
1423:
1424: cse_util_pkg.write_log('Count :' || x_inst_dtls_tbl.COUNT);
1425: l_relationship_query_rec.object_id := p_instance_id ;
1426: l_relationship_query_rec.relationship_type_code := 'COMPONENT-OF';
1427:
1428: csi_ii_relationships_pub.get_relationships(

Line 1508: cse_util_pkg.write_log(' Instance ID : '|| x_inst_dtls_tbl(k).instance_id);

1504: END IF ; --l_ii_relationship_tbl.COUNT > 0
1505:
1506: FOR k IN x_inst_dtls_tbl.FIRST .. x_inst_dtls_tbl.LAST
1507: LOOP
1508: cse_util_pkg.write_log(' Instance ID : '|| x_inst_dtls_tbl(k).instance_id);
1509: cse_util_pkg.write_log(' Item ID : '|| x_inst_dtls_tbl(k).inventory_item_id);
1510: cse_util_pkg.write_log(' Location ID : ' || x_inst_dtls_tbl(k).location_id);
1511: cse_util_pkg.write_log(' Location Type Code : '|| x_inst_dtls_tbl(k).location_type_code);
1512: END LOOP ;

Line 1509: cse_util_pkg.write_log(' Item ID : '|| x_inst_dtls_tbl(k).inventory_item_id);

1505:
1506: FOR k IN x_inst_dtls_tbl.FIRST .. x_inst_dtls_tbl.LAST
1507: LOOP
1508: cse_util_pkg.write_log(' Instance ID : '|| x_inst_dtls_tbl(k).instance_id);
1509: cse_util_pkg.write_log(' Item ID : '|| x_inst_dtls_tbl(k).inventory_item_id);
1510: cse_util_pkg.write_log(' Location ID : ' || x_inst_dtls_tbl(k).location_id);
1511: cse_util_pkg.write_log(' Location Type Code : '|| x_inst_dtls_tbl(k).location_type_code);
1512: END LOOP ;
1513:

Line 1510: cse_util_pkg.write_log(' Location ID : ' || x_inst_dtls_tbl(k).location_id);

1506: FOR k IN x_inst_dtls_tbl.FIRST .. x_inst_dtls_tbl.LAST
1507: LOOP
1508: cse_util_pkg.write_log(' Instance ID : '|| x_inst_dtls_tbl(k).instance_id);
1509: cse_util_pkg.write_log(' Item ID : '|| x_inst_dtls_tbl(k).inventory_item_id);
1510: cse_util_pkg.write_log(' Location ID : ' || x_inst_dtls_tbl(k).location_id);
1511: cse_util_pkg.write_log(' Location Type Code : '|| x_inst_dtls_tbl(k).location_type_code);
1512: END LOOP ;
1513:
1514: EXCEPTION

Line 1511: cse_util_pkg.write_log(' Location Type Code : '|| x_inst_dtls_tbl(k).location_type_code);

1507: LOOP
1508: cse_util_pkg.write_log(' Instance ID : '|| x_inst_dtls_tbl(k).instance_id);
1509: cse_util_pkg.write_log(' Item ID : '|| x_inst_dtls_tbl(k).inventory_item_id);
1510: cse_util_pkg.write_log(' Location ID : ' || x_inst_dtls_tbl(k).location_id);
1511: cse_util_pkg.write_log(' Location Type Code : '|| x_inst_dtls_tbl(k).location_type_code);
1512: END LOOP ;
1513:
1514: EXCEPTION
1515: WHEN e_error THEN

Line 1518: cse_util_pkg.write_log('In error :'||substr(x_error_message,1,200));

1514: EXCEPTION
1515: WHEN e_error THEN
1516: x_return_status := fnd_api.G_RET_STS_ERROR ;
1517: x_error_message := l_error_message ;
1518: cse_util_pkg.write_log('In error :'||substr(x_error_message,1,200));
1519: WHEN OTHERS THEN
1520: x_return_status := fnd_api.G_RET_STS_ERROR ;
1521: x_error_message := SQLERRM ;
1522: cse_util_pkg.write_log('In other exception :'||x_error_message);

Line 1522: cse_util_pkg.write_log('In other exception :'||x_error_message);

1518: cse_util_pkg.write_log('In error :'||substr(x_error_message,1,200));
1519: WHEN OTHERS THEN
1520: x_return_status := fnd_api.G_RET_STS_ERROR ;
1521: x_error_message := SQLERRM ;
1522: cse_util_pkg.write_log('In other exception :'||x_error_message);
1523: END get_inst_n_comp_dtls ;
1524:
1525:
1526:

Line 1579: END CSE_UTIL_PKG;

1575:
1576:
1577: ------------------------------------------------------------------------------
1578:
1579: END CSE_UTIL_PKG;