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

516: p_debug_mode => l_debug_mode );
517: END IF;
518:
519: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
520: FND_MSG_PUB.initialize;
521: END IF;
522:
523: IF (p_commit = FND_API.G_TRUE) THEN
524: savepoint CREATE_MAPPING_PUBLIC;

Line 750: l_msg_count := Fnd_Msg_Pub.count_msg;

746:
747: WHEN FND_API.G_EXC_ERROR THEN
748:
749: x_return_status := Fnd_Api.G_RET_STS_ERROR;
750: l_msg_count := Fnd_Msg_Pub.count_msg;
751:
752: IF (p_commit = FND_API.G_TRUE) THEN
753: ROLLBACK TO CREATE_MAPPING_PUBLIC;
754: END IF;

Line 784: Fnd_Msg_Pub.add_exc_msg

780: IF (p_commit = FND_API.G_TRUE) THEN
781: ROLLBACK TO CREATE_MAPPING_PUBLIC;
782: END IF;
783:
784: Fnd_Msg_Pub.add_exc_msg
785: ( p_pkg_name => 'PA_PROJ_STRUC_MAPPING_PUB'
786: , p_procedure_name => 'CREATE_MAPPING'
787: , p_error_text => x_msg_data);
788:

Line 811: Fnd_Msg_Pub.add_exc_msg

807: Pa_Debug.g_err_stage:= 'x_msg_count='||x_msg_count;
808: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage, l_debug_level5);
809:
810:
811: Fnd_Msg_Pub.add_exc_msg
812: ( p_pkg_name => 'PA_PROJ_STRUC_MAPPING_PUB'
813: , p_procedure_name => 'CREATE_MAPPING'
814: , p_error_text => x_msg_data);
815: Pa_Debug.g_err_stage:= 'x_msg_count='||x_msg_count;

Line 967: FND_MSG_PUB.initialize;

963: p_debug_mode => l_debug_mode );
964: END IF;
965:
966: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
967: FND_MSG_PUB.initialize;
968: END IF;
969:
970: IF ( p_commit = FND_API.G_TRUE ) THEN
971: savepoint UPDATE_MAPPING_PUBLIC;

Line 1178: l_msg_count := Fnd_Msg_Pub.count_msg;

1174:
1175: WHEN FND_API.G_EXC_ERROR THEN
1176:
1177: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1178: l_msg_count := Fnd_Msg_Pub.count_msg;
1179:
1180: IF ( p_commit = FND_API.G_TRUE ) THEN
1181: ROLLBACK TO UPDATE_MAPPING_PUBLIC;
1182: END IF;

Line 1217: x_msg_count := Fnd_Msg_Pub.count_msg;

1213:
1214: WHEN Invalid_Arg_Exc_WP THEN
1215:
1216: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1217: x_msg_count := Fnd_Msg_Pub.count_msg;
1218: x_msg_data := 'PA_PROJ_STRUC_MAPPING_PUB : UPDATE_MAPPING : Some parameters are NULL';
1219:
1220: IF ( p_commit = FND_API.G_TRUE ) THEN
1221: ROLLBACK TO UPDATE_MAPPING_PUBLIC;

Line 1236: Fnd_Msg_Pub.add_exc_msg

1232: IF c_get_fp_task_ver_id_frm_name%ISOPEN THEN
1233: CLOSE c_get_fp_task_ver_id_frm_name;
1234: END IF;
1235:
1236: Fnd_Msg_Pub.add_exc_msg
1237: ( p_pkg_name => 'PA_PROJ_STRUC_MAPPING_PUB'
1238: , p_procedure_name => 'UPDATE_MAPPING'
1239: , p_error_text => x_msg_data);
1240:

Line 1271: Fnd_Msg_Pub.add_exc_msg

1267: IF c_get_wp_task_ver_id_frm_name%ISOPEN THEN
1268: CLOSE c_get_wp_task_ver_id_frm_name;
1269: END IF;
1270:
1271: Fnd_Msg_Pub.add_exc_msg
1272: ( p_pkg_name => 'PA_PROJ_STRUC_MAPPING_PUB'
1273: , p_procedure_name => 'UPDATE_MAPPING'
1274: , p_error_text => x_msg_data);
1275:

Line 1449: FND_MSG_PUB.initialize;

1445: Pa_Debug.WRITE(g_module_name,'p_dest_str_version_id'||p_dest_str_version_id,l_debug_level3);
1446: END IF;
1447:
1448: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
1449: FND_MSG_PUB.initialize;
1450: END IF;
1451:
1452: IF l_debug_mode = 'Y' THEN
1453: Pa_Debug.g_err_stage:= 'PA_PROJ_STRUC_MAPPING_PUB : COPY_MAPPING : Validating Input parameters';

Line 1706: l_msg_count := Fnd_Msg_Pub.count_msg;

1702:
1703: WHEN FND_API.G_EXC_ERROR THEN
1704:
1705: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1706: l_msg_count := Fnd_Msg_Pub.count_msg;
1707:
1708: IF l_msg_count = 1 AND x_msg_data IS NULL
1709: THEN
1710: Pa_Interface_Utils_Pub.get_messages

Line 1732: Fnd_Msg_Pub.add_exc_msg

1728: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1729: x_msg_count := 1;
1730: x_msg_data := 'PA_PROJ_STRUC_MAPPING_PUB : COPY_MAPPING : NULL PARAMETERS ARE PASSED OR CURSOR DIDNT RETURN ANY ROWS';
1731:
1732: Fnd_Msg_Pub.add_exc_msg
1733: ( p_pkg_name => 'PA_PROJ_STRUC_MAPPING_PUB'
1734: , p_procedure_name => 'COPY_MAPPING'
1735: , p_error_text => x_msg_data);
1736:

Line 1752: Fnd_Msg_Pub.add_exc_msg

1748: x_msg_count := 1;
1749: x_msg_data := SQLERRM;
1750:
1751:
1752: Fnd_Msg_Pub.add_exc_msg
1753: ( p_pkg_name => 'PA_PROJ_STRUC_MAPPING_PUB'
1754: , p_procedure_name => 'COPY_MAPPING'
1755: , p_error_text => x_msg_data);
1756:

Line 1864: FND_MSG_PUB.initialize;

1860: l_debug_level3);
1861: END IF;
1862:
1863: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
1864: FND_MSG_PUB.initialize;
1865: END IF;
1866:
1867: IF (p_commit = FND_API.G_TRUE) THEN
1868: savepoint DELETE_ALL_MAPPING_PUBLIC;

Line 1911: l_msg_count := Fnd_Msg_Pub.count_msg;

1907:
1908: WHEN FND_API.G_EXC_ERROR THEN
1909:
1910: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1911: l_msg_count := Fnd_Msg_Pub.count_msg;
1912:
1913: IF p_commit = FND_API.G_TRUE THEN
1914: ROLLBACK TO DELETE_ALL_MAPPING_PUBLIC;
1915: END IF;

Line 1949: Fnd_Msg_Pub.add_exc_msg

1945: END IF;
1946: IF c_get_fin_task_ver_id%ISOPEN THEN
1947: CLOSE c_get_fin_task_ver_id;
1948: END IF;
1949: Fnd_Msg_Pub.add_exc_msg
1950: ( p_pkg_name => 'PA_PROJ_STRUC_MAPPING_PUB'
1951: , p_procedure_name => 'DELETE_ALL_MAPPING'
1952: , p_error_text => x_msg_data);
1953:

Line 1976: Fnd_Msg_Pub.add_exc_msg

1972: IF c_get_fin_task_ver_id%ISOPEN THEN
1973: CLOSE c_get_fin_task_ver_id;
1974: END IF;
1975:
1976: Fnd_Msg_Pub.add_exc_msg
1977: ( p_pkg_name => 'PA_PROJ_STRUC_MAPPING_PUB'
1978: , p_procedure_name => 'DELETE_ALL_MAPPING'
1979: , p_error_text => x_msg_data);
1980: