[Home] [Help]
189:
190:
191: WHEN OTHERS THEN
192:
193: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
194: THEN
195: OE_MSG_PUB.Add_Exc_Msg
196: ( G_PKG_NAME
197: , 'Header_Id_Conversion'
191: WHEN OTHERS THEN
192:
193: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
194: THEN
195: OE_MSG_PUB.Add_Exc_Msg
196: ( G_PKG_NAME
197: , 'Header_Id_Conversion'
198: );
199: END IF;
365:
366:
367:
368: WHEN OTHERS THEN
369: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
370: THEN
371: OE_MSG_PUB.Add_Exc_Msg
372: ( G_PKG_NAME
373: , 'Line_Id_Conversion'
367:
368: WHEN OTHERS THEN
369: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
370: THEN
371: OE_MSG_PUB.Add_Exc_Msg
372: ( G_PKG_NAME
373: , 'Line_Id_Conversion'
374: );
375: END IF;
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');
444: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
445: OE_MSG_PUB.Add;
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');
444: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
445: OE_MSG_PUB.Add;
446: END IF;
447: END IF;
448:
449: ELSE
456: END IF;
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:
474: INTO l_header_rec.header_id
475: FROM DUAL;
476: oe_debug_pub.add('Set Message Context');
477:
478: OE_MSG_PUB.set_msg_context(
479: p_entity_code => 'BLANKET_HEADER'
480: ,p_entity_id => l_header_rec.header_id
481: ,p_header_id => l_header_rec.header_id
482: ,p_line_id => null
499: , p_header_rec => l_header_rec) ;
500:
501: END IF;
502:
503: OE_MSG_PUB.set_msg_context(
504: p_entity_code => 'BLANKET_HEADER'
505: ,p_entity_id => l_header_rec.header_id
506: ,p_header_id => l_header_rec.header_id
507: ,p_line_id => null
543:
544: oe_debug_pub.add('In Lines Loop');
545: oe_debug_pub.add(' ordered item :'|| l_line_tbl(l_count).ordered_item, 1);
546:
547: OE_MSG_PUB.set_msg_context(
548: p_entity_code => 'BLANKET_LINE'
549: ,p_entity_id => l_line_tbl(l_count).line_id
550: ,p_header_id => l_line_tbl(l_count).header_id
551: ,p_line_id => l_line_tbl(l_count).line_id
558: ,p_source_document_type_id => null);
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:
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
602: ( p_count => x_msg_count
603: , p_data => x_msg_data
604: );
605:
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
613: ( p_count => x_msg_count
614: , p_data => x_msg_data
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
624: ( G_PKG_NAME
625: , 'Process_Blanket'
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
624: ( G_PKG_NAME
625: , 'Process_Blanket'
626: );
627: END IF;
625: , 'Process_Blanket'
626: );
627: END IF;
628:
629: OE_MSG_PUB.Count_And_Get
630: ( p_count => x_msg_count
631: , p_data => x_msg_data
632: );
633: