DBA Data[Home] [Help]

APPS.OE_BLANKET_PUB dependencies on FND_API

Line 201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

197: , 'Header_Id_Conversion'
198: );
199: END IF;
200:
201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
202:
203: END Header_Id_Conversion;
204:
205:

Line 377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

373: , 'Line_Id_Conversion'
374: );
375: END IF;
376:
377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
378:
379: null;
380: END Line_Id_Conversion;
381:

Line 437: IF (p_org_id IS NOT NULL AND p_org_id <> FND_API.G_MISS_NUM) THEN

433: l_header_rec := p_header_rec ;
434: l_header_val_rec := p_header_val_rec;
435: -- Logic added for MOAC
436:
437: IF (p_org_id IS NOT NULL AND p_org_id <> FND_API.G_MISS_NUM) THEN
438: l_org_id := p_org_id;
439: IF (p_operating_unit IS NOT NULL AND p_operating_unit <> FND_API.G_MISS_CHAR)
440: THEN
441: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 439: IF (p_operating_unit IS NOT NULL AND p_operating_unit <> FND_API.G_MISS_CHAR)

435: -- Logic added for MOAC
436:
437: IF (p_org_id IS NOT NULL AND p_org_id <> FND_API.G_MISS_NUM) THEN
438: l_org_id := p_org_id;
439: IF (p_operating_unit IS NOT NULL AND p_operating_unit <> FND_API.G_MISS_CHAR)
440: THEN
441: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
442: THEN
443: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');

Line 450: IF (p_operating_unit IS NOT NULL AND p_operating_unit <> FND_API.G_MISS_CHAR)

446: END IF;
447: END IF;
448:
449: ELSE
450: IF (p_operating_unit IS NOT NULL AND p_operating_unit <> FND_API.G_MISS_CHAR)
451: THEN
452: -- call value_to_id to get org_id
453: l_org_id := OE_Value_To_Id.OPERATING_UNIT(p_operating_unit);
454:

Line 461: x_return_status := FND_API.G_RET_STS_ERROR;

457:
458: IF l_header_rec.operation NOT IN ( 'INSERT','CREATE') THEN
459: FND_MESSAGE.SET_NAME('ONT','ONT_BSA_BATCH');
460: OE_MSG_PUB.Add;
461: x_return_status := FND_API.G_RET_STS_ERROR;
462: RAISE FND_API.G_EXC_ERROR;
463: END IF;
464:
465:

Line 462: RAISE FND_API.G_EXC_ERROR;

458: IF l_header_rec.operation NOT IN ( 'INSERT','CREATE') THEN
459: FND_MESSAGE.SET_NAME('ONT','ONT_BSA_BATCH');
460: OE_MSG_PUB.Add;
461: x_return_status := FND_API.G_RET_STS_ERROR;
462: RAISE FND_API.G_EXC_ERROR;
463: END IF;
464:
465:
466: set_context(p_org_id =>l_org_id);

Line 491: x_return_status := FND_API.G_RET_STS_SUCCESS;

487: ,p_source_document_line_id => null
488: ,p_order_source_id => l_header_rec.source_document_id
489: ,p_source_document_type_id => null);
490:
491: x_return_status := FND_API.G_RET_STS_SUCCESS;
492:
493:
494: oe_debug_pub.add('3');
495: oe_debug_pub.add (' Price List :'|| l_header_val_rec.price_list );

Line 516: x_return_status := FND_API.G_RET_STS_SUCCESS;

512: ,p_source_document_line_id => null
513: ,p_order_source_id => l_header_rec.source_document_id
514: ,p_source_document_type_id => null);
515:
516: x_return_status := FND_API.G_RET_STS_SUCCESS;
517:
518: FOR l_count in 1..l_line_tbl.COUNT LOOP
519:
520: oe_debug_pub.add('In Lines Loop', 1);

Line 563: x_return_status := FND_API.G_RET_STS_ERROR;

559:
560: IF l_line_tbl(l_count).operation NOT IN ( 'INSERT','CREATE') THEN
561: FND_MESSAGE.SET_NAME('ONT','ONT_BSA_BATCH');
562: OE_MSG_PUB.Add;
563: x_return_status := FND_API.G_RET_STS_ERROR;
564: RAISE FND_API.G_EXC_ERROR;
565: END IF;
566:
567: END LOOP;

Line 564: RAISE FND_API.G_EXC_ERROR;

560: IF l_line_tbl(l_count).operation NOT IN ( 'INSERT','CREATE') THEN
561: FND_MESSAGE.SET_NAME('ONT','ONT_BSA_BATCH');
562: OE_MSG_PUB.Add;
563: x_return_status := FND_API.G_RET_STS_ERROR;
564: RAISE FND_API.G_EXC_ERROR;
565: END IF;
566:
567: END LOOP;
568: -- Prepare control record

Line 595: WHEN FND_API.G_EXC_ERROR THEN

591: );
592:
593: EXCEPTION
594:
595: WHEN FND_API.G_EXC_ERROR THEN
596:
597: x_return_status := FND_API.G_RET_STS_ERROR;
598:
599: -- Get message count and data

Line 597: x_return_status := FND_API.G_RET_STS_ERROR;

593: EXCEPTION
594:
595: WHEN FND_API.G_EXC_ERROR THEN
596:
597: x_return_status := FND_API.G_RET_STS_ERROR;
598:
599: -- Get message count and data
600:
601: OE_MSG_PUB.Count_And_Get

Line 606: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

602: ( p_count => x_msg_count
603: , p_data => x_msg_data
604: );
605:
606: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
607:
608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
609:
610: -- Get message count and data

Line 608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

604: );
605:
606: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
607:
608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
609:
610: -- Get message count and data
611:
612: OE_MSG_PUB.Count_And_Get

Line 619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

615: );
616:
617: WHEN OTHERS THEN
618:
619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
620:
621: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
622: THEN
623: OE_MSG_PUB.Add_Exc_Msg