DBA Data[Home] [Help]

APPS.ONT_CUSTACCEPTOIP_PVT dependencies on OE_DEBUG_PUB

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

45: l_return_status VARCHAR2(1);
46: l_msg_count NUMBER;
47: l_msg_data VARCHAR2(4000);
48:
49: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
50: l_temp_var VARCHAR2(2000) := NULL;
51: l_org_id NUMBER;
52:
53: BEGIN

Line 57: oe_debug_pub.initialize;

53: BEGIN
54:
55: --myerrams, Bug: 5285062
56: IF To_number(Nvl(fnd_profile.value('ONT_DEBUG_LEVEL'), '0')) > 0 THEN
57: oe_debug_pub.initialize;
58: l_temp_var := oe_debug_pub.set_debug_mode('FILE');
59: oe_debug_pub.debug_on;
60: END IF;
61: IF l_debug_level > 0 THEN

Line 58: l_temp_var := oe_debug_pub.set_debug_mode('FILE');

54:
55: --myerrams, Bug: 5285062
56: IF To_number(Nvl(fnd_profile.value('ONT_DEBUG_LEVEL'), '0')) > 0 THEN
57: oe_debug_pub.initialize;
58: l_temp_var := oe_debug_pub.set_debug_mode('FILE');
59: oe_debug_pub.debug_on;
60: END IF;
61: IF l_debug_level > 0 THEN
62: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: Start of method ONT_CustAcceptOip_PVT.Call_OIP_Process_Order' ) ;

Line 59: oe_debug_pub.debug_on;

55: --myerrams, Bug: 5285062
56: IF To_number(Nvl(fnd_profile.value('ONT_DEBUG_LEVEL'), '0')) > 0 THEN
57: oe_debug_pub.initialize;
58: l_temp_var := oe_debug_pub.set_debug_mode('FILE');
59: oe_debug_pub.debug_on;
60: END IF;
61: IF l_debug_level > 0 THEN
62: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: Start of method ONT_CustAcceptOip_PVT.Call_OIP_Process_Order' ) ;
63: END IF;

Line 62: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: Start of method ONT_CustAcceptOip_PVT.Call_OIP_Process_Order' ) ;

58: l_temp_var := oe_debug_pub.set_debug_mode('FILE');
59: oe_debug_pub.debug_on;
60: END IF;
61: IF l_debug_level > 0 THEN
62: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: Start of method ONT_CustAcceptOip_PVT.Call_OIP_Process_Order' ) ;
63: END IF;
64:
65: -- myerrams, to get the org_id of header passed.
66: select org_id into l_org_id from oe_order_headers_all where header_id = p_header_id;

Line 70: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: Org_Id of the header passed:' || l_org_id) ;

66: select org_id into l_org_id from oe_order_headers_all where header_id = p_header_id;
67:
68:
69: IF l_debug_level > 0 THEN
70: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: Org_Id of the header passed:' || l_org_id) ;
71: END IF;
72:
73: --myerrams, Bug:5155962; Modified the code to match the LookupCode instead of Meaning
74: --as Meaning can be different for different languages.

Line 85: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: Parameters passed to Process Order') ;

81: END IF;
82: --myerrams, end. Bug:5155962
83:
84: IF l_debug_level > 0 THEN
85: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: Parameters passed to Process Order') ;
86: END IF;
87:
88: oe_msg_pub.initialize;
89: FOR i IN 1..p_line_id_tbl.COUNT LOOP

Line 102: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: Record Number:' || i || ' out of ' || p_line_id_tbl.COUNT || ' records') ;

98: l_action_request_tbl(i).param5 := p_header_id;
99: l_action_request_tbl(i).date_param1 := p_signature_date;
100:
101: IF l_debug_level > 0 THEN
102: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: Record Number:' || i || ' out of ' || p_line_id_tbl.COUNT || ' records') ;
103: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: entity_code' || l_action_request_tbl(i).entity_code) ;
104: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: request_type' || l_action_request_tbl(i).request_type) ;
105: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: entity_id' || l_action_request_tbl(i).entity_id) ;
106: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: customer_comments' || l_action_request_tbl(i).param1) ;

Line 103: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: entity_code' || l_action_request_tbl(i).entity_code) ;

99: l_action_request_tbl(i).date_param1 := p_signature_date;
100:
101: IF l_debug_level > 0 THEN
102: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: Record Number:' || i || ' out of ' || p_line_id_tbl.COUNT || ' records') ;
103: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: entity_code' || l_action_request_tbl(i).entity_code) ;
104: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: request_type' || l_action_request_tbl(i).request_type) ;
105: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: entity_id' || l_action_request_tbl(i).entity_id) ;
106: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: customer_comments' || l_action_request_tbl(i).param1) ;
107: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: customer_signature' || l_action_request_tbl(i).param2) ;

Line 104: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: request_type' || l_action_request_tbl(i).request_type) ;

100:
101: IF l_debug_level > 0 THEN
102: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: Record Number:' || i || ' out of ' || p_line_id_tbl.COUNT || ' records') ;
103: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: entity_code' || l_action_request_tbl(i).entity_code) ;
104: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: request_type' || l_action_request_tbl(i).request_type) ;
105: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: entity_id' || l_action_request_tbl(i).entity_id) ;
106: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: customer_comments' || l_action_request_tbl(i).param1) ;
107: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: customer_signature' || l_action_request_tbl(i).param2) ;
108: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: reference_document' || l_action_request_tbl(i).param3) ;

Line 105: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: entity_id' || l_action_request_tbl(i).entity_id) ;

101: IF l_debug_level > 0 THEN
102: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: Record Number:' || i || ' out of ' || p_line_id_tbl.COUNT || ' records') ;
103: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: entity_code' || l_action_request_tbl(i).entity_code) ;
104: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: request_type' || l_action_request_tbl(i).request_type) ;
105: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: entity_id' || l_action_request_tbl(i).entity_id) ;
106: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: customer_comments' || l_action_request_tbl(i).param1) ;
107: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: customer_signature' || l_action_request_tbl(i).param2) ;
108: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: reference_document' || l_action_request_tbl(i).param3) ;
109: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: Explicit Revenue Recognition Acceptance') ;

Line 106: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: customer_comments' || l_action_request_tbl(i).param1) ;

102: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: Record Number:' || i || ' out of ' || p_line_id_tbl.COUNT || ' records') ;
103: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: entity_code' || l_action_request_tbl(i).entity_code) ;
104: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: request_type' || l_action_request_tbl(i).request_type) ;
105: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: entity_id' || l_action_request_tbl(i).entity_id) ;
106: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: customer_comments' || l_action_request_tbl(i).param1) ;
107: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: customer_signature' || l_action_request_tbl(i).param2) ;
108: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: reference_document' || l_action_request_tbl(i).param3) ;
109: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: Explicit Revenue Recognition Acceptance') ;
110: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: header_id' || l_action_request_tbl(i).param5) ;

Line 107: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: customer_signature' || l_action_request_tbl(i).param2) ;

103: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: entity_code' || l_action_request_tbl(i).entity_code) ;
104: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: request_type' || l_action_request_tbl(i).request_type) ;
105: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: entity_id' || l_action_request_tbl(i).entity_id) ;
106: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: customer_comments' || l_action_request_tbl(i).param1) ;
107: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: customer_signature' || l_action_request_tbl(i).param2) ;
108: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: reference_document' || l_action_request_tbl(i).param3) ;
109: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: Explicit Revenue Recognition Acceptance') ;
110: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: header_id' || l_action_request_tbl(i).param5) ;
111: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: signature_date' || l_action_request_tbl(i).date_param1) ;

Line 108: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: reference_document' || l_action_request_tbl(i).param3) ;

104: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: request_type' || l_action_request_tbl(i).request_type) ;
105: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: entity_id' || l_action_request_tbl(i).entity_id) ;
106: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: customer_comments' || l_action_request_tbl(i).param1) ;
107: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: customer_signature' || l_action_request_tbl(i).param2) ;
108: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: reference_document' || l_action_request_tbl(i).param3) ;
109: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: Explicit Revenue Recognition Acceptance') ;
110: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: header_id' || l_action_request_tbl(i).param5) ;
111: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: signature_date' || l_action_request_tbl(i).date_param1) ;
112: END IF;

Line 109: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: Explicit Revenue Recognition Acceptance') ;

105: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: entity_id' || l_action_request_tbl(i).entity_id) ;
106: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: customer_comments' || l_action_request_tbl(i).param1) ;
107: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: customer_signature' || l_action_request_tbl(i).param2) ;
108: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: reference_document' || l_action_request_tbl(i).param3) ;
109: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: Explicit Revenue Recognition Acceptance') ;
110: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: header_id' || l_action_request_tbl(i).param5) ;
111: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: signature_date' || l_action_request_tbl(i).date_param1) ;
112: END IF;
113:

Line 110: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: header_id' || l_action_request_tbl(i).param5) ;

106: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: customer_comments' || l_action_request_tbl(i).param1) ;
107: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: customer_signature' || l_action_request_tbl(i).param2) ;
108: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: reference_document' || l_action_request_tbl(i).param3) ;
109: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: Explicit Revenue Recognition Acceptance') ;
110: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: header_id' || l_action_request_tbl(i).param5) ;
111: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: signature_date' || l_action_request_tbl(i).date_param1) ;
112: END IF;
113:
114: END LOOP;

Line 111: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: signature_date' || l_action_request_tbl(i).date_param1) ;

107: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: customer_signature' || l_action_request_tbl(i).param2) ;
108: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: reference_document' || l_action_request_tbl(i).param3) ;
109: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: Explicit Revenue Recognition Acceptance') ;
110: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: header_id' || l_action_request_tbl(i).param5) ;
111: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: signature_date' || l_action_request_tbl(i).date_param1) ;
112: END IF;
113:
114: END LOOP;
115:

Line 117: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: Before Call to Process Order API.') ;

113:
114: END LOOP;
115:
116: IF l_debug_level > 0 THEN
117: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: Before Call to Process Order API.') ;
118: END IF;
119:
120: OE_Order_PUB.Process_Order
121: ( p_api_version_number => 1.0

Line 151: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: After Call to Process Order API.') ;

147: , x_action_request_tbl => l_action_request_out_tbl
148: );
149:
150: IF l_debug_level > 0 THEN
151: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: After Call to Process Order API.') ;
152: END IF;
153:
154: x_return_status := l_return_status;
155: x_msg_count := l_msg_count;

Line 167: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: x_msg_count:' || x_msg_count) ;

163: x_msg_data := x_msg_data || k || '.' || l_msg_data || ' ' ;
164: end loop;
165: end if;
166: IF l_debug_level > 0 THEN
167: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: x_msg_count:' || x_msg_count) ;
168: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: x_msg_data: ' || x_msg_data) ;
169: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: End of method ONT_CustAcceptOip_PVT.Call_OIP_Process_Order' ) ;
170: END IF;
171:

Line 168: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: x_msg_data: ' || x_msg_data) ;

164: end loop;
165: end if;
166: IF l_debug_level > 0 THEN
167: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: x_msg_count:' || x_msg_count) ;
168: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: x_msg_data: ' || x_msg_data) ;
169: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: End of method ONT_CustAcceptOip_PVT.Call_OIP_Process_Order' ) ;
170: END IF;
171:
172: EXCEPTION

Line 169: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: End of method ONT_CustAcceptOip_PVT.Call_OIP_Process_Order' ) ;

165: end if;
166: IF l_debug_level > 0 THEN
167: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: x_msg_count:' || x_msg_count) ;
168: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: x_msg_data: ' || x_msg_data) ;
169: oe_debug_pub.add( 'GBL:Customer Acceptance OIP: End of method ONT_CustAcceptOip_PVT.Call_OIP_Process_Order' ) ;
170: END IF;
171:
172: EXCEPTION
173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN