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_GLOBAL

Line 80: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;

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:
84: IF p_Item_Orderability_Import_Rec.ITEM_LEVEL is NULL then

Line 88: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get ;

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:
92: IF p_Item_Orderability_Import_Rec.generally_available is NULL then

Line 96: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get ;

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:
100: IF p_Item_Orderability_Import_Rec.rule_level is NULL then

Line 104: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;

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:
108:

Line 113: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;

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:
117: IF p_Item_Orderability_Import_Rec.creation_date is NULL then

Line 121: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;

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

Line 130: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;

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:
134: IF p_Item_Orderability_Import_Rec.last_update_date is NULL then

Line 138: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;

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:
142:

Line 179: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;

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

Line 190: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;

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

Line 215: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;

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

Line 229: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;

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

Line 248: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;

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

Line 266: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;

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

Line 308: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;

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
312: begin

Line 325: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;

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

Line 353: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;

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
357: begin

Line 367: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;

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

Line 397: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;

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:
401: ELSE

Line 413: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;

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

Line 438: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;

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
442: SELECT 'Y'

Line 451: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;

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

Line 476: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;

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
480: SELECT 'Y'

Line 489: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;

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

Line 515: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;

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
519: SELECT 'Y'

Line 529: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;

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

Line 554: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;

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
558: SELECT 'Y'

Line 568: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;

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

Line 594: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;

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:
598: begin

Line 609: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;

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

Line 634: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;

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:
638: begin

Line 650: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;

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

Line 676: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;

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
680: SELECT 'Y'

Line 690: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;

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

Line 717: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;

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:
721: begin

Line 732: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;

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

Line 760: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;

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
764: begin

Line 774: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;

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

Line 790: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;

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
794: begin

Line 803: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;

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

Line 865: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;

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
869: NULL;

Line 899: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;

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:
903:

Line 927: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;

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
931: NULL;

Line 962: p_Item_Orderability_Import_Rec.msg_data := p_Item_Orderability_Import_Rec.msg_data ||fnd_global.local_chr(59)||fnd_message.get;

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:
966: