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 ARP_MESSAGE

Line 72: arp_message.set_line('CS_SR_PARTY_MERGE_PKG.CS_INC_ALL_MERGE_PARTY()+');

68: l_last_fetch BOOLEAN := FALSE ;
69:
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:

Line 111: arp_message.set_name('AR', 'AR_LOCKING_TABLE');

107: IF p_from_fk_id <> p_to_fk_id THEN
108:
109: BEGIN
110: -- obtain lock on records to be updated.
111: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
112: arp_message.set_token('TABLE_NAME', 'CS_INCIDENTS_ALL_B', FALSE);
113:
114: OPEN c1;
115: LOOP -- Loop for BULK selecting and processing the BULK selection in a batch of 1000

Line 112: arp_message.set_token('TABLE_NAME', 'CS_INCIDENTS_ALL_B', FALSE);

108:
109: BEGIN
110: -- obtain lock on records to be updated.
111: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
112: arp_message.set_token('TABLE_NAME', 'CS_INCIDENTS_ALL_B', FALSE);
113:
114: OPEN c1;
115: LOOP -- Loop for BULK selecting and processing the BULK selection in a batch of 1000
116:

Line 161: arp_message.set_name('AR', 'AR_ROWS_UPDATED');

157: WHERE rowid = l_rowid_tbl(i);
158:
159: l_count := sql%rowcount;
160:
161: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
162: arp_message.set_token('NUM_ROWS', to_char(l_count) );
163:
164: FOR i IN 1..l_incident_id.count
165: LOOP

Line 162: arp_message.set_token('NUM_ROWS', to_char(l_count) );

158:
159: l_count := sql%rowcount;
160:
161: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
162: arp_message.set_token('NUM_ROWS', to_char(l_count) );
163:
164: FOR i IN 1..l_incident_id.count
165: LOOP
166:

Line 230: arp_message.set_line(g_proc_name || '.' || l_api_name ||

226: CLOSE c1;
227:
228: EXCEPTION
229: WHEN resource_busy THEN
230: arp_message.set_line(g_proc_name || '.' || l_api_name ||
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 );

Line 239: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);

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);
240: x_return_status := FND_API.G_RET_STS_ERROR;
241: RAISE;
242: END;
243:

Line 328: arp_message.set_line('CS_SR_PARTY_MERGE_PKG.CS_INC_ALL_MERGE_SITE_USES()+');

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

Line 367: arp_message.set_name('AR', 'AR_LOCKING_TABLE');

363:
364: IF p_from_fk_id <> p_to_fk_id THEN
365: BEGIN
366: -- obtain lock on records to be updated.
367: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
368: arp_message.set_token('TABLE_NAME', 'CS_INCIDENTS_ALL_B', FALSE);
369:
370: OPEN c1;
371: LOOP

Line 368: arp_message.set_token('TABLE_NAME', 'CS_INCIDENTS_ALL_B', FALSE);

364: IF p_from_fk_id <> p_to_fk_id THEN
365: BEGIN
366: -- obtain lock on records to be updated.
367: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
368: arp_message.set_token('TABLE_NAME', 'CS_INCIDENTS_ALL_B', FALSE);
369:
370: OPEN c1;
371: LOOP
372: FETCH c1 bulk collect

Line 408: arp_message.set_name('AR', 'AR_ROWS_UPDATED');

404: WHERE rowid = l_rowid_tbl(i);
405:
406: l_count := SQL%ROWCOUNT;
407:
408: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
409: arp_message.set_token('NUM_ROWS', to_char(l_count) );
410:
411:
412: -- Create an audit record for each service request in cs_incidents_audit_b table

Line 409: arp_message.set_token('NUM_ROWS', to_char(l_count) );

405:
406: l_count := SQL%ROWCOUNT;
407:
408: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
409: arp_message.set_token('NUM_ROWS', to_char(l_count) );
410:
411:
412: -- Create an audit record for each service request in cs_incidents_audit_b table
413: -- for which the bill_to_site_use_id or ship_to_site_use_id is updated

Line 480: arp_message.set_line(g_proc_name || '.' || l_api_name ||

476: CLOSE c1;
477:
478: EXCEPTION
479: WHEN resource_busy THEN
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;

Line 488: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);

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);
489: x_return_status := FND_API.G_RET_STS_ERROR;
490: RAISE;
491: END;
492: END IF;

Line 601: arp_message.set_line('CS_SR_PARTY_MERGE_PKG.CS_INC_ALL_MERGE_SITE_ID()+');

597: RESOURCE_BUSY EXCEPTION;
598: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
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

Line 642: arp_message.set_name('AR', 'AR_LOCKING_TABLE');

638:
639: IF p_from_fk_id <> p_to_fk_id THEN
640: BEGIN
641: -- obtain lock on records to be updated.
642: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
643: arp_message.set_token('TABLE_NAME', 'CS_INCIDENTS_ALL_B', FALSE);
644:
645: OPEN C1;
646: LOOP -- Bulk fetch loop for 1000 records

Line 643: arp_message.set_token('TABLE_NAME', 'CS_INCIDENTS_ALL_B', FALSE);

639: IF p_from_fk_id <> p_to_fk_id THEN
640: BEGIN
641: -- obtain lock on records to be updated.
642: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
643: arp_message.set_token('TABLE_NAME', 'CS_INCIDENTS_ALL_B', FALSE);
644:
645: OPEN C1;
646: LOOP -- Bulk fetch loop for 1000 records
647: FETCH C1 BULK COLLECT

Line 709: arp_message.set_name('AR', 'AR_ROWS_UPDATED');

705: WHERE rowid = l_rowid_tbl(i);
706:
707: l_count := sql%rowcount;
708:
709: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
710: arp_message.set_token('NUM_ROWS', to_char(l_count) );
711:
712: -- create audit record in cs_incidents_audit_b table for each service
713: -- request for which site_id is updated.

Line 710: arp_message.set_token('NUM_ROWS', to_char(l_count) );

706:
707: l_count := sql%rowcount;
708:
709: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
710: arp_message.set_token('NUM_ROWS', to_char(l_count) );
711:
712: -- create audit record in cs_incidents_audit_b table for each service
713: -- request for which site_id is updated.
714:

Line 835: arp_message.set_line(g_proc_name || '.' || l_api_name ||

831: CLOSE c1 ;
832:
833: EXCEPTION
834: WHEN resource_busy THEN
835: arp_message.set_line(g_proc_name || '.' || l_api_name ||
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 );

Line 844: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);

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);
845: x_return_status := FND_API.G_RET_STS_ERROR;
846: RAISE;
847: END;
848: END IF;

Line 903: arp_message.set_line('CS_SR_PARTY_MERGE_PKG.CS_AUDIT_MERGE_PARTY()+');

899: RESOURCE_BUSY EXCEPTION;
900: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
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

Line 940: arp_message.set_name('AR', 'AR_LOCKING_TABLE');

936:
937: if p_from_fk_id <> p_to_fk_id then
938: begin
939: -- obtain lock on records to be updated.
940: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
941: arp_message.set_token('TABLE_NAME', 'CS_INCIDENTS_AUDIT_B', FALSE);
942:
943: open c1;
944: fetch c1 bulk collect into l_rowid_tbl;

Line 941: arp_message.set_token('TABLE_NAME', 'CS_INCIDENTS_AUDIT_B', FALSE);

937: if p_from_fk_id <> p_to_fk_id then
938: begin
939: -- obtain lock on records to be updated.
940: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
941: arp_message.set_token('TABLE_NAME', 'CS_INCIDENTS_AUDIT_B', FALSE);
942:
943: open c1;
944: fetch c1 bulk collect into l_rowid_tbl;
945: close c1;

Line 969: arp_message.set_name('AR', 'AR_ROWS_UPDATED');

965: where rowid = l_rowid_tbl(i);
966:
967: l_count := sql%rowcount;
968:
969: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
970: arp_message.set_token('NUM_ROWS', to_char(l_count) );
971:
972: exception
973: when resource_busy then

Line 970: arp_message.set_token('NUM_ROWS', to_char(l_count) );

