DBA Data[Home] [Help]

APPS.IBE_MERGE_PVT dependencies on IBE_MERGE_PVT

Line 1: Package Body IBE_MERGE_PVT As

1: Package Body IBE_MERGE_PVT As
2: /* $Header: IBEVMRGB.pls 120.0 2005/05/30 02:40:49 appldev noship $ */
3:
4: G_FETCH_LIMIT CONSTANT NUMBER := 1000;
5: /*----------------------------------------------------------------------------*

Line 791: arp_message.set_line('IBE_MERGE_PVT.CUSTOMER_MERGE()+');

787: AND RACM.SET_NUMBER = set_number;
788:
789: BEGIN
790:
791: arp_message.set_line('IBE_MERGE_PVT.CUSTOMER_MERGE()+');
792:
793: p_request_id := request_id;
794:
795: /* Check to See if you can allow the customer merge to happen */

Line 878: arp_message.set_line('IBE_MERGE_PVT.CUSTOMER_MERGE()-');

874: arp_message.set_name('AR','AR_ROWS_UPDATED');
875: arp_message.set_token('NUM_ROWS',to_char(g_count));
876:
877:
878: arp_message.set_line('IBE_MERGE_PVT.CUSTOMER_MERGE()-');
879:
880: EXCEPTION
881:
882: WHEN MERGE_NOT_ALLOWED THEN

Line 884: arp_message.set_error('IBE_MERGE_PVT.CUSTOMER_MERGE');

880: EXCEPTION
881:
882: WHEN MERGE_NOT_ALLOWED THEN
883: arp_message.set_name('IBE','IBE_MERGE_NOT_ALLOWED');
884: arp_message.set_error('IBE_MERGE_PVT.CUSTOMER_MERGE');
885: raise;
886:
887: WHEN OTHERS THEN
888: arp_message.set_error('IBE_MERGE_PVT.CUSTOMER_MERGE');

Line 888: arp_message.set_error('IBE_MERGE_PVT.CUSTOMER_MERGE');

884: arp_message.set_error('IBE_MERGE_PVT.CUSTOMER_MERGE');
885: raise;
886:
887: WHEN OTHERS THEN
888: arp_message.set_error('IBE_MERGE_PVT.CUSTOMER_MERGE');
889: raise;
890:
891: End Customer_Merge;
892:

Line 945: arp_message.set_line('IBE_MERGE_PVT.MERGE_SHIP_LISTS()+');

941:
942:
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:

Line 1015: arp_message.set_line('IBE_MERGE_PVT.MERGE_SHIP_LISTS()-');

1011: return;
1012:
1013: End If;
1014:
1015: arp_message.set_line('IBE_MERGE_PVT.MERGE_SHIP_LISTS()-');
1016:
1017:
1018: Exception
1019: When RESOURCE_BUSY Then

Line 1020: arp_message.set_line('IBE_MERGE_PVT.MERGE_SHIP_LISTS; Could not obtain lock'||

1016:
1017:
1018: Exception
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;

Line 1027: arp_message.set_line('IBE_MERGE_PVT.MERGE_SHIP_LISTS'||sqlerrm);

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);
1028:
1029: x_return_status := FND_API.G_RET_STS_ERROR;
1030: raise;
1031:

Line 1092: arp_message.set_line('IBE_MERGE_PVT.MERGE_ONECLICK()+');

1088: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
1089:
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

Line 1236: arp_message.set_line('IBE_MERGE_PVT.MERGE_ONECLICK()-');

1232: End If;
1233:
1234: End If;
1235:
1236: arp_message.set_line('IBE_MERGE_PVT.MERGE_ONECLICK()-');
1237:
1238: Exception
1239: When RESOURCE_BUSY Then
1240: arp_message.set_line('IBE_MERGE_PVT.MERGE_ONECLICK; Could not obtain lock'||

Line 1240: arp_message.set_line('IBE_MERGE_PVT.MERGE_ONECLICK; Could not obtain lock'||

1236: arp_message.set_line('IBE_MERGE_PVT.MERGE_ONECLICK()-');
1237:
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

Line 1245: arp_message.set_line('IBE_MERGE_PVT.MERGE_ONECLICK'||sqlerrm);

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;
1247: raise;
1248:
1249:

Line 1315: arp_message.set_line('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS()+');

1311: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
1312:
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:

Line 1352: arp_message.set_line('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS; '||

1348: EXIT When merge_records%NOTFOUND;
1349: Begin
1350: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
1351: arp_message.set_token('TABLE_NAME', 'IBE_MSITE_PRTY_ACCSS', FALSE);
1352: arp_message.set_line('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS; '||
1353: ' merging msite:'||l_msite_id||' both & are BOTH on');
1354:
1355: -- only merge when both & are BOTH on
1356: -- and doesn't have restrictions on the minisite

Line 1383: arp_message.set_line('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS'||sqlerrm);

1379: end if;
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;

Line 1393: arp_message.set_line('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS()-');

1389:
1390: End If;
1391: End If;
1392:
1393: arp_message.set_line('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS()-');
1394:
1395: Exception
1396: When RESOURCE_BUSY Then
1397: arp_message.set_line('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS; Could not obtain lock'||

Line 1397: arp_message.set_line('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS; Could not obtain lock'||

1393: arp_message.set_line('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS()-');
1394:
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

Line 1402: arp_message.set_line('IBE_MERGE_PVT.MERGE_MSITE_PARTY_ACCESS'||sqlerrm);

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;
1404: raise;
1405:
1406:

Line 1472: arp_message.set_line('IBE_MERGE_PVT.MERGE_SHARED_QUOTE()+');

1468: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
1469:
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 */

Line 1565: arp_message.set_line('IBE_MERGE_PVT.MERGE_SHIP_LISTS()-');

1561:
1562:
1563: End If; --end if p_from_fk_id <> p_to_fk_id Then
1564:
1565: arp_message.set_line('IBE_MERGE_PVT.MERGE_SHIP_LISTS()-');
1566:
1567:
1568: Exception
1569: When RESOURCE_BUSY Then

Line 1570: arp_message.set_line('IBE_MERGE_PVT.MERGE_SH_QUOTE_ACCESS; Could not obtain lock'||

1566:
1567:
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

Line 1575: arp_message.set_line('IBE_MERGE_PVT.MERGE_SH_QUOTE_ACCESS'||sqlerrm);

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;
1577: raise;
1578: End MERGE_SHARED_QUOTE;
1579:

Line 1637: arp_message.set_line('IBE_MERGE_PVT.MERGE_ACTIVE_QUOTE()+');

1633:
1634:
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:

Line 1682: arp_message.set_line('IBE_MERGE_PVT.MERGE_ACTIVE_QUOTE()-');

1678: return;
1679:
1680: END IF;
1681:
1682: arp_message.set_line('IBE_MERGE_PVT.MERGE_ACTIVE_QUOTE()-');
1683:
1684:
1685: Exception
1686: When RESOURCE_BUSY Then

Line 1687: arp_message.set_line('IBE_MERGE_PVT.MERGE_ACTIVE_QUOTE; Could not obtain lock'||

1683:
1684:
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

Line 1692: arp_message.set_line('IBE_MERGE_PVT.MERGE_ACTIVE_QUOTE'||sqlerrm);

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;
1694: raise;
1695: END MERGE_ACTIVE_QUOTE;
1696:

Line 1697: End IBE_MERGE_PVT;

1693: x_return_status := FND_API.G_RET_STS_ERROR;
1694: raise;
1695: END MERGE_ACTIVE_QUOTE;
1696:
1697: End IBE_MERGE_PVT;
1698: