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

101: -- Moac : commented the below locking.
102: --FOR UPDATE NOWAIT;
103:
104: --
105: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
106: --
107: -- Moac
108: l_single_org BOOLEAN := FALSE;
109: l_old_org_id NUMBER := -99;

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

110:
111: BEGIN
112:
113: /*
114: l_file_val := OE_DEBUG_PUB.Set_Debug_Mode('FILE');
115: OE_DEBUG_PUB.Initialize;
116: OE_DEBUG_PUB.Debug_Off;
117: OE_DEBUG_PUB.Debug_On;
118: oe_Debug_pub.setdebuglevel(5);

Line 115: OE_DEBUG_PUB.Initialize;

111: BEGIN
112:
113: /*
114: l_file_val := OE_DEBUG_PUB.Set_Debug_Mode('FILE');
115: OE_DEBUG_PUB.Initialize;
116: OE_DEBUG_PUB.Debug_Off;
117: OE_DEBUG_PUB.Debug_On;
118: oe_Debug_pub.setdebuglevel(5);
119: */

Line 116: OE_DEBUG_PUB.Debug_Off;

112:
113: /*
114: l_file_val := OE_DEBUG_PUB.Set_Debug_Mode('FILE');
115: OE_DEBUG_PUB.Initialize;
116: OE_DEBUG_PUB.Debug_Off;
117: OE_DEBUG_PUB.Debug_On;
118: oe_Debug_pub.setdebuglevel(5);
119: */
120: fnd_file.put_line(FND_FILE.LOG, 'Debug File: ' || l_file_val);

Line 117: OE_DEBUG_PUB.Debug_On;

113: /*
114: l_file_val := OE_DEBUG_PUB.Set_Debug_Mode('FILE');
115: OE_DEBUG_PUB.Initialize;
116: OE_DEBUG_PUB.Debug_Off;
117: OE_DEBUG_PUB.Debug_On;
118: oe_Debug_pub.setdebuglevel(5);
119: */
120: fnd_file.put_line(FND_FILE.LOG, 'Debug File: ' || l_file_val);
121: fnd_file.put_line(FND_FILE.LOG, 'Parameters:');

Line 118: oe_Debug_pub.setdebuglevel(5);

114: l_file_val := OE_DEBUG_PUB.Set_Debug_Mode('FILE');
115: OE_DEBUG_PUB.Initialize;
116: OE_DEBUG_PUB.Debug_Off;
117: OE_DEBUG_PUB.Debug_On;
118: oe_Debug_pub.setdebuglevel(5);
119: */
120: fnd_file.put_line(FND_FILE.LOG, 'Debug File: ' || l_file_val);
121: fnd_file.put_line(FND_FILE.LOG, 'Parameters:');
122:

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

153: SAVEPOINT lock_lines;
154:
155: FOR j in line_cur LOOP
156: IF l_debug_level > 0 THEN
157: oe_debug_pub.add( 'INV IFACE CONC: LINE_ID - ' || TO_CHAR ( J.LINE_ID ) , 5 ) ;
158: END IF;
159: IF Line_Eligible(p_line_id => j.line_id) THEN
160: BEGIN
161:

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

159: IF Line_Eligible(p_line_id => j.line_id) THEN
160: BEGIN
161:
162: IF l_debug_level > 0 THEN
163: oe_debug_pub.add( 'COMPLETING ACTIVITY FOR : ' || J.LINE_ID , 5 ) ;
164: END IF;
165:
166: -- MOAC Start. Set policy context if the OU changes on lines.
167: IF NOT l_single_org and j.org_id <> l_old_org_id then