DBA Data[Home] [Help]

APPS.OE_ORDER_COPY_UTIL dependencies on OE_MSG_PUB

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

198: EXCEPTION
199: WHEN OTHERS THEN
200:
201:
202: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
203: THEN
204: OE_MSG_PUB.Add_Exc_Msg
205: ( G_PKG_NAME
206: , l_api_name

Line 204: OE_MSG_PUB.Add_Exc_Msg

200:
201:
202: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
203: THEN
204: OE_MSG_PUB.Add_Exc_Msg
205: ( G_PKG_NAME
206: , l_api_name
207: );
208: END IF;

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

244:
245: RETURN l_category;
246: EXCEPTION
247: WHEN OTHERS THEN
248: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
249: THEN
250: OE_MSG_PUB.Add_Exc_Msg
251: ( G_PKG_NAME
252: , l_api_name

Line 250: OE_MSG_PUB.Add_Exc_Msg

246: EXCEPTION
247: WHEN OTHERS THEN
248: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
249: THEN
250: OE_MSG_PUB.Add_Exc_Msg
251: ( G_PKG_NAME
252: , l_api_name
253: );
254: END IF;

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

321: IF l_debug_level > 0 THEN
322: oe_debug_pub.add( 'IN OTHERS ASWIN' , 2 ) ;
323: END IF;
324:
325: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
326: THEN
327: OE_MSG_PUB.Add_Exc_Msg
328: ( G_PKG_NAME
329: , l_api_name

Line 327: OE_MSG_PUB.Add_Exc_Msg

323: END IF;
324:
325: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
326: THEN
327: OE_MSG_PUB.Add_Exc_Msg
328: ( G_PKG_NAME
329: , l_api_name
330: );
331: END IF;

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

400: END IF;
401:
402: EXCEPTION
403: WHEN OTHERS THEN
404: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
405: THEN
406: OE_MSG_PUB.Add_Exc_Msg
407: ( G_PKG_NAME
408: , l_api_name

Line 406: OE_MSG_PUB.Add_Exc_Msg

402: EXCEPTION
403: WHEN OTHERS THEN
404: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
405: THEN
406: OE_MSG_PUB.Add_Exc_Msg
407: ( G_PKG_NAME
408: , l_api_name
409: );
410: END IF;

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

828: IF l_debug_level > 0 THEN
829: oe_debug_pub.add( 'IN OTHERS' , 2 ) ;
830: END IF;
831:
832: If OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
833: THEN
834: OE_MSG_PUB.Add_Exc_Msg
835: ( G_PKG_NAME
836: , l_api_name

Line 834: OE_MSG_PUB.Add_Exc_Msg

830: END IF;
831:
832: If OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
833: THEN
834: OE_MSG_PUB.Add_Exc_Msg
835: ( G_PKG_NAME
836: , l_api_name
837: );
838: END IF;

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

913: IF l_debug_level > 0 THEN
914: oe_debug_pub.add( 'IN OTHERS' , 2 ) ;
915: END IF;
916:
917: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
918: THEN
919: OE_MSG_PUB.Add_Exc_Msg
920: ( G_PKG_NAME
921: , l_api_name

Line 919: OE_MSG_PUB.Add_Exc_Msg

915: END IF;
916:
917: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
918: THEN
919: OE_MSG_PUB.Add_Exc_Msg
920: ( G_PKG_NAME
921: , l_api_name
922: );
923: END IF;

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

1058: IF l_debug_level > 0 THEN
1059: oe_debug_pub.add( 'IN OTHERS' , 3 ) ;
1060: END IF;
1061:
1062: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1063: THEN
1064: OE_MSG_PUB.Add_Exc_Msg
1065: ( G_PKG_NAME
1066: , l_api_name

Line 1064: OE_MSG_PUB.Add_Exc_Msg

1060: END IF;
1061:
1062: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1063: THEN
1064: OE_MSG_PUB.Add_Exc_Msg
1065: ( G_PKG_NAME
1066: , l_api_name
1067: );
1068: END IF;

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

1283: IF l_debug_level > 0 THEN
1284: oe_debug_pub.add( 'IN OTHERS' , 3 ) ;
1285: END IF;
1286:
1287: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1288: THEN
1289: OE_MSG_PUB.Add_Exc_Msg
1290: ( G_PKG_NAME
1291: , l_api_name

Line 1289: OE_MSG_PUB.Add_Exc_Msg

1285: END IF;
1286:
1287: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1288: THEN
1289: OE_MSG_PUB.Add_Exc_Msg
1290: ( G_PKG_NAME
1291: , l_api_name
1292: );
1293: END IF;

Line 1548: OE_MSG_PUB.Add;

1544:
1545: l_line_tbl.DELETE(k);
1546: --bug3441056 start
1547: FND_MESSAGE.SET_NAME('ONT','ONT_TSO_NO_LINE_COPY');
1548: OE_MSG_PUB.Add;
1549: --RAISE FND_API.G_EXC_ERROR;
1550: --bug3441056 contd
1551: GOTO OUT_OF_MACD_LOGIC;
1552: ELSIF G_ORDER_LEVEL_COPY = 1 THEN

Line 1584: OE_MSG_PUB.Add;

1580: l_line_tbl.DELETE(k);
1581:
1582: IF l_top_container_model = 'Y' THEN
1583: FND_MESSAGE.SET_NAME('ONT','ONT_TSO_NO_BOOKED_ORDER_COPY');
1584: OE_MSG_PUB.Add;
1585: END IF;
1586:
1587: GOTO OUT_OF_MACD_LOGIC;
1588: END IF;

Line 2178: OE_Msg_Pub.Add_Text(l_msg_data);

2174: ,x_msg_count => l_msg_count
2175: ,x_msg_data => l_msg_data);
2176:
2177: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2178: OE_Msg_Pub.Add_Text(l_msg_data);
2179: IF l_debug_level > 0 THEN
2180: oe_debug_pub.add( 'ERROR FROM NEW COPY: '
2181: || L_MSG_DATA , 1 ) ;
2182: END IF;

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

2268: IF l_debug_level > 0 THEN
2269: oe_debug_pub.add( 'IN OTHERS LOAD LINES '|| sqlerrm , 1 ) ;
2270: END IF;
2271:
2272: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2273: THEN
2274: OE_MSG_PUB.Add_Exc_Msg
2275: ( G_PKG_NAME
2276: , l_api_name

Line 2274: OE_MSG_PUB.Add_Exc_Msg

2270: END IF;
2271:
2272: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2273: THEN
2274: OE_MSG_PUB.Add_Exc_Msg
2275: ( G_PKG_NAME
2276: , l_api_name
2277: );
2278: END IF;

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

3422: IF l_debug_level > 0 THEN
3423: oe_debug_pub.add( 'IN OTHERS' , 1 ) ;
3424: END IF;
3425:
3426: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3427: THEN
3428: OE_MSG_PUB.Add_Exc_Msg
3429: ( G_PKG_NAME
3430: , l_api_name

Line 3428: OE_MSG_PUB.Add_Exc_Msg

3424: END IF;
3425:
3426: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3427: THEN
3428: OE_MSG_PUB.Add_Exc_Msg
3429: ( G_PKG_NAME
3430: , l_api_name
3431: );
3432: END IF;

Line 3834: OE_MSG_PUB.initialize;

3830:
3831: -- Initialize message list.
3832:
3833: IF FND_API.to_Boolean(p_copy_rec.init_msg_list) THEN
3834: OE_MSG_PUB.initialize;
3835: END IF;
3836:
3837: -- Initialize API return status to success
3838: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4045: OE_MSG_PUB.Add;

4041: IF l_debug_level > 0 THEN
4042: oe_debug_pub.add('Error in Copy order');
4043: END IF;
4044: FND_MESSAGE.SET_NAME('ONT','OE_CC_NO_COPY_SEC_CODE_REQ');
4045: OE_MSG_PUB.Add;
4046: RAISE FND_API.G_EXC_ERROR;
4047: ELSE
4048: IF l_debug_level > 0 THEN
4049: oe_debug_pub.add('Before calling load and init header payments....');

Line 4226: OE_MSG_PUB.Add;

4222: oe_debug_pub.add('Error in Line Payments Copy order');
4223: oe_debug_pub.add('Copy line payments checkbox...'||l_copy_line_payments);
4224: END IF;
4225: FND_MESSAGE.SET_NAME('ONT','OE_CC_NO_COPY_SEC_CODE_REQ');
4226: OE_MSG_PUB.Add;
4227: RAISE FND_API.G_EXC_ERROR;
4228: ELSE
4229: IF l_debug_level > 0 THEN
4230: oe_debug_pub.add('Before calling load and init line payments...');

Line 4427: OE_MSG_PUB.Add;

4423: oe_debug_pub.add(' Set Result :'||l_sets_result);
4424: END IF;
4425:
4426: FND_MESSAGE.SET_NAME('ONT','OE_COPY_LINE_SETS');
4427: OE_MSG_PUB.Add;
4428: ELSE
4429: IF l_debug_level > 0 THEN
4430: oe_debug_pub.add(' Set Result :'||l_sets_result);
4431: END IF;

Line 4434: OE_MSG_PUB.Add;

4430: oe_debug_pub.add(' Set Result :'||l_sets_result);
4431: END IF;
4432:
4433: FND_MESSAGE.SET_NAME('ONT','OE_FAIL_LINE_SETS');
4434: OE_MSG_PUB.Add;
4435: END IF;
4436: END IF;
4437: -- Copy Sets ER #2830872 , #1566254 End.
4438:

Line 4474: OE_MSG_PUB.Add;

4470: ELSE
4471: FND_MESSAGE.SET_NAME( 'ONT', 'OE_CPY_NEW_QUOTE' );
4472: FND_MESSAGE.SET_TOKEN('QUOTE', to_char(l_header_rec.quote_number));
4473: END IF;
4474: OE_MSG_PUB.Add;
4475:
4476: l_copy_partial_or_full := TRUE;
4477: x_header_id := l_header_rec.header_id;
4478:

Line 4571: OE_MSG_PUB.Add;

4567: ELSE
4568: FND_MESSAGE.SET_NAME( 'ONT', 'OE_QUOTE_CPY_LINES_FAILED' );
4569: FND_MESSAGE.SET_TOKEN('QUOTE', to_char(l_header_rec.quote_number));
4570: END IF;
4571: OE_MSG_PUB.Add;
4572:
4573: ELSIF ( l_all_lines_copied ) THEN
4574:
4575: IF FND_API.to_Boolean(p_copy_rec.copy_order) THEN

Line 4592: OE_MSG_PUB.Add;

4588: FND_MESSAGE.SET_NAME('ONT','OE_CPY_NEW_QUOTE_SUCCESS');
4589: FND_MESSAGE.SET_TOKEN('QUOTE',
4590: to_char(l_header_rec.quote_number));
4591: END IF;
4592: OE_MSG_PUB.Add;
4593:
4594: ELSE
4595:
4596: IF l_debug_level > 0 THEN

Line 4601: OE_MSG_PUB.Add;

4597: oe_debug_pub.add( 'APPENEDED LINES SUCCESSFULLY FOR ORDER : ' || TO_CHAR ( L_HEADER_REC.ORDER_NUMBER ) , 1 ) ;
4598: END IF;
4599:
4600: FND_MESSAGE.SET_NAME('ONT','OE_CPY_APPEND_LINES');
4601: OE_MSG_PUB.Add;
4602:
4603: END IF;
4604:
4605: x_header_id := l_header_rec.header_id;

Line 4619: OE_MSG_PUB.Add;

4615: FND_MESSAGE.SET_NAME('ONT','OE_QUOTE_CPY_COPY_PARTIAL');
4616: FND_MESSAGE.SET_TOKEN('QUOTE',
4617: to_char(l_header_rec.quote_number));
4618: END IF;
4619: OE_MSG_PUB.Add;
4620:
4621: IF l_debug_level > 0 THEN
4622: oe_debug_pub.add( 'COPY SUCCEEDED PARTIALLY FOR ORDER : ' || TO_CHAR ( L_HEADER_REC.ORDER_NUMBER ) , 1 ) ;
4623: END IF;

Line 4668: OE_MSG_PUB.Add;

4664: oe_debug_pub.add( 'FAILED TO COPY ORDER' , 1 ) ;
4665: END IF;
4666:
4667: FND_MESSAGE.SET_NAME('ONT','OE_CPY_COPY_FAILED');
4668: OE_MSG_PUB.Add;
4669:
4670: END IF; -- header created or not;
4671:
4672: IF ( l_delete_config ) THEN

Line 4693: OE_MSG_PUB.Count_And_Get

4689: /* Test 2288800 */
4690:
4691: END LOOP; -- l_hdr_lst
4692:
4693: OE_MSG_PUB.Count_And_Get
4694: ( p_count => x_msg_count,
4695: p_data => x_msg_data );
4696:
4697: -- for bug 1935675

Line 4727: OE_MSG_PUB.Count_And_Get

4723: END IF;
4724: G_LINE_PRICE_MODE := NULL;
4725:
4726: x_return_status := FND_API.G_RET_STS_ERROR ;
4727: OE_MSG_PUB.Count_And_Get
4728: ( p_count => x_msg_count,
4729: p_data => x_msg_data
4730: );
4731: OE_DEBUG_PUB.DumpDebug;

Line 4741: OE_MSG_PUB.Count_And_Get

4737: END IF;
4738: G_LINE_PRICE_MODE := NULL;
4739:
4740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4741: OE_MSG_PUB.Count_And_Get
4742: ( p_count => x_msg_count,
4743: p_data => x_msg_data
4744: );
4745: OE_DEBUG_PUB.DumpDebug;

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

4751: END IF;
4752: G_LINE_PRICE_MODE := NULL;
4753:
4754: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4755: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4756: THEN
4757: OE_MSG_PUB.Add_Exc_Msg
4758: ( G_PKG_NAME
4759: , l_api_name

Line 4757: OE_MSG_PUB.Add_Exc_Msg

4753:
4754: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4755: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4756: THEN
4757: OE_MSG_PUB.Add_Exc_Msg
4758: ( G_PKG_NAME
4759: , l_api_name
4760: );
4761: END IF;

Line 4762: OE_MSG_PUB.Count_And_Get

4758: ( G_PKG_NAME
4759: , l_api_name
4760: );
4761: END IF;
4762: OE_MSG_PUB.Count_And_Get
4763: ( p_count => x_msg_count,
4764: p_data => x_msg_data
4765: );
4766:

Line 5315: OE_MSG_PUB.Add_Exc_Msg

5311: IF l_debug_level > 0 THEN
5312: oe_debug_pub.add( 'OTHERS ERROR , PROCESS_LINE_NUMBERS' ) ;
5313: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
5314: END IF;
5315: OE_MSG_PUB.Add_Exc_Msg
5316: ( G_PKG_NAME
5317: , 'Process_Line_Numbers'
5318: );
5319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;