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_WLT_VALIDATE_PVT dependencies on FND_MSG_PUB

Line 15: g_msg_lvl_unexp_error NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ;

11: g_log_level_event number := FND_LOG.LEVEL_EVENT ;
12: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
13: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;
14:
15: g_msg_lvl_unexp_error NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ;
16: g_msg_lvl_error NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR ;
17: g_msg_lvl_success NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS ;
18: g_msg_lvl_debug_high NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH ;
19: g_msg_lvl_debug_medium NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM ;

Line 16: g_msg_lvl_error NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR ;

12: g_log_level_procedure number := FND_LOG.LEVEL_PROCEDURE ;
13: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;
14:
15: g_msg_lvl_unexp_error NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ;
16: g_msg_lvl_error NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR ;
17: g_msg_lvl_success NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS ;
18: g_msg_lvl_debug_high NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH ;
19: g_msg_lvl_debug_medium NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM ;
20: g_msg_lvl_debug_low NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ;

Line 17: g_msg_lvl_success NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS ;

13: g_log_level_statement number := FND_LOG.LEVEL_STATEMENT ;
14:
15: g_msg_lvl_unexp_error NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ;
16: g_msg_lvl_error NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR ;
17: g_msg_lvl_success NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS ;
18: g_msg_lvl_debug_high NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH ;
19: g_msg_lvl_debug_medium NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM ;
20: g_msg_lvl_debug_low NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ;
21:

Line 18: g_msg_lvl_debug_high NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH ;

14:
15: g_msg_lvl_unexp_error NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ;
16: g_msg_lvl_error NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR ;
17: g_msg_lvl_success NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS ;
18: g_msg_lvl_debug_high NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH ;
19: g_msg_lvl_debug_medium NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM ;
20: g_msg_lvl_debug_low NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ;
21:
22: g_ret_success varchar2(1) := FND_API.G_RET_STS_SUCCESS;

Line 19: g_msg_lvl_debug_medium NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM ;

15: g_msg_lvl_unexp_error NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ;
16: g_msg_lvl_error NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR ;
17: g_msg_lvl_success NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS ;
18: g_msg_lvl_debug_high NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH ;
19: g_msg_lvl_debug_medium NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM ;
20: g_msg_lvl_debug_low NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ;
21:
22: g_ret_success varchar2(1) := FND_API.G_RET_STS_SUCCESS;
23: g_ret_error varchar2(1) := FND_API.G_RET_STS_ERROR;

Line 20: g_msg_lvl_debug_low NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ;

16: g_msg_lvl_error NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR ;
17: g_msg_lvl_success NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS ;
18: g_msg_lvl_debug_high NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH ;
19: g_msg_lvl_debug_medium NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM ;
20: g_msg_lvl_debug_low NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ;
21:
22: g_ret_success varchar2(1) := FND_API.G_RET_STS_SUCCESS;
23: g_ret_error varchar2(1) := FND_API.G_RET_STS_ERROR;
24: g_ret_unexpected varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

Line 104: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

100: else -- non-std job
101: if p_rtg_ref_id is null then
102:
103: IF g_log_level_error >= l_log_level OR
104: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
105: THEN
106: l_msg_tokens.delete;
107: WSM_log_PVT.logMessage(p_module_name => l_module ,
108: p_msg_name => 'WSM_NS_RTNG_REF_NULL' ,

Line 144: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

140: and bor.cfm_routing_flag = 3;
141: EXCEPTION
142: WHEN no_data_found then
143: IF g_log_level_error >= l_log_level OR
144: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
145: THEN
146: l_msg_tokens.delete;
147: l_msg_tokens(1).TokenName := 'FLD_NAME';
148: IF (p_job_type = 1) THEN -- std job

Line 201: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

197:
198: EXCEPTION
199: WHEN no_data_found then
200: IF g_log_level_error >= l_log_level OR
201: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
202: THEN
203: l_msg_tokens.delete;
204: l_msg_tokens(1).TokenName := 'FLD_NAME';
205: IF (p_job_type = 1) THEN -- std job

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

224:
225: EXCEPTION
226: WHEN FND_API.G_EXC_ERROR THEN
227: x_return_status := G_RET_ERROR;
228: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
229: p_count => x_error_count ,
230: p_data => x_error_msg
231: );
232:

Line 237: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

233: WHEN OTHERS THEN
234: x_return_status := G_RET_UNEXPECTED;
235:
236: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
237: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
238: THEN
239: WSM_log_PVT.handle_others( p_module_name => l_module ,
240: p_stmt_num => l_stmt_num ,
241: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

241: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
242: p_run_log_level => l_log_level
243: );
244: END IF;
245: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
246: p_count => x_error_count ,
247: p_data => x_error_msg
248: );
249: END routing_seq;

Line 338: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

334: WHEN too_many_rows THEN
335: null;
336: WHEN no_data_found THEN
337: IF g_log_level_error >= l_log_level OR
338: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
339: THEN
340: l_msg_tokens.delete;
341: l_msg_tokens(1).TokenName := 'FLD_NAME';
342: l_msg_tokens(1).TokenValue := 'Bom Reference Id';

Line 385: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

381: p_common_bom_seq_id := null; --VJ: Changed
382: --x_common_bom_seq_id := null; --VJ: Deleted
383: ELSE -- non-std job
384: IF g_log_level_error >= l_log_level OR
385: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
386: THEN
387: l_msg_tokens.delete;
388: WSM_log_PVT.logMessage(p_module_name => l_module ,
389: p_msg_name => 'WIP_BILL_DOES_NOT_EXIST',

Line 424: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

420: -- AND trunc(nvl(bad.disable_date, sysdate + 1)) > trunc(sysdate);
421: EXCEPTION
422: WHEN no_data_found then
423: IF g_log_level_error >= l_log_level OR
424: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
425: THEN
426: l_msg_tokens.delete;
427: l_msg_tokens(1).TokenName := 'FLD_NAME';
428: l_msg_tokens(1).TokenValue := 'ALTERNATE_BOM_DESIGNATOR';

Line 457: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

453:
454: EXCEPTION
455: WHEN no_data_found then
456: IF g_log_level_error >= l_log_level OR
457: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
458: THEN
459: l_msg_tokens.delete;
460: l_msg_tokens(1).TokenName := 'FLD_NAME';
461: l_msg_tokens(1).TokenValue := 'COMMON_BOM_SEQUENCE_ID';

Line 488: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

484:
485: EXCEPTION
486: WHEN no_data_found then
487: IF g_log_level_error >= l_log_level OR
488: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
489: THEN
490: l_msg_tokens.delete;
491: l_msg_tokens(1).TokenName := 'FLD_NAME';
492: l_msg_tokens(1).TokenValue := 'COMMON_BOM_SEQUENCE_ID';

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

527:
528: EXCEPTION
529: WHEN FND_API.G_EXC_ERROR THEN
530: x_return_status := G_RET_ERROR;
531: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
532: p_count => x_error_count ,
533: p_data => x_error_msg
534: );
535:

Line 540: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

536: WHEN OTHERS THEN
537: x_return_status := G_RET_UNEXPECTED;
538:
539: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
540: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
541: THEN
542: WSM_log_PVT.handle_others( p_module_name => l_module ,
543: p_stmt_num => l_stmt_num ,
544: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

544: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
545: p_run_log_level => l_log_level
546: );
547: END IF;
548: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
549: p_count => x_error_count ,
550: p_data => x_error_msg
551: );
552: END;

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

615: l_stmt_num := 20;
616:
617: -- job name should be less than 80 chars
618: IF LENGTH(p_job_name) > 80 THEN
619: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
620: l_msg_tokens.delete;
621: WSM_log_PVT.logMessage(p_module_name=> l_module ,
622: p_msg_name => 'WSM_JOB_NAME_THIRTY_CHAR',
623: p_msg_appl_name => 'WSM',

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

651: WHERE wip_entity_name = p_job_name
652: AND organization_id = p_org_id;
653:
654: IF l_temp_num = 1 then
655: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
656: l_msg_tokens.delete;
657: WSM_log_PVT.logMessage(p_module_name=> l_module ,
658: p_msg_name => 'WIP_ML_JOB_NAME',
659: p_msg_appl_name => 'WIP',

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

670: WHEN no_data_found THEN
671: null;
672:
673: WHEN OTHERS THEN
674: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
675: l_msg_tokens.delete;
676: WSM_log_PVT.logMessage(p_module_name=> l_module ,
677: p_msg_name => 'WIP_ML_JOB_NAME',
678: p_msg_appl_name => 'WIP',

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

700:
701: EXCEPTION
702: WHEN FND_API.G_EXC_ERROR THEN
703: x_return_status := G_RET_ERROR;
704: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
705: p_count => x_error_count ,
706: p_data => x_error_msg
707: );
708:

Line 713: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

709: WHEN OTHERS THEN
710: x_return_status := G_RET_UNEXPECTED;
711:
712: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
713: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
714: THEN
715: WSM_log_PVT.handle_others( p_module_name => l_module ,
716: p_stmt_num => l_stmt_num ,
717: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

717: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,
718: p_run_log_level => l_log_level
719: );
720: END IF;
721: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
722: p_count => x_error_count ,
723: p_data => x_error_msg
724: );
725: END wip_entity;

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

779:
780: IF p_wltx_header.organization_id is NULL and p_wltx_header.organization_code is NULL THEN
781:
782: -- Both organization code and id cant be NULL
783: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
784: l_msg_tokens.delete;
785: l_msg_tokens(1).TokenName := 'FLD_NAME';
786: l_msg_tokens(1).TokenValue := 'Both Organization_id and organization_code in Split Merge Transactions';
787: WSM_log_PVT.logMessage(p_module_name => l_module ,

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

850: END IF;
851:
852: EXCEPTION
853: WHEN NO_DATA_FOUND THEN
854: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
855: l_msg_tokens.delete;
856: l_msg_tokens(1).TokenName := 'FLD_NAME';
857: l_msg_tokens(1).TokenValue := 'value for field ' || l_field_name || ' in the txn header record ';
858: WSM_log_PVT.logMessage(p_module_name => l_module ,

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

874: BEGIN
875: IF p_wltx_header.transaction_type_id IS NULL THEN
876:
877: l_stmt_num := 100;
878: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
879: l_msg_tokens.delete;
880: l_msg_tokens(1).TokenName := 'FLD_NAME';
881: l_msg_tokens(1).TokenValue := 'Transaction Type in Split Merge Transactions';
882: WSM_log_PVT.logMessage(p_module_name => l_module ,

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

915: END IF;
916:
917: EXCEPTION
918: WHEN no_data_found then
919: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
920: l_msg_tokens.delete;
921: l_msg_tokens(1).TokenName := 'FLD_NAME';
922: l_msg_tokens(1).TokenValue := ' value for field transaction_type_id in the txn header record ';
923: WSM_log_PVT.logMessage(p_module_name => l_module ,

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

950: End if;
951:
952: ELSIF p_wltx_header.transaction_date > SYSDATE THEN
953: -- error out...(Transaction date cant be greater than current date)
954: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
955: l_msg_tokens.delete;
956: l_msg_tokens(1).TokenName := 'FLD_NAME';
957: l_msg_tokens(1).TokenValue := 'value for the transaction date in the txn header record . Transaction date cannot be greater than current date';
958: WSM_log_PVT.logMessage(p_module_name => l_module ,

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

979: and nvl(mtl.disable_date, sysdate+1) > sysdate;
980:
981: EXCEPTION
982: WHEN NO_DATA_FOUND THEN
983: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
984: l_msg_tokens.delete;
985: l_msg_tokens(1).TokenName := 'FLD_NAME';
986: l_msg_tokens(1).TokenValue := 'value for field reason_id in the txn header record ';
987: WSM_log_PVT.logMessage(p_module_name => l_module ,

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

1025: p_run_log_level => l_log_level
1026: );
1027: End if;
1028:
1029: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
1030: l_msg_tokens.delete;
1031: WSM_log_PVT.logMessage(p_module_name=> l_module ,
1032: p_msg_name => 'WSM_ACCT_PERIOD_NOT_OPEN',
1033: p_msg_appl_name => 'WSM',

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

1057:
1058: WHEN FND_API.G_EXC_ERROR THEN
1059:
1060: x_return_status := G_RET_ERROR;
1061: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
1062: p_count => x_msg_count ,
1063: p_data => x_msg_data
1064: );
1065:

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

1066: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1067:
1068: x_return_status := G_RET_UNEXPECTED;
1069:
1070: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
1071: p_count => x_msg_count ,
1072: p_data => x_msg_data
1073: );
1074: WHEN OTHERS THEN

Line 1079: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

1075:
1076: x_return_status := G_RET_UNEXPECTED;
1077:
1078: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
1079: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
1080: THEN
1081: WSM_log_PVT.handle_others( p_module_name => l_module ,
1082: p_stmt_num => l_stmt_num ,
1083: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

1084: p_run_log_level => l_log_level
1085: );
1086: END IF;
1087:
1088: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
1089: p_count => x_msg_count ,
1090: p_data => x_msg_data
1091: );
1092: END;

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

1144:
1145: l_stmt_num := 20;
1146: -- First validate the txn date and the date released..
1147: IF (p_txn_date < p_sj_date_released) THEN
1148: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
1149: l_msg_tokens.delete;
1150: l_msg_tokens(1).TokenName := 'JOB';
1151: l_msg_tokens(1).TokenValue := p_sj_wip_entity_name;
1152: WSM_log_PVT.logMessage(p_module_name => l_module ,

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

1176: AND wsmt.transaction_date > p_txn_date
1177: AND rownum = 1;
1178:
1179: -- Error our in this case...
1180: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
1181: l_msg_tokens.delete;
1182: l_msg_tokens(1).TokenName := 'JOB';
1183: l_msg_tokens(1).TokenValue := p_sj_wip_entity_name;
1184: WSM_log_PVT.logMessage(p_module_name => l_module ,

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

1200: EXCEPTION
1201: WHEN FND_API.G_EXC_ERROR THEN
1202:
1203: x_return_status := G_RET_ERROR;
1204: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
1205: p_count => x_msg_count ,
1206: p_data => x_msg_data
1207: );
1208:

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

1207: );
1208:
1209: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1210: x_return_status := G_RET_UNEXPECTED;
1211: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
1212: p_count => x_msg_count ,
1213: p_data => x_msg_data
1214: );
1215:

Line 1219: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

1215:
1216: WHEN OTHERS THEN
1217: x_return_status := G_RET_UNEXPECTED;
1218: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
1219: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
1220: THEN
1221: WSM_log_PVT.handle_others( p_module_name => l_module ,
1222: p_stmt_num => l_stmt_num ,
1223: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

1224: p_run_log_level => l_log_level
1225: );
1226: END IF;
1227:
1228: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
1229: p_count => x_msg_count ,
1230: p_data => x_msg_data
1231: );
1232:

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

1446: -- what we'll be doing here is select all the required fields use cursors... and then.... compare....
1447: -- atleast wip_entity_id/ wip_entity_name is a must.....
1448: IF p_starting_job_rec.wip_entity_name IS NULL AND p_starting_job_rec.wip_entity_id IS NULL THEN
1449: -- error out....
1450: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
1451: l_msg_tokens.delete;
1452: l_msg_tokens(1).TokenName := 'FLD_NAME';
1453: l_msg_tokens(1).TokenValue := 'Entity id and Entity name';
1454: WSM_log_PVT.logMessage(p_module_name => l_module ,

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

1746: 5
1747: )
1748: THEN
1749: -- Populate a warning message..........................event
1750: IF g_log_level_event >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_SUCCESS) then
1751: l_msg_tokens.delete;
1752: WSM_log_PVT.logMessage(p_module_name => l_module ,
1753: p_msg_name => 'WSM_OP_PURCHASE_REQ',
1754: p_msg_appl_name => 'WSM' ,

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

1778:
1779: EXCEPTION
1780: WHEN e_invalid_field THEN
1781:
1782: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
1783: l_msg_tokens.delete;
1784: l_msg_tokens(1).TokenName := 'FLD_NAME';
1785: l_msg_tokens(1).TokenValue := l_field_name;
1786:

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

1809: END IF;
1810: RAISE FND_API.G_EXC_ERROR;
1811:
1812: x_return_status := G_RET_ERROR;
1813: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
1814: p_count => x_msg_count ,
1815: p_data => x_msg_data
1816: );
1817: WHEN FND_API.G_EXC_ERROR THEN

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

1816: );
1817: WHEN FND_API.G_EXC_ERROR THEN
1818: ROLLBACK TO start_def_start_job;
1819: x_return_status := G_RET_ERROR;
1820: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
1821: p_count => x_msg_count ,
1822: p_data => x_msg_data
1823: );
1824:

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

1826: ROLLBACK TO start_def_start_job;
1827:
1828: x_return_status := G_RET_UNEXPECTED;
1829:
1830: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
1831: p_count => x_msg_count ,
1832: p_data => x_msg_data
1833: );
1834:

Line 1840: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

1836: ROLLBACK TO start_def_start_job;
1837: x_return_status := G_RET_UNEXPECTED;
1838:
1839: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
1840: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
1841: THEN
1842: WSM_log_PVT.handle_others( p_module_name => l_module ,
1843: p_stmt_num => l_stmt_num ,
1844: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

1845: p_run_log_level => l_log_level
1846: );
1847: END IF;
1848:
1849: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
1850: p_count => x_msg_count ,
1851: p_data => x_msg_data
1852: );
1853:

Line 1996: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

1992: IF x_job_serial_code <> l_code THEN
1993: -- error out..
1994: -- Cannot merge jobs with different item ctrl...
1995: IF g_log_level_error >= l_log_level OR
1996: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
1997: THEN
1998:
1999: l_msg_tokens.delete;
2000: WSM_log_PVT.logMessage(p_module_name => l_module ,

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

2035: l_serial_track := nvl(p_starting_jobs_tbl(l_counter).serial_track_flag,-1);
2036: ELSIF l_serial_track <> nvl(p_starting_jobs_tbl(l_counter).serial_track_flag,-1) THEN
2037: -- Error out ... cannot managed serial and non-serial tracked jobs.
2038:
2039: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
2040: l_msg_tokens.delete;
2041: WSM_log_PVT.logMessage(p_module_name=> l_module ,
2042: p_msg_name => 'WSM_INVALID_TRACK_MERGE',
2043: p_msg_appl_name => 'WSM',

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

2057: If l_wip_entity_name.exists(p_starting_jobs_tbl(l_counter).wip_entity_name) THEN
2058:
2059: l_stmt_num := 75;
2060: --error msg
2061: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
2062:
2063: l_msg_tokens.delete;
2064: WSM_log_PVT.logMessage(p_module_name=> l_module ,
2065: p_msg_name => 'WSM_CHECK_STLOT_WHILE_MERGE',

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

2079: -- All the jobs must be of same type
2080: if p_starting_jobs_tbl(l_counter).job_type <> l_job_type then
2081:
2082: l_stmt_num := 80;
2083: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
2084:
2085: l_msg_tokens.delete;
2086: WSM_log_PVT.logMessage(p_module_name=> l_module ,
2087: p_msg_name => 'WSM_DIFF_JOB_TYP_ST',

Line 2103: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) then

2099:
2100: -- Merge possible only at standard operation
2101: IF p_starting_jobs_tbl(l_counter).standard_operation_id is NULL then
2102: l_stmt_num := 85;
2103: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) then
2104: l_msg_tokens.delete;
2105: WSM_log_PVT.logMessage(p_module_name => l_module ,
2106: p_msg_name => 'WSM_NO_MERGE_AT_NSO',
2107: p_msg_appl_name => 'WSM' ,

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

2123: OR
2124: (l_intraop_step <> nvl(p_starting_jobs_tbl(l_counter).intraoperation_step,-1))
2125: THEN
2126: l_stmt_num := 100;
2127: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
2128: l_msg_tokens.delete;
2129: WSM_log_PVT.logMessage(p_module_name=> l_module ,
2130: p_msg_name => 'WSM_MERGE_SL_STD_OP_ID',
2131: p_msg_appl_name => 'WSM',

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

2146: p_rep_job_index := l_counter;
2147: ELSE
2148: -- error out .. only one rep job
2149: l_stmt_num := 110;
2150: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
2151: l_msg_tokens.delete;
2152: WSM_log_PVT.logMessage(p_module_name=> l_module ,
2153: p_msg_name => 'WSM_REPRESENTATIVE_LOT',
2154: p_msg_appl_name => 'WSM',

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

2172: IF p_rep_job_index = -1 THEN
2173:
2174: l_stmt_num := 120;
2175: -- error out as atleast one rep job needed....log error
2176: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
2177: l_msg_tokens.delete;
2178: WSM_log_PVT.logMessage(p_module_name=> l_module ,
2179: p_msg_name => 'WSM_REPRESENTATIVE_LOT',
2180: p_msg_appl_name => 'WSM',

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

2195: EXCEPTION
2196: WHEN FND_API.G_EXC_ERROR THEN
2197: ROLLBACK TO start_val_start_job_merge;
2198: x_return_status := G_RET_ERROR;
2199: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
2200: p_count => x_msg_count ,
2201: p_data => x_msg_data
2202: );
2203:

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

2204: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2205: ROLLBACK TO start_val_start_job_merge;
2206: x_return_status := G_RET_UNEXPECTED;
2207:
2208: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
2209: p_count => x_msg_count ,
2210: p_data => x_msg_data
2211: );
2212: WHEN OTHERS THEN

Line 2217: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

2213: ROLLBACK TO start_val_start_job_merge;
2214: x_return_status := G_RET_UNEXPECTED;
2215:
2216: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
2217: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
2218: THEN
2219: WSM_log_PVT.handle_others( p_module_name => l_module ,
2220: p_stmt_num => l_stmt_num ,
2221: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

2222: p_run_log_level => l_log_level
2223: );
2224: END IF;
2225:
2226: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
2227: p_count => x_msg_count ,
2228: p_data => x_msg_data
2229: );
2230: END;

Line 2363: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

2359: IF l_start_serial_code <> l_res_serial_code then
2360: -- error out..
2361: -- Cannot do an update assembly txn as the serial control code differs for the two items..(of starting and resulting job)
2362: IF g_log_level_error >= l_log_level OR
2363: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
2364: THEN
2365:
2366: l_msg_tokens.delete;
2367: WSM_log_PVT.logMessage(p_module_name => l_module ,

Line 2459: IF( G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) ) then

2455: x_err_code => l_error_code,
2456: x_err_msg => l_msg_data);
2457:
2458: IF l_error_code < 0 THEN
2459: IF( G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) ) then
2460: l_msg_tokens.delete;
2461: WSM_log_PVT.logMessage(p_module_name => l_module ,
2462: p_msg_text => l_msg_data,
2463: p_stmt_num => l_stmt_num ,

Line 2485: IF( G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) ) then

2481: x_err_code => l_error_code,
2482: x_err_msg => l_msg_data);
2483:
2484: IF l_error_code < 0 THEN
2485: IF( G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) ) then
2486: l_msg_tokens.delete;
2487: WSM_log_PVT.logMessage(p_module_name => l_module ,
2488: p_msg_text => l_msg_data,
2489: p_stmt_num => l_stmt_num ,

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

2686: (p_resulting_job_rec.alternate_routing_designator = p_starting_job_rec.alternate_routing_designator) and
2687: (p_resulting_job_rec.routing_revision = p_starting_job_rec.routing_revision ) and
2688: (p_resulting_job_rec.routing_revision_date = p_starting_job_rec.routing_revision_date)
2689: then
2690: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
2691: l_msg_tokens.delete;
2692: WSM_log_PVT.logMessage(p_module_name=> l_module,
2693: p_msg_name => 'WSM_NO_ROUTING_CHANGE',
2694: p_msg_appl_name => 'WSM',

Line 2715: IF( G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) ) then

2711: x_err_code => l_error_code,
2712: x_err_msg => l_msg_data);
2713:
2714: IF l_error_code < 0 THEN
2715: IF( G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) ) then
2716: l_msg_tokens.delete;
2717: WSM_log_PVT.logMessage(p_module_name => l_module ,
2718: p_msg_text => l_msg_data,
2719: p_stmt_num => l_stmt_num ,

Line 2741: IF( G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) ) then

2737: x_err_code => l_error_code,
2738: x_err_msg => l_msg_data);
2739:
2740: IF l_error_code < 0 THEN
2741: IF( G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) ) then
2742: l_msg_tokens.delete;
2743: WSM_log_PVT.logMessage(p_module_name => l_module ,
2744: p_msg_text => l_msg_data,
2745: p_stmt_num => l_stmt_num ,

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

2889: p_resulting_job_rec.wip_supply_type := p_starting_job_rec.wip_supply_type;
2890:
2891: if (p_resulting_job_rec.start_quantity is null) then
2892: -- error out as qty info is needed....
2893: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
2894: l_msg_tokens.delete;
2895: WSM_log_PVT.logMessage(p_module_name => l_module ,
2896: p_msg_name => 'WSM_QTY_INFO_REQUIRED',
2897: p_msg_appl_name => 'WSM',

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

2909: (p_resulting_job_rec.start_quantity <=0 ) OR
2910: (p_resulting_job_rec.start_quantity <= p_starting_job_rec.quantity_available)
2911: then
2912: -- error out....
2913: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
2914: l_msg_tokens.delete;
2915: WSM_log_PVT.logMessage(p_module_name => l_module ,
2916: p_msg_name => 'WSM_QUANTITY_GREATER',
2917: p_msg_appl_name => 'WSM',

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

2951: (p_resulting_job_rec.net_quantity < 0 ) or
2952: (p_resulting_job_rec.net_quantity > p_resulting_job_rec.start_quantity)
2953: then
2954: -- error out...
2955: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
2956: l_msg_tokens.delete;
2957: l_msg_tokens(1).TokenName := 'FLD_NAME';
2958: l_msg_tokens(1).TokenValue := ' Net Quantity';
2959: WSM_log_PVT.logMessage(p_module_name => l_module ,

Line 2979: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

2975: )
2976: THEN
2977: -- error out...-- has to be an integer...
2978: IF g_log_level_error >= l_log_level OR
2979: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
2980: THEN
2981: l_msg_tokens.delete;
2982: WSM_log_PVT.logMessage(p_module_name => l_module ,
2983: p_msg_name => 'WSM_INVALID_JOB_TXN_QTY',

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

2995:
2996: -- account information......
2997: if (p_resulting_job_rec.BONUS_ACCT_ID is null) then
2998: -- error out... has to be provided...
2999: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
3000: l_msg_tokens.delete;
3001: l_msg_tokens(1).TokenName := 'FLD_NAME';
3002: l_msg_tokens(1).TokenValue := 'BONUS_ACCT_ID';
3003: WSM_log_PVT.logMessage(p_module_name => l_module ,

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

3037:
3038: EXCEPTION
3039: when no_data_found then
3040: -- error out.... --
3041: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
3042:
3043: l_msg_tokens.delete;
3044: l_msg_tokens(1).TokenName := 'FLD_NAME';
3045: l_msg_tokens(1).TokenValue := 'BONUS_ACCT_ID';

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

3164: if (p_resulting_job_rec.wip_entity_name = l_null_char) OR
3165: (p_resulting_job_rec.wip_entity_name IS NULL)
3166: then
3167: -- error out.... --
3168: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
3169: l_msg_tokens.delete;
3170: l_msg_tokens(1).TokenName := 'FLD_NAME';
3171: l_msg_tokens(1).TokenValue := 'wip_entity_name';
3172: WSM_log_PVT.logMessage(p_module_name => l_module ,

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

3191: if (p_resulting_job_rec.wip_entity_name = p_starting_job_rec.wip_entity_name) and
3192: (nvl(p_resulting_job_rec.description,'-1') = nvl(p_starting_job_rec.description,'-1'))
3193: then
3194: -- error out as atleast one has to change --
3195: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
3196: l_msg_tokens.delete;
3197: WSM_log_PVT.logMessage(p_module_name=> l_module ,
3198: p_msg_name => 'WSM_NO_JOB_CHANGE',
3199: p_msg_appl_name => 'WSM',

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

3648: EXCEPTION
3649: WHEN FND_API.G_EXC_ERROR THEN
3650:
3651: x_return_status := G_RET_ERROR;
3652: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,
3653: p_count => x_msg_count ,
3654: p_data => x_msg_data
3655: );
3656:

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

3657: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3658:
3659: x_return_status := G_RET_UNEXPECTED;
3660:
3661: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
3662: p_count => x_msg_count ,
3663: p_data => x_msg_data
3664: );
3665:

Line 3671: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

3667:
3668: x_return_status := G_RET_UNEXPECTED;
3669:
3670: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
3671: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
3672: THEN
3673: WSM_log_PVT.handle_others( p_module_name => l_module ,
3674: p_stmt_num => l_stmt_num ,
3675: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

3676: p_run_log_level => l_log_level
3677: );
3678: END IF;
3679:
3680: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
3681: p_count => x_msg_count ,
3682: p_data => x_msg_data
3683: );
3684:

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

3712: begin
3713: l_stmt_num := 10;
3714: if p_txn_type <> WSMPCNST.MERGE then
3715: --error out... --
3716: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
3717: l_msg_tokens.delete;
3718: l_msg_tokens(1).TokenName := 'FLD_NAME';
3719: l_msg_tokens(1).TokenValue := 'Transaction Type not Merge';
3720: WSM_log_PVT.logMessage(p_module_name => l_module ,

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

3779:
3780: if (p_resulting_job_rec.wip_entity_name = l_null_char)
3781: then
3782: -- error out.... --
3783: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
3784: l_msg_tokens.delete;
3785: l_msg_tokens(1).TokenName := 'FLD_NAME';
3786: l_msg_tokens(1).TokenValue := 'wip_entity_name';
3787: WSM_log_PVT.logMessage(p_module_name => l_module ,

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

3847:
3848: l_stmt_num := 25;
3849: IF NVL(p_resulting_job_rec.coproducts_supply,0) NOT IN(1,2) THEN
3850: --error out.... --
3851: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
3852:
3853: l_msg_tokens.delete;
3854: l_msg_tokens(1).TokenName := 'FLD_NAME';
3855: l_msg_tokens(1).TokenName := 'CoProducts Supply';

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

3876: --p_resulting_job_rec.net_quantity := nvl(p_resulting_job_rec.net_quantity,p_job_net_quantity);
3877:
3878: if p_resulting_job_rec.net_quantity > p_resulting_job_rec.start_quantity then
3879: -- error out,.,,,, --
3880: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
3881:
3882: l_msg_tokens.delete;
3883: WSM_log_PVT.logMessage(p_module_name=> l_module ,
3884: p_msg_name => 'WSM_NET_QTY_MORE_START_QTY',

Line 3910: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

3906: THEN
3907: -- error out...
3908: -- has to be an integer...
3909: IF g_log_level_error >= l_log_level OR
3910: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
3911: THEN
3912:
3913: l_msg_tokens.delete;
3914: WSM_log_PVT.logMessage(p_module_name => l_module ,

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

3967: exception
3968: WHEN FND_API.G_EXC_ERROR THEN
3969:
3970: x_return_status := G_RET_ERROR;
3971: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
3972: p_count => x_msg_count ,
3973: p_data => x_msg_data
3974: );
3975:

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

3976: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3977:
3978: x_return_status := G_RET_UNEXPECTED;
3979:
3980: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
3981: p_count => x_msg_count ,
3982: p_data => x_msg_data
3983: );
3984:

Line 3990: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

3986:
3987: x_return_status := G_RET_UNEXPECTED;
3988:
3989: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
3990: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
3991: THEN
3992: WSM_log_PVT.handle_others( p_module_name => l_module ,
3993: p_stmt_num => l_stmt_num ,
3994: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

3995: p_run_log_level => l_log_level
3996: );
3997: END IF;
3998:
3999: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
4000: p_count => x_msg_count ,
4001: p_data => x_msg_data
4002: );
4003: END;

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

4055: End if;
4056:
4057: if p_txn_type <> WSMPCNST.SPLIT then
4058: -- error out....--
4059: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
4060: l_msg_tokens.delete;
4061: l_msg_tokens(1).TokenName := 'FLD_NAME';
4062: l_msg_tokens(1).TokenValue := 'Transaction Type Not Split';
4063: WSM_log_PVT.logMessage(p_module_name => l_module ,

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

4110: if (p_resulting_jobs_tbl(l_counter).wip_entity_id is null) and
4111: (p_resulting_jobs_tbl(l_counter).wip_entity_name is null)
4112: then
4113: -- error out..... as both cant be NULL--
4114: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
4115:
4116: l_msg_tokens.delete;
4117: l_msg_tokens(1).TokenName := 'FLD_NAME';
4118: l_msg_tokens(1).TokenValue := 'Entity id and name ';

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

4174:
4175: p_resulting_jobs_tbl(l_counter).wip_entity_name := p_starting_job_rec.wip_entity_name;
4176: else
4177: -- error out....
4178: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
4179: l_msg_tokens.delete;
4180: WSM_log_PVT.logMessage(p_module_name=> l_module ,
4181: p_msg_name => 'WSM_SJ_AS_RJ',
4182: p_msg_appl_name => 'WSM',

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

4209:
4210: l_start_as_result := 1;
4211: ELSE
4212: -- error out,,,,,
4213: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
4214:
4215: l_msg_tokens.delete;
4216: WSM_log_PVT.logMessage(p_module_name=> l_module ,
4217: p_msg_name => 'WSM_SJ_AS_RJ_ONCE',

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

4229:
4230: l_stmt_num := 60;
4231: -- check for duplicate job name
4232: If l_job_name_tbl.exists(p_resulting_jobs_tbl(l_counter).wip_entity_name) THEN
4233: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
4234:
4235: l_msg_tokens.delete;
4236: WSM_log_PVT.logMessage(p_module_name=> l_module ,
4237: p_msg_name => 'WSM_DUPLICATE_RJ_NAME',

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

4260: if (p_resulting_jobs_tbl(l_counter).start_quantity is null) or
4261: (p_resulting_jobs_tbl(l_counter).start_quantity <= 0)
4262: then
4263: -- error out....--
4264: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
4265: l_msg_tokens.delete;
4266: l_msg_tokens(1).TokenName := 'FLD_NAME';
4267: l_msg_tokens(1).TokenValue := 'start_quantity';
4268: WSM_log_PVT.logMessage(p_module_name => l_module ,

Line 4287: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

4283: (p_resulting_jobs_tbl(l_counter).start_quantity <> floor(p_resulting_jobs_tbl(l_counter).start_quantity))
4284: THEN
4285: -- error out...
4286: IF g_log_level_error >= l_log_level OR
4287: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
4288: THEN
4289:
4290: l_msg_tokens.delete;
4291: WSM_log_PVT.logMessage(p_module_name => l_module ,

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

4304:
4305: l_stmt_num := 80;
4306: if (l_total_quantity + p_resulting_jobs_tbl(l_counter).start_quantity) > p_starting_job_rec.quantity_available then
4307: -- error out..... --
4308: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
4309:
4310: l_msg_tokens.delete;
4311: WSM_log_PVT.logMessage(p_module_name => l_module ,
4312: p_msg_name => 'WSM_SUM_RESULT_START_MORE',

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

4343: (p_resulting_jobs_tbl(l_counter).net_quantity < 0 ) or
4344: (p_resulting_jobs_tbl(l_counter).net_quantity > p_resulting_jobs_tbl(l_counter).start_quantity)
4345: then
4346: -- error out... --
4347: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
4348:
4349: l_msg_tokens.delete;
4350: l_msg_tokens(1).TokenName := 'FLD_NAME';
4351: l_msg_tokens(1).TokenValue := 'net_quantity';

Line 4373: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

4369: (p_resulting_jobs_tbl(l_counter).net_quantity <> floor(p_resulting_jobs_tbl(l_counter).net_quantity))
4370: THEN
4371: -- error out...
4372: IF g_log_level_error >= l_log_level OR
4373: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
4374: THEN
4375:
4376: l_msg_tokens.delete;
4377: WSM_log_PVT.logMessage(p_module_name => l_module ,

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

4405: end if;
4406:
4407: if NVL(p_resulting_jobs_tbl(l_counter).coproducts_supply,0) not in(1,2) then
4408: --error out.... --
4409: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
4410:
4411: l_msg_tokens.delete;
4412: l_msg_tokens(1).TokenName := 'FLD_NAME';
4413: l_msg_tokens(1).TokenName := 'CoProducts Supply';

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

4429: -- check the split has update assy flag.........--
4430: l_stmt_num := 100;
4431: p_resulting_jobs_tbl(l_counter).split_has_update_assy := nvl(p_resulting_jobs_tbl(l_counter).split_has_update_assy,0);
4432: if p_resulting_jobs_tbl(l_counter).split_has_update_assy not in (0,1) then
4433: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
4434: l_msg_tokens.delete;
4435: l_msg_tokens(1).TokenName := 'FLD_NAME';
4436: l_msg_tokens(1).TokenName := 'Split_has_update_assembly';
4437:

Line 4562: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)

4558: -- error out...
4559: -- cannot do a update from non-serial to serial or vice versa....
4560:
4561: IF g_log_level_error >= l_log_level OR
4562: FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR)
4563: THEN
4564:
4565: l_msg_tokens.delete;
4566: WSM_log_PVT.logMessage(p_module_name => l_module ,

Line 4664: IF( G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) ) then

4660: x_err_code => l_error_code,
4661: x_err_msg => l_msg_data);
4662:
4663: IF l_error_code < 0 THEN
4664: IF( G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) ) then
4665: l_msg_tokens.delete;
4666: WSM_log_PVT.logMessage(p_module_name => l_module ,
4667: p_msg_text => l_msg_data,
4668: p_stmt_num => l_stmt_num ,

Line 4690: IF( G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) ) then

4686: x_err_code => l_error_code,
4687: x_err_msg => l_msg_data);
4688:
4689: IF l_error_code < 0 THEN
4690: IF( G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) ) then
4691: l_msg_tokens.delete;
4692: WSM_log_PVT.logMessage(p_module_name => l_module ,
4693: p_msg_text => l_msg_data,
4694: p_stmt_num => l_stmt_num ,

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

4793: /* Bugfix 5438722 Validate that there isn't just one resulting job with all the available quantity */
4794:
4795: if (l_total_quantity = p_starting_job_rec.quantity_available) and (p_resulting_jobs_tbl.count = 1) then
4796: -- error out...
4797: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
4798: l_msg_tokens.delete;
4799: WSM_log_PVT.logMessage(p_module_name => l_module ,
4800: p_msg_name => 'WSM_ONE_RES_JOB_HAS_FULL_QTY',
4801: p_msg_appl_name => 'WSM',

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

4817: -- Either create.... a new record or modify the parent if it exists.....
4818: if l_start_as_result = -1 then
4819: if p_resulting_jobs_tbl.count < 1 then
4820: -- error out...
4821: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
4822: l_msg_tokens.delete;
4823: WSM_log_PVT.logMessage(p_module_name => l_module ,
4824: p_msg_name => 'WSM_RESULT_LOT_REQUIRED',
4825: p_msg_appl_name => 'WSM',

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

4902: ELSE
4903: -- parent record is also a part of the resulting jobs bunch....
4904: IF p_resulting_jobs_tbl.count <= 1 THEN
4905: -- error out...
4906: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
4907: l_msg_tokens.delete;
4908: WSM_log_PVT.logMessage(p_module_name => l_module ,
4909: p_msg_name => 'WSM_SJ_AS_RJ_ONCE',
4910: p_msg_appl_name => 'WSM',

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

4940:
4941: WHEN FND_API.G_EXC_ERROR THEN
4942:
4943: x_return_status := G_RET_ERROR;
4944: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
4945: p_count => x_msg_count ,
4946: p_data => x_msg_data
4947: );
4948:

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

4949: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4950:
4951: x_return_status := G_RET_UNEXPECTED;
4952:
4953: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
4954: p_count => x_msg_count ,
4955: p_data => x_msg_data
4956: );
4957:

Line 4963: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

4959:
4960: x_return_status := G_RET_UNEXPECTED;
4961:
4962: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
4963: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
4964: THEN
4965: WSM_log_PVT.handle_others( p_module_name => l_module ,
4966: p_stmt_num => l_stmt_num ,
4967: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

4968: p_run_log_level => l_log_level
4969: );
4970: END IF;
4971:
4972: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
4973: p_count => x_msg_count ,
4974: p_data => x_msg_data
4975: );
4976:

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

5038: -- these are two valid values for lot based jobs
5039:
5040: elsif ( p_resulting_job_rec.job_type <> 1 and p_resulting_job_rec.job_type <> 3 ) then
5041:
5042: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
5043: l_msg_tokens.delete;
5044: l_msg_tokens(1).TokenName := 'FLD_NAME';
5045: l_msg_tokens(1).TokenValue := 'Job Type';
5046: WSM_log_PVT.logMessage(p_module_name => l_module ,

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

5089: BEGIN
5090: l_stmt_num := 30;
5091: IF p_resulting_job_rec.wip_entity_name is null then
5092: -- error out as it is mandatory......
5093: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
5094: l_msg_tokens.delete;
5095: l_msg_tokens(1).TokenName := 'FLD_NAME';
5096: l_msg_tokens(1).TokenValue := 'wip_entity_name';
5097: WSM_log_PVT.logMessage(p_module_name => l_module ,

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

5115: and WE.organization_id = p_txn_org_id;
5116:
5117: if l_dummy=1 then
5118: -- error out as duplicate job....
5119: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
5120: l_msg_tokens.delete;
5121: WSM_log_PVT.logMessage(p_module_name=> l_module ,
5122: p_msg_name => 'WSM_DUPLICATE_ENT_NAME',
5123: p_msg_appl_name => 'WSM',

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

5176: -- Quantity check .....
5177: -- ST : Fix for bug 5218598 : Added the nvl clause --
5178: if nvl(p_resulting_job_rec.start_quantity,0) <= 0 then
5179: -- error out...
5180: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
5181: l_msg_tokens.delete;
5182: l_msg_tokens(1).TokenName := 'FLD_NAME';
5183: l_msg_tokens(1).TokenValue := 'start_quantity';
5184: WSM_log_PVT.logMessage(p_module_name => l_module ,

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

5201: (p_resulting_job_rec.net_quantity < 0)
5202: )
5203: then
5204: -- error out...
5205: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
5206: l_msg_tokens.delete;
5207: l_msg_tokens(1).TokenName := 'FLD_NAME';
5208: l_msg_tokens(1).TokenValue := 'Net quantity';
5209: WSM_log_PVT.logMessage(p_module_name => l_module ,

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

5225: (floor(p_resulting_job_rec.start_quantity) <> p_resulting_job_rec.start_quantity)
5226: )
5227: then
5228: -- error out..
5229: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
5230: l_msg_tokens.delete;
5231: WSM_log_PVT.logMessage(p_module_name => l_module ,
5232: p_msg_name => 'WSM_INVALID_JOB_TXN_QTY',
5233: p_msg_appl_name => 'WSM' ,

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

5244:
5245: -- Start date completion date defaulting to be handled...
5246: if p_resulting_job_rec.scheduled_start_date is null and p_resulting_job_rec.scheduled_completion_date is null then
5247: -- error out...
5248: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
5249:
5250: l_msg_tokens.delete;
5251: l_msg_tokens(1).TokenName := 'FLD_NAME';
5252: l_msg_tokens(1).TokenValue := 'Both scheduled_start_date and scheduled_end_date';

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

5286: end if;
5287:
5288: if p_resulting_job_rec.scheduled_start_date > p_resulting_job_rec.scheduled_completion_date then
5289: -- error out.....
5290: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
5291:
5292: l_msg_tokens.delete;
5293: WSM_log_PVT.logMessage(p_module_name=> l_module ,
5294: p_msg_name => 'WSM_INVALID_DATES',

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

5330:
5331: EXCEPTION
5332: WHEN NO_DATA_FOUND then
5333: -- error out....
5334: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
5335:
5336: l_msg_tokens.delete;
5337: l_msg_tokens(1).TokenName := 'FLD_NAME';
5338: l_msg_tokens(1).TokenValue := 'BONUS_ACCT_ID';

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

5425: -- If the starting intraop step isnt specified, default to QUEUE
5426: p_resulting_job_rec.starting_intraoperation_step := nvl(p_resulting_job_rec.starting_intraoperation_step,WIP_CONSTANTS.QUEUE);
5427:
5428: IF p_resulting_job_rec.starting_intraoperation_step <> 1 THEN
5429: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
5430:
5431: l_msg_tokens.delete;
5432: l_msg_tokens(1).TokenName := 'FLD_NAME';
5433: l_msg_tokens(1).TokenValue := 'intraoperation step for bonus';

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

5532:
5533: IF (l_err_code <> 0) THEN
5534: -- error out ........
5535: l_stmt_num := 120;
5536: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
5537:
5538: l_msg_tokens.delete;
5539: WSM_log_PVT.logMessage(p_module_name=> l_module ,
5540: p_msg_name => 'WSM_INVALID_CLASS_CODE',

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

5551:
5552: IF l_class_code IS NULL THEN
5553: -- error out....
5554: l_stmt_num := 130;
5555: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
5556:
5557: l_msg_tokens.delete;
5558: WSM_log_PVT.logMessage(p_module_name=> l_module ,
5559: p_msg_name => 'WSM_INVALID_CLASS_CODE',

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

5591:
5592:
5593: IF l_est_scrap_account IS NULL OR l_est_scrap_var_account IS NULL THEN
5594: -- error out ...
5595: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
5596:
5597: l_msg_tokens.delete;
5598: WSM_log_PVT.logMessage(p_module_name=> l_module ,
5599: p_msg_name => 'WSM_NO_WAC_SCRAP_ACC',

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

5641: (p_resulting_job_rec.job_type = 3 and l_class_type <> 7 ))
5642: THEN
5643:
5644: l_stmt_num := 170;
5645: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
5646:
5647: l_msg_tokens.delete;
5648: WSM_log_PVT.logMessage(p_module_name=> l_module ,
5649: p_msg_name => 'WSM_INVALID_CLASS_CODE',

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

5664:
5665: EXCEPTION
5666: WHEN NO_DATA_FOUND then
5667: -- handle ....
5668: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
5669:
5670: l_msg_tokens.delete;
5671: WSM_log_PVT.logMessage(p_module_name=> l_module ,
5672: p_msg_name => 'WSM_INVALID_CLASS_CODE',

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

5686: EXCEPTION
5687: WHEN FND_API.G_EXC_ERROR THEN
5688:
5689: x_return_status := G_RET_ERROR;
5690: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
5691: p_count => x_msg_count ,
5692: p_data => x_msg_data
5693: );
5694:

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

5695: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5696:
5697: x_return_status := G_RET_UNEXPECTED;
5698:
5699: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
5700: p_count => x_msg_count ,
5701: p_data => x_msg_data
5702: );
5703:

Line 5709: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

5705:
5706: x_return_status := G_RET_UNEXPECTED;
5707:
5708: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
5709: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
5710: THEN
5711: WSM_log_PVT.handle_others( p_module_name => l_module ,
5712: p_stmt_num => l_stmt_num ,
5713: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

5714: p_run_log_level => l_log_level
5715: );
5716: END IF;
5717:
5718: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
5719: p_count => x_msg_count ,
5720: p_data => x_msg_data
5721: );
5722: END derive_val_res_job_details;

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

5812: -- if both null then copy from the starting....
5813: if p_rj_rtg_reference_id is null and p_rj_rtg_reference_item is null then
5814: --p_rj_rtg_reference_id := p_sj_rtg_reference_id; (AH)
5815: --error out as user has to specify some info...(AH)
5816: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
5817: l_msg_tokens.delete;
5818: l_msg_tokens(1).TokenName := 'FLD_NAME';
5819: l_msg_tokens(1).TokenValue := 'For NSJ,Both rtg_reference_id and rtg_reference_item ';
5820: WSM_log_PVT.logMessage(p_module_name => l_module ,

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

5859:
5860: EXCEPTION
5861: WHEN no_data_found THEN
5862: -- error out...
5863: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
5864:
5865: l_msg_tokens.delete;
5866: l_msg_tokens(1).TokenName := 'FLD_NAME';
5867: l_msg_tokens(1).TokenValue := 'value for rotuing reference item/routing reference id';

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

5902: and rownum < 2;
5903:
5904: IF l_row_exists = 0 THEN
5905: -- error out as no network routing exists...
5906: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
5907:
5908: WSM_log_PVT.logMessage(p_module_name => l_module ,
5909: p_msg_name => 'WSM_NO_WSM_ROUTING' ,
5910: p_msg_appl_name => 'WSM' ,

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

6007: -- ST : Fix for bug 5218479 : Moved the erroring out code outside (so that it's common)
6008: l_stmt_num := 35;
6009: IF l_error_out = 1 THEN
6010: -- error out...
6011: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
6012:
6013: l_msg_tokens.delete;
6014: l_msg_tokens(1).TokenName := 'FLD_NAME';
6015: l_msg_tokens(1).TokenValue := 'value for rotuing revision/routing revision date';

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

6066:
6067: WHEN FND_API.G_EXC_ERROR THEN
6068:
6069: x_return_status := G_RET_ERROR;
6070: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
6071: p_count => x_msg_count ,
6072: p_data => x_msg_data
6073: );
6074:

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

6075: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6076:
6077: x_return_status := G_RET_UNEXPECTED;
6078:
6079: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
6080: p_count => x_msg_count ,
6081: p_data => x_msg_data
6082: );
6083: WHEN OTHERS THEN

Line 6088: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

6084:
6085: x_return_status := G_RET_UNEXPECTED;
6086:
6087: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
6088: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
6089: THEN
6090: WSM_log_PVT.handle_others( p_module_name => l_module ,
6091: p_stmt_num => l_stmt_num ,
6092: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

6093: p_run_log_level => l_log_level
6094: );
6095: END IF;
6096:
6097: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
6098: p_count => x_msg_count ,
6099: p_data => x_msg_data
6100: );
6101: END derive_val_routing_info;

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

6217: -- if both null then copy from the starting....
6218: if p_rj_bom_reference_id is null and p_rj_bom_reference_item is null then
6219: --p_rj_bom_reference_id := p_sj_bom_reference_id; (AH)
6220: --error out as user has to specify some info...(AH)
6221: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
6222:
6223: l_msg_tokens.delete;
6224: l_msg_tokens(1).TokenName := 'FLD_NAME';
6225: l_msg_tokens(1).TokenValue := 'BOM_REFERENCE_ID in resulting jobs';

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

6254: END IF;
6255:
6256: EXCEPTION
6257: WHEN no_data_found then
6258: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
6259:
6260: l_msg_tokens.delete;
6261: l_msg_tokens(1).TokenName := 'FLD_NAME';
6262: l_msg_tokens(1).TokenValue := 'BOM REFERENCE ITEM/BOM REFERENCE ID in resulting jobs';

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

6343:
6344: -- ST : Fix for bug 5218479 --
6345: IF l_error_out = 1 THEN
6346: -- error out...
6347: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
6348:
6349: l_msg_tokens.delete;
6350: l_msg_tokens(1).TokenName := 'FLD_NAME';
6351: l_msg_tokens(1).TokenValue := 'value for bom_revision';

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

6401: exception
6402: WHEN FND_API.G_EXC_ERROR THEN
6403:
6404: x_return_status := G_RET_ERROR;
6405: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
6406: p_count => x_msg_count ,
6407: p_data => x_msg_data
6408: );
6409:

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

6410: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6411:
6412: x_return_status := G_RET_UNEXPECTED;
6413:
6414: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
6415: p_count => x_msg_count ,
6416: p_data => x_msg_data
6417: );
6418: WHEN OTHERS THEN

Line 6423: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

6419:
6420: x_return_status := G_RET_UNEXPECTED;
6421:
6422: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
6423: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
6424: THEN
6425: WSM_log_PVT.handle_others( p_module_name => l_module ,
6426: p_stmt_num => l_stmt_num ,
6427: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

6428: p_run_log_level => l_log_level
6429: );
6430: END IF;
6431:
6432: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
6433: p_count => x_msg_count ,
6434: p_data => x_msg_data
6435: );
6436: end derive_val_bom_info;

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

6553:
6554: EXCEPTION
6555: WHEN no_data_found THEN
6556: -- error out....
6557: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
6558:
6559: l_msg_tokens.delete;
6560: l_msg_tokens(1).TokenName := 'FLD_NAME';
6561: l_msg_tokens(1).TokenValue := 'value for completion subinventory';

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

6588: -- ST : Fix for bug 5094555 end --
6589:
6590: EXCEPTION
6591: when no_data_found 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: l_msg_tokens(1).TokenName := 'FLD_NAME';
6596: l_msg_tokens(1).TokenValue := 'or no matching value for completion subinventory';

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

6627: and concatenated_segments = p_rj_completion_locator;
6628:
6629: EXCEPTION
6630: WHEN no_data_found THEN
6631: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
6632:
6633: l_msg_tokens.delete;
6634: l_msg_tokens(1).TokenName := 'FLD_NAME';
6635: l_msg_tokens(1).TokenValue := 'Completion locator id.';

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

6673:
6674: exception
6675: when NO_DATA_FOUND then
6676: -- error out..
6677: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
6678: l_msg_tokens.delete;
6679: l_msg_tokens(1).TokenName := 'FLD_NAME';
6680: l_msg_tokens(1).TokenValue := 'Completion locator.';
6681: WSM_log_PVT.logMessage(p_module_name => l_module ,

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

6710: l_temp_boolean := FALSE;
6711: end;
6712: l_stmt_num := 80;
6713: if not l_temp_boolean then
6714: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
6715: l_msg_tokens.delete;
6716: l_msg_tokens(1).TokenName := 'FLD_NAME';
6717: l_msg_tokens(1).TokenValue := 'COMPLETION_LOCATOR_ID';
6718: WSM_log_PVT.logMessage(p_module_name => l_module ,

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

6735:
6736: WHEN FND_API.G_EXC_ERROR THEN
6737:
6738: x_return_status := G_RET_ERROR;
6739: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
6740: p_count => x_msg_count ,
6741: p_data => x_msg_data
6742: );
6743:

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

6744: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6745:
6746: x_return_status := G_RET_UNEXPECTED;
6747:
6748: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
6749: p_count => x_msg_count ,
6750: p_data => x_msg_data
6751: );
6752: WHEN OTHERS THEN

Line 6757: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

6753:
6754: x_return_status := G_RET_UNEXPECTED;
6755:
6756: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
6757: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
6758: THEN
6759: WSM_log_PVT.handle_others( p_module_name => l_module ,
6760: p_stmt_num => l_stmt_num ,
6761: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

6762: p_run_log_level => l_log_level
6763: );
6764: END IF;
6765:
6766: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
6767: p_count => x_msg_count ,
6768: p_data => x_msg_data
6769: );
6770: end derive_val_compl_subinv;

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

6911: p_new_op_seq_code := l_operation_code;
6912: elsif nvl(p_new_op_seq_code,'$$&&') <> nvl(l_operation_code,'$$&&') then
6913: -- ST : Fix for bug 5116062 : Added an outer NVL clause
6914: -- error out.... wrong op_code...
6915: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
6916:
6917: l_msg_tokens.delete;
6918: l_msg_tokens(1).TokenName := 'FLD_NAME';
6919: l_msg_tokens(1).TokenValue := 'value for operation code';

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

6931: end if;
6932:
6933: EXCEPTION
6934: when no_data_found then
6935: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
6936:
6937: l_msg_tokens.delete;
6938: l_msg_tokens(1).TokenName := 'FLD_NAME';
6939: l_msg_tokens(1).TokenValue := 'Starting operation information';

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

6952:
6953: elsif l_op_rptd_times > 1 then
6954: l_stmt_num :=40;
6955: -- have to error out... repeated in the target ....
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_JOB_AT_REPEATED_OP',

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

6969: raise FND_API.G_EXC_ERROR;
6970: else
6971: l_stmt_num :=50;
6972: -- no match found....
6973: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6974:
6975: l_msg_tokens.delete;
6976: WSM_log_PVT.logMessage(p_module_name=> l_module ,
6977: p_msg_name => 'WSM_NO_CURRENT_STDOP_TGTRTG',

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

6988:
6989: else
6990: l_stmt_num :=60;
6991: -- error out as for ToMove have to provide the starting op...
6992: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
6993:
6994: l_msg_tokens.delete;
6995: WSM_log_PVT.logMessage(p_module_name=> l_module ,
6996: p_msg_name => 'WSM_START_OP_REQD',

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

7099:
7100: EXCEPTION
7101: when no_data_found then
7102: -- error out....
7103: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
7104:
7105: l_msg_tokens.delete;
7106: l_msg_tokens(1).TokenName := 'FLD_NAME';
7107: l_msg_tokens(1).TokenValue := 'start operation information';

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

7126: p_routing_rev_date => p_new_rtg_rev_date ,
7127: x_err_code => l_err_code ,
7128: x_err_msg => l_err_msg)
7129: THEN
7130: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
7131: l_msg_tokens.delete;
7132: WSM_log_PVT.logMessage(p_module_name => l_module ,
7133: p_msg_name => 'WSM_OP_PO_MOVE',
7134: p_msg_appl_name => 'WSM' ,

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

7159:
7160: WHEN FND_API.G_EXC_ERROR THEN
7161:
7162: x_return_status := G_RET_ERROR;
7163: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
7164: p_count => x_msg_count ,
7165: p_data => x_msg_data
7166: );
7167:

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

7168: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7169:
7170: x_return_status := G_RET_UNEXPECTED;
7171:
7172: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
7173: p_count => x_msg_count ,
7174: p_data => x_msg_data
7175: );
7176: WHEN OTHERS THEN

Line 7181: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

7177:
7178: x_return_status := G_RET_UNEXPECTED;
7179:
7180: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
7181: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
7182: THEN
7183: WSM_log_PVT.handle_others( p_module_name => l_module ,
7184: p_stmt_num => l_stmt_num ,
7185: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

7186: p_run_log_level => l_log_level
7187: );
7188: END IF;
7189:
7190: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
7191: p_count => x_msg_count ,
7192: p_data => x_msg_data
7193: );
7194: end derive_val_starting_op;

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

7216:
7217: l_stmt_num := 10;
7218: IF p_new_item_name IS NULL AND p_new_item_id IS NULL THEN
7219: -- error out.... .
7220: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
7221: l_msg_tokens.delete;
7222: l_msg_tokens(1).TokenName := 'FLD_NAME';
7223: l_msg_tokens(1).TokenValue := 'p_new_item_name and p_new_item_id ';
7224: WSM_log_PVT.logMessage(p_module_name => l_module ,

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

7259: END IF;
7260: EXCEPTION
7261: WHEN no_data_found THEN
7262: -- Invalid item name / item id combo.... error out
7263: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
7264:
7265: l_msg_tokens.delete;
7266: l_msg_tokens(1).TokenName := 'FLD_NAME';
7267: l_msg_tokens(1).TokenValue := 'value for item name / item_id specified ';

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

7280:
7281: l_stmt_num := 30;
7282: IF p_new_item_id = p_old_item_id then
7283: -- error out....
7284: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
7285:
7286: l_msg_tokens.delete;
7287: l_msg_tokens(1).TokenName := 'FLD_NAME';
7288: l_msg_tokens(1).TokenValue := 'Assembly cannot be same';

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

7300: end if;
7301:
7302: l_stmt_num := 40;
7303: if l_lot_control_code <> 2 OR (l_serial_number_control_code NOT IN(1,2))then
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: l_msg_tokens(1).TokenName := 'FLD_NAME';
7308: l_msg_tokens(1).TokenValue := 'value for lot_control_code/serial_control_code';

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

7326:
7327: WHEN FND_API.G_EXC_ERROR THEN
7328:
7329: x_return_status := G_RET_ERROR;
7330: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
7331: p_count => x_msg_count ,
7332: p_data => x_msg_data
7333: );
7334:

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

7335: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7336:
7337: x_return_status := G_RET_UNEXPECTED;
7338:
7339: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
7340: p_count => x_msg_count ,
7341: p_data => x_msg_data
7342: );
7343: WHEN OTHERS THEN

Line 7348: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

7344:
7345: x_return_status := G_RET_UNEXPECTED;
7346:
7347: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
7348: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
7349: THEN
7350: WSM_log_PVT.handle_others( p_module_name => l_module ,
7351: p_stmt_num => l_stmt_num ,
7352: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

7353: p_run_log_level => l_log_level
7354: );
7355: END IF;
7356:
7357: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
7358: p_count => x_msg_count ,
7359: p_data => x_msg_data
7360: );
7361: end derive_val_primary_item;

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

7787: EXCEPTION
7788: WHEN FND_API.G_EXC_ERROR THEN
7789:
7790: x_return_status := G_RET_ERROR;
7791: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
7792: p_count => x_msg_count ,
7793: p_data => x_msg_data
7794: );
7795:

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

7796: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7797:
7798: x_return_status := G_RET_UNEXPECTED;
7799:
7800: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
7801: p_count => x_msg_count ,
7802: p_data => x_msg_data
7803: );
7804: WHEN OTHERS THEN

Line 7809: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

7805:
7806: x_return_status := G_RET_UNEXPECTED;
7807:
7808: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
7809: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
7810: THEN
7811: WSM_log_PVT.handle_others( p_module_name => l_module ,
7812: p_stmt_num => l_stmt_num ,
7813: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

7814: p_run_log_level => l_log_level
7815: );
7816: END IF;
7817:
7818: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
7819: p_count => x_msg_count ,
7820: p_data => x_msg_data
7821: );
7822:

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

7955: and BSO.standard_operation_id (+) = BOS.standard_operation_id
7956: and p_revision_date between BOS.effectivity_date and nvl(BOS.disable_date, p_revision_date+1);
7957: EXCEPTION
7958: WHEN NO_DATA_FOUND THEN
7959: IF g_log_level_error >= l_log_level OR FND_MSG_PUB.check_msg_level(G_MSG_LVL_ERROR) THEN
7960: l_msg_tokens.delete;
7961: l_msg_tokens(1).TokenName := 'FLD_NAME';
7962: l_msg_tokens(1).TokenValue := 'starting_operation';
7963: WSM_log_PVT.logMessage(p_module_name => l_module ,

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

8017:
8018: EXCEPTION
8019: WHEN NO_DATA_FOUND then
8020: -- not on the primary path....
8021: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
8022:
8023: l_msg_tokens.delete;
8024: WSM_log_PVT.logMessage(p_module_name=> l_module ,
8025: p_msg_name => 'WSM_OPRN_NOT_PRIMARY',

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

8045: )
8046: = 0)
8047: THEN
8048: -- Disabled primary path.............
8049: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
8050:
8051: l_msg_tokens.delete;
8052: WSM_log_PVT.logMessage(p_module_name=> l_module ,
8053: p_msg_name => 'WSM_PRIMARY_PATH_DISABLED',

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

8064: END IF;
8065: EXCEPTION
8066: WHEN FND_API.G_EXC_ERROR THEN
8067: x_return_status := G_RET_ERROR;
8068: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
8069: p_count => x_msg_count ,
8070: p_data => x_msg_data
8071: );
8072:

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

8074:
8075:
8076: x_return_status := G_RET_UNEXPECTED;
8077:
8078: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
8079: p_count => x_msg_count ,
8080: p_data => x_msg_data
8081: );
8082: WHEN OTHERS THEN

Line 8087: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

8083:
8084: x_return_status := G_RET_UNEXPECTED;
8085:
8086: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
8087: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
8088: THEN
8089: WSM_log_PVT.handle_others( p_module_name => l_module ,
8090: p_stmt_num => l_stmt_num ,
8091: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

8092: p_run_log_level => l_log_level
8093: );
8094: END IF;
8095:
8096: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
8097: p_count => x_msg_count ,
8098: p_data => x_msg_data
8099: );
8100: END;