DBA Data[Home] [Help]

APPS.IBE_MERGE_PVT dependencies on FND_API

Line 947: x_return_status := FND_API.G_RET_STS_SUCCESS;

943: Begin
944:
945: arp_message.set_line('IBE_MERGE_PVT.MERGE_SHIP_LISTS()+');
946:
947: x_return_status := FND_API.G_RET_STS_SUCCESS;
948:
949:
950:
951: --Do All Validations

Line 1023: x_return_status := FND_API.G_RET_STS_ERROR;

1019: When RESOURCE_BUSY Then
1020: arp_message.set_line('IBE_MERGE_PVT.MERGE_SHIP_LISTS; Could not obtain lock'||
1021: 'on table IBE_SH_SHP_LISTS_ALL');
1022:
1023: x_return_status := FND_API.G_RET_STS_ERROR;
1024: raise;
1025: When Others Then
1026:
1027: arp_message.set_line('IBE_MERGE_PVT.MERGE_SHIP_LISTS'||sqlerrm);

Line 1029: x_return_status := FND_API.G_RET_STS_ERROR;

1025: When Others Then
1026:
1027: arp_message.set_line('IBE_MERGE_PVT.MERGE_SHIP_LISTS'||sqlerrm);
1028:
1029: x_return_status := FND_API.G_RET_STS_ERROR;
1030: raise;
1031:
1032: End MERGE_SHIP_LISTS;
1033:

Line 1094: x_return_status := FND_API.G_RET_STS_SUCCESS;

1090: Begin
1091:
1092: arp_message.set_line('IBE_MERGE_PVT.MERGE_ONECLICK()+');
1093:
1094: x_return_status := FND_API.G_RET_STS_SUCCESS;
1095:
1096: --Do All Validations
1097:
1098: --Check the Merge Reason code. If the merge reason is duplicate record, then no validation is required.

Line 1242: x_return_status := FND_API.G_RET_STS_ERROR;

1238: Exception
1239: When RESOURCE_BUSY Then
1240: arp_message.set_line('IBE_MERGE_PVT.MERGE_ONECLICK; Could not obtain lock'||
1241: 'on table IBE_ORD_ONECLICK_ALL');
1242: x_return_status := FND_API.G_RET_STS_ERROR;
1243: raise;
1244: When Others Then
1245: arp_message.set_line('IBE_MERGE_PVT.MERGE_ONECLICK'||sqlerrm);
1246: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1246: x_return_status := FND_API.G_RET_STS_ERROR;

1242: x_return_status := FND_API.G_RET_STS_ERROR;
1243: raise;
1244: When Others Then
1245: arp_message.set_line('IBE_MERGE_PVT.MERGE_ONECLICK'||sqlerrm);
1246: x_return_status := FND_API.G_RET_STS_ERROR;
1247: raise;
1248:
1249:
1250: END MERGE_ONECLICK;

Line 1317: x_return_status := FND_API.G_RET_STS_SUCCESS;

1313: Begin
1314:
1315: arp_message.set_line('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS()+');
1316:
1317: x_return_status := FND_API.G_RET_STS_SUCCESS;
1318:
1319:
1320:
1321: /* Perform the merge operation */

Line 1384: x_return_status := FND_API.G_RET_STS_ERROR;

1380:
1381: Exception
1382: When Others Then
1383: arp_message.set_line('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS'||sqlerrm);
1384: x_return_status := FND_API.G_RET_STS_ERROR;
1385: raise;
1386: end;
1387: end loop;
1388: close merge_records;

Line 1399: x_return_status := FND_API.G_RET_STS_ERROR;

1395: Exception
1396: When RESOURCE_BUSY Then
1397: arp_message.set_line('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS; Could not obtain lock'||
1398: 'on table IBE_MSITE_PRTY_ACCSS');
1399: x_return_status := FND_API.G_RET_STS_ERROR;
1400: raise;
1401: When Others Then
1402: arp_message.set_line('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS'||sqlerrm);
1403: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1403: x_return_status := FND_API.G_RET_STS_ERROR;

1399: x_return_status := FND_API.G_RET_STS_ERROR;
1400: raise;
1401: When Others Then
1402: arp_message.set_line('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS'||sqlerrm);
1403: x_return_status := FND_API.G_RET_STS_ERROR;
1404: raise;
1405:
1406:
1407: END MERGE_MSITE_PARTY_ACCESS;

Line 1474: x_return_status := FND_API.G_RET_STS_SUCCESS;

1470: Begin
1471:
1472: arp_message.set_line('IBE_MERGE_PVT.MERGE_SHARED_QUOTE()+');
1473:
1474: x_return_status := FND_API.G_RET_STS_SUCCESS;
1475:
1476: /* Perform the merge operation */
1477:
1478: /* If the parent has NOT Changed(i.e Parent is getting transfered), then nothing needs to be done. Set Merge To id same

Line 1572: x_return_status := FND_API.G_RET_STS_ERROR;

1568: Exception
1569: When RESOURCE_BUSY Then
1570: arp_message.set_line('IBE_MERGE_PVT.MERGE_SH_QUOTE_ACCESS; Could not obtain lock'||
1571: 'on table IBE_SH_QUOTE_ACCESS');
1572: x_return_status := FND_API.G_RET_STS_ERROR;
1573: raise;
1574: When Others Then
1575: arp_message.set_line('IBE_MERGE_PVT.MERGE_SH_QUOTE_ACCESS'||sqlerrm);
1576: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1576: x_return_status := FND_API.G_RET_STS_ERROR;

1572: x_return_status := FND_API.G_RET_STS_ERROR;
1573: raise;
1574: When Others Then
1575: arp_message.set_line('IBE_MERGE_PVT.MERGE_SH_QUOTE_ACCESS'||sqlerrm);
1576: x_return_status := FND_API.G_RET_STS_ERROR;
1577: raise;
1578: End MERGE_SHARED_QUOTE;
1579:
1580: /*----------------------------------------------------------------------------*

Line 1639: x_return_status := FND_API.G_RET_STS_SUCCESS;

1635: BEGIN
1636:
1637: arp_message.set_line('IBE_MERGE_PVT.MERGE_ACTIVE_QUOTE()+');
1638:
1639: x_return_status := FND_API.G_RET_STS_SUCCESS;
1640:
1641:
1642: if p_from_fk_id = p_to_fk_id then
1643: x_to_id := p_from_id;

Line 1689: x_return_status := FND_API.G_RET_STS_ERROR;

1685: Exception
1686: When RESOURCE_BUSY Then
1687: arp_message.set_line('IBE_MERGE_PVT.MERGE_ACTIVE_QUOTE; Could not obtain lock'||
1688: 'on table IBE_ACTIVE_QUOTES_ALL');
1689: x_return_status := FND_API.G_RET_STS_ERROR;
1690: raise;
1691: When Others Then
1692: arp_message.set_line('IBE_MERGE_PVT.MERGE_ACTIVE_QUOTE'||sqlerrm);
1693: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1693: x_return_status := FND_API.G_RET_STS_ERROR;

1689: x_return_status := FND_API.G_RET_STS_ERROR;
1690: raise;
1691: When Others Then
1692: arp_message.set_line('IBE_MERGE_PVT.MERGE_ACTIVE_QUOTE'||sqlerrm);
1693: x_return_status := FND_API.G_RET_STS_ERROR;
1694: raise;
1695: END MERGE_ACTIVE_QUOTE;
1696:
1697: End IBE_MERGE_PVT;