DBA Data[Home] [Help]

APPS.OE_OE_HTML_LINE_EXT dependencies on OE_DEBUG_PUB

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

21: , p_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type
22: , p_old_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type
23: ) IS
24: l_control_rec OE_GLOBALS.Control_Rec_Type;
25: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
26: l_return_status VARCHAR2(1);
27: I Number;
28: J Number;
29: l_num_lines NUMBER;

Line 40: oe_debug_pub.g_debug_level := FND_PROFILE.VALUE('ONT_DEBUG_LEVEL');

36:
37: -- Consider changing the line_tbl to OUT type so that the old record
38: -- can be cached after save.
39:
40: oe_debug_pub.g_debug_level := FND_PROFILE.VALUE('ONT_DEBUG_LEVEL');
41: l_fname := oe_Debug_pub.set_debug_mode('FILE');
42: oe_debug_pub.debug_on;
43: OE_GLOBALS.G_UI_FLAG := TRUE;
44: l_control_rec.controlled_operation := TRUE;

Line 41: l_fname := oe_Debug_pub.set_debug_mode('FILE');

37: -- Consider changing the line_tbl to OUT type so that the old record
38: -- can be cached after save.
39:
40: oe_debug_pub.g_debug_level := FND_PROFILE.VALUE('ONT_DEBUG_LEVEL');
41: l_fname := oe_Debug_pub.set_debug_mode('FILE');
42: oe_debug_pub.debug_on;
43: OE_GLOBALS.G_UI_FLAG := TRUE;
44: l_control_rec.controlled_operation := TRUE;
45: l_control_rec.validate_entity := FALSE;

Line 42: oe_debug_pub.debug_on;

38: -- can be cached after save.
39:
40: oe_debug_pub.g_debug_level := FND_PROFILE.VALUE('ONT_DEBUG_LEVEL');
41: l_fname := oe_Debug_pub.set_debug_mode('FILE');
42: oe_debug_pub.debug_on;
43: OE_GLOBALS.G_UI_FLAG := TRUE;
44: l_control_rec.controlled_operation := TRUE;
45: l_control_rec.validate_entity := FALSE;
46: l_control_rec.write_to_DB := FALSE;

Line 74: oe_debug_pub.add( 'IN BEGINING HTML LINE- SAVE' ) ;

70:
71: -- Call Oe_Order_Pvt.Process_order
72:
73: IF l_debug_level > 0 THEN
74: oe_debug_pub.add( 'IN BEGINING HTML LINE- SAVE' ) ;
75: END IF;
76: oe_debug_pub.add( 'AT Beg HTML LINE- SAVE FIRST CALL-Line Type'
77: || l_line_tbl(1).line_type_id ) ;
78: oe_debug_pub.add( 'AT Beg HTML LINE- SAVE FIRST CALL-Line Type'

Line 76: oe_debug_pub.add( 'AT Beg HTML LINE- SAVE FIRST CALL-Line Type'

72:
73: IF l_debug_level > 0 THEN
74: oe_debug_pub.add( 'IN BEGINING HTML LINE- SAVE' ) ;
75: END IF;
76: oe_debug_pub.add( 'AT Beg HTML LINE- SAVE FIRST CALL-Line Type'
77: || l_line_tbl(1).line_type_id ) ;
78: oe_debug_pub.add( 'AT Beg HTML LINE- SAVE FIRST CALL-Line Type'
79: || l_old_line_tbl(1).line_type_id ) ;
80:

Line 78: oe_debug_pub.add( 'AT Beg HTML LINE- SAVE FIRST CALL-Line Type'

74: oe_debug_pub.add( 'IN BEGINING HTML LINE- SAVE' ) ;
75: END IF;
76: oe_debug_pub.add( 'AT Beg HTML LINE- SAVE FIRST CALL-Line Type'
77: || l_line_tbl(1).line_type_id ) ;
78: oe_debug_pub.add( 'AT Beg HTML LINE- SAVE FIRST CALL-Line Type'
79: || l_old_line_tbl(1).line_type_id ) ;
80:
81: Oe_Order_Pvt.Lines
82: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE

Line 90: oe_debug_pub.add( 'AT END HTML LINE- SAVE FIRST CALL' ) ;

86: , p_x_old_line_tbl => l_old_line_tbl
87: , x_return_Status => l_return_status
88: );
89: IF l_debug_level > 0 THEN
90: oe_debug_pub.add( 'AT END HTML LINE- SAVE FIRST CALL' ) ;
91: oe_debug_pub.add( 'AT END HTML LINE- SAVE FIRST CALL-Line Type'
92: || l_line_tbl(1).line_type_id ) ;
93: END IF;
94:

Line 91: oe_debug_pub.add( 'AT END HTML LINE- SAVE FIRST CALL-Line Type'

87: , x_return_Status => l_return_status
88: );
89: IF l_debug_level > 0 THEN
90: oe_debug_pub.add( 'AT END HTML LINE- SAVE FIRST CALL' ) ;
91: oe_debug_pub.add( 'AT END HTML LINE- SAVE FIRST CALL-Line Type'
92: || l_line_tbl(1).line_type_id ) ;
93: END IF;
94:
95: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 103: oe_debug_pub.add( 'AT BEGINING HTML LINE- SAVE SECOND CALL' ) ;

99: END IF;
100:
101:
102: IF l_debug_level > 0 THEN
103: oe_debug_pub.add( 'AT BEGINING HTML LINE- SAVE SECOND CALL' ) ;
104: END IF;
105:
106: l_control_rec.controlled_operation := TRUE;
107: l_control_rec.validate_entity := TRUE;

Line 123: oe_debug_pub.add('Operation -Update');

119: WHILE I IS NOT NULL AND l_num_lines > 0
120: LOOP
121: IF FND_API.To_Boolean(l_line_tbl(i).db_flag) OR
122: l_line_tbl(i).operation = OE_GLOBALS.G_OPR_UPDATE THEN
123: oe_debug_pub.add('Operation -Update');
124: -- The operation is set to handle if it doesn't get set in middle tier.
125: l_line_tbl(i).operation:=OE_GLOBALS.G_OPR_UPDATE;
126:
127: -- PO would have already queried the record if the old record is missing.

Line 134: oe_debug_pub.add('Operation -CREATE');

130: ( p_line_id => l_line_tbl(i).line_id
131: , x_line_rec => l_old_line_tbl(i) );
132: ELSE
133: -- This needs to be changed once deletes are handled.
134: oe_debug_pub.add('Operation -CREATE');
135: -- The operation is set to handle if it doesn't get set in middle tier.
136: l_line_tbl(i).operation:=OE_GLOBALS.G_OPR_CREATE;
137: GET_LINE_SHIPMENT_NUMBER(
138: x_return_Status => l_return_status

Line 143: oe_debug_pub.add( 'IN GET_LINE_SHIPMENT_NUMBER'||l_line_tbl(i).line_number);

139: , p_header_id => l_line_tbl(i).header_id
140: , x_line_number => l_line_tbl(i).line_number
141: , x_shipment_number => l_line_tbl(i).shipment_number
142: );
143: oe_debug_pub.add( 'IN GET_LINE_SHIPMENT_NUMBER'||l_line_tbl(i).line_number);
144: oe_debug_pub.add( 'IN GET_LINE_SHIPMENT_NUMBER'||l_line_tbl(i).shipment_number);
145: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
147: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 144: oe_debug_pub.add( 'IN GET_LINE_SHIPMENT_NUMBER'||l_line_tbl(i).shipment_number);

140: , x_line_number => l_line_tbl(i).line_number
141: , x_shipment_number => l_line_tbl(i).shipment_number
142: );
143: oe_debug_pub.add( 'IN GET_LINE_SHIPMENT_NUMBER'||l_line_tbl(i).line_number);
144: oe_debug_pub.add( 'IN GET_LINE_SHIPMENT_NUMBER'||l_line_tbl(i).shipment_number);
145: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
147: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
148: RAISE FND_API.G_EXC_ERROR;

Line 195: oe_debug_pub.add( 'AT END HTML LINE- SAVE SECOND CALL' ) ;

191: , p_x_old_line_tbl => l_old_line_tbl
192: , x_return_Status => l_return_status
193: );
194: IF l_debug_level > 0 THEN
195: oe_debug_pub.add( 'AT END HTML LINE- SAVE SECOND CALL' ) ;
196: END IF;
197:
198: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 210: oe_debug_pub.add( 'AT END HTML LINE- PROCESS OBJECT CALL' ) ;

206: , x_msg_count => x_msg_count
207: , x_msg_data => x_msg_data
208: , x_cascade_flag => l_cascade_flag
209: ); */
210: oe_debug_pub.add( 'AT END HTML LINE- PROCESS OBJECT CALL' ) ;
211:
212: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
214: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 225: oe_debug_pub.add( 'IN END HTML LINE- SAVE' ) ;

221: oe_msg_pub.count_and_get
222: ( p_count => x_msg_count
223: , p_data => x_msg_data
224: );
225: oe_debug_pub.add( 'IN END HTML LINE- SAVE' ) ;
226: EXCEPTION
227: WHEN FND_API.G_EXC_ERROR THEN
228:
229: OE_GLOBALS.G_UI_FLAG := FALSE;

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

293: , x_shipment_number OUT NOCOPY Number
294: ) IS
295: l_line_number Number;
296: --
297: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
298: --
299: BEGIN
300: -- Also this will need to be enhanced to support manual line numbers.
301: -- For Manual Line Numbers, we will also have to check that the line

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

373: and line.item_identifier_type = ref.cross_reference_type(+)
374: and line.ordered_item = ref.cross_reference(+)
375: and line.inventory_item_id = ref.inventory_item_id(+)
376: and line.ordered_item_id = c.customer_item_id(+);
377: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
378:
379: BEGIN
380:
381: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 395: oe_debug_pub.add( 'WHEN OTHERS OF CALL_MRP_ATP' ) ;

391: EXCEPTION
392:
393: WHEN OTHERS THEN
394: IF l_debug_level > 0 THEN
395: oe_debug_pub.add( 'WHEN OTHERS OF CALL_MRP_ATP' ) ;
396: oe_debug_pub.add( 'CODE='||SQLCODE||' MSG='||SQLERRM ) ;
397: END IF;
398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
399: -- Get message count and data

Line 396: oe_debug_pub.add( 'CODE='||SQLCODE||' MSG='||SQLERRM ) ;

392:
393: WHEN OTHERS THEN
394: IF l_debug_level > 0 THEN
395: oe_debug_pub.add( 'WHEN OTHERS OF CALL_MRP_ATP' ) ;
396: oe_debug_pub.add( 'CODE='||SQLCODE||' MSG='||SQLERRM ) ;
397: END IF;
398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
399: -- Get message count and data
400: OE_MSG_PUB.Count_And_Get