APPS.WSM_WIP_LOT_TXN_PVT dependencies on FND_MSG_PUB

Line 16: g_msg_lvl_unexp_error NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ;

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

Line 17: g_msg_lvl_error NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR ;

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

Line 18: g_msg_lvl_success NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS ;

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

Line 19: g_msg_lvl_debug_high NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH ;

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

Line 20: g_msg_lvl_debug_medium NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM ;

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

Line 21: g_msg_lvl_debug_low NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ;

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

Line 450: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

446:
447: x_return_status := G_RET_UNEXPECTED;
448:
449: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
450: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
451: THEN
452: WSM_log_PVT.handle_others( p_module_name => l_module ,
453: p_stmt_num => l_stmt_num ,
454: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

455: p_run_log_level => l_log_level
456: );
457: END IF;
458:
459: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
460: p_count => x_msg_count ,
461: p_data => x_error_msg
462:
463: );

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

599: l_stmt_num := 15;
600:
601: if l_starting_jobs_tbl.count <> 1 then
602: /* error out... */
603: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
604:
605: l_msg_tokens.delete;
606: WSM_log_PVT.logMessage(p_module_name=> l_module ,
607: p_msg_name => 'WSM_START_LOT_REQUIRED',

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

618: end if;
619:
620: if l_resulting_jobs_tbl.count <1 then
621: /* error out... */
622: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
623:
624: l_msg_tokens.delete;
625: WSM_log_PVT.logMessage(p_module_name=> l_module ,
626: p_msg_name => 'WSM_RESULT_LOT_REQUIRED',

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

692: l_stmt_num := 60;
693:
694: if l_starting_jobs_tbl.count < 2 then
695: /* error out... */
696: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
697:
698: l_msg_tokens.delete;
699: WSM_log_PVT.logMessage(p_module_name => l_module ,
700: p_msg_text => 'No. of SJs cannot be less than 2 in case of Merge',

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

710: end if;
711:
712: if l_resulting_jobs_tbl.count <> 1 then
713: /* error out... */
714: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
715:
716: l_msg_tokens.delete;
717: WSM_log_PVT.logMessage(p_module_name=> l_module ,
718: p_msg_name => 'WSM_RESULT_LOT_REQUIRED',

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

748:
749: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
750: /* Txn errored....*/
751: /* Log the Procedure exit point.... */
752: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
753:
754: l_msg_tokens.delete;
755: WSM_log_PVT.logMessage(p_module_name => l_module ,
756: p_msg_text => 'Merge API Failed',

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

777: elsif l_txn_header_rec.transaction_type_id = WSMPCNST.UPDATE_ASSEMBLY then
778:
779: if l_starting_jobs_tbl.count <> 1 then
780: /* error out... */
781: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
782:
783: l_msg_tokens.delete;
784: WSM_log_PVT.logMessage(p_module_name=> l_module ,
785: p_msg_name => 'WSM_START_LOT_REQUIRED',

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

795: end if;
796:
797: if l_resulting_jobs_tbl.count <> 1 then
798: /* error out... */
799: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
800:
801: l_msg_tokens.delete;
802: WSM_log_PVT.logMessage(p_module_name=> l_module ,
803: p_msg_name => 'WSM_RESULT_LOT_REQUIRED',

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

831:
832: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
833: /* Txn errored....*/
834: /* Log the Procedure exit point.... */
835: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
836:
837: l_msg_tokens.delete;
838: WSM_log_PVT.logMessage(p_module_name => l_module ,
839: p_msg_text => 'Update Assembly Txn procedure failed.' ,

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

859: elsif l_txn_header_rec.transaction_type_id = WSMPCNST.UPDATE_ROUTING then
860:
861: if l_starting_jobs_tbl.count <> 1 then
862: /* error out... */
863: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
864:
865: l_msg_tokens.delete;
866: WSM_log_PVT.logMessage(p_module_name=> l_module ,
867: p_msg_name => 'WSM_START_LOT_REQUIRED',

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

877: end if;
878:
879: if l_resulting_jobs_tbl.count <> 1 then
880: /* error out... */
881: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
882:
883: l_msg_tokens.delete;
884: WSM_log_PVT.logMessage(p_module_name=> l_module ,
885: p_msg_name => 'WSM_RESULT_LOT_REQUIRED',

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

910:
911: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
912: /* Txn errored....*/
913: /* Log the Procedure exit point.... */
914: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
915:
916: l_msg_tokens.delete;
917: WSM_log_PVT.logMessage(p_module_name => l_module ,
918: p_msg_text => 'Update Routing Txn procedure failed.',

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

939: elsif l_txn_header_rec.transaction_type_id = WSMPCNST.UPDATE_QUANTITY then
940:
941: if l_starting_jobs_tbl.count <> 1 then
942: /* error out... */
943: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
944:
945: l_msg_tokens.delete;
946: WSM_log_PVT.logMessage(p_module_name=> l_module ,
947: p_msg_name => 'WSM_START_LOT_REQUIRED',

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

957: end if;
958:
959: if l_resulting_jobs_tbl.count <> 1 then
960: /* error out... */
961: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
962:
963: l_msg_tokens.delete;
964: WSM_log_PVT.logMessage(p_module_name=> l_module ,
965: p_msg_name => 'WSM_RESULT_LOT_REQUIRED',

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

991:
992: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
993: /* Txn errored....*/
994: /* Log the Procedure exit point.... */
995: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
996:
997: l_msg_tokens.delete;
998: /* Bugfix 5352389 Changed p_fnd_log_level from ERROR to STATEMENT */
999: WSM_log_PVT.logMessage(p_module_name => l_module ,

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

1020: elsif l_txn_header_rec.transaction_type_id = WSMPCNST.UPDATE_LOT_NAME then
1021:
1022: if l_starting_jobs_tbl.count <> 1 then
1023: /* error out... */
1024: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
1025:
1026: l_msg_tokens.delete;
1027: WSM_log_PVT.logMessage(p_module_name=> l_module ,
1028: p_msg_name => 'WSM_START_LOT_REQUIRED',

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

1038: end if;
1039:
1040: if l_resulting_jobs_tbl.count <> 1 then
1041: /* error out... */
1042: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
1043:
1044: l_msg_tokens.delete;
1045: WSM_log_PVT.logMessage(p_module_name=> l_module ,
1046: p_msg_name => 'WSM_RESULT_LOT_REQUIRED',

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

1072:
1073: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
1074: /* Txn errored....*/
1075: /* Log the Procedure exit point.... */
1076: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
1077:
1078: l_msg_tokens.delete;
1079: WSM_log_PVT.logMessage(p_module_name => l_module ,
1080: p_msg_text => 'Update Lot Name Txn procedure failed.',

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

1101: elsif l_txn_header_rec.transaction_type_id = WSMPCNST.BONUS then
1102:
1103: if l_resulting_jobs_tbl.count <> 1 then
1104: /* error out... */
1105: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
1106:
1107: l_msg_tokens.delete;
1108: WSM_log_PVT.logMessage(p_module_name=> l_module ,
1109: p_msg_name => 'WSM_RESULT_LOT_REQUIRED',

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

1134:
1135: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
1136: /* Txn errored....*/
1137: /* Log the Procedure exit point.... */
1138: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
1139:
1140: l_msg_tokens.delete;
1141: WSM_log_PVT.logMessage(p_module_name => l_module ,
1142: p_msg_text => 'Bonus Txn procedure failed.',

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

1178: );
1179:
1180: if x_return_status <> fnd_api.g_ret_sts_success then
1181: --log error
1182: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
1183:
1184: l_msg_tokens.delete;
1185: WSM_log_PVT.logMessage(p_module_name => l_module ,
1186: p_msg_text => 'WSM_WLT_VALIDATE_PVT.insert_txn_data failed',

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

1273: --End if;
1274: --END IF;
1275: -- ST : Fix for bug 5263262 End --
1276:
1277: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
1278: p_count => x_msg_count ,
1279: p_data => x_error_msg
1280: );
1281:

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

1294:
1295: WHEN FND_API.G_EXC_ERROR THEN
1296:
1297: x_return_status := G_RET_ERROR;
1298: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
1299: p_count => x_msg_count ,
1300: p_data => x_error_msg
1301: );
1302:

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

1303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1304:
1305: x_return_status := G_RET_UNEXPECTED;
1306:
1307: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
1308: p_count => x_msg_count ,
1309: p_data => x_error_msg
1310:
1311: );

Line 1317: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

1313:
1314: x_return_status := G_RET_UNEXPECTED;
1315:
1316: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
1317: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
1318: THEN
1319: WSM_log_PVT.handle_others( p_module_name => l_module ,
1320: p_stmt_num => l_stmt_num ,
1321: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

1322: p_run_log_level => l_log_level
1323: );
1324: END IF;
1325:
1326: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
1327: p_count => x_msg_count ,
1328: p_data => x_error_msg
1329:
1330: );

Line 1396: FND_MSG_PUB.initialize;

1392:
1393: /* Initialize message list if p_init_msg_list is set to TRUE. */
1394: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1395: l_stmt_num := 30;
1396: FND_MSG_PUB.initialize;
1397: end if;
1398:
1399: l_stmt_num := 40;
1400:

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

1405: l_api_name
1406: )
1407: THEN
1408: /* Incompatible versions...*/
1409: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
1410:
1411: l_msg_tokens.delete;
1412: WSM_log_PVT.logMessage(p_module_name => l_module ,
1413: p_msg_text => 'Incompatible API called for Split Txn',

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

1473: End if;
1474:
1475: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
1476: /* Txn errored....*/
1477: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
1478:
1479: l_msg_tokens.delete;
1480: WSM_log_PVT.logMessage(p_module_name => l_module ,
1481: p_msg_text => 'validate_txn_header failed.' ,

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

1547:
1548:
1549: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
1550: /* Txn errored....*/
1551: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
1552:
1553: l_msg_tokens.delete;
1554: WSM_log_PVT.logMessage(p_module_name => l_module ,
1555: p_msg_text => 'derive_val_st_job_details failed.' ,

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

1619: End if;
1620:
1621: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
1622: /* Txn errored....*/
1623: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
1624:
1625: l_msg_tokens.delete;
1626: /* Bugfix 5438722 Changed p_fnd_log_level from ERROR to STATEMENT */
1627: WSM_log_PVT.logMessage(p_module_name => l_module ,

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

1698: End if;
1699:
1700: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
1701: /* Txn errored....*/
1702: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
1703:
1704: l_msg_tokens.delete;
1705: WSM_log_PVT.logMessage(p_module_name => l_module ,
1706: p_msg_text => 'PROCESS_LOTS failed.' ,

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

1761: WHEN FND_API.G_EXC_ERROR THEN
1762: ROLLBACK TO start_split_txn;
1763:
1764: x_return_status := G_RET_ERROR;
1765: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
1766: p_count => x_msg_count ,
1767: p_data => x_msg_data
1768: );
1769:

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

1774: ROLLBACK TO start_split_txn;
1775:
1776: x_return_status := G_RET_UNEXPECTED;
1777:
1778: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
1779: p_count => x_msg_count ,
1780: p_data => x_msg_data
1781: );
1782: -- remove this later...

Line 1791: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

1787:
1788: x_return_status := G_RET_UNEXPECTED;
1789:
1790: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
1791: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
1792: THEN
1793: WSM_log_PVT.handle_others( p_module_name => l_module ,
1794: p_stmt_num => l_stmt_num ,
1795: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

1796: p_run_log_level => l_log_level
1797: );
1798: END IF;
1799:
1800: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
1801: p_count => x_msg_count ,
1802: p_data => x_msg_data
1803: );
1804:

Line 1880: FND_MSG_PUB.initialize;

1876: l_stmt_num := 20;
1877:
1878: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1879: l_stmt_num := 30;
1880: FND_MSG_PUB.initialize;
1881: /* Message list enabled....-- EVENT */
1882: --'FND_MSG_PUB Message Table Initialized'
1883: end if;
1884:

Line 1882: --'FND_MSG_PUB Message Table Initialized'

1878: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1879: l_stmt_num := 30;
1880: FND_MSG_PUB.initialize;
1881: /* Message list enabled....-- EVENT */
1882: --'FND_MSG_PUB Message Table Initialized'
1883: end if;
1884:
1885: /* Log the Procedure entry point.... */
1886: --'Calling FND_API.Compatible_API_Call');

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

1894: l_api_name
1895: )
1896: THEN
1897: /* Incompatible versions...*/
1898: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
1899:
1900: l_msg_tokens.delete;
1901: WSM_log_PVT.logMessage(p_module_name => l_module ,
1902: p_msg_text => 'Incompatible API called for Merge Txn',

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

1949: End if;
1950:
1951: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
1952: /* Txn errored....*/
1953: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
1954:
1955: l_msg_tokens.delete;
1956: WSM_log_PVT.logMessage(p_module_name => l_module ,
1957: p_msg_text => 'validate_txn_header failed.' ,

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

2026: End if;
2027:
2028: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
2029: /* Txn errored....*/
2030: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
2031:
2032: l_msg_tokens.delete;
2033: WSM_log_PVT.logMessage(p_module_name => l_module ,
2034: p_msg_text => 'derive_val_st_job_details failed.' ,

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

2104: End if;
2105:
2106: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
2107: /* Txn errored....*/
2108: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
2109:
2110: l_msg_tokens.delete;
2111: WSM_log_PVT.logMessage(p_module_name => l_module ,
2112: p_msg_text => 'derive_val_res_job_details failed.' ,

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

2188: End if;
2189:
2190: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
2191: /* Txn errored....*/
2192: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
2193:
2194: l_msg_tokens.delete;
2195: WSM_log_PVT.logMessage(p_module_name => l_module ,
2196: p_msg_text => 'PROCESS_LOTS failed.' ,

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

2249: WHEN FND_API.G_EXC_ERROR THEN
2250: ROLLBACK TO start_merge_txn;
2251:
2252: x_return_status := G_RET_ERROR;
2253: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
2254: p_count => x_msg_count ,
2255: p_data => x_msg_data
2256: );
2257: fnd_file.put_line(fnd_file.log,' WSM_WIP_LOT_TXN_PVT.merge_txn : ' || l_stmt_num || ' Error : ');

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

2261: ROLLBACK TO start_merge_txn;
2262:
2263: x_return_status := G_RET_UNEXPECTED;
2264:
2265: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
2266: p_count => x_msg_count,
2267: p_data => x_msg_data
2268: );
2269: fnd_file.put_line(fnd_file.log,' WSM_WIP_LOT_TXN_PVT.merge_txn : ' || l_stmt_num || ' Unexp error : ');

Line 2278: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

2274:
2275: x_return_status := G_RET_UNEXPECTED;
2276:
2277: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
2278: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
2279: THEN
2280: WSM_log_PVT.handle_others( p_module_name => l_module ,
2281: p_stmt_num => l_stmt_num ,
2282: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

2283: p_run_log_level => l_log_level
2284: );
2285: END IF;
2286:
2287: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
2288: p_count => x_msg_count ,
2289: p_data => x_msg_data
2290: );
2291: fnd_file.put_line(fnd_file.log,' WSM_WIP_LOT_TXN_PVT.merge_txn : ' || l_stmt_num || ' Other error : ' || SQLCODE || ' : ' || substrb(SQLERRM,1,1000) );

Line 2339: /* Logging into the FND_MSG_PUB will be to the level of G_MSG_LVL_SUCCESS

2335: x_msg_count := NULL;
2336: x_msg_data := 0;
2337:
2338: /* Log the Procedure entry point.... */
2339: /* Logging into the FND_MSG_PUB will be to the level of G_MSG_LVL_SUCCESS
2340: G_MSG_LVL_DEBUG_HIGH , G_MSG_LVL_DEBUG_MEDIUM ,G_MSG_LVL_DEBUG_LOW not considered as of now...
2341: */
2342:
2343: --'Entering the Update Assembly Txn API');

Line 2358: FND_MSG_PUB.initialize;

2354: /* Initialize message list if p_init_msg_list is set to TRUE. */
2355: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2356:
2357: l_stmt_num := 30;
2358: FND_MSG_PUB.initialize;
2359: /* Message list enabled....-- EVENT */
2360: --'FND_MSG_PUB Message Table Initialized');
2361: end if;
2362:

Line 2360: --'FND_MSG_PUB Message Table Initialized');

2356:
2357: l_stmt_num := 30;
2358: FND_MSG_PUB.initialize;
2359: /* Message list enabled....-- EVENT */
2360: --'FND_MSG_PUB Message Table Initialized');
2361: end if;
2362:
2363: /* FND_MSG_PUB logginng .... */
2364: --'Inside Update_Assembly_Txn API ' );

Line 2363: /* FND_MSG_PUB logginng .... */

2359: /* Message list enabled....-- EVENT */
2360: --'FND_MSG_PUB Message Table Initialized');
2361: end if;
2362:
2363: /* FND_MSG_PUB logginng .... */
2364: --'Inside Update_Assembly_Txn API ' );
2365:
2366:
2367: /* Log the Procedure entry point....proc */

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

2377: l_api_name
2378: )
2379: THEN
2380: /* Incompatible versions...*/
2381: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
2382:
2383: l_msg_tokens.delete;
2384: WSM_log_PVT.logMessage(p_module_name => l_module ,
2385: p_msg_text => 'Incompatible API called for Upd Assy Txn',

Line 2401: /* FND_MSG_PUB logginng .... */

2397: --API compatibility success ');
2398: /*event lvl logging*/
2399: --API compatibility success ');
2400:
2401: /* FND_MSG_PUB logginng .... */
2402: --' API compatibility success ' );
2403:
2404: if p_calling_mode <> 2 then
2405:

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

2439: End if;
2440:
2441: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
2442: /* Txn errored....*/
2443: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
2444:
2445: l_msg_tokens.delete;
2446: WSM_log_PVT.logMessage(p_module_name => l_module ,
2447: p_msg_text => 'validate_txn_header failed.' ,

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

2511: End if;
2512:
2513: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
2514: /* Txn errored....*/
2515: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
2516:
2517: l_msg_tokens.delete;
2518: WSM_log_PVT.logMessage(p_module_name => l_module ,
2519: p_msg_text => 'derive_val_st_job_details failed.' ,

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

2584: End if;
2585:
2586: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
2587: /* Txn errored....*/
2588: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
2589:
2590: l_msg_tokens.delete;
2591: WSM_log_PVT.logMessage(p_module_name => l_module ,
2592: p_msg_text => 'derive_val_res_job_details failed.' ,

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

2662: End if;
2663:
2664: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
2665: /* Txn errored....*/
2666: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
2667:
2668: l_msg_tokens.delete;
2669: WSM_log_PVT.logMessage(p_module_name => l_module ,
2670: p_msg_text => 'PROCESS_LOTS failed.' ,

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

2724: WHEN FND_API.G_EXC_ERROR THEN
2725: ROLLBACK TO start_upd_assy_txn;
2726:
2727: x_return_status := G_RET_ERROR;
2728: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
2729: p_count => x_msg_count ,
2730: p_data => x_msg_data
2731: );
2732:

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

2737: ROLLBACK TO start_upd_assy_txn;
2738:
2739: x_return_status := G_RET_UNEXPECTED;
2740:
2741: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
2742: p_count => x_msg_count ,
2743: p_data => x_msg_data
2744: );
2745: fnd_file.put_line(fnd_file.log,' WSM_WIP_LOT_TXN_PVT.update_assembly_txn : ' || l_stmt_num || ' Un Exp Error : ');

Line 2753: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

2749:
2750: x_return_status := G_RET_UNEXPECTED;
2751:
2752: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
2753: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
2754: THEN
2755: WSM_log_PVT.handle_others( p_module_name => l_module ,
2756: p_stmt_num => l_stmt_num ,
2757: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

2758: p_run_log_level => l_log_level
2759: );
2760: END IF;
2761:
2762: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
2763: p_count => x_msg_count ,
2764: p_data => x_msg_data
2765: );
2766: fnd_file.put_line(fnd_file.log,' WSM_WIP_LOT_TXN_PVT.update_assembly_txn : ' || l_stmt_num || ' Other Error : ');

Line 2817: /* Logging into the FND_MSG_PUB will be to the level of G_MSG_LVL_SUCCESS

2813: x_msg_data := 0;
2814:
2815:
2816: /* Log the Procedure entry point.... */
2817: /* Logging into the FND_MSG_PUB will be to the level of G_MSG_LVL_SUCCESS
2818: G_MSG_LVL_DEBUG_HIGH , G_MSG_LVL_DEBUG_MEDIUM ,G_MSG_LVL_DEBUG_LOW not considered as of now...
2819: */
2820: /*proc level*/
2821: --'Entering the Update Routing Txn API');

Line 2836: FND_MSG_PUB.initialize;

2832: /* Initialize message list if p_init_msg_list is set to TRUE. */
2833: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2834:
2835: l_stmt_num := 30;
2836: FND_MSG_PUB.initialize;
2837: /* Message list enabled....-- EVENT */
2838: --'FND_MSG_PUB Message Table Initialized');
2839:
2840: end if;

Line 2838: --'FND_MSG_PUB Message Table Initialized');

2834:
2835: l_stmt_num := 30;
2836: FND_MSG_PUB.initialize;
2837: /* Message list enabled....-- EVENT */
2838: --'FND_MSG_PUB Message Table Initialized');
2839:
2840: end if;
2841:
2842: /* FND_MSG_PUB logginng .... */

Line 2842: /* FND_MSG_PUB logginng .... */

2838: --'FND_MSG_PUB Message Table Initialized');
2839:
2840: end if;
2841:
2842: /* FND_MSG_PUB logginng .... */
2843: --'Inside Update_Routing_Txn API ' );
2844:
2845: /* Log the Procedure entry point.... proc*/
2846: --'Calling FND_API.Compatible_API_Call');

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

2854: l_api_name
2855: )
2856: THEN
2857: /* Incompatible versions...*/
2858: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
2859:
2860: l_msg_tokens.delete;
2861: WSM_log_PVT.logMessage(p_module_name => l_module ,
2862: p_msg_text => 'Incompatible API called for Upd Routing Txn',

Line 2879: /* FND_MSG_PUB logginng .... */

2875:
2876: /*event lelvel logginh*/
2877: --'API compatibility success ');
2878:
2879: /* FND_MSG_PUB logginng .... */
2880: -- API compatibility success ' );
2881: if p_calling_mode <> 2 then
2882: l_stmt_num := 50; --Start AH
2883:

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

2915: End if;
2916:
2917: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
2918: /* Txn errored....*/
2919: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
2920:
2921: l_msg_tokens.delete;
2922: WSM_log_PVT.logMessage(p_module_name => l_module ,
2923: p_msg_text => 'validate_txn_header failed.' ,

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

2987: End if;
2988:
2989: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
2990: /* Txn errored....*/
2991: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
2992:
2993: l_msg_tokens.delete;
2994: WSM_log_PVT.logMessage(p_module_name => l_module ,
2995: p_msg_text => 'derive_val_st_job_details failed.' ,

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

3062: /*stmt lvl*/
3063:
3064: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
3065: /* Txn errored....*/
3066: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
3067:
3068: l_msg_tokens.delete;
3069: WSM_log_PVT.logMessage(p_module_name => l_module ,
3070: p_msg_text => 'derive_val_res_job_details failed.' ,

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

3141: End if;
3142:
3143: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
3144: /* Txn errored....*/
3145: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
3146:
3147: l_msg_tokens.delete;
3148: WSM_log_PVT.logMessage(p_module_name => l_module ,
3149: p_msg_text => 'PROCESS_LOTS failed.' ,

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

3201: WHEN FND_API.G_EXC_ERROR THEN
3202: ROLLBACK TO start_upd_rtg_txn;
3203:
3204: x_return_status := G_RET_ERROR;
3205: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
3206: p_count => x_msg_count ,
3207: p_data => x_msg_data
3208: );
3209:

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

3212: ROLLBACK TO start_upd_rtg_txn;
3213:
3214: x_return_status := G_RET_UNEXPECTED;
3215:
3216: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
3217: p_count => x_msg_count ,
3218: p_data => x_msg_data
3219: );
3220:

Line 3228: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

3224:
3225: x_return_status := G_RET_UNEXPECTED;
3226:
3227: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
3228: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
3229: THEN
3230: WSM_log_PVT.handle_others( p_module_name => l_module ,
3231: p_stmt_num => l_stmt_num ,
3232: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

3233: p_run_log_level => l_log_level
3234: );
3235: END IF;
3236:
3237: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
3238: p_count => x_msg_count ,
3239: p_data => x_msg_data
3240: );
3241: END;

Line 3290: /* Logging into the FND_MSG_PUB will be to the level of G_MSG_LVL_SUCCESS

3286: x_msg_data := 0;
3287:
3288:
3289: /* Log the Procedure entry point.... */
3290: /* Logging into the FND_MSG_PUB will be to the level of G_MSG_LVL_SUCCESS
3291: G_MSG_LVL_DEBUG_HIGH , G_MSG_LVL_DEBUG_MEDIUM ,G_MSG_LVL_DEBUG_LOW not considered as of now...
3292: */
3293: /*stmt lvl*/
3294: --'Entering the Update Quantity Txn API');

Line 3309: FND_MSG_PUB.initialize;

3305: /* Initialize message list if p_init_msg_list is set to TRUE. */
3306: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3307:
3308: l_stmt_num := 30;
3309: FND_MSG_PUB.initialize;
3310: /* Message list enabled....-- EVENT */
3311: --'FND_MSG_PUB Message Table Initialized');
3312: end if;
3313:

Line 3311: --'FND_MSG_PUB Message Table Initialized');

3307:
3308: l_stmt_num := 30;
3309: FND_MSG_PUB.initialize;
3310: /* Message list enabled....-- EVENT */
3311: --'FND_MSG_PUB Message Table Initialized');
3312: end if;
3313:
3314: /* FND_MSG_PUB logginng .... */
3315: --'Inside Update_Quantity_Txn API ' );

Line 3314: /* FND_MSG_PUB logginng .... */

3310: /* Message list enabled....-- EVENT */
3311: --'FND_MSG_PUB Message Table Initialized');
3312: end if;
3313:
3314: /* FND_MSG_PUB logginng .... */
3315: --'Inside Update_Quantity_Txn API ' );
3316:
3317: /* Log the Procedure entry point.... */
3318: --'Calling FND_API.Compatible_API_Call');

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

3326: l_api_name
3327: )
3328: THEN
3329: /* Incompatible versions...*/
3330: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
3331:
3332: l_msg_tokens.delete;
3333: WSM_log_PVT.logMessage(p_module_name => l_module ,
3334: p_msg_text => 'Incompatible API called for Upd Qty Txn',

Line 3350: /* FND_MSG_PUB logginng .... */

3346: --'API compatibility success ');
3347: /*event level*/
3348: --'API compatibility success ');
3349:
3350: /* FND_MSG_PUB logginng .... */
3351: --' API compatibility success ' );
3352:
3353: if P_calling_mode <> 2 then
3354:

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

3389: End if;
3390:
3391: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
3392: /* Txn errored....*/
3393: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
3394:
3395: l_msg_tokens.delete;
3396: WSM_log_PVT.logMessage(p_module_name => l_module ,
3397: p_msg_text => 'validate_txn_header failed.' ,

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

3461: End if;
3462:
3463: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
3464: /* Txn errored....*/
3465: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
3466:
3467: l_msg_tokens.delete;
3468: WSM_log_PVT.logMessage(p_module_name => l_module ,
3469: p_msg_text => 'derive_val_st_job_details failed.' ,

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

3534: End if;
3535:
3536: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
3537: /* Txn errored....*/
3538: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
3539:
3540: l_msg_tokens.delete;
3541: /* Bugfix 5352389 changed fnd_log_level from ERROR to STATEMENT */
3542: WSM_log_PVT.logMessage(p_module_name => l_module ,

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

3616: End if;
3617:
3618: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
3619: /* Txn errored....*/
3620: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
3621:
3622: l_msg_tokens.delete;
3623: WSM_log_PVT.logMessage(p_module_name => l_module ,
3624: p_msg_text => 'PROCESS_LOTS failed.' ,

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

3678: WHEN FND_API.G_EXC_ERROR THEN
3679: ROLLBACK TO start_upd_qty_txn;
3680:
3681: x_return_status := G_RET_ERROR;
3682: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
3683: p_count => x_msg_count ,
3684: p_data => x_msg_data
3685: );
3686:

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

3690: ROLLBACK TO start_upd_qty_txn;
3691:
3692: x_return_status := G_RET_UNEXPECTED;
3693:
3694: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
3695: p_count => x_msg_count ,
3696: p_data => x_msg_data
3697: );
3698: WHEN OTHERS THEN

Line 3705: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

3701:
3702: x_return_status := G_RET_UNEXPECTED;
3703:
3704: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
3705: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
3706: THEN
3707: WSM_log_PVT.handle_others( p_module_name => l_module ,
3708: p_stmt_num => l_stmt_num ,
3709: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

3710: p_run_log_level => l_log_level
3711: );
3712: END IF;
3713:
3714: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
3715: p_count => x_msg_count ,
3716: p_data => x_msg_data
3717: );
3718: END;

Line 3783: FND_MSG_PUB.initialize;

3779: /* Initialize message list if p_init_msg_list is set to TRUE. */
3780: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3781:
3782: l_stmt_num := 30;
3783: FND_MSG_PUB.initialize;
3784: /* Message list enabled....-- EVENT */
3785: if( g_log_level_statement >= l_log_level ) then
3786: l_msg_tokens.delete;
3787: WSM_log_PVT.logMessage(p_module_name => l_module ,

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

3803: l_api_name
3804: )
3805: THEN
3806: /* Incompatible versions...*/
3807: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
3808:
3809: l_msg_tokens.delete;
3810: WSM_log_PVT.logMessage(p_module_name => l_module ,
3811: p_msg_text => 'Incompatible API called for Upd Lotname Txn',

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

3859: End if;
3860:
3861: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
3862: /* Txn errored....*/
3863: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
3864:
3865: l_msg_tokens.delete;
3866: WSM_log_PVT.logMessage(p_module_name => l_module ,
3867: p_msg_text => 'validate_txn_header failed.' ,

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

3931: End if;
3932:
3933: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
3934: /* Txn errored....*/
3935: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
3936:
3937: l_msg_tokens.delete;
3938: WSM_log_PVT.logMessage(p_module_name => l_module ,
3939: p_msg_text => 'derive_val_st_job_details failed.' ,

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

4004: End if;
4005:
4006: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
4007: /* Txn errored....*/
4008: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
4009:
4010: l_msg_tokens.delete;
4011: WSM_log_PVT.logMessage(p_module_name => l_module ,
4012: p_msg_text => 'derive_val_res_job_details failed.' ,

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

4087: End if;
4088:
4089: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
4090: /* Txn errored....*/
4091: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
4092:
4093: l_msg_tokens.delete;
4094: WSM_log_PVT.logMessage(p_module_name => l_module ,
4095: p_msg_text => 'PROCESS_LOTS failed.' ,

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

4148: WHEN FND_API.G_EXC_ERROR THEN
4149: ROLLBACK TO start_upd_lotname_txn;
4150:
4151: x_return_status := G_RET_ERROR;
4152: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
4153: p_count => x_msg_count ,
4154: p_data => x_msg_data
4155: );
4156:

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

4157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4158:
4159: x_return_status := G_RET_UNEXPECTED;
4160:
4161: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
4162: p_count => x_msg_count ,
4163: p_data => x_msg_data
4164: );
4165:

Line 4173: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

4169:
4170: x_return_status := G_RET_UNEXPECTED;
4171:
4172: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
4173: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
4174: THEN
4175: WSM_log_PVT.handle_others( p_module_name => l_module ,
4176: p_stmt_num => l_stmt_num ,
4177: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

4178: p_run_log_level => l_log_level
4179: );
4180: END IF;
4181:
4182: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
4183: p_count => x_msg_count ,
4184: p_data => x_msg_data
4185: );
4186: END;

Line 4253: FND_MSG_PUB.initialize;

4249:
4250: /* Initialize message list if p_init_msg_list is set to TRUE. */
4251: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4252: l_stmt_num := 30;
4253: FND_MSG_PUB.initialize;
4254: /* Message list enabled....-- EVENT */
4255: end if;
4256:
4257: l_stmt_num := 40;

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

4263: l_api_name
4264: )
4265: THEN
4266: /* Incompatible versions...*/
4267: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
4268:
4269: l_msg_tokens.delete;
4270: WSM_log_PVT.logMessage(p_module_name => l_module ,
4271: p_msg_text => 'Incompatible API called for Bonus Txn',

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

4319: End if;
4320:
4321: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
4322: /* Txn errored....*/
4323: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
4324:
4325: l_msg_tokens.delete;
4326: WSM_log_PVT.logMessage(p_module_name => l_module ,
4327: p_msg_text => 'validate_txn_header failed.' ,

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

4391: End if;
4392:
4393: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
4394: /* Txn errored....*/
4395: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
4396:
4397: l_msg_tokens.delete;
4398: WSM_log_PVT.logMessage(p_module_name => l_module ,
4399: p_msg_text => 'derive_val_res_job_details failed.' ,

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

4472: End if;
4473:
4474: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
4475: /* Txn errored....*/
4476: IF G_LOG_LEVEL_ERROR >= l_log_level OR FND_MSG_PUB.check_msg_level(g_msg_lvl_error) THEN
4477:
4478: l_msg_tokens.delete;
4479: WSM_log_PVT.logMessage(p_module_name => l_module ,
4480: p_msg_text => 'PROCESS_LOTS failed.' ,

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

4534: WHEN FND_API.G_EXC_ERROR THEN
4535: ROLLBACK TO start_bonus_txn;
4536:
4537: x_return_status := G_RET_ERROR;
4538: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
4539: p_count => x_msg_count ,
4540: p_data => x_msg_data
4541: );
4542:

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

4543: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4544:
4545: x_return_status := G_RET_UNEXPECTED;
4546:
4547: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
4548: p_count => x_msg_count ,
4549: p_data => x_msg_data
4550: );
4551:

Line 4559: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))

4555:
4556: x_return_status := G_RET_UNEXPECTED;
4557:
4558: IF (G_LOG_LEVEL_UNEXPECTED >= l_log_level) OR
4559: (FND_MSG_PUB.check_msg_level(G_MSG_LVL_UNEXP_ERROR))
4560: THEN
4561: WSM_log_PVT.handle_others( p_module_name => l_module ,
4562: p_stmt_num => l_stmt_num ,
4563: p_fnd_log_level => G_LOG_LEVEL_UNEXPECTED ,

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

4564: p_run_log_level => l_log_level
4565: );
4566: END IF;
4567:
4568: FND_MSG_PUB.Count_And_Get (p_encoded => 'F' ,
4569: p_count => x_msg_count ,
4570: p_data => x_msg_data
4571: );
4572: END;