DBA Data[Home] [Help]

APPS.INV_MIGRATE_PROCESS_ORG dependencies on GMA_COMMON_LOGGING

Line 65: -- GMA_COMMON_LOGGING.gma_migration_central_log (

61: X_failure_count := 0;
62:
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',

Line 166: -- GMA_COMMON_LOGGING.gma_migration_central_log (

162: WHERE whse_code = P_whse_code;
163:
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',

Line 177: GMA_COMMON_LOGGING.gma_migration_central_log (

173:
174: EXCEPTION
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',

Line 188: -- GMA_COMMON_LOGGING.gma_migration_central_log (

184: p_app_short_name => 'GMA');
185:
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',

Line 261: GMA_COMMON_LOGGING.gma_migration_central_log (

257: l_migration_id := P_migration_run_id;
258: X_failure_count := 0;
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',

Line 343: GMA_COMMON_LOGGING.gma_migration_central_log (

339: COMMIT;
340: END IF;
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',

Line 360: GMA_COMMON_LOGGING.gma_migration_central_log (

356: x_failure_count := x_failure_count + 1;
357: WHEN OTHERS THEN
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',

Line 369: GMA_COMMON_LOGGING.gma_migration_central_log (

365: p_context => 'ORGANIZATION',
366: p_db_error => SQLERRM,
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',

Line 563: GMA_COMMON_LOGGING.gma_migration_central_log (

559: NULL;
560:
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',

Line 572: GMA_COMMON_LOGGING.gma_migration_central_log (

568: p_context => 'LOCATION',
569: p_db_error => SQLERRM,
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',

Line 647: -- GMA_COMMON_LOGGING.gma_migration_central_log (

643: X_failure_count := 0;
644:
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',

Line 708: -- GMA_COMMON_LOGGING.gma_migration_central_log (

704: END LOOP;
705:
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',

Line 722: GMA_COMMON_LOGGING.gma_migration_central_log (

718: x_failure_count := l_failure_count;
719:
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',

Line 733: -- GMA_COMMON_LOGGING.gma_migration_central_log (

729: p_app_short_name => 'GMA');
730:
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',

Line 825: -- GMA_COMMON_LOGGING.gma_migration_central_log (

821: l_migration_id := P_migration_run_id;
822:
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',

Line 872: GMA_COMMON_LOGGING.gma_migration_central_log (

868: default_loc_status_id = 1
869: WHERE organization_id = l_organization_id
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',

Line 986: GMA_COMMON_LOGGING.gma_migration_central_log (

982: WHEN MIG_LOCATION_ERROR THEN
983: X_failure_count := X_failure_count + l_failure_count;
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',

Line 999: GMA_COMMON_LOGGING.gma_migration_central_log (

995:
996: WHEN OTHERS THEN
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',

Line 1012: -- GMA_COMMON_LOGGING.gma_migration_central_log (

1008: END LOOP;
1009:
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',

Line 1025: GMA_COMMON_LOGGING.gma_migration_central_log (

1021: EXCEPTION
1022: WHEN OTHERS THEN
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',

Line 1036: -- GMA_COMMON_LOGGING.gma_migration_central_log (

1032: p_app_short_name => 'GMA');
1033:
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',

Line 1481: GMA_COMMON_LOGGING.gma_migration_central_log (

1477:
1478: EXCEPTION
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',

Line 1493: GMA_COMMON_LOGGING.gma_migration_central_log (

1489: p_app_short_name => 'GMA');
1490:
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',

Line 1505: GMA_COMMON_LOGGING.gma_migration_central_log (

1501:
1502: WHEN OTHERS THEN
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',

Line 1581: GMA_COMMON_LOGGING.gma_migration_central_log (

1577: X_failure_count := 0;
1578: l_migrate_count := 0; /* Bug 5727749 */
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',

Line 1657: GMA_COMMON_LOGGING.gma_migration_central_log (

1653: EXCEPTION
1654: WHEN CREATE_ORGN_ERROR THEN
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',

Line 1668: GMA_COMMON_LOGGING.gma_migration_central_log (

1664: p_param1 => l_rec.orgn_code,
1665: p_app_short_name => 'GMA');
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',

Line 1680: GMA_COMMON_LOGGING.gma_migration_central_log(

1676:
1677: --RLNAGARA Material Status Migration ME
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',

Line 1693: GMA_COMMON_LOGGING.gma_migration_central_log(

1689:
1690: --RLNAGARA Material Status Migration ME
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',

Line 1706: GMA_COMMON_LOGGING.gma_migration_central_log (

1702:
1703: WHEN OTHERS THEN
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',

Line 1717: GMA_COMMON_LOGGING.gma_migration_central_log (

1713: p_app_short_name => 'GMA');
1714: END;
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',

Line 1732: GMA_COMMON_LOGGING.gma_migration_central_log (

1728: EXCEPTION
1729: WHEN OTHERS THEN
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',

Line 1741: GMA_COMMON_LOGGING.gma_migration_central_log (

1737: p_context => 'ORGANIZATION',
1738: p_db_error => SQLERRM,
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',