APPS.PA_ACTIONS_PVT dependencies on PA_DEBUG

Line 129: PA_DEBUG.set_curr_function( p_function => 'CREATE_DLV_ACTIONS_IN_BULK'

125: x_msg_count := 0;
126: x_return_status := FND_API.G_RET_STS_SUCCESS;
127:
128: IF p_debug_mode = 'Y' THEN
129: PA_DEBUG.set_curr_function( p_function => 'CREATE_DLV_ACTIONS_IN_BULK'
130: ,p_debug_mode => p_debug_mode );
131: pa_debug.g_err_stage:= 'Inside CREATE_DLV_ACTIONS_IN_BULK ';
132: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
133: END IF;

Line 131: pa_debug.g_err_stage:= 'Inside CREATE_DLV_ACTIONS_IN_BULK ';

127:
128: IF p_debug_mode = 'Y' THEN
129: PA_DEBUG.set_curr_function( p_function => 'CREATE_DLV_ACTIONS_IN_BULK'
130: ,p_debug_mode => p_debug_mode );
131: pa_debug.g_err_stage:= 'Inside CREATE_DLV_ACTIONS_IN_BULK ';
132: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
133: END IF;
134:
135: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

Line 132: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

128: IF p_debug_mode = 'Y' THEN
129: PA_DEBUG.set_curr_function( p_function => 'CREATE_DLV_ACTIONS_IN_BULK'
130: ,p_debug_mode => p_debug_mode );
131: pa_debug.g_err_stage:= 'Inside CREATE_DLV_ACTIONS_IN_BULK ';
132: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
133: END IF;
134:
135: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
136: FND_MSG_PUB.initialize;

Line 140: pa_debug.write(g_module_name,'Printing Input Parameters ',3) ;

136: FND_MSG_PUB.initialize;
137: END IF;
138:
139: IF p_debug_mode = 'Y' THEN
140: pa_debug.write(g_module_name,'Printing Input Parameters ',3) ;
141: pa_debug.write(g_module_name,'#'||p_project_id||'#'||p_object_id||'#'||p_object_version_id||'#'||p_object_type||'#'||
142: p_pm_source_code||'#'||p_carrying_out_organization_id,3) ;
143:
144: IF (p_calling_module = 'AMG') THEN

Line 141: pa_debug.write(g_module_name,'#'||p_project_id||'#'||p_object_id||'#'||p_object_version_id||'#'||p_object_type||'#'||

137: END IF;
138:
139: IF p_debug_mode = 'Y' THEN
140: pa_debug.write(g_module_name,'Printing Input Parameters ',3) ;
141: pa_debug.write(g_module_name,'#'||p_project_id||'#'||p_object_id||'#'||p_object_version_id||'#'||p_object_type||'#'||
142: p_pm_source_code||'#'||p_carrying_out_organization_id,3) ;
143:
144: IF (p_calling_module = 'AMG') THEN
145: i := p_name_tbl.first();

Line 147: pa_debug.write(g_module_name,'#1'||p_name_tbl(i)||'#'||p_manager_person_id_tbl(i)||'#'||p_function_code_tbl(i)||'#'||p_due_date_tbl(i)||'#'||p_completed_flag_tbl(i)||'#'||p_pm_source_reference_tbl(i),3) ;

143:
144: IF (p_calling_module = 'AMG') THEN
145: i := p_name_tbl.first();
146: WHILE i is not null loop
147: pa_debug.write(g_module_name,'#1'||p_name_tbl(i)||'#'||p_manager_person_id_tbl(i)||'#'||p_function_code_tbl(i)||'#'||p_due_date_tbl(i)||'#'||p_completed_flag_tbl(i)||'#'||p_pm_source_reference_tbl(i),3) ;
148: pa_debug.write(g_module_name,'#2'||p_completion_date_tbl(i)||'#'||p_description_tbl(i)||'#'||p_element_version_id_tbl(i)||'#'||p_proj_element_id_tbl(i)||'#'||p_record_version_number_tbl(i) ,3) ;
149:
150: i := p_name_tbl.next(i);
151: end loop;

Line 148: pa_debug.write(g_module_name,'#2'||p_completion_date_tbl(i)||'#'||p_description_tbl(i)||'#'||p_element_version_id_tbl(i)||'#'||p_proj_element_id_tbl(i)||'#'||p_record_version_number_tbl(i) ,3) ;

144: IF (p_calling_module = 'AMG') THEN
145: i := p_name_tbl.first();
146: WHILE i is not null loop
147: pa_debug.write(g_module_name,'#1'||p_name_tbl(i)||'#'||p_manager_person_id_tbl(i)||'#'||p_function_code_tbl(i)||'#'||p_due_date_tbl(i)||'#'||p_completed_flag_tbl(i)||'#'||p_pm_source_reference_tbl(i),3) ;
148: pa_debug.write(g_module_name,'#2'||p_completion_date_tbl(i)||'#'||p_description_tbl(i)||'#'||p_element_version_id_tbl(i)||'#'||p_proj_element_id_tbl(i)||'#'||p_record_version_number_tbl(i) ,3) ;
149:
150: i := p_name_tbl.next(i);
151: end loop;
152: END IF; -- p_calling_module = 'AMG'

Line 159: pa_debug.g_err_stage := 'Bulk inserting into PA_PROJ_ELEMENTS';

155: IF nvl(p_name_tbl.LAST,0)> 0 THEN
156:
157: -- populate the element table
158: IF p_debug_mode = 'Y' THEN
159: pa_debug.g_err_stage := 'Bulk inserting into PA_PROJ_ELEMENTS';
160: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
161: END IF;
162:
163: -- 3574730 : not able to create deliverable, default actions copy is causing the problem

Line 160: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);

156:
157: -- populate the element table
158: IF p_debug_mode = 'Y' THEN
159: pa_debug.g_err_stage := 'Bulk inserting into PA_PROJ_ELEMENTS';
160: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
161: END IF;
162:
163: -- 3574730 : not able to create deliverable, default actions copy is causing the problem
164: -- the below code must be removed once permanent fix is done

Line 276: pa_debug.g_err_stage := 'Bulk inserting into PA_PROJ_ELEMENT_VERSIONS';

272: BULK COLLECT INTO l_proj_element_id_tbl ;
273:
274:
275: IF p_debug_mode = 'Y' THEN
276: pa_debug.g_err_stage := 'Bulk inserting into PA_PROJ_ELEMENT_VERSIONS';
277: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
278: END IF;
279:
280:

Line 277: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);

273:
274:
275: IF p_debug_mode = 'Y' THEN
276: pa_debug.g_err_stage := 'Bulk inserting into PA_PROJ_ELEMENT_VERSIONS';
277: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
278: END IF;
279:
280:
281: -- populate the element version table

Line 321: pa_debug.g_err_stage := 'Bulk inserting into PA_PROJ_ELEM_VER_SCHEDULE';

317: BULK COLLECT INTO l_element_version_id_tbl ;
318:
319:
320: IF p_debug_mode = 'Y' THEN
321: pa_debug.g_err_stage := 'Bulk inserting into PA_PROJ_ELEM_VER_SCHEDULE';
322: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
323: END IF;
324:
325: -- populate the element version table

Line 322: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);

318:
319:
320: IF p_debug_mode = 'Y' THEN
321: pa_debug.g_err_stage := 'Bulk inserting into PA_PROJ_ELEM_VER_SCHEDULE';
322: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
323: END IF;
324:
325: -- populate the element version table
326: FORALL i in l_element_version_id_tbl.FIRST..l_element_version_id_tbl.LAST

Line 368: pa_debug.g_err_stage := 'Bulk inserting into PA_OBJECT_RELATIONSHIPS';

364: l_rel_subtype := g_dlvr_to_action ;
365: END IF;
366:
367: IF p_debug_mode = 'Y' THEN
368: pa_debug.g_err_stage := 'Bulk inserting into PA_OBJECT_RELATIONSHIPS';
369: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
370: END IF;
371:
372: -- populate the object relationships table

Line 369: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);

365: END IF;
366:
367: IF p_debug_mode = 'Y' THEN
368: pa_debug.g_err_stage := 'Bulk inserting into PA_OBJECT_RELATIONSHIPS';
369: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
370: END IF;
371:
372: -- populate the object relationships table
373: FORALL i in l_proj_element_id_tbl.FIRST..l_proj_element_id_tbl.LAST

Line 412: pa_debug.reset_curr_function;

408: ) ;
409: END IF ;
410:
411: IF p_debug_mode = 'Y' THEN --Added for bug 4945876
412: pa_debug.reset_curr_function;
413: END IF;
414:
415: EXCEPTION
416: WHEN OTHERS THEN

Line 423: pa_debug.g_err_stage := 'Exiting CREATE_DLV_ACTIONS_IN_BULK' ;

419: x_msg_data := SQLERRM;
420: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_ACTIONS_PVT'
421: ,p_procedure_name => 'CREATE_DLV_ACTIONS_IN_BULK');
422: IF p_debug_mode = 'Y' THEN
423: pa_debug.g_err_stage := 'Exiting CREATE_DLV_ACTIONS_IN_BULK' ;
424: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
425: pa_debug.reset_curr_function;
426: END IF;
427: RAISE;

Line 424: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);

420: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_ACTIONS_PVT'
421: ,p_procedure_name => 'CREATE_DLV_ACTIONS_IN_BULK');
422: IF p_debug_mode = 'Y' THEN
423: pa_debug.g_err_stage := 'Exiting CREATE_DLV_ACTIONS_IN_BULK' ;
424: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
425: pa_debug.reset_curr_function;
426: END IF;
427: RAISE;
428: END CREATE_DLV_ACTIONS_IN_BULK ;

Line 425: pa_debug.reset_curr_function;

421: ,p_procedure_name => 'CREATE_DLV_ACTIONS_IN_BULK');
422: IF p_debug_mode = 'Y' THEN
423: pa_debug.g_err_stage := 'Exiting CREATE_DLV_ACTIONS_IN_BULK' ;
424: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
425: pa_debug.reset_curr_function;
426: END IF;
427: RAISE;
428: END CREATE_DLV_ACTIONS_IN_BULK ;
429:

Line 539: PA_DEBUG.set_curr_function( p_function => 'CR_DLV_ACTIONS_IN_BULK'

535: x_msg_count := 0;
536: x_return_status := FND_API.G_RET_STS_SUCCESS;
537:
538: IF p_debug_mode = 'Y' THEN
539: PA_DEBUG.set_curr_function( p_function => 'CR_DLV_ACTIONS_IN_BULK'
540: ,p_debug_mode => p_debug_mode );
541: pa_debug.g_err_stage:= 'Inside UPDATE_DLV_ACTIONS_IN_BULK ';
542: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
543: END IF;

Line 541: pa_debug.g_err_stage:= 'Inside UPDATE_DLV_ACTIONS_IN_BULK ';

537:
538: IF p_debug_mode = 'Y' THEN
539: PA_DEBUG.set_curr_function( p_function => 'CR_DLV_ACTIONS_IN_BULK'
540: ,p_debug_mode => p_debug_mode );
541: pa_debug.g_err_stage:= 'Inside UPDATE_DLV_ACTIONS_IN_BULK ';
542: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
543: END IF;
544:
545: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

Line 542: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

538: IF p_debug_mode = 'Y' THEN
539: PA_DEBUG.set_curr_function( p_function => 'CR_DLV_ACTIONS_IN_BULK'
540: ,p_debug_mode => p_debug_mode );
541: pa_debug.g_err_stage:= 'Inside UPDATE_DLV_ACTIONS_IN_BULK ';
542: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
543: END IF;
544:
545: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
546: FND_MSG_PUB.initialize;

Line 626: pa_debug.g_err_stage := 'Exiting UPDATE_DLV_ACTIONS_IN_BULK' ;

622:
623: -- 3941159 end
624:
625: IF p_debug_mode = 'Y' THEN
626: pa_debug.g_err_stage := 'Exiting UPDATE_DLV_ACTIONS_IN_BULK' ;
627: pa_debug.write(g_module_name, pa_debug.g_err_stage, 5);
628: pa_debug.reset_curr_function;
629: END IF;
630:

Line 627: pa_debug.write(g_module_name, pa_debug.g_err_stage, 5);

623: -- 3941159 end
624:
625: IF p_debug_mode = 'Y' THEN
626: pa_debug.g_err_stage := 'Exiting UPDATE_DLV_ACTIONS_IN_BULK' ;
627: pa_debug.write(g_module_name, pa_debug.g_err_stage, 5);
628: pa_debug.reset_curr_function;
629: END IF;
630:
631: EXCEPTION

Line 628: pa_debug.reset_curr_function;

624:
625: IF p_debug_mode = 'Y' THEN
626: pa_debug.g_err_stage := 'Exiting UPDATE_DLV_ACTIONS_IN_BULK' ;
627: pa_debug.write(g_module_name, pa_debug.g_err_stage, 5);
628: pa_debug.reset_curr_function;
629: END IF;
630:
631: EXCEPTION
632: WHEN OTHERS THEN

Line 639: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

635: x_msg_data := SQLERRM;
636: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_ACTIONS_PVT'
637: ,p_procedure_name => 'UPDATE_DLV_ACTIONS_IN_BULK');
638: IF p_debug_mode = 'Y' THEN
639: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
640: pa_debug.write('UPDATE_DLV_ACTIONS_IN_BULK: ' || g_module_name,pa_debug.g_err_stage,5);
641: pa_debug.reset_curr_function;
642: END IF;
643: RAISE;

Line 640: pa_debug.write('UPDATE_DLV_ACTIONS_IN_BULK: ' || g_module_name,pa_debug.g_err_stage,5);

636: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_ACTIONS_PVT'
637: ,p_procedure_name => 'UPDATE_DLV_ACTIONS_IN_BULK');
638: IF p_debug_mode = 'Y' THEN
639: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
640: pa_debug.write('UPDATE_DLV_ACTIONS_IN_BULK: ' || g_module_name,pa_debug.g_err_stage,5);
641: pa_debug.reset_curr_function;
642: END IF;
643: RAISE;
644: END UPDATE_DLV_ACTIONS_IN_BULK ;

Line 641: pa_debug.reset_curr_function;

637: ,p_procedure_name => 'UPDATE_DLV_ACTIONS_IN_BULK');
638: IF p_debug_mode = 'Y' THEN
639: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
640: pa_debug.write('UPDATE_DLV_ACTIONS_IN_BULK: ' || g_module_name,pa_debug.g_err_stage,5);
641: pa_debug.reset_curr_function;
642: END IF;
643: RAISE;
644: END UPDATE_DLV_ACTIONS_IN_BULK ;
645:

Line 712: PA_DEBUG.set_curr_function( p_function => 'DELETE_DLV_ACTIONS_IN_BULK'

708: x_msg_count := 0;
709: x_return_status := FND_API.G_RET_STS_SUCCESS;
710:
711: IF p_debug_mode = 'Y' THEN
712: PA_DEBUG.set_curr_function( p_function => 'DELETE_DLV_ACTIONS_IN_BULK'
713: ,p_debug_mode => p_debug_mode );
714: pa_debug.g_err_stage:= 'Inside DELETE_DLV_ACTIONS_IN_BULK ';
715: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
716: END IF;

Line 714: pa_debug.g_err_stage:= 'Inside DELETE_DLV_ACTIONS_IN_BULK ';

710:
711: IF p_debug_mode = 'Y' THEN
712: PA_DEBUG.set_curr_function( p_function => 'DELETE_DLV_ACTIONS_IN_BULK'
713: ,p_debug_mode => p_debug_mode );
714: pa_debug.g_err_stage:= 'Inside DELETE_DLV_ACTIONS_IN_BULK ';
715: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
716: END IF;
717:
718: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

Line 715: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

711: IF p_debug_mode = 'Y' THEN
712: PA_DEBUG.set_curr_function( p_function => 'DELETE_DLV_ACTIONS_IN_BULK'
713: ,p_debug_mode => p_debug_mode );
714: pa_debug.g_err_stage:= 'Inside DELETE_DLV_ACTIONS_IN_BULK ';
715: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
716: END IF;
717:
718: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
719: FND_MSG_PUB.initialize;

Line 770: pa_debug.g_err_stage:='Delete entries from PA_OBJECT_RELATIONSHIPS table' ;

766: -- Delete the entries from PA_OBJECT_RELATIONSHIPS table
767: IF nvl(p_proj_element_id_tbl.LAST,0)>0 THEN
768:
769: IF p_debug_mode = 'Y' THEN
770: pa_debug.g_err_stage:='Delete entries from PA_OBJECT_RELATIONSHIPS table' ;
771: pa_debug.write('DELETE_DLV_ACTIONS_IN_BULK: ' || g_module_name,pa_debug.g_err_stage,5);
772: END IF;
773:
774: FORALL i in p_proj_element_id_tbl.FIRST..p_proj_element_id_tbl.LAST

Line 771: pa_debug.write('DELETE_DLV_ACTIONS_IN_BULK: ' || g_module_name,pa_debug.g_err_stage,5);

767: IF nvl(p_proj_element_id_tbl.LAST,0)>0 THEN
768:
769: IF p_debug_mode = 'Y' THEN
770: pa_debug.g_err_stage:='Delete entries from PA_OBJECT_RELATIONSHIPS table' ;
771: pa_debug.write('DELETE_DLV_ACTIONS_IN_BULK: ' || g_module_name,pa_debug.g_err_stage,5);
772: END IF;
773:
774: FORALL i in p_proj_element_id_tbl.FIRST..p_proj_element_id_tbl.LAST
775: DELETE FROM PA_OBJECT_RELATIONSHIPS

Line 784: pa_debug.g_err_stage:='Delete entries from PA_PROJ_ELEM_VER_SCHEDULE table' ;

780: -- Delete the entries from PA_PROJ_ELEM_VER_SCHEDULE table
781: IF nvl(p_element_version_id_tbl.LAST,0)>0 THEN
782:
783: IF p_debug_mode = 'Y' THEN
784: pa_debug.g_err_stage:='Delete entries from PA_PROJ_ELEM_VER_SCHEDULE table' ;
785: pa_debug.write('DELETE_DLV_ACTIONS_IN_BULK: ' || g_module_name,pa_debug.g_err_stage,5);
786: END IF;
787:
788: FORALL i in p_element_version_id_tbl.FIRST..p_element_version_id_tbl.LAST

Line 785: pa_debug.write('DELETE_DLV_ACTIONS_IN_BULK: ' || g_module_name,pa_debug.g_err_stage,5);

781: IF nvl(p_element_version_id_tbl.LAST,0)>0 THEN
782:
783: IF p_debug_mode = 'Y' THEN
784: pa_debug.g_err_stage:='Delete entries from PA_PROJ_ELEM_VER_SCHEDULE table' ;
785: pa_debug.write('DELETE_DLV_ACTIONS_IN_BULK: ' || g_module_name,pa_debug.g_err_stage,5);
786: END IF;
787:
788: FORALL i in p_element_version_id_tbl.FIRST..p_element_version_id_tbl.LAST
789: DELETE FROM PA_PROJ_ELEM_VER_SCHEDULE

Line 798: pa_debug.g_err_stage:='Delete entries from PA_ELEMENT_VERSIONS table' ;

794: -- Delete the entries from PA_ELEMENT_VERSIONS table
795: IF nvl(p_element_version_id_tbl.LAST,0)>0 THEN
796:
797: IF p_debug_mode = 'Y' THEN
798: pa_debug.g_err_stage:='Delete entries from PA_ELEMENT_VERSIONS table' ;
799: pa_debug.write('DELETE_DLV_ACTIONS_IN_BULK: ' || g_module_name,pa_debug.g_err_stage,5);
800: END IF;
801:
802: FORALL i in p_element_version_id_tbl.FIRST..p_element_version_id_tbl.LAST

Line 799: pa_debug.write('DELETE_DLV_ACTIONS_IN_BULK: ' || g_module_name,pa_debug.g_err_stage,5);

795: IF nvl(p_element_version_id_tbl.LAST,0)>0 THEN
796:
797: IF p_debug_mode = 'Y' THEN
798: pa_debug.g_err_stage:='Delete entries from PA_ELEMENT_VERSIONS table' ;
799: pa_debug.write('DELETE_DLV_ACTIONS_IN_BULK: ' || g_module_name,pa_debug.g_err_stage,5);
800: END IF;
801:
802: FORALL i in p_element_version_id_tbl.FIRST..p_element_version_id_tbl.LAST
803: DELETE FROM PA_PROJ_ELEMENT_VERSIONS

Line 813: pa_debug.g_err_stage:='Delete entries from PA_ELEMENT_VERSIONS table' ;

809: -- Delete the entries from PA_PROJ_ELEMENTS table
810: IF nvl(p_proj_element_id_tbl.LAST,0)>0 THEN
811:
812: IF p_debug_mode = 'Y' THEN
813: pa_debug.g_err_stage:='Delete entries from PA_ELEMENT_VERSIONS table' ;
814: pa_debug.write('DELETE_DLV_ACTIONS_IN_BULK: ' || g_module_name,pa_debug.g_err_stage,5);
815: END IF;
816:
817: FORALL i in p_proj_element_id_tbl.FIRST..p_proj_element_id_tbl.LAST

Line 814: pa_debug.write('DELETE_DLV_ACTIONS_IN_BULK: ' || g_module_name,pa_debug.g_err_stage,5);

810: IF nvl(p_proj_element_id_tbl.LAST,0)>0 THEN
811:
812: IF p_debug_mode = 'Y' THEN
813: pa_debug.g_err_stage:='Delete entries from PA_ELEMENT_VERSIONS table' ;
814: pa_debug.write('DELETE_DLV_ACTIONS_IN_BULK: ' || g_module_name,pa_debug.g_err_stage,5);
815: END IF;
816:
817: FORALL i in p_proj_element_id_tbl.FIRST..p_proj_element_id_tbl.LAST
818: DELETE FROM PA_PROJ_ELEMENTS

Line 824: pa_debug.g_err_stage := 'Exiting UPDATE_DLV_ACTIONS_IN_BULK' ;

820:
821: END IF ;
822:
823: IF p_debug_mode = 'Y' THEN
824: pa_debug.g_err_stage := 'Exiting UPDATE_DLV_ACTIONS_IN_BULK' ;
825: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
826: pa_debug.reset_curr_function;
827: END IF;
828:

Line 825: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);

821: END IF ;
822:
823: IF p_debug_mode = 'Y' THEN
824: pa_debug.g_err_stage := 'Exiting UPDATE_DLV_ACTIONS_IN_BULK' ;
825: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
826: pa_debug.reset_curr_function;
827: END IF;
828:
829: EXCEPTION

Line 826: pa_debug.reset_curr_function;

822:
823: IF p_debug_mode = 'Y' THEN
824: pa_debug.g_err_stage := 'Exiting UPDATE_DLV_ACTIONS_IN_BULK' ;
825: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
826: pa_debug.reset_curr_function;
827: END IF;
828:
829: EXCEPTION
830: WHEN OTHERS THEN

Line 837: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

833: x_msg_data := SQLERRM;
834: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_ACTIONS_PVT'
835: ,p_procedure_name => 'DELETE_DLV_ACTIONS_IN_BULK');
836: IF p_debug_mode = 'Y' THEN
837: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
838: pa_debug.write('DELETE_DLV_ACTIONS_IN_BULK: ' || g_module_name,pa_debug.g_err_stage,5);
839: pa_debug.reset_curr_function;
840: END IF;
841: RAISE;

Line 838: pa_debug.write('DELETE_DLV_ACTIONS_IN_BULK: ' || g_module_name,pa_debug.g_err_stage,5);

834: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_ACTIONS_PVT'
835: ,p_procedure_name => 'DELETE_DLV_ACTIONS_IN_BULK');
836: IF p_debug_mode = 'Y' THEN
837: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
838: pa_debug.write('DELETE_DLV_ACTIONS_IN_BULK: ' || g_module_name,pa_debug.g_err_stage,5);
839: pa_debug.reset_curr_function;
840: END IF;
841: RAISE;
842: END DELETE_DLV_ACTIONS_IN_BULK ;

Line 839: pa_debug.reset_curr_function;

835: ,p_procedure_name => 'DELETE_DLV_ACTIONS_IN_BULK');
836: IF p_debug_mode = 'Y' THEN
837: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
838: pa_debug.write('DELETE_DLV_ACTIONS_IN_BULK: ' || g_module_name,pa_debug.g_err_stage,5);
839: pa_debug.reset_curr_function;
840: END IF;
841: RAISE;
842: END DELETE_DLV_ACTIONS_IN_BULK ;
843:

Line 908: PA_DEBUG.set_curr_function( p_function => 'PA_DELETE_DLV_ACTION'

904: x_msg_count := 0;
905: x_return_status := FND_API.G_RET_STS_SUCCESS;
906:
907: IF p_debug_mode = 'Y' THEN
908: PA_DEBUG.set_curr_function( p_function => 'PA_DELETE_DLV_ACTION'
909: ,p_debug_mode => p_debug_mode );
910: pa_debug.g_err_stage:= 'Inside DELETE_DLV_ACTION ';
911: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
912: END IF;

Line 910: pa_debug.g_err_stage:= 'Inside DELETE_DLV_ACTION ';

906:
907: IF p_debug_mode = 'Y' THEN
908: PA_DEBUG.set_curr_function( p_function => 'PA_DELETE_DLV_ACTION'
909: ,p_debug_mode => p_debug_mode );
910: pa_debug.g_err_stage:= 'Inside DELETE_DLV_ACTION ';
911: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
912: END IF;
913:
914: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

Line 911: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

907: IF p_debug_mode = 'Y' THEN
908: PA_DEBUG.set_curr_function( p_function => 'PA_DELETE_DLV_ACTION'
909: ,p_debug_mode => p_debug_mode );
910: pa_debug.g_err_stage:= 'Inside DELETE_DLV_ACTION ';
911: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
912: END IF;
913:
914: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
915: FND_MSG_PUB.initialize;

Line 950: pa_debug.g_err_stage:= 'Inside DELETE BILLING EVENTS ';

946:
947: IF l_function_code = g_billing THEN
948:
949: IF p_debug_mode = 'Y' THEN
950: pa_debug.g_err_stage:= 'Inside DELETE BILLING EVENTS ';
951: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
952: END IF;
953:
954: -- Delete the billing event if its a billing function

Line 951: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

947: IF l_function_code = g_billing THEN
948:
949: IF p_debug_mode = 'Y' THEN
950: pa_debug.g_err_stage:= 'Inside DELETE BILLING EVENTS ';
951: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
952: END IF;
953:
954: -- Delete the billing event if its a billing function
955: PA_BILLING_WRKBNCH_EVENTS.DELETE_DELV_EVENT

Line 963: pa_debug.write(g_module_name,'Returned from PA_BILLING_WRKBNCH_EVENTS.DELETE_DELV_EVENT ['||x_return_status||']',3) ;

959: ,P_Action_Name => l_name
960: ,X_Return_Status => x_return_status
961: ) ;
962: IF p_debug_mode = 'Y' THEN
963: pa_debug.write(g_module_name,'Returned from PA_BILLING_WRKBNCH_EVENTS.DELETE_DELV_EVENT ['||x_return_status||']',3) ;
964: END IF;
965:
966: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
967: RAISE Invalid_Arg_Exc_Dlv ;

Line 990: pa_debug.write(g_module_name,'Returned from OKE_DELIVERABLE_UTILS_PUB.DELETE_ACTION ['||x_return_status||']',3) ;

986: -- , X_Msg_Data => x_msg_data
987: -- ) ;
988:
989: IF p_debug_mode = 'Y' THEN
990: pa_debug.write(g_module_name,'Returned from OKE_DELIVERABLE_UTILS_PUB.DELETE_ACTION ['||x_return_status||']',3) ;
991: END IF;
992:
993: -- IF X_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
994: -- RAISE Invalid_Arg_Exc_Dlv ;

Line 1020: pa_debug.write(g_module_name,'Returned from oke_amg_grp.manage_dlv_action['||l_function_code||'] ['||x_return_status||']',3) ;

1016: , x_msg_count => x_msg_count
1017: );
1018:
1019: IF p_debug_mode = 'Y' THEN
1020: pa_debug.write(g_module_name,'Returned from oke_amg_grp.manage_dlv_action['||l_function_code||'] ['||x_return_status||']',3) ;
1021: END IF;
1022:
1023: IF X_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
1024: RAISE Invalid_Arg_Exc_Dlv ;

Line 1050: pa_debug.write(g_module_name,'Returned from oke_amg_grp.manage_dlv_action['||l_function_code||'] ['||x_return_status||']',3) ;

1046: , x_msg_count => x_msg_count
1047: );
1048:
1049: IF p_debug_mode = 'Y' THEN
1050: pa_debug.write(g_module_name,'Returned from oke_amg_grp.manage_dlv_action['||l_function_code||'] ['||x_return_status||']',3) ;
1051: END IF;
1052:
1053: IF X_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
1054: RAISE Invalid_Arg_Exc_Dlv ;

Line 1080: pa_debug.g_err_stage := 'Exiting DELETE_DLV_ACTION' ;

1076: WHERE object_id_to2 = p_action_id
1077: and object_id_to1 = p_action_ver_id; -- Added condition for perf bug# 3964701
1078:
1079: IF p_debug_mode = 'Y' THEN
1080: pa_debug.g_err_stage := 'Exiting DELETE_DLV_ACTION' ;
1081: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
1082: pa_debug.reset_curr_function;
1083: END IF;
1084:

Line 1081: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);

1077: and object_id_to1 = p_action_ver_id; -- Added condition for perf bug# 3964701
1078:
1079: IF p_debug_mode = 'Y' THEN
1080: pa_debug.g_err_stage := 'Exiting DELETE_DLV_ACTION' ;
1081: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
1082: pa_debug.reset_curr_function;
1083: END IF;
1084:
1085: EXCEPTION

Line 1082: pa_debug.reset_curr_function;

1078:
1079: IF p_debug_mode = 'Y' THEN
1080: pa_debug.g_err_stage := 'Exiting DELETE_DLV_ACTION' ;
1081: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
1082: pa_debug.reset_curr_function;
1083: END IF;
1084:
1085: EXCEPTION
1086: WHEN Invalid_Arg_Exc_Dlv THEN

Line 1090: pa_debug.g_err_stage := 'inside invalid arg exception of DELETE_DLV_ACTION';

1086: WHEN Invalid_Arg_Exc_Dlv THEN
1087: x_return_status := FND_API.G_RET_STS_ERROR;
1088: l_msg_count := FND_MSG_PUB.count_msg;
1089: IF p_debug_mode = 'Y' THEN
1090: pa_debug.g_err_stage := 'inside invalid arg exception of DELETE_DLV_ACTION';
1091: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
1092: END IF;
1093:
1094: IF x_msg_count = 1 THEN

Line 1091: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);

1087: x_return_status := FND_API.G_RET_STS_ERROR;
1088: l_msg_count := FND_MSG_PUB.count_msg;
1089: IF p_debug_mode = 'Y' THEN
1090: pa_debug.g_err_stage := 'inside invalid arg exception of DELETE_DLV_ACTION';
1091: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
1092: END IF;
1093:
1094: IF x_msg_count = 1 THEN
1095: PA_INTERFACE_UTILS_PUB.get_messages

Line 1108: pa_debug.reset_curr_function;

1104: ELSE
1105: x_msg_count := l_msg_count;
1106: END IF;
1107: IF p_debug_mode = 'Y' THEN
1108: pa_debug.reset_curr_function;
1109: END IF ;
1110: RETURN;
1111: WHEN OTHERS THEN
1112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1120: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

1116: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_ACTIONS_PVT'
1117: ,p_procedure_name => 'DELETE_DLV_ACTION');
1118:
1119: IF p_debug_mode = 'Y' THEN
1120: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
1121: pa_debug.write(g_module_name, 'DELETE_DLV_ACTION: ' ||pa_debug.g_err_stage,5);
1122: pa_debug.reset_curr_function;
1123: END IF;
1124: RAISE;

Line 1121: pa_debug.write(g_module_name, 'DELETE_DLV_ACTION: ' ||pa_debug.g_err_stage,5);

1117: ,p_procedure_name => 'DELETE_DLV_ACTION');
1118:
1119: IF p_debug_mode = 'Y' THEN
1120: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
1121: pa_debug.write(g_module_name, 'DELETE_DLV_ACTION: ' ||pa_debug.g_err_stage,5);
1122: pa_debug.reset_curr_function;
1123: END IF;
1124: RAISE;
1125: END DELETE_DLV_ACTION ;

Line 1122: pa_debug.reset_curr_function;

1118:
1119: IF p_debug_mode = 'Y' THEN
1120: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
1121: pa_debug.write(g_module_name, 'DELETE_DLV_ACTION: ' ||pa_debug.g_err_stage,5);
1122: pa_debug.reset_curr_function;
1123: END IF;
1124: RAISE;
1125: END DELETE_DLV_ACTION ;
1126:

Line 1157: PA_DEBUG.set_curr_function( p_function => 'IS_DELETE_ACTION_ALLOWED'

1153: x_msg_count := 0;
1154: x_return_status := FND_API.G_RET_STS_SUCCESS;
1155:
1156: IF p_debug_mode = 'Y' THEN
1157: PA_DEBUG.set_curr_function( p_function => 'IS_DELETE_ACTION_ALLOWED'
1158: ,p_debug_mode => p_debug_mode );
1159: pa_debug.g_err_stage:= 'Inside IS_DELETE_ACTION_ALLOWED ';
1160: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1161: END IF;

Line 1159: pa_debug.g_err_stage:= 'Inside IS_DELETE_ACTION_ALLOWED ';

1155:
1156: IF p_debug_mode = 'Y' THEN
1157: PA_DEBUG.set_curr_function( p_function => 'IS_DELETE_ACTION_ALLOWED'
1158: ,p_debug_mode => p_debug_mode );
1159: pa_debug.g_err_stage:= 'Inside IS_DELETE_ACTION_ALLOWED ';
1160: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1161: END IF;
1162:
1163: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

Line 1160: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

1156: IF p_debug_mode = 'Y' THEN
1157: PA_DEBUG.set_curr_function( p_function => 'IS_DELETE_ACTION_ALLOWED'
1158: ,p_debug_mode => p_debug_mode );
1159: pa_debug.g_err_stage:= 'Inside IS_DELETE_ACTION_ALLOWED ';
1160: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1161: END IF;
1162:
1163: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
1164: FND_MSG_PUB.initialize;

Line 1175: pa_debug.g_err_stage := 'Exiting IS_DELETE_ACTION_ALLOWED' ;

1171: IF p_function_code = g_billing THEN
1172: IF nvl(PA_BILLING_WRKBNCH_EVENTS.CHECK_DELV_EVENT_PROCESSED(p_project_id,p_dlv_version_id,p_action_ver_id),'N') = 'Y' THEN
1173: l_err_message := 'PA_BILLING_ACTION_DEL_ERR' ;
1174: END IF ;
1175: pa_debug.g_err_stage := 'Exiting IS_DELETE_ACTION_ALLOWED' ;
1176: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
1177: ELSIF p_function_code = g_shipping THEN
1178: -- 3570283 changed parameter from p_dlv_version_id to p_action_ver_id
1179: -- api is expecting action version id and was passed deliverable version id

Line 1176: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);

1172: IF nvl(PA_BILLING_WRKBNCH_EVENTS.CHECK_DELV_EVENT_PROCESSED(p_project_id,p_dlv_version_id,p_action_ver_id),'N') = 'Y' THEN
1173: l_err_message := 'PA_BILLING_ACTION_DEL_ERR' ;
1174: END IF ;
1175: pa_debug.g_err_stage := 'Exiting IS_DELETE_ACTION_ALLOWED' ;
1176: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
1177: ELSIF p_function_code = g_shipping THEN
1178: -- 3570283 changed parameter from p_dlv_version_id to p_action_ver_id
1179: -- api is expecting action version id and was passed deliverable version id
1180:

Line 1233: pa_debug.g_err_stage := 'Exiting IS_DELETE_ACTION_ALLOWED' ;

1229: x_return_status := 'E';
1230: END IF ;
1231:
1232: IF p_debug_mode = 'Y' THEN
1233: pa_debug.g_err_stage := 'Exiting IS_DELETE_ACTION_ALLOWED' ;
1234: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
1235: pa_debug.reset_curr_function;
1236: END IF;
1237:

Line 1234: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);

1230: END IF ;
1231:
1232: IF p_debug_mode = 'Y' THEN
1233: pa_debug.g_err_stage := 'Exiting IS_DELETE_ACTION_ALLOWED' ;
1234: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
1235: pa_debug.reset_curr_function;
1236: END IF;
1237:
1238: EXCEPTION

Line 1235: pa_debug.reset_curr_function;

1231:
1232: IF p_debug_mode = 'Y' THEN
1233: pa_debug.g_err_stage := 'Exiting IS_DELETE_ACTION_ALLOWED' ;
1234: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
1235: pa_debug.reset_curr_function;
1236: END IF;
1237:
1238: EXCEPTION
1239: WHEN OTHERS THEN

Line 1248: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

1244: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_ACTIONS_PVT'
1245: ,p_procedure_name => 'IS_DELETE_ACTION_ALLOWED');
1246:
1247: IF p_debug_mode = 'Y' THEN
1248: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
1249: pa_debug.write('IS_DELETE_ACTION_ALLOWED: ' || g_module_name,pa_debug.g_err_stage,5);
1250: pa_debug.reset_curr_function;
1251: END IF;
1252: RAISE;

Line 1249: pa_debug.write('IS_DELETE_ACTION_ALLOWED: ' || g_module_name,pa_debug.g_err_stage,5);

1245: ,p_procedure_name => 'IS_DELETE_ACTION_ALLOWED');
1246:
1247: IF p_debug_mode = 'Y' THEN
1248: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
1249: pa_debug.write('IS_DELETE_ACTION_ALLOWED: ' || g_module_name,pa_debug.g_err_stage,5);
1250: pa_debug.reset_curr_function;
1251: END IF;
1252: RAISE;
1253: END IS_DELETE_ACTION_ALLOWED;

Line 1250: pa_debug.reset_curr_function;

1246:
1247: IF p_debug_mode = 'Y' THEN
1248: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
1249: pa_debug.write('IS_DELETE_ACTION_ALLOWED: ' || g_module_name,pa_debug.g_err_stage,5);
1250: pa_debug.reset_curr_function;
1251: END IF;
1252: RAISE;
1253: END IS_DELETE_ACTION_ALLOWED;
1254:

Line 1444: PA_DEBUG.set_curr_function( p_function => 'COPY_ACTIONS'

1440: x_msg_count := 0;
1441: x_return_status := FND_API.G_RET_STS_SUCCESS;
1442:
1443: IF p_debug_mode = 'Y' THEN
1444: PA_DEBUG.set_curr_function( p_function => 'COPY_ACTIONS'
1445: ,p_debug_mode => p_debug_mode );
1446: pa_debug.g_err_stage:= 'Inside COPY_ACTIONS ';
1447: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1448: END IF;

Line 1446: pa_debug.g_err_stage:= 'Inside COPY_ACTIONS ';

1442:
1443: IF p_debug_mode = 'Y' THEN
1444: PA_DEBUG.set_curr_function( p_function => 'COPY_ACTIONS'
1445: ,p_debug_mode => p_debug_mode );
1446: pa_debug.g_err_stage:= 'Inside COPY_ACTIONS ';
1447: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1448: END IF;
1449:
1450: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN

Line 1447: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

1443: IF p_debug_mode = 'Y' THEN
1444: PA_DEBUG.set_curr_function( p_function => 'COPY_ACTIONS'
1445: ,p_debug_mode => p_debug_mode );
1446: pa_debug.g_err_stage:= 'Inside COPY_ACTIONS ';
1447: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1448: END IF;
1449:
1450: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
1451: FND_MSG_PUB.initialize;

Line 1461: pa_debug.g_err_stage:= 'Before fetch:get_source_actions : ';

1457:
1458: --Fetch all the actions from the source to
1459: --PLSQL table.
1460: IF p_debug_mode = 'Y' THEN
1461: pa_debug.g_err_stage:= 'Before fetch:get_source_actions : ';
1462: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1463: END IF;
1464:
1465: -- Bug 3614361

Line 1462: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

1458: --Fetch all the actions from the source to
1459: --PLSQL table.
1460: IF p_debug_mode = 'Y' THEN
1461: pa_debug.g_err_stage:= 'Before fetch:get_source_actions : ';
1462: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1463: END IF;
1464:
1465: -- Bug 3614361
1466: IF p_source_object_type = g_dlvr_types THEN

Line 1506: pa_debug.g_err_stage:= 'After fetch:get_source_actions : ';

1502: ,l_rec_ver_num_id_tbl ;
1503: CLOSE get_source_actions ;
1504:
1505: IF p_debug_mode = 'Y' THEN
1506: pa_debug.g_err_stage:= 'After fetch:get_source_actions : ';
1507: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1508: pa_debug.g_err_stage:= ':l_name_tbl.LAST: '||l_name_tbl.LAST;
1509: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1510: END IF;

Line 1507: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

1503: CLOSE get_source_actions ;
1504:
1505: IF p_debug_mode = 'Y' THEN
1506: pa_debug.g_err_stage:= 'After fetch:get_source_actions : ';
1507: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1508: pa_debug.g_err_stage:= ':l_name_tbl.LAST: '||l_name_tbl.LAST;
1509: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1510: END IF;
1511: --Following code commented for Bug # 3431156

Line 1508: pa_debug.g_err_stage:= ':l_name_tbl.LAST: '||l_name_tbl.LAST;

1504:
1505: IF p_debug_mode = 'Y' THEN
1506: pa_debug.g_err_stage:= 'After fetch:get_source_actions : ';
1507: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1508: pa_debug.g_err_stage:= ':l_name_tbl.LAST: '||l_name_tbl.LAST;
1509: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1510: END IF;
1511: --Following code commented for Bug # 3431156
1512: /* -- Get the element version id of the deliverable

Line 1509: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

1505: IF p_debug_mode = 'Y' THEN
1506: pa_debug.g_err_stage:= 'After fetch:get_source_actions : ';
1507: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1508: pa_debug.g_err_stage:= ':l_name_tbl.LAST: '||l_name_tbl.LAST;
1509: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1510: END IF;
1511: --Following code commented for Bug # 3431156
1512: /* -- Get the element version id of the deliverable
1513: IF p_target_object_type = 'PA_DELIVERABLES' THEN

Line 1554: pa_debug.g_err_stage:= 'Before calling CREATE_DLV_ACTIONS_IN_BULK ';

1550: END IF ;
1551: END LOOP ;
1552: END IF ;
1553: IF p_debug_mode = 'Y' THEN
1554: pa_debug.g_err_stage:= 'Before calling CREATE_DLV_ACTIONS_IN_BULK ';
1555: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1556: END IF;
1557:
1558: -- If some thing is fetched call CREATE_DLV_ACTIONS_INBULK API

Line 1555: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

1551: END LOOP ;
1552: END IF ;
1553: IF p_debug_mode = 'Y' THEN
1554: pa_debug.g_err_stage:= 'Before calling CREATE_DLV_ACTIONS_IN_BULK ';
1555: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1556: END IF;
1557:
1558: -- If some thing is fetched call CREATE_DLV_ACTIONS_INBULK API
1559: IF nvl(l_name_tbl.LAST,0) > 0 THEN

Line 1622: pa_debug.g_err_stage:= 'The source element version id(deliverable)is :'|| l_source_object_ver_id;

1618: FETCH get_version_id INTO l_source_object_ver_id ;
1619: CLOSE get_version_id ;
1620:
1621: IF p_debug_mode = 'Y' THEN
1622: pa_debug.g_err_stage:= 'The source element version id(deliverable)is :'|| l_source_object_ver_id;
1623: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1624: END IF;
1625:
1626: --If something is fetched Call the Copy Action API of OKE

Line 1623: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

1619: CLOSE get_version_id ;
1620:
1621: IF p_debug_mode = 'Y' THEN
1622: pa_debug.g_err_stage:= 'The source element version id(deliverable)is :'|| l_source_object_ver_id;
1623: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1624: END IF;
1625:
1626: --If something is fetched Call the Copy Action API of OKE
1627: IF nvl(l_name_tbl.LAST,0)>0 THEN

Line 1630: pa_debug.g_err_stage:= 'Before calling OKE_DELIVERABLE_UTILS_PUB.Copy_Action ';

1626: --If something is fetched Call the Copy Action API of OKE
1627: IF nvl(l_name_tbl.LAST,0)>0 THEN
1628:
1629: IF p_debug_mode = 'Y' THEN
1630: pa_debug.g_err_stage:= 'Before calling OKE_DELIVERABLE_UTILS_PUB.Copy_Action ';
1631: pa_debug.write(g_module_name,pa_debug.g_err_stage,5) ;
1632: END IF;
1633:
1634: -- 3612702 : when deliverable actions are copied based on due date

Line 1631: pa_debug.write(g_module_name,pa_debug.g_err_stage,5) ;

1627: IF nvl(l_name_tbl.LAST,0)>0 THEN
1628:
1629: IF p_debug_mode = 'Y' THEN
1630: pa_debug.g_err_stage:= 'Before calling OKE_DELIVERABLE_UTILS_PUB.Copy_Action ';
1631: pa_debug.write(g_module_name,pa_debug.g_err_stage,5) ;
1632: END IF;
1633:
1634: -- 3612702 : when deliverable actions are copied based on due date
1635: -- defaulting logic dates should be populated,

Line 1659: pa_debug.g_err_stage:= 'After calling OKE_DELIVERABLE_UTILS_PUB.Copy_Action ';

1655:
1656: END LOOP ;
1657:
1658: IF p_debug_mode = 'Y' THEN
1659: pa_debug.g_err_stage:= 'After calling OKE_DELIVERABLE_UTILS_PUB.Copy_Action ';
1660: pa_debug.write(g_module_name,pa_debug.g_err_stage,5) ;
1661: END IF;
1662:
1663: END IF ;

Line 1660: pa_debug.write(g_module_name,pa_debug.g_err_stage,5) ;

1656: END LOOP ;
1657:
1658: IF p_debug_mode = 'Y' THEN
1659: pa_debug.g_err_stage:= 'After calling OKE_DELIVERABLE_UTILS_PUB.Copy_Action ';
1660: pa_debug.write(g_module_name,pa_debug.g_err_stage,5) ;
1661: END IF;
1662:
1663: END IF ;
1664:

Line 1691: pa_debug.g_err_stage:= 'The target element version id(deliverable)is :'|| l_object_version_id;

1687: FETCH get_version_id INTO l_object_version_id ;
1688: CLOSE get_version_id ;
1689:
1690: IF p_debug_mode = 'Y' THEN
1691: pa_debug.g_err_stage:= 'The target element version id(deliverable)is :'|| l_object_version_id;
1692: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1693: END IF;
1694:
1695: --If something is fetched Call the Default_Action API of OKE

Line 1692: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

1688: CLOSE get_version_id ;
1689:
1690: IF p_debug_mode = 'Y' THEN
1691: pa_debug.g_err_stage:= 'The target element version id(deliverable)is :'|| l_object_version_id;
1692: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1693: END IF;
1694:
1695: --If something is fetched Call the Default_Action API of OKE
1696:

Line 1700: pa_debug.g_err_stage:= 'Before calling OKE_DELIVERABLE_UTILS_PUB.Default_Action In Loop ';

1696:
1697: IF nvl(l_name_tbl.LAST,0)>0 THEN
1698:
1699: IF p_debug_mode = 'Y' THEN
1700: pa_debug.g_err_stage:= 'Before calling OKE_DELIVERABLE_UTILS_PUB.Default_Action In Loop ';
1701: pa_debug.write(g_module_name,pa_debug.g_err_stage,5) ;
1702: END IF;
1703:
1704: FOR i in l_name_tbl.FIRST..l_name_tbl.LAST LOOP

Line 1701: pa_debug.write(g_module_name,pa_debug.g_err_stage,5) ;

1697: IF nvl(l_name_tbl.LAST,0)>0 THEN
1698:
1699: IF p_debug_mode = 'Y' THEN
1700: pa_debug.g_err_stage:= 'Before calling OKE_DELIVERABLE_UTILS_PUB.Default_Action In Loop ';
1701: pa_debug.write(g_module_name,pa_debug.g_err_stage,5) ;
1702: END IF;
1703:
1704: FOR i in l_name_tbl.FIRST..l_name_tbl.LAST LOOP
1705:

Line 1735: pa_debug.g_err_stage:= 'After calling OKE_DELIVERABLE_UTILS_PUB.Default_Action In Loop';

1731:
1732: END LOOP ;
1733:
1734: IF p_debug_mode = 'Y' THEN
1735: pa_debug.g_err_stage:= 'After calling OKE_DELIVERABLE_UTILS_PUB.Default_Action In Loop';
1736: pa_debug.write(g_module_name,pa_debug.g_err_stage,5) ;
1737: END IF;
1738:
1739: END IF ;

Line 1736: pa_debug.write(g_module_name,pa_debug.g_err_stage,5) ;

1732: END LOOP ;
1733:
1734: IF p_debug_mode = 'Y' THEN
1735: pa_debug.g_err_stage:= 'After calling OKE_DELIVERABLE_UTILS_PUB.Default_Action In Loop';
1736: pa_debug.write(g_module_name,pa_debug.g_err_stage,5) ;
1737: END IF;
1738:
1739: END IF ;
1740: END IF;

Line 1749: pa_debug.g_err_stage := 'Exiting COPY_ACTIONS' ;

1745:
1746: -- 3911050 end
1747:
1748: IF p_debug_mode = 'Y' THEN
1749: pa_debug.g_err_stage := 'Exiting COPY_ACTIONS' ;
1750: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
1751: pa_debug.reset_curr_function;
1752: END IF;
1753:

Line 1750: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);

1746: -- 3911050 end
1747:
1748: IF p_debug_mode = 'Y' THEN
1749: pa_debug.g_err_stage := 'Exiting COPY_ACTIONS' ;
1750: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
1751: pa_debug.reset_curr_function;
1752: END IF;
1753:
1754: EXCEPTION

Line 1751: pa_debug.reset_curr_function;

1747:
1748: IF p_debug_mode = 'Y' THEN
1749: pa_debug.g_err_stage := 'Exiting COPY_ACTIONS' ;
1750: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
1751: pa_debug.reset_curr_function;
1752: END IF;
1753:
1754: EXCEPTION
1755: WHEN Invalid_Arg_Exc_Dlv THEN

Line 1759: pa_debug.g_err_stage := 'inside invalid arg exception of COPY_ACTIONS';

1755: WHEN Invalid_Arg_Exc_Dlv THEN
1756: x_return_status := FND_API.G_RET_STS_ERROR;
1757: l_msg_count := FND_MSG_PUB.count_msg;
1758: IF l_debug_mode = 'Y' THEN
1759: pa_debug.g_err_stage := 'inside invalid arg exception of COPY_ACTIONS';
1760: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
1761: END IF;
1762:
1763: IF l_msg_count = 1 THEN

Line 1760: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);

1756: x_return_status := FND_API.G_RET_STS_ERROR;
1757: l_msg_count := FND_MSG_PUB.count_msg;
1758: IF l_debug_mode = 'Y' THEN
1759: pa_debug.g_err_stage := 'inside invalid arg exception of COPY_ACTIONS';
1760: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
1761: END IF;
1762:
1763: IF l_msg_count = 1 THEN
1764: PA_INTERFACE_UTILS_PUB.get_messages

Line 1777: pa_debug.reset_curr_function;

1773: ELSE
1774: x_msg_count := l_msg_count;
1775: END IF;
1776: IF l_debug_mode = 'Y' THEN
1777: pa_debug.reset_curr_function;
1778: END IF ;
1779: RETURN;
1780: WHEN OTHERS THEN
1781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1792: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

1788:
1789: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_ACTIONS_PVT'
1790: ,p_procedure_name => 'COPY_ACTIONS');
1791: IF p_debug_mode = 'Y' THEN
1792: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
1793: pa_debug.write('COPY_ACTIONS: ' || g_module_name,pa_debug.g_err_stage,5);
1794: pa_debug.reset_curr_function;
1795: END IF;
1796: RAISE;

Line 1793: pa_debug.write('COPY_ACTIONS: ' || g_module_name,pa_debug.g_err_stage,5);

1789: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_ACTIONS_PVT'
1790: ,p_procedure_name => 'COPY_ACTIONS');
1791: IF p_debug_mode = 'Y' THEN
1792: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
1793: pa_debug.write('COPY_ACTIONS: ' || g_module_name,pa_debug.g_err_stage,5);
1794: pa_debug.reset_curr_function;
1795: END IF;
1796: RAISE;
1797: END COPY_ACTIONS;

Line 1794: pa_debug.reset_curr_function;

1790: ,p_procedure_name => 'COPY_ACTIONS');
1791: IF p_debug_mode = 'Y' THEN
1792: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
1793: pa_debug.write('COPY_ACTIONS: ' || g_module_name,pa_debug.g_err_stage,5);
1794: pa_debug.reset_curr_function;
1795: END IF;
1796: RAISE;
1797: END COPY_ACTIONS;
1798: END PA_ACTIONS_PVT;