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_COGS_GRP dependencies on OE_DEBUG_PUB

Line 19: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level; --9811795

15: l_ato_line_id_cogs NUMBER; --9811795
16: l_ato_line_id_rev NUMBER; --9811795
17: l_invoicable VARCHAR2(1);
18: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
19: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level; --9811795
20:
21: BEGIN
22: x_return_status := FND_API.G_RET_STS_SUCCESS;
23: x_revenue_event_line_id := -1; --9811795

Line 28: OE_DEBUG_PUB.ADD('Entering oe_cogs_grp.get_revenue_event_line ');

24:
25: --9811795 start
26: IF l_debug_level > 0
27: THEN
28: OE_DEBUG_PUB.ADD('Entering oe_cogs_grp.get_revenue_event_line ');
29: END IF;
30: --9811795 end
31:
32: l_line_id := p_shippable_line_id;

Line 44: OE_DEBUG_PUB.ADD('Below calling extension API');

40: IF l_ato_line_id_cogs IS NOT NULL THEN
41:
42: IF l_debug_level > 0
43: THEN
44: OE_DEBUG_PUB.ADD('Below calling extension API');
45: END IF;
46:
47: oe_cogs_extension.get_revenue_event_line
48: (

Line 58: OE_DEBUG_PUB.ADD('After calling extension API , revenue event line id :'||x_revenue_event_line_id);

54: );
55:
56: IF l_debug_level > 0
57: THEN
58: OE_DEBUG_PUB.ADD('After calling extension API , revenue event line id :'||x_revenue_event_line_id);
59: END IF;
60:
61: IF x_revenue_event_line_id <> -1 THEN
62:

Line 76: OE_DEBUG_PUB.ADD('Revenue Line ID and COGS Line ID are not a part of same ATO Model');

72: OE_MSG_PUB.ADD;
73:
74: IF l_debug_level > 0
75: THEN
76: OE_DEBUG_PUB.ADD('Revenue Line ID and COGS Line ID are not a part of same ATO Model');
77: END IF;
78:
79: x_return_status := FND_API.G_RET_STS_ERROR;
80: RETURN;

Line 124: OE_DEBUG_PUB.ADD('Exiting oe_cogs_grp.get_revenue_event_line ');

120:
121: --9811795 start
122: IF l_debug_level > 0
123: THEN
124: OE_DEBUG_PUB.ADD('Exiting oe_cogs_grp.get_revenue_event_line ');
125: END IF;
126: --9811795 end
127:
128: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 141: OE_DEBUG_PUB.ADD('Error When no data found ');

137:
138: --9811795 start
139: IF l_debug_level > 0
140: THEN
141: OE_DEBUG_PUB.ADD('Error When no data found ');
142: END IF;
143: --9811795 end
144:
145: WHEN OTHERS THEN

Line 151: OE_DEBUG_PUB.ADD('When others:'||substr(SQLCODE,1,250));

147:
148: --9811795 start
149: IF l_debug_level > 0
150: THEN
151: OE_DEBUG_PUB.ADD('When others:'||substr(SQLCODE,1,250));
152: END IF;
153: --9811795 end
154:
155: END get_revenue_event_line;

Line 169: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

165: l_master_org_id NUMBER;
166: l_master_org varchar2(30) := 'MASTER_ORGANIZATION_ID';
167: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
168: l_notify_costing VARCHAR2(1);
169: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
170:
171: -- bug#11717692
172: l_inventory_interfaced VARCHAR2(1) := 'N';
173:

Line 185: oe_debug_pub.add( 'is revenue line: return/retrobill/internal/cancelled: returning N' , 1 ) ;

181: OR l_line_rec.source_document_type_id = 10
182: OR l_line_rec.cancelled_flag = 'Y' ) THEN
183:
184: IF l_debug_level > 0 THEN
185: oe_debug_pub.add( 'is revenue line: return/retrobill/internal/cancelled: returning N' , 1 ) ;
186: END IF;
187:
188: RETURN 'N';
189:

Line 201: oe_debug_pub.add( 'is revenue line: standard shippable: returning Y' , 1 ) ;

197: IF l_line_rec.top_model_line_id IS NULL
198: AND l_line_rec.item_type_code = 'STANDARD'
199: AND l_line_rec.shipped_quantity IS NOT NULL THEN
200: IF l_debug_level > 0 THEN
201: oe_debug_pub.add( 'is revenue line: standard shippable: returning Y' , 1 ) ;
202: END IF;
203:
204: RETURN 'Y';
205:

Line 235: oe_debug_pub.add( 'is revenue line: model component: l_child='||l_child||' shipped_quantity='||l_line_rec.shipped_quantity||' returning Y' , 1 ) ;

231: END;
232:
233: IF l_child = 'Y' OR l_line_rec.shipped_quantity IS NOT NULL THEN
234: IF l_debug_level > 0 THEN
235: oe_debug_pub.add( 'is revenue line: model component: l_child='||l_child||' shipped_quantity='||l_line_rec.shipped_quantity||' returning Y' , 1 ) ;
236: END IF;
237:
238: RETURN 'Y';
239:

Line 253: oe_debug_pub.add( 'Checking if the Line is inventory interfaced', 1);

249: -- when the Lines INVENTORY_INTERFACE WF activity is COMPLETE
250:
251: ELSE
252: IF l_debug_level > 0 THEN
253: oe_debug_pub.add( 'Checking if the Line is inventory interfaced', 1);
254: END IF;
255:
256: BEGIN
257: SELECT 'Y' INTO l_inventory_interfaced

Line 268: oe_debug_pub.add( 'No data returned from the Workflow status query. ', 1);

264: AND WAS.ACTIVITY_RESULT_CODE = 'COMPLETE';
265: EXCEPTION
266: WHEN NO_DATA_FOUND THEN
267: IF l_debug_level > 0 THEN
268: oe_debug_pub.add( 'No data returned from the Workflow status query. ', 1);
269: END IF;
270: l_inventory_interfaced := 'N';
271: END;
272:

Line 275: oe_debug_pub.add( 'Line is inventory interfaced.', 1);

271: END;
272:
273: IF l_inventory_interfaced = 'Y' THEN
274: IF l_debug_level > 0 THEN
275: oe_debug_pub.add( 'Line is inventory interfaced.', 1);
276: oe_debug_pub.add( 'is revenue line: Sales Order Issue: returning Y.', 1);
277: END IF;
278: RETURN 'Y';
279: END IF;

Line 276: oe_debug_pub.add( 'is revenue line: Sales Order Issue: returning Y.', 1);

272:
273: IF l_inventory_interfaced = 'Y' THEN
274: IF l_debug_level > 0 THEN
275: oe_debug_pub.add( 'Line is inventory interfaced.', 1);
276: oe_debug_pub.add( 'is revenue line: Sales Order Issue: returning Y.', 1);
277: END IF;
278: RETURN 'Y';
279: END IF;
280: END IF; -- SO Issue Exists

Line 285: oe_debug_pub.add( 'is revenue line: returning N', 1);

281: -- End of Changes for Bug #11717692
282:
283: END IF;
284: IF l_debug_level > 0 THEN
285: oe_debug_pub.add( 'is revenue line: returning N', 1);
286: END IF;
287: RETURN 'N';
288:
289: EXCEPTION WHEN OTHERS THEN