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.PV_SLSTEAM_MIGRTN_PVT dependencies on FND_MESSAGE

Line 56: ERRBUF := fnd_message.get;

52: printlog('Batch ended at '|| TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));
53:
54:
55: RETCODE := 0;
56: ERRBUF := fnd_message.get;
57:
58: EXCEPTION
59: WHEN OTHERS THEN
60: printOutput('Database Error:'||sqlcode||' '||sqlerrm);

Line 67: ERRBUF := fnd_message.get;

63: RETCODE := g_ret_code;
64: ELSE
65: RETCODE := 0;
66: END IF;
67: ERRBUF := fnd_message.get;
68: END EXT_SLSTEAM_MIGRTN;
69:
70: PROCEDURE delete_corrupt_partner
71: IS

Line 1346: fnd_message.set_name('PV','PV_ACCESS_MIG_DESC');

1342:
1343:
1344:
1345: begin
1346: fnd_message.set_name('PV','PV_ACCESS_MIG_DESC');
1347: l_temp_msg := fnd_message.get;
1348: printOutput(RPAD('=',120,'='));
1349: printOutput(RPAD(' ',(120-length(l_temp_msg))/2,' ')||l_temp_msg);
1350: printOutput(RPAD('=',120,'='));

Line 1347: l_temp_msg := fnd_message.get;

1343:
1344:
1345: begin
1346: fnd_message.set_name('PV','PV_ACCESS_MIG_DESC');
1347: l_temp_msg := fnd_message.get;
1348: printOutput(RPAD('=',120,'='));
1349: printOutput(RPAD(' ',(120-length(l_temp_msg))/2,' ')||l_temp_msg);
1350: printOutput(RPAD('=',120,'='));
1351: printOutput(RPAD(' ',120,' '));

Line 1361: fnd_message.set_name('PV','PV_CONCURRENT_MODE');

1357: FROM fnd_lookup_values
1358: WHERE lookup_type = 'PV_MIGRATION_RUN_MODE'
1359: AND lookup_code = p_mode)
1360: LOOP
1361: fnd_message.set_name('PV','PV_CONCURRENT_MODE');
1362: fnd_message.set_token('P_MODE',x.meaning);
1363: END LOOP;
1364:
1365:

Line 1362: fnd_message.set_token('P_MODE',x.meaning);

1358: WHERE lookup_type = 'PV_MIGRATION_RUN_MODE'
1359: AND lookup_code = p_mode)
1360: LOOP
1361: fnd_message.set_name('PV','PV_CONCURRENT_MODE');
1362: fnd_message.set_token('P_MODE',x.meaning);
1363: END LOOP;
1364:
1365:
1366: l_temp_msg := fnd_message.get ;

Line 1366: l_temp_msg := fnd_message.get ;

1362: fnd_message.set_token('P_MODE',x.meaning);
1363: END LOOP;
1364:
1365:
1366: l_temp_msg := fnd_message.get ;
1367: printOutput(RPAD(' ',(120-length(l_temp_msg))/2,' ')||l_temp_msg);
1368: printOutput(RPAD(' ',120,' '));
1369: printOutput(RPAD(' ',120,' '));
1370: printOutput(RPAD(' ',120,' '));

Line 1377: fnd_message.set_name('PV','PV_DEL_CRPT_PF_PT');

1373: INTO l_count
1374: FROM pv_access_migration_log
1375: WHERE action = 'DELTE_CORRUPT_PF_PARTNER';
1376:
1377: fnd_message.set_name('PV','PV_DEL_CRPT_PF_PT');
1378: l_temp_msg := fnd_message.get ||' '||l_count;
1379:
1380: printOutput(RPAD('',(120-length(l_temp_msg))/2,' ')||l_temp_msg);
1381: printOutput(RPAD('-',120,'-'));

Line 1378: l_temp_msg := fnd_message.get ||' '||l_count;

1374: FROM pv_access_migration_log
1375: WHERE action = 'DELTE_CORRUPT_PF_PARTNER';
1376:
1377: fnd_message.set_name('PV','PV_DEL_CRPT_PF_PT');
1378: l_temp_msg := fnd_message.get ||' '||l_count;
1379:
1380: printOutput(RPAD('',(120-length(l_temp_msg))/2,' ')||l_temp_msg);
1381: printOutput(RPAD('-',120,'-'));
1382: IF l_count > 0 THEN

Line 1403: fnd_message.set_name('PV','PV_OPP_NAME_ATTR');

1399: l_migration_tbl(i).entity_id := x.entity_id;
1400: l_migration_tbl(i).party_name := x.party_name;
1401: l_migration_tbl(i).resource_id := x.salesforce_id;
1402: end loop;
1403: fnd_message.set_name('PV','PV_OPP_NAME_ATTR');
1404: l_title := RPAD(fnd_message.get,50,' ');
1405: fnd_message.set_name('PV','PV_OPP_NUMBER_ATTR');
1406: l_title := l_title || RPAD(fnd_message.get,18,' ');
1407: fnd_message.set_name('PV','PV_PARTNER_NAME');

Line 1404: l_title := RPAD(fnd_message.get,50,' ');

1400: l_migration_tbl(i).party_name := x.party_name;
1401: l_migration_tbl(i).resource_id := x.salesforce_id;
1402: end loop;
1403: fnd_message.set_name('PV','PV_OPP_NAME_ATTR');
1404: l_title := RPAD(fnd_message.get,50,' ');
1405: fnd_message.set_name('PV','PV_OPP_NUMBER_ATTR');
1406: l_title := l_title || RPAD(fnd_message.get,18,' ');
1407: fnd_message.set_name('PV','PV_PARTNER_NAME');
1408: l_title := l_title || RPAD(fnd_message.get,40,' ');

Line 1405: fnd_message.set_name('PV','PV_OPP_NUMBER_ATTR');

1401: l_migration_tbl(i).resource_id := x.salesforce_id;
1402: end loop;
1403: fnd_message.set_name('PV','PV_OPP_NAME_ATTR');
1404: l_title := RPAD(fnd_message.get,50,' ');
1405: fnd_message.set_name('PV','PV_OPP_NUMBER_ATTR');
1406: l_title := l_title || RPAD(fnd_message.get,18,' ');
1407: fnd_message.set_name('PV','PV_PARTNER_NAME');
1408: l_title := l_title || RPAD(fnd_message.get,40,' ');
1409: fnd_message.set_name('PV','PV_RESOURCE_ID_ATTR');

Line 1406: l_title := l_title || RPAD(fnd_message.get,18,' ');

1402: end loop;
1403: fnd_message.set_name('PV','PV_OPP_NAME_ATTR');
1404: l_title := RPAD(fnd_message.get,50,' ');
1405: fnd_message.set_name('PV','PV_OPP_NUMBER_ATTR');
1406: l_title := l_title || RPAD(fnd_message.get,18,' ');
1407: fnd_message.set_name('PV','PV_PARTNER_NAME');
1408: l_title := l_title || RPAD(fnd_message.get,40,' ');
1409: fnd_message.set_name('PV','PV_RESOURCE_ID_ATTR');
1410: l_title := l_title || RPAD(fnd_message.get,13,' ');

Line 1407: fnd_message.set_name('PV','PV_PARTNER_NAME');

1403: fnd_message.set_name('PV','PV_OPP_NAME_ATTR');
1404: l_title := RPAD(fnd_message.get,50,' ');
1405: fnd_message.set_name('PV','PV_OPP_NUMBER_ATTR');
1406: l_title := l_title || RPAD(fnd_message.get,18,' ');
1407: fnd_message.set_name('PV','PV_PARTNER_NAME');
1408: l_title := l_title || RPAD(fnd_message.get,40,' ');
1409: fnd_message.set_name('PV','PV_RESOURCE_ID_ATTR');
1410: l_title := l_title || RPAD(fnd_message.get,13,' ');
1411:

Line 1408: l_title := l_title || RPAD(fnd_message.get,40,' ');

1404: l_title := RPAD(fnd_message.get,50,' ');
1405: fnd_message.set_name('PV','PV_OPP_NUMBER_ATTR');
1406: l_title := l_title || RPAD(fnd_message.get,18,' ');
1407: fnd_message.set_name('PV','PV_PARTNER_NAME');
1408: l_title := l_title || RPAD(fnd_message.get,40,' ');
1409: fnd_message.set_name('PV','PV_RESOURCE_ID_ATTR');
1410: l_title := l_title || RPAD(fnd_message.get,13,' ');
1411:
1412: printOutput ( l_title);

Line 1409: fnd_message.set_name('PV','PV_RESOURCE_ID_ATTR');

1405: fnd_message.set_name('PV','PV_OPP_NUMBER_ATTR');
1406: l_title := l_title || RPAD(fnd_message.get,18,' ');
1407: fnd_message.set_name('PV','PV_PARTNER_NAME');
1408: l_title := l_title || RPAD(fnd_message.get,40,' ');
1409: fnd_message.set_name('PV','PV_RESOURCE_ID_ATTR');
1410: l_title := l_title || RPAD(fnd_message.get,13,' ');
1411:
1412: printOutput ( l_title);
1413: printOutput(RPAD('-',120,'-'));

Line 1410: l_title := l_title || RPAD(fnd_message.get,13,' ');

1406: l_title := l_title || RPAD(fnd_message.get,18,' ');
1407: fnd_message.set_name('PV','PV_PARTNER_NAME');
1408: l_title := l_title || RPAD(fnd_message.get,40,' ');
1409: fnd_message.set_name('PV','PV_RESOURCE_ID_ATTR');
1410: l_title := l_title || RPAD(fnd_message.get,13,' ');
1411:
1412: printOutput ( l_title);
1413: printOutput(RPAD('-',120,'-'));
1414:

Line 1437: fnd_message.set_name('PV','PV_DEL_CUR_CUST_ESLSTM');

1433: INTO l_count
1434: FROM pv_access_migration_log
1435: WHERE action = 'DELETE_CORRUPT_CUST_PARTNER';
1436:
1437: fnd_message.set_name('PV','PV_DEL_CUR_CUST_ESLSTM');
1438: l_temp_msg := fnd_message.get ||' '||l_count;
1439:
1440: printOutput(RPAD('',(120-length(l_temp_msg))/2,' ')||l_temp_msg);
1441: printOutput(RPAD('-',120,'-'));

Line 1438: l_temp_msg := fnd_message.get ||' '||l_count;

1434: FROM pv_access_migration_log
1435: WHERE action = 'DELETE_CORRUPT_CUST_PARTNER';
1436:
1437: fnd_message.set_name('PV','PV_DEL_CUR_CUST_ESLSTM');
1438: l_temp_msg := fnd_message.get ||' '||l_count;
1439:
1440: printOutput(RPAD('',(120-length(l_temp_msg))/2,' ')||l_temp_msg);
1441: printOutput(RPAD('-',120,'-'));
1442: IF l_count > 0 THEN

Line 1461: fnd_message.set_name('PV','PV_CUSTOMER_NAME_ATTR');

1457: l_migration_tbl(i).entity_id := x.entity_id;
1458: l_migration_tbl(i).party_name := x.party_name;
1459: l_migration_tbl(i).resource_id := x.salesforce_id;
1460: end loop;
1461: fnd_message.set_name('PV','PV_CUSTOMER_NAME_ATTR');
1462: l_title := RPAD(fnd_message.get,50,' ');
1463: fnd_message.set_name('PV','PV_CUSTOMER_ID_ATTR');
1464: l_title := l_title || RPAD(fnd_message.get,18,' ');
1465: fnd_message.set_name('PV','PV_PARTNER_NAME');

Line 1462: l_title := RPAD(fnd_message.get,50,' ');

1458: l_migration_tbl(i).party_name := x.party_name;
1459: l_migration_tbl(i).resource_id := x.salesforce_id;
1460: end loop;
1461: fnd_message.set_name('PV','PV_CUSTOMER_NAME_ATTR');
1462: l_title := RPAD(fnd_message.get,50,' ');
1463: fnd_message.set_name('PV','PV_CUSTOMER_ID_ATTR');
1464: l_title := l_title || RPAD(fnd_message.get,18,' ');
1465: fnd_message.set_name('PV','PV_PARTNER_NAME');
1466: l_title := l_title || RPAD(fnd_message.get,40,' ');

Line 1463: fnd_message.set_name('PV','PV_CUSTOMER_ID_ATTR');

1459: l_migration_tbl(i).resource_id := x.salesforce_id;
1460: end loop;
1461: fnd_message.set_name('PV','PV_CUSTOMER_NAME_ATTR');
1462: l_title := RPAD(fnd_message.get,50,' ');
1463: fnd_message.set_name('PV','PV_CUSTOMER_ID_ATTR');
1464: l_title := l_title || RPAD(fnd_message.get,18,' ');
1465: fnd_message.set_name('PV','PV_PARTNER_NAME');
1466: l_title := l_title || RPAD(fnd_message.get,40,' ');
1467: fnd_message.set_name('PV','PV_RESOURCE_ID_ATTR');

Line 1464: l_title := l_title || RPAD(fnd_message.get,18,' ');

1460: end loop;
1461: fnd_message.set_name('PV','PV_CUSTOMER_NAME_ATTR');
1462: l_title := RPAD(fnd_message.get,50,' ');
1463: fnd_message.set_name('PV','PV_CUSTOMER_ID_ATTR');
1464: l_title := l_title || RPAD(fnd_message.get,18,' ');
1465: fnd_message.set_name('PV','PV_PARTNER_NAME');
1466: l_title := l_title || RPAD(fnd_message.get,40,' ');
1467: fnd_message.set_name('PV','PV_RESOURCE_ID_ATTR');
1468: l_title := l_title || RPAD(fnd_message.get,13,' ');

Line 1465: fnd_message.set_name('PV','PV_PARTNER_NAME');

1461: fnd_message.set_name('PV','PV_CUSTOMER_NAME_ATTR');
1462: l_title := RPAD(fnd_message.get,50,' ');
1463: fnd_message.set_name('PV','PV_CUSTOMER_ID_ATTR');
1464: l_title := l_title || RPAD(fnd_message.get,18,' ');
1465: fnd_message.set_name('PV','PV_PARTNER_NAME');
1466: l_title := l_title || RPAD(fnd_message.get,40,' ');
1467: fnd_message.set_name('PV','PV_RESOURCE_ID_ATTR');
1468: l_title := l_title || RPAD(fnd_message.get,13,' ');
1469:

Line 1466: l_title := l_title || RPAD(fnd_message.get,40,' ');

1462: l_title := RPAD(fnd_message.get,50,' ');
1463: fnd_message.set_name('PV','PV_CUSTOMER_ID_ATTR');
1464: l_title := l_title || RPAD(fnd_message.get,18,' ');
1465: fnd_message.set_name('PV','PV_PARTNER_NAME');
1466: l_title := l_title || RPAD(fnd_message.get,40,' ');
1467: fnd_message.set_name('PV','PV_RESOURCE_ID_ATTR');
1468: l_title := l_title || RPAD(fnd_message.get,13,' ');
1469:
1470: printOutput ( l_title);

Line 1467: fnd_message.set_name('PV','PV_RESOURCE_ID_ATTR');

1463: fnd_message.set_name('PV','PV_CUSTOMER_ID_ATTR');
1464: l_title := l_title || RPAD(fnd_message.get,18,' ');
1465: fnd_message.set_name('PV','PV_PARTNER_NAME');
1466: l_title := l_title || RPAD(fnd_message.get,40,' ');
1467: fnd_message.set_name('PV','PV_RESOURCE_ID_ATTR');
1468: l_title := l_title || RPAD(fnd_message.get,13,' ');
1469:
1470: printOutput ( l_title);
1471: printOutput(RPAD('-',120,'-'));

Line 1468: l_title := l_title || RPAD(fnd_message.get,13,' ');

1464: l_title := l_title || RPAD(fnd_message.get,18,' ');
1465: fnd_message.set_name('PV','PV_PARTNER_NAME');
1466: l_title := l_title || RPAD(fnd_message.get,40,' ');
1467: fnd_message.set_name('PV','PV_RESOURCE_ID_ATTR');
1468: l_title := l_title || RPAD(fnd_message.get,13,' ');
1469:
1470: printOutput ( l_title);
1471: printOutput(RPAD('-',120,'-'));
1472:

Line 1497: fnd_message.set_name('PV','PV_DEL_PTR_LEAD_ESLSTM');

1493: INTO l_count
1494: FROM pv_access_migration_log
1495: WHERE action = 'DELETE_CORRUPT_LEAD_PARTNER';
1496:
1497: fnd_message.set_name('PV','PV_DEL_PTR_LEAD_ESLSTM');
1498: l_temp_msg := fnd_message.get ||' '||l_count;
1499:
1500: printOutput(RPAD('',(120-length(l_temp_msg))/2,' ')||l_temp_msg);
1501: printOutput(RPAD('-',120,'-'));

Line 1498: l_temp_msg := fnd_message.get ||' '||l_count;

1494: FROM pv_access_migration_log
1495: WHERE action = 'DELETE_CORRUPT_LEAD_PARTNER';
1496:
1497: fnd_message.set_name('PV','PV_DEL_PTR_LEAD_ESLSTM');
1498: l_temp_msg := fnd_message.get ||' '||l_count;
1499:
1500: printOutput(RPAD('',(120-length(l_temp_msg))/2,' ')||l_temp_msg);
1501: printOutput(RPAD('-',120,'-'));
1502: IF l_count > 0 THEN

Line 1522: fnd_message.set_name('PV','PV_LEAD_NAME_ATTR');

1518: l_migration_tbl(i).party_name := x.party_name;
1519: l_migration_tbl(i).resource_id := x.salesforce_id;
1520: end loop;
1521:
1522: fnd_message.set_name('PV','PV_LEAD_NAME_ATTR');
1523: l_title := RPAD(fnd_message.get,50,' ');
1524: fnd_message.set_name('PV','PV_LEAD_ID_ATTR');
1525: l_title := l_title || RPAD(fnd_message.get,18,' ');
1526: fnd_message.set_name('PV','PV_PARTNER_NAME');

Line 1523: l_title := RPAD(fnd_message.get,50,' ');

1519: l_migration_tbl(i).resource_id := x.salesforce_id;
1520: end loop;
1521:
1522: fnd_message.set_name('PV','PV_LEAD_NAME_ATTR');
1523: l_title := RPAD(fnd_message.get,50,' ');
1524: fnd_message.set_name('PV','PV_LEAD_ID_ATTR');
1525: l_title := l_title || RPAD(fnd_message.get,18,' ');
1526: fnd_message.set_name('PV','PV_PARTNER_NAME');
1527: l_title := l_title || RPAD(fnd_message.get,40,' ');

Line 1524: fnd_message.set_name('PV','PV_LEAD_ID_ATTR');

1520: end loop;
1521:
1522: fnd_message.set_name('PV','PV_LEAD_NAME_ATTR');
1523: l_title := RPAD(fnd_message.get,50,' ');
1524: fnd_message.set_name('PV','PV_LEAD_ID_ATTR');
1525: l_title := l_title || RPAD(fnd_message.get,18,' ');
1526: fnd_message.set_name('PV','PV_PARTNER_NAME');
1527: l_title := l_title || RPAD(fnd_message.get,40,' ');
1528: fnd_message.set_name('PV','PV_RESOURCE_ID_ATTR');

Line 1525: l_title := l_title || RPAD(fnd_message.get,18,' ');

1521:
1522: fnd_message.set_name('PV','PV_LEAD_NAME_ATTR');
1523: l_title := RPAD(fnd_message.get,50,' ');
1524: fnd_message.set_name('PV','PV_LEAD_ID_ATTR');
1525: l_title := l_title || RPAD(fnd_message.get,18,' ');
1526: fnd_message.set_name('PV','PV_PARTNER_NAME');
1527: l_title := l_title || RPAD(fnd_message.get,40,' ');
1528: fnd_message.set_name('PV','PV_RESOURCE_ID_ATTR');
1529: l_title := l_title || RPAD(fnd_message.get,13,' ');

Line 1526: fnd_message.set_name('PV','PV_PARTNER_NAME');

1522: fnd_message.set_name('PV','PV_LEAD_NAME_ATTR');
1523: l_title := RPAD(fnd_message.get,50,' ');
1524: fnd_message.set_name('PV','PV_LEAD_ID_ATTR');
1525: l_title := l_title || RPAD(fnd_message.get,18,' ');
1526: fnd_message.set_name('PV','PV_PARTNER_NAME');
1527: l_title := l_title || RPAD(fnd_message.get,40,' ');
1528: fnd_message.set_name('PV','PV_RESOURCE_ID_ATTR');
1529: l_title := l_title || RPAD(fnd_message.get,13,' ');
1530:

Line 1527: l_title := l_title || RPAD(fnd_message.get,40,' ');

1523: l_title := RPAD(fnd_message.get,50,' ');
1524: fnd_message.set_name('PV','PV_LEAD_ID_ATTR');
1525: l_title := l_title || RPAD(fnd_message.get,18,' ');
1526: fnd_message.set_name('PV','PV_PARTNER_NAME');
1527: l_title := l_title || RPAD(fnd_message.get,40,' ');
1528: fnd_message.set_name('PV','PV_RESOURCE_ID_ATTR');
1529: l_title := l_title || RPAD(fnd_message.get,13,' ');
1530:
1531: printOutput ( l_title);

Line 1528: fnd_message.set_name('PV','PV_RESOURCE_ID_ATTR');

1524: fnd_message.set_name('PV','PV_LEAD_ID_ATTR');
1525: l_title := l_title || RPAD(fnd_message.get,18,' ');
1526: fnd_message.set_name('PV','PV_PARTNER_NAME');
1527: l_title := l_title || RPAD(fnd_message.get,40,' ');
1528: fnd_message.set_name('PV','PV_RESOURCE_ID_ATTR');
1529: l_title := l_title || RPAD(fnd_message.get,13,' ');
1530:
1531: printOutput ( l_title);
1532: printOutput(RPAD('-',120,'-'));

Line 1529: l_title := l_title || RPAD(fnd_message.get,13,' ');

1525: l_title := l_title || RPAD(fnd_message.get,18,' ');
1526: fnd_message.set_name('PV','PV_PARTNER_NAME');
1527: l_title := l_title || RPAD(fnd_message.get,40,' ');
1528: fnd_message.set_name('PV','PV_RESOURCE_ID_ATTR');
1529: l_title := l_title || RPAD(fnd_message.get,13,' ');
1530:
1531: printOutput ( l_title);
1532: printOutput(RPAD('-',120,'-'));
1533:

Line 1558: fnd_message.set_name('PV','PV_DEL_PTR_OPP_ESLSTM');

1554: INTO l_count
1555: FROM pv_access_migration_log
1556: WHERE action = 'DELETE_CORRUPT_OPP_PARTNER';
1557:
1558: fnd_message.set_name('PV','PV_DEL_PTR_OPP_ESLSTM');
1559: l_temp_msg := fnd_message.get ||' '||l_count;
1560:
1561:
1562: printOutput(RPAD('',(120-length(l_temp_msg))/2,' ')||l_temp_msg);

Line 1559: l_temp_msg := fnd_message.get ||' '||l_count;

1555: FROM pv_access_migration_log
1556: WHERE action = 'DELETE_CORRUPT_OPP_PARTNER';
1557:
1558: fnd_message.set_name('PV','PV_DEL_PTR_OPP_ESLSTM');
1559: l_temp_msg := fnd_message.get ||' '||l_count;
1560:
1561:
1562: printOutput(RPAD('',(120-length(l_temp_msg))/2,' ')||l_temp_msg);
1563: printOutput(RPAD('-',120,'-'));

Line 1588: fnd_message.set_name('PV','PV_OPP_NAME_ATTR');

1584: l_migration_tbl(i).party_name := x.party_name;
1585: l_migration_tbl(i).resource_id := x.salesforce_id;
1586: end loop;
1587:
1588: fnd_message.set_name('PV','PV_OPP_NAME_ATTR');
1589: l_title := RPAD(fnd_message.get,50,' ');
1590: fnd_message.set_name('PV','PV_OPP_NUMBER_ATTR');
1591: l_title := l_title || RPAD(fnd_message.get,18,' ');
1592: fnd_message.set_name('PV','PV_PARTNER_NAME');

Line 1589: l_title := RPAD(fnd_message.get,50,' ');

1585: l_migration_tbl(i).resource_id := x.salesforce_id;
1586: end loop;
1587:
1588: fnd_message.set_name('PV','PV_OPP_NAME_ATTR');
1589: l_title := RPAD(fnd_message.get,50,' ');
1590: fnd_message.set_name('PV','PV_OPP_NUMBER_ATTR');
1591: l_title := l_title || RPAD(fnd_message.get,18,' ');
1592: fnd_message.set_name('PV','PV_PARTNER_NAME');
1593: l_title := l_title || RPAD(fnd_message.get,40,' ');

Line 1590: fnd_message.set_name('PV','PV_OPP_NUMBER_ATTR');

1586: end loop;
1587:
1588: fnd_message.set_name('PV','PV_OPP_NAME_ATTR');
1589: l_title := RPAD(fnd_message.get,50,' ');
1590: fnd_message.set_name('PV','PV_OPP_NUMBER_ATTR');
1591: l_title := l_title || RPAD(fnd_message.get,18,' ');
1592: fnd_message.set_name('PV','PV_PARTNER_NAME');
1593: l_title := l_title || RPAD(fnd_message.get,40,' ');
1594: fnd_message.set_name('PV','PV_RESOURCE_ID_ATTR');

Line 1591: l_title := l_title || RPAD(fnd_message.get,18,' ');

1587:
1588: fnd_message.set_name('PV','PV_OPP_NAME_ATTR');
1589: l_title := RPAD(fnd_message.get,50,' ');
1590: fnd_message.set_name('PV','PV_OPP_NUMBER_ATTR');
1591: l_title := l_title || RPAD(fnd_message.get,18,' ');
1592: fnd_message.set_name('PV','PV_PARTNER_NAME');
1593: l_title := l_title || RPAD(fnd_message.get,40,' ');
1594: fnd_message.set_name('PV','PV_RESOURCE_ID_ATTR');
1595: l_title := l_title || RPAD(fnd_message.get,13,' ');

Line 1592: fnd_message.set_name('PV','PV_PARTNER_NAME');

1588: fnd_message.set_name('PV','PV_OPP_NAME_ATTR');
1589: l_title := RPAD(fnd_message.get,50,' ');
1590: fnd_message.set_name('PV','PV_OPP_NUMBER_ATTR');
1591: l_title := l_title || RPAD(fnd_message.get,18,' ');
1592: fnd_message.set_name('PV','PV_PARTNER_NAME');
1593: l_title := l_title || RPAD(fnd_message.get,40,' ');
1594: fnd_message.set_name('PV','PV_RESOURCE_ID_ATTR');
1595: l_title := l_title || RPAD(fnd_message.get,13,' ');
1596:

Line 1593: l_title := l_title || RPAD(fnd_message.get,40,' ');

1589: l_title := RPAD(fnd_message.get,50,' ');
1590: fnd_message.set_name('PV','PV_OPP_NUMBER_ATTR');
1591: l_title := l_title || RPAD(fnd_message.get,18,' ');
1592: fnd_message.set_name('PV','PV_PARTNER_NAME');
1593: l_title := l_title || RPAD(fnd_message.get,40,' ');
1594: fnd_message.set_name('PV','PV_RESOURCE_ID_ATTR');
1595: l_title := l_title || RPAD(fnd_message.get,13,' ');
1596:
1597: printOutput ( l_title);

Line 1594: fnd_message.set_name('PV','PV_RESOURCE_ID_ATTR');

1590: fnd_message.set_name('PV','PV_OPP_NUMBER_ATTR');
1591: l_title := l_title || RPAD(fnd_message.get,18,' ');
1592: fnd_message.set_name('PV','PV_PARTNER_NAME');
1593: l_title := l_title || RPAD(fnd_message.get,40,' ');
1594: fnd_message.set_name('PV','PV_RESOURCE_ID_ATTR');
1595: l_title := l_title || RPAD(fnd_message.get,13,' ');
1596:
1597: printOutput ( l_title);
1598: printOutput(RPAD('-',120,'-'));

Line 1595: l_title := l_title || RPAD(fnd_message.get,13,' ');

1591: l_title := l_title || RPAD(fnd_message.get,18,' ');
1592: fnd_message.set_name('PV','PV_PARTNER_NAME');
1593: l_title := l_title || RPAD(fnd_message.get,40,' ');
1594: fnd_message.set_name('PV','PV_RESOURCE_ID_ATTR');
1595: l_title := l_title || RPAD(fnd_message.get,13,' ');
1596:
1597: printOutput ( l_title);
1598: printOutput(RPAD('-',120,'-'));
1599:

Line 1624: fnd_message.set_name('PV','PV_INS_PTR_CUST_ESLSTM');

1620: INTO l_count
1621: FROM pv_access_migration_log
1622: WHERE action = 'INSERT_CUST_PARTY';
1623:
1624: fnd_message.set_name('PV','PV_INS_PTR_CUST_ESLSTM');
1625: l_temp_msg := fnd_message.get ||' '||l_count;
1626:
1627: printOutput(RPAD('',(120-length(l_temp_msg))/2,' ')||l_temp_msg);
1628: printOutput(RPAD('-',120,'-'));

Line 1625: l_temp_msg := fnd_message.get ||' '||l_count;

1621: FROM pv_access_migration_log
1622: WHERE action = 'INSERT_CUST_PARTY';
1623:
1624: fnd_message.set_name('PV','PV_INS_PTR_CUST_ESLSTM');
1625: l_temp_msg := fnd_message.get ||' '||l_count;
1626:
1627: printOutput(RPAD('',(120-length(l_temp_msg))/2,' ')||l_temp_msg);
1628: printOutput(RPAD('-',120,'-'));
1629: IF l_count > 0 THEN

Line 1648: fnd_message.set_name('PV','PV_CUSTOMER_NAME_ATTR');

1644: l_migration_tbl(i).entity_id := x.entity_id;
1645: l_migration_tbl(i).party_name := x.party_name;
1646: l_migration_tbl(i).resource_id := x.salesforce_id;
1647: end loop;
1648: fnd_message.set_name('PV','PV_CUSTOMER_NAME_ATTR');
1649: l_title := RPAD(fnd_message.get,50,' ');
1650: fnd_message.set_name('PV','PV_CUSTOMER_ID_ATTR');
1651: l_title := l_title || RPAD(fnd_message.get,18,' ');
1652: fnd_message.set_name('PV','PV_PARTNER_NAME');

Line 1649: l_title := RPAD(fnd_message.get,50,' ');

1645: l_migration_tbl(i).party_name := x.party_name;
1646: l_migration_tbl(i).resource_id := x.salesforce_id;
1647: end loop;
1648: fnd_message.set_name('PV','PV_CUSTOMER_NAME_ATTR');
1649: l_title := RPAD(fnd_message.get,50,' ');
1650: fnd_message.set_name('PV','PV_CUSTOMER_ID_ATTR');
1651: l_title := l_title || RPAD(fnd_message.get,18,' ');
1652: fnd_message.set_name('PV','PV_PARTNER_NAME');
1653: l_title := l_title || RPAD(fnd_message.get,40,' ');

Line 1650: fnd_message.set_name('PV','PV_CUSTOMER_ID_ATTR');

1646: l_migration_tbl(i).resource_id := x.salesforce_id;
1647: end loop;
1648: fnd_message.set_name('PV','PV_CUSTOMER_NAME_ATTR');
1649: l_title := RPAD(fnd_message.get,50,' ');
1650: fnd_message.set_name('PV','PV_CUSTOMER_ID_ATTR');
1651: l_title := l_title || RPAD(fnd_message.get,18,' ');
1652: fnd_message.set_name('PV','PV_PARTNER_NAME');
1653: l_title := l_title || RPAD(fnd_message.get,40,' ');
1654: fnd_message.set_name('PV','PV_RESOURCE_ID_ATTR');

Line 1651: l_title := l_title || RPAD(fnd_message.get,18,' ');

1647: end loop;
1648: fnd_message.set_name('PV','PV_CUSTOMER_NAME_ATTR');
1649: l_title := RPAD(fnd_message.get,50,' ');
1650: fnd_message.set_name('PV','PV_CUSTOMER_ID_ATTR');
1651: l_title := l_title || RPAD(fnd_message.get,18,' ');
1652: fnd_message.set_name('PV','PV_PARTNER_NAME');
1653: l_title := l_title || RPAD(fnd_message.get,40,' ');
1654: fnd_message.set_name('PV','PV_RESOURCE_ID_ATTR');
1655: l_title := l_title || RPAD(fnd_message.get,13,' ');

Line 1652: fnd_message.set_name('PV','PV_PARTNER_NAME');

1648: fnd_message.set_name('PV','PV_CUSTOMER_NAME_ATTR');
1649: l_title := RPAD(fnd_message.get,50,' ');
1650: fnd_message.set_name('PV','PV_CUSTOMER_ID_ATTR');
1651: l_title := l_title || RPAD(fnd_message.get,18,' ');
1652: fnd_message.set_name('PV','PV_PARTNER_NAME');
1653: l_title := l_title || RPAD(fnd_message.get,40,' ');
1654: fnd_message.set_name('PV','PV_RESOURCE_ID_ATTR');
1655: l_title := l_title || RPAD(fnd_message.get,13,' ');
1656:

Line 1653: l_title := l_title || RPAD(fnd_message.get,40,' ');

1649: l_title := RPAD(fnd_message.get,50,' ');
1650: fnd_message.set_name('PV','PV_CUSTOMER_ID_ATTR');
1651: l_title := l_title || RPAD(fnd_message.get,18,' ');
1652: fnd_message.set_name('PV','PV_PARTNER_NAME');
1653: l_title := l_title || RPAD(fnd_message.get,40,' ');
1654: fnd_message.set_name('PV','PV_RESOURCE_ID_ATTR');
1655: l_title := l_title || RPAD(fnd_message.get,13,' ');
1656:
1657: printOutput ( l_title);

Line 1654: fnd_message.set_name('PV','PV_RESOURCE_ID_ATTR');

1650: fnd_message.set_name('PV','PV_CUSTOMER_ID_ATTR');
1651: l_title := l_title || RPAD(fnd_message.get,18,' ');
1652: fnd_message.set_name('PV','PV_PARTNER_NAME');
1653: l_title := l_title || RPAD(fnd_message.get,40,' ');
1654: fnd_message.set_name('PV','PV_RESOURCE_ID_ATTR');
1655: l_title := l_title || RPAD(fnd_message.get,13,' ');
1656:
1657: printOutput ( l_title);
1658: printOutput(RPAD('-',120,'-'));

Line 1655: l_title := l_title || RPAD(fnd_message.get,13,' ');

1651: l_title := l_title || RPAD(fnd_message.get,18,' ');
1652: fnd_message.set_name('PV','PV_PARTNER_NAME');
1653: l_title := l_title || RPAD(fnd_message.get,40,' ');
1654: fnd_message.set_name('PV','PV_RESOURCE_ID_ATTR');
1655: l_title := l_title || RPAD(fnd_message.get,13,' ');
1656:
1657: printOutput ( l_title);
1658: printOutput(RPAD('-',120,'-'));
1659:

Line 1684: fnd_message.set_name('PV','PV_INS_PTR_LEAD_ESLSTM');

1680: INTO l_count
1681: FROM pv_access_migration_log
1682: WHERE action = 'INSERT_LEAD_PARTY';
1683:
1684: fnd_message.set_name('PV','PV_INS_PTR_LEAD_ESLSTM');
1685: l_temp_msg := fnd_message.get ||' '||l_count;
1686:
1687: printOutput(RPAD('',(120-length(l_temp_msg))/2,' ')||l_temp_msg);
1688: printOutput(RPAD('-',120,'-'));

Line 1685: l_temp_msg := fnd_message.get ||' '||l_count;

1681: FROM pv_access_migration_log
1682: WHERE action = 'INSERT_LEAD_PARTY';
1683:
1684: fnd_message.set_name('PV','PV_INS_PTR_LEAD_ESLSTM');
1685: l_temp_msg := fnd_message.get ||' '||l_count;
1686:
1687: printOutput(RPAD('',(120-length(l_temp_msg))/2,' ')||l_temp_msg);
1688: printOutput(RPAD('-',120,'-'));
1689: IF l_count > 0 THEN

Line 1709: fnd_message.set_name('PV','PV_LEAD_NAME_ATTR');

1705: l_migration_tbl(i).party_name := x.party_name;
1706: l_migration_tbl(i).resource_id := x.salesforce_id;
1707: end loop;
1708:
1709: fnd_message.set_name('PV','PV_LEAD_NAME_ATTR');
1710: l_title := RPAD(fnd_message.get,50,' ');
1711: fnd_message.set_name('PV','PV_LEAD_ID_ATTR');
1712: l_title := l_title || RPAD(fnd_message.get,18,' ');
1713: fnd_message.set_name('PV','PV_PARTNER_NAME');

Line 1710: l_title := RPAD(fnd_message.get,50,' ');

1706: l_migration_tbl(i).resource_id := x.salesforce_id;
1707: end loop;
1708:
1709: fnd_message.set_name('PV','PV_LEAD_NAME_ATTR');
1710: l_title := RPAD(fnd_message.get,50,' ');
1711: fnd_message.set_name('PV','PV_LEAD_ID_ATTR');
1712: l_title := l_title || RPAD(fnd_message.get,18,' ');
1713: fnd_message.set_name('PV','PV_PARTNER_NAME');
1714: l_title := l_title || RPAD(fnd_message.get,40,' ');

Line 1711: fnd_message.set_name('PV','PV_LEAD_ID_ATTR');

1707: end loop;
1708:
1709: fnd_message.set_name('PV','PV_LEAD_NAME_ATTR');
1710: l_title := RPAD(fnd_message.get,50,' ');
1711: fnd_message.set_name('PV','PV_LEAD_ID_ATTR');
1712: l_title := l_title || RPAD(fnd_message.get,18,' ');
1713: fnd_message.set_name('PV','PV_PARTNER_NAME');
1714: l_title := l_title || RPAD(fnd_message.get,40,' ');
1715: fnd_message.set_name('PV','PV_RESOURCE_ID_ATTR');

Line 1712: l_title := l_title || RPAD(fnd_message.get,18,' ');

1708:
1709: fnd_message.set_name('PV','PV_LEAD_NAME_ATTR');
1710: l_title := RPAD(fnd_message.get,50,' ');
1711: fnd_message.set_name('PV','PV_LEAD_ID_ATTR');
1712: l_title := l_title || RPAD(fnd_message.get,18,' ');
1713: fnd_message.set_name('PV','PV_PARTNER_NAME');
1714: l_title := l_title || RPAD(fnd_message.get,40,' ');
1715: fnd_message.set_name('PV','PV_RESOURCE_ID_ATTR');
1716: l_title := l_title || RPAD(fnd_message.get,13,' ');

Line 1713: fnd_message.set_name('PV','PV_PARTNER_NAME');

1709: fnd_message.set_name('PV','PV_LEAD_NAME_ATTR');
1710: l_title := RPAD(fnd_message.get,50,' ');
1711: fnd_message.set_name('PV','PV_LEAD_ID_ATTR');
1712: l_title := l_title || RPAD(fnd_message.get,18,' ');
1713: fnd_message.set_name('PV','PV_PARTNER_NAME');
1714: l_title := l_title || RPAD(fnd_message.get,40,' ');
1715: fnd_message.set_name('PV','PV_RESOURCE_ID_ATTR');
1716: l_title := l_title || RPAD(fnd_message.get,13,' ');
1717:

Line 1714: l_title := l_title || RPAD(fnd_message.get,40,' ');

1710: l_title := RPAD(fnd_message.get,50,' ');
1711: fnd_message.set_name('PV','PV_LEAD_ID_ATTR');
1712: l_title := l_title || RPAD(fnd_message.get,18,' ');
1713: fnd_message.set_name('PV','PV_PARTNER_NAME');
1714: l_title := l_title || RPAD(fnd_message.get,40,' ');
1715: fnd_message.set_name('PV','PV_RESOURCE_ID_ATTR');
1716: l_title := l_title || RPAD(fnd_message.get,13,' ');
1717:
1718: printOutput ( l_title);

Line 1715: fnd_message.set_name('PV','PV_RESOURCE_ID_ATTR');

1711: fnd_message.set_name('PV','PV_LEAD_ID_ATTR');
1712: l_title := l_title || RPAD(fnd_message.get,18,' ');
1713: fnd_message.set_name('PV','PV_PARTNER_NAME');
1714: l_title := l_title || RPAD(fnd_message.get,40,' ');
1715: fnd_message.set_name('PV','PV_RESOURCE_ID_ATTR');
1716: l_title := l_title || RPAD(fnd_message.get,13,' ');
1717:
1718: printOutput ( l_title);
1719: printOutput(RPAD('-',120,'-'));

Line 1716: l_title := l_title || RPAD(fnd_message.get,13,' ');

1712: l_title := l_title || RPAD(fnd_message.get,18,' ');
1713: fnd_message.set_name('PV','PV_PARTNER_NAME');
1714: l_title := l_title || RPAD(fnd_message.get,40,' ');
1715: fnd_message.set_name('PV','PV_RESOURCE_ID_ATTR');
1716: l_title := l_title || RPAD(fnd_message.get,13,' ');
1717:
1718: printOutput ( l_title);
1719: printOutput(RPAD('-',120,'-'));
1720:

Line 1745: fnd_message.set_name('PV','PV_INS_PTR_OPP_ESLSTM');

1741: INTO l_count
1742: FROM pv_access_migration_log
1743: WHERE action IN ('INSERT_OPP_PARTY','INSERT_OPP_PRFRD_PT','INSERT_OPP_SAVED_PT','INSERT_OPP_ASSIGNED_PT');
1744:
1745: fnd_message.set_name('PV','PV_INS_PTR_OPP_ESLSTM');
1746: l_temp_msg := fnd_message.get ||' '||l_count;
1747:
1748:
1749: printOutput(RPAD('',(120-length(l_temp_msg))/2,' ')||l_temp_msg);

Line 1746: l_temp_msg := fnd_message.get ||' '||l_count;

1742: FROM pv_access_migration_log
1743: WHERE action IN ('INSERT_OPP_PARTY','INSERT_OPP_PRFRD_PT','INSERT_OPP_SAVED_PT','INSERT_OPP_ASSIGNED_PT');
1744:
1745: fnd_message.set_name('PV','PV_INS_PTR_OPP_ESLSTM');
1746: l_temp_msg := fnd_message.get ||' '||l_count;
1747:
1748:
1749: printOutput(RPAD('',(120-length(l_temp_msg))/2,' ')||l_temp_msg);
1750: printOutput(RPAD('-',120,'-'));

Line 1775: fnd_message.set_name('PV','PV_OPP_NAME_ATTR');

1771: l_migration_tbl(i).party_name := x.party_name;
1772: l_migration_tbl(i).resource_id := x.salesforce_id;
1773: end loop;
1774:
1775: fnd_message.set_name('PV','PV_OPP_NAME_ATTR');
1776: l_title := RPAD(fnd_message.get,50,' ');
1777: fnd_message.set_name('PV','PV_OPP_NUMBER_ATTR');
1778: l_title := l_title || RPAD(fnd_message.get,18,' ');
1779: fnd_message.set_name('PV','PV_PARTNER_NAME');

Line 1776: l_title := RPAD(fnd_message.get,50,' ');

1772: l_migration_tbl(i).resource_id := x.salesforce_id;
1773: end loop;
1774:
1775: fnd_message.set_name('PV','PV_OPP_NAME_ATTR');
1776: l_title := RPAD(fnd_message.get,50,' ');
1777: fnd_message.set_name('PV','PV_OPP_NUMBER_ATTR');
1778: l_title := l_title || RPAD(fnd_message.get,18,' ');
1779: fnd_message.set_name('PV','PV_PARTNER_NAME');
1780: l_title := l_title || RPAD(fnd_message.get,40,' ');

Line 1777: fnd_message.set_name('PV','PV_OPP_NUMBER_ATTR');

1773: end loop;
1774:
1775: fnd_message.set_name('PV','PV_OPP_NAME_ATTR');
1776: l_title := RPAD(fnd_message.get,50,' ');
1777: fnd_message.set_name('PV','PV_OPP_NUMBER_ATTR');
1778: l_title := l_title || RPAD(fnd_message.get,18,' ');
1779: fnd_message.set_name('PV','PV_PARTNER_NAME');
1780: l_title := l_title || RPAD(fnd_message.get,40,' ');
1781: fnd_message.set_name('PV','PV_RESOURCE_ID_ATTR');

Line 1778: l_title := l_title || RPAD(fnd_message.get,18,' ');

1774:
1775: fnd_message.set_name('PV','PV_OPP_NAME_ATTR');
1776: l_title := RPAD(fnd_message.get,50,' ');
1777: fnd_message.set_name('PV','PV_OPP_NUMBER_ATTR');
1778: l_title := l_title || RPAD(fnd_message.get,18,' ');
1779: fnd_message.set_name('PV','PV_PARTNER_NAME');
1780: l_title := l_title || RPAD(fnd_message.get,40,' ');
1781: fnd_message.set_name('PV','PV_RESOURCE_ID_ATTR');
1782: l_title := l_title || RPAD(fnd_message.get,13,' ');

Line 1779: fnd_message.set_name('PV','PV_PARTNER_NAME');

1775: fnd_message.set_name('PV','PV_OPP_NAME_ATTR');
1776: l_title := RPAD(fnd_message.get,50,' ');
1777: fnd_message.set_name('PV','PV_OPP_NUMBER_ATTR');
1778: l_title := l_title || RPAD(fnd_message.get,18,' ');
1779: fnd_message.set_name('PV','PV_PARTNER_NAME');
1780: l_title := l_title || RPAD(fnd_message.get,40,' ');
1781: fnd_message.set_name('PV','PV_RESOURCE_ID_ATTR');
1782: l_title := l_title || RPAD(fnd_message.get,13,' ');
1783:

Line 1780: l_title := l_title || RPAD(fnd_message.get,40,' ');

1776: l_title := RPAD(fnd_message.get,50,' ');
1777: fnd_message.set_name('PV','PV_OPP_NUMBER_ATTR');
1778: l_title := l_title || RPAD(fnd_message.get,18,' ');
1779: fnd_message.set_name('PV','PV_PARTNER_NAME');
1780: l_title := l_title || RPAD(fnd_message.get,40,' ');
1781: fnd_message.set_name('PV','PV_RESOURCE_ID_ATTR');
1782: l_title := l_title || RPAD(fnd_message.get,13,' ');
1783:
1784: printOutput ( l_title);

Line 1781: fnd_message.set_name('PV','PV_RESOURCE_ID_ATTR');

1777: fnd_message.set_name('PV','PV_OPP_NUMBER_ATTR');
1778: l_title := l_title || RPAD(fnd_message.get,18,' ');
1779: fnd_message.set_name('PV','PV_PARTNER_NAME');
1780: l_title := l_title || RPAD(fnd_message.get,40,' ');
1781: fnd_message.set_name('PV','PV_RESOURCE_ID_ATTR');
1782: l_title := l_title || RPAD(fnd_message.get,13,' ');
1783:
1784: printOutput ( l_title);
1785: printOutput(RPAD('-',120,'-'));

Line 1782: l_title := l_title || RPAD(fnd_message.get,13,' ');

1778: l_title := l_title || RPAD(fnd_message.get,18,' ');
1779: fnd_message.set_name('PV','PV_PARTNER_NAME');
1780: l_title := l_title || RPAD(fnd_message.get,40,' ');
1781: fnd_message.set_name('PV','PV_RESOURCE_ID_ATTR');
1782: l_title := l_title || RPAD(fnd_message.get,13,' ');
1783:
1784: printOutput ( l_title);
1785: printOutput(RPAD('-',120,'-'));
1786: