APPS.IPA_APIS dependencies on IPA_APIS_INTERFACE_ERRORS

Line 116: DELETE FROM ipa_apis_interface_errors;

112:
113: begin
114:
115: -- Delete Old error records from error table
116: DELETE FROM ipa_apis_interface_errors;
117: COMMIT ;
118:
119: FOR apis_rec in apis_intf
120: LOOP

Line 181: INSERT INTO ipa_apis_interface_errors

177:
178: IF error_code = 1 THEN -- ( privious error )
179:
180: x_error_msg := x_error_msg || ' Values missing ' ;
181: INSERT INTO ipa_apis_interface_errors
182: ( INTERFACE_ID ,
183: BATCH_NAME ,
184: PROJECT_ID ,
185: PROJECT_ASSET_ID ,

Line 207: INSERT INTO ipa_apis_interface_errors

203: END IF;
204:
205: IF apis_rec.date_placed_in_service < l_earliest_fa_dpis THEN
206:
207: INSERT INTO ipa_apis_interface_errors
208: ( INTERFACE_ID ,
209: BATCH_NAME ,
210: PROJECT_ID ,
211: PROJECT_ASSET_ID ,

Line 252: INSERT INTO ipa_apis_interface_errors

248: AND pp.project_type = ppt.project_type
249: AND PP.org_id = ppt.org_id ; -- Fix for bug: 4960534
250: EXCEPTION
251: WHEN no_data_found THEN
252: INSERT INTO ipa_apis_interface_errors
253: ( INTERFACE_ID ,
254: PROJECT_ID ,
255: PROJECT_ASSET_ID ,
256: ERROR_MESSAGE

Line 301: INSERT INTO ipa_apis_interface_errors

297:
298: EXCEPTION
299:
300: WHEN no_data_found THEN
301: INSERT INTO ipa_apis_interface_errors
302: ( INTERFACE_ID ,
303: ERROR_MESSAGE
304: )
305: VALUES

Line 479: INSERT INTO ipa_apis_interface_errors

475: END LOOP ;
476: end if;
477:
478: IF l_count = 0 THEN
479: INSERT INTO ipa_apis_interface_errors
480: ( INTERFACE_ID ,
481: ERROR_MESSAGE
482: )
483: VALUES

Line 623: INSERT INTO ipa_apis_interface_errors

619: i_book_type_code ) ;
620:
621: if result < 0 then -- warning invalid dpis
622:
623: INSERT INTO ipa_apis_interface_errors
624: ( INTERFACE_ID ,
625: PROJECT_ID ,
626: PROJECT_ASSET_ID ,
627: ERROR_MESSAGE

Line 640: INSERT INTO ipa_apis_interface_errors

636: warning_msg := '';
637: fnd_message.set_name ('PA','PA_CP_WRN_INVALID_DPIS' );
638: warning_msg := 'Error:'|| fnd_message.get;
639:
640: INSERT INTO ipa_apis_interface_errors
641: ( INTERFACE_ID ,
642: PROJECT_ID ,
643: PROJECT_ASSET_ID ,
644: DATE_PLACED_IN_SERVICE ,

Line 683: INSERT INTO ipa_apis_interface_errors

679: AND project_asset_id = i_project_asset_id ;
680:
681:
682: IF ( SQL%ROWCOUNT = 0 ) THEN
683: INSERT INTO ipa_apis_interface_errors
684: ( INTERFACE_ID ,
685: PROJECT_ID ,
686: PROJECT_ASSET_ID ,
687: ERROR_MESSAGE

Line 699: INSERT INTO ipa_apis_interface_errors

695: end if;
696:
697: ELSE
698:
699: INSERT INTO ipa_apis_interface_errors
700: ( INTERFACE_ID ,
701: PROJECT_ID ,
702: PROJECT_ASSET_ID ,
703: ERROR_MESSAGE