APPS.IPA_APIS dependencies on IPA_APIS

Line 1: PACKAGE BODY ipa_apis AS

1: PACKAGE BODY ipa_apis AS
2: /* $Header: IPASRVB.pls 120.2 2006/02/14 12:14:24 dlanka noship $ */
3:
4: PROCEDURE summarize_dpis (
5: errbug IN OUT NOCOPY VARCHAR2 ,

Line 34: SELECT * FROM ipa_apis_interface

30: x_error_msg varchar2(500) ;
31: incomplete_fail_flag varchar2(1) ;
32:
33: CURSOR apis_intf IS
34: SELECT * FROM ipa_apis_interface
35: ORDER BY interface_id;
36:
37: CURSOR project_cur( grouping_method1 VARCHAR2 ,
38: grouping_method2 VARCHAR2 ,

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 300: INSERT INTO ipa_apis_interface_errors

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

Line 473: INSERT INTO ipa_apis_interface_errors

469: END LOOP ;
470: end if;
471:
472: IF l_count = 0 THEN
473: INSERT INTO ipa_apis_interface_errors
474: ( INTERFACE_ID ,
475: ERROR_MESSAGE
476: )
477: VALUES

Line 605: INSERT INTO ipa_apis_interface_errors

601: i_book_type_code ) ;
602:
603: if result < 0 then -- warning invalid dpis
604:
605: INSERT INTO ipa_apis_interface_errors
606: ( INTERFACE_ID ,
607: PROJECT_ID ,
608: PROJECT_ASSET_ID ,
609: ERROR_MESSAGE

Line 622: INSERT INTO ipa_apis_interface_errors

618: warning_msg := '';
619: fnd_message.set_name ('PA','PA_CP_WRN_INVALID_DPIS' );
620: warning_msg := 'Error:'|| fnd_message.get;
621:
622: INSERT INTO ipa_apis_interface_errors
623: ( INTERFACE_ID ,
624: PROJECT_ID ,
625: PROJECT_ASSET_ID ,
626: DATE_PLACED_IN_SERVICE ,

Line 657: INSERT INTO ipa_apis_interface_errors

653: AND project_asset_id = i_project_asset_id ;
654:
655:
656: IF ( SQL%ROWCOUNT = 0 ) THEN
657: INSERT INTO ipa_apis_interface_errors
658: ( INTERFACE_ID ,
659: PROJECT_ID ,
660: PROJECT_ASSET_ID ,
661: ERROR_MESSAGE

Line 673: INSERT INTO ipa_apis_interface_errors

669: end if;
670:
671: ELSE
672:
673: INSERT INTO ipa_apis_interface_errors
674: ( INTERFACE_ID ,
675: PROJECT_ID ,
676: PROJECT_ASSET_ID ,
677: ERROR_MESSAGE

Line 687: update ipa_apis_interface

683: error_msg ) ;
684:
685: END IF;
686:
687: update ipa_apis_interface
688: set record_status = 'PROCESSED'
689: where interface_id = i_interface_id ;
690:
691: /* COMMIT; */

Line 697: END ipa_apis ;

693: END update_dpis ;
694:
695:
696:
697: END ipa_apis ;