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 1505: p_log_level => FND_LOG.LEVEL_ERROR,

1501: WHEN ORGN_MISSING THEN
1502: x_failure_count := x_failure_count + 1;
1503: GMA_COMMON_LOGGING.gma_migration_central_log (
1504: p_run_id => P_migration_run_id,
1505: p_log_level => FND_LOG.LEVEL_ERROR,
1506: p_message_token => 'GMA_TEMP_ORGN_MISSING_ERROR',
1507: p_table_name => 'SY_ORGN_MST',
1508: p_context => 'ORGANIZATION',
1509: p_token1 => 'ORGANIZATION',

Line 1517: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

1513: WHEN COST_GROUP_SETUP_ERR THEN
1514: x_failure_count := x_failure_count + 1;
1515: GMA_COMMON_LOGGING.gma_migration_central_log (
1516: p_run_id => P_migration_run_id,
1517: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
1518: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1519: p_table_name => 'SY_ORGN_MST',
1520: p_context => 'ORGANIZATION',
1521: p_db_error => p_orgn_code||'-'||l_msg_data,

Line 1528: p_log_level => FND_LOG.LEVEL_ERROR,

1524: WHEN ORGN_CODE_EXISTING THEN
1525: x_failure_count := x_failure_count + 1;
1526: GMA_COMMON_LOGGING.gma_migration_central_log (
1527: p_run_id => P_migration_run_id,
1528: p_log_level => FND_LOG.LEVEL_ERROR,
1529: p_message_token => 'INV_ALREADY_EXISTS',
1530: p_table_name => 'SY_ORGN_MST',
1531: p_context => 'ORGANIZATION',
1532: p_param1 => P_organization_code,

Line 1541: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

1537: x_failure_count := x_failure_count + 1;
1538:
1539: GMA_COMMON_LOGGING.gma_migration_central_log (
1540: p_run_id => P_migration_run_id,
1541: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
1542: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1543: p_table_name => 'SY_ORGN_MST',
1544: p_context => 'ORGANIZATION',
1545: p_db_error => SQLERRM,

Line 1624: p_log_level => FND_LOG.LEVEL_PROCEDURE,

1620:
1621:
1622: GMA_COMMON_LOGGING.gma_migration_central_log (
1623: p_run_id => l_migration_id,
1624: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1625: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
1626: p_table_name => 'SY_ORGN_MST',
1627: p_context => 'ORGANIZATION',
1628: p_app_short_name => 'GMA');

Line 1717: p_log_level => FND_LOG.LEVEL_ERROR,

1713: x_failure_count := x_failure_count + 1;
1714: ROLLBACK TO Organization_Setup;
1715: GMA_COMMON_LOGGING.gma_migration_central_log (
1716: p_run_id => l_migration_id,
1717: p_log_level => FND_LOG.LEVEL_ERROR,
1718: p_message_token => 'GMA_ORGN_MISSING_ERROR',
1719: p_table_name => 'SY_ORGN_MST',
1720: p_context => 'ORGANIZATION',
1721: p_token1 => 'ORGANIZATION',

Line 1728: p_log_level => FND_LOG.LEVEL_ERROR,

1724:
1725: WHEN WHSE_CODE_ERROR THEN
1726: GMA_COMMON_LOGGING.gma_migration_central_log (
1727: p_run_id => l_migration_id,
1728: p_log_level => FND_LOG.LEVEL_ERROR,
1729: p_message_token => 'GMA_MIGRATION_FAIL',
1730: p_token1 => 'PARAM1',
1731: p_param1 => 'due to an error in migrating the W/H as a subinventory',
1732: p_context => 'ORGANIZATION',

Line 1740: p_log_level => FND_LOG.LEVEL_ERROR,

1736: WHEN DEFAULT_STATUS_MISSING THEN
1737: x_failure_count := x_failure_count + 1;
1738: GMA_COMMON_LOGGING.gma_migration_central_log(
1739: p_run_id => P_migration_run_id,
1740: p_log_level => FND_LOG.LEVEL_ERROR,
1741: p_message_token => 'GMA_DEFAULT_STATUS_MISSING_ERROR',
1742: p_table_name => 'SY_ORGN_MST',
1743: p_context => 'ORGANIZATION',
1744: p_token1 => 'ORGANIZATION',

Line 1753: p_log_level => FND_LOG.LEVEL_ERROR,

1749: WHEN STATUS_ID_MISSING THEN
1750: x_failure_count := x_failure_count + 1;
1751: GMA_COMMON_LOGGING.gma_migration_central_log(
1752: p_run_id => P_migration_run_id,
1753: p_log_level => FND_LOG.LEVEL_ERROR,
1754: p_message_token => 'GMD_MIG_STATUS_ID',
1755: p_table_name => 'MTL_MATERIAL_STATUSES',
1756: p_context => 'STAT',
1757: p_token1 => 'STAT',

Line 1766: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

1762: x_failure_count := x_failure_count + 1;
1763: ROLLBACK TO Organization_Setup;
1764: GMA_COMMON_LOGGING.gma_migration_central_log (
1765: p_run_id => l_migration_id,
1766: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
1767: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1768: p_table_name => 'SY_ORGN_MST',
1769: p_context => 'ORGANIZATION',
1770: p_db_error => SQLERRM,

Line 1777: p_log_level => FND_LOG.LEVEL_PROCEDURE,

1773: END LOOP;
1774:
1775: GMA_COMMON_LOGGING.gma_migration_central_log (
1776: p_run_id => l_migration_id,
1777: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1778: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
1779: p_table_name => 'SY_ORGN_MST',
1780: p_context => 'ORGANIZATION',
1781: p_param1 => l_migrate_count,

Line 1792: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

1788: x_failure_count := X_failure_count + 1;
1789:
1790: GMA_COMMON_LOGGING.gma_migration_central_log (
1791: p_run_id => l_migration_id,
1792: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
1793: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1794: p_table_name => 'SY_ORGN_MST',
1795: p_context => 'ORGANIZATION',
1796: p_db_error => SQLERRM,

Line 1801: p_log_level => FND_LOG.LEVEL_PROCEDURE,

1797: p_app_short_name => 'GMA');
1798:
1799: GMA_COMMON_LOGGING.gma_migration_central_log (
1800: p_run_id => l_migration_id,
1801: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1802: p_message_token => 'GMA_MIGRATION_TABLE_FAIL',
1803: p_table_name => 'SY_ORGN_MST',
1804: p_context => 'ORGANIZATION',
1805: p_app_short_name => 'GMA');