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

632: BEGIN
633:
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',

Line 657: GMA_COMMON_LOGGING.gma_migration_central_log (

653: FETCH c_get_mig_rec into l_mig_rec;
654:
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',

Line 735: GMA_COMMON_LOGGING.gma_migration_central_log (

731: END IF;
732:
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',

Line 1058: GMA_COMMON_LOGGING.gma_migration_central_log (

1054:
1055: 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',

Line 1076: GMA_COMMON_LOGGING.gma_migration_central_log (

1072: ROLLBACK to SAVEPOINT Org_Item;
1073: --Bug# 5293938 Add this exception handler
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',

Line 1095: GMA_COMMON_LOGGING.gma_migration_central_log (

1091:
1092:
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',

Line 1113: GMA_COMMON_LOGGING.gma_migration_central_log (

1109: ROLLBACK to SAVEPOINT Org_Item;
1110:
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',

Line 1131: GMA_COMMON_LOGGING.gma_migration_central_log (

1127: ROLLBACK to SAVEPOINT Org_Item;
1128:
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',

Line 1156: GMA_COMMON_LOGGING.gma_migration_central_log (

1152: CLOSE c_get_mig_rec;
1153:
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',

Line 1173: GMA_COMMON_LOGGING.gma_migration_central_log (

1169:
1170: EXCEPTION
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',

Line 1187: GMA_COMMON_LOGGING.gma_migration_central_log (

1183: p_param5 => NULL,
1184: p_db_error => SQLERRM,
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',

Line 1349: GMA_COMMON_LOGGING.gma_migration_central_log (

1345: BEGIN
1346:
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',

Line 1835: GMA_COMMON_LOGGING.gma_migration_central_log (

1831: EXCEPTION
1832: WHEN PROC_CALL_ERROR THEN
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',

Line 1854: GMA_COMMON_LOGGING.gma_migration_central_log (

1850:
1851: WHEN NO_UOM_CONVERSION THEN
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',

Line 1871: GMA_COMMON_LOGGING.gma_migration_central_log (

1867:
1868: WHEN OTHERS THEN
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',

Line 1893: GMA_COMMON_LOGGING.gma_migration_central_log (

1889:
1890: END LOOP; -- Items with standalone formula source
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',

Line 1911: GMA_COMMON_LOGGING.gma_migration_central_log (

1907:
1908: EXCEPTION
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',

Line 1924: GMA_COMMON_LOGGING.gma_migration_central_log (

1920:
1921: WHEN OTHERS THEN
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',

Line 1938: GMA_COMMON_LOGGING.gma_migration_central_log (

1934: p_param5 => NULL,
1935: p_db_error => SQLERRM,
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',

Line 2033: GMA_COMMON_LOGGING.gma_migration_central_log (

2029: BEGIN
2030:
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',

Line 2109: GMA_COMMON_LOGGING.gma_migration_central_log (

2105:
2106: WHEN INVALID_ORG_ITEM THEN
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',

Line 2126: GMA_COMMON_LOGGING.gma_migration_central_log (

2122:
2123: WHEN OTHERS THEN
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',

Line 2148: GMA_COMMON_LOGGING.gma_migration_central_log (

2144: END LOOP;
2145:
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',

Line 2166: GMA_COMMON_LOGGING.gma_migration_central_log (

2162: EXCEPTION
2163: WHEN OTHERS THEN
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',

Line 2180: GMA_COMMON_LOGGING.gma_migration_central_log (

2176: p_param5 => NULL,
2177: p_db_error => SQLERRM,
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',