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)
36: AND p_line_rec.ato_line_id(p_line_index) = p_line_rec.line_id(p_line_index)

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

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)
36: AND p_line_rec.ato_line_id(p_line_index) = p_line_rec.line_id(p_line_index)
37: THEN
38: oe_debug_pub.add( ' 3:');
39: RETURN 'ATO_ITEM';
40: ELSIF (p_line_rec.item_type_code(p_line_index) = OE_GLOBALS.G_ITEM_MODEL AND
41: p_line_rec.line_id(p_line_index) =
42: p_line_rec.ato_line_id(p_line_index)) THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

205: l_avalue wf_engine.numtabtyp;
206: l_avaluetext wf_engine.texttabtyp;
207: line VARCHAR2(240);
208: --
209: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
210: --
211: BEGIN
212:
213: -- Set Line User Key

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

272:
273: EXCEPTION
274: WHEN OTHERS THEN
275: IF l_debug_level > 0 THEN
276: oe_debug_pub.add( 'CREATE_LINEWORKITEM OTHER ERROR' ) ;
277: END IF;
278: IF l_debug_level > 0 THEN
279: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
280: END IF;

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

275: IF l_debug_level > 0 THEN
276: oe_debug_pub.add( 'CREATE_LINEWORKITEM OTHER ERROR' ) ;
277: END IF;
278: IF l_debug_level > 0 THEN
279: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
280: END IF;
281: OE_BULK_MSG_PUB.Add_Exc_Msg
282: ( G_PKG_NAME
283: , 'Create_LineWorkItem'

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

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;
312: --
313: BEGIN
314:
315: -- Check if Order Type exists in Global and has valid assignment.

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

344:
345: EXCEPTION
346: WHEN OTHERS THEN
347: IF l_debug_level > 0 THEN
348: oe_debug_pub.add( 'OTHERS ERROR , VALIDATE_OT_WF_ASSIGNMENT' ) ;
349: END IF;
350: IF l_debug_level > 0 THEN
351: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
352: END IF;

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

347: IF l_debug_level > 0 THEN
348: oe_debug_pub.add( 'OTHERS ERROR , VALIDATE_OT_WF_ASSIGNMENT' ) ;
349: END IF;
350: IF l_debug_level > 0 THEN
351: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
352: END IF;
353: OE_BULK_MSG_PUB.Add_Exc_Msg
354: ( G_PKG_NAME
355: , 'Validate_OT_WF_Assignment'

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

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;
383: --
384: BEGIN
385:
386: IF l_debug_level > 0 THEN

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

383: --
384: BEGIN
385:
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')

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

391: -- one of the bulk supported item types ('STANDARD','KIT' or 'INCLUDED')
392: -- So handle it as an invalid WF assignment
393: BEGIN
394:
395: oe_debug_pub.add( 'ITEM_TYPE_CODE IS ' || P_LINE_REC.ITEM_TYPE_CODE(p_line_index) ) ;
396: oe_debug_pub.add( ' Order Quantity UOM :'|| p_line_rec.order_quantity_uom(p_line_index));
397: oe_debug_pub.add( ' ato line id :'|| p_line_rec.ato_line_id(p_line_index));
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));

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

392: -- So handle it as an invalid WF assignment
393: BEGIN
394:
395: oe_debug_pub.add( 'ITEM_TYPE_CODE IS ' || P_LINE_REC.ITEM_TYPE_CODE(p_line_index) ) ;
396: oe_debug_pub.add( ' Order Quantity UOM :'|| p_line_rec.order_quantity_uom(p_line_index));
397: oe_debug_pub.add( ' ato line id :'|| p_line_rec.ato_line_id(p_line_index));
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:

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

393: BEGIN
394:
395: oe_debug_pub.add( 'ITEM_TYPE_CODE IS ' || P_LINE_REC.ITEM_TYPE_CODE(p_line_index) ) ;
396: oe_debug_pub.add( ' Order Quantity UOM :'|| p_line_rec.order_quantity_uom(p_line_index));
397: oe_debug_pub.add( ' ato line id :'|| p_line_rec.ato_line_id(p_line_index));
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.

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

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

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

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

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

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');
409: RETURN FALSE;
410: END;
411:
412: WHILE (ctr <= G_LINE_TYPE_WF_ASSIGN_TBL.COUNT) LOOP

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

428:
429: IF (l_cache_exists) THEN
430:
431: IF x_process_name IS NOT NULL THEN
432: oe_debug_pub.add('returning true');
433: RETURN TRUE;
434: ELSE -- no assignment for this combination.
435: oe_debug_pub.add('returning false');
436: RETURN FALSE;

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

431: IF x_process_name IS NOT NULL THEN
432: oe_debug_pub.add('returning true');
433: RETURN TRUE;
434: ELSE -- no assignment for this combination.
435: oe_debug_pub.add('returning false');
436: RETURN FALSE;
437: END IF;
438:
439: ELSE -- no entry in cache

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

445: END IF;
446: CLOSE c_line_process;
447:
448: -- Update cache
449: oe_debug_pub.add('updating the cache');
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;

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

461:
462: END IF; -- Combination is in cache
463:
464: IF l_debug_level > 0 THEN
465: oe_debug_pub.add( 'Exiting Validate_LT_WF_Assignment',1 ) ;
466: END IF;
467:
468:
469: EXCEPTION

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

468:
469: EXCEPTION
470: WHEN OTHERS THEN
471: IF l_debug_level > 0 THEN
472: oe_debug_pub.add( 'OTHERS ERROR , VALIDATE_LT_WF_ASSIGNMENT' ) ;
473: END IF;
474: IF l_debug_level > 0 THEN
475: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
476: END IF;

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

471: IF l_debug_level > 0 THEN
472: oe_debug_pub.add( 'OTHERS ERROR , VALIDATE_LT_WF_ASSIGNMENT' ) ;
473: END IF;
474: IF l_debug_level > 0 THEN
475: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
476: END IF;
477: OE_BULK_MSG_PUB.Add_Exc_Msg
478: ( G_PKG_NAME
479: , 'Validate_LT_WF_Assignment'

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

503: j NUMBER := 1;
504: l_header_count NUMBER := p_header_rec.HEADER_ID.COUNT;
505: l_ii_index NUMBER;
506: --
507: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
508: --
509: BEGIN
510:
511: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

519:
520: IF nvl(p_header_rec.lock_control(i),0) NOT IN ( -99, -98, -97) THEN
521:
522: IF l_debug_level > 0 THEN
523: oe_debug_pub.add( 'START WF , HEADER ID:'||L_HEADER_ID ) ;
524: END IF;
525:
526: G_HEADER_INDEX := i;
527:

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

616: AND NOT (p_line_rec.item_type_code(j) = 'INCLUDED')
617: LOOP
618:
619: IF l_debug_level > 0 THEN
620: oe_debug_pub.add('Line Index : '||j);
621: oe_debug_pub.add('Line Header ID : '||p_line_rec.header_id(j));
622: END IF;
623:
624: -- Start flows only if line header_id matches current

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

617: LOOP
618:
619: IF l_debug_level > 0 THEN
620: oe_debug_pub.add('Line Index : '||j);
621: oe_debug_pub.add('Line Header ID : '||p_line_rec.header_id(j));
622: END IF;
623:
624: -- Start flows only if line header_id matches current
625: -- header_id

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

700: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
701: G_HEADER_INDEX := NULL;
702: G_LINE_INDEX := NULL;
703: IF l_debug_level > 0 THEN
704: oe_debug_pub.add( 'UNEXP ERROR , START_FLOWS' ) ;
705: END IF;
706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
707: WHEN OTHERS THEN
708: G_HEADER_INDEX := NULL;

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

707: WHEN OTHERS THEN
708: G_HEADER_INDEX := NULL;
709: G_LINE_INDEX := NULL;
710: IF l_debug_level > 0 THEN
711: oe_debug_pub.add( 'OTHERS ERROR , START_FLOWS' ) ;
712: END IF;
713: IF l_debug_level > 0 THEN
714: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
715: END IF;

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

710: IF l_debug_level > 0 THEN
711: oe_debug_pub.add( 'OTHERS ERROR , START_FLOWS' ) ;
712: END IF;
713: IF l_debug_level > 0 THEN
714: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
715: END IF;
716: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
717: OE_BULK_MSG_PUB.Add_Exc_Msg
718: ( G_PKG_NAME