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

Line 66: IF FND_API.to_Boolean( p_init_msg_list ) THEN

62: l_start_date date;
63: l_end_date date;
64: BEGIN
65: -- Initialize message list if p_init_msg_list is set to TRUE.
66: IF FND_API.to_Boolean( p_init_msg_list ) THEN
67: FND_MSG_PUB.initialize;
68: END IF;
69:
70: -- Initialize API return status to success

Line 71: x_return_status := FND_API.G_RET_STS_SUCCESS;

67: FND_MSG_PUB.initialize;
68: END IF;
69:
70: -- Initialize API return status to success
71: x_return_status := FND_API.G_RET_STS_SUCCESS;
72: IF aso_debug_pub.g_debug_flag = 'Y' THEN
73: aso_debug_pub.add('Entering Validate_Line_Tradein ', 2, 'Y');
74: aso_debug_pub.add('Quote category code = ' || p_qte_header_rec.quote_category_code, 2, 'N');
75: aso_debug_pub.add('Line category code = ' || p_qte_line_rec.line_category_code, 2, 'N');

Line 86: p_qte_line_rec.line_category_code <> FND_API.G_MISS_CHAR then

82: OPEN C_inventory_item;
83: FETCH C_inventory_item into l_inventory_item_id, l_line_category_code;
84:
85: IF p_qte_line_rec.line_category_code is not null and
86: p_qte_line_rec.line_category_code <> FND_API.G_MISS_CHAR then
87: l_line_category_code := p_qte_line_rec.line_category_code;
88: end if;
89: IF p_qte_line_rec.inventory_item_id is not null and
90: p_qte_line_rec.inventory_item_id <> FND_API.G_MISS_NUM then

Line 90: p_qte_line_rec.inventory_item_id <> FND_API.G_MISS_NUM then

86: p_qte_line_rec.line_category_code <> FND_API.G_MISS_CHAR then
87: l_line_category_code := p_qte_line_rec.line_category_code;
88: end if;
89: IF p_qte_line_rec.inventory_item_id is not null and
90: p_qte_line_rec.inventory_item_id <> FND_API.G_MISS_NUM then
91: l_inventory_item_id := p_qte_line_rec.inventory_item_id;
92: end if;
93: CLOSE C_inventory_item;
94: else

Line 96: p_qte_line_rec.line_category_code <> FND_API.G_MISS_CHAR then

92: end if;
93: CLOSE C_inventory_item;
94: else
95: IF p_qte_line_rec.line_category_code is not null and
96: p_qte_line_rec.line_category_code <> FND_API.G_MISS_CHAR then
97: l_line_category_code := p_qte_line_rec.line_category_code;
98: end if;
99: IF p_qte_line_rec.inventory_item_id is not null and
100: p_qte_line_rec.inventory_item_id <> FND_API.G_MISS_NUM then

Line 100: p_qte_line_rec.inventory_item_id <> FND_API.G_MISS_NUM then

96: p_qte_line_rec.line_category_code <> FND_API.G_MISS_CHAR then
97: l_line_category_code := p_qte_line_rec.line_category_code;
98: end if;
99: IF p_qte_line_rec.inventory_item_id is not null and
100: p_qte_line_rec.inventory_item_id <> FND_API.G_MISS_NUM then
101: l_inventory_item_id := p_qte_line_rec.inventory_item_id;
102: end if;
103: end if; -- end check update operation.
104:

Line 120: x_return_status := FND_API.G_RET_STS_ERROR;

116: -- Line level validations
117: IF l_line_category_code = 'RETURN' THEN
118: IF (p_qte_header_rec.quote_category_code <> 'MIXED') THEN
119:
120: x_return_status := FND_API.G_RET_STS_ERROR;
121: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
122: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_LINE_CATEGORY_CODE');
123: FND_MSG_PUB.ADD;
124: END IF;

Line 129: x_return_status := FND_API.G_RET_STS_ERROR;

125: END IF;
126:
127: -- Check if item is returnable
128: IF (NVL(l_returnable_flag,'Y') = 'N') THEN
129: x_return_status := FND_API.G_RET_STS_ERROR;
130: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
131: FND_MESSAGE.Set_Name('ASO', 'ASO_NOT_RETURNABLE');
132: FND_MSG_PUB.ADD;
133: END IF;

Line 144: x_return_status := FND_API.G_RET_STS_ERROR;

140: FETCH C_Service_Available INTO l_service_count;
141: CLOSE C_Service_Available;
142:
143: IF l_service_count > 0 THEN
144: x_return_status := FND_API.G_RET_STS_ERROR;
145: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
146: FND_MESSAGE.Set_Name('ASO', 'ASO_SERVICE_NOT_RETURNABLE');
147: FND_MSG_PUB.ADD;
148: END IF;

Line 158: p_qte_line_rec.item_type_code <> FND_API.G_MISS_CHAR THEN

154: IF (NVL(l_customer_order_enabled_flag,'Y') = 'N') THEN
155: IF p_qte_line_rec.operation_code = 'CREATE' THEN
156: IF p_qte_line_rec.item_type_code <> 'CFG' AND
157: p_qte_line_rec.item_type_code IS NOT NULL AND
158: p_qte_line_rec.item_type_code <> FND_API.G_MISS_CHAR THEN
159:
160: x_return_status := FND_API.G_RET_STS_ERROR;
161: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
162: FND_MESSAGE.Set_Name('ASO', 'ASO_NOT_ORDERABLE');

Line 160: x_return_status := FND_API.G_RET_STS_ERROR;

156: IF p_qte_line_rec.item_type_code <> 'CFG' AND
157: p_qte_line_rec.item_type_code IS NOT NULL AND
158: p_qte_line_rec.item_type_code <> FND_API.G_MISS_CHAR THEN
159:
160: x_return_status := FND_API.G_RET_STS_ERROR;
161: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
162: FND_MESSAGE.Set_Name('ASO', 'ASO_NOT_ORDERABLE');
163: FND_MSG_PUB.ADD;
164: END IF;

Line 171: p_qte_line_rec.item_type_code <> FND_API.G_MISS_CHAR THEN

167: ELSE -- 'CREATE'
168: IF p_qte_line_rec.operation_code = 'UPDATE' THEN
169: IF p_qte_line_rec.item_type_code <> 'CFG' AND
170: p_qte_line_rec.item_type_code IS NOT NULL AND
171: p_qte_line_rec.item_type_code <> FND_API.G_MISS_CHAR THEN
172:
173: x_return_status := FND_API.G_RET_STS_ERROR;
174: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
175: FND_MESSAGE.Set_Name('ASO', 'ASO_NOT_ORDERABLE');

Line 173: x_return_status := FND_API.G_RET_STS_ERROR;

169: IF p_qte_line_rec.item_type_code <> 'CFG' AND
170: p_qte_line_rec.item_type_code IS NOT NULL AND
171: p_qte_line_rec.item_type_code <> FND_API.G_MISS_CHAR THEN
172:
173: x_return_status := FND_API.G_RET_STS_ERROR;
174: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
175: FND_MESSAGE.Set_Name('ASO', 'ASO_NOT_ORDERABLE');
176: FND_MSG_PUB.ADD;
177: END IF;

Line 182: p_qte_line_rec.item_type_code = FND_API.G_MISS_CHAR THEN

178:
179: ELSE -- 'CFG'
180:
181: IF p_qte_line_rec.item_type_code IS NULL OR
182: p_qte_line_rec.item_type_code = FND_API.G_MISS_CHAR THEN
183: OPEN C_item_type;
184: FETCH C_item_type INTO l_item_type_code;
185: CLOSE C_item_type;
186:

Line 189: l_item_type_code <> FND_API.G_MISS_CHAR THEN

185: CLOSE C_item_type;
186:
187: IF l_item_type_code <> 'CFG' AND
188: l_item_type_code IS NOT NULL AND
189: l_item_type_code <> FND_API.G_MISS_CHAR THEN
190:
191: x_return_status := FND_API.G_RET_STS_ERROR;
192: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
193: FND_MESSAGE.Set_Name('ASO', 'ASO_NOT_ORDERABLE');

Line 191: x_return_status := FND_API.G_RET_STS_ERROR;

187: IF l_item_type_code <> 'CFG' AND
188: l_item_type_code IS NOT NULL AND
189: l_item_type_code <> FND_API.G_MISS_CHAR THEN
190:
191: x_return_status := FND_API.G_RET_STS_ERROR;
192: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
193: FND_MESSAGE.Set_Name('ASO', 'ASO_NOT_ORDERABLE');
194: FND_MSG_PUB.ADD;
195: END IF;

Line 213: p_qte_line_rec.order_line_type_id <> FND_API.G_MISS_NUM THEN

209:
210:
211: -- Check if the workflow exists for this line type
212: /* IF p_qte_line_rec.order_line_type_id IS NOT NULL AND
213: p_qte_line_rec.order_line_type_id <> FND_API.G_MISS_NUM THEN
214:
215: OPEN C_workflow;
216: FETCH C_Workflow into l_start_date, l_end_Date;
217: IF C_workflow%NOTFOUND THEN

Line 218: x_return_status := FND_API.G_RET_STS_ERROR;

214:
215: OPEN C_workflow;
216: FETCH C_Workflow into l_start_date, l_end_Date;
217: IF C_workflow%NOTFOUND THEN
218: x_return_status := FND_API.G_RET_STS_ERROR;
219: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
220: FND_MESSAGE.Set_Name('ASO', 'ASO_NO_WORKFLOW');
221: FND_MSG_PUB.ADD;
222: END IF;

Line 259: IF FND_API.to_Boolean( p_init_msg_list ) THEN

255: l_end_date DATE;
256:
257: BEGIN
258: -- Initialize message list if p_init_msg_list is set to TRUE.
259: IF FND_API.to_Boolean( p_init_msg_list ) THEN
260: FND_MSG_PUB.initialize;
261: END IF;
262:
263: -- Initialize API return status to success

Line 264: x_return_status := FND_API.G_RET_STS_SUCCESS;

260: FND_MSG_PUB.initialize;
261: END IF;
262:
263: -- Initialize API return status to success
264: x_return_status := FND_API.G_RET_STS_SUCCESS;
265: IF aso_debug_pub.g_debug_flag = 'Y' THEN
266: aso_debug_pub.add('Entering OrderType ', 2, 'Y');
267: aso_debug_pub.add('Quote category code = ' || p_qte_header_rec.quote_category_code, 2, 'N');
268: aso_debug_pub.add('order type id = ' || p_qte_header_rec.order_type_id, 2, 'N');

Line 271: IF (p_qte_header_rec.order_type_id IS NOT NULL AND p_qte_header_rec.order_type_id <> FND_API.G_MISS_NUM) THEN

267: aso_debug_pub.add('Quote category code = ' || p_qte_header_rec.quote_category_code, 2, 'N');
268: aso_debug_pub.add('order type id = ' || p_qte_header_rec.order_type_id, 2, 'N');
269: END IF;
270:
271: IF (p_qte_header_rec.order_type_id IS NOT NULL AND p_qte_header_rec.order_type_id <> FND_API.G_MISS_NUM) THEN
272: OPEN C_Order_Type(p_qte_header_rec.order_type_id);
273: FETCH C_Order_Type INTO l_order_category_code, l_start_date, l_end_date;
274: IF aso_debug_pub.g_debug_flag = 'Y' THEN
275: aso_debug_pub.add('l_Quote category code = ' || l_order_category_code , 2, 'N');

Line 284: x_return_status := FND_API.G_RET_STS_ERROR;

280: IF (C_Order_Type%NOTFOUND OR
281: (sysdate NOT BETWEEN NVL(l_start_date, sysdate) AND
282: NVL(l_end_date, sysdate))) THEN
283: CLOSE C_Order_Type;
284: x_return_status := FND_API.G_RET_STS_ERROR;
285: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
286: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
287: FND_MESSAGE.Set_Token('COLUMN', 'ORDER_TYPE_ID', FALSE);
288: FND_MSG_PUB.ADD;

Line 292: p_qte_header_rec.quote_category_code = FND_API.G_MISS_CHAR) THEN

288: FND_MSG_PUB.ADD;
289: END IF;
290: ELSE
291: IF (p_qte_header_rec.quote_category_code IS NULL OR
292: p_qte_header_rec.quote_category_code = FND_API.G_MISS_CHAR) THEN
293: p_qte_header_rec.quote_category_code := l_order_category_code;
294:
295: ELSE
296: IF (p_qte_header_rec.quote_category_code <> l_order_category_code) THEN

Line 297: x_return_status := FND_API.G_RET_STS_ERROR;

293: p_qte_header_rec.quote_category_code := l_order_category_code;
294:
295: ELSE
296: IF (p_qte_header_rec.quote_category_code <> l_order_category_code) THEN
297: x_return_status := FND_API.G_RET_STS_ERROR;
298: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
299: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
300: FND_MESSAGE.Set_Token('COLUMN', 'QUOTE_CATEGORY_CODE', FALSE);
301: FND_MSG_PUB.ADD;

Line 348: IF FND_API.to_Boolean( p_init_msg_list ) THEN

344: l_end_date DATE;
345:
346: BEGIN
347: -- Initialize message list if p_init_msg_list is set to TRUE.
348: IF FND_API.to_Boolean( p_init_msg_list ) THEN
349: FND_MSG_PUB.initialize;
350: END IF;
351:
352: -- Initialize API return status to success

Line 353: x_return_status := FND_API.G_RET_STS_SUCCESS;

349: FND_MSG_PUB.initialize;
350: END IF;
351:
352: -- Initialize API return status to success
353: x_return_status := FND_API.G_RET_STS_SUCCESS;
354: IF aso_debug_pub.g_debug_flag = 'Y' THEN
355: aso_debug_pub.add('Entering LineType ', 2, 'Y');
356: aso_debug_pub.add('Line category code = ' || p_qte_line_rec.line_category_code, 2, 'N');
357: aso_debug_pub.add('Line Type = ' || p_qte_line_rec.order_line_type_id, 2, 'N');

Line 360: IF (p_qte_line_rec.order_line_type_id IS NOT NULL AND p_qte_line_rec.order_line_type_id <> FND_API.G_MISS_NUM) THEN

356: aso_debug_pub.add('Line category code = ' || p_qte_line_rec.line_category_code, 2, 'N');
357: aso_debug_pub.add('Line Type = ' || p_qte_line_rec.order_line_type_id, 2, 'N');
358: END IF;
359:
360: IF (p_qte_line_rec.order_line_type_id IS NOT NULL AND p_qte_line_rec.order_line_type_id <> FND_API.G_MISS_NUM) THEN
361: OPEN C_Order_Line_Type(p_qte_line_rec.order_line_type_id);
362: FETCH C_Order_Line_Type INTO l_line_category_code, l_start_date, l_end_date;
363: IF aso_debug_pub.g_debug_flag = 'Y' THEN
364: aso_debug_pub.add('l Line category code = ' || l_line_category_code, 2, 'N');

Line 372: x_return_status := FND_API.G_RET_STS_ERROR;

368: IF (C_Order_Line_Type%NOTFOUND OR
369: (sysdate NOT BETWEEN NVL(l_start_date, sysdate) AND
370: NVL(l_end_date, sysdate))) THEN
371: CLOSE C_Order_Line_Type;
372: x_return_status := FND_API.G_RET_STS_ERROR;
373: IF aso_debug_pub.g_debug_flag = 'Y' THEN
374: aso_debug_pub.add('Create_Quote_lines - check line type 1', 1, 'Y');
375: END IF;
376: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 383: p_qte_line_rec.line_category_code = FND_API.G_MISS_CHAR) THEN

379: FND_MSG_PUB.ADD;
380: END IF;
381: ELSE
382: IF (p_qte_line_rec.line_category_code IS NULL OR
383: p_qte_line_rec.line_category_code = FND_API.G_MISS_CHAR) THEN
384: p_qte_line_rec.line_category_code := l_line_category_code;
385:
386: ELSE
387: IF (p_qte_line_rec.line_category_code <> l_line_category_code) THEN

Line 388: x_return_status := FND_API.G_RET_STS_ERROR;

384: p_qte_line_rec.line_category_code := l_line_category_code;
385:
386: ELSE
387: IF (p_qte_line_rec.line_category_code <> l_line_category_code) THEN
388: x_return_status := FND_API.G_RET_STS_ERROR;
389: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
390: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
391: FND_MESSAGE.Set_Token('COLUMN', 'LINE_CATEGORY_CODE', FALSE);
392: FND_MSG_PUB.ADD;

Line 400: p_qte_line_rec.line_category_code = FND_API.G_MISS_CHAR)

396: END IF;
397: END IF;
398: ELSE -- order_line_type_id is null
399: IF ((p_qte_line_rec.line_category_code IS NULL OR
400: p_qte_line_rec.line_category_code = FND_API.G_MISS_CHAR)
401: AND p_qte_line_rec.operation_code = 'CREATE') THEN
402: p_qte_line_rec.line_category_code := 'ORDER';
403: END IF;
404: END IF;

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

411:
412:
413: PROCEDURE Add_Lines_from_InstallBase(
414: P_Api_Version_Number IN NUMBER,
415: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
416: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
417: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
418: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type
419: := ASO_QUOTE_PUB.G_Miss_Control_Rec,

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

412:
413: PROCEDURE Add_Lines_from_InstallBase(
414: P_Api_Version_Number IN NUMBER,
415: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
416: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
417: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
418: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type
419: := ASO_QUOTE_PUB.G_Miss_Control_Rec,
420: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type

Line 417: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

413: PROCEDURE Add_Lines_from_InstallBase(
414: P_Api_Version_Number IN NUMBER,
415: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
416: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
417: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
418: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type
419: := ASO_QUOTE_PUB.G_Miss_Control_Rec,
420: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
421: := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,

Line 520: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

516: -- Standard Start of API savepoint
517: SAVEPOINT Add_Lines_from_InstallBase_PVT;
518:
519: -- Standard call to check for call compatibility.
520: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
521: p_api_version_number,
522: l_api_name,
523: G_PKG_NAME) THEN
524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

520: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
521: p_api_version_number,
522: l_api_name,
523: G_PKG_NAME) THEN
524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
525: END IF;
526:
527: -- Initialize message list if p_init_msg_list is set to TRUE.
528: IF FND_API.to_Boolean( p_init_msg_list )

Line 528: IF FND_API.to_Boolean( p_init_msg_list )

524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
525: END IF;
526:
527: -- Initialize message list if p_init_msg_list is set to TRUE.
528: IF FND_API.to_Boolean( p_init_msg_list )
529: THEN
530: FND_MSG_PUB.initialize;
531: END IF;
532:

Line 538: x_return_status := FND_API.G_RET_STS_SUCCESS;

534: aso_debug_pub.add('Add_Lines_from_InstallBase - Begin ', 1, 'Y');
535: END IF;
536:
537: -- Initialize API return status to SUCCESS
538: x_return_status := FND_API.G_RET_STS_SUCCESS;
539:
540: IF p_qte_header_rec.org_id IS NULL OR
541: p_qte_header_rec.org_id = FND_API.G_MISS_NUM THEN
542:

Line 541: p_qte_header_rec.org_id = FND_API.G_MISS_NUM THEN

537: -- Initialize API return status to SUCCESS
538: x_return_status := FND_API.G_RET_STS_SUCCESS;
539:
540: IF p_qte_header_rec.org_id IS NULL OR
541: p_qte_header_rec.org_id = FND_API.G_MISS_NUM THEN
542:
543: OPEN C_Get_Header_Org(p_qte_header_rec.quote_header_id);
544: FETCH C_Get_Header_Org INTO l_org_id;
545: CLOSE C_Get_Header_Org;

Line 600: x_return_status := FND_API.G_RET_STS_ERROR;

596: aso_debug_pub.add('Add_Lines_from_InstallBase - Invalid instance: ', 1, 'N');
597: END IF;
598:
599: CLOSE C_Get_Item_Details;
600: x_return_status := FND_API.G_RET_STS_ERROR;
601:
602: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INSTANCE');
603: FND_MSG_PUB.ADD;
604: RAISE FND_API.G_EXC_ERROR;

Line 604: RAISE FND_API.G_EXC_ERROR;

600: x_return_status := FND_API.G_RET_STS_ERROR;
601:
602: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INSTANCE');
603: FND_MSG_PUB.ADD;
604: RAISE FND_API.G_EXC_ERROR;
605:
606: END IF;
607:
608: CLOSE C_Get_Item_Details;

Line 615: x_return_status := FND_API.G_RET_STS_ERROR;

611: IF aso_debug_pub.g_debug_flag = 'Y' THEN
612: aso_debug_pub.add('Add_Lines_from_InstallBase - Not Returnable instance: ', 1, 'N');
613: END IF;
614:
615: x_return_status := FND_API.G_RET_STS_ERROR;
616:
617: FND_MESSAGE.Set_Name('ASO', 'ASO_NOT_RETURNABLE');
618: FND_MSG_PUB.ADD;
619: RAISE FND_API.G_EXC_ERROR;

Line 619: RAISE FND_API.G_EXC_ERROR;

615: x_return_status := FND_API.G_RET_STS_ERROR;
616:
617: FND_MESSAGE.Set_Name('ASO', 'ASO_NOT_RETURNABLE');
618: FND_MSG_PUB.ADD;
619: RAISE FND_API.G_EXC_ERROR;
620:
621: ELSE
622:
623: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 637: IF P_Instance_Tbl(i).Price_List_Id <> FND_API.G_MISS_NUM AND

633: l_qte_line_tbl(j).Quantity := l_Cur_Inst.Quantity;
634: l_qte_line_tbl(j).UOM_Code := l_Cur_Inst.Unit_Of_Measure;
635: l_qte_line_tbl(j).Line_Category_Code := 'RETURN';
636: l_qte_line_tbl(j).Operation_Code := 'CREATE';
637: IF P_Instance_Tbl(i).Price_List_Id <> FND_API.G_MISS_NUM AND
638: P_Instance_Tbl(i).Price_List_Id IS NOT NULL THEN
639: l_qte_line_tbl(j).Price_List_Id := P_Instance_Tbl(i).Price_List_Id;
640: ELSE
641: l_qte_line_tbl(j).Price_List_Id := FND_API.G_MISS_NUM;

Line 641: l_qte_line_tbl(j).Price_List_Id := FND_API.G_MISS_NUM;

637: IF P_Instance_Tbl(i).Price_List_Id <> FND_API.G_MISS_NUM AND
638: P_Instance_Tbl(i).Price_List_Id IS NOT NULL THEN
639: l_qte_line_tbl(j).Price_List_Id := P_Instance_Tbl(i).Price_List_Id;
640: ELSE
641: l_qte_line_tbl(j).Price_List_Id := FND_API.G_MISS_NUM;
642: END IF;
643: /*
644: IF l_Cur_Inst.last_oe_order_line_id IS NOT NULL THEN
645: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 712: x_return_status := FND_API.G_RET_STS_ERROR;

708: aso_debug_pub.add('Add_Lines_from_InstallBase - Invalid child instance: ', 1, 'N');
709: END IF;
710:
711: CLOSE C_Get_Item_Details;
712: x_return_status := FND_API.G_RET_STS_ERROR;
713:
714: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INSTANCE');
715: FND_MSG_PUB.ADD;
716: RAISE FND_API.G_EXC_ERROR;

Line 716: RAISE FND_API.G_EXC_ERROR;

712: x_return_status := FND_API.G_RET_STS_ERROR;
713:
714: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_INSTANCE');
715: FND_MSG_PUB.ADD;
716: RAISE FND_API.G_EXC_ERROR;
717:
718: END IF;
719:
720: CLOSE C_Get_Item_Details;

Line 737: IF P_Instance_Tbl(i).Price_List_Id <> FND_API.G_MISS_NUM AND

733: l_qte_line_tbl(j).Quantity := l_Cur_Child.Quantity;
734: l_qte_line_tbl(j).UOM_Code := l_Cur_Child.Unit_Of_Measure;
735: l_qte_line_tbl(j).Line_Category_Code := 'RETURN';
736: l_qte_line_tbl(j).Operation_Code := 'CREATE';
737: IF P_Instance_Tbl(i).Price_List_Id <> FND_API.G_MISS_NUM AND
738: P_Instance_Tbl(i).Price_List_Id IS NOT NULL THEN
739: l_qte_line_tbl(j).Price_List_Id := P_Instance_Tbl(i).Price_List_Id;
740: ELSE
741: l_qte_line_tbl(j).Price_List_Id := FND_API.G_MISS_NUM;

Line 741: l_qte_line_tbl(j).Price_List_Id := FND_API.G_MISS_NUM;

737: IF P_Instance_Tbl(i).Price_List_Id <> FND_API.G_MISS_NUM AND
738: P_Instance_Tbl(i).Price_List_Id IS NOT NULL THEN
739: l_qte_line_tbl(j).Price_List_Id := P_Instance_Tbl(i).Price_List_Id;
740: ELSE
741: l_qte_line_tbl(j).Price_List_Id := FND_API.G_MISS_NUM;
742: END IF;
743:
744: l_qte_line_tbl(j).Price_List_Id := P_Instance_Tbl(i).Price_List_Id;
745: /*

Line 810: l_control_rec.DEFAULTING_FLAG := FND_API.G_TRUE;

806: END IF;
807:
808: if l_prof_val = 'Y' then
809: l_control_rec.DEFAULTING_FWK_FLAG := 'Y';
810: l_control_rec.DEFAULTING_FLAG := FND_API.G_TRUE;
811: l_control_rec.APPLICATION_TYPE_CODE := 'QUOTING HTML';
812: else
813: l_control_rec.DEFAULTING_FWK_FLAG := 'N';
814: l_control_rec.DEFAULTING_FLAG := FND_API.G_FALSE;

Line 814: l_control_rec.DEFAULTING_FLAG := FND_API.G_FALSE;

810: l_control_rec.DEFAULTING_FLAG := FND_API.G_TRUE;
811: l_control_rec.APPLICATION_TYPE_CODE := 'QUOTING HTML';
812: else
813: l_control_rec.DEFAULTING_FWK_FLAG := 'N';
814: l_control_rec.DEFAULTING_FLAG := FND_API.G_FALSE;
815: end if;
816:
817: IF aso_debug_pub.g_debug_flag = 'Y' THEN
818: aso_debug_pub.add('Add_Lines_from_InstallBase - calling ASO_QUOTE_PUB.Update_Quote: ', 1, 'N');

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

857: IF aso_debug_pub.g_debug_flag = 'Y' THEN
858: aso_debug_pub.add('Add_Lines_from_InstallBase - after update_quote: x_ret_status: '||x_return_status, 1, 'N');
859: END IF;
860:
861: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
862: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
863: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
864: RAISE FND_API.G_EXC_ERROR;
865: END IF;

Line 862: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

858: aso_debug_pub.add('Add_Lines_from_InstallBase - after update_quote: x_ret_status: '||x_return_status, 1, 'N');
859: END IF;
860:
861: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
862: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
863: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
864: RAISE FND_API.G_EXC_ERROR;
865: END IF;
866:

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

859: END IF;
860:
861: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
862: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
863: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
864: RAISE FND_API.G_EXC_ERROR;
865: END IF;
866:
867: ELSE

Line 864: RAISE FND_API.G_EXC_ERROR;

860:
861: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
862: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
863: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
864: RAISE FND_API.G_EXC_ERROR;
865: END IF;
866:
867: ELSE
868: x_qte_header_rec := p_qte_header_rec;

Line 884: WHEN FND_API.G_EXC_ERROR THEN

880: p_data => x_msg_data
881: );
882:
883: EXCEPTION
884: WHEN FND_API.G_EXC_ERROR THEN
885: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
886: P_API_NAME => L_API_NAME
887: ,P_PKG_NAME => G_PKG_NAME
888: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 896: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

892: ,X_MSG_COUNT => X_MSG_COUNT
893: ,X_MSG_DATA => X_MSG_DATA
894: ,X_RETURN_STATUS => X_RETURN_STATUS);
895:
896: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
897: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
898: P_API_NAME => L_API_NAME
899: ,P_PKG_NAME => G_PKG_NAME
900: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 924: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

920: END Add_Lines_from_InstallBase;
921:
922:
923: PROCEDURE Validate_IB_Return_Qty(
924: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
925: p_Qte_Line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
926: p_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type,
927: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
928: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 967: IF FND_API.to_Boolean( p_init_msg_list ) THEN

963:
964: BEGIN
965:
966: -- Initialize message list if p_init_msg_list is set to TRUE.
967: IF FND_API.to_Boolean( p_init_msg_list ) THEN
968: FND_MSG_PUB.initialize;
969: END IF;
970:
971: -- Initialize API return status to success

Line 972: x_return_status := FND_API.G_RET_STS_SUCCESS;

968: FND_MSG_PUB.initialize;
969: END IF;
970:
971: -- Initialize API return status to success
972: x_return_status := FND_API.G_RET_STS_SUCCESS;
973: IF aso_debug_pub.g_debug_flag = 'Y' THEN
974: aso_debug_pub.add('Entering Validate_IB_Return_Qty ', 2, 'Y');
975: aso_debug_pub.add('Validate_IB_Return_Qty - p_qte_line_rec.operation_code: '||p_qte_line_rec.operation_code, 1, 'N');
976: aso_debug_pub.add('Validate_IB_Return_Qty - p_qte_line_rec.operation_code: '||p_qte_line_rec.operation_code, 1, 'N');

Line 986: IF p_qte_line_rec.quantity IS NOT NULL AND p_qte_line_rec.quantity <> FND_API.G_MISS_NUM THEN

982: OPEN C_Get_Dtl_Info(p_qte_line_rec.quote_line_id);
983: FETCH C_Get_Dtl_Info INTO l_inst_id, l_ref_type, l_ref_id;
984: CLOSE C_Get_Dtl_Info;
985:
986: IF p_qte_line_rec.quantity IS NOT NULL AND p_qte_line_rec.quantity <> FND_API.G_MISS_NUM THEN
987: l_qte_quantity := p_qte_line_rec.quantity;
988: ELSE
989: OPEN C_Get_Qot_Qty(p_qte_line_rec.quote_line_id);
990: FETCH C_Get_Qot_Qty INTO l_qte_quantity;

Line 1036: l_qte_quantity <> FND_API.G_MISS_NUM THEN

1032: aso_debug_pub.add('Validate_IB_Return_Qty - l_qte_quantity: '||l_qte_quantity, 1, 'N');
1033: END IF;
1034:
1035: IF l_qte_quantity IS NOT NULL AND
1036: l_qte_quantity <> FND_API.G_MISS_NUM THEN
1037:
1038: IF l_inst_id IS NOT NULL AND
1039: l_inst_id <> FND_API.G_MISS_NUM THEN
1040:

Line 1039: l_inst_id <> FND_API.G_MISS_NUM THEN

1035: IF l_qte_quantity IS NOT NULL AND
1036: l_qte_quantity <> FND_API.G_MISS_NUM THEN
1037:
1038: IF l_inst_id IS NOT NULL AND
1039: l_inst_id <> FND_API.G_MISS_NUM THEN
1040:
1041: IF p_qte_line_rec.line_category_code IS NOT NULL AND
1042: p_qte_line_rec.line_category_code <> FND_API.G_MISS_CHAR THEN
1043:

Line 1042: p_qte_line_rec.line_category_code <> FND_API.G_MISS_CHAR THEN

1038: IF l_inst_id IS NOT NULL AND
1039: l_inst_id <> FND_API.G_MISS_NUM THEN
1040:
1041: IF p_qte_line_rec.line_category_code IS NOT NULL AND
1042: p_qte_line_rec.line_category_code <> FND_API.G_MISS_CHAR THEN
1043:
1044: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1045: aso_debug_pub.add('Validate_IB_Return_Qty - p_qte_line_rec.line_category_code: '||p_qte_line_rec.line_category_code, 1, 'N');
1046: END IF;

Line 1049: x_return_status := FND_API.G_RET_STS_ERROR;

1045: aso_debug_pub.add('Validate_IB_Return_Qty - p_qte_line_rec.line_category_code: '||p_qte_line_rec.line_category_code, 1, 'N');
1046: END IF;
1047:
1048: IF p_qte_line_rec.line_category_code <> 'RETURN' THEN
1049: x_return_status := FND_API.G_RET_STS_ERROR;
1050: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1051: FND_MESSAGE.Set_Name('ASO', 'ASO_INST_RETURN_CODE');
1052: FND_MSG_PUB.ADD;
1053: END IF;

Line 1059: l_ref_id <> FND_API.G_MISS_NUM THEN

1055: END IF;
1056: /*
1057: IF l_ref_type = 'ORDER' THEN
1058: IF l_ref_id IS NOT NULL AND
1059: l_ref_id <> FND_API.G_MISS_NUM THEN
1060:
1061: OPEN C_Get_Ord_Qty(l_ref_id);
1062: FETCH C_Get_Ord_Qty INTO l_qty;
1063: CLOSE C_Get_Ord_Qty;

Line 1069: x_return_status := FND_API.G_RET_STS_ERROR;

1065: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1066: aso_debug_pub.add('Validate_IB_Return_Qty - l_qty: '||l_qty, 1, 'N');
1067: END IF;
1068: IF l_qty <> l_qte_quantity THEN
1069: x_return_status := FND_API.G_RET_STS_ERROR;
1070: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1071: FND_MESSAGE.Set_Name('ASO', 'ASO_REFERENCED_RET_QTY');
1072: FND_MSG_PUB.ADD;
1073: END IF;

Line 1087: x_return_status := FND_API.G_RET_STS_ERROR;

1083: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1084: aso_debug_pub.add('Validate_IB_Return_Qty - l_qty: '||l_qty, 1, 'N');
1085: END IF;
1086: IF l_qty < l_qte_quantity THEN
1087: x_return_status := FND_API.G_RET_STS_ERROR;
1088: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1089: FND_MESSAGE.Set_Name('ASO', 'ASO_NOT_REFERENCED_RET_QTY');
1090: FND_MSG_PUB.ADD;
1091: END IF;