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_PARTYMERGE_PKG dependencies on ARP_MESSAGE

Line 395: arp_message.set_line('CS_PARTYMERGE_PKG.UPDATE_CS_DATA()+');

391: END IF;
392: END IF;
393: END IF;
394:
395: arp_message.set_line('CS_PARTYMERGE_PKG.UPDATE_CS_DATA()+');
396:
397: x_return_status := FND_API.G_RET_STS_SUCCESS;
398:
399: -- Update service request transaction data and create a SR audit record for each service request that is updated.

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

411: END IF;
412: END IF;
413: END IF;
414: -- obtain lock on records to be updated.
415: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
416: arp_message.set_token('TABLE_NAME', 'CS_INCIDENTS_ALL_B', FALSE);
417:
418: OPEN C_Get_ServiceRequests;
419: LOOP -- Loop for BULK SR processing in a batch of 1000

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

412: END IF;
413: END IF;
414: -- obtain lock on records to be updated.
415: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
416: arp_message.set_token('TABLE_NAME', 'CS_INCIDENTS_ALL_B', FALSE);
417:
418: OPEN C_Get_ServiceRequests;
419: LOOP -- Loop for BULK SR processing in a batch of 1000
420:

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

551: END IF;
552: END IF;
553: END IF;
554:
555: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
556: arp_message.set_token('NUM_ROWS', to_char(l_count) );
557:
558: -- Create SR Audit record for each updated service request transaction
559:

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

552: END IF;
553: END IF;
554:
555: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
556: arp_message.set_token('NUM_ROWS', to_char(l_count) );
557:
558: -- Create SR Audit record for each updated service request transaction
559:
560: dbg_msg := ('Creating SR Audit record for each updated service request');

Line 702: arp_message.set_line(g_pkg_name || '.' || g_proc_name || ': ' || sqlerrm);

698: END LOOP; -- End lool for BULK SR processing in a batch of 1000
699: CLOSE C_Get_ServiceRequests;
700: EXCEPTION
701: WHEN FND_API.G_EXC_ERROR THEN
702: arp_message.set_line(g_pkg_name || '.' || g_proc_name || ': ' || sqlerrm);
703: x_return_status := FND_API.G_RET_STS_ERROR;
704: ROLLBACK;
705: RAISE;
706:

Line 708: arp_message.set_line(g_pkg_name || '.' || g_proc_name || ': Could not obtain lock for records in table '||

704: ROLLBACK;
705: RAISE;
706:
707: WHEN resource_busy THEN
708: arp_message.set_line(g_pkg_name || '.' || g_proc_name || ': Could not obtain lock for records in table '||
709: 'CS_INCIDENTS_ALL_B for columns referring HZ parties');
710: x_return_status := FND_API.G_RET_STS_ERROR;
711: ROLLBACK;
712: RAISE;

Line 715: arp_message.set_line(g_pkg_name || '.' || g_proc_name || ': ' || sqlerrm);

711: ROLLBACK;
712: RAISE;
713:
714: WHEN others THEN
715: arp_message.set_line(g_pkg_name || '.' || g_proc_name || ': ' || sqlerrm);
716: x_return_status := FND_API.G_RET_STS_ERROR;
717: ROLLBACK;
718: RAISE;
719: END ;

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

825: END IF;
826:
827: -- get all the impacted SR Charges transactions in a batch of 1000 .
828: -- obtain lock on records to be updated.
829: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
830: arp_message.set_token('TABLE_NAME', 'CS_ESTIMATE_DETAILS', FALSE);
831:
832: OPEN C_Get_Estimate_details;
833: LOOP -- Loop for BULK SR charges processing in a batch of 1000

Line 830: arp_message.set_token('TABLE_NAME', 'CS_ESTIMATE_DETAILS', FALSE);

826:
827: -- get all the impacted SR Charges transactions in a batch of 1000 .
828: -- obtain lock on records to be updated.
829: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
830: arp_message.set_token('TABLE_NAME', 'CS_ESTIMATE_DETAILS', FALSE);
831:
832: OPEN C_Get_Estimate_details;
833: LOOP -- Loop for BULK SR charges processing in a batch of 1000
834: FETCH C_Get_Estimate_details BULK COLLECT

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

904: END IF;
905: END IF;
906: END IF;
907:
908: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
909: arp_message.set_token('NUM_ROWS', to_char(l_count) );
910:
911: IF l_last_fetch THEN
912: EXIT;

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

905: END IF;
906: END IF;
907:
908: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
909: arp_message.set_token('NUM_ROWS', to_char(l_count) );
910:
911: IF l_last_fetch THEN
912: EXIT;
913: END IF ;

Line 921: arp_message.set_line(g_pkg_name || '.' || g_proc_name || ': Could not obtain lock for records in table '||

917: CLOSE C_Get_Estimate_details;
918:
919: EXCEPTION
920: WHEN resource_busy THEN
921: arp_message.set_line(g_pkg_name || '.' || g_proc_name || ': Could not obtain lock for records in table '||
922: 'CS_ESTIMATE_DETAILS for columns referring HZ entities');
923: x_return_status := FND_API.G_RET_STS_ERROR;
924: ROLLBACK;
925: RAISE;

Line 928: arp_message.set_line(g_pkg_name || '.' || g_proc_name || ': ' || sqlerrm);

924: ROLLBACK;
925: RAISE;
926:
927: WHEN others THEN
928: arp_message.set_line(g_pkg_name || '.' || g_proc_name || ': ' || sqlerrm);
929: x_return_status := FND_API.G_RET_STS_ERROR;
930:
931: ROLLBACK;
932: RAISE;

Line 1158: arp_message.set_line(g_pkg_name || '.' || g_proc_name || ': ' || sqlerrm);

1154: END IF;
1155:
1156: EXCEPTION
1157: WHEN others THEN
1158: arp_message.set_line(g_pkg_name || '.' || g_proc_name || ': ' || sqlerrm);
1159: x_return_status := FND_API.G_RET_STS_ERROR;
1160: ROLLBACK;
1161: RAISE;
1162: END;

Line 1247: arp_message.set_line(g_pkg_name || '.' || g_proc_name || ': ' || sqlerrm);

1243: END IF;
1244:
1245: EXCEPTION
1246: WHEN others THEN
1247: arp_message.set_line(g_pkg_name || '.' || g_proc_name || ': ' || sqlerrm);
1248:
1249: x_return_status := FND_API.G_RET_STS_ERROR;
1250: ROLLBACK;
1251: RAISE;

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

1311: END IF;
1312: END IF;
1313: END IF;
1314:
1315: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
1316: arp_message.set_token('NUM_ROWS', to_char(l_count) );
1317:
1318: -- Create SR Audit record for each updated party role extensible attribute transaction
1319:

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

1312: END IF;
1313: END IF;
1314:
1315: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
1316: arp_message.set_token('NUM_ROWS', to_char(l_count) );
1317:
1318: -- Create SR Audit record for each updated party role extensible attribute transaction
1319:
1320: IF((FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN

Line 1390: arp_message.set_line(g_pkg_name || '.' || g_proc_name || ': ' || sqlerrm);

1386:
1387:
1388: EXCEPTION
1389: WHEN others THEN
1390: arp_message.set_line(g_pkg_name || '.' || g_proc_name || ': ' || sqlerrm);
1391:
1392: x_return_status := FND_API.G_RET_STS_ERROR;
1393: ROLLBACK;
1394: RAISE;

Line 1425: arp_message.set_line(g_pkg_name || '.' || g_proc_name || ': Could not obtain lock for records in table '||

1421: END IF;
1422:
1423: EXCEPTION
1424: WHEN resource_busy THEN
1425: arp_message.set_line(g_pkg_name || '.' || g_proc_name || ': Could not obtain lock for records in table '||
1426: 'for columns referring HZ entities');
1427: x_return_status := FND_API.G_RET_STS_ERROR;
1428: ROLLBACK;
1429: RAISE;

Line 1432: arp_message.set_line(g_pkg_name || '.' || g_proc_name || ': ' || sqlerrm);

1428: ROLLBACK;
1429: RAISE;
1430:
1431: WHEN others THEN
1432: arp_message.set_line(g_pkg_name || '.' || g_proc_name || ': ' || sqlerrm);
1433: x_return_status := FND_API.G_RET_STS_ERROR;
1434: ROLLBACK;
1435: RAISE;
1436: