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_BULK_WF_UTIL dependencies on WF_ITEM

Line 9: FUNCTION Get_Wf_Item_type

5:
6: -------------------------------------------------------------------
7: -- LOCAL PROCEDURES/FUNCTIONS
8: -------------------------------------------------------------------
9: FUNCTION Get_Wf_Item_type
10: ( p_line_index In NUMBER,
11: p_Line_rec IN OE_WSH_BULK_GRP.LINE_REC_TYPE
12: ) RETURN VARCHAR2
13: IS

Line 99: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_WF_ITEM_TYPE');

95: RETURN 'EDUCATION_ITEM';
96: syed */
97: ELSE
98:
99: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_WF_ITEM_TYPE');
100: OE_BULK_MSG_PUB.ADD;
101: RAISE FND_API.G_EXC_ERROR;
102: END IF;
103:

Line 108: oe_debug_pub.add( 'OTHERS ERROR , GET_WF_ITEM_TYPE' ) ;

104:
105: EXCEPTION
106: WHEN OTHERS THEN
107: IF l_debug_level > 0 THEN
108: oe_debug_pub.add( 'OTHERS ERROR , GET_WF_ITEM_TYPE' ) ;
109: END IF;
110: IF l_debug_level > 0 THEN
111: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
112: END IF;

Line 115: , 'Get_WF_Item_Type'

111: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
112: END IF;
113: OE_BULK_MSG_PUB.Add_Exc_Msg
114: ( G_PKG_NAME
115: , 'Get_WF_Item_Type'
116: );
117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
118: END Get_WF_Item_Type;
119:

Line 118: END Get_WF_Item_Type;

114: ( G_PKG_NAME
115: , 'Get_WF_Item_Type'
116: );
117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
118: END Get_WF_Item_Type;
119:
120: PROCEDURE Create_HdrWorkItem
121: ( p_index IN NUMBER
122: , p_header_rec IN OE_BULK_ORDER_PVT.HEADER_REC_TYPE

Line 208: l_wf_item_type VARCHAR2(30);

204: , p_header_rec IN OE_BULK_ORDER_PVT.HEADER_REC_TYPE
205: )
206: IS
207: l_process_name VARCHAR2(30);
208: l_wf_item_type VARCHAR2(30);
209: l_wf_assigned BOOLEAN;
210: l_order_number NUMBER;
211: l_aname wf_engine.nametabtyp;
212: l_aname2 wf_engine.nametabtyp;

Line 275: WF_ITEM.Set_Item_Parent(OE_Globals.G_WFI_LIN,

271: , l_aname2
272: , l_avaluetext
273: );
274:
275: WF_ITEM.Set_Item_Parent(OE_Globals.G_WFI_LIN,
276: to_char(p_line_rec.line_id(p_line_index)),
277: OE_GLOBALS.G_WFI_HDR,
278: to_char(p_line_rec.header_id(p_line_index)), '');
279:

Line 315: AND nvl(wf_item_type,'OEOH') = 'OEOH'

311: WHERE order_type_id = p_type_id
312: AND line_type_id IS NULL
313: -- 11i10 - only fulfillment orders supported in HVOP so
314: -- select fulfillment flow
315: AND nvl(wf_item_type,'OEOH') = 'OEOH'
316: AND sysdate >= start_date_active
317: AND sysdate <= nvl(end_date_active, sysdate);
318: --
319: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 379: l_wf_item_type VARCHAR2(30);

375: RETURN BOOLEAN
376: IS
377: ctr NUMBER := 1;
378: l_cache_exists BOOLEAN := FALSE;
379: l_wf_item_type VARCHAR2(30);
380: CURSOR c_line_process IS
381: SELECT process_name
382: ,item_type_code
383: FROM OE_WORKFLOW_ASSIGNMENTS

Line 386: AND nvl(item_type_code,l_wf_item_type) = l_wf_item_type

382: ,item_type_code
383: FROM OE_WORKFLOW_ASSIGNMENTS
384: WHERE order_type_id = p_order_type_id
385: AND line_type_id = p_line_rec.line_type_id(p_line_index)
386: AND nvl(item_type_code,l_wf_item_type) = l_wf_item_type
387: AND sysdate >= start_date_active
388: AND sysdate <= nvl(end_date_active, sysdate);
389: --
390: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 398: -- Bug 2900592, get_wf_item_type returns error if item type is not

394: IF l_debug_level > 0 THEN
395: oe_debug_pub.add( 'Entering Validate_LT_WF_Assignment',1 ) ;
396: END IF;
397:
398: -- Bug 2900592, get_wf_item_type returns error if item type is not
399: -- one of the bulk supported item types ('STANDARD','KIT' or 'INCLUDED')
400: -- So handle it as an invalid WF assignment
401: BEGIN
402:

Line 410: l_wf_item_type := Get_WF_Item_Type(p_line_index,p_line_rec);

406: oe_debug_pub.add( ' line id :'|| p_line_rec.line_id(p_line_index));
407: oe_debug_pub.add( ' Top Model Line Id ;'|| p_line_rec.top_model_line_id(p_line_index));
408:
409: -- Check if combination exists in Global and has valid assignment.
410: l_wf_item_type := Get_WF_Item_Type(p_line_index,p_line_rec);
411: if l_debug_level > 0 then
412: oe_debug_pub.add('work flow item type'||l_wf_item_type);
413: end if;
414: EXCEPTION

Line 412: oe_debug_pub.add('work flow item type'||l_wf_item_type);

408:
409: -- Check if combination exists in Global and has valid assignment.
410: l_wf_item_type := Get_WF_Item_Type(p_line_index,p_line_rec);
411: if l_debug_level > 0 then
412: oe_debug_pub.add('work flow item type'||l_wf_item_type);
413: end if;
414: EXCEPTION
415: WHEN OTHERS THEN
416: oe_debug_pub.add('Into the exception');

Line 424: AND (nvl(G_LINE_TYPE_WF_ASSIGN_TBL(ctr).wf_item_type,l_wf_item_type)

420: WHILE (ctr <= G_LINE_TYPE_WF_ASSIGN_TBL.COUNT) LOOP
421:
422: IF (G_LINE_TYPE_WF_ASSIGN_TBL(ctr).order_type_id = p_order_TYPE_ID)
423: AND (G_LINE_TYPE_WF_ASSIGN_TBL(ctr).line_type_id = p_line_rec.line_type_id(p_line_index))
424: AND (nvl(G_LINE_TYPE_WF_ASSIGN_TBL(ctr).wf_item_type,l_wf_item_type)
425: = l_wf_item_type)
426: THEN
427:
428: x_process_name := G_LINE_TYPE_WF_ASSIGN_TBL(ctr).process_name;

Line 425: = l_wf_item_type)

421:
422: IF (G_LINE_TYPE_WF_ASSIGN_TBL(ctr).order_type_id = p_order_TYPE_ID)
423: AND (G_LINE_TYPE_WF_ASSIGN_TBL(ctr).line_type_id = p_line_rec.line_type_id(p_line_index))
424: AND (nvl(G_LINE_TYPE_WF_ASSIGN_TBL(ctr).wf_item_type,l_wf_item_type)
425: = l_wf_item_type)
426: THEN
427:
428: x_process_name := G_LINE_TYPE_WF_ASSIGN_TBL(ctr).process_name;
429: l_cache_exists := TRUE;

Line 450: FETCH c_line_process INTO x_process_name, l_wf_item_type;

446:
447: ELSE -- no entry in cache
448:
449: OPEN c_line_process;
450: FETCH c_line_process INTO x_process_name, l_wf_item_type;
451: IF c_line_process%NOTFOUND THEN
452: x_process_name := NULL;
453: END IF;
454: CLOSE c_line_process;

Line 462: G_LINE_TYPE_WF_ASSIGN_TBL(ctr).wf_item_type := l_wf_item_type;

458: ctr := G_LINE_TYPE_WF_ASSIGN_TBL.COUNT + 1;
459: G_LINE_TYPE_WF_ASSIGN_TBL(ctr).order_type_id := p_order_type_id;
460: G_LINE_TYPE_WF_ASSIGN_TBL(ctr).line_type_id := p_line_rec.line_type_id(p_line_index);
461: G_LINE_TYPE_WF_ASSIGN_TBL(ctr).process_name := x_process_name;
462: G_LINE_TYPE_WF_ASSIGN_TBL(ctr).wf_item_type := l_wf_item_type;
463:
464: IF x_process_name IS NOT NULL THEN
465: RETURN TRUE;
466: ELSE

Line 509: l_wf_item_type VARCHAR2(30);

505: IS
506: l_msg_text VARCHAR2(2000);
507: l_msg_count NUMBER;
508: l_header_id NUMBER;
509: l_wf_item_type VARCHAR2(30);
510: i NUMBER;
511: j NUMBER := 1;
512: l_header_count NUMBER := p_header_rec.HEADER_ID.COUNT;
513: l_ii_index NUMBER;

Line 574: -- Set line index to null when header WF item is created.

570:
571: G_HEADER_INDEX := i;
572:
573: -- Bug 3482897
574: -- Set line index to null when header WF item is created.
575: -- WFs for free good lines are started in the pricing call prior
576: -- to this WF start. This is allowed by WF even though parent WF for
577: -- header does not exist.
578: -- If line index is not nulled out, line WFs for these promotional items