DBA Data[Home] [Help]

APPS.OE_ORDER_COPY_UTIL dependencies on OE_MSG_PUB

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

159: EXCEPTION
160: WHEN OTHERS THEN
161:
162:
163: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
164: THEN
165: OE_MSG_PUB.Add_Exc_Msg
166: ( G_PKG_NAME
167: , l_api_name

Line 165: OE_MSG_PUB.Add_Exc_Msg

161:
162:
163: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
164: THEN
165: OE_MSG_PUB.Add_Exc_Msg
166: ( G_PKG_NAME
167: , l_api_name
168: );
169: END IF;

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

205:
206: RETURN l_category;
207: EXCEPTION
208: WHEN OTHERS THEN
209: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
210: THEN
211: OE_MSG_PUB.Add_Exc_Msg
212: ( G_PKG_NAME
213: , l_api_name

Line 211: OE_MSG_PUB.Add_Exc_Msg

207: EXCEPTION
208: WHEN OTHERS THEN
209: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
210: THEN
211: OE_MSG_PUB.Add_Exc_Msg
212: ( G_PKG_NAME
213: , l_api_name
214: );
215: END IF;

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

282: IF l_debug_level > 0 THEN
283: oe_debug_pub.add( 'IN OTHERS ASWIN' , 2 ) ;
284: END IF;
285:
286: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
287: THEN
288: OE_MSG_PUB.Add_Exc_Msg
289: ( G_PKG_NAME
290: , l_api_name

Line 288: OE_MSG_PUB.Add_Exc_Msg

284: END IF;
285:
286: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
287: THEN
288: OE_MSG_PUB.Add_Exc_Msg
289: ( G_PKG_NAME
290: , l_api_name
291: );
292: END IF;

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

361: END IF;
362:
363: EXCEPTION
364: WHEN OTHERS THEN
365: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
366: THEN
367: OE_MSG_PUB.Add_Exc_Msg
368: ( G_PKG_NAME
369: , l_api_name

Line 367: OE_MSG_PUB.Add_Exc_Msg

363: EXCEPTION
364: WHEN OTHERS THEN
365: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
366: THEN
367: OE_MSG_PUB.Add_Exc_Msg
368: ( G_PKG_NAME
369: , l_api_name
370: );
371: END IF;

Line 760: If OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

756: IF l_debug_level > 0 THEN
757: oe_debug_pub.add( 'IN OTHERS' , 2 ) ;
758: END IF;
759:
760: If OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
761: THEN
762: OE_MSG_PUB.Add_Exc_Msg
763: ( G_PKG_NAME
764: , l_api_name

Line 762: OE_MSG_PUB.Add_Exc_Msg

758: END IF;
759:
760: If OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
761: THEN
762: OE_MSG_PUB.Add_Exc_Msg
763: ( G_PKG_NAME
764: , l_api_name
765: );
766: END IF;

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

841: IF l_debug_level > 0 THEN
842: oe_debug_pub.add( 'IN OTHERS' , 2 ) ;
843: END IF;
844:
845: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
846: THEN
847: OE_MSG_PUB.Add_Exc_Msg
848: ( G_PKG_NAME
849: , l_api_name

Line 847: OE_MSG_PUB.Add_Exc_Msg

843: END IF;
844:
845: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
846: THEN
847: OE_MSG_PUB.Add_Exc_Msg
848: ( G_PKG_NAME
849: , l_api_name
850: );
851: END IF;

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

986: IF l_debug_level > 0 THEN
987: oe_debug_pub.add( 'IN OTHERS' , 3 ) ;
988: END IF;
989:
990: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
991: THEN
992: OE_MSG_PUB.Add_Exc_Msg
993: ( G_PKG_NAME
994: , l_api_name

Line 992: OE_MSG_PUB.Add_Exc_Msg

988: END IF;
989:
990: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
991: THEN
992: OE_MSG_PUB.Add_Exc_Msg
993: ( G_PKG_NAME
994: , l_api_name
995: );
996: END IF;

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

1211: IF l_debug_level > 0 THEN
1212: oe_debug_pub.add( 'IN OTHERS' , 3 ) ;
1213: END IF;
1214:
1215: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1216: THEN
1217: OE_MSG_PUB.Add_Exc_Msg
1218: ( G_PKG_NAME
1219: , l_api_name

Line 1217: OE_MSG_PUB.Add_Exc_Msg

1213: END IF;
1214:
1215: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1216: THEN
1217: OE_MSG_PUB.Add_Exc_Msg
1218: ( G_PKG_NAME
1219: , l_api_name
1220: );
1221: END IF;

Line 1476: OE_MSG_PUB.Add;

1472:
1473: l_line_tbl.DELETE(k);
1474: --bug3441056 start
1475: FND_MESSAGE.SET_NAME('ONT','ONT_TSO_NO_LINE_COPY');
1476: OE_MSG_PUB.Add;
1477: --RAISE FND_API.G_EXC_ERROR;
1478: --bug3441056 contd
1479: GOTO OUT_OF_MACD_LOGIC;
1480: ELSIF G_ORDER_LEVEL_COPY = 1 THEN

Line 1512: OE_MSG_PUB.Add;

1508: l_line_tbl.DELETE(k);
1509:
1510: IF l_top_container_model = 'Y' THEN
1511: FND_MESSAGE.SET_NAME('ONT','ONT_TSO_NO_BOOKED_ORDER_COPY');
1512: OE_MSG_PUB.Add;
1513: END IF;
1514:
1515: GOTO OUT_OF_MACD_LOGIC;
1516: END IF;

Line 2059: OE_Msg_Pub.Add_Text(l_msg_data);

2055: ,x_msg_count => l_msg_count
2056: ,x_msg_data => l_msg_data);
2057:
2058: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2059: OE_Msg_Pub.Add_Text(l_msg_data);
2060: IF l_debug_level > 0 THEN
2061: oe_debug_pub.add( 'ERROR FROM NEW COPY: '
2062: || L_MSG_DATA , 1 ) ;
2063: END IF;

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

2149: IF l_debug_level > 0 THEN
2150: oe_debug_pub.add( 'IN OTHERS LOAD LINES '|| sqlerrm , 1 ) ;
2151: END IF;
2152:
2153: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2154: THEN
2155: OE_MSG_PUB.Add_Exc_Msg
2156: ( G_PKG_NAME
2157: , l_api_name

Line 2155: OE_MSG_PUB.Add_Exc_Msg

2151: END IF;
2152:
2153: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2154: THEN
2155: OE_MSG_PUB.Add_Exc_Msg
2156: ( G_PKG_NAME
2157: , l_api_name
2158: );
2159: END IF;

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

3272: IF l_debug_level > 0 THEN
3273: oe_debug_pub.add( 'IN OTHERS' , 1 ) ;
3274: END IF;
3275:
3276: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3277: THEN
3278: OE_MSG_PUB.Add_Exc_Msg
3279: ( G_PKG_NAME
3280: , l_api_name

Line 3278: OE_MSG_PUB.Add_Exc_Msg

3274: END IF;
3275:
3276: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3277: THEN
3278: OE_MSG_PUB.Add_Exc_Msg
3279: ( G_PKG_NAME
3280: , l_api_name
3281: );
3282: END IF;

Line 3684: OE_MSG_PUB.initialize;

3680:
3681: -- Initialize message list.
3682:
3683: IF FND_API.to_Boolean(p_copy_rec.init_msg_list) THEN
3684: OE_MSG_PUB.initialize;
3685: END IF;
3686:
3687: -- Initialize API return status to success
3688: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3895: OE_MSG_PUB.Add;

3891: IF l_debug_level > 0 THEN
3892: oe_debug_pub.add('Error in Copy order');
3893: END IF;
3894: FND_MESSAGE.SET_NAME('ONT','OE_CC_NO_COPY_SEC_CODE_REQ');
3895: OE_MSG_PUB.Add;
3896: RAISE FND_API.G_EXC_ERROR;
3897: ELSE
3898: IF l_debug_level > 0 THEN
3899: oe_debug_pub.add('Before calling load and init header payments....');

Line 4076: OE_MSG_PUB.Add;

4072: oe_debug_pub.add('Error in Line Payments Copy order');
4073: oe_debug_pub.add('Copy line payments checkbox...'||l_copy_line_payments);
4074: END IF;
4075: FND_MESSAGE.SET_NAME('ONT','OE_CC_NO_COPY_SEC_CODE_REQ');
4076: OE_MSG_PUB.Add;
4077: RAISE FND_API.G_EXC_ERROR;
4078: ELSE
4079: IF l_debug_level > 0 THEN
4080: oe_debug_pub.add('Before calling load and init line payments...');

Line 4277: OE_MSG_PUB.Add;

4273: oe_debug_pub.add(' Set Result :'||l_sets_result);
4274: END IF;
4275:
4276: FND_MESSAGE.SET_NAME('ONT','OE_COPY_LINE_SETS');
4277: OE_MSG_PUB.Add;
4278: ELSE
4279: IF l_debug_level > 0 THEN
4280: oe_debug_pub.add(' Set Result :'||l_sets_result);
4281: END IF;

Line 4284: OE_MSG_PUB.Add;

4280: oe_debug_pub.add(' Set Result :'||l_sets_result);
4281: END IF;
4282:
4283: FND_MESSAGE.SET_NAME('ONT','OE_FAIL_LINE_SETS');
4284: OE_MSG_PUB.Add;
4285: END IF;
4286: END IF;
4287: -- Copy Sets ER #2830872 , #1566254 End.
4288:

Line 4324: OE_MSG_PUB.Add;

4320: ELSE
4321: FND_MESSAGE.SET_NAME( 'ONT', 'OE_CPY_NEW_QUOTE' );
4322: FND_MESSAGE.SET_TOKEN('QUOTE', to_char(l_header_rec.quote_number));
4323: END IF;
4324: OE_MSG_PUB.Add;
4325:
4326: l_copy_partial_or_full := TRUE;
4327: x_header_id := l_header_rec.header_id;
4328:

Line 4421: OE_MSG_PUB.Add;

4417: ELSE
4418: FND_MESSAGE.SET_NAME( 'ONT', 'OE_QUOTE_CPY_LINES_FAILED' );
4419: FND_MESSAGE.SET_TOKEN('QUOTE', to_char(l_header_rec.quote_number));
4420: END IF;
4421: OE_MSG_PUB.Add;
4422:
4423: ELSIF ( l_all_lines_copied ) THEN
4424:
4425: IF FND_API.to_Boolean(p_copy_rec.copy_order) THEN

Line 4442: OE_MSG_PUB.Add;

4438: FND_MESSAGE.SET_NAME('ONT','OE_CPY_NEW_QUOTE_SUCCESS');
4439: FND_MESSAGE.SET_TOKEN('QUOTE',
4440: to_char(l_header_rec.quote_number));
4441: END IF;
4442: OE_MSG_PUB.Add;
4443:
4444: ELSE
4445:
4446: IF l_debug_level > 0 THEN

Line 4451: OE_MSG_PUB.Add;

4447: oe_debug_pub.add( 'APPENEDED LINES SUCCESSFULLY FOR ORDER : ' || TO_CHAR ( L_HEADER_REC.ORDER_NUMBER ) , 1 ) ;
4448: END IF;
4449:
4450: FND_MESSAGE.SET_NAME('ONT','OE_CPY_APPEND_LINES');
4451: OE_MSG_PUB.Add;
4452:
4453: END IF;
4454:
4455: x_header_id := l_header_rec.header_id;

Line 4469: OE_MSG_PUB.Add;

4465: FND_MESSAGE.SET_NAME('ONT','OE_QUOTE_CPY_COPY_PARTIAL');
4466: FND_MESSAGE.SET_TOKEN('QUOTE',
4467: to_char(l_header_rec.quote_number));
4468: END IF;
4469: OE_MSG_PUB.Add;
4470:
4471: IF l_debug_level > 0 THEN
4472: oe_debug_pub.add( 'COPY SUCCEEDED PARTIALLY FOR ORDER : ' || TO_CHAR ( L_HEADER_REC.ORDER_NUMBER ) , 1 ) ;
4473: END IF;

Line 4518: OE_MSG_PUB.Add;

4514: oe_debug_pub.add( 'FAILED TO COPY ORDER' , 1 ) ;
4515: END IF;
4516:
4517: FND_MESSAGE.SET_NAME('ONT','OE_CPY_COPY_FAILED');
4518: OE_MSG_PUB.Add;
4519:
4520: END IF; -- header created or not;
4521:
4522: IF ( l_delete_config ) THEN

Line 4543: OE_MSG_PUB.Count_And_Get

4539: /* Test 2288800 */
4540:
4541: END LOOP; -- l_hdr_lst
4542:
4543: OE_MSG_PUB.Count_And_Get
4544: ( p_count => x_msg_count,
4545: p_data => x_msg_data );
4546:
4547: -- for bug 1935675

Line 4577: OE_MSG_PUB.Count_And_Get

4573: END IF;
4574: G_LINE_PRICE_MODE := NULL;
4575:
4576: x_return_status := FND_API.G_RET_STS_ERROR ;
4577: OE_MSG_PUB.Count_And_Get
4578: ( p_count => x_msg_count,
4579: p_data => x_msg_data
4580: );
4581: OE_DEBUG_PUB.DumpDebug;

Line 4591: OE_MSG_PUB.Count_And_Get

4587: END IF;
4588: G_LINE_PRICE_MODE := NULL;
4589:
4590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4591: OE_MSG_PUB.Count_And_Get
4592: ( p_count => x_msg_count,
4593: p_data => x_msg_data
4594: );
4595: OE_DEBUG_PUB.DumpDebug;

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

4601: END IF;
4602: G_LINE_PRICE_MODE := NULL;
4603:
4604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4605: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4606: THEN
4607: OE_MSG_PUB.Add_Exc_Msg
4608: ( G_PKG_NAME
4609: , l_api_name

Line 4607: OE_MSG_PUB.Add_Exc_Msg

4603:
4604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4605: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4606: THEN
4607: OE_MSG_PUB.Add_Exc_Msg
4608: ( G_PKG_NAME
4609: , l_api_name
4610: );
4611: END IF;

Line 4612: OE_MSG_PUB.Count_And_Get

4608: ( G_PKG_NAME
4609: , l_api_name
4610: );
4611: END IF;
4612: OE_MSG_PUB.Count_And_Get
4613: ( p_count => x_msg_count,
4614: p_data => x_msg_data
4615: );
4616:

Line 5144: OE_MSG_PUB.Add_Exc_Msg

5140: IF l_debug_level > 0 THEN
5141: oe_debug_pub.add( 'OTHERS ERROR , PROCESS_LINE_NUMBERS' ) ;
5142: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
5143: END IF;
5144: OE_MSG_PUB.Add_Exc_Msg
5145: ( G_PKG_NAME
5146: , 'Process_Line_Numbers'
5147: );
5148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;