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 98: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_WF_ITEM_TYPE');

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

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

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

Line 114: , 'Get_WF_Item_Type'

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

Line 117: END Get_WF_Item_Type;

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

Line 200: l_wf_item_type VARCHAR2(30);

196: , p_header_rec IN OE_BULK_ORDER_PVT.HEADER_REC_TYPE
197: )
198: IS
199: l_process_name VARCHAR2(30);
200: l_wf_item_type VARCHAR2(30);
201: l_wf_assigned BOOLEAN;
202: l_order_number NUMBER;
203: l_aname wf_engine.nametabtyp;
204: l_aname2 wf_engine.nametabtyp;

Line 267: WF_ITEM.Set_Item_Parent(OE_Globals.G_WFI_LIN,

263: , l_aname2
264: , l_avaluetext
265: );
266:
267: WF_ITEM.Set_Item_Parent(OE_Globals.G_WFI_LIN,
268: to_char(p_line_rec.line_id(p_line_index)),
269: OE_GLOBALS.G_WFI_HDR,
270: to_char(p_line_rec.header_id(p_line_index)), '');
271:

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

303: WHERE order_type_id = p_type_id
304: AND line_type_id IS NULL
305: -- 11i10 - only fulfillment orders supported in HVOP so
306: -- select fulfillment flow
307: AND nvl(wf_item_type,'OEOH') = 'OEOH'
308: AND sysdate >= start_date_active
309: AND sysdate <= nvl(end_date_active, sysdate);
310: --
311: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 371: l_wf_item_type VARCHAR2(30);

367: RETURN BOOLEAN
368: IS
369: ctr NUMBER := 1;
370: l_cache_exists BOOLEAN := FALSE;
371: l_wf_item_type VARCHAR2(30);
372: CURSOR c_line_process IS
373: SELECT process_name
374: ,item_type_code
375: FROM OE_WORKFLOW_ASSIGNMENTS

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

374: ,item_type_code
375: FROM OE_WORKFLOW_ASSIGNMENTS
376: WHERE order_type_id = p_order_type_id
377: AND line_type_id = p_line_rec.line_type_id(p_line_index)
378: AND nvl(item_type_code,l_wf_item_type) = l_wf_item_type
379: AND sysdate >= start_date_active
380: AND sysdate <= nvl(end_date_active, sysdate);
381: --
382: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

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

386: IF l_debug_level > 0 THEN
387: oe_debug_pub.add( 'Entering Validate_LT_WF_Assignment',1 ) ;
388: END IF;
389:
390: -- Bug 2900592, get_wf_item_type returns error if item type is not
391: -- one of the bulk supported item types ('STANDARD','KIT' or 'INCLUDED')
392: -- So handle it as an invalid WF assignment
393: BEGIN
394:

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

398: oe_debug_pub.add( ' line id :'|| p_line_rec.line_id(p_line_index));
399: oe_debug_pub.add( ' Top Model Line Id ;'|| p_line_rec.top_model_line_id(p_line_index));
400:
401: -- Check if combination exists in Global and has valid assignment.
402: l_wf_item_type := Get_WF_Item_Type(p_line_index,p_line_rec);
403: if l_debug_level > 0 then
404: oe_debug_pub.add('work flow item type'||l_wf_item_type);
405: end if;
406: EXCEPTION

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

400:
401: -- Check if combination exists in Global and has valid assignment.
402: l_wf_item_type := Get_WF_Item_Type(p_line_index,p_line_rec);
403: if l_debug_level > 0 then
404: oe_debug_pub.add('work flow item type'||l_wf_item_type);
405: end if;
406: EXCEPTION
407: WHEN OTHERS THEN
408: oe_debug_pub.add('Into the exception');

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

412: WHILE (ctr <= G_LINE_TYPE_WF_ASSIGN_TBL.COUNT) LOOP
413:
414: IF (G_LINE_TYPE_WF_ASSIGN_TBL(ctr).order_type_id = p_order_TYPE_ID)
415: AND (G_LINE_TYPE_WF_ASSIGN_TBL(ctr).line_type_id = p_line_rec.line_type_id(p_line_index))
416: AND (nvl(G_LINE_TYPE_WF_ASSIGN_TBL(ctr).wf_item_type,l_wf_item_type)
417: = l_wf_item_type)
418: THEN
419:
420: x_process_name := G_LINE_TYPE_WF_ASSIGN_TBL(ctr).process_name;

Line 417: = l_wf_item_type)

413:
414: IF (G_LINE_TYPE_WF_ASSIGN_TBL(ctr).order_type_id = p_order_TYPE_ID)
415: AND (G_LINE_TYPE_WF_ASSIGN_TBL(ctr).line_type_id = p_line_rec.line_type_id(p_line_index))
416: AND (nvl(G_LINE_TYPE_WF_ASSIGN_TBL(ctr).wf_item_type,l_wf_item_type)
417: = l_wf_item_type)
418: THEN
419:
420: x_process_name := G_LINE_TYPE_WF_ASSIGN_TBL(ctr).process_name;
421: l_cache_exists := TRUE;

Line 442: FETCH c_line_process INTO x_process_name, l_wf_item_type;

438:
439: ELSE -- no entry in cache
440:
441: OPEN c_line_process;
442: FETCH c_line_process INTO x_process_name, l_wf_item_type;
443: IF c_line_process%NOTFOUND THEN
444: x_process_name := NULL;
445: END IF;
446: CLOSE c_line_process;

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

450: ctr := G_LINE_TYPE_WF_ASSIGN_TBL.COUNT + 1;
451: G_LINE_TYPE_WF_ASSIGN_TBL(ctr).order_type_id := p_order_type_id;
452: G_LINE_TYPE_WF_ASSIGN_TBL(ctr).line_type_id := p_line_rec.line_type_id(p_line_index);
453: G_LINE_TYPE_WF_ASSIGN_TBL(ctr).process_name := x_process_name;
454: G_LINE_TYPE_WF_ASSIGN_TBL(ctr).wf_item_type := l_wf_item_type;
455:
456: IF x_process_name IS NOT NULL THEN
457: RETURN TRUE;
458: ELSE

Line 501: l_wf_item_type VARCHAR2(30);

497: IS
498: l_msg_text VARCHAR2(2000);
499: l_msg_count NUMBER;
500: l_header_id NUMBER;
501: l_wf_item_type VARCHAR2(30);
502: i NUMBER;
503: j NUMBER := 1;
504: l_header_count NUMBER := p_header_rec.HEADER_ID.COUNT;
505: l_ii_index NUMBER;

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

525:
526: G_HEADER_INDEX := i;
527:
528: -- Bug 3482897
529: -- Set line index to null when header WF item is created.
530: -- WFs for free good lines are started in the pricing call prior
531: -- to this WF start. This is allowed by WF even though parent WF for
532: -- header does not exist.
533: -- If line index is not nulled out, line WFs for these promotional items