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 511: x_return_status := FND_API.G_RET_STS_SUCCESS;

507:
508: BEGIN
509:
510: x_msg_count := 0;
511: x_return_status := FND_API.G_RET_STS_SUCCESS;
512: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
513:
514: IF l_debug_mode = 'Y' THEN
515: PA_DEBUG.set_curr_function( p_function => 'CREATE_MAPPING',

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

515: PA_DEBUG.set_curr_function( p_function => 'CREATE_MAPPING',
516: p_debug_mode => l_debug_mode );
517: END IF;
518:
519: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
520: FND_MSG_PUB.initialize;
521: END IF;
522:
523: IF (p_commit = FND_API.G_TRUE) THEN

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

519: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
520: FND_MSG_PUB.initialize;
521: END IF;
522:
523: IF (p_commit = FND_API.G_TRUE) THEN
524: savepoint CREATE_MAPPING_PUBLIC;
525: END IF;
526:
527: IF l_debug_mode = 'Y' THEN

Line 584: RAISE FND_API.G_EXC_ERROR ;

580: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
581: p_msg_name => 'PA_CM_SUB_TASK_MAP',
582: p_token1=>'PATC_MSG_TOKEN1',
583: p_value1=>l_msg_token1);
584: RAISE FND_API.G_EXC_ERROR ;
585:
586:
587: End If;
588: /*Bug 8574986 END*/

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

591: -- if fp task id and and fp task name both are null
592: -- raise error
593: IF (
594: (
595: ( p_wp_task_name is NULL OR p_wp_task_name = FND_API.G_MISS_CHAR ) AND
596: ( p_wp_task_version_id is NULL OR p_wp_task_version_id = FND_API.G_MISS_NUM )
597: ) OR
598: (
599: ( p_fp_task_name is NULL OR p_fp_task_name = FND_API.G_MISS_CHAR ) AND

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

592: -- raise error
593: IF (
594: (
595: ( p_wp_task_name is NULL OR p_wp_task_name = FND_API.G_MISS_CHAR ) AND
596: ( p_wp_task_version_id is NULL OR p_wp_task_version_id = FND_API.G_MISS_NUM )
597: ) OR
598: (
599: ( p_fp_task_name is NULL OR p_fp_task_name = FND_API.G_MISS_CHAR ) AND
600: ( p_fp_task_version_id is NULL OR p_fp_task_version_id = FND_API.G_MISS_NUM )

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

595: ( p_wp_task_name is NULL OR p_wp_task_name = FND_API.G_MISS_CHAR ) AND
596: ( p_wp_task_version_id is NULL OR p_wp_task_version_id = FND_API.G_MISS_NUM )
597: ) OR
598: (
599: ( p_fp_task_name is NULL OR p_fp_task_name = FND_API.G_MISS_CHAR ) AND
600: ( p_fp_task_version_id is NULL OR p_fp_task_version_id = FND_API.G_MISS_NUM )
601: )
602: )
603: THEN

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

596: ( p_wp_task_version_id is NULL OR p_wp_task_version_id = FND_API.G_MISS_NUM )
597: ) OR
598: (
599: ( p_fp_task_name is NULL OR p_fp_task_name = FND_API.G_MISS_CHAR ) AND
600: ( p_fp_task_version_id is NULL OR p_fp_task_version_id = FND_API.G_MISS_NUM )
601: )
602: )
603: THEN
604: IF l_debug_mode = 'Y' THEN

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

610: END IF;
611:
612: -- Parent structure version id is essential to get task id using task name , so it should be validated
613: IF (
614: ( p_wp_task_version_id IS NULL OR p_wp_task_version_id = FND_API.G_MISS_NUM ) AND
615: (
616: ( p_wp_task_name IS NOT NULL AND p_wp_task_name <> FND_API.G_MISS_CHAR ) AND
617: ( p_parent_str_version_id IS NULL OR p_parent_str_version_id = FND_API.G_MISS_NUM )
618: )

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

612: -- Parent structure version id is essential to get task id using task name , so it should be validated
613: IF (
614: ( p_wp_task_version_id IS NULL OR p_wp_task_version_id = FND_API.G_MISS_NUM ) AND
615: (
616: ( p_wp_task_name IS NOT NULL AND p_wp_task_name <> FND_API.G_MISS_CHAR ) AND
617: ( p_parent_str_version_id IS NULL OR p_parent_str_version_id = FND_API.G_MISS_NUM )
618: )
619: )
620: THEN

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

613: IF (
614: ( p_wp_task_version_id IS NULL OR p_wp_task_version_id = FND_API.G_MISS_NUM ) AND
615: (
616: ( p_wp_task_name IS NOT NULL AND p_wp_task_name <> FND_API.G_MISS_CHAR ) AND
617: ( p_parent_str_version_id IS NULL OR p_parent_str_version_id = FND_API.G_MISS_NUM )
618: )
619: )
620: THEN
621: IF l_debug_mode = 'Y' THEN

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

627: END IF;
628:
629: -- If the task name is passed insteand of task id, we need to fetch the task id
630:
631: IF ( p_wp_task_version_id IS NOT NULL AND p_wp_task_version_id <> FND_API.G_MISS_NUM )
632: THEN
633: l_wp_task_version_id := p_wp_task_version_id;
634:
635: ELSIF

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

632: THEN
633: l_wp_task_version_id := p_wp_task_version_id;
634:
635: ELSIF
636: ( ( p_wp_task_name IS NOT NULL AND p_wp_task_name <> FND_API.G_MISS_CHAR )AND
637: ( p_parent_str_version_id IS NOT NULL AND p_parent_str_version_id <> FND_API.G_MISS_NUM )
638: )
639: THEN
640: --select the wp_task_version_id for the corresponding name and store it in l_wp_task_version_id

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

633: l_wp_task_version_id := p_wp_task_version_id;
634:
635: ELSIF
636: ( ( p_wp_task_name IS NOT NULL AND p_wp_task_name <> FND_API.G_MISS_CHAR )AND
637: ( p_parent_str_version_id IS NOT NULL AND p_parent_str_version_id <> FND_API.G_MISS_NUM )
638: )
639: THEN
640: --select the wp_task_version_id for the corresponding name and store it in l_wp_task_version_id
641:

Line 649: RAISE FND_API.G_EXC_ERROR ;

645: IF ( c_get_wp_task_ver_id_frm_name%NOTFOUND )
646: THEN
647: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
648: p_msg_name => 'PA_OBJECT_NAME_INV' );
649: RAISE FND_API.G_EXC_ERROR ;
650: END IF;
651: CLOSE c_get_wp_task_ver_id_frm_name ;
652:
653: END IF;

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

651: CLOSE c_get_wp_task_ver_id_frm_name ;
652:
653: END IF;
654:
655: IF ( ( p_fp_task_version_id IS NOT NULL AND p_fp_task_version_id <> FND_API.G_MISS_NUM )
656: )
657: THEN
658: l_fp_task_version_id := p_fp_task_version_id;
659:

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

656: )
657: THEN
658: l_fp_task_version_id := p_fp_task_version_id;
659:
660: ELSIF ( p_fp_task_name IS NOT NULL AND p_fp_task_name <> FND_API.G_MISS_CHAR )
661: THEN
662: -- get the fp_task_version_id and place it in l_fp_task_version_id;
663: -- Assuming there will be only one version for the FP task.
664: Pa_Debug.WRITE('test',l_fp_task_version_id, l_debug_level3);

Line 671: RAISE FND_API.G_EXC_ERROR ;

667: IF ( c_get_fp_task_ver_id_frm_name%NOTFOUND )
668: THEN
669: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
670: p_msg_name => 'PA_OBJECT_NAME_INV' );
671: RAISE FND_API.G_EXC_ERROR ;
672: END IF;
673: CLOSE c_get_fp_task_ver_id_frm_name ;
674:
675: END IF;

Line 696: IF l_create_mapping_ok <> FND_API.G_RET_STS_SUCCESS

692: );
693:
694: x_return_status := l_create_mapping_ok;
695:
696: IF l_create_mapping_ok <> FND_API.G_RET_STS_SUCCESS
697: THEN
698:
699: -- Mapping can't be created
700: IF l_debug_mode = 'Y' THEN

Line 708: RAISE FND_API.G_EXC_ERROR;

704: END IF;
705: Pa_Utils.ADD_MESSAGE
706: ( p_app_short_name => 'PA',
707: p_msg_name => l_error_message_code);
708: RAISE FND_API.G_EXC_ERROR;
709: ELSE
710: -- Mapping Can be created, call public API to create mapping
711: IF l_debug_mode = 'Y' THEN
712: 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 721: p_init_msg_list => FND_API.G_FALSE

717: --Call public API to create the mapping
718:
719: PA_RELATIONSHIP_PUB.CREATE_RELATIONSHIP
720: (
721: p_init_msg_list => FND_API.G_FALSE
722: , p_commit => p_commit
723: , p_debug_mode => l_debug_mode
724: , p_project_id_from => p_project_id
725: , p_task_version_id_from => l_wp_task_version_id

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

734: , x_msg_data => x_msg_data
735:
736: );
737: END IF;
738: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
739: RAISE FND_API.G_EXC_ERROR;
740: END IF;
741: IF (p_commit = FND_API.G_TRUE) THEN
742: COMMIT;

Line 739: RAISE FND_API.G_EXC_ERROR;

735:
736: );
737: END IF;
738: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
739: RAISE FND_API.G_EXC_ERROR;
740: END IF;
741: IF (p_commit = FND_API.G_TRUE) THEN
742: COMMIT;
743: END IF;

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

737: END IF;
738: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
739: RAISE FND_API.G_EXC_ERROR;
740: END IF;
741: IF (p_commit = FND_API.G_TRUE) THEN
742: COMMIT;
743: END IF;
744:
745: EXCEPTION

Line 747: WHEN FND_API.G_EXC_ERROR THEN

743: END IF;
744:
745: EXCEPTION
746:
747: WHEN FND_API.G_EXC_ERROR THEN
748:
749: x_return_status := Fnd_Api.G_RET_STS_ERROR;
750: l_msg_count := Fnd_Msg_Pub.count_msg;
751:

Line 749: x_return_status := Fnd_Api.G_RET_STS_ERROR;

745: EXCEPTION
746:
747: WHEN FND_API.G_EXC_ERROR THEN
748:
749: x_return_status := Fnd_Api.G_RET_STS_ERROR;
750: l_msg_count := Fnd_Msg_Pub.count_msg;
751:
752: IF (p_commit = FND_API.G_TRUE) THEN
753: ROLLBACK TO CREATE_MAPPING_PUBLIC;

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

748:
749: x_return_status := Fnd_Api.G_RET_STS_ERROR;
750: l_msg_count := Fnd_Msg_Pub.count_msg;
751:
752: IF (p_commit = FND_API.G_TRUE) THEN
753: ROLLBACK TO CREATE_MAPPING_PUBLIC;
754: END IF;
755:
756: IF l_msg_count = 1 AND x_msg_data IS NULL

Line 759: ( p_encoded => Fnd_Api.G_TRUE

755:
756: IF l_msg_count = 1 AND x_msg_data IS NULL
757: THEN
758: Pa_Interface_Utils_Pub.get_messages
759: ( p_encoded => Fnd_Api.G_TRUE
760: , p_msg_index => 1
761: , p_msg_count => l_msg_count
762: , p_msg_data => l_msg_data
763: , p_data => l_data

Line 776: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

772: END IF;
773:
774: WHEN Invalid_Arg_Exc_WP THEN
775:
776: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
777: x_msg_count := 1;
778: x_msg_data := 'PA_PROJ_STRUC_MAPPING_PUB : CREATE_MAPPING : NULL arguments are passed to the procedure';
779:
780: IF (p_commit = FND_API.G_TRUE) THEN

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

776: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
777: x_msg_count := 1;
778: x_msg_data := 'PA_PROJ_STRUC_MAPPING_PUB : CREATE_MAPPING : NULL arguments are passed to the procedure';
779:
780: IF (p_commit = FND_API.G_TRUE) THEN
781: ROLLBACK TO CREATE_MAPPING_PUBLIC;
782: END IF;
783:
784: Fnd_Msg_Pub.add_exc_msg

Line 800: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

796:
797:
798: WHEN OTHERS THEN
799:
800: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
801: x_msg_count := 1;
802: x_msg_data := SQLERRM;
803:
804: IF (p_commit = FND_API.G_TRUE) THEN

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

800: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
801: x_msg_count := 1;
802: x_msg_data := SQLERRM;
803:
804: IF (p_commit = FND_API.G_TRUE) THEN
805: ROLLBACK TO CREATE_MAPPING_PUBLIC;
806: END IF;
807: Pa_Debug.g_err_stage:= 'x_msg_count='||x_msg_count;
808: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage, l_debug_level5);

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

861:
862: PROCEDURE UPDATE_MAPPING
863: (
864: p_api_version IN NUMBER := 1.0
865: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
866: , p_commit IN VARCHAR2 := FND_API.G_FALSE
867: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
868: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
869: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

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

862: PROCEDURE UPDATE_MAPPING
863: (
864: p_api_version IN NUMBER := 1.0
865: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
866: , p_commit IN VARCHAR2 := FND_API.G_FALSE
867: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
868: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
869: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
870: , p_debug_mode IN VARCHAR2 := 'N'

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

863: (
864: p_api_version IN NUMBER := 1.0
865: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
866: , p_commit IN VARCHAR2 := FND_API.G_FALSE
867: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
868: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
869: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
870: , p_debug_mode IN VARCHAR2 := 'N'
871: , p_record_version_number IN NUMBER := FND_API.G_MISS_NUM

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

864: p_api_version IN NUMBER := 1.0
865: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
866: , p_commit IN VARCHAR2 := FND_API.G_FALSE
867: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
868: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
869: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
870: , p_debug_mode IN VARCHAR2 := 'N'
871: , p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
872: , p_structure_type IN VARCHAR2 := 'WORKPLAN'

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

867: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
868: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
869: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
870: , p_debug_mode IN VARCHAR2 := 'N'
871: , p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
872: , p_structure_type IN VARCHAR2 := 'WORKPLAN'
873: , p_project_id IN NUMBER
874: , p_wp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
875: , p_wp_prnt_str_ver_id IN NUMBER := FND_API.G_MISS_NUM

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

870: , p_debug_mode IN VARCHAR2 := 'N'
871: , p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
872: , p_structure_type IN VARCHAR2 := 'WORKPLAN'
873: , p_project_id IN NUMBER
874: , p_wp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
875: , p_wp_prnt_str_ver_id IN NUMBER := FND_API.G_MISS_NUM
876: , p_wp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
877: , p_fp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
878: , p_fp_task_version_id IN NUMBER := FND_API.G_MISS_NUM

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

871: , p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
872: , p_structure_type IN VARCHAR2 := 'WORKPLAN'
873: , p_project_id IN NUMBER
874: , p_wp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
875: , p_wp_prnt_str_ver_id IN NUMBER := FND_API.G_MISS_NUM
876: , p_wp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
877: , p_fp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
878: , p_fp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
879: , p_object_relationship_id IN NUMBER := FND_API.G_MISS_NUM

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

872: , p_structure_type IN VARCHAR2 := 'WORKPLAN'
873: , p_project_id IN NUMBER
874: , p_wp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
875: , p_wp_prnt_str_ver_id IN NUMBER := FND_API.G_MISS_NUM
876: , p_wp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
877: , p_fp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
878: , p_fp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
879: , p_object_relationship_id IN NUMBER := FND_API.G_MISS_NUM
880: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

873: , p_project_id IN NUMBER
874: , p_wp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
875: , p_wp_prnt_str_ver_id IN NUMBER := FND_API.G_MISS_NUM
876: , p_wp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
877: , p_fp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
878: , p_fp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
879: , p_object_relationship_id IN NUMBER := FND_API.G_MISS_NUM
880: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
881: , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

874: , p_wp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
875: , p_wp_prnt_str_ver_id IN NUMBER := FND_API.G_MISS_NUM
876: , p_wp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
877: , p_fp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
878: , p_fp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
879: , p_object_relationship_id IN NUMBER := FND_API.G_MISS_NUM
880: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
881: , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
882: , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

875: , p_wp_prnt_str_ver_id IN NUMBER := FND_API.G_MISS_NUM
876: , p_wp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
877: , p_fp_task_name IN VARCHAR2 := FND_API.G_MISS_CHAR
878: , p_fp_task_version_id IN NUMBER := FND_API.G_MISS_NUM
879: , p_object_relationship_id IN NUMBER := FND_API.G_MISS_NUM
880: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
881: , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
882: , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
883: )

Line 957: x_return_status := FND_API.G_RET_STS_SUCCESS;

953:
954: BEGIN
955:
956: x_msg_count := 0;
957: x_return_status := FND_API.G_RET_STS_SUCCESS;
958: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
959:
960:
961: IF l_debug_mode = 'Y' THEN

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

962: PA_DEBUG.set_curr_function( p_function => 'UPDATE_MAPPING',
963: p_debug_mode => l_debug_mode );
964: END IF;
965:
966: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
967: FND_MSG_PUB.initialize;
968: END IF;
969:
970: IF ( p_commit = FND_API.G_TRUE ) THEN

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

966: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
967: FND_MSG_PUB.initialize;
968: END IF;
969:
970: IF ( p_commit = FND_API.G_TRUE ) THEN
971: savepoint UPDATE_MAPPING_PUBLIC;
972: END IF;
973:
974: IF l_debug_mode = 'Y' THEN

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

1017: -- if fp task id and and fp task name both are null
1018: -- raise error
1019: IF (
1020: (
1021: ( p_wp_task_name is NULL OR p_wp_task_name = FND_API.G_MISS_CHAR ) AND
1022: ( p_wp_task_version_id is NULL OR p_wp_task_version_id = FND_API.G_MISS_NUM )
1023: ) AND
1024: (
1025: ( p_fp_task_name is NULL OR p_fp_task_name = FND_API.G_MISS_CHAR ) AND

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

1018: -- raise error
1019: IF (
1020: (
1021: ( p_wp_task_name is NULL OR p_wp_task_name = FND_API.G_MISS_CHAR ) AND
1022: ( p_wp_task_version_id is NULL OR p_wp_task_version_id = FND_API.G_MISS_NUM )
1023: ) AND
1024: (
1025: ( p_fp_task_name is NULL OR p_fp_task_name = FND_API.G_MISS_CHAR ) AND
1026: ( p_fp_task_version_id is NULL OR p_fp_task_version_id = FND_API.G_MISS_NUM )

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

1021: ( p_wp_task_name is NULL OR p_wp_task_name = FND_API.G_MISS_CHAR ) AND
1022: ( p_wp_task_version_id is NULL OR p_wp_task_version_id = FND_API.G_MISS_NUM )
1023: ) AND
1024: (
1025: ( p_fp_task_name is NULL OR p_fp_task_name = FND_API.G_MISS_CHAR ) AND
1026: ( p_fp_task_version_id is NULL OR p_fp_task_version_id = FND_API.G_MISS_NUM )
1027: )
1028: )
1029: THEN

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

1022: ( p_wp_task_version_id is NULL OR p_wp_task_version_id = FND_API.G_MISS_NUM )
1023: ) AND
1024: (
1025: ( p_fp_task_name is NULL OR p_fp_task_name = FND_API.G_MISS_CHAR ) AND
1026: ( p_fp_task_version_id is NULL OR p_fp_task_version_id = FND_API.G_MISS_NUM )
1027: )
1028: )
1029: THEN
1030: IF l_debug_mode = 'Y' THEN

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

1036: END IF;
1037:
1038: -- Parent structure version id is essential to get task id using task name , so it should be validated
1039: IF (
1040: ( p_wp_task_version_id IS NULL OR p_wp_task_version_id = FND_API.G_MISS_NUM ) AND
1041: (
1042: ( p_wp_task_name IS NOT NULL AND p_wp_task_name <> FND_API.G_MISS_NUM ) AND
1043: ( p_wp_prnt_str_ver_id IS NULL OR p_wp_prnt_str_ver_id = FND_API.G_MISS_NUM )
1044: )

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

1038: -- Parent structure version id is essential to get task id using task name , so it should be validated
1039: IF (
1040: ( p_wp_task_version_id IS NULL OR p_wp_task_version_id = FND_API.G_MISS_NUM ) AND
1041: (
1042: ( p_wp_task_name IS NOT NULL AND p_wp_task_name <> FND_API.G_MISS_NUM ) AND
1043: ( p_wp_prnt_str_ver_id IS NULL OR p_wp_prnt_str_ver_id = FND_API.G_MISS_NUM )
1044: )
1045: )
1046: THEN

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

1039: IF (
1040: ( p_wp_task_version_id IS NULL OR p_wp_task_version_id = FND_API.G_MISS_NUM ) AND
1041: (
1042: ( p_wp_task_name IS NOT NULL AND p_wp_task_name <> FND_API.G_MISS_NUM ) AND
1043: ( p_wp_prnt_str_ver_id IS NULL OR p_wp_prnt_str_ver_id = FND_API.G_MISS_NUM )
1044: )
1045: )
1046: THEN
1047: IF l_debug_mode = 'Y' THEN

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

1051: END IF;
1052: RAISE Invalid_Arg_Exc_WP;
1053: END IF;
1054:
1055: IF ( p_wp_task_version_id IS NOT NULL AND p_wp_task_version_id <> FND_API.G_MISS_NUM )
1056: THEN
1057: l_wp_task_version_id := p_wp_task_version_id;
1058: ELSIF (
1059: ( p_wp_task_name IS NOT NULL AND p_wp_task_name <> FND_API.G_MISS_CHAR ) AND

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

1055: IF ( p_wp_task_version_id IS NOT NULL AND p_wp_task_version_id <> FND_API.G_MISS_NUM )
1056: THEN
1057: l_wp_task_version_id := p_wp_task_version_id;
1058: ELSIF (
1059: ( p_wp_task_name IS NOT NULL AND p_wp_task_name <> FND_API.G_MISS_CHAR ) AND
1060: ( p_wp_prnt_str_ver_id IS NOT NULL AND p_wp_prnt_str_ver_id <> FND_API.G_MISS_NUM )
1061: )
1062: THEN
1063: --get the wp_task_version_id and place it in l_wp_task_version_id;

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

1056: THEN
1057: l_wp_task_version_id := p_wp_task_version_id;
1058: ELSIF (
1059: ( p_wp_task_name IS NOT NULL AND p_wp_task_name <> FND_API.G_MISS_CHAR ) AND
1060: ( p_wp_prnt_str_ver_id IS NOT NULL AND p_wp_prnt_str_ver_id <> FND_API.G_MISS_NUM )
1061: )
1062: THEN
1063: --get the wp_task_version_id and place it in l_wp_task_version_id;
1064: OPEN c_get_wp_task_ver_id_frm_name ( p_wp_task_name , p_project_id , p_wp_prnt_str_ver_id );

Line 1070: RAISE FND_API.G_EXC_ERROR ;

1066: IF (c_get_wp_task_ver_id_frm_name%NOTFOUND)
1067: THEN
1068: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
1069: p_msg_name => 'PA_OBJECT_NAME_INV' );
1070: RAISE FND_API.G_EXC_ERROR ;
1071: END IF;
1072: CLOSE c_get_wp_task_ver_id_frm_name;
1073:
1074: END IF;

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

1071: END IF;
1072: CLOSE c_get_wp_task_ver_id_frm_name;
1073:
1074: END IF;
1075: IF ( p_fp_task_version_id IS NOT NULL AND p_fp_task_version_id <> FND_API.G_MISS_NUM )
1076: THEN
1077: l_fp_task_version_id := p_fp_task_version_id;
1078:
1079: ELSIF ( p_fp_task_name IS NOT NULL AND p_fp_task_name <> FND_API.G_MISS_CHAR

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

1075: IF ( p_fp_task_version_id IS NOT NULL AND p_fp_task_version_id <> FND_API.G_MISS_NUM )
1076: THEN
1077: l_fp_task_version_id := p_fp_task_version_id;
1078:
1079: ELSIF ( p_fp_task_name IS NOT NULL AND p_fp_task_name <> FND_API.G_MISS_CHAR
1080: )
1081: THEN
1082: -- get the fp_task_version_id and place it in l_fp_task_version_id;
1083: -- Assuming there will be only one version for the FP task.Parent structure version id is passed

Line 1091: RAISE FND_API.G_EXC_ERROR ;

1087: IF (c_get_fp_task_ver_id_frm_name%NOTFOUND)
1088: THEN
1089: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
1090: p_msg_name => 'PA_OBJECT_NAME_INV' );
1091: RAISE FND_API.G_EXC_ERROR ;
1092: END IF;
1093: CLOSE c_get_fp_task_ver_id_frm_name;
1094: END IF;
1095:

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

1092: END IF;
1093: CLOSE c_get_fp_task_ver_id_frm_name;
1094: END IF;
1095:
1096: IF ( ( p_object_relationship_id IS NULL OR p_object_relationship_id = FND_API.G_MISS_NUM )
1097: AND
1098: p_calling_module <> 'SELF_SERVICE'
1099: )
1100: THEN

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

1106: l_rec_version_num := p_record_version_number;
1107: END IF;
1108:
1109: --If l_object_relationship_id is not null
1110: IF ( l_object_relationship_id IS NOT NULL AND l_object_relationship_id <> FND_API.G_MISS_NUM )
1111: THEN
1112: --delete the existing mapping
1113: PA_RELATIONSHIP_PUB.DELETE_RELATIONSHIP
1114: (

Line 1116: , p_init_msg_list => FND_API.G_FALSE

1112: --delete the existing mapping
1113: PA_RELATIONSHIP_PUB.DELETE_RELATIONSHIP
1114: (
1115: p_api_version => p_api_version
1116: , p_init_msg_list => FND_API.G_FALSE
1117: , p_commit => p_commit
1118: , p_validate_only => p_validate_only
1119: , p_calling_module => 'SELF_SERVICE'
1120: , p_debug_mode => l_debug_mode

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

1123: , x_return_status => x_return_status
1124: , x_msg_count => x_msg_count
1125: , x_msg_data => x_msg_data
1126: );
1127: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
1128: THEN
1129: RAISE FND_API.G_EXC_ERROR;
1130: END IF;
1131: END IF;

Line 1129: RAISE FND_API.G_EXC_ERROR;

1125: , x_msg_data => x_msg_data
1126: );
1127: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
1128: THEN
1129: RAISE FND_API.G_EXC_ERROR;
1130: END IF;
1131: END IF;
1132:
1133: --IF l_fp_task_ver_id is not null

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

1131: END IF;
1132:
1133: --IF l_fp_task_ver_id is not null
1134: IF (
1135: (l_fp_task_version_id IS NOT NULL AND l_fp_task_version_id <> FND_API.G_MISS_NUM ) AND
1136: (l_wp_task_version_id IS NOT NULL AND l_wp_task_version_id <> FND_API.G_MISS_NUM )
1137: )
1138: THEN
1139: --create new mapping with l_wp_task_ver_id and l_fp_task_ver_id

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

1132:
1133: --IF l_fp_task_ver_id is not null
1134: IF (
1135: (l_fp_task_version_id IS NOT NULL AND l_fp_task_version_id <> FND_API.G_MISS_NUM ) AND
1136: (l_wp_task_version_id IS NOT NULL AND l_wp_task_version_id <> FND_API.G_MISS_NUM )
1137: )
1138: THEN
1139: --create new mapping with l_wp_task_ver_id and l_fp_task_ver_id
1140: -- Call CREATE_MAPPING

Line 1145: , p_init_msg_list => FND_API.G_FALSE

1141: PA_PROJ_STRUC_MAPPING_PUB.CREATE_MAPPING(
1142: p_wp_task_version_id => l_wp_task_version_id
1143: , p_fp_task_version_id => l_fp_task_version_id
1144: , p_project_id => p_project_id
1145: , p_init_msg_list => FND_API.G_FALSE
1146: , p_commit => p_commit
1147: , p_debug_mode => l_debug_mode
1148: , x_return_status => x_return_status
1149: , x_msg_count => x_msg_count

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

1148: , x_return_status => x_return_status
1149: , x_msg_count => x_msg_count
1150: , x_msg_data => x_msg_data
1151: );
1152: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS )
1153: THEN
1154: RAISE FND_API.G_EXC_ERROR;
1155: END IF;
1156: END IF;

Line 1154: RAISE FND_API.G_EXC_ERROR;

1150: , x_msg_data => x_msg_data
1151: );
1152: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS )
1153: THEN
1154: RAISE FND_API.G_EXC_ERROR;
1155: END IF;
1156: END IF;
1157:
1158: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)

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

1154: RAISE FND_API.G_EXC_ERROR;
1155: END IF;
1156: END IF;
1157:
1158: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
1159: THEN
1160: RAISE FND_API.G_EXC_ERROR;
1161: END IF;
1162:

Line 1160: RAISE FND_API.G_EXC_ERROR;

1156: END IF;
1157:
1158: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
1159: THEN
1160: RAISE FND_API.G_EXC_ERROR;
1161: END IF;
1162:
1163: IF ( p_commit = FND_API.G_TRUE ) THEN
1164: COMMIT;

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

1159: THEN
1160: RAISE FND_API.G_EXC_ERROR;
1161: END IF;
1162:
1163: IF ( p_commit = FND_API.G_TRUE ) THEN
1164: COMMIT;
1165: END IF;
1166:
1167: -- Bug 10053423

Line 1175: WHEN FND_API.G_EXC_ERROR THEN

1171: END IF;
1172:
1173: EXCEPTION
1174:
1175: WHEN FND_API.G_EXC_ERROR THEN
1176:
1177: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1178: l_msg_count := Fnd_Msg_Pub.count_msg;
1179:

Line 1177: x_return_status := Fnd_Api.G_RET_STS_ERROR;

1173: EXCEPTION
1174:
1175: WHEN FND_API.G_EXC_ERROR THEN
1176:
1177: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1178: l_msg_count := Fnd_Msg_Pub.count_msg;
1179:
1180: IF ( p_commit = FND_API.G_TRUE ) THEN
1181: ROLLBACK TO UPDATE_MAPPING_PUBLIC;

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

1176:
1177: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1178: l_msg_count := Fnd_Msg_Pub.count_msg;
1179:
1180: IF ( p_commit = FND_API.G_TRUE ) THEN
1181: ROLLBACK TO UPDATE_MAPPING_PUBLIC;
1182: END IF;
1183:
1184: IF cur_get_object_relationship_id%ISOPEN THEN

Line 1199: ( p_encoded => Fnd_Api.G_TRUE

1195:
1196: IF l_msg_count = 1 AND x_msg_data IS NULL
1197: THEN
1198: Pa_Interface_Utils_Pub.get_messages
1199: ( p_encoded => Fnd_Api.G_TRUE
1200: , p_msg_index => 1
1201: , p_msg_count => l_msg_count
1202: , p_msg_data => l_msg_data
1203: , p_data => l_data

Line 1216: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

1212: END IF;
1213:
1214: WHEN Invalid_Arg_Exc_WP THEN
1215:
1216: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1217: x_msg_count := Fnd_Msg_Pub.count_msg;
1218: x_msg_data := 'PA_PROJ_STRUC_MAPPING_PUB : UPDATE_MAPPING : Some parameters are NULL';
1219:
1220: IF ( p_commit = FND_API.G_TRUE ) THEN

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

1216: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1217: x_msg_count := Fnd_Msg_Pub.count_msg;
1218: x_msg_data := 'PA_PROJ_STRUC_MAPPING_PUB : UPDATE_MAPPING : Some parameters are NULL';
1219:
1220: IF ( p_commit = FND_API.G_TRUE ) THEN
1221: ROLLBACK TO UPDATE_MAPPING_PUBLIC;
1222: END IF;
1223:
1224: IF cur_get_object_relationship_id%ISOPEN THEN

Line 1251: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

1247:
1248:
1249: WHEN OTHERS THEN
1250:
1251: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1252: x_msg_count := 1;
1253: x_msg_data := SQLERRM;
1254:
1255: IF ( p_commit = FND_API.G_TRUE ) THEN

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

1251: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1252: x_msg_count := 1;
1253: x_msg_data := SQLERRM;
1254:
1255: IF ( p_commit = FND_API.G_TRUE ) THEN
1256: ROLLBACK TO UPDATE_MAPPING_PUBLIC;
1257: END IF;
1258:
1259: IF cur_get_object_relationship_id%ISOPEN THEN

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

1307:
1308: PROCEDURE COPY_MAPPING
1309: (
1310: p_api_version IN NUMBER := 1.0
1311: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1312: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1313: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
1314: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1315: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

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

1308: PROCEDURE COPY_MAPPING
1309: (
1310: p_api_version IN NUMBER := 1.0
1311: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1312: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1313: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
1314: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1315: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1316: , p_debug_mode IN VARCHAR2 := 'N'

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

1309: (
1310: p_api_version IN NUMBER := 1.0
1311: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1312: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1313: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
1314: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1315: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1316: , p_debug_mode IN VARCHAR2 := 'N'
1317: , p_record_version_number IN NUMBER := FND_API.G_MISS_NUM

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

1310: p_api_version IN NUMBER := 1.0
1311: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1312: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1313: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
1314: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1315: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1316: , p_debug_mode IN VARCHAR2 := 'N'
1317: , p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
1318: , p_context IN VARCHAR2

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

1313: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
1314: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1315: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1316: , p_debug_mode IN VARCHAR2 := 'N'
1317: , p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
1318: , p_context IN VARCHAR2
1319: , p_src_project_id IN NUMBER := FND_API.G_MISS_NUM
1320: , p_dest_project_id IN NUMBER := FND_API.G_MISS_NUM
1321: , p_src_str_version_id IN NUMBER := FND_API.G_MISS_NUM

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

1315: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1316: , p_debug_mode IN VARCHAR2 := 'N'
1317: , p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
1318: , p_context IN VARCHAR2
1319: , p_src_project_id IN NUMBER := FND_API.G_MISS_NUM
1320: , p_dest_project_id IN NUMBER := FND_API.G_MISS_NUM
1321: , p_src_str_version_id IN NUMBER := FND_API.G_MISS_NUM
1322: , p_dest_str_version_id IN NUMBER := FND_API.G_MISS_NUM
1323: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

1316: , p_debug_mode IN VARCHAR2 := 'N'
1317: , p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
1318: , p_context IN VARCHAR2
1319: , p_src_project_id IN NUMBER := FND_API.G_MISS_NUM
1320: , p_dest_project_id IN NUMBER := FND_API.G_MISS_NUM
1321: , p_src_str_version_id IN NUMBER := FND_API.G_MISS_NUM
1322: , p_dest_str_version_id IN NUMBER := FND_API.G_MISS_NUM
1323: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1324: , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

1317: , p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
1318: , p_context IN VARCHAR2
1319: , p_src_project_id IN NUMBER := FND_API.G_MISS_NUM
1320: , p_dest_project_id IN NUMBER := FND_API.G_MISS_NUM
1321: , p_src_str_version_id IN NUMBER := FND_API.G_MISS_NUM
1322: , p_dest_str_version_id IN NUMBER := FND_API.G_MISS_NUM
1323: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1324: , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1325: , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

1318: , p_context IN VARCHAR2
1319: , p_src_project_id IN NUMBER := FND_API.G_MISS_NUM
1320: , p_dest_project_id IN NUMBER := FND_API.G_MISS_NUM
1321: , p_src_str_version_id IN NUMBER := FND_API.G_MISS_NUM
1322: , p_dest_str_version_id IN NUMBER := FND_API.G_MISS_NUM
1323: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1324: , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1325: , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1326:

Line 1428: x_return_status := FND_API.G_RET_STS_SUCCESS;

1424:
1425:
1426: x_msg_count := 0;
1427: l_user_id := FND_GLOBAL.USER_ID;
1428: x_return_status := FND_API.G_RET_STS_SUCCESS;
1429: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
1430:
1431:
1432: IF l_debug_mode = 'Y' THEN

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

1444: Pa_Debug.WRITE(g_module_name,'p_src_str_version_id'||p_src_str_version_id,l_debug_level3);
1445: Pa_Debug.WRITE(g_module_name,'p_dest_str_version_id'||p_dest_str_version_id,l_debug_level3);
1446: END IF;
1447:
1448: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
1449: FND_MSG_PUB.initialize;
1450: END IF;
1451:
1452: IF l_debug_mode = 'Y' THEN

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

1466: --If context is copy_project, src and destination project id must be passed and they should not be same
1467: IF ( p_context ='COPY_PROJECT' ) THEN
1468: IF
1469: (
1470: ( p_src_project_id IS NULL OR p_src_project_id = FND_API.G_MISS_NUM )
1471: OR ( p_dest_project_id IS NULL OR p_dest_project_id = FND_API.G_MISS_NUM )
1472: OR ( p_src_project_id = p_dest_project_id )
1473: )
1474: THEN

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

1467: IF ( p_context ='COPY_PROJECT' ) THEN
1468: IF
1469: (
1470: ( p_src_project_id IS NULL OR p_src_project_id = FND_API.G_MISS_NUM )
1471: OR ( p_dest_project_id IS NULL OR p_dest_project_id = FND_API.G_MISS_NUM )
1472: OR ( p_src_project_id = p_dest_project_id )
1473: )
1474: THEN
1475: 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 1595: IF ( ( p_src_str_version_id IS NULL OR p_src_str_version_id = FND_API.G_MISS_NUM )

1591: -- It is assumed that p_src_project_id will be passed in this case
1592: -- src_project_id will make the c_get_mapped_tasks efficient with project Id filter.
1593: ELSIF (p_context = 'CREATE_WORKING_VERSION' OR p_context = 'PUBLISH_VERSION')
1594: THEN
1595: IF ( ( p_src_str_version_id IS NULL OR p_src_str_version_id = FND_API.G_MISS_NUM )
1596: OR( p_dest_str_version_id IS NULL OR p_dest_str_version_id = FND_API.G_MISS_NUM )
1597: OR( p_src_project_id IS NULL OR p_src_project_id = FND_API.G_MISS_NUM )
1598: ) THEN
1599:

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

1592: -- src_project_id will make the c_get_mapped_tasks efficient with project Id filter.
1593: ELSIF (p_context = 'CREATE_WORKING_VERSION' OR p_context = 'PUBLISH_VERSION')
1594: THEN
1595: IF ( ( p_src_str_version_id IS NULL OR p_src_str_version_id = FND_API.G_MISS_NUM )
1596: OR( p_dest_str_version_id IS NULL OR p_dest_str_version_id = FND_API.G_MISS_NUM )
1597: OR( p_src_project_id IS NULL OR p_src_project_id = FND_API.G_MISS_NUM )
1598: ) THEN
1599:
1600: 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 1597: OR( p_src_project_id IS NULL OR p_src_project_id = FND_API.G_MISS_NUM )

1593: ELSIF (p_context = 'CREATE_WORKING_VERSION' OR p_context = 'PUBLISH_VERSION')
1594: THEN
1595: IF ( ( p_src_str_version_id IS NULL OR p_src_str_version_id = FND_API.G_MISS_NUM )
1596: OR( p_dest_str_version_id IS NULL OR p_dest_str_version_id = FND_API.G_MISS_NUM )
1597: OR( p_src_project_id IS NULL OR p_src_project_id = FND_API.G_MISS_NUM )
1598: ) THEN
1599:
1600: 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';
1601: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,

Line 1703: WHEN FND_API.G_EXC_ERROR THEN

1699: Pa_Debug.WRITE(g_module_name,'After Completing insert',l_debug_level3);
1700:
1701: EXCEPTION
1702:
1703: WHEN FND_API.G_EXC_ERROR THEN
1704:
1705: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1706: l_msg_count := Fnd_Msg_Pub.count_msg;
1707:

Line 1705: x_return_status := Fnd_Api.G_RET_STS_ERROR;

1701: EXCEPTION
1702:
1703: WHEN FND_API.G_EXC_ERROR THEN
1704:
1705: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1706: l_msg_count := Fnd_Msg_Pub.count_msg;
1707:
1708: IF l_msg_count = 1 AND x_msg_data IS NULL
1709: THEN

Line 1711: ( p_encoded => Fnd_Api.G_TRUE

1707:
1708: IF l_msg_count = 1 AND x_msg_data IS NULL
1709: THEN
1710: Pa_Interface_Utils_Pub.get_messages
1711: ( p_encoded => Fnd_Api.G_TRUE
1712: , p_msg_index => 1
1713: , p_msg_count => l_msg_count
1714: , p_msg_data => l_msg_data
1715: , p_data => l_data

Line 1728: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

1724: END IF;
1725:
1726: WHEN Invalid_Arg_Exc_WP THEN
1727:
1728: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1729: x_msg_count := 1;
1730: x_msg_data := 'PA_PROJ_STRUC_MAPPING_PUB : COPY_MAPPING : NULL PARAMETERS ARE PASSED OR CURSOR DIDNT RETURN ANY ROWS';
1731:
1732: Fnd_Msg_Pub.add_exc_msg

Line 1747: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

1743: RAISE;
1744:
1745: WHEN OTHERS THEN
1746:
1747: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1748: x_msg_count := 1;
1749: x_msg_data := SQLERRM;
1750:
1751:

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

1781:
1782: PROCEDURE DELETE_ALL_MAPPING
1783: (
1784: p_api_version IN NUMBER := 1.0
1785: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1786: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1787: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
1788: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1789: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

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

1782: PROCEDURE DELETE_ALL_MAPPING
1783: (
1784: p_api_version IN NUMBER := 1.0
1785: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1786: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1787: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
1788: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1789: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1790: , p_debug_mode IN VARCHAR2 := 'N'

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

1783: (
1784: p_api_version IN NUMBER := 1.0
1785: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1786: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1787: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
1788: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1789: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1790: , p_debug_mode IN VARCHAR2 := 'N'
1791: , p_project_id IN NUMBER

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

1784: p_api_version IN NUMBER := 1.0
1785: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1786: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1787: , p_validate_only IN VARCHAR2 := FND_API.G_FALSE
1788: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1789: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1790: , p_debug_mode IN VARCHAR2 := 'N'
1791: , p_project_id IN NUMBER
1792: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1845: x_return_status := FND_API.G_RET_STS_SUCCESS;

1841:
1842: BEGIN
1843:
1844: x_msg_count := 0;
1845: x_return_status := FND_API.G_RET_STS_SUCCESS;
1846:
1847: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
1848: --l_debug_mode := NVL(p_debug_mode,'N');
1849: IF l_debug_mode = 'Y' THEN

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

1859: Pa_Debug.WRITE(g_module_name,'p_project_id'||':'||p_project_id,
1860: l_debug_level3);
1861: END IF;
1862:
1863: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
1864: FND_MSG_PUB.initialize;
1865: END IF;
1866:
1867: IF (p_commit = FND_API.G_TRUE) THEN

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

1863: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
1864: FND_MSG_PUB.initialize;
1865: END IF;
1866:
1867: IF (p_commit = FND_API.G_TRUE) THEN
1868: savepoint DELETE_ALL_MAPPING_PUBLIC;
1869: END IF;
1870:
1871: IF l_debug_mode = 'Y' THEN

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

1898: DELETE FROM PA_OBJECT_RELATIONSHIPS
1899: WHERE
1900: OBJECT_RELATIONSHIP_ID = l_mapped_obj_rel_id_tbl(iCounter);
1901: END IF;
1902: IF (p_commit = FND_API.G_TRUE) THEN
1903: COMMIT;
1904: END IF;
1905:
1906: EXCEPTION

Line 1908: WHEN FND_API.G_EXC_ERROR THEN

1904: END IF;
1905:
1906: EXCEPTION
1907:
1908: WHEN FND_API.G_EXC_ERROR THEN
1909:
1910: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1911: l_msg_count := Fnd_Msg_Pub.count_msg;
1912:

Line 1910: x_return_status := Fnd_Api.G_RET_STS_ERROR;

1906: EXCEPTION
1907:
1908: WHEN FND_API.G_EXC_ERROR THEN
1909:
1910: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1911: l_msg_count := Fnd_Msg_Pub.count_msg;
1912:
1913: IF p_commit = FND_API.G_TRUE THEN
1914: ROLLBACK TO DELETE_ALL_MAPPING_PUBLIC;

Line 1913: IF p_commit = FND_API.G_TRUE THEN

1909:
1910: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1911: l_msg_count := Fnd_Msg_Pub.count_msg;
1912:
1913: IF p_commit = FND_API.G_TRUE THEN
1914: ROLLBACK TO DELETE_ALL_MAPPING_PUBLIC;
1915: END IF;
1916: IF c_get_fin_task_ver_id%ISOPEN THEN
1917: CLOSE c_get_fin_task_ver_id;

Line 1922: ( p_encoded => Fnd_Api.G_TRUE

1918: END IF;
1919: IF l_msg_count = 1 AND x_msg_data IS NULL
1920: THEN
1921: Pa_Interface_Utils_Pub.get_messages
1922: ( p_encoded => Fnd_Api.G_TRUE
1923: , p_msg_index => 1
1924: , p_msg_count => l_msg_count
1925: , p_msg_data => l_msg_data
1926: , p_data => l_data

Line 1939: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

1935: END IF;
1936:
1937: WHEN Invalid_Arg_Exc_WP THEN
1938:
1939: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1940: x_msg_count := 1;
1941: --x_msg_data := 'PA_PROJ_STRUC_MAPPING_PUB : DELETE_ALL_MAPPING : NULL PARAMETERS ARE PASSED OR CURSOR DIDNT RETURN ANY ROWS';
1942:
1943: IF p_commit = FND_API.G_TRUE THEN

Line 1943: IF p_commit = FND_API.G_TRUE THEN

1939: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1940: x_msg_count := 1;
1941: --x_msg_data := 'PA_PROJ_STRUC_MAPPING_PUB : DELETE_ALL_MAPPING : NULL PARAMETERS ARE PASSED OR CURSOR DIDNT RETURN ANY ROWS';
1942:
1943: IF p_commit = FND_API.G_TRUE THEN
1944: ROLLBACK TO DELETE_ALL_MAPPING_PUBLIC;
1945: END IF;
1946: IF c_get_fin_task_ver_id%ISOPEN THEN
1947: CLOSE c_get_fin_task_ver_id;

Line 1964: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

1960: RAISE;
1961:
1962: WHEN OTHERS THEN
1963:
1964: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1965: x_msg_count := 1;
1966: x_msg_data := SQLERRM;
1967:
1968: IF p_commit = FND_API.G_TRUE THEN

Line 1968: IF p_commit = FND_API.G_TRUE THEN

1964: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1965: x_msg_count := 1;
1966: x_msg_data := SQLERRM;
1967:
1968: IF p_commit = FND_API.G_TRUE THEN
1969: ROLLBACK TO DELETE_ALL_MAPPING_PUBLIC;
1970: END IF;
1971:
1972: IF c_get_fin_task_ver_id%ISOPEN THEN