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

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

21:
22:
23: PROCEDURE Copy_Quote_To_Tmpl (
24: P_Api_Version_Number IN NUMBER
25: , P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
26: , P_Commit IN VARCHAR2 := FND_API.G_FALSE
27: , P_old_quote_header_Id IN NUMBER
28: , X_Qte_Header_Id OUT NOCOPY /* file.sql.39 change */ NUMBER
29: , X_Qte_Number OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 26: , P_Commit IN VARCHAR2 := FND_API.G_FALSE

22:
23: PROCEDURE Copy_Quote_To_Tmpl (
24: P_Api_Version_Number IN NUMBER
25: , P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
26: , P_Commit IN VARCHAR2 := FND_API.G_FALSE
27: , P_old_quote_header_Id IN NUMBER
28: , X_Qte_Header_Id OUT NOCOPY /* file.sql.39 change */ NUMBER
29: , X_Qte_Number OUT NOCOPY /* file.sql.39 change */ NUMBER
30: , X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 76: IF NOT FND_API.Compatible_API_Call (

72:
73: -- Standard Start of API savepoint
74: SAVEPOINT COPY_QUOTE_TO_TMPL;
75: -- Standard call to check for call compatibility.
76: IF NOT FND_API.Compatible_API_Call (
77: l_api_version_number
78: , p_api_version_number
79: , l_api_name
80: , G_PKG_NAME

Line 82: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

78: , p_api_version_number
79: , l_api_name
80: , G_PKG_NAME
81: ) THEN
82: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
83: END IF;
84:
85: -- Initialize message list if p_init_msg_list is set to TRUE.
86: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 86: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

82: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
83: END IF;
84:
85: -- Initialize message list if p_init_msg_list is set to TRUE.
86: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
87: FND_MSG_PUB.initialize;
88: END IF;
89:
90: -- Debug Message

Line 97: l_return_status := FND_API.G_RET_STS_SUCCESS;

93: FND_MSG_PUB.ADD;
94: END IF;
95:
96: -- Initialize API return status to success
97: l_return_status := FND_API.G_RET_STS_SUCCESS;
98:
99: --
100: -- API body
101: --

Line 111: RAISE FND_API.G_EXC_ERROR;

107: FND_MESSAGE.Set_Name ('ASO' , 'UT_CANNOT_GET_PROFILE_VALUE' );
108: FND_MESSAGE.Set_Token ('PROFILE' , 'USER_ID', FALSE );
109: FND_MSG_PUB.ADD;
110: END IF;
111: RAISE FND_API.G_EXC_ERROR;
112: END IF;
113:
114: -- ******************************************************************
115:

Line 149: x_return_status := FND_API.G_RET_STS_ERROR;

145: OPEN c_qte_status_id ( fnd_profile.VALUE ('ASO_DEFAULT_STATUS_CODE' ) );
146: FETCH c_qte_status_id INTO l_qte_header_rec.quote_status_id;
147:
148: IF c_qte_status_id%NOTFOUND THEN
149: x_return_status := FND_API.G_RET_STS_ERROR;
150: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
151: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_NO_PROFILE_VALUE' );
152: FND_MESSAGE.Set_Token ( 'PROFILE' , 'ASO_DEFAULT_STATUS_CODE' , FALSE );
153: FND_MSG_PUB.ADD;

Line 156: RAISE FND_API.G_EXC_ERROR;

152: FND_MESSAGE.Set_Token ( 'PROFILE' , 'ASO_DEFAULT_STATUS_CODE' , FALSE );
153: FND_MSG_PUB.ADD;
154: END IF;
155: CLOSE c_qte_status_id;
156: RAISE FND_API.G_EXC_ERROR;
157: END IF;
158:
159: CLOSE c_qte_status_id;
160:

Line 203: , P_Init_Msg_List => FND_API.G_FALSE

199:
200:
201: Copy_Tmpl_Header (
202: P_Api_Version_Number => 1.0
203: , P_Init_Msg_List => FND_API.G_FALSE
204: , P_Commit => FND_API.G_FALSE
205: , P_qte_Header_Rec => l_qte_header_rec
206: , X_Qte_Header_id => x_qte_header_id
207: , X_Return_Status => l_return_status

Line 204: , P_Commit => FND_API.G_FALSE

200:
201: Copy_Tmpl_Header (
202: P_Api_Version_Number => 1.0
203: , P_Init_Msg_List => FND_API.G_FALSE
204: , P_Commit => FND_API.G_FALSE
205: , P_qte_Header_Rec => l_qte_header_rec
206: , X_Qte_Header_id => x_qte_header_id
207: , X_Return_Status => l_return_status
208: , X_Msg_Count => x_msg_count

Line 216: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

212: aso_debug_pub.ADD ( 'Copy_Tmpl - After copy_ header rows ' || l_return_status , 1 , 'Y' );
213: END IF;
214:
215: X_Qte_Number:= l_qte_header_rec.quote_number;
216: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
218: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
219: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
220: FND_MESSAGE.Set_Token ('ROW' , 'ASO_QUOTE_HEADER', TRUE );

Line 217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

213: END IF;
214:
215: X_Qte_Number:= l_qte_header_rec.quote_number;
216: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
218: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
219: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
220: FND_MESSAGE.Set_Token ('ROW' , 'ASO_QUOTE_HEADER', TRUE );
221: FND_MSG_PUB.ADD;

Line 223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

219: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
220: FND_MESSAGE.Set_Token ('ROW' , 'ASO_QUOTE_HEADER', TRUE );
221: FND_MSG_PUB.ADD;
222: END IF;
223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
224: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
225: x_return_status := FND_API.G_RET_STS_ERROR;
226: RAISE FND_API.G_EXC_ERROR;
227: END IF;

Line 224: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

220: FND_MESSAGE.Set_Token ('ROW' , 'ASO_QUOTE_HEADER', TRUE );
221: FND_MSG_PUB.ADD;
222: END IF;
223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
224: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
225: x_return_status := FND_API.G_RET_STS_ERROR;
226: RAISE FND_API.G_EXC_ERROR;
227: END IF;
228:

Line 225: x_return_status := FND_API.G_RET_STS_ERROR;

221: FND_MSG_PUB.ADD;
222: END IF;
223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
224: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
225: x_return_status := FND_API.G_RET_STS_ERROR;
226: RAISE FND_API.G_EXC_ERROR;
227: END IF;
228:
229: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 226: RAISE FND_API.G_EXC_ERROR;

222: END IF;
223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
224: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
225: x_return_status := FND_API.G_RET_STS_ERROR;
226: RAISE FND_API.G_EXC_ERROR;
227: END IF;
228:
229: IF aso_debug_pub.g_debug_flag = 'Y' THEN
230: aso_debug_pub.ADD ( 'Copy_template - before copy template rows ', 1 , 'Y' );

Line 237: , P_Init_Msg_List => FND_API.G_FALSE

233:
234:
235: Copy_Tmpl_Lines (
236: P_Api_Version_Number => 1.0
237: , P_Init_Msg_List => FND_API.G_FALSE
238: , P_Commit => FND_API.G_FALSE
239: , P_qte_Header_Id => P_old_quote_header_Id
240: , P_new_qte_header_id => x_qte_header_id
241: --, P_Qte_Header_Rec => l_copy_line_qte_header_rec

Line 238: , P_Commit => FND_API.G_FALSE

234:
235: Copy_Tmpl_Lines (
236: P_Api_Version_Number => 1.0
237: , P_Init_Msg_List => FND_API.G_FALSE
238: , P_Commit => FND_API.G_FALSE
239: , P_qte_Header_Id => P_old_quote_header_Id
240: , P_new_qte_header_id => x_qte_header_id
241: --, P_Qte_Header_Rec => l_copy_line_qte_header_rec
242: , P_Control_Rec => ASO_QUOTE_PUB.G_MISS_Control_Rec

Line 251: if (l_return_status =FND_API.G_RET_STS_SUCCESS) then

247: IF aso_debug_pub.g_debug_flag = 'Y' THEN
248: aso_debug_pub.ADD ( 'Copy_template - template rows ' || l_return_status , 1 , 'Y' );
249: END IF;
250:
251: if (l_return_status =FND_API.G_RET_STS_SUCCESS) then
252:
253:
254: if l_copy_config_profile='N' then
255: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 262: P_Init_Msg_List => FND_API.G_FALSE,

258:
259: ASO_QUOTE_PUB.validate_model_configuration
260: (
261: P_Api_Version_Number => 1.0,
262: P_Init_Msg_List => FND_API.G_FALSE,
263: P_Commit => FND_API.G_FALSE,
264: P_Quote_header_id =>x_qte_header_id,
265: P_UPDATE_QUOTE =>'T',
266: P_CONFIG_EFFECTIVE_DATE => sysdate,

Line 263: P_Commit => FND_API.G_FALSE,

259: ASO_QUOTE_PUB.validate_model_configuration
260: (
261: P_Api_Version_Number => 1.0,
262: P_Init_Msg_List => FND_API.G_FALSE,
263: P_Commit => FND_API.G_FALSE,
264: P_Quote_header_id =>x_qte_header_id,
265: P_UPDATE_QUOTE =>'T',
266: P_CONFIG_EFFECTIVE_DATE => sysdate,
267: P_CONFIG_model_lookup_DATE => sysdate,

Line 274: if l_Return_Status=FND_API.G_RET_STS_SUCCESS then

270: X_Msg_Count => x_msg_count,
271: X_Msg_Data => x_msg_data
272: );
273:
274: if l_Return_Status=FND_API.G_RET_STS_SUCCESS then
275: commit work;
276: end if;
277:
278: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 288: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

284: end if; -- success
285:
286:
287:
288: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
290: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
291: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
292: FND_MESSAGE.Set_Token ('ROW' , 'ASO_QUOTE_HEADER', TRUE );

Line 289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

285:
286:
287:
288: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
290: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
291: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
292: FND_MESSAGE.Set_Token ('ROW' , 'ASO_QUOTE_HEADER', TRUE );
293: FND_MSG_PUB.ADD;

Line 295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

291: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
292: FND_MESSAGE.Set_Token ('ROW' , 'ASO_QUOTE_HEADER', TRUE );
293: FND_MSG_PUB.ADD;
294: END IF;
295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
296: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
297: x_return_status := FND_API.G_RET_STS_ERROR;
298: RAISE FND_API.G_EXC_ERROR;
299: END IF;

Line 296: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

292: FND_MESSAGE.Set_Token ('ROW' , 'ASO_QUOTE_HEADER', TRUE );
293: FND_MSG_PUB.ADD;
294: END IF;
295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
296: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
297: x_return_status := FND_API.G_RET_STS_ERROR;
298: RAISE FND_API.G_EXC_ERROR;
299: END IF;
300:

Line 297: x_return_status := FND_API.G_RET_STS_ERROR;

293: FND_MSG_PUB.ADD;
294: END IF;
295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
296: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
297: x_return_status := FND_API.G_RET_STS_ERROR;
298: RAISE FND_API.G_EXC_ERROR;
299: END IF;
300:
301: X_Return_Status := l_return_status;

Line 298: RAISE FND_API.G_EXC_ERROR;

294: END IF;
295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
296: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
297: x_return_status := FND_API.G_RET_STS_ERROR;
298: RAISE FND_API.G_EXC_ERROR;
299: END IF;
300:
301: X_Return_Status := l_return_status;
302:

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

303: end Copy_Quote_To_Tmpl;
304:
305: PROCEDURE Copy_Tmpl_Header (
306: P_Api_Version_Number IN NUMBER
307: , P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
308: , P_Commit IN VARCHAR2 := FND_API.G_FALSE
309: , P_Qte_Header_Rec IN ASO_QUOTE_PUB.qte_header_rec_Type
310: , X_Qte_Header_Id OUT NOCOPY /* file.sql.39 change */ NUMBER
311: , X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 308: , P_Commit IN VARCHAR2 := FND_API.G_FALSE

304:
305: PROCEDURE Copy_Tmpl_Header (
306: P_Api_Version_Number IN NUMBER
307: , P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
308: , P_Commit IN VARCHAR2 := FND_API.G_FALSE
309: , P_Qte_Header_Rec IN ASO_QUOTE_PUB.qte_header_rec_Type
310: , X_Qte_Header_Id OUT NOCOPY /* file.sql.39 change */ NUMBER
311: , X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
312: , X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 344: IF NOT FND_API.Compatible_API_Call (

340: -- Standard Start of API savepoint
341: SAVEPOINT COPY_TMPL_HEADER;
342:
343: -- Standard call to check for call compatibility.
344: IF NOT FND_API.Compatible_API_Call (
345: l_api_version_number
346: , p_api_version_number
347: , l_api_name
348: , G_PKG_NAME

Line 350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

346: , p_api_version_number
347: , l_api_name
348: , G_PKG_NAME
349: ) THEN
350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
351: END IF;
352:
353: -- Initialize message list if p_init_msg_list is set to TRUE.
354: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 354: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
351: END IF;
352:
353: -- Initialize message list if p_init_msg_list is set to TRUE.
354: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
355: FND_MSG_PUB.initialize;
356: END IF;
357:
358: -- Debug Message

Line 365: l_return_status := FND_API.G_RET_STS_SUCCESS;

361: FND_MSG_PUB.ADD;
362: END IF;
363:
364: -- Initialize API return status to success
365: l_return_status := FND_API.G_RET_STS_SUCCESS;
366:
367: --
368: -- API body
369: --

Line 409: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

405: IF aso_debug_pub.g_debug_flag = 'Y' THEN
406: aso_debug_pub.ADD ( 'Copy_Template - After insert_rows - status: ' || l_return_status , 1 , 'Y' );
407: END IF;
408:
409: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
411: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
412: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
413: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYHEADER AFTER_INSERT' , TRUE );

Line 410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

406: aso_debug_pub.ADD ( 'Copy_Template - After insert_rows - status: ' || l_return_status , 1 , 'Y' );
407: END IF;
408:
409: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
411: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
412: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
413: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYHEADER AFTER_INSERT' , TRUE );
414: FND_MSG_PUB.ADD;

Line 416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

412: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
413: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYHEADER AFTER_INSERT' , TRUE );
414: FND_MSG_PUB.ADD;
415: END IF;
416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
417: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
418: x_return_status := FND_API.G_RET_STS_ERROR;
419: RAISE FND_API.G_EXC_ERROR;
420: END IF;

Line 417: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

413: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYHEADER AFTER_INSERT' , TRUE );
414: FND_MSG_PUB.ADD;
415: END IF;
416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
417: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
418: x_return_status := FND_API.G_RET_STS_ERROR;
419: RAISE FND_API.G_EXC_ERROR;
420: END IF;
421:

Line 418: x_return_status := FND_API.G_RET_STS_ERROR;

414: FND_MSG_PUB.ADD;
415: END IF;
416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
417: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
418: x_return_status := FND_API.G_RET_STS_ERROR;
419: RAISE FND_API.G_EXC_ERROR;
420: END IF;
421:
422: x_qte_header_id := l_qte_header_rec_out.quote_header_id;

Line 419: RAISE FND_API.G_EXC_ERROR;

415: END IF;
416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
417: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
418: x_return_status := FND_API.G_RET_STS_ERROR;
419: RAISE FND_API.G_EXC_ERROR;
420: END IF;
421:
422: x_qte_header_id := l_qte_header_rec_out.quote_header_id;
423:

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

427:
428:
429: PROCEDURE Copy_Tmpl_Lines(
430: P_Api_Version_Number IN NUMBER,
431: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
432: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
433: P_Qte_Header_Id IN NUMBER,
434: P_New_Qte_Header_Id IN NUMBER,
435: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type,

Line 432: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

428:
429: PROCEDURE Copy_Tmpl_Lines(
430: P_Api_Version_Number IN NUMBER,
431: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
432: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
433: P_Qte_Header_Id IN NUMBER,
434: P_New_Qte_Header_Id IN NUMBER,
435: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type,
436: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 585: l_ato_model VARCHAR2(1) := FND_API.G_FALSE;

581: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
582: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
583: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
584: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
585: l_ato_model VARCHAR2(1) := FND_API.G_FALSE;
586:
587: l_copy_flag varchar2(1):='T';
588:
589:

Line 596: IF NOT FND_API.Compatible_API_Call (

592: -- Standard Start of API savepoint
593: SAVEPOINT COPY_TMPL_LINES;
594:
595: -- Standard call to check for call compatibility.
596: IF NOT FND_API.Compatible_API_Call (
597: l_api_version_number
598: , p_api_version_number
599: , l_api_name
600: , G_PKG_NAME

Line 602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

598: , p_api_version_number
599: , l_api_name
600: , G_PKG_NAME
601: ) THEN
602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
603: END IF;
604:
605: -- Initialize message list if p_init_msg_list is set to TRUE.
606: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 606: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
603: END IF;
604:
605: -- Initialize message list if p_init_msg_list is set to TRUE.
606: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
607: FND_MSG_PUB.initialize;
608: END IF;
609:
610: -- Debug Message

Line 617: x_return_status := FND_API.G_RET_STS_SUCCESS;

613: FND_MSG_PUB.ADD;
614: END IF;
615:
616: -- Initialize API return status to success
617: x_return_status := FND_API.G_RET_STS_SUCCESS;
618:
619: --
620: -- API body
621: --

Line 632: l_line_index_link_tbl ( l_qte_line_tbl ( i ).quote_line_id ) := FND_API.G_MISS_NUM;

628: l_qte_line_tbl := ASO_UTILITY_PVT.Query_Qte_Line_Rows ( p_qte_header_id );
629:
630:
631: FOR i IN 1 .. l_qte_line_tbl.COUNT LOOP
632: l_line_index_link_tbl ( l_qte_line_tbl ( i ).quote_line_id ) := FND_API.G_MISS_NUM;
633: END LOOP;
634:
635:
636:

Line 699: IF l_line_index_link_tbl ( l_qte_line_id ) = FND_API.G_MISS_NUM THEN

695:
696:
697:
698: IF (l_copy_flag = 'T') then
699: IF l_line_index_link_tbl ( l_qte_line_id ) = FND_API.G_MISS_NUM THEN
700:
701: l_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows ( l_qte_line_id );
702:
703: -- for reconfigure from install base

Line 739: l_config_control_rec.new_config_flag := FND_API.G_TRUE;

735:
736: IF l_qte_line_dtl_tbl ( 1 ).config_header_id IS NOT NULL
737: AND l_qte_line_dtl_tbl ( 1 ).config_revision_num IS NOT NULL THEN
738:
739: l_config_control_rec.new_config_flag := FND_API.G_TRUE;
740:
741: -- set the flag for ato model
742: IF (l_qte_line_dtl_tbl(1).ato_line_id is not null and l_qte_line_dtl_tbl(1).ato_line_id <> fnd_api.g_miss_num) then
743: l_ato_model := fnd_api.g_true;

Line 742: IF (l_qte_line_dtl_tbl(1).ato_line_id is not null and l_qte_line_dtl_tbl(1).ato_line_id <> fnd_api.g_miss_num) then

738:
739: l_config_control_rec.new_config_flag := FND_API.G_TRUE;
740:
741: -- set the flag for ato model
742: IF (l_qte_line_dtl_tbl(1).ato_line_id is not null and l_qte_line_dtl_tbl(1).ato_line_id <> fnd_api.g_miss_num) then
743: l_ato_model := fnd_api.g_true;
744: end if;
745:
746:

Line 743: l_ato_model := fnd_api.g_true;

739: l_config_control_rec.new_config_flag := FND_API.G_TRUE;
740:
741: -- set the flag for ato model
742: IF (l_qte_line_dtl_tbl(1).ato_line_id is not null and l_qte_line_dtl_tbl(1).ato_line_id <> fnd_api.g_miss_num) then
743: l_ato_model := fnd_api.g_true;
744: end if;
745:
746:
747: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 763: , p_autonomous_flag => FND_API.G_FALSE

759: , x_new_item_id_tbl => l_new_item_id_tbl
760: , x_return_status => l_return_status
761: , x_msg_count => x_msg_count
762: , x_msg_data => x_msg_data
763: , p_autonomous_flag => FND_API.G_FALSE
764: );
765:
766: IF aso_debug_pub.g_debug_flag = 'Y' THEN
767: aso_debug_pub.ADD ( 'After Calling ASO_CGF_INT.Copy Configuration' , 1 , 'N' );

Line 770: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

766: IF aso_debug_pub.g_debug_flag = 'Y' THEN
767: aso_debug_pub.ADD ( 'After Calling ASO_CGF_INT.Copy Configuration' , 1 , 'N' );
768: END IF;
769:
770: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
771: l_old_config_header_id :=
772: l_qte_line_dtl_tbl ( 1 ).config_header_id;
773: l_old_config_revision_num :=
774: l_qte_line_dtl_tbl ( 1 ).config_revision_num;

Line 780: x_return_status := FND_API.G_RET_STS_ERROR;

776: l_config_hdr_id;
777: l_qte_line_dtl_tbl ( 1 ).config_revision_num :=
778: l_config_rev_nbr;
779: ELSE
780: x_return_status := FND_API.G_RET_STS_ERROR;
781: RAISE FND_API.G_EXC_ERROR;
782: END IF;
783:
784: END IF; -- config_header_id

Line 781: RAISE FND_API.G_EXC_ERROR;

777: l_qte_line_dtl_tbl ( 1 ).config_revision_num :=
778: l_config_rev_nbr;
779: ELSE
780: x_return_status := FND_API.G_RET_STS_ERROR;
781: RAISE FND_API.G_EXC_ERROR;
782: END IF;
783:
784: END IF; -- config_header_id
785:

Line 827: l_qte_line_tbl(i).line_list_price:=FND_API.G_MISS_NUM;

823: AND l_service_item_flag <> 'Y'
824: AND (l_copy_flag='T') THEN
825:
826: -- Setting Pricing parameters as null
827: l_qte_line_tbl(i).line_list_price:=FND_API.G_MISS_NUM;
828: l_qte_line_tbl(i).line_adjusted_amount:=FND_API.G_MISS_NUM;
829: l_qte_line_tbl(i).line_Quote_price:=FND_API.G_MISS_NUM;
830: l_qte_line_tbl(i).priced_price_list_id:=FND_API.G_MISS_NUM;
831: l_qte_line_tbl(i).pricing_quantity_uom:=null;

Line 828: l_qte_line_tbl(i).line_adjusted_amount:=FND_API.G_MISS_NUM;

824: AND (l_copy_flag='T') THEN
825:
826: -- Setting Pricing parameters as null
827: l_qte_line_tbl(i).line_list_price:=FND_API.G_MISS_NUM;
828: l_qte_line_tbl(i).line_adjusted_amount:=FND_API.G_MISS_NUM;
829: l_qte_line_tbl(i).line_Quote_price:=FND_API.G_MISS_NUM;
830: l_qte_line_tbl(i).priced_price_list_id:=FND_API.G_MISS_NUM;
831: l_qte_line_tbl(i).pricing_quantity_uom:=null;
832: l_qte_line_tbl(i).pricing_quantity:=FND_API.G_MISS_NUM;

Line 829: l_qte_line_tbl(i).line_Quote_price:=FND_API.G_MISS_NUM;

825:
826: -- Setting Pricing parameters as null
827: l_qte_line_tbl(i).line_list_price:=FND_API.G_MISS_NUM;
828: l_qte_line_tbl(i).line_adjusted_amount:=FND_API.G_MISS_NUM;
829: l_qte_line_tbl(i).line_Quote_price:=FND_API.G_MISS_NUM;
830: l_qte_line_tbl(i).priced_price_list_id:=FND_API.G_MISS_NUM;
831: l_qte_line_tbl(i).pricing_quantity_uom:=null;
832: l_qte_line_tbl(i).pricing_quantity:=FND_API.G_MISS_NUM;
833:

Line 830: l_qte_line_tbl(i).priced_price_list_id:=FND_API.G_MISS_NUM;

826: -- Setting Pricing parameters as null
827: l_qte_line_tbl(i).line_list_price:=FND_API.G_MISS_NUM;
828: l_qte_line_tbl(i).line_adjusted_amount:=FND_API.G_MISS_NUM;
829: l_qte_line_tbl(i).line_Quote_price:=FND_API.G_MISS_NUM;
830: l_qte_line_tbl(i).priced_price_list_id:=FND_API.G_MISS_NUM;
831: l_qte_line_tbl(i).pricing_quantity_uom:=null;
832: l_qte_line_tbl(i).pricing_quantity:=FND_API.G_MISS_NUM;
833:
834:

Line 832: l_qte_line_tbl(i).pricing_quantity:=FND_API.G_MISS_NUM;

828: l_qte_line_tbl(i).line_adjusted_amount:=FND_API.G_MISS_NUM;
829: l_qte_line_tbl(i).line_Quote_price:=FND_API.G_MISS_NUM;
830: l_qte_line_tbl(i).priced_price_list_id:=FND_API.G_MISS_NUM;
831: l_qte_line_tbl(i).pricing_quantity_uom:=null;
832: l_qte_line_tbl(i).pricing_quantity:=FND_API.G_MISS_NUM;
833:
834:
835: -- Setting the shipment data
836: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows(p_qte_header_id, L_QTE_LINE_ID);

Line 839: l_qte_line_tbl ( i ).object_version_number := FND_API.G_MISS_NUM;

835: -- Setting the shipment data
836: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows(p_qte_header_id, L_QTE_LINE_ID);
837: l_qte_line_tbl(i).quote_line_id := NULL;
838:
839: l_qte_line_tbl ( i ).object_version_number := FND_API.G_MISS_NUM;
840:
841: FOR j IN 1 .. l_shipment_tbl.COUNT LOOP
842: l_shipment_tbl( j ).QUOTE_HEADER_ID := p_new_qte_header_id;
843: l_shipment_tbl( j ).shipment_id := null;

Line 844: l_shipment_tbl( j ).object_version_number := FND_API.G_MISS_NUM;

840:
841: FOR j IN 1 .. l_shipment_tbl.COUNT LOOP
842: l_shipment_tbl( j ).QUOTE_HEADER_ID := p_new_qte_header_id;
843: l_shipment_tbl( j ).shipment_id := null;
844: l_shipment_tbl( j ).object_version_number := FND_API.G_MISS_NUM;
845: l_shipment_tbl( j ).SHIP_TO_CUST_ACCOUNT_ID := Null;
846: l_shipment_tbl( j ).SHIP_TO_CUST_PARTY_ID := Null;
847: l_shipment_tbl( j ).SHIP_TO_PARTY_ID := Null;
848: l_shipment_tbl( j ).SHIP_TO_PARTY_SITE_ID := Null;

Line 881: l_qte_line_dtl_tbl(j).object_version_number := FND_API.G_MISS_NUM;

877: --BC4J Fix
878:
879: FOR j IN 1 .. l_qte_line_dtl_tbl.COUNT LOOP
880: l_qte_line_dtl_tbl(j).quote_line_detail_id := null;
881: l_qte_line_dtl_tbl(j).object_version_number := FND_API.G_MISS_NUM;
882: l_qte_line_dtl_tbl(j).top_model_line_id := null;
883: l_qte_line_dtl_tbl(j).ato_line_id := null;
884: l_qte_line_dtl_tbl(j).qte_line_index := i;
885: END LOOP;

Line 942: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

938: l_qte_line_dtl_tbl := l_qte_line_dtl_tbl_out ;
939: l_Line_Attr_Ext_Tbl := l_Line_Attr_Ext_Tbl_out;
940:
941:
942: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
943: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
944: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
945: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
946: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_INSERT' , TRUE );

Line 943: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

939: l_Line_Attr_Ext_Tbl := l_Line_Attr_Ext_Tbl_out;
940:
941:
942: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
943: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
944: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
945: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
946: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_INSERT' , TRUE );
947: FND_MSG_PUB.ADD;

Line 949: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

945: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
946: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_INSERT' , TRUE );
947: FND_MSG_PUB.ADD;
948: END IF;
949: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
950: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
951: x_return_status := FND_API.G_RET_STS_ERROR;
952: RAISE FND_API.G_EXC_ERROR;
953: END IF;

Line 950: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

946: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_INSERT' , TRUE );
947: FND_MSG_PUB.ADD;
948: END IF;
949: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
950: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
951: x_return_status := FND_API.G_RET_STS_ERROR;
952: RAISE FND_API.G_EXC_ERROR;
953: END IF;
954: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 951: x_return_status := FND_API.G_RET_STS_ERROR;

947: FND_MSG_PUB.ADD;
948: END IF;
949: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
950: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
951: x_return_status := FND_API.G_RET_STS_ERROR;
952: RAISE FND_API.G_EXC_ERROR;
953: END IF;
954: IF aso_debug_pub.g_debug_flag = 'Y' THEN
955: aso_debug_pub.ADD ( 'Copy_Template - After insert_quote_line_rows - status: ' || l_return_status , 1 , 'Y' );

Line 952: RAISE FND_API.G_EXC_ERROR;

948: END IF;
949: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
950: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
951: x_return_status := FND_API.G_RET_STS_ERROR;
952: RAISE FND_API.G_EXC_ERROR;
953: END IF;
954: IF aso_debug_pub.g_debug_flag = 'Y' THEN
955: aso_debug_pub.ADD ( 'Copy_Template - After insert_quote_line_rows - status: ' || l_return_status , 1 , 'Y' );
956: END IF;

Line 964: ato_line_id = decode(l_ato_model,fnd_api.g_true,lx_qte_line_rec.quote_line_id,null)

960: aso_debug_pub.ADD ( 'Copy_Template - l_ato_model: ' || l_ato_model , 1 , 'Y' );
961: END IF;
962: update aso_quote_line_details
963: set top_model_line_id = lx_qte_line_rec.quote_line_id,
964: ato_line_id = decode(l_ato_model,fnd_api.g_true,lx_qte_line_rec.quote_line_id,null)
965: where quote_line_id = lx_qte_line_rec.quote_line_id;
966:
967:
968: l_line_index_link_tbl ( l_qte_line_id ) :=

Line 1002: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

998: aso_debug_pub.ADD ( ' After Calling Service Copy' , 1 , 'N' );
999: END IF;
1000:
1001:
1002: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1003: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1004: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
1005: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
1006: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_SERVICE' , TRUE );

Line 1003: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

999: END IF;
1000:
1001:
1002: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1003: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1004: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
1005: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
1006: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_SERVICE' , TRUE );
1007: FND_MSG_PUB.ADD;

Line 1009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1005: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
1006: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_SERVICE' , TRUE );
1007: FND_MSG_PUB.ADD;
1008: END IF;
1009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1010: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1011: x_return_status := FND_API.G_RET_STS_ERROR;
1012: RAISE FND_API.G_EXC_ERROR;
1013: END IF;

Line 1010: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

1006: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_SERVICE' , TRUE );
1007: FND_MSG_PUB.ADD;
1008: END IF;
1009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1010: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1011: x_return_status := FND_API.G_RET_STS_ERROR;
1012: RAISE FND_API.G_EXC_ERROR;
1013: END IF;
1014:

Line 1011: x_return_status := FND_API.G_RET_STS_ERROR;

1007: FND_MSG_PUB.ADD;
1008: END IF;
1009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1010: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1011: x_return_status := FND_API.G_RET_STS_ERROR;
1012: RAISE FND_API.G_EXC_ERROR;
1013: END IF;
1014:
1015: END IF;

Line 1012: RAISE FND_API.G_EXC_ERROR;

1008: END IF;
1009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1010: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1011: x_return_status := FND_API.G_RET_STS_ERROR;
1012: RAISE FND_API.G_EXC_ERROR;
1013: END IF;
1014:
1015: END IF;
1016:

Line 1060: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

1056: aso_debug_pub.ADD ( ' After Calling Copy Tmp Config Copy' , 1 , 'N' );
1057: END IF;
1058:
1059:
1060: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1062: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
1063: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
1064: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_CONFIG_COPY' , TRUE );

Line 1061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1057: END IF;
1058:
1059:
1060: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1062: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
1063: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
1064: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_CONFIG_COPY' , TRUE );
1065: FND_MSG_PUB.ADD;

Line 1067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1063: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
1064: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_CONFIG_COPY' , TRUE );
1065: FND_MSG_PUB.ADD;
1066: END IF;
1067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1068: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1069: x_return_status := FND_API.G_RET_STS_ERROR;
1070: RAISE FND_API.G_EXC_ERROR;
1071: END IF;

Line 1068: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

1064: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_CONFIG_COPY' , TRUE );
1065: FND_MSG_PUB.ADD;
1066: END IF;
1067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1068: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1069: x_return_status := FND_API.G_RET_STS_ERROR;
1070: RAISE FND_API.G_EXC_ERROR;
1071: END IF;
1072:

Line 1069: x_return_status := FND_API.G_RET_STS_ERROR;

1065: FND_MSG_PUB.ADD;
1066: END IF;
1067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1068: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1069: x_return_status := FND_API.G_RET_STS_ERROR;
1070: RAISE FND_API.G_EXC_ERROR;
1071: END IF;
1072:
1073: /* bug 1903605*/

Line 1070: RAISE FND_API.G_EXC_ERROR;

1066: END IF;
1067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1068: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1069: x_return_status := FND_API.G_RET_STS_ERROR;
1070: RAISE FND_API.G_EXC_ERROR;
1071: END IF;
1072:
1073: /* bug 1903605*/
1074: l_old_config_header_id := NULL;

Line 1120: lx_LINE_RELATIONSHIP_ID := FND_API.G_MISS_NUM;

1116:
1117: -- copy line relationships
1118:
1119: FOR line_rel_rec IN c_line_relation ( p_qte_header_id ) LOOP
1120: lx_LINE_RELATIONSHIP_ID := FND_API.G_MISS_NUM;
1121: ASO_LINE_RELATIONSHIPS_PKG.Insert_Row (
1122: px_LINE_RELATIONSHIP_ID => lx_LINE_RELATIONSHIP_ID
1123: , p_CREATION_DATE => SYSDATE
1124: , p_CREATED_BY => G_USER_ID

Line 1148: x_return_status := FND_API.G_RET_STS_SUCCESS;

1144: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1145: aso_debug_pub.ADD ( ' End Copy template Lines API ', 1 , 'N' );
1146: END IF;
1147:
1148: x_return_status := FND_API.G_RET_STS_SUCCESS;
1149:
1150: --
1151: -- End of API body
1152: --

Line 1155: IF FND_API.to_Boolean ( p_commit ) THEN

1151: -- End of API body
1152: --
1153:
1154: -- Standard check for p_commit
1155: IF FND_API.to_Boolean ( p_commit ) THEN
1156: COMMIT WORK;
1157: END IF;
1158:
1159: -- Standard call to get message count and if count is 1, get message info.

Line 1167: WHEN FND_API.G_EXC_ERROR THEN

1163: );
1164:
1165: EXCEPTION
1166:
1167: WHEN FND_API.G_EXC_ERROR THEN
1168: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
1169: P_API_NAME => L_API_NAME
1170: , P_PKG_NAME => G_PKG_NAME
1171: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 1178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1174: , X_MSG_DATA => X_MSG_DATA
1175: , X_RETURN_STATUS => X_RETURN_STATUS
1176: );
1177:
1178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1179: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
1180: P_API_NAME => L_API_NAME
1181: , P_PKG_NAME => G_PKG_NAME
1182: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 1287: x_return_status := FND_API.G_RET_STS_SUCCESS;

1283: aso_debug_pub.ADD ( 'Copy_Tmpl_Service - p_qte_header_id ' || p_qte_header_id , 1 , 'Y' );
1284: aso_debug_pub.ADD ( 'Copy_Tmpl_Service - p_qte_line_id ' || p_qte_line_id , 1 , 'Y' );
1285: END IF;
1286:
1287: x_return_status := FND_API.G_RET_STS_SUCCESS;
1288:
1289: OPEN line_id_from_service ( p_qte_line_id );
1290:
1291: LOOP

Line 1367: l_qte_line_rec.object_version_number := FND_API.G_MISS_NUM;

1363:
1364: --l_tax_detail_tbl := ASO_UTILITY_PVT.Query_Tax_Detail_Rows ( p_qte_header_id , QTE_LINE_ID , l_shipment_tbl );
1365:
1366: l_qte_line_rec.quote_line_id := NULL;
1367: l_qte_line_rec.object_version_number := FND_API.G_MISS_NUM;
1368:
1369: --Setting line attributes as null as they are not required for template 10212323
1370:
1371: l_qte_line_rec.INVOICE_TO_PARTY_SITE_ID := Null;

Line 1396: l_qte_line_dtl_tbl(j).object_version_number := FND_API.G_MISS_NUM;

1392: --BC4J Fix
1393:
1394: FOR j IN 1 .. l_qte_line_dtl_tbl.COUNT LOOP
1395: l_qte_line_dtl_tbl(j).quote_line_detail_id := null;
1396: l_qte_line_dtl_tbl(j).object_version_number := FND_API.G_MISS_NUM;
1397: END LOOP;
1398:
1399: /*FOR j IN 1 .. l_price_adj_tbl.COUNT LOOP
1400: l_price_adj_tbl ( j ).QUOTE_HEADER_ID := p_new_qte_header_id;

Line 1402: l_price_adj_tbl ( j ).object_version_number := FND_API.G_MISS_NUM;

1398:
1399: /*FOR j IN 1 .. l_price_adj_tbl.COUNT LOOP
1400: l_price_adj_tbl ( j ).QUOTE_HEADER_ID := p_new_qte_header_id;
1401: l_price_adj_tbl ( j ).price_adjustment_id := null;
1402: l_price_adj_tbl ( j ).object_version_number := FND_API.G_MISS_NUM;
1403: END LOOP;
1404:
1405: FOR j IN 1 .. l_price_adj_attr_tbl.COUNT LOOP
1406: l_price_adj_attr_tbl(j).price_adj_attrib_id := null;

Line 1407: l_price_adj_attr_tbl(j).object_version_number := FND_API.G_MISS_NUM;

1403: END LOOP;
1404:
1405: FOR j IN 1 .. l_price_adj_attr_tbl.COUNT LOOP
1406: l_price_adj_attr_tbl(j).price_adj_attrib_id := null;
1407: l_price_adj_attr_tbl(j).object_version_number := FND_API.G_MISS_NUM;
1408: END LOOP;
1409:
1410: FOR j IN 1 .. l_price_attr_tbl.COUNT LOOP
1411: l_price_attr_tbl ( j ).QUOTE_HEADER_ID := p_new_qte_header_id;

Line 1413: l_price_attr_tbl ( j ).object_version_number := FND_API.G_MISS_NUM;

1409:
1410: FOR j IN 1 .. l_price_attr_tbl.COUNT LOOP
1411: l_price_attr_tbl ( j ).QUOTE_HEADER_ID := p_new_qte_header_id;
1412: l_price_attr_tbl ( j ).price_attribute_id := null;
1413: l_price_attr_tbl ( j ).object_version_number := FND_API.G_MISS_NUM;
1414: END LOOP;
1415:
1416: */
1417: FOR j IN 1 .. l_shipment_tbl.COUNT LOOP

Line 1420: l_shipment_tbl( j ).object_version_number := FND_API.G_MISS_NUM;

1416: */
1417: FOR j IN 1 .. l_shipment_tbl.COUNT LOOP
1418: l_shipment_tbl( j ).QUOTE_HEADER_ID := p_new_qte_header_id;
1419: l_shipment_tbl( j ).shipment_id := null;
1420: l_shipment_tbl( j ).object_version_number := FND_API.G_MISS_NUM;
1421: l_shipment_tbl( j ).SHIP_TO_CUST_ACCOUNT_ID := Null;
1422: l_shipment_tbl( j ).SHIP_TO_CUST_PARTY_ID := Null;
1423: l_shipment_tbl( j ).SHIP_TO_PARTY_ID := Null;
1424: l_shipment_tbl( j ).SHIP_TO_PARTY_SITE_ID := Null;

Line 1454: l_sales_credit_tbl(j).object_version_number := FND_API.G_MISS_NUM;

1450: /*
1451: FOR j IN 1 .. l_sales_credit_tbl.COUNT LOOP
1452: l_sales_credit_tbl(j).QUOTE_HEADER_ID := p_new_qte_header_id;
1453: l_sales_credit_tbl(j).sales_credit_id := null;
1454: l_sales_credit_tbl(j).object_version_number := FND_API.G_MISS_NUM;
1455: END LOOP;
1456:
1457: FOR j IN 1 .. l_quote_party_tbl.COUNT LOOP
1458: l_quote_party_tbl(j).QUOTE_HEADER_ID := p_new_qte_header_id;

Line 1460: l_quote_party_tbl(j).object_version_number := FND_API.G_MISS_NUM;

1456:
1457: FOR j IN 1 .. l_quote_party_tbl.COUNT LOOP
1458: l_quote_party_tbl(j).QUOTE_HEADER_ID := p_new_qte_header_id;
1459: l_quote_party_tbl(j).QUOTE_PARTY_ID := null;
1460: l_quote_party_tbl(j).object_version_number := FND_API.G_MISS_NUM;
1461: END LOOP;
1462:
1463: FOR j IN 1 .. l_tax_detail_tbl.COUNT LOOP
1464: l_tax_detail_tbl(j).tax_detail_id := null;

Line 1465: l_tax_detail_tbl(j).object_version_number := FND_API.G_MISS_NUM;

1461: END LOOP;
1462:
1463: FOR j IN 1 .. l_tax_detail_tbl.COUNT LOOP
1464: l_tax_detail_tbl(j).tax_detail_id := null;
1465: l_tax_detail_tbl(j).object_version_number := FND_API.G_MISS_NUM;
1466: END LOOP;
1467:
1468: FOR j IN 1 .. l_line_attr_Ext_Tbl.COUNT LOOP
1469: l_line_attr_Ext_Tbl(j).line_attribute_id := null;

Line 1470: l_line_attr_Ext_Tbl(j).object_version_number := FND_API.G_MISS_NUM;

1466: END LOOP;
1467:
1468: FOR j IN 1 .. l_line_attr_Ext_Tbl.COUNT LOOP
1469: l_line_attr_Ext_Tbl(j).line_attribute_id := null;
1470: l_line_attr_Ext_Tbl(j).object_version_number := FND_API.G_MISS_NUM;
1471: END LOOP;
1472:
1473: FOR j IN 1 .. l_freight_charge_tbl.COUNT LOOP
1474: l_freight_charge_tbl(j).freight_charge_id := null;

Line 1475: l_freight_charge_tbl(j).object_version_number := FND_API.G_MISS_NUM;

1471: END LOOP;
1472:
1473: FOR j IN 1 .. l_freight_charge_tbl.COUNT LOOP
1474: l_freight_charge_tbl(j).freight_charge_id := null;
1475: l_freight_charge_tbl(j).object_version_number := FND_API.G_MISS_NUM;
1476: END LOOP;
1477: */
1478:
1479: --End of BC4J Fix

Line 1528: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

1524: l_Line_Attr_Ext_Tbl := l_Line_Attr_Ext_Tbl_out;
1525:
1526:
1527:
1528: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1529: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
1530: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
1531: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYSERVICE AFTER_INSERT' , TRUE );
1532: FND_MSG_PUB.ADD;

Line 1534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1530: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
1531: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYSERVICE AFTER_INSERT' , TRUE );
1532: FND_MSG_PUB.ADD;
1533: END IF;
1534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1535: ELSIF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
1536: RAISE FND_API.G_EXC_ERROR;
1537: END IF;
1538:

Line 1535: ELSIF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN

1531: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYSERVICE AFTER_INSERT' , TRUE );
1532: FND_MSG_PUB.ADD;
1533: END IF;
1534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1535: ELSIF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
1536: RAISE FND_API.G_EXC_ERROR;
1537: END IF;
1538:
1539:

Line 1536: RAISE FND_API.G_EXC_ERROR;

1532: FND_MSG_PUB.ADD;
1533: END IF;
1534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1535: ELSIF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
1536: RAISE FND_API.G_EXC_ERROR;
1537: END IF;
1538:
1539:
1540: lx_line_index_link_tbl ( qte_line_id ) := lx_qte_line_rec.quote_line_id;

Line 1669: x_return_status := FND_API.G_RET_STS_SUCCESS;

1665: aso_debug_pub.ADD ( 'Copy_Config_Tmpl - p_new_qte_header_id ' || p_new_qte_header_id , 1 , 'Y' );
1666: aso_debug_pub.ADD ( 'Copy_Config_Tmpl - p_qte_header_id ' || p_qte_header_id , 1 , 'Y' );
1667: END IF;
1668:
1669: x_return_status := FND_API.G_RET_STS_SUCCESS;
1670:
1671: OPEN line_id_from_config (
1672: p_old_config_header_id
1673: , p_old_config_revision_num

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

1757:
1758: l_ref_ln_id := lx_line_index_link_tbl ( l_qte_line_dtl_tbl ( j ).ref_line_id );
1759: l_qte_line_dtl_tbl ( j ).ref_line_id := l_ref_ln_id;
1760:
1761: IF (l_qte_line_dtl_tbl(j).top_model_line_id IS NOT NULL AND l_qte_line_dtl_tbl(j).top_model_line_id <> FND_API.G_MISS_NUM
1762: and lx_line_index_link_tbl.exists(l_qte_line_dtl_tbl(j).top_model_line_id) ) THEN
1763: l_top_model_line_id := lx_line_index_link_tbl ( l_qte_line_dtl_tbl ( j ).top_model_line_id );
1764: l_qte_line_dtl_tbl ( j ).top_model_line_id := l_top_model_line_id;
1765: END IF;

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

1763: l_top_model_line_id := lx_line_index_link_tbl ( l_qte_line_dtl_tbl ( j ).top_model_line_id );
1764: l_qte_line_dtl_tbl ( j ).top_model_line_id := l_top_model_line_id;
1765: END IF;
1766:
1767: IF (l_qte_line_dtl_tbl ( j ).ato_line_id IS NOT NULL AND l_qte_line_dtl_tbl ( j ).ato_line_id <> FND_API.G_MISS_NUM
1768: and lx_line_index_link_tbl.exists(l_qte_line_dtl_tbl(j).ato_line_id) ) THEN
1769: l_ato_line_id := lx_line_index_link_tbl ( l_qte_line_dtl_tbl ( j ).ato_line_id );
1770: l_qte_line_dtl_tbl ( j ).ato_line_id := l_ato_line_id;
1771: END IF;

Line 1778: l_qte_line_rec.object_version_number := FND_API.G_MISS_NUM;

1774: END LOOP;
1775:
1776: l_quote_line_id := l_qte_line_rec.quote_line_id;
1777: l_qte_line_rec.quote_line_id := NULL;
1778: l_qte_line_rec.object_version_number := FND_API.G_MISS_NUM;
1779:
1780: --Setting line attributes as null as they are not required for template 10212323
1781:
1782: l_qte_line_rec.INVOICE_TO_PARTY_SITE_ID := Null;

Line 1807: l_qte_line_dtl_tbl(j).object_version_number := FND_API.G_MISS_NUM;

1803: --BC4J Fix
1804:
1805: FOR j IN 1 .. l_qte_line_dtl_tbl.COUNT LOOP
1806: l_qte_line_dtl_tbl(j).quote_line_detail_id := null;
1807: l_qte_line_dtl_tbl(j).object_version_number := FND_API.G_MISS_NUM;
1808: END LOOP;
1809:
1810: /*FOR j IN 1 .. l_price_adj_tbl.COUNT LOOP
1811: l_price_adj_tbl ( j ).QUOTE_HEADER_ID := p_new_qte_header_id;

Line 1813: l_price_adj_tbl ( j ).object_version_number := FND_API.G_MISS_NUM;

1809:
1810: /*FOR j IN 1 .. l_price_adj_tbl.COUNT LOOP
1811: l_price_adj_tbl ( j ).QUOTE_HEADER_ID := p_new_qte_header_id;
1812: l_price_adj_tbl ( j ).price_adjustment_id := null;
1813: l_price_adj_tbl ( j ).object_version_number := FND_API.G_MISS_NUM;
1814: END LOOP;
1815:
1816: FOR j IN 1 .. l_price_adj_attr_tbl.COUNT LOOP
1817: l_price_adj_attr_tbl(j).price_adj_attrib_id := null;

Line 1818: l_price_adj_attr_tbl(j).object_version_number := FND_API.G_MISS_NUM;

1814: END LOOP;
1815:
1816: FOR j IN 1 .. l_price_adj_attr_tbl.COUNT LOOP
1817: l_price_adj_attr_tbl(j).price_adj_attrib_id := null;
1818: l_price_adj_attr_tbl(j).object_version_number := FND_API.G_MISS_NUM;
1819: END LOOP;
1820:
1821: FOR j IN 1 .. l_price_attr_tbl.COUNT LOOP
1822: l_price_attr_tbl ( j ).QUOTE_HEADER_ID := p_new_qte_header_id;

Line 1824: l_price_attr_tbl ( j ).object_version_number := FND_API.G_MISS_NUM;

1820:
1821: FOR j IN 1 .. l_price_attr_tbl.COUNT LOOP
1822: l_price_attr_tbl ( j ).QUOTE_HEADER_ID := p_new_qte_header_id;
1823: l_price_attr_tbl ( j ).price_attribute_id := null;
1824: l_price_attr_tbl ( j ).object_version_number := FND_API.G_MISS_NUM;
1825: END LOOP;
1826:
1827: */
1828:

Line 1832: l_shipment_tbl( j ).object_version_number := FND_API.G_MISS_NUM;

1828:
1829: FOR j IN 1 .. l_shipment_tbl.COUNT LOOP
1830: l_shipment_tbl( j ).QUOTE_HEADER_ID := p_new_qte_header_id;
1831: l_shipment_tbl( j ).shipment_id := null;
1832: l_shipment_tbl( j ).object_version_number := FND_API.G_MISS_NUM;
1833: l_shipment_tbl( j ).SHIP_TO_CUST_ACCOUNT_ID := Null;
1834: l_shipment_tbl( j ).SHIP_TO_CUST_PARTY_ID := Null;
1835: l_shipment_tbl( j ).SHIP_TO_PARTY_ID := Null;
1836: l_shipment_tbl( j ).SHIP_TO_PARTY_SITE_ID := Null;

Line 1865: l_sales_credit_tbl(j).object_version_number := FND_API.G_MISS_NUM;

1861:
1862: /* FOR j IN 1 .. l_sales_credit_tbl.COUNT LOOP
1863: l_sales_credit_tbl(j).QUOTE_HEADER_ID := p_new_qte_header_id;
1864: l_sales_credit_tbl(j).sales_credit_id := null;
1865: l_sales_credit_tbl(j).object_version_number := FND_API.G_MISS_NUM;
1866: END LOOP;
1867:
1868: FOR j IN 1 .. l_tax_detail_tbl.COUNT LOOP
1869: l_tax_detail_tbl(j).tax_detail_id := null;

Line 1870: l_tax_detail_tbl(j).object_version_number := FND_API.G_MISS_NUM;

1866: END LOOP;
1867:
1868: FOR j IN 1 .. l_tax_detail_tbl.COUNT LOOP
1869: l_tax_detail_tbl(j).tax_detail_id := null;
1870: l_tax_detail_tbl(j).object_version_number := FND_API.G_MISS_NUM;
1871: END LOOP;
1872:
1873: FOR j IN 1 .. l_quote_party_tbl.COUNT LOOP
1874: l_quote_party_tbl(j).QUOTE_HEADER_ID := p_new_qte_header_id;

Line 1876: l_quote_party_tbl(j).object_version_number := FND_API.G_MISS_NUM;

1872:
1873: FOR j IN 1 .. l_quote_party_tbl.COUNT LOOP
1874: l_quote_party_tbl(j).QUOTE_HEADER_ID := p_new_qte_header_id;
1875: l_quote_party_tbl(j).QUOTE_PARTY_ID := null;
1876: l_quote_party_tbl(j).object_version_number := FND_API.G_MISS_NUM;
1877: END LOOP;
1878:
1879: FOR j IN 1 .. l_line_attr_Ext_Tbl.COUNT LOOP
1880: l_line_attr_Ext_Tbl(j).line_attribute_id := null;

Line 1881: l_line_attr_Ext_Tbl(j).object_version_number := FND_API.G_MISS_NUM;

1877: END LOOP;
1878:
1879: FOR j IN 1 .. l_line_attr_Ext_Tbl.COUNT LOOP
1880: l_line_attr_Ext_Tbl(j).line_attribute_id := null;
1881: l_line_attr_Ext_Tbl(j).object_version_number := FND_API.G_MISS_NUM;
1882: END LOOP;
1883:
1884: FOR j IN 1 .. l_freight_charge_tbl.COUNT LOOP
1885: l_freight_charge_tbl(j).freight_charge_id := null;

Line 1886: l_freight_charge_tbl(j).object_version_number := FND_API.G_MISS_NUM;

1882: END LOOP;
1883:
1884: FOR j IN 1 .. l_freight_charge_tbl.COUNT LOOP
1885: l_freight_charge_tbl(j).freight_charge_id := null;
1886: l_freight_charge_tbl(j).object_version_number := FND_API.G_MISS_NUM;
1887: END LOOP;
1888: */
1889:
1890: --End of BC4J Fix

Line 1940: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

1936: l_Line_Attr_Ext_Tbl := l_Line_Attr_Ext_Tbl_out;
1937:
1938:
1939:
1940: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1941: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
1942: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
1943: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYCONFIG AFTER_INSERT' , TRUE );
1944: FND_MSG_PUB.ADD;

Line 1946: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1942: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
1943: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYCONFIG AFTER_INSERT' , TRUE );
1944: FND_MSG_PUB.ADD;
1945: END IF;
1946: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1947: ELSIF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
1948: RAISE FND_API.G_EXC_ERROR;
1949: END IF;
1950:

Line 1947: ELSIF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN

1943: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYCONFIG AFTER_INSERT' , TRUE );
1944: FND_MSG_PUB.ADD;
1945: END IF;
1946: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1947: ELSIF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
1948: RAISE FND_API.G_EXC_ERROR;
1949: END IF;
1950:
1951:

Line 1948: RAISE FND_API.G_EXC_ERROR;

1944: FND_MSG_PUB.ADD;
1945: END IF;
1946: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1947: ELSIF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
1948: RAISE FND_API.G_EXC_ERROR;
1949: END IF;
1950:
1951:
1952:

Line 1976: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

1972: , X_Msg_Data => x_msg_data
1973: );
1974:
1975:
1976: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1977: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
1978: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
1979: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPY_TMPLCONFIG AFTER_SERVICE' , TRUE );
1980: FND_MSG_PUB.ADD;

Line 1982: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1978: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
1979: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPY_TMPLCONFIG AFTER_SERVICE' , TRUE );
1980: FND_MSG_PUB.ADD;
1981: END IF;
1982: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1983: ELSIF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
1984: RAISE FND_API.G_EXC_ERROR;
1985: END IF;
1986: END IF;

Line 1983: ELSIF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN

1979: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPY_TMPLCONFIG AFTER_SERVICE' , TRUE );
1980: FND_MSG_PUB.ADD;
1981: END IF;
1982: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1983: ELSIF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
1984: RAISE FND_API.G_EXC_ERROR;
1985: END IF;
1986: END IF;
1987: END LOOP;

Line 1984: RAISE FND_API.G_EXC_ERROR;

1980: FND_MSG_PUB.ADD;
1981: END IF;
1982: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1983: ELSIF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
1984: RAISE FND_API.G_EXC_ERROR;
1985: END IF;
1986: END IF;
1987: END LOOP;
1988: