DBA Data[Home] [Help]

APPS.WSMPLOAD dependencies on FND_MSG_PUB

Line 29: g_msg_lvl_unexp_error NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ;

25: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
26: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
27: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;
28:
29: g_msg_lvl_unexp_error NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ;
30: g_msg_lvl_error NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR ;
31: g_msg_lvl_success NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS ;
32: g_msg_lvl_debug_high NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH ;
33: g_msg_lvl_debug_medium NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM ;

Line 30: g_msg_lvl_error NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR ;

26: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
27: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;
28:
29: g_msg_lvl_unexp_error NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ;
30: g_msg_lvl_error NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR ;
31: g_msg_lvl_success NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS ;
32: g_msg_lvl_debug_high NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH ;
33: g_msg_lvl_debug_medium NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM ;
34: g_msg_lvl_debug_low NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ;

Line 31: g_msg_lvl_success NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS ;

27: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;
28:
29: g_msg_lvl_unexp_error NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ;
30: g_msg_lvl_error NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR ;
31: g_msg_lvl_success NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS ;
32: g_msg_lvl_debug_high NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH ;
33: g_msg_lvl_debug_medium NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM ;
34: g_msg_lvl_debug_low NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ;
35:

Line 32: g_msg_lvl_debug_high NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH ;

28:
29: g_msg_lvl_unexp_error NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ;
30: g_msg_lvl_error NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR ;
31: g_msg_lvl_success NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS ;
32: g_msg_lvl_debug_high NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH ;
33: g_msg_lvl_debug_medium NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM ;
34: g_msg_lvl_debug_low NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ;
35:
36: g_ret_success varchar2(1) := FND_API.G_RET_STS_SUCCESS;

Line 33: g_msg_lvl_debug_medium NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM ;

29: g_msg_lvl_unexp_error NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ;
30: g_msg_lvl_error NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR ;
31: g_msg_lvl_success NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS ;
32: g_msg_lvl_debug_high NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH ;
33: g_msg_lvl_debug_medium NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM ;
34: g_msg_lvl_debug_low NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ;
35:
36: g_ret_success varchar2(1) := FND_API.G_RET_STS_SUCCESS;
37: g_ret_error varchar2(1) := FND_API.G_RET_STS_ERROR;

Line 34: g_msg_lvl_debug_low NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ;

30: g_msg_lvl_error NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR ;
31: g_msg_lvl_success NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS ;
32: g_msg_lvl_debug_high NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH ;
33: g_msg_lvl_debug_medium NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM ;
34: g_msg_lvl_debug_low NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ;
35:
36: g_ret_success varchar2(1) := FND_API.G_RET_STS_SUCCESS;
37: g_ret_error varchar2(1) := FND_API.G_RET_STS_ERROR;
38: g_ret_unexpected varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

Line 244: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN

240: p_inf_sch_date => NULL
241: );
242:
243: IF (l_error_code <> 0) THEN
244: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
245:
246: l_msg_tokens.delete;
247: WSM_log_PVT.logMessage(p_module_name => l_module ,
248: p_msg_text => 'WSM_JobCopies_PVT.Create_RepJobCopies returned error:'||l_error_msg,

Line 359: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN

355: p_run_log_level => l_log_level
356: );
357: End if;
358: ELSE
359: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
360:
361: l_msg_tokens.delete;
362: WSM_log_PVT.logMessage(p_module_name => l_module ,
363: p_msg_text => 'WSM_JobCopies_PVT.Create_JobCopies returned error:'||l_error_msg,

Line 432: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN

428: x_err_buf => l_error_msg,
429: x_msg_count => x_msg_count);
430:
431: IF (l_error_code <> 0) THEN
432: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
433:
434: l_msg_tokens.delete;
435: WSM_log_PVT.logMessage(p_module_name => l_module ,
436: p_msg_text => 'WSMPJUPD.GET_JOB_CURR_OP_INFO returned error:'||l_error_code,

Line 478: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN

474: );
475:
476: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
477: -- x_error_code := -1;
478: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
479:
480: l_msg_tokens.delete;
481: WSM_log_PVT.logMessage(p_module_name => l_module ,
482: p_msg_text => 'WSM_infinite_scheduler_PVT.schedule returned error:'||l_error_msg,

Line 513: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,

509: exception
510: WHEN FND_API.G_EXC_ERROR THEN
511:
512: x_return_status := G_RET_ERROR;
513: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
514: p_count => x_msg_count ,
515: p_data => x_error_msg
516: );
517:

Line 522: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,

518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
519:
520: x_return_status := G_RET_UNEXPECTED;
521:
522: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
523: p_count => x_msg_count ,
524: p_data => x_error_msg
525: );
526: WHEN OTHERS THEN

Line 531: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

527:
528: x_return_status := G_RET_UNEXPECTED;
529:
530: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
531: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
532: THEN
533: WSM_log_PVT.handle_others( p_module_name => l_module ,
534: p_stmt_num => l_stmt_num ,
535: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

Line 540: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,

536: p_run_log_level => l_log_level
537: );
538: END IF;
539:
540: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
541: p_count => x_msg_count ,
542: p_data => x_error_msg
543: );
544: end;

Line 1135: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN

1131: );
1132:
1133: IF l_return_status <> G_RET_SUCCESS THEN
1134: -- error out..
1135: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
1136:
1137: l_msg_tokens.delete;
1138: WSM_log_PVT.logMessage(p_module_name => l_module ,
1139: p_msg_text => 'WSM_Serial_Support_PVT.WLT_serial_intf_proc Failed',

Line 1158: l_error_msg := fnd_msg_pub.get( p_msg_index => l_msg_count - i + 1,

1154: IF (l_msg_count = 1) THEN
1155: fnd_file.put_line(fnd_file.log,l_error_msg);
1156: ELSIF (l_msg_count > 1) THEN
1157: FOR i IN 1..l_msg_count LOOP
1158: l_error_msg := fnd_msg_pub.get( p_msg_index => l_msg_count - i + 1,
1159: p_encoded => FND_API.G_FALSE
1160: );
1161: fnd_file.put_line(fnd_file.log,l_error_msg);
1162: END LOOP;

Line 1305: l_error_msg := fnd_msg_pub.get( p_msg_index => l_msg_count - i + 1,

1301: IF (l_msg_count = 1) THEN
1302: fnd_file.put_line(fnd_file.log,l_error_msg);
1303: ELSIF (l_msg_count > 1) THEN
1304: FOR i IN 1..l_msg_count LOOP
1305: l_error_msg := fnd_msg_pub.get( p_msg_index => l_msg_count - i + 1,
1306: p_encoded => FND_API.G_FALSE
1307: );
1308: fnd_file.put_line(fnd_file.log,l_error_msg);
1309: END LOOP;

Line 1390: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN

1386:
1387: ROLLBACK TO s_process_one_wlt;
1388:
1389: -- error out..
1390: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
1391:
1392: l_msg_tokens.delete;
1393: WSM_log_PVT.logMessage(p_module_name => l_module ,
1394: p_msg_text => l_error_msg ,

Line 1480: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN

1476: l_txn_status_tbl(l_txn_counter) := wip_constants.error;
1477: l_txn_header_tbl(l_txn_counter) := l_wsm_wtxn_hdr_tbl(l_txn_counter).header_id;
1478:
1479: -- Add the error message : ST : Fix for bug 4859986
1480: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
1481:
1482: l_msg_tokens.delete;
1483: l_msg_tokens(1).TokenName := 'TABLE';
1484: l_msg_tokens(1).TokenValue := 'WSM_STARTING_JOBS_INTERFACE (header_id = ' || l_wsm_wtxn_hdr_tbl(l_txn_counter).header_id

Line 1533: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN

1529: );
1530:
1531: -- if return status not success then error out...
1532: if l_return_code <> 0 then
1533: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
1534:
1535: l_msg_tokens.delete;
1536: WSM_log_PVT.logMessage(p_module_name => l_module ,
1537: p_msg_text => l_error_msg ,

Line 1656: IF (l_txn_processed = 0 AND (g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR))) THEN

1652: End if;
1653:
1654: -- ST : Fix for bug 4859986
1655: -- log a message for no pending rows (at error level so that it appears in the log..)
1656: IF (l_txn_processed = 0 AND (g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR))) THEN
1657: l_msg_tokens.delete;
1658: WSM_log_PVT.logMessage( p_module_name => l_module ,
1659: p_msg_name => 'WSM_NO_PEND_TXNS' ,
1660: p_msg_appl_name => 'WSM' ,

Line 1776: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

1772: EXCEPTION
1773: -- ST : Added for bug 5297923
1774: WHEN e_invalid_job_data THEN
1775: IF g_log_level_error >= l_log_level OR
1776: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
1777: THEN
1778: fnd_message.set_name('WSM','WSM_INVALID_FIELD');
1779: fnd_message.set_token('FLD_NAME','Wip Entity Name/Wip Entity ID/organization id');
1780: l_error_msg := fnd_message.get;

Line 1806: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

1802: -- ST : Added for bug 5297923 : end --
1803:
1804: WHEN OTHERS THEN
1805: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
1806: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
1807: THEN
1808: WSM_log_PVT.handle_others( p_module_name => l_module ,
1809: p_stmt_num => l_stmt_num ,
1810: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,