[Home] [Help]
PACKAGE: APPS.FPA_UTILITIES_PVT
Source
1 package FPA_Utilities_PVT AUTHID CURRENT_USER as
2 /* $Header: FPAVUTLS.pls 120.1 2005/08/18 11:04:39 appldev ship $ */
3
4 procedure attach_AW(
5 p_api_version IN number
6 ,p_attach_mode IN varchar2
7 ,x_return_status OUT NOCOPY varchar2
8 ,x_msg_count OUT NOCOPY number
9 ,x_msg_data OUT NOCOPY varchar2
10 );
11
12 procedure detach_AW(
13 p_api_version IN number
14 ,x_return_status OUT NOCOPY varchar2
15 ,x_msg_count OUT NOCOPY number
16 ,x_msg_data OUT NOCOPY varchar2
17 );
18
19 function Duplicate_Name(
20 p_table_name IN varchar2
21 ,p_column_name IN varchar2
22 ,p_name IN varchar2
23 ) return number;
24
25 -- The following function returns the AW space for PJP.
26 -- It is used in the DDL for PJPs views.
27 function aw_space_name return varchar2;
28
29 function Get_Net_Cash_Needed(
30 p_budget IN number
31 ,p_cash_req IN number
32 ) return number;
33
34 function Get_Overtime_Resources(
35 p_req_resources IN number
36 ,p_curr_resources IN number
37 ) return number;
38
39 function Get_Unused_Resources(
40 p_req_resources IN number
41 ,p_curr_resources IN number
42 ) return number;
43
44
45 /****** Section for common API messages, exception handling and logging. *********
46 ******** created: ashariff Dt: 10/29/2004 ****************************************/
47
48 TYPE msg_rec_type IS RECORD (
49 error_status NUMBER,
50 data VARCHAR2(2000));
51 TYPE msg_tbl_type IS TABLE OF msg_rec_type
52 INDEX BY BINARY_INTEGER;
53
54 TYPE error_rec_type IS RECORD (
55 idx NUMBER,
56 error_type VARCHAR2(1),
57 msg_count INTEGER,
58 msg_data VARCHAR2(2000),
59 sqlcode NUMBER,
60 api_name VARCHAR2(30),
61 api_package VARCHAR2(30));
62 TYPE error_tbl_type IS TABLE OF error_rec_type
63 INDEX BY BINARY_INTEGER;
64
65
66 -- GLOBAL CONSTANTS
67
68 G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
69 G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
70 G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
71 G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
72 G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
73
74 -- GLOBAL MESSAGE CONSTANTS
75
76 G_FND_APP CONSTANT VARCHAR2(200) := 'FND';
77 G_APP_NAME CONSTANT VARCHAR2(200) := 'FPA';
78 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := 'COL_NAME';
79
80 -- ERRORS AND EXCEPTIONS
81
82 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
83 G_RET_STS_WARNING CONSTANT VARCHAR2(1) := 'W';
84 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
85 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
86 G_EXCEPTION_ERROR EXCEPTION;
87 G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
88 G_EXC_WARNING EXCEPTION;
89
90 -- Functions and Procedures
91
92 PROCEDURE init_msg_list(
93 p_init_msg_list IN VARCHAR2);
94
95 FUNCTION start_activity(
96 p_api_name IN VARCHAR2,
97 p_pkg_name IN VARCHAR2,
98 p_init_msg_list IN VARCHAR2,
99 l_api_version IN NUMBER,
100 p_api_version IN NUMBER,
101 p_api_type IN VARCHAR2,
102 p_msg_log IN VARCHAR2,
103 x_return_status OUT NOCOPY VARCHAR2
104 ) RETURN VARCHAR2;
105
106 PROCEDURE start_activity(
107 p_api_name IN VARCHAR2,
108 p_pkg_name IN VARCHAR2,
109 p_init_msg_list IN VARCHAR2,
110 p_msg_log IN VARCHAR2
111 );
112
113
114 FUNCTION handle_exceptions (
115 p_api_name IN VARCHAR2,
116 p_pkg_name IN VARCHAR2,
117 p_exc_name IN VARCHAR2,
118 p_msg_log IN VARCHAR2,
119 x_msg_count OUT NOCOPY NUMBER,
120 x_msg_data OUT NOCOPY VARCHAR2,
121 p_api_type IN VARCHAR2
122 ) RETURN VARCHAR2;
123
124 PROCEDURE end_activity
125 (
126 p_api_name IN VARCHAR2,
127 p_pkg_name IN VARCHAR2,
128 p_msg_log IN VARCHAR2,
129 x_msg_count OUT NOCOPY NUMBER,
130 x_msg_data OUT NOCOPY VARCHAR2
131 );
132
133 PROCEDURE set_message (
134 p_app_name IN VARCHAR2 DEFAULT FPA_UTILITIES_PVT.G_APP_NAME,
135 p_msg_name IN VARCHAR2,
136 p_token1 IN VARCHAR2 DEFAULT NULL,
137 p_token1_value IN VARCHAR2 DEFAULT NULL,
138 p_token2 IN VARCHAR2 DEFAULT NULL,
139 p_token2_value IN VARCHAR2 DEFAULT NULL,
140 p_token3 IN VARCHAR2 DEFAULT NULL,
141 p_token3_value IN VARCHAR2 DEFAULT NULL,
142 p_token4 IN VARCHAR2 DEFAULT NULL,
143 p_token4_value IN VARCHAR2 DEFAULT NULL,
144 p_token5 IN VARCHAR2 DEFAULT NULL,
145 p_token5_value IN VARCHAR2 DEFAULT NULL,
146 p_token6 IN VARCHAR2 DEFAULT NULL,
147 p_token6_value IN VARCHAR2 DEFAULT NULL,
148 p_token7 IN VARCHAR2 DEFAULT NULL,
149 p_token7_value IN VARCHAR2 DEFAULT NULL,
150 p_token8 IN VARCHAR2 DEFAULT NULL,
151 p_token8_value IN VARCHAR2 DEFAULT NULL,
152 p_token9 IN VARCHAR2 DEFAULT NULL,
153 p_token9_value IN VARCHAR2 DEFAULT NULL,
154 p_token10 IN VARCHAR2 DEFAULT NULL,
155 p_token10_value IN VARCHAR2 DEFAULT NULL
156 );
157
158 /****END: Section for common API messages, exception handling and logging.******
159 ********************************************************************************/
160
161 end FPA_Utilities_PVT;