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.OE_ITORD_PUB dependencies on OE_ITORD_PUB

Line 1: PACKAGE BODY OE_ITORD_PUB AS

1: PACKAGE BODY OE_ITORD_PUB AS
2: /* $Header: OEXPITOB.pls 120.3 2010/09/03 09:59:00 amallik ship $ */
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_ITORD_PUB';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_ITORD_PUB';

1: PACKAGE BODY OE_ITORD_PUB AS
2: /* $Header: OEXPITOB.pls 120.3 2010/09/03 09:59:00 amallik ship $ */
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_ITORD_PUB';
6:
7: /* This procedure shall be called by custom programs to import item orderability rules into OM */
8:
9: Procedure Import_Item_orderability_rules ( p_Item_Orderability_Import_Tbl IN OUT NOCOPY OE_ITORD_PUB.Item_Orderability_Import_Tbl

Line 9: Procedure Import_Item_orderability_rules ( p_Item_Orderability_Import_Tbl IN OUT NOCOPY OE_ITORD_PUB.Item_Orderability_Import_Tbl

5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_ITORD_PUB';
6:
7: /* This procedure shall be called by custom programs to import item orderability rules into OM */
8:
9: Procedure Import_Item_orderability_rules ( p_Item_Orderability_Import_Tbl IN OUT NOCOPY OE_ITORD_PUB.Item_Orderability_Import_Tbl
10: , p_commit_flag IN VARCHAR2 DEFAULT 'N') IS
11: l_debug_level NUMBER := oe_debug_pub.g_debug_level;
12: begin
13:

Line 16: oe_debug_pub.add('Entering OE_ITORD_PUB.Import_Item_orderability_rules');

12: begin
13:
14:
15: IF l_debug_level > 0 then
16: oe_debug_pub.add('Entering OE_ITORD_PUB.Import_Item_orderability_rules');
17: End If;
18:
19: for i in 1..p_Item_Orderability_Import_Tbl.count loop
20:

Line 21: OE_ITORD_PUB.Check_required_fields( p_Item_Orderability_Import_Tbl(i));

17: End If;
18:
19: for i in 1..p_Item_Orderability_Import_Tbl.count loop
20:
21: OE_ITORD_PUB.Check_required_fields( p_Item_Orderability_Import_Tbl(i));
22: IF p_Item_Orderability_Import_Tbl(i).status = FND_API.G_RET_STS_SUCCESS then
23: OE_ITORD_PUB.Validate_required_fields ( p_Item_Orderability_Import_Tbl(i));
24: IF p_Item_Orderability_Import_Tbl(i).status = FND_API.G_RET_STS_SUCCESS then
25: OE_ITORD_PUB.Validate_conditional_fields ( p_Item_Orderability_Import_Tbl(i));

Line 23: OE_ITORD_PUB.Validate_required_fields ( p_Item_Orderability_Import_Tbl(i));

19: for i in 1..p_Item_Orderability_Import_Tbl.count loop
20:
21: OE_ITORD_PUB.Check_required_fields( p_Item_Orderability_Import_Tbl(i));
22: IF p_Item_Orderability_Import_Tbl(i).status = FND_API.G_RET_STS_SUCCESS then
23: OE_ITORD_PUB.Validate_required_fields ( p_Item_Orderability_Import_Tbl(i));
24: IF p_Item_Orderability_Import_Tbl(i).status = FND_API.G_RET_STS_SUCCESS then
25: OE_ITORD_PUB.Validate_conditional_fields ( p_Item_Orderability_Import_Tbl(i));
26: IF p_Item_Orderability_Import_Tbl(i).status = FND_API.G_RET_STS_SUCCESS then
27: OE_ITORD_PUB.check_duplicate_rules ( p_Item_Orderability_Import_Tbl(i) );

Line 25: OE_ITORD_PUB.Validate_conditional_fields ( p_Item_Orderability_Import_Tbl(i));

21: OE_ITORD_PUB.Check_required_fields( p_Item_Orderability_Import_Tbl(i));
22: IF p_Item_Orderability_Import_Tbl(i).status = FND_API.G_RET_STS_SUCCESS then
23: OE_ITORD_PUB.Validate_required_fields ( p_Item_Orderability_Import_Tbl(i));
24: IF p_Item_Orderability_Import_Tbl(i).status = FND_API.G_RET_STS_SUCCESS then
25: OE_ITORD_PUB.Validate_conditional_fields ( p_Item_Orderability_Import_Tbl(i));
26: IF p_Item_Orderability_Import_Tbl(i).status = FND_API.G_RET_STS_SUCCESS then
27: OE_ITORD_PUB.check_duplicate_rules ( p_Item_Orderability_Import_Tbl(i) );
28: IF p_Item_Orderability_Import_Tbl(i).status = FND_API.G_RET_STS_SUCCESS then
29: OE_ITORD_PUB.Validate_rules_DFF (p_Item_Orderability_Import_Tbl(i));

Line 27: OE_ITORD_PUB.check_duplicate_rules ( p_Item_Orderability_Import_Tbl(i) );

23: OE_ITORD_PUB.Validate_required_fields ( p_Item_Orderability_Import_Tbl(i));
24: IF p_Item_Orderability_Import_Tbl(i).status = FND_API.G_RET_STS_SUCCESS then
25: OE_ITORD_PUB.Validate_conditional_fields ( p_Item_Orderability_Import_Tbl(i));
26: IF p_Item_Orderability_Import_Tbl(i).status = FND_API.G_RET_STS_SUCCESS then
27: OE_ITORD_PUB.check_duplicate_rules ( p_Item_Orderability_Import_Tbl(i) );
28: IF p_Item_Orderability_Import_Tbl(i).status = FND_API.G_RET_STS_SUCCESS then
29: OE_ITORD_PUB.Validate_rules_DFF (p_Item_Orderability_Import_Tbl(i));
30: IF p_Item_Orderability_Import_Tbl(i).status = FND_API.G_RET_STS_SUCCESS then
31: OE_ITORD_PUB.insert_rules(p_Item_Orderability_Import_Tbl(i));

Line 29: OE_ITORD_PUB.Validate_rules_DFF (p_Item_Orderability_Import_Tbl(i));

25: OE_ITORD_PUB.Validate_conditional_fields ( p_Item_Orderability_Import_Tbl(i));
26: IF p_Item_Orderability_Import_Tbl(i).status = FND_API.G_RET_STS_SUCCESS then
27: OE_ITORD_PUB.check_duplicate_rules ( p_Item_Orderability_Import_Tbl(i) );
28: IF p_Item_Orderability_Import_Tbl(i).status = FND_API.G_RET_STS_SUCCESS then
29: OE_ITORD_PUB.Validate_rules_DFF (p_Item_Orderability_Import_Tbl(i));
30: IF p_Item_Orderability_Import_Tbl(i).status = FND_API.G_RET_STS_SUCCESS then
31: OE_ITORD_PUB.insert_rules(p_Item_Orderability_Import_Tbl(i));
32: END IF;
33:

Line 31: OE_ITORD_PUB.insert_rules(p_Item_Orderability_Import_Tbl(i));

27: OE_ITORD_PUB.check_duplicate_rules ( p_Item_Orderability_Import_Tbl(i) );
28: IF p_Item_Orderability_Import_Tbl(i).status = FND_API.G_RET_STS_SUCCESS then
29: OE_ITORD_PUB.Validate_rules_DFF (p_Item_Orderability_Import_Tbl(i));
30: IF p_Item_Orderability_Import_Tbl(i).status = FND_API.G_RET_STS_SUCCESS then
31: OE_ITORD_PUB.insert_rules(p_Item_Orderability_Import_Tbl(i));
32: END IF;
33:
34: END IF;
35: END IF;

Line 48: oe_debug_pub.add('Leaving OE_ITORD_PUB.Import_Item_orderability_rules');

44: rollback;
45: End If;
46:
47: IF l_debug_level > 0 then
48: oe_debug_pub.add('Leaving OE_ITORD_PUB.Import_Item_orderability_rules');
49: End If;
50:
51: Exception
52: when others then

Line 61: Procedure Check_required_fields ( p_Item_Orderability_Import_Rec IN OUT NOCOPY OE_ITORD_PUB.Item_Orderability_Import_Rec )

57: );
58: End Import_Item_orderability_rules;
59:
60:
61: Procedure Check_required_fields ( p_Item_Orderability_Import_Rec IN OUT NOCOPY OE_ITORD_PUB.Item_Orderability_Import_Rec )
62: IS
63: l_debug_level NUMBER := oe_debug_pub.g_debug_level;
64: begin
65:

Line 68: oe_debug_pub.add('Entering OE_ITORD_PUB.Check_required_fields');

64: begin
65:
66:
67: IF l_debug_level > 0 then
68: oe_debug_pub.add('Entering OE_ITORD_PUB.Check_required_fields');
69: End If;
70:
71: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_SUCCESS;
72: p_Item_Orderability_Import_Rec.msg_data := NULL;

Line 181: oe_debug_pub.add('Leaving OE_ITORD_PUB.Check_required_fields');

177: END IF;
178:
179:
180: IF l_debug_level > 0 then
181: oe_debug_pub.add('Leaving OE_ITORD_PUB.Check_required_fields');
182: End If;
183:
184: Exception
185: when others then

Line 189: Procedure Validate_required_fields ( p_Item_Orderability_Import_REC IN OUT NOCOPY OE_ITORD_PUB.Item_Orderability_Import_REC )

185: when others then
186: NULL;
187: End Check_required_fields;
188:
189: Procedure Validate_required_fields ( p_Item_Orderability_Import_REC IN OUT NOCOPY OE_ITORD_PUB.Item_Orderability_Import_REC )
190: IS
191:
192: l_exists varchar2(1);
193: l_debug_level NUMBER := oe_debug_pub.g_debug_level;

Line 198: oe_debug_pub.add('Entering OE_ITORD_PUB.Validate_required_fields');

194: begin
195:
196:
197: IF l_debug_level > 0 then
198: oe_debug_pub.add('Entering OE_ITORD_PUB.Validate_required_fields');
199: End If;
200:
201: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_SUCCESS;
202: p_Item_Orderability_Import_Rec.msg_data := NULL;

Line 311: oe_debug_pub.add('Leaving OE_ITORD_PUB.Validate_required_fields');

307: END IF;
308:
309:
310: IF l_debug_level > 0 then
311: oe_debug_pub.add('Leaving OE_ITORD_PUB.Validate_required_fields');
312: End If;
313:
314: Exception
315: when others then

Line 323: Procedure Validate_conditional_fields ( p_Item_Orderability_Import_Rec IN OUT NOCOPY OE_ITORD_PUB.Item_Orderability_Import_Rec )

319: End Validate_required_fields;
320:
321:
322:
323: Procedure Validate_conditional_fields ( p_Item_Orderability_Import_Rec IN OUT NOCOPY OE_ITORD_PUB.Item_Orderability_Import_Rec )
324: IS
325: l_exists VARCHAR2(1);
326: l_debug_level NUMBER := oe_debug_pub.g_debug_level;
327: begin

Line 330: oe_debug_pub.add('Entering OE_ITORD_PUB.Validate_conditional_fields');

326: l_debug_level NUMBER := oe_debug_pub.g_debug_level;
327: begin
328:
329: IF l_debug_level > 0 then
330: oe_debug_pub.add('Entering OE_ITORD_PUB.Validate_conditional_fields');
331: End If;
332:
333: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_SUCCESS;
334: p_Item_Orderability_Import_Rec.msg_data := NULL;

Line 851: oe_debug_pub.add('Leaving OE_ITORD_PUB.Validate_conditional_fields');

847: p_Item_Orderability_Import_Rec.inventory_item_id := NULL;
848: END IF;
849:
850: IF l_debug_level > 0 then
851: oe_debug_pub.add('Leaving OE_ITORD_PUB.Validate_conditional_fields');
852: End If;
853:
854: Exception
855: when others then

Line 862: Procedure check_duplicate_rules ( p_Item_Orderability_Import_Rec IN OUT NOCOPY OE_ITORD_PUB.Item_Orderability_Import_Rec )

858: p_Item_Orderability_Import_Rec.msg_count := 1;
859: End Validate_conditional_fields;
860:
861:
862: Procedure check_duplicate_rules ( p_Item_Orderability_Import_Rec IN OUT NOCOPY OE_ITORD_PUB.Item_Orderability_Import_Rec )
863: IS
864: l_exists Varchar2(1);
865: l_return_token boolean := TRUE;
866: l_rule_level_coulmn VARCHAR2(1000);

Line 875: oe_debug_pub.add('Entering OE_ITORD_PUB.check_duplicate_rules');

871: l_debug_level NUMBER := oe_debug_pub.g_debug_level;
872: begin
873:
874: IF l_debug_level > 0 then
875: oe_debug_pub.add('Entering OE_ITORD_PUB.check_duplicate_rules');
876: End If;
877:
878: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_SUCCESS;
879: p_Item_Orderability_Import_Rec.msg_data := NULL;

Line 915: OE_ITORD_PUB.get_rule_coulumn_details(p_Item_Orderability_Import_Rec,l_rule_level_coulmn,l_rule_level_value,l_data_type);

911: End;
912:
913: IF p_Item_Orderability_Import_Rec.RULE_LEVEL IS NOT NULL THEN -- Added for bug 10055559
914:
915: OE_ITORD_PUB.get_rule_coulumn_details(p_Item_Orderability_Import_Rec,l_rule_level_coulmn,l_rule_level_value,l_data_type);
916:
917: sql_stmt := ' select count(1) '
918: || ' from oe_item_orderability io_hdr , oe_item_orderability_rules io_rules '
919: || ' where io_hdr.orderability_id = io_rules.orderability_id '

Line 980: OE_ITORD_PUB.get_rule_coulumn_details(p_Item_Orderability_Import_Rec,l_rule_level_coulmn,l_rule_level_value,l_data_type);

976: End ;
977:
978: IF p_Item_Orderability_Import_Rec.RULE_LEVEL IS NOT NULL THEN -- Added for bug 10055559
979:
980: OE_ITORD_PUB.get_rule_coulumn_details(p_Item_Orderability_Import_Rec,l_rule_level_coulmn,l_rule_level_value,l_data_type);
981:
982: sql_stmt := ' select count(1) '
983: || ' from oe_item_orderability io_hdr , oe_item_orderability_rules io_rules '
984: || ' where io_hdr.orderability_id = io_rules.orderability_id '

Line 1016: oe_debug_pub.add('Leaving OE_ITORD_PUB.check_duplicate_rules');

1012:
1013: End If;
1014:
1015: IF l_debug_level > 0 then
1016: oe_debug_pub.add('Leaving OE_ITORD_PUB.check_duplicate_rules');
1017: End If;
1018:
1019: Exception
1020: when others then

Line 1026: Procedure get_rule_coulumn_details( p_Item_Orderability_Import_Rec IN OE_ITORD_PUB.Item_Orderability_Import_Rec ,

1022: p_Item_Orderability_Import_Rec.msg_data := SQLERRM;
1023: p_Item_Orderability_Import_Rec.msg_count := 1;
1024: End check_duplicate_rules;
1025:
1026: Procedure get_rule_coulumn_details( p_Item_Orderability_Import_Rec IN OE_ITORD_PUB.Item_Orderability_Import_Rec ,
1027: x_rule_level_column OUT NOCOPY VARCHAR2,
1028: x_rule_level_value OUT NOCOPY VARCHAR2,
1029: x_data_type OUT NOCOPY VARCHAR2
1030: ) IS

Line 1091: Procedure insert_rules( p_Item_Orderability_Import_Rec IN OUT NOCOPY OE_ITORD_PUB.Item_Orderability_Import_Rec ) IS

1087: oe_debug_pub.add('Exiting get_rule_coulumn_details, x_rule_level_column : ' || x_rule_level_column || ', x_rule_level_value : ' || x_rule_level_value || ', x_data_type : ' || x_data_type, 5);
1088:
1089: End;
1090:
1091: Procedure insert_rules( p_Item_Orderability_Import_Rec IN OUT NOCOPY OE_ITORD_PUB.Item_Orderability_Import_Rec ) IS
1092:
1093: l_item_orderability_rec OE_ITORD_UTIL.Item_Orderability_Rec;
1094: l_item_orderability_rules_rec OE_ITORD_UTIL.Item_Orderability_Rules_Rec;
1095: l_orderability_id NUMBER;

Line 1103: oe_debug_pub.add('Entering OE_ITORD_PUB.insert_rules');

1099: l_debug_level NUMBER := oe_debug_pub.g_debug_level;
1100: begin
1101:
1102: IF l_debug_level > 0 then
1103: oe_debug_pub.add('Entering OE_ITORD_PUB.insert_rules');
1104: End If;
1105:
1106: p_Item_Orderability_Import_Rec.status := FND_API.G_RET_STS_SUCCESS;
1107: p_Item_Orderability_Import_Rec.msg_data := NULL;

Line 1208: oe_debug_pub.add('Leaving OE_ITORD_PUB.insert_rules');

1204: End If;
1205:
1206:
1207: IF l_debug_level > 0 then
1208: oe_debug_pub.add('Leaving OE_ITORD_PUB.insert_rules');
1209: End If;
1210:
1211: Exception
1212: when others then

Line 1221: Procedure Validate_rules_DFF (p_Item_Orderability_Import_Rec IN OUT NOCOPY OE_ITORD_PUB.Item_Orderability_Import_Rec )

1217:
1218: End insert_rules;
1219:
1220:
1221: Procedure Validate_rules_DFF (p_Item_Orderability_Import_Rec IN OUT NOCOPY OE_ITORD_PUB.Item_Orderability_Import_Rec )
1222: IS
1223: l_debug_level NUMBER := oe_debug_pub.g_debug_level;
1224: BEGIN
1225:

Line 1227: oe_debug_pub.add('Entering OE_ITORD_PUB.Validate_rules_DFF ');

1223: l_debug_level NUMBER := oe_debug_pub.g_debug_level;
1224: BEGIN
1225:
1226: IF l_debug_level > 0 then
1227: oe_debug_pub.add('Entering OE_ITORD_PUB.Validate_rules_DFF ');
1228: End If;
1229:
1230:
1231: FND_FLEX_DESCVAL.Set_Context_Value

Line 1316: oe_debug_pub.add('Leaving OE_ITORD_PUB.Validate_rules_DFF ');

1312:
1313:
1314:
1315: IF l_debug_level > 0 then
1316: oe_debug_pub.add('Leaving OE_ITORD_PUB.Validate_rules_DFF ');
1317: End If;
1318:
1319: EXCEPTION
1320:

Line 1330: END OE_ITORD_PUB;

1326: END Validate_rules_DFF;
1327:
1328:
1329:
1330: END OE_ITORD_PUB;