37: p_nl_trackable_flag := 'FALSE';
38: END IF;
39: EXCEPTION
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;
38: END IF;
39: EXCEPTION
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:
39: EXCEPTION
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(
73: p_lot_control := 'FALSE';
74: END IF;
75: EXCEPTION
76: WHEN OTHERS THEN
77: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
78: fnd_message.set_token('ERR_MSG', sqlerrm);
79: l_err_text := fnd_message.get;
80: raise;
81: END check_lot_control;
74: END IF;
75: EXCEPTION
76: WHEN OTHERS THEN
77: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
78: fnd_message.set_token('ERR_MSG', sqlerrm);
79: l_err_text := fnd_message.get;
80: raise;
81: END check_lot_control;
82:
75: EXCEPTION
76: WHEN OTHERS THEN
77: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
78: fnd_message.set_token('ERR_MSG', sqlerrm);
79: l_err_text := fnd_message.get;
80: raise;
81: END check_lot_control;
82:
83: PROCEDURE check_serial_control(
111: EXCEPTION
112: WHEN NO_DATA_FOUND THEN
113: p_serial_control := 'FALSE';
114: WHEN OTHERS THEN
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);
112: WHEN NO_DATA_FOUND THEN
113: p_serial_control := 'FALSE';
114: WHEN OTHERS THEN
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;
113: p_serial_control := 'FALSE';
114: WHEN OTHERS THEN
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;
149: p_depreciable := 'FALSE';
150: END IF;
151: EXCEPTION
152: WHEN OTHERS THEN
153: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
154: fnd_message.set_token('ERR_MSG', sqlerrm);
155: l_err_text := fnd_message.get;
156: raise;
157: END check_depreciable_subinv;
150: END IF;
151: EXCEPTION
152: WHEN OTHERS THEN
153: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
154: fnd_message.set_token('ERR_MSG', sqlerrm);
155: l_err_text := fnd_message.get;
156: raise;
157: END check_depreciable_subinv;
158:
151: EXCEPTION
152: WHEN OTHERS THEN
153: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
154: fnd_message.set_token('ERR_MSG', sqlerrm);
155: l_err_text := fnd_message.get;
156: raise;
157: END check_depreciable_subinv;
158:
159: PROCEDURE get_asset_creation_code(
185: END IF;
186: CLOSE Asset_CC_Cur;
187: EXCEPTION
188: WHEN OTHERS THEN
189: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
190: fnd_message.set_token('ERR_MSG', sqlerrm);
191: l_err_text := fnd_message.get;
192: raise;
193: END get_asset_creation_code;
186: CLOSE Asset_CC_Cur;
187: EXCEPTION
188: WHEN OTHERS THEN
189: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
190: fnd_message.set_token('ERR_MSG', sqlerrm);
191: l_err_text := fnd_message.get;
192: raise;
193: END get_asset_creation_code;
194:
187: EXCEPTION
188: WHEN OTHERS THEN
189: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
190: fnd_message.set_token('ERR_MSG', sqlerrm);
191: l_err_text := fnd_message.get;
192: raise;
193: END get_asset_creation_code;
194:
195: PROCEDURE check_depreciable(
213: p_depreciable := 'Y';
214: END IF;
215: EXCEPTION
216: WHEN OTHERS THEN
217: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
218: fnd_message.set_token('ERR_MSG', sqlerrm);
219: l_err_text := fnd_message.get;
220: raise;
221: END check_depreciable;
214: END IF;
215: EXCEPTION
216: WHEN OTHERS THEN
217: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
218: fnd_message.set_token('ERR_MSG', sqlerrm);
219: l_err_text := fnd_message.get;
220: raise;
221: END check_depreciable;
222:
215: EXCEPTION
216: WHEN OTHERS THEN
217: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
218: fnd_message.set_token('ERR_MSG', sqlerrm);
219: l_err_text := fnd_message.get;
220: raise;
221: END check_depreciable;
222:
223: PROCEDURE get_combine_segments(
254: x_combine_segments := temp_segs;
255: EXCEPTION
256: WHEN DLT_NOT_FOUND THEN
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;
255: EXCEPTION
256: WHEN DLT_NOT_FOUND THEN
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;
263: x_Error_Message := l_err_text;
264: x_Return_Status := FND_API.G_RET_STS_ERROR;
265: -- return;
266: WHEN OTHERS THEN
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);
264: x_Return_Status := FND_API.G_RET_STS_ERROR;
265: -- return;
266: WHEN OTHERS THEN
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;
265: -- return;
266: WHEN OTHERS THEN
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;
309:
310: x_concat_segments := fnd_flex_ext.concatenate_segments(nsegs, segs, delimiter);
311: EXCEPTION
312: WHEN SEGS_NOT_FOUND THEN
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);
310: x_concat_segments := fnd_flex_ext.concatenate_segments(nsegs, segs, delimiter);
311: EXCEPTION
312: WHEN SEGS_NOT_FOUND THEN
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;
311: EXCEPTION
312: WHEN SEGS_NOT_FOUND THEN
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;
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
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;
319: x_Return_Status := FND_API.G_RET_STS_ERROR;
320: X_Error_Message :=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;
326: END IF;
327: x_Return_Status := FND_API.G_RET_STS_ERROR;
328: X_Error_Message :=l_err_text;
329: WHEN OTHERS THEN
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);
327: x_Return_Status := FND_API.G_RET_STS_ERROR;
328: X_Error_Message :=l_err_text;
329: WHEN OTHERS THEN
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;
328: X_Error_Message :=l_err_text;
329: WHEN OTHERS THEN
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;
557: EXCEPTION
558: WHEN e_Nothing THEN
559: NULL;
560: WHEN Multiple_Active_Exp THEN
561: fnd_message.set_name('CSE','CSE_MULTIPLE_ACT_INST_FOUND');
562: fnd_message.set_token('INV_ITEM',P_Dest_Instance_Tbl(1).INVENTORY_ITEM_ID);
563: x_error_message := fnd_message.get;
564: x_return_status :=FND_API.G_RET_STS_ERROR;
565: WHEN OTHERS THEN
558: WHEN e_Nothing THEN
559: NULL;
560: WHEN Multiple_Active_Exp THEN
561: fnd_message.set_name('CSE','CSE_MULTIPLE_ACT_INST_FOUND');
562: fnd_message.set_token('INV_ITEM',P_Dest_Instance_Tbl(1).INVENTORY_ITEM_ID);
563: x_error_message := fnd_message.get;
564: x_return_status :=FND_API.G_RET_STS_ERROR;
565: WHEN OTHERS THEN
566: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
559: NULL;
560: WHEN Multiple_Active_Exp THEN
561: fnd_message.set_name('CSE','CSE_MULTIPLE_ACT_INST_FOUND');
562: fnd_message.set_token('INV_ITEM',P_Dest_Instance_Tbl(1).INVENTORY_ITEM_ID);
563: x_error_message := fnd_message.get;
564: x_return_status :=FND_API.G_RET_STS_ERROR;
565: WHEN OTHERS THEN
566: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
567: fnd_message.set_token('API_NAME',l_api_name);
562: fnd_message.set_token('INV_ITEM',P_Dest_Instance_Tbl(1).INVENTORY_ITEM_ID);
563: x_error_message := fnd_message.get;
564: x_return_status :=FND_API.G_RET_STS_ERROR;
565: WHEN OTHERS THEN
566: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
567: fnd_message.set_token('API_NAME',l_api_name);
568: fnd_message.set_token('SQL_ERROR',SQLERRM);
569: x_error_message := fnd_message.get;
570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
563: x_error_message := fnd_message.get;
564: x_return_status :=FND_API.G_RET_STS_ERROR;
565: WHEN OTHERS THEN
566: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
567: fnd_message.set_token('API_NAME',l_api_name);
568: fnd_message.set_token('SQL_ERROR',SQLERRM);
569: x_error_message := fnd_message.get;
570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
571:
564: x_return_status :=FND_API.G_RET_STS_ERROR;
565: WHEN OTHERS THEN
566: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
567: fnd_message.set_token('API_NAME',l_api_name);
568: fnd_message.set_token('SQL_ERROR',SQLERRM);
569: x_error_message := fnd_message.get;
570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
571:
572: END get_destination_instance;
565: WHEN OTHERS THEN
566: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
567: fnd_message.set_token('API_NAME',l_api_name);
568: fnd_message.set_token('SQL_ERROR',SQLERRM);
569: x_error_message := fnd_message.get;
570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
571:
572: END get_destination_instance;
573:
603: END IF;
604:
605: EXCEPTION
606: WHEN hz_loc_not_found THEN
607: fnd_message.set_name('CSE','CSE_HZ_LOC_ID_NOTFOUND');
608: fnd_message.set_token('NETWORK_LOC_CODE',p_network_location_code);
609: x_error_message := fnd_message.get;
610: x_return_status :=FND_API.G_RET_STS_ERROR;
611: WHEN others THEN
604:
605: EXCEPTION
606: WHEN hz_loc_not_found THEN
607: fnd_message.set_name('CSE','CSE_HZ_LOC_ID_NOTFOUND');
608: fnd_message.set_token('NETWORK_LOC_CODE',p_network_location_code);
609: x_error_message := fnd_message.get;
610: x_return_status :=FND_API.G_RET_STS_ERROR;
611: WHEN others THEN
612: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
605: EXCEPTION
606: WHEN hz_loc_not_found THEN
607: fnd_message.set_name('CSE','CSE_HZ_LOC_ID_NOTFOUND');
608: fnd_message.set_token('NETWORK_LOC_CODE',p_network_location_code);
609: x_error_message := fnd_message.get;
610: x_return_status :=FND_API.G_RET_STS_ERROR;
611: WHEN others THEN
612: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
613: fnd_message.set_token('ERR_MSG',l_Api_Name||'='|| SQLERRM);
608: fnd_message.set_token('NETWORK_LOC_CODE',p_network_location_code);
609: x_error_message := fnd_message.get;
610: x_return_status :=FND_API.G_RET_STS_ERROR;
611: WHEN others THEN
612: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
613: fnd_message.set_token('ERR_MSG',l_Api_Name||'='|| SQLERRM);
614: x_error_message := fnd_message.get;
615: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
616:
609: x_error_message := fnd_message.get;
610: x_return_status :=FND_API.G_RET_STS_ERROR;
611: WHEN others THEN
612: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
613: fnd_message.set_token('ERR_MSG',l_Api_Name||'='|| SQLERRM);
614: x_error_message := fnd_message.get;
615: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
616:
617: END get_hz_location;
610: x_return_status :=FND_API.G_RET_STS_ERROR;
611: WHEN others THEN
612: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
613: fnd_message.set_token('ERR_MSG',l_Api_Name||'='|| SQLERRM);
614: x_error_message := fnd_message.get;
615: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
616:
617: END get_hz_location;
618:
648: END IF;
649:
650: EXCEPTION
651: WHEN hz_loc_not_found THEN
652: fnd_message.set_name('CSE','CSE_PARTY_SITE_NOTFOUND');
653: fnd_message.set_token('PARTY_SITE',p_party_site_id);
654: x_error_message := fnd_message.get;
655: x_return_status :=FND_API.G_RET_STS_ERROR;
656: WHEN others THEN
649:
650: EXCEPTION
651: WHEN hz_loc_not_found THEN
652: fnd_message.set_name('CSE','CSE_PARTY_SITE_NOTFOUND');
653: fnd_message.set_token('PARTY_SITE',p_party_site_id);
654: x_error_message := fnd_message.get;
655: x_return_status :=FND_API.G_RET_STS_ERROR;
656: WHEN others THEN
657: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
650: EXCEPTION
651: WHEN hz_loc_not_found THEN
652: fnd_message.set_name('CSE','CSE_PARTY_SITE_NOTFOUND');
653: fnd_message.set_token('PARTY_SITE',p_party_site_id);
654: x_error_message := fnd_message.get;
655: x_return_status :=FND_API.G_RET_STS_ERROR;
656: WHEN others THEN
657: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
658: fnd_message.set_token('ERR_MSG',l_Api_Name||'='|| SQLERRM);
653: fnd_message.set_token('PARTY_SITE',p_party_site_id);
654: x_error_message := fnd_message.get;
655: x_return_status :=FND_API.G_RET_STS_ERROR;
656: WHEN others THEN
657: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
658: fnd_message.set_token('ERR_MSG',l_Api_Name||'='|| SQLERRM);
659: x_error_message := fnd_message.get;
660: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
661:
654: x_error_message := fnd_message.get;
655: x_return_status :=FND_API.G_RET_STS_ERROR;
656: WHEN others THEN
657: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
658: fnd_message.set_token('ERR_MSG',l_Api_Name||'='|| SQLERRM);
659: x_error_message := fnd_message.get;
660: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
661:
662: END get_hz_location;
655: x_return_status :=FND_API.G_RET_STS_ERROR;
656: WHEN others THEN
657: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
658: fnd_message.set_token('ERR_MSG',l_Api_Name||'='|| SQLERRM);
659: x_error_message := fnd_message.get;
660: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
661:
662: END get_hz_location;
663:
693: END IF;
694:
695: EXCEPTION
696: WHEN fa_loc_not_found THEN
697: fnd_message.set_name('CSE','CSE_FA_LOC_ID_NOTFOUND');
698: fnd_message.set_token('HZ_LOCATION_ID',p_hz_location_id);
699: x_error_message := fnd_message.get;
700: x_return_status :=FND_API.G_RET_STS_ERROR;
701: WHEN others THEN
694:
695: EXCEPTION
696: WHEN fa_loc_not_found THEN
697: fnd_message.set_name('CSE','CSE_FA_LOC_ID_NOTFOUND');
698: fnd_message.set_token('HZ_LOCATION_ID',p_hz_location_id);
699: x_error_message := fnd_message.get;
700: x_return_status :=FND_API.G_RET_STS_ERROR;
701: WHEN others THEN
702: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
695: EXCEPTION
696: WHEN fa_loc_not_found THEN
697: fnd_message.set_name('CSE','CSE_FA_LOC_ID_NOTFOUND');
698: fnd_message.set_token('HZ_LOCATION_ID',p_hz_location_id);
699: x_error_message := fnd_message.get;
700: x_return_status :=FND_API.G_RET_STS_ERROR;
701: WHEN others THEN
702: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
703: fnd_message.set_token('ERR_MSG',l_Api_Name||'='|| SQLERRM);
698: fnd_message.set_token('HZ_LOCATION_ID',p_hz_location_id);
699: x_error_message := fnd_message.get;
700: x_return_status :=FND_API.G_RET_STS_ERROR;
701: WHEN others THEN
702: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
703: fnd_message.set_token('ERR_MSG',l_Api_Name||'='|| SQLERRM);
704: x_error_message := fnd_message.get;
705: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
706: END;
699: x_error_message := fnd_message.get;
700: x_return_status :=FND_API.G_RET_STS_ERROR;
701: WHEN others THEN
702: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
703: fnd_message.set_token('ERR_MSG',l_Api_Name||'='|| SQLERRM);
704: x_error_message := fnd_message.get;
705: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
706: END;
707:
700: x_return_status :=FND_API.G_RET_STS_ERROR;
701: WHEN others THEN
702: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
703: fnd_message.set_token('ERR_MSG',l_Api_Name||'='|| SQLERRM);
704: x_error_message := fnd_message.get;
705: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
706: END;
707:
708: PROCEDURE get_master_organization(p_organization_id IN NUMBER,
752: END IF;
753:
754: EXCEPTION
755: WHEN e_procedure_error THEN
756: fnd_message.set_name('CSE','CSE_MSTR_ORG_NOTFOUND');
757: fnd_message.set_token('ORGANIZATION_ID',p_organization_id);
758: fnd_message.set_token('ORGANIZATION_CODE',l_org_code);
759: x_error_message := fnd_message.get;
760: x_return_status := l_fnd_error;
753:
754: EXCEPTION
755: WHEN e_procedure_error THEN
756: fnd_message.set_name('CSE','CSE_MSTR_ORG_NOTFOUND');
757: fnd_message.set_token('ORGANIZATION_ID',p_organization_id);
758: fnd_message.set_token('ORGANIZATION_CODE',l_org_code);
759: x_error_message := fnd_message.get;
760: x_return_status := l_fnd_error;
761:
754: EXCEPTION
755: WHEN e_procedure_error THEN
756: fnd_message.set_name('CSE','CSE_MSTR_ORG_NOTFOUND');
757: fnd_message.set_token('ORGANIZATION_ID',p_organization_id);
758: fnd_message.set_token('ORGANIZATION_CODE',l_org_code);
759: x_error_message := fnd_message.get;
760: x_return_status := l_fnd_error;
761:
762: WHEN others THEN
755: WHEN e_procedure_error THEN
756: fnd_message.set_name('CSE','CSE_MSTR_ORG_NOTFOUND');
757: fnd_message.set_token('ORGANIZATION_ID',p_organization_id);
758: fnd_message.set_token('ORGANIZATION_CODE',l_org_code);
759: x_error_message := fnd_message.get;
760: x_return_status := l_fnd_error;
761:
762: WHEN others THEN
763: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
759: x_error_message := fnd_message.get;
760: x_return_status := l_fnd_error;
761:
762: WHEN others THEN
763: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
764: fnd_message.set_token('SQL_ERROR',SQLERRM);
765: x_error_message := fnd_message.get;
766: x_return_status := l_fnd_unexpected;
767: END get_master_organization;
760: x_return_status := l_fnd_error;
761:
762: WHEN others THEN
763: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
764: fnd_message.set_token('SQL_ERROR',SQLERRM);
765: x_error_message := fnd_message.get;
766: x_return_status := l_fnd_unexpected;
767: END get_master_organization;
768:
761:
762: WHEN others THEN
763: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
764: fnd_message.set_token('SQL_ERROR',SQLERRM);
765: x_error_message := fnd_message.get;
766: x_return_status := l_fnd_unexpected;
767: END get_master_organization;
768:
769: PROCEDURE build_error_string (
1264: WHEN OTHERS THEN
1265: IF check_top_assembly%ISOPEN
1266: THEN CLOSE check_top_assembly;
1267: END IF;
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);
1265: IF check_top_assembly%ISOPEN
1266: THEN CLOSE check_top_assembly;
1267: END IF;
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;
1267: END IF;
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: ------------------------------------------------------------------------------