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_PROJ_STRUC_MAPPING_PUB dependencies on FND_API

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

25:
26: PROCEDURE DELETE_MAPPING
27: (
28: p_api_version IN NUMBER := 1.0
29: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
30: , p_commit IN VARCHAR2 := FND_API.G_FALSE
31: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
32: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
33: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

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

26: PROCEDURE DELETE_MAPPING
27: (
28: p_api_version IN NUMBER := 1.0
29: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
30: , p_commit IN VARCHAR2 := FND_API.G_FALSE
31: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
32: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
33: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
34: , p_debug_mode IN VARCHAR2 := 'N'

Line 31: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE

27: (
28: p_api_version IN NUMBER := 1.0
29: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
30: , p_commit IN VARCHAR2 := FND_API.G_FALSE
31: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
32: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
33: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
34: , p_debug_mode IN VARCHAR2 := 'N'
35: , p_record_version_number IN NUMBER := FND_API.G_MISS_NUM

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

28: p_api_version IN NUMBER := 1.0
29: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
30: , p_commit IN VARCHAR2 := FND_API.G_FALSE
31: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
32: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
33: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
34: , p_debug_mode IN VARCHAR2 := 'N'
35: , p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
36: , p_wp_from_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR

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

31: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
32: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
33: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
34: , p_debug_mode IN VARCHAR2 := 'N'
35: , p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
36: , p_wp_from_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
37: , p_wp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
38: , p_fp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
39: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 36: , p_wp_from_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR

32: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
33: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
34: , p_debug_mode IN VARCHAR2 := 'N'
35: , p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
36: , p_wp_from_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
37: , p_wp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
38: , p_fp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
39: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
40: , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 37: , p_wp_task_version_id IN NUMBER := FND_API.G_MISS_NUM

33: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
34: , p_debug_mode IN VARCHAR2 := 'N'
35: , p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
36: , p_wp_from_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
37: , p_wp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
38: , p_fp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
39: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
40: , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
41: , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 38: , p_fp_task_version_id IN NUMBER := FND_API.G_MISS_NUM

34: , p_debug_mode IN VARCHAR2 := 'N'
35: , p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
36: , p_wp_from_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
37: , p_wp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
38: , p_fp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
39: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
40: , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
41: , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
42: )

Line 98: x_return_status := FND_API.G_RET_STS_SUCCESS;

94:
95: BEGIN
96:
97: x_msg_count := 0;
98: x_return_status := FND_API.G_RET_STS_SUCCESS;
99:
100: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
101: IF l_debug_mode = 'Y' THEN
102: PA_DEBUG.set_curr_function( p_function => 'DELETE_MAPPING',

Line 121: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

117: Pa_Debug.WRITE(g_module_name,'p_fp_task_version_id'||':'||p_fp_task_version_id,
118: l_debug_level3);
119: END IF;
120:
121: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
122: FND_MSG_PUB.initialize;
123: END IF;
124:
125: IF (p_commit = FND_API.G_TRUE) THEN

Line 125: IF (p_commit = FND_API.G_TRUE) THEN

121: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
122: FND_MSG_PUB.initialize;
123: END IF;
124:
125: IF (p_commit = FND_API.G_TRUE) THEN
126: savepoint DELETE_MAPPING_PUBLIC;
127: END IF;
128:
129: IF l_debug_mode = 'Y' THEN

Line 136: ( p_wp_task_version_id IS NULL OR p_wp_task_version_id = FND_API.G_MISS_NUM ) AND

132: l_debug_level3);
133: END IF;
134:
135: IF (
136: ( p_wp_task_version_id IS NULL OR p_wp_task_version_id = FND_API.G_MISS_NUM ) AND
137: ( p_fp_task_version_id IS NULL OR p_fp_task_version_id = FND_API.G_MISS_NUM )
138: )
139: THEN
140: IF l_debug_mode = 'Y' THEN

Line 137: ( p_fp_task_version_id IS NULL OR p_fp_task_version_id = FND_API.G_MISS_NUM )

133: END IF;
134:
135: IF (
136: ( p_wp_task_version_id IS NULL OR p_wp_task_version_id = FND_API.G_MISS_NUM ) AND
137: ( p_fp_task_version_id IS NULL OR p_fp_task_version_id = FND_API.G_MISS_NUM )
138: )
139: THEN
140: IF l_debug_mode = 'Y' THEN
141: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : DELETE_MAPPING : Both p_wp_task_version_id and p_fp_task_version_id are null';

Line 149: IF ( ( p_wp_task_version_id IS NOT NULL AND p_wp_task_version_id <> FND_API.G_MISS_NUM )

145: RAISE Invalid_Arg_Exc_WP;
146: END IF;
147: --Following is added to implement locking
148: -- If both WP task ID and FP Task ID are passed from self service
149: IF ( ( p_wp_task_version_id IS NOT NULL AND p_wp_task_version_id <> FND_API.G_MISS_NUM )
150: AND
151: ( p_fp_task_version_id IS NOT NULL AND p_fp_task_version_id <> FND_API.G_MISS_NUM )
152: )
153: THEN

Line 151: ( p_fp_task_version_id IS NOT NULL AND p_fp_task_version_id <> FND_API.G_MISS_NUM )

147: --Following is added to implement locking
148: -- If both WP task ID and FP Task ID are passed from self service
149: IF ( ( p_wp_task_version_id IS NOT NULL AND p_wp_task_version_id <> FND_API.G_MISS_NUM )
150: AND
151: ( p_fp_task_version_id IS NOT NULL AND p_fp_task_version_id <> FND_API.G_MISS_NUM )
152: )
153: THEN
154: --Get the object_relationship_id
155: OPEN c_get_mapping_frm_wp_fp_task ( p_wp_task_version_id , p_fp_task_version_id );

Line 171: RAISE FND_API.G_EXC_ERROR ;

167: -- it should be "Mapping does not exist between the given tasks."
168: IF p_calling_module = 'AMG' THEN
169: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
170: p_msg_name => 'PA_TASK_MAPPING_NOT_EXIST' );
171: RAISE FND_API.G_EXC_ERROR ;
172: ELSE
173: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
174: p_msg_name => 'PA_RECORD_CHANGED' );
175: RAISE FND_API.G_EXC_ERROR ;

Line 175: RAISE FND_API.G_EXC_ERROR ;

171: RAISE FND_API.G_EXC_ERROR ;
172: ELSE
173: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
174: p_msg_name => 'PA_RECORD_CHANGED' );
175: RAISE FND_API.G_EXC_ERROR ;
176: END IF;
177: END IF;
178: CLOSE c_get_mapping_frm_wp_fp_task;
179: -- if any row found, delete the row

Line 193: , p_init_msg_list => FND_API.G_FALSE

189:
190: PA_RELATIONSHIP_PUB.DELETE_RELATIONSHIP
191: (
192: p_api_version => p_api_version
193: , p_init_msg_list => FND_API.G_FALSE
194: , p_commit => p_commit
195: , p_validate_only => p_validate_only
196: , p_calling_module => 'SELF_SERVICE'
197: , p_debug_mode => l_debug_mode

Line 204: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)

200: , x_return_status => x_return_status
201: , x_msg_count => x_msg_count
202: , x_msg_data => x_msg_data
203: );
204: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
205: THEN
206: RAISE FND_API.G_EXC_ERROR;
207: END IF;
208: END IF;

Line 206: RAISE FND_API.G_EXC_ERROR;

202: , x_msg_data => x_msg_data
203: );
204: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
205: THEN
206: RAISE FND_API.G_EXC_ERROR;
207: END IF;
208: END IF;
209:
210: -- If the WP task ID is not NULL, get the relationship ID and delete mapping

Line 211: ELSIF (p_wp_task_version_id IS NOT NULL AND p_wp_task_version_id <> FND_API.G_MISS_NUM )

207: END IF;
208: END IF;
209:
210: -- If the WP task ID is not NULL, get the relationship ID and delete mapping
211: ELSIF (p_wp_task_version_id IS NOT NULL AND p_wp_task_version_id <> FND_API.G_MISS_NUM )
212: THEN
213: OPEN c_get_mapping_frm_wp_task ( p_wp_task_version_id );
214: FETCH c_get_mapping_frm_wp_task INTO l_object_relationship_id , l_rec_version_num ;
215: CLOSE c_get_mapping_frm_wp_task;

Line 230: , p_init_msg_list => FND_API.G_FALSE

226:
227: PA_RELATIONSHIP_PUB.DELETE_RELATIONSHIP
228: (
229: p_api_version => p_api_version
230: , p_init_msg_list => FND_API.G_FALSE
231: , p_commit => p_commit
232: , p_validate_only => p_validate_only
233: , p_calling_module => 'SELF_SERVICE'
234: , p_debug_mode => l_debug_mode

Line 242: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)

238: , x_msg_count => x_msg_count
239: , x_msg_data => x_msg_data
240: );
241:
242: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
243: THEN
244: RAISE FND_API.G_EXC_ERROR;
245: END IF;
246:

Line 244: RAISE FND_API.G_EXC_ERROR;

240: );
241:
242: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
243: THEN
244: RAISE FND_API.G_EXC_ERROR;
245: END IF;
246:
247: ELSE
248: IF l_debug_mode = 'Y' THEN

Line 257: ELSIF ( p_fp_task_version_id IS NOT NULL AND p_fp_task_version_id <> FND_API.G_MISS_NUM )

253: END IF;--IF (l_object_relationship_id IS NOT NULL) ENDS
254:
255:
256: -- If financial task id is passed get the mapping with FP task id
257: ELSIF ( p_fp_task_version_id IS NOT NULL AND p_fp_task_version_id <> FND_API.G_MISS_NUM )
258: THEN
259: FOR map_rec IN c_get_mapping_frm_fp_task ( p_fp_task_version_id ) LOOP
260:
261: PA_RELATIONSHIP_PUB.DELETE_RELATIONSHIP

Line 264: , p_init_msg_list => FND_API.G_FALSE

260:
261: PA_RELATIONSHIP_PUB.DELETE_RELATIONSHIP
262: (
263: p_api_version => p_api_version
264: , p_init_msg_list => FND_API.G_FALSE
265: , p_commit => p_commit
266: , p_validate_only => p_validate_only
267: , p_calling_module => 'SELF_SERVICE'
268: , p_debug_mode => l_debug_mode

Line 275: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)

271: , x_return_status => x_return_status
272: , x_msg_count => x_msg_count
273: , x_msg_data => x_msg_data
274: );
275: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
276: THEN
277: RAISE FND_API.G_EXC_ERROR;
278: END IF;
279:

Line 277: RAISE FND_API.G_EXC_ERROR;

273: , x_msg_data => x_msg_data
274: );
275: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
276: THEN
277: RAISE FND_API.G_EXC_ERROR;
278: END IF;
279:
280: END LOOP;
281: END IF;

Line 284: IF (p_commit = FND_API.G_TRUE) THEN

280: END LOOP;
281: END IF;
282:
283:
284: IF (p_commit = FND_API.G_TRUE) THEN
285: COMMIT;
286: END IF;
287:
288:

Line 291: WHEN FND_API.G_EXC_ERROR THEN

287:
288:
289: EXCEPTION
290:
291: WHEN FND_API.G_EXC_ERROR THEN
292:
293: x_return_status := Fnd_Api.G_RET_STS_ERROR;
294: l_msg_count := Fnd_Msg_Pub.count_msg;
295:

Line 293: x_return_status := Fnd_Api.G_RET_STS_ERROR;

289: EXCEPTION
290:
291: WHEN FND_API.G_EXC_ERROR THEN
292:
293: x_return_status := Fnd_Api.G_RET_STS_ERROR;
294: l_msg_count := Fnd_Msg_Pub.count_msg;
295:
296: IF p_commit = FND_API.G_TRUE THEN
297: ROLLBACK TO DELETE_MAPPING_PUBLIC;

Line 296: IF p_commit = FND_API.G_TRUE THEN

292:
293: x_return_status := Fnd_Api.G_RET_STS_ERROR;
294: l_msg_count := Fnd_Msg_Pub.count_msg;
295:
296: IF p_commit = FND_API.G_TRUE THEN
297: ROLLBACK TO DELETE_MAPPING_PUBLIC;
298: END IF;
299:
300: IF c_get_mapping_frm_wp_task%ISOPEN THEN

Line 315: ( p_encoded => Fnd_Api.G_TRUE

311:
312: IF l_msg_count = 1 AND x_msg_data IS NULL
313: THEN
314: Pa_Interface_Utils_Pub.get_messages
315: ( p_encoded => Fnd_Api.G_TRUE
316: , p_msg_index => 1
317: , p_msg_count => l_msg_count
318: , p_msg_data => l_msg_data
319: , p_data => l_data

Line 332: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

328: END IF;
329:
330: WHEN Invalid_Arg_Exc_WP THEN
331:
332: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
333: x_msg_count := 1;
334: x_msg_data := 'PA_PROJ_STRUC_MAPPING_PUB : DELETE_MAPPING : NULL PARAMETERS ARE PASSED OR CURSOR DIDNT RETURN ANY ROWS';
335:
336: IF p_commit = FND_API.G_TRUE THEN

Line 336: IF p_commit = FND_API.G_TRUE THEN

332: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
333: x_msg_count := 1;
334: x_msg_data := 'PA_PROJ_STRUC_MAPPING_PUB : DELETE_MAPPING : NULL PARAMETERS ARE PASSED OR CURSOR DIDNT RETURN ANY ROWS';
335:
336: IF p_commit = FND_API.G_TRUE THEN
337: ROLLBACK TO DELETE_MAPPING_PUBLIC;
338: END IF;
339: IF c_get_mapping_frm_wp_task%ISOPEN THEN
340: CLOSE c_get_mapping_frm_wp_task;

Line 366: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

362: RAISE;
363:
364: WHEN OTHERS THEN
365:
366: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
367: x_msg_count := 1;
368: x_msg_data := SQLERRM;
369:
370: IF p_commit = FND_API.G_TRUE THEN

Line 370: IF p_commit = FND_API.G_TRUE THEN

366: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
367: x_msg_count := 1;
368: x_msg_data := SQLERRM;
369:
370: IF p_commit = FND_API.G_TRUE THEN
371: ROLLBACK TO DELETE_MAPPING_PUBLIC;
372: END IF;
373:
374: IF c_get_mapping_frm_wp_task%ISOPEN THEN

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

419:
420: PROCEDURE CREATE_MAPPING
421: (
422: p_api_version IN NUMBER := 1.0
423: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
424: , p_commit IN VARCHAR2 := FND_API.G_FALSE
425: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
426: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
427: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

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

420: PROCEDURE CREATE_MAPPING
421: (
422: p_api_version IN NUMBER := 1.0
423: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
424: , p_commit IN VARCHAR2 := FND_API.G_FALSE
425: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
426: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
427: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
428: , p_debug_mode IN VARCHAR2 := 'N'

Line 425: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE

421: (
422: p_api_version IN NUMBER := 1.0
423: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
424: , p_commit IN VARCHAR2 := FND_API.G_FALSE
425: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
426: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
427: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
428: , p_debug_mode IN VARCHAR2 := 'N'
429: , p_wp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR

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

422: p_api_version IN NUMBER := 1.0
423: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
424: , p_commit IN VARCHAR2 := FND_API.G_FALSE
425: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
426: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
427: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
428: , p_debug_mode IN VARCHAR2 := 'N'
429: , p_wp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
430: , p_wp_task_version_id IN NUMBER := FND_API.G_MISS_NUM

Line 429: , p_wp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR

425: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
426: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
427: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
428: , p_debug_mode IN VARCHAR2 := 'N'
429: , p_wp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
430: , p_wp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
431: , p_parent_str_version_id IN NUMBER := FND_API.G_MISS_NUM
432: , p_fp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
433: , p_fp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 430: , p_wp_task_version_id IN NUMBER := FND_API.G_MISS_NUM

426: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
427: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
428: , p_debug_mode IN VARCHAR2 := 'N'
429: , p_wp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
430: , p_wp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
431: , p_parent_str_version_id IN NUMBER := FND_API.G_MISS_NUM
432: , p_fp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
433: , p_fp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
434: , p_project_id IN NUMBER

Line 431: , p_parent_str_version_id IN NUMBER := FND_API.G_MISS_NUM

427: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
428: , p_debug_mode IN VARCHAR2 := 'N'
429: , p_wp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
430: , p_wp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
431: , p_parent_str_version_id IN NUMBER := FND_API.G_MISS_NUM
432: , p_fp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
433: , p_fp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
434: , p_project_id IN NUMBER
435: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 432: , p_fp_task_version_id IN NUMBER := FND_API.G_MISS_NUM

428: , p_debug_mode IN VARCHAR2 := 'N'
429: , p_wp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
430: , p_wp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
431: , p_parent_str_version_id IN NUMBER := FND_API.G_MISS_NUM
432: , p_fp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
433: , p_fp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
434: , p_project_id IN NUMBER
435: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
436: , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 433: , p_fp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR

429: , p_wp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
430: , p_wp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
431: , p_parent_str_version_id IN NUMBER := FND_API.G_MISS_NUM
432: , p_fp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
433: , p_fp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
434: , p_project_id IN NUMBER
435: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
436: , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
437: , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 505: x_return_status := FND_API.G_RET_STS_SUCCESS;

501:
502: BEGIN
503:
504: x_msg_count := 0;
505: x_return_status := FND_API.G_RET_STS_SUCCESS;
506: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
507:
508: IF l_debug_mode = 'Y' THEN
509: PA_DEBUG.set_curr_function( p_function => 'CREATE_MAPPING',

Line 513: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

509: PA_DEBUG.set_curr_function( p_function => 'CREATE_MAPPING',
510: p_debug_mode => l_debug_mode );
511: END IF;
512:
513: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
514: FND_MSG_PUB.initialize;
515: END IF;
516:
517: IF (p_commit = FND_API.G_TRUE) THEN

Line 517: IF (p_commit = FND_API.G_TRUE) THEN

513: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
514: FND_MSG_PUB.initialize;
515: END IF;
516:
517: IF (p_commit = FND_API.G_TRUE) THEN
518: savepoint CREATE_MAPPING_PUBLIC;
519: END IF;
520:
521: IF l_debug_mode = 'Y' THEN

Line 564: ( p_wp_task_name is NULL OR p_wp_task_name = FND_API.G_MISS_CHAR ) AND

560: -- if fp task id and and fp task name both are null
561: -- raise error
562: IF (
563: (
564: ( p_wp_task_name is NULL OR p_wp_task_name = FND_API.G_MISS_CHAR ) AND
565: ( p_wp_task_version_id is NULL OR p_wp_task_version_id = FND_API.G_MISS_NUM )
566: ) OR
567: (
568: ( p_fp_task_name is NULL OR p_fp_task_name = FND_API.G_MISS_CHAR ) AND

Line 565: ( p_wp_task_version_id is NULL OR p_wp_task_version_id = FND_API.G_MISS_NUM )

561: -- raise error
562: IF (
563: (
564: ( p_wp_task_name is NULL OR p_wp_task_name = FND_API.G_MISS_CHAR ) AND
565: ( p_wp_task_version_id is NULL OR p_wp_task_version_id = FND_API.G_MISS_NUM )
566: ) OR
567: (
568: ( p_fp_task_name is NULL OR p_fp_task_name = FND_API.G_MISS_CHAR ) AND
569: ( p_fp_task_version_id is NULL OR p_fp_task_version_id = FND_API.G_MISS_NUM )

Line 568: ( p_fp_task_name is NULL OR p_fp_task_name = FND_API.G_MISS_CHAR ) AND

564: ( p_wp_task_name is NULL OR p_wp_task_name = FND_API.G_MISS_CHAR ) AND
565: ( p_wp_task_version_id is NULL OR p_wp_task_version_id = FND_API.G_MISS_NUM )
566: ) OR
567: (
568: ( p_fp_task_name is NULL OR p_fp_task_name = FND_API.G_MISS_CHAR ) AND
569: ( p_fp_task_version_id is NULL OR p_fp_task_version_id = FND_API.G_MISS_NUM )
570: )
571: )
572: THEN

Line 569: ( p_fp_task_version_id is NULL OR p_fp_task_version_id = FND_API.G_MISS_NUM )

565: ( p_wp_task_version_id is NULL OR p_wp_task_version_id = FND_API.G_MISS_NUM )
566: ) OR
567: (
568: ( p_fp_task_name is NULL OR p_fp_task_name = FND_API.G_MISS_CHAR ) AND
569: ( p_fp_task_version_id is NULL OR p_fp_task_version_id = FND_API.G_MISS_NUM )
570: )
571: )
572: THEN
573: IF l_debug_mode = 'Y' THEN

Line 583: ( p_wp_task_version_id IS NULL OR p_wp_task_version_id = FND_API.G_MISS_NUM ) AND

579: END IF;
580:
581: -- Parent structure version id is essential to get task id using task name , so it should be validated
582: IF (
583: ( p_wp_task_version_id IS NULL OR p_wp_task_version_id = FND_API.G_MISS_NUM ) AND
584: (
585: ( p_wp_task_name IS NOT NULL AND p_wp_task_name <> FND_API.G_MISS_CHAR ) AND
586: ( p_parent_str_version_id IS NULL OR p_parent_str_version_id = FND_API.G_MISS_NUM )
587: )

Line 585: ( p_wp_task_name IS NOT NULL AND p_wp_task_name <> FND_API.G_MISS_CHAR ) AND

581: -- Parent structure version id is essential to get task id using task name , so it should be validated
582: IF (
583: ( p_wp_task_version_id IS NULL OR p_wp_task_version_id = FND_API.G_MISS_NUM ) AND
584: (
585: ( p_wp_task_name IS NOT NULL AND p_wp_task_name <> FND_API.G_MISS_CHAR ) AND
586: ( p_parent_str_version_id IS NULL OR p_parent_str_version_id = FND_API.G_MISS_NUM )
587: )
588: )
589: THEN

Line 586: ( p_parent_str_version_id IS NULL OR p_parent_str_version_id = FND_API.G_MISS_NUM )

582: IF (
583: ( p_wp_task_version_id IS NULL OR p_wp_task_version_id = FND_API.G_MISS_NUM ) AND
584: (
585: ( p_wp_task_name IS NOT NULL AND p_wp_task_name <> FND_API.G_MISS_CHAR ) AND
586: ( p_parent_str_version_id IS NULL OR p_parent_str_version_id = FND_API.G_MISS_NUM )
587: )
588: )
589: THEN
590: IF l_debug_mode = 'Y' THEN

Line 600: IF ( p_wp_task_version_id IS NOT NULL AND p_wp_task_version_id <> FND_API.G_MISS_NUM )

596: END IF;
597:
598: -- If the task name is passed insteand of task id, we need to fetch the task id
599:
600: IF ( p_wp_task_version_id IS NOT NULL AND p_wp_task_version_id <> FND_API.G_MISS_NUM )
601: THEN
602: l_wp_task_version_id := p_wp_task_version_id;
603:
604: ELSIF

Line 605: ( ( p_wp_task_name IS NOT NULL AND p_wp_task_name <> FND_API.G_MISS_CHAR )AND

601: THEN
602: l_wp_task_version_id := p_wp_task_version_id;
603:
604: ELSIF
605: ( ( p_wp_task_name IS NOT NULL AND p_wp_task_name <> FND_API.G_MISS_CHAR )AND
606: ( p_parent_str_version_id IS NOT NULL AND p_parent_str_version_id <> FND_API.G_MISS_NUM )
607: )
608: THEN
609: --select the wp_task_version_id for the corresponding name and store it in l_wp_task_version_id

Line 606: ( p_parent_str_version_id IS NOT NULL AND p_parent_str_version_id <> FND_API.G_MISS_NUM )

602: l_wp_task_version_id := p_wp_task_version_id;
603:
604: ELSIF
605: ( ( p_wp_task_name IS NOT NULL AND p_wp_task_name <> FND_API.G_MISS_CHAR )AND
606: ( p_parent_str_version_id IS NOT NULL AND p_parent_str_version_id <> FND_API.G_MISS_NUM )
607: )
608: THEN
609: --select the wp_task_version_id for the corresponding name and store it in l_wp_task_version_id
610:

Line 618: RAISE FND_API.G_EXC_ERROR ;

614: IF ( c_get_wp_task_ver_id_frm_name%NOTFOUND )
615: THEN
616: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
617: p_msg_name => 'PA_OBJECT_NAME_INV' );
618: RAISE FND_API.G_EXC_ERROR ;
619: END IF;
620: CLOSE c_get_wp_task_ver_id_frm_name ;
621:
622: END IF;

Line 624: IF ( ( p_fp_task_version_id IS NOT NULL AND p_fp_task_version_id <> FND_API.G_MISS_NUM )

620: CLOSE c_get_wp_task_ver_id_frm_name ;
621:
622: END IF;
623:
624: IF ( ( p_fp_task_version_id IS NOT NULL AND p_fp_task_version_id <> FND_API.G_MISS_NUM )
625: )
626: THEN
627: l_fp_task_version_id := p_fp_task_version_id;
628:

Line 629: ELSIF ( p_fp_task_name IS NOT NULL AND p_fp_task_name <> FND_API.G_MISS_CHAR )

625: )
626: THEN
627: l_fp_task_version_id := p_fp_task_version_id;
628:
629: ELSIF ( p_fp_task_name IS NOT NULL AND p_fp_task_name <> FND_API.G_MISS_CHAR )
630: THEN
631: -- get the fp_task_version_id and place it in l_fp_task_version_id;
632: -- Assuming there will be only one version for the FP task.
633: Pa_Debug.WRITE('test',l_fp_task_version_id, l_debug_level3);

Line 640: RAISE FND_API.G_EXC_ERROR ;

636: IF ( c_get_fp_task_ver_id_frm_name%NOTFOUND )
637: THEN
638: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
639: p_msg_name => 'PA_OBJECT_NAME_INV' );
640: RAISE FND_API.G_EXC_ERROR ;
641: END IF;
642: CLOSE c_get_fp_task_ver_id_frm_name ;
643:
644: END IF;

Line 665: IF l_create_mapping_ok <> FND_API.G_RET_STS_SUCCESS

661: );
662:
663: x_return_status := l_create_mapping_ok;
664:
665: IF l_create_mapping_ok <> FND_API.G_RET_STS_SUCCESS
666: THEN
667:
668: -- Mapping can't be created
669: IF l_debug_mode = 'Y' THEN

Line 677: RAISE FND_API.G_EXC_ERROR;

673: END IF;
674: Pa_Utils.ADD_MESSAGE
675: ( p_app_short_name => 'PA',
676: p_msg_name => l_error_message_code);
677: RAISE FND_API.G_EXC_ERROR;
678: ELSE
679: -- Mapping Can be created, call public API to create mapping
680: IF l_debug_mode = 'Y' THEN
681: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : CREATE_MAPPING : Calling create'||l_wp_task_version_id||l_fp_task_version_id;

Line 690: p_init_msg_list => FND_API.G_FALSE

686: --Call public API to create the mapping
687:
688: PA_RELATIONSHIP_PUB.CREATE_RELATIONSHIP
689: (
690: p_init_msg_list => FND_API.G_FALSE
691: , p_commit => p_commit
692: , p_debug_mode => l_debug_mode
693: , p_project_id_from => p_project_id
694: , p_task_version_id_from => l_wp_task_version_id

Line 707: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

703: , x_msg_data => x_msg_data
704:
705: );
706: END IF;
707: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
708: RAISE FND_API.G_EXC_ERROR;
709: END IF;
710: IF (p_commit = FND_API.G_TRUE) THEN
711: COMMIT;

Line 708: RAISE FND_API.G_EXC_ERROR;

704:
705: );
706: END IF;
707: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
708: RAISE FND_API.G_EXC_ERROR;
709: END IF;
710: IF (p_commit = FND_API.G_TRUE) THEN
711: COMMIT;
712: END IF;

Line 710: IF (p_commit = FND_API.G_TRUE) THEN

706: END IF;
707: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
708: RAISE FND_API.G_EXC_ERROR;
709: END IF;
710: IF (p_commit = FND_API.G_TRUE) THEN
711: COMMIT;
712: END IF;
713:
714: EXCEPTION

Line 716: WHEN FND_API.G_EXC_ERROR THEN

712: END IF;
713:
714: EXCEPTION
715:
716: WHEN FND_API.G_EXC_ERROR THEN
717:
718: x_return_status := Fnd_Api.G_RET_STS_ERROR;
719: l_msg_count := Fnd_Msg_Pub.count_msg;
720:

Line 718: x_return_status := Fnd_Api.G_RET_STS_ERROR;

714: EXCEPTION
715:
716: WHEN FND_API.G_EXC_ERROR THEN
717:
718: x_return_status := Fnd_Api.G_RET_STS_ERROR;
719: l_msg_count := Fnd_Msg_Pub.count_msg;
720:
721: IF (p_commit = FND_API.G_TRUE) THEN
722: ROLLBACK TO CREATE_MAPPING_PUBLIC;

Line 721: IF (p_commit = FND_API.G_TRUE) THEN

717:
718: x_return_status := Fnd_Api.G_RET_STS_ERROR;
719: l_msg_count := Fnd_Msg_Pub.count_msg;
720:
721: IF (p_commit = FND_API.G_TRUE) THEN
722: ROLLBACK TO CREATE_MAPPING_PUBLIC;
723: END IF;
724:
725: IF l_msg_count = 1 AND x_msg_data IS NULL

Line 728: ( p_encoded => Fnd_Api.G_TRUE

724:
725: IF l_msg_count = 1 AND x_msg_data IS NULL
726: THEN
727: Pa_Interface_Utils_Pub.get_messages
728: ( p_encoded => Fnd_Api.G_TRUE
729: , p_msg_index => 1
730: , p_msg_count => l_msg_count
731: , p_msg_data => l_msg_data
732: , p_data => l_data

Line 745: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

741: END IF;
742:
743: WHEN Invalid_Arg_Exc_WP THEN
744:
745: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
746: x_msg_count := 1;
747: x_msg_data := 'PA_PROJ_STRUC_MAPPING_PUB : CREATE_MAPPING : NULL arguments are passed to the procedure';
748:
749: IF (p_commit = FND_API.G_TRUE) THEN

Line 749: IF (p_commit = FND_API.G_TRUE) THEN

745: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
746: x_msg_count := 1;
747: x_msg_data := 'PA_PROJ_STRUC_MAPPING_PUB : CREATE_MAPPING : NULL arguments are passed to the procedure';
748:
749: IF (p_commit = FND_API.G_TRUE) THEN
750: ROLLBACK TO CREATE_MAPPING_PUBLIC;
751: END IF;
752:
753: Fnd_Msg_Pub.add_exc_msg

Line 769: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

765:
766:
767: WHEN OTHERS THEN
768:
769: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
770: x_msg_count := 1;
771: x_msg_data := SQLERRM;
772:
773: IF (p_commit = FND_API.G_TRUE) THEN

Line 773: IF (p_commit = FND_API.G_TRUE) THEN

769: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
770: x_msg_count := 1;
771: x_msg_data := SQLERRM;
772:
773: IF (p_commit = FND_API.G_TRUE) THEN
774: ROLLBACK TO CREATE_MAPPING_PUBLIC;
775: END IF;
776: Pa_Debug.g_err_stage:= 'x_msg_count='||x_msg_count;
777: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage, l_debug_level5);

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

830:
831: PROCEDURE UPDATE_MAPPING
832: (
833: p_api_version IN NUMBER := 1.0
834: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
835: , p_commit IN VARCHAR2 := FND_API.G_FALSE
836: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
837: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
838: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

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

831: PROCEDURE UPDATE_MAPPING
832: (
833: p_api_version IN NUMBER := 1.0
834: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
835: , p_commit IN VARCHAR2 := FND_API.G_FALSE
836: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
837: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
838: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
839: , p_debug_mode IN VARCHAR2 := 'N'

Line 836: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE

832: (
833: p_api_version IN NUMBER := 1.0
834: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
835: , p_commit IN VARCHAR2 := FND_API.G_FALSE
836: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
837: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
838: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
839: , p_debug_mode IN VARCHAR2 := 'N'
840: , p_record_version_number IN NUMBER := FND_API.G_MISS_NUM

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

833: p_api_version IN NUMBER := 1.0
834: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
835: , p_commit IN VARCHAR2 := FND_API.G_FALSE
836: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
837: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
838: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
839: , p_debug_mode IN VARCHAR2 := 'N'
840: , p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
841: , p_structure_type IN VARCHAR2 := 'WORKPLAN'

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

836: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
837: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
838: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
839: , p_debug_mode IN VARCHAR2 := 'N'
840: , p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
841: , p_structure_type IN VARCHAR2 := 'WORKPLAN'
842: , p_project_id IN NUMBER
843: , p_wp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
844: , p_wp_prnt_str_ver_id IN NUMBER := FND_API.G_MISS_NUM

Line 843: , p_wp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR

839: , p_debug_mode IN VARCHAR2 := 'N'
840: , p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
841: , p_structure_type IN VARCHAR2 := 'WORKPLAN'
842: , p_project_id IN NUMBER
843: , p_wp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
844: , p_wp_prnt_str_ver_id IN NUMBER := FND_API.G_MISS_NUM
845: , p_wp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
846: , p_fp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
847: , p_fp_task_version_id IN NUMBER := FND_API.G_MISS_NUM

Line 844: , p_wp_prnt_str_ver_id IN NUMBER := FND_API.G_MISS_NUM

840: , p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
841: , p_structure_type IN VARCHAR2 := 'WORKPLAN'
842: , p_project_id IN NUMBER
843: , p_wp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
844: , p_wp_prnt_str_ver_id IN NUMBER := FND_API.G_MISS_NUM
845: , p_wp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
846: , p_fp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
847: , p_fp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
848: , p_object_relationship_id IN NUMBER := FND_API.G_MISS_NUM

Line 845: , p_wp_task_version_id IN NUMBER := FND_API.G_MISS_NUM

841: , p_structure_type IN VARCHAR2 := 'WORKPLAN'
842: , p_project_id IN NUMBER
843: , p_wp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
844: , p_wp_prnt_str_ver_id IN NUMBER := FND_API.G_MISS_NUM
845: , p_wp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
846: , p_fp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
847: , p_fp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
848: , p_object_relationship_id IN NUMBER := FND_API.G_MISS_NUM
849: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 846: , p_fp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR

842: , p_project_id IN NUMBER
843: , p_wp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
844: , p_wp_prnt_str_ver_id IN NUMBER := FND_API.G_MISS_NUM
845: , p_wp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
846: , p_fp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
847: , p_fp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
848: , p_object_relationship_id IN NUMBER := FND_API.G_MISS_NUM
849: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
850: , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 847: , p_fp_task_version_id IN NUMBER := FND_API.G_MISS_NUM

843: , p_wp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
844: , p_wp_prnt_str_ver_id IN NUMBER := FND_API.G_MISS_NUM
845: , p_wp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
846: , p_fp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
847: , p_fp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
848: , p_object_relationship_id IN NUMBER := FND_API.G_MISS_NUM
849: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
850: , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
851: , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 848: , p_object_relationship_id IN NUMBER := FND_API.G_MISS_NUM

844: , p_wp_prnt_str_ver_id IN NUMBER := FND_API.G_MISS_NUM
845: , p_wp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
846: , p_fp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
847: , p_fp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
848: , p_object_relationship_id IN NUMBER := FND_API.G_MISS_NUM
849: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
850: , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
851: , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
852: )

Line 926: x_return_status := FND_API.G_RET_STS_SUCCESS;

922:
923: BEGIN
924:
925: x_msg_count := 0;
926: x_return_status := FND_API.G_RET_STS_SUCCESS;
927: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
928:
929: IF l_debug_mode = 'Y' THEN
930: PA_DEBUG.set_curr_function( p_function => 'UPDATE_MAPPING',

Line 934: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

930: PA_DEBUG.set_curr_function( p_function => 'UPDATE_MAPPING',
931: p_debug_mode => l_debug_mode );
932: END IF;
933:
934: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
935: FND_MSG_PUB.initialize;
936: END IF;
937:
938: IF ( p_commit = FND_API.G_TRUE ) THEN

Line 938: IF ( p_commit = FND_API.G_TRUE ) THEN

934: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
935: FND_MSG_PUB.initialize;
936: END IF;
937:
938: IF ( p_commit = FND_API.G_TRUE ) THEN
939: savepoint UPDATE_MAPPING_PUBLIC;
940: END IF;
941:
942: IF l_debug_mode = 'Y' THEN

Line 989: ( p_wp_task_name is NULL OR p_wp_task_name = FND_API.G_MISS_CHAR ) AND

985: -- if fp task id and and fp task name both are null
986: -- raise error
987: IF (
988: (
989: ( p_wp_task_name is NULL OR p_wp_task_name = FND_API.G_MISS_CHAR ) AND
990: ( p_wp_task_version_id is NULL OR p_wp_task_version_id = FND_API.G_MISS_NUM )
991: ) AND
992: (
993: ( p_fp_task_name is NULL OR p_fp_task_name = FND_API.G_MISS_CHAR ) AND

Line 990: ( p_wp_task_version_id is NULL OR p_wp_task_version_id = FND_API.G_MISS_NUM )

986: -- raise error
987: IF (
988: (
989: ( p_wp_task_name is NULL OR p_wp_task_name = FND_API.G_MISS_CHAR ) AND
990: ( p_wp_task_version_id is NULL OR p_wp_task_version_id = FND_API.G_MISS_NUM )
991: ) AND
992: (
993: ( p_fp_task_name is NULL OR p_fp_task_name = FND_API.G_MISS_CHAR ) AND
994: ( p_fp_task_version_id is NULL OR p_fp_task_version_id = FND_API.G_MISS_NUM )

Line 993: ( p_fp_task_name is NULL OR p_fp_task_name = FND_API.G_MISS_CHAR ) AND

989: ( p_wp_task_name is NULL OR p_wp_task_name = FND_API.G_MISS_CHAR ) AND
990: ( p_wp_task_version_id is NULL OR p_wp_task_version_id = FND_API.G_MISS_NUM )
991: ) AND
992: (
993: ( p_fp_task_name is NULL OR p_fp_task_name = FND_API.G_MISS_CHAR ) AND
994: ( p_fp_task_version_id is NULL OR p_fp_task_version_id = FND_API.G_MISS_NUM )
995: )
996: )
997: THEN

Line 994: ( p_fp_task_version_id is NULL OR p_fp_task_version_id = FND_API.G_MISS_NUM )

990: ( p_wp_task_version_id is NULL OR p_wp_task_version_id = FND_API.G_MISS_NUM )
991: ) AND
992: (
993: ( p_fp_task_name is NULL OR p_fp_task_name = FND_API.G_MISS_CHAR ) AND
994: ( p_fp_task_version_id is NULL OR p_fp_task_version_id = FND_API.G_MISS_NUM )
995: )
996: )
997: THEN
998: IF l_debug_mode = 'Y' THEN

Line 1008: ( p_wp_task_version_id IS NULL OR p_wp_task_version_id = FND_API.G_MISS_NUM ) AND

1004: END IF;
1005:
1006: -- Parent structure version id is essential to get task id using task name , so it should be validated
1007: IF (
1008: ( p_wp_task_version_id IS NULL OR p_wp_task_version_id = FND_API.G_MISS_NUM ) AND
1009: (
1010: ( p_wp_task_name IS NOT NULL AND p_wp_task_name <> FND_API.G_MISS_NUM ) AND
1011: ( p_wp_prnt_str_ver_id IS NULL OR p_wp_prnt_str_ver_id = FND_API.G_MISS_NUM )
1012: )

Line 1010: ( p_wp_task_name IS NOT NULL AND p_wp_task_name <> FND_API.G_MISS_NUM ) AND

1006: -- Parent structure version id is essential to get task id using task name , so it should be validated
1007: IF (
1008: ( p_wp_task_version_id IS NULL OR p_wp_task_version_id = FND_API.G_MISS_NUM ) AND
1009: (
1010: ( p_wp_task_name IS NOT NULL AND p_wp_task_name <> FND_API.G_MISS_NUM ) AND
1011: ( p_wp_prnt_str_ver_id IS NULL OR p_wp_prnt_str_ver_id = FND_API.G_MISS_NUM )
1012: )
1013: )
1014: THEN

Line 1011: ( p_wp_prnt_str_ver_id IS NULL OR p_wp_prnt_str_ver_id = FND_API.G_MISS_NUM )

1007: IF (
1008: ( p_wp_task_version_id IS NULL OR p_wp_task_version_id = FND_API.G_MISS_NUM ) AND
1009: (
1010: ( p_wp_task_name IS NOT NULL AND p_wp_task_name <> FND_API.G_MISS_NUM ) AND
1011: ( p_wp_prnt_str_ver_id IS NULL OR p_wp_prnt_str_ver_id = FND_API.G_MISS_NUM )
1012: )
1013: )
1014: THEN
1015: IF l_debug_mode = 'Y' THEN

Line 1023: IF ( p_wp_task_version_id IS NOT NULL AND p_wp_task_version_id <> FND_API.G_MISS_NUM )

1019: END IF;
1020: RAISE Invalid_Arg_Exc_WP;
1021: END IF;
1022:
1023: IF ( p_wp_task_version_id IS NOT NULL AND p_wp_task_version_id <> FND_API.G_MISS_NUM )
1024: THEN
1025: l_wp_task_version_id := p_wp_task_version_id;
1026: ELSIF (
1027: ( p_wp_task_name IS NOT NULL AND p_wp_task_name <> FND_API.G_MISS_CHAR ) AND

Line 1027: ( p_wp_task_name IS NOT NULL AND p_wp_task_name <> FND_API.G_MISS_CHAR ) AND

1023: IF ( p_wp_task_version_id IS NOT NULL AND p_wp_task_version_id <> FND_API.G_MISS_NUM )
1024: THEN
1025: l_wp_task_version_id := p_wp_task_version_id;
1026: ELSIF (
1027: ( p_wp_task_name IS NOT NULL AND p_wp_task_name <> FND_API.G_MISS_CHAR ) AND
1028: ( p_wp_prnt_str_ver_id IS NOT NULL AND p_wp_prnt_str_ver_id <> FND_API.G_MISS_NUM )
1029: )
1030: THEN
1031: --get the wp_task_version_id and place it in l_wp_task_version_id;

Line 1028: ( p_wp_prnt_str_ver_id IS NOT NULL AND p_wp_prnt_str_ver_id <> FND_API.G_MISS_NUM )

1024: THEN
1025: l_wp_task_version_id := p_wp_task_version_id;
1026: ELSIF (
1027: ( p_wp_task_name IS NOT NULL AND p_wp_task_name <> FND_API.G_MISS_CHAR ) AND
1028: ( p_wp_prnt_str_ver_id IS NOT NULL AND p_wp_prnt_str_ver_id <> FND_API.G_MISS_NUM )
1029: )
1030: THEN
1031: --get the wp_task_version_id and place it in l_wp_task_version_id;
1032: OPEN c_get_wp_task_ver_id_frm_name ( p_wp_task_name , p_project_id , p_wp_prnt_str_ver_id );

Line 1038: RAISE FND_API.G_EXC_ERROR ;

1034: IF (c_get_wp_task_ver_id_frm_name%NOTFOUND)
1035: THEN
1036: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
1037: p_msg_name => 'PA_OBJECT_NAME_INV' );
1038: RAISE FND_API.G_EXC_ERROR ;
1039: END IF;
1040: CLOSE c_get_wp_task_ver_id_frm_name;
1041:
1042: END IF;

Line 1043: IF ( p_fp_task_version_id IS NOT NULL AND p_fp_task_version_id <> FND_API.G_MISS_NUM )

1039: END IF;
1040: CLOSE c_get_wp_task_ver_id_frm_name;
1041:
1042: END IF;
1043: IF ( p_fp_task_version_id IS NOT NULL AND p_fp_task_version_id <> FND_API.G_MISS_NUM )
1044: THEN
1045: l_fp_task_version_id := p_fp_task_version_id;
1046:
1047: ELSIF ( p_fp_task_name IS NOT NULL AND p_fp_task_name <> FND_API.G_MISS_CHAR

Line 1047: ELSIF ( p_fp_task_name IS NOT NULL AND p_fp_task_name <> FND_API.G_MISS_CHAR

1043: IF ( p_fp_task_version_id IS NOT NULL AND p_fp_task_version_id <> FND_API.G_MISS_NUM )
1044: THEN
1045: l_fp_task_version_id := p_fp_task_version_id;
1046:
1047: ELSIF ( p_fp_task_name IS NOT NULL AND p_fp_task_name <> FND_API.G_MISS_CHAR
1048: )
1049: THEN
1050: -- get the fp_task_version_id and place it in l_fp_task_version_id;
1051: -- Assuming there will be only one version for the FP task.Parent structure version id is passed

Line 1059: RAISE FND_API.G_EXC_ERROR ;

1055: IF (c_get_fp_task_ver_id_frm_name%NOTFOUND)
1056: THEN
1057: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
1058: p_msg_name => 'PA_OBJECT_NAME_INV' );
1059: RAISE FND_API.G_EXC_ERROR ;
1060: END IF;
1061: CLOSE c_get_fp_task_ver_id_frm_name;
1062: END IF;
1063:

Line 1064: IF ( ( p_object_relationship_id IS NULL OR p_object_relationship_id = FND_API.G_MISS_NUM )

1060: END IF;
1061: CLOSE c_get_fp_task_ver_id_frm_name;
1062: END IF;
1063:
1064: IF ( ( p_object_relationship_id IS NULL OR p_object_relationship_id = FND_API.G_MISS_NUM )
1065: AND
1066: p_calling_module <> 'SELF_SERVICE'
1067: )
1068: THEN

Line 1078: IF ( l_object_relationship_id IS NOT NULL AND l_object_relationship_id <> FND_API.G_MISS_NUM )

1074: l_rec_version_num := p_record_version_number;
1075: END IF;
1076:
1077: --If l_object_relationship_id is not null
1078: IF ( l_object_relationship_id IS NOT NULL AND l_object_relationship_id <> FND_API.G_MISS_NUM )
1079: THEN
1080: --delete the existing mapping
1081: PA_RELATIONSHIP_PUB.DELETE_RELATIONSHIP
1082: (

Line 1084: , p_init_msg_list => FND_API.G_FALSE

1080: --delete the existing mapping
1081: PA_RELATIONSHIP_PUB.DELETE_RELATIONSHIP
1082: (
1083: p_api_version => p_api_version
1084: , p_init_msg_list => FND_API.G_FALSE
1085: , p_commit => p_commit
1086: , p_validate_only => p_validate_only
1087: , p_calling_module => 'SELF_SERVICE'
1088: , p_debug_mode => l_debug_mode

Line 1095: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)

1091: , x_return_status => x_return_status
1092: , x_msg_count => x_msg_count
1093: , x_msg_data => x_msg_data
1094: );
1095: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
1096: THEN
1097: RAISE FND_API.G_EXC_ERROR;
1098: END IF;
1099: END IF;

Line 1097: RAISE FND_API.G_EXC_ERROR;

1093: , x_msg_data => x_msg_data
1094: );
1095: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
1096: THEN
1097: RAISE FND_API.G_EXC_ERROR;
1098: END IF;
1099: END IF;
1100:
1101: --IF l_fp_task_ver_id is not null

Line 1103: (l_fp_task_version_id IS NOT NULL AND l_fp_task_version_id <> FND_API.G_MISS_NUM ) AND

1099: END IF;
1100:
1101: --IF l_fp_task_ver_id is not null
1102: IF (
1103: (l_fp_task_version_id IS NOT NULL AND l_fp_task_version_id <> FND_API.G_MISS_NUM ) AND
1104: (l_wp_task_version_id IS NOT NULL AND l_wp_task_version_id <> FND_API.G_MISS_NUM )
1105: )
1106: THEN
1107: --create new mapping with l_wp_task_ver_id and l_fp_task_ver_id

Line 1104: (l_wp_task_version_id IS NOT NULL AND l_wp_task_version_id <> FND_API.G_MISS_NUM )

1100:
1101: --IF l_fp_task_ver_id is not null
1102: IF (
1103: (l_fp_task_version_id IS NOT NULL AND l_fp_task_version_id <> FND_API.G_MISS_NUM ) AND
1104: (l_wp_task_version_id IS NOT NULL AND l_wp_task_version_id <> FND_API.G_MISS_NUM )
1105: )
1106: THEN
1107: --create new mapping with l_wp_task_ver_id and l_fp_task_ver_id
1108: -- Call CREATE_MAPPING

Line 1113: , p_init_msg_list => FND_API.G_FALSE

1109: PA_PROJ_STRUC_MAPPING_PUB.CREATE_MAPPING(
1110: p_wp_task_version_id => l_wp_task_version_id
1111: , p_fp_task_version_id => l_fp_task_version_id
1112: , p_project_id => p_project_id
1113: , p_init_msg_list => FND_API.G_FALSE
1114: , p_commit => p_commit
1115: , p_debug_mode => l_debug_mode
1116: , x_return_status => x_return_status
1117: , x_msg_count => x_msg_count

Line 1120: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS )

1116: , x_return_status => x_return_status
1117: , x_msg_count => x_msg_count
1118: , x_msg_data => x_msg_data
1119: );
1120: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS )
1121: THEN
1122: RAISE FND_API.G_EXC_ERROR;
1123: END IF;
1124: END IF;

Line 1122: RAISE FND_API.G_EXC_ERROR;

1118: , x_msg_data => x_msg_data
1119: );
1120: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS )
1121: THEN
1122: RAISE FND_API.G_EXC_ERROR;
1123: END IF;
1124: END IF;
1125:
1126: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)

Line 1126: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)

1122: RAISE FND_API.G_EXC_ERROR;
1123: END IF;
1124: END IF;
1125:
1126: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
1127: THEN
1128: RAISE FND_API.G_EXC_ERROR;
1129: END IF;
1130:

Line 1128: RAISE FND_API.G_EXC_ERROR;

1124: END IF;
1125:
1126: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
1127: THEN
1128: RAISE FND_API.G_EXC_ERROR;
1129: END IF;
1130:
1131: IF ( p_commit = FND_API.G_TRUE ) THEN
1132: COMMIT;

Line 1131: IF ( p_commit = FND_API.G_TRUE ) THEN

1127: THEN
1128: RAISE FND_API.G_EXC_ERROR;
1129: END IF;
1130:
1131: IF ( p_commit = FND_API.G_TRUE ) THEN
1132: COMMIT;
1133: END IF;
1134:
1135: EXCEPTION

Line 1137: WHEN FND_API.G_EXC_ERROR THEN

1133: END IF;
1134:
1135: EXCEPTION
1136:
1137: WHEN FND_API.G_EXC_ERROR THEN
1138:
1139: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1140: l_msg_count := Fnd_Msg_Pub.count_msg;
1141:

Line 1139: x_return_status := Fnd_Api.G_RET_STS_ERROR;

1135: EXCEPTION
1136:
1137: WHEN FND_API.G_EXC_ERROR THEN
1138:
1139: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1140: l_msg_count := Fnd_Msg_Pub.count_msg;
1141:
1142: IF ( p_commit = FND_API.G_TRUE ) THEN
1143: ROLLBACK TO UPDATE_MAPPING_PUBLIC;

Line 1142: IF ( p_commit = FND_API.G_TRUE ) THEN

1138:
1139: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1140: l_msg_count := Fnd_Msg_Pub.count_msg;
1141:
1142: IF ( p_commit = FND_API.G_TRUE ) THEN
1143: ROLLBACK TO UPDATE_MAPPING_PUBLIC;
1144: END IF;
1145:
1146: IF cur_get_object_relationship_id%ISOPEN THEN

Line 1161: ( p_encoded => Fnd_Api.G_TRUE

1157:
1158: IF l_msg_count = 1 AND x_msg_data IS NULL
1159: THEN
1160: Pa_Interface_Utils_Pub.get_messages
1161: ( p_encoded => Fnd_Api.G_TRUE
1162: , p_msg_index => 1
1163: , p_msg_count => l_msg_count
1164: , p_msg_data => l_msg_data
1165: , p_data => l_data

Line 1178: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

1174: END IF;
1175:
1176: WHEN Invalid_Arg_Exc_WP THEN
1177:
1178: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1179: x_msg_count := Fnd_Msg_Pub.count_msg;
1180: x_msg_data := 'PA_PROJ_STRUC_MAPPING_PUB : UPDATE_MAPPING : Some parameters are NULL';
1181:
1182: IF ( p_commit = FND_API.G_TRUE ) THEN

Line 1182: IF ( p_commit = FND_API.G_TRUE ) THEN

1178: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1179: x_msg_count := Fnd_Msg_Pub.count_msg;
1180: x_msg_data := 'PA_PROJ_STRUC_MAPPING_PUB : UPDATE_MAPPING : Some parameters are NULL';
1181:
1182: IF ( p_commit = FND_API.G_TRUE ) THEN
1183: ROLLBACK TO UPDATE_MAPPING_PUBLIC;
1184: END IF;
1185:
1186: IF cur_get_object_relationship_id%ISOPEN THEN

Line 1213: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

1209:
1210:
1211: WHEN OTHERS THEN
1212:
1213: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1214: x_msg_count := 1;
1215: x_msg_data := SQLERRM;
1216:
1217: IF ( p_commit = FND_API.G_TRUE ) THEN

Line 1217: IF ( p_commit = FND_API.G_TRUE ) THEN

1213: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1214: x_msg_count := 1;
1215: x_msg_data := SQLERRM;
1216:
1217: IF ( p_commit = FND_API.G_TRUE ) THEN
1218: ROLLBACK TO UPDATE_MAPPING_PUBLIC;
1219: END IF;
1220:
1221: IF cur_get_object_relationship_id%ISOPEN THEN

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

1269:
1270: PROCEDURE COPY_MAPPING
1271: (
1272: p_api_version IN NUMBER := 1.0
1273: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1274: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1275: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
1276: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1277: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

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

1270: PROCEDURE COPY_MAPPING
1271: (
1272: p_api_version IN NUMBER := 1.0
1273: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1274: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1275: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
1276: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1277: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1278: , p_debug_mode IN VARCHAR2 := 'N'

Line 1275: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE

1271: (
1272: p_api_version IN NUMBER := 1.0
1273: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1274: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1275: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
1276: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1277: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1278: , p_debug_mode IN VARCHAR2 := 'N'
1279: , p_record_version_number IN NUMBER := FND_API.G_MISS_NUM

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

1272: p_api_version IN NUMBER := 1.0
1273: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1274: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1275: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
1276: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1277: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1278: , p_debug_mode IN VARCHAR2 := 'N'
1279: , p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
1280: , p_context IN VARCHAR2

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

1275: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
1276: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1277: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1278: , p_debug_mode IN VARCHAR2 := 'N'
1279: , p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
1280: , p_context IN VARCHAR2
1281: , p_src_project_id IN NUMBER := FND_API.G_MISS_NUM
1282: , p_dest_project_id IN NUMBER := FND_API.G_MISS_NUM
1283: , p_src_str_version_id IN NUMBER := FND_API.G_MISS_NUM

Line 1281: , p_src_project_id IN NUMBER := FND_API.G_MISS_NUM

1277: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1278: , p_debug_mode IN VARCHAR2 := 'N'
1279: , p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
1280: , p_context IN VARCHAR2
1281: , p_src_project_id IN NUMBER := FND_API.G_MISS_NUM
1282: , p_dest_project_id IN NUMBER := FND_API.G_MISS_NUM
1283: , p_src_str_version_id IN NUMBER := FND_API.G_MISS_NUM
1284: , p_dest_str_version_id IN NUMBER := FND_API.G_MISS_NUM
1285: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1282: , p_dest_project_id IN NUMBER := FND_API.G_MISS_NUM

1278: , p_debug_mode IN VARCHAR2 := 'N'
1279: , p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
1280: , p_context IN VARCHAR2
1281: , p_src_project_id IN NUMBER := FND_API.G_MISS_NUM
1282: , p_dest_project_id IN NUMBER := FND_API.G_MISS_NUM
1283: , p_src_str_version_id IN NUMBER := FND_API.G_MISS_NUM
1284: , p_dest_str_version_id IN NUMBER := FND_API.G_MISS_NUM
1285: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1286: , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 1283: , p_src_str_version_id IN NUMBER := FND_API.G_MISS_NUM

1279: , p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
1280: , p_context IN VARCHAR2
1281: , p_src_project_id IN NUMBER := FND_API.G_MISS_NUM
1282: , p_dest_project_id IN NUMBER := FND_API.G_MISS_NUM
1283: , p_src_str_version_id IN NUMBER := FND_API.G_MISS_NUM
1284: , p_dest_str_version_id IN NUMBER := FND_API.G_MISS_NUM
1285: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1286: , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1287: , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1284: , p_dest_str_version_id IN NUMBER := FND_API.G_MISS_NUM

1280: , p_context IN VARCHAR2
1281: , p_src_project_id IN NUMBER := FND_API.G_MISS_NUM
1282: , p_dest_project_id IN NUMBER := FND_API.G_MISS_NUM
1283: , p_src_str_version_id IN NUMBER := FND_API.G_MISS_NUM
1284: , p_dest_str_version_id IN NUMBER := FND_API.G_MISS_NUM
1285: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1286: , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1287: , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1288:

Line 1390: x_return_status := FND_API.G_RET_STS_SUCCESS;

1386:
1387:
1388: x_msg_count := 0;
1389: l_user_id := FND_GLOBAL.USER_ID;
1390: x_return_status := FND_API.G_RET_STS_SUCCESS;
1391: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
1392:
1393:
1394: IF l_debug_mode = 'Y' THEN

Line 1410: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

1406: Pa_Debug.WRITE(g_module_name,'p_src_str_version_id'||p_src_str_version_id,l_debug_level3);
1407: Pa_Debug.WRITE(g_module_name,'p_dest_str_version_id'||p_dest_str_version_id,l_debug_level3);
1408: END IF;
1409:
1410: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
1411: FND_MSG_PUB.initialize;
1412: END IF;
1413:
1414: IF l_debug_mode = 'Y' THEN

Line 1432: ( p_src_project_id IS NULL OR p_src_project_id = FND_API.G_MISS_NUM )

1428: --If context is copy_project, src and destination project id must be passed and they should not be same
1429: IF ( p_context ='COPY_PROJECT' ) THEN
1430: IF
1431: (
1432: ( p_src_project_id IS NULL OR p_src_project_id = FND_API.G_MISS_NUM )
1433: OR ( p_dest_project_id IS NULL OR p_dest_project_id = FND_API.G_MISS_NUM )
1434: OR ( p_src_project_id = p_dest_project_id )
1435: )
1436: THEN

Line 1433: OR ( p_dest_project_id IS NULL OR p_dest_project_id = FND_API.G_MISS_NUM )

1429: IF ( p_context ='COPY_PROJECT' ) THEN
1430: IF
1431: (
1432: ( p_src_project_id IS NULL OR p_src_project_id = FND_API.G_MISS_NUM )
1433: OR ( p_dest_project_id IS NULL OR p_dest_project_id = FND_API.G_MISS_NUM )
1434: OR ( p_src_project_id = p_dest_project_id )
1435: )
1436: THEN
1437: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : COPY_MAPPING : if p_context is Copy Project , both src and destination project id will be required';

Line 1557: IF ( ( p_src_str_version_id IS NULL OR p_src_str_version_id = FND_API.G_MISS_NUM )

1553: -- It is assumed that p_src_project_id will be passed in this case
1554: -- src_project_id will make the c_get_mapped_tasks efficient with project Id filter.
1555: ELSIF (p_context = 'CREATE_WORKING_VERSION' OR p_context = 'PUBLISH_VERSION')
1556: THEN
1557: IF ( ( p_src_str_version_id IS NULL OR p_src_str_version_id = FND_API.G_MISS_NUM )
1558: OR( p_dest_str_version_id IS NULL OR p_dest_str_version_id = FND_API.G_MISS_NUM )
1559: OR( p_src_project_id IS NULL OR p_src_project_id = FND_API.G_MISS_NUM )
1560: ) THEN
1561:

Line 1558: OR( p_dest_str_version_id IS NULL OR p_dest_str_version_id = FND_API.G_MISS_NUM )

1554: -- src_project_id will make the c_get_mapped_tasks efficient with project Id filter.
1555: ELSIF (p_context = 'CREATE_WORKING_VERSION' OR p_context = 'PUBLISH_VERSION')
1556: THEN
1557: IF ( ( p_src_str_version_id IS NULL OR p_src_str_version_id = FND_API.G_MISS_NUM )
1558: OR( p_dest_str_version_id IS NULL OR p_dest_str_version_id = FND_API.G_MISS_NUM )
1559: OR( p_src_project_id IS NULL OR p_src_project_id = FND_API.G_MISS_NUM )
1560: ) THEN
1561:
1562: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : COPY_MAPPING : if p_context is create_working_version,both src and destination str ver id will be required';

Line 1559: OR( p_src_project_id IS NULL OR p_src_project_id = FND_API.G_MISS_NUM )

1555: ELSIF (p_context = 'CREATE_WORKING_VERSION' OR p_context = 'PUBLISH_VERSION')
1556: THEN
1557: IF ( ( p_src_str_version_id IS NULL OR p_src_str_version_id = FND_API.G_MISS_NUM )
1558: OR( p_dest_str_version_id IS NULL OR p_dest_str_version_id = FND_API.G_MISS_NUM )
1559: OR( p_src_project_id IS NULL OR p_src_project_id = FND_API.G_MISS_NUM )
1560: ) THEN
1561:
1562: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : COPY_MAPPING : if p_context is create_working_version,both src and destination str ver id will be required';
1563: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,

Line 1665: WHEN FND_API.G_EXC_ERROR THEN

1661: Pa_Debug.WRITE(g_module_name,'After Completing insert',l_debug_level3);
1662:
1663: EXCEPTION
1664:
1665: WHEN FND_API.G_EXC_ERROR THEN
1666:
1667: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1668: l_msg_count := Fnd_Msg_Pub.count_msg;
1669:

Line 1667: x_return_status := Fnd_Api.G_RET_STS_ERROR;

1663: EXCEPTION
1664:
1665: WHEN FND_API.G_EXC_ERROR THEN
1666:
1667: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1668: l_msg_count := Fnd_Msg_Pub.count_msg;
1669:
1670: IF l_msg_count = 1 AND x_msg_data IS NULL
1671: THEN

Line 1673: ( p_encoded => Fnd_Api.G_TRUE

1669:
1670: IF l_msg_count = 1 AND x_msg_data IS NULL
1671: THEN
1672: Pa_Interface_Utils_Pub.get_messages
1673: ( p_encoded => Fnd_Api.G_TRUE
1674: , p_msg_index => 1
1675: , p_msg_count => l_msg_count
1676: , p_msg_data => l_msg_data
1677: , p_data => l_data

Line 1690: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

1686: END IF;
1687:
1688: WHEN Invalid_Arg_Exc_WP THEN
1689:
1690: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1691: x_msg_count := 1;
1692: x_msg_data := 'PA_PROJ_STRUC_MAPPING_PUB : COPY_MAPPING : NULL PARAMETERS ARE PASSED OR CURSOR DIDNT RETURN ANY ROWS';
1693:
1694: Fnd_Msg_Pub.add_exc_msg

Line 1709: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

1705: RAISE;
1706:
1707: WHEN OTHERS THEN
1708:
1709: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1710: x_msg_count := 1;
1711: x_msg_data := SQLERRM;
1712:
1713:

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

1743:
1744: PROCEDURE DELETE_ALL_MAPPING
1745: (
1746: p_api_version IN NUMBER := 1.0
1747: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1748: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1749: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
1750: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1751: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

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

1744: PROCEDURE DELETE_ALL_MAPPING
1745: (
1746: p_api_version IN NUMBER := 1.0
1747: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1748: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1749: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
1750: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1751: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1752: , p_debug_mode IN VARCHAR2 := 'N'

Line 1749: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE

1745: (
1746: p_api_version IN NUMBER := 1.0
1747: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1748: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1749: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
1750: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1751: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1752: , p_debug_mode IN VARCHAR2 := 'N'
1753: , p_project_id IN NUMBER

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

1746: p_api_version IN NUMBER := 1.0
1747: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1748: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1749: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
1750: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1751: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1752: , p_debug_mode IN VARCHAR2 := 'N'
1753: , p_project_id IN NUMBER
1754: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1807: x_return_status := FND_API.G_RET_STS_SUCCESS;

1803:
1804: BEGIN
1805:
1806: x_msg_count := 0;
1807: x_return_status := FND_API.G_RET_STS_SUCCESS;
1808:
1809: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
1810: --l_debug_mode := NVL(p_debug_mode,'N');
1811: IF l_debug_mode = 'Y' THEN

Line 1825: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

1821: Pa_Debug.WRITE(g_module_name,'p_project_id'||':'||p_project_id,
1822: l_debug_level3);
1823: END IF;
1824:
1825: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
1826: FND_MSG_PUB.initialize;
1827: END IF;
1828:
1829: IF (p_commit = FND_API.G_TRUE) THEN

Line 1829: IF (p_commit = FND_API.G_TRUE) THEN

1825: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
1826: FND_MSG_PUB.initialize;
1827: END IF;
1828:
1829: IF (p_commit = FND_API.G_TRUE) THEN
1830: savepoint DELETE_ALL_MAPPING_PUBLIC;
1831: END IF;
1832:
1833: IF l_debug_mode = 'Y' THEN

Line 1864: IF (p_commit = FND_API.G_TRUE) THEN

1860: DELETE FROM PA_OBJECT_RELATIONSHIPS
1861: WHERE
1862: OBJECT_RELATIONSHIP_ID = l_mapped_obj_rel_id_tbl(iCounter);
1863: END IF;
1864: IF (p_commit = FND_API.G_TRUE) THEN
1865: COMMIT;
1866: END IF;
1867:
1868: EXCEPTION

Line 1870: WHEN FND_API.G_EXC_ERROR THEN

1866: END IF;
1867:
1868: EXCEPTION
1869:
1870: WHEN FND_API.G_EXC_ERROR THEN
1871:
1872: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1873: l_msg_count := Fnd_Msg_Pub.count_msg;
1874:

Line 1872: x_return_status := Fnd_Api.G_RET_STS_ERROR;

1868: EXCEPTION
1869:
1870: WHEN FND_API.G_EXC_ERROR THEN
1871:
1872: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1873: l_msg_count := Fnd_Msg_Pub.count_msg;
1874:
1875: IF p_commit = FND_API.G_TRUE THEN
1876: ROLLBACK TO DELETE_ALL_MAPPING_PUBLIC;

Line 1875: IF p_commit = FND_API.G_TRUE THEN

1871:
1872: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1873: l_msg_count := Fnd_Msg_Pub.count_msg;
1874:
1875: IF p_commit = FND_API.G_TRUE THEN
1876: ROLLBACK TO DELETE_ALL_MAPPING_PUBLIC;
1877: END IF;
1878: IF c_get_fin_task_ver_id%ISOPEN THEN
1879: CLOSE c_get_fin_task_ver_id;

Line 1884: ( p_encoded => Fnd_Api.G_TRUE

1880: END IF;
1881: IF l_msg_count = 1 AND x_msg_data IS NULL
1882: THEN
1883: Pa_Interface_Utils_Pub.get_messages
1884: ( p_encoded => Fnd_Api.G_TRUE
1885: , p_msg_index => 1
1886: , p_msg_count => l_msg_count
1887: , p_msg_data => l_msg_data
1888: , p_data => l_data

Line 1901: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

1897: END IF;
1898:
1899: WHEN Invalid_Arg_Exc_WP THEN
1900:
1901: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1902: x_msg_count := 1;
1903: --x_msg_data := 'PA_PROJ_STRUC_MAPPING_PUB : DELETE_ALL_MAPPING : NULL PARAMETERS ARE PASSED OR CURSOR DIDNT RETURN ANY ROWS';
1904:
1905: IF p_commit = FND_API.G_TRUE THEN

Line 1905: IF p_commit = FND_API.G_TRUE THEN

1901: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1902: x_msg_count := 1;
1903: --x_msg_data := 'PA_PROJ_STRUC_MAPPING_PUB : DELETE_ALL_MAPPING : NULL PARAMETERS ARE PASSED OR CURSOR DIDNT RETURN ANY ROWS';
1904:
1905: IF p_commit = FND_API.G_TRUE THEN
1906: ROLLBACK TO DELETE_ALL_MAPPING_PUBLIC;
1907: END IF;
1908: IF c_get_fin_task_ver_id%ISOPEN THEN
1909: CLOSE c_get_fin_task_ver_id;

Line 1926: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

1922: RAISE;
1923:
1924: WHEN OTHERS THEN
1925:
1926: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1927: x_msg_count := 1;
1928: x_msg_data := SQLERRM;
1929:
1930: IF p_commit = FND_API.G_TRUE THEN

Line 1930: IF p_commit = FND_API.G_TRUE THEN

1926: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1927: x_msg_count := 1;
1928: x_msg_data := SQLERRM;
1929:
1930: IF p_commit = FND_API.G_TRUE THEN
1931: ROLLBACK TO DELETE_ALL_MAPPING_PUBLIC;
1932: END IF;
1933:
1934: IF c_get_fin_task_ver_id%ISOPEN THEN