DBA Data[Home] [Help]

APPS.OE_INV_IFACE_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 Inventory Interface Eligible

Line 32: oe_debug_pub.add( 'INV IFACE CONC: LINE DOES NOT HAVE NOTIFIED INV IFACE ELIGIBLE' , 5 ) ;

28:
29: EXCEPTION
30: WHEN NO_DATA_FOUND THEN
31: IF l_debug_level > 0 THEN
32: oe_debug_pub.add( 'INV IFACE CONC: LINE DOES NOT HAVE NOTIFIED INV IFACE ELIGIBLE' , 5 ) ;
33: END IF;
34: RETURN FALSE;
35: WHEN OTHERS THEN
36: IF l_debug_level > 0 THEN

Line 37: oe_debug_pub.add( 'INV IFACE CONC: OTHER EXCEPTION' , 5 ) ;

33: END IF;
34: RETURN FALSE;
35: WHEN OTHERS THEN
36: IF l_debug_level > 0 THEN
37: oe_debug_pub.add( 'INV IFACE CONC: OTHER EXCEPTION' , 5 ) ;
38: END IF;
39: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
40: RETURN FALSE;
41: END Line_Eligible;

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

117: And wias.activity_status = 'NOTIFIED';
118:
119:
120: --
121: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
122: --
123: -- Moac
124: l_single_org BOOLEAN := FALSE;
125: l_old_org_id NUMBER := -99;

Line 130: l_file_val := OE_DEBUG_PUB.Set_Debug_Mode('FILE');

126:
127: BEGIN
128:
129: /*
130: l_file_val := OE_DEBUG_PUB.Set_Debug_Mode('FILE');
131: OE_DEBUG_PUB.Initialize;
132: OE_DEBUG_PUB.Debug_Off;
133: OE_DEBUG_PUB.Debug_On;
134: oe_Debug_pub.setdebuglevel(5);

Line 131: OE_DEBUG_PUB.Initialize;

127: BEGIN
128:
129: /*
130: l_file_val := OE_DEBUG_PUB.Set_Debug_Mode('FILE');
131: OE_DEBUG_PUB.Initialize;
132: OE_DEBUG_PUB.Debug_Off;
133: OE_DEBUG_PUB.Debug_On;
134: oe_Debug_pub.setdebuglevel(5);
135: */

Line 132: OE_DEBUG_PUB.Debug_Off;

128:
129: /*
130: l_file_val := OE_DEBUG_PUB.Set_Debug_Mode('FILE');
131: OE_DEBUG_PUB.Initialize;
132: OE_DEBUG_PUB.Debug_Off;
133: OE_DEBUG_PUB.Debug_On;
134: oe_Debug_pub.setdebuglevel(5);
135: */
136: fnd_file.put_line(FND_FILE.LOG, 'Debug File: ' || l_file_val);

Line 133: OE_DEBUG_PUB.Debug_On;

129: /*
130: l_file_val := OE_DEBUG_PUB.Set_Debug_Mode('FILE');
131: OE_DEBUG_PUB.Initialize;
132: OE_DEBUG_PUB.Debug_Off;
133: OE_DEBUG_PUB.Debug_On;
134: oe_Debug_pub.setdebuglevel(5);
135: */
136: fnd_file.put_line(FND_FILE.LOG, 'Debug File: ' || l_file_val);
137: fnd_file.put_line(FND_FILE.LOG, 'Parameters:');

Line 134: oe_Debug_pub.setdebuglevel(5);

130: l_file_val := OE_DEBUG_PUB.Set_Debug_Mode('FILE');
131: OE_DEBUG_PUB.Initialize;
132: OE_DEBUG_PUB.Debug_Off;
133: OE_DEBUG_PUB.Debug_On;
134: oe_Debug_pub.setdebuglevel(5);
135: */
136: fnd_file.put_line(FND_FILE.LOG, 'Debug File: ' || l_file_val);
137: fnd_file.put_line(FND_FILE.LOG, 'Parameters:');
138:

Line 187: oe_debug_pub.add( 'INV IFACE CONC: - ' ) ;

183: p_customer IS NULL AND
184: p_item IS NULL THEN
185:
186: IF l_debug_level > 0 THEN
187: oe_debug_pub.add( 'INV IFACE CONC: - ' ) ;
188: END IF;
189: FOR i IN wf_item_inv LOOP
190:
191: oe_debug_pub.add('##### Processing item key ' || i.item_key ||'##' , 5);

Line 191: oe_debug_pub.add('##### Processing item key ' || i.item_key ||'##' , 5);

187: oe_debug_pub.add( 'INV IFACE CONC: - ' ) ;
188: END IF;
189: FOR i IN wf_item_inv LOOP
190:
191: oe_debug_pub.add('##### Processing item key ' || i.item_key ||'##' , 5);
192:
193: l_lin_id := TO_NUMBER(i.item_key) ;
194: IF l_debug_level > 0 THEN
195: oe_debug_pub.add( '##INV IFACE CONC: LINE_ID - ' || l_lin_id , 5 ) ;

Line 195: oe_debug_pub.add( '##INV IFACE CONC: LINE_ID - ' || l_lin_id , 5 ) ;

191: oe_debug_pub.add('##### Processing item key ' || i.item_key ||'##' , 5);
192:
193: l_lin_id := TO_NUMBER(i.item_key) ;
194: IF l_debug_level > 0 THEN
195: oe_debug_pub.add( '##INV IFACE CONC: LINE_ID - ' || l_lin_id , 5 ) ;
196: END IF;
197:
198: IF Line_Eligible(p_line_id => l_lin_id) THEN
199: BEGIN

Line 202: oe_debug_pub.add( '##COMPLETING ACTIVITY FOR : ' || i.item_key , 5 ) ;

198: IF Line_Eligible(p_line_id => l_lin_id) THEN
199: BEGIN
200:
201: IF l_debug_level > 0 THEN
202: oe_debug_pub.add( '##COMPLETING ACTIVITY FOR : ' || i.item_key , 5 ) ;
203: END IF;
204: wf_engine.CompleteActivityInternalName
205: ('OEOL',
206: i.item_key,

Line 226: oe_debug_pub.add( 'INV IFACE CONC: LINE_ID - ' || TO_CHAR ( J.LINE_ID ) , 5 ) ;

222: SAVEPOINT lock_lines;
223:
224: FOR j in line_cur LOOP
225: IF l_debug_level > 0 THEN
226: oe_debug_pub.add( 'INV IFACE CONC: LINE_ID - ' || TO_CHAR ( J.LINE_ID ) , 5 ) ;
227: END IF;
228: IF Line_Eligible(p_line_id => j.line_id) THEN
229: BEGIN
230:

Line 232: oe_debug_pub.add( 'COMPLETING ACTIVITY FOR : ' || J.LINE_ID , 5 ) ;

228: IF Line_Eligible(p_line_id => j.line_id) THEN
229: BEGIN
230:
231: IF l_debug_level > 0 THEN
232: oe_debug_pub.add( 'COMPLETING ACTIVITY FOR : ' || J.LINE_ID , 5 ) ;
233: END IF;
234:
235: -- MOAC Start. Set policy context if the OU changes on lines.
236: IF NOT l_single_org and j.org_id <> l_old_org_id then