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 2010: OE_MSG_PUB.Initialize;

2006: IF p_init_msg_list = FND_API.G_TRUE THEN
2007: IF l_debug_level > 0 THEN
2008: oe_debug_pub.add( 'BEFORE INITIALIZING MESSAGES LIST' ) ;
2009: END IF;
2010: OE_MSG_PUB.Initialize;
2011: END IF;
2012:
2013: /* -----------------------------------------------------------
2014: Set message context

Line 2022: OE_MSG_PUB.set_msg_context(

2018: oe_debug_pub.add( 'BEFORE SETTING MESSAGE CONTEXT' ) ;
2019: oe_debug_pub.add('trim data = '||l_rtrim_data);
2020: END IF;
2021:
2022: OE_MSG_PUB.set_msg_context(
2023: p_entity_code => 'HEADER'
2024: ,p_entity_ref => null
2025: ,p_entity_id => null
2026: ,p_header_id => null

Line 2652: OE_MSG_PUB.Add;

2648: END IF;
2649:
2650: FND_MESSAGE.SET_NAME('ONT','OE_OI_DUPLICATE_REF');
2651: FND_MESSAGE.SET_TOKEN('DUPLICATE_REF','orig_sys_discount_ref');
2652: OE_MSG_PUB.Add;
2653:
2654: END IF;
2655: END IF;
2656:

Line 2829: OE_MSG_PUB.Add;

2825: oe_debug_pub.add( 'YOU ARE ENTERING A DUPLICATE ORIG_SYS_ATTS_REF FOR THE SAME ORDER' ) ;
2826: END IF;
2827: FND_MESSAGE.SET_NAME('ONT','OE_OI_DUPLICATE_REF');
2828: FND_MESSAGE.SET_TOKEN('DUPLICATE_REF','orig_sys_ats_ref');
2829: OE_MSG_PUB.Add;
2830: END IF;
2831: END IF;
2832: l_header_att_count := l_header_att_count +1;
2833: l_header_price_att_tbl(l_header_att_count) := l_header_price_att_rec;

Line 2896: OE_MSG_PUB.Add;

2892: oe_debug_pub.add( 'YOU ARE ENTERING A DUPLICATE ORIG_SYS_CREDIT_REF FORTHE SAME ORDER' ) ;
2893: END IF;
2894: FND_MESSAGE.SET_NAME('ONT','OE_OI_DUPLICATE_REF');
2895: FND_MESSAGE.SET_TOKEN('DUPLICATE_REF','orig_sys_credit_ref');
2896: OE_MSG_PUB.Add;
2897: END IF;
2898: END IF;
2899:
2900: l_header_scredit_count := l_header_scredit_count + 1;

Line 2996: OE_MSG_PUB.Add;

2992: oe_debug_pub.add( 'YOU ARE ENTERING A DUPLICATE ORIG_SYS_payment_REF FORTHE SAME ORDER' ) ;
2993: END IF;
2994: FND_MESSAGE.SET_NAME('ONT','OE_OI_DUPLICATE_REF');
2995: FND_MESSAGE.SET_TOKEN('DUPLICATE_REF','orig_sys_payment_ref');
2996: OE_MSG_PUB.Add;
2997:
2998: END IF;
2999: END IF;
3000:

Line 3154: OE_MSG_PUB.add;

3150: l_action_request_rec.date_param1 := l_action_rec.date_param1;
3151: ELSE
3152: --display a message saying Customer Acceptance is not enabled
3153: FND_MESSAGE.Set_Name('ONT', 'ONT_CUST_ACC_DISABLED');
3154: OE_MSG_PUB.add;
3155: END IF;
3156:
3157: IF l_debug_level > 0 THEN
3158: oe_debug_pub.add( 'PARAM2/CUSTOMER_COMMENTS: ' || L_ACTION_REQUEST_REC.PARAM2 , 1 ) ;

Line 3774: OE_MSG_PUB.Add;

3770: oe_debug_pub.add( 'YOU ARE ENTERING EITHER A DUPLICATE ORIG_SYS_LINE_REF OR ORIG_SYS_SHIPMENT_REF FOR THE SAME ORDER' ) ;
3771: END IF;
3772: FND_MESSAGE.SET_NAME('ONT','OE_OI_DUPLICATE_REF');
3773: FND_MESSAGE.SET_TOKEN('DUPLICATE_REF','orig_sys_line_ref and orig_sys_shipment_ref');
3774: OE_MSG_PUB.Add;
3775: ELSIF
3776: (l_line_rec.orig_sys_line_ref = l_line_tbl(l_line_count).orig_sys_line_ref) AND
3777: (G_IMPORT_SHIPMENTS = 'NO') THEN
3778: p_return_status := FND_API.G_RET_STS_ERROR;

Line 3785: OE_MSG_PUB.Add;

3781: oe_debug_pub.add( 'YOU ARE ENTERING A DUPLICATE ORIG_SYS_LINE_REF FOR THE SAME ORDER' ) ;
3782: END IF;
3783: FND_MESSAGE.SET_NAME('ONT','OE_OI_DUPLICATE_REF');
3784: FND_MESSAGE.SET_TOKEN('DUPLICATE_REF','orig_sys_line_ref');
3785: OE_MSG_PUB.Add;
3786: END IF;
3787: ELSIF
3788: OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL < '110508' THEN
3789: IF (l_line_rec.orig_sys_line_ref = l_line_tbl(l_line_count).orig_sys_line_ref) THEN

Line 3797: OE_MSG_PUB.Add;

3793: oe_debug_pub.add( 'YOU ARE ENTERING A DUPLICATE ORIG_SYS_LINE_REF FOR THESAME ORDER' ) ;
3794: END IF;
3795: FND_MESSAGE.SET_NAME('ONT','OE_OI_DUPLICATE_REF');
3796: FND_MESSAGE.SET_TOKEN('DUPLICATE_REF','orig_sys_line_ref');
3797: OE_MSG_PUB.Add;
3798: END IF;
3799: END IF;
3800: END IF;
3801:

Line 3886: OE_MSG_PUB.Add_TEXT(failure_message);

3882: IF l_debug_level > 0 THEN
3883: oe_debug_pub.add( 'ERROR IN GETTING CCID' ) ;
3884: END IF;
3885: failure_message := fnd_flex_ext.get_message;
3886: OE_MSG_PUB.Add_TEXT(failure_message);
3887: p_return_status := FND_API.G_RET_STS_ERROR;
3888: l_validate_only := FND_API.G_TRUE;
3889: IF l_debug_level > 0 THEN
3890: oe_debug_pub.add('failure message = ' || substr ( failure_message , 1 , 50 ) ) ;

Line 3924: OE_MSG_PUB.Add;

3920: l_line_rec.inventory_item_id := FND_API.G_MISS_NUM;
3921: FND_MESSAGE.SET_NAME('ONT','OE_OIM_INVALID_ITEM_ID');
3922: FND_MESSAGE.SET_TOKEN('ORDER_NO', l_orig_sys_document_ref);
3923: FND_MESSAGE.SET_TOKEN('ORDER_SOURCE', l_order_source_id);
3924: OE_MSG_PUB.Add;
3925: p_return_status := FND_API.G_RET_STS_ERROR;
3926: l_validate_only := FND_API.G_TRUE;
3927: IF l_debug_level > 0 THEN
3928: oe_debug_pub.add( 'CANNOT IMPORT ORDER AS BOTH INVENTORY_ITEM_ID AND INVENTORY_ITEM_SEGMENTS ARE POPULATED' ) ;

Line 3973: OE_MSG_PUB.Add;

3969: oe_debug_pub.add('Ignoring : '|| l_line_rec.fulfillment_set, 1 ) ;
3970: l_line_rec.fulfillment_set := NULL;
3971: l_line_rec.fulfillment_set_id := NULL;
3972: FND_MESSAGE.Set_Name('ONT','ONT_FULSET_NAME_IGNORED');
3973: OE_MSG_PUB.Add;
3974: END IF;
3975:
3976:
3977:

Line 4267: OE_MSG_PUB.Add;

4263: l_validate_only := FND_API.G_TRUE;
4264: oe_debug_pub.add('You are entering a duplicate orig_sys_att_refat the line level for the same order');
4265: FND_MESSAGE.SET_NAME('ONT','OE_OI_DUPLICATE_REF');
4266: FND_MESSAGE.SET_TOKEN('DUPLICATE_REF','orig_sys_price_att_ref');
4267: OE_MSG_PUB.Add;
4268: END IF;
4269: END IF;
4270: */
4271: l_line_att_count := l_line_att_count+1;

Line 4685: OE_MSG_PUB.add;

4681:
4682: ELSE
4683: --display a message saying Customer Acceptance is not enabled
4684: FND_MESSAGE.Set_Name('ONT', 'ONT_CUST_ACC_DISABLED');
4685: OE_MSG_PUB.add;
4686: END IF;
4687: IF l_debug_level > 0 THEN
4688: oe_debug_pub.add( 'PARAM2/CUSTOMER_COMMENTS: ' || L_ACTION_REQUEST_REC.PARAM2 , 1 ) ;
4689:

Line 5039: OE_MSG_PUB.Add;

5035: IF l_debug_level > 0 THEN
5036: oe_debug_pub.add( 'PROCESS ORDER FAILED WITH ERRORS BUT RETURNED NO MESSAGE' ) ;
5037: END IF;
5038: FND_MESSAGE.SET_NAME('ONT','OE_OI_PO_ERROR');
5039: OE_MSG_PUB.Add;
5040: ELSIF l_return_status_po = FND_API.G_RET_STS_UNEXP_ERROR THEN
5041: IF l_debug_level > 0 THEN
5042: oe_debug_pub.add( 'PROCESS ORDER FAILED WITH UNEXPECTED ERRORS BUT RETURNED NO MESSAGE... ' ) ;
5043: END IF;

Line 5045: OE_MSG_PUB.Add;

5041: IF l_debug_level > 0 THEN
5042: oe_debug_pub.add( 'PROCESS ORDER FAILED WITH UNEXPECTED ERRORS BUT RETURNED NO MESSAGE... ' ) ;
5043: END IF;
5044: FND_MESSAGE.SET_NAME('ONT','OE_OI_PO_UNEXP_ERROR');
5045: OE_MSG_PUB.Add;
5046: END IF;
5047: END IF;
5048:
5049: IF l_header_rec.operation IN ('INSERT', 'CREATE') AND

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

5297: WHEN OTHERS THEN
5298: IF l_debug_level > 0 THEN
5299: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
5300: END IF;
5301: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5302: l_return_status_upd_err := FND_API.G_RET_STS_UNEXP_ERROR;
5303: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');
5304: END IF;
5305: END;

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

5299: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
5300: END IF;
5301: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5302: l_return_status_upd_err := FND_API.G_RET_STS_UNEXP_ERROR;
5303: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');
5304: END IF;
5305: END;
5306: /* Fixing Bug #2026177 and processing the out nocopy table from process order */
5307:

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

5335: WHEN OTHERS THEN
5336: IF l_debug_level > 0 THEN
5337: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
5338: END IF;
5339: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5340: THEN
5341: l_return_status_upd_err := FND_API.G_RET_STS_UNEXP_ERROR;
5342: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');
5343: END IF;

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

5338: END IF;
5339: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5340: THEN
5341: l_return_status_upd_err := FND_API.G_RET_STS_UNEXP_ERROR;
5342: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');
5343: END IF;
5344: END;
5345: END IF;
5346: END LOOP;

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

5374: WHEN OTHERS THEN
5375: IF l_debug_level > 0 THEN
5376: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
5377: END IF;
5378: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5379: THEN
5380: l_return_status_upd_err := FND_API.G_RET_STS_UNEXP_ERROR;
5381: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');
5382: END IF;

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

5377: END IF;
5378: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5379: THEN
5380: l_return_status_upd_err := FND_API.G_RET_STS_UNEXP_ERROR;
5381: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');
5382: END IF;
5383: END;
5384: END IF;
5385: END LOOP;

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

5414: WHEN OTHERS THEN
5415: IF l_debug_level > 0 THEN
5416: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
5417: END IF;
5418: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5419: THEN
5420: l_return_status_upd_err := FND_API.G_RET_STS_UNEXP_ERROR;
5421: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');
5422: END IF;

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

5417: END IF;
5418: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5419: THEN
5420: l_return_status_upd_err := FND_API.G_RET_STS_UNEXP_ERROR;
5421: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');
5422: END IF;
5423: END;
5424: END IF;
5425: END LOOP;

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

5453: WHEN OTHERS THEN
5454: IF l_debug_level > 0 THEN
5455: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
5456: END IF;
5457: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5458: THEN
5459: l_return_status_upd_err := FND_API.G_RET_STS_UNEXP_ERROR;
5460: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');
5461: END IF;

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

5456: END IF;
5457: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5458: THEN
5459: l_return_status_upd_err := FND_API.G_RET_STS_UNEXP_ERROR;
5460: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');
5461: END IF;
5462: END;
5463: END IF;
5464: END LOOP;

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

5497: WHEN OTHERS THEN
5498: IF l_debug_level > 0 THEN
5499: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
5500: END IF;
5501: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5502: THEN
5503: l_return_status_upd_err := FND_API.G_RET_STS_UNEXP_ERROR;
5504: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');
5505: END IF;

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

5500: END IF;
5501: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5502: THEN
5503: l_return_status_upd_err := FND_API.G_RET_STS_UNEXP_ERROR;
5504: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');
5505: END IF;
5506: END;
5507: END IF;
5508: END LOOP;

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

5507: END IF;
5508: END LOOP;
5509: END;
5510: /*
5511: l_tbl_index := oe_msg_pub.g_msg_tbl.FIRST;
5512: LOOP
5513: IF l_debug_level > 0 THEN
5514: oe_debug_pub.add( 'L_TBL_INDEX = '||L_TBL_INDEX ) ;
5515: END IF;

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

5512: LOOP
5513: IF l_debug_level > 0 THEN
5514: oe_debug_pub.add( 'L_TBL_INDEX = '||L_TBL_INDEX ) ;
5515: END IF;
5516: If oe_msg_pub.g_msg_tbl(l_tbl_index).entity_code = 'OI_INL_CUSTSUCC'
5517: Then
5518: IF l_debug_level > 0 THEN
5519: oe_debug_pub.add( 'BEFORE DELETING OI_INL_ADDCUST MSG' ) ;
5520: END IF;

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

5517: Then
5518: IF l_debug_level > 0 THEN
5519: oe_debug_pub.add( 'BEFORE DELETING OI_INL_ADDCUST MSG' ) ;
5520: END IF;
5521: --oe_msg_pub.g_msg_tbl(l_tbl_index).message := Null;
5522: --oe_msg_pub.g_msg_tbl(l_tbl_index).message_text := Null;
5523: oe_msg_pub.Delete_Msg(p_msg_index => l_tbl_index);
5524: End If;
5525: Exit When l_tbl_index = oe_msg_pub.g_msg_tbl.LAST;

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

5518: IF l_debug_level > 0 THEN
5519: oe_debug_pub.add( 'BEFORE DELETING OI_INL_ADDCUST MSG' ) ;
5520: END IF;
5521: --oe_msg_pub.g_msg_tbl(l_tbl_index).message := Null;
5522: --oe_msg_pub.g_msg_tbl(l_tbl_index).message_text := Null;
5523: oe_msg_pub.Delete_Msg(p_msg_index => l_tbl_index);
5524: End If;
5525: Exit When l_tbl_index = oe_msg_pub.g_msg_tbl.LAST;
5526: l_tbl_index := oe_msg_pub.g_msg_tbl.NEXT(l_tbl_index);

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

5519: oe_debug_pub.add( 'BEFORE DELETING OI_INL_ADDCUST MSG' ) ;
5520: END IF;
5521: --oe_msg_pub.g_msg_tbl(l_tbl_index).message := Null;
5522: --oe_msg_pub.g_msg_tbl(l_tbl_index).message_text := Null;
5523: oe_msg_pub.Delete_Msg(p_msg_index => l_tbl_index);
5524: End If;
5525: Exit When l_tbl_index = oe_msg_pub.g_msg_tbl.LAST;
5526: l_tbl_index := oe_msg_pub.g_msg_tbl.NEXT(l_tbl_index);
5527: End Loop;

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

5521: --oe_msg_pub.g_msg_tbl(l_tbl_index).message := Null;
5522: --oe_msg_pub.g_msg_tbl(l_tbl_index).message_text := Null;
5523: oe_msg_pub.Delete_Msg(p_msg_index => l_tbl_index);
5524: End If;
5525: Exit When l_tbl_index = oe_msg_pub.g_msg_tbl.LAST;
5526: l_tbl_index := oe_msg_pub.g_msg_tbl.NEXT(l_tbl_index);
5527: End Loop;
5528: */
5529:

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

5522: --oe_msg_pub.g_msg_tbl(l_tbl_index).message_text := Null;
5523: oe_msg_pub.Delete_Msg(p_msg_index => l_tbl_index);
5524: End If;
5525: Exit When l_tbl_index = oe_msg_pub.g_msg_tbl.LAST;
5526: l_tbl_index := oe_msg_pub.g_msg_tbl.NEXT(l_tbl_index);
5527: End Loop;
5528: */
5529:
5530: /* -----------------------------------------------------------

Line 5570: OE_MSG_PUB.Count_And_Get (p_count => p_msg_count

5566: /* -----------------------------------------------------------
5567: Update the processing messages table
5568: -----------------------------------------------------------
5569: */
5570: OE_MSG_PUB.Count_And_Get (p_count => p_msg_count
5571: ,p_data => p_msg_data);
5572:
5573: IF l_debug_level > 0 THEN
5574: oe_debug_pub.add( 'MESSAGES RETURNED: '|| TO_CHAR ( P_MSG_COUNT ) ) ;

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

5578:
5579: IF l_debug_level > 0 THEN
5580: oe_debug_pub.add( 'BEFORE UPDATING THE PROCESSING MESSAGES TABLE' ) ;
5581: END IF;
5582: l_tbl_index := oe_msg_pub.g_msg_tbl.FIRST;
5583:
5584: LOOP
5585: IF l_debug_level > 0 THEN
5586: oe_debug_pub.add( 'BEFORE CALLING GET' ) ;

Line 5601: oe_msg_pub.get_msg_context (

5597:
5598: IF l_debug_level > 0 THEN
5599: oe_debug_pub.add( 'BEFORE CALLING GET_MSG_CONTEXT' ) ;
5600: END IF;
5601: oe_msg_pub.get_msg_context (
5602: p_msg_index => l_tbl_index
5603: ,x_entity_code => l_msg_entity_code
5604: ,x_entity_ref => l_msg_entity_ref
5605: ,x_entity_id => l_msg_entity_id

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

5622:
5623: IF l_debug_level > 0 THEN
5624: oe_debug_pub.add( 'AFTER CALLING GET_MSG_CONTEXT' ) ;
5625: END IF;
5626: IF oe_msg_pub.g_msg_tbl(l_tbl_index).message_text IS NULL THEN
5627: IF l_debug_level > 0 THEN
5628: oe_debug_pub.add( 'IN INDEX.MESSAGE_TEXT IS NULL' ) ;
5629: END IF;
5630: p_msg_data := oe_msg_pub.get(l_tbl_index, 'F');

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

5626: IF oe_msg_pub.g_msg_tbl(l_tbl_index).message_text IS NULL THEN
5627: IF l_debug_level > 0 THEN
5628: oe_debug_pub.add( 'IN INDEX.MESSAGE_TEXT IS NULL' ) ;
5629: END IF;
5630: p_msg_data := oe_msg_pub.get(l_tbl_index, 'F');
5631: END IF;
5632:
5633: l_msg_context := '';
5634: IF l_msg_order_source_id IS NOT NULL THEN

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

5687: AND l_header_rec.header_id <> FND_API.G_MISS_NUM THEN
5688: IF l_debug_level > 0 THEN
5689: oe_debug_pub.add( 'Header id updated in msg stack:' || l_header_rec.header_id ) ;
5690: END IF;
5691: oe_msg_pub.g_msg_tbl(l_tbl_index).header_id := l_header_rec.header_id;
5692: END IF;
5693: --bug 4195533
5694: Exit When l_tbl_index = oe_msg_pub.g_msg_tbl.LAST;
5695: l_tbl_index := oe_msg_pub.g_msg_tbl.NEXT(l_tbl_index);

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

5690: END IF;
5691: oe_msg_pub.g_msg_tbl(l_tbl_index).header_id := l_header_rec.header_id;
5692: END IF;
5693: --bug 4195533
5694: Exit When l_tbl_index = oe_msg_pub.g_msg_tbl.LAST;
5695: l_tbl_index := oe_msg_pub.g_msg_tbl.NEXT(l_tbl_index);
5696:
5697: END LOOP;
5698: END IF;

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

5691: oe_msg_pub.g_msg_tbl(l_tbl_index).header_id := l_header_rec.header_id;
5692: END IF;
5693: --bug 4195533
5694: Exit When l_tbl_index = oe_msg_pub.g_msg_tbl.LAST;
5695: l_tbl_index := oe_msg_pub.g_msg_tbl.NEXT(l_tbl_index);
5696:
5697: END LOOP;
5698: END IF;
5699:

Line 5747: OE_MSG_PUB.save_messages (l_request_id);

5743: oe_debug_pub.add( 'BEFORE SAVING MESSAGES IN THE DATABASE TABLE' ) ;
5744: END IF;
5745:
5746: IF p_msg_count > 0 THEN
5747: OE_MSG_PUB.save_messages (l_request_id);
5748: END IF;
5749: COMMIT; /* commit again to commit the error messages */
5750:
5751:

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

5872: WHEN OTHERS THEN
5873: IF l_debug_level > 0 THEN
5874: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
5875: END IF;
5876: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5877: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');
5878: END IF;
5879: p_msg_count := p_msg_count + 1;
5880: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

5873: IF l_debug_level > 0 THEN
5874: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
5875: END IF;
5876: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5877: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');
5878: END IF;
5879: p_msg_count := p_msg_count + 1;
5880: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5881: