DBA Data[Home] [Help]

APPS.PA_DELIVERABLE_PUB dependencies on FND_MSG_PUB

Line 275: FND_MSG_PUB.initialize;

271: l_debug_level3);
272: END IF;
273:
274: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
275: FND_MSG_PUB.initialize;
276: END IF;
277:
278: IF (p_commit = FND_API.G_TRUE) THEN
279: savepoint CREATE_DLVR_PUB;

Line 483: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

479: -- if is_dlvr_number_unique is 'N' return with error
480:
481: IF (is_dlvr_number_unique = 'N' ) THEN
482: IF (p_calling_module = 'AMG') THEN
483: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
484:
485: l_err_message := FND_MESSAGE.GET_STRING('PA','DLVR_NUMBER_DUPLICATE') ;
486: PA_UTILS.ADD_MESSAGE
487: (p_app_short_name => 'PA',

Line 715: l_msg_count := Fnd_Msg_Pub.count_msg;

711:
712: WHEN FND_API.G_EXC_ERROR THEN
713:
714: x_return_status := Fnd_Api.G_RET_STS_ERROR;
715: l_msg_count := Fnd_Msg_Pub.count_msg;
716:
717: IF p_commit = FND_API.G_TRUE THEN
718: ROLLBACK TO CREATE_DLVR_PUB;
719: END IF;

Line 749: Fnd_Msg_Pub.add_exc_msg

745: IF p_commit = FND_API.G_TRUE THEN
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:

Line 772: Fnd_Msg_Pub.add_exc_msg

768: IF p_commit = FND_API.G_TRUE THEN
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:

Line 1019: FND_MSG_PUB.initialize;

1015: l_debug_level3);
1016: END IF;
1017:
1018: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
1019: FND_MSG_PUB.initialize;
1020: END IF;
1021:
1022: IF (p_commit = FND_API.G_TRUE) THEN
1023: savepoint UPDATE_DLVR_PUB;

Line 1418: l_msg_count := Fnd_Msg_Pub.count_msg;

1414:
1415: WHEN FND_API.G_EXC_ERROR THEN
1416:
1417: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1418: l_msg_count := Fnd_Msg_Pub.count_msg;
1419:
1420: IF p_commit = FND_API.G_TRUE THEN
1421: ROLLBACK TO UPDATE_DLVR_PUB;
1422: END IF;

Line 1452: Fnd_Msg_Pub.add_exc_msg

1448: IF p_commit = FND_API.G_TRUE THEN
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:

Line 1475: Fnd_Msg_Pub.add_exc_msg

1471: IF p_commit = FND_API.G_TRUE THEN
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:

Line 1572: FND_MSG_PUB.initialize;

1568: pa_debug.write(g_module_name,'p_object_relationship_id'||':'||p_object_relationship_id,3) ;
1569: END IF;
1570:
1571: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
1572: FND_MSG_PUB.initialize;
1573: END IF;
1574:
1575: IF (p_commit = FND_API.G_TRUE) THEN
1576: savepoint DEL_DLV_TASK_ASSCN_PUB_SP ;

Line 1639: l_msg_count := FND_MSG_PUB.count_msg;

1635:
1636: EXCEPTION
1637: WHEN Invalid_Arg_Exc_Dlv THEN
1638: x_return_status := FND_API.G_RET_STS_ERROR;
1639: l_msg_count := FND_MSG_PUB.count_msg;
1640:
1641: IF (p_commit = FND_API.G_TRUE) THEN
1642: ROLLBACK TO DEL_DLV_TASK_ASSCN_PUB_SP;
1643: END IF ;

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

1672: IF (p_commit = FND_API.G_TRUE) THEN
1673: ROLLBACK TO DEL_DLV_TASK_ASSCN_PUB_SP;
1674: END IF ;
1675:
1676: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_DELIVERABLES_PUB'
1677: ,p_procedure_name => 'DELETE_DLV_TASK_ASSOCIATION');
1678:
1679: IF p_debug_mode = 'Y' THEN
1680: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 1767: FND_MSG_PUB.initialize;

1763: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1764: END IF;
1765:
1766: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
1767: FND_MSG_PUB.initialize;
1768: END IF;
1769:
1770: SAVEPOINT DELETE_DELIVERABLES ;
1771:

Line 1831: FND_MSG_PUB.initialize;

1827: IF j > 0 THEN
1828:
1829: ROLLBACK TO DELETE_DELIVERABLES;
1830:
1831: FND_MSG_PUB.initialize;
1832:
1833: FOR k IN l_element_name_tbl.FIRST..l_element_name_tbl.LAST LOOP
1834:
1835: PA_UTILS.ADD_MESSAGE

Line 1851: x_msg_count := FND_MSG_PUB.count_msg ;

1847: END LOOP ;
1848: END IF ;
1849: END IF ;
1850:
1851: x_msg_count := FND_MSG_PUB.count_msg ;
1852:
1853: IF x_msg_count > 0 THEN
1854: x_return_status := 'E' ;
1855: END IF ;

Line 1868: FND_MSG_PUB.add_exc_msg

1864: x_msg_count := 1;
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);

Line 1967: FND_MSG_PUB.initialize;

1963: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
1964: END IF;
1965:
1966: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
1967: FND_MSG_PUB.initialize;
1968: END IF;
1969:
1970: IF (p_commit = FND_API.G_TRUE) THEN
1971: SAVEPOINT CREATE_ASSOCIATIONS_SP ;

Line 2022: l_msg_count := FND_MSG_PUB.count_msg;

2018:
2019: EXCEPTION
2020: WHEN Invalid_Arg_Exc_Dlv THEN
2021: x_return_status := FND_API.G_RET_STS_ERROR;
2022: l_msg_count := FND_MSG_PUB.count_msg;
2023:
2024: IF (p_commit = FND_API.G_TRUE) THEN
2025: ROLLBACK TO CREATE_ASSOCIATIONS_SP;
2026: END IF ;

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

2055: IF (p_commit = FND_API.G_TRUE) THEN
2056: ROLLBACK TO CREATE_ASSOCIATIONS_SP;
2057: END IF ;
2058:
2059: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_DELIVERABLES_PUB'
2060: ,p_procedure_name => 'CREATE_ASSOCIATIONS_IN_BULK');
2061:
2062: IF p_debug_mode = 'Y' THEN
2063: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 2130: FND_MSG_PUB.initialize;

2126: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2127: END IF;
2128:
2129: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
2130: FND_MSG_PUB.initialize;
2131: END IF;
2132:
2133: IF (p_commit = FND_API.G_TRUE) THEN
2134: SAVEPOINT DELETE_DELIVERABLE_STRUCTURE;

Line 2175: l_msg_count := FND_MSG_PUB.count_msg;

2171: END IF ;
2172: EXCEPTION
2173: WHEN Invalid_Arg_Exc_Dlv THEN
2174: x_return_status := FND_API.G_RET_STS_ERROR;
2175: l_msg_count := FND_MSG_PUB.count_msg;
2176:
2177: IF (p_commit = FND_API.G_TRUE) THEN
2178: ROLLBACK TO DELETE_DELIVERABLE_STRUCTURE;
2179: END IF ;

Line 2212: FND_MSG_PUB.add_exc_msg

2208: IF (p_commit = FND_API.G_TRUE) THEN
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);

Line 2263: FND_MSG_PUB.initialize;

2259: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2260: END IF;
2261:
2262: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
2263: FND_MSG_PUB.initialize;
2264: END IF;
2265:
2266: IF (p_commit = FND_API.G_TRUE) THEN
2267: ROLLBACK TO DELETE_DLV_TASK_ASSCN_IN_BULK ;

Line 2317: l_msg_count := FND_MSG_PUB.count_msg;

2313:
2314: EXCEPTION
2315: WHEN Invalid_Arg_Exc_Dlv THEN
2316: x_return_status := FND_API.G_RET_STS_ERROR;
2317: l_msg_count := FND_MSG_PUB.count_msg;
2318:
2319: IF l_debug_mode = 'Y' THEN
2320: pa_debug.g_err_stage := 'inside invalid arg exception of DELETE_DLV_TASK_ASSCN_IN_BULK';
2321: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);

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

2350: IF (p_commit = FND_API.G_TRUE) THEN
2351: ROLLBACK TO DELETE_DLV_TASK_ASSCN_IN_BULK ;
2352: END IF ;
2353:
2354: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_DELIVERABLES_PVT'
2355: ,p_procedure_name => 'DELETE_DLV_TASK_ASSCN_IN_BULK');
2356:
2357: IF p_debug_mode = 'Y' THEN
2358: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 2402: FND_MSG_PUB.initialize;

2398: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2399: END IF;
2400:
2401: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
2402: FND_MSG_PUB.initialize;
2403: END IF;
2404:
2405: IF (p_project_id IS NULL )
2406: THEN

Line 2451: l_msg_count := FND_MSG_PUB.count_msg;

2447:
2448: EXCEPTION
2449: WHEN Invalid_Arg_Exc_Dlv THEN
2450: x_return_status := FND_API.G_RET_STS_ERROR;
2451: l_msg_count := FND_MSG_PUB.count_msg;
2452:
2453: IF l_debug_mode = 'Y' THEN
2454: pa_debug.g_err_stage := 'inside invalid arg exception of DELETE_DLV_ASSOCIATIONS';
2455: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);

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

2476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2477: x_msg_count := 1;
2478: x_msg_data := SQLERRM;
2479:
2480: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_DELIVERABLES_PVT'
2481: ,p_procedure_name => 'DELETE_DLV_ASSOCIATIONS');
2482:
2483: IF p_debug_mode = 'Y' THEN
2484: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 2538: FND_MSG_PUB.initialize;

2534: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2535: END IF;
2536:
2537: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
2538: FND_MSG_PUB.initialize;
2539: END IF;
2540: IF (p_commit = FND_API.G_TRUE) THEN
2541: SAVEPOINT COPY_DELIVERABLES_SP ;
2542: END IF ;

Line 2588: l_msg_count := FND_MSG_PUB.count_msg;

2584: END IF ;
2585: EXCEPTION
2586: WHEN Invalid_Arg_Exc_Dlv THEN
2587: x_return_status := FND_API.G_RET_STS_ERROR;
2588: l_msg_count := FND_MSG_PUB.count_msg;
2589:
2590: IF (p_commit = FND_API.G_TRUE) THEN
2591: ROLLBACK TO COPY_DELIVERABLES_SP ;
2592: END IF ;

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 2714: FND_MSG_PUB.initialize;

2710: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
2711: END IF;
2712:
2713: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
2714: FND_MSG_PUB.initialize;
2715: END IF;
2716:
2717: IF (p_commit = FND_API.G_TRUE) THEN
2718: SAVEPOINT COPY_ASSOCIATIONS_SP ;

Line 2775: l_msg_count := FND_MSG_PUB.count_msg;

2771:
2772: EXCEPTION
2773: WHEN Invalid_Arg_Exc_Dlv THEN
2774: x_return_status := FND_API.G_RET_STS_ERROR;
2775: l_msg_count := FND_MSG_PUB.count_msg;
2776:
2777: IF (p_commit = FND_API.G_TRUE) THEN
2778: ROLLBACK TO COPY_ASSOCIATIONS_SP ;
2779: END IF ;

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;