613: BEGIN
614:
615: arp_message.set_line('ASO_MERGE_PVT.MERGE_QUOTE_HEADERS()+');
616:
617: x_return_status := FND_API.G_RET_STS_SUCCESS;
618:
619: /* Perform the merge operation */
620:
621: /* If the parent has NOT Changed(i.e Parent is getting transfered), then nothing needs to be done. Set Merge To id same
723: When RESOURCE_BUSY Then
724: arp_message.set_line('ASO_MERGE_PVT.MERGE_QUOTE_HEADERS; Could not obtain lock'||
725: 'on table ASO_QUOTE_HEADERS_ALL');
726:
727: x_return_status := FND_API.G_RET_STS_ERROR;
728: raise;
729: When Others Then
730: arp_message.set_line('ASO_MERGE_PVT.MERGE_QUOTE_HEADERS'||sqlerrm);
731: x_return_status := FND_API.G_RET_STS_ERROR;
727: x_return_status := FND_API.G_RET_STS_ERROR;
728: raise;
729: When Others Then
730: arp_message.set_line('ASO_MERGE_PVT.MERGE_QUOTE_HEADERS'||sqlerrm);
731: x_return_status := FND_API.G_RET_STS_ERROR;
732: raise;
733: END MERGE_QUOTE_HEADERS;
734:
735: /*----------------------------------------------------------------------------*
776: BEGIN
777:
778: arp_message.set_line('ASO_MERGE_PVT.MERGE_QUOTE_LINES()+');
779:
780: x_return_status := FND_API.G_RET_STS_SUCCESS;
781:
782: /* Perform the merge operation */
783:
784: /* If the parent has NOT Changed(i.e Parent is getting transfered), then nothing needs to be done. Set Merge To id same
857: When RESOURCE_BUSY Then
858: arp_message.set_line('ASO_MERGE_PVT.MERGE_QUOTE_LINES; Could not obtain lock'||
859: 'on table ASO_QUOTE_LINES_ALL');
860:
861: x_return_status := FND_API.G_RET_STS_ERROR;
862: raise;
863: When Others Then
864: arp_message.set_line('ASO_MERGE_PVT.MERGE_QUOTE_LINES'||sqlerrm);
865: x_return_status := FND_API.G_RET_STS_ERROR;
861: x_return_status := FND_API.G_RET_STS_ERROR;
862: raise;
863: When Others Then
864: arp_message.set_line('ASO_MERGE_PVT.MERGE_QUOTE_LINES'||sqlerrm);
865: x_return_status := FND_API.G_RET_STS_ERROR;
866: raise;
867:
868: END MERGE_QUOTE_LINES;
869:
911: BEGIN
912:
913: arp_message.set_line('ASO_MERGE_PVT.MERGE_SHIPMENTS()+');
914:
915: x_return_status := FND_API.G_RET_STS_SUCCESS;
916:
917: /* Perform the merge operation */
918:
919: /* If the parent has NOT Changed(i.e Parent is getting transfered), then nothing needs to be done. Set Merge To id same
987: When RESOURCE_BUSY Then
988: arp_message.set_line('ASO_MERGE_PVT.MERGE_SHIPMENTS; Could not obtain lock'||
989: 'on table ASO_SHIPMENTS');
990:
991: x_return_status := FND_API.G_RET_STS_ERROR;
992: raise;
993: When Others Then
994: arp_message.set_line('ASO_MERGE_PVT.MERGE_SHIPMENTS'||sqlerrm);
995: x_return_status := FND_API.G_RET_STS_ERROR;
991: x_return_status := FND_API.G_RET_STS_ERROR;
992: raise;
993: When Others Then
994: arp_message.set_line('ASO_MERGE_PVT.MERGE_SHIPMENTS'||sqlerrm);
995: x_return_status := FND_API.G_RET_STS_ERROR;
996: raise;
997:
998: END MERGE_SHIPMENTS;
999: