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.ASO_QUOTE_TMPL_PVT dependencies on FND_API

Line 18: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

14:
15:
16: PROCEDURE Add_Template_To_Quote(
17: P_API_VERSION_NUMBER IN NUMBER,
18: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
19: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
20: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
21: P_UPDATE_FLAG IN VARCHAR2 := 'Y',
22: P_TEMPLATE_ID_TBL IN ASO_QUOTE_TMPL_INT.LIST_TEMPLATE_TBL_TYPE,

Line 19: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

15:
16: PROCEDURE Add_Template_To_Quote(
17: P_API_VERSION_NUMBER IN NUMBER,
18: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
19: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
20: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
21: P_UPDATE_FLAG IN VARCHAR2 := 'Y',
22: P_TEMPLATE_ID_TBL IN ASO_QUOTE_TMPL_INT.LIST_TEMPLATE_TBL_TYPE,
23: P_QTE_HEADER_REC IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,

Line 20: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

16: PROCEDURE Add_Template_To_Quote(
17: P_API_VERSION_NUMBER IN NUMBER,
18: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
19: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
20: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
21: P_UPDATE_FLAG IN VARCHAR2 := 'Y',
22: P_TEMPLATE_ID_TBL IN ASO_QUOTE_TMPL_INT.LIST_TEMPLATE_TBL_TYPE,
23: P_QTE_HEADER_REC IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
24: P_CONTROL_REC IN ASO_QUOTE_PUB.CONTROL_REC_TYPE := ASO_QUOTE_PUB.G_MISS_control_REC,

Line 41: l_top_model_line_id NUMBER := FND_API.G_MISS_NUM;

37: L_API_VERSION CONSTANT NUMBER := 1.0;
38:
39: l_template_line_count NUMBER := 0;
40: l_conc_segments VARCHAR2(40);
41: l_top_model_line_id NUMBER := FND_API.G_MISS_NUM;
42: l_dropped_flag VARCHAR2(1) := 'N';
43: l_service_flag VARCHAR2(1) := 'N';
44: l_config_header_id NUMBER;
45: l_config_rev_number NUMBER;

Line 134: IF NOT FND_API.Compatible_API_Call(

130: aso_debug_pub.add('****** Start of Add_Template_To_Quote API ******', 1, 'Y');
131: END IF;
132:
133: -- Standard call to check for call compatibility.
134: IF NOT FND_API.Compatible_API_Call(
135: L_API_VERSION ,
136: P_API_VERSION_NUMBER,
137: L_API_NAME ,
138: G_PKG_NAME

Line 140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

136: P_API_VERSION_NUMBER,
137: L_API_NAME ,
138: G_PKG_NAME
139: ) THEN
140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
141: END IF;
142:
143: -- Initialize message list if p_init_msg_list is set to TRUE.
144: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 144: IF FND_API.To_Boolean(p_init_msg_list) THEN

140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
141: END IF;
142:
143: -- Initialize message list if p_init_msg_list is set to TRUE.
144: IF FND_API.To_Boolean(p_init_msg_list) THEN
145: FND_Msg_Pub.initialize;
146: END IF;
147:
148: -- Initialize API return status to success

Line 149: x_return_status := FND_API.G_RET_STS_SUCCESS;

145: FND_Msg_Pub.initialize;
146: END IF;
147:
148: -- Initialize API return status to success
149: x_return_status := FND_API.G_RET_STS_SUCCESS;
150:
151: -- API body
152: l_qte_header_rec := p_qte_header_rec;
153:

Line 154: IF (p_qte_header_rec.org_id is null or p_qte_header_rec.org_id = fnd_api.g_miss_num ) then

150:
151: -- API body
152: l_qte_header_rec := p_qte_header_rec;
153:
154: IF (p_qte_header_rec.org_id is null or p_qte_header_rec.org_id = fnd_api.g_miss_num ) then
155: IF aso_debug_pub.g_debug_flag = 'Y' THEN
156: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Input ogr_id is null or g_miss', 1, 'Y');
157: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: p_qte_header_rec.quote_header_id: ' || p_qte_header_rec.quote_header_id, 1, 'Y');
158: END IF;

Line 190: p_init_msg_list => FND_API.G_FALSE,

186: END IF;
187:
188: ASO_VALIDATE_PRICING_PVT.Validate_Pricing_Order(
189: p_api_version_number => 1.0,
190: p_init_msg_list => FND_API.G_FALSE,
191: p_commit => FND_API.G_FALSE,
192: p_control_rec => l_pricing_control_rec,
193: p_qte_header_rec => l_qte_header_rec,
194: p_qte_line_tbl => lp_qte_line_tbl,

Line 191: p_commit => FND_API.G_FALSE,

187:
188: ASO_VALIDATE_PRICING_PVT.Validate_Pricing_Order(
189: p_api_version_number => 1.0,
190: p_init_msg_list => FND_API.G_FALSE,
191: p_commit => FND_API.G_FALSE,
192: p_control_rec => l_pricing_control_rec,
193: p_qte_header_rec => l_qte_header_rec,
194: p_qte_line_tbl => lp_qte_line_tbl,
195: x_qte_header_rec => lpx_qte_header_rec,

Line 210: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

206: IF aso_debug_pub.g_debug_flag = 'Y' THEN
207: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: after Validate_Pricing_Order', 1, 'Y');
208: END IF;
209:
210: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
211: RAISE FND_API.G_EXC_ERROR;
212: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
214: END IF;

Line 211: RAISE FND_API.G_EXC_ERROR;

207: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: after Validate_Pricing_Order', 1, 'Y');
208: END IF;
209:
210: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
211: RAISE FND_API.G_EXC_ERROR;
212: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
214: END IF;
215:

Line 212: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

208: END IF;
209:
210: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
211: RAISE FND_API.G_EXC_ERROR;
212: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
214: END IF;
215:
216: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

209:
210: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
211: RAISE FND_API.G_EXC_ERROR;
212: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
214: END IF;
215:
216: IF aso_debug_pub.g_debug_flag = 'Y' THEN
217: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: start validated lines loop', 1, 'Y');

Line 221: IF lpx_qte_line_tbl(i).pricing_status_code <> FND_API.G_RET_STS_SUCCESS THEN

217: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: start validated lines loop', 1, 'Y');
218: END IF;
219:
220: FOR i IN 1..lpx_qte_line_tbl.count LOOP
221: IF lpx_qte_line_tbl(i).pricing_status_code <> FND_API.G_RET_STS_SUCCESS THEN
222: l_dropped_line_id_tbl(lpx_qte_line_tbl(i).quote_line_id) := lpx_qte_line_tbl(i).quote_line_id;
223:
224: FOR conc_segments_rec IN c_conc_segments(lpx_qte_line_tbl(i).inventory_item_id) LOOP
225: l_conc_segments := conc_segments_rec.concatenated_segments;

Line 342: IF (l_qte_line_dtl_tbl(j).config_header_id <> FND_API.G_MISS_NUM AND l_qte_line_dtl_tbl(j).config_header_id IS NOT NULL) AND

338: FOR i IN 1..l_qte_line_tbl.count LOOP
339: IF l_qte_line_tbl(i).item_type_code = 'MDL' THEN
340: FOR j IN 1..l_qte_line_dtl_tbl.count LOOP
341: IF l_qte_line_dtl_tbl(j).qte_line_index = i THEN
342: IF (l_qte_line_dtl_tbl(j).config_header_id <> FND_API.G_MISS_NUM AND l_qte_line_dtl_tbl(j).config_header_id IS NOT NULL) AND
343: (l_qte_line_dtl_tbl(j).config_revision_num <> FND_API.G_MISS_NUM AND l_qte_line_dtl_tbl(j).config_revision_num IS NOT NULL) THEN
344:
345: l_config_header_id := l_qte_line_dtl_tbl(j).config_header_id;
346: l_config_rev_number := l_qte_line_dtl_tbl(j).config_revision_num;

Line 343: (l_qte_line_dtl_tbl(j).config_revision_num <> FND_API.G_MISS_NUM AND l_qte_line_dtl_tbl(j).config_revision_num IS NOT NULL) THEN

339: IF l_qte_line_tbl(i).item_type_code = 'MDL' THEN
340: FOR j IN 1..l_qte_line_dtl_tbl.count LOOP
341: IF l_qte_line_dtl_tbl(j).qte_line_index = i THEN
342: IF (l_qte_line_dtl_tbl(j).config_header_id <> FND_API.G_MISS_NUM AND l_qte_line_dtl_tbl(j).config_header_id IS NOT NULL) AND
343: (l_qte_line_dtl_tbl(j).config_revision_num <> FND_API.G_MISS_NUM AND l_qte_line_dtl_tbl(j).config_revision_num IS NOT NULL) THEN
344:
345: l_config_header_id := l_qte_line_dtl_tbl(j).config_header_id;
346: l_config_rev_number := l_qte_line_dtl_tbl(j).config_revision_num;
347:

Line 368: p_init_msg_list => FND_API.G_FALSE,

364: );*/
365:
366: ASO_CFG_INT.Copy_Configuration(
367: p_api_version_number => 1.0,
368: p_init_msg_list => FND_API.G_FALSE,
369: p_commit => FND_API.G_FALSE,
370: p_config_header_id => l_config_header_id,
371: p_config_revision_num => l_config_rev_number,
372: p_copy_mode => CZ_API_PUB.G_NEW_HEADER_COPY_MODE,

Line 369: p_commit => FND_API.G_FALSE,

365:
366: ASO_CFG_INT.Copy_Configuration(
367: p_api_version_number => 1.0,
368: p_init_msg_list => FND_API.G_FALSE,
369: p_commit => FND_API.G_FALSE,
370: p_config_header_id => l_config_header_id,
371: p_config_revision_num => l_config_rev_number,
372: p_copy_mode => CZ_API_PUB.G_NEW_HEADER_COPY_MODE,
373: p_handle_deleted_flag => NULL,

Line 388: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

384: IF aso_debug_pub.g_debug_flag = 'Y' THEN
385: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: after Copy_Configuration', 1, 'Y');
386: END IF;
387:
388: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
389: RAISE FND_API.G_EXC_ERROR;
390: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
392: END IF;

Line 389: RAISE FND_API.G_EXC_ERROR;

385: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: after Copy_Configuration', 1, 'Y');
386: END IF;
387:
388: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
389: RAISE FND_API.G_EXC_ERROR;
390: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
392: END IF;
393:

Line 390: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

386: END IF;
387:
388: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
389: RAISE FND_API.G_EXC_ERROR;
390: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
392: END IF;
393:
394: -- Changes for Config item Id

Line 391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

387:
388: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
389: RAISE FND_API.G_EXC_ERROR;
390: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
392: END IF;
393:
394: -- Changes for Config item Id
395:

Line 424: l_qte_line_tbl(i).line_number := FND_API.G_MISS_NUM;

420:
421: l_qte_line_tbl(i).quote_header_id := p_qte_header_rec.quote_header_id;
422: l_qte_line_tbl(i).operation_code := 'CREATE';
423: l_qte_line_tbl(i).quote_line_id := NULL;
424: l_qte_line_tbl(i).line_number := FND_API.G_MISS_NUM;
425: END LOOP;
426:
427: -- Template Manager Changes
428: IF p_update_flag = 'N' THEN

Line 441: P_Init_Msg_List => FND_API.G_FALSE,

437: END IF;
438:
439: ASO_QUOTE_PUB.Update_Quote(
440: P_Api_Version_Number => 1.0,
441: P_Init_Msg_List => FND_API.G_FALSE,
442: P_Commit => FND_API.G_FALSE,
443: P_Control_Rec => p_control_rec,
444: P_Qte_Header_Rec => l_qte_header_rec,
445: P_Qte_Line_Tbl => l_qte_line_tbL,

Line 442: P_Commit => FND_API.G_FALSE,

438:
439: ASO_QUOTE_PUB.Update_Quote(
440: P_Api_Version_Number => 1.0,
441: P_Init_Msg_List => FND_API.G_FALSE,
442: P_Commit => FND_API.G_FALSE,
443: P_Control_Rec => p_control_rec,
444: P_Qte_Header_Rec => l_qte_header_rec,
445: P_Qte_Line_Tbl => l_qte_line_tbL,
446: P_Qte_Line_Dtl_Tbl => l_qte_line_dtl_tbl,

Line 474: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

470: IF aso_debug_pub.g_debug_flag = 'Y' THEN
471: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: after Update_Quote', 1, 'Y');
472: END IF;
473:
474: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
475: RAISE FND_API.G_EXC_ERROR;
476: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
478: END IF;

Line 475: RAISE FND_API.G_EXC_ERROR;

471: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: after Update_Quote', 1, 'Y');
472: END IF;
473:
474: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
475: RAISE FND_API.G_EXC_ERROR;
476: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
478: END IF;
479:

Line 476: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

472: END IF;
473:
474: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
475: RAISE FND_API.G_EXC_ERROR;
476: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
478: END IF;
479:
480: x_qte_line_tbl := ASO_QUOTE_PUB.G_Miss_Qte_Line_Tbl;

Line 477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

473:
474: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
475: RAISE FND_API.G_EXC_ERROR;
476: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
478: END IF;
479:
480: x_qte_line_tbl := ASO_QUOTE_PUB.G_Miss_Qte_Line_Tbl;
481: x_qte_line_tbl := ASO_UTILITY_PVT.Query_Qte_Line_Rows_sort(p_qte_header_rec.quote_header_id);

Line 508: IF x_qte_line_dtl_tbl(1).ref_line_id IS NOT NULL AND x_qte_line_dtl_tbl(1).ref_line_id <> FND_API.G_MISS_NUM THEN

504: end if;
505:
506:
507:
508: IF x_qte_line_dtl_tbl(1).ref_line_id IS NOT NULL AND x_qte_line_dtl_tbl(1).ref_line_id <> FND_API.G_MISS_NUM THEN
509: l_line_rltship_rec.OPERATION_CODE := 'CREATE';
510: l_line_rltship_rec.QUOTE_LINE_ID := x_qte_line_dtl_tbl(1).ref_line_id;
511: l_line_rltship_rec.RELATED_QUOTE_LINE_ID := x_qte_line_dtl_tbl(1).quote_line_id;
512: l_line_rltship_rec.RELATIONSHIP_TYPE_CODE := 'CONFIG';

Line 520: P_Init_Msg_List => FND_API.G_FALSE,

516: END IF;
517:
518: ASO_LINE_RLTSHIP_PVT.Create_Line_Rltship(
519: P_Api_Version_Number => 1.0,
520: P_Init_Msg_List => FND_API.G_FALSE,
521: P_Commit => FND_API.G_FALSE,
522: P_Validation_Level => p_validation_level,
523: P_Line_Rltship_Rec => l_line_rltship_rec,
524: X_LINE_RELATIONSHIP_ID => lx_line_relationship_id,

Line 521: P_Commit => FND_API.G_FALSE,

517:
518: ASO_LINE_RLTSHIP_PVT.Create_Line_Rltship(
519: P_Api_Version_Number => 1.0,
520: P_Init_Msg_List => FND_API.G_FALSE,
521: P_Commit => FND_API.G_FALSE,
522: P_Validation_Level => p_validation_level,
523: P_Line_Rltship_Rec => l_line_rltship_rec,
524: X_LINE_RELATIONSHIP_ID => lx_line_relationship_id,
525: X_Return_Status => x_return_status,

Line 534: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

530: IF aso_debug_pub.g_debug_flag = 'Y' THEN
531: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: after Create_Line_Rltship: lx_line_relationship_id: '||lx_line_relationship_id, 1, 'Y');
532: END IF;
533:
534: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
535: RAISE FND_API.G_EXC_ERROR;
536: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
538: END IF;

Line 535: RAISE FND_API.G_EXC_ERROR;

531: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: after Create_Line_Rltship: lx_line_relationship_id: '||lx_line_relationship_id, 1, 'Y');
532: END IF;
533:
534: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
535: RAISE FND_API.G_EXC_ERROR;
536: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
538: END IF;
539: END IF;

Line 536: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

532: END IF;
533:
534: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
535: RAISE FND_API.G_EXC_ERROR;
536: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
538: END IF;
539: END IF;
540: END IF;

Line 537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

533:
534: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
535: RAISE FND_API.G_EXC_ERROR;
536: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
538: END IF;
539: END IF;
540: END IF;
541: END LOOP;

Line 556: IF FND_API.To_Boolean(p_commit) THEN

552: aso_debug_pub.add('****** End of Add_Template_To_Quote API ******', 1, 'Y');
553: END IF;
554:
555: -- Standard check of p_commit
556: IF FND_API.To_Boolean(p_commit) THEN
557: COMMIT WORK;
558: END IF;
559:
560: -- Standard call to get message count and if count is 1, get message info

Line 562: p_encoded => FND_API.G_FALSE,

558: END IF;
559:
560: -- Standard call to get message count and if count is 1, get message info
561: FND_Msg_Pub.Count_And_Get(
562: p_encoded => FND_API.G_FALSE,
563: p_count => x_msg_count ,
564: p_data => x_msg_data
565: );
566:

Line 568: WHEN FND_API.G_EXC_ERROR THEN

564: p_data => x_msg_data
565: );
566:
567: EXCEPTION
568: WHEN FND_API.G_EXC_ERROR THEN
569: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
570: P_API_NAME => L_API_NAME,
571: P_PKG_NAME => G_PKG_NAME,
572: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 581: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

577: X_MSG_DATA => X_MSG_DATA,
578: X_RETURN_STATUS => X_RETURN_STATUS
579: );
580:
581: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
582: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
583: P_API_NAME => L_API_NAME,
584: P_PKG_NAME => G_PKG_NAME,
585: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,