DBA Data[Home] [Help]

APPS.OE_SHIP_CONFIRMATION_PUB dependencies on OE_MSG_PUB

Line 1325: OE_MSG_PUB.Count_And_Get

1321: END IF; --IF p_line_tbl.COUNT > 0
1322:
1323: x_return_status := FND_API.G_RET_STS_SUCCESS;
1324:
1325: OE_MSG_PUB.Count_And_Get
1326: ( p_count => x_msg_count
1327: , p_data => x_msg_data
1328: );
1329:

Line 1345: OE_MSG_PUB.Count_And_Get

1341: x_return_status := FND_API.G_RET_STS_ERROR;
1342:
1343: -- Get message count and data
1344:
1345: OE_MSG_PUB.Count_And_Get
1346: ( p_count => x_msg_count
1347: , p_data => x_msg_data
1348: );
1349:

Line 1359: OE_MSG_PUB.Count_And_Get

1355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1356:
1357: -- Get message count and data
1358:
1359: OE_MSG_PUB.Count_And_Get
1360: ( p_count => x_msg_count
1361: , p_data => x_msg_data
1362: );
1363:

Line 1380: OE_MSG_PUB.Count_And_Get

1376: END IF;
1377:
1378: -- Get message count and data
1379:
1380: OE_MSG_PUB.Count_And_Get
1381: ( p_count => x_msg_count
1382: , p_data => x_msg_data
1383: );
1384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 3692: OE_Msg_Pub.Add_Text('Could not obtain Lock on Order Line/s');

3688: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
3689: IF l_debug_level > 0 THEN
3690: OE_DEBUG_PUB.Add('Unable to lock the line',3);
3691: END IF;
3692: OE_Msg_Pub.Add_Text('Could not obtain Lock on Order Line/s');
3693: RAISE FND_API.G_EXC_ERROR;
3694:
3695: WHEN OTHERS THEN
3696: IF l_debug_level > 0 THEN

Line 3766: OE_MSG_PUB.set_msg_context(

3762: oe_debug_pub.ADD('request_line_rec line_id count: ' || p_requested_line_rec.line_id.COUNT, 3);
3763: END IF;
3764:
3765: -- Setting the message context, bug 4516453
3766: OE_MSG_PUB.set_msg_context(
3767: p_entity_code => 'HEADER'
3768: ,p_entity_id => p_ship_line_rec.header_id(p_ship_line_rec.header_id.FIRST)
3769: ,p_header_id => p_ship_line_rec.header_id(p_ship_line_rec.header_id.FIRST)
3770: ,p_line_id => null

Line 3891: OE_Msg_Pub.Add_Text('Could not obtain Lock on Order Line/s');

3887: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
3888: IF l_debug_level > 0 THEN
3889: OE_DEBUG_PUB.Add('Unable to lock the line',3);
3890: END IF;
3891: OE_Msg_Pub.Add_Text('Could not obtain Lock on Order Line/s');
3892: RAISE FND_API.G_EXC_ERROR;
3893: WHEN others THEN
3894: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3895: IF l_debug_level > 0 THEN

Line 3920: OE_Msg_Pub.Add_Text('Could not obtain Lock on Ship Set');

3916: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
3917: IF l_debug_level > 0 THEN
3918: OE_DEBUG_PUB.Add('Unable to lock the ship set :' || l_ship_set_id ,3);
3919: END IF;
3920: OE_Msg_Pub.Add_Text('Could not obtain Lock on Ship Set');
3921: RAISE FND_API.G_EXC_ERROR;
3922: WHEN others THEN
3923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3924: IF l_debug_level > 0 THEN

Line 3950: OE_Msg_Pub.Add_Text('Could not obtain Lock on Arrival Set');

3946: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
3947: IF l_debug_level > 0 THEN
3948: OE_DEBUG_PUB.Add('Unable to lock the arrival set :' || l_arrival_set_id ,3);
3949: END IF;
3950: OE_Msg_Pub.Add_Text('Could not obtain Lock on Arrival Set');
3951: RAISE FND_API.G_EXC_ERROR;
3952: WHEN others THEN
3953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3954: IF l_debug_level > 0 THEN

Line 4284: OE_MSG_PUB.Reset_Msg_Context (p_entity_code => 'HEADER'); -- bug 4516453

4280: ,x_return_status => x_return_status
4281: ,p_line_tbl => l_line_tbl
4282: ,p_old_line_tbl => l_old_line_tbl );
4283:
4284: OE_MSG_PUB.Reset_Msg_Context (p_entity_code => 'HEADER'); -- bug 4516453
4285:
4286: --CC Reversal ER#16014135 Start
4287: FOR I in p_ship_line_rec.line_id.FIRST..p_ship_line_rec.line_id.LAST
4288: LOOP

Line 4336: OE_Msg_Pub.Add_Text('Could not obtain Lock on Order Line/s');

4332: OE_DEBUG_PUB.Add('Unable to lock the line',3);
4333: END IF;
4334: --9354229
4335: oe_globals.g_call_process_req := TRUE;
4336: OE_Msg_Pub.Add_Text('Could not obtain Lock on Order Line/s');
4337: OE_MSG_PUB.Save_API_Messages(); --bug 4516453
4338: OE_MSG_PUB.Reset_Msg_Context (p_entity_code => 'HEADER'); -- bug 4516453
4339: RAISE FND_API.G_EXC_ERROR;
4340:

Line 4337: OE_MSG_PUB.Save_API_Messages(); --bug 4516453

4333: END IF;
4334: --9354229
4335: oe_globals.g_call_process_req := TRUE;
4336: OE_Msg_Pub.Add_Text('Could not obtain Lock on Order Line/s');
4337: OE_MSG_PUB.Save_API_Messages(); --bug 4516453
4338: OE_MSG_PUB.Reset_Msg_Context (p_entity_code => 'HEADER'); -- bug 4516453
4339: RAISE FND_API.G_EXC_ERROR;
4340:
4341: WHEN others THEN

Line 4338: OE_MSG_PUB.Reset_Msg_Context (p_entity_code => 'HEADER'); -- bug 4516453

4334: --9354229
4335: oe_globals.g_call_process_req := TRUE;
4336: OE_Msg_Pub.Add_Text('Could not obtain Lock on Order Line/s');
4337: OE_MSG_PUB.Save_API_Messages(); --bug 4516453
4338: OE_MSG_PUB.Reset_Msg_Context (p_entity_code => 'HEADER'); -- bug 4516453
4339: RAISE FND_API.G_EXC_ERROR;
4340:
4341: WHEN others THEN
4342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4348: OE_MSG_PUB.Save_API_Messages(); --bug 4516453

4344: Oe_Debug_pub.Add('error in handle_nonbulk_mode '|| sqlerrm, 3);
4345: END IF;
4346: --9354229
4347: oe_globals.g_call_process_req := TRUE;
4348: OE_MSG_PUB.Save_API_Messages(); --bug 4516453
4349: OE_MSG_PUB.Reset_Msg_Context (p_entity_code => 'HEADER'); -- bug 4516453
4350: RAISE;
4351: END Handle_NonBulk_Mode;
4352:

Line 4349: OE_MSG_PUB.Reset_Msg_Context (p_entity_code => 'HEADER'); -- bug 4516453

4345: END IF;
4346: --9354229
4347: oe_globals.g_call_process_req := TRUE;
4348: OE_MSG_PUB.Save_API_Messages(); --bug 4516453
4349: OE_MSG_PUB.Reset_Msg_Context (p_entity_code => 'HEADER'); -- bug 4516453
4350: RAISE;
4351: END Handle_NonBulk_Mode;
4352:
4353:

Line 4527: OE_MSG_PUB.set_msg_context(

4523:
4524: x_return_status := FND_API.G_RET_STS_SUCCESS;
4525:
4526: -- Setting the message context, bug 4516453
4527: OE_MSG_PUB.set_msg_context(
4528: p_entity_code => 'HEADER'
4529: ,p_entity_id => p_ship_line_rec.header_id(p_start_index)
4530: ,p_header_id => p_ship_line_rec.header_id(p_start_index)
4531: ,p_line_id => null

Line 5022: OE_MSG_PUB.Reset_Msg_Context (p_entity_code => 'HEADER');

5018: END IF;
5019: --12552430 End
5020:
5021: -- Reseting the msg context, bug 4516453
5022: OE_MSG_PUB.Reset_Msg_Context (p_entity_code => 'HEADER');
5023:
5024: IF l_debug_level > 0 THEN
5025: oe_debug_pub.add('leaving Handle_Bulk_Mode_Per_Order '|| x_return_status, 1);
5026: END IF;

Line 5033: OE_Msg_Pub.Add_Text('Could not obtain Lock on Order Line/s');

5029: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
5030: IF l_debug_level > 0 THEN
5031: OE_DEBUG_PUB.Add('Unable to lock the line',3);
5032: END IF;
5033: OE_Msg_Pub.Add_Text('Could not obtain Lock on Order Line/s');
5034: OE_MSG_PUB.Save_API_Messages(); --bug 4516453
5035: OE_MSG_PUB.Reset_Msg_Context (p_entity_code => 'HEADER');
5036: RAISE FND_API.G_EXC_ERROR;
5037:

Line 5034: OE_MSG_PUB.Save_API_Messages(); --bug 4516453

5030: IF l_debug_level > 0 THEN
5031: OE_DEBUG_PUB.Add('Unable to lock the line',3);
5032: END IF;
5033: OE_Msg_Pub.Add_Text('Could not obtain Lock on Order Line/s');
5034: OE_MSG_PUB.Save_API_Messages(); --bug 4516453
5035: OE_MSG_PUB.Reset_Msg_Context (p_entity_code => 'HEADER');
5036: RAISE FND_API.G_EXC_ERROR;
5037:
5038: WHEN others THEN

Line 5035: OE_MSG_PUB.Reset_Msg_Context (p_entity_code => 'HEADER');

5031: OE_DEBUG_PUB.Add('Unable to lock the line',3);
5032: END IF;
5033: OE_Msg_Pub.Add_Text('Could not obtain Lock on Order Line/s');
5034: OE_MSG_PUB.Save_API_Messages(); --bug 4516453
5035: OE_MSG_PUB.Reset_Msg_Context (p_entity_code => 'HEADER');
5036: RAISE FND_API.G_EXC_ERROR;
5037:
5038: WHEN others THEN
5039: IF l_debug_level > 0 THEN

Line 5042: OE_MSG_PUB.Save_API_Messages(); --bug 4516453

5038: WHEN others THEN
5039: IF l_debug_level > 0 THEN
5040: oe_debug_pub.add('error in Handle_Bulk_Mode_Per_Order ' || sqlerrm, 1);
5041: END IF;
5042: OE_MSG_PUB.Save_API_Messages(); --bug 4516453
5043: OE_MSG_PUB.Reset_Msg_Context (p_entity_code => 'HEADER');
5044: RAISE;
5045: END Handle_Bulk_Mode_Per_Order;
5046:

Line 5043: OE_MSG_PUB.Reset_Msg_Context (p_entity_code => 'HEADER');

5039: IF l_debug_level > 0 THEN
5040: oe_debug_pub.add('error in Handle_Bulk_Mode_Per_Order ' || sqlerrm, 1);
5041: END IF;
5042: OE_MSG_PUB.Save_API_Messages(); --bug 4516453
5043: OE_MSG_PUB.Reset_Msg_Context (p_entity_code => 'HEADER');
5044: RAISE;
5045: END Handle_Bulk_Mode_Per_Order;
5046:
5047: /*------------------------------------------------------------

Line 5083: OE_MSG_PUB.Add;

5079: -- MOAC check for Org_id
5080: l_org_id := MO_GLOBAL.get_current_org_id;
5081: IF (l_org_id IS NULL OR l_org_id = FND_API.G_MISS_NUM) THEN
5082: FND_MESSAGE.set_name('FND','MO_ORG_REQUIRED');
5083: OE_MSG_PUB.Add;
5084: RAISE FND_API.G_EXC_ERROR;
5085: END IF;
5086:
5087: SAVEPOINT om_ship_confirm;

Line 5202: OE_MSG_PUB.Count_And_Get

5198: ( x_return_status => l_return_status);
5199:
5200: x_return_status := FND_API.G_RET_STS_ERROR;
5201:
5202: OE_MSG_PUB.Count_And_Get
5203: (p_count => x_msg_count
5204: ,p_data => x_msg_data);
5205:
5206: IF l_debug_level > 0 THEN

Line 5222: OE_MSG_PUB.Count_And_Get

5218: ( x_return_status => l_return_status);
5219:
5220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5221:
5222: OE_MSG_PUB.Count_And_Get
5223: (p_count => x_msg_count
5224: ,p_data => x_msg_data);
5225:
5226: IF l_debug_level > 0 THEN

Line 5247: OE_MSG_PUB.Count_And_Get

5243: ( G_PKG_NAME
5244: ,'ship_confirm_new');
5245: END IF;
5246:
5247: OE_MSG_PUB.Count_And_Get
5248: (p_count => x_msg_count
5249: ,p_data => x_msg_data);
5250:
5251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5614: OE_MSG_PUB.Count_And_Get

5610: END IF;
5611: EXCEPTION
5612: WHEN FND_API.G_EXC_ERROR THEN
5613: x_return_status := FND_API.G_RET_STS_ERROR;
5614: OE_MSG_PUB.Count_And_Get
5615: ( p_count => x_msg_count
5616: , p_data => x_msg_data
5617: );
5618:

Line 5622: OE_MSG_PUB.Count_And_Get

5618:
5619: WHEN OTHERS THEN
5620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5621: x_result_out := 'U';
5622: OE_MSG_PUB.Count_And_Get
5623: ( p_count => x_msg_count
5624: , p_data => x_msg_data
5625: );
5626: END ship_zero;