DBA Data[Home] [Help]

APPS.OE_SHIP_CONFIRMATION_PUB dependencies on OE_MSG_PUB

Line 1280: OE_MSG_PUB.Count_And_Get

1276: END IF; --IF p_line_tbl.COUNT > 0
1277:
1278: x_return_status := FND_API.G_RET_STS_SUCCESS;
1279:
1280: OE_MSG_PUB.Count_And_Get
1281: ( p_count => x_msg_count
1282: , p_data => x_msg_data
1283: );
1284:

Line 1300: OE_MSG_PUB.Count_And_Get

1296: x_return_status := FND_API.G_RET_STS_ERROR;
1297:
1298: -- Get message count and data
1299:
1300: OE_MSG_PUB.Count_And_Get
1301: ( p_count => x_msg_count
1302: , p_data => x_msg_data
1303: );
1304:

Line 1314: OE_MSG_PUB.Count_And_Get

1310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1311:
1312: -- Get message count and data
1313:
1314: OE_MSG_PUB.Count_And_Get
1315: ( p_count => x_msg_count
1316: , p_data => x_msg_data
1317: );
1318:

Line 1335: OE_MSG_PUB.Count_And_Get

1331: END IF;
1332:
1333: -- Get message count and data
1334:
1335: OE_MSG_PUB.Count_And_Get
1336: ( p_count => x_msg_count
1337: , p_data => x_msg_data
1338: );
1339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

3506: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
3507: IF l_debug_level > 0 THEN
3508: OE_DEBUG_PUB.Add('Unable to lock the line',3);
3509: END IF;
3510: OE_Msg_Pub.Add_Text('Could not obtain Lock on Order Line/s');
3511: RAISE FND_API.G_EXC_ERROR;
3512:
3513: WHEN OTHERS THEN
3514: IF l_debug_level > 0 THEN

Line 3572: OE_MSG_PUB.set_msg_context(

3568: oe_debug_pub.ADD('request_line_rec line_id count: ' || p_requested_line_rec.line_id.COUNT, 3);
3569: END IF;
3570:
3571: -- Setting the message context, bug 4516453
3572: OE_MSG_PUB.set_msg_context(
3573: p_entity_code => 'HEADER'
3574: ,p_entity_id => p_ship_line_rec.header_id(p_ship_line_rec.header_id.FIRST)
3575: ,p_header_id => p_ship_line_rec.header_id(p_ship_line_rec.header_id.FIRST)
3576: ,p_line_id => null

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

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

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

3718: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
3719: IF l_debug_level > 0 THEN
3720: OE_DEBUG_PUB.Add('Unable to lock the ship set :' || l_ship_set_id ,3);
3721: END IF;
3722: OE_Msg_Pub.Add_Text('Could not obtain Lock on Ship Set');
3723: RAISE FND_API.G_EXC_ERROR;
3724: WHEN others THEN
3725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3726: IF l_debug_level > 0 THEN

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

3748: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
3749: IF l_debug_level > 0 THEN
3750: OE_DEBUG_PUB.Add('Unable to lock the arrival set :' || l_arrival_set_id ,3);
3751: END IF;
3752: OE_Msg_Pub.Add_Text('Could not obtain Lock on Arrival Set');
3753: RAISE FND_API.G_EXC_ERROR;
3754: WHEN others THEN
3755: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3756: IF l_debug_level > 0 THEN

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

4039: ,x_return_status => x_return_status
4040: ,p_line_tbl => l_line_tbl
4041: ,p_old_line_tbl => l_old_line_tbl );
4042:
4043: OE_MSG_PUB.Reset_Msg_Context (p_entity_code => 'HEADER'); -- bug 4516453
4044:
4045: IF l_debug_level > 0 THEN
4046: Oe_Debug_pub.Add('leaving handle_nonbulk_mode '||x_return_status, 3);
4047: END IF;

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

4050: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
4051: IF l_debug_level > 0 THEN
4052: OE_DEBUG_PUB.Add('Unable to lock the line',3);
4053: END IF;
4054: OE_Msg_Pub.Add_Text('Could not obtain Lock on Order Line/s');
4055: OE_MSG_PUB.Save_API_Messages(); --bug 4516453
4056: OE_MSG_PUB.Reset_Msg_Context (p_entity_code => 'HEADER'); -- bug 4516453
4057: RAISE FND_API.G_EXC_ERROR;
4058:

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

4051: IF l_debug_level > 0 THEN
4052: OE_DEBUG_PUB.Add('Unable to lock the line',3);
4053: END IF;
4054: OE_Msg_Pub.Add_Text('Could not obtain Lock on Order Line/s');
4055: OE_MSG_PUB.Save_API_Messages(); --bug 4516453
4056: OE_MSG_PUB.Reset_Msg_Context (p_entity_code => 'HEADER'); -- bug 4516453
4057: RAISE FND_API.G_EXC_ERROR;
4058:
4059: WHEN others THEN

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

4052: OE_DEBUG_PUB.Add('Unable to lock the line',3);
4053: END IF;
4054: OE_Msg_Pub.Add_Text('Could not obtain Lock on Order Line/s');
4055: OE_MSG_PUB.Save_API_Messages(); --bug 4516453
4056: OE_MSG_PUB.Reset_Msg_Context (p_entity_code => 'HEADER'); -- bug 4516453
4057: RAISE FND_API.G_EXC_ERROR;
4058:
4059: WHEN others THEN
4060: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

4060: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4061: IF l_debug_level > 0 THEN
4062: Oe_Debug_pub.Add('error in handle_nonbulk_mode '|| sqlerrm, 3);
4063: END IF;
4064: OE_MSG_PUB.Save_API_Messages(); --bug 4516453
4065: OE_MSG_PUB.Reset_Msg_Context (p_entity_code => 'HEADER'); -- bug 4516453
4066: RAISE;
4067: END Handle_NonBulk_Mode;
4068:

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

4061: IF l_debug_level > 0 THEN
4062: Oe_Debug_pub.Add('error in handle_nonbulk_mode '|| sqlerrm, 3);
4063: END IF;
4064: OE_MSG_PUB.Save_API_Messages(); --bug 4516453
4065: OE_MSG_PUB.Reset_Msg_Context (p_entity_code => 'HEADER'); -- bug 4516453
4066: RAISE;
4067: END Handle_NonBulk_Mode;
4068:
4069:

Line 4236: OE_MSG_PUB.set_msg_context(

4232:
4233: x_return_status := FND_API.G_RET_STS_SUCCESS;
4234:
4235: -- Setting the message context, bug 4516453
4236: OE_MSG_PUB.set_msg_context(
4237: p_entity_code => 'HEADER'
4238: ,p_entity_id => p_ship_line_rec.header_id(p_start_index)
4239: ,p_header_id => p_ship_line_rec.header_id(p_start_index)
4240: ,p_line_id => null

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

4657: END IF;
4658: END IF;
4659:
4660: -- Reseting the msg context, bug 4516453
4661: OE_MSG_PUB.Reset_Msg_Context (p_entity_code => 'HEADER');
4662:
4663: IF l_debug_level > 0 THEN
4664: oe_debug_pub.add('leaving Handle_Bulk_Mode_Per_Order '|| x_return_status, 1);
4665: END IF;

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

4668: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
4669: IF l_debug_level > 0 THEN
4670: OE_DEBUG_PUB.Add('Unable to lock the line',3);
4671: END IF;
4672: OE_Msg_Pub.Add_Text('Could not obtain Lock on Order Line/s');
4673: OE_MSG_PUB.Save_API_Messages(); --bug 4516453
4674: OE_MSG_PUB.Reset_Msg_Context (p_entity_code => 'HEADER');
4675: RAISE FND_API.G_EXC_ERROR;
4676:

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

4669: IF l_debug_level > 0 THEN
4670: OE_DEBUG_PUB.Add('Unable to lock the line',3);
4671: END IF;
4672: OE_Msg_Pub.Add_Text('Could not obtain Lock on Order Line/s');
4673: OE_MSG_PUB.Save_API_Messages(); --bug 4516453
4674: OE_MSG_PUB.Reset_Msg_Context (p_entity_code => 'HEADER');
4675: RAISE FND_API.G_EXC_ERROR;
4676:
4677: WHEN others THEN

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

4670: OE_DEBUG_PUB.Add('Unable to lock the line',3);
4671: END IF;
4672: OE_Msg_Pub.Add_Text('Could not obtain Lock on Order Line/s');
4673: OE_MSG_PUB.Save_API_Messages(); --bug 4516453
4674: OE_MSG_PUB.Reset_Msg_Context (p_entity_code => 'HEADER');
4675: RAISE FND_API.G_EXC_ERROR;
4676:
4677: WHEN others THEN
4678: IF l_debug_level > 0 THEN

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

4677: WHEN others THEN
4678: IF l_debug_level > 0 THEN
4679: oe_debug_pub.add('error in Handle_Bulk_Mode_Per_Order ' || sqlerrm, 1);
4680: END IF;
4681: OE_MSG_PUB.Save_API_Messages(); --bug 4516453
4682: OE_MSG_PUB.Reset_Msg_Context (p_entity_code => 'HEADER');
4683: RAISE;
4684: END Handle_Bulk_Mode_Per_Order;
4685:

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

4678: IF l_debug_level > 0 THEN
4679: oe_debug_pub.add('error in Handle_Bulk_Mode_Per_Order ' || sqlerrm, 1);
4680: END IF;
4681: OE_MSG_PUB.Save_API_Messages(); --bug 4516453
4682: OE_MSG_PUB.Reset_Msg_Context (p_entity_code => 'HEADER');
4683: RAISE;
4684: END Handle_Bulk_Mode_Per_Order;
4685:
4686: /*------------------------------------------------------------

Line 4721: OE_MSG_PUB.Add;

4717: -- MOAC check for Org_id
4718: l_org_id := MO_GLOBAL.get_current_org_id;
4719: IF (l_org_id IS NULL OR l_org_id = FND_API.G_MISS_NUM) THEN
4720: FND_MESSAGE.set_name('FND','MO_ORG_REQUIRED');
4721: OE_MSG_PUB.Add;
4722: RAISE FND_API.G_EXC_ERROR;
4723: END IF;
4724:
4725: SAVEPOINT om_ship_confirm;

Line 4835: OE_MSG_PUB.Count_And_Get

4831: oe_debug_pub.add('ship_confirm_new EXC ERROR: '||SQLERRM,1);
4832: END IF;
4833: x_return_status := FND_API.G_RET_STS_ERROR;
4834:
4835: OE_MSG_PUB.Count_And_Get
4836: (p_count => x_msg_count
4837: ,p_data => x_msg_data);
4838:
4839: IF l_debug_level > 0 THEN

Line 4850: OE_MSG_PUB.Count_And_Get

4846: oe_debug_pub.add('ship_confirm_new UNEXPECTED ERROR : '||SQLERRM, 1);
4847: END IF;
4848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4849:
4850: OE_MSG_PUB.Count_And_Get
4851: (p_count => x_msg_count
4852: ,p_data => x_msg_data);
4853:
4854: IF l_debug_level > 0 THEN

Line 4871: OE_MSG_PUB.Count_And_Get

4867: ( G_PKG_NAME
4868: ,'ship_confirm_new');
4869: END IF;
4870:
4871: OE_MSG_PUB.Count_And_Get
4872: (p_count => x_msg_count
4873: ,p_data => x_msg_data);
4874:
4875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5234: OE_MSG_PUB.Count_And_Get

5230: END IF;
5231: EXCEPTION
5232: WHEN FND_API.G_EXC_ERROR THEN
5233: x_return_status := FND_API.G_RET_STS_ERROR;
5234: OE_MSG_PUB.Count_And_Get
5235: ( p_count => x_msg_count
5236: , p_data => x_msg_data
5237: );
5238:

Line 5242: OE_MSG_PUB.Count_And_Get

5238:
5239: WHEN OTHERS THEN
5240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5241: x_result_out := 'U';
5242: OE_MSG_PUB.Count_And_Get
5243: ( p_count => x_msg_count
5244: , p_data => x_msg_data
5245: );
5246: END ship_zero;