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.INV_RULE_GEN_PVT dependencies on FND_API

Line 46: x_return_status := FND_API.G_RET_STS_SUCCESS;

42: From mtl_inv_picking_rules
43: Where inv_rule_id = p_inv_rule_id;
44:
45: BEGIN
46: x_return_status := FND_API.G_RET_STS_SUCCESS;
47: debug('Procedure Save');
48: l_is_new_rec := 1;
49: if p_mtl_picking_rule_rec.inv_rule_id is not null then
50: l_is_new_rec := 0;

Line 112: WHEN FND_API.G_EXC_ERROR THEN

108: , x_msg_count => x_msg_count
109: );
110: END IF;
111: EXCEPTION
112: WHEN FND_API.G_EXC_ERROR THEN
113: x_return_status := FND_API.G_RET_STS_ERROR;
114: FND_MSG_Pub.count_and_get
115: ( p_count => x_msg_count
116: , p_data => x_msg_data

Line 113: x_return_status := FND_API.G_RET_STS_ERROR;

109: );
110: END IF;
111: EXCEPTION
112: WHEN FND_API.G_EXC_ERROR THEN
113: x_return_status := FND_API.G_RET_STS_ERROR;
114: FND_MSG_Pub.count_and_get
115: ( p_count => x_msg_count
116: , p_data => x_msg_data
117: );

Line 141: x_return_status := FND_API.G_RET_STS_SUCCESS;

137: IS
138: l_api_name CONSTANT VARCHAR2 (30) := 'Save_to_mtl_picking_rules';
139: l_inv_rule_id NUMBER;
140: BEGIN
141: x_return_status := FND_API.G_RET_STS_SUCCESS;
142: l_inv_rule_id := p_mtl_picking_rule_rec.inv_rule_id;
143: debug('Procedure Save_to_mtl_picking_rules');
144: If l_inv_rule_id is null then
145: select mtl_inv_picking_rules_s.nextval into l_inv_Rule_id from dual;

Line 228: WHEN FND_API.G_EXC_ERROR THEN

224: , LAST_UPDATE_LOGIN = fnd_global.login_id
225: where inv_rule_id = l_inv_rule_id;
226: end if;
227: EXCEPTION
228: WHEN FND_API.G_EXC_ERROR THEN
229: x_return_status := FND_API.G_RET_STS_ERROR;
230: FND_MSG_Pub.count_and_get
231: ( p_count => x_msg_count
232: , p_data => x_msg_data

Line 229: x_return_status := FND_API.G_RET_STS_ERROR;

225: where inv_rule_id = l_inv_rule_id;
226: end if;
227: EXCEPTION
228: WHEN FND_API.G_EXC_ERROR THEN
229: x_return_status := FND_API.G_RET_STS_ERROR;
230: FND_MSG_Pub.count_and_get
231: ( p_count => x_msg_count
232: , p_data => x_msg_data
233: );

Line 261: x_return_status := FND_API.G_RET_STS_SUCCESS;

257: l_organization_id NUMBER;
258: l_allocation_mode_id NUMBER;
259:
260: BEGIN
261: x_return_status := FND_API.G_RET_STS_SUCCESS;
262: l_picking_rule_rec := p_mtl_picking_rule_rec;
263: l_organization_id := -1; -- all orgs
264: l_allocation_mode_id := 3; -- NON LPN
265: l_wms_rule_id := p_mtl_picking_rule_rec.wms_rule_id;

Line 361: WHEN FND_API.G_EXC_ERROR THEN

357:
358: p_mtl_picking_rule_rec := l_picking_rule_rec;
359:
360: EXCEPTION
361: WHEN FND_API.G_EXC_ERROR THEN
362: x_return_status := FND_API.G_RET_STS_ERROR;
363: FND_MSG_Pub.count_and_get
364: ( p_count => x_msg_count
365: , p_data => x_msg_data

Line 362: x_return_status := FND_API.G_RET_STS_ERROR;

358: p_mtl_picking_rule_rec := l_picking_rule_rec;
359:
360: EXCEPTION
361: WHEN FND_API.G_EXC_ERROR THEN
362: x_return_status := FND_API.G_RET_STS_ERROR;
363: FND_MSG_Pub.count_and_get
364: ( p_count => x_msg_count
365: , p_data => x_msg_data
366: );

Line 415: x_return_status := FND_API.G_RET_STS_SUCCESS;

411: * 1) shelf days
412: * 2) grade for SO
413: * 3) customer spec match for SO
414: */
415: x_return_status := FND_API.G_RET_STS_SUCCESS;
416: l_picking_rule_rec := p_mtl_picking_rule_rec;
417: l_apply_to_source := l_picking_rule_rec.apply_to_source;
418:
419: For i in 1..6 Loop

Line 650: WHEN FND_API.G_EXC_ERROR THEN

646: );
647: END IF;
648: END LOOP;
649: EXCEPTION
650: WHEN FND_API.G_EXC_ERROR THEN
651: x_return_status := FND_API.G_RET_STS_ERROR;
652: FND_MSG_Pub.count_and_get
653: ( p_count => x_msg_count
654: , p_data => x_msg_data

Line 651: x_return_status := FND_API.G_RET_STS_ERROR;

647: END IF;
648: END LOOP;
649: EXCEPTION
650: WHEN FND_API.G_EXC_ERROR THEN
651: x_return_status := FND_API.G_RET_STS_ERROR;
652: FND_MSG_Pub.count_and_get
653: ( p_count => x_msg_count
654: , p_data => x_msg_data
655: );

Line 681: x_return_status := FND_API.G_RET_STS_SUCCESS;

677: , x_msg_count OUT NOCOPY NUMBER)
678: IS
679: l_api_name CONSTANT VARCHAR2 (30) := 'Restrictions_Update';
680: Begin
681: x_return_status := FND_API.G_RET_STS_SUCCESS;
682: inv_rule_gen_pvt.Restrictions_delete
683: (p_mtl_picking_rule_rec=> p_mtl_picking_rule_rec
684: , x_return_status => x_return_status
685: , x_msg_data => x_msg_data

Line 695: WHEN FND_API.G_EXC_ERROR THEN

691: , x_msg_data => x_msg_data
692: , x_msg_count => x_msg_count
693: );
694: EXCEPTION
695: WHEN FND_API.G_EXC_ERROR THEN
696: x_return_status := FND_API.G_RET_STS_ERROR;
697: FND_MSG_Pub.count_and_get
698: ( p_count => x_msg_count
699: , p_data => x_msg_data

Line 696: x_return_status := FND_API.G_RET_STS_ERROR;

692: , x_msg_count => x_msg_count
693: );
694: EXCEPTION
695: WHEN FND_API.G_EXC_ERROR THEN
696: x_return_status := FND_API.G_RET_STS_ERROR;
697: FND_MSG_Pub.count_and_get
698: ( p_count => x_msg_count
699: , p_data => x_msg_data
700: );

Line 722: x_return_status := FND_API.G_RET_STS_SUCCESS;

718: , x_msg_count OUT NOCOPY NUMBER)
719: IS
720: l_api_name CONSTANT VARCHAR2 (30) := 'Restrictions_Delete';
721: Begin
722: x_return_status := FND_API.G_RET_STS_SUCCESS;
723: Delete wms_restrictions where rule_id = p_mtl_picking_rule_rec.wms_rule_id;
724: EXCEPTION
725: WHEN FND_API.G_EXC_ERROR THEN
726: x_return_status := FND_API.G_RET_STS_ERROR;

Line 725: WHEN FND_API.G_EXC_ERROR THEN

721: Begin
722: x_return_status := FND_API.G_RET_STS_SUCCESS;
723: Delete wms_restrictions where rule_id = p_mtl_picking_rule_rec.wms_rule_id;
724: EXCEPTION
725: WHEN FND_API.G_EXC_ERROR THEN
726: x_return_status := FND_API.G_RET_STS_ERROR;
727: FND_MSG_Pub.count_and_get
728: ( p_count => x_msg_count
729: , p_data => x_msg_data

Line 726: x_return_status := FND_API.G_RET_STS_ERROR;

722: x_return_status := FND_API.G_RET_STS_SUCCESS;
723: Delete wms_restrictions where rule_id = p_mtl_picking_rule_rec.wms_rule_id;
724: EXCEPTION
725: WHEN FND_API.G_EXC_ERROR THEN
726: x_return_status := FND_API.G_RET_STS_ERROR;
727: FND_MSG_Pub.count_and_get
728: ( p_count => x_msg_count
729: , p_data => x_msg_data
730: );

Line 757: x_return_status := FND_API.G_RET_STS_SUCCESS;

753: l_consistency_id NUMBER;
754: l_row_id VARCHAR2(500);
755: l_parameter_id NUMBER;
756: Begin
757: x_return_status := FND_API.G_RET_STS_SUCCESS;
758: l_picking_rule_rec := p_mtl_picking_rule_rec;
759: If p_mtl_picking_rule_rec.single_lot = 'Y' then
760: -- find the parameter for lot.lot_number
761: l_parameter_id := 60006; -- lot.lot_Number

Line 794: WHEN FND_API.G_EXC_ERROR THEN

790: );
791:
792: end if;
793: EXCEPTION
794: WHEN FND_API.G_EXC_ERROR THEN
795: x_return_status := FND_API.G_RET_STS_ERROR;
796: FND_MSG_Pub.count_and_get
797: ( p_count => x_msg_count
798: , p_data => x_msg_data

Line 795: x_return_status := FND_API.G_RET_STS_ERROR;

791:
792: end if;
793: EXCEPTION
794: WHEN FND_API.G_EXC_ERROR THEN
795: x_return_status := FND_API.G_RET_STS_ERROR;
796: FND_MSG_Pub.count_and_get
797: ( p_count => x_msg_count
798: , p_data => x_msg_data
799: );

Line 822: x_return_status := FND_API.G_RET_STS_SUCCESS;

818: )
819: IS
820: l_api_name CONSTANT VARCHAR2 (30) := 'Consistency_Update';
821: Begin
822: x_return_status := FND_API.G_RET_STS_SUCCESS;
823: inv_rule_gen_pvt.consistency_delete
824: (p_mtl_picking_rule_rec=> p_mtl_picking_rule_rec
825: , x_return_status => x_return_status
826: , x_msg_data => x_msg_data

Line 836: WHEN FND_API.G_EXC_ERROR THEN

832: , x_msg_data => x_msg_data
833: , x_msg_count => x_msg_count
834: );
835: EXCEPTION
836: WHEN FND_API.G_EXC_ERROR THEN
837: x_return_status := FND_API.G_RET_STS_ERROR;
838: FND_MSG_Pub.count_and_get
839: ( p_count => x_msg_count
840: , p_data => x_msg_data

Line 837: x_return_status := FND_API.G_RET_STS_ERROR;

833: , x_msg_count => x_msg_count
834: );
835: EXCEPTION
836: WHEN FND_API.G_EXC_ERROR THEN
837: x_return_status := FND_API.G_RET_STS_ERROR;
838: FND_MSG_Pub.count_and_get
839: ( p_count => x_msg_count
840: , p_data => x_msg_data
841: );

Line 864: x_return_status := FND_API.G_RET_STS_SUCCESS;

860: )
861: IS
862: l_api_name CONSTANT VARCHAR2 (30) := 'Consistency_Delete';
863: Begin
864: x_return_status := FND_API.G_RET_STS_SUCCESS;
865: Delete wms_rule_consistencies where rule_id = p_mtl_picking_Rule_rec.wms_rule_id;
866: EXCEPTION
867: WHEN FND_API.G_EXC_ERROR THEN
868: x_return_status := FND_API.G_RET_STS_ERROR;

Line 867: WHEN FND_API.G_EXC_ERROR THEN

863: Begin
864: x_return_status := FND_API.G_RET_STS_SUCCESS;
865: Delete wms_rule_consistencies where rule_id = p_mtl_picking_Rule_rec.wms_rule_id;
866: EXCEPTION
867: WHEN FND_API.G_EXC_ERROR THEN
868: x_return_status := FND_API.G_RET_STS_ERROR;
869: FND_MSG_Pub.count_and_get
870: ( p_count => x_msg_count
871: , p_data => x_msg_data

Line 868: x_return_status := FND_API.G_RET_STS_ERROR;

864: x_return_status := FND_API.G_RET_STS_SUCCESS;
865: Delete wms_rule_consistencies where rule_id = p_mtl_picking_Rule_rec.wms_rule_id;
866: EXCEPTION
867: WHEN FND_API.G_EXC_ERROR THEN
868: x_return_status := FND_API.G_RET_STS_ERROR;
869: FND_MSG_Pub.count_and_get
870: ( p_count => x_msg_count
871: , p_data => x_msg_data
872: );

Line 901: x_return_status := FND_API.G_RET_STS_SUCCESS;

897: l_order_code NUMBER;
898: i NUMBER;
899: l_go_ahead NUMBER;
900: Begin
901: x_return_status := FND_API.G_RET_STS_SUCCESS;
902: debug('sort insert, lot_sort_rank '||p_mtl_picking_rule_rec.lot_sort_rank);
903: debug('sort insert, revision_sort_rank '||p_mtl_picking_rule_rec.revision_sort_rank);
904: debug('sort insert, sub_sort_rank '||p_mtl_picking_rule_rec.subinventory_sort_rank);
905: debug('sort insert, locator_sort_rank '||p_mtl_picking_rule_rec.locator_sort_rank);

Line 1027: WHEN FND_API.G_EXC_ERROR THEN

1023: );
1024: end if;
1025: END LOOP;
1026: EXCEPTION
1027: WHEN FND_API.G_EXC_ERROR THEN
1028: x_return_status := FND_API.G_RET_STS_ERROR;
1029: FND_MSG_Pub.count_and_get
1030: ( p_count => x_msg_count
1031: , p_data => x_msg_data

Line 1028: x_return_status := FND_API.G_RET_STS_ERROR;

1024: end if;
1025: END LOOP;
1026: EXCEPTION
1027: WHEN FND_API.G_EXC_ERROR THEN
1028: x_return_status := FND_API.G_RET_STS_ERROR;
1029: FND_MSG_Pub.count_and_get
1030: ( p_count => x_msg_count
1031: , p_data => x_msg_data
1032: );

Line 1059: x_return_status := FND_API.G_RET_STS_SUCCESS;

1055: , x_msg_count OUT NOCOPY NUMBER)
1056: IS
1057: l_api_name CONSTANT VARCHAR2 (30) := 'Sorting_criteria_Update';
1058: Begin
1059: x_return_status := FND_API.G_RET_STS_SUCCESS;
1060: inv_rule_gen_pvt.sorting_criteria_delete
1061: (p_mtl_picking_rule_rec=> p_mtl_picking_rule_rec
1062: , x_return_status => x_return_status
1063: , x_msg_data => x_msg_data

Line 1073: WHEN FND_API.G_EXC_ERROR THEN

1069: , x_msg_data => x_msg_data
1070: , x_msg_count => x_msg_count
1071: );
1072: EXCEPTION
1073: WHEN FND_API.G_EXC_ERROR THEN
1074: x_return_status := FND_API.G_RET_STS_ERROR;
1075: FND_MSG_Pub.count_and_get
1076: ( p_count => x_msg_count
1077: , p_data => x_msg_data

Line 1074: x_return_status := FND_API.G_RET_STS_ERROR;

1070: , x_msg_count => x_msg_count
1071: );
1072: EXCEPTION
1073: WHEN FND_API.G_EXC_ERROR THEN
1074: x_return_status := FND_API.G_RET_STS_ERROR;
1075: FND_MSG_Pub.count_and_get
1076: ( p_count => x_msg_count
1077: , p_data => x_msg_data
1078: );

Line 1100: x_return_status := FND_API.G_RET_STS_SUCCESS;

1096: , x_msg_count OUT NOCOPY NUMBER)
1097: IS
1098: l_api_name CONSTANT VARCHAR2 (30) := 'Sorting_criteria_Delete';
1099: Begin
1100: x_return_status := FND_API.G_RET_STS_SUCCESS;
1101: debug('delete sorting criteria');
1102: Delete wms_sort_criteria where rule_id = p_mtl_picking_Rule_rec.wms_rule_id;
1103: EXCEPTION
1104: WHEN FND_API.G_EXC_ERROR THEN

Line 1104: WHEN FND_API.G_EXC_ERROR THEN

1100: x_return_status := FND_API.G_RET_STS_SUCCESS;
1101: debug('delete sorting criteria');
1102: Delete wms_sort_criteria where rule_id = p_mtl_picking_Rule_rec.wms_rule_id;
1103: EXCEPTION
1104: WHEN FND_API.G_EXC_ERROR THEN
1105: x_return_status := FND_API.G_RET_STS_ERROR;
1106: FND_MSG_Pub.count_and_get
1107: ( p_count => x_msg_count
1108: , p_data => x_msg_data

Line 1105: x_return_status := FND_API.G_RET_STS_ERROR;

1101: debug('delete sorting criteria');
1102: Delete wms_sort_criteria where rule_id = p_mtl_picking_Rule_rec.wms_rule_id;
1103: EXCEPTION
1104: WHEN FND_API.G_EXC_ERROR THEN
1105: x_return_status := FND_API.G_RET_STS_ERROR;
1106: FND_MSG_Pub.count_and_get
1107: ( p_count => x_msg_count
1108: , p_data => x_msg_data
1109: );

Line 1135: x_return_status := FND_API.G_RET_STS_SUCCESS;

1131: l_strategy_id NUMBER;
1132: l_strategy_name VARCHAR2(50);
1133: l_rowid VARCHAR2(500);
1134: Begin
1135: x_return_status := FND_API.G_RET_STS_SUCCESS;
1136: --check enabled flag for the rule, only insert strategy for enabled rules
1137: debug('Procedure Strategy_insert');
1138: if p_mtl_picking_rule_rec.enabled_flag <> 'Y' Then
1139: return;

Line 1216: WHEN FND_API.G_EXC_ERROR THEN

1212: , X_Date_Type_From => null
1213: , X_Date_Type_To => null
1214: );
1215: EXCEPTION
1216: WHEN FND_API.G_EXC_ERROR THEN
1217: x_return_status := FND_API.G_RET_STS_ERROR;
1218: FND_MSG_Pub.count_and_get
1219: ( p_count => x_msg_count
1220: , p_data => x_msg_data

Line 1217: x_return_status := FND_API.G_RET_STS_ERROR;

1213: , X_Date_Type_To => null
1214: );
1215: EXCEPTION
1216: WHEN FND_API.G_EXC_ERROR THEN
1217: x_return_status := FND_API.G_RET_STS_ERROR;
1218: FND_MSG_Pub.count_and_get
1219: ( p_count => x_msg_count
1220: , p_data => x_msg_data
1221: );

Line 1246: x_return_status := FND_API.G_RET_STS_SUCCESS;

1242: )
1243: IS
1244: l_api_name CONSTANT VARCHAR2 (30) := 'Strategy_Update';
1245: Begin
1246: x_return_status := FND_API.G_RET_STS_SUCCESS;
1247: if p_mtl_picking_rule_rec.enabled_flag = 'N' then
1248: WMS_STRATEGIES_PKG.Update_Row(
1249: X_Strategy_Id => p_mtl_picking_rule_rec.wms_Strategy_Id,
1250: X_Organization_Id => -1,

Line 1278: WHEN FND_API.G_EXC_ERROR THEN

1274: X_Attribute_Category => null
1275: );
1276: end if;
1277: EXCEPTION
1278: WHEN FND_API.G_EXC_ERROR THEN
1279: x_return_status := FND_API.G_RET_STS_ERROR;
1280: FND_MSG_Pub.count_and_get
1281: ( p_count => x_msg_count
1282: , p_data => x_msg_data

Line 1279: x_return_status := FND_API.G_RET_STS_ERROR;

1275: );
1276: end if;
1277: EXCEPTION
1278: WHEN FND_API.G_EXC_ERROR THEN
1279: x_return_status := FND_API.G_RET_STS_ERROR;
1280: FND_MSG_Pub.count_and_get
1281: ( p_count => x_msg_count
1282: , p_data => x_msg_data
1283: );

Line 1307: x_return_status := FND_API.G_RET_STS_SUCCESS;

1303: )
1304: IS
1305: l_api_name CONSTANT VARCHAR2 (30) := 'Strategy_Delete';
1306: Begin
1307: x_return_status := FND_API.G_RET_STS_SUCCESS;
1308: null;
1309: EXCEPTION
1310: WHEN FND_API.G_EXC_ERROR THEN
1311: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1310: WHEN FND_API.G_EXC_ERROR THEN

1306: Begin
1307: x_return_status := FND_API.G_RET_STS_SUCCESS;
1308: null;
1309: EXCEPTION
1310: WHEN FND_API.G_EXC_ERROR THEN
1311: x_return_status := FND_API.G_RET_STS_ERROR;
1312: FND_MSG_Pub.count_and_get
1313: ( p_count => x_msg_count
1314: , p_data => x_msg_data

Line 1311: x_return_status := FND_API.G_RET_STS_ERROR;

1307: x_return_status := FND_API.G_RET_STS_SUCCESS;
1308: null;
1309: EXCEPTION
1310: WHEN FND_API.G_EXC_ERROR THEN
1311: x_return_status := FND_API.G_RET_STS_ERROR;
1312: FND_MSG_Pub.count_and_get
1313: ( p_count => x_msg_count
1314: , p_data => x_msg_data
1315: );

Line 1342: x_return_status := FND_API.G_RET_STS_SUCCESS;

1338: l_msg_data VARCHAR2(2000);
1339: l_msg_count NUMBER;
1340: v_type_code number;
1341: BEGIN
1342: x_return_status := FND_API.G_RET_STS_SUCCESS;
1343: l_picking_rule_rec := p_mtl_picking_rule_rec;
1344: debug('Procedure rule enable flag');
1345: IF l_picking_rule_rec.Enabled_Flag = 'Y' THEN
1346: l_picking_rule_rec.enabled_flag:='Y';

Line 1351: ,p_init_msg_list => FND_API.G_TRUE

1347: -- Check rule Syntax
1348: debug('checksyntax');
1349: WMS_rule_PVT.CheckSyntax (
1350: p_api_version => 1.0
1351: ,p_init_msg_list => FND_API.G_TRUE
1352: ,p_validation_level => FND_API.G_VALID_LEVEL_NONE
1353: ,x_return_status => l_return_status
1354: ,x_msg_count => l_msg_count
1355: ,x_msg_data => l_msg_data

Line 1352: ,p_validation_level => FND_API.G_VALID_LEVEL_NONE

1348: debug('checksyntax');
1349: WMS_rule_PVT.CheckSyntax (
1350: p_api_version => 1.0
1351: ,p_init_msg_list => FND_API.G_TRUE
1352: ,p_validation_level => FND_API.G_VALID_LEVEL_NONE
1353: ,x_return_status => l_return_status
1354: ,x_msg_count => l_msg_count
1355: ,x_msg_data => l_msg_data
1356: ,p_rule_id => l_picking_rule_rec.wms_rule_ID

Line 1358: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1354: ,x_msg_count => l_msg_count
1355: ,x_msg_data => l_msg_data
1356: ,p_rule_id => l_picking_rule_rec.wms_rule_ID
1357: );
1358: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1359: debug('checksyntax failed');
1360: --INV_GLOBAL_PKG.Show_Errors;
1361: l_picking_rule_rec.Enabled_Flag := 'N';
1362: END IF;

Line 1369: ,p_init_msg_list => FND_API.G_TRUE

1365: debug('generateruleexecpkgs');
1366: WMS_rule_gen_pkgs.GenerateRuleExecPkgs
1367: (
1368: p_api_version => 1.0
1369: ,p_init_msg_list => FND_API.G_TRUE
1370: ,p_validation_level => FND_API.G_VALID_LEVEL_NONE
1371: ,x_return_status => l_return_status
1372: ,x_msg_count => l_msg_count
1373: ,x_msg_data => l_msg_data

Line 1370: ,p_validation_level => FND_API.G_VALID_LEVEL_NONE

1366: WMS_rule_gen_pkgs.GenerateRuleExecPkgs
1367: (
1368: p_api_version => 1.0
1369: ,p_init_msg_list => FND_API.G_TRUE
1370: ,p_validation_level => FND_API.G_VALID_LEVEL_NONE
1371: ,x_return_status => l_return_status
1372: ,x_msg_count => l_msg_count
1373: ,x_msg_data => l_msg_data
1374: ,p_pick_code => 2

Line 1423: WHEN FND_API.G_EXC_ERROR THEN

1419: where rule_id=p_mtl_picking_rule_rec.wms_rule_id;
1420: commit;
1421: END IF;
1422: EXCEPTION
1423: WHEN FND_API.G_EXC_ERROR THEN
1424: x_return_status := FND_API.G_RET_STS_ERROR;
1425: FND_MSG_Pub.count_and_get
1426: ( p_count => x_msg_count
1427: , p_data => x_msg_data

Line 1424: x_return_status := FND_API.G_RET_STS_ERROR;

1420: commit;
1421: END IF;
1422: EXCEPTION
1423: WHEN FND_API.G_EXC_ERROR THEN
1424: x_return_status := FND_API.G_RET_STS_ERROR;
1425: FND_MSG_Pub.count_and_get
1426: ( p_count => x_msg_count
1427: , p_data => x_msg_data
1428: );

Line 1487: x_return_status := FND_API.G_RET_STS_SUCCESS;

1483: l_rules_engine_mode NUMBER := NVL(FND_PROFILE.VALUE('WMS_RULES_ENGINE_MODE'), 0);
1484: l_nDummy VARCHAR2(1);
1485: l_bReturn BOOLEAN;
1486: BEGIN
1487: x_return_status := FND_API.G_RET_STS_SUCCESS;
1488: debug('check rule is assigned');
1489: debug('rule_id '|| p_mtl_picking_rule_rec.wms_rule_id);
1490: debug('strategy_id '|| p_mtl_picking_rule_rec.wms_strategy_id);
1491: /*

Line 1526: WHEN FND_API.G_EXC_ERROR THEN

1522: end if;
1523:
1524: RETURN(l_bReturn);
1525: EXCEPTION
1526: WHEN FND_API.G_EXC_ERROR THEN
1527: x_return_status := FND_API.G_RET_STS_ERROR;
1528: FND_MSG_Pub.count_and_get
1529: ( p_count => x_msg_count
1530: , p_data => x_msg_data

Line 1527: x_return_status := FND_API.G_RET_STS_ERROR;

1523:
1524: RETURN(l_bReturn);
1525: EXCEPTION
1526: WHEN FND_API.G_EXC_ERROR THEN
1527: x_return_status := FND_API.G_RET_STS_ERROR;
1528: FND_MSG_Pub.count_and_get
1529: ( p_count => x_msg_count
1530: , p_data => x_msg_data
1531: );

Line 1557: x_return_status := FND_API.G_RET_STS_SUCCESS;

1553: l_msg_data VARCHAR2(2000);
1554: l_msg_count NUMBER;
1555: rec_status VARCHAR2(25);
1556: BEGIN
1557: x_return_status := FND_API.G_RET_STS_SUCCESS;
1558: IF p_mtl_picking_rule_rec.Enabled_Flag = 'Y' THEN
1559: WMS_Rule_PVT.GenerateRulePackage
1560: (
1561: p_api_version => 1.0

Line 1562: ,p_init_msg_list => FND_API.G_TRUE

1558: IF p_mtl_picking_rule_rec.Enabled_Flag = 'Y' THEN
1559: WMS_Rule_PVT.GenerateRulePackage
1560: (
1561: p_api_version => 1.0
1562: ,p_init_msg_list => FND_API.G_TRUE
1563: ,p_validation_level => FND_API.G_VALID_LEVEL_NONE
1564: ,x_return_status => x_return_status
1565: ,x_msg_count => x_msg_count
1566: ,x_msg_data => x_msg_data

Line 1563: ,p_validation_level => FND_API.G_VALID_LEVEL_NONE

1559: WMS_Rule_PVT.GenerateRulePackage
1560: (
1561: p_api_version => 1.0
1562: ,p_init_msg_list => FND_API.G_TRUE
1563: ,p_validation_level => FND_API.G_VALID_LEVEL_NONE
1564: ,x_return_status => x_return_status
1565: ,x_msg_count => x_msg_count
1566: ,x_msg_data => x_msg_data
1567: ,p_rule_id => p_mtl_picking_rule_rec.wms_RULE_ID

Line 1569: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)

1565: ,x_msg_count => x_msg_count
1566: ,x_msg_data => x_msg_data
1567: ,p_rule_id => p_mtl_picking_rule_rec.wms_RULE_ID
1568: );
1569: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
1570: THEN
1571: p_mtl_picking_rule_rec.Enabled_Flag := 'N';
1572: RAISE FND_API.G_EXC_ERROR;
1573: ELSE

Line 1572: RAISE FND_API.G_EXC_ERROR;

1568: );
1569: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
1570: THEN
1571: p_mtl_picking_rule_rec.Enabled_Flag := 'N';
1572: RAISE FND_API.G_EXC_ERROR;
1573: ELSE
1574: fnd_message.set_name('WMS','WMS_PACKAGE_REGENERATE');
1575: FND_MSG_PUB.Add;
1576: RAISE FND_API.G_EXC_ERROR;

Line 1576: RAISE FND_API.G_EXC_ERROR;

1572: RAISE FND_API.G_EXC_ERROR;
1573: ELSE
1574: fnd_message.set_name('WMS','WMS_PACKAGE_REGENERATE');
1575: FND_MSG_PUB.Add;
1576: RAISE FND_API.G_EXC_ERROR;
1577: END IF;
1578: END IF;
1579: EXCEPTION
1580: WHEN FND_API.G_EXC_ERROR THEN

Line 1580: WHEN FND_API.G_EXC_ERROR THEN

1576: RAISE FND_API.G_EXC_ERROR;
1577: END IF;
1578: END IF;
1579: EXCEPTION
1580: WHEN FND_API.G_EXC_ERROR THEN
1581: x_return_status := FND_API.G_RET_STS_ERROR;
1582: FND_MSG_Pub.count_and_get
1583: ( p_count => x_msg_count
1584: , p_data => x_msg_data

Line 1581: x_return_status := FND_API.G_RET_STS_ERROR;

1577: END IF;
1578: END IF;
1579: EXCEPTION
1580: WHEN FND_API.G_EXC_ERROR THEN
1581: x_return_status := FND_API.G_RET_STS_ERROR;
1582: FND_MSG_Pub.count_and_get
1583: ( p_count => x_msg_count
1584: , p_data => x_msg_data
1585: );