eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSM_SERIAL_SUPPORT_PVT dependencies on FND_MSG_PUB

Line 26: g_msg_lvl_unexp_error NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ;

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

Line 27: g_msg_lvl_error NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR ;

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

Line 28: g_msg_lvl_success NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS ;

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

Line 29: g_msg_lvl_debug_high NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH ;

25:
26: g_msg_lvl_unexp_error NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ;
27: g_msg_lvl_error NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR ;
28: g_msg_lvl_success NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS ;
29: g_msg_lvl_debug_high NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH ;
30: g_msg_lvl_debug_medium NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM ;
31: g_msg_lvl_debug_low NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ;
32:
33: g_ret_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 30: g_msg_lvl_debug_medium NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM ;

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

Line 31: g_msg_lvl_debug_low NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ;

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

Line 392: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

388: -- Error out if not in valid status...
389: if l_status_type not in (1,3,6) then
390: -- error out..
391: IF g_log_level_error >= l_log_level OR
392: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
393: THEN
394:
395: l_msg_tokens.delete;
396: WSM_log_PVT.logMessage(p_module_name => l_module ,

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

443:
444: WHEN FND_API.G_EXC_ERROR THEN
445:
446: x_return_status := G_RET_ERROR;
447: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
448: p_count => x_error_count ,
449: p_data => x_error_msg
450: );
451:

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

452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
453:
454: x_return_status := G_RET_UNEXPECTED;
455:
456: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
457: p_count => x_error_count ,
458: p_data => x_error_msg
459: );
460: WHEN OTHERS THEN

Line 465: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

461:
462: x_return_status := G_RET_UNEXPECTED;
463:
464: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
465: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
466: THEN
467: WSM_log_PVT.handle_others( p_module_name => l_module ,
468: p_stmt_num => l_stmt_num ,
469: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

470: p_run_log_level => l_log_level
471: );
472: END IF;
473:
474: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
475: p_count => x_error_count ,
476: p_data => x_error_msg
477: );
478: END LBJ_serial_intf_proc;

Line 590: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

586: if p_wsm_serial_nums_tbl.count > 0 then
587: -- return error as interface rows were updated...
588: l_stmt_num := 50;
589: IF g_log_level_error >= l_log_level OR
590: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
591: THEN
592: l_msg_tokens.delete;
593: WSM_log_PVT.logMessage(p_module_name => l_module ,
594: p_msg_name => 'WSM_INVLAID_SERIAL_INFO',

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

645: EXCEPTION
646: WHEN FND_API.G_EXC_ERROR THEN
647: ROLLBACK TO LBJ_serial_proc;
648: x_return_status := G_RET_ERROR;
649: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
650: p_count => x_error_count ,
651: p_data => x_error_msg
652: );
653:

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

654: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
655: ROLLBACK TO LBJ_serial_proc;
656: x_return_status := G_RET_UNEXPECTED;
657:
658: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
659: p_count => x_error_count ,
660: p_data => x_error_msg
661: );
662: WHEN OTHERS THEN

Line 667: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

663: ROLLBACK TO LBJ_serial_proc;
664: x_return_status := G_RET_UNEXPECTED;
665:
666: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
667: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
668: THEN
669: WSM_log_PVT.handle_others( p_module_name => l_module ,
670: p_stmt_num => l_stmt_num ,
671: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

672: p_run_log_level => l_log_level
673: );
674: END IF;
675:
676: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
677: p_count => x_error_count ,
678: p_data => x_error_msg
679: );
680: END LBJ_serial_processor;

Line 734: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

730: WHEN NO_DATA_FOUND THEN
731: --Invalid item id/org id combination
732: --error out..
733: IF g_log_level_error >= l_log_level OR
734: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
735: THEN
736:
737: l_msg_tokens.delete;
738: l_msg_tokens(1).TokenName := 'FLD_NAME';

Line 783: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

779: WHEN NO_DATA_FOUND THEN
780: --Invalid wip_entity_id
781: -- error out..
782: IF g_log_level_error >= l_log_level OR
783: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
784: THEN
785:
786: l_msg_tokens.delete;
787: l_msg_tokens(1).TokenName := 'FLD_NAME';

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

803:
804: WHEN FND_API.G_EXC_ERROR THEN
805:
806: x_return_status := G_RET_ERROR;
807: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
808: p_count => x_error_count ,
809: p_data => x_error_msg
810: );
811: WHEN OTHERS THEN

Line 816: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

812:
813: x_return_status := G_RET_UNEXPECTED;
814:
815: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
816: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
817: THEN
818: WSM_log_PVT.handle_others( p_module_name => l_module ,
819: p_stmt_num => l_stmt_num ,
820: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

821: p_run_log_level => l_log_level
822: );
823: END IF;
824:
825: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
826: p_count => x_error_count ,
827: p_data => x_error_msg
828: );
829:

Line 996: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

992:
993: l_stmt_num := 100;
994: -- Error out.. As cannot add/delete/ generate and associate once serialization has begun..
995: IF g_log_level_error >= l_log_level OR
996: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
997: THEN
998:
999: l_msg_tokens.delete;
1000: WSM_log_PVT.logMessage(p_module_name => l_module ,

Line 1021: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

1017: IF l_serial_num_count >= l_qty then
1018: --error out...
1019: -- enough serial numbers reached...
1020: IF g_log_level_error >= l_log_level OR
1021: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
1022: THEN
1023:
1024: l_msg_tokens.delete;
1025: WSM_log_PVT.logMessage(p_module_name => l_module ,

Line 1110: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

1106: -- error out...
1107: -- as qty cannot be null/negative or non-integer.....
1108: l_stmt_num := 200;
1109: IF g_log_level_error >= l_log_level OR
1110: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
1111: THEN
1112:
1113: l_msg_tokens.delete;
1114: WSM_log_PVT.logMessage(p_module_name => l_module ,

Line 1134: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

1130: -- enough serial numbers reached...
1131: -- enough serial numbers reached...
1132: l_stmt_num := 220;
1133: IF g_log_level_error >= l_log_level OR
1134: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
1135: THEN
1136:
1137: l_msg_tokens.delete;
1138: WSM_log_PVT.logMessage(p_module_name => l_module ,

Line 1217: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

1213: -- Invalid action code...
1214: -- Error out...
1215: l_stmt_num := 290;
1216: IF g_log_level_error >= l_log_level OR
1217: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
1218: THEN
1219:
1220: l_msg_tokens.delete;
1221: l_msg_tokens(1).TokenName := 'FLD_NAME';

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

1242:
1243: WHEN FND_API.G_EXC_ERROR THEN
1244:
1245: x_return_status := G_RET_ERROR;
1246: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
1247: p_count => x_error_count ,
1248: p_data => x_error_msg
1249: );
1250:

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

1251: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1252:
1253: x_return_status := G_RET_UNEXPECTED;
1254:
1255: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
1256: p_count => x_error_count ,
1257: p_data => x_error_msg
1258: );
1259: WHEN OTHERS THEN

Line 1264: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

1260:
1261: x_return_status := G_RET_UNEXPECTED;
1262:
1263: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
1264: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
1265: THEN
1266: WSM_log_PVT.handle_others( p_module_name => l_module ,
1267: p_stmt_num => l_stmt_num ,
1268: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

1269: p_run_log_level => l_log_level
1270: );
1271: END IF;
1272:
1273: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
1274: p_count => x_error_count ,
1275: p_data => x_error_msg
1276: );
1277: END process_serial_info;

Line 1348: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

1344:
1345: if l_quantity <> 1 or l_return_code <> 0 then
1346: -- error out
1347: IF g_log_level_error >= l_log_level OR
1348: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
1349: THEN
1350:
1351: l_msg_tokens.delete;
1352: l_msg_tokens(1).TokenName := 'SERIAL_NUM';

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

1503:
1504: WHEN FND_API.G_EXC_ERROR THEN
1505:
1506: x_return_status := G_RET_ERROR;
1507: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
1508: p_count => x_error_count ,
1509: p_data => x_error_msg
1510: );
1511:

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

1512: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1513:
1514: x_return_status := G_RET_UNEXPECTED;
1515:
1516: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
1517: p_count => x_error_count ,
1518: p_data => x_error_msg
1519: );
1520: WHEN OTHERS THEN

Line 1525: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

1521:
1522: x_return_status := G_RET_UNEXPECTED;
1523:
1524: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
1525: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
1526: THEN
1527: WSM_log_PVT.handle_others( p_module_name => l_module ,
1528: p_stmt_num => l_stmt_num ,
1529: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

1530: p_run_log_level => l_log_level
1531: );
1532: END IF;
1533:
1534: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
1535: p_count => x_error_count ,
1536: p_data => x_error_msg
1537: );
1538: END add_assoc_serial_number;

Line 1613: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

1609:
1610: l_stmt_num := 30;
1611: if l_quantity <> 1 OR l_return_code <> 0 then
1612: IF g_log_level_error >= l_log_level OR
1613: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
1614: THEN
1615: l_msg_tokens.delete;
1616: l_msg_tokens(1).TokenName := 'SERIAL_NUM';
1617: l_msg_tokens(1).TokenValue := null;

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

1754:
1755: WHEN FND_API.G_EXC_ERROR THEN
1756:
1757: x_return_status := G_RET_ERROR;
1758: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
1759: p_count => x_error_count ,
1760: p_data => x_error_msg
1761: );
1762:

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

1763: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1764:
1765: x_return_status := G_RET_UNEXPECTED;
1766:
1767: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
1768: p_count => x_error_count ,
1769: p_data => x_error_msg
1770: );
1771: WHEN OTHERS THEN

Line 1776: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

1772:
1773: x_return_status := G_RET_UNEXPECTED;
1774:
1775: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
1776: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
1777: THEN
1778: WSM_log_PVT.handle_others( p_module_name => l_module ,
1779: p_stmt_num => l_stmt_num ,
1780: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

1781: p_run_log_level => l_log_level
1782: );
1783: END IF;
1784:
1785: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
1786: p_count => x_error_count ,
1787: p_data => x_error_msg
1788: );
1789:

Line 1890: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

1886: and msn.wip_entity_id = p_wip_entity_id;
1887:
1888: IF l_exists = 1 THEN
1889: IF g_log_level_error >= l_log_level OR
1890: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
1891: THEN
1892: l_msg_tokens.delete;
1893: WSM_log_PVT.logMessage(p_module_name => l_module ,
1894: p_msg_name => 'WIP_JDI_INVALID_UNUSED_SERIAL',

Line 1907: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

1903: RAISE FND_API.G_EXC_ERROR;
1904: END IF;
1905: ELSE
1906: IF g_log_level_error >= l_log_level OR
1907: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
1908: THEN
1909: l_msg_tokens.delete;
1910: WSM_log_PVT.logMessage(p_module_name => l_module ,
1911: p_msg_name => 'WIP_JDI_INVALID_UNUSED_SERIAL',

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

1972:
1973: WHEN FND_API.G_EXC_ERROR THEN
1974:
1975: x_return_status := G_RET_ERROR;
1976: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
1977: p_count => x_error_count ,
1978: p_data => x_error_msg
1979: );
1980:

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

1981: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1982:
1983: x_return_status := G_RET_UNEXPECTED;
1984:
1985: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
1986: p_count => x_error_count ,
1987: p_data => x_error_msg
1988: );
1989: WHEN OTHERS THEN

Line 1994: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

1990:
1991: x_return_status := G_RET_UNEXPECTED;
1992:
1993: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
1994: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
1995: THEN
1996: WSM_log_PVT.handle_others( p_module_name => l_module ,
1997: p_stmt_num => l_stmt_num ,
1998: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

1999: p_run_log_level => l_log_level
2000: );
2001: END IF;
2002:
2003: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
2004: p_count => x_error_count ,
2005: p_data => x_error_msg
2006: );
2007:

Line 2137: FND_MSG_PUB.check_msg_level(G_MSG_LVL_DEBUG_HIGH)

2133: -- and the user is free to specify the context..
2134: -- IF the user has passed NULL the INV API takes care of finding the defined context...
2135: -- populate a error message saying that the attributes will be cleared...
2136: IF g_log_level_exception >= l_log_level OR
2137: FND_MSG_PUB.check_msg_level(G_MSG_LVL_DEBUG_HIGH)
2138: THEN
2139: l_msg_tokens.delete;
2140: l_msg_tokens(1).TokenName := 'FLD_NAME';
2141: l_msg_tokens(1).TokenValue := 'Serial Attribute Category for Serial Number : ' || p_serial_number_rec.serial_number;

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

2405:
2406: WHEN FND_API.G_EXC_ERROR THEN
2407:
2408: x_return_status := G_RET_ERROR;
2409: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
2410: p_count => x_error_count ,
2411: p_data => x_error_msg
2412: );
2413:

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

2414: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2415:
2416: x_return_status := G_RET_UNEXPECTED;
2417:
2418: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
2419: p_count => x_error_count ,
2420: p_data => x_error_msg
2421: );
2422: WHEN OTHERS THEN

Line 2427: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

2423:
2424: x_return_status := G_RET_UNEXPECTED;
2425:
2426: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
2427: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
2428: THEN
2429: WSM_log_PVT.handle_others( p_module_name => l_module ,
2430: p_stmt_num => l_stmt_num ,
2431: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

2432: p_run_log_level => l_log_level
2433: );
2434: END IF;
2435:
2436: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
2437: p_count => x_error_count ,
2438: p_data => x_error_msg
2439: );
2440: END update_serial_attr;

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

2606:
2607: WHEN FND_API.G_EXC_ERROR THEN
2608:
2609: x_return_status := G_RET_ERROR;
2610: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
2611: p_count => x_error_count ,
2612: p_data => x_error_msg
2613: );
2614:

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

2615: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2616:
2617: x_return_status := G_RET_UNEXPECTED;
2618:
2619: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
2620: p_count => x_error_count ,
2621: p_data => x_error_msg
2622: );
2623: WHEN OTHERS THEN

Line 2628: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

2624:
2625: x_return_status := G_RET_UNEXPECTED;
2626:
2627: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
2628: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
2629: THEN
2630: WSM_log_PVT.handle_others( p_module_name => l_module ,
2631: p_stmt_num => l_stmt_num ,
2632: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

2633: p_run_log_level => l_log_level
2634: );
2635: END IF;
2636:
2637: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
2638: p_count => x_error_count ,
2639: p_data => x_error_msg
2640: );
2641:

Line 2687: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

2683: WHEN others THEN
2684: x_return_status := G_RET_UNEXPECTED;
2685:
2686: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
2687: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
2688: THEN
2689: WSM_log_PVT.handle_others( p_module_name => l_module ,
2690: p_stmt_num => l_stmt_num ,
2691: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

2692: p_run_log_level => l_log_level
2693: );
2694: END IF;
2695:
2696: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
2697: p_count => x_error_count ,
2698: p_data => x_err_data
2699: );
2700:

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

2893:
2894: WHEN FND_API.G_EXC_ERROR THEN
2895: rollback to update_serial;
2896: x_return_status := G_RET_ERROR;
2897: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
2898: p_count => x_error_count ,
2899: p_data => x_error_msg
2900: );
2901:

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

2901:
2902: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2903: rollback to update_serial;
2904: x_return_status := G_RET_UNEXPECTED;
2905: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
2906: p_count => x_error_count ,
2907: p_data => x_error_msg
2908: );
2909: WHEN OTHERS THEN

Line 2913: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

2909: WHEN OTHERS THEN
2910: rollback to update_serial;
2911: x_return_status := G_RET_UNEXPECTED;
2912: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
2913: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
2914: THEN
2915: WSM_log_PVT.handle_others( p_module_name => l_module ,
2916: p_stmt_num => l_stmt_num ,
2917: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

2918: p_run_log_level => l_log_level
2919: );
2920: END IF;
2921:
2922: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
2923: p_count => x_error_count ,
2924: p_data => x_error_msg
2925: );
2926:

Line 3247: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

3243:
3244: if l_row_updated > 0 OR p_wsm_serial_nums_tbl.count > 0 then
3245: -- return error as interface rows were updated...
3246: IF g_log_level_error >= l_log_level OR
3247: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
3248: THEN
3249:
3250: l_msg_tokens.delete;
3251: WSM_log_PVT.logMessage(p_module_name => l_module ,

Line 3333: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

3329: if l_row_updated > 0 or p_wsm_serial_nums_tbl.count > 0 then
3330: -- error.. message....
3331: l_stmt_num := 80;
3332: IF g_log_level_error >= l_log_level OR
3333: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
3334: THEN
3335:
3336: l_msg_tokens.delete;
3337: WSM_log_PVT.logMessage(p_module_name => l_module ,

Line 3374: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

3370: if SQL%ROWCOUNT > 0 then
3371: -- Error out..
3372: l_stmt_num := 100;
3373: IF g_log_level_error >= l_log_level OR
3374: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
3375: THEN
3376:
3377: l_msg_tokens.delete;
3378: WSM_log_PVT.logMessage(p_module_name => l_module ,

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

3463:
3464: WHEN FND_API.G_EXC_ERROR THEN
3465:
3466: x_return_status := G_RET_ERROR;
3467: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
3468: p_count => x_error_count ,
3469: p_data => x_error_msg
3470: );
3471:

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

3472: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3473:
3474: x_return_status := G_RET_UNEXPECTED;
3475:
3476: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
3477: p_count => x_error_count ,
3478: p_data => x_error_msg
3479: );
3480: WHEN OTHERS THEN

Line 3485: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

3481:
3482: x_return_status := G_RET_UNEXPECTED;
3483:
3484: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
3485: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
3486: THEN
3487: WSM_log_PVT.handle_others( p_module_name => l_module ,
3488: p_stmt_num => l_stmt_num ,
3489: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

3490: p_run_log_level => l_log_level
3491: );
3492: END IF;
3493:
3494: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
3495: p_count => x_error_count ,
3496: p_data => x_error_msg
3497: );
3498: END Move_serial_intf_proc;

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

3752:
3753: WHEN FND_API.G_EXC_ERROR THEN
3754: ROLLBACK to Move_serial_proc;
3755: x_return_status := G_RET_ERROR;
3756: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
3757: p_count => x_error_count ,
3758: p_data => x_error_msg
3759: );
3760:

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

3761: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3762: ROLLBACK to Move_serial_proc;
3763: x_return_status := G_RET_UNEXPECTED;
3764:
3765: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
3766: p_count => x_error_count ,
3767: p_data => x_error_msg
3768: );
3769: WHEN OTHERS THEN

Line 3774: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

3770: ROLLBACK to Move_serial_proc;
3771: x_return_status := G_RET_UNEXPECTED;
3772:
3773: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
3774: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
3775: THEN
3776: WSM_log_PVT.handle_others( p_module_name => l_module ,
3777: p_stmt_num => l_stmt_num ,
3778: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

3779: p_run_log_level => l_log_level
3780: );
3781: END IF;
3782:
3783: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
3784: p_count => x_error_count ,
3785: p_data => x_error_msg
3786: );
3787: END Move_serial_processor;

Line 3953: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

3949: -- check for non-needed serial info...
3950: if x_serial_track_flag IS NULL and p_serial_num_tbl.count>0 then
3951: -- Set return status to error and return.. we don't expect records
3952: IF g_log_level_error >= l_log_level OR
3953: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
3954: THEN
3955:
3956: l_msg_tokens.delete;
3957: WSM_log_PVT.logMessage(p_module_name => l_module ,

Line 3989: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

3985: -- Validate...
3986: IF l_job_serial_count > (p_available_qty - p_scrap_qty) THEN
3987: -- error out in this case...
3988: IF g_log_level_error >= l_log_level OR
3989: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
3990: THEN
3991: l_msg_tokens.delete;
3992: l_msg_tokens(1).TokenName := 'JOB';
3993:

Line 4019: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

4015: IF l_job_serial_count <> p_available_qty THEN
4016:
4017: -- Not enough data to start serial tracking...
4018: IF g_log_level_error >= l_log_level OR
4019: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
4020: THEN
4021: l_msg_tokens.delete;
4022: WSM_log_PVT.logMessage(p_module_name => l_module ,
4023: p_msg_name => 'WSM_NO_START_SERTRACK' ,

Line 4047: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

4043: if l_serial_list.exists(p_serial_num_tbl(l_cntr).serial_number) then
4044: -- error out...
4045: -- Duplicate entry...
4046: IF g_log_level_error >= l_log_level OR
4047: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
4048: THEN
4049: l_msg_tokens.delete;
4050: l_msg_tokens(1).TokenName := 'SERIAL';
4051: l_msg_tokens(1).TokenValue := p_serial_num_tbl(l_cntr).serial_number;

Line 4102: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

4098: -- insufficient info...
4099: l_stmt_num := 90;
4100:
4101: IF g_log_level_error >= l_log_level OR
4102: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
4103: THEN
4104:
4105: l_msg_tokens.delete;
4106: WSM_log_PVT.logMessage(p_module_name => l_module ,

Line 4509: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

4505: if p_scrap_qty <> l_scrap_serial_qty then
4506: -- error out. Insufficient info..
4507: l_stmt_num := 250;
4508: IF g_log_level_error >= l_log_level OR
4509: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
4510: THEN
4511:
4512: l_msg_tokens.delete;
4513: WSM_log_PVT.logMessage(p_module_name => l_module ,

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

4686: EXCEPTION
4687: WHEN FND_API.G_EXC_ERROR THEN
4688:
4689: x_return_status := G_RET_ERROR;
4690: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
4691: p_count => x_error_count ,
4692: p_data => x_error_msg
4693: );
4694:

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

4695: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4696:
4697: x_return_status := G_RET_UNEXPECTED;
4698:
4699: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
4700: p_count => x_error_count ,
4701: p_data => x_error_msg
4702: );
4703: WHEN OTHERS THEN

Line 4708: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

4704:
4705: x_return_status := G_RET_UNEXPECTED;
4706:
4707: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
4708: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
4709: THEN
4710: WSM_log_PVT.handle_others( p_module_name => l_module ,
4711: p_stmt_num => l_stmt_num ,
4712: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

4713: p_run_log_level => l_log_level
4714: );
4715: END IF;
4716:
4717: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
4718: p_count => x_error_count ,
4719: p_data => x_error_msg
4720: );
4721: END check_move_serial_qty;

Line 4861: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

4857: then
4858: l_stmt_num := 60;
4859: -- some of the serials are not present hence error out....
4860: IF g_log_level_error >= l_log_level OR
4861: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
4862: THEN
4863:
4864: l_msg_tokens.delete;
4865: WSM_log_PVT.logMessage(p_module_name => l_module ,

Line 4918: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

4914: if l_scrap_serial_num_list.count <> p_scrap_qty then
4915: l_stmt_num := 110;
4916: -- some of the serials are not present hence error out....
4917: IF g_log_level_error >= l_log_level OR
4918: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
4919: THEN
4920:
4921: l_msg_tokens.delete;
4922: WSM_log_PVT.logMessage(p_module_name => l_module ,

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

5002: EXCEPTION
5003: WHEN FND_API.G_EXC_ERROR THEN
5004:
5005: x_return_status := G_RET_ERROR;
5006: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
5007: p_count => x_error_count ,
5008: p_data => x_error_msg
5009: );
5010:

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

5011: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5012:
5013: x_return_status := G_RET_UNEXPECTED;
5014:
5015: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
5016: p_count => x_error_count ,
5017: p_data => x_error_msg
5018: );
5019: WHEN OTHERS THEN

Line 5024: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

5020:
5021: x_return_status := G_RET_UNEXPECTED;
5022:
5023: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
5024: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
5025: THEN
5026: WSM_log_PVT.handle_others( p_module_name => l_module ,
5027: p_stmt_num => l_stmt_num ,
5028: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

5029: p_run_log_level => l_log_level
5030: );
5031: END IF;
5032:
5033: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
5034: p_count => x_error_count ,
5035: p_data => x_error_msg
5036: );
5037:

Line 5220: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

5216:
5217: EXCEPTION
5218: WHEN NO_DATA_FOUND THEN
5219: IF g_log_level_error >= l_log_level OR
5220: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
5221: THEN
5222:
5223: l_msg_tokens.delete;
5224: l_msg_tokens(1).TokenName := 'FLD_NAME';

Line 5264: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

5260:
5261: EXCEPTION
5262: WHEN NO_DATA_FOUND THEN
5263: IF g_log_level_error >= l_log_level OR
5264: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
5265: THEN
5266:
5267: l_msg_tokens.delete;
5268: l_msg_tokens(1).TokenName := 'FLD_NAME';

Line 5315: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

5311:
5312: if SQL%ROWCOUNT > 0 then
5313: -- Error out..
5314: IF g_log_level_error >= l_log_level OR
5315: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
5316: THEN
5317:
5318: l_msg_tokens.delete;
5319: WSM_log_PVT.logMessage(p_module_name => l_module ,

Line 5351: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

5347:
5348: if SQL%ROWCOUNT > 0 then
5349: -- Error out..
5350: IF g_log_level_error >= l_log_level OR
5351: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
5352: THEN
5353:
5354: l_msg_tokens.delete;
5355: l_msg_tokens(1).TokenName := 'FLD_NAME';

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

5380:
5381: WHEN FND_API.G_EXC_ERROR THEN
5382:
5383: x_return_status := G_RET_ERROR;
5384: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
5385: p_count => x_error_count ,
5386: p_data => x_error_msg
5387: );
5388:

Line 5394: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

5390:
5391: x_return_status := G_RET_UNEXPECTED;
5392:
5393: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
5394: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
5395: THEN
5396: WSM_log_PVT.handle_others( p_module_name => l_module ,
5397: p_stmt_num => l_stmt_num ,
5398: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

5399: p_run_log_level => l_log_level
5400: );
5401: END IF;
5402:
5403: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
5404: p_count => x_error_count ,
5405: p_data => x_error_msg
5406: );
5407: END WLT_serial_intf_proc;

Line 5507: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

5503:
5504: x_return_status := G_RET_UNEXPECTED;
5505:
5506: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
5507: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
5508: THEN
5509: WSM_log_PVT.handle_others( p_module_name => l_module ,
5510: p_stmt_num => l_stmt_num ,
5511: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

5512: p_run_log_level => l_log_level
5513: );
5514: END IF;
5515:
5516: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
5517: p_count => x_error_count ,
5518: p_data => x_error_msg
5519: );
5520:

Line 5630: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

5626:
5627: x_return_status := G_RET_UNEXPECTED;
5628:
5629: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
5630: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
5631: THEN
5632: WSM_log_PVT.handle_others( p_module_name => l_module ,
5633: p_stmt_num => l_stmt_num ,
5634: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

5635: p_run_log_level => l_log_level
5636: );
5637: END IF;
5638:
5639: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
5640: p_count => x_error_count ,
5641: p_data => x_error_msg
5642: );
5643: END Insert_into_WST;

Line 5879: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

5875: IF p_serial_num_tbl.count <> 0 then
5876: l_stmt_num := 45;
5877: -- error out...
5878: IF g_log_level_error >= l_log_level OR
5879: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
5880: THEN
5881:
5882: l_msg_tokens.delete;
5883: WSM_log_PVT.logMessage(p_module_name => l_module ,

Line 5933: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

5929: -- error out...
5930: -- error out...
5931: l_stmt_num := 70;
5932: IF g_log_level_error >= l_log_level OR
5933: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
5934: THEN
5935:
5936: l_msg_tokens.delete;
5937: WSM_log_PVT.logMessage(p_module_name => l_module ,

Line 5966: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

5962: -- Duplicate entry....
5963: -- error out...
5964: l_stmt_num := 85;
5965: IF g_log_level_error >= l_log_level OR
5966: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
5967: THEN
5968: l_msg_tokens.delete;
5969: l_msg_tokens(1).TokenName := 'SERIAL';
5970: l_msg_tokens(1).TokenValue := p_serial_num_tbl(l_index2).serial_number;

Line 6037: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

6033:
6034: l_stmt_num := 105;
6035: --error out..
6036: IF g_log_level_error >= l_log_level OR
6037: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
6038: THEN
6039: l_msg_tokens.delete;
6040: l_msg_tokens(1).TokenName := 'FLD_NAME';
6041: l_msg_tokens(1).TokenValue := 'Changed Job Name';

Line 6129: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

6125: then
6126: l_stmt_num := 132;
6127: -- error out...
6128: IF g_log_level_error >= l_log_level OR
6129: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
6130: THEN
6131:
6132: l_msg_tokens.delete;
6133: l_msg_tokens(1).TokenName := 'JOB';

Line 6167: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

6163: IF p_resulting_jobs_tbl(l_index).start_quantity <
6164: (l_job_ser_info_tbl(p_resulting_jobs_tbl(l_index).wip_entity_name).l_count + l_serial_num_count - p_serial_num_tbl.count)
6165: THEN
6166: IF g_log_level_error >= l_log_level OR
6167: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
6168: THEN
6169:
6170: l_msg_tokens.delete;
6171: l_msg_tokens(1).TokenName := 'JOB';

Line 6398: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

6394: -- Already encountered....
6395: -- error out...
6396: l_stmt_num := 142;
6397: IF g_log_level_error >= l_log_level OR
6398: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
6399: THEN
6400: l_msg_tokens.delete;
6401: l_msg_tokens(1).TokenName := 'JOB';
6402: l_msg_tokens(1).TokenValue := p_resulting_jobs_tbl(l_index).wip_entity_name;

Line 6434: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

6430: -- error out...
6431: -- Possible that we dont add serial numbers for a parent job that is not serial tracked...
6432: -- This happens when the total no. of serial numbers is less than the available qty..
6433: IF g_log_level_error >= l_log_level OR
6434: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
6435: THEN
6436: l_msg_tokens.delete;
6437: l_msg_tokens(1).TokenName := 'JOB';
6438: l_msg_tokens(1).TokenValue := p_resulting_jobs_tbl(l_parent_as_resjob).wip_entity_name;

Line 6458: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

6454: IF l_serial_num_count <> p_serial_num_tbl.count then
6455: l_stmt_num := 146;
6456: -- error out...
6457: IF g_log_level_error >= l_log_level OR
6458: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
6459: THEN
6460:
6461: l_msg_tokens.delete;
6462: WSM_log_PVT.logMessage(p_module_name => l_module ,

Line 6508: FND_MSG_PUB.check_msg_level(G_MSG_LVL_DEBUG_HIGH)

6504:
6505: IF nvl(l_child_job_ser_context,'&&##') <> nvl(l_parent_job_ser_context,'&&##') then
6506: -- populate a error message saying that the attributes will be cleared...
6507: IF g_log_level_exception >= l_log_level OR
6508: FND_MSG_PUB.check_msg_level(G_MSG_LVL_DEBUG_HIGH)
6509: THEN
6510:
6511: l_msg_tokens.delete;
6512: l_msg_tokens(1).TokenName := 'JOB';

Line 6916: FND_MSG_PUB.check_msg_level(G_MSG_LVL_DEBUG_HIGH)

6912:
6913: if nvl(l_context,'&&##') <> nvl(l_parent_job_ser_context,'&&##') THEN
6914: -- populate a warning message...
6915: IF g_log_level_exception >= l_log_level OR
6916: FND_MSG_PUB.check_msg_level(G_MSG_LVL_DEBUG_HIGH)
6917: THEN
6918:
6919: l_msg_tokens.delete;
6920: l_msg_tokens(1).TokenName := 'JOB';

Line 7075: FND_MSG_PUB.check_msg_level(G_MSG_LVL_DEBUG_HIGH)

7071: --
7072: if nvl(l_context,'&&##') <> nvl(l_parent_job_ser_context,'&&##') THEN
7073: -- populate a warning message...
7074: IF g_log_level_exception >= l_log_level OR
7075: FND_MSG_PUB.check_msg_level(G_MSG_LVL_DEBUG_HIGH)
7076: THEN
7077:
7078: l_msg_tokens.delete;
7079: l_msg_tokens(1).TokenName := 'JOB';

Line 7243: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

7239: l_stmt_num := 290;
7240: IF p_serial_num_tbl.count > 0 THEN
7241: -- error out...
7242: IF g_log_level_error >= l_log_level OR
7243: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
7244: THEN
7245:
7246: l_msg_tokens.delete;
7247: WSM_log_PVT.logMessage(p_module_name => l_module ,

Line 7331: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

7327:
7328: IF l_serial_num_count <> p_resulting_jobs_tbl(p_resulting_jobs_tbl.first).start_quantity then
7329: -- error out..
7330: IF g_log_level_error >= l_log_level OR
7331: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
7332: THEN
7333:
7334: l_msg_tokens.delete;
7335: WSM_log_PVT.logMessage(p_module_name => l_module ,

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

7453: EXCEPTION
7454: WHEN FND_API.G_EXC_ERROR THEN
7455: ROLLBACK to WLT_serial_proc;
7456: x_return_status := G_RET_ERROR;
7457: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
7458: p_count => x_error_count ,
7459: p_data => x_error_msg
7460: );
7461:

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

7462: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7463: ROLLBACK to WLT_serial_proc;
7464: x_return_status := G_RET_UNEXPECTED;
7465:
7466: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
7467: p_count => x_error_count ,
7468: p_data => x_error_msg
7469: );
7470: WHEN OTHERS THEN

Line 7475: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

7471: ROLLBACK to WLT_serial_proc;
7472: x_return_status := G_RET_UNEXPECTED;
7473:
7474: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
7475: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
7476: THEN
7477: WSM_log_PVT.handle_others( p_module_name => l_module ,
7478: p_stmt_num => l_stmt_num ,
7479: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

7480: p_run_log_level => l_log_level
7481: );
7482: END IF;
7483:
7484: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
7485: p_count => x_error_count ,
7486: p_data => x_error_msg
7487: );
7488:

Line 7545: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

7541: floor(p_net_qty) <> p_net_qty)
7542: THEN
7543:
7544: IF g_log_level_error >= l_log_level OR
7545: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
7546: THEN
7547:
7548: l_msg_tokens.delete;
7549: WSM_log_PVT.logMessage(p_module_name => l_module ,

Line 7571: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

7567:
7568: IF floor(p_transaction_qty) <> p_transaction_qty THEN
7569:
7570: IF g_log_level_error >= l_log_level OR
7571: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
7572: THEN
7573:
7574: l_msg_tokens.delete;
7575: WSM_log_PVT.logMessage(p_module_name => l_module ,

Line 7603: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

7599:
7600: IF l_conv_rate = -99999 THEN
7601:
7602: IF g_log_level_error >= l_log_level OR
7603: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
7604: THEN
7605:
7606: l_msg_tokens.delete;
7607: WSM_log_PVT.logMessage(p_module_name => l_module ,

Line 7630: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

7626: )
7627: THEN
7628:
7629: IF g_log_level_error >= l_log_level OR
7630: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
7631: THEN
7632:
7633: l_msg_tokens.delete;
7634: WSM_log_PVT.logMessage(p_module_name => l_module ,

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

7652:
7653: WHEN FND_API.G_EXC_ERROR THEN
7654:
7655: x_return_status := G_RET_ERROR;
7656: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
7657: p_count => x_error_count ,
7658: p_data => x_error_msg
7659: );
7660:

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

7661: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7662:
7663: x_return_status := G_RET_UNEXPECTED;
7664:
7665: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
7666: p_count => x_error_count ,
7667: p_data => x_error_msg
7668: );
7669: WHEN OTHERS THEN

Line 7674: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

7670:
7671: x_return_status := G_RET_UNEXPECTED;
7672:
7673: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
7674: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
7675: THEN
7676: WSM_log_PVT.handle_others( p_module_name => l_module ,
7677: p_stmt_num => l_stmt_num ,
7678: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

7679: p_run_log_level => l_log_level
7680: );
7681: END IF;
7682:
7683: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
7684: p_count => x_error_count ,
7685: p_data => x_error_msg
7686: );
7687:

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

8892:
8893: WHEN FND_API.G_EXC_ERROR THEN
8894:
8895: x_return_status := G_RET_ERROR;
8896: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
8897: p_count => x_error_count ,
8898: p_data => x_error_msg
8899: );
8900:

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

8901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8902:
8903: x_return_status := G_RET_UNEXPECTED;
8904:
8905: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
8906: p_count => x_error_count ,
8907: p_data => x_error_msg
8908: );
8909: WHEN OTHERS THEN

Line 8914: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

8910:
8911: x_return_status := G_RET_UNEXPECTED;
8912:
8913: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
8914: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
8915: THEN
8916: WSM_log_PVT.handle_others( p_module_name => l_module ,
8917: p_stmt_num => l_stmt_num ,
8918: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

8919: p_run_log_level => l_log_level
8920: );
8921: END IF;
8922:
8923: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
8924: p_count => x_error_count ,
8925: p_data => x_error_msg
8926: );
8927: END Update_attr_move;

Line 8969: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

8965:
8966: x_return_status := G_RET_UNEXPECTED;
8967:
8968: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
8969: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
8970: THEN
8971: WSM_log_PVT.handle_others( p_module_name => l_module ,
8972: p_stmt_num => l_stmt_num ,
8973: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

8974: p_run_log_level => l_log_level
8975: );
8976: END IF;
8977:
8978: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
8979: p_count => x_error_count ,
8980: p_data => x_error_msg
8981: );
8982:

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

9278:
9279: WHEN FND_API.G_EXC_ERROR THEN
9280:
9281: x_return_status := G_RET_ERROR;
9282: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
9283: p_count => x_error_count ,
9284: p_data => x_error_msg
9285: );
9286:

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

9287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9288:
9289: x_return_status := G_RET_UNEXPECTED;
9290:
9291: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
9292: p_count => x_error_count ,
9293: p_data => x_error_msg
9294: );
9295: WHEN OTHERS THEN

Line 9300: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

9296:
9297: x_return_status := G_RET_UNEXPECTED;
9298:
9299: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
9300: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
9301: THEN
9302: WSM_log_PVT.handle_others( p_module_name => l_module ,
9303: p_stmt_num => l_stmt_num ,
9304: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

9305: p_run_log_level => l_log_level
9306: );
9307: END IF;
9308:
9309: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
9310: p_count => x_error_count ,
9311: p_data => x_error_msg
9312: );
9313: END Move_forms_serial_proc;

Line 9508: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

9504:
9505: x_return_status := G_RET_UNEXPECTED;
9506:
9507: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
9508: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
9509: THEN
9510: WSM_log_PVT.handle_others( p_module_name => l_module ,
9511: p_stmt_num => l_stmt_num ,
9512: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

9513: p_run_log_level => l_log_level
9514: );
9515: END IF;
9516:
9517: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
9518: p_count => x_error_count ,
9519: p_data => x_error_msg
9520: );
9521: END log_serial_data;