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_MSG_PUB

Line 67: FND_MSG_PUB.initialize;

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
71: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 121: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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;
125: END IF;

Line 123: FND_MSG_PUB.ADD;

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;
125: END IF;
126:
127: -- Check if item is returnable

Line 130: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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;
134: END IF;

Line 132: FND_MSG_PUB.ADD;

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;
134: END IF;
135:
136: IF p_qte_line_rec.operation_code = 'UPDATE' AND

Line 145: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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;
149: END IF;

Line 147: FND_MSG_PUB.ADD;

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;
149: END IF;
150: END IF;
151:

Line 161: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

Line 163: FND_MSG_PUB.ADD;

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;
165:
166: END IF;
167: ELSE -- 'CREATE'

Line 174: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

Line 176: FND_MSG_PUB.ADD;

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;
178:
179: ELSE -- 'CFG'
180:

Line 192: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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;
196: END IF;

Line 194: FND_MSG_PUB.ADD;

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;
196: END IF;
197: END IF;
198:

Line 219: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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;
223: END IF;

Line 221: FND_MSG_PUB.ADD;

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;
223: END IF;
224: END IF; */
225:

Line 260: FND_MSG_PUB.initialize;

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
264: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 285: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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;
289: END IF;

Line 288: FND_MSG_PUB.ADD;

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

Line 298: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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;
302: END IF;

Line 301: FND_MSG_PUB.ADD;

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;
302: END IF;
303: END IF;
304: END IF;
305: CLOSE C_Order_Type;

Line 349: FND_MSG_PUB.initialize;

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
353: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 376: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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
377: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
378: FND_MESSAGE.Set_Token('COLUMN', 'ORDER_LINE_TYPE_ID', FALSE);
379: FND_MSG_PUB.ADD;
380: END IF;

Line 379: FND_MSG_PUB.ADD;

375: END IF;
376: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
377: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
378: FND_MESSAGE.Set_Token('COLUMN', 'ORDER_LINE_TYPE_ID', FALSE);
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

Line 389: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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;
393: END IF;

Line 392: FND_MSG_PUB.ADD;

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;
393: END IF;
394: END IF;
395: CLOSE C_Order_Line_Type;
396: END IF;

Line 530: FND_MSG_PUB.initialize;

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:
533: IF aso_debug_pub.g_debug_flag = 'Y' THEN
534: aso_debug_pub.add('Add_Lines_from_InstallBase - Begin ', 1, 'Y');

Line 603: FND_MSG_PUB.ADD;

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;
605:
606: END IF;
607:

Line 618: FND_MSG_PUB.ADD;

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;
620:
621: ELSE
622:

Line 715: FND_MSG_PUB.ADD;

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;
717:
718: END IF;
719:

Line 878: FND_MSG_PUB.Count_And_Get

874: to_char(x_qte_header_rec.last_update_date,'DD-MM-YYYY HH:MI:SS'),1,'N');
875: aso_debug_pub.add('x_Qte_line_tbl.count = '|| x_Qte_line_tbl.count,1,'N');
876: END IF;
877:
878: FND_MSG_PUB.Count_And_Get
879: ( p_count => x_msg_count,
880: p_data => x_msg_data
881: );
882:

Line 888: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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
889: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
890: ,P_SQLCODE => SQLCODE
891: ,P_SQLERRM => SQLERRM
892: ,X_MSG_COUNT => X_MSG_COUNT

Line 900: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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
901: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
902: ,P_SQLCODE => SQLCODE
903: ,P_SQLERRM => SQLERRM
904: ,X_MSG_COUNT => X_MSG_COUNT

Line 968: FND_MSG_PUB.initialize;

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
972: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1050: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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;
1054: END IF;

Line 1052: FND_MSG_PUB.ADD;

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;
1054: END IF;
1055: END IF;
1056: /*

Line 1070: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) 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;
1074: END IF;

Line 1072: FND_MSG_PUB.ADD;

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;
1074: END IF;
1075: END IF;
1076:

Line 1088: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) 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;
1092: END IF;

Line 1090: FND_MSG_PUB.ADD;

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;
1092: END IF;
1093: /*
1094: END IF;