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_PROJ_STRUC_MAPPING_PUB

Line 1: PACKAGE BODY PA_PROJ_STRUC_MAPPING_PUB AS

1: PACKAGE BODY PA_PROJ_STRUC_MAPPING_PUB AS
2: /* $Header: PAPSMPPB.pls 120.3.12020000.2 2012/07/12 05:58:33 djambhek ship $ */
3:
4: g_module_name VARCHAR2(100) := 'PA_PROJ_STRUC_MAPPING_PUB';
5: Invalid_Arg_Exc_WP Exception;

Line 4: g_module_name VARCHAR2(100) := 'PA_PROJ_STRUC_MAPPING_PUB';

1: PACKAGE BODY PA_PROJ_STRUC_MAPPING_PUB AS
2: /* $Header: PAPSMPPB.pls 120.3.12020000.2 2012/07/12 05:58:33 djambhek ship $ */
3:
4: g_module_name VARCHAR2(100) := 'PA_PROJ_STRUC_MAPPING_PUB';
5: Invalid_Arg_Exc_WP Exception;
6:
7: -- Procedure : DELETE_MAPPING
8: -- Type : Public Procedure

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 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 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 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 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 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 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 334: x_msg_data := 'PA_PROJ_STRUC_MAPPING_PUB : DELETE_MAPPING : NULL PARAMETERS ARE PASSED OR CURSOR DIDNT RETURN ANY ROWS';

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
337: ROLLBACK TO DELETE_MAPPING_PUBLIC;
338: END IF;

Line 352: ( p_pkg_name => 'PA_PROJ_STRUC_MAPPING_PUB'

348: CLOSE c_get_mapping_frm_wp_fp_task;
349: END IF;
350:
351: Fnd_Msg_Pub.add_exc_msg
352: ( p_pkg_name => 'PA_PROJ_STRUC_MAPPING_PUB'
353: , p_procedure_name => 'DELETE_MAPPING'
354: , p_error_text => x_msg_data);
355:
356: IF l_debug_mode = 'Y' THEN

Line 387: ( p_pkg_name => 'PA_PROJ_STRUC_MAPPING_PUB'

383: CLOSE c_get_mapping_frm_wp_fp_task;
384: END IF;
385:
386: Fnd_Msg_Pub.add_exc_msg
387: ( p_pkg_name => 'PA_PROJ_STRUC_MAPPING_PUB'
388: , p_procedure_name => 'DELETE_MAPPING'
389: , p_error_text => x_msg_data);
390:
391: IF l_debug_mode = 'Y' 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 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 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 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 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 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 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 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 778: x_msg_data := 'PA_PROJ_STRUC_MAPPING_PUB : CREATE_MAPPING : NULL arguments are passed to the procedure';

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
781: ROLLBACK TO CREATE_MAPPING_PUBLIC;
782: END IF;

Line 785: ( p_pkg_name => 'PA_PROJ_STRUC_MAPPING_PUB'

781: ROLLBACK TO CREATE_MAPPING_PUBLIC;
782: END IF;
783:
784: Fnd_Msg_Pub.add_exc_msg
785: ( p_pkg_name => 'PA_PROJ_STRUC_MAPPING_PUB'
786: , p_procedure_name => 'CREATE_MAPPING'
787: , p_error_text => x_msg_data);
788:
789: IF l_debug_mode = 'Y' THEN

Line 812: ( p_pkg_name => 'PA_PROJ_STRUC_MAPPING_PUB'

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

Line 893: l_wp_task_version_id_tbl PA_PROJ_STRUC_MAPPING_PUB.OBJECT_VERSION_ID_TABLE_TYPE;

889: l_debug_mode VARCHAR2(1);
890: l_wp_task_version_id NUMBER ;
891: l_fp_task_version_id NUMBER ;
892: l_notfound BOOLEAN;
893: l_wp_task_version_id_tbl PA_PROJ_STRUC_MAPPING_PUB.OBJECT_VERSION_ID_TABLE_TYPE;
894: l_map_wp_task_ver_id_tbl PA_PROJ_STRUC_MAPPING_PUB.OBJECT_VERSION_ID_TABLE_TYPE;
895: l_wp_task_name_table PA_PROJ_STRUC_MAPPING_PUB.OBJECT_NAME_TABLE_TYPE ;
896: l_parse_return_message VARCHAR2(30);
897: l_proj_element_version_id NUMBER;

Line 894: l_map_wp_task_ver_id_tbl PA_PROJ_STRUC_MAPPING_PUB.OBJECT_VERSION_ID_TABLE_TYPE;

890: l_wp_task_version_id NUMBER ;
891: l_fp_task_version_id NUMBER ;
892: l_notfound BOOLEAN;
893: l_wp_task_version_id_tbl PA_PROJ_STRUC_MAPPING_PUB.OBJECT_VERSION_ID_TABLE_TYPE;
894: l_map_wp_task_ver_id_tbl PA_PROJ_STRUC_MAPPING_PUB.OBJECT_VERSION_ID_TABLE_TYPE;
895: l_wp_task_name_table PA_PROJ_STRUC_MAPPING_PUB.OBJECT_NAME_TABLE_TYPE ;
896: l_parse_return_message VARCHAR2(30);
897: l_proj_element_version_id NUMBER;
898: l_object_relationship_id NUMBER;

Line 895: l_wp_task_name_table PA_PROJ_STRUC_MAPPING_PUB.OBJECT_NAME_TABLE_TYPE ;

891: l_fp_task_version_id NUMBER ;
892: l_notfound BOOLEAN;
893: l_wp_task_version_id_tbl PA_PROJ_STRUC_MAPPING_PUB.OBJECT_VERSION_ID_TABLE_TYPE;
894: l_map_wp_task_ver_id_tbl PA_PROJ_STRUC_MAPPING_PUB.OBJECT_VERSION_ID_TABLE_TYPE;
895: l_wp_task_name_table PA_PROJ_STRUC_MAPPING_PUB.OBJECT_NAME_TABLE_TYPE ;
896: l_parse_return_message VARCHAR2(30);
897: l_proj_element_version_id NUMBER;
898: l_object_relationship_id NUMBER;
899: l_rec_version_num NUMBER;

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 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 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 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 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 1141: PA_PROJ_STRUC_MAPPING_PUB.CREATE_MAPPING(

1137: )
1138: THEN
1139: --create new mapping with l_wp_task_ver_id and l_fp_task_ver_id
1140: -- Call CREATE_MAPPING
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

Line 1218: x_msg_data := 'PA_PROJ_STRUC_MAPPING_PUB : UPDATE_MAPPING : Some parameters are NULL';

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
1221: ROLLBACK TO UPDATE_MAPPING_PUBLIC;
1222: END IF;

Line 1237: ( p_pkg_name => 'PA_PROJ_STRUC_MAPPING_PUB'

1233: CLOSE c_get_fp_task_ver_id_frm_name;
1234: END IF;
1235:
1236: Fnd_Msg_Pub.add_exc_msg
1237: ( p_pkg_name => 'PA_PROJ_STRUC_MAPPING_PUB'
1238: , p_procedure_name => 'UPDATE_MAPPING'
1239: , p_error_text => x_msg_data);
1240:
1241: IF l_debug_mode = 'Y' THEN

Line 1272: ( p_pkg_name => 'PA_PROJ_STRUC_MAPPING_PUB'

1268: CLOSE c_get_wp_task_ver_id_frm_name;
1269: END IF;
1270:
1271: Fnd_Msg_Pub.add_exc_msg
1272: ( p_pkg_name => 'PA_PROJ_STRUC_MAPPING_PUB'
1273: , p_procedure_name => 'UPDATE_MAPPING'
1274: , p_error_text => x_msg_data);
1275:
1276: IF l_debug_mode = 'Y' THEN

Line 1411: l_src_from_tasks_id_tbl PA_PROJ_STRUC_MAPPING_PUB.OBJECT_VERSION_ID_TABLE_TYPE;

1407: AND parent_structure_version_id = l_str_version_id
1408: AND proj_element_id = l_task_id
1409: AND pa_proj_element_versions.project_id = l_project_id;
1410:
1411: l_src_from_tasks_id_tbl PA_PROJ_STRUC_MAPPING_PUB.OBJECT_VERSION_ID_TABLE_TYPE;
1412: l_src_to_tasks_id_tbl PA_PROJ_STRUC_MAPPING_PUB.OBJECT_VERSION_ID_TABLE_TYPE;
1413:
1414: l_dest_from_tasks_id_tbl PA_PROJ_STRUC_MAPPING_PUB.OBJECT_VERSION_ID_TABLE_TYPE;
1415: l_dest_to_tasks_id_tbl PA_PROJ_STRUC_MAPPING_PUB.OBJECT_VERSION_ID_TABLE_TYPE;

Line 1412: l_src_to_tasks_id_tbl PA_PROJ_STRUC_MAPPING_PUB.OBJECT_VERSION_ID_TABLE_TYPE;

1408: AND proj_element_id = l_task_id
1409: AND pa_proj_element_versions.project_id = l_project_id;
1410:
1411: l_src_from_tasks_id_tbl PA_PROJ_STRUC_MAPPING_PUB.OBJECT_VERSION_ID_TABLE_TYPE;
1412: l_src_to_tasks_id_tbl PA_PROJ_STRUC_MAPPING_PUB.OBJECT_VERSION_ID_TABLE_TYPE;
1413:
1414: l_dest_from_tasks_id_tbl PA_PROJ_STRUC_MAPPING_PUB.OBJECT_VERSION_ID_TABLE_TYPE;
1415: l_dest_to_tasks_id_tbl PA_PROJ_STRUC_MAPPING_PUB.OBJECT_VERSION_ID_TABLE_TYPE;
1416:

Line 1414: l_dest_from_tasks_id_tbl PA_PROJ_STRUC_MAPPING_PUB.OBJECT_VERSION_ID_TABLE_TYPE;

1410:
1411: l_src_from_tasks_id_tbl PA_PROJ_STRUC_MAPPING_PUB.OBJECT_VERSION_ID_TABLE_TYPE;
1412: l_src_to_tasks_id_tbl PA_PROJ_STRUC_MAPPING_PUB.OBJECT_VERSION_ID_TABLE_TYPE;
1413:
1414: l_dest_from_tasks_id_tbl PA_PROJ_STRUC_MAPPING_PUB.OBJECT_VERSION_ID_TABLE_TYPE;
1415: l_dest_to_tasks_id_tbl PA_PROJ_STRUC_MAPPING_PUB.OBJECT_VERSION_ID_TABLE_TYPE;
1416:
1417: l_from_task_id_tbl PA_PROJ_STRUC_MAPPING_PUB.OBJECT_ID_TABLE_TYPE;
1418: l_to_task_id_tbl PA_PROJ_STRUC_MAPPING_PUB.OBJECT_ID_TABLE_TYPE;

Line 1415: l_dest_to_tasks_id_tbl PA_PROJ_STRUC_MAPPING_PUB.OBJECT_VERSION_ID_TABLE_TYPE;

1411: l_src_from_tasks_id_tbl PA_PROJ_STRUC_MAPPING_PUB.OBJECT_VERSION_ID_TABLE_TYPE;
1412: l_src_to_tasks_id_tbl PA_PROJ_STRUC_MAPPING_PUB.OBJECT_VERSION_ID_TABLE_TYPE;
1413:
1414: l_dest_from_tasks_id_tbl PA_PROJ_STRUC_MAPPING_PUB.OBJECT_VERSION_ID_TABLE_TYPE;
1415: l_dest_to_tasks_id_tbl PA_PROJ_STRUC_MAPPING_PUB.OBJECT_VERSION_ID_TABLE_TYPE;
1416:
1417: l_from_task_id_tbl PA_PROJ_STRUC_MAPPING_PUB.OBJECT_ID_TABLE_TYPE;
1418: l_to_task_id_tbl PA_PROJ_STRUC_MAPPING_PUB.OBJECT_ID_TABLE_TYPE;
1419:

Line 1417: l_from_task_id_tbl PA_PROJ_STRUC_MAPPING_PUB.OBJECT_ID_TABLE_TYPE;

1413:
1414: l_dest_from_tasks_id_tbl PA_PROJ_STRUC_MAPPING_PUB.OBJECT_VERSION_ID_TABLE_TYPE;
1415: l_dest_to_tasks_id_tbl PA_PROJ_STRUC_MAPPING_PUB.OBJECT_VERSION_ID_TABLE_TYPE;
1416:
1417: l_from_task_id_tbl PA_PROJ_STRUC_MAPPING_PUB.OBJECT_ID_TABLE_TYPE;
1418: l_to_task_id_tbl PA_PROJ_STRUC_MAPPING_PUB.OBJECT_ID_TABLE_TYPE;
1419:
1420: l_from_dest_task_ver_id PA_PROJ_STRUC_MAPPING_PUB.OBJECT_VERSION_ID_TABLE_TYPE;
1421: l_to_dest_task_ver_id PA_PROJ_STRUC_MAPPING_PUB.OBJECT_VERSION_ID_TABLE_TYPE;

Line 1418: l_to_task_id_tbl PA_PROJ_STRUC_MAPPING_PUB.OBJECT_ID_TABLE_TYPE;

1414: l_dest_from_tasks_id_tbl PA_PROJ_STRUC_MAPPING_PUB.OBJECT_VERSION_ID_TABLE_TYPE;
1415: l_dest_to_tasks_id_tbl PA_PROJ_STRUC_MAPPING_PUB.OBJECT_VERSION_ID_TABLE_TYPE;
1416:
1417: l_from_task_id_tbl PA_PROJ_STRUC_MAPPING_PUB.OBJECT_ID_TABLE_TYPE;
1418: l_to_task_id_tbl PA_PROJ_STRUC_MAPPING_PUB.OBJECT_ID_TABLE_TYPE;
1419:
1420: l_from_dest_task_ver_id PA_PROJ_STRUC_MAPPING_PUB.OBJECT_VERSION_ID_TABLE_TYPE;
1421: l_to_dest_task_ver_id PA_PROJ_STRUC_MAPPING_PUB.OBJECT_VERSION_ID_TABLE_TYPE;
1422:

Line 1420: l_from_dest_task_ver_id PA_PROJ_STRUC_MAPPING_PUB.OBJECT_VERSION_ID_TABLE_TYPE;

1416:
1417: l_from_task_id_tbl PA_PROJ_STRUC_MAPPING_PUB.OBJECT_ID_TABLE_TYPE;
1418: l_to_task_id_tbl PA_PROJ_STRUC_MAPPING_PUB.OBJECT_ID_TABLE_TYPE;
1419:
1420: l_from_dest_task_ver_id PA_PROJ_STRUC_MAPPING_PUB.OBJECT_VERSION_ID_TABLE_TYPE;
1421: l_to_dest_task_ver_id PA_PROJ_STRUC_MAPPING_PUB.OBJECT_VERSION_ID_TABLE_TYPE;
1422:
1423: BEGIN
1424:

Line 1421: l_to_dest_task_ver_id PA_PROJ_STRUC_MAPPING_PUB.OBJECT_VERSION_ID_TABLE_TYPE;

1417: l_from_task_id_tbl PA_PROJ_STRUC_MAPPING_PUB.OBJECT_ID_TABLE_TYPE;
1418: l_to_task_id_tbl PA_PROJ_STRUC_MAPPING_PUB.OBJECT_ID_TABLE_TYPE;
1419:
1420: l_from_dest_task_ver_id PA_PROJ_STRUC_MAPPING_PUB.OBJECT_VERSION_ID_TABLE_TYPE;
1421: l_to_dest_task_ver_id PA_PROJ_STRUC_MAPPING_PUB.OBJECT_VERSION_ID_TABLE_TYPE;
1422:
1423: BEGIN
1424:
1425:

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 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 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 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 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 1730: x_msg_data := 'PA_PROJ_STRUC_MAPPING_PUB : COPY_MAPPING : NULL PARAMETERS ARE PASSED OR CURSOR DIDNT RETURN ANY ROWS';

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
1733: ( p_pkg_name => 'PA_PROJ_STRUC_MAPPING_PUB'
1734: , p_procedure_name => 'COPY_MAPPING'

Line 1733: ( p_pkg_name => 'PA_PROJ_STRUC_MAPPING_PUB'

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
1733: ( p_pkg_name => 'PA_PROJ_STRUC_MAPPING_PUB'
1734: , p_procedure_name => 'COPY_MAPPING'
1735: , p_error_text => x_msg_data);
1736:
1737: IF l_debug_mode = 'Y' THEN

Line 1753: ( p_pkg_name => 'PA_PROJ_STRUC_MAPPING_PUB'

1749: x_msg_data := SQLERRM;
1750:
1751:
1752: Fnd_Msg_Pub.add_exc_msg
1753: ( p_pkg_name => 'PA_PROJ_STRUC_MAPPING_PUB'
1754: , p_procedure_name => 'COPY_MAPPING'
1755: , p_error_text => x_msg_data);
1756:
1757: IF l_debug_mode = 'Y' THEN

Line 1809: l_mapped_obj_rel_id_tbl PA_PROJ_STRUC_MAPPING_PUB.OBJ_REL_ID_TABLE_TYPE;

1805: l_debug_level3 CONSTANT NUMBER := 3;
1806: l_debug_level4 CONSTANT NUMBER := 4;
1807: l_debug_level5 CONSTANT NUMBER := 5;
1808: --Table to collect all the mapped financial task version id
1809: l_mapped_obj_rel_id_tbl PA_PROJ_STRUC_MAPPING_PUB.OBJ_REL_ID_TABLE_TYPE;
1810:
1811: --This cursor will give all mapped financial tasks and object_relationships_id for the passed project id.
1812: CURSOR c_get_fin_task_ver_id (l_project_id NUMBER)
1813: IS

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 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 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 1941: --x_msg_data := 'PA_PROJ_STRUC_MAPPING_PUB : DELETE_ALL_MAPPING : NULL PARAMETERS ARE PASSED OR CURSOR DIDNT RETURN ANY ROWS';

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
1944: ROLLBACK TO DELETE_ALL_MAPPING_PUBLIC;
1945: END IF;

Line 1950: ( p_pkg_name => 'PA_PROJ_STRUC_MAPPING_PUB'

1946: IF c_get_fin_task_ver_id%ISOPEN THEN
1947: CLOSE c_get_fin_task_ver_id;
1948: END IF;
1949: Fnd_Msg_Pub.add_exc_msg
1950: ( p_pkg_name => 'PA_PROJ_STRUC_MAPPING_PUB'
1951: , p_procedure_name => 'DELETE_ALL_MAPPING'
1952: , p_error_text => x_msg_data);
1953:
1954: IF l_debug_mode = 'Y' THEN

Line 1977: ( p_pkg_name => 'PA_PROJ_STRUC_MAPPING_PUB'

1973: CLOSE c_get_fin_task_ver_id;
1974: END IF;
1975:
1976: Fnd_Msg_Pub.add_exc_msg
1977: ( p_pkg_name => 'PA_PROJ_STRUC_MAPPING_PUB'
1978: , p_procedure_name => 'DELETE_ALL_MAPPING'
1979: , p_error_text => x_msg_data);
1980:
1981: IF l_debug_mode = 'Y' THEN

Line 1990: END PA_PROJ_STRUC_MAPPING_PUB;

1986: END IF;
1987: RAISE;
1988: END DELETE_ALL_MAPPING ;
1989:
1990: END PA_PROJ_STRUC_MAPPING_PUB;