DBA Data[Home] [Help]

APPS.GR_MIGRATE_TO_12 dependencies on GMA_COMMON_LOGGING

Line 353: GMA_COMMON_LOGGING.gma_migration_central_log (

349:
350: BEGIN
351: x_failure_count := 0;
352:
353: GMA_COMMON_LOGGING.gma_migration_central_log (
354: p_run_id => P_migration_run_id,
355: p_log_level => FND_LOG.LEVEL_PROCEDURE,
356: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
357: p_table_name => 'GR_ITEM_GENERAL_MIG',

Line 450: GMA_COMMON_LOGGING.gma_migration_central_log (

446: RAISE NO_REG_ORG;
447: END IF;
448: END IF;
449:
450: GMA_COMMON_LOGGING.gma_migration_central_log (
451: p_run_id => P_migration_run_id,
452: p_log_level => FND_LOG.LEVEL_PROCEDURE,
453: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
454: p_table_name => 'GR_ITEM_GENERAL_MIG',

Line 469: GMA_COMMON_LOGGING.gma_migration_central_log (

465: EXCEPTION
466:
467: WHEN NO_REG_ORG THEN
468:
469: GMA_COMMON_LOGGING.gma_migration_central_log (
470: p_run_id => P_migration_run_id,
471: p_log_level => FND_LOG.LEVEL_ERROR,
472: p_message_token => 'GR_NO_REG_ORG',
473: p_table_name => 'GR_ITEM_GENERAL_MIG',

Line 481: GMA_COMMON_LOGGING.gma_migration_central_log (

477: WHEN OTHERS THEN
478:
479: x_failure_count := x_failure_count + 1;
480:
481: GMA_COMMON_LOGGING.gma_migration_central_log (
482: p_run_id => P_migration_run_id,
483: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
484: p_message_token => 'GMA_MIGRATION_DB_ERROR',
485: p_table_name => 'GR_ITEM_GENERAL_MIG',

Line 495: GMA_COMMON_LOGGING.gma_migration_central_log (

491: p_param5 => NULL,
492: p_db_error => SQLERRM,
493: p_app_short_name => 'GMA');
494:
495: GMA_COMMON_LOGGING.gma_migration_central_log (
496: p_run_id => P_migration_run_id,
497: p_log_level => FND_LOG.LEVEL_PROCEDURE,
498: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
499: p_table_name => 'GR_ITEM_GENERAL_MIG',

Line 639: GMA_COMMON_LOGGING.gma_migration_central_log (

635: BEGIN
636:
637: x_failure_count := 0;
638:
639: GMA_COMMON_LOGGING.gma_migration_central_log (
640: p_run_id => P_migration_run_id,
641: p_log_level => FND_LOG.LEVEL_PROCEDURE,
642: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
643: p_table_name => 'GR_ITEM_GENERAL',

Line 660: GMA_COMMON_LOGGING.gma_migration_central_log (

656: FETCH c_get_mig_rec into l_mig_rec;
657:
658: IF c_get_mig_rec%NOTFOUND THEN
659:
660: GMA_COMMON_LOGGING.gma_migration_central_log (
661: p_run_id => P_migration_run_id,
662: p_log_level => FND_LOG.LEVEL_PROCEDURE,
663: p_message_token => 'GR_NO_REGITEMS_TO_MIG',
664: p_table_name => 'GR_ITEM_GENERAL',

Line 715: GMA_COMMON_LOGGING.gma_migration_central_log (

711: -- RAISE NO_CAS_NUMBER;
712: -- log warning instead -- 14067151
713: -- x_failure_count := x_failure_count + 1; -- 14067151
714:
715: GMA_COMMON_LOGGING.gma_migration_central_log (
716: p_run_id => P_migration_run_id,
717: p_log_level => FND_LOG.LEVEL_PROCEDURE,
718: p_message_token => 'GR_NO_CAS_NUMBER',
719: p_table_name => 'GR_ITEM_GENERAL',

Line 758: GMA_COMMON_LOGGING.gma_migration_central_log (

754: END IF;
755:
756: ELSE
757:
758: GMA_COMMON_LOGGING.gma_migration_central_log (
759: p_run_id => P_migration_run_id,
760: p_log_level => FND_LOG.LEVEL_PROCEDURE,
761: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
762: p_table_name => 'GR_ITEM_GENERAL',

Line 1081: GMA_COMMON_LOGGING.gma_migration_central_log (

1077:
1078: EXCEPTION
1079: WHEN INVALID_REG_ITEM THEN
1080: x_failure_count := x_failure_count + 1;
1081: GMA_COMMON_LOGGING.gma_migration_central_log (
1082: p_run_id => P_migration_run_id,
1083: p_log_level => FND_LOG.LEVEL_EXCEPTION,
1084: p_message_token => 'GR_INVALID_REG_ITEM',
1085: p_table_name => 'GR_ITEM_GENERAL',

Line 1099: GMA_COMMON_LOGGING.gma_migration_central_log (

1095: ROLLBACK to SAVEPOINT Org_Item;
1096: --Bug# 5293938 Add this exception handler
1097: WHEN NO_CAS_NUMBER THEN
1098: x_failure_count := x_failure_count + 1;
1099: GMA_COMMON_LOGGING.gma_migration_central_log (
1100: p_run_id => P_migration_run_id,
1101: p_log_level => FND_LOG.LEVEL_EXCEPTION,
1102: p_message_token => 'GR_NO_CAS_NUMBER',
1103: p_table_name => 'GR_ITEM_GENERAL',

Line 1118: GMA_COMMON_LOGGING.gma_migration_central_log (

1114:
1115:
1116: WHEN ITEM_CREATE_ERROR THEN
1117: x_failure_count := x_failure_count + 1;
1118: GMA_COMMON_LOGGING.gma_migration_central_log (
1119: p_run_id => P_migration_run_id,
1120: p_log_level => FND_LOG.LEVEL_EXCEPTION,
1121: p_message_token => 'GR_INV_ITEM_ERROR',
1122: p_table_name => 'GR_ITEM_GENERAL',

Line 1136: GMA_COMMON_LOGGING.gma_migration_central_log (

1132: ROLLBACK to SAVEPOINT Org_Item;
1133:
1134: WHEN PROC_CALL_ERROR THEN
1135: x_failure_count := x_failure_count + 1;
1136: GMA_COMMON_LOGGING.gma_migration_central_log (
1137: p_run_id => P_migration_run_id,
1138: p_log_level => FND_LOG.LEVEL_EXCEPTION,
1139: p_message_token => l_msg_data,
1140: p_table_name => 'GR_ITEM_GENERAL',

Line 1154: GMA_COMMON_LOGGING.gma_migration_central_log (

1150: ROLLBACK to SAVEPOINT Org_Item;
1151:
1152: WHEN OTHERS THEN
1153: x_failure_count := x_failure_count + 1;
1154: GMA_COMMON_LOGGING.gma_migration_central_log (
1155: p_run_id => P_migration_run_id,
1156: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
1157: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1158: p_table_name => 'GR_ITEM_GENERAL',

Line 1179: GMA_COMMON_LOGGING.gma_migration_central_log (

1175: CLOSE c_get_mig_rec;
1176:
1177: END IF; -- Unmigrated records found
1178:
1179: GMA_COMMON_LOGGING.gma_migration_central_log (
1180: p_run_id => P_migration_run_id,
1181: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1182: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
1183: p_table_name => 'GR_ITEM_GENERAL',

Line 1196: GMA_COMMON_LOGGING.gma_migration_central_log (

1192:
1193: EXCEPTION
1194: WHEN OTHERS THEN
1195: x_failure_count := x_failure_count + 1;
1196: GMA_COMMON_LOGGING.gma_migration_central_log (
1197: p_run_id => P_migration_run_id,
1198: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
1199: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1200: p_table_name => 'GR_ITEM_GENERAL',

Line 1210: GMA_COMMON_LOGGING.gma_migration_central_log (

1206: p_param5 => NULL,
1207: p_db_error => SQLERRM,
1208: p_app_short_name => 'GMA');
1209:
1210: GMA_COMMON_LOGGING.gma_migration_central_log (
1211: p_run_id => P_migration_run_id,
1212: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1213: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
1214: p_table_name => 'GR_ITEM_GENERAL',

Line 1373: GMA_COMMON_LOGGING.gma_migration_central_log (

1369: BEGIN
1370:
1371: x_failure_count := 0;
1372:
1373: GMA_COMMON_LOGGING.gma_migration_central_log (
1374: p_run_id => P_migration_run_id,
1375: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1376: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
1377: p_table_name => 'GR_ITEM_CONCENTRATIONS',

Line 1859: GMA_COMMON_LOGGING.gma_migration_central_log (

1855: EXCEPTION
1856: WHEN PROC_CALL_ERROR THEN
1857: x_failure_count := x_failure_count + 1;
1858:
1859: GMA_COMMON_LOGGING.gma_migration_central_log (
1860: p_run_id => P_migration_run_id,
1861: p_log_level => FND_LOG.LEVEL_EXCEPTION,
1862: p_message_token => l_msg_data,
1863: p_table_name => 'GR_ITEM_CONCENTRATIONS',

Line 1878: GMA_COMMON_LOGGING.gma_migration_central_log (

1874:
1875: WHEN NO_UOM_CONVERSION THEN
1876: x_failure_count := x_failure_count + 1;
1877:
1878: GMA_COMMON_LOGGING.gma_migration_central_log (
1879: p_run_id => P_migration_run_id,
1880: p_log_level => FND_LOG.LEVEL_EXCEPTION,
1881: p_message_token => l_msg_data,
1882: p_table_name => 'GR_ITEM_CONCENTRATIONS',

Line 1895: GMA_COMMON_LOGGING.gma_migration_central_log (

1891:
1892: WHEN OTHERS THEN
1893: x_failure_count := x_failure_count + 1;
1894:
1895: GMA_COMMON_LOGGING.gma_migration_central_log (
1896: p_run_id => P_migration_run_id,
1897: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
1898: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1899: p_table_name => 'PO_HAZARD_CLASSES',

Line 1917: GMA_COMMON_LOGGING.gma_migration_central_log (

1913:
1914: END LOOP; -- Items with standalone formula source
1915: CLOSE c_get_items;
1916:
1917: GMA_COMMON_LOGGING.gma_migration_central_log (
1918: p_run_id => P_migration_run_id,
1919: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1920: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
1921: p_table_name => 'GR_ITEM_CONCENTRATIONS',

Line 1935: GMA_COMMON_LOGGING.gma_migration_central_log (

1931:
1932: EXCEPTION
1933: WHEN ORGN_NOT_MIGRATED THEN
1934: x_failure_count := x_failure_count + l_failure_count;
1935: GMA_COMMON_LOGGING.gma_migration_central_log (
1936: p_run_id => P_migration_run_id,
1937: p_log_level => FND_LOG.LEVEL_ERROR,
1938: p_message_token => 'GMA_ORG_NOT_MIGRATED',
1939: p_table_name => 'GR_ITEM_CONCENTRATIONS',

Line 1948: GMA_COMMON_LOGGING.gma_migration_central_log (

1944:
1945: WHEN OTHERS THEN
1946: x_failure_count := x_failure_count + 1;
1947:
1948: GMA_COMMON_LOGGING.gma_migration_central_log (
1949: p_run_id => P_migration_run_id,
1950: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
1951: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1952: p_table_name => 'GR_ITEM_CONCENTRATIONS',

Line 1962: GMA_COMMON_LOGGING.gma_migration_central_log (

1958: p_param5 => NULL,
1959: p_db_error => SQLERRM,
1960: p_app_short_name => 'GMA');
1961:
1962: GMA_COMMON_LOGGING.gma_migration_central_log (
1963: p_run_id => P_migration_run_id,
1964: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1965: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
1966: p_table_name => 'GR_ITEM_CONCENTRATIONS',

Line 2057: GMA_COMMON_LOGGING.gma_migration_central_log (

2053: BEGIN
2054:
2055: x_failure_count := 0;
2056:
2057: GMA_COMMON_LOGGING.gma_migration_central_log (
2058: p_run_id => P_migration_run_id,
2059: p_log_level => FND_LOG.LEVEL_PROCEDURE,
2060: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
2061: p_table_name => 'GR_DISPATCH_HISTORY',

Line 2133: GMA_COMMON_LOGGING.gma_migration_central_log (

2129:
2130: WHEN INVALID_ORG_ITEM THEN
2131: x_failure_count := x_failure_count + 1;
2132:
2133: GMA_COMMON_LOGGING.gma_migration_central_log (
2134: p_run_id => P_migration_run_id,
2135: p_log_level => FND_LOG.LEVEL_EXCEPTION,
2136: p_message_token => 'GR_INVALID_ORG_ITEM',
2137: p_table_name => 'GR_DISPATCH_HISTORY',

Line 2150: GMA_COMMON_LOGGING.gma_migration_central_log (

2146:
2147: WHEN OTHERS THEN
2148: x_failure_count := x_failure_count + 1;
2149:
2150: GMA_COMMON_LOGGING.gma_migration_central_log (
2151: p_run_id => P_migration_run_id,
2152: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
2153: p_message_token => 'GMA_MIGRATION_DB_ERROR',
2154: p_table_name => 'GR_DISPATCH_HISTORY',

Line 2172: GMA_COMMON_LOGGING.gma_migration_central_log (

2168: END LOOP;
2169:
2170: CLOSE c_get_disp_rec;
2171:
2172: GMA_COMMON_LOGGING.gma_migration_central_log (
2173: p_run_id => P_migration_run_id,
2174: p_log_level => FND_LOG.LEVEL_PROCEDURE,
2175: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
2176: p_table_name => 'GR_DISPATCH_HISTORY',

Line 2190: GMA_COMMON_LOGGING.gma_migration_central_log (

2186: EXCEPTION
2187: WHEN OTHERS THEN
2188: x_failure_count := x_failure_count + 1;
2189:
2190: GMA_COMMON_LOGGING.gma_migration_central_log (
2191: p_run_id => P_migration_run_id,
2192: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
2193: p_message_token => 'GMA_MIGRATION_DB_ERROR',
2194: p_table_name => 'GR_DISPATCH_HISTORY',

Line 2204: GMA_COMMON_LOGGING.gma_migration_central_log (

2200: p_param5 => NULL,
2201: p_db_error => SQLERRM,
2202: p_app_short_name => 'GMA');
2203:
2204: GMA_COMMON_LOGGING.gma_migration_central_log (
2205: p_run_id => P_migration_run_id,
2206: p_log_level => FND_LOG.LEVEL_PROCEDURE,
2207: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
2208: p_table_name => 'GR_DISPATCH_HISTORY',