DBA Data[Home] [Help]

APPS.ASO_MERGE_PVT dependencies on ASO_MERGE_PVT

Line 1: Package Body ASO_MERGE_PVT As

1: Package Body ASO_MERGE_PVT As
2: /* $Header: asovmrgb.pls 120.1 2010/12/03 08:18:11 vidsrini ship $ */
3:
4: /*----------------------------------------------------------------------------*
5: | |

Line 212: ASO_MERGE_PVT.UPDATE_QUOTE_LINES(

208: arp_message.set_token('NUM_ROWS',to_char(l_count));
209:
210: END IF;
211:
212: ASO_MERGE_PVT.UPDATE_QUOTE_LINES(
213: req_id => req_id,
214: set_num => set_num,
215: process_mode => process_mode
216: );

Line 218: ASO_MERGE_PVT.UPDATE_SHIPMENTS(

214: set_num => set_num,
215: process_mode => process_mode
216: );
217:
218: ASO_MERGE_PVT.UPDATE_SHIPMENTS(
219: req_id => req_id,
220: set_num => set_num,
221: process_mode => process_mode
222: );

Line 616: arp_message.set_line('ASO_MERGE_PVT.MERGE_QUOTE_HEADERS()+');

612: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
613:
614: BEGIN
615:
616: arp_message.set_line('ASO_MERGE_PVT.MERGE_QUOTE_HEADERS()+');
617:
618: x_return_status := FND_API.G_RET_STS_SUCCESS;
619:
620: /* Perform the merge operation */

Line 721: arp_message.set_line('ASO_MERGE_PVT.MERGE_QUOTE_HEADERS()-');

717: END IF;
718:
719: End If;
720:
721: arp_message.set_line('ASO_MERGE_PVT.MERGE_QUOTE_HEADERS()-');
722:
723: Exception
724: When RESOURCE_BUSY Then
725: arp_message.set_line('ASO_MERGE_PVT.MERGE_QUOTE_HEADERS; Could not obtain lock'||

Line 725: arp_message.set_line('ASO_MERGE_PVT.MERGE_QUOTE_HEADERS; Could not obtain lock'||

721: arp_message.set_line('ASO_MERGE_PVT.MERGE_QUOTE_HEADERS()-');
722:
723: Exception
724: When RESOURCE_BUSY Then
725: arp_message.set_line('ASO_MERGE_PVT.MERGE_QUOTE_HEADERS; Could not obtain lock'||
726: 'on table ASO_QUOTE_HEADERS_ALL');
727:
728: x_return_status := FND_API.G_RET_STS_ERROR;
729: raise;

Line 731: arp_message.set_line('ASO_MERGE_PVT.MERGE_QUOTE_HEADERS'||sqlerrm);

727:
728: x_return_status := FND_API.G_RET_STS_ERROR;
729: raise;
730: When Others Then
731: arp_message.set_line('ASO_MERGE_PVT.MERGE_QUOTE_HEADERS'||sqlerrm);
732: x_return_status := FND_API.G_RET_STS_ERROR;
733: raise;
734: END MERGE_QUOTE_HEADERS;
735:

Line 779: arp_message.set_line('ASO_MERGE_PVT.MERGE_QUOTE_LINES()+');

775: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
776:
777: BEGIN
778:
779: arp_message.set_line('ASO_MERGE_PVT.MERGE_QUOTE_LINES()+');
780:
781: x_return_status := FND_API.G_RET_STS_SUCCESS;
782:
783: /* Perform the merge operation */

Line 855: arp_message.set_line('ASO_MERGE_PVT.MERGE_QUOTE_LINES()-');

851: End If;
852:
853: End If;
854:
855: arp_message.set_line('ASO_MERGE_PVT.MERGE_QUOTE_LINES()-');
856:
857: Exception
858: When RESOURCE_BUSY Then
859: arp_message.set_line('ASO_MERGE_PVT.MERGE_QUOTE_LINES; Could not obtain lock'||

Line 859: arp_message.set_line('ASO_MERGE_PVT.MERGE_QUOTE_LINES; Could not obtain lock'||

855: arp_message.set_line('ASO_MERGE_PVT.MERGE_QUOTE_LINES()-');
856:
857: Exception
858: When RESOURCE_BUSY Then
859: arp_message.set_line('ASO_MERGE_PVT.MERGE_QUOTE_LINES; Could not obtain lock'||
860: 'on table ASO_QUOTE_LINES_ALL');
861:
862: x_return_status := FND_API.G_RET_STS_ERROR;
863: raise;

Line 865: arp_message.set_line('ASO_MERGE_PVT.MERGE_QUOTE_LINES'||sqlerrm);

861:
862: x_return_status := FND_API.G_RET_STS_ERROR;
863: raise;
864: When Others Then
865: arp_message.set_line('ASO_MERGE_PVT.MERGE_QUOTE_LINES'||sqlerrm);
866: x_return_status := FND_API.G_RET_STS_ERROR;
867: raise;
868:
869: END MERGE_QUOTE_LINES;

Line 914: arp_message.set_line('ASO_MERGE_PVT.MERGE_SHIPMENTS()+');

910: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
911:
912: BEGIN
913:
914: arp_message.set_line('ASO_MERGE_PVT.MERGE_SHIPMENTS()+');
915:
916: x_return_status := FND_API.G_RET_STS_SUCCESS;
917:
918: /* Perform the merge operation */

Line 985: arp_message.set_line('ASO_MERGE_PVT.MERGE_SHIPMENTS()-');

981: End If;
982:
983: End If;
984:
985: arp_message.set_line('ASO_MERGE_PVT.MERGE_SHIPMENTS()-');
986:
987: Exception
988: When RESOURCE_BUSY Then
989: arp_message.set_line('ASO_MERGE_PVT.MERGE_SHIPMENTS; Could not obtain lock'||

Line 989: arp_message.set_line('ASO_MERGE_PVT.MERGE_SHIPMENTS; Could not obtain lock'||

985: arp_message.set_line('ASO_MERGE_PVT.MERGE_SHIPMENTS()-');
986:
987: Exception
988: When RESOURCE_BUSY Then
989: arp_message.set_line('ASO_MERGE_PVT.MERGE_SHIPMENTS; Could not obtain lock'||
990: 'on table ASO_SHIPMENTS');
991:
992: x_return_status := FND_API.G_RET_STS_ERROR;
993: raise;

Line 995: arp_message.set_line('ASO_MERGE_PVT.MERGE_SHIPMENTS'||sqlerrm);

991:
992: x_return_status := FND_API.G_RET_STS_ERROR;
993: raise;
994: When Others Then
995: arp_message.set_line('ASO_MERGE_PVT.MERGE_SHIPMENTS'||sqlerrm);
996: x_return_status := FND_API.G_RET_STS_ERROR;
997: raise;
998:
999: END MERGE_SHIPMENTS;

Line 1001: END ASO_MERGE_PVT;

997: raise;
998:
999: END MERGE_SHIPMENTS;
1000:
1001: END ASO_MERGE_PVT;