DBA Data[Home] [Help]

APPS.PA_USER_ATTR_PUB dependencies on PA_DEBUG

Line 117: pa_debug.init_err_stack('PA_USER_ATTR_PUB.Copy_User_Attrs_Data');

113: l_msg_index_out NUMBER;
114: l_errorcode NUMBER;
115:
116: BEGIN
117: pa_debug.init_err_stack('PA_USER_ATTR_PUB.Copy_User_Attrs_Data');
118:
119: if (p_debug_mode = 'Y') then
120: pa_debug.debug('PA_USER_ATTR_PUB.Copy_User_Attrs_Data BEGIN');
121: end if;

Line 120: pa_debug.debug('PA_USER_ATTR_PUB.Copy_User_Attrs_Data BEGIN');

116: BEGIN
117: pa_debug.init_err_stack('PA_USER_ATTR_PUB.Copy_User_Attrs_Data');
118:
119: if (p_debug_mode = 'Y') then
120: pa_debug.debug('PA_USER_ATTR_PUB.Copy_User_Attrs_Data BEGIN');
121: end if;
122:
123: if not FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
124: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 307: pa_debug.debug('PA_USER_ATTR_PUB.Copy_User_Attrs_Data END');

303: commit work;
304: end if;
305:
306: if (p_debug_mode = 'Y') then
307: pa_debug.debug('PA_USER_ATTR_PUB.Copy_User_Attrs_Data END');
308: end if;
309:
310: EXCEPTION
311: when FND_API.G_EXC_ERROR then

Line 372: pa_debug.init_err_stack('PA_USER_ATTR_PUB.Delete_User_Attrs_Data');

368: l_data VARCHAR2(250);
369: l_msg_index_out NUMBER;
370:
371: BEGIN
372: pa_debug.init_err_stack('PA_USER_ATTR_PUB.Delete_User_Attrs_Data');
373:
374: if (p_debug_mode = 'Y') then
375: pa_debug.debug('PA_USER_ATTR_PUB.Delete_User_Attrs_Data BEGIN');
376: end if;

Line 375: pa_debug.debug('PA_USER_ATTR_PUB.Delete_User_Attrs_Data BEGIN');

371: BEGIN
372: pa_debug.init_err_stack('PA_USER_ATTR_PUB.Delete_User_Attrs_Data');
373:
374: if (p_debug_mode = 'Y') then
375: pa_debug.debug('PA_USER_ATTR_PUB.Delete_User_Attrs_Data BEGIN');
376: end if;
377:
378: if not FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
379: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 427: pa_debug.debug('PA_USER_ATTR_PUB.Delete_User_Attrs_Data END');

423: commit work;
424: end if;
425:
426: if (p_debug_mode = 'Y') then
427: pa_debug.debug('PA_USER_ATTR_PUB.Delete_User_Attrs_Data END');
428: end if;
429:
430: EXCEPTION
431: when FND_API.G_EXC_ERROR then

Line 601: pa_debug.init_err_stack('PA_USER_ATTR_PUB.Delete_All_User_Attrs_Data');

597: l_data VARCHAR2(250);
598: l_msg_index_out NUMBER;
599:
600: BEGIN
601: pa_debug.init_err_stack('PA_USER_ATTR_PUB.Delete_All_User_Attrs_Data');
602:
603: if (p_debug_mode = 'Y') then
604: pa_debug.debug('PA_USER_ATTR_PUB.Delete_All_User_Attrs_Data BEGIN');
605: end if;

Line 604: pa_debug.debug('PA_USER_ATTR_PUB.Delete_All_User_Attrs_Data BEGIN');

600: BEGIN
601: pa_debug.init_err_stack('PA_USER_ATTR_PUB.Delete_All_User_Attrs_Data');
602:
603: if (p_debug_mode = 'Y') then
604: pa_debug.debug('PA_USER_ATTR_PUB.Delete_All_User_Attrs_Data BEGIN');
605: end if;
606:
607: if not FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
608: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 653: pa_debug.debug('PA_USER_ATTR_PUB.Delete_All_User_Attrs_Data END');

649:
650: x_return_status := FND_API.G_RET_STS_SUCCESS;
651:
652: if (p_debug_mode = 'Y') then
653: pa_debug.debug('PA_USER_ATTR_PUB.Delete_All_User_Attrs_Data END');
654: end if;
655:
656: EXCEPTION
657: when FND_API.G_EXC_ERROR then

Line 735: pa_debug.init_err_stack('PA_USER_ATTR_PUB.Process_User_Attrs_Data');

731: l_msg_index_out NUMBER;
732: l_proj_elem_id NUMBER;
733:
734: BEGIN
735: pa_debug.init_err_stack('PA_USER_ATTR_PUB.Process_User_Attrs_Data');
736:
737: SAVEPOINT PROCESS_USER_ATTRS_DATA_PUB;
738:
739: if (p_debug_mode = 'Y') then

Line 740: pa_debug.debug('PA_USER_ATTR_PUB.Process_User_Attrs_Data BEGIN');

736:
737: SAVEPOINT PROCESS_USER_ATTRS_DATA_PUB;
738:
739: if (p_debug_mode = 'Y') then
740: pa_debug.debug('PA_USER_ATTR_PUB.Process_User_Attrs_Data BEGIN');
741: end if;
742:
743: if not FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
744: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 750: pa_debug.debug('Project Id = ' || to_char(p_project_id));

746:
747: i := p_ext_attr_data_table.first;
748:
749: if (p_debug_mode = 'Y') then
750: pa_debug.debug('Project Id = ' || to_char(p_project_id));
751: end if;
752:
753: ------------------------------------------------------------------
754: -- Initialization phase: --

Line 827: pa_debug.debug('Build Row Object:');

823: ,attr_rec.TRANSACTION_TYPE
824: );
825:
826: IF (p_debug_mode = 'Y') then
827: pa_debug.debug('Build Row Object:');
828: pa_debug.debug('Row Identifier =' || attr_rec.ROW_IDENTIFIER);
829: pa_debug.debug('ATTR_GROUP_ID =' || attr_rec.ATTR_GROUP_ID);
830: pa_debug.debug('ATTR_GROUP_INT_NAME =' || attr_rec.ATTR_GROUP_INT_NAME);
831: pa_debug.debug('PROJ_ELEMENT_ID =' || l_proj_elem_id);

Line 828: pa_debug.debug('Row Identifier =' || attr_rec.ROW_IDENTIFIER);

824: );
825:
826: IF (p_debug_mode = 'Y') then
827: pa_debug.debug('Build Row Object:');
828: pa_debug.debug('Row Identifier =' || attr_rec.ROW_IDENTIFIER);
829: pa_debug.debug('ATTR_GROUP_ID =' || attr_rec.ATTR_GROUP_ID);
830: pa_debug.debug('ATTR_GROUP_INT_NAME =' || attr_rec.ATTR_GROUP_INT_NAME);
831: pa_debug.debug('PROJ_ELEMENT_ID =' || l_proj_elem_id);
832: pa_debug.debug('TRANSACTION_TYPE =' || attr_rec.TRANSACTION_TYPE);

Line 829: pa_debug.debug('ATTR_GROUP_ID =' || attr_rec.ATTR_GROUP_ID);

825:
826: IF (p_debug_mode = 'Y') then
827: pa_debug.debug('Build Row Object:');
828: pa_debug.debug('Row Identifier =' || attr_rec.ROW_IDENTIFIER);
829: pa_debug.debug('ATTR_GROUP_ID =' || attr_rec.ATTR_GROUP_ID);
830: pa_debug.debug('ATTR_GROUP_INT_NAME =' || attr_rec.ATTR_GROUP_INT_NAME);
831: pa_debug.debug('PROJ_ELEMENT_ID =' || l_proj_elem_id);
832: pa_debug.debug('TRANSACTION_TYPE =' || attr_rec.TRANSACTION_TYPE);
833: END IF;

Line 830: pa_debug.debug('ATTR_GROUP_INT_NAME =' || attr_rec.ATTR_GROUP_INT_NAME);

826: IF (p_debug_mode = 'Y') then
827: pa_debug.debug('Build Row Object:');
828: pa_debug.debug('Row Identifier =' || attr_rec.ROW_IDENTIFIER);
829: pa_debug.debug('ATTR_GROUP_ID =' || attr_rec.ATTR_GROUP_ID);
830: pa_debug.debug('ATTR_GROUP_INT_NAME =' || attr_rec.ATTR_GROUP_INT_NAME);
831: pa_debug.debug('PROJ_ELEMENT_ID =' || l_proj_elem_id);
832: pa_debug.debug('TRANSACTION_TYPE =' || attr_rec.TRANSACTION_TYPE);
833: END IF;
834: END IF;

Line 831: pa_debug.debug('PROJ_ELEMENT_ID =' || l_proj_elem_id);

827: pa_debug.debug('Build Row Object:');
828: pa_debug.debug('Row Identifier =' || attr_rec.ROW_IDENTIFIER);
829: pa_debug.debug('ATTR_GROUP_ID =' || attr_rec.ATTR_GROUP_ID);
830: pa_debug.debug('ATTR_GROUP_INT_NAME =' || attr_rec.ATTR_GROUP_INT_NAME);
831: pa_debug.debug('PROJ_ELEMENT_ID =' || l_proj_elem_id);
832: pa_debug.debug('TRANSACTION_TYPE =' || attr_rec.TRANSACTION_TYPE);
833: END IF;
834: END IF;
835:

Line 832: pa_debug.debug('TRANSACTION_TYPE =' || attr_rec.TRANSACTION_TYPE);

828: pa_debug.debug('Row Identifier =' || attr_rec.ROW_IDENTIFIER);
829: pa_debug.debug('ATTR_GROUP_ID =' || attr_rec.ATTR_GROUP_ID);
830: pa_debug.debug('ATTR_GROUP_INT_NAME =' || attr_rec.ATTR_GROUP_INT_NAME);
831: pa_debug.debug('PROJ_ELEMENT_ID =' || l_proj_elem_id);
832: pa_debug.debug('TRANSACTION_TYPE =' || attr_rec.TRANSACTION_TYPE);
833: END IF;
834: END IF;
835:
836: ---------------------------------------------------------------

Line 851: pa_debug.debug('Build Data Object:');

847: ,null -- ATTR_UNIT_OF_MEASURE
848: ,attr_rec.USER_ROW_IDENTIFIER
849: );
850: IF (p_debug_mode = 'Y') then
851: pa_debug.debug('Build Data Object:');
852: pa_debug.debug('Row Identifier =' || attr_rec.ROW_IDENTIFIER);
853: pa_debug.debug('ATTR_INT_NAME =' || attr_rec.ATTR_INT_NAME);
854: pa_debug.debug('ATTR_VALUE_STR =' || attr_rec.ATTR_VALUE_STR);
855: pa_debug.debug('ATTR_VALUE_NUM =' || attr_rec.ATTR_VALUE_NUM);

Line 852: pa_debug.debug('Row Identifier =' || attr_rec.ROW_IDENTIFIER);

848: ,attr_rec.USER_ROW_IDENTIFIER
849: );
850: IF (p_debug_mode = 'Y') then
851: pa_debug.debug('Build Data Object:');
852: pa_debug.debug('Row Identifier =' || attr_rec.ROW_IDENTIFIER);
853: pa_debug.debug('ATTR_INT_NAME =' || attr_rec.ATTR_INT_NAME);
854: pa_debug.debug('ATTR_VALUE_STR =' || attr_rec.ATTR_VALUE_STR);
855: pa_debug.debug('ATTR_VALUE_NUM =' || attr_rec.ATTR_VALUE_NUM);
856: pa_debug.debug('ATTR_VALUE_DATE =' || attr_rec.ATTR_VALUE_DATE);

Line 853: pa_debug.debug('ATTR_INT_NAME =' || attr_rec.ATTR_INT_NAME);

849: );
850: IF (p_debug_mode = 'Y') then
851: pa_debug.debug('Build Data Object:');
852: pa_debug.debug('Row Identifier =' || attr_rec.ROW_IDENTIFIER);
853: pa_debug.debug('ATTR_INT_NAME =' || attr_rec.ATTR_INT_NAME);
854: pa_debug.debug('ATTR_VALUE_STR =' || attr_rec.ATTR_VALUE_STR);
855: pa_debug.debug('ATTR_VALUE_NUM =' || attr_rec.ATTR_VALUE_NUM);
856: pa_debug.debug('ATTR_VALUE_DATE =' || attr_rec.ATTR_VALUE_DATE);
857: pa_debug.debug('ATTR_DISP_VALUE =' || attr_rec.ATTR_DISP_VALUE);

Line 854: pa_debug.debug('ATTR_VALUE_STR =' || attr_rec.ATTR_VALUE_STR);

850: IF (p_debug_mode = 'Y') then
851: pa_debug.debug('Build Data Object:');
852: pa_debug.debug('Row Identifier =' || attr_rec.ROW_IDENTIFIER);
853: pa_debug.debug('ATTR_INT_NAME =' || attr_rec.ATTR_INT_NAME);
854: pa_debug.debug('ATTR_VALUE_STR =' || attr_rec.ATTR_VALUE_STR);
855: pa_debug.debug('ATTR_VALUE_NUM =' || attr_rec.ATTR_VALUE_NUM);
856: pa_debug.debug('ATTR_VALUE_DATE =' || attr_rec.ATTR_VALUE_DATE);
857: pa_debug.debug('ATTR_DISP_VALUE =' || attr_rec.ATTR_DISP_VALUE);
858: END IF;

Line 855: pa_debug.debug('ATTR_VALUE_NUM =' || attr_rec.ATTR_VALUE_NUM);

851: pa_debug.debug('Build Data Object:');
852: pa_debug.debug('Row Identifier =' || attr_rec.ROW_IDENTIFIER);
853: pa_debug.debug('ATTR_INT_NAME =' || attr_rec.ATTR_INT_NAME);
854: pa_debug.debug('ATTR_VALUE_STR =' || attr_rec.ATTR_VALUE_STR);
855: pa_debug.debug('ATTR_VALUE_NUM =' || attr_rec.ATTR_VALUE_NUM);
856: pa_debug.debug('ATTR_VALUE_DATE =' || attr_rec.ATTR_VALUE_DATE);
857: pa_debug.debug('ATTR_DISP_VALUE =' || attr_rec.ATTR_DISP_VALUE);
858: END IF;
859: ------------------------------------------------------

Line 856: pa_debug.debug('ATTR_VALUE_DATE =' || attr_rec.ATTR_VALUE_DATE);

852: pa_debug.debug('Row Identifier =' || attr_rec.ROW_IDENTIFIER);
853: pa_debug.debug('ATTR_INT_NAME =' || attr_rec.ATTR_INT_NAME);
854: pa_debug.debug('ATTR_VALUE_STR =' || attr_rec.ATTR_VALUE_STR);
855: pa_debug.debug('ATTR_VALUE_NUM =' || attr_rec.ATTR_VALUE_NUM);
856: pa_debug.debug('ATTR_VALUE_DATE =' || attr_rec.ATTR_VALUE_DATE);
857: pa_debug.debug('ATTR_DISP_VALUE =' || attr_rec.ATTR_DISP_VALUE);
858: END IF;
859: ------------------------------------------------------
860: -- Update these variables for the next loop through --

Line 857: pa_debug.debug('ATTR_DISP_VALUE =' || attr_rec.ATTR_DISP_VALUE);

853: pa_debug.debug('ATTR_INT_NAME =' || attr_rec.ATTR_INT_NAME);
854: pa_debug.debug('ATTR_VALUE_STR =' || attr_rec.ATTR_VALUE_STR);
855: pa_debug.debug('ATTR_VALUE_NUM =' || attr_rec.ATTR_VALUE_NUM);
856: pa_debug.debug('ATTR_VALUE_DATE =' || attr_rec.ATTR_VALUE_DATE);
857: pa_debug.debug('ATTR_DISP_VALUE =' || attr_rec.ATTR_DISP_VALUE);
858: END IF;
859: ------------------------------------------------------
860: -- Update these variables for the next loop through --
861: ------------------------------------------------------

Line 872: pa_debug.debug('>> EGO_USER_ATTRS_DATA_PUB.Process_User_Attrs_Data');

868: -- Since we are done looping and constructing the pl/sql tables,we are --
869: -- ready to process the data we've collected for this project instance --
870: -------------------------------------------------------------------------
871: if (p_debug_mode = 'Y') then
872: pa_debug.debug('>> EGO_USER_ATTRS_DATA_PUB.Process_User_Attrs_Data');
873: end if;
874: p_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(); --Bug 7688888
875: EGO_USER_ATTRS_DATA_PUB.Process_User_Attrs_Data
876: (

Line 897: pa_debug.debug('>> EGO_USER_ATTRS_DATA_PUB.Process_User_Attrs_Data');

893: ,x_msg_count => l_msg_count
894: ,x_msg_data => l_msg_data
895: );
896: if (p_debug_mode = 'Y') then
897: pa_debug.debug('>> EGO_USER_ATTRS_DATA_PUB.Process_User_Attrs_Data');
898: pa_debug.debug('Return Status = ' || l_return_status);
899: pa_debug.debug('Message Count = ' || l_msg_count);
900: end if;
901:

Line 898: pa_debug.debug('Return Status = ' || l_return_status);

894: ,x_msg_data => l_msg_data
895: );
896: if (p_debug_mode = 'Y') then
897: pa_debug.debug('>> EGO_USER_ATTRS_DATA_PUB.Process_User_Attrs_Data');
898: pa_debug.debug('Return Status = ' || l_return_status);
899: pa_debug.debug('Message Count = ' || l_msg_count);
900: end if;
901:
902: -- process error status/messages

Line 899: pa_debug.debug('Message Count = ' || l_msg_count);

895: );
896: if (p_debug_mode = 'Y') then
897: pa_debug.debug('>> EGO_USER_ATTRS_DATA_PUB.Process_User_Attrs_Data');
898: pa_debug.debug('Return Status = ' || l_return_status);
899: pa_debug.debug('Message Count = ' || l_msg_count);
900: end if;
901:
902: -- process error status/messages
903: x_failed_row_id_list := l_failed_row_id_list;