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.WSMPJUPD dependencies on FND_MSG_PUB

Line 23: g_msg_lvl_unexp_error NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ;

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

Line 24: g_msg_lvl_error NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR ;

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

Line 25: g_msg_lvl_success NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS ;

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

Line 26: g_msg_lvl_debug_high NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH ;

22:
23: g_msg_lvl_unexp_error NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ;
24: g_msg_lvl_error NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR ;
25: g_msg_lvl_success NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS ;
26: g_msg_lvl_debug_high NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH ;
27: g_msg_lvl_debug_medium NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM ;
28: g_msg_lvl_debug_low NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ;
29:
30: g_ret_success varchar2(1) := FND_API.G_RET_STS_SUCCESS;

Line 27: g_msg_lvl_debug_medium NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM ;

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

Line 28: g_msg_lvl_debug_low NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ;

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

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

720: EXCEPTION
721: WHEN FND_API.G_EXC_ERROR THEN
722: ROLLBACK TO start_secondary_quantities;
723: x_return_status := G_RET_ERROR;
724: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
725: p_count => x_msg_count ,
726: p_data => x_error_msg
727: );
728:

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

728:
729: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
730: ROLLBACK TO start_secondary_quantities;
731: x_return_status := G_RET_UNEXPECTED;
732: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
733: p_count => x_msg_count ,
734: p_data => x_error_msg
735: );
736: WHEN OTHERS THEN

Line 742: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

738: ROLLBACK TO start_secondary_quantities;
739: x_return_status := G_RET_UNEXPECTED;
740:
741: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
742: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
743: THEN
744: WSM_log_PVT.handle_others( p_module_name => l_module ,
745: p_stmt_num => l_stmt_num ,
746: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

746: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
747: p_run_log_level => l_log_level
748: );
749: END IF;
750: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
751: p_count => x_msg_count ,
752: p_data => x_error_msg
753: );
754: END;

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

900:
901: ROLLBACK TO start_copy_wsm_op_reason_codes;
902:
903: x_return_status := G_RET_ERROR;
904: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
905: p_count => x_msg_count ,
906: p_data => x_error_msg
907: );
908:

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

910:
911: ROLLBACK TO start_copy_wsm_op_reason_codes;
912:
913: x_return_status := G_RET_UNEXPECTED;
914: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
915: p_count => x_msg_count ,
916: p_data => x_error_msg
917: );
918: WHEN OTHERS THEN

Line 924: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

920: ROLLBACK TO start_copy_wsm_op_reason_codes;
921:
922: x_return_status := G_RET_UNEXPECTED;
923: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
924: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
925: THEN
926: WSM_log_PVT.handle_others( p_module_name => l_module ,
927: p_stmt_num => l_stmt_num ,
928: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

928: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
929: p_run_log_level => l_log_level
930: );
931: END IF;
932: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
933: p_count => x_msg_count ,
934: p_data => x_error_msg
935: );
936: END ;

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

1090:
1091: ROLLBACK TO start_copy_wsm_subst_comp;
1092:
1093: x_return_status := G_RET_ERROR;
1094: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
1095: p_count => x_error_msg ,
1096: p_data => x_msg_count
1097: );
1098:

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

1100:
1101: ROLLBACK TO start_copy_wsm_subst_comp;
1102:
1103: x_return_status := G_RET_UNEXPECTED;
1104: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
1105: p_count => x_error_msg ,
1106: p_data => x_msg_count
1107: );
1108: WHEN OTHERS THEN

Line 1114: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

1110: ROLLBACK TO start_copy_wsm_subst_comp;
1111:
1112: x_return_status := G_RET_UNEXPECTED;
1113: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
1114: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
1115: THEN
1116: WSM_log_PVT.handle_others( p_module_name => l_module ,
1117: p_stmt_num => l_stmt_num ,
1118: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

1119: p_run_log_level => l_log_level
1120: );
1121: END IF;
1122:
1123: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
1124: p_count => x_error_msg ,
1125: p_data => x_msg_count
1126: );
1127:

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

1205: ELSIF l_qty_RUN > 0 THEN
1206: x_err_code := -1;
1207: x_err_buf := 'WSMPJUPD.GET_JOB_CURR_OP_INFO('||to_char(l_stmt_num)||'): Incorrect job status for this transaction';
1208:
1209: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
1210:
1211: l_msg_tokens.delete;
1212: WSM_log_PVT.logMessage(p_module_name => l_module ,
1213: p_msg_text => x_err_buf ,

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

1225: ELSE
1226: x_err_code := -1;
1227: x_err_buf := 'WSMPJUPD.GET_JOB_CURR_OP_INFO('||to_char(l_stmt_num)||'): Incorrect job status for this transaction';
1228:
1229: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
1230:
1231: l_msg_tokens.delete;
1232: WSM_log_PVT.logMessage(p_module_name => l_module ,
1233: p_msg_text => x_err_buf ,

Line 1259: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

1255: x_err_code := SQLCODE;
1256: x_err_buf := 'WSMPJUPD.GET_JOB_CURR_OP_INFO('||to_char(l_stmt_num)||'): '||substrb(sqlerrm,1,1000);
1257:
1258: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
1259: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
1260: THEN
1261: WSM_log_PVT.handle_others( p_module_name => l_module ,
1262: p_stmt_num => l_stmt_num ,
1263: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

Line 1541: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

1537: x_err_code := SQLCODE;
1538: x_err_buf := ' WSMPJUPD.COPY_REP_JOB_WO_FA('||l_stmt_num||'): '||substrb(sqlerrm,1,1000);
1539:
1540: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
1541: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
1542: THEN
1543: WSM_log_PVT.handle_others( p_module_name => l_module ,
1544: p_stmt_num => l_stmt_num ,
1545: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

Line 1698: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

1694: x_err_code := SQLCODE;
1695: x_err_buf := ' WSMPJUPD.COPY_REP_JOB_WOR('||l_stmt_num||'): '||substrb(sqlerrm,1,1000);
1696:
1697: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
1698: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
1699: THEN
1700: WSM_log_PVT.handle_others( p_module_name => l_module ,
1701: p_stmt_num => l_stmt_num ,
1702: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

Line 1873: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

1869: x_err_code := SQLCODE;
1870: x_err_buf := ' WSMPJUPD.COPY_REP_JOB_WSOR('||l_stmt_num||'): '||substrb(sqlerrm,1,1000);
1871:
1872: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
1873: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
1874: THEN
1875: WSM_log_PVT.handle_others( p_module_name => l_module ,
1876: p_stmt_num => l_stmt_num ,
1877: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

Line 1961: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

1957: x_err_code := SQLCODE;
1958: x_err_buf := ' WSMPJUPD.COPY_REP_JOB_WORI('||l_stmt_num||'): '||substrb(sqlerrm,1,1000);
1959:
1960: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
1961: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
1962: THEN
1963: WSM_log_PVT.handle_others( p_module_name => l_module ,
1964: p_stmt_num => l_stmt_num ,
1965: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

Line 2179: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

2175: x_err_code := SQLCODE;
2176: x_err_buf := ' WSMPJUPD.COPY_REP_JOB_WRO('||l_stmt_num||'): '||substrb(sqlerrm,1,1000);
2177:
2178: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
2179: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
2180: THEN
2181: WSM_log_PVT.handle_others( p_module_name => l_module ,
2182: p_stmt_num => l_stmt_num ,
2183: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

Line 2265: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

2261: x_err_code := SQLCODE;
2262: x_err_buf := ' WSMPJUPD.COPY_REP_JOB_WOY('||l_stmt_num||'): '||substrb(sqlerrm,1,1000);
2263:
2264: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
2265: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
2266: THEN
2267: WSM_log_PVT.handle_others( p_module_name => l_module ,
2268: p_stmt_num => l_stmt_num ,
2269: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

Line 2431: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

2427: x_err_code := SQLCODE;
2428: x_err_buf := ' WSMPJUPD.CHANGE_QUANTITY('||l_stmt_num||'): '||substrb(sqlerrm,1,1000);
2429:
2430: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
2431: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
2432: THEN
2433: WSM_log_PVT.handle_others( p_module_name => l_module ,
2434: p_stmt_num => l_stmt_num ,
2435: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

Line 2527: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

2523: x_err_code := SQLCODE;
2524: x_err_msg := 'WSMPJUPD.handle_kanban_sub_loc_change('||l_stmt_num||'): '||substrb(sqlerrm,1,1000);
2525:
2526: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
2527: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
2528: THEN
2529: WSM_log_PVT.handle_others( p_module_name => l_module ,
2530: p_stmt_num => l_stmt_num ,
2531: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

Line 2759: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

2755: x_err_code := SQLCODE;
2756: x_err_buf := 'WSMPJUPD.UPDATE_QTY_ISSUED('||l_stmt_num||'): '||substrb(sqlerrm,1,1000);
2757:
2758: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
2759: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
2760: THEN
2761: WSM_log_PVT.handle_others( p_module_name => l_module ,
2762: p_stmt_num => l_stmt_num ,
2763: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

Line 2935: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

2931: x_err_code := SQLCODE;
2932: x_err_buf := 'CREATE_WSOR_WLBJ_RECORDS('||l_stmt_num||'): '||substrb(sqlerrm,1,1000);
2933:
2934: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
2935: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
2936: THEN
2937: WSM_log_PVT.handle_others( p_module_name => l_module ,
2938: p_stmt_num => l_stmt_num ,
2939: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

3070:
3071:
3072:
3073: IF (x_err_code <> 0) THEN
3074: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
3075: l_msg_tokens.delete;
3076: WSM_log_PVT.logMessage(p_module_name => l_module ,
3077: p_msg_text => x_err_buf ,
3078: p_stmt_num => l_stmt_num ,

Line 3094: IF g_log_level_event >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_SUCCESS) then

3090: fnd_message.set_name('WSM', 'WSM_MANUAL_CHARGES_EXISTS');
3091: fnd_message.set_token('ELEMENT', 'Resources');
3092: l_fnd_err_msg := FND_MESSAGE.GET;
3093:
3094: IF g_log_level_event >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_SUCCESS) then
3095:
3096: l_msg_tokens.delete;
3097: l_msg_tokens(1).TokenName := 'ELEMENT';
3098: l_msg_tokens(1).TokenValue := 'Resources';

Line 3118: IF g_log_level_event >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_SUCCESS) then

3114: fnd_message.set_name('WSM', 'WSM_MANUAL_CHARGES_EXISTS');
3115: fnd_message.set_token('ELEMENT', 'Materials');
3116: l_fnd_err_msg := FND_MESSAGE.GET;
3117:
3118: IF g_log_level_event >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_SUCCESS) then
3119:
3120: l_msg_tokens.delete;
3121: l_msg_tokens(1).TokenName := 'ELEMENT';
3122: l_msg_tokens(1).TokenValue := 'Materials';

Line 3141: IF g_log_level_event >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_SUCCESS) then

3137: IF (l_manually_added_comp = 2) THEN
3138: fnd_message.set_name('WSM','WSM_PHANTOM_COMPONENTS_EXISTS');
3139: l_fnd_err_msg := FND_MESSAGE.GET;
3140:
3141: IF g_log_level_event >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_SUCCESS) then
3142:
3143: l_msg_tokens.delete;
3144: WSM_log_PVT.logMessage(p_module_name => l_module ,
3145: p_msg_name => 'WSM_PHANTOM_COMPONENTS_EXISTS',

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

3291: );
3292:
3293: IF (x_err_code <> 0) THEN
3294:
3295: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
3296: l_msg_tokens.delete;
3297: WSM_log_PVT.logMessage(p_module_name => l_module ,
3298: p_msg_text => 'Returned failure from WSMPLBJI.insert_procedure.Error:'|| x_err_buf,
3299: p_stmt_num => l_stmt_num ,

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

3341: );
3342:
3343:
3344: IF (x_err_code <> 0) THEN
3345: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
3346:
3347: l_msg_tokens.delete;
3348: WSM_log_PVT.logMessage(p_module_name => l_module ,
3349: p_msg_text => 'Returned failure from CREATE_WSOR_WLBJ_RECORDS',

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

3407: x_err_buf := l_fnd_err_msg;
3408: WHEN FND_API.G_EXC_ERROR THEN
3409: x_err_code := SQLCODE;
3410: x_err_buf := ' WSMPJUPD.CHANGE_ROUTING('||l_stmt_num||'): '||substrb(sqlerrm,1,1000);
3411: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F',
3412: p_count => x_msg_count ,
3413: p_data => x_err_buf
3414: );
3415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

3414: );
3415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3416: x_err_code := SQLCODE;
3417: x_err_buf := ' WSMPJUPD.CHANGE_ROUTING('||l_stmt_num||'): '||substrb(sqlerrm,1,1000);
3418: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F',
3419: p_count => x_msg_count ,
3420: p_data => x_err_buf
3421: );
3422: WHEN OTHERS THEN

Line 3427: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

3423: x_err_code := SQLCODE;
3424: x_err_buf := ' WSMPJUPD.CHANGE_ROUTING('||l_stmt_num||'): '||substrb(sqlerrm,1,1000);
3425:
3426: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
3427: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
3428: THEN
3429: WSM_log_PVT.handle_others( p_module_name => l_module ,
3430: p_stmt_num => l_stmt_num ,
3431: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

3506: x_err_msg => x_err_buf
3507: );
3508:
3509: IF (x_err_code <> 0) THEN
3510: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
3511:
3512: l_msg_tokens.delete;
3513: WSM_log_PVT.logMessage(p_module_name => l_module ,
3514: p_msg_text => 'Handle_kanban_sub_loc_change returned error: ' || x_err_buf,

Line 3578: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN

3574:
3575: fnd_message.set_token('STATUS',g_translated_meaning);
3576: x_err_buf := fnd_message.get;
3577:
3578: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
3579:
3580: l_msg_tokens.delete;
3581: l_msg_tokens(1).TokenName := 'STATUS';
3582: l_msg_tokens(1).TokenValue := g_translated_meaning;

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

3639: x_err_buf => x_err_buf
3640: );
3641:
3642: IF (x_err_code <> 0) THEN
3643: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
3644:
3645: l_msg_tokens.delete;
3646: WSM_log_PVT.logMessage(p_module_name => l_module ,
3647: p_msg_text => 'CHANGE_ROUTING returned error:'||x_err_buf,

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

3732: EXCEPTION
3733: WHEN FND_API.G_EXC_ERROR THEN
3734: x_err_code := -1;
3735: x_err_buf := ' WSMPJUPD.UPDATE_ASSEMBLY_OR_ROUTING('||l_stmt_num||'): '||x_err_buf;
3736: FND_MSG_PUB.Count_And_Get (p_encoded => 'F',
3737: p_count => x_msg_count ,
3738: p_data => x_err_buf
3739: );
3740:

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

3740:
3741: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3742: x_err_code := -1;
3743: x_err_buf := ' WSMPJUPD.UPDATE_ASSEMBLY_OR_ROUTING('||l_stmt_num||'): '||x_err_buf;
3744: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F',
3745: p_count => x_msg_count ,
3746: p_data => x_err_buf
3747: );
3748: WHEN OTHERS THEN

Line 3753: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

3749: x_err_code := SQLCODE;
3750: x_err_buf := ' WSMPJUPD.UPDATE_ASSEMBLY_OR_ROUTING('||l_stmt_num||'): '||substrb(sqlerrm,1,1000);
3751:
3752: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
3753: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
3754: THEN
3755: WSM_log_PVT.handle_others( p_module_name => l_module ,
3756: p_stmt_num => l_stmt_num ,
3757: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

3817: p_txn_date);
3818: --End NL BugFix 3126650
3819:
3820: IF (l_err_code <> 0) THEN
3821: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
3822:
3823: l_msg_tokens.delete;
3824: WSM_log_PVT.logMessage(p_module_name => l_module ,
3825: p_msg_text => 'WSMPUTIL.GET_INV_ACCT_PERIOD returned error:' || l_err_buf,

Line 3920: IF g_log_level_event >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_SUCCESS) then

3916:
3917: --Start additions to fix bug #3048394--
3918: IF (SQL%ROWCOUNT <> 1) THEN
3919:
3920: IF g_log_level_event >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_SUCCESS) then
3921:
3922: l_msg_tokens.delete;
3923: l_msg_tokens(1).TokenName := 'ELEMENT';
3924: l_msg_tokens(1).TokenValue := 'mtl_material_transactions';

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

3940: exception
3941: WHEN FND_API.G_EXC_ERROR THEN
3942:
3943: x_return_status := G_RET_ERROR;
3944: FND_MSG_PUB.Count_And_Get (p_encoded => 'F',
3945: p_count => x_msg_count ,
3946: p_data => x_msg_data
3947: );
3948:

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

3949: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3950:
3951: x_return_status := G_RET_UNEXPECTED;
3952:
3953: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F',
3954: p_count => x_msg_count ,
3955: p_data => x_msg_data
3956: );
3957: when others then

Line 3974: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

3970:
3971: END IF;
3972:
3973: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
3974: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
3975: THEN
3976: WSM_log_PVT.handle_others( p_module_name => l_module ,
3977: p_stmt_num => l_stmt_num ,
3978: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

4113: (x_err_code = -1) -- Warning
4114: THEN
4115: x_err_code := 0; -- Fix for bug #3421662 --
4116: ELSE
4117: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
4118: l_msg_tokens.delete;
4119: WSM_log_PVT.logMessage(p_module_name => l_module ,
4120: p_msg_text => 'WSM_JobCopies_PVT.Create_JobCopies returned error:' || x_err_buf,
4121: p_stmt_num => l_stmt_num ,

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

4230: p_inf_sch_date => NULL
4231: );
4232:
4233: IF (x_err_code <> 0) THEN
4234: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
4235:
4236: l_msg_tokens.delete;
4237: WSM_log_PVT.logMessage(p_module_name => l_module ,
4238: p_msg_text => 'WSM_JobCopies_PVT.Create_RepJobCopies returned error:' || x_err_buf,

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

4375: (x_err_code = -1) -- Warning
4376: THEN
4377: x_err_code := 0; -- Fix for bug #3421662 --
4378: ELSE
4379: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
4380:
4381: l_msg_tokens.delete;
4382: WSM_log_PVT.logMessage(p_module_name => l_module ,
4383: p_msg_text => 'WSM_JobCopies_PVT.Create_JobCopies returned error:' || x_err_buf,

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

4507: (x_err_code = -1) -- Warning
4508: THEN
4509: x_err_code := 0; -- Fix for bug #3421662 --
4510: ELSE
4511: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
4512:
4513: l_msg_tokens.delete;
4514: WSM_log_PVT.logMessage(p_module_name => l_module ,
4515: p_msg_text => 'WSM_JobCopies_PVT.Create_JobCopies returned error:' || x_err_buf,

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

4569: WHEN FND_API.G_EXC_ERROR THEN
4570: x_err_code := SQLCODE;
4571: x_err_buf := ' WSMPJUPD.CREATE_COPIES_OR_SET_COPY_DATA('||l_stmt_num||'): '||x_err_buf;
4572:
4573: FND_MSG_PUB.Count_And_Get (p_encoded => 'F',
4574: p_count => x_msg_count ,
4575: p_data => x_err_buf
4576: );
4577:

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

4579:
4580: x_err_code := SQLCODE;
4581: x_err_buf := ' WSMPJUPD.CREATE_COPIES_OR_SET_COPY_DATA('||l_stmt_num||'): '||x_err_buf;
4582:
4583: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F',
4584: p_count => x_msg_count ,
4585: p_data => x_err_buf
4586: );
4587:

Line 4594: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

4590: x_err_code := SQLCODE;
4591: x_err_buf := ' WSMPJUPD.CREATE_COPIES_OR_SET_COPY_DATA('||l_stmt_num||'): '||substrb(sqlerrm,1,1000);
4592:
4593: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
4594: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
4595: THEN
4596: WSM_log_PVT.handle_others( p_module_name => l_module ,
4597: p_stmt_num => l_stmt_num ,
4598: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

4664: x_msg_count => x_msg_count
4665: );
4666:
4667: IF (x_err_code <> 0) THEN
4668: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
4669: l_msg_tokens.delete;
4670: WSM_log_PVT.logMessage(p_module_name => l_module ,
4671: p_msg_text => 'GET_JOB_CURR_OP_INFO returned error:' || x_err_buf,
4672: p_stmt_num => l_stmt_num ,

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

4701: );
4702:
4703: IF(l_returnStatus <> FND_API.G_RET_STS_SUCCESS) THEN
4704: x_err_code := -1;
4705: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
4706: l_msg_tokens.delete;
4707: WSM_log_PVT.logMessage(p_module_name => l_module ,
4708: p_msg_text => 'WSM_infinite_scheduler_PVT.schedule returned error:' || x_err_buf,
4709: p_stmt_num => l_stmt_num ,

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

4735:
4736: x_err_code := SQLCODE;
4737: x_err_buf := ' WSMPJUPD.CALL_INF_SCH_OR_SET_SCH_DATA('||l_stmt_num||'): '||x_err_buf;
4738: /*
4739: FND_MSG_PUB.Count_And_Get (p_encoded => 'F',
4740: p_count => x_msg_count ,
4741: p_data => x_err_buf
4742: );
4743: */

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

4745:
4746: x_err_code := SQLCODE;
4747: x_err_buf := ' WSMPJUPD.CALL_INF_SCH_OR_SET_SCH_DATA('||l_stmt_num||'): '||x_err_buf;
4748: /*
4749: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F',
4750: p_count => x_msg_count ,
4751: p_data => x_err_buf
4752: );
4753: */

Line 4759: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

4755: x_err_code := SQLCODE;
4756: x_err_buf := ' WSMPJUPD.CALL_INF_SCH_OR_SET_SCH_DATA('||l_stmt_num||'): '||substrb(sqlerrm,1,1000);
4757:
4758: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
4759: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
4760: THEN
4761: WSM_log_PVT.handle_others( p_module_name => l_module ,
4762: p_stmt_num => l_stmt_num ,
4763: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

5120: l_stmt_num := 70;
5121:
5122: IF (l_err_code <> 0) THEN
5123:
5124: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
5125:
5126: l_msg_tokens.delete;
5127: WSM_log_PVT.logMessage(p_module_name => l_module ,
5128: p_msg_text => 'Returned failure from WSMPLBJI.build_lbji_info procedure' ,

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

5251:
5252: l_stmt_num := 80;
5253:
5254: IF (l_err_code <> 0) THEN
5255: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
5256:
5257: l_msg_tokens.delete;
5258: WSM_log_PVT.logMessage(p_module_name => l_module ,
5259: p_msg_text => 'Returned failure from WSM_lbj_interface_PVT.build_job_header_info'||l_err_buf,

Line 5337: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN

5333: p_replenish_quantity => p_wltx_resulting_jobs_tbl(l_job_counter).start_quantity
5334: );
5335:
5336: if ( l_ret_status <> fnd_api.g_ret_sts_success ) then
5337: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
5338:
5339: l_msg_tokens.delete;
5340: l_msg_tokens(1).TokenName := 'STATUS';
5341: l_msg_tokens(1).TokenValue := g_translated_meaning;

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

5407: x_err_buf => l_err_buf
5408: );
5409:
5410: IF (l_err_code <> 0) THEN
5411: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
5412:
5413: l_msg_tokens.delete;
5414: WSM_log_PVT.logMessage(p_module_name => l_module ,
5415: p_msg_text => 'Returned failure from COPY_REP_JOB_WO_FA',

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

5446: x_err_code => l_err_code,
5447: x_err_buf => l_err_buf);
5448:
5449: IF (l_err_code <> 0) THEN
5450: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
5451:
5452: l_msg_tokens.delete;
5453: WSM_log_PVT.logMessage(p_module_name => l_module ,
5454: p_msg_text => 'Returned failure from COPY_REP_JOB_WOR',

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

5493: x_err_buf => l_err_buf
5494: );
5495:
5496: IF (l_err_code <> 0) THEN
5497: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
5498:
5499: l_msg_tokens.delete;
5500: WSM_log_PVT.logMessage(p_module_name => l_module ,
5501: p_msg_text => 'Returned failure from COPY_REP_JOB_WSOR',

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

5524: x_err_code => l_err_code,
5525: x_err_buf => l_err_buf
5526: );
5527: IF (l_err_code <> 0) THEN
5528: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
5529:
5530: l_msg_tokens.delete;
5531: WSM_log_PVT.logMessage(p_module_name => l_module ,
5532: p_msg_text => 'Returned failure from COPY_REP_JOB_WORI',

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

5567: x_err_buf => l_err_buf
5568: );
5569:
5570: IF (l_err_code <> 0) THEN
5571: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
5572:
5573: l_msg_tokens.delete;
5574: WSM_log_PVT.logMessage(p_module_name => l_module ,
5575: p_msg_text => 'Returned failure from COPY_REP_JOB_WRO',

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

5607: x_err_buf => l_err_buf
5608: );
5609:
5610: IF (l_err_code <> 0) THEN
5611: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
5612: l_msg_tokens.delete;
5613: WSM_log_PVT.logMessage(p_module_name => l_module ,
5614: p_msg_text => 'Returned failure from COPY_REP_JOB_WOY',
5615: p_stmt_num => l_stmt_num ,

Line 5710: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN

5706: );
5707:
5708: if ( l_ret_status <> fnd_api.g_ret_sts_success ) then
5709:
5710: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
5711:
5712: l_msg_tokens.delete;
5713: l_msg_tokens(1).TokenName := 'STATUS';
5714: l_msg_tokens(1).TokenValue := g_translated_meaning;

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

5753: x_err_msg => l_err_buf
5754: );
5755:
5756: IF (l_err_code <> 0) THEN
5757: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
5758:
5759: l_msg_tokens.delete;
5760: WSM_log_PVT.logMessage(p_module_name => l_module ,
5761: p_msg_text => 'Returned failure from handle_kanban_sub_loc_change',

Line 5802: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN

5798: p_replenish_quantity => p_wltx_resulting_jobs_tbl(l_sj_also_rj_index).start_quantity
5799: );
5800:
5801: if ( l_ret_Status <> fnd_api.g_ret_sts_success ) then
5802: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
5803:
5804: l_msg_tokens.delete;
5805: l_msg_tokens(1).TokenName := 'STATUS';
5806: l_msg_tokens(1).TokenValue := g_translated_meaning;

Line 5908: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN

5904: p_Supply_Status => INV_Kanban_PVT.G_Supply_Status_Exception
5905: );
5906:
5907: if ( l_ret_Status <> fnd_api.g_ret_sts_success ) then
5908: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
5909:
5910: l_msg_tokens.delete;
5911: l_msg_tokens(1).TokenName := 'STATUS';
5912: l_msg_tokens(1).TokenValue := g_translated_meaning;

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

5959: x_error_msg => l_err_buf
5960: );
5961:
5962: if l_err_code <> 0 then
5963: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
5964: l_msg_tokens.delete;
5965: /* Start bugfix 5738550 Use hardcoded text only if API call did not return message */
5966: if l_err_buf is null then
5967: l_err_buf := 'Returned failure from WSMPOPRN.update_job_name';

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

6032: x_err_buf => l_err_buf
6033: );
6034:
6035: IF (l_err_code <> 0) THEN
6036: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6037: l_msg_tokens.delete;
6038: WSM_log_PVT.logMessage(p_module_name => l_module ,
6039: p_msg_text => 'CHANGE_QUANTITY returned failure' ,
6040: p_stmt_num => l_stmt_num ,

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

6076: x_err_buf => l_err_buf
6077: );
6078:
6079: if l_err_code <> 0 then
6080: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6081:
6082: l_msg_tokens.delete;
6083: WSM_log_PVT.logMessage(p_module_name => l_module ,
6084: p_msg_text => 'UPDATE_QTY_ISSUED returned failure' ,

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

6133: x_msg_count => x_msg_count
6134: );
6135:
6136: IF (l_err_code <> 0) THEN
6137: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6138:
6139: l_msg_tokens.delete;
6140: WSM_log_PVT.logMessage(p_module_name => l_module ,
6141: p_msg_text => 'UPDATE_ASSEMBLY_OR_ROUTING returned failure' ,

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

6207: );
6208:
6209:
6210: IF (l_err_code <> 0) THEN
6211: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6212:
6213: l_msg_tokens.delete;
6214: WSM_log_PVT.logMessage(p_module_name => l_module ,
6215: p_msg_text => 'CREATE_COPIES_OR_SET_COPY_DATA returned '||l_err_code,

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

6248: );
6249:
6250: IF (l_err_code <> 0) THEN
6251: -- error out...
6252: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6253:
6254: l_msg_tokens.delete;
6255: WSM_log_PVT.logMessage(p_module_name => l_module ,
6256: p_msg_text => ' CALL_INF_SCH_OR_SET_SCH_DATA returned '||l_err_code,

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

6356: End if;
6357:
6358: ELSE
6359:
6360: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6361:
6362: l_msg_tokens.delete;
6363: WSM_log_PVT.logMessage(p_module_name => l_module ,
6364: p_msg_text => 'inv_genealogy_pub.insert_genealogy failed',

Line 6382: l_err_buf := fnd_msg_pub.get;

6378:
6379: ELSE
6380: FOR i IN 1..l_msg_count LOOP
6381: l_err_code := -1;
6382: l_err_buf := fnd_msg_pub.get;
6383:
6384: END LOOP;
6385:
6386: l_err_buf := 'Multiple errors in inv_genealogy_pub.insert_genealogy - populated in the log file';

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

6460: p_run_log_level => l_log_level
6461: );
6462: End if;
6463: ELSE
6464: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6465:
6466: l_msg_tokens.delete;
6467: WSM_log_PVT.logMessage(p_module_name => l_module ,
6468: p_msg_text => 'inv_genealogy_pub.insert_genealogy failed',

Line 6484: l_err_buf := fnd_msg_pub.get;

6480: l_err_buf := 'Error in inv_genealogy_pub.insert_genealogy: '||l_msg_data;
6481: ELSE
6482: FOR i IN 1..l_msg_count LOOP
6483: l_err_code := -1;
6484: l_err_buf := fnd_msg_pub.get;
6485: END LOOP;
6486:
6487: l_err_buf := 'Multiple errors in inv_genealogy_pub.insert_genealogy - populated in the log file';
6488:

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

6517:
6518: if l_ret_status <> fnd_api.g_ret_sts_success then
6519: -- error out...
6520: l_stmt_num := 395;
6521: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6522: l_msg_tokens.delete;
6523: WSM_log_PVT.logMessage(p_module_name => l_module ,
6524: p_msg_text => 'Insert_MMT_record failed',
6525: p_stmt_num => l_stmt_num ,

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

6558: x_msg_count => x_msg_count
6559: );
6560:
6561: IF (l_err_code <> 0) THEN
6562: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6563: l_msg_tokens.delete;
6564: WSM_log_PVT.logMessage(p_module_name => l_module ,
6565: p_msg_text => 'UPDATE_ASSEMBLY_OR_ROUTING failed',
6566: p_stmt_num => l_stmt_num ,

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

6588: x_err_buf => l_err_buf,
6589: x_msg_count => x_msg_count
6590: );
6591: IF (l_err_code <> 0) THEN
6592: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6593:
6594: l_msg_tokens.delete;
6595: WSM_log_PVT.logMessage(p_module_name => l_module ,
6596: p_msg_text => 'CREATE_COPIES_OR_SET_COPY_DATA failed',

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

6663: x_err_buf => l_err_buf
6664: );
6665:
6666: IF (l_err_code <> 0) THEN
6667: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6668:
6669: l_msg_tokens.delete;
6670: WSM_log_PVT.logMessage(p_module_name => l_module ,
6671: p_msg_text => 'CHANGE_QUANTITY failed',

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

6703: x_err_buf => l_err_buf
6704: );
6705:
6706: if l_err_code <> 0 then
6707: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6708:
6709: l_msg_tokens.delete;
6710: WSM_log_PVT.logMessage(p_module_name => l_module ,
6711: p_msg_text => 'UPDATE_QTY_ISSUED failed',

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

6741: x_err_msg => l_err_buf
6742: );
6743:
6744: IF (l_err_code <> 0) THEN
6745: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6746:
6747: l_msg_tokens.delete;
6748: WSM_log_PVT.logMessage(p_module_name => l_module ,
6749: p_msg_text => 'handle_kanban_sub_loc_change failed',

Line 6784: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN

6780: --x_err_code := -1;
6781: fnd_message.set_name('WSM', 'WSM_KNBN_CARD_STS_FAIL');
6782: fnd_message.set_token('STATUS',g_translated_meaning);
6783: --x_err_buf := fnd_message.get;
6784: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
6785:
6786: l_msg_tokens.delete;
6787: l_msg_tokens(1).TokenName := 'STATUS';
6788: l_msg_tokens(1).TokenValue := g_translated_meaning;

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

6876: );
6877:
6878: IF (l_err_code <> 0) THEN
6879: -- error out...
6880: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6881:
6882: l_msg_tokens.delete;
6883: WSM_log_PVT.logMessage(p_module_name => l_module ,
6884: p_msg_text => 'CALL_INF_SCH_OR_SET_SCH_DATA returned failure:'||l_err_code,

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

6940:
6941: if l_ret_status <> fnd_api.g_ret_sts_success then
6942: -- error out...
6943: l_stmt_num := 395;
6944: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6945:
6946: l_msg_tokens.delete;
6947: WSM_log_PVT.logMessage(p_module_name => l_module ,
6948: p_msg_text => 'Insert_MMT_record failed',

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

7016: elsif p_wltx_header.transaction_type_id = WSMPCNST.BONUS then
7017: if p_wltx_resulting_jobs_tbl.count > 0 then
7018: l_rj_index := p_wltx_resulting_jobs_tbl.first;
7019: else
7020: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
7021:
7022: l_msg_tokens.delete;
7023: WSM_log_PVT.logMessage(p_module_name=> l_module ,
7024: p_msg_name => 'WSM_RESULT_LOT_REQUIRED',

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

7133: l_stmt_num := 70;
7134:
7135: IF (l_err_code <> 0) THEN
7136: --remove this
7137: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
7138:
7139: l_msg_tokens.delete;
7140: WSM_log_PVT.logMessage(p_module_name => l_module ,
7141: p_msg_text => 'Returned failure from WSMPLBJI.build_lbji_info procedure'||l_err_buf,

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

7314: l_acct_period_id := WSMPUTIL.GET_INV_ACCT_PERIOD(l_err_code, l_err_buf, p_wltx_resulting_jobs_tbl(l_rj_index).organization_id, p_wltx_header.transaction_date);
7315:
7316: IF (l_err_code <> 0) THEN
7317: /*error out*/
7318: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
7319:
7320: l_msg_tokens.delete;
7321: WSM_log_PVT.logMessage(p_module_name => l_module ,
7322: p_msg_text => 'Accounting Period not open',

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

7364: );
7365: if l_ret_status <> fnd_api.g_ret_sts_success then
7366: -- error out...
7367: l_stmt_num := 395;
7368: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
7369:
7370: l_msg_tokens.delete;
7371: WSM_log_PVT.logMessage(p_module_name => l_module ,
7372: p_msg_text => 'Insert_MMT_record failed:'||l_msg_data,

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

7396: x_msg_count => x_msg_count
7397: );
7398:
7399: IF (l_err_code <> 0) THEN
7400: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
7401:
7402: l_msg_tokens.delete;
7403: WSM_log_PVT.logMessage(p_module_name => l_module ,
7404: p_msg_text => 'CREATE_COPIES_OR_SET_COPY_DATA returned failure ' || l_err_buf,

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

7442: l_txn_costed := WIP_CONSTANTS.pending;
7443:
7444: else
7445: -- error out....
7446: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
7447:
7448: l_msg_tokens.delete;
7449: WSM_log_PVT.logMessage(p_module_name => l_module ,
7450: p_msg_text => 'Invalid Txn type',

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

7585:
7586: WHEN FND_API.G_EXC_ERROR THEN
7587: x_return_status := FND_API.G_RET_STS_ERROR ;
7588:
7589: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
7590: p_count => x_msg_count ,
7591: p_data => x_error_msg
7592: );
7593:

Line 7599: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

7595:
7596: x_return_status := G_RET_UNEXPECTED;
7597:
7598: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
7599: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
7600: THEN
7601: WSM_log_PVT.handle_others( p_module_name => l_module ,
7602: p_stmt_num => l_stmt_num ,
7603: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

7604: p_run_log_level => l_log_level
7605: );
7606: END IF;
7607:
7608: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
7609: p_count => x_msg_count ,
7610: p_data => x_error_msg
7611: );
7612: WHEN OTHERS THEN

Line 7617: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

7613:
7614: x_return_status := G_RET_UNEXPECTED;
7615:
7616: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
7617: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
7618: THEN
7619: WSM_log_PVT.handle_others( p_module_name => l_module ,
7620: p_stmt_num => l_stmt_num ,
7621: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

7622: p_run_log_level => l_log_level
7623: );
7624: END IF;
7625:
7626: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
7627: p_count => x_msg_count ,
7628: p_data => x_error_msg
7629: );
7630: