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_EXIST');
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 3116: IF g_log_level_event >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_SUCCESS) then

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

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

3133: IF (l_manually_added_comp = 2) THEN
3134: fnd_message.set_name('WSM','WSM_PHANTOM_COMPONENTS_EXIST');
3135: l_fnd_err_msg := FND_MESSAGE.GET;
3136:
3137: IF g_log_level_event >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_SUCCESS) then
3138:
3139: l_msg_tokens.delete;
3140: WSM_log_PVT.logMessage(p_module_name => l_module ,
3141: p_msg_name => 'WSM_PHANTOM_COMPONENTS_EXIST',

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

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

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

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

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

3401: EXCEPTION
3402: WHEN FND_API.G_EXC_ERROR THEN
3403: x_err_code := SQLCODE;
3404: x_err_buf := ' WSMPJUPD.CHANGE_ROUTING('||l_stmt_num||'): '||substrb(sqlerrm,1,1000);
3405: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F',
3406: p_count => x_msg_count ,
3407: p_data => x_err_buf
3408: );
3409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

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

Line 3421: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

3417: x_err_code := SQLCODE;
3418: x_err_buf := ' WSMPJUPD.CHANGE_ROUTING('||l_stmt_num||'): '||substrb(sqlerrm,1,1000);
3419:
3420: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
3421: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
3422: THEN
3423: WSM_log_PVT.handle_others( p_module_name => l_module ,
3424: p_stmt_num => l_stmt_num ,
3425: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

3500: x_err_msg => x_err_buf
3501: );
3502:
3503: IF (x_err_code <> 0) THEN
3504: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
3505:
3506: l_msg_tokens.delete;
3507: WSM_log_PVT.logMessage(p_module_name => l_module ,
3508: p_msg_text => 'Handle_kanban_sub_loc_change returned error: ' || x_err_buf,

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

3568:
3569: fnd_message.set_token('STATUS',g_translated_meaning);
3570: x_err_buf := fnd_message.get;
3571:
3572: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
3573:
3574: l_msg_tokens.delete;
3575: l_msg_tokens(1).TokenName := 'STATUS';
3576: l_msg_tokens(1).TokenValue := g_translated_meaning;

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

3633: x_err_buf => x_err_buf
3634: );
3635:
3636: IF (x_err_code <> 0) THEN
3637: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
3638:
3639: l_msg_tokens.delete;
3640: WSM_log_PVT.logMessage(p_module_name => l_module ,
3641: p_msg_text => 'CHANGE_ROUTING returned error:'||x_err_buf,

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

3726: EXCEPTION
3727: WHEN FND_API.G_EXC_ERROR THEN
3728: x_err_code := -1;
3729: x_err_buf := ' WSMPJUPD.UPDATE_ASSEMBLY_OR_ROUTING('||l_stmt_num||'): '||x_err_buf;
3730: FND_MSG_PUB.Count_And_Get (p_encoded => 'F',
3731: p_count => x_msg_count ,
3732: p_data => x_err_buf
3733: );
3734:

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

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

Line 3747: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

3743: x_err_code := SQLCODE;
3744: x_err_buf := ' WSMPJUPD.UPDATE_ASSEMBLY_OR_ROUTING('||l_stmt_num||'): '||substrb(sqlerrm,1,1000);
3745:
3746: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
3747: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
3748: THEN
3749: WSM_log_PVT.handle_others( p_module_name => l_module ,
3750: p_stmt_num => l_stmt_num ,
3751: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

3811: p_txn_date);
3812: --End NL BugFix 3126650
3813:
3814: IF (l_err_code <> 0) THEN
3815: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
3816:
3817: l_msg_tokens.delete;
3818: WSM_log_PVT.logMessage(p_module_name => l_module ,
3819: p_msg_text => 'WSMPUTIL.GET_INV_ACCT_PERIOD returned error:' || l_err_buf,

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

3910:
3911: --Start additions to fix bug #3048394--
3912: IF (SQL%ROWCOUNT <> 1) THEN
3913:
3914: IF g_log_level_event >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_SUCCESS) then
3915:
3916: l_msg_tokens.delete;
3917: l_msg_tokens(1).TokenName := 'ELEMENT';
3918: l_msg_tokens(1).TokenValue := 'mtl_material_transactions';

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

3934: exception
3935: WHEN FND_API.G_EXC_ERROR THEN
3936:
3937: x_return_status := G_RET_ERROR;
3938: FND_MSG_PUB.Count_And_Get (p_encoded => 'F',
3939: p_count => x_msg_count ,
3940: p_data => x_msg_data
3941: );
3942:

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

3943: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3944:
3945: x_return_status := G_RET_UNEXPECTED;
3946:
3947: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F',
3948: p_count => x_msg_count ,
3949: p_data => x_msg_data
3950: );
3951: when others then

Line 3968: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

3964:
3965: END IF;
3966:
3967: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
3968: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
3969: THEN
3970: WSM_log_PVT.handle_others( p_module_name => l_module ,
3971: p_stmt_num => l_stmt_num ,
3972: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

4107: (x_err_code = -1) -- Warning
4108: THEN
4109: x_err_code := 0; -- Fix for bug #3421662 --
4110: ELSE
4111: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
4112: l_msg_tokens.delete;
4113: WSM_log_PVT.logMessage(p_module_name => l_module ,
4114: p_msg_text => 'WSM_JobCopies_PVT.Create_JobCopies returned error:' || x_err_buf,
4115: p_stmt_num => l_stmt_num ,

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

4222: p_inf_sch_date => NULL
4223: );
4224:
4225: IF (x_err_code <> 0) THEN
4226: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
4227:
4228: l_msg_tokens.delete;
4229: WSM_log_PVT.logMessage(p_module_name => l_module ,
4230: p_msg_text => 'WSM_JobCopies_PVT.Create_RepJobCopies returned error:' || x_err_buf,

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

4367: (x_err_code = -1) -- Warning
4368: THEN
4369: x_err_code := 0; -- Fix for bug #3421662 --
4370: ELSE
4371: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
4372:
4373: l_msg_tokens.delete;
4374: WSM_log_PVT.logMessage(p_module_name => l_module ,
4375: p_msg_text => 'WSM_JobCopies_PVT.Create_JobCopies returned error:' || x_err_buf,

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

4499: (x_err_code = -1) -- Warning
4500: THEN
4501: x_err_code := 0; -- Fix for bug #3421662 --
4502: ELSE
4503: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
4504:
4505: l_msg_tokens.delete;
4506: WSM_log_PVT.logMessage(p_module_name => l_module ,
4507: p_msg_text => 'WSM_JobCopies_PVT.Create_JobCopies returned error:' || x_err_buf,

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

4561: WHEN FND_API.G_EXC_ERROR THEN
4562: x_err_code := SQLCODE;
4563: x_err_buf := ' WSMPJUPD.CREATE_COPIES_OR_SET_COPY_DATA('||l_stmt_num||'): '||x_err_buf;
4564:
4565: FND_MSG_PUB.Count_And_Get (p_encoded => 'F',
4566: p_count => x_msg_count ,
4567: p_data => x_err_buf
4568: );
4569:

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

4571:
4572: x_err_code := SQLCODE;
4573: x_err_buf := ' WSMPJUPD.CREATE_COPIES_OR_SET_COPY_DATA('||l_stmt_num||'): '||x_err_buf;
4574:
4575: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F',
4576: p_count => x_msg_count ,
4577: p_data => x_err_buf
4578: );
4579:

Line 4586: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

4582: x_err_code := SQLCODE;
4583: x_err_buf := ' WSMPJUPD.CREATE_COPIES_OR_SET_COPY_DATA('||l_stmt_num||'): '||substrb(sqlerrm,1,1000);
4584:
4585: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
4586: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
4587: THEN
4588: WSM_log_PVT.handle_others( p_module_name => l_module ,
4589: p_stmt_num => l_stmt_num ,
4590: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

4656: x_msg_count => x_msg_count
4657: );
4658:
4659: IF (x_err_code <> 0) THEN
4660: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
4661: l_msg_tokens.delete;
4662: WSM_log_PVT.logMessage(p_module_name => l_module ,
4663: p_msg_text => 'GET_JOB_CURR_OP_INFO returned error:' || x_err_buf,
4664: p_stmt_num => l_stmt_num ,

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

4693: );
4694:
4695: IF(l_returnStatus <> FND_API.G_RET_STS_SUCCESS) THEN
4696: x_err_code := -1;
4697: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
4698: l_msg_tokens.delete;
4699: WSM_log_PVT.logMessage(p_module_name => l_module ,
4700: p_msg_text => 'WSM_infinite_scheduler_PVT.schedule returned error:' || x_err_buf,
4701: p_stmt_num => l_stmt_num ,

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

4727:
4728: x_err_code := SQLCODE;
4729: x_err_buf := ' WSMPJUPD.CALL_INF_SCH_OR_SET_SCH_DATA('||l_stmt_num||'): '||x_err_buf;
4730: /*
4731: FND_MSG_PUB.Count_And_Get (p_encoded => 'F',
4732: p_count => x_msg_count ,
4733: p_data => x_err_buf
4734: );
4735: */

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

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

Line 4751: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

4747: x_err_code := SQLCODE;
4748: x_err_buf := ' WSMPJUPD.CALL_INF_SCH_OR_SET_SCH_DATA('||l_stmt_num||'): '||substrb(sqlerrm,1,1000);
4749:
4750: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
4751: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
4752: THEN
4753: WSM_log_PVT.handle_others( p_module_name => l_module ,
4754: p_stmt_num => l_stmt_num ,
4755: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

5056: l_stmt_num := 70;
5057:
5058: IF (l_err_code <> 0) THEN
5059:
5060: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
5061:
5062: l_msg_tokens.delete;
5063: WSM_log_PVT.logMessage(p_module_name => l_module ,
5064: p_msg_text => 'Returned failure from WSMPLBJI.build_lbji_info procedure' ,

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

5187:
5188: l_stmt_num := 80;
5189:
5190: IF (l_err_code <> 0) THEN
5191: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
5192:
5193: l_msg_tokens.delete;
5194: WSM_log_PVT.logMessage(p_module_name => l_module ,
5195: p_msg_text => 'Returned failure from WSM_lbj_interface_PVT.build_job_header_info'||l_err_buf,

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

5269: p_replenish_quantity => p_wltx_resulting_jobs_tbl(l_job_counter).start_quantity
5270: );
5271:
5272: if ( l_ret_status <> fnd_api.g_ret_sts_success ) then
5273: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
5274:
5275: l_msg_tokens.delete;
5276: l_msg_tokens(1).TokenName := 'STATUS';
5277: l_msg_tokens(1).TokenValue := g_translated_meaning;

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

5343: x_err_buf => l_err_buf
5344: );
5345:
5346: IF (l_err_code <> 0) THEN
5347: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
5348:
5349: l_msg_tokens.delete;
5350: WSM_log_PVT.logMessage(p_module_name => l_module ,
5351: p_msg_text => 'Returned failure from COPY_REP_JOB_WO_FA',

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

5382: x_err_code => l_err_code,
5383: x_err_buf => l_err_buf);
5384:
5385: IF (l_err_code <> 0) THEN
5386: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
5387:
5388: l_msg_tokens.delete;
5389: WSM_log_PVT.logMessage(p_module_name => l_module ,
5390: p_msg_text => 'Returned failure from COPY_REP_JOB_WOR',

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

5429: x_err_buf => l_err_buf
5430: );
5431:
5432: IF (l_err_code <> 0) THEN
5433: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
5434:
5435: l_msg_tokens.delete;
5436: WSM_log_PVT.logMessage(p_module_name => l_module ,
5437: p_msg_text => 'Returned failure from COPY_REP_JOB_WSOR',

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

5460: x_err_code => l_err_code,
5461: x_err_buf => l_err_buf
5462: );
5463: IF (l_err_code <> 0) THEN
5464: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
5465:
5466: l_msg_tokens.delete;
5467: WSM_log_PVT.logMessage(p_module_name => l_module ,
5468: p_msg_text => 'Returned failure from COPY_REP_JOB_WORI',

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

5503: x_err_buf => l_err_buf
5504: );
5505:
5506: IF (l_err_code <> 0) THEN
5507: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
5508:
5509: l_msg_tokens.delete;
5510: WSM_log_PVT.logMessage(p_module_name => l_module ,
5511: p_msg_text => 'Returned failure from COPY_REP_JOB_WRO',

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

5543: x_err_buf => l_err_buf
5544: );
5545:
5546: IF (l_err_code <> 0) THEN
5547: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
5548: l_msg_tokens.delete;
5549: WSM_log_PVT.logMessage(p_module_name => l_module ,
5550: p_msg_text => 'Returned failure from COPY_REP_JOB_WOY',
5551: p_stmt_num => l_stmt_num ,

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

5642: );
5643:
5644: if ( l_ret_status <> fnd_api.g_ret_sts_success ) then
5645:
5646: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
5647:
5648: l_msg_tokens.delete;
5649: l_msg_tokens(1).TokenName := 'STATUS';
5650: l_msg_tokens(1).TokenValue := g_translated_meaning;

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

5689: x_err_msg => l_err_buf
5690: );
5691:
5692: IF (l_err_code <> 0) THEN
5693: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
5694:
5695: l_msg_tokens.delete;
5696: WSM_log_PVT.logMessage(p_module_name => l_module ,
5697: p_msg_text => 'Returned failure from handle_kanban_sub_loc_change',

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

5734: p_replenish_quantity => p_wltx_resulting_jobs_tbl(l_sj_also_rj_index).start_quantity
5735: );
5736:
5737: if ( l_ret_Status <> fnd_api.g_ret_sts_success ) then
5738: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
5739:
5740: l_msg_tokens.delete;
5741: l_msg_tokens(1).TokenName := 'STATUS';
5742: l_msg_tokens(1).TokenValue := g_translated_meaning;

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

5840: p_Supply_Status => INV_Kanban_PVT.G_Supply_Status_Exception
5841: );
5842:
5843: if ( l_ret_Status <> fnd_api.g_ret_sts_success ) then
5844: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
5845:
5846: l_msg_tokens.delete;
5847: l_msg_tokens(1).TokenName := 'STATUS';
5848: l_msg_tokens(1).TokenValue := g_translated_meaning;

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

5895: x_error_msg => l_err_buf
5896: );
5897:
5898: if l_err_code <> 0 then
5899: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
5900: l_msg_tokens.delete;
5901: /* Start bugfix 5738550 Use hardcoded text only if API call did not return message */
5902: if l_err_buf is null then
5903: l_err_buf := 'Returned failure from WSMPOPRN.update_job_name';

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

5968: x_err_buf => l_err_buf
5969: );
5970:
5971: IF (l_err_code <> 0) THEN
5972: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
5973: l_msg_tokens.delete;
5974: WSM_log_PVT.logMessage(p_module_name => l_module ,
5975: p_msg_text => 'CHANGE_QUANTITY returned failure' ,
5976: p_stmt_num => l_stmt_num ,

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

6012: x_err_buf => l_err_buf
6013: );
6014:
6015: if l_err_code <> 0 then
6016: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6017:
6018: l_msg_tokens.delete;
6019: WSM_log_PVT.logMessage(p_module_name => l_module ,
6020: p_msg_text => 'UPDATE_QTY_ISSUED returned failure' ,

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

6069: x_msg_count => x_msg_count
6070: );
6071:
6072: IF (l_err_code <> 0) THEN
6073: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6074:
6075: l_msg_tokens.delete;
6076: WSM_log_PVT.logMessage(p_module_name => l_module ,
6077: p_msg_text => 'UPDATE_ASSEMBLY_OR_ROUTING returned failure' ,

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

6143: );
6144:
6145:
6146: IF (l_err_code <> 0) THEN
6147: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6148:
6149: l_msg_tokens.delete;
6150: WSM_log_PVT.logMessage(p_module_name => l_module ,
6151: p_msg_text => 'CREATE_COPIES_OR_SET_COPY_DATA returned '||l_err_code,

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

6184: );
6185:
6186: IF (l_err_code <> 0) THEN
6187: -- error out...
6188: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6189:
6190: l_msg_tokens.delete;
6191: WSM_log_PVT.logMessage(p_module_name => l_module ,
6192: p_msg_text => ' CALL_INF_SCH_OR_SET_SCH_DATA returned '||l_err_code,

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

6292: End if;
6293:
6294: ELSE
6295:
6296: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6297:
6298: l_msg_tokens.delete;
6299: WSM_log_PVT.logMessage(p_module_name => l_module ,
6300: p_msg_text => 'inv_genealogy_pub.insert_genealogy failed',

Line 6318: l_err_buf := fnd_msg_pub.get;

6314:
6315: ELSE
6316: FOR i IN 1..l_msg_count LOOP
6317: l_err_code := -1;
6318: l_err_buf := fnd_msg_pub.get;
6319:
6320: END LOOP;
6321:
6322: l_err_buf := 'Multiple errors in inv_genealogy_pub.insert_genealogy - populated in the log file';

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

6396: p_run_log_level => l_log_level
6397: );
6398: End if;
6399: ELSE
6400: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6401:
6402: l_msg_tokens.delete;
6403: WSM_log_PVT.logMessage(p_module_name => l_module ,
6404: p_msg_text => 'inv_genealogy_pub.insert_genealogy failed',

Line 6420: l_err_buf := fnd_msg_pub.get;

6416: l_err_buf := 'Error in inv_genealogy_pub.insert_genealogy: '||l_msg_data;
6417: ELSE
6418: FOR i IN 1..l_msg_count LOOP
6419: l_err_code := -1;
6420: l_err_buf := fnd_msg_pub.get;
6421: END LOOP;
6422:
6423: l_err_buf := 'Multiple errors in inv_genealogy_pub.insert_genealogy - populated in the log file';
6424:

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

6453:
6454: if l_ret_status <> fnd_api.g_ret_sts_success then
6455: -- error out...
6456: l_stmt_num := 395;
6457: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6458: l_msg_tokens.delete;
6459: WSM_log_PVT.logMessage(p_module_name => l_module ,
6460: p_msg_text => 'Insert_MMT_record failed',
6461: p_stmt_num => l_stmt_num ,

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

6494: x_msg_count => x_msg_count
6495: );
6496:
6497: IF (l_err_code <> 0) THEN
6498: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6499: l_msg_tokens.delete;
6500: WSM_log_PVT.logMessage(p_module_name => l_module ,
6501: p_msg_text => 'UPDATE_ASSEMBLY_OR_ROUTING failed',
6502: p_stmt_num => l_stmt_num ,

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

6524: x_err_buf => l_err_buf,
6525: x_msg_count => x_msg_count
6526: );
6527: IF (l_err_code <> 0) THEN
6528: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6529:
6530: l_msg_tokens.delete;
6531: WSM_log_PVT.logMessage(p_module_name => l_module ,
6532: p_msg_text => 'UPDATE_ASSEMBLY_OR_ROUTING failed',

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

6599: x_err_buf => l_err_buf
6600: );
6601:
6602: IF (l_err_code <> 0) THEN
6603: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6604:
6605: l_msg_tokens.delete;
6606: WSM_log_PVT.logMessage(p_module_name => l_module ,
6607: p_msg_text => 'CHANGE_QUANTITY failed',

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

6639: x_err_buf => l_err_buf
6640: );
6641:
6642: if l_err_code <> 0 then
6643: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6644:
6645: l_msg_tokens.delete;
6646: WSM_log_PVT.logMessage(p_module_name => l_module ,
6647: p_msg_text => 'UPDATE_QTY_ISSUED failed',

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

6677: x_err_msg => l_err_buf
6678: );
6679:
6680: IF (l_err_code <> 0) THEN
6681: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6682:
6683: l_msg_tokens.delete;
6684: WSM_log_PVT.logMessage(p_module_name => l_module ,
6685: p_msg_text => 'handle_kanban_sub_loc_change failed',

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

6716: --x_err_code := -1;
6717: fnd_message.set_name('WSM', 'WSM_KNBN_CARD_STS_FAIL');
6718: fnd_message.set_token('STATUS',g_translated_meaning);
6719: --x_err_buf := fnd_message.get;
6720: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
6721:
6722: l_msg_tokens.delete;
6723: l_msg_tokens(1).TokenName := 'STATUS';
6724: l_msg_tokens(1).TokenValue := g_translated_meaning;

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

6812: );
6813:
6814: IF (l_err_code <> 0) THEN
6815: -- error out...
6816: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6817:
6818: l_msg_tokens.delete;
6819: WSM_log_PVT.logMessage(p_module_name => l_module ,
6820: p_msg_text => 'CALL_INF_SCH_OR_SET_SCH_DATA returned failure:'||l_err_code,

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

6876:
6877: if l_ret_status <> fnd_api.g_ret_sts_success then
6878: -- error out...
6879: l_stmt_num := 395;
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 => 'Insert_MMT_record failed',

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

6952: elsif p_wltx_header.transaction_type_id = WSMPCNST.BONUS then
6953: if p_wltx_resulting_jobs_tbl.count > 0 then
6954: l_rj_index := p_wltx_resulting_jobs_tbl.first;
6955: else
6956: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6957:
6958: l_msg_tokens.delete;
6959: WSM_log_PVT.logMessage(p_module_name=> l_module ,
6960: p_msg_name => 'WSM_RESULT_LOT_REQUIRED',

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

7069: l_stmt_num := 70;
7070:
7071: IF (l_err_code <> 0) THEN
7072: --remove this
7073: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
7074:
7075: l_msg_tokens.delete;
7076: WSM_log_PVT.logMessage(p_module_name => l_module ,
7077: p_msg_text => 'Returned failure from WSMPLBJI.build_lbji_info procedure'||l_err_buf,

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

7250: 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);
7251:
7252: IF (l_err_code <> 0) THEN
7253: /*error out*/
7254: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
7255:
7256: l_msg_tokens.delete;
7257: WSM_log_PVT.logMessage(p_module_name => l_module ,
7258: p_msg_text => 'Accounting Period not open',

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

7300: );
7301: if l_ret_status <> fnd_api.g_ret_sts_success then
7302: -- error out...
7303: l_stmt_num := 395;
7304: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
7305:
7306: l_msg_tokens.delete;
7307: WSM_log_PVT.logMessage(p_module_name => l_module ,
7308: p_msg_text => 'Insert_MMT_record failed:'||l_msg_data,

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

7332: x_msg_count => x_msg_count
7333: );
7334:
7335: IF (l_err_code <> 0) THEN
7336: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
7337:
7338: l_msg_tokens.delete;
7339: WSM_log_PVT.logMessage(p_module_name => l_module ,
7340: p_msg_text => 'CREATE_COPIES_OR_SET_COPY_DATA returned failure ' || l_err_buf,

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

7378: l_txn_costed := WIP_CONSTANTS.pending;
7379:
7380: else
7381: -- error out....
7382: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
7383:
7384: l_msg_tokens.delete;
7385: WSM_log_PVT.logMessage(p_module_name => l_module ,
7386: p_msg_text => 'Invalid Txn type',

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

7521:
7522: WHEN FND_API.G_EXC_ERROR THEN
7523: x_return_status := FND_API.G_RET_STS_ERROR ;
7524:
7525: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
7526: p_count => x_msg_count ,
7527: p_data => x_error_msg
7528: );
7529:

Line 7535: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

7531:
7532: x_return_status := G_RET_UNEXPECTED;
7533:
7534: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
7535: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
7536: THEN
7537: WSM_log_PVT.handle_others( p_module_name => l_module ,
7538: p_stmt_num => l_stmt_num ,
7539: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

7540: p_run_log_level => l_log_level
7541: );
7542: END IF;
7543:
7544: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
7545: p_count => x_msg_count ,
7546: p_data => x_error_msg
7547: );
7548: WHEN OTHERS THEN

Line 7553: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

7549:
7550: x_return_status := G_RET_UNEXPECTED;
7551:
7552: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
7553: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
7554: THEN
7555: WSM_log_PVT.handle_others( p_module_name => l_module ,
7556: p_stmt_num => l_stmt_num ,
7557: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

7558: p_run_log_level => l_log_level
7559: );
7560: END IF;
7561:
7562: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
7563: p_count => x_msg_count ,
7564: p_data => x_error_msg
7565: );
7566: