DBA Data[Home] [Help]

APPS.OE_BULK_PROCESS_HEADER dependencies on OE_MSG_PUB

Line 305: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

301: RETURN TRUE;
302: EXCEPTION
303: WHEN NO_DATA_FOUND THEN
304:
305: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
306: THEN
307:
308: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'END_CUSTOMER_ID');
309:

Line 308: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'END_CUSTOMER_ID');

304:
305: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
306: THEN
307:
308: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'END_CUSTOMER_ID');
309:
310: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
311: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
312: OE_Order_Util.Get_Attribute_Name('END_CUSTOMER_ID')||':validation:'||to_char(p_end_customer_id));

Line 313: OE_MSG_PUB.Add;

309:
310: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
311: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
312: OE_Order_Util.Get_Attribute_Name('END_CUSTOMER_ID')||':validation:'||to_char(p_end_customer_id));
313: OE_MSG_PUB.Add;
314: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
315:
316: END IF;
317:

Line 314: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);

310: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
311: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
312: OE_Order_Util.Get_Attribute_Name('END_CUSTOMER_ID')||':validation:'||to_char(p_end_customer_id));
313: OE_MSG_PUB.Add;
314: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
315:
316: END IF;
317:
318: RETURN FALSE;

Line 322: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

318: RETURN FALSE;
319:
320: WHEN OTHERS THEN
321:
322: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
323: THEN
324: OE_MSG_PUB.Add_Exc_Msg
325: ( G_PKG_NAME
326: , 'END_CUSOTMER'

Line 324: OE_MSG_PUB.Add_Exc_Msg

320: WHEN OTHERS THEN
321:
322: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
323: THEN
324: OE_MSG_PUB.Add_Exc_Msg
325: ( G_PKG_NAME
326: , 'END_CUSOTMER'
327: );
328: END IF;

Line 352: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

348: RETURN TRUE;
349: EXCEPTION
350: WHEN NO_DATA_FOUND THEN
351:
352: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
353: THEN
354:
355: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'END_CUSTOMER_CONTACT_ID');
356:

Line 355: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'END_CUSTOMER_CONTACT_ID');

351:
352: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
353: THEN
354:
355: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'END_CUSTOMER_CONTACT_ID');
356:
357: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
358: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
359: OE_Order_Util.Get_Attribute_Name('end_customer_contact_id'));

Line 360: OE_MSG_PUB.Add;

356:
357: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
358: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
359: OE_Order_Util.Get_Attribute_Name('end_customer_contact_id'));
360: OE_MSG_PUB.Add;
361: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
362:
363: END IF;
364:

Line 361: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);

357: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
358: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
359: OE_Order_Util.Get_Attribute_Name('end_customer_contact_id'));
360: OE_MSG_PUB.Add;
361: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
362:
363: END IF;
364:
365:

Line 370: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

366: RETURN FALSE;
367:
368: WHEN OTHERS THEN
369:
370: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
371: THEN
372: OE_MSG_PUB.Add_Exc_Msg
373: ( G_PKG_NAME
374: , 'End_Customer_Contact'

Line 372: OE_MSG_PUB.Add_Exc_Msg

368: WHEN OTHERS THEN
369:
370: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
371: THEN
372: OE_MSG_PUB.Add_Exc_Msg
373: ( G_PKG_NAME
374: , 'End_Customer_Contact'
375: );
376: END IF;

Line 420: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

416: END IF;
417:
418: EXCEPTION
419: WHEN NO_DATA_FOUND THEN
420: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
421: THEN
422:
423: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'END_CUSTOMER_SITE_USE_ID');
424:

Line 423: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'END_CUSTOMER_SITE_USE_ID');

419: WHEN NO_DATA_FOUND THEN
420: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
421: THEN
422:
423: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'END_CUSTOMER_SITE_USE_ID');
424:
425: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
426: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
427: OE_Order_Util.Get_Attribute_Name('end_customer_site_use_id'));

Line 428: OE_MSG_PUB.Add;

424:
425: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
426: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
427: OE_Order_Util.Get_Attribute_Name('end_customer_site_use_id'));
428: OE_MSG_PUB.Add;
429: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
430:
431: END IF;
432:

Line 429: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);

425: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
426: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
427: OE_Order_Util.Get_Attribute_Name('end_customer_site_use_id'));
428: OE_MSG_PUB.Add;
429: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
430:
431: END IF;
432:
433:

Line 438: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

434: RETURN FALSE;
435:
436: WHEN OTHERS THEN
437:
438: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
439: THEN
440: OE_MSG_PUB.Add_Exc_Msg
441: ( G_PKG_NAME
442: , 'END_CUSTOMER_SITE_USE_ID'

Line 440: OE_MSG_PUB.Add_Exc_Msg

436: WHEN OTHERS THEN
437:
438: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
439: THEN
440: OE_MSG_PUB.Add_Exc_Msg
441: ( G_PKG_NAME
442: , 'END_CUSTOMER_SITE_USE_ID'
443: );
444: END IF;

Line 469: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

465: RETURN TRUE;
466: EXCEPTION
467: WHEN NO_DATA_FOUND THEN
468:
469: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
470: THEN
471:
472: OE_DEBUG_PUB.ADD('Validation failed for IB_INSTALLED_AT_LOCATION in OEBLHDRB.pls');
473: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'IB_INSTALLED_AT_LOCATION');

Line 473: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'IB_INSTALLED_AT_LOCATION');

469: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
470: THEN
471:
472: OE_DEBUG_PUB.ADD('Validation failed for IB_INSTALLED_AT_LOCATION in OEBLHDRB.pls');
473: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'IB_INSTALLED_AT_LOCATION');
474:
475: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
476: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
477: OE_Order_Util.Get_Attribute_Name('ib_installed_at_location'));

Line 478: OE_MSG_PUB.Add;

474:
475: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
476: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
477: OE_Order_Util.Get_Attribute_Name('ib_installed_at_location'));
478: OE_MSG_PUB.Add;
479: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
480:
481: END IF;
482:

Line 479: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);

475: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
476: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
477: OE_Order_Util.Get_Attribute_Name('ib_installed_at_location'));
478: OE_MSG_PUB.Add;
479: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
480:
481: END IF;
482:
483:

Line 488: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

484: RETURN FALSE;
485:
486: WHEN OTHERS THEN
487:
488: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
489: THEN
490: OE_MSG_PUB.Add_Exc_Msg
491: ( G_PKG_NAME
492: , 'IB_INSTALLED_AT_LOCATION'

Line 490: OE_MSG_PUB.Add_Exc_Msg

486: WHEN OTHERS THEN
487:
488: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
489: THEN
490: OE_MSG_PUB.Add_Exc_Msg
491: ( G_PKG_NAME
492: , 'IB_INSTALLED_AT_LOCATION'
493: );
494: END IF;

Line 521: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

517: RETURN TRUE;
518: EXCEPTION
519: WHEN NO_DATA_FOUND THEN
520:
521: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
522: THEN
523:
524: OE_DEBUG_PUB.ADD('Validation failed for IB_INSTALLED_AT_LOCATION in OEBLHDRB.pls');
525: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'IB_INSTALLED_AT_LOCATION');

Line 525: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'IB_INSTALLED_AT_LOCATION');

521: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
522: THEN
523:
524: OE_DEBUG_PUB.ADD('Validation failed for IB_INSTALLED_AT_LOCATION in OEBLHDRB.pls');
525: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'IB_INSTALLED_AT_LOCATION');
526:
527: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
528: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
529: OE_Order_Util.Get_Attribute_Name('ib_installed_at_location'));

Line 530: OE_MSG_PUB.Add;

526:
527: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
528: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
529: OE_Order_Util.Get_Attribute_Name('ib_installed_at_location'));
530: OE_MSG_PUB.Add;
531: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
532:
533: END IF;
534:

Line 531: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);

527: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
528: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
529: OE_Order_Util.Get_Attribute_Name('ib_installed_at_location'));
530: OE_MSG_PUB.Add;
531: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
532:
533: END IF;
534:
535:

Line 540: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

536: RETURN FALSE;
537:
538: WHEN OTHERS THEN
539:
540: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
541: THEN
542: OE_MSG_PUB.Add_Exc_Msg
543: ( G_PKG_NAME
544: , 'IB_INSTALLED_AT_LOCATION'

Line 542: OE_MSG_PUB.Add_Exc_Msg

538: WHEN OTHERS THEN
539:
540: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
541: THEN
542: OE_MSG_PUB.Add_Exc_Msg
543: ( G_PKG_NAME
544: , 'IB_INSTALLED_AT_LOCATION'
545: );
546: END IF;

Line 578: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

574: RETURN TRUE;
575: EXCEPTION
576: WHEN NO_DATA_FOUND THEN
577:
578: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
579: THEN
580:
581: OE_DEBUG_PUB.ADD('Validation failed for IB_CURRENT_LOCATION in OEBLHDRB.pls');
582: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'IB_CURRENT_LOCATION');

Line 582: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'IB_CURRENT_LOCATION');

578: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
579: THEN
580:
581: OE_DEBUG_PUB.ADD('Validation failed for IB_CURRENT_LOCATION in OEBLHDRB.pls');
582: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'IB_CURRENT_LOCATION');
583:
584: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
585: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
586: OE_Order_Util.Get_Attribute_Name('ib_current_location'));

Line 587: OE_MSG_PUB.Add;

583:
584: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
585: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
586: OE_Order_Util.Get_Attribute_Name('ib_current_location'));
587: OE_MSG_PUB.Add;
588: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
589:
590: END IF;
591:

Line 588: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);

584: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
585: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
586: OE_Order_Util.Get_Attribute_Name('ib_current_location'));
587: OE_MSG_PUB.Add;
588: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
589:
590: END IF;
591:
592:

Line 597: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

593: RETURN FALSE;
594:
595: WHEN OTHERS THEN
596:
597: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
598: THEN
599: OE_MSG_PUB.Add_Exc_Msg
600: ( G_PKG_NAME
601: , 'IB_CURRENT_LOCATION'

Line 599: OE_MSG_PUB.Add_Exc_Msg

595: WHEN OTHERS THEN
596:
597: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
598: THEN
599: OE_MSG_PUB.Add_Exc_Msg
600: ( G_PKG_NAME
601: , 'IB_CURRENT_LOCATION'
602: );
603: END IF;

Line 1901: OE_MSG_PUB.ADD;

1897: p_header_rec.conversion_rate(i) IS NOT NULL
1898: THEN
1899: l_return_status := FND_API.G_RET_STS_ERROR;
1900: FND_MESSAGE.SET_NAME('ONT','OE_VALIDATION_CONV_TYPE');
1901: OE_MSG_PUB.ADD;
1902:
1903: END IF; -- END of checks based on conversion type
1904:
1905: