DBA Data[Home] [Help]

APPS.PA_DELIVERABLE_PUB dependencies on PA_DELIVERABLE_PUB

Line 1: PACKAGE BODY PA_DELIVERABLE_PUB AS

1: PACKAGE BODY PA_DELIVERABLE_PUB AS
2: /* $Header: PADLVPUB.pls 120.2.12010000.2 2008/11/12 15:33:17 rthumma ship $ */
3:
4: g_module_name VARCHAR2(100) := 'PA_DELIVERABLE_PUB';
5: Invalid_Arg_Exc_Dlv EXCEPTION ;

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

1: PACKAGE BODY PA_DELIVERABLE_PUB AS
2: /* $Header: PADLVPUB.pls 120.2.12010000.2 2008/11/12 15:33:17 rthumma ship $ */
3:
4: g_module_name VARCHAR2(100) := 'PA_DELIVERABLE_PUB';
5: Invalid_Arg_Exc_Dlv EXCEPTION ;
6:
7: Invalid_Arg_Exc_WP Exception;
8:

Line 743: x_msg_data := 'PA_DELIVERABLE_PUB : Create_Deliverable : NULL PARAMETERS ARE PASSED OR CURSOR DIDNT RETURN ANY ROWS';

739: WHEN Invalid_Arg_Exc_WP THEN
740:
741: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
742: x_msg_count := 1;
743: x_msg_data := 'PA_DELIVERABLE_PUB : Create_Deliverable : NULL PARAMETERS ARE PASSED OR CURSOR DIDNT RETURN ANY ROWS';
744:
745: IF p_commit = FND_API.G_TRUE THEN
746: ROLLBACK TO CREATE_DLVR_PUB;
747: END IF;

Line 750: ( p_pkg_name => 'PA_DELIVERABLE_PUB'

746: ROLLBACK TO CREATE_DLVR_PUB;
747: END IF;
748:
749: Fnd_Msg_Pub.add_exc_msg
750: ( p_pkg_name => 'PA_DELIVERABLE_PUB'
751: , p_procedure_name => 'Create_Deliverable'
752: , p_error_text => x_msg_data);
753:
754: IF l_debug_mode = 'Y' THEN

Line 773: ( p_pkg_name => 'PA_DELIVERABLE_PUB'

769: ROLLBACK TO CREATE_DLVR_PUB;
770: END IF;
771:
772: Fnd_Msg_Pub.add_exc_msg
773: ( p_pkg_name => 'PA_DELIVERABLE_PUB'
774: , p_procedure_name => 'Create_Deliverable'
775: , p_error_text => x_msg_data);
776:
777: IF l_debug_mode = 'Y' THEN

Line 1446: x_msg_data := 'PA_DELIVERABLE_PUB : Update_Deliverable : NULL PARAMETERS ARE PASSED OR CURSOR DIDNT RETURN ANY ROWS';

1442: WHEN Invalid_Arg_Exc_WP THEN
1443:
1444: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1445: x_msg_count := 1;
1446: x_msg_data := 'PA_DELIVERABLE_PUB : Update_Deliverable : NULL PARAMETERS ARE PASSED OR CURSOR DIDNT RETURN ANY ROWS';
1447:
1448: IF p_commit = FND_API.G_TRUE THEN
1449: ROLLBACK TO UPDATE_DLVR_PUB;
1450: END IF;

Line 1453: ( p_pkg_name => 'PA_DELIVERABLE_PUB'

1449: ROLLBACK TO UPDATE_DLVR_PUB;
1450: END IF;
1451:
1452: Fnd_Msg_Pub.add_exc_msg
1453: ( p_pkg_name => 'PA_DELIVERABLE_PUB'
1454: , p_procedure_name => 'Update_Deliverable'
1455: , p_error_text => x_msg_data);
1456:
1457: IF l_debug_mode = 'Y' THEN

Line 1476: ( p_pkg_name => 'PA_DELIVERABLE_PUB'

1472: ROLLBACK TO UPDATE_DLVR_PUB;
1473: END IF;
1474:
1475: Fnd_Msg_Pub.add_exc_msg
1476: ( p_pkg_name => 'PA_DELIVERABLE_PUB'
1477: , p_procedure_name => 'Update_Deliverable'
1478: , p_error_text => x_msg_data);
1479:
1480: IF l_debug_mode = 'Y' THEN

Line 1869: ( p_pkg_name => 'PA_DELIVERABLE_PUB'

1865: x_msg_data := SQLERRM;
1866: ROLLBACK TO DELETE_DELIVERABLES;
1867:
1868: FND_MSG_PUB.add_exc_msg
1869: ( p_pkg_name => 'PA_DELIVERABLE_PUB'
1870: ,p_procedure_name => 'DELETE_DELIVERABLES_IN_BULK' );
1871: IF l_debug_mode = 'Y' THEN
1872: pa_debug.write('DELETE_DELIVERABLES_IN_BULK' || g_module_name,SQLERRM,4);
1873: pa_debug.write('DELETE_DELIVERABLES_IN_BULK' || g_module_name,pa_debug.G_Err_Stack,4);

Line 2213: ( p_pkg_name => 'PA_DELIVERABLE_PUB'

2209: ROLLBACK TO DELETE_DELIVERABLE_STRUCTURE;
2210: END IF ;
2211:
2212: FND_MSG_PUB.add_exc_msg
2213: ( p_pkg_name => 'PA_DELIVERABLE_PUB'
2214: ,p_procedure_name => 'DELETE_DELIVERABLE_STRUCTURE' );
2215: IF l_debug_mode = 'Y' THEN
2216: pa_debug.write('DELETE_DELIVERABLE_STRUCTURE' || g_module_name,SQLERRM,4);
2217: pa_debug.write('DELETE_DELIVERABLE_STRUCTURE' || g_module_name,pa_debug.G_Err_Stack,4);

Line 2625: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_DELIVERABLE_PUB'

2621: IF (p_commit = FND_API.G_TRUE) THEN
2622: ROLLBACK TO COPY_DELIVERABLES_SP ;
2623: END IF ;
2624:
2625: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_DELIVERABLE_PUB'
2626: ,p_procedure_name => 'COPY_DELIVERABLES');
2627:
2628: IF p_debug_mode = 'Y' THEN
2629: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 2748: PA_DELIVERABLE_PUB.CREATE_ASSOCIATIONS_IN_BULK

2744: OPEN c_get_element_id(p_dest_task_versions_tab(i));
2745: FETCH c_get_element_id INTO l_task_element_id,l_project_id ;
2746: CLOSE c_get_element_id ;
2747:
2748: PA_DELIVERABLE_PUB.CREATE_ASSOCIATIONS_IN_BULK
2749: (p_element_id_tbl => l_element_id_tbl
2750: ,p_version_id_tbl => l_version_id_tbl
2751: ,p_element_name_tbl => l_element_name_tbl
2752: ,p_element_number_tbl => l_element_number_tbl

Line 2812: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_DELIVERABLE_PUB'

2808: IF (p_commit = FND_API.G_TRUE) THEN
2809: ROLLBACK TO COPY_ASSOCIATIONS_SP ;
2810: END IF ;
2811:
2812: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_DELIVERABLE_PUB'
2813: ,p_procedure_name => 'COPY_ASSOCIATIONS');
2814:
2815: IF p_debug_mode = 'Y' THEN
2816: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 2823: END PA_DELIVERABLE_PUB;

2819: END IF;
2820: RAISE;
2821: END COPY_ASSOCIATIONS ;
2822:
2823: END PA_DELIVERABLE_PUB;