DBA Data[Home] [Help]

APPS.GR_MIGRATE_TO_12 dependencies on FND_LOG

Line 355: p_log_level => FND_LOG.LEVEL_PROCEDURE,

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',
358: p_context => 'GR_ITEM_MIGRATION_TABLE',
359: p_param1 => NULL,

Line 452: p_log_level => FND_LOG.LEVEL_PROCEDURE,

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',
455: p_context => 'GR_ITEM_MIGRATION_TABLE',
456: p_param1 => l_migration_count,

Line 471: p_log_level => FND_LOG.LEVEL_ERROR,

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',
474: p_context => 'GR_ITEM_MIGRATION_TABLE',
475: p_app_short_name => 'GMA');

Line 483: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

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',
486: p_context => 'GR_ITEM_MIGRATION_TABLE',
487: p_param1 => NULL,

Line 497: p_log_level => FND_LOG.LEVEL_PROCEDURE,

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',
500: p_context => 'GR_ITEM_MIGRATION_TABLE',
501: p_param1 => x_failure_count,

Line 638: p_log_level => FND_LOG.LEVEL_PROCEDURE,

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

Line 659: p_log_level => FND_LOG.LEVEL_PROCEDURE,

655: IF c_get_mig_rec%NOTFOUND THEN
656:
657: GMA_COMMON_LOGGING.gma_migration_central_log (
658: p_run_id => P_migration_run_id,
659: p_log_level => FND_LOG.LEVEL_PROCEDURE,
660: p_message_token => 'GR_NO_REGITEMS_TO_MIG',
661: p_table_name => 'GR_ITEM_GENERAL',
662: p_context => 'REGULATORY_ITEMS',
663: p_param1 => NULL,

Line 737: p_log_level => FND_LOG.LEVEL_PROCEDURE,

733: ELSE
734:
735: GMA_COMMON_LOGGING.gma_migration_central_log (
736: p_run_id => P_migration_run_id,
737: p_log_level => FND_LOG.LEVEL_PROCEDURE,
738: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
739: p_table_name => 'GR_ITEM_GENERAL',
740: p_context => 'REGULATORY_ITEMS',
741: p_param1 => NULL,

Line 1060: p_log_level => FND_LOG.LEVEL_EXCEPTION,

1056: WHEN INVALID_REG_ITEM THEN
1057: x_failure_count := x_failure_count + 1;
1058: GMA_COMMON_LOGGING.gma_migration_central_log (
1059: p_run_id => P_migration_run_id,
1060: p_log_level => FND_LOG.LEVEL_EXCEPTION,
1061: p_message_token => 'GR_INVALID_REG_ITEM',
1062: p_table_name => 'GR_ITEM_GENERAL',
1063: p_context => 'REGULATORY_ITEMS',
1064: p_param1 => l_mig_rec.item_code,

Line 1078: p_log_level => FND_LOG.LEVEL_EXCEPTION,

1074: WHEN NO_CAS_NUMBER THEN
1075: x_failure_count := x_failure_count + 1;
1076: GMA_COMMON_LOGGING.gma_migration_central_log (
1077: p_run_id => P_migration_run_id,
1078: p_log_level => FND_LOG.LEVEL_EXCEPTION,
1079: p_message_token => 'GR_NO_CAS_NUMBER',
1080: p_table_name => 'GR_ITEM_GENERAL',
1081: p_context => 'REGULATORY_ITEMS',
1082: p_param1 => l_mig_rec.item_code,

Line 1097: p_log_level => FND_LOG.LEVEL_EXCEPTION,

1093: WHEN ITEM_CREATE_ERROR THEN
1094: x_failure_count := x_failure_count + 1;
1095: GMA_COMMON_LOGGING.gma_migration_central_log (
1096: p_run_id => P_migration_run_id,
1097: p_log_level => FND_LOG.LEVEL_EXCEPTION,
1098: p_message_token => 'GR_INV_ITEM_ERROR',
1099: p_table_name => 'GR_ITEM_GENERAL',
1100: p_context => 'REGULATORY_ITEMS',
1101: p_param1 => l_mig_rec.item_code,

Line 1115: p_log_level => FND_LOG.LEVEL_EXCEPTION,

1111: WHEN PROC_CALL_ERROR THEN
1112: x_failure_count := x_failure_count + 1;
1113: GMA_COMMON_LOGGING.gma_migration_central_log (
1114: p_run_id => P_migration_run_id,
1115: p_log_level => FND_LOG.LEVEL_EXCEPTION,
1116: p_message_token => l_msg_data,
1117: p_table_name => 'GR_ITEM_GENERAL',
1118: p_context => 'REGULATORY_ITEMS',
1119: p_param1 => NULL,

Line 1133: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

1129: WHEN OTHERS THEN
1130: x_failure_count := x_failure_count + 1;
1131: GMA_COMMON_LOGGING.gma_migration_central_log (
1132: p_run_id => P_migration_run_id,
1133: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
1134: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1135: p_table_name => 'GR_ITEM_GENERAL',
1136: p_context => 'REGULATORY_ITEMS',
1137: p_param1 => NULL,

Line 1158: p_log_level => FND_LOG.LEVEL_PROCEDURE,

1154: END IF; -- Unmigrated records found
1155:
1156: GMA_COMMON_LOGGING.gma_migration_central_log (
1157: p_run_id => P_migration_run_id,
1158: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1159: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
1160: p_table_name => 'GR_ITEM_GENERAL',
1161: p_context => 'REGULATORY_ITEMS',
1162: p_param1 => l_migration_count,

Line 1175: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

1171: WHEN OTHERS THEN
1172: x_failure_count := x_failure_count + 1;
1173: GMA_COMMON_LOGGING.gma_migration_central_log (
1174: p_run_id => P_migration_run_id,
1175: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
1176: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1177: p_table_name => 'GR_ITEM_GENERAL',
1178: p_context => 'REGULATORY_ITEMS',
1179: p_param1 => NULL,

Line 1189: p_log_level => FND_LOG.LEVEL_PROCEDURE,

1185: p_app_short_name => 'GMA');
1186:
1187: GMA_COMMON_LOGGING.gma_migration_central_log (
1188: p_run_id => P_migration_run_id,
1189: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1190: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
1191: p_table_name => 'GR_ITEM_GENERAL',
1192: p_context => 'REGULATORY_ITEMS',
1193: p_param1 => x_failure_count,

Line 1351: p_log_level => FND_LOG.LEVEL_PROCEDURE,

1347: x_failure_count := 0;
1348:
1349: GMA_COMMON_LOGGING.gma_migration_central_log (
1350: p_run_id => P_migration_run_id,
1351: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1352: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
1353: p_table_name => 'GR_ITEM_CONCENTRATIONS',
1354: p_context => 'STANDALONE_FORMULAS',
1355: p_param1 => NULL,

Line 1837: p_log_level => FND_LOG.LEVEL_EXCEPTION,

1833: x_failure_count := x_failure_count + 1;
1834:
1835: GMA_COMMON_LOGGING.gma_migration_central_log (
1836: p_run_id => P_migration_run_id,
1837: p_log_level => FND_LOG.LEVEL_EXCEPTION,
1838: p_message_token => l_msg_data,
1839: p_table_name => 'GR_ITEM_CONCENTRATIONS',
1840: p_context => 'STANDALONE_FORMULAS',
1841: p_param1 => NULL,

Line 1856: p_log_level => FND_LOG.LEVEL_EXCEPTION,

1852: x_failure_count := x_failure_count + 1;
1853:
1854: GMA_COMMON_LOGGING.gma_migration_central_log (
1855: p_run_id => P_migration_run_id,
1856: p_log_level => FND_LOG.LEVEL_EXCEPTION,
1857: p_message_token => l_msg_data,
1858: p_table_name => 'GR_ITEM_CONCENTRATIONS',
1859: p_context => 'STANDALONE_FORMULAS',
1860: p_param1 => NULL,

Line 1873: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

1869: x_failure_count := x_failure_count + 1;
1870:
1871: GMA_COMMON_LOGGING.gma_migration_central_log (
1872: p_run_id => P_migration_run_id,
1873: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
1874: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1875: p_table_name => 'PO_HAZARD_CLASSES',
1876: p_context => 'HAZARD_CLASSES',
1877: p_param1 => NULL,

Line 1895: p_log_level => FND_LOG.LEVEL_PROCEDURE,

1891: CLOSE c_get_items;
1892:
1893: GMA_COMMON_LOGGING.gma_migration_central_log (
1894: p_run_id => P_migration_run_id,
1895: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1896: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
1897: p_table_name => 'GR_ITEM_CONCENTRATIONS',
1898: p_context => 'STANDALONE_FORMULAS',
1899: p_param1 => l_migration_count,

Line 1913: p_log_level => FND_LOG.LEVEL_ERROR,

1909: WHEN ORGN_NOT_MIGRATED THEN
1910: x_failure_count := x_failure_count + l_failure_count;
1911: GMA_COMMON_LOGGING.gma_migration_central_log (
1912: p_run_id => P_migration_run_id,
1913: p_log_level => FND_LOG.LEVEL_ERROR,
1914: p_message_token => 'GMA_ORG_NOT_MIGRATED',
1915: p_table_name => 'GR_ITEM_CONCENTRATIONS',
1916: p_context => 'STANDALONE_FORMULAS',
1917: p_token1 => 'ORGANIZATION',

Line 1926: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

1922: x_failure_count := x_failure_count + 1;
1923:
1924: GMA_COMMON_LOGGING.gma_migration_central_log (
1925: p_run_id => P_migration_run_id,
1926: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
1927: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1928: p_table_name => 'GR_ITEM_CONCENTRATIONS',
1929: p_context => 'STANDALONE_FORMULAS',
1930: p_param1 => NULL,

Line 1940: p_log_level => FND_LOG.LEVEL_PROCEDURE,

1936: p_app_short_name => 'GMA');
1937:
1938: GMA_COMMON_LOGGING.gma_migration_central_log (
1939: p_run_id => P_migration_run_id,
1940: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1941: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
1942: p_table_name => 'GR_ITEM_CONCENTRATIONS',
1943: p_context => 'STANDALONE_FORMULAS',
1944: p_param1 => x_failure_count,

Line 2035: p_log_level => FND_LOG.LEVEL_PROCEDURE,

2031: x_failure_count := 0;
2032:
2033: GMA_COMMON_LOGGING.gma_migration_central_log (
2034: p_run_id => P_migration_run_id,
2035: p_log_level => FND_LOG.LEVEL_PROCEDURE,
2036: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
2037: p_table_name => 'GR_DISPATCH_HISTORY',
2038: p_context => 'UPDATE_DISPATCH_HISTORY',
2039: p_param1 => NULL,

Line 2111: p_log_level => FND_LOG.LEVEL_EXCEPTION,

2107: x_failure_count := x_failure_count + 1;
2108:
2109: GMA_COMMON_LOGGING.gma_migration_central_log (
2110: p_run_id => P_migration_run_id,
2111: p_log_level => FND_LOG.LEVEL_EXCEPTION,
2112: p_message_token => 'GR_INVALID_ORG_ITEM',
2113: p_table_name => 'GR_DISPATCH_HISTORY',
2114: p_context => 'UPDATE_DISPATCH_HISTORY',
2115: p_param1 => l_org_id,

Line 2128: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

2124: x_failure_count := x_failure_count + 1;
2125:
2126: GMA_COMMON_LOGGING.gma_migration_central_log (
2127: p_run_id => P_migration_run_id,
2128: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
2129: p_message_token => 'GMA_MIGRATION_DB_ERROR',
2130: p_table_name => 'GR_DISPATCH_HISTORY',
2131: p_context => 'UPDATE_DISPATCH_HISTORY',
2132: p_param1 => NULL,

Line 2150: p_log_level => FND_LOG.LEVEL_PROCEDURE,

2146: CLOSE c_get_disp_rec;
2147:
2148: GMA_COMMON_LOGGING.gma_migration_central_log (
2149: p_run_id => P_migration_run_id,
2150: p_log_level => FND_LOG.LEVEL_PROCEDURE,
2151: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
2152: p_table_name => 'GR_DISPATCH_HISTORY',
2153: p_context => 'UPDATE_DISPATCH_HISTORY',
2154: p_param1 => l_migration_count,

Line 2168: p_log_level => FND_LOG.LEVEL_UNEXPECTED,

2164: x_failure_count := x_failure_count + 1;
2165:
2166: GMA_COMMON_LOGGING.gma_migration_central_log (
2167: p_run_id => P_migration_run_id,
2168: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
2169: p_message_token => 'GMA_MIGRATION_DB_ERROR',
2170: p_table_name => 'GR_DISPATCH_HISTORY',
2171: p_context => 'UPDATE_DISPATCH_HISTORY',
2172: p_param1 => NULL,

Line 2182: p_log_level => FND_LOG.LEVEL_PROCEDURE,

2178: p_app_short_name => 'GMA');
2179:
2180: GMA_COMMON_LOGGING.gma_migration_central_log (
2181: p_run_id => P_migration_run_id,
2182: p_log_level => FND_LOG.LEVEL_PROCEDURE,
2183: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
2184: p_table_name => 'GR_DISPATCH_HISTORY',
2185: p_context => 'UPDATE_DISPATCH_HISTORY',
2186: p_param1 => x_failure_count,