DBA Data[Home] [Help]

APPS.PA_DELIVERABLE_PVT dependencies on FND_MSG_PUB

Line 553: l_msg_count := Fnd_Msg_Pub.count_msg;

549: EXCEPTION
550:
551: WHEN FND_API.G_EXC_ERROR THEN
552: x_return_status := Fnd_Api.G_RET_STS_ERROR;
553: l_msg_count := Fnd_Msg_Pub.count_msg;
554:
555: IF p_commit = FND_API.G_TRUE THEN
556: ROLLBACK TO CREATE_DLVR_PVT;
557: END IF;

Line 587: Fnd_Msg_Pub.add_exc_msg

583: IF p_commit = FND_API.G_TRUE THEN
584: ROLLBACK TO CREATE_DLVR_PVT;
585: END IF;
586:
587: Fnd_Msg_Pub.add_exc_msg
588: ( p_pkg_name => 'PA_DELIVERABLE_PVT'
589: , p_procedure_name => 'Create_Deliverable'
590: , p_error_text => x_msg_data);
591:

Line 1524: l_msg_count := Fnd_Msg_Pub.count_msg;

1520: EXCEPTION
1521:
1522: WHEN FND_API.G_EXC_ERROR THEN
1523: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1524: l_msg_count := Fnd_Msg_Pub.count_msg;
1525:
1526: IF l_row_id_ppe_csr%ISOPEN THEN
1527: CLOSE l_row_id_ppe_csr;
1528: END IF;

Line 1598: Fnd_Msg_Pub.add_exc_msg

1594: IF p_commit = FND_API.G_TRUE THEN
1595: ROLLBACK TO UPDATE_DLVR_PVT;
1596: END IF;
1597:
1598: Fnd_Msg_Pub.add_exc_msg
1599: ( p_pkg_name => 'PA_DELIVERABLE_PVT'
1600: , p_procedure_name => 'Update_Deliverable'
1601: , p_error_text => x_msg_data);
1602:

Line 1694: FND_MSG_PUB.initialize;

1690: pa_debug.write(g_module_name,'p_project_id'||':'||p_project_id,3) ;
1691: END IF;
1692:
1693: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
1694: FND_MSG_PUB.initialize;
1695: END IF;
1696:
1697: IF (p_commit = FND_API.G_TRUE) THEN
1698: savepoint DELETE_DELIVERABLE_SP ;

Line 1970: l_msg_count := FND_MSG_PUB.count_msg;

1966:
1967: EXCEPTION
1968: WHEN Invalid_Arg_Exc_Dlv THEN
1969: x_return_status := FND_API.G_RET_STS_ERROR;
1970: l_msg_count := FND_MSG_PUB.count_msg;
1971:
1972: IF p_commit = FND_API.G_TRUE THEN
1973: ROLLBACK TO DELETE_DELIVERABLE_SP;
1974: END IF;

Line 2001: l_msg_count := Fnd_Msg_Pub.count_msg;

1997: RETURN;
1998:
1999: WHEN FND_API.G_EXC_ERROR THEN
2000: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2001: l_msg_count := Fnd_Msg_Pub.count_msg;
2002:
2003: IF p_commit = FND_API.G_TRUE THEN
2004: ROLLBACK TO DELETE_DELIVERABLE_SP;
2005: END IF;

Line 2036: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_DELIVERABLES_PVT'

2032: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2033: x_msg_count := 1;
2034: x_msg_data := SQLERRM;
2035:
2036: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_DELIVERABLES_PVT'
2037: ,p_procedure_name => 'DELETE_DELIVERABLE');
2038:
2039: IF p_debug_mode = 'Y' THEN
2040: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 2117: FND_MSG_PUB.initialize;

2113: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2114: END IF;
2115:
2116: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
2117: FND_MSG_PUB.initialize;
2118: END IF;
2119:
2120: IF (p_commit = FND_API.G_TRUE) THEN
2121: savepoint DEL_DLV_TASK_ASSOCIATION_SP ;

Line 2227: l_msg_count := FND_MSG_PUB.count_msg;

2223:
2224: EXCEPTION
2225: WHEN Invalid_Arg_Exc_Dlv THEN
2226: x_return_status := FND_API.G_RET_STS_ERROR;
2227: l_msg_count := FND_MSG_PUB.count_msg;
2228:
2229: IF (p_commit = FND_API.G_TRUE) THEN
2230: ROLLBACK TO DEL_DLV_TASK_ASSOCIATION_SP;
2231: END IF ;

Line 2264: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_DELIVERABLES_PVT'

2260: IF (p_commit = FND_API.G_TRUE) THEN
2261: ROLLBACK TO DEL_DLV_TASK_ASSOCIATION_SP;
2262: END IF ;
2263:
2264: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_DELIVERABLES_PVT'
2265: ,p_procedure_name => 'DELETE_DLV_TASK_ASSOCIATION');
2266:
2267: IF p_debug_mode = 'Y' THEN
2268: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 2334: FND_MSG_PUB.initialize;

2330: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2331: END IF;
2332:
2333: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
2334: FND_MSG_PUB.initialize;
2335: END IF;
2336:
2337:
2338: IF p_task_element_id IS NOT NULL THEN

Line 2388: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_DELIVERABLES_PUB'

2384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2385: x_msg_count := 1;
2386: x_msg_data := SQLERRM;
2387:
2388: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_DELIVERABLES_PUB'
2389: ,p_procedure_name => 'IS_DISASSOCIATION_ALLOWED');
2390:
2391: IF p_debug_mode = 'Y' THEN
2392: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 2468: FND_MSG_PUB.initialize;

2464: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2465: END IF;
2466:
2467: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
2468: FND_MSG_PUB.initialize;
2469: END IF;
2470:
2471: -- Perform following validation
2472:

Line 2558: x_msg_count := FND_MSG_PUB.count_msg ;

2554: END IF ;
2555: END IF ;
2556: END IF ;
2557:
2558: x_msg_count := FND_MSG_PUB.count_msg ;
2559:
2560: IF x_msg_count > 0 THEN
2561: RAISE Invalid_Arg_Exc_Dlv ;
2562: END IF ;

Line 2609: l_msg_count := FND_MSG_PUB.count_msg;

2605:
2606: EXCEPTION
2607: WHEN Invalid_Arg_Exc_Dlv THEN
2608: x_return_status := FND_API.G_RET_STS_ERROR;
2609: l_msg_count := FND_MSG_PUB.count_msg;
2610: IF p_debug_mode = 'Y' THEN
2611: pa_debug.g_err_stage := 'inside invalid arg exception of CREATE_ASSOCIATIONS_IN_BULK';
2612: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
2613: END IF;

Line 2636: FND_MSG_PUB.add_exc_msg

2632: WHEN OTHERS THEN
2633: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2634: x_msg_count := 1;
2635: x_msg_data := SQLERRM;
2636: FND_MSG_PUB.add_exc_msg
2637: ( p_pkg_name => 'PA_DELIVERABLE_PVT'
2638: ,p_procedure_name => 'CREATE_ASSOCIATIONS_IN_BULK' );
2639: IF p_debug_mode = 'Y' THEN
2640: pa_debug.write('CREATE_ASSOCIATIONS_IN_BULK' || g_module_name,SQLERRM,4);

Line 2726: FND_MSG_PUB.initialize;

2722: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2723: END IF;
2724:
2725: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
2726: FND_MSG_PUB.initialize;
2727: END IF;
2728:
2729: IF (p_commit = FND_API.G_TRUE) THEN
2730: SAVEPOINT CREATE_DLV_TASK_ASSOCIATION_SP ;

Line 2866: l_msg_count := FND_MSG_PUB.count_msg;

2862: END IF ;
2863: EXCEPTION
2864: WHEN Invalid_Arg_Exc_Dlv THEN
2865: x_return_status := FND_API.G_RET_STS_ERROR;
2866: l_msg_count := FND_MSG_PUB.count_msg;
2867:
2868: IF (p_commit = FND_API.G_TRUE) THEN
2869: ROLLBACK TO CREATE_DLV_TASK_ASSOCIATION_SP;
2870: END IF ;

Line 2903: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_DELIVERABLES_VT'

2899: IF (p_commit = FND_API.G_TRUE) THEN
2900: ROLLBACK TO CREATE_DLV_TASK_ASSOCIATION_SP;
2901: END IF ;
2902:
2903: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_DELIVERABLES_VT'
2904: ,p_procedure_name => 'CREATE_DLV_TASK_ASSOCIATION');
2905:
2906: IF p_debug_mode = 'Y' THEN
2907: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 2958: FND_MSG_PUB.initialize;

2954: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2955: END IF;
2956:
2957: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
2958: FND_MSG_PUB.initialize;
2959: END IF;
2960:
2961: -- Validate mandatory input parameter
2962: PA_DELIVERABLE_UTILS.CHECK_DLVR_DISABLE_ALLOWED

Line 3108: l_msg_count := FND_MSG_PUB.count_msg;

3104:
3105: EXCEPTION
3106: WHEN Invalid_Arg_Exc_Dlv THEN
3107: x_return_status := FND_API.G_RET_STS_ERROR;
3108: l_msg_count := FND_MSG_PUB.count_msg;
3109:
3110: IF p_debug_mode = 'Y' THEN
3111: pa_debug.g_err_stage := 'inside invalid arg exception of DELETE_DELIVERABLE_STRUCTURE';
3112: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);

Line 3137: FND_MSG_PUB.add_exc_msg

3133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3134: x_msg_count := 1;
3135: x_msg_data := SQLERRM;
3136:
3137: FND_MSG_PUB.add_exc_msg
3138: ( p_pkg_name => 'PA_DELIVERABLE_PVT'
3139: ,p_procedure_name => 'DELETE_DELIVERABLE_STRUCTURE' );
3140: IF p_debug_mode = 'Y' THEN
3141: pa_debug.write('DELETE_DELIVERABLE_STRUCTURE' || g_module_name,SQLERRM,4);

Line 3269: FND_MSG_PUB.initialize;

3265: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3266: END IF;
3267:
3268: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
3269: FND_MSG_PUB.initialize;
3270: END IF;
3271:
3272: IF p_debug_mode = 'Y' THEN
3273: pa_debug.g_err_stage:= 'Opening cursor ';

Line 3341: l_msg_count := FND_MSG_PUB.count_msg;

3337:
3338: EXCEPTION
3339: WHEN Invalid_Arg_Exc_Dlv THEN
3340: x_return_status := FND_API.G_RET_STS_ERROR;
3341: l_msg_count := FND_MSG_PUB.count_msg;
3342:
3343: IF p_debug_mode = 'Y' THEN
3344: pa_debug.g_err_stage := 'inside invalid arg exception of DELETE_DLV_TASK_ASSCN_IN_BULK';
3345: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);

Line 3370: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_DELIVERABLES_PVT'

3366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3367: x_msg_count := 1;
3368: x_msg_data := SQLERRM;
3369:
3370: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_DELIVERABLES_PVT'
3371: ,p_procedure_name => 'DELETE_DLV_TASK_ASSCN_IN_BULK');
3372:
3373: IF p_debug_mode = 'Y' THEN
3374: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 3504: FND_MSG_PUB.initialize;

3500: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3501: END IF;
3502:
3503: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
3504: FND_MSG_PUB.initialize;
3505: END IF;
3506:
3507: /* Commented for Bug 3906015 : Incorrect Check was being performed
3508: -- Validate mandatory input parameter

Line 3555: l_msg_count := FND_MSG_PUB.count_msg;

3551:
3552: EXCEPTION
3553: WHEN Invalid_Arg_Exc_Dlv THEN
3554: x_return_status := FND_API.G_RET_STS_ERROR;
3555: l_msg_count := FND_MSG_PUB.count_msg;
3556:
3557: IF p_debug_mode = 'Y' THEN
3558: pa_debug.g_err_stage := 'inside invalid arg exception of DELETE_DLV_ASSOCIATIONS';
3559: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);

Line 3584: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_DELIVERABLES_PVT'

3580: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3581: x_msg_count := 1;
3582: x_msg_data := SQLERRM;
3583:
3584: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_DELIVERABLES_PVT'
3585: ,p_procedure_name => 'DELETE_DLV_ASSOCIATIONS');
3586:
3587: IF p_debug_mode = 'Y' THEN
3588: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 3912: FND_MSG_PUB.initialize;

3908: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
3909: END IF;
3910:
3911: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
3912: FND_MSG_PUB.initialize;
3913: END IF;
3914:
3915: IF p_calling_context = 'COPY_PROJECT' THEN
3916:

Line 4792: l_msg_count := FND_MSG_PUB.count_msg;

4788:
4789: EXCEPTION
4790: WHEN Invalid_Arg_Exc_Dlv THEN
4791: x_return_status := FND_API.G_RET_STS_ERROR;
4792: l_msg_count := FND_MSG_PUB.count_msg;
4793:
4794: IF l_debug_mode = 'Y' THEN
4795: pa_debug.g_err_stage := 'inside invalid arg exception of COPY_DELIVERABLES';
4796: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);

Line 4821: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_DELIVERABLES_PVT'

4817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4818: x_msg_count := 1;
4819: x_msg_data := SQLERRM;
4820:
4821: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_DELIVERABLES_PVT'
4822: ,p_procedure_name => 'COPY_DELIVERABLES');
4823:
4824: IF p_debug_mode = 'Y' THEN
4825: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;