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 PA_DEBUG

Line 100: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

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',
103: p_debug_mode => l_debug_mode );
104: END IF;

Line 102: PA_DEBUG.set_curr_function( p_function => 'DELETE_MAPPING',

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',
103: p_debug_mode => l_debug_mode );
104: END IF;
105:
106: IF l_debug_mode = 'Y' THEN

Line 107: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : DELETE_MAPPING : Printing Input parameters';

103: p_debug_mode => l_debug_mode );
104: END IF;
105:
106: IF l_debug_mode = 'Y' THEN
107: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : DELETE_MAPPING : Printing Input parameters';
108: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
109: l_debug_level3);
110:
111: Pa_Debug.WRITE(g_module_name,'p_wp_from_task_name'||':'||p_wp_from_task_name,

Line 108: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,

104: END IF;
105:
106: IF l_debug_mode = 'Y' THEN
107: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : DELETE_MAPPING : Printing Input parameters';
108: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
109: l_debug_level3);
110:
111: Pa_Debug.WRITE(g_module_name,'p_wp_from_task_name'||':'||p_wp_from_task_name,
112: l_debug_level3);

Line 111: Pa_Debug.WRITE(g_module_name,'p_wp_from_task_name'||':'||p_wp_from_task_name,

107: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : DELETE_MAPPING : Printing Input parameters';
108: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
109: l_debug_level3);
110:
111: Pa_Debug.WRITE(g_module_name,'p_wp_from_task_name'||':'||p_wp_from_task_name,
112: l_debug_level3);
113:
114: Pa_Debug.WRITE(g_module_name,'p_wp_task_version_id'||':'||p_wp_task_version_id,
115: l_debug_level3);

Line 114: Pa_Debug.WRITE(g_module_name,'p_wp_task_version_id'||':'||p_wp_task_version_id,

110:
111: Pa_Debug.WRITE(g_module_name,'p_wp_from_task_name'||':'||p_wp_from_task_name,
112: l_debug_level3);
113:
114: Pa_Debug.WRITE(g_module_name,'p_wp_task_version_id'||':'||p_wp_task_version_id,
115: l_debug_level3);
116:
117: Pa_Debug.WRITE(g_module_name,'p_fp_task_version_id'||':'||p_fp_task_version_id,
118: l_debug_level3);

Line 117: Pa_Debug.WRITE(g_module_name,'p_fp_task_version_id'||':'||p_fp_task_version_id,

113:
114: Pa_Debug.WRITE(g_module_name,'p_wp_task_version_id'||':'||p_wp_task_version_id,
115: l_debug_level3);
116:
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

Line 130: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : DELETE_MAPPING : Validating Input parameters';

126: savepoint DELETE_MAPPING_PUBLIC;
127: END IF;
128:
129: IF l_debug_mode = 'Y' THEN
130: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : DELETE_MAPPING : Validating Input parameters';
131: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
132: l_debug_level3);
133: END IF;
134:

Line 131: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,

127: END IF;
128:
129: IF l_debug_mode = 'Y' THEN
130: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : DELETE_MAPPING : Validating Input parameters';
131: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
132: l_debug_level3);
133: END IF;
134:
135: IF (

Line 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';

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';
142: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
143: l_debug_level3);
144: END IF;
145: RAISE Invalid_Arg_Exc_WP;

Line 142: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,

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';
142: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
143: l_debug_level3);
144: END IF;
145: RAISE Invalid_Arg_Exc_WP;
146: END IF;

Line 162: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : DELETE_MAPPING : No Mapping Exists';

158: -- Raise exception and populate error message
159: IF ( c_get_mapping_frm_wp_fp_task%NOTFOUND )
160: THEN
161: IF l_debug_mode = 'Y' THEN
162: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : DELETE_MAPPING : No Mapping Exists';
163: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
164: l_debug_level3);
165: END IF;
166: -- Bug 4142254 : Record has been changes error make sense for Self Service, but from AMG

Line 163: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,

159: IF ( c_get_mapping_frm_wp_fp_task%NOTFOUND )
160: THEN
161: IF l_debug_mode = 'Y' THEN
162: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : DELETE_MAPPING : No Mapping Exists';
163: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
164: l_debug_level3);
165: END IF;
166: -- Bug 4142254 : Record has been changes error make sense for Self Service, but from AMG
167: -- it should be "Mapping does not exist between the given tasks."

Line 183: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : DELETE_MAPPING : Calling delete';

179: -- if any row found, delete the row
180: IF (l_object_relationship_id IS NOT NULL)
181: THEN
182: IF l_debug_mode = 'Y' THEN
183: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : DELETE_MAPPING : Calling delete';
184: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
185: l_debug_level3);
186: END IF;
187:

Line 184: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,

180: IF (l_object_relationship_id IS NOT NULL)
181: THEN
182: IF l_debug_mode = 'Y' THEN
183: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : DELETE_MAPPING : Calling delete';
184: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
185: l_debug_level3);
186: END IF;
187:
188: -- Call public API for deleting the relationship

Line 220: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : DELETE_MAPPING : Calling delete';

216:
217: IF (l_object_relationship_id IS NOT NULL)
218: THEN
219: IF l_debug_mode = 'Y' THEN
220: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : DELETE_MAPPING : Calling delete';
221: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
222: l_debug_level3);
223: END IF;
224:

Line 221: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,

217: IF (l_object_relationship_id IS NOT NULL)
218: THEN
219: IF l_debug_mode = 'Y' THEN
220: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : DELETE_MAPPING : Calling delete';
221: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
222: l_debug_level3);
223: END IF;
224:
225: -- Call public API for deleting the relationship

Line 249: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : DELETE_MAPPING : Mapping does not exist for the passed WP task ID';

245: END IF;
246:
247: ELSE
248: IF l_debug_mode = 'Y' THEN
249: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : DELETE_MAPPING : Mapping does not exist for the passed WP task ID';
250: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
251: l_debug_level3);
252: END IF;
253: END IF;--IF (l_object_relationship_id IS NOT NULL) ENDS

Line 250: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,

246:
247: ELSE
248: IF l_debug_mode = 'Y' THEN
249: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : DELETE_MAPPING : Mapping does not exist for the passed WP task ID';
250: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
251: l_debug_level3);
252: END IF;
253: END IF;--IF (l_object_relationship_id IS NOT NULL) ENDS
254:

Line 327: Pa_Debug.reset_curr_function;

323: ELSE
324: x_msg_count := l_msg_count;
325: END IF;
326: IF l_debug_mode = 'Y' THEN
327: Pa_Debug.reset_curr_function;
328: END IF;
329:
330: WHEN Invalid_Arg_Exc_WP THEN
331:

Line 357: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;

353: , p_procedure_name => 'DELETE_MAPPING'
354: , p_error_text => x_msg_data);
355:
356: IF l_debug_mode = 'Y' THEN
357: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
358: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
359: l_debug_level5);
360: Pa_Debug.reset_curr_function;
361: END IF;

Line 358: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,

354: , p_error_text => x_msg_data);
355:
356: IF l_debug_mode = 'Y' THEN
357: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
358: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
359: l_debug_level5);
360: Pa_Debug.reset_curr_function;
361: END IF;
362: RAISE;

Line 360: Pa_Debug.reset_curr_function;

356: IF l_debug_mode = 'Y' THEN
357: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
358: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
359: l_debug_level5);
360: Pa_Debug.reset_curr_function;
361: END IF;
362: RAISE;
363:
364: WHEN OTHERS THEN

Line 392: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;

388: , p_procedure_name => 'DELETE_MAPPING'
389: , p_error_text => x_msg_data);
390:
391: IF l_debug_mode = 'Y' THEN
392: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
393: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
394: l_debug_level5);
395: Pa_Debug.reset_curr_function;
396: END IF;

Line 393: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,

389: , p_error_text => x_msg_data);
390:
391: IF l_debug_mode = 'Y' THEN
392: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
393: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
394: l_debug_level5);
395: Pa_Debug.reset_curr_function;
396: END IF;
397: RAISE;

Line 395: Pa_Debug.reset_curr_function;

391: IF l_debug_mode = 'Y' THEN
392: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
393: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
394: l_debug_level5);
395: Pa_Debug.reset_curr_function;
396: END IF;
397: RAISE;
398: END DELETE_MAPPING ;
399:

Line 512: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

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',
516: p_debug_mode => l_debug_mode );

Line 515: PA_DEBUG.set_curr_function( p_function => 'CREATE_MAPPING',

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',
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

Line 528: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : CREATE_MAPPING : Printing Input parameters';

524: savepoint CREATE_MAPPING_PUBLIC;
525: END IF;
526:
527: IF l_debug_mode = 'Y' THEN
528: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : CREATE_MAPPING : Printing Input parameters';
529: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
530: l_debug_level3);
531:
532: Pa_Debug.WRITE(g_module_name,'p_wp_task_name'||':'||p_wp_task_name,

Line 529: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,

525: END IF;
526:
527: IF l_debug_mode = 'Y' THEN
528: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : CREATE_MAPPING : Printing Input parameters';
529: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
530: l_debug_level3);
531:
532: Pa_Debug.WRITE(g_module_name,'p_wp_task_name'||':'||p_wp_task_name,
533: l_debug_level3);

Line 532: Pa_Debug.WRITE(g_module_name,'p_wp_task_name'||':'||p_wp_task_name,

528: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : CREATE_MAPPING : Printing Input parameters';
529: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
530: l_debug_level3);
531:
532: Pa_Debug.WRITE(g_module_name,'p_wp_task_name'||':'||p_wp_task_name,
533: l_debug_level3);
534:
535: Pa_Debug.WRITE(g_module_name,'p_wp_task_version_id'||':'||p_wp_task_version_id,
536: l_debug_level3);

Line 535: Pa_Debug.WRITE(g_module_name,'p_wp_task_version_id'||':'||p_wp_task_version_id,

531:
532: Pa_Debug.WRITE(g_module_name,'p_wp_task_name'||':'||p_wp_task_name,
533: l_debug_level3);
534:
535: Pa_Debug.WRITE(g_module_name,'p_wp_task_version_id'||':'||p_wp_task_version_id,
536: l_debug_level3);
537:
538: Pa_Debug.WRITE(g_module_name,'p_parent_str_version_id'||':'||p_parent_str_version_id,
539: l_debug_level3);

Line 538: Pa_Debug.WRITE(g_module_name,'p_parent_str_version_id'||':'||p_parent_str_version_id,

534:
535: Pa_Debug.WRITE(g_module_name,'p_wp_task_version_id'||':'||p_wp_task_version_id,
536: l_debug_level3);
537:
538: Pa_Debug.WRITE(g_module_name,'p_parent_str_version_id'||':'||p_parent_str_version_id,
539: l_debug_level3);
540:
541: Pa_Debug.WRITE(g_module_name,'p_fp_task_version_id'||':'||p_fp_task_version_id,
542: l_debug_level3);

Line 541: Pa_Debug.WRITE(g_module_name,'p_fp_task_version_id'||':'||p_fp_task_version_id,

537:
538: Pa_Debug.WRITE(g_module_name,'p_parent_str_version_id'||':'||p_parent_str_version_id,
539: l_debug_level3);
540:
541: Pa_Debug.WRITE(g_module_name,'p_fp_task_version_id'||':'||p_fp_task_version_id,
542: l_debug_level3);
543: Pa_Debug.WRITE(g_module_name,'p_fp_task_name'||':'||p_fp_task_name,
544: l_debug_level3);
545: Pa_Debug.WRITE(g_module_name,'p_project_id'||':'||p_project_id,

Line 543: Pa_Debug.WRITE(g_module_name,'p_fp_task_name'||':'||p_fp_task_name,

539: l_debug_level3);
540:
541: Pa_Debug.WRITE(g_module_name,'p_fp_task_version_id'||':'||p_fp_task_version_id,
542: l_debug_level3);
543: Pa_Debug.WRITE(g_module_name,'p_fp_task_name'||':'||p_fp_task_name,
544: l_debug_level3);
545: Pa_Debug.WRITE(g_module_name,'p_project_id'||':'||p_project_id,
546: l_debug_level3);
547: END IF;

Line 545: Pa_Debug.WRITE(g_module_name,'p_project_id'||':'||p_project_id,

541: Pa_Debug.WRITE(g_module_name,'p_fp_task_version_id'||':'||p_fp_task_version_id,
542: l_debug_level3);
543: Pa_Debug.WRITE(g_module_name,'p_fp_task_name'||':'||p_fp_task_name,
544: l_debug_level3);
545: Pa_Debug.WRITE(g_module_name,'p_project_id'||':'||p_project_id,
546: l_debug_level3);
547: END IF;
548:
549: IF l_debug_mode = 'Y' THEN

Line 550: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : CREATE_MAPPING : Validating Input parameters';

546: l_debug_level3);
547: END IF;
548:
549: IF l_debug_mode = 'Y' THEN
550: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : CREATE_MAPPING : Validating Input parameters';
551: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage, l_debug_level3);
552: END IF;
553:
554: --Check if project id is null , raise an error

Line 551: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage, l_debug_level3);

547: END IF;
548:
549: IF l_debug_mode = 'Y' THEN
550: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : CREATE_MAPPING : Validating Input parameters';
551: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage, l_debug_level3);
552: END IF;
553:
554: --Check if project id is null , raise an error
555: IF (p_project_id is NULL)

Line 558: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : CREATE_MAPPING : project id can not be null';

554: --Check if project id is null , raise an error
555: IF (p_project_id is NULL)
556: THEN
557: IF l_debug_mode = 'Y' THEN
558: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : CREATE_MAPPING : project id can not be null';
559: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
560: l_debug_level3);
561: END IF;
562: RAISE Invalid_Arg_Exc_WP;

Line 559: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,

555: IF (p_project_id is NULL)
556: THEN
557: IF l_debug_mode = 'Y' THEN
558: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : CREATE_MAPPING : project id can not be null';
559: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
560: l_debug_level3);
561: END IF;
562: RAISE Invalid_Arg_Exc_WP;
563: END IF;

Line 605: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : CREATE_MAPPING : Both work plan task id and task name are null';

601: )
602: )
603: THEN
604: IF l_debug_mode = 'Y' THEN
605: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : CREATE_MAPPING : Both work plan task id and task name are null';
606: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
607: l_debug_level3);
608: END IF;
609: RAISE Invalid_Arg_Exc_WP;

Line 606: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,

602: )
603: THEN
604: IF l_debug_mode = 'Y' THEN
605: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : CREATE_MAPPING : Both work plan task id and task name are null';
606: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
607: l_debug_level3);
608: END IF;
609: RAISE Invalid_Arg_Exc_WP;
610: END IF;

Line 622: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : CREATE_MAPPING : parent structue version id can not be null, if wp task name is not null';

618: )
619: )
620: THEN
621: IF l_debug_mode = 'Y' THEN
622: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : CREATE_MAPPING : parent structue version id can not be null, if wp task name is not null';
623: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
624: l_debug_level3);
625: END IF;
626: RAISE Invalid_Arg_Exc_WP;

Line 623: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,

619: )
620: THEN
621: IF l_debug_mode = 'Y' THEN
622: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : CREATE_MAPPING : parent structue version id can not be null, if wp task name is not null';
623: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
624: l_debug_level3);
625: END IF;
626: RAISE Invalid_Arg_Exc_WP;
627: END IF;

Line 664: Pa_Debug.WRITE('test',l_fp_task_version_id, l_debug_level3);

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);
665: OPEN c_get_fp_task_ver_id_frm_name ( p_fp_task_name , p_project_id );
666: FETCH c_get_fp_task_ver_id_frm_name INTO l_fp_task_version_id ;
667: IF ( c_get_fp_task_ver_id_frm_name%NOTFOUND )
668: THEN

Line 678: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : CREATE_MAPPING : Calling PA_PROJ_STRUC_MAPPING_UTILS.CHECK_CREATE_MAPPING_OK ';

674:
675: END IF;
676:
677: IF l_debug_mode = 'Y' THEN
678: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : CREATE_MAPPING : Calling PA_PROJ_STRUC_MAPPING_UTILS.CHECK_CREATE_MAPPING_OK ';
679: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage, l_debug_level3);
680: END IF;
681:
682: -- Call util API to check whether the mapping can be created

Line 679: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage, l_debug_level3);

675: END IF;
676:
677: IF l_debug_mode = 'Y' THEN
678: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : CREATE_MAPPING : Calling PA_PROJ_STRUC_MAPPING_UTILS.CHECK_CREATE_MAPPING_OK ';
679: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage, l_debug_level3);
680: END IF;
681:
682: -- Call util API to check whether the mapping can be created
683: PA_PROJ_STRUC_MAPPING_UTILS.CHECK_CREATE_MAPPING_OK

Line 701: Pa_Debug.g_err_stage:= ' PA_PROJ_STRUC_MAPPING_PUB : CREATE_MAPPING : '|| l_error_message_code;

697: THEN
698:
699: -- Mapping can't be created
700: IF l_debug_mode = 'Y' THEN
701: Pa_Debug.g_err_stage:= ' PA_PROJ_STRUC_MAPPING_PUB : CREATE_MAPPING : '|| l_error_message_code;
702: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
703: l_debug_level3);
704: END IF;
705: Pa_Utils.ADD_MESSAGE

Line 702: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,

698:
699: -- Mapping can't be created
700: IF l_debug_mode = 'Y' THEN
701: Pa_Debug.g_err_stage:= ' PA_PROJ_STRUC_MAPPING_PUB : CREATE_MAPPING : '|| l_error_message_code;
702: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
703: l_debug_level3);
704: END IF;
705: Pa_Utils.ADD_MESSAGE
706: ( p_app_short_name => 'PA',

Line 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;

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;
713: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
714: l_debug_level3);
715: END IF;
716:

Line 713: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,

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;
713: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
714: l_debug_level3);
715: END IF;
716:
717: --Call public API to create the mapping

Line 771: Pa_Debug.reset_curr_function;

767: ELSE
768: x_msg_count := l_msg_count;
769: END IF;
770: IF l_debug_mode = 'Y' THEN
771: Pa_Debug.reset_curr_function;
772: END IF;
773:
774: WHEN Invalid_Arg_Exc_WP THEN
775:

Line 790: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;

786: , p_procedure_name => 'CREATE_MAPPING'
787: , p_error_text => x_msg_data);
788:
789: IF l_debug_mode = 'Y' THEN
790: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
791: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
792: l_debug_level5);
793: Pa_Debug.reset_curr_function;
794: END IF;

Line 791: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,

787: , p_error_text => x_msg_data);
788:
789: IF l_debug_mode = 'Y' THEN
790: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
791: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
792: l_debug_level5);
793: Pa_Debug.reset_curr_function;
794: END IF;
795: RAISE;

Line 793: Pa_Debug.reset_curr_function;

789: IF l_debug_mode = 'Y' THEN
790: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
791: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
792: l_debug_level5);
793: Pa_Debug.reset_curr_function;
794: END IF;
795: RAISE;
796:
797:

Line 807: Pa_Debug.g_err_stage:= 'x_msg_count='||x_msg_count;

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);
809:
810:
811: Fnd_Msg_Pub.add_exc_msg

Line 808: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage, l_debug_level5);

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);
809:
810:
811: Fnd_Msg_Pub.add_exc_msg
812: ( p_pkg_name => 'PA_PROJ_STRUC_MAPPING_PUB'

Line 815: Pa_Debug.g_err_stage:= 'x_msg_count='||x_msg_count;

811: Fnd_Msg_Pub.add_exc_msg
812: ( p_pkg_name => 'PA_PROJ_STRUC_MAPPING_PUB'
813: , p_procedure_name => 'CREATE_MAPPING'
814: , p_error_text => x_msg_data);
815: Pa_Debug.g_err_stage:= 'x_msg_count='||x_msg_count;
816: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage, l_debug_level5);
817:
818:
819: IF l_debug_mode = 'Y' THEN

Line 816: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage, l_debug_level5);

812: ( p_pkg_name => 'PA_PROJ_STRUC_MAPPING_PUB'
813: , p_procedure_name => 'CREATE_MAPPING'
814: , p_error_text => x_msg_data);
815: Pa_Debug.g_err_stage:= 'x_msg_count='||x_msg_count;
816: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage, l_debug_level5);
817:
818:
819: IF l_debug_mode = 'Y' THEN
820: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;

Line 820: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;

816: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage, l_debug_level5);
817:
818:
819: IF l_debug_mode = 'Y' THEN
820: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
821: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
822: l_debug_level5);
823: Pa_Debug.reset_curr_function;
824: END IF;

Line 821: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,

817:
818:
819: IF l_debug_mode = 'Y' THEN
820: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
821: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
822: l_debug_level5);
823: Pa_Debug.reset_curr_function;
824: END IF;
825: RAISE;

Line 823: Pa_Debug.reset_curr_function;

819: IF l_debug_mode = 'Y' THEN
820: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
821: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
822: l_debug_level5);
823: Pa_Debug.reset_curr_function;
824: END IF;
825: RAISE;
826: END CREATE_MAPPING ;
827:

Line 958: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

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
962: PA_DEBUG.set_curr_function( p_function => 'UPDATE_MAPPING',

Line 962: PA_DEBUG.set_curr_function( p_function => 'UPDATE_MAPPING',

958: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
959:
960:
961: IF l_debug_mode = 'Y' 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

Line 975: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : UPDATE_MAPPING : Printing Input parameters';

971: savepoint UPDATE_MAPPING_PUBLIC;
972: END IF;
973:
974: IF l_debug_mode = 'Y' THEN
975: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : UPDATE_MAPPING : Printing Input parameters';
976: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
977: l_debug_level3);
978:
979: Pa_Debug.WRITE(g_module_name,'p_structure_type'||':'||p_structure_type,

Line 976: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,

972: END IF;
973:
974: IF l_debug_mode = 'Y' THEN
975: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : UPDATE_MAPPING : Printing Input parameters';
976: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
977: l_debug_level3);
978:
979: Pa_Debug.WRITE(g_module_name,'p_structure_type'||':'||p_structure_type,
980: l_debug_level3);

Line 979: Pa_Debug.WRITE(g_module_name,'p_structure_type'||':'||p_structure_type,

975: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : UPDATE_MAPPING : Printing Input parameters';
976: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
977: l_debug_level3);
978:
979: Pa_Debug.WRITE(g_module_name,'p_structure_type'||':'||p_structure_type,
980: l_debug_level3);
981:
982: Pa_Debug.WRITE(g_module_name,'p_project_id'||':'||p_project_id,
983: l_debug_level3);

Line 982: Pa_Debug.WRITE(g_module_name,'p_project_id'||':'||p_project_id,

978:
979: Pa_Debug.WRITE(g_module_name,'p_structure_type'||':'||p_structure_type,
980: l_debug_level3);
981:
982: Pa_Debug.WRITE(g_module_name,'p_project_id'||':'||p_project_id,
983: l_debug_level3);
984:
985: Pa_Debug.WRITE(g_module_name,'p_wp_task_name'||':'||p_wp_task_name,
986: l_debug_level3);

Line 985: Pa_Debug.WRITE(g_module_name,'p_wp_task_name'||':'||p_wp_task_name,

981:
982: Pa_Debug.WRITE(g_module_name,'p_project_id'||':'||p_project_id,
983: l_debug_level3);
984:
985: Pa_Debug.WRITE(g_module_name,'p_wp_task_name'||':'||p_wp_task_name,
986: l_debug_level3);
987:
988: Pa_Debug.WRITE(g_module_name,'p_wp_prnt_str_ver_id'||':'||p_wp_prnt_str_ver_id,
989: l_debug_level3);

Line 988: Pa_Debug.WRITE(g_module_name,'p_wp_prnt_str_ver_id'||':'||p_wp_prnt_str_ver_id,

984:
985: Pa_Debug.WRITE(g_module_name,'p_wp_task_name'||':'||p_wp_task_name,
986: l_debug_level3);
987:
988: Pa_Debug.WRITE(g_module_name,'p_wp_prnt_str_ver_id'||':'||p_wp_prnt_str_ver_id,
989: l_debug_level3);
990: Pa_Debug.WRITE(g_module_name,'p_wp_task_version_id'||':'||p_wp_task_version_id,
991: l_debug_level3);
992: Pa_Debug.WRITE(g_module_name,'p_fp_task_name'||':'||p_fp_task_name,

Line 990: Pa_Debug.WRITE(g_module_name,'p_wp_task_version_id'||':'||p_wp_task_version_id,

986: l_debug_level3);
987:
988: Pa_Debug.WRITE(g_module_name,'p_wp_prnt_str_ver_id'||':'||p_wp_prnt_str_ver_id,
989: l_debug_level3);
990: Pa_Debug.WRITE(g_module_name,'p_wp_task_version_id'||':'||p_wp_task_version_id,
991: l_debug_level3);
992: Pa_Debug.WRITE(g_module_name,'p_fp_task_name'||':'||p_fp_task_name,
993: l_debug_level3);
994:

Line 992: Pa_Debug.WRITE(g_module_name,'p_fp_task_name'||':'||p_fp_task_name,

988: Pa_Debug.WRITE(g_module_name,'p_wp_prnt_str_ver_id'||':'||p_wp_prnt_str_ver_id,
989: l_debug_level3);
990: Pa_Debug.WRITE(g_module_name,'p_wp_task_version_id'||':'||p_wp_task_version_id,
991: l_debug_level3);
992: Pa_Debug.WRITE(g_module_name,'p_fp_task_name'||':'||p_fp_task_name,
993: l_debug_level3);
994:
995: Pa_Debug.WRITE(g_module_name,'p_fp_task_version_id'||':'||p_fp_task_version_id,
996: l_debug_level3);

Line 995: Pa_Debug.WRITE(g_module_name,'p_fp_task_version_id'||':'||p_fp_task_version_id,

991: l_debug_level3);
992: Pa_Debug.WRITE(g_module_name,'p_fp_task_name'||':'||p_fp_task_name,
993: l_debug_level3);
994:
995: Pa_Debug.WRITE(g_module_name,'p_fp_task_version_id'||':'||p_fp_task_version_id,
996: l_debug_level3);
997: END IF;
998:
999: IF l_debug_mode = 'Y' THEN

Line 1000: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : UPDATE_MAPPING : Validating Input parameters';

996: l_debug_level3);
997: END IF;
998:
999: IF l_debug_mode = 'Y' THEN
1000: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : UPDATE_MAPPING : Validating Input parameters';
1001: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1002: l_debug_level3);
1003: END IF;
1004:

Line 1001: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,

997: END IF;
998:
999: IF l_debug_mode = 'Y' THEN
1000: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : UPDATE_MAPPING : Validating Input parameters';
1001: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1002: l_debug_level3);
1003: END IF;
1004:
1005: -- if PROJECT id IS NULL RAISE ERROR MESSAGE

Line 1009: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : UPDATE_MAPPING : project id can not be null';

1005: -- if PROJECT id IS NULL RAISE ERROR MESSAGE
1006: IF (p_project_id is NULL)
1007: THEN
1008: IF l_debug_mode = 'Y' THEN
1009: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : UPDATE_MAPPING : project id can not be null';
1010: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1011: l_debug_level3);
1012: END IF;
1013: RAISE Invalid_Arg_Exc_WP;

Line 1010: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,

1006: IF (p_project_id is NULL)
1007: THEN
1008: IF l_debug_mode = 'Y' THEN
1009: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : UPDATE_MAPPING : project id can not be null';
1010: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1011: l_debug_level3);
1012: END IF;
1013: RAISE Invalid_Arg_Exc_WP;
1014: END IF;

Line 1031: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : UPDATE_MAPPING : Both of tasks id and tasks name are null';

1027: )
1028: )
1029: THEN
1030: IF l_debug_mode = 'Y' THEN
1031: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : UPDATE_MAPPING : Both of tasks id and tasks name are null';
1032: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1033: l_debug_level3);
1034: END IF;
1035: RAISE Invalid_Arg_Exc_WP;

Line 1032: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,

1028: )
1029: THEN
1030: IF l_debug_mode = 'Y' THEN
1031: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : UPDATE_MAPPING : Both of tasks id and tasks name are null';
1032: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1033: l_debug_level3);
1034: END IF;
1035: RAISE Invalid_Arg_Exc_WP;
1036: END IF;

Line 1048: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : UPDATE_MAPPING : parent structue version id can not be null, if wp task name is not null';

1044: )
1045: )
1046: THEN
1047: IF l_debug_mode = 'Y' THEN
1048: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : UPDATE_MAPPING : parent structue version id can not be null, if wp task name is not null';
1049: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1050: l_debug_level3);
1051: END IF;
1052: RAISE Invalid_Arg_Exc_WP;

Line 1049: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,

1045: )
1046: THEN
1047: IF l_debug_mode = 'Y' THEN
1048: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : UPDATE_MAPPING : parent structue version id can not be null, if wp task name is not null';
1049: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1050: l_debug_level3);
1051: END IF;
1052: RAISE Invalid_Arg_Exc_WP;
1053: END IF;

Line 1169: pa_debug.reset_curr_function;

1165: END IF;
1166:
1167: -- Bug 10053423
1168: IF l_debug_mode = 'Y' THEN
1169: pa_debug.reset_curr_function;
1170: pa_debug.write(g_module_name, 'UPDATE_MAPPING: Exiting succesfully',5);
1171: END IF;
1172:
1173: EXCEPTION

Line 1170: pa_debug.write(g_module_name, 'UPDATE_MAPPING: Exiting succesfully',5);

1166:
1167: -- Bug 10053423
1168: IF l_debug_mode = 'Y' THEN
1169: pa_debug.reset_curr_function;
1170: pa_debug.write(g_module_name, 'UPDATE_MAPPING: Exiting succesfully',5);
1171: END IF;
1172:
1173: EXCEPTION
1174:

Line 1211: Pa_Debug.reset_curr_function;

1207: ELSE
1208: x_msg_count := l_msg_count;
1209: END IF;
1210: IF l_debug_mode = 'Y' THEN
1211: Pa_Debug.reset_curr_function;
1212: END IF;
1213:
1214: WHEN Invalid_Arg_Exc_WP THEN
1215:

Line 1242: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;

1238: , p_procedure_name => 'UPDATE_MAPPING'
1239: , p_error_text => x_msg_data);
1240:
1241: IF l_debug_mode = 'Y' THEN
1242: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
1243: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1244: l_debug_level5);
1245: Pa_Debug.reset_curr_function;
1246: END IF;

Line 1243: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,

1239: , p_error_text => x_msg_data);
1240:
1241: IF l_debug_mode = 'Y' THEN
1242: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
1243: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1244: l_debug_level5);
1245: Pa_Debug.reset_curr_function;
1246: END IF;
1247:

Line 1245: Pa_Debug.reset_curr_function;

1241: IF l_debug_mode = 'Y' THEN
1242: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
1243: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1244: l_debug_level5);
1245: Pa_Debug.reset_curr_function;
1246: END IF;
1247:
1248:
1249: WHEN OTHERS THEN

Line 1277: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;

1273: , p_procedure_name => 'UPDATE_MAPPING'
1274: , p_error_text => x_msg_data);
1275:
1276: IF l_debug_mode = 'Y' THEN
1277: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
1278: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1279: l_debug_level5);
1280: Pa_Debug.reset_curr_function;
1281: END IF;

Line 1278: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,

1274: , p_error_text => x_msg_data);
1275:
1276: IF l_debug_mode = 'Y' THEN
1277: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
1278: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1279: l_debug_level5);
1280: Pa_Debug.reset_curr_function;
1281: END IF;
1282:

Line 1280: Pa_Debug.reset_curr_function;

1276: IF l_debug_mode = 'Y' THEN
1277: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
1278: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1279: l_debug_level5);
1280: Pa_Debug.reset_curr_function;
1281: END IF;
1282:
1283: END UPDATE_MAPPING ;
1284:

Line 1429: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

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
1433: PA_DEBUG.set_curr_function( p_function => 'COPY_MAPPING',

Line 1433: PA_DEBUG.set_curr_function( p_function => 'COPY_MAPPING',

1429: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
1430:
1431:
1432: IF l_debug_mode = 'Y' THEN
1433: PA_DEBUG.set_curr_function( p_function => 'COPY_MAPPING',
1434: p_debug_mode => l_debug_mode );
1435: END IF;
1436:
1437: IF l_debug_mode = 'Y' THEN

Line 1438: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : COPY_MAPPING : Printing Input parameters';

1434: p_debug_mode => l_debug_mode );
1435: END IF;
1436:
1437: IF l_debug_mode = 'Y' THEN
1438: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : COPY_MAPPING : Printing Input parameters';
1439: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1440: l_debug_level3);
1441: Pa_Debug.WRITE(g_module_name,'p_context'||p_context,l_debug_level3);
1442: Pa_Debug.WRITE(g_module_name,'p_src_project_id'||p_src_project_id,l_debug_level3);

Line 1439: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,

1435: END IF;
1436:
1437: IF l_debug_mode = 'Y' THEN
1438: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : COPY_MAPPING : Printing Input parameters';
1439: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1440: l_debug_level3);
1441: Pa_Debug.WRITE(g_module_name,'p_context'||p_context,l_debug_level3);
1442: Pa_Debug.WRITE(g_module_name,'p_src_project_id'||p_src_project_id,l_debug_level3);
1443: Pa_Debug.WRITE(g_module_name,'p_dest_project_id'||p_dest_project_id,l_debug_level3);

Line 1441: Pa_Debug.WRITE(g_module_name,'p_context'||p_context,l_debug_level3);

1437: IF l_debug_mode = 'Y' THEN
1438: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : COPY_MAPPING : Printing Input parameters';
1439: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1440: l_debug_level3);
1441: Pa_Debug.WRITE(g_module_name,'p_context'||p_context,l_debug_level3);
1442: Pa_Debug.WRITE(g_module_name,'p_src_project_id'||p_src_project_id,l_debug_level3);
1443: Pa_Debug.WRITE(g_module_name,'p_dest_project_id'||p_dest_project_id,l_debug_level3);
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);

Line 1442: Pa_Debug.WRITE(g_module_name,'p_src_project_id'||p_src_project_id,l_debug_level3);

1438: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : COPY_MAPPING : Printing Input parameters';
1439: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1440: l_debug_level3);
1441: Pa_Debug.WRITE(g_module_name,'p_context'||p_context,l_debug_level3);
1442: Pa_Debug.WRITE(g_module_name,'p_src_project_id'||p_src_project_id,l_debug_level3);
1443: Pa_Debug.WRITE(g_module_name,'p_dest_project_id'||p_dest_project_id,l_debug_level3);
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;

Line 1443: Pa_Debug.WRITE(g_module_name,'p_dest_project_id'||p_dest_project_id,l_debug_level3);

1439: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1440: l_debug_level3);
1441: Pa_Debug.WRITE(g_module_name,'p_context'||p_context,l_debug_level3);
1442: Pa_Debug.WRITE(g_module_name,'p_src_project_id'||p_src_project_id,l_debug_level3);
1443: Pa_Debug.WRITE(g_module_name,'p_dest_project_id'||p_dest_project_id,l_debug_level3);
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:

Line 1444: Pa_Debug.WRITE(g_module_name,'p_src_str_version_id'||p_src_str_version_id,l_debug_level3);

1440: l_debug_level3);
1441: Pa_Debug.WRITE(g_module_name,'p_context'||p_context,l_debug_level3);
1442: Pa_Debug.WRITE(g_module_name,'p_src_project_id'||p_src_project_id,l_debug_level3);
1443: Pa_Debug.WRITE(g_module_name,'p_dest_project_id'||p_dest_project_id,l_debug_level3);
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

Line 1445: Pa_Debug.WRITE(g_module_name,'p_dest_str_version_id'||p_dest_str_version_id,l_debug_level3);

1441: Pa_Debug.WRITE(g_module_name,'p_context'||p_context,l_debug_level3);
1442: Pa_Debug.WRITE(g_module_name,'p_src_project_id'||p_src_project_id,l_debug_level3);
1443: Pa_Debug.WRITE(g_module_name,'p_dest_project_id'||p_dest_project_id,l_debug_level3);
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;

Line 1453: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : COPY_MAPPING : Validating Input parameters';

1449: FND_MSG_PUB.initialize;
1450: END IF;
1451:
1452: IF l_debug_mode = 'Y' THEN
1453: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : COPY_MAPPING : Validating Input parameters';
1454: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1455: l_debug_level3);
1456: END IF;
1457:

Line 1454: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,

1450: END IF;
1451:
1452: IF l_debug_mode = 'Y' THEN
1453: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : COPY_MAPPING : Validating Input parameters';
1454: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1455: l_debug_level3);
1456: END IF;
1457:
1458: IF ( p_context IS NULL ) THEN

Line 1459: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : COPY_MAPPING : p_context is mandatory and cant be null';

1455: l_debug_level3);
1456: END IF;
1457:
1458: IF ( p_context IS NULL ) THEN
1459: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : COPY_MAPPING : p_context is mandatory and cant be null';
1460: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1461: l_debug_level3);
1462:
1463: RAISE Invalid_Arg_Exc_WP;

Line 1460: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,

1456: END IF;
1457:
1458: IF ( p_context IS NULL ) THEN
1459: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : COPY_MAPPING : p_context is mandatory and cant be null';
1460: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1461: l_debug_level3);
1462:
1463: RAISE Invalid_Arg_Exc_WP;
1464: END IF;

Line 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';

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';
1476: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1477: l_debug_level3);
1478:
1479: RAISE Invalid_Arg_Exc_WP;

Line 1476: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,

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';
1476: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1477: l_debug_level3);
1478:
1479: RAISE Invalid_Arg_Exc_WP;
1480:

Line 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';

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,
1602: l_debug_level3);
1603: RAISE Invalid_Arg_Exc_WP;
1604: END IF;

Line 1601: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,

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,
1602: l_debug_level3);
1603: RAISE Invalid_Arg_Exc_WP;
1604: END IF;
1605:

Line 1633: Pa_Debug.WRITE(g_module_name,'l_from_task_id_tbl.COUNT '||l_from_task_id_tbl.COUNT ,l_debug_level3);

1629: FETCH c_get_mapped_task_ver_id INTO l_from_dest_task_ver_id ( iCounter );
1630: CLOSE c_get_mapped_task_ver_id;
1631: END LOOP;
1632:
1633: Pa_Debug.WRITE(g_module_name,'l_from_task_id_tbl.COUNT '||l_from_task_id_tbl.COUNT ,l_debug_level3);
1634:
1635: -- Insert into PA_OBJECT_RELATIONSHIPS
1636: --bug 3574885, the forall should be called only when l_from_dest_task_ver_id is not empty
1637: --rtarway ,bug 3916440, the forall should be called only when l_src_to_tasks_id_tbl is not empty

Line 1699: Pa_Debug.WRITE(g_module_name,'After Completing insert',l_debug_level3);

1695: );
1696: END IF;
1697: END IF;
1698:
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

Line 1723: Pa_Debug.reset_curr_function;

1719: ELSE
1720: x_msg_count := l_msg_count;
1721: END IF;
1722: IF l_debug_mode = 'Y' THEN
1723: Pa_Debug.reset_curr_function;
1724: END IF;
1725:
1726: WHEN Invalid_Arg_Exc_WP THEN
1727:

Line 1738: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;

1734: , p_procedure_name => 'COPY_MAPPING'
1735: , p_error_text => x_msg_data);
1736:
1737: IF l_debug_mode = 'Y' THEN
1738: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
1739: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1740: l_debug_level5);
1741: Pa_Debug.reset_curr_function;
1742: END IF;

Line 1739: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,

1735: , p_error_text => x_msg_data);
1736:
1737: IF l_debug_mode = 'Y' THEN
1738: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
1739: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1740: l_debug_level5);
1741: Pa_Debug.reset_curr_function;
1742: END IF;
1743: RAISE;

Line 1741: Pa_Debug.reset_curr_function;

1737: IF l_debug_mode = 'Y' THEN
1738: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
1739: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1740: l_debug_level5);
1741: Pa_Debug.reset_curr_function;
1742: END IF;
1743: RAISE;
1744:
1745: WHEN OTHERS THEN

Line 1758: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;

1754: , p_procedure_name => 'COPY_MAPPING'
1755: , p_error_text => x_msg_data);
1756:
1757: IF l_debug_mode = 'Y' THEN
1758: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
1759: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1760: l_debug_level5);
1761: Pa_Debug.reset_curr_function;
1762: END IF;

Line 1759: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,

1755: , p_error_text => x_msg_data);
1756:
1757: IF l_debug_mode = 'Y' THEN
1758: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
1759: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1760: l_debug_level5);
1761: Pa_Debug.reset_curr_function;
1762: END IF;
1763: RAISE;

Line 1761: Pa_Debug.reset_curr_function;

1757: IF l_debug_mode = 'Y' THEN
1758: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
1759: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1760: l_debug_level5);
1761: Pa_Debug.reset_curr_function;
1762: END IF;
1763: RAISE;
1764:
1765: END COPY_MAPPING ;

Line 1847: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

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
1850: PA_DEBUG.set_curr_function( p_function => 'DELETE_ALL_MAPPING',
1851: p_debug_mode => l_debug_mode );

Line 1850: PA_DEBUG.set_curr_function( p_function => 'DELETE_ALL_MAPPING',

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
1850: PA_DEBUG.set_curr_function( p_function => 'DELETE_ALL_MAPPING',
1851: p_debug_mode => l_debug_mode );
1852: END IF;
1853:
1854: IF l_debug_mode = 'Y' THEN

Line 1855: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : DELETE_ALL_MAPPING : Printing Input parameters';

1851: p_debug_mode => l_debug_mode );
1852: END IF;
1853:
1854: IF l_debug_mode = 'Y' THEN
1855: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : DELETE_ALL_MAPPING : Printing Input parameters';
1856: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1857: l_debug_level3);
1858:
1859: Pa_Debug.WRITE(g_module_name,'p_project_id'||':'||p_project_id,

Line 1856: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,

1852: END IF;
1853:
1854: IF l_debug_mode = 'Y' THEN
1855: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : DELETE_ALL_MAPPING : Printing Input parameters';
1856: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1857: l_debug_level3);
1858:
1859: Pa_Debug.WRITE(g_module_name,'p_project_id'||':'||p_project_id,
1860: l_debug_level3);

Line 1859: Pa_Debug.WRITE(g_module_name,'p_project_id'||':'||p_project_id,

1855: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : DELETE_ALL_MAPPING : Printing Input parameters';
1856: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1857: l_debug_level3);
1858:
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

Line 1872: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : DELETE_ALL_MAPPING : Validating Input parameters';

1868: savepoint DELETE_ALL_MAPPING_PUBLIC;
1869: END IF;
1870:
1871: IF l_debug_mode = 'Y' THEN
1872: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : DELETE_ALL_MAPPING : Validating Input parameters';
1873: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1874: l_debug_level3);
1875: END IF;
1876:

Line 1873: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,

1869: END IF;
1870:
1871: IF l_debug_mode = 'Y' THEN
1872: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : DELETE_ALL_MAPPING : Validating Input parameters';
1873: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1874: l_debug_level3);
1875: END IF;
1876:
1877: IF ( p_project_id IS NULL )

Line 1880: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : DELETE_ALL_MAPPING : p_project_id can not be null';

1876:
1877: IF ( p_project_id IS NULL )
1878: THEN
1879: IF l_debug_mode = 'Y' THEN
1880: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : DELETE_ALL_MAPPING : p_project_id can not be null';
1881: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1882: l_debug_level3);
1883: END IF;
1884: RAISE Invalid_Arg_Exc_WP;

Line 1881: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,

1877: IF ( p_project_id IS NULL )
1878: THEN
1879: IF l_debug_mode = 'Y' THEN
1880: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : DELETE_ALL_MAPPING : p_project_id can not be null';
1881: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1882: l_debug_level3);
1883: END IF;
1884: RAISE Invalid_Arg_Exc_WP;
1885: END IF;

Line 1934: Pa_Debug.reset_curr_function;

1930: ELSE
1931: x_msg_count := l_msg_count;
1932: END IF;
1933: IF l_debug_mode = 'Y' THEN
1934: Pa_Debug.reset_curr_function;
1935: END IF;
1936:
1937: WHEN Invalid_Arg_Exc_WP THEN
1938:

Line 1955: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;

1951: , p_procedure_name => 'DELETE_ALL_MAPPING'
1952: , p_error_text => x_msg_data);
1953:
1954: IF l_debug_mode = 'Y' THEN
1955: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
1956: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1957: l_debug_level5);
1958: Pa_Debug.reset_curr_function;
1959: END IF;

Line 1956: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,

1952: , p_error_text => x_msg_data);
1953:
1954: IF l_debug_mode = 'Y' THEN
1955: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
1956: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1957: l_debug_level5);
1958: Pa_Debug.reset_curr_function;
1959: END IF;
1960: RAISE;

Line 1958: Pa_Debug.reset_curr_function;

1954: IF l_debug_mode = 'Y' THEN
1955: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
1956: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1957: l_debug_level5);
1958: Pa_Debug.reset_curr_function;
1959: END IF;
1960: RAISE;
1961:
1962: WHEN OTHERS THEN

Line 1982: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;

1978: , p_procedure_name => 'DELETE_ALL_MAPPING'
1979: , p_error_text => x_msg_data);
1980:
1981: IF l_debug_mode = 'Y' THEN
1982: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
1983: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1984: l_debug_level5);
1985: Pa_Debug.reset_curr_function;
1986: END IF;

Line 1983: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,

1979: , p_error_text => x_msg_data);
1980:
1981: IF l_debug_mode = 'Y' THEN
1982: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
1983: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1984: l_debug_level5);
1985: Pa_Debug.reset_curr_function;
1986: END IF;
1987: RAISE;

Line 1985: Pa_Debug.reset_curr_function;

1981: IF l_debug_mode = 'Y' THEN
1982: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
1983: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1984: l_debug_level5);
1985: Pa_Debug.reset_curr_function;
1986: END IF;
1987: RAISE;
1988: END DELETE_ALL_MAPPING ;
1989: