DBA Data[Home] [Help]

APPS.ONT_UPG_TAX_UTIL dependencies on OE_DEBUG_PUB

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

46: /* In the above cursor query 'EXISTS' is added for the performance bug 3056892 */
47: /* =========================================================================== */
48:
49: --
50: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
51: --
52: begin
53:
54: x_return_status := l_return_status;

Line 63: oe_debug_pub.add( 'IN HEADERS' , 1 ) ;

59: OE_MSG_PUB.Initialize;
60: loop
61:
62: IF l_debug_level > 0 THEN
63: oe_debug_pub.add( 'IN HEADERS' , 1 ) ;
64: END IF;
65:
66: header_id_t.delete;
67:

Line 69: oe_debug_pub.add( 'IN HEADERS: 1' , 1 ) ;

65:
66: header_id_t.delete;
67:
68: IF l_debug_level > 0 THEN
69: oe_debug_pub.add( 'IN HEADERS: 1' , 1 ) ;
70: END IF;
71:
72: FETCH headers BULK COLLECT INTO header_id_t
73: Limit G_HEADER_SIZE;

Line 76: oe_debug_pub.add( 'IN HEADERS: 2' , 1 ) ;

72: FETCH headers BULK COLLECT INTO header_id_t
73: Limit G_HEADER_SIZE;
74:
75: IF l_debug_level > 0 THEN
76: oe_debug_pub.add( 'IN HEADERS: 2' , 1 ) ;
77: END IF;
78:
79: IF header_id_t.first is not null THEN
80:

Line 82: oe_debug_pub.add( 'INSIDE THE HEADER_ID_T.FIRST NOT NULL' , 1 ) ;

78:
79: IF header_id_t.first is not null THEN
80:
81: IF l_debug_level > 0 THEN
82: oe_debug_pub.add( 'INSIDE THE HEADER_ID_T.FIRST NOT NULL' , 1 ) ;
83: END IF;
84:
85: FOR K in header_id_t.first..header_id_t.last LOOP
86:

Line 88: oe_debug_pub.add( 'HEADER ID IS : ' || HEADER_ID_T ( K ) , 1 ) ;

84:
85: FOR K in header_id_t.first..header_id_t.last LOOP
86:
87: IF l_debug_level > 0 THEN
88: oe_debug_pub.add( 'HEADER ID IS : ' || HEADER_ID_T ( K ) , 1 ) ;
89: END IF;
90:
91: OE_MSG_PUB.set_msg_context(
92: p_entity_code => 'HEADER'

Line 115: oe_debug_pub.add( 'MESSAGES RETURNED: '|| TO_CHAR ( l_msg_count ),1 ) ;

111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
112: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
113: OE_MSG_PUB.Count_And_Get (p_count => l_msg_count
114: ,p_data => l_msg_data);
115: oe_debug_pub.add( 'MESSAGES RETURNED: '|| TO_CHAR ( l_msg_count ),1 ) ;
116: if l_msg_count > 0 then
117: OE_MSG_PUB.Add_text('Tax calculation failed for Header Id :'|| header_id_t(K));
118: l_msg_data := 'Error message for header_id ' || header_id_t(K) ||' is : '||l_msg_data;
119: IF l_debug_level > 0 THEN

Line 120: oe_debug_pub.add( l_msg_data,1 ) ;

116: if l_msg_count > 0 then
117: OE_MSG_PUB.Add_text('Tax calculation failed for Header Id :'|| header_id_t(K));
118: l_msg_data := 'Error message for header_id ' || header_id_t(K) ||' is : '||l_msg_data;
119: IF l_debug_level > 0 THEN
120: oe_debug_pub.add( l_msg_data,1 ) ;
121: END IF;
122: end if;
123: --RAISE FND_API.G_EXC_ERROR;
124: END IF;

Line 126: oe_debug_pub.add(' Save the Messages for Header: '|| header_id_t(K), 1);

122: end if;
123: --RAISE FND_API.G_EXC_ERROR;
124: END IF;
125: IF l_debug_level > 0 THEN
126: oe_debug_pub.add(' Save the Messages for Header: '|| header_id_t(K), 1);
127: END IF;
128: OE_MSG_PUB.save_UI_messages (0,'C');
129:
130: END LOOP; /* for loop */

Line 152: oe_debug_pub.add( 'TAX_ORDER: IN NO DATA FOUND' , 4 ) ;

148: x_return_status := FND_API.G_RET_STS_ERROR;
149:
150: WHEN NO_DATA_FOUND THEN
151: IF l_debug_level > 0 THEN
152: oe_debug_pub.add( 'TAX_ORDER: IN NO DATA FOUND' , 4 ) ;
153: END IF;
154: x_return_status := FND_API.G_RET_STS_SUCCESS;
155:
156: WHEN OTHERS THEN