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),'Y') = 'Y' THEN /* changes done for bug 8890368 */
1173: l_err_message := 'PA_BILLING_ACTION_DEL_ERR' ; /* reverted the flag to 'Y' from 'N' in above for bug 9278197 */
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),'Y') = 'Y' THEN /* changes done for bug 8890368 */
1173: l_err_message := 'PA_BILLING_ACTION_DEL_ERR' ; /* reverted the flag to 'Y' from 'N' in above for bug 9278197 */
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 1445: PA_DEBUG.set_curr_function( p_function => 'COPY_ACTIONS'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1752: pa_debug.reset_curr_function;

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

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

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

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

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

Line 1778: pa_debug.reset_curr_function;

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

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

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

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

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

Line 1795: pa_debug.reset_curr_function;

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