DBA Data[Home] [Help]

APPS.IBE_MERGE_PVT dependencies on FND_API

Line 900: x_return_status := FND_API.G_RET_STS_SUCCESS;

896:
897: arp_message.set_line('IBE_MERGE_PVT.MERGE_SHIP_LISTS()+');
898: IBE_UTIL.debug('IBE_MERGE_PVT.MERGE_SHIP_LISTS()+');
899:
900: x_return_status := FND_API.G_RET_STS_SUCCESS;
901:
902:
903:
904: --Do All Validations

Line 977: x_return_status := FND_API.G_RET_STS_ERROR;

973: arp_message.set_line('IBE_MERGE_PVT.MERGE_SHIP_LISTS; Could not obtain lock'||
974: 'on table IBE_SH_SHP_LISTS_ALL');
975: IBE_UTIL.debug('IBE_MERGE_PVT.MERGE_SHIP_LISTS; Could not obtain lock'||
976: 'on table IBE_SH_SHP_LISTS_ALL');
977: x_return_status := FND_API.G_RET_STS_ERROR;
978: raise;
979: When Others Then
980:
981: arp_message.set_line('IBE_MERGE_PVT.MERGE_SHIP_LISTS'||sqlerrm);

Line 983: x_return_status := FND_API.G_RET_STS_ERROR;

979: When Others Then
980:
981: arp_message.set_line('IBE_MERGE_PVT.MERGE_SHIP_LISTS'||sqlerrm);
982: IBE_UTIL.debug('IBE_MERGE_PVT.MERGE_SHIP_LISTS'||sqlerrm);
983: x_return_status := FND_API.G_RET_STS_ERROR;
984: raise;
985:
986: End MERGE_SHIP_LISTS;
987:

Line 1049: x_return_status := FND_API.G_RET_STS_SUCCESS;

1045:
1046: arp_message.set_line('IBE_MERGE_PVT.MERGE_ONECLICK()+');
1047: IBE_UTIL.debug('IBE_MERGE_PVT.MERGE_ONECLICK()+');
1048:
1049: x_return_status := FND_API.G_RET_STS_SUCCESS;
1050:
1051: --Do All Validations
1052:
1053: --Check the Merge Reason code. If the merge reason is duplicate record, then no validation is required.

Line 1199: x_return_status := FND_API.G_RET_STS_ERROR;

1195: arp_message.set_line('IBE_MERGE_PVT.MERGE_ONECLICK; Could not obtain lock'||
1196: 'on table IBE_ORD_ONECLICK_ALL');
1197: IBE_UTIL.debug('IBE_MERGE_PVT.MERGE_ONECLICK; Could not obtain lock'||
1198: 'on table IBE_ORD_ONECLICK_ALL');
1199: x_return_status := FND_API.G_RET_STS_ERROR;
1200: raise;
1201: When Others Then
1202: arp_message.set_line('IBE_MERGE_PVT.MERGE_ONECLICK'||sqlerrm);
1203: IBE_UTIL.debug('IBE_MERGE_PVT.MERGE_ONECLICK'||sqlerrm);

Line 1204: x_return_status := FND_API.G_RET_STS_ERROR;

1200: raise;
1201: When Others Then
1202: arp_message.set_line('IBE_MERGE_PVT.MERGE_ONECLICK'||sqlerrm);
1203: IBE_UTIL.debug('IBE_MERGE_PVT.MERGE_ONECLICK'||sqlerrm);
1204: x_return_status := FND_API.G_RET_STS_ERROR;
1205: raise;
1206:
1207:
1208: END MERGE_ONECLICK;

Line 1276: x_return_status := FND_API.G_RET_STS_SUCCESS;

1272:
1273: arp_message.set_line('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS()+');
1274: IBE_UTIL.debug('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS()+');
1275:
1276: x_return_status := FND_API.G_RET_STS_SUCCESS;
1277:
1278:
1279:
1280: /* Perform the merge operation */

Line 1346: x_return_status := FND_API.G_RET_STS_ERROR;

1342: Exception
1343: When Others Then
1344: arp_message.set_line('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS'||sqlerrm);
1345: IBE_UTIL.debug('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS'||sqlerrm);
1346: x_return_status := FND_API.G_RET_STS_ERROR;
1347: raise;
1348: end;
1349: end loop;
1350: close merge_records;

Line 1363: x_return_status := FND_API.G_RET_STS_ERROR;

1359: arp_message.set_line('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS; Could not obtain lock'||
1360: 'on table IBE_MSITE_PRTY_ACCSS');
1361: IBE_UTIL.debug('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS; Could not obtain lock'||
1362: 'on table IBE_MSITE_PRTY_ACCSS');
1363: x_return_status := FND_API.G_RET_STS_ERROR;
1364: raise;
1365: When Others Then
1366: arp_message.set_line('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS'||sqlerrm);
1367: IBE_UTIL.debug('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS'||sqlerrm);

Line 1368: x_return_status := FND_API.G_RET_STS_ERROR;

1364: raise;
1365: When Others Then
1366: arp_message.set_line('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS'||sqlerrm);
1367: IBE_UTIL.debug('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS'||sqlerrm);
1368: x_return_status := FND_API.G_RET_STS_ERROR;
1369: raise;
1370:
1371:
1372: END MERGE_MSITE_PARTY_ACCESS;

Line 1440: x_return_status := FND_API.G_RET_STS_SUCCESS;

1436:
1437: arp_message.set_line('IBE_MERGE_PVT.MERGE_SHARED_QUOTE()+');
1438: IBE_UTIL.debug('IBE_MERGE_PVT.MERGE_SHARED_QUOTE()+');
1439:
1440: x_return_status := FND_API.G_RET_STS_SUCCESS;
1441:
1442: /* Perform the merge operation */
1443:
1444: /* If the parent has NOT Changed(i.e Parent is getting transfered), then nothing needs to be done. Set Merge To id same

Line 1540: x_return_status := FND_API.G_RET_STS_ERROR;

1536: arp_message.set_line('IBE_MERGE_PVT.MERGE_SH_QUOTE_ACCESS; Could not obtain lock'||
1537: 'on table IBE_SH_QUOTE_ACCESS');
1538: IBE_UTIL.debug('IBE_MERGE_PVT.MERGE_SH_QUOTE_ACCESS; Could not obtain lock'||
1539: 'on table IBE_SH_QUOTE_ACCESS');
1540: x_return_status := FND_API.G_RET_STS_ERROR;
1541: raise;
1542: When Others Then
1543: arp_message.set_line('IBE_MERGE_PVT.MERGE_SH_QUOTE_ACCESS'||sqlerrm);
1544: IBE_UTIL.debug('IBE_MERGE_PVT.MERGE_SH_QUOTE_ACCESS'||sqlerrm);

Line 1545: x_return_status := FND_API.G_RET_STS_ERROR;

1541: raise;
1542: When Others Then
1543: arp_message.set_line('IBE_MERGE_PVT.MERGE_SH_QUOTE_ACCESS'||sqlerrm);
1544: IBE_UTIL.debug('IBE_MERGE_PVT.MERGE_SH_QUOTE_ACCESS'||sqlerrm);
1545: x_return_status := FND_API.G_RET_STS_ERROR;
1546: raise;
1547: End MERGE_SHARED_QUOTE;
1548:
1549: /*----------------------------------------------------------------------------*

Line 1609: x_return_status := FND_API.G_RET_STS_SUCCESS;

1605:
1606: arp_message.set_line('IBE_MERGE_PVT.MERGE_ACTIVE_QUOTE()+');
1607: IBE_UTIL.debug('IBE_MERGE_PVT.MERGE_ACTIVE_QUOTE()+');
1608:
1609: x_return_status := FND_API.G_RET_STS_SUCCESS;
1610:
1611:
1612: if p_from_fk_id = p_to_fk_id then
1613: x_to_id := p_from_id;

Line 1661: x_return_status := FND_API.G_RET_STS_ERROR;

1657: arp_message.set_line('IBE_MERGE_PVT.MERGE_ACTIVE_QUOTE; Could not obtain lock'||
1658: 'on table IBE_ACTIVE_QUOTES_ALL');
1659: IBE_UTIL.debug('IBE_MERGE_PVT.MERGE_ACTIVE_QUOTE; Could not obtain lock'||
1660: 'on table IBE_ACTIVE_QUOTES_ALL');
1661: x_return_status := FND_API.G_RET_STS_ERROR;
1662: raise;
1663: When Others Then
1664: arp_message.set_line('IBE_MERGE_PVT.MERGE_ACTIVE_QUOTE'||sqlerrm);
1665: IBE_UTIL.debug('IBE_MERGE_PVT.MERGE_ACTIVE_QUOTE'||sqlerrm);

Line 1666: x_return_status := FND_API.G_RET_STS_ERROR;

1662: raise;
1663: When Others Then
1664: arp_message.set_line('IBE_MERGE_PVT.MERGE_ACTIVE_QUOTE'||sqlerrm);
1665: IBE_UTIL.debug('IBE_MERGE_PVT.MERGE_ACTIVE_QUOTE'||sqlerrm);
1666: x_return_status := FND_API.G_RET_STS_ERROR;
1667: raise;
1668: END MERGE_ACTIVE_QUOTE;
1669:
1670: End IBE_MERGE_PVT;