DBA Data[Home] [Help]

APPS.CSE_UTIL_PKG dependencies on FND_MESSAGE

Line 41: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');

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;

Line 42: fnd_message.set_token('ERR_MSG', sqlerrm);

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:

Line 43: l_err_text := fnd_message.get;

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(

Line 77: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');

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;

Line 78: fnd_message.set_token('ERR_MSG', sqlerrm);

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:

Line 79: l_err_text := fnd_message.get;

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(

Line 115: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');

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);

Line 116: fnd_message.set_token('ERR_MSG', sqlerrm);

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;

Line 117: l_err_text := fnd_message.get;

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;

Line 153: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');

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;

Line 154: fnd_message.set_token('ERR_MSG', sqlerrm);

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:

Line 155: l_err_text := fnd_message.get;

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(

Line 189: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');

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;

Line 190: fnd_message.set_token('ERR_MSG', sqlerrm);

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:

Line 191: l_err_text := fnd_message.get;

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(

Line 217: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');

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;

Line 218: fnd_message.set_token('ERR_MSG', sqlerrm);

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:

Line 219: l_err_text := fnd_message.get;

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(

Line 258: fnd_message.set_name('CSE', 'CSE_DELIMITER_NOT_FOUND');

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;

Line 259: l_err_text := fnd_message.get;

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;

Line 267: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');

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);

Line 268: fnd_message.set_token('ERR_MSG', sqlerrm);

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;

Line 269: l_err_text := fnd_message.get;

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;

Line 313: fnd_message.set_name('CSE', 'CSE_FLEX_SEGMENTS_NOT_FOUND');

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);

Line 314: fnd_message.set_token('COMBINATION_ID',P_Combination_Id);

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;

Line 315: l_err_text := fnd_message.get;

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;

Line 322: fnd_message.set_name('CSE', 'CSE_DELIMITER_NOT_FOUND');

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;

Line 323: l_err_text := fnd_message.get;

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;

Line 330: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');

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);

Line 331: fnd_message.set_token('ERR_MSG', sqlerrm);

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;

Line 332: l_err_text := fnd_message.get;

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;

Line 561: fnd_message.set_name('CSE','CSE_MULTIPLE_ACT_INST_FOUND');

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

Line 562: fnd_message.set_token('INV_ITEM',P_Dest_Instance_Tbl(1).INVENTORY_ITEM_ID);

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');

Line 563: x_error_message := fnd_message.get;

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);

Line 566: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');

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;

Line 567: fnd_message.set_token('API_NAME',l_api_name);

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:

Line 568: fnd_message.set_token('SQL_ERROR',SQLERRM);

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;

Line 569: x_error_message := fnd_message.get;

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:

Line 607: fnd_message.set_name('CSE','CSE_HZ_LOC_ID_NOTFOUND');

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

Line 608: fnd_message.set_token('NETWORK_LOC_CODE',p_network_location_code);

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');

Line 609: x_error_message := fnd_message.get;

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);

Line 612: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');

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:

Line 613: fnd_message.set_token('ERR_MSG',l_Api_Name||'='|| SQLERRM);

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;

Line 614: 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;
618:

Line 652: fnd_message.set_name('CSE','CSE_PARTY_SITE_NOTFOUND');

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

Line 653: fnd_message.set_token('PARTY_SITE',p_party_site_id);

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');

Line 654: x_error_message := fnd_message.get;

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);

Line 657: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');

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:

Line 658: fnd_message.set_token('ERR_MSG',l_Api_Name||'='|| SQLERRM);

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;

Line 659: 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;
663:

Line 697: fnd_message.set_name('CSE','CSE_FA_LOC_ID_NOTFOUND');

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

Line 698: fnd_message.set_token('HZ_LOCATION_ID',p_hz_location_id);

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');

Line 699: x_error_message := fnd_message.get;

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);

Line 702: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');

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;

Line 703: fnd_message.set_token('ERR_MSG',l_Api_Name||'='|| SQLERRM);

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:

Line 704: 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:
708: PROCEDURE get_master_organization(p_organization_id IN NUMBER,

Line 756: fnd_message.set_name('CSE','CSE_MSTR_ORG_NOTFOUND');

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;

Line 757: fnd_message.set_token('ORGANIZATION_ID',p_organization_id);

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:

Line 758: fnd_message.set_token('ORGANIZATION_CODE',l_org_code);

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

Line 759: x_error_message := fnd_message.get;

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');

Line 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;

Line 764: fnd_message.set_token('SQL_ERROR',SQLERRM);

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:

Line 765: x_error_message := fnd_message.get;

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 (

Line 1268: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');

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);

Line 1269: fnd_message.set_token('ERR_MSG', sqlerrm);

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;

Line 1271: x_error_message := fnd_message.get;

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: ------------------------------------------------------------------------------