DBA Data[Home] [Help]

APPS.PA_PROJ_TEMPLATE_SETUP_PVT dependencies on FND_MSG_PUB

Line 223: FND_MSG_PUB.initialize;

219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
220: END IF;
221:
222: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
223: FND_MSG_PUB.initialize;
224: END IF;
225:
226: --Check for not null
227: PA_PROJ_TEMPLATE_SETUP_UTILS.Check_Template_attr_req(

Line 808: x_msg_count := FND_MSG_PUB.count_msg;

804: END LOOP;
805: END;
806:
807: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
808: x_msg_count := FND_MSG_PUB.count_msg;
809: IF x_msg_count = 1 then
810: pa_interface_utils_pub.get_messages
811: (p_encoded => FND_API.G_TRUE,
812: p_msg_index => 1,

Line 866: x_msg_count := FND_MSG_PUB.count_msg;

862: END LOOP;
863: END;
864:
865: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
866: x_msg_count := FND_MSG_PUB.count_msg;
867: IF x_msg_count = 1 then
868: pa_interface_utils_pub.get_messages
869: (p_encoded => FND_API.G_TRUE,
870: p_msg_index => 1,

Line 1032: x_msg_count := FND_MSG_PUB.count_msg;

1028: ,x_msg_count => l_msg_count
1029: ,x_msg_data => l_msg_data );
1030:
1031: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1032: x_msg_count := FND_MSG_PUB.count_msg;
1033: IF x_msg_count = 1 then
1034: pa_interface_utils_pub.get_messages
1035: (p_encoded => FND_API.G_TRUE,
1036: p_msg_index => 1,

Line 1063: x_msg_count := FND_MSG_PUB.count_msg;

1059: ,x_return_status => l_return_status
1060: );
1061:
1062: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1063: x_msg_count := FND_MSG_PUB.count_msg;
1064: IF x_msg_count = 1 then
1065: pa_interface_utils_pub.get_messages
1066: (p_encoded => FND_API.G_TRUE,
1067: p_msg_index => 1,

Line 1087: x_msg_count := FND_MSG_PUB.count_msg;

1083: ,x_msg_data => l_msg_data
1084: ,x_return_status => l_return_status );
1085:
1086: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1087: x_msg_count := FND_MSG_PUB.count_msg;
1088: IF x_msg_count = 1 then
1089: pa_interface_utils_pub.get_messages
1090: (p_encoded => FND_API.G_TRUE,
1091: p_msg_index => 1,

Line 1121: x_msg_count := FND_MSG_PUB.count_msg;

1117: ,x_return_status => l_return_status
1118: );
1119:
1120: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1121: x_msg_count := FND_MSG_PUB.count_msg;
1122: IF x_msg_count = 1 then
1123: pa_interface_utils_pub.get_messages
1124: (p_encoded => FND_API.G_TRUE,
1125: p_msg_index => 1,

Line 1157: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',

1153: if p_commit = FND_API.G_TRUE then
1154: rollback to Create_Project_Template;
1155: end if;
1156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1157: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
1158: p_procedure_name => 'Create_Project_Template',
1159: p_error_text => SUBSTRB(SQLERRM,1,240));
1160: when OTHERS then
1161: if p_commit = FND_API.G_TRUE then

Line 1165: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',

1161: if p_commit = FND_API.G_TRUE then
1162: rollback to Create_Project_Template;
1163: end if;
1164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1165: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
1166: p_procedure_name => 'Create_Project_Template',
1167: p_error_text => SUBSTRB(SQLERRM,1,240));
1168: raise;
1169: END Create_Project_Template;

Line 1414: FND_MSG_PUB.initialize;

1410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1411: END IF;
1412:
1413: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
1414: FND_MSG_PUB.initialize;
1415: END IF;
1416:
1417: --check project type change
1418: OPEN cur_project;

Line 2127: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',

2123: if p_commit = FND_API.G_TRUE then
2124: rollback to Update_Project_Template;
2125: end if;
2126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2127: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
2128: p_procedure_name => 'Update_Project_Template',
2129: p_error_text => SUBSTRB(SQLERRM,1,240));
2130: when OTHERS then
2131: if p_commit = FND_API.G_TRUE then

Line 2135: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',

2131: if p_commit = FND_API.G_TRUE then
2132: rollback to Update_Project_Template;
2133: end if;
2134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2135: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
2136: p_procedure_name => 'Update_Project_Template',
2137: p_error_text => SUBSTRB(SQLERRM,1,240));
2138: raise;
2139: END Update_Project_Template;

Line 2197: FND_MSG_PUB.initialize;

2193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2194: END IF;
2195:
2196: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
2197: FND_MSG_PUB.initialize;
2198: END IF;
2199:
2200: --Bug 2947492: The following api call is modified to pass parameters by notation.
2201: Pa_Project_Core.Delete_Project (

Line 2236: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',

2232: if p_commit = FND_API.G_TRUE then
2233: rollback to Delete_Project_Template;
2234: end if;
2235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2236: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
2237: p_procedure_name => 'Delete_Project_Template',
2238: p_error_text => SUBSTRB(SQLERRM,1,240));
2239: when OTHERS then
2240: if p_commit = FND_API.G_TRUE then

Line 2244: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',

2240: if p_commit = FND_API.G_TRUE then
2241: rollback to Delete_Project_Template;
2242: end if;
2243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2244: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
2245: p_procedure_name => 'Delete_Project_Template',
2246: p_error_text => SUBSTRB(SQLERRM,1,240));
2247: raise;
2248: END Delete_Project_Template;

Line 2314: FND_MSG_PUB.initialize;

2310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2311: END IF;
2312:
2313: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
2314: FND_MSG_PUB.initialize;
2315: END IF;
2316:
2317: OPEN cur_chk_options;
2318: FETCH cur_chk_options INTO l_dummy_char;

Line 2369: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',

2365: if p_commit = FND_API.G_TRUE then
2366: rollback to Add_Project_Options;
2367: end if;
2368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2369: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
2370: p_procedure_name => 'Add_Project_Options',
2371: p_error_text => SUBSTRB(SQLERRM,1,240));
2372: when OTHERS then
2373: if p_commit = FND_API.G_TRUE then

Line 2377: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',

2373: if p_commit = FND_API.G_TRUE then
2374: rollback to Add_Project_Options;
2375: end if;
2376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2377: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
2378: p_procedure_name => 'Add_Project_Options',
2379: p_error_text => SUBSTRB(SQLERRM,1,240));
2380: raise;
2381: END Add_Project_Options;

Line 2458: FND_MSG_PUB.initialize;

2454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2455: END IF;
2456:
2457: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
2458: FND_MSG_PUB.initialize;
2459: END IF;
2460:
2461: --bug
2462:

Line 2521: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',

2517: if p_commit = FND_API.G_TRUE then
2518: rollback to Delete_Project_Options;
2519: end if;
2520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2521: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
2522: p_procedure_name => 'Delete_Project_Options',
2523: p_error_text => SUBSTRB(SQLERRM,1,240));
2524: when OTHERS then
2525: if p_commit = FND_API.G_TRUE then

Line 2529: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',

2525: if p_commit = FND_API.G_TRUE then
2526: rollback to Delete_Project_Options;
2527: end if;
2528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2529: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
2530: p_procedure_name => 'Delete_Project_Options',
2531: p_error_text => SUBSTRB(SQLERRM,1,240));
2532: raise;
2533: END Delete_Project_Options;

Line 2623: FND_MSG_PUB.initialize;

2619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2620: END IF;
2621:
2622: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
2623: FND_MSG_PUB.initialize;
2624: END IF;
2625:
2626: --check sort order unique
2627: OPEN cur_chk_sort_order;

Line 2821: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',

2817: if p_commit = FND_API.G_TRUE then
2818: rollback to Add_Quick_Entry_Field;
2819: end if;
2820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2821: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
2822: p_procedure_name => 'Add_Quick_Entry_Field',
2823: p_error_text => SUBSTRB(SQLERRM,1,240));
2824: when OTHERS then
2825: if p_commit = FND_API.G_TRUE then

Line 2829: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',

2825: if p_commit = FND_API.G_TRUE then
2826: rollback to Add_Quick_Entry_Field;
2827: end if;
2828: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2829: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
2830: p_procedure_name => 'Add_Quick_Entry_Field',
2831: p_error_text => SUBSTRB(SQLERRM,1,240));
2832: raise;
2833: END Add_Quick_Entry_Field;

Line 2916: FND_MSG_PUB.initialize;

2912: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2913: END IF;
2914:
2915: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
2916: FND_MSG_PUB.initialize;
2917: END IF;
2918:
2919: --cant update Project Number or Proejct Name
2920: IF ( p_FIELD_NAME = 'SEGMENT1' OR p_FIELD_NAME = 'NAME' ) AND

Line 3095: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',

3091: if p_commit = FND_API.G_TRUE then
3092: rollback to Update_Quick_Entry_Field;
3093: end if;
3094: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3095: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
3096: p_procedure_name => 'Update_Quick_Entry_Field',
3097: p_error_text => SUBSTRB(SQLERRM,1,240));
3098: when OTHERS then
3099: if p_commit = FND_API.G_TRUE then

Line 3103: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',

3099: if p_commit = FND_API.G_TRUE then
3100: rollback to Update_Quick_Entry_Field;
3101: end if;
3102: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3103: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
3104: p_procedure_name => 'Update_Quick_Entry_Field',
3105: p_error_text => SUBSTRB(SQLERRM,1,240));
3106: raise;
3107: END Update_Quick_Entry_Field;

Line 3177: FND_MSG_PUB.initialize;

3173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3174: END IF;
3175:
3176: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
3177: FND_MSG_PUB.initialize;
3178: END IF;
3179:
3180: OPEN cur_chk_dflt_qe;
3181: FETCH cur_chk_dflt_qe INTO l_field_name;

Line 3217: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',

3213: if p_commit = FND_API.G_TRUE then
3214: rollback to Delete_Quick_Entry_Field;
3215: end if;
3216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3217: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
3218: p_procedure_name => 'Delete_Quick_Entry_Field',
3219: p_error_text => SUBSTRB(SQLERRM,1,240));
3220: when OTHERS then
3221: if p_commit = FND_API.G_TRUE then

Line 3225: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',

3221: if p_commit = FND_API.G_TRUE then
3222: rollback to Delete_Quick_Entry_Field;
3223: end if;
3224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3225: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
3226: p_procedure_name => 'Delete_Quick_Entry_Field',
3227: p_error_text => SUBSTRB(SQLERRM,1,240));
3228: raise;
3229: END Delete_Quick_Entry_Field;