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 1503: GMA_COMMON_LOGGING.gma_migration_central_log (

1499:
1500: EXCEPTION
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',

Line 1515: GMA_COMMON_LOGGING.gma_migration_central_log (

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

Line 1526: GMA_COMMON_LOGGING.gma_migration_central_log (

1522: p_app_short_name => 'GMA');
1523: --Bug #13981860
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',

Line 1539: GMA_COMMON_LOGGING.gma_migration_central_log (

1535:
1536: WHEN OTHERS THEN
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',

Line 1622: GMA_COMMON_LOGGING.gma_migration_central_log (

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

Line 1715: GMA_COMMON_LOGGING.gma_migration_central_log (

1711: EXCEPTION
1712: WHEN CREATE_ORGN_ERROR THEN
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',

Line 1726: GMA_COMMON_LOGGING.gma_migration_central_log (

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

Line 1738: GMA_COMMON_LOGGING.gma_migration_central_log(

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

Line 1751: GMA_COMMON_LOGGING.gma_migration_central_log(

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

Line 1764: GMA_COMMON_LOGGING.gma_migration_central_log (

1760:
1761: WHEN OTHERS THEN
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',

Line 1775: GMA_COMMON_LOGGING.gma_migration_central_log (

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

Line 1790: GMA_COMMON_LOGGING.gma_migration_central_log (

1786: EXCEPTION
1787: WHEN OTHERS THEN
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',

Line 1799: GMA_COMMON_LOGGING.gma_migration_central_log (

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