DBA Data[Home] [Help]

APPS.INV_MIGRATE_PROCESS_ORG dependencies on FND_LOG

Line 67: -- p_log_level => FND_LOG.LEVEL_PROCEDURE,

63: -- Bug 5727749 T.Cataldo 5-April-2007 Remove calls to the central
64: -- logging API that are already handled by the calling layer.
65: -- GMA_COMMON_LOGGING.gma_migration_central_log (
66: -- p_run_id => l_migration_id,
67: -- p_log_level => FND_LOG.LEVEL_PROCEDURE,
68: -- p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
69: -- p_table_name => 'IC_WHSE_MST',
70: -- p_context => 'WHSE_SYNC',
71: -- p_app_short_name => 'GMA');

Line 168: -- p_log_level => FND_LOG.LEVEL_PROCEDURE,

164: -- Bug 5727749 T.Cataldo 5-April-2007 Remove calls to the central
165: -- logging API that are already handled by the calling layer.
166: -- GMA_COMMON_LOGGING.gma_migration_central_log (
167: -- p_run_id => l_migration_id,
168: -- p_log_level => FND_LOG.LEVEL_PROCEDURE,
169: -- p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
170: -- p_table_name => 'IC_WHSE_MST',
171: -- p_context => 'WHSE_SYNC',
172: -- p_app_short_name => 'GMA');

Line 179: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

175: WHEN OTHERS THEN
176: x_failure_count := x_failure_count + 1;
177: GMA_COMMON_LOGGING.gma_migration_central_log (
178: p_run_id => l_migration_id,
179: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
180: p_message_token => 'GMA_MIGRATION_DB_ERROR',
181: p_table_name => 'IC_WHSE_MST',
182: p_context => 'WHSE_SYNC',
183: p_db_error => SQLERRM,

Line 190: -- p_log_level => FND_LOG.LEVEL_PROCEDURE,

186: -- Bug 5727749 T.Cataldo 5-April-2007 Remove calls to the central
187: -- logging API that are already handled by the calling layer.
188: -- GMA_COMMON_LOGGING.gma_migration_central_log (
189: -- p_run_id => l_migration_id,
190: -- p_log_level => FND_LOG.LEVEL_PROCEDURE,
191: -- p_message_token => 'GMA_MIGRATION_TABLE_FAIL',
192: -- p_table_name => 'IC_WHSE_MST',
193: -- p_context => 'WHSE_SYNC',
194: -- p_app_short_name => 'GMA');

Line 263: p_log_level => FND_LOG.LEVEL_PROCEDURE,

259: l_migrate_count := 0; /* Bug 5727749 */
260:
261: GMA_COMMON_LOGGING.gma_migration_central_log (
262: p_run_id => l_migration_id,
263: p_log_level => FND_LOG.LEVEL_PROCEDURE,
264: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
265: p_table_name => 'MTL_PARAMETERS',
266: p_context => 'ORGANIZATION',
267: p_app_short_name => 'GMA');

Line 345: p_log_level => FND_LOG.LEVEL_PROCEDURE,

341: END LOOP;
342:
343: GMA_COMMON_LOGGING.gma_migration_central_log (
344: p_run_id => l_migration_id,
345: p_log_level => FND_LOG.LEVEL_PROCEDURE,
346: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
347: p_table_name => 'MTL_PARAMETERS',
348: p_context => 'ORGANIZATION',
349: p_param1 => l_migrate_count,

Line 362: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

358: ROLLBACK;
359: x_failure_count := x_failure_count + 1;
360: GMA_COMMON_LOGGING.gma_migration_central_log (
361: p_run_id => l_migration_id,
362: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
363: p_message_token => 'GMA_MIGRATION_DB_ERROR',
364: p_table_name => 'MTL_PARAMETERS',
365: p_context => 'ORGANIZATION',
366: p_db_error => SQLERRM,

Line 371: p_log_level => FND_LOG.LEVEL_PROCEDURE,

367: p_app_short_name => 'GMA');
368:
369: GMA_COMMON_LOGGING.gma_migration_central_log (
370: p_run_id => l_migration_id,
371: p_log_level => FND_LOG.LEVEL_PROCEDURE,
372: p_message_token => 'GMA_MIGRATION_TABLE_FAIL',
373: p_table_name => 'MTL_PARAMETERS',
374: p_context => 'ORGANIZATION',
375: p_app_short_name => 'GMA');

Line 565: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

561: WHEN OTHERS THEN
562: x_failure_count := x_failure_count + 1;
563: GMA_COMMON_LOGGING.gma_migration_central_log (
564: p_run_id => l_migration_id,
565: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
566: p_message_token => 'GMA_MIGRATION_DB_ERROR',
567: p_table_name => 'IC_LOCT_MST',
568: p_context => 'LOCATION',
569: p_db_error => SQLERRM,

Line 574: p_log_level => FND_LOG.LEVEL_PROCEDURE,

570: p_app_short_name => 'GMA');
571:
572: GMA_COMMON_LOGGING.gma_migration_central_log (
573: p_run_id => l_migration_id,
574: p_log_level => FND_LOG.LEVEL_PROCEDURE,
575: p_message_token => 'GMA_MIGRATION_TABLE_FAIL',
576: p_table_name => 'IC_LOCT_MST',
577: p_context => 'LOCATION',
578: p_app_short_name => 'GMA');

Line 649: -- p_log_level => FND_LOG.LEVEL_PROCEDURE,

645: -- Bug 5727749 T.Cataldo 5-April-2007 Remove calls to the central
646: -- logging API that are already handled by the calling layer.
647: -- GMA_COMMON_LOGGING.gma_migration_central_log (
648: -- p_run_id => l_migration_id,
649: -- p_log_level => FND_LOG.LEVEL_PROCEDURE,
650: -- p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
651: -- p_table_name => 'IC_LOCT_MST',
652: -- p_context => 'LOCATION',
653: -- p_app_short_name => 'GMA');

Line 710: -- p_log_level => FND_LOG.LEVEL_PROCEDURE,

706: -- Bug 5727749 T.Cataldo 5-April-2007 Remove calls to the central
707: -- logging API that are already handled by the calling layer.
708: -- GMA_COMMON_LOGGING.gma_migration_central_log (
709: -- p_run_id => l_migration_id,
710: -- p_log_level => FND_LOG.LEVEL_PROCEDURE,
711: -- p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
712: -- p_table_name => 'IC_LOCT_MST',
713: -- p_context => 'LOCATION',
714: -- p_app_short_name => 'GMA');

Line 724: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

720: WHEN OTHERS THEN
721: x_failure_count := x_failure_count + l_failure_count;
722: GMA_COMMON_LOGGING.gma_migration_central_log (
723: p_run_id => l_migration_id,
724: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
725: p_message_token => 'GMA_MIGRATION_DB_ERROR',
726: p_table_name => 'IC_LOCT_MST',
727: p_context => 'LOCATION',
728: p_db_error => SQLERRM,

Line 735: -- p_log_level => FND_LOG.LEVEL_PROCEDURE,

731: -- Bug 5727749 T.Cataldo 5-April-2007 Remove calls to the central
732: -- logging API that are already handled by the calling layer.
733: -- GMA_COMMON_LOGGING.gma_migration_central_log (
734: -- p_run_id => l_migration_id,
735: -- p_log_level => FND_LOG.LEVEL_PROCEDURE,
736: -- p_message_token => 'GMA_MIGRATION_TABLE_FAIL',
737: -- p_table_name => 'IC_LOCT_MST',
738: -- p_context => 'LOCATION',
739: -- p_app_short_name => 'GMA');

Line 827: -- p_log_level => FND_LOG.LEVEL_PROCEDURE,

823: -- Bug 5727749 T.Cataldo 5-April-2007 Remove calls to the central
824: -- logging API that are already handled by the calling layer.
825: -- GMA_COMMON_LOGGING.gma_migration_central_log (
826: -- p_run_id => l_migration_id,
827: -- p_log_level => FND_LOG.LEVEL_PROCEDURE,
828: -- p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
829: -- p_table_name => 'IC_WHSE_MST',
830: -- p_context => 'WAREHOUSE',
831: -- p_app_short_name => 'GMA');

Line 874: p_log_level => FND_LOG.LEVEL_PROCEDURE,

870: AND secondary_inventory_name = l_rec.whse_code;
871:
872: GMA_COMMON_LOGGING.gma_migration_central_log (
873: p_run_id => l_migration_id,
874: p_log_level => FND_LOG.LEVEL_PROCEDURE,
875: p_message_token => 'GMA_WHSE_EXISTS',
876: p_table_name => 'IC_WHSE_MST',
877: p_context => 'WAREHOUSE',
878: p_token1 => 'WAREHOUSE',

Line 988: p_log_level => FND_LOG.LEVEL_ERROR,

984: WHEN ORGN_NOT_MIGRATED THEN
985: x_failure_count := x_failure_count + 1;
986: GMA_COMMON_LOGGING.gma_migration_central_log (
987: p_run_id => l_migration_id,
988: p_log_level => FND_LOG.LEVEL_ERROR,
989: p_message_token => 'GMD_ORG_NOT_MIGRATED',
990: p_table_name => 'IC_WHSE_MST',
991: p_context => 'WAREHOUSE',
992: p_token1 => 'ORGANIZATION',

Line 1001: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

997: x_failure_count := x_failure_count + 1;
998:
999: GMA_COMMON_LOGGING.gma_migration_central_log (
1000: p_run_id => l_migration_id,
1001: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
1002: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1003: p_table_name => 'IC_WHSE_MST',
1004: p_context => 'WAREHOUSE',
1005: p_db_error => SQLERRM,

Line 1014: -- p_log_level => FND_LOG.LEVEL_PROCEDURE,

1010: -- Bug 5727749 T.Cataldo 5-April-2007 Remove calls to the central
1011: -- logging API that are already handled by the calling layer.
1012: -- GMA_COMMON_LOGGING.gma_migration_central_log (
1013: -- p_run_id => l_migration_id,
1014: -- p_log_level => FND_LOG.LEVEL_PROCEDURE,
1015: -- p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
1016: -- p_table_name => 'IC_WHSE_MST',
1017: -- p_context => 'WAREHOUSE',
1018: -- p_app_short_name => 'GMA');

Line 1027: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

1023: x_failure_count := x_failure_count + 1;
1024:
1025: GMA_COMMON_LOGGING.gma_migration_central_log (
1026: p_run_id => l_migration_id,
1027: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
1028: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1029: p_table_name => 'IC_WHSE_MST',
1030: p_context => 'WAREHOUSE',
1031: p_db_error => SQLERRM,

Line 1038: -- p_log_level => FND_LOG.LEVEL_PROCEDURE,

1034: -- Bug 5727749 T.Cataldo 5-April-2007 Remove calls to the central
1035: -- logging API that are already handled by the calling layer.
1036: -- GMA_COMMON_LOGGING.gma_migration_central_log (
1037: -- p_run_id => l_migration_id,
1038: -- p_log_level => FND_LOG.LEVEL_PROCEDURE,
1039: -- p_message_token => 'GMA_MIGRATION_TABLE_FAIL',
1040: -- p_table_name => 'IC_WHSE_MST',
1041: -- p_context => 'WAREHOUSE',
1042: -- p_app_short_name => 'GMA');

Line 1483: p_log_level => FND_LOG.LEVEL_ERROR,

1479: WHEN ORGN_MISSING THEN
1480: x_failure_count := x_failure_count + 1;
1481: GMA_COMMON_LOGGING.gma_migration_central_log (
1482: p_run_id => P_migration_run_id,
1483: p_log_level => FND_LOG.LEVEL_ERROR,
1484: p_message_token => 'GMA_TEMP_ORGN_MISSING_ERROR',
1485: p_table_name => 'SY_ORGN_MST',
1486: p_context => 'ORGANIZATION',
1487: p_token1 => 'ORGANIZATION',

Line 1495: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

1491: WHEN COST_GROUP_SETUP_ERR THEN
1492: x_failure_count := x_failure_count + 1;
1493: GMA_COMMON_LOGGING.gma_migration_central_log (
1494: p_run_id => P_migration_run_id,
1495: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
1496: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1497: p_table_name => 'SY_ORGN_MST',
1498: p_context => 'ORGANIZATION',
1499: p_db_error => p_orgn_code||'-'||l_msg_data,

Line 1507: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

1503: x_failure_count := x_failure_count + 1;
1504:
1505: GMA_COMMON_LOGGING.gma_migration_central_log (
1506: p_run_id => P_migration_run_id,
1507: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
1508: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1509: p_table_name => 'SY_ORGN_MST',
1510: p_context => 'ORGANIZATION',
1511: p_db_error => SQLERRM,

Line 1583: p_log_level => FND_LOG.LEVEL_PROCEDURE,

1579:
1580:
1581: GMA_COMMON_LOGGING.gma_migration_central_log (
1582: p_run_id => l_migration_id,
1583: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1584: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
1585: p_table_name => 'SY_ORGN_MST',
1586: p_context => 'ORGANIZATION',
1587: p_app_short_name => 'GMA');

Line 1659: p_log_level => FND_LOG.LEVEL_ERROR,

1655: x_failure_count := x_failure_count + 1;
1656: ROLLBACK TO Organization_Setup;
1657: GMA_COMMON_LOGGING.gma_migration_central_log (
1658: p_run_id => l_migration_id,
1659: p_log_level => FND_LOG.LEVEL_ERROR,
1660: p_message_token => 'GMA_ORGN_MISSING_ERROR',
1661: p_table_name => 'SY_ORGN_MST',
1662: p_context => 'ORGANIZATION',
1663: p_token1 => 'ORGANIZATION',

Line 1670: p_log_level => FND_LOG.LEVEL_ERROR,

1666:
1667: WHEN WHSE_CODE_ERROR THEN
1668: GMA_COMMON_LOGGING.gma_migration_central_log (
1669: p_run_id => l_migration_id,
1670: p_log_level => FND_LOG.LEVEL_ERROR,
1671: p_message_token => 'GMA_MIGRATION_FAIL',
1672: p_token1 => 'PARAM1',
1673: p_param1 => 'due to an error in migrating the W/H as a subinventory',
1674: p_context => 'ORGANIZATION',

Line 1682: p_log_level => FND_LOG.LEVEL_ERROR,

1678: WHEN DEFAULT_STATUS_MISSING THEN
1679: x_failure_count := x_failure_count + 1;
1680: GMA_COMMON_LOGGING.gma_migration_central_log(
1681: p_run_id => P_migration_run_id,
1682: p_log_level => FND_LOG.LEVEL_ERROR,
1683: p_message_token => 'GMA_DEFAULT_STATUS_MISSING_ERROR',
1684: p_table_name => 'SY_ORGN_MST',
1685: p_context => 'ORGANIZATION',
1686: p_token1 => 'ORGANIZATION',

Line 1695: p_log_level => FND_LOG.LEVEL_ERROR,

1691: WHEN STATUS_ID_MISSING THEN
1692: x_failure_count := x_failure_count + 1;
1693: GMA_COMMON_LOGGING.gma_migration_central_log(
1694: p_run_id => P_migration_run_id,
1695: p_log_level => FND_LOG.LEVEL_ERROR,
1696: p_message_token => 'GMD_MIG_STATUS_ID',
1697: p_table_name => 'MTL_MATERIAL_STATUSES',
1698: p_context => 'STAT',
1699: p_token1 => 'STAT',

Line 1708: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

1704: x_failure_count := x_failure_count + 1;
1705: ROLLBACK TO Organization_Setup;
1706: GMA_COMMON_LOGGING.gma_migration_central_log (
1707: p_run_id => l_migration_id,
1708: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
1709: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1710: p_table_name => 'SY_ORGN_MST',
1711: p_context => 'ORGANIZATION',
1712: p_db_error => SQLERRM,

Line 1719: p_log_level => FND_LOG.LEVEL_PROCEDURE,

1715: END LOOP;
1716:
1717: GMA_COMMON_LOGGING.gma_migration_central_log (
1718: p_run_id => l_migration_id,
1719: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1720: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
1721: p_table_name => 'SY_ORGN_MST',
1722: p_context => 'ORGANIZATION',
1723: p_param1 => l_migrate_count,

Line 1734: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

1730: x_failure_count := X_failure_count + 1;
1731:
1732: GMA_COMMON_LOGGING.gma_migration_central_log (
1733: p_run_id => l_migration_id,
1734: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
1735: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1736: p_table_name => 'SY_ORGN_MST',
1737: p_context => 'ORGANIZATION',
1738: p_db_error => SQLERRM,

Line 1743: p_log_level => FND_LOG.LEVEL_PROCEDURE,

1739: p_app_short_name => 'GMA');
1740:
1741: GMA_COMMON_LOGGING.gma_migration_central_log (
1742: p_run_id => l_migration_id,
1743: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1744: p_message_token => 'GMA_MIGRATION_TABLE_FAIL',
1745: p_table_name => 'SY_ORGN_MST',
1746: p_context => 'ORGANIZATION',
1747: p_app_short_name => 'GMA');