966:
967: l_count := sql%rowcount;
968:
969: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
970: arp_message.set_token('NUM_ROWS', to_char(l_count) );
971:
972: exception
973: when resource_busy then
974: arp_message.set_line(g_proc_name || '.' || l_api_name ||

Line 974: arp_message.set_line(g_proc_name || '.' || l_api_name ||

970: arp_message.set_token('NUM_ROWS', to_char(l_count) );
971:
972: exception
973: when resource_busy then
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;

Line 982: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);

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);
983: x_return_status := FND_API.G_RET_STS_ERROR;
984: raise;
985: end;
986: end if;

Line 1070: arp_message.set_line('CS_SR_PARTY_MERGE_PKG.CS_AUDIT_MERGE_SITE_ID()+');

1066: RESOURCE_BUSY EXCEPTION;
1067: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
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

Line 1107: arp_message.set_name('AR', 'AR_LOCKING_TABLE');

1103:
1104: if p_from_fk_id <> p_to_fk_id then
1105: begin
1106: -- obtain lock on records to be updated.
1107: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
1108: arp_message.set_token('TABLE_NAME', 'CS_INCIDENTS_AUDIT_B', FALSE);
1109:
1110: open c1;
1111: fetch c1 bulk collect into l_rowid_tbl;

Line 1108: arp_message.set_token('TABLE_NAME', 'CS_INCIDENTS_AUDIT_B', FALSE);

1104: if p_from_fk_id <> p_to_fk_id then
1105: begin
1106: -- obtain lock on records to be updated.
1107: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
1108: arp_message.set_token('TABLE_NAME', 'CS_INCIDENTS_AUDIT_B', FALSE);
1109:
1110: open c1;
1111: fetch c1 bulk collect into l_rowid_tbl;
1112: close c1;

Line 1132: arp_message.set_name('AR', 'AR_ROWS_UPDATED');

1128: where rowid = l_rowid_tbl(i);
1129:
1130: l_count := sql%rowcount;
1131:
1132: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
1133: arp_message.set_token('NUM_ROWS', to_char(l_count) );
1134:
1135: exception
1136: when resource_busy then

Line 1133: arp_message.set_token('NUM_ROWS', to_char(l_count) );

1129:
1130: l_count := sql%rowcount;
1131:
1132: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
1133: arp_message.set_token('NUM_ROWS', to_char(l_count) );
1134:
1135: exception
1136: when resource_busy then
1137: arp_message.set_line(g_proc_name || '.' || l_api_name ||

Line 1137: arp_message.set_line(g_proc_name || '.' || l_api_name ||

1133: arp_message.set_token('NUM_ROWS', to_char(l_count) );
1134:
1135: exception
1136: when resource_busy then
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;

Line 1145: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);

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);
1146: x_return_status := FND_API.G_RET_STS_ERROR;
1147: raise;
1148: end;
1149: end if;

Line 1207: arp_message.set_line('CS_PARTY_MERGE_PKG.CS_CONTACTS_MERGE_PARTY()+');

1203: RESOURCE_BUSY EXCEPTION;
1204: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
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');

Line 1250: arp_message.set_name('AR', 'AR_LOCKING_TABLE');

1246:
1247: if p_from_fk_id <> p_to_fk_id then
1248: begin
1249: -- obtain lock on records to be updated.
1250: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
1251: arp_message.set_token('TABLE_NAME', 'CS_HZ_SR_CONTACT_POINTS', FALSE);
1252:
1253: open c1;
1254: close c1;

Line 1251: arp_message.set_token('TABLE_NAME', 'CS_HZ_SR_CONTACT_POINTS', FALSE);

1247: if p_from_fk_id <> p_to_fk_id then
1248: begin
1249: -- obtain lock on records to be updated.
1250: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
1251: arp_message.set_token('TABLE_NAME', 'CS_HZ_SR_CONTACT_POINTS', FALSE);
1252:
1253: open c1;
1254: close c1;
1255:

Line 1533: arp_message.set_name('AR', 'AR_ROWS_UPDATED');

1529: END IF;
1530:
1531: l_count := sql%rowcount;
1532:
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

Line 1534: arp_message.set_token('NUM_ROWS', to_char(l_count) );

1530:
1531: l_count := sql%rowcount;
1532:
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;

