eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PROJECT_PARTIES_PUB dependencies on FND_API

Line 5: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

1: package body PA_PROJECT_PARTIES_PUB as
2: /* $Header: PARPPPMB.pls 120.5.12010000.3 2009/09/08 07:25:19 anuragar ship $ */
3:
4: PROCEDURE CREATE_PROJECT_PARTY( p_api_version IN NUMBER := 1.0,
5: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
6: p_commit IN VARCHAR2 := FND_API.G_FALSE,
7: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
8: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
9: p_debug_mode IN VARCHAR2 default 'N',

Line 6: p_commit IN VARCHAR2 := FND_API.G_FALSE,

2: /* $Header: PARPPPMB.pls 120.5.12010000.3 2009/09/08 07:25:19 anuragar ship $ */
3:
4: PROCEDURE CREATE_PROJECT_PARTY( p_api_version IN NUMBER := 1.0,
5: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
6: p_commit IN VARCHAR2 := FND_API.G_FALSE,
7: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
8: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
9: p_debug_mode IN VARCHAR2 default 'N',
10: p_object_id IN NUMBER := FND_API.G_MISS_NUM,

Line 7: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,

3:
4: PROCEDURE CREATE_PROJECT_PARTY( p_api_version IN NUMBER := 1.0,
5: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
6: p_commit IN VARCHAR2 := FND_API.G_FALSE,
7: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
8: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
9: p_debug_mode IN VARCHAR2 default 'N',
10: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
11: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 8: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

4: PROCEDURE CREATE_PROJECT_PARTY( p_api_version IN NUMBER := 1.0,
5: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
6: p_commit IN VARCHAR2 := FND_API.G_FALSE,
7: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
8: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
9: p_debug_mode IN VARCHAR2 default 'N',
10: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
11: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
12: p_project_role_id IN NUMBER := FND_API.G_MISS_NUM,

Line 10: p_object_id IN NUMBER := FND_API.G_MISS_NUM,

6: p_commit IN VARCHAR2 := FND_API.G_FALSE,
7: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
8: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
9: p_debug_mode IN VARCHAR2 default 'N',
10: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
11: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
12: p_project_role_id IN NUMBER := FND_API.G_MISS_NUM,
13: p_project_role_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
14: p_resource_type_id IN NUMBER := 101, --EMPLOYEE

Line 11: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

7: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
8: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
9: p_debug_mode IN VARCHAR2 default 'N',
10: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
11: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
12: p_project_role_id IN NUMBER := FND_API.G_MISS_NUM,
13: p_project_role_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
14: p_resource_type_id IN NUMBER := 101, --EMPLOYEE
15: p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM,

Line 12: p_project_role_id IN NUMBER := FND_API.G_MISS_NUM,

8: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
9: p_debug_mode IN VARCHAR2 default 'N',
10: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
11: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
12: p_project_role_id IN NUMBER := FND_API.G_MISS_NUM,
13: p_project_role_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
14: p_resource_type_id IN NUMBER := 101, --EMPLOYEE
15: p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM,
16: p_resource_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 13: p_project_role_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

9: p_debug_mode IN VARCHAR2 default 'N',
10: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
11: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
12: p_project_role_id IN NUMBER := FND_API.G_MISS_NUM,
13: p_project_role_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
14: p_resource_type_id IN NUMBER := 101, --EMPLOYEE
15: p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM,
16: p_resource_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
17: p_start_date_active IN DATE := FND_API.G_MISS_DATE,

Line 15: p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM,

11: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
12: p_project_role_id IN NUMBER := FND_API.G_MISS_NUM,
13: p_project_role_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
14: p_resource_type_id IN NUMBER := 101, --EMPLOYEE
15: p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM,
16: p_resource_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
17: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
18: p_scheduled_flag IN VARCHAR2 := 'N',
19: p_calling_module IN VARCHAR2,

Line 16: p_resource_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

12: p_project_role_id IN NUMBER := FND_API.G_MISS_NUM,
13: p_project_role_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
14: p_resource_type_id IN NUMBER := 101, --EMPLOYEE
15: p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM,
16: p_resource_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
17: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
18: p_scheduled_flag IN VARCHAR2 := 'N',
19: p_calling_module IN VARCHAR2,
20: p_project_id IN NUMBER := FND_API.G_MISS_NUM,

Line 17: p_start_date_active IN DATE := FND_API.G_MISS_DATE,

13: p_project_role_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
14: p_resource_type_id IN NUMBER := 101, --EMPLOYEE
15: p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM,
16: p_resource_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
17: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
18: p_scheduled_flag IN VARCHAR2 := 'N',
19: p_calling_module IN VARCHAR2,
20: p_project_id IN NUMBER := FND_API.G_MISS_NUM,
21: p_project_end_date IN DATE := FND_API.G_MISS_DATE,

Line 20: p_project_id IN NUMBER := FND_API.G_MISS_NUM,

16: p_resource_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
17: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
18: p_scheduled_flag IN VARCHAR2 := 'N',
19: p_calling_module IN VARCHAR2,
20: p_project_id IN NUMBER := FND_API.G_MISS_NUM,
21: p_project_end_date IN DATE := FND_API.G_MISS_DATE,
22: p_mgr_validation_type IN VARCHAR2 default 'FORM',/*Added for bug 2111806*/
23: p_end_date_active IN OUT NOCOPY DATE, --File.Sql.39 bug 4440895
24: x_project_party_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 21: p_project_end_date IN DATE := FND_API.G_MISS_DATE,

17: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
18: p_scheduled_flag IN VARCHAR2 := 'N',
19: p_calling_module IN VARCHAR2,
20: p_project_id IN NUMBER := FND_API.G_MISS_NUM,
21: p_project_end_date IN DATE := FND_API.G_MISS_DATE,
22: p_mgr_validation_type IN VARCHAR2 default 'FORM',/*Added for bug 2111806*/
23: p_end_date_active IN OUT NOCOPY DATE, --File.Sql.39 bug 4440895
24: x_project_party_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
25: x_resource_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 66: if NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,

62: if (p_debug_mode = 'Y') then
63: pa_debug.debug('create_project_party: Checking the api version number.');
64: end if;
65:
66: if NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
67: l_api_name, 'PA_PROJECT_PARTIES_PUB') then
68: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
69: end if;
70:

Line 68: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

64: end if;
65:
66: if NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
67: l_api_name, 'PA_PROJECT_PARTIES_PUB') then
68: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
69: end if;
70:
71: ------dbms_output.put_line('Before initializing the stack');
72:

Line 80: if FND_API.to_boolean(nvl(p_init_msg_list,FND_API.G_TRUE)) then

76: pa_debug.debug('Create_project_party: Initializing message stack.');
77: end if;
78: pa_debug.init_err_stack('Create_project_party_pub');
79:
80: if FND_API.to_boolean(nvl(p_init_msg_list,FND_API.G_TRUE)) then
81: fnd_msg_pub.initialize;
82: end if;
83:
84: ------dbms_output.put_line('After initializing the stack');

Line 86: x_return_status := FND_API.G_RET_STS_SUCCESS;

82: end if;
83:
84: ------dbms_output.put_line('After initializing the stack');
85:
86: x_return_status := FND_API.G_RET_STS_SUCCESS;
87:
88: if p_project_role_id is null or p_project_role_id = FND_API.G_MISS_NUM then
89: l_project_role_id := pa_project_parties_utils.get_project_role_id(p_project_role_type,p_calling_module);
90: else

Line 88: if p_project_role_id is null or p_project_role_id = FND_API.G_MISS_NUM then

84: ------dbms_output.put_line('After initializing the stack');
85:
86: x_return_status := FND_API.G_RET_STS_SUCCESS;
87:
88: if p_project_role_id is null or p_project_role_id = FND_API.G_MISS_NUM then
89: l_project_role_id := pa_project_parties_utils.get_project_role_id(p_project_role_type,p_calling_module);
90: else
91: l_project_role_id := p_project_role_id;
92: end if;

Line 94: /* if p_resource_source_id is null or p_resource_source_id = FND_API.G_MISS_NUM then

90: else
91: l_project_role_id := p_project_role_id;
92: end if;
93: --dbms_output.put_line('Check2');
94: /* if p_resource_source_id is null or p_resource_source_id = FND_API.G_MISS_NUM then
95: l_resource_source_id := pa_project_parties_utils.get_resource_source_id(p_resource_name);
96: else
97: l_resource_source_id := p_resource_source_id;
98: end if; */

Line 101: if p_project_id is not null and p_project_id <> FND_API.G_MISS_NUM then

97: l_resource_source_id := p_resource_source_id;
98: end if; */
99:
100:
101: if p_project_id is not null and p_project_id <> FND_API.G_MISS_NUM then
102: PA_PROJECT_PARTIES_UTILS.GET_PROJECT_DATES(p_project_id => p_project_id,
103: x_project_start_date => l_project_start_date,
104: x_project_end_date => l_project_end_date,
105: x_return_status => x_return_status);

Line 108: if p_project_id is null or p_project_id = FND_API.G_MISS_NUM then

104: x_project_end_date => l_project_end_date,
105: x_return_status => x_return_status);
106: end if;
107: --dbms_output.put_line('Check3');
108: if p_project_id is null or p_project_id = FND_API.G_MISS_NUM then
109: l_project_id := null;
110: else
111: l_project_id := p_project_id;
112: end if;

Line 123: if p_project_id is not null and p_project_id <> FND_API.G_MISS_NUM then

119: -> If project has a future start date, key member start date should
120: default to the sysdate.
121: */
122:
123: if p_project_id is not null and p_project_id <> FND_API.G_MISS_NUM then
124: if l_project_start_date is not NULL THEN
125: if l_project_start_date <= trunc(sysdate) then
126: l_project_start_date := l_project_start_date;
127: else

Line 136: if p_start_date_active is null or p_start_date_active = FND_API.G_MISS_DATE then

132: end if;
133: end if;
134:
135: /* Following code commented to implement the new logic as mentioned above
136: if p_start_date_active is null or p_start_date_active = FND_API.G_MISS_DATE then
137: l_start_date_active := trunc(sysdate);
138: else
139: l_start_date_active := p_start_date_active;
140: end if;

Line 143: /* if p_resource_source_id is null or p_resource_source_id = FND_API.G_MISS_NUM then

139: l_start_date_active := p_start_date_active;
140: end if;
141: */
142:
143: /* if p_resource_source_id is null or p_resource_source_id = FND_API.G_MISS_NUM then
144: l_resource_source_id := pa_project_parties_utils.get_resource_source_id(p_resource_name);
145: else
146: l_resource_source_id := p_resource_source_id;
147: end if; */

Line 150: /*if p_start_date_active is null or p_start_date_active = FND_API.G_MISS_DATE then

146: l_resource_source_id := p_resource_source_id;
147: end if; */
148:
149: /* Commented the code for the bug 2686120*/
150: /*if p_start_date_active is null or p_start_date_active = FND_API.G_MISS_DATE then
151: l_start_date_active := l_project_start_date;
152: else
153: l_start_date_active := p_start_date_active;
154: end if;*/

Line 164: p_start_date_active = FND_API.G_MISS_DATE

160:
161: /*Commented the below code for the bug 2910972*/
162:
163: /*IF p_start_date_active is null OR
164: p_start_date_active = FND_API.G_MISS_DATE
165: THEN
166: IF l_key_member_start_date > sysdate THEN
167: l_start_date_active := l_key_member_start_date;
168: ELSE

Line 178: p_start_date_active = FND_API.G_MISS_DATE

174:
175: /*Added the below code for the bug 2910972*/
176:
177: IF p_start_date_active is null OR
178: p_start_date_active = FND_API.G_MISS_DATE
179: THEN
180: IF l_key_member_start_date > sysdate THEN
181: l_start_date_active := l_key_member_start_date;
182: ELSE

Line 200: IF l_project_role_id <> -999 AND x_return_status = FND_API.G_RET_STS_SUCCESS THEN

196: /* Bug 2636791 - changes for add organization start date.
197: On adding a new organization to a project
198: start date should be sysdate*/
199: /* Bug 3116962 : Added a IF clause to check if the project_role_id is valid or not. Accordingly the SELECT statement below will execute. */
200: IF l_project_role_id <> -999 AND x_return_status = FND_API.G_RET_STS_SUCCESS THEN
201: SELECT resource_type_id into x_resource_type_id
202: FROM pa_resource_types
203: WHERE resource_type_code='HZ_PARTY';
204:

Line 247: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

243: ,x_return_status => x_return_status
244: ,x_error_message_code => l_error_message_code)
245: ;
246:
247: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
248: fnd_message.set_name('PA',l_error_message_code);
249: fnd_msg_pub.add;
250: end if;
251:

Line 255: if l_project_role_id <> -999 and l_resource_source_id <> -999 and x_return_status = FND_API.G_RET_STS_SUCCESS then

251:
252: --dbms_output.put_line('Check5 role_id='||l_project_role_id||', resource_source_id='||l_resource_source_id);
253: -- dbms_output.put_line('Return Status '||x_return_status);
254:
255: if l_project_role_id <> -999 and l_resource_source_id <> -999 and x_return_status = FND_API.G_RET_STS_SUCCESS then
256: --dbms_output.put_line('Check6');
257: PA_PROJECT_PARTIES_PVT.CREATE_PROJECT_PARTY( p_commit => p_commit,
258: p_validate_only => p_validate_only,
259: p_validation_level => p_validation_level,

Line 283: x_return_status := FND_API.G_RET_STS_ERROR;

279: x_return_status => x_return_status,
280: x_msg_count => x_msg_count,
281: x_msg_data => x_msg_data);
282: else
283: x_return_status := FND_API.G_RET_STS_ERROR;
284: end if;
285:
286: fnd_msg_pub.count_and_get(p_count => x_msg_count,
287: p_data => x_msg_data);

Line 291: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE

287: p_data => x_msg_data);
288: --dbms_output.put_line('Check7');
289: IF x_msg_count = 1 THEN
290: --dbms_output.put_line('Check8');
291: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
292: ,p_msg_index => 1
293: ,p_data => x_msg_data
294: ,p_msg_index_out => l_msg_index_out
295: );

Line 301: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

297: --dbms_output.put_line('Check9');
298: pa_debug.reset_err_stack;
299:
300: EXCEPTION
301: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
302: --dbms_output.put_line('Check10');
303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
304: fnd_message.set_name('PA','PA_UNEXPECTED_ERROR');
305: fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_PUB');

Line 303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

299:
300: EXCEPTION
301: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
302: --dbms_output.put_line('Check10');
303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
304: fnd_message.set_name('PA','PA_UNEXPECTED_ERROR');
305: fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_PUB');
306: fnd_message.set_token('PROCEDURE_NAME','CREATE_PROJECT_PARTY');
307: fnd_msg_pub.add();

Line 314: x_return_status := fnd_api.g_ret_sts_error;

310: raise;
311:
312: WHEN OTHERS THEN
313: rollback to create_project_party;
314: x_return_status := fnd_api.g_ret_sts_error;
315: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PARTIES_PUB',
316: p_procedure_name => pa_debug.G_err_stack,
317: p_error_text => SUBSTRB(SQLERRM,1,240));
318: raise;

Line 323: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

319:
320: END CREATE_PROJECT_PARTY;
321:
322: PROCEDURE UPDATE_PROJECT_PARTY( p_api_version IN NUMBER := 1.0,
323: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
324: p_commit IN VARCHAR2 := FND_API.G_FALSE,
325: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
326: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
327: p_debug_mode IN VARCHAR2 default 'N',

Line 324: p_commit IN VARCHAR2 := FND_API.G_FALSE,

320: END CREATE_PROJECT_PARTY;
321:
322: PROCEDURE UPDATE_PROJECT_PARTY( p_api_version IN NUMBER := 1.0,
323: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
324: p_commit IN VARCHAR2 := FND_API.G_FALSE,
325: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
326: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
327: p_debug_mode IN VARCHAR2 default 'N',
328: p_object_id IN NUMBER := FND_API.G_MISS_NUM,

Line 325: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,

321:
322: PROCEDURE UPDATE_PROJECT_PARTY( p_api_version IN NUMBER := 1.0,
323: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
324: p_commit IN VARCHAR2 := FND_API.G_FALSE,
325: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
326: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
327: p_debug_mode IN VARCHAR2 default 'N',
328: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
329: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 326: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

322: PROCEDURE UPDATE_PROJECT_PARTY( p_api_version IN NUMBER := 1.0,
323: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
324: p_commit IN VARCHAR2 := FND_API.G_FALSE,
325: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
326: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
327: p_debug_mode IN VARCHAR2 default 'N',
328: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
329: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
330: p_project_role_id IN NUMBER,

Line 328: p_object_id IN NUMBER := FND_API.G_MISS_NUM,

324: p_commit IN VARCHAR2 := FND_API.G_FALSE,
325: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
326: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
327: p_debug_mode IN VARCHAR2 default 'N',
328: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
329: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
330: p_project_role_id IN NUMBER,
331: p_project_role_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
332: p_resource_type_id IN NUMBER := 101, --EMPLOYEE

Line 329: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

325: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
326: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
327: p_debug_mode IN VARCHAR2 default 'N',
328: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
329: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
330: p_project_role_id IN NUMBER,
331: p_project_role_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
332: p_resource_type_id IN NUMBER := 101, --EMPLOYEE
333: p_resource_source_id IN NUMBER,

Line 331: p_project_role_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

327: p_debug_mode IN VARCHAR2 default 'N',
328: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
329: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
330: p_project_role_id IN NUMBER,
331: p_project_role_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
332: p_resource_type_id IN NUMBER := 101, --EMPLOYEE
333: p_resource_source_id IN NUMBER,
334: p_resource_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
335: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,

Line 334: p_resource_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

330: p_project_role_id IN NUMBER,
331: p_project_role_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
332: p_resource_type_id IN NUMBER := 101, --EMPLOYEE
333: p_resource_source_id IN NUMBER,
334: p_resource_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
335: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
336: p_start_date_active IN DATE,
337: p_scheduled_flag IN VARCHAR2 := 'N',
338: p_record_version_number IN NUMBER := FND_API.G_MISS_NUM,

Line 335: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,

331: p_project_role_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
332: p_resource_type_id IN NUMBER := 101, --EMPLOYEE
333: p_resource_source_id IN NUMBER,
334: p_resource_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
335: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
336: p_start_date_active IN DATE,
337: p_scheduled_flag IN VARCHAR2 := 'N',
338: p_record_version_number IN NUMBER := FND_API.G_MISS_NUM,
339: p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 338: p_record_version_number IN NUMBER := FND_API.G_MISS_NUM,

334: p_resource_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
335: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
336: p_start_date_active IN DATE,
337: p_scheduled_flag IN VARCHAR2 := 'N',
338: p_record_version_number IN NUMBER := FND_API.G_MISS_NUM,
339: p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR,
340: p_project_id IN NUMBER := FND_API.G_MISS_NUM,
341: p_project_end_date IN DATE := FND_API.G_MISS_DATE,
342: p_project_party_id IN NUMBER,

Line 339: p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR,

335: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
336: p_start_date_active IN DATE,
337: p_scheduled_flag IN VARCHAR2 := 'N',
338: p_record_version_number IN NUMBER := FND_API.G_MISS_NUM,
339: p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR,
340: p_project_id IN NUMBER := FND_API.G_MISS_NUM,
341: p_project_end_date IN DATE := FND_API.G_MISS_DATE,
342: p_project_party_id IN NUMBER,
343: p_assignment_id IN NUMBER := 0,

Line 340: p_project_id IN NUMBER := FND_API.G_MISS_NUM,

336: p_start_date_active IN DATE,
337: p_scheduled_flag IN VARCHAR2 := 'N',
338: p_record_version_number IN NUMBER := FND_API.G_MISS_NUM,
339: p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR,
340: p_project_id IN NUMBER := FND_API.G_MISS_NUM,
341: p_project_end_date IN DATE := FND_API.G_MISS_DATE,
342: p_project_party_id IN NUMBER,
343: p_assignment_id IN NUMBER := 0,
344: p_assign_record_version_number IN NUMBER := 0,

Line 341: p_project_end_date IN DATE := FND_API.G_MISS_DATE,

337: p_scheduled_flag IN VARCHAR2 := 'N',
338: p_record_version_number IN NUMBER := FND_API.G_MISS_NUM,
339: p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR,
340: p_project_id IN NUMBER := FND_API.G_MISS_NUM,
341: p_project_end_date IN DATE := FND_API.G_MISS_DATE,
342: p_project_party_id IN NUMBER,
343: p_assignment_id IN NUMBER := 0,
344: p_assign_record_version_number IN NUMBER := 0,
345: p_mgr_validation_type IN VARCHAR2 default 'FORM',/*Added for bug 2111806*/

Line 379: if NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,

375: if (p_debug_mode = 'Y') then
376: pa_debug.debug('Update_project_party: Checking he api version number.');
377: end if;
378:
379: if NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
380: l_api_name, 'PA_PROJECT_PARTIES_PUB') then
381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
382: end if;
383:

Line 381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

377: end if;
378:
379: if NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
380: l_api_name, 'PA_PROJECT_PARTIES_PUB') then
381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
382: end if;
383:
384: ------dbms_output.put_line('Before initializing the stack');
385: pa_debug.init_err_stack('Update_project_party_pub');

Line 393: if FND_API.to_boolean(nvl(p_init_msg_list,FND_API.G_TRUE)) then

389: if (p_debug_mode = 'Y') then
390: pa_debug.debug('Update_project_party: Initializing message stack.');
391: end if;
392:
393: if FND_API.to_boolean(nvl(p_init_msg_list,FND_API.G_TRUE)) then
394: fnd_msg_pub.initialize;
395: end if;
396:
397: ------dbms_output.put_line('After initializing the stack');

Line 399: x_return_status := FND_API.G_RET_STS_SUCCESS;

395: end if;
396:
397: ------dbms_output.put_line('After initializing the stack');
398:
399: x_return_status := FND_API.G_RET_STS_SUCCESS;
400:
401: if p_project_role_id is null or p_project_role_id = FND_API.G_MISS_NUM then
402: l_project_role_id := pa_project_parties_utils.get_project_role_id(p_project_role_type,p_calling_module);
403: else

Line 401: if p_project_role_id is null or p_project_role_id = FND_API.G_MISS_NUM then

397: ------dbms_output.put_line('After initializing the stack');
398:
399: x_return_status := FND_API.G_RET_STS_SUCCESS;
400:
401: if p_project_role_id is null or p_project_role_id = FND_API.G_MISS_NUM then
402: l_project_role_id := pa_project_parties_utils.get_project_role_id(p_project_role_type,p_calling_module);
403: else
404: l_project_role_id := p_project_role_id;
405: end if;

Line 407: /* if p_resource_source_id is null or p_resource_source_id = FND_API.G_MISS_NUM then

403: else
404: l_project_role_id := p_project_role_id;
405: end if;
406:
407: /* if p_resource_source_id is null or p_resource_source_id = FND_API.G_MISS_NUM then
408: l_resource_source_id := pa_project_parties_utils.get_resource_source_id(p_resource_name);
409: else
410: l_resource_source_id := p_resource_source_id;
411: end if; */

Line 413: if p_project_id is not null and p_project_id <> FND_API.G_MISS_NUM then

409: else
410: l_resource_source_id := p_resource_source_id;
411: end if; */
412:
413: if p_project_id is not null and p_project_id <> FND_API.G_MISS_NUM then
414: PA_PROJECT_PARTIES_UTILS.GET_PROJECT_DATES(p_project_id => p_project_id,
415: x_project_start_date => l_project_start_date,
416: x_project_end_date => l_project_end_date,
417: x_return_status => x_return_status);

Line 420: if p_project_id is null or p_project_id = FND_API.G_MISS_NUM then

416: x_project_end_date => l_project_end_date,
417: x_return_status => x_return_status);
418: end if;
419:
420: if p_project_id is null or p_project_id = FND_API.G_MISS_NUM then
421: l_project_id := null;
422: else
423: l_project_id := p_project_id;
424: end if;

Line 427: if p_start_date_active is null or p_start_date_active = FND_API.G_MISS_DATE then

423: l_project_id := p_project_id;
424: end if;
425:
426:
427: if p_start_date_active is null or p_start_date_active = FND_API.G_MISS_DATE then
428: --- if l_project_start_date is not null then
429: --- l_start_date_active := l_project_start_date;
430: --- else
431: l_start_date_active := trunc(sysdate);

Line 457: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

453: ,x_resource_type_id => l_resource_type_id
454: ,x_return_status => x_return_status
455: ,x_error_message_code => l_error_message_code);
456:
457: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
458: fnd_message.set_name('PA',l_error_message_code);
459: fnd_msg_pub.add;
460: end if;
461:

Line 462: if l_project_role_id <> -999 and l_resource_source_id <> -999 and x_return_status = FND_API.G_RET_STS_SUCCESS then

458: fnd_message.set_name('PA',l_error_message_code);
459: fnd_msg_pub.add;
460: end if;
461:
462: if l_project_role_id <> -999 and l_resource_source_id <> -999 and x_return_status = FND_API.G_RET_STS_SUCCESS then
463: PA_PROJECT_PARTIES_PVT.UPDATE_PROJECT_PARTY( p_commit => p_commit,
464: p_validate_only => p_validate_only,
465: p_validation_level => p_validation_level,
466: p_debug_mode => p_debug_mode,

Line 492: x_return_status := FND_API.G_RET_STS_ERROR;

488: x_return_status => x_return_status,
489: x_msg_count => x_msg_count,
490: x_msg_data => x_msg_data);
491: else
492: x_return_status := FND_API.G_RET_STS_ERROR;
493: end if;
494:
495: fnd_msg_pub.count_and_get(p_count => x_msg_count,
496: p_data => x_msg_data);

Line 499: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE

495: fnd_msg_pub.count_and_get(p_count => x_msg_count,
496: p_data => x_msg_data);
497:
498: IF x_msg_count = 1 THEN
499: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
500: ,p_msg_index => 1
501: ,p_data => x_msg_data
502: ,p_msg_index_out => l_msg_index_out
503: );

Line 509: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

505:
506: pa_debug.reset_err_stack;
507:
508: EXCEPTION
509: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
511: fnd_message.set_name('PA','PA_UNEXPECTED_ERROR');
512: fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_PUB');
513: fnd_message.set_token('PROCEDURE_NAME','UPDATE_PROJECT_PARTY');

Line 510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

506: pa_debug.reset_err_stack;
507:
508: EXCEPTION
509: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
511: fnd_message.set_name('PA','PA_UNEXPECTED_ERROR');
512: fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_PUB');
513: fnd_message.set_token('PROCEDURE_NAME','UPDATE_PROJECT_PARTY');
514: fnd_msg_pub.add();

Line 522: x_return_status := fnd_api.g_ret_sts_error;

518:
519:
520: WHEN OTHERS THEN
521: rollback to update_project_party;
522: x_return_status := fnd_api.g_ret_sts_error;
523: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PARTIES_PUB',
524: p_procedure_name => pa_debug.g_err_stack,
525: p_error_text => SUBSTRB(SQLERRM,1,240));
526: raise;

Line 532: /* modified the default value for p_init_msg_list from FND_API.G_TRUE to FND_API.G_FALSE, for

528: end update_project_party;
529:
530:
531: PROCEDURE DELETE_PROJECT_PARTY( p_api_version IN NUMBER := 1.0,
532: /* modified the default value for p_init_msg_list from FND_API.G_TRUE to FND_API.G_FALSE, for
533: the bug#1851096 */
534: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
535: p_commit IN VARCHAR2 := FND_API.G_FALSE,
536: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,

Line 534: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

530:
531: PROCEDURE DELETE_PROJECT_PARTY( p_api_version IN NUMBER := 1.0,
532: /* modified the default value for p_init_msg_list from FND_API.G_TRUE to FND_API.G_FALSE, for
533: the bug#1851096 */
534: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
535: p_commit IN VARCHAR2 := FND_API.G_FALSE,
536: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
537: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
538: p_debug_mode IN VARCHAR2 default 'N',

Line 535: p_commit IN VARCHAR2 := FND_API.G_FALSE,

531: PROCEDURE DELETE_PROJECT_PARTY( p_api_version IN NUMBER := 1.0,
532: /* modified the default value for p_init_msg_list from FND_API.G_TRUE to FND_API.G_FALSE, for
533: the bug#1851096 */
534: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
535: p_commit IN VARCHAR2 := FND_API.G_FALSE,
536: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
537: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
538: p_debug_mode IN VARCHAR2 default 'N',
539: p_record_version_number IN NUMBER := FND_API.G_MISS_NUM,

Line 536: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,

532: /* modified the default value for p_init_msg_list from FND_API.G_TRUE to FND_API.G_FALSE, for
533: the bug#1851096 */
534: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
535: p_commit IN VARCHAR2 := FND_API.G_FALSE,
536: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
537: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
538: p_debug_mode IN VARCHAR2 default 'N',
539: p_record_version_number IN NUMBER := FND_API.G_MISS_NUM,
540: p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 537: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

533: the bug#1851096 */
534: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
535: p_commit IN VARCHAR2 := FND_API.G_FALSE,
536: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
537: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
538: p_debug_mode IN VARCHAR2 default 'N',
539: p_record_version_number IN NUMBER := FND_API.G_MISS_NUM,
540: p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR,
541: p_project_id IN NUMBER := FND_API.G_MISS_NUM,

Line 539: p_record_version_number IN NUMBER := FND_API.G_MISS_NUM,

535: p_commit IN VARCHAR2 := FND_API.G_FALSE,
536: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
537: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
538: p_debug_mode IN VARCHAR2 default 'N',
539: p_record_version_number IN NUMBER := FND_API.G_MISS_NUM,
540: p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR,
541: p_project_id IN NUMBER := FND_API.G_MISS_NUM,
542: p_project_party_id IN NUMBER := FND_API.G_MISS_NUM,
543: p_scheduled_flag IN VARCHAR2 default 'N',

Line 540: p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR,

536: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
537: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
538: p_debug_mode IN VARCHAR2 default 'N',
539: p_record_version_number IN NUMBER := FND_API.G_MISS_NUM,
540: p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR,
541: p_project_id IN NUMBER := FND_API.G_MISS_NUM,
542: p_project_party_id IN NUMBER := FND_API.G_MISS_NUM,
543: p_scheduled_flag IN VARCHAR2 default 'N',
544: p_assignment_id IN NUMBER := 0,

Line 541: p_project_id IN NUMBER := FND_API.G_MISS_NUM,

537: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
538: p_debug_mode IN VARCHAR2 default 'N',
539: p_record_version_number IN NUMBER := FND_API.G_MISS_NUM,
540: p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR,
541: p_project_id IN NUMBER := FND_API.G_MISS_NUM,
542: p_project_party_id IN NUMBER := FND_API.G_MISS_NUM,
543: p_scheduled_flag IN VARCHAR2 default 'N',
544: p_assignment_id IN NUMBER := 0,
545: p_assign_record_version_number IN NUMBER := 0,

Line 542: p_project_party_id IN NUMBER := FND_API.G_MISS_NUM,

538: p_debug_mode IN VARCHAR2 default 'N',
539: p_record_version_number IN NUMBER := FND_API.G_MISS_NUM,
540: p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR,
541: p_project_id IN NUMBER := FND_API.G_MISS_NUM,
542: p_project_party_id IN NUMBER := FND_API.G_MISS_NUM,
543: p_scheduled_flag IN VARCHAR2 default 'N',
544: p_assignment_id IN NUMBER := 0,
545: p_assign_record_version_number IN NUMBER := 0,
546: p_mgr_validation_type IN VARCHAR2 default 'FORM',/*Added for bug 2111806*/

Line 572: if NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,

568: if (p_debug_mode = 'Y') then
569: pa_debug.debug('Delete_project_party: Checking he api version number.');
570: end if;
571:
572: if NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
573: l_api_name, 'PA_PROJECT_PARTIES_PUB') then
574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
575: end if;
576:

Line 574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

570: end if;
571:
572: if NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
573: l_api_name, 'PA_PROJECT_PARTIES_PUB') then
574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
575: end if;
576:
577: ------dbms_output.put_line('Before initializing the stack');
578: pa_debug.init_err_stack('Delete_project_party_pub');

Line 586: if FND_API.to_boolean(nvl(p_init_msg_list,fnd_api.G_TRUE)) then

582: if (p_debug_mode = 'Y') then
583: pa_debug.debug('Delete_project_party: Initializing message stack.');
584: end if;
585:
586: if FND_API.to_boolean(nvl(p_init_msg_list,fnd_api.G_TRUE)) then
587: fnd_msg_pub.initialize;
588: end if;
589:
590: ------dbms_output.put_line('After initializing the stack');

Line 593: x_return_status := FND_API.G_RET_STS_SUCCESS;

589:
590: ------dbms_output.put_line('After initializing the stack');
591:
592:
593: x_return_status := FND_API.G_RET_STS_SUCCESS;
594: --changes for 8726175 starts
595: open task_cnt_crsr;
596: fetch task_cnt_crsr into l_task_cnt;
597: if l_task_cnt > 0

Line 603: x_return_status := FND_API.G_RET_STS_ERROR;

599: FND_MESSAGE.Set_Name('PA', 'PA_PARTY_PROGR_TASK');
600: fnd_msg_pub.add();
601: fnd_msg_pub.count_and_get(p_count => x_msg_count,
602: p_data => x_msg_data);
603: x_return_status := FND_API.G_RET_STS_ERROR;
604:
605: else
606: if (p_debug_mode = 'Y') then
607: pa_debug.debug('Delete_project_party : Before delete from pa_project_players ');

Line 617: ,p_validate_only => FND_API.G_FALSE

613: ( p_assignment_id => p_assignment_id
614: ,p_assignment_type => 'STAFFED_ASSIGNMENT'
615: ,p_record_version_number => p_assign_record_version_number
616: ,p_commit => p_commit
617: ,p_validate_only => FND_API.G_FALSE
618: ,p_init_msg_list => FND_API.G_TRUE
619: ,x_return_status => x_return_status
620: ,x_msg_count => x_msg_count
621: ,x_msg_data => x_msg_data

Line 618: ,p_init_msg_list => FND_API.G_TRUE

614: ,p_assignment_type => 'STAFFED_ASSIGNMENT'
615: ,p_record_version_number => p_assign_record_version_number
616: ,p_commit => p_commit
617: ,p_validate_only => FND_API.G_FALSE
618: ,p_init_msg_list => FND_API.G_TRUE
619: ,x_return_status => x_return_status
620: ,x_msg_count => x_msg_count
621: ,x_msg_data => x_msg_data
622: );

Line 645: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE

641: fnd_msg_pub.count_and_get(p_count => x_msg_count,
642: p_data => x_msg_data);
643:
644: IF x_msg_count = 1 THEN
645: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
646: ,p_msg_index => 1
647: ,p_data => x_msg_data
648: ,p_msg_index_out => l_msg_index_out
649: );

Line 657: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

653: pa_debug.reset_err_stack;
654:
655: EXCEPTION
656:
657: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
659: fnd_message.set_name('PA','PA_UNEXPECTED_ERROR');
660: fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_PUB');
661: fnd_message.set_token('PROCEDURE_NAME','DELETE_PROJECT_PARTY');

Line 658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

654:
655: EXCEPTION
656:
657: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
659: fnd_message.set_name('PA','PA_UNEXPECTED_ERROR');
660: fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_PUB');
661: fnd_message.set_token('PROCEDURE_NAME','DELETE_PROJECT_PARTY');
662: fnd_msg_pub.add();

Line 674: x_return_status := FND_API.G_RET_STS_ERROR;

670: pa_debug.debug('Delete_project_party : Exception NO_DATA_FOUND ');
671: end if;
672:
673: fnd_message.set_name('PA', 'PA_XC_NO_DATA_FOUND');
674: x_return_status := FND_API.G_RET_STS_ERROR;
675:
676: WHEN OTHERS then
677:
678: if (p_debug_mode = 'Y') then

Line 688: x_return_status := FND_API.G_RET_STS_ERROR;

684: FND_MESSAGE.Set_token('ENTITY', 'PA_PROJECT_PARTIES');
685: FND_MESSAGE.Set_token('PROJECT',to_char(P_PROJECT_ID));
686: FND_MESSAGE.Set_token('TASK',NULL);
687: x_msg_data := FND_MESSAGE.get;
688: x_return_status := FND_API.G_RET_STS_ERROR;
689: else
690: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PARTIES_PUB',
691: p_procedure_name => pa_debug.g_err_stack,
692: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 693: x_return_status := FND_API.G_RET_STS_ERROR;

689: else
690: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PARTIES_PUB',
691: p_procedure_name => pa_debug.g_err_stack,
692: p_error_text => SUBSTRB(SQLERRM,1,240));
693: x_return_status := FND_API.G_RET_STS_ERROR;
694: end if;
695:
696: END DELETE_PROJECT_PARTY;
697:

Line 781: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

777: This api is used as a wrapper API to CREATE_PROJECT_PARTY
778: ==============================================================================*/
779:
780: PROCEDURE CREATE_PROJECT_PARTY_WRP( p_api_version IN NUMBER := 1.0,
781: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
782: p_commit IN VARCHAR2 := FND_API.G_FALSE,
783: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
784: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
785: p_debug_mode IN VARCHAR2 default 'N',

Line 782: p_commit IN VARCHAR2 := FND_API.G_FALSE,

778: ==============================================================================*/
779:
780: PROCEDURE CREATE_PROJECT_PARTY_WRP( p_api_version IN NUMBER := 1.0,
781: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
782: p_commit IN VARCHAR2 := FND_API.G_FALSE,
783: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
784: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
785: p_debug_mode IN VARCHAR2 default 'N',
786: p_object_id IN NUMBER := FND_API.G_MISS_NUM,

Line 783: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,

779:
780: PROCEDURE CREATE_PROJECT_PARTY_WRP( p_api_version IN NUMBER := 1.0,
781: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
782: p_commit IN VARCHAR2 := FND_API.G_FALSE,
783: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
784: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
785: p_debug_mode IN VARCHAR2 default 'N',
786: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
787: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 784: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

780: PROCEDURE CREATE_PROJECT_PARTY_WRP( p_api_version IN NUMBER := 1.0,
781: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
782: p_commit IN VARCHAR2 := FND_API.G_FALSE,
783: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
784: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
785: p_debug_mode IN VARCHAR2 default 'N',
786: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
787: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
788: p_project_role_id IN NUMBER := FND_API.G_MISS_NUM,

Line 786: p_object_id IN NUMBER := FND_API.G_MISS_NUM,

782: p_commit IN VARCHAR2 := FND_API.G_FALSE,
783: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
784: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
785: p_debug_mode IN VARCHAR2 default 'N',
786: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
787: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
788: p_project_role_id IN NUMBER := FND_API.G_MISS_NUM,
789: p_project_role_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
790: p_resource_type_id IN NUMBER := 101, --EMPLOYEE

Line 787: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

783: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
784: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
785: p_debug_mode IN VARCHAR2 default 'N',
786: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
787: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
788: p_project_role_id IN NUMBER := FND_API.G_MISS_NUM,
789: p_project_role_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
790: p_resource_type_id IN NUMBER := 101, --EMPLOYEE
791: p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM,

Line 788: p_project_role_id IN NUMBER := FND_API.G_MISS_NUM,

784: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
785: p_debug_mode IN VARCHAR2 default 'N',
786: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
787: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
788: p_project_role_id IN NUMBER := FND_API.G_MISS_NUM,
789: p_project_role_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
790: p_resource_type_id IN NUMBER := 101, --EMPLOYEE
791: p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM,
792: p_resource_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 789: p_project_role_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

785: p_debug_mode IN VARCHAR2 default 'N',
786: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
787: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
788: p_project_role_id IN NUMBER := FND_API.G_MISS_NUM,
789: p_project_role_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
790: p_resource_type_id IN NUMBER := 101, --EMPLOYEE
791: p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM,
792: p_resource_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
793: p_start_date_active IN DATE := FND_API.G_MISS_DATE,/*Added for bug2774759*/

Line 791: p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM,

787: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
788: p_project_role_id IN NUMBER := FND_API.G_MISS_NUM,
789: p_project_role_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
790: p_resource_type_id IN NUMBER := 101, --EMPLOYEE
791: p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM,
792: p_resource_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
793: p_start_date_active IN DATE := FND_API.G_MISS_DATE,/*Added for bug2774759*/
794: p_scheduled_flag IN VARCHAR2 := 'N',
795: p_calling_module IN VARCHAR2,

Line 792: p_resource_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

788: p_project_role_id IN NUMBER := FND_API.G_MISS_NUM,
789: p_project_role_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
790: p_resource_type_id IN NUMBER := 101, --EMPLOYEE
791: p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM,
792: p_resource_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
793: p_start_date_active IN DATE := FND_API.G_MISS_DATE,/*Added for bug2774759*/
794: p_scheduled_flag IN VARCHAR2 := 'N',
795: p_calling_module IN VARCHAR2,
796: p_project_id IN NUMBER := FND_API.G_MISS_NUM,

Line 793: p_start_date_active IN DATE := FND_API.G_MISS_DATE,/Added for bug2774759/

789: p_project_role_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
790: p_resource_type_id IN NUMBER := 101, --EMPLOYEE
791: p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM,
792: p_resource_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
793: p_start_date_active IN DATE := FND_API.G_MISS_DATE,/*Added for bug2774759*/
794: p_scheduled_flag IN VARCHAR2 := 'N',
795: p_calling_module IN VARCHAR2,
796: p_project_id IN NUMBER := FND_API.G_MISS_NUM,
797: p_project_end_date IN DATE := FND_API.G_MISS_DATE,

Line 796: p_project_id IN NUMBER := FND_API.G_MISS_NUM,

792: p_resource_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
793: p_start_date_active IN DATE := FND_API.G_MISS_DATE,/*Added for bug2774759*/
794: p_scheduled_flag IN VARCHAR2 := 'N',
795: p_calling_module IN VARCHAR2,
796: p_project_id IN NUMBER := FND_API.G_MISS_NUM,
797: p_project_end_date IN DATE := FND_API.G_MISS_DATE,
798: p_mgr_validation_type IN VARCHAR2 default 'FORM',/*Added for bug 2111806*/
799: p_end_date_active IN OUT NOCOPY DATE,
800: x_project_party_id OUT NOCOPY NUMBER,

Line 797: p_project_end_date IN DATE := FND_API.G_MISS_DATE,

793: p_start_date_active IN DATE := FND_API.G_MISS_DATE,/*Added for bug2774759*/
794: p_scheduled_flag IN VARCHAR2 := 'N',
795: p_calling_module IN VARCHAR2,
796: p_project_id IN NUMBER := FND_API.G_MISS_NUM,
797: p_project_end_date IN DATE := FND_API.G_MISS_DATE,
798: p_mgr_validation_type IN VARCHAR2 default 'FORM',/*Added for bug 2111806*/
799: p_end_date_active IN OUT NOCOPY DATE,
800: x_project_party_id OUT NOCOPY NUMBER,
801: x_resource_id OUT NOCOPY NUMBER,

Line 837: x_return_status := FND_API.G_RET_STS_SUCCESS;

833: IF l_debug_mode = 'Y' THEN
834: pa_debug.set_curr_function( p_function => 'CREATE_PROJECT_PARTY_WRP'
835: ,p_debug_mode => l_debug_mode);
836: END IF;
837: x_return_status := FND_API.G_RET_STS_SUCCESS;
838: x_msg_count := 0;
839:
840: /* get the project_role_id */
841: if p_project_role_id is null or p_project_role_id = FND_API.G_MISS_NUM then

Line 841: if p_project_role_id is null or p_project_role_id = FND_API.G_MISS_NUM then

837: x_return_status := FND_API.G_RET_STS_SUCCESS;
838: x_msg_count := 0;
839:
840: /* get the project_role_id */
841: if p_project_role_id is null or p_project_role_id = FND_API.G_MISS_NUM then
842: l_project_role_id := pa_project_parties_utils.get_project_role_id(p_project_role_type,p_calling_module);
843: else
844: l_project_role_id := p_project_role_id;
845: end if;

Line 873: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

869: ,p_start_date => p_start_date_active
870: ,p_end_date => p_end_date_active
871: ,p_return_status => x_return_status);
872:
873: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
874: RAISE FND_API.G_EXC_ERROR;
875: END IF;
876: End If; --If project_role_id = 1
877: /* calling CREATE_PROJECT_PARTY unconditionally for all the key members

Line 874: RAISE FND_API.G_EXC_ERROR;

870: ,p_end_date => p_end_date_active
871: ,p_return_status => x_return_status);
872:
873: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
874: RAISE FND_API.G_EXC_ERROR;
875: END IF;
876: End If; --If project_role_id = 1
877: /* calling CREATE_PROJECT_PARTY unconditionally for all the key members
878: This flow is similar to AMG API. Instead of calling add_key_members , we

Line 907: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) Then

903: , x_return_status => x_return_status -- x_return_status
904: , x_msg_count => x_msg_count -- x_msg_count
905: , x_msg_data => x_msg_data -- x_msg_data
906: );
907: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) Then
908: x_return_status := x_return_status;
909: x_msg_count := x_msg_count;
910: raise FND_API.G_EXC_ERROR;
911: END IF;

Line 910: raise FND_API.G_EXC_ERROR;

906: );
907: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) Then
908: x_return_status := x_return_status;
909: x_msg_count := x_msg_count;
910: raise FND_API.G_EXC_ERROR;
911: END IF;
912: /* end if call create_project_party */
913: IF l_debug_mode = 'Y' THEN
914: PA_DEBUG.Reset_Curr_Function;

Line 918: WHEN FND_API.G_EXC_ERROR

914: PA_DEBUG.Reset_Curr_Function;
915: END IF;
916:
917: EXCEPTION
918: WHEN FND_API.G_EXC_ERROR
919: THEN
920: rollback to create_project_party_wrp;
921:
922: --setting all the OUT and IN OUT parameters to null

Line 923: x_return_status := FND_API.G_RET_STS_ERROR;

919: THEN
920: rollback to create_project_party_wrp;
921:
922: --setting all the OUT and IN OUT parameters to null
923: x_return_status := FND_API.G_RET_STS_ERROR;
924: p_end_date_active := null;
925: x_project_party_id := null;
926: x_resource_id := null;
927: x_assignment_id := null;

Line 937: ( p_encoded => Fnd_Api.G_TRUE

933:
934: IF x_msg_count = 1 AND x_msg_data IS NULL
935: THEN
936: Pa_Interface_Utils_Pub.get_messages
937: ( p_encoded => Fnd_Api.G_TRUE
938: , p_msg_index => 1
939: , p_msg_count => x_msg_count
940: , p_msg_data => l_msg_data
941: , p_data => l_data

Line 949: x_return_status := fnd_api.g_ret_sts_unexp_error;

945: WHEN OTHERS THEN
946: rollback to create_project_party_wrp;
947:
948: --setting all the OUT and IN OUT parameters to null
949: x_return_status := fnd_api.g_ret_sts_unexp_error;
950: p_end_date_active := null;
951: x_project_party_id := null;
952: x_resource_id := null;
953: x_assignment_id := null;