DBA Data[Home] [Help]

APPS.INV_OPM_LOT_MIGRATION dependencies on FND_MSG_PUB

Line 442: -- dbms_output.put_line (substr(fnd_msg_pub.get_detail(i, NULL),1,255));

438: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
439: -- Log Error
440: x_failure_count := x_failure_count + 1;
441: FOR i in 1..l_msg_count LOOP
442: -- dbms_output.put_line (substr(fnd_msg_pub.get_detail(i, NULL),1,255));
443: GMA_COMMON_LOGGING.gma_migration_central_log (
444: p_run_id => p_migration_run_id,
445: p_log_level => FND_LOG.LEVEL_ERROR,
446: p_message_token => 'GMI_UNEXPECTED_ERROR',

Line 450: p_param1 => fnd_msg_pub.get_detail(i, NULL),

446: p_message_token => 'GMI_UNEXPECTED_ERROR',
447: p_table_name => 'IC_LOTS_MST',
448: p_context => 'LOTS',
449: p_token1 => 'ERROR',
450: p_param1 => fnd_msg_pub.get_detail(i, NULL),
451: p_param2 => NULL,
452: p_param3 => NULL,
453: p_param4 => NULL,
454: p_param5 => NULL,

Line 1292: FND_MSG_PUB.Count_AND_GET (p_count => l_msg_count, p_data => l_msg_data);

1288:
1289: EXCEPTION
1290: WHEN FND_API.G_EXC_ERROR THEN
1291: x_failure_count := x_failure_count + 1;
1292: FND_MSG_PUB.Count_AND_GET (p_count => l_msg_count, p_data => l_msg_data);
1293: FOR i in 1..l_msg_count LOOP
1294: -- dbms_output.put_line (substr(fnd_msg_pub.get_detail(i, NULL),1,255));
1295: GMA_COMMON_LOGGING.gma_migration_central_log (
1296: p_run_id => P_migration_run_id,

Line 1294: -- dbms_output.put_line (substr(fnd_msg_pub.get_detail(i, NULL),1,255));

1290: WHEN FND_API.G_EXC_ERROR THEN
1291: x_failure_count := x_failure_count + 1;
1292: FND_MSG_PUB.Count_AND_GET (p_count => l_msg_count, p_data => l_msg_data);
1293: FOR i in 1..l_msg_count LOOP
1294: -- dbms_output.put_line (substr(fnd_msg_pub.get_detail(i, NULL),1,255));
1295: GMA_COMMON_LOGGING.gma_migration_central_log (
1296: p_run_id => P_migration_run_id,
1297: p_log_level => FND_LOG.LEVEL_ERROR,
1298: p_message_token => 'GMI_UNEXPECTED_ERROR',

Line 1302: p_param1 => fnd_msg_pub.get_detail(i, NULL),

1298: p_message_token => 'GMI_UNEXPECTED_ERROR',
1299: p_table_name => 'IC_LOTS_MST',
1300: p_context => 'LOTS',
1301: p_token1 => 'ERROR',
1302: p_param1 => fnd_msg_pub.get_detail(i, NULL),
1303: p_param2 => NULL,
1304: p_param3 => NULL,
1305: p_param4 => NULL,
1306: p_param5 => NULL,

Line 1313: FND_MSG_PUB.Count_AND_GET (p_count => l_msg_count, p_data => l_msg_data);

1309: END LOOP;
1310:
1311: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1312: x_failure_count := x_failure_count + 1;
1313: FND_MSG_PUB.Count_AND_GET (p_count => l_msg_count, p_data => l_msg_data);
1314: FOR i in 1..l_msg_count LOOP
1315: -- dbms_output.put_line (substr(fnd_msg_pub.get_detail(i, NULL),1,255));
1316: GMA_COMMON_LOGGING.gma_migration_central_log (
1317: p_run_id => P_migration_run_id,

Line 1315: -- dbms_output.put_line (substr(fnd_msg_pub.get_detail(i, NULL),1,255));

1311: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1312: x_failure_count := x_failure_count + 1;
1313: FND_MSG_PUB.Count_AND_GET (p_count => l_msg_count, p_data => l_msg_data);
1314: FOR i in 1..l_msg_count LOOP
1315: -- dbms_output.put_line (substr(fnd_msg_pub.get_detail(i, NULL),1,255));
1316: GMA_COMMON_LOGGING.gma_migration_central_log (
1317: p_run_id => P_migration_run_id,
1318: p_log_level => FND_LOG.LEVEL_ERROR,
1319: p_message_token => 'GMI_UNEXPECTED_ERROR',

Line 1323: p_param1 => fnd_msg_pub.get_detail(i, NULL),

1319: p_message_token => 'GMI_UNEXPECTED_ERROR',
1320: p_table_name => 'IC_LOTS_MST',
1321: p_context => 'LOTS',
1322: p_token1 => 'ERROR',
1323: p_param1 => fnd_msg_pub.get_detail(i, NULL),
1324: p_param2 => NULL,
1325: p_param3 => NULL,
1326: p_param4 => NULL,
1327: p_param5 => NULL,

Line 1334: FND_MSG_PUB.Count_AND_GET (p_count => l_msg_count, p_data => l_msg_data);

1330: END LOOP;
1331:
1332: WHEN OTHERS THEN
1333: x_failure_count := x_failure_count + 1;
1334: FND_MSG_PUB.Count_AND_GET (p_count => l_msg_count, p_data => l_msg_data);
1335: FOR i in 1..l_msg_count LOOP
1336: -- dbms_output.put_line (substr(fnd_msg_pub.get_detail(i, NULL),1,255));
1337: GMA_COMMON_LOGGING.gma_migration_central_log (
1338: p_run_id => P_migration_run_id,

Line 1336: -- dbms_output.put_line (substr(fnd_msg_pub.get_detail(i, NULL),1,255));

1332: WHEN OTHERS THEN
1333: x_failure_count := x_failure_count + 1;
1334: FND_MSG_PUB.Count_AND_GET (p_count => l_msg_count, p_data => l_msg_data);
1335: FOR i in 1..l_msg_count LOOP
1336: -- dbms_output.put_line (substr(fnd_msg_pub.get_detail(i, NULL),1,255));
1337: GMA_COMMON_LOGGING.gma_migration_central_log (
1338: p_run_id => P_migration_run_id,
1339: p_log_level => FND_LOG.LEVEL_ERROR,
1340: p_message_token => 'GMI_UNEXPECTED_ERROR',

Line 1344: p_param1 => fnd_msg_pub.get_detail(i, NULL),

1340: p_message_token => 'GMI_UNEXPECTED_ERROR',
1341: p_table_name => 'IC_LOTS_MST',
1342: p_context => 'LOTS',
1343: p_token1 => 'ERROR',
1344: p_param1 => fnd_msg_pub.get_detail(i, NULL),
1345: p_param2 => NULL,
1346: p_param3 => NULL,
1347: p_param4 => NULL,
1348: p_param5 => NULL,