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 OE_DEBUG_PUB

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

11: p_Line_rec IN OE_WSH_BULK_GRP.LINE_REC_TYPE
12: ) RETURN VARCHAR2
13: IS
14: --
15: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
16: --
17: BEGIN
18:
19: IF l_debug_level > 0 THEN

Line 20: oe_debug_pub.add( 'ITEM_TYPE_CODE IS ' || P_LINE_REC.ITEM_TYPE_CODE(p_line_index) ) ;

16: --
17: BEGIN
18:
19: IF l_debug_level > 0 THEN
20: oe_debug_pub.add( 'ITEM_TYPE_CODE IS ' || P_LINE_REC.ITEM_TYPE_CODE(p_line_index) ) ;
21: oe_debug_pub.add( ' Order Quantity UOM :'|| p_line_rec.order_quantity_uom(p_line_index));
22: oe_debug_pub.add( ' ato line id :'|| p_line_rec.ato_line_id(p_line_index));
23: oe_debug_pub.add( ' line id :'|| p_line_rec.line_id(p_line_index));
24: oe_debug_pub.add( ' Top Model Line Id ;'|| p_line_rec.top_model_line_id(p_line_index));

Line 21: oe_debug_pub.add( ' Order Quantity UOM :'|| p_line_rec.order_quantity_uom(p_line_index));

17: BEGIN
18:
19: IF l_debug_level > 0 THEN
20: oe_debug_pub.add( 'ITEM_TYPE_CODE IS ' || P_LINE_REC.ITEM_TYPE_CODE(p_line_index) ) ;
21: oe_debug_pub.add( ' Order Quantity UOM :'|| p_line_rec.order_quantity_uom(p_line_index));
22: oe_debug_pub.add( ' ato line id :'|| p_line_rec.ato_line_id(p_line_index));
23: oe_debug_pub.add( ' line id :'|| p_line_rec.line_id(p_line_index));
24: oe_debug_pub.add( ' Top Model Line Id ;'|| p_line_rec.top_model_line_id(p_line_index));
25: END IF;

Line 22: oe_debug_pub.add( ' ato line id :'|| p_line_rec.ato_line_id(p_line_index));

18:
19: IF l_debug_level > 0 THEN
20: oe_debug_pub.add( 'ITEM_TYPE_CODE IS ' || P_LINE_REC.ITEM_TYPE_CODE(p_line_index) ) ;
21: oe_debug_pub.add( ' Order Quantity UOM :'|| p_line_rec.order_quantity_uom(p_line_index));
22: oe_debug_pub.add( ' ato line id :'|| p_line_rec.ato_line_id(p_line_index));
23: oe_debug_pub.add( ' line id :'|| p_line_rec.line_id(p_line_index));
24: oe_debug_pub.add( ' Top Model Line Id ;'|| p_line_rec.top_model_line_id(p_line_index));
25: END IF;
26:

Line 23: oe_debug_pub.add( ' line id :'|| p_line_rec.line_id(p_line_index));

19: IF l_debug_level > 0 THEN
20: oe_debug_pub.add( 'ITEM_TYPE_CODE IS ' || P_LINE_REC.ITEM_TYPE_CODE(p_line_index) ) ;
21: oe_debug_pub.add( ' Order Quantity UOM :'|| p_line_rec.order_quantity_uom(p_line_index));
22: oe_debug_pub.add( ' ato line id :'|| p_line_rec.ato_line_id(p_line_index));
23: oe_debug_pub.add( ' line id :'|| p_line_rec.line_id(p_line_index));
24: oe_debug_pub.add( ' Top Model Line Id ;'|| p_line_rec.top_model_line_id(p_line_index));
25: END IF;
26:
27: -- Code for Returns

Line 24: oe_debug_pub.add( ' Top Model Line Id ;'|| p_line_rec.top_model_line_id(p_line_index));

20: oe_debug_pub.add( 'ITEM_TYPE_CODE IS ' || P_LINE_REC.ITEM_TYPE_CODE(p_line_index) ) ;
21: oe_debug_pub.add( ' Order Quantity UOM :'|| p_line_rec.order_quantity_uom(p_line_index));
22: oe_debug_pub.add( ' ato line id :'|| p_line_rec.ato_line_id(p_line_index));
23: oe_debug_pub.add( ' line id :'|| p_line_rec.line_id(p_line_index));
24: oe_debug_pub.add( ' Top Model Line Id ;'|| p_line_rec.top_model_line_id(p_line_index));
25: END IF;
26:
27: -- Code for Returns
28: IF p_line_rec.line_category_code(p_line_index) = 'RETURN' THEN

Line 32: oe_debug_pub.add( ' 1:');

28: IF p_line_rec.line_category_code(p_line_index) = 'RETURN' THEN
29: RETURN 'STANDARD';
30: END IF;
31:
32: oe_debug_pub.add( ' 1:');
33:
34: IF ( p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_STANDARD OR
35: p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_OPTION OR
36: p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_INCLUDED) --9775352

Line 39: oe_debug_pub.add( ' 3:');

35: p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_OPTION OR
36: p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_INCLUDED) --9775352
37: AND p_line_rec.ato_line_id(p_line_index) = p_line_rec.line_id(p_line_index)
38: THEN
39: oe_debug_pub.add( ' 3:');
40: RETURN 'ATO_ITEM';
41: ELSIF (p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_MODEL AND
42: p_line_rec.line_id(p_line_index) =
43: p_line_rec.ato_line_id(p_line_index)) THEN

Line 44: oe_debug_pub.add( ' 4:');

40: RETURN 'ATO_ITEM';
41: ELSIF (p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_MODEL AND
42: p_line_rec.line_id(p_line_index) =
43: p_line_rec.ato_line_id(p_line_index)) THEN
44: oe_debug_pub.add( ' 4:');
45: RETURN 'ATO_MODEL';
46: ELSIF (p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_CONFIG) THEN
47: oe_debug_pub.add( ' 5:');
48: RETURN 'CONFIGURATION';

Line 47: oe_debug_pub.add( ' 5:');

43: p_line_rec.ato_line_id(p_line_index)) THEN
44: oe_debug_pub.add( ' 4:');
45: RETURN 'ATO_MODEL';
46: ELSIF (p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_CONFIG) THEN
47: oe_debug_pub.add( ' 5:');
48: RETURN 'CONFIGURATION';
49: ELSIF (p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_INCLUDED)
50: THEN
51: oe_debug_pub.add( ' 6:');

Line 51: oe_debug_pub.add( ' 6:');

47: oe_debug_pub.add( ' 5:');
48: RETURN 'CONFIGURATION';
49: ELSIF (p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_INCLUDED)
50: THEN
51: oe_debug_pub.add( ' 6:');
52: RETURN 'II';
53: ELSIF (p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_KIT) THEN
54: oe_debug_pub.add( ' 7:');
55: RETURN 'KIT';

Line 54: oe_debug_pub.add( ' 7:');

50: THEN
51: oe_debug_pub.add( ' 6:');
52: RETURN 'II';
53: ELSIF (p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_KIT) THEN
54: oe_debug_pub.add( ' 7:');
55: RETURN 'KIT';
56: ELSIF (p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_MODEL AND
57: p_line_rec.line_id(p_line_index) =
58: p_line_rec.top_model_line_id(p_line_index) AND

Line 60: oe_debug_pub.add( ' 8:');

56: ELSIF (p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_MODEL AND
57: p_line_rec.line_id(p_line_index) =
58: p_line_rec.top_model_line_id(p_line_index) AND
59: p_line_rec.ato_line_id(p_line_index) IS NULL) THEN
60: oe_debug_pub.add( ' 8:');
61: RETURN 'PTO_MODEL';
62: ELSIF (p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_CLASS AND
63: p_line_rec.ato_line_id(p_line_index) IS NULL) THEN
64: oe_debug_pub.add( ' 9:');

Line 64: oe_debug_pub.add( ' 9:');

60: oe_debug_pub.add( ' 8:');
61: RETURN 'PTO_MODEL';
62: ELSIF (p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_CLASS AND
63: p_line_rec.ato_line_id(p_line_index) IS NULL) THEN
64: oe_debug_pub.add( ' 9:');
65: RETURN 'PTO_CLASS';
66: ELSIF (p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_OPTION AND
67: p_line_rec.ato_line_id(p_line_index) IS NULL) THEN
68: oe_debug_pub.add( ' 10:');

Line 68: oe_debug_pub.add( ' 10:');

64: oe_debug_pub.add( ' 9:');
65: RETURN 'PTO_CLASS';
66: ELSIF (p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_OPTION AND
67: p_line_rec.ato_line_id(p_line_index) IS NULL) THEN
68: oe_debug_pub.add( ' 10:');
69: RETURN 'PTO_OPTION';
70: -- for ato under pto, we want to start ato model flow
71: -- even if the item_type_code is class. For ato under ato
72: -- start standard flow.

Line 73: oe_debug_pub.add( ' 11:');

69: RETURN 'PTO_OPTION';
70: -- for ato under pto, we want to start ato model flow
71: -- even if the item_type_code is class. For ato under ato
72: -- start standard flow.
73: oe_debug_pub.add( ' 11:');
74: ELSIF (p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_CLASS AND
75: p_line_rec.ato_line_id(p_line_index) IS NOT NULL) THEN
76:
77: IF p_line_rec.ato_line_id(p_line_index) = p_line_rec.line_id(p_line_index)

Line 79: oe_debug_pub.add( ' 11:');

75: p_line_rec.ato_line_id(p_line_index) IS NOT NULL) THEN
76:
77: IF p_line_rec.ato_line_id(p_line_index) = p_line_rec.line_id(p_line_index)
78: THEN
79: oe_debug_pub.add( ' 11:');
80: RETURN 'ATO_MODEL';
81: ELSE
82: oe_debug_pub.add( ' 12:');
83: RETURN 'ATO_CLASS'; -- changed from STANDARD for 4572204

Line 82: oe_debug_pub.add( ' 12:');

78: THEN
79: oe_debug_pub.add( ' 11:');
80: RETURN 'ATO_MODEL';
81: ELSE
82: oe_debug_pub.add( ' 12:');
83: RETURN 'ATO_CLASS'; -- changed from STANDARD for 4572204
84: END IF;
85: ELSIF (p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_OPTION AND
86: p_line_rec.ato_line_id(p_line_index) IS NOT NULL) THEN

Line 87: oe_debug_pub.add( ' 13:');

83: RETURN 'ATO_CLASS'; -- changed from STANDARD for 4572204
84: END IF;
85: ELSIF (p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_OPTION AND
86: p_line_rec.ato_line_id(p_line_index) IS NOT NULL) THEN
87: oe_debug_pub.add( ' 13:');
88: RETURN 'ATO_OPTION'; -- changed from STANDARD for 4572204
89: ELSIF (p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_STANDARD)
90: THEN
91: oe_debug_pub.add( ' 14:');

Line 91: oe_debug_pub.add( ' 14:');

87: oe_debug_pub.add( ' 13:');
88: RETURN 'ATO_OPTION'; -- changed from STANDARD for 4572204
89: ELSIF (p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_STANDARD)
90: THEN
91: oe_debug_pub.add( ' 14:');
92: RETURN 'STANDARD';
93: /* ELSIF OE_OTA_UTIL.Is_OTA_Line(p_line_rec.order_quantity_uom(p_line_index)) THEN
94: oe_debug_pub.add( ' 15:');
95: RETURN 'EDUCATION_ITEM';

Line 94: oe_debug_pub.add( ' 15:');

90: THEN
91: oe_debug_pub.add( ' 14:');
92: RETURN 'STANDARD';
93: /* ELSIF OE_OTA_UTIL.Is_OTA_Line(p_line_rec.order_quantity_uom(p_line_index)) THEN
94: oe_debug_pub.add( ' 15:');
95: RETURN 'EDUCATION_ITEM';
96: syed */
97: ELSE
98:

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 111: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;

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;
113: OE_BULK_MSG_PUB.Add_Exc_Msg
114: ( G_PKG_NAME
115: , 'Get_WF_Item_Type'

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

127: l_avalue wf_engine.numtabtyp;
128: l_avaluetext wf_engine.texttabtyp;
129: sales_order VARCHAR2(240);
130: --
131: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
132: --
133: BEGIN
134:
135: IF l_debug_level > 0 THEN

Line 136: oe_debug_pub.add( 'IN CREATE_HDRWORKITEM' ) ;

132: --
133: BEGIN
134:
135: IF l_debug_level > 0 THEN
136: oe_debug_pub.add( 'IN CREATE_HDRWORKITEM' ) ;
137: END IF;
138:
139: -- Set Header User Key
140: if p_header_rec.order_category_code(p_index) = 'RETURN' then

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

213: l_avalue wf_engine.numtabtyp;
214: l_avaluetext wf_engine.texttabtyp;
215: line VARCHAR2(240);
216: --
217: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
218: --
219: BEGIN
220:
221: -- Set Line User Key

Line 284: oe_debug_pub.add( 'CREATE_LINEWORKITEM OTHER ERROR' ) ;

280:
281: EXCEPTION
282: WHEN OTHERS THEN
283: IF l_debug_level > 0 THEN
284: oe_debug_pub.add( 'CREATE_LINEWORKITEM OTHER ERROR' ) ;
285: END IF;
286: IF l_debug_level > 0 THEN
287: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
288: END IF;

Line 287: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;

283: IF l_debug_level > 0 THEN
284: oe_debug_pub.add( 'CREATE_LINEWORKITEM OTHER ERROR' ) ;
285: END IF;
286: IF l_debug_level > 0 THEN
287: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
288: END IF;
289: OE_BULK_MSG_PUB.Add_Exc_Msg
290: ( G_PKG_NAME
291: , 'Create_LineWorkItem'

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

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;
320: --
321: BEGIN
322:
323: -- Check if Order Type exists in Global and has valid assignment.

Line 356: oe_debug_pub.add( 'OTHERS ERROR , VALIDATE_OT_WF_ASSIGNMENT' ) ;

352:
353: EXCEPTION
354: WHEN OTHERS THEN
355: IF l_debug_level > 0 THEN
356: oe_debug_pub.add( 'OTHERS ERROR , VALIDATE_OT_WF_ASSIGNMENT' ) ;
357: END IF;
358: IF l_debug_level > 0 THEN
359: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
360: END IF;

Line 359: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;

355: IF l_debug_level > 0 THEN
356: oe_debug_pub.add( 'OTHERS ERROR , VALIDATE_OT_WF_ASSIGNMENT' ) ;
357: END IF;
358: IF l_debug_level > 0 THEN
359: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
360: END IF;
361: OE_BULK_MSG_PUB.Add_Exc_Msg
362: ( G_PKG_NAME
363: , 'Validate_OT_WF_Assignment'

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

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;
391: --
392: BEGIN
393:
394: IF l_debug_level > 0 THEN

Line 395: oe_debug_pub.add( 'Entering Validate_LT_WF_Assignment',1 ) ;

391: --
392: BEGIN
393:
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')

Line 403: oe_debug_pub.add( 'ITEM_TYPE_CODE IS ' || P_LINE_REC.ITEM_TYPE_CODE(p_line_index) ) ;

399: -- one of the bulk supported item types ('STANDARD','KIT' or 'INCLUDED')
400: -- So handle it as an invalid WF assignment
401: BEGIN
402:
403: oe_debug_pub.add( 'ITEM_TYPE_CODE IS ' || P_LINE_REC.ITEM_TYPE_CODE(p_line_index) ) ;
404: oe_debug_pub.add( ' Order Quantity UOM :'|| p_line_rec.order_quantity_uom(p_line_index));
405: oe_debug_pub.add( ' ato line id :'|| p_line_rec.ato_line_id(p_line_index));
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));

Line 404: oe_debug_pub.add( ' Order Quantity UOM :'|| p_line_rec.order_quantity_uom(p_line_index));

400: -- So handle it as an invalid WF assignment
401: BEGIN
402:
403: oe_debug_pub.add( 'ITEM_TYPE_CODE IS ' || P_LINE_REC.ITEM_TYPE_CODE(p_line_index) ) ;
404: oe_debug_pub.add( ' Order Quantity UOM :'|| p_line_rec.order_quantity_uom(p_line_index));
405: oe_debug_pub.add( ' ato line id :'|| p_line_rec.ato_line_id(p_line_index));
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:

Line 405: oe_debug_pub.add( ' ato line id :'|| p_line_rec.ato_line_id(p_line_index));

401: BEGIN
402:
403: oe_debug_pub.add( 'ITEM_TYPE_CODE IS ' || P_LINE_REC.ITEM_TYPE_CODE(p_line_index) ) ;
404: oe_debug_pub.add( ' Order Quantity UOM :'|| p_line_rec.order_quantity_uom(p_line_index));
405: oe_debug_pub.add( ' ato line id :'|| p_line_rec.ato_line_id(p_line_index));
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.

Line 406: oe_debug_pub.add( ' line id :'|| p_line_rec.line_id(p_line_index));

402:
403: oe_debug_pub.add( 'ITEM_TYPE_CODE IS ' || P_LINE_REC.ITEM_TYPE_CODE(p_line_index) ) ;
404: oe_debug_pub.add( ' Order Quantity UOM :'|| p_line_rec.order_quantity_uom(p_line_index));
405: oe_debug_pub.add( ' ato line id :'|| p_line_rec.ato_line_id(p_line_index));
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);

Line 407: oe_debug_pub.add( ' Top Model Line Id ;'|| p_line_rec.top_model_line_id(p_line_index));

403: oe_debug_pub.add( 'ITEM_TYPE_CODE IS ' || P_LINE_REC.ITEM_TYPE_CODE(p_line_index) ) ;
404: oe_debug_pub.add( ' Order Quantity UOM :'|| p_line_rec.order_quantity_uom(p_line_index));
405: oe_debug_pub.add( ' ato line id :'|| p_line_rec.ato_line_id(p_line_index));
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

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 416: oe_debug_pub.add('Into the exception');

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');
417: RETURN FALSE;
418: END;
419:
420: WHILE (ctr <= G_LINE_TYPE_WF_ASSIGN_TBL.COUNT) LOOP

Line 440: oe_debug_pub.add('returning true');

436:
437: IF (l_cache_exists) THEN
438:
439: IF x_process_name IS NOT NULL THEN
440: oe_debug_pub.add('returning true');
441: RETURN TRUE;
442: ELSE -- no assignment for this combination.
443: oe_debug_pub.add('returning false');
444: RETURN FALSE;

Line 443: oe_debug_pub.add('returning false');

439: IF x_process_name IS NOT NULL THEN
440: oe_debug_pub.add('returning true');
441: RETURN TRUE;
442: ELSE -- no assignment for this combination.
443: oe_debug_pub.add('returning false');
444: RETURN FALSE;
445: END IF;
446:
447: ELSE -- no entry in cache

Line 457: oe_debug_pub.add('updating the cache');

453: END IF;
454: CLOSE c_line_process;
455:
456: -- Update cache
457: oe_debug_pub.add('updating the cache');
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;

Line 473: oe_debug_pub.add( 'Exiting Validate_LT_WF_Assignment',1 ) ;

469:
470: END IF; -- Combination is in cache
471:
472: IF l_debug_level > 0 THEN
473: oe_debug_pub.add( 'Exiting Validate_LT_WF_Assignment',1 ) ;
474: END IF;
475:
476:
477: EXCEPTION

Line 480: oe_debug_pub.add( 'OTHERS ERROR , VALIDATE_LT_WF_ASSIGNMENT' ) ;

476:
477: EXCEPTION
478: WHEN OTHERS THEN
479: IF l_debug_level > 0 THEN
480: oe_debug_pub.add( 'OTHERS ERROR , VALIDATE_LT_WF_ASSIGNMENT' ) ;
481: END IF;
482: IF l_debug_level > 0 THEN
483: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
484: END IF;

Line 483: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;

479: IF l_debug_level > 0 THEN
480: oe_debug_pub.add( 'OTHERS ERROR , VALIDATE_LT_WF_ASSIGNMENT' ) ;
481: END IF;
482: IF l_debug_level > 0 THEN
483: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
484: END IF;
485: OE_BULK_MSG_PUB.Add_Exc_Msg
486: ( G_PKG_NAME
487: , 'Validate_LT_WF_Assignment'

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

541: WF_Api_l_user_keys wf_engine_bulk.userkeytabtype;
542: WF_Api_l_owner_roles wf_engine_bulk.ownerroletabtype;
543: /* End of WF Bulk API ER #8601238 */
544: --
545: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
546: --
547: BEGIN
548:
549: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 568: oe_debug_pub.add( 'START WF , HEADER ID:'||L_HEADER_ID ) ;

564:
565: IF nvl(p_header_rec.lock_control(i),0) NOT IN ( -99, -98, -97) THEN
566:
567: IF l_debug_level > 0 THEN
568: oe_debug_pub.add( 'START WF , HEADER ID:'||L_HEADER_ID ) ;
569: END IF;
570:
571: G_HEADER_INDEX := i;
572:

Line 837: oe_debug_pub.add('Line Index : '||j);

833: AND NOT (p_line_rec.item_type_code(j) = 'INCLUDED')
834: LOOP
835:
836: IF l_debug_level > 0 THEN
837: oe_debug_pub.add('Line Index : '||j);
838: oe_debug_pub.add('Line Header ID : '||p_line_rec.header_id(j));
839: END IF;
840:
841: -- Start flows only if line header_id matches current

Line 838: oe_debug_pub.add('Line Header ID : '||p_line_rec.header_id(j));

834: LOOP
835:
836: IF l_debug_level > 0 THEN
837: oe_debug_pub.add('Line Index : '||j);
838: oe_debug_pub.add('Line Header ID : '||p_line_rec.header_id(j));
839: END IF;
840:
841: -- Start flows only if line header_id matches current
842: -- header_id

Line 922: oe_debug_pub.add( 'UNEXP ERROR , START_FLOWS' ) ;

918: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
919: G_HEADER_INDEX := NULL;
920: G_LINE_INDEX := NULL;
921: IF l_debug_level > 0 THEN
922: oe_debug_pub.add( 'UNEXP ERROR , START_FLOWS' ) ;
923: END IF;
924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
925: WHEN OTHERS THEN
926: G_HEADER_INDEX := NULL;

Line 929: oe_debug_pub.add( 'OTHERS ERROR , START_FLOWS' ) ;

925: WHEN OTHERS THEN
926: G_HEADER_INDEX := NULL;
927: G_LINE_INDEX := NULL;
928: IF l_debug_level > 0 THEN
929: oe_debug_pub.add( 'OTHERS ERROR , START_FLOWS' ) ;
930: END IF;
931: IF l_debug_level > 0 THEN
932: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
933: END IF;

Line 932: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;

928: IF l_debug_level > 0 THEN
929: oe_debug_pub.add( 'OTHERS ERROR , START_FLOWS' ) ;
930: END IF;
931: IF l_debug_level > 0 THEN
932: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
933: END IF;
934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
935: OE_BULK_MSG_PUB.Add_Exc_Msg
936: ( G_PKG_NAME