APPS.OE_SCH_FIRM_CONC dependencies on OE_DEBUG_PUB

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

9: RETURN BOOLEAN
10: IS
11: l_activity_status_code VARCHAR2(8);
12: --
13: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
14: --
15: BEGIN
16:
17: -- Check for workflow status to be Purchase Release Eligible

Line 33: oe_debug_pub.add( 'RETURNING FALSE 1 ' , 1 ) ;

29:
30: EXCEPTION
31: WHEN NO_DATA_FOUND THEN
32: IF l_debug_level > 0 THEN
33: oe_debug_pub.add( 'RETURNING FALSE 1 ' , 1 ) ;
34: END IF;
35: RETURN FALSE;
36: WHEN OTHERS THEN
37: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

88: And wias.item_key = l.line_id
89: order by l.org_id;
90:
91: --
92: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
93: --
94:
95: l_request_date_low DATE;
96: l_request_date_high DATE;

Line 124: oe_debug_pub.add('Starting Progress Firm: ' , 1 ) ;

120: -- If value is passed through any of the parameters, then get the header
121: -- and line
122: -- records and call wf_engine.
123:
124: oe_debug_pub.add('Starting Progress Firm: ' , 1 ) ;
125:
126: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL > '110509' THEN
127: IF p_order_number_low is null AND
128: p_order_number_high is null AND

Line 169: oe_debug_pub.add( 'COMPLETING ACTIVITY FOR : ' || K.ITEM_KEY ,1);

165: END IF;
166: -- MOAC End.
167:
168: IF l_debug_level > 0 THEN
169: oe_debug_pub.add( 'COMPLETING ACTIVITY FOR : ' || K.ITEM_KEY ,1);
170: END IF;
171: wf_engine.CompleteActivityInternalName
172: ('OEOL',
173: k.item_key,

Line 199: OE_DEBUG_PUB.Add('Inside the Firm Demand Concurrent Program',1);

195: ELSE -- If some value is passed then derive based on the header_cur.
196:
197:
198: IF l_debug_level > 0 THEN
199: OE_DEBUG_PUB.Add('Inside the Firm Demand Concurrent Program',1);
200: END IF;
201:
202: SELECT FND_DATE.Canonical_To_Date(p_request_date_low),
203: FND_DATE.Canonical_To_Date(p_request_date_high),

Line 305: oe_debug_pub.add (l_sql_stmt,1);

301: l_sql_stmt := l_sql_stmt|| ' Order By h.org_id ';
302: End IF;
303: -- Moac End
304:
305: oe_debug_pub.add (l_sql_stmt,1);
306: l_sqlCursor := DBMS_SQL.Open_Cursor;
307:
308: DBMS_SQL.PARSE(l_sqlCursor, l_sql_stmt, DBMS_SQL.NATIVE);
309:

Line 398: oe_debug_pub.add( 'COMPLETING ACTIVITY FOR : ' || v_line_id ,1);

394: END IF;
395: -- Moac End
396:
397: IF l_debug_level > 0 THEN
398: oe_debug_pub.add( 'COMPLETING ACTIVITY FOR : ' || v_line_id ,1);
399: END IF;
400:
401: wf_engine.CompleteActivityInternalName
402: ('OEOL',

Line 431: oe_debug_pub.add('Error executing Scheduling ' || SQLERRM,1);

427: EXCEPTION
428:
429: WHEN OTHERS THEN
430:
431: oe_debug_pub.add('Error executing Scheduling ' || SQLERRM,1);
432: fnd_file.put_line(FND_FILE.LOG,
433: 'Error executing Scheduling, ' || SQLERRM);
434: END Request;
435: