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_ORDER_IMPORT_PVT dependencies on OE_MSG_PUB

Line 2022: OE_MSG_PUB.Initialize;

2018: IF p_init_msg_list = FND_API.G_TRUE THEN
2019: IF l_debug_level > 0 THEN
2020: oe_debug_pub.add( 'BEFORE INITIALIZING MESSAGES LIST' ) ;
2021: END IF;
2022: OE_MSG_PUB.Initialize;
2023: END IF;
2024:
2025: /* -----------------------------------------------------------
2026: Set message context

Line 2034: OE_MSG_PUB.set_msg_context(

2030: oe_debug_pub.add( 'BEFORE SETTING MESSAGE CONTEXT' ) ;
2031: oe_debug_pub.add('trim data = '||l_rtrim_data);
2032: END IF;
2033:
2034: OE_MSG_PUB.set_msg_context(
2035: p_entity_code => 'HEADER'
2036: ,p_entity_ref => null
2037: ,p_entity_id => null
2038: ,p_header_id => null

Line 2664: OE_MSG_PUB.Add;

2660: END IF;
2661:
2662: FND_MESSAGE.SET_NAME('ONT','OE_OI_DUPLICATE_REF');
2663: FND_MESSAGE.SET_TOKEN('DUPLICATE_REF','orig_sys_discount_ref');
2664: OE_MSG_PUB.Add;
2665:
2666: END IF;
2667: END IF;
2668:

Line 2841: OE_MSG_PUB.Add;

2837: oe_debug_pub.add( 'YOU ARE ENTERING A DUPLICATE ORIG_SYS_ATTS_REF FOR THE SAME ORDER' ) ;
2838: END IF;
2839: FND_MESSAGE.SET_NAME('ONT','OE_OI_DUPLICATE_REF');
2840: FND_MESSAGE.SET_TOKEN('DUPLICATE_REF','orig_sys_ats_ref');
2841: OE_MSG_PUB.Add;
2842: END IF;
2843: END IF;
2844: l_header_att_count := l_header_att_count +1;
2845: l_header_price_att_tbl(l_header_att_count) := l_header_price_att_rec;

Line 2908: OE_MSG_PUB.Add;

2904: oe_debug_pub.add( 'YOU ARE ENTERING A DUPLICATE ORIG_SYS_CREDIT_REF FORTHE SAME ORDER' ) ;
2905: END IF;
2906: FND_MESSAGE.SET_NAME('ONT','OE_OI_DUPLICATE_REF');
2907: FND_MESSAGE.SET_TOKEN('DUPLICATE_REF','orig_sys_credit_ref');
2908: OE_MSG_PUB.Add;
2909: END IF;
2910: END IF;
2911:
2912: l_header_scredit_count := l_header_scredit_count + 1;

Line 3009: OE_MSG_PUB.Add;

3005: oe_debug_pub.add( 'YOU ARE ENTERING A DUPLICATE ORIG_SYS_payment_REF FORTHE SAME ORDER' ) ;
3006: END IF;
3007: FND_MESSAGE.SET_NAME('ONT','OE_OI_DUPLICATE_REF');
3008: FND_MESSAGE.SET_TOKEN('DUPLICATE_REF','orig_sys_payment_ref');
3009: OE_MSG_PUB.Add;
3010:
3011: END IF;
3012: END IF;
3013:

Line 3167: OE_MSG_PUB.add;

3163: l_action_request_rec.date_param1 := l_action_rec.date_param1;
3164: ELSE
3165: --display a message saying Customer Acceptance is not enabled
3166: FND_MESSAGE.Set_Name('ONT', 'ONT_CUST_ACC_DISABLED');
3167: OE_MSG_PUB.add;
3168: END IF;
3169:
3170: IF l_debug_level > 0 THEN
3171: oe_debug_pub.add( 'PARAM2/CUSTOMER_COMMENTS: ' || L_ACTION_REQUEST_REC.PARAM2 , 1 ) ;

Line 3804: OE_MSG_PUB.Add;

3800: oe_debug_pub.add( 'YOU ARE ENTERING EITHER A DUPLICATE ORIG_SYS_LINE_REF OR ORIG_SYS_SHIPMENT_REF FOR THE SAME ORDER' ) ;
3801: END IF;
3802: FND_MESSAGE.SET_NAME('ONT','OE_OI_DUPLICATE_REF');
3803: FND_MESSAGE.SET_TOKEN('DUPLICATE_REF','orig_sys_line_ref and orig_sys_shipment_ref');
3804: OE_MSG_PUB.Add;
3805: ELSIF
3806: (l_line_rec.orig_sys_line_ref = l_line_tbl(l_line_count).orig_sys_line_ref) AND
3807: (G_IMPORT_SHIPMENTS = 'NO') THEN
3808: p_return_status := FND_API.G_RET_STS_ERROR;

Line 3815: OE_MSG_PUB.Add;

3811: oe_debug_pub.add( 'YOU ARE ENTERING A DUPLICATE ORIG_SYS_LINE_REF FOR THE SAME ORDER' ) ;
3812: END IF;
3813: FND_MESSAGE.SET_NAME('ONT','OE_OI_DUPLICATE_REF');
3814: FND_MESSAGE.SET_TOKEN('DUPLICATE_REF','orig_sys_line_ref');
3815: OE_MSG_PUB.Add;
3816: END IF;
3817: ELSIF
3818: OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL < '110508' THEN
3819: IF (l_line_rec.orig_sys_line_ref = l_line_tbl(l_line_count).orig_sys_line_ref) THEN

Line 3827: OE_MSG_PUB.Add;

3823: oe_debug_pub.add( 'YOU ARE ENTERING A DUPLICATE ORIG_SYS_LINE_REF FOR THESAME ORDER' ) ;
3824: END IF;
3825: FND_MESSAGE.SET_NAME('ONT','OE_OI_DUPLICATE_REF');
3826: FND_MESSAGE.SET_TOKEN('DUPLICATE_REF','orig_sys_line_ref');
3827: OE_MSG_PUB.Add;
3828: END IF;
3829: END IF;
3830: END IF;
3831:

Line 3916: OE_MSG_PUB.Add_TEXT(failure_message);

3912: IF l_debug_level > 0 THEN
3913: oe_debug_pub.add( 'ERROR IN GETTING CCID' ) ;
3914: END IF;
3915: failure_message := fnd_flex_ext.get_message;
3916: OE_MSG_PUB.Add_TEXT(failure_message);
3917: p_return_status := FND_API.G_RET_STS_ERROR;
3918: l_validate_only := FND_API.G_TRUE;
3919: IF l_debug_level > 0 THEN
3920: oe_debug_pub.add('failure message = ' || substr ( failure_message , 1 , 50 ) ) ;

Line 3954: OE_MSG_PUB.Add;

3950: l_line_rec.inventory_item_id := FND_API.G_MISS_NUM;
3951: FND_MESSAGE.SET_NAME('ONT','OE_OIM_INVALID_ITEM_ID');
3952: FND_MESSAGE.SET_TOKEN('ORDER_NO', l_orig_sys_document_ref);
3953: FND_MESSAGE.SET_TOKEN('ORDER_SOURCE', l_order_source_id);
3954: OE_MSG_PUB.Add;
3955: p_return_status := FND_API.G_RET_STS_ERROR;
3956: l_validate_only := FND_API.G_TRUE;
3957: IF l_debug_level > 0 THEN
3958: oe_debug_pub.add( 'CANNOT IMPORT ORDER AS BOTH INVENTORY_ITEM_ID AND INVENTORY_ITEM_SEGMENTS ARE POPULATED' ) ;

Line 4003: OE_MSG_PUB.Add;

3999: oe_debug_pub.add('Ignoring : '|| l_line_rec.fulfillment_set, 1 ) ;
4000: l_line_rec.fulfillment_set := NULL;
4001: l_line_rec.fulfillment_set_id := NULL;
4002: FND_MESSAGE.Set_Name('ONT','ONT_FULSET_NAME_IGNORED');
4003: OE_MSG_PUB.Add;
4004: END IF;
4005:
4006:
4007:

Line 4297: OE_MSG_PUB.Add;

4293: l_validate_only := FND_API.G_TRUE;
4294: oe_debug_pub.add('You are entering a duplicate orig_sys_att_refat the line level for the same order');
4295: FND_MESSAGE.SET_NAME('ONT','OE_OI_DUPLICATE_REF');
4296: FND_MESSAGE.SET_TOKEN('DUPLICATE_REF','orig_sys_price_att_ref');
4297: OE_MSG_PUB.Add;
4298: END IF;
4299: END IF;
4300: */
4301: l_line_att_count := l_line_att_count+1;

Line 4716: OE_MSG_PUB.add;

4712:
4713: ELSE
4714: --display a message saying Customer Acceptance is not enabled
4715: FND_MESSAGE.Set_Name('ONT', 'ONT_CUST_ACC_DISABLED');
4716: OE_MSG_PUB.add;
4717: END IF;
4718: IF l_debug_level > 0 THEN
4719: oe_debug_pub.add( 'PARAM2/CUSTOMER_COMMENTS: ' || L_ACTION_REQUEST_REC.PARAM2 , 1 ) ;
4720:

Line 5070: OE_MSG_PUB.Add;

5066: IF l_debug_level > 0 THEN
5067: oe_debug_pub.add( 'PROCESS ORDER FAILED WITH ERRORS BUT RETURNED NO MESSAGE' ) ;
5068: END IF;
5069: FND_MESSAGE.SET_NAME('ONT','OE_OI_PO_ERROR');
5070: OE_MSG_PUB.Add;
5071: ELSIF l_return_status_po = FND_API.G_RET_STS_UNEXP_ERROR THEN
5072: IF l_debug_level > 0 THEN
5073: oe_debug_pub.add( 'PROCESS ORDER FAILED WITH UNEXPECTED ERRORS BUT RETURNED NO MESSAGE... ' ) ;
5074: END IF;

Line 5076: OE_MSG_PUB.Add;

5072: IF l_debug_level > 0 THEN
5073: oe_debug_pub.add( 'PROCESS ORDER FAILED WITH UNEXPECTED ERRORS BUT RETURNED NO MESSAGE... ' ) ;
5074: END IF;
5075: FND_MESSAGE.SET_NAME('ONT','OE_OI_PO_UNEXP_ERROR');
5076: OE_MSG_PUB.Add;
5077: END IF;
5078: END IF;
5079:
5080: IF l_header_rec.operation IN ('INSERT', 'CREATE') AND

Line 5332: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

5328: WHEN OTHERS THEN
5329: IF l_debug_level > 0 THEN
5330: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
5331: END IF;
5332: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5333: l_return_status_upd_err := FND_API.G_RET_STS_UNEXP_ERROR;
5334: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');
5335: END IF;
5336: END;

Line 5334: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');

5330: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
5331: END IF;
5332: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5333: l_return_status_upd_err := FND_API.G_RET_STS_UNEXP_ERROR;
5334: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');
5335: END IF;
5336: END;
5337: /* Fixing Bug #2026177 and processing the out nocopy table from process order */
5338:

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

5366: WHEN OTHERS THEN
5367: IF l_debug_level > 0 THEN
5368: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
5369: END IF;
5370: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5371: THEN
5372: l_return_status_upd_err := FND_API.G_RET_STS_UNEXP_ERROR;
5373: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');
5374: END IF;

Line 5373: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');

5369: END IF;
5370: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5371: THEN
5372: l_return_status_upd_err := FND_API.G_RET_STS_UNEXP_ERROR;
5373: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');
5374: END IF;
5375: END;
5376: END IF;
5377: END LOOP;

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

5405: WHEN OTHERS THEN
5406: IF l_debug_level > 0 THEN
5407: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
5408: END IF;
5409: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5410: THEN
5411: l_return_status_upd_err := FND_API.G_RET_STS_UNEXP_ERROR;
5412: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');
5413: END IF;

Line 5412: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');

5408: END IF;
5409: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5410: THEN
5411: l_return_status_upd_err := FND_API.G_RET_STS_UNEXP_ERROR;
5412: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');
5413: END IF;
5414: END;
5415: END IF;
5416: END LOOP;

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

5445: WHEN OTHERS THEN
5446: IF l_debug_level > 0 THEN
5447: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
5448: END IF;
5449: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5450: THEN
5451: l_return_status_upd_err := FND_API.G_RET_STS_UNEXP_ERROR;
5452: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');
5453: END IF;

Line 5452: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');

5448: END IF;
5449: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5450: THEN
5451: l_return_status_upd_err := FND_API.G_RET_STS_UNEXP_ERROR;
5452: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');
5453: END IF;
5454: END;
5455: END IF;
5456: END LOOP;

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

5484: WHEN OTHERS THEN
5485: IF l_debug_level > 0 THEN
5486: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
5487: END IF;
5488: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5489: THEN
5490: l_return_status_upd_err := FND_API.G_RET_STS_UNEXP_ERROR;
5491: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');
5492: END IF;

Line 5491: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');

5487: END IF;
5488: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5489: THEN
5490: l_return_status_upd_err := FND_API.G_RET_STS_UNEXP_ERROR;
5491: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');
5492: END IF;
5493: END;
5494: END IF;
5495: END LOOP;

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

5528: WHEN OTHERS THEN
5529: IF l_debug_level > 0 THEN
5530: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
5531: END IF;
5532: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5533: THEN
5534: l_return_status_upd_err := FND_API.G_RET_STS_UNEXP_ERROR;
5535: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');
5536: END IF;

Line 5535: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');

5531: END IF;
5532: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5533: THEN
5534: l_return_status_upd_err := FND_API.G_RET_STS_UNEXP_ERROR;
5535: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');
5536: END IF;
5537: END;
5538: END IF;
5539: END LOOP;

Line 5542: l_tbl_index := oe_msg_pub.g_msg_tbl.FIRST;

5538: END IF;
5539: END LOOP;
5540: END;
5541: /*
5542: l_tbl_index := oe_msg_pub.g_msg_tbl.FIRST;
5543: LOOP
5544: IF l_debug_level > 0 THEN
5545: oe_debug_pub.add( 'L_TBL_INDEX = '||L_TBL_INDEX ) ;
5546: END IF;

Line 5547: If oe_msg_pub.g_msg_tbl(l_tbl_index).entity_code = 'OI_INL_CUSTSUCC'

5543: LOOP
5544: IF l_debug_level > 0 THEN
5545: oe_debug_pub.add( 'L_TBL_INDEX = '||L_TBL_INDEX ) ;
5546: END IF;
5547: If oe_msg_pub.g_msg_tbl(l_tbl_index).entity_code = 'OI_INL_CUSTSUCC'
5548: Then
5549: IF l_debug_level > 0 THEN
5550: oe_debug_pub.add( 'BEFORE DELETING OI_INL_ADDCUST MSG' ) ;
5551: END IF;

Line 5552: --oe_msg_pub.g_msg_tbl(l_tbl_index).message := Null;

5548: Then
5549: IF l_debug_level > 0 THEN
5550: oe_debug_pub.add( 'BEFORE DELETING OI_INL_ADDCUST MSG' ) ;
5551: END IF;
5552: --oe_msg_pub.g_msg_tbl(l_tbl_index).message := Null;
5553: --oe_msg_pub.g_msg_tbl(l_tbl_index).message_text := Null;
5554: oe_msg_pub.Delete_Msg(p_msg_index => l_tbl_index);
5555: End If;
5556: Exit When l_tbl_index = oe_msg_pub.g_msg_tbl.LAST;

Line 5553: --oe_msg_pub.g_msg_tbl(l_tbl_index).message_text := Null;

5549: IF l_debug_level > 0 THEN
5550: oe_debug_pub.add( 'BEFORE DELETING OI_INL_ADDCUST MSG' ) ;
5551: END IF;
5552: --oe_msg_pub.g_msg_tbl(l_tbl_index).message := Null;
5553: --oe_msg_pub.g_msg_tbl(l_tbl_index).message_text := Null;
5554: oe_msg_pub.Delete_Msg(p_msg_index => l_tbl_index);
5555: End If;
5556: Exit When l_tbl_index = oe_msg_pub.g_msg_tbl.LAST;
5557: l_tbl_index := oe_msg_pub.g_msg_tbl.NEXT(l_tbl_index);

Line 5554: oe_msg_pub.Delete_Msg(p_msg_index => l_tbl_index);

5550: oe_debug_pub.add( 'BEFORE DELETING OI_INL_ADDCUST MSG' ) ;
5551: END IF;
5552: --oe_msg_pub.g_msg_tbl(l_tbl_index).message := Null;
5553: --oe_msg_pub.g_msg_tbl(l_tbl_index).message_text := Null;
5554: oe_msg_pub.Delete_Msg(p_msg_index => l_tbl_index);
5555: End If;
5556: Exit When l_tbl_index = oe_msg_pub.g_msg_tbl.LAST;
5557: l_tbl_index := oe_msg_pub.g_msg_tbl.NEXT(l_tbl_index);
5558: End Loop;

Line 5556: Exit When l_tbl_index = oe_msg_pub.g_msg_tbl.LAST;

5552: --oe_msg_pub.g_msg_tbl(l_tbl_index).message := Null;
5553: --oe_msg_pub.g_msg_tbl(l_tbl_index).message_text := Null;
5554: oe_msg_pub.Delete_Msg(p_msg_index => l_tbl_index);
5555: End If;
5556: Exit When l_tbl_index = oe_msg_pub.g_msg_tbl.LAST;
5557: l_tbl_index := oe_msg_pub.g_msg_tbl.NEXT(l_tbl_index);
5558: End Loop;
5559: */
5560:

Line 5557: l_tbl_index := oe_msg_pub.g_msg_tbl.NEXT(l_tbl_index);

5553: --oe_msg_pub.g_msg_tbl(l_tbl_index).message_text := Null;
5554: oe_msg_pub.Delete_Msg(p_msg_index => l_tbl_index);
5555: End If;
5556: Exit When l_tbl_index = oe_msg_pub.g_msg_tbl.LAST;
5557: l_tbl_index := oe_msg_pub.g_msg_tbl.NEXT(l_tbl_index);
5558: End Loop;
5559: */
5560:
5561: /* -----------------------------------------------------------

Line 5601: OE_MSG_PUB.Count_And_Get (p_count => p_msg_count

5597: /* -----------------------------------------------------------
5598: Update the processing messages table
5599: -----------------------------------------------------------
5600: */
5601: OE_MSG_PUB.Count_And_Get (p_count => p_msg_count
5602: ,p_data => p_msg_data);
5603:
5604: IF l_debug_level > 0 THEN
5605: oe_debug_pub.add( 'MESSAGES RETURNED: '|| TO_CHAR ( P_MSG_COUNT ) ) ;

Line 5613: l_tbl_index := oe_msg_pub.g_msg_tbl.FIRST;

5609:
5610: IF l_debug_level > 0 THEN
5611: oe_debug_pub.add( 'BEFORE UPDATING THE PROCESSING MESSAGES TABLE' ) ;
5612: END IF;
5613: l_tbl_index := oe_msg_pub.g_msg_tbl.FIRST;
5614:
5615: LOOP
5616: IF l_debug_level > 0 THEN
5617: oe_debug_pub.add( 'BEFORE CALLING GET' ) ;

Line 5632: oe_msg_pub.get_msg_context (

5628:
5629: IF l_debug_level > 0 THEN
5630: oe_debug_pub.add( 'BEFORE CALLING GET_MSG_CONTEXT' ) ;
5631: END IF;
5632: oe_msg_pub.get_msg_context (
5633: p_msg_index => l_tbl_index
5634: ,x_entity_code => l_msg_entity_code
5635: ,x_entity_ref => l_msg_entity_ref
5636: ,x_entity_id => l_msg_entity_id

Line 5657: IF oe_msg_pub.g_msg_tbl(l_tbl_index).message_text IS NULL THEN

5653:
5654: IF l_debug_level > 0 THEN
5655: oe_debug_pub.add( 'AFTER CALLING GET_MSG_CONTEXT' ) ;
5656: END IF;
5657: IF oe_msg_pub.g_msg_tbl(l_tbl_index).message_text IS NULL THEN
5658: IF l_debug_level > 0 THEN
5659: oe_debug_pub.add( 'IN INDEX.MESSAGE_TEXT IS NULL' ) ;
5660: END IF;
5661: p_msg_data := oe_msg_pub.get(l_tbl_index, 'F');

Line 5661: p_msg_data := oe_msg_pub.get(l_tbl_index, 'F');

5657: IF oe_msg_pub.g_msg_tbl(l_tbl_index).message_text IS NULL THEN
5658: IF l_debug_level > 0 THEN
5659: oe_debug_pub.add( 'IN INDEX.MESSAGE_TEXT IS NULL' ) ;
5660: END IF;
5661: p_msg_data := oe_msg_pub.get(l_tbl_index, 'F');
5662: END IF;
5663:
5664: l_msg_context := '';
5665: IF l_msg_order_source_id IS NOT NULL THEN

Line 5722: oe_msg_pub.g_msg_tbl(l_tbl_index).header_id := l_header_rec.header_id;

5718: AND l_header_rec.header_id <> FND_API.G_MISS_NUM THEN
5719: IF l_debug_level > 0 THEN
5720: oe_debug_pub.add( 'Header id updated in msg stack:' || l_header_rec.header_id ) ;
5721: END IF;
5722: oe_msg_pub.g_msg_tbl(l_tbl_index).header_id := l_header_rec.header_id;
5723: END IF;
5724: --bug 4195533
5725: Exit When l_tbl_index = oe_msg_pub.g_msg_tbl.LAST;
5726: l_tbl_index := oe_msg_pub.g_msg_tbl.NEXT(l_tbl_index);

Line 5725: Exit When l_tbl_index = oe_msg_pub.g_msg_tbl.LAST;

5721: END IF;
5722: oe_msg_pub.g_msg_tbl(l_tbl_index).header_id := l_header_rec.header_id;
5723: END IF;
5724: --bug 4195533
5725: Exit When l_tbl_index = oe_msg_pub.g_msg_tbl.LAST;
5726: l_tbl_index := oe_msg_pub.g_msg_tbl.NEXT(l_tbl_index);
5727:
5728: END LOOP;
5729: END IF;

Line 5726: l_tbl_index := oe_msg_pub.g_msg_tbl.NEXT(l_tbl_index);

5722: oe_msg_pub.g_msg_tbl(l_tbl_index).header_id := l_header_rec.header_id;
5723: END IF;
5724: --bug 4195533
5725: Exit When l_tbl_index = oe_msg_pub.g_msg_tbl.LAST;
5726: l_tbl_index := oe_msg_pub.g_msg_tbl.NEXT(l_tbl_index);
5727:
5728: END LOOP;
5729: END IF;
5730:

Line 5778: OE_MSG_PUB.save_messages (l_request_id);

5774: oe_debug_pub.add( 'BEFORE SAVING MESSAGES IN THE DATABASE TABLE' ) ;
5775: END IF;
5776:
5777: IF p_msg_count > 0 THEN
5778: OE_MSG_PUB.save_messages (l_request_id);
5779: END IF;
5780: COMMIT; /* commit again to commit the error messages */
5781:
5782:

Line 5907: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

5903: WHEN OTHERS THEN
5904: IF l_debug_level > 0 THEN
5905: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
5906: END IF;
5907: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5908: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');
5909: END IF;
5910: p_msg_count := p_msg_count + 1;
5911: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 5908: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');

5904: IF l_debug_level > 0 THEN
5905: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
5906: END IF;
5907: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5908: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');
5909: END IF;
5910: p_msg_count := p_msg_count + 1;
5911: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5912: