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
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
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' ) ;
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;
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;
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.
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
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) ;
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) ;
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) ;
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') ;
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) ;
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) ;
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;
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:
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;
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:
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
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;
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:
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
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