PACKAGE: APPS.WIP_JDI_UTILS

Source

1 package WIP_JDI_Utils AUTHID CURRENT_USER as
2 /* $Header: wipjdius.pls 115.6 2002/11/28 18:40:11 rmahidha ship $ */
3 
4 --
5 -- Valid error types.
6 --
7   MSG_ERROR CONSTANT NUMBER := 1;
8   MSG_WARNING CONSTANT NUMBER := 2;
9   MSG_LOG CONSTANT NUMBER := 3;
10   MSG_COLUMN CONSTANT NUMBER := 4;
11   MSG_CONC CONSTANT NUMBER := 5;
12 
13 --
14 -- Procedures for error handling in loading details.
15 --
16 
17 Procedure Begin_Processing_Request(p_group_id 		number,
18 				   p_parent_header_id	number,
19                                    x_err_code		 out NOCOPY varchar2,
20                                    x_err_msg		 out NOCOPY varchar2,
21 				   x_return_status	 out NOCOPY varchar2);
22 
23 -- Generate new interface_id and set process_status to running.
24 
25 
26 Procedure Error_If_Batch(p_group_id 	number,
27                          p_new_process_status number,
28 			 p_where_clause varchar2,
29 			 p_error_type	number,
30 			 p_error_msg	varchar2);
31 
32 -- Insert error into PL/SQL table, if p_where_clause is satisfied.
33 
34 Procedure End_Processing_Request(p_wip_entity_id 	number,
35 				 p_organization_id	number);
36 
37 
38 -- Commit if no error, else rollback.
39 
40 Procedure Change_Status_Error(p_group_id number := null,
41                               p_parent_header_id number := null,
42                               p_wip_entity_id    number := null,
43                               p_organization_id  number := null);
44 
45 -- Change process_status to error after rollback.
46 
47 Procedure Change_Status_Pending(p_row_id varchar2,p_group_id number);
48 
49 
50 -- Used in resubmit jobs or schedules.
51 
52 end WIP_JDI_Utils;