Line 1552: arp_message.set_line(g_proc_name || '.' || l_api_name ||

1548: p_data => x_msg_data
1549: );
1550: raise;
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;

Line 1559: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);

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);
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

Line 1609: arp_message.set_line('CS_PARTY_MERGE_PKG.CS_CONTACTS_MERGE_CONTACT_POINTS()+');

1605: RESOURCE_BUSY EXCEPTION;
1606: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
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

Line 1651: arp_message.set_name('AR', 'AR_LOCKING_TABLE');

1647:
1648: IF p_from_fk_id <> p_to_fk_id then
1649: begin
1650: -- obtain lock on records to be updated.
1651: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
1652: arp_message.set_token('TABLE_NAME', 'CS_HZ_SR_CONTACT_POINTS', FALSE);
1653:
1654: open c1;
1655: close c1;

Line 1652: arp_message.set_token('TABLE_NAME', 'CS_HZ_SR_CONTACT_POINTS', FALSE);

1648: IF p_from_fk_id <> p_to_fk_id then
1649: begin
1650: -- obtain lock on records to be updated.
1651: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
1652: arp_message.set_token('TABLE_NAME', 'CS_HZ_SR_CONTACT_POINTS', FALSE);
1653:
1654: open c1;
1655: close c1;
1656:

Line 1927: arp_message.set_name('AR', 'AR_ROWS_UPDATED');

1923:
1924:
1925: l_count := sql%rowcount;
1926:
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

Line 1928: arp_message.set_token('NUM_ROWS', to_char(l_count) );

1924:
1925: l_count := sql%rowcount;
1926:
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;

Line 1946: arp_message.set_line(g_proc_name || '.' || l_api_name ||

1942: p_data => x_msg_data
1943: );
1944: RAISE;
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;

Line 1953: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);

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);
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

Line 2007: arp_message.set_line('CS_SR_PARTY_MERGE_PKG.CS_INC_ALL_MERGE_CONT_POINTS()+');

2003: RESOURCE_BUSY EXCEPTION;
2004: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
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

Line 2041: arp_message.set_name('AR', 'AR_LOCKING_TABLE');

2037:
2038: IF p_from_fk_id <> p_to_fk_id THEN
2039: BEGIN
2040: -- obtain lock on records to be updated.
2041: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
2042: arp_message.set_token('TABLE_NAME', 'CS_INCIDENTS_ALL_B', FALSE);
2043:
2044: OPEN c1;
2045: LOOP -- loop to batch process 1000 records

Line 2042: arp_message.set_token('TABLE_NAME', 'CS_INCIDENTS_ALL_B', FALSE);

2038: IF p_from_fk_id <> p_to_fk_id THEN
2039: BEGIN
2040: -- obtain lock on records to be updated.
2041: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
2042: arp_message.set_token('TABLE_NAME', 'CS_INCIDENTS_ALL_B', FALSE);
2043:
2044: OPEN c1;
2045: LOOP -- loop to batch process 1000 records
2046: FETCH c1 bulk collect

Line 2083: arp_message.set_name('AR', 'AR_ROWS_UPDATED');

2079: WHERE rowid = l_rowid_tbl(i);
2080:
2081: l_count := sql%rowcount;
2082:
2083: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
2084: arp_message.set_token('NUM_ROWS', to_char(l_count) );
2085:
2086: -- create audit record in cs_incidents_audit_b table for each service
2087: -- request for which site_id is updated.

Line 2084: arp_message.set_token('NUM_ROWS', to_char(l_count) );

2080:
2081: l_count := sql%rowcount;
2082:
2083: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
2084: arp_message.set_token('NUM_ROWS', to_char(l_count) );
2085:
2086: -- create audit record in cs_incidents_audit_b table for each service
2087: -- request for which site_id is updated.
2088:

Line 2160: arp_message.set_line(g_proc_name || '.' || l_api_name ||

2156: CLOSE c1 ;
2157:
2158: EXCEPTION
2159: WHEN resource_busy THEN
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;

Line 2168: arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);

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);
2169: x_return_status := FND_API.G_RET_STS_ERROR;
2170: RAISE;
2171: END;
2172: END IF;