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 2008/04/18 14:28:00 kmaddi 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 2008/04/18 14:28:00 kmaddi 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 563: if NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,

559: if (p_debug_mode = 'Y') then
560: pa_debug.debug('Delete_project_party: Checking he api version number.');
561: end if;
562:
563: if NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
564: l_api_name, 'PA_PROJECT_PARTIES_PUB') then
565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
566: end if;
567:

Line 565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

561: end if;
562:
563: if NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
564: l_api_name, 'PA_PROJECT_PARTIES_PUB') then
565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
566: end if;
567:
568: ------dbms_output.put_line('Before initializing the stack');
569: pa_debug.init_err_stack('Delete_project_party_pub');

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

573: if (p_debug_mode = 'Y') then
574: pa_debug.debug('Delete_project_party: Initializing message stack.');
575: end if;
576:
577: if FND_API.to_boolean(nvl(p_init_msg_list,fnd_api.G_TRUE)) then
578: fnd_msg_pub.initialize;
579: end if;
580:
581: ------dbms_output.put_line('After initializing the stack');

Line 584: x_return_status := FND_API.G_RET_STS_SUCCESS;

580:
581: ------dbms_output.put_line('After initializing the stack');
582:
583:
584: x_return_status := FND_API.G_RET_STS_SUCCESS;
585:
586:
587: if (p_debug_mode = 'Y') then
588: pa_debug.debug('Delete_project_party : Before delete from pa_project_players ');

Line 598: ,p_validate_only => FND_API.G_FALSE

594: ( p_assignment_id => p_assignment_id
595: ,p_assignment_type => 'STAFFED_ASSIGNMENT'
596: ,p_record_version_number => p_assign_record_version_number
597: ,p_commit => p_commit
598: ,p_validate_only => FND_API.G_FALSE
599: ,p_init_msg_list => FND_API.G_TRUE
600: ,x_return_status => x_return_status
601: ,x_msg_count => x_msg_count
602: ,x_msg_data => x_msg_data

Line 599: ,p_init_msg_list => FND_API.G_TRUE

595: ,p_assignment_type => 'STAFFED_ASSIGNMENT'
596: ,p_record_version_number => p_assign_record_version_number
597: ,p_commit => p_commit
598: ,p_validate_only => FND_API.G_FALSE
599: ,p_init_msg_list => FND_API.G_TRUE
600: ,x_return_status => x_return_status
601: ,x_msg_count => x_msg_count
602: ,x_msg_data => x_msg_data
603: );

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

622: fnd_msg_pub.count_and_get(p_count => x_msg_count,
623: p_data => x_msg_data);
624:
625: IF x_msg_count = 1 THEN
626: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
627: ,p_msg_index => 1
628: ,p_data => x_msg_data
629: ,p_msg_index_out => l_msg_index_out
630: );

Line 637: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

633: pa_debug.reset_err_stack;
634:
635: EXCEPTION
636:
637: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
639: fnd_message.set_name('PA','PA_UNEXPECTED_ERROR');
640: fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_PUB');
641: fnd_message.set_token('PROCEDURE_NAME','DELETE_PROJECT_PARTY');

Line 638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

634:
635: EXCEPTION
636:
637: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
639: fnd_message.set_name('PA','PA_UNEXPECTED_ERROR');
640: fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_PUB');
641: fnd_message.set_token('PROCEDURE_NAME','DELETE_PROJECT_PARTY');
642: fnd_msg_pub.add();

Line 654: x_return_status := FND_API.G_RET_STS_ERROR;

650: pa_debug.debug('Delete_project_party : Exception NO_DATA_FOUND ');
651: end if;
652:
653: fnd_message.set_name('PA', 'PA_XC_NO_DATA_FOUND');
654: x_return_status := FND_API.G_RET_STS_ERROR;
655:
656: WHEN OTHERS then
657:
658: if (p_debug_mode = 'Y') then

Line 668: x_return_status := FND_API.G_RET_STS_ERROR;

664: FND_MESSAGE.Set_token('ENTITY', 'PA_PROJECT_PARTIES');
665: FND_MESSAGE.Set_token('PROJECT',to_char(P_PROJECT_ID));
666: FND_MESSAGE.Set_token('TASK',NULL);
667: x_msg_data := FND_MESSAGE.get;
668: x_return_status := FND_API.G_RET_STS_ERROR;
669: else
670: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PARTIES_PUB',
671: p_procedure_name => pa_debug.g_err_stack,
672: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 673: x_return_status := FND_API.G_RET_STS_ERROR;

669: else
670: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PARTIES_PUB',
671: p_procedure_name => pa_debug.g_err_stack,
672: p_error_text => SUBSTRB(SQLERRM,1,240));
673: x_return_status := FND_API.G_RET_STS_ERROR;
674: end if;
675:
676: END DELETE_PROJECT_PARTY;
677:

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

757: This api is used as a wrapper API to CREATE_PROJECT_PARTY
758: ==============================================================================*/
759:
760: PROCEDURE CREATE_PROJECT_PARTY_WRP( p_api_version IN NUMBER := 1.0,
761: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
762: p_commit IN VARCHAR2 := FND_API.G_FALSE,
763: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
764: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
765: p_debug_mode IN VARCHAR2 default 'N',

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

758: ==============================================================================*/
759:
760: PROCEDURE CREATE_PROJECT_PARTY_WRP( p_api_version IN NUMBER := 1.0,
761: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
762: p_commit IN VARCHAR2 := FND_API.G_FALSE,
763: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
764: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
765: p_debug_mode IN VARCHAR2 default 'N',
766: p_object_id IN NUMBER := FND_API.G_MISS_NUM,

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

759:
760: PROCEDURE CREATE_PROJECT_PARTY_WRP( p_api_version IN NUMBER := 1.0,
761: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
762: p_commit IN VARCHAR2 := FND_API.G_FALSE,
763: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
764: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
765: p_debug_mode IN VARCHAR2 default 'N',
766: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
767: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

760: PROCEDURE CREATE_PROJECT_PARTY_WRP( p_api_version IN NUMBER := 1.0,
761: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
762: p_commit IN VARCHAR2 := FND_API.G_FALSE,
763: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
764: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
765: p_debug_mode IN VARCHAR2 default 'N',
766: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
767: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
768: p_project_role_id IN NUMBER := FND_API.G_MISS_NUM,

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

762: p_commit IN VARCHAR2 := FND_API.G_FALSE,
763: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
764: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
765: p_debug_mode IN VARCHAR2 default 'N',
766: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
767: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
768: p_project_role_id IN NUMBER := FND_API.G_MISS_NUM,
769: p_project_role_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
770: p_resource_type_id IN NUMBER := 101, --EMPLOYEE

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

763: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
764: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
765: p_debug_mode IN VARCHAR2 default 'N',
766: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
767: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
768: p_project_role_id IN NUMBER := FND_API.G_MISS_NUM,
769: p_project_role_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
770: p_resource_type_id IN NUMBER := 101, --EMPLOYEE
771: p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM,

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

764: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
765: p_debug_mode IN VARCHAR2 default 'N',
766: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
767: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
768: p_project_role_id IN NUMBER := FND_API.G_MISS_NUM,
769: p_project_role_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
770: p_resource_type_id IN NUMBER := 101, --EMPLOYEE
771: p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM,
772: p_resource_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

765: p_debug_mode IN VARCHAR2 default 'N',
766: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
767: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
768: p_project_role_id IN NUMBER := FND_API.G_MISS_NUM,
769: p_project_role_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
770: p_resource_type_id IN NUMBER := 101, --EMPLOYEE
771: p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM,
772: p_resource_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
773: p_start_date_active IN DATE := FND_API.G_MISS_DATE,/*Added for bug2774759*/

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

767: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
768: p_project_role_id IN NUMBER := FND_API.G_MISS_NUM,
769: p_project_role_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
770: p_resource_type_id IN NUMBER := 101, --EMPLOYEE
771: p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM,
772: p_resource_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
773: p_start_date_active IN DATE := FND_API.G_MISS_DATE,/*Added for bug2774759*/
774: p_scheduled_flag IN VARCHAR2 := 'N',
775: p_calling_module IN VARCHAR2,

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

768: p_project_role_id IN NUMBER := FND_API.G_MISS_NUM,
769: p_project_role_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
770: p_resource_type_id IN NUMBER := 101, --EMPLOYEE
771: p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM,
772: p_resource_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
773: p_start_date_active IN DATE := FND_API.G_MISS_DATE,/*Added for bug2774759*/
774: p_scheduled_flag IN VARCHAR2 := 'N',
775: p_calling_module IN VARCHAR2,
776: p_project_id IN NUMBER := FND_API.G_MISS_NUM,

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

769: p_project_role_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
770: p_resource_type_id IN NUMBER := 101, --EMPLOYEE
771: p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM,
772: p_resource_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
773: p_start_date_active IN DATE := FND_API.G_MISS_DATE,/*Added for bug2774759*/
774: p_scheduled_flag IN VARCHAR2 := 'N',
775: p_calling_module IN VARCHAR2,
776: p_project_id IN NUMBER := FND_API.G_MISS_NUM,
777: p_project_end_date IN DATE := FND_API.G_MISS_DATE,

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

772: p_resource_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
773: p_start_date_active IN DATE := FND_API.G_MISS_DATE,/*Added for bug2774759*/
774: p_scheduled_flag IN VARCHAR2 := 'N',
775: p_calling_module IN VARCHAR2,
776: p_project_id IN NUMBER := FND_API.G_MISS_NUM,
777: p_project_end_date IN DATE := FND_API.G_MISS_DATE,
778: p_mgr_validation_type IN VARCHAR2 default 'FORM',/*Added for bug 2111806*/
779: p_end_date_active IN OUT NOCOPY DATE,
780: x_project_party_id OUT NOCOPY NUMBER,

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

773: p_start_date_active IN DATE := FND_API.G_MISS_DATE,/*Added for bug2774759*/
774: p_scheduled_flag IN VARCHAR2 := 'N',
775: p_calling_module IN VARCHAR2,
776: p_project_id IN NUMBER := FND_API.G_MISS_NUM,
777: p_project_end_date IN DATE := FND_API.G_MISS_DATE,
778: p_mgr_validation_type IN VARCHAR2 default 'FORM',/*Added for bug 2111806*/
779: p_end_date_active IN OUT NOCOPY DATE,
780: x_project_party_id OUT NOCOPY NUMBER,
781: x_resource_id OUT NOCOPY NUMBER,

Line 817: x_return_status := FND_API.G_RET_STS_SUCCESS;

813: IF l_debug_mode = 'Y' THEN
814: pa_debug.set_curr_function( p_function => 'CREATE_PROJECT_PARTY_WRP'
815: ,p_debug_mode => l_debug_mode);
816: END IF;
817: x_return_status := FND_API.G_RET_STS_SUCCESS;
818: x_msg_count := 0;
819:
820: /* get the project_role_id */
821: if p_project_role_id is null or p_project_role_id = FND_API.G_MISS_NUM then

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

817: x_return_status := FND_API.G_RET_STS_SUCCESS;
818: x_msg_count := 0;
819:
820: /* get the project_role_id */
821: if p_project_role_id is null or p_project_role_id = FND_API.G_MISS_NUM then
822: l_project_role_id := pa_project_parties_utils.get_project_role_id(p_project_role_type,p_calling_module);
823: else
824: l_project_role_id := p_project_role_id;
825: end if;

Line 853: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

849: ,p_start_date => p_start_date_active
850: ,p_end_date => p_end_date_active
851: ,p_return_status => x_return_status);
852:
853: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
854: RAISE FND_API.G_EXC_ERROR;
855: END IF;
856: End If; --If project_role_id = 1
857: /* calling CREATE_PROJECT_PARTY unconditionally for all the key members

Line 854: RAISE FND_API.G_EXC_ERROR;

850: ,p_end_date => p_end_date_active
851: ,p_return_status => x_return_status);
852:
853: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
854: RAISE FND_API.G_EXC_ERROR;
855: END IF;
856: End If; --If project_role_id = 1
857: /* calling CREATE_PROJECT_PARTY unconditionally for all the key members
858: This flow is similar to AMG API. Instead of calling add_key_members , we

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

883: , x_return_status => x_return_status -- x_return_status
884: , x_msg_count => x_msg_count -- x_msg_count
885: , x_msg_data => x_msg_data -- x_msg_data
886: );
887: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) Then
888: x_return_status := x_return_status;
889: x_msg_count := x_msg_count;
890: raise FND_API.G_EXC_ERROR;
891: END IF;

Line 890: raise FND_API.G_EXC_ERROR;

886: );
887: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) Then
888: x_return_status := x_return_status;
889: x_msg_count := x_msg_count;
890: raise FND_API.G_EXC_ERROR;
891: END IF;
892: /* end if call create_project_party */
893: IF l_debug_mode = 'Y' THEN
894: PA_DEBUG.Reset_Curr_Function;

Line 898: WHEN FND_API.G_EXC_ERROR

894: PA_DEBUG.Reset_Curr_Function;
895: END IF;
896:
897: EXCEPTION
898: WHEN FND_API.G_EXC_ERROR
899: THEN
900: rollback to create_project_party_wrp;
901:
902: --setting all the OUT and IN OUT parameters to null

Line 903: x_return_status := FND_API.G_RET_STS_ERROR;

899: THEN
900: rollback to create_project_party_wrp;
901:
902: --setting all the OUT and IN OUT parameters to null
903: x_return_status := FND_API.G_RET_STS_ERROR;
904: p_end_date_active := null;
905: x_project_party_id := null;
906: x_resource_id := null;
907: x_assignment_id := null;

Line 917: ( p_encoded => Fnd_Api.G_TRUE

913:
914: IF x_msg_count = 1 AND x_msg_data IS NULL
915: THEN
916: Pa_Interface_Utils_Pub.get_messages
917: ( p_encoded => Fnd_Api.G_TRUE
918: , p_msg_index => 1
919: , p_msg_count => x_msg_count
920: , p_msg_data => l_msg_data
921: , p_data => l_data

Line 929: x_return_status := fnd_api.g_ret_sts_unexp_error;

925: WHEN OTHERS THEN
926: rollback to create_project_party_wrp;
927:
928: --setting all the OUT and IN OUT parameters to null
929: x_return_status := fnd_api.g_ret_sts_unexp_error;
930: p_end_date_active := null;
931: x_project_party_id := null;
932: x_resource_id := null;
933: x_assignment_id := null;