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_DEBUG_PUB

Line 11: l_debug_level NUMBER := oe_debug_pub.g_debug_level;

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:
14:
15: IF l_debug_level > 0 then

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 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 63: l_debug_level NUMBER := oe_debug_pub.g_debug_level;

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:
66:
67: IF l_debug_level > 0 then

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 193: l_debug_level NUMBER := oe_debug_pub.g_debug_level;

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;
194: begin
195:
196:
197: IF l_debug_level > 0 then

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 326: l_debug_level NUMBER := oe_debug_pub.g_debug_level;

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
328:
329: IF l_debug_level > 0 then
330: oe_debug_pub.add('Entering OE_ITORD_PUB.Validate_conditional_fields');

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 871: l_debug_level NUMBER := oe_debug_pub.g_debug_level;

867: l_rule_level_value VARCHAR2(1000);
868: l_data_type VARCHAR2(1);
869:
870: sql_stmt VARCHAR2(32000);
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');

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 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 1034: oe_debug_pub.add('Entering get_rule_coulumn_details', 5);

1030: ) IS
1031: p_rule_level VARCHAR2(1000);
1032: begin
1033:
1034: oe_debug_pub.add('Entering get_rule_coulumn_details', 5);
1035:
1036: x_data_type := 'N';
1037: p_rule_level := p_Item_Orderability_Import_Rec.RULE_LEVEL;
1038:

Line 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);

1083: x_rule_level_column := 'DELIVER_TO_LOCATION_ID';
1084: x_rule_level_value := p_Item_Orderability_Import_Rec.DELIVER_TO_LOCATION_ID;
1085: END IF;
1086:
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

Line 1099: l_debug_level NUMBER := oe_debug_pub.g_debug_level;

1095: l_orderability_id NUMBER;
1096: l_status VARCHAR2(1);
1097: l_rowid rowid := NULL;
1098:
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');

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 1223: l_debug_level NUMBER := oe_debug_pub.g_debug_level;

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:
1226: IF l_debug_level > 0 then
1227: oe_debug_pub.add('Entering OE_ITORD_PUB.Validate_rules_DFF ');

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: