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
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
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;
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;
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);
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: */
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);
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:');
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:
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:
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