APPS.OE_ORDER_EXTN_IMPORT_PVT dependencies on OE_HEADERS_EXT_IFACE_ALL

Line 29: FROM OE_HEADERS_EXT_IFACE_ALL

25: order_source_id,
26: orig_sys_document_ref,
27: sold_to_org_id,
28: org_id
29: FROM OE_HEADERS_EXT_IFACE_ALL
30: WHERE PROCESS_STATUS=1
31: AND DATA_SET_ID=l_data_set_id;
32:
33: CURSOR l_line_cur IS

Line 88: UPDATE OE_HEADERS_EXT_IFACE_ALL

84: ||',' || 'orig_sys_document_ref : ' ||i.orig_sys_document_ref);
85: END;
86:
87: IF l_header_id IS NOT NULL THEN
88: UPDATE OE_HEADERS_EXT_IFACE_ALL
89: SET PROCESS_STATUS = 2, HEADER_ID= l_header_id
90: WHERE data_set_id = l_data_set_id
91: AND PROCESS_STATUS = 1
92: AND order_source_id = i.order_source_id

Line 99: UPDATE OE_HEADERS_EXT_IFACE_ALL

95: = decode(l_customer_key_profile, 'Y',nvl(i.sold_to_org_id, FND_API.G_MISS_NUM), 1));
96:
97: END IF;
98: ELSE
99: UPDATE OE_HEADERS_EXT_IFACE_ALL
100: SET PROCESS_STATUS = 2
101: WHERE data_set_id = l_data_set_id
102: AND header_id = i.header_id
103: AND PROCESS_STATUS = 1;

Line 110: FROM OE_HEADERS_EXT_IFACE_ALL

106: END LOOP ;
107:
108: BEGIN
109: SELECT COUNT(*) INTO l_header_count
110: FROM OE_HEADERS_EXT_IFACE_ALL
111: WHERE PROCESS_STATUS=2
112: AND HEADER_ID IS NOT NULL;
113: EXCEPTION
114: WHEN NO_DATA_FOUND THEN

Line 119: FND_FILE.PUT_LINE( FND_FILE.LOG, 'NO records in OE_HEADERS_EXT_IFACE_ALL to process');

115: l_header_count := NULL;
116: END;
117:
118: IF l_header_count = 0 THEN
119: FND_FILE.PUT_LINE( FND_FILE.LOG, 'NO records in OE_HEADERS_EXT_IFACE_ALL to process');
120: END IF;
121:
122: IF l_header_count > 0 THEN
123: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Calling EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data to import OE_HEADERS_EXT_IFACE_ALL data');

Line 123: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Calling EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data to import OE_HEADERS_EXT_IFACE_ALL data');

119: FND_FILE.PUT_LINE( FND_FILE.LOG, 'NO records in OE_HEADERS_EXT_IFACE_ALL to process');
120: END IF;
121:
122: IF l_header_count > 0 THEN
123: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Calling EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data to import OE_HEADERS_EXT_IFACE_ALL data');
124:
125: EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data
126: ( p_api_version => 1.0
127: , p_application_id => 660

Line 131: , p_interface_table_name => 'OE_HEADERS_EXT_IFACE_ALL'

127: , p_application_id => 660
128: , p_attr_group_type => 'OE_HEADER_ATTRIBUTES_EXT'
129: , p_object_name => 'OE_ORDER_HEADERS_ALL'
130: , p_hz_party_id => 'OPERATIONS:5877'
131: , p_interface_table_name => 'OE_HEADERS_EXT_IFACE_ALL'
132: , p_data_set_id => l_data_set_id
133: ,p_related_class_codes_query => l_rel_sql
134: , p_init_fnd_msg_list => 'F'
135: , p_log_errors => 'T'

Line 146: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_return_status after importing OE_HEADERS_EXT_IFACE_ALL : '||l_return_status);

142: , x_msg_count => l_msg_count
143: , x_msg_data => l_err_text
144: );
145:
146: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_return_status after importing OE_HEADERS_EXT_IFACE_ALL : '||l_return_status);
147: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_err_code : '||l_err_code);
148: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_err_text : '||l_err_text);
149: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_msg_count : '||l_msg_count);
150:

Line 153: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Sucessfully imported OE_HEADERS_EXT_IFACE_ALL data');

149: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_msg_count : '||l_msg_count);
150:
151: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
152: retcode := 0;
153: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Sucessfully imported OE_HEADERS_EXT_IFACE_ALL data');
154: ELSIF l_return_status = 'W' THEN
155: retcode := 1;
156: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Warning while importing OE_HEADERS_EXT_IFACE_ALL');
157: ELSE

Line 156: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Warning while importing OE_HEADERS_EXT_IFACE_ALL');

152: retcode := 0;
153: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Sucessfully imported OE_HEADERS_EXT_IFACE_ALL data');
154: ELSIF l_return_status = 'W' THEN
155: retcode := 1;
156: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Warning while importing OE_HEADERS_EXT_IFACE_ALL');
157: ELSE
158: retcode := 2;
159: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error reported while importing OE_HEADERS_EXT_IFACE_ALL. Please fix the errors in this log file and re-run the concurrent program.');
160: END IF;

Line 159: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error reported while importing OE_HEADERS_EXT_IFACE_ALL. Please fix the errors in this log file and re-run the concurrent program.');

155: retcode := 1;
156: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Warning while importing OE_HEADERS_EXT_IFACE_ALL');
157: ELSE
158: retcode := 2;
159: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error reported while importing OE_HEADERS_EXT_IFACE_ALL. Please fix the errors in this log file and re-run the concurrent program.');
160: END IF;
161:
162:
163: ERROR_HANDLER.Log_Error(

Line 170: DELETE FROM OE_HEADERS_EXT_IFACE_ALL

166: ,p_write_err_to_debugfile => 'N'
167: );
168:
169: IF l_return_status = FND_API.G_RET_STS_SUCCESS OR l_return_status = 'W' THEN
170: DELETE FROM OE_HEADERS_EXT_IFACE_ALL
171: WHERE data_set_id = l_data_set_id
172: AND PROCESS_STATUS = 2;
173: COMMIT;
174: END IF;