DBA Data[Home] [Help]

APPS.PA_PROJ_STRUC_MAPPING_PUB dependencies on FND_MSG_PUB

Line 122: FND_MSG_PUB.initialize;

118: l_debug_level3);
119: END IF;
120:
121: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
122: FND_MSG_PUB.initialize;
123: END IF;
124:
125: IF (p_commit = FND_API.G_TRUE) THEN
126: savepoint DELETE_MAPPING_PUBLIC;

Line 294: l_msg_count := Fnd_Msg_Pub.count_msg;

290:
291: WHEN FND_API.G_EXC_ERROR THEN
292:
293: x_return_status := Fnd_Api.G_RET_STS_ERROR;
294: l_msg_count := Fnd_Msg_Pub.count_msg;
295:
296: IF p_commit = FND_API.G_TRUE THEN
297: ROLLBACK TO DELETE_MAPPING_PUBLIC;
298: END IF;

Line 351: Fnd_Msg_Pub.add_exc_msg

347: IF c_get_mapping_frm_wp_fp_task%ISOPEN THEN
348: CLOSE c_get_mapping_frm_wp_fp_task;
349: END IF;
350:
351: Fnd_Msg_Pub.add_exc_msg
352: ( p_pkg_name => 'PA_PROJ_STRUC_MAPPING_PUB'
353: , p_procedure_name => 'DELETE_MAPPING'
354: , p_error_text => x_msg_data);
355:

Line 386: Fnd_Msg_Pub.add_exc_msg

382: IF c_get_mapping_frm_wp_fp_task%ISOPEN THEN
383: CLOSE c_get_mapping_frm_wp_fp_task;
384: END IF;
385:
386: Fnd_Msg_Pub.add_exc_msg
387: ( p_pkg_name => 'PA_PROJ_STRUC_MAPPING_PUB'
388: , p_procedure_name => 'DELETE_MAPPING'
389: , p_error_text => x_msg_data);
390:

Line 514: FND_MSG_PUB.initialize;

510: p_debug_mode => l_debug_mode );
511: END IF;
512:
513: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
514: FND_MSG_PUB.initialize;
515: END IF;
516:
517: IF (p_commit = FND_API.G_TRUE) THEN
518: savepoint CREATE_MAPPING_PUBLIC;

Line 719: l_msg_count := Fnd_Msg_Pub.count_msg;

715:
716: WHEN FND_API.G_EXC_ERROR THEN
717:
718: x_return_status := Fnd_Api.G_RET_STS_ERROR;
719: l_msg_count := Fnd_Msg_Pub.count_msg;
720:
721: IF (p_commit = FND_API.G_TRUE) THEN
722: ROLLBACK TO CREATE_MAPPING_PUBLIC;
723: END IF;

Line 753: Fnd_Msg_Pub.add_exc_msg

749: IF (p_commit = FND_API.G_TRUE) THEN
750: ROLLBACK TO CREATE_MAPPING_PUBLIC;
751: END IF;
752:
753: Fnd_Msg_Pub.add_exc_msg
754: ( p_pkg_name => 'PA_PROJ_STRUC_MAPPING_PUB'
755: , p_procedure_name => 'CREATE_MAPPING'
756: , p_error_text => x_msg_data);
757:

Line 780: Fnd_Msg_Pub.add_exc_msg

776: Pa_Debug.g_err_stage:= 'x_msg_count='||x_msg_count;
777: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage, l_debug_level5);
778:
779:
780: Fnd_Msg_Pub.add_exc_msg
781: ( p_pkg_name => 'PA_PROJ_STRUC_MAPPING_PUB'
782: , p_procedure_name => 'CREATE_MAPPING'
783: , p_error_text => x_msg_data);
784: Pa_Debug.g_err_stage:= 'x_msg_count='||x_msg_count;

Line 935: FND_MSG_PUB.initialize;

931: p_debug_mode => l_debug_mode );
932: END IF;
933:
934: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
935: FND_MSG_PUB.initialize;
936: END IF;
937:
938: IF ( p_commit = FND_API.G_TRUE ) THEN
939: savepoint UPDATE_MAPPING_PUBLIC;

Line 1140: l_msg_count := Fnd_Msg_Pub.count_msg;

1136:
1137: WHEN FND_API.G_EXC_ERROR THEN
1138:
1139: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1140: l_msg_count := Fnd_Msg_Pub.count_msg;
1141:
1142: IF ( p_commit = FND_API.G_TRUE ) THEN
1143: ROLLBACK TO UPDATE_MAPPING_PUBLIC;
1144: END IF;

Line 1179: x_msg_count := Fnd_Msg_Pub.count_msg;

1175:
1176: WHEN Invalid_Arg_Exc_WP THEN
1177:
1178: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1179: x_msg_count := Fnd_Msg_Pub.count_msg;
1180: x_msg_data := 'PA_PROJ_STRUC_MAPPING_PUB : UPDATE_MAPPING : Some parameters are NULL';
1181:
1182: IF ( p_commit = FND_API.G_TRUE ) THEN
1183: ROLLBACK TO UPDATE_MAPPING_PUBLIC;

Line 1198: Fnd_Msg_Pub.add_exc_msg

1194: IF c_get_fp_task_ver_id_frm_name%ISOPEN THEN
1195: CLOSE c_get_fp_task_ver_id_frm_name;
1196: END IF;
1197:
1198: Fnd_Msg_Pub.add_exc_msg
1199: ( p_pkg_name => 'PA_PROJ_STRUC_MAPPING_PUB'
1200: , p_procedure_name => 'UPDATE_MAPPING'
1201: , p_error_text => x_msg_data);
1202:

Line 1233: Fnd_Msg_Pub.add_exc_msg

1229: IF c_get_wp_task_ver_id_frm_name%ISOPEN THEN
1230: CLOSE c_get_wp_task_ver_id_frm_name;
1231: END IF;
1232:
1233: Fnd_Msg_Pub.add_exc_msg
1234: ( p_pkg_name => 'PA_PROJ_STRUC_MAPPING_PUB'
1235: , p_procedure_name => 'UPDATE_MAPPING'
1236: , p_error_text => x_msg_data);
1237:

Line 1411: FND_MSG_PUB.initialize;

1407: Pa_Debug.WRITE(g_module_name,'p_dest_str_version_id'||p_dest_str_version_id,l_debug_level3);
1408: END IF;
1409:
1410: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
1411: FND_MSG_PUB.initialize;
1412: END IF;
1413:
1414: IF l_debug_mode = 'Y' THEN
1415: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : COPY_MAPPING : Validating Input parameters';

Line 1668: l_msg_count := Fnd_Msg_Pub.count_msg;

1664:
1665: WHEN FND_API.G_EXC_ERROR THEN
1666:
1667: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1668: l_msg_count := Fnd_Msg_Pub.count_msg;
1669:
1670: IF l_msg_count = 1 AND x_msg_data IS NULL
1671: THEN
1672: Pa_Interface_Utils_Pub.get_messages

Line 1694: Fnd_Msg_Pub.add_exc_msg

1690: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1691: x_msg_count := 1;
1692: x_msg_data := 'PA_PROJ_STRUC_MAPPING_PUB : COPY_MAPPING : NULL PARAMETERS ARE PASSED OR CURSOR DIDNT RETURN ANY ROWS';
1693:
1694: Fnd_Msg_Pub.add_exc_msg
1695: ( p_pkg_name => 'PA_PROJ_STRUC_MAPPING_PUB'
1696: , p_procedure_name => 'COPY_MAPPING'
1697: , p_error_text => x_msg_data);
1698:

Line 1714: Fnd_Msg_Pub.add_exc_msg

1710: x_msg_count := 1;
1711: x_msg_data := SQLERRM;
1712:
1713:
1714: Fnd_Msg_Pub.add_exc_msg
1715: ( p_pkg_name => 'PA_PROJ_STRUC_MAPPING_PUB'
1716: , p_procedure_name => 'COPY_MAPPING'
1717: , p_error_text => x_msg_data);
1718:

Line 1826: FND_MSG_PUB.initialize;

1822: l_debug_level3);
1823: END IF;
1824:
1825: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
1826: FND_MSG_PUB.initialize;
1827: END IF;
1828:
1829: IF (p_commit = FND_API.G_TRUE) THEN
1830: savepoint DELETE_ALL_MAPPING_PUBLIC;

Line 1873: l_msg_count := Fnd_Msg_Pub.count_msg;

1869:
1870: WHEN FND_API.G_EXC_ERROR THEN
1871:
1872: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1873: l_msg_count := Fnd_Msg_Pub.count_msg;
1874:
1875: IF p_commit = FND_API.G_TRUE THEN
1876: ROLLBACK TO DELETE_ALL_MAPPING_PUBLIC;
1877: END IF;

Line 1911: Fnd_Msg_Pub.add_exc_msg

1907: END IF;
1908: IF c_get_fin_task_ver_id%ISOPEN THEN
1909: CLOSE c_get_fin_task_ver_id;
1910: END IF;
1911: Fnd_Msg_Pub.add_exc_msg
1912: ( p_pkg_name => 'PA_PROJ_STRUC_MAPPING_PUB'
1913: , p_procedure_name => 'DELETE_ALL_MAPPING'
1914: , p_error_text => x_msg_data);
1915:

Line 1938: Fnd_Msg_Pub.add_exc_msg

1934: IF c_get_fin_task_ver_id%ISOPEN THEN
1935: CLOSE c_get_fin_task_ver_id;
1936: END IF;
1937:
1938: Fnd_Msg_Pub.add_exc_msg
1939: ( p_pkg_name => 'PA_PROJ_STRUC_MAPPING_PUB'
1940: , p_procedure_name => 'DELETE_ALL_MAPPING'
1941: , p_error_text => x_msg_data);
1942: