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_CONC_REQ_INT dependencies on FND_API

Line 8: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

4: G_PKG_NAME CONSTANT VARCHAR2 (30):= 'ASO_CONC_REQ_INT';
5:
6: Procedure Submit_price_tax_req(
7: P_Api_Version_Number IN NUMBER,
8: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
9: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
10: p_control_rec IN ASO_QUOTE_PUB.Control_Rec_Type :=ASO_QUOTE_PUB.G_Miss_Control_Rec,
11: x_request_id OUT NOCOPY /* file.sql.39 change */ Number,
12: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 94: IF NOT FND_API.Compatible_API_Call(

90:
91: savepoint Submit_price_tax_req_INT;
92:
93: -- Standard call to check for call compatibility.
94: IF NOT FND_API.Compatible_API_Call(
95: L_API_VERSION ,
96: P_API_VERSION_NUMBER,
97: L_API_NAME ,
98: G_PKG_NAME

Line 100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

96: P_API_VERSION_NUMBER,
97: L_API_NAME ,
98: G_PKG_NAME
99: ) THEN
100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
101: END IF;
102:
103: -- Initialize message list if p_init_msg_list is set to TRUE.
104: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 104: IF FND_API.To_Boolean(p_init_msg_list) THEN

100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
101: END IF;
102:
103: -- Initialize message list if p_init_msg_list is set to TRUE.
104: IF FND_API.To_Boolean(p_init_msg_list) THEN
105: FND_Msg_Pub.initialize;
106: END IF;
107:
108:

Line 109: x_return_status := FND_API.G_RET_STS_SUCCESS;

105: FND_Msg_Pub.initialize;
106: END IF;
107:
108:
109: x_return_status := FND_API.G_RET_STS_SUCCESS;
110:
111: x_msg_count := 0;
112:
113: /*******************************************************

Line 121: if (x_status = FND_API.G_TRUE) then

117: Lock_Exists(
118: p_quote_header_id => p_qte_header_rec.quote_header_id,
119: x_status => x_status);
120:
121: if (x_status = FND_API.G_TRUE) then
122: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
123: FND_MESSAGE.Set_Name('ASO', 'ASO_CONC_REQUEST_RUNNING');
124: FND_MSG_PUB.ADD;
125: END IF;

Line 127: raise FND_API.G_EXC_ERROR;

123: FND_MESSAGE.Set_Name('ASO', 'ASO_CONC_REQUEST_RUNNING');
124: FND_MSG_PUB.ADD;
125: END IF;
126:
127: raise FND_API.G_EXC_ERROR;
128: end if;
129:
130: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
131: aso_debug_pub.add('ASO_CONC_REQ: Submit_request:quote_header_id:'|| p_qte_header_rec.quote_header_id,1,'N');

Line 149: If ((p_control_rec.header_pricing_event = null) or (p_control_rec.header_pricing_event = FND_API.G_MISS_CHAR)) then

145: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: pricing status indicator:'|| p_qte_header_rec.Pricing_status_indicator,1,'N');
146: aso_debug_pub.add('ASO_CONC_REQ: Submit_request: tax status indicator:'|| p_qte_header_rec.tax_status_indicator,1,'N');
147: END IF;
148:
149: If ((p_control_rec.header_pricing_event = null) or (p_control_rec.header_pricing_event = FND_API.G_MISS_CHAR)) then
150: l_header_pricing_event := ' ';
151: else
152: l_header_pricing_event := p_control_rec.header_pricing_event;
153: end if;

Line 155: If ((p_control_rec.pricing_request_type = null) or (p_control_rec.pricing_request_type = FND_API.G_MISS_CHAR)) then

151: else
152: l_header_pricing_event := p_control_rec.header_pricing_event;
153: end if;
154:
155: If ((p_control_rec.pricing_request_type = null) or (p_control_rec.pricing_request_type = FND_API.G_MISS_CHAR)) then
156: l_pricing_request_type := ' ';
157: else
158: l_pricing_request_type := p_control_rec.pricing_request_type;
159: end if;

Line 161: If ((p_control_rec.CALCULATE_TAX_FLAG = null) or (p_control_rec.CALCULATE_TAX_FLAG = FND_API.G_MISS_CHAR)) then

157: else
158: l_pricing_request_type := p_control_rec.pricing_request_type;
159: end if;
160:
161: If ((p_control_rec.CALCULATE_TAX_FLAG = null) or (p_control_rec.CALCULATE_TAX_FLAG = FND_API.G_MISS_CHAR)) then
162: l_CALCULATE_TAX_FLAG := ' ';
163: else
164: l_CALCULATE_TAX_FLAG := p_control_rec.CALCULATE_TAX_FLAG;
165: end if;

Line 167: If ((p_control_rec.calculate_freight_charge_flag = null) or (p_control_rec.calculate_freight_charge_flag = FND_API.G_MISS_CHAR)) then

163: else
164: l_CALCULATE_TAX_FLAG := p_control_rec.CALCULATE_TAX_FLAG;
165: end if;
166:
167: If ((p_control_rec.calculate_freight_charge_flag = null) or (p_control_rec.calculate_freight_charge_flag = FND_API.G_MISS_CHAR)) then
168: l_calc_freight_charge_flag := ' ';
169: else
170: l_calc_freight_charge_flag := p_control_rec.calculate_freight_charge_flag;
171: end if;

Line 173: If ((p_control_rec.auto_version_flag = null) or (p_control_rec.auto_version_flag = FND_API.G_MISS_CHAR)) then

169: else
170: l_calc_freight_charge_flag := p_control_rec.calculate_freight_charge_flag;
171: end if;
172:
173: If ((p_control_rec.auto_version_flag = null) or (p_control_rec.auto_version_flag = FND_API.G_MISS_CHAR)) then
174: l_auto_version_flag := ' ';
175: else
176: l_auto_version_flag := p_control_rec.auto_version_flag;
177: end if;

Line 179: If ((p_control_rec.copy_task_flag = null) or (p_control_rec.copy_task_flag = FND_API.G_MISS_CHAR)) then

175: else
176: l_auto_version_flag := p_control_rec.auto_version_flag;
177: end if;
178:
179: If ((p_control_rec.copy_task_flag = null) or (p_control_rec.copy_task_flag = FND_API.G_MISS_CHAR)) then
180: l_copy_task_flag := ' ';
181: else
182: l_copy_task_flag := p_control_rec.copy_task_flag;
183: end if;

Line 185: If ((p_control_rec.copy_notes_flag = null) or (p_control_rec.copy_notes_flag = FND_API.G_MISS_CHAR)) then

181: else
182: l_copy_task_flag := p_control_rec.copy_task_flag;
183: end if;
184:
185: If ((p_control_rec.copy_notes_flag = null) or (p_control_rec.copy_notes_flag = FND_API.G_MISS_CHAR)) then
186: l_copy_notes_flag := ' ';
187: else
188: l_copy_notes_flag := p_control_rec.copy_notes_flag ;
189: end if;

Line 191: If ((p_control_rec.copy_att_flag = null) or (p_control_rec.copy_att_flag = FND_API.G_MISS_CHAR)) then

187: else
188: l_copy_notes_flag := p_control_rec.copy_notes_flag ;
189: end if;
190:
191: If ((p_control_rec.copy_att_flag = null) or (p_control_rec.copy_att_flag = FND_API.G_MISS_CHAR)) then
192: l_copy_att_flag := ' ';
193: else
194: l_copy_att_flag := p_control_rec.copy_att_flag;
195: end if;

Line 198: If ((p_control_rec.DEPENDENCY_FLAG is NULL ) or (p_control_rec.DEPENDENCY_FLAG = FND_API.G_MISS_CHAR)) then

194: l_copy_att_flag := p_control_rec.copy_att_flag;
195: end if;
196:
197: --Defaulting Framework changes
198: If ((p_control_rec.DEPENDENCY_FLAG is NULL ) or (p_control_rec.DEPENDENCY_FLAG = FND_API.G_MISS_CHAR)) then
199: l_DEPENDENCY_FLAG := ' ';
200: else
201: l_DEPENDENCY_FLAG := p_control_rec.DEPENDENCY_FLAG;
202: End If;

Line 204: If ((p_control_rec.DEFAULTING_FLAG IS NULL) or (p_control_rec.DEFAULTING_FLAG = FND_API.G_MISS_CHAR)) then

200: else
201: l_DEPENDENCY_FLAG := p_control_rec.DEPENDENCY_FLAG;
202: End If;
203:
204: If ((p_control_rec.DEFAULTING_FLAG IS NULL) or (p_control_rec.DEFAULTING_FLAG = FND_API.G_MISS_CHAR)) then
205: l_DEFAULTING_FLAG := ' ';
206: else
207: l_DEFAULTING_FLAG := p_control_rec.DEFAULTING_FLAG;
208: End If;

Line 210: If ((p_control_rec.DEFAULTING_FWK_FLAG IS NULL) or (p_control_rec.DEFAULTING_FWK_FLAG = FND_API.G_MISS_CHAR)) then

206: else
207: l_DEFAULTING_FLAG := p_control_rec.DEFAULTING_FLAG;
208: End If;
209:
210: If ((p_control_rec.DEFAULTING_FWK_FLAG IS NULL) or (p_control_rec.DEFAULTING_FWK_FLAG = FND_API.G_MISS_CHAR)) then
211: l_DEFAULTING_FWK_FLAG := ' ';
212: else
213: l_DEFAULTING_FWK_FLAG := p_control_rec.DEFAULTING_FWK_FLAG;
214: End If;

Line 216: If ((p_control_rec.APPLICATION_TYPE_CODE IS NULL) or (p_control_rec.APPLICATION_TYPE_CODE = FND_API.G_MISS_CHAR)) then

212: else
213: l_DEFAULTING_FWK_FLAG := p_control_rec.DEFAULTING_FWK_FLAG;
214: End If;
215:
216: If ((p_control_rec.APPLICATION_TYPE_CODE IS NULL) or (p_control_rec.APPLICATION_TYPE_CODE = FND_API.G_MISS_CHAR)) then
217: l_APPLICATION_TYPE_CODE := ' ';
218: else
219: l_APPLICATION_TYPE_CODE := p_control_rec.APPLICATION_TYPE_CODE;
220: End If;

Line 226: elsif (p_qte_header_rec.Pricing_status_indicator = FND_API.G_MISS_CHAR) then

222:
223:
224: If (p_qte_header_rec.Pricing_status_indicator = null) then
225: l_Pricing_status_indicator := ' ';
226: elsif (p_qte_header_rec.Pricing_status_indicator = FND_API.G_MISS_CHAR) then
227: l_Pricing_status_indicator := 'G_MISS_CHAR';
228: else
229: l_Pricing_status_indicator := p_qte_header_rec.Pricing_status_indicator;
230: end if;

Line 234: elsif (p_qte_header_rec.tax_status_indicator = FND_API.G_MISS_CHAR) then

230: end if;
231:
232: If (p_qte_header_rec.tax_status_indicator = null) then
233: l_tax_status_indicator := ' ';
234: elsif (p_qte_header_rec.tax_status_indicator = FND_API.G_MISS_CHAR) then
235: l_tax_status_indicator := 'G_MISS_CHAR';
236: else
237: l_tax_status_indicator := p_qte_header_rec.tax_status_indicator;
238: end if;

Line 283: raise FND_API.G_EXC_ERROR;

279: fnd_file.put_line(FND_FILE.LOG,'Error in submitting concurrent request');
280: errbuf := FND_MESSAGE.GET;
281: fnd_message.set_name('ASO', errbuf);
282: FND_MSG_PUB.Add;
283: raise FND_API.G_EXC_ERROR;
284: end if;
285:
286: /*******************************************************
287: Update quote with Price_request_id

Line 292: l_qte_header_rec.pricing_status_indicator := FND_API.G_MISS_CHAR;

288: *******************************************************/
289:
290: l_qte_header_rec := p_qte_header_rec;
291: l_qte_header_rec.price_request_id := lx_request_id;
292: l_qte_header_rec.pricing_status_indicator := FND_API.G_MISS_CHAR;
293: l_qte_header_rec.tax_status_indicator := FND_API.G_MISS_CHAR;
294:
295: ASO_QUOTE_PUB.Update_Quote(
296: p_api_version_number => 1.0,

Line 293: l_qte_header_rec.tax_status_indicator := FND_API.G_MISS_CHAR;

289:
290: l_qte_header_rec := p_qte_header_rec;
291: l_qte_header_rec.price_request_id := lx_request_id;
292: l_qte_header_rec.pricing_status_indicator := FND_API.G_MISS_CHAR;
293: l_qte_header_rec.tax_status_indicator := FND_API.G_MISS_CHAR;
294:
295: ASO_QUOTE_PUB.Update_Quote(
296: p_api_version_number => 1.0,
297: p_init_msg_list => FND_API.G_FALSE,

Line 297: p_init_msg_list => FND_API.G_FALSE,

293: l_qte_header_rec.tax_status_indicator := FND_API.G_MISS_CHAR;
294:
295: ASO_QUOTE_PUB.Update_Quote(
296: p_api_version_number => 1.0,
297: p_init_msg_list => FND_API.G_FALSE,
298: p_commit => FND_API.G_FALSE,
299: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
300: p_control_rec => l_control_rec,
301: p_qte_header_rec => l_qte_header_rec,

Line 298: p_commit => FND_API.G_FALSE,

294:
295: ASO_QUOTE_PUB.Update_Quote(
296: p_api_version_number => 1.0,
297: p_init_msg_list => FND_API.G_FALSE,
298: p_commit => FND_API.G_FALSE,
299: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
300: p_control_rec => l_control_rec,
301: p_qte_header_rec => l_qte_header_rec,
302: P_hd_Price_Attributes_Tbl => l_hd_Price_Attributes_Tbl,

Line 299: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

295: ASO_QUOTE_PUB.Update_Quote(
296: p_api_version_number => 1.0,
297: p_init_msg_list => FND_API.G_FALSE,
298: p_commit => FND_API.G_FALSE,
299: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
300: p_control_rec => l_control_rec,
301: p_qte_header_rec => l_qte_header_rec,
302: P_hd_Price_Attributes_Tbl => l_hd_Price_Attributes_Tbl,
303: P_hd_Payment_Tbl => l_hd_Payment_Tbl,

Line 352: IF x_return_status = FND_API.G_RET_STS_ERROR then

348: X_Msg_Count => x_Msg_Count,
349: X_Msg_Data => x_Msg_Data);
350:
351:
352: IF x_return_status = FND_API.G_RET_STS_ERROR then
353: x_request_id := null;
354: raise FND_API.G_EXC_ERROR;
355: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
356: x_request_id := null;

Line 354: raise FND_API.G_EXC_ERROR;

350:
351:
352: IF x_return_status = FND_API.G_RET_STS_ERROR then
353: x_request_id := null;
354: raise FND_API.G_EXC_ERROR;
355: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
356: x_request_id := null;
357: raise FND_API.G_EXC_UNEXPECTED_ERROR;
358: END IF;

Line 355: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

351:
352: IF x_return_status = FND_API.G_RET_STS_ERROR then
353: x_request_id := null;
354: raise FND_API.G_EXC_ERROR;
355: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
356: x_request_id := null;
357: raise FND_API.G_EXC_UNEXPECTED_ERROR;
358: END IF;
359:

Line 357: raise FND_API.G_EXC_UNEXPECTED_ERROR;

353: x_request_id := null;
354: raise FND_API.G_EXC_ERROR;
355: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
356: x_request_id := null;
357: raise FND_API.G_EXC_UNEXPECTED_ERROR;
358: END IF;
359:
360: x_request_id := lx_request_id;
361: commit work;

Line 365: WHEN FND_API.G_EXC_ERROR THEN

361: commit work;
362:
363: Exception
364:
365: WHEN FND_API.G_EXC_ERROR THEN
366: x_return_status := FND_API.G_RET_STS_ERROR;
367:
368: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
369: P_API_NAME => L_API_NAME

Line 366: x_return_status := FND_API.G_RET_STS_ERROR;

362:
363: Exception
364:
365: WHEN FND_API.G_EXC_ERROR THEN
366: x_return_status := FND_API.G_RET_STS_ERROR;
367:
368: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
369: P_API_NAME => L_API_NAME
370: ,P_PKG_NAME => G_PKG_NAME

Line 377: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

373: ,X_MSG_COUNT => X_MSG_COUNT
374: ,X_MSG_DATA => X_MSG_DATA
375: ,X_RETURN_STATUS => X_RETURN_STATUS);
376:
377: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
379:
380:
381: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

Line 378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

374: ,X_MSG_DATA => X_MSG_DATA
375: ,X_RETURN_STATUS => X_RETURN_STATUS);
376:
377: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
379:
380:
381: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
382: P_API_NAME => L_API_NAME

Line 391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

387: ,X_MSG_DATA => X_MSG_DATA
388: ,X_RETURN_STATUS => X_RETURN_STATUS);
389:
390: WHEN OTHERS THEN
391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
392:
393: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
394: P_API_NAME => L_API_NAME
395: ,P_PKG_NAME => G_PKG_NAME

Line 491: x_return_status := FND_API.G_RET_STS_ERROR;

487:
488: FND_FILE.PUT_LINE(FND_FILE.LOG,l_quote_name);
489:
490: exception when no_data_found then
491: x_return_status := FND_API.G_RET_STS_ERROR;
492:
493: end;
494:
495: begin

Line 502: l_qte_header_rec.batch_price_flag := FND_API.G_FALSE;

498: WHERE a.quote_header_id = p_quote_header_id;
499: end;
500:
501:
502: l_qte_header_rec.batch_price_flag := FND_API.G_FALSE;
503: l_qte_header_rec.quote_header_id := p_quote_header_id;
504: l_qte_header_rec.last_update_date := l_last_update_date;
505:
506: if p_pricing_status_indicator = 'G_MISS_CHAR' then

Line 507: l_qte_header_rec.pricing_status_indicator := FND_API.G_MISS_CHAR;

503: l_qte_header_rec.quote_header_id := p_quote_header_id;
504: l_qte_header_rec.last_update_date := l_last_update_date;
505:
506: if p_pricing_status_indicator = 'G_MISS_CHAR' then
507: l_qte_header_rec.pricing_status_indicator := FND_API.G_MISS_CHAR;
508: else
509: l_qte_header_rec.pricing_status_indicator := p_pricing_status_indicator;
510: end if;
511:

Line 513: l_qte_header_rec.tax_status_indicator := FND_API.G_MISS_CHAR;

509: l_qte_header_rec.pricing_status_indicator := p_pricing_status_indicator;
510: end if;
511:
512: if p_tax_status_indicator = 'G_MISS_CHAR' then
513: l_qte_header_rec.tax_status_indicator := FND_API.G_MISS_CHAR;
514: else
515: l_qte_header_rec.tax_status_indicator := p_tax_status_indicator;
516: end if;
517:

Line 540: p_init_msg_list => FND_API.G_FALSE,

536: FND_FILE.PUT_LINE(FND_FILE.LOG,'Org ID : '||l_org_id);
537:
538: ASO_QUOTE_PUB.Update_Quote(
539: p_api_version_number => 1.0,
540: p_init_msg_list => FND_API.G_FALSE,
541: p_commit => FND_API.G_false,
542: p_control_rec => l_control_rec,
543: p_qte_header_rec => l_qte_header_rec,
544: X_Qte_Header_Rec => lx_qte_header_rec,

Line 541: p_commit => FND_API.G_false,

537:
538: ASO_QUOTE_PUB.Update_Quote(
539: p_api_version_number => 1.0,
540: p_init_msg_list => FND_API.G_FALSE,
541: p_commit => FND_API.G_false,
542: p_control_rec => l_control_rec,
543: p_qte_header_rec => l_qte_header_rec,
544: X_Qte_Header_Rec => lx_qte_header_rec,
545: X_Qte_Line_Tbl => lx_Qte_Line_Tbl,

Line 577: fnd_api.g_false);

573: x_msg_index := 1;
574:
575: while x_msg_count > 0 loop
576: x_msg_data := fnd_msg_pub.get(x_msg_index,
577: fnd_api.g_false);
578: FND_FILE.PUT_LINE(FND_FILE.LOG,x_msg_data);
579: x_msg_index := x_msg_index + 1;
580: x_msg_count := x_msg_count - 1;
581: end loop;

Line 587: If x_return_status = FND_API.G_RET_STS_ERROR then

583: /********************************************************
584: Send Notification on completion
585: *********************************************************/
586:
587: If x_return_status = FND_API.G_RET_STS_ERROR then
588: fnd_message.set_name('ASO','ASO_PRICE_REQ_COM_SUB');
589: fnd_message.set_token('QUOTE_NAME',l_quote_name);
590: fnd_message.set_token('REQUEST_ID',l_request_id);
591:

Line 601: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

597: l_body := fnd_message.get ;
598:
599: FND_FILE.PUT_LINE(FND_FILE.LOG,l_body);
600:
601: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
602: fnd_message.set_name('ASO','ASO_PRICE_REQ_COM_SUB');
603: fnd_message.set_token('QUOTE_NAME',l_quote_name);
604: fnd_message.set_token('REQUEST_ID',l_request_id);
605:

Line 629: IF x_return_status = FND_API.G_RET_STS_ERROR then

625: FND_FILE.PUT_LINE(FND_FILE.LOG,l_body);
626:
627: end if;
628:
629: IF x_return_status = FND_API.G_RET_STS_ERROR then
630: rollback;
631: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
632: rollback;
633: else

Line 631: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

627: end if;
628:
629: IF x_return_status = FND_API.G_RET_STS_ERROR then
630: rollback;
631: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
632: rollback;
633: else
634: commit work;
635: END IF;

Line 645: WHEN FND_API.G_EXC_ERROR THEN

641:
642: FND_FILE.PUT_LINE(FND_FILE.LOG,'After Notification');
643:
644: EXCEPTION
645: WHEN FND_API.G_EXC_ERROR THEN
646: x_return_status := FND_API.G_RET_STS_ERROR;
647:
648: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
649: P_API_NAME => L_API_NAME

Line 646: x_return_status := FND_API.G_RET_STS_ERROR;

642: FND_FILE.PUT_LINE(FND_FILE.LOG,'After Notification');
643:
644: EXCEPTION
645: WHEN FND_API.G_EXC_ERROR THEN
646: x_return_status := FND_API.G_RET_STS_ERROR;
647:
648: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
649: P_API_NAME => L_API_NAME
650: ,P_PKG_NAME => G_PKG_NAME

Line 657: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

653: ,X_MSG_COUNT => X_MSG_COUNT
654: ,X_MSG_DATA => X_MSG_DATA
655: ,X_RETURN_STATUS => X_RETURN_STATUS);
656:
657: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
659:
660:
661: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

Line 658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

654: ,X_MSG_DATA => X_MSG_DATA
655: ,X_RETURN_STATUS => X_RETURN_STATUS);
656:
657: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
659:
660:
661: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
662: P_API_NAME => L_API_NAME

Line 671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

667: ,X_MSG_DATA => X_MSG_DATA
668: ,X_RETURN_STATUS => X_RETURN_STATUS);
669:
670: WHEN OTHERS THEN
671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
672:
673: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
674: P_API_NAME => L_API_NAME
675: ,P_PKG_NAME => G_PKG_NAME

Line 693: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

689:
690:
691: Procedure Cancel_price_tax_req(
692: P_Api_Version_Number IN NUMBER,
693: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
694: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
695: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
696: x_msg_count OUT NOCOPY /* file.sql.39 change */ Number,
697: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 724: IF NOT FND_API.Compatible_API_Call(

720: *******************************************************/
721: Savepoint Cancel_price_tax_req_INT;
722:
723: -- Standard call to check for call compatibility.
724: IF NOT FND_API.Compatible_API_Call(
725: L_API_VERSION ,
726: P_API_VERSION_NUMBER,
727: L_API_NAME ,
728: G_PKG_NAME

Line 730: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

726: P_API_VERSION_NUMBER,
727: L_API_NAME ,
728: G_PKG_NAME
729: ) THEN
730: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
731: END IF;
732:
733: -- Initialize message list if p_init_msg_list is set to TRUE.
734: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 734: IF FND_API.To_Boolean(p_init_msg_list) THEN

730: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
731: END IF;
732:
733: -- Initialize message list if p_init_msg_list is set to TRUE.
734: IF FND_API.To_Boolean(p_init_msg_list) THEN
735: FND_Msg_Pub.initialize;
736: END IF;
737:
738: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 738: x_return_status := FND_API.G_RET_STS_SUCCESS;

734: IF FND_API.To_Boolean(p_init_msg_list) THEN
735: FND_Msg_Pub.initialize;
736: END IF;
737:
738: x_return_status := FND_API.G_RET_STS_SUCCESS;
739:
740: x_msg_count := 0;
741:
742: Open find_quote_csr(p_qte_header_rec.quote_header_id);

Line 748: x_return_status := FND_API.G_RET_STS_ERROR;

744: fetch find_quote_csr into l_quote_name,l_request_id;
745:
746: IF (find_quote_csr%NOTFOUND or l_request_id is null) THEN
747: CLOSE find_quote_csr;
748: x_return_status := FND_API.G_RET_STS_ERROR;
749: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
750: FND_MESSAGE.Set_Name('ASO', 'ASO_CONC_REQUEST_NOT_FOUND');
751: FND_MSG_PUB.ADD;
752: END IF;

Line 754: raise FND_API.G_EXC_ERROR;

750: FND_MESSAGE.Set_Name('ASO', 'ASO_CONC_REQUEST_NOT_FOUND');
751: FND_MSG_PUB.ADD;
752: END IF;
753:
754: raise FND_API.G_EXC_ERROR;
755: END IF;
756:
757: close find_quote_csr ;
758:

Line 791: raise FND_API.G_EXC_ERROR;

787: p_subject => l_subject,
788: p_body => l_body);
789:
790: if not (l_result) then
791: raise FND_API.G_EXC_ERROR;
792: end if;
793:
794: EXCEPTION
795: WHEN FND_API.G_EXC_ERROR THEN

Line 795: WHEN FND_API.G_EXC_ERROR THEN

791: raise FND_API.G_EXC_ERROR;
792: end if;
793:
794: EXCEPTION
795: WHEN FND_API.G_EXC_ERROR THEN
796: x_return_status := FND_API.G_RET_STS_ERROR;
797:
798: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
799: P_API_NAME => L_API_NAME

Line 796: x_return_status := FND_API.G_RET_STS_ERROR;

792: end if;
793:
794: EXCEPTION
795: WHEN FND_API.G_EXC_ERROR THEN
796: x_return_status := FND_API.G_RET_STS_ERROR;
797:
798: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
799: P_API_NAME => L_API_NAME
800: ,P_PKG_NAME => G_PKG_NAME

Line 808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

804: ,X_MSG_DATA => X_MSG_DATA
805: ,X_RETURN_STATUS => X_RETURN_STATUS);
806:
807: WHEN OTHERS THEN
808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
809:
810: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
811: P_API_NAME => L_API_NAME
812: ,P_PKG_NAME => G_PKG_NAME

Line 1007: x_status := FND_API.G_FALSE;

1003: Select price_request_id into l_request_id from aso_quote_headers_all
1004: Where quote_header_id =p_quote_header_id;
1005:
1006: If l_request_id is null then
1007: x_status := FND_API.G_FALSE;
1008: Else
1009: x_status := FND_API.G_TRUE;
1010: End if;
1011:

Line 1009: x_status := FND_API.G_TRUE;

1005:
1006: If l_request_id is null then
1007: x_status := FND_API.G_FALSE;
1008: Else
1009: x_status := FND_API.G_TRUE;
1010: End if;
1011:
1012: end Lock_Exists;
1013: