eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_SR_PARTY_MERGE_PKG dependencies on FND_API

Line 74: x_return_status := FND_API.G_RET_STS_SUCCESS;

70:
71: BEGIN
72: arp_message.set_line('CS_SR_PARTY_MERGE_PKG.CS_INC_ALL_MERGE_PARTY()+');
73:
74: x_return_status := FND_API.G_RET_STS_SUCCESS;
75:
76:
77: SELECT merge_reason_code
78: INTO l_merge_reason_code

Line 176: IF l_return_status <> FND_API.G_RET_STS_ERROR Then

172: x_msg_data => x_msg_data,
173: x_audit_vals_rec => l_audit_vals_rec );
174:
175:
176: IF l_return_status <> FND_API.G_RET_STS_ERROR Then
177:
178: IF l_audit_vals_rec.customer_id <> l_customer_id(i) THEN
179: l_audit_vals_rec.old_customer_id := l_customer_id(i);
180: END IF;

Line 235: x_return_status := FND_API.G_RET_STS_ERROR;

231: '; Could not obtain lock for records in table ' ||
232: 'CS_INCIDENTS_ALL_B for customer_id / bill_to_contact_id ' ||
233: '/ ship_to_contact_id / bill_to_party_id / ship_to_part_id = '
234: || p_from_fk_id );
235: x_return_status := FND_API.G_RET_STS_ERROR;
236: raise;
237:
238: WHEN others THEN
239: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);

Line 240: x_return_status := FND_API.G_RET_STS_ERROR;

236: raise;
237:
238: WHEN others THEN
239: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
240: x_return_status := FND_API.G_RET_STS_ERROR;
241: RAISE;
242: END;
243:
244: END IF; -- if p_from_fk_id <> p_to_fk_id

Line 262: x_return_status := FND_API.G_RET_STS_SUCCESS;

258: p_batch_party_id IN NUMBER,
259: x_return_status OUT NOCOPY VARCHAR2)
260: IS
261: BEGIN
262: x_return_status := FND_API.G_RET_STS_SUCCESS;
263: END CS_INC_ALL_MERGE_BILL_TO_CONT;
264:
265: -- The following procedure will not perform any operations; the update of the
266: -- ship_to_contact_id is done in procedure CS_INC_ALL_MERGE_PARTY

Line 279: x_return_status := FND_API.G_RET_STS_SUCCESS;

275: p_batch_party_id IN NUMBER,
276: x_return_status OUT NOCOPY VARCHAR2)
277: IS
278: BEGIN
279: x_return_status := FND_API.G_RET_STS_SUCCESS;
280: END CS_INC_ALL_MERGE_SHIP_TO_CONT;
281:
282:
283: -- The following procedure merges CS_INCIDENTS_ALL_B columns:

Line 330: x_return_status := FND_API.G_RET_STS_SUCCESS;

326: BEGIN
327:
328: arp_message.set_line('CS_SR_PARTY_MERGE_PKG.CS_INC_ALL_MERGE_SITE_USES()+');
329:
330: x_return_status := FND_API.G_RET_STS_SUCCESS;
331:
332: SELECT merge_reason_code
333: INTO l_merge_reason_code
334: FROM hz_merge_batch

Line 426: IF l_return_status <> FND_API.G_RET_STS_ERROR Then

422: x_msg_data => x_msg_data,
423: x_audit_vals_rec => l_audit_vals_rec );
424:
425:
426: IF l_return_status <> FND_API.G_RET_STS_ERROR Then
427:
428: IF l_bill_to_site_use_id(i) = p_from_fk_id THEN
429: l_audit_vals_rec.bill_to_site_use_id := p_to_fk_id ;
430: l_audit_vals_rec.old_bill_to_site_use_id := l_bill_to_site_use_id(i);

Line 484: x_return_status := FND_API.G_RET_STS_ERROR;

480: arp_message.set_line(g_proc_name || '.' || l_api_name ||
481: '; Could not obtain lock for records in table ' ||
482: 'CS_INCIDENTS_ALL_B for bill_to_site_use_id / ship_to_site_use_id / '
483: || p_from_fk_id );
484: x_return_status := FND_API.G_RET_STS_ERROR;
485: RAISE;
486:
487: WHEN others THEN
488: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);

Line 489: x_return_status := FND_API.G_RET_STS_ERROR;

485: RAISE;
486:
487: WHEN others THEN
488: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
489: x_return_status := FND_API.G_RET_STS_ERROR;
490: RAISE;
491: END;
492: END IF;
493:

Line 510: x_return_status := FND_API.G_RET_STS_SUCCESS;

506: p_batch_party_id IN NUMBER,
507: x_return_status OUT NOCOPY VARCHAR2)
508: IS
509: BEGIN
510: x_return_status := FND_API.G_RET_STS_SUCCESS;
511: END CS_INC_ALL_MERGE_INST_SITE_USE;
512:
513: -- The following procedure will not perform any operations; the update of the
514: -- ship_to_site_use_id is done in procedure CS_INC_ALL_MERGE_SITE_USES

Line 527: x_return_status := FND_API.G_RET_STS_SUCCESS;

523: p_batch_party_id IN NUMBER,
524: x_return_status OUT NOCOPY VARCHAR2)
525: IS
526: BEGIN
527: x_return_status := FND_API.G_RET_STS_SUCCESS;
528: END CS_INC_ALL_MERGE_SHIP_SITE_USE;
529:
530:
531: -- The following procedure merges CS_INCIDENTS_ALL_B columns:

Line 603: x_return_status := FND_API.G_RET_STS_SUCCESS;

599:
600: BEGIN
601: arp_message.set_line('CS_SR_PARTY_MERGE_PKG.CS_INC_ALL_MERGE_SITE_ID()+');
602:
603: x_return_status := FND_API.G_RET_STS_SUCCESS;
604:
605: SELECT merge_reason_code
606: INTO l_merge_reason_code
607: FROM hz_merge_batch

Line 726: IF x_return_status <> FND_API.G_RET_STS_ERROR THEN

722: x_msg_count => x_msg_count,
723: x_msg_data => x_msg_data,
724: x_audit_vals_rec => l_audit_vals_rec );
725:
726: IF x_return_status <> FND_API.G_RET_STS_ERROR THEN
727:
728: -- set the site_id/old_site_id of audit record
729:
730: IF l_site_id(i) = p_from_fk_id THEN

Line 840: x_return_status := FND_API.G_RET_STS_ERROR;

836: '; Could not obtain lock for records in table ' ||
837: 'CS_INCIDENTS_ALL_B for site_id / customer_site_id / ' ||
838: 'install_site_use_id / bill_to_site_id / ship_to_site_id / '||
839: 'install_site_id = ' || p_from_fk_id );
840: x_return_status := FND_API.G_RET_STS_ERROR;
841: RAISE;
842:
843: WHEN others THEN
844: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);

Line 845: x_return_status := FND_API.G_RET_STS_ERROR;

841: RAISE;
842:
843: WHEN others THEN
844: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
845: x_return_status := FND_API.G_RET_STS_ERROR;
846: RAISE;
847: END;
848: END IF;
849: END CS_INC_ALL_MERGE_SITE_ID;

Line 866: x_return_status := FND_API.G_RET_STS_SUCCESS;

862: x_return_status OUT NOCOPY VARCHAR2)
863: IS
864:
865: BEGIN
866: x_return_status := FND_API.G_RET_STS_SUCCESS;
867: END CS_INC_ALL_MERGE_CT_SITE_ID;
868:
869: -- The following procedure merges CS_INCIDENT_AUDIT_B columns:
870: -- bill_to_contact_id

Line 905: x_return_status := FND_API.G_RET_STS_SUCCESS;

901:
902: BEGIN
903: arp_message.set_line('CS_SR_PARTY_MERGE_PKG.CS_AUDIT_MERGE_PARTY()+');
904:
905: x_return_status := FND_API.G_RET_STS_SUCCESS;
906:
907: select merge_reason_code
908: into l_merge_reason_code
909: from hz_merge_batch

Line 978: x_return_status := FND_API.G_RET_STS_ERROR;

974: arp_message.set_line(g_proc_name || '.' || l_api_name ||
975: '; Could not obtain lock for records in table ' ||
976: 'CS_INCIDENTS_AUDIT_B for bill_to_contact_id = ' || p_from_fk_id );
977:
978: x_return_status := FND_API.G_RET_STS_ERROR;
979: raise;
980:
981: when others then
982: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);

Line 983: x_return_status := FND_API.G_RET_STS_ERROR;

979: raise;
980:
981: when others then
982: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
983: x_return_status := FND_API.G_RET_STS_ERROR;
984: raise;
985: end;
986: end if;
987: END CS_AUDIT_MERGE_PARTY;

Line 1004: x_return_status := FND_API.G_RET_STS_SUCCESS;

1000: p_batch_party_id IN NUMBER,
1001: x_return_status OUT NOCOPY VARCHAR2)
1002: IS
1003: BEGIN
1004: x_return_status := FND_API.G_RET_STS_SUCCESS;
1005: END CS_AUDIT_MERGE_OLD_BILL_CONT;
1006:
1007: -- The following procedure will not perform any operations; the update of the
1008: -- ship_to_contact_id is done in procedure CS_AUDIT_MERGE_PARTY

Line 1021: x_return_status := FND_API.G_RET_STS_SUCCESS;

1017: p_batch_party_id IN NUMBER,
1018: x_return_status OUT NOCOPY VARCHAR2)
1019: IS
1020: BEGIN
1021: x_return_status := FND_API.G_RET_STS_SUCCESS;
1022: END CS_AUDIT_MERGE_SHIP_TO_CONT;
1023:
1024: -- The following procedure will not perform any operations; the update of the
1025: -- old_ship_to_contact_id is done in procedure CS_AUDIT_MERGE_PARTY

Line 1038: x_return_status := FND_API.G_RET_STS_SUCCESS;

1034: p_batch_party_id IN NUMBER,
1035: x_return_status OUT NOCOPY VARCHAR2)
1036: IS
1037: BEGIN
1038: x_return_status := FND_API.G_RET_STS_SUCCESS;
1039: END CS_AUDIT_MERGE_OLD_SHIP_CONT;
1040:
1041:
1042: PROCEDURE CS_AUDIT_MERGE_SITE_ID(

Line 1072: x_return_status := FND_API.G_RET_STS_SUCCESS;

1068:
1069: BEGIN
1070: arp_message.set_line('CS_SR_PARTY_MERGE_PKG.CS_AUDIT_MERGE_SITE_ID()+');
1071:
1072: x_return_status := FND_API.G_RET_STS_SUCCESS;
1073:
1074: select merge_reason_code
1075: into l_merge_reason_code
1076: from hz_merge_batch

Line 1141: x_return_status := FND_API.G_RET_STS_ERROR;

1137: arp_message.set_line(g_proc_name || '.' || l_api_name ||
1138: '; Could not obtain lock for records in table ' ||
1139: 'CS_INCIDENTS_AUDIT_B for site_id = ' || p_from_fk_id );
1140:
1141: x_return_status := FND_API.G_RET_STS_ERROR;
1142: raise;
1143:
1144: when others then
1145: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);

Line 1146: x_return_status := FND_API.G_RET_STS_ERROR;

1142: raise;
1143:
1144: when others then
1145: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
1146: x_return_status := FND_API.G_RET_STS_ERROR;
1147: raise;
1148: end;
1149: end if;
1150: END CS_AUDIT_MERGE_SITE_ID;

Line 1166: x_return_status := FND_API.G_RET_STS_SUCCESS;

1162: p_batch_party_id IN NUMBER,
1163: x_return_status OUT NOCOPY VARCHAR2)
1164: IS
1165: BEGIN
1166: x_return_status := FND_API.G_RET_STS_SUCCESS;
1167: END CS_AUDIT_MERGE_OLD_SITE_ID;
1168:
1169:
1170: PROCEDURE CS_CONTACTS_MERGE_PARTY(

Line 1209: x_return_status := FND_API.G_RET_STS_SUCCESS;

1205:
1206: BEGIN
1207: arp_message.set_line('CS_PARTY_MERGE_PKG.CS_CONTACTS_MERGE_PARTY()+');
1208:
1209: x_return_status := FND_API.G_RET_STS_SUCCESS;
1210:
1211: ---dbms_output.put_line('am going to get reason code');
1212:
1213: select merge_reason_code

Line 1313: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1309: x_return_status => l_return_status,
1310: x_msg_count => x_msg_count,
1311: x_msg_data => x_msg_data ) ;
1312:
1313: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1314: RAISE FND_API.G_EXC_ERROR;
1315: END IF ;
1316:
1317: -- Change the old value of the party id in the old CP audit record.

Line 1314: RAISE FND_API.G_EXC_ERROR;

1310: x_msg_count => x_msg_count,
1311: x_msg_data => x_msg_data ) ;
1312:
1313: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1314: RAISE FND_API.G_EXC_ERROR;
1315: END IF ;
1316:
1317: -- Change the old value of the party id in the old CP audit record.
1318:

Line 1335: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1331: x_return_status => l_return_status,
1332: x_msg_count => x_msg_count,
1333: x_msg_data => x_msg_data ) ;
1334:
1335: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1336: RAISE FND_API.G_EXC_ERROR;
1337: END IF ;
1338:
1339: -- Create SR Child Audit Record

Line 1336: RAISE FND_API.G_EXC_ERROR;

1332: x_msg_count => x_msg_count,
1333: x_msg_data => x_msg_data ) ;
1334:
1335: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1336: RAISE FND_API.G_EXC_ERROR;
1337: END IF ;
1338:
1339: -- Create SR Child Audit Record
1340:

Line 1353: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1349: x_return_status => l_return_status ,
1350: x_msg_count => x_msg_count ,
1351: x_msg_data => x_msg_data ) ;
1352:
1353: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1354: RAISE FND_API.G_EXC_ERROR;
1355: END IF ;
1356:
1357: END LOOP ;

Line 1354: RAISE FND_API.G_EXC_ERROR;

1350: x_msg_count => x_msg_count ,
1351: x_msg_data => x_msg_data ) ;
1352:
1353: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1354: RAISE FND_API.G_EXC_ERROR;
1355: END IF ;
1356:
1357: END LOOP ;
1358:

Line 1404: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1400: x_return_status => l_return_status,
1401: x_msg_count => x_msg_count,
1402: x_msg_data => x_msg_data ) ;
1403:
1404: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1405: RAISE FND_API.G_EXC_ERROR;
1406: END IF ;
1407:
1408: -- Change the old value of the party id in the old CP audit record.

Line 1405: RAISE FND_API.G_EXC_ERROR;

1401: x_msg_count => x_msg_count,
1402: x_msg_data => x_msg_data ) ;
1403:
1404: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1405: RAISE FND_API.G_EXC_ERROR;
1406: END IF ;
1407:
1408: -- Change the old value of the party id in the old CP audit record.
1409:

Line 1426: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1422: x_return_status => l_return_status,
1423: x_msg_count => x_msg_count,
1424: x_msg_data => x_msg_data ) ;
1425:
1426: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1427: RAISE FND_API.G_EXC_ERROR;
1428: END IF ;
1429:
1430: -- Create SR Child Audit Record

Line 1427: RAISE FND_API.G_EXC_ERROR;

1423: x_msg_count => x_msg_count,
1424: x_msg_data => x_msg_data ) ;
1425:
1426: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1427: RAISE FND_API.G_EXC_ERROR;
1428: END IF ;
1429:
1430: -- Create SR Child Audit Record
1431:

Line 1445: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1441: x_return_status => l_return_status ,
1442: x_msg_count => x_msg_count ,
1443: x_msg_data => x_msg_data ) ;
1444:
1445: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1446: RAISE FND_API.G_EXC_ERROR;
1447: END IF ;
1448:
1449: END LOOP ;

Line 1446: RAISE FND_API.G_EXC_ERROR;

1442: x_msg_count => x_msg_count ,
1443: x_msg_data => x_msg_data ) ;
1444:
1445: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1446: RAISE FND_API.G_EXC_ERROR;
1447: END IF ;
1448:
1449: END LOOP ;
1450:

Line 1479: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1475: x_return_status => l_return_status,
1476: x_msg_count => x_msg_count,
1477: x_msg_data => x_msg_data ) ;
1478:
1479: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1480: RAISE FND_API.G_EXC_ERROR;
1481: END IF ;
1482:
1483: -- Change the old value of the party id in the old CP audit record.

Line 1480: RAISE FND_API.G_EXC_ERROR;

1476: x_msg_count => x_msg_count,
1477: x_msg_data => x_msg_data ) ;
1478:
1479: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1480: RAISE FND_API.G_EXC_ERROR;
1481: END IF ;
1482:
1483: -- Change the old value of the party id in the old CP audit record.
1484:

Line 1503: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1499: x_return_status => l_return_status,
1500: x_msg_count => x_msg_count,
1501: x_msg_data => x_msg_data ) ;
1502:
1503: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1504: RAISE FND_API.G_EXC_ERROR;
1505: END IF ;
1506:
1507: -- Create SR Child Audit Record

Line 1504: RAISE FND_API.G_EXC_ERROR;

1500: x_msg_count => x_msg_count,
1501: x_msg_data => x_msg_data ) ;
1502:
1503: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1504: RAISE FND_API.G_EXC_ERROR;
1505: END IF ;
1506:
1507: -- Create SR Child Audit Record
1508:

Line 1521: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1517: x_return_status => l_return_status ,
1518: x_msg_count => x_msg_count ,
1519: x_msg_data => x_msg_data ) ;
1520:
1521: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1522: RAISE FND_API.G_EXC_ERROR;
1523: END IF ;
1524:
1525: END LOOP ;

Line 1522: RAISE FND_API.G_EXC_ERROR;

1518: x_msg_count => x_msg_count ,
1519: x_msg_data => x_msg_data ) ;
1520:
1521: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1522: RAISE FND_API.G_EXC_ERROR;
1523: END IF ;
1524:
1525: END LOOP ;
1526:

Line 1537: WHEN FND_API.G_EXC_ERROR THEN

1533: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
1534: arp_message.set_token('NUM_ROWS', to_char(l_count) );
1535:
1536: exception
1537: WHEN FND_API.G_EXC_ERROR THEN
1538: x_return_status := FND_API.G_RET_STS_ERROR;
1539: FND_MSG_PUB.Count_And_Get
1540: ( p_count => x_msg_count,
1541: p_data => x_msg_data

Line 1538: x_return_status := FND_API.G_RET_STS_ERROR;

1534: arp_message.set_token('NUM_ROWS', to_char(l_count) );
1535:
1536: exception
1537: WHEN FND_API.G_EXC_ERROR THEN
1538: x_return_status := FND_API.G_RET_STS_ERROR;
1539: FND_MSG_PUB.Count_And_Get
1540: ( p_count => x_msg_count,
1541: p_data => x_msg_data
1542: );

Line 1544: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1540: ( p_count => x_msg_count,
1541: p_data => x_msg_data
1542: );
1543: raise;
1544: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1546: FND_MSG_PUB.Count_And_Get
1547: ( p_count => x_msg_count,
1548: p_data => x_msg_data

Line 1545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1541: p_data => x_msg_data
1542: );
1543: raise;
1544: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1546: FND_MSG_PUB.Count_And_Get
1547: ( p_count => x_msg_count,
1548: p_data => x_msg_data
1549: );

Line 1555: x_return_status := FND_API.G_RET_STS_ERROR;

1551: WHEN resource_busy then
1552: arp_message.set_line(g_proc_name || '.' || l_api_name ||
1553: '; Could not obtain lock for records in table ' ||
1554: 'CS_HZ_SR_CONTACT_POINTS for party_id = ' || p_from_fk_id );
1555: x_return_status := FND_API.G_RET_STS_ERROR;
1556: raise;
1557:
1558: WHEN others then
1559: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);

Line 1560: x_return_status := FND_API.G_RET_STS_ERROR;

1556: raise;
1557:
1558: WHEN others then
1559: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
1560: x_return_status := FND_API.G_RET_STS_ERROR;
1561: FND_MSG_PUB.Count_And_Get
1562: ( p_count => x_msg_count,
1563: p_data => x_msg_data
1564: );

Line 1611: x_return_status := FND_API.G_RET_STS_SUCCESS;

1607:
1608: BEGIN
1609: arp_message.set_line('CS_PARTY_MERGE_PKG.CS_CONTACTS_MERGE_CONTACT_POINTS()+');
1610:
1611: x_return_status := FND_API.G_RET_STS_SUCCESS;
1612:
1613: SELECT merge_reason_code
1614: INTO l_merge_reason_code
1615: FROM hz_merge_batch

Line 1713: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1709: x_return_status => l_return_status,
1710: x_msg_count => x_msg_count,
1711: x_msg_data => x_msg_data ) ;
1712:
1713: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1714: RAISE FND_API.G_EXC_ERROR;
1715: END IF ;
1716:
1717: -- Change the old value of the party id in the old CP audit record.

Line 1714: RAISE FND_API.G_EXC_ERROR;

1710: x_msg_count => x_msg_count,
1711: x_msg_data => x_msg_data ) ;
1712:
1713: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1714: RAISE FND_API.G_EXC_ERROR;
1715: END IF ;
1716:
1717: -- Change the old value of the party id in the old CP audit record.
1718:

Line 1736: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1732: x_return_status => l_return_status,
1733: x_msg_count => x_msg_count,
1734: x_msg_data => x_msg_data ) ;
1735:
1736: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1737: RAISE FND_API.G_EXC_ERROR;
1738: END IF ;
1739:
1740: -- Create SR Child Audit Record

Line 1737: RAISE FND_API.G_EXC_ERROR;

1733: x_msg_count => x_msg_count,
1734: x_msg_data => x_msg_data ) ;
1735:
1736: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1737: RAISE FND_API.G_EXC_ERROR;
1738: END IF ;
1739:
1740: -- Create SR Child Audit Record
1741:

Line 1754: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1750: x_return_status => l_return_status ,
1751: x_msg_count => x_msg_count ,
1752: x_msg_data => x_msg_data ) ;
1753:
1754: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1755: RAISE FND_API.G_EXC_ERROR;
1756: END IF ;
1757:
1758: END LOOP ;

Line 1755: RAISE FND_API.G_EXC_ERROR;

1751: x_msg_count => x_msg_count ,
1752: x_msg_data => x_msg_data ) ;
1753:
1754: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1755: RAISE FND_API.G_EXC_ERROR;
1756: END IF ;
1757:
1758: END LOOP ;
1759:

Line 1801: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1797: x_return_status => l_return_status,
1798: x_msg_count => x_msg_count,
1799: x_msg_data => x_msg_data ) ;
1800:
1801: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1802: RAISE FND_API.G_EXC_ERROR;
1803: END IF ;
1804:
1805: -- Change the old value of the party id in the old CP audit record.

Line 1802: RAISE FND_API.G_EXC_ERROR;

1798: x_msg_count => x_msg_count,
1799: x_msg_data => x_msg_data ) ;
1800:
1801: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1802: RAISE FND_API.G_EXC_ERROR;
1803: END IF ;
1804:
1805: -- Change the old value of the party id in the old CP audit record.
1806:

Line 1823: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1819: x_return_status => l_return_status,
1820: x_msg_count => x_msg_count,
1821: x_msg_data => x_msg_data ) ;
1822:
1823: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1824: RAISE FND_API.G_EXC_ERROR;
1825: END IF ;
1826:
1827: -- Create SR Child Audit Record

Line 1824: RAISE FND_API.G_EXC_ERROR;

1820: x_msg_count => x_msg_count,
1821: x_msg_data => x_msg_data ) ;
1822:
1823: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1824: RAISE FND_API.G_EXC_ERROR;
1825: END IF ;
1826:
1827: -- Create SR Child Audit Record
1828:

Line 1841: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1837: x_return_status => l_return_status ,
1838: x_msg_count => x_msg_count ,
1839: x_msg_data => x_msg_data ) ;
1840:
1841: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1842: RAISE FND_API.G_EXC_ERROR;
1843: END IF ;
1844:
1845:

Line 1842: RAISE FND_API.G_EXC_ERROR;

1838: x_msg_count => x_msg_count ,
1839: x_msg_data => x_msg_data ) ;
1840:
1841: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1842: RAISE FND_API.G_EXC_ERROR;
1843: END IF ;
1844:
1845:
1846: END LOOP ;

Line 1875: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1871: x_return_status => l_return_status,
1872: x_msg_count => x_msg_count,
1873: x_msg_data => x_msg_data ) ;
1874:
1875: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1876: RAISE FND_API.G_EXC_ERROR;
1877: END IF ;
1878:
1879: -- Change the old value of the party id in the old CP audit record.

Line 1876: RAISE FND_API.G_EXC_ERROR;

1872: x_msg_count => x_msg_count,
1873: x_msg_data => x_msg_data ) ;
1874:
1875: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1876: RAISE FND_API.G_EXC_ERROR;
1877: END IF ;
1878:
1879: -- Change the old value of the party id in the old CP audit record.
1880:

Line 1897: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1893: x_return_status => l_return_status,
1894: x_msg_count => x_msg_count,
1895: x_msg_data => x_msg_data ) ;
1896:
1897: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1898: RAISE FND_API.G_EXC_ERROR;
1899: END IF ;
1900:
1901: -- Create SR Child Audit Record

Line 1898: RAISE FND_API.G_EXC_ERROR;

1894: x_msg_count => x_msg_count,
1895: x_msg_data => x_msg_data ) ;
1896:
1897: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1898: RAISE FND_API.G_EXC_ERROR;
1899: END IF ;
1900:
1901: -- Create SR Child Audit Record
1902:

Line 1915: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1911: x_return_status => l_return_status ,
1912: x_msg_count => x_msg_count ,
1913: x_msg_data => x_msg_data ) ;
1914:
1915: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1916: RAISE FND_API.G_EXC_ERROR;
1917: END IF ;
1918:
1919: END LOOP;

Line 1916: RAISE FND_API.G_EXC_ERROR;

1912: x_msg_count => x_msg_count ,
1913: x_msg_data => x_msg_data ) ;
1914:
1915: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1916: RAISE FND_API.G_EXC_ERROR;
1917: END IF ;
1918:
1919: END LOOP;
1920:

Line 1931: WHEN FND_API.G_EXC_ERROR THEN

1927: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
1928: arp_message.set_token('NUM_ROWS', to_char(l_count) );
1929:
1930: exception
1931: WHEN FND_API.G_EXC_ERROR THEN
1932: x_return_status := FND_API.G_RET_STS_ERROR;
1933: FND_MSG_PUB.Count_And_Get
1934: ( p_count => x_msg_count,
1935: p_data => x_msg_data

Line 1932: x_return_status := FND_API.G_RET_STS_ERROR;

1928: arp_message.set_token('NUM_ROWS', to_char(l_count) );
1929:
1930: exception
1931: WHEN FND_API.G_EXC_ERROR THEN
1932: x_return_status := FND_API.G_RET_STS_ERROR;
1933: FND_MSG_PUB.Count_And_Get
1934: ( p_count => x_msg_count,
1935: p_data => x_msg_data
1936: );

Line 1938: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1934: ( p_count => x_msg_count,
1935: p_data => x_msg_data
1936: );
1937: RAISE;
1938: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1939: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1940: FND_MSG_PUB.Count_And_Get
1941: ( p_count => x_msg_count,
1942: p_data => x_msg_data

Line 1939: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1935: p_data => x_msg_data
1936: );
1937: RAISE;
1938: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1939: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1940: FND_MSG_PUB.Count_And_Get
1941: ( p_count => x_msg_count,
1942: p_data => x_msg_data
1943: );

Line 1949: x_return_status := FND_API.G_RET_STS_ERROR;

1945: when resource_busy then
1946: arp_message.set_line(g_proc_name || '.' || l_api_name ||
1947: '; Could not obtain lock for records in table ' ||
1948: 'CS_HZ_SR_CONTACT_POINTS for contact_point_id = ' || p_from_fk_id );
1949: x_return_status := FND_API.G_RET_STS_ERROR;
1950: raise;
1951:
1952: when others then
1953: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);

Line 1954: x_return_status := FND_API.G_RET_STS_ERROR;

1950: raise;
1951:
1952: when others then
1953: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
1954: x_return_status := FND_API.G_RET_STS_ERROR;
1955: raise;
1956: end;
1957: end if; -- IF p_from_fk_id <> p_to_fk_id
1958:

Line 2009: x_return_status := FND_API.G_RET_STS_SUCCESS;

2005:
2006: BEGIN
2007: arp_message.set_line('CS_SR_PARTY_MERGE_PKG.CS_INC_ALL_MERGE_CONT_POINTS()+');
2008:
2009: x_return_status := FND_API.G_RET_STS_SUCCESS;
2010:
2011: SELECT merge_reason_code
2012: INTO l_merge_reason_code
2013: FROM hz_merge_batch

Line 2100: IF x_return_status <> FND_API.G_RET_STS_ERROR THEN

2096: x_msg_count => x_msg_count,
2097: x_msg_data => x_msg_data,
2098: x_audit_vals_rec => l_audit_vals_rec );
2099:
2100: IF x_return_status <> FND_API.G_RET_STS_ERROR THEN
2101:
2102: -- set the customer_email_id/old_customer_email_id of audit record
2103:
2104: IF l_customer_email_id(i) = p_from_fk_id THEN

Line 2164: x_return_status := FND_API.G_RET_STS_ERROR;

2160: arp_message.set_line(g_proc_name || '.' || l_api_name ||
2161: '; Could not obtain lock for records in table ' ||
2162: 'CS_INCIDENTS_ALL_B for customer_phone_id / customer_email_id = '
2163: || p_from_fk_id );
2164: x_return_status := FND_API.G_RET_STS_ERROR;
2165: RAISE;
2166:
2167: WHEN others THEN
2168: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);

Line 2169: x_return_status := FND_API.G_RET_STS_ERROR;

2165: RAISE;
2166:
2167: WHEN others THEN
2168: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
2169: x_return_status := FND_API.G_RET_STS_ERROR;
2170: RAISE;
2171: END;
2172: END IF;
2173: END CS_INC_ALL_MERGE_CONT_POINTS;