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

Line 22: IF p_Item_Orderability_Import_Tbl(i).status = FND_API.G_RET_STS_SUCCESS then

18:
19: for i in 1..p_Item_Orderability_Import_Tbl.count loop
20:
21: OE_ITORD_PUB.Check_required_fields( p_Item_Orderability_Import_Tbl(i));
22: IF p_Item_Orderability_Import_Tbl(i).status = FND_API.G_RET_STS_SUCCESS then
23: OE_ITORD_PUB.Validate_required_fields ( p_Item_Orderability_Import_Tbl(i));
24: IF p_Item_Orderability_Import_Tbl(i).status = FND_API.G_RET_STS_SUCCESS then
25: OE_ITORD_PUB.Validate_conditional_fields ( p_Item_Orderability_Import_Tbl(i));
26: IF p_Item_Orderability_Import_Tbl(i).status = FND_API.G_RET_STS_SUCCESS then

Line 24: IF p_Item_Orderability_Import_Tbl(i).status = FND_API.G_RET_STS_SUCCESS then

20:
21: OE_ITORD_PUB.Check_required_fields( p_Item_Orderability_Import_Tbl(i));
22: IF p_Item_Orderability_Import_Tbl(i).status = FND_API.G_RET_STS_SUCCESS then
23: OE_ITORD_PUB.Validate_required_fields ( p_Item_Orderability_Import_Tbl(i));
24: IF p_Item_Orderability_Import_Tbl(i).status = FND_API.G_RET_STS_SUCCESS then
25: OE_ITORD_PUB.Validate_conditional_fields ( p_Item_Orderability_Import_Tbl(i));
26: IF p_Item_Orderability_Import_Tbl(i).status = FND_API.G_RET_STS_SUCCESS then
27: OE_ITORD_PUB.check_duplicate_rules ( p_Item_Orderability_Import_Tbl(i) );
28: IF p_Item_Orderability_Import_Tbl(i).status = FND_API.G_RET_STS_SUCCESS then

Line 26: IF p_Item_Orderability_Import_Tbl(i).status = FND_API.G_RET_STS_SUCCESS then

22: IF p_Item_Orderability_Import_Tbl(i).status = FND_API.G_RET_STS_SUCCESS then
23: OE_ITORD_PUB.Validate_required_fields ( p_Item_Orderability_Import_Tbl(i));
24: IF p_Item_Orderability_Import_Tbl(i).status = FND_API.G_RET_STS_SUCCESS then
25: OE_ITORD_PUB.Validate_conditional_fields ( p_Item_Orderability_Import_Tbl(i));
26: IF p_Item_Orderability_Import_Tbl(i).status = FND_API.G_RET_STS_SUCCESS then
27: OE_ITORD_PUB.check_duplicate_rules ( p_Item_Orderability_Import_Tbl(i) );
28: IF p_Item_Orderability_Import_Tbl(i).status = FND_API.G_RET_STS_SUCCESS then
29: OE_ITORD_PUB.Validate_rules_DFF (p_Item_Orderability_Import_Tbl(i));
30: IF p_Item_Orderability_Import_Tbl(i).status = FND_API.G_RET_STS_SUCCESS then

Line 28: IF p_Item_Orderability_Import_Tbl(i).status = FND_API.G_RET_STS_SUCCESS then

24: IF p_Item_Orderability_Import_Tbl(i).status = FND_API.G_RET_STS_SUCCESS then
25: OE_ITORD_PUB.Validate_conditional_fields ( p_Item_Orderability_Import_Tbl(i));
26: IF p_Item_Orderability_Import_Tbl(i).status = FND_API.G_RET_STS_SUCCESS then
27: OE_ITORD_PUB.check_duplicate_rules ( p_Item_Orderability_Import_Tbl(i) );
28: IF p_Item_Orderability_Import_Tbl(i).status = FND_API.G_RET_STS_SUCCESS then
29: OE_ITORD_PUB.Validate_rules_DFF (p_Item_Orderability_Import_Tbl(i));
30: IF p_Item_Orderability_Import_Tbl(i).status = FND_API.G_RET_STS_SUCCESS then
31: OE_ITORD_PUB.insert_rules(p_Item_Orderability_Import_Tbl(i));
32: END IF;

Line 30: IF p_Item_Orderability_Import_Tbl(i).status = FND_API.G_RET_STS_SUCCESS then

26: IF p_Item_Orderability_Import_Tbl(i).status = FND_API.G_RET_STS_SUCCESS then
27: OE_ITORD_PUB.check_duplicate_rules ( p_Item_Orderability_Import_Tbl(i) );
28: IF p_Item_Orderability_Import_Tbl(i).status = FND_API.G_RET_STS_SUCCESS then
29: OE_ITORD_PUB.Validate_rules_DFF (p_Item_Orderability_Import_Tbl(i));
30: IF p_Item_Orderability_Import_Tbl(i).status = FND_API.G_RET_STS_SUCCESS then
31: OE_ITORD_PUB.insert_rules(p_Item_Orderability_Import_Tbl(i));
32: END IF;
33:
34: END IF;

Line 71: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_SUCCESS;

67: IF l_debug_level > 0 then
68: oe_debug_pub.add('Entering OE_ITORD_PUB.Check_required_fields');
69: End If;
70:
71: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_SUCCESS;
72: p_Item_Orderability_Import_Rec.msg_data := NULL;
73: p_Item_Orderability_Import_Rec.msg_count := 0;
74:
75: IF p_Item_Orderability_Import_Rec.org_id is NULL then

Line 79: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;

75: IF p_Item_Orderability_Import_Rec.org_id is NULL then
76:
77: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
78: fnd_message.set_token('ATTRIBUTE','ORG_ID');
79: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;
80: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;
81: p_Item_Orderability_Import_Rec.msg_count := p_Item_Orderability_Import_Rec.msg_count + 1;
82: END IF;
83:

Line 87: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;

83:
84: IF p_Item_Orderability_Import_Rec.ITEM_LEVEL is NULL then
85: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
86: fnd_message.set_token('ATTRIBUTE','ITEM_LEVEL');
87: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;
88: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get ;
89: p_Item_Orderability_Import_Rec.msg_count := p_Item_Orderability_Import_Rec.msg_count + 1;
90: END IF;
91:

Line 95: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;

91:
92: IF p_Item_Orderability_Import_Rec.generally_available is NULL then
93: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
94: fnd_message.set_token('ATTRIBUTE','GENERALLY_AVAILABLE');
95: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;
96: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get ;
97: p_Item_Orderability_Import_Rec.msg_count := p_Item_Orderability_Import_Rec.msg_count + 1;
98: END IF;
99:

Line 103: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;

99:
100: IF p_Item_Orderability_Import_Rec.rule_level is NULL then
101: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
102: fnd_message.set_token('ATTRIBUTE','RULE_LEVEL');
103: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;
104: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;
105: p_Item_Orderability_Import_Rec.msg_count := p_Item_Orderability_Import_Rec.msg_count + 1;
106: END IF;
107:

Line 112: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;

108:
109: IF p_Item_Orderability_Import_Rec.created_by is NULL then
110: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
111: fnd_message.set_token('ATTRIBUTE','CREATED_BY');
112: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;
113: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;
114: p_Item_Orderability_Import_Rec.msg_count := p_Item_Orderability_Import_Rec.msg_count + 1;
115: END IF;
116:

Line 120: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;

116:
117: IF p_Item_Orderability_Import_Rec.creation_date is NULL then
118: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
119: fnd_message.set_token('ATTRIBUTE','CREATION_DATE');
120: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;
121: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;
122: p_Item_Orderability_Import_Rec.msg_count := p_Item_Orderability_Import_Rec.msg_count + 1;
123:
124: END IF;

Line 129: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;

125:
126: IF p_Item_Orderability_Import_Rec.last_updated_by is NULL then
127: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
128: fnd_message.set_token('ATTRIBUTE','LAST_UPDATED_BY');
129: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;
130: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;
131: p_Item_Orderability_Import_Rec.msg_count := p_Item_Orderability_Import_Rec.msg_count + 1;
132: END IF;
133:

Line 137: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;

133:
134: IF p_Item_Orderability_Import_Rec.last_update_date is NULL then
135: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
136: fnd_message.set_token('ATTRIBUTE','LAST_UPDATE_DATE');
137: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;
138: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;
139: p_Item_Orderability_Import_Rec.msg_count := p_Item_Orderability_Import_Rec.msg_count + 1;
140: END IF;
141:

Line 164: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_SUCCESS;

160: IF l_debug_level > 0 then
161: oe_debug_pub.add('Entering OE_ITORD_PUB.Validate_required_fields');
162: End If;
163:
164: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_SUCCESS;
165: p_Item_Orderability_Import_Rec.msg_data := NULL;
166: p_Item_Orderability_Import_Rec.msg_count := 0;
167:
168: IF p_Item_Orderability_Import_Rec.org_id is NOT NULL then

Line 178: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;

174: Exception
175: when no_data_found then
176: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
177: fnd_message.set_token('ATTRIBUTE','ORG_ID');
178: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;
179: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;
180: p_Item_Orderability_Import_Rec.msg_count := p_Item_Orderability_Import_Rec.msg_count + 1;
181: End;
182: END IF;

Line 189: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;

185:
186: IF p_Item_Orderability_Import_Rec.ITEM_LEVEL NOT IN ('I','C') then
187: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
188: fnd_message.set_token('ATTRIBUTE','ITEM_LEVEL');
189: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;
190: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;
191: p_Item_Orderability_Import_Rec.msg_count := p_Item_Orderability_Import_Rec.msg_count + 1;
192: END IF;
193:

Line 214: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;

210:
211: ) then
212: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
213: fnd_message.set_token('ATTRIBUTE','RULE_LEVEL');
214: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;
215: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;
216: p_Item_Orderability_Import_Rec.msg_count := p_Item_Orderability_Import_Rec.msg_count + 1;
217:
218: END IF;

Line 228: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;

224: IF p_Item_Orderability_Import_Rec.generally_available is NOT NULL then
225: IF p_Item_Orderability_Import_Rec.generally_available NOT IN ('Y' ,'N' ) then
226: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
227: fnd_message.set_token('ATTRIBUTE','GENERALLY_AVAILABLE');
228: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;
229: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;
230: p_Item_Orderability_Import_Rec.msg_count := p_Item_Orderability_Import_Rec.msg_count + 1;
231:
232: END IF;

Line 247: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;

243: Exception
244: when others then
245: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
246: fnd_message.set_token('ATTRIBUTE','CREATED_BY');
247: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;
248: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;
249: p_Item_Orderability_Import_Rec.msg_count := p_Item_Orderability_Import_Rec.msg_count + 1;
250:
251: End;

Line 265: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;

261: Exception
262: when others then
263: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
264: fnd_message.set_token('ATTRIBUTE','LAST_UPDATED_BY');
265: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;
266: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;
267: p_Item_Orderability_Import_Rec.msg_count := p_Item_Orderability_Import_Rec.msg_count + 1;
268:
269: End;

Line 279: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_UNEXP_ERROR;

275: End If;
276:
277: Exception
278: when others then
279: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_UNEXP_ERROR;
280: p_Item_Orderability_Import_Rec.msg_data := SQLERRM;
281: p_Item_Orderability_Import_Rec.msg_count := 1;
282: End Validate_required_fields;
283:

Line 296: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_SUCCESS;

292: IF l_debug_level > 0 then
293: oe_debug_pub.add('Entering OE_ITORD_PUB.Validate_conditional_fields');
294: End If;
295:
296: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_SUCCESS;
297: p_Item_Orderability_Import_Rec.msg_data := NULL;
298: p_Item_Orderability_Import_Rec.msg_count := 0;
299:
300:

Line 307: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;

303: IF p_Item_Orderability_Import_Rec.customer_id IS NULL then
304: fnd_message.set_name('ONT','OE_ITORD_FIELD_REQUIRED');
305: fnd_message.set_token('FIELD','Rule Level Value');
306: fnd_message.set_token('CRITERIA','CUSTOMER_ID');
307: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;
308: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;
309: p_Item_Orderability_Import_Rec.msg_count := p_Item_Orderability_Import_Rec.msg_count + 1;
310:
311: ELSE

Line 324: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;

320: Exception
321: when no_data_found then
322: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
323: fnd_message.set_token('ATTRIBUTE','CUSTOMER_ID');
324: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;
325: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;
326: p_Item_Orderability_Import_Rec.msg_count := p_Item_Orderability_Import_Rec.msg_count + 1;
327:
328: End;

Line 352: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;

348: IF p_Item_Orderability_Import_Rec.CUSTOMER_CLASS_ID IS NULL then
349: fnd_message.set_name('ONT','OE_ITORD_FIELD_REQUIRED');
350: fnd_message.set_token('FIELD','Rule Level Value');
351: fnd_message.set_token('CRITERIA','CUSTOMER_CLASS_ID');
352: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;
353: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;
354: p_Item_Orderability_Import_Rec.msg_count := p_Item_Orderability_Import_Rec.msg_count + 1;
355:
356: ELSE

Line 366: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;

362: Exception
363: when no_data_found then
364: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
365: fnd_message.set_token('ATTRIBUTE','CUSTOMER_CLASS_ID');
366: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;
367: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;
368: p_Item_Orderability_Import_Rec.msg_count := p_Item_Orderability_Import_Rec.msg_count + 1;
369:
370: End;

Line 396: P_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;

392:
393: fnd_message.set_name('ONT','OE_ITORD_FIELD_REQUIRED');
394: fnd_message.set_token('FIELD','Rule Level Value');
395: fnd_message.set_token('CRITERIA','CUSTOMER_CATEGORY_CODE');
396: P_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;
397: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;
398: p_Item_Orderability_Import_Rec.msg_count := p_Item_Orderability_Import_Rec.msg_count + 1;
399:
400:

Line 412: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;

408: Exception
409: when no_data_found then
410: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
411: fnd_message.set_token('ATTRIBUTE','CUSTOMER_CATEGORY_CODE');
412: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;
413: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;
414: p_Item_Orderability_Import_Rec.msg_count := p_Item_Orderability_Import_Rec.msg_count + 1;
415:
416: End;

Line 437: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;

433: IF p_Item_Orderability_Import_Rec.region_id IS NULL THEN
434: fnd_message.set_name('ONT','OE_ITORD_FIELD_REQUIRED');
435: fnd_message.set_token('FIELD','Rule Level Value');
436: fnd_message.set_token('CRITERIA','REGION_ID');
437: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;
438: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;
439: p_Item_Orderability_Import_Rec.msg_count := p_Item_Orderability_Import_Rec.msg_count + 1;
440: ELSE
441: begin

Line 450: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;

446: Exception
447: when no_data_found then
448: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
449: fnd_message.set_token('ATTRIBUTE','REGION_ID');
450: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;
451: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;
452: p_Item_Orderability_Import_Rec.msg_count := p_Item_Orderability_Import_Rec.msg_count + 1;
453:
454: End;

Line 475: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;

471: IF p_Item_Orderability_Import_Rec.order_type_id IS NULL THEN
472: fnd_message.set_name('ONT','OE_ITORD_FIELD_REQUIRED');
473: fnd_message.set_token('FIELD','Rule Level Value');
474: fnd_message.set_token('CRITERIA','ORDER_TYPE_ID');
475: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;
476: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;
477: p_Item_Orderability_Import_Rec.msg_count := p_Item_Orderability_Import_Rec.msg_count + 1;
478: ELSE
479: begin

Line 488: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;

484: Exception
485: when no_data_found then
486: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
487: fnd_message.set_token('ATTRIBUTE','ORDER_TYPE_ID');
488: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;
489: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;
490: p_Item_Orderability_Import_Rec.msg_count := p_Item_Orderability_Import_Rec.msg_count + 1;
491: End;
492: END IF;

Line 514: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;

510: IF p_Item_Orderability_Import_Rec.SHIP_TO_LOCATION_ID IS NULL THEN
511: fnd_message.set_name('ONT','OE_ITORD_FIELD_REQUIRED');
512: fnd_message.set_token('FIELD','Rule Level Value');
513: fnd_message.set_token('CRITERIA','SHIP_TO_LOCATION_ID');
514: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;
515: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;
516: p_Item_Orderability_Import_Rec.msg_count := p_Item_Orderability_Import_Rec.msg_count + 1;
517: ELSE
518: begin

Line 528: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;

524: Exception
525: when no_data_found then
526: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
527: fnd_message.set_token('ATTRIBUTE','SHIP_TO_LOCATION_ID');
528: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;
529: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;
530: p_Item_Orderability_Import_Rec.msg_count := p_Item_Orderability_Import_Rec.msg_count + 1;
531: End;
532: END IF;

Line 553: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;

549: IF p_Item_Orderability_Import_Rec.SALES_CHANNEL_CODE IS NULL THEN
550: fnd_message.set_name('ONT','OE_ITORD_FIELD_REQUIRED');
551: fnd_message.set_token('FIELD','Rule Level Value');
552: fnd_message.set_token('CRITERIA','SALES_CHANNEL_CODE');
553: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;
554: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;
555: p_Item_Orderability_Import_Rec.msg_count := p_Item_Orderability_Import_Rec.msg_count + 1;
556: ELSE
557: begin

Line 567: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;

563: Exception
564: when no_data_found then
565: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
566: fnd_message.set_token('ATTRIBUTE','SALES_CHANNEL_CODE');
567: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;
568: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;
569: p_Item_Orderability_Import_Rec.msg_count := p_Item_Orderability_Import_Rec.msg_count + 1;
570: End;
571: END IF;

Line 593: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;

589: IF p_Item_Orderability_Import_Rec.SALES_PERSON_ID IS NULL THEN
590: fnd_message.set_name('ONT','OE_ITORD_FIELD_REQUIRED');
591: fnd_message.set_token('FIELD','Rule Level Value');
592: fnd_message.set_token('CRITERIA','SALES_PERSON_ID');
593: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;
594: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;
595: p_Item_Orderability_Import_Rec.msg_count := p_Item_Orderability_Import_Rec.msg_count + 1;
596: ELSE
597:

Line 608: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;

604: Exception
605: when no_data_found then
606: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
607: fnd_message.set_token('ATTRIBUTE','SALES_PERSON_ID');
608: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;
609: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;
610: p_Item_Orderability_Import_Rec.msg_count := p_Item_Orderability_Import_Rec.msg_count + 1;
611: End;
612:

Line 633: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;

629: IF p_Item_Orderability_Import_Rec.end_customer_id IS NULL THEN
630: fnd_message.set_name('ONT','OE_ITORD_FIELD_REQUIRED');
631: fnd_message.set_token('FIELD','Rule Level Value');
632: fnd_message.set_token('CRITERIA','END_CUSTOMER_ID');
633: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;
634: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;
635: p_Item_Orderability_Import_Rec.msg_count := p_Item_Orderability_Import_Rec.msg_count + 1;
636: ELSE
637:

Line 649: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;

645: Exception
646: when no_data_found then
647: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
648: fnd_message.set_token('ATTRIBUTE','END_CUSTOMER_ID');
649: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;
650: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;
651: p_Item_Orderability_Import_Rec.msg_count := p_Item_Orderability_Import_Rec.msg_count + 1;
652: End;
653:

Line 675: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;

671: IF p_Item_Orderability_Import_Rec.BILL_TO_LOCATION_ID IS NULL THEN
672: fnd_message.set_name('ONT','OE_ITORD_FIELD_REQUIRED');
673: fnd_message.set_token('FIELD','Rule Level Value');
674: fnd_message.set_token('CRITERIA','BILL_TO_LOCATION_ID');
675: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;
676: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;
677: p_Item_Orderability_Import_Rec.msg_count := p_Item_Orderability_Import_Rec.msg_count + 1;
678: ELSE
679: begin

Line 689: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;

685: Exception
686: when no_data_found then
687: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
688: fnd_message.set_token('ATTRIBUTE','BILL_TO_LOCATION_ID');
689: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;
690: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;
691: p_Item_Orderability_Import_Rec.msg_count := p_Item_Orderability_Import_Rec.msg_count + 1;
692:
693: End;

Line 716: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;

712: IF p_Item_Orderability_Import_Rec.DELIVER_TO_LOCATION_ID IS NULL THEN
713: fnd_message.set_name('ONT','OE_ITORD_FIELD_REQUIRED');
714: fnd_message.set_token('FIELD','Rule Level Value');
715: fnd_message.set_token('CRITERIA','DELIVER_TO_LOCATION_ID');
716: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;
717: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;
718: p_Item_Orderability_Import_Rec.msg_count := p_Item_Orderability_Import_Rec.msg_count + 1;
719: ELSE
720:

Line 731: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;

727: Exception
728: when no_data_found then
729: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
730: fnd_message.set_token('ATTRIBUTE','DELIVER_TO_LOCATION_ID');
731: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;
732: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;
733: p_Item_Orderability_Import_Rec.msg_count := p_Item_Orderability_Import_Rec.msg_count + 1;
734:
735: End;

Line 759: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;

755:
756: fnd_message.set_name('ONT','OE_ITORD_FIELD_REQUIRED');
757: fnd_message.set_token('FIELD','Inventory Item');
758: fnd_message.set_token('CRITERIA','Item');
759: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;
760: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;
761: p_Item_Orderability_Import_Rec.msg_count := p_Item_Orderability_Import_Rec.msg_count + 1;
762:
763: ELSE

Line 773: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;

769: Exception
770: when no_data_found then
771: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
772: fnd_message.set_token('ATTRIBUTE','INVENTORY_ITEM_ID');
773: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;
774: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;
775: p_Item_Orderability_Import_Rec.msg_count := p_Item_Orderability_Import_Rec.msg_count + 1;
776:
777: End;

Line 789: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;

785: If p_Item_Orderability_Import_Rec.item_category_id IS NULL then
786: fnd_message.set_name('ONT','OE_ITORD_FIELD_REQUIRED');
787: fnd_message.set_token('FIELD','Item Category');
788: fnd_message.set_token('CRITERIA','Category');
789: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;
790: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;
791: p_Item_Orderability_Import_Rec.msg_count := p_Item_Orderability_Import_Rec.msg_count + 1;
792:
793: Else

Line 802: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;

798: Exception
799: when others then
800: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
801: fnd_message.set_token('ATTRIBUTE','ITEM_CATEGORY_ID');
802: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;
803: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;
804: p_Item_Orderability_Import_Rec.msg_count := p_Item_Orderability_Import_Rec.msg_count + 1;
805:
806: End ;

Line 819: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_UNEXP_ERROR;

815: End If;
816:
817: Exception
818: when others then
819: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_UNEXP_ERROR;
820: p_Item_Orderability_Import_Rec.msg_data := SQLERRM;
821: p_Item_Orderability_Import_Rec.msg_count := 1;
822: End Validate_conditional_fields;
823:

Line 841: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_SUCCESS;

837: IF l_debug_level > 0 then
838: oe_debug_pub.add('Entering OE_ITORD_PUB.check_duplicate_rules');
839: End If;
840:
841: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_SUCCESS;
842: p_Item_Orderability_Import_Rec.msg_data := NULL;
843: p_Item_Orderability_Import_Rec.msg_count := 0;
844:
845: IF p_Item_Orderability_Import_Rec.item_level = 'I' then

Line 864: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;

860: AND rownum = 1;
861:
862: fnd_message.set_name('ONT','OE_ITORD_RULE_EXISTS');
863: fnd_message.SET_TOKEN('CRITERIA','Item Category');
864: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;
865: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;
866: p_Item_Orderability_Import_Rec.msg_count := p_Item_Orderability_Import_Rec.msg_count + 1;
867: Exception
868: when no_data_found then

Line 898: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;

894: THEN
895: fnd_message.set_name('ONT','OE_ITORD_DUP_RULE_EXISTS');
896: fnd_message.set_token('RULE_LEVEL',l_rule_level_coulmn);
897: fnd_message.set_token('RULE_LEVEL_VALUE',l_rule_level_value);
898: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;
899: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;
900: p_Item_Orderability_Import_Rec.msg_count := p_Item_Orderability_Import_Rec.msg_count + 1;
901: END IF;
902:

Line 926: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;

922: AND rownum = 1;
923:
924: fnd_message.set_name('ONT','OE_ITORD_RULE_EXISTS');
925: fnd_message.SET_TOKEN('CRITERIA','Item');
926: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;
927: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;
928: p_Item_Orderability_Import_Rec.msg_count := p_Item_Orderability_Import_Rec.msg_count + 1;
929: Exception
930: when no_data_found then

Line 961: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;

957: THEN
958: fnd_message.set_name('ONT','OE_ITORD_DUP_RULE_EXISTS');
959: fnd_message.set_token('RULE_LEVEL',l_rule_level_coulmn);
960: fnd_message.set_token('RULE_LEVEL_VALUE',l_rule_level_value);
961: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;
962: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;
963: p_Item_Orderability_Import_Rec.msg_count := p_Item_Orderability_Import_Rec.msg_count + 1;
964: END IF;
965:

Line 976: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_UNEXP_ERROR;

972: End If;
973:
974: Exception
975: when others then
976: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_UNEXP_ERROR;
977: p_Item_Orderability_Import_Rec.msg_data := SQLERRM;
978: p_Item_Orderability_Import_Rec.msg_count := 1;
979: End check_duplicate_rules;
980:

Line 1057: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_SUCCESS;

1053: IF l_debug_level > 0 then
1054: oe_debug_pub.add('Entering OE_ITORD_PUB.insert_rules');
1055: End If;
1056:
1057: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_SUCCESS;
1058: p_Item_Orderability_Import_Rec.msg_data := NULL;
1059: p_Item_Orderability_Import_Rec.msg_count := 0;
1060:
1061:

Line 1150: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_SUCCESS;

1146:
1147: select orderability_id into l_orderability_id
1148: from oe_item_orderability_rules where rowid = l_rowid ;
1149:
1150: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_SUCCESS;
1151: p_Item_Orderability_Import_Rec.msg_data := 'Rule Created Successfully .Orderability_id ='||l_orderability_id;
1152: p_Item_Orderability_Import_Rec.msg_count := 1;
1153:
1154: End If;

Line 1163: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_UNEXP_ERROR;

1159: End If;
1160:
1161: Exception
1162: when others then
1163: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_UNEXP_ERROR;
1164: p_Item_Orderability_Import_Rec.msg_data := SQLERRM;
1165: p_Item_Orderability_Import_Rec.msg_count := 1;
1166:
1167:

Line 1252: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_SUCCESS;

1248: IF FND_FLEX_DESCVAL.Validate_Desccols( appl_short_name => 'ONT' ,
1249: desc_flex_name =>'OE_ITORD_ATTRIBUTES'
1250: )
1251: THEN
1252: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_SUCCESS;
1253: p_Item_Orderability_Import_Rec.msg_data := 'VALID';
1254: p_Item_Orderability_Import_Rec.msg_count := 1;
1255: ELSE
1256: FND_MESSAGE.Set_Encoded(FND_FLEX_DESCVAL.Encoded_Error_Message);

Line 1257: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;

1253: p_Item_Orderability_Import_Rec.msg_data := 'VALID';
1254: p_Item_Orderability_Import_Rec.msg_count := 1;
1255: ELSE
1256: FND_MESSAGE.Set_Encoded(FND_FLEX_DESCVAL.Encoded_Error_Message);
1257: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_ERROR;
1258: p_Item_Orderability_Import_Rec.msg_data := fnd_message.get;
1259: p_Item_Orderability_Import_Rec.msg_count := 1;
1260: END IF;
1261:

Line 1272: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_UNEXP_ERROR;

1268:
1269: EXCEPTION
1270:
1271: WHEN OTHERS THEN
1272: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_UNEXP_ERROR;
1273: P_Item_Orderability_Import_Rec.msg_data := SQLERRM;
1274: p_Item_Orderability_Import_Rec.msg_count := 1;
1275:
1276: END Validate_rules_DFF;