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 803: x_msg_count := FND_MSG_PUB.count_msg;

799: END LOOP;
800: END;
801:
802: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
803: x_msg_count := FND_MSG_PUB.count_msg;
804: IF x_msg_count = 1 then
805: pa_interface_utils_pub.get_messages
806: (p_encoded => FND_API.G_TRUE,
807: p_msg_index => 1,

Line 861: x_msg_count := FND_MSG_PUB.count_msg;

857: END LOOP;
858: END;
859:
860: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
861: x_msg_count := FND_MSG_PUB.count_msg;
862: IF x_msg_count = 1 then
863: pa_interface_utils_pub.get_messages
864: (p_encoded => FND_API.G_TRUE,
865: p_msg_index => 1,

Line 1027: x_msg_count := FND_MSG_PUB.count_msg;

1023: ,x_msg_count => l_msg_count
1024: ,x_msg_data => l_msg_data );
1025:
1026: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1027: x_msg_count := FND_MSG_PUB.count_msg;
1028: IF x_msg_count = 1 then
1029: pa_interface_utils_pub.get_messages
1030: (p_encoded => FND_API.G_TRUE,
1031: p_msg_index => 1,

Line 1058: x_msg_count := FND_MSG_PUB.count_msg;

1054: ,x_return_status => l_return_status
1055: );
1056:
1057: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1058: x_msg_count := FND_MSG_PUB.count_msg;
1059: IF x_msg_count = 1 then
1060: pa_interface_utils_pub.get_messages
1061: (p_encoded => FND_API.G_TRUE,
1062: p_msg_index => 1,

Line 1082: x_msg_count := FND_MSG_PUB.count_msg;

1078: ,x_msg_data => l_msg_data
1079: ,x_return_status => l_return_status );
1080:
1081: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1082: x_msg_count := FND_MSG_PUB.count_msg;
1083: IF x_msg_count = 1 then
1084: pa_interface_utils_pub.get_messages
1085: (p_encoded => FND_API.G_TRUE,
1086: p_msg_index => 1,

Line 1116: x_msg_count := FND_MSG_PUB.count_msg;

1112: ,x_return_status => l_return_status
1113: );
1114:
1115: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1116: x_msg_count := FND_MSG_PUB.count_msg;
1117: IF x_msg_count = 1 then
1118: pa_interface_utils_pub.get_messages
1119: (p_encoded => FND_API.G_TRUE,
1120: p_msg_index => 1,

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

1148: if p_commit = FND_API.G_TRUE then
1149: rollback to Create_Project_Template;
1150: end if;
1151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1152: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
1153: p_procedure_name => 'Create_Project_Template',
1154: p_error_text => SUBSTRB(SQLERRM,1,240));
1155: when OTHERS then
1156: if p_commit = FND_API.G_TRUE then

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

1156: if p_commit = FND_API.G_TRUE then
1157: rollback to Create_Project_Template;
1158: end if;
1159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1160: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
1161: p_procedure_name => 'Create_Project_Template',
1162: p_error_text => SUBSTRB(SQLERRM,1,240));
1163: raise;
1164: END Create_Project_Template;

Line 1409: FND_MSG_PUB.initialize;

1405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1406: END IF;
1407:
1408: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
1409: FND_MSG_PUB.initialize;
1410: END IF;
1411:
1412: --check project type change
1413: OPEN cur_project;

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

2118: if p_commit = FND_API.G_TRUE then
2119: rollback to Update_Project_Template;
2120: end if;
2121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2122: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
2123: p_procedure_name => 'Update_Project_Template',
2124: p_error_text => SUBSTRB(SQLERRM,1,240));
2125: when OTHERS then
2126: if p_commit = FND_API.G_TRUE then

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

2126: if p_commit = FND_API.G_TRUE then
2127: rollback to Update_Project_Template;
2128: end if;
2129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2130: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
2131: p_procedure_name => 'Update_Project_Template',
2132: p_error_text => SUBSTRB(SQLERRM,1,240));
2133: raise;
2134: END Update_Project_Template;

Line 2192: FND_MSG_PUB.initialize;

2188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2189: END IF;
2190:
2191: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
2192: FND_MSG_PUB.initialize;
2193: END IF;
2194:
2195: --Bug 2947492: The following api call is modified to pass parameters by notation.
2196: Pa_Project_Core.Delete_Project (

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

2227: if p_commit = FND_API.G_TRUE then
2228: rollback to Delete_Project_Template;
2229: end if;
2230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2231: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
2232: p_procedure_name => 'Delete_Project_Template',
2233: p_error_text => SUBSTRB(SQLERRM,1,240));
2234: when OTHERS then
2235: if p_commit = FND_API.G_TRUE then

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

2235: if p_commit = FND_API.G_TRUE then
2236: rollback to Delete_Project_Template;
2237: end if;
2238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2239: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
2240: p_procedure_name => 'Delete_Project_Template',
2241: p_error_text => SUBSTRB(SQLERRM,1,240));
2242: raise;
2243: END Delete_Project_Template;

Line 2309: FND_MSG_PUB.initialize;

2305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2306: END IF;
2307:
2308: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
2309: FND_MSG_PUB.initialize;
2310: END IF;
2311:
2312: OPEN cur_chk_options;
2313: FETCH cur_chk_options INTO l_dummy_char;

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

2360: if p_commit = FND_API.G_TRUE then
2361: rollback to Add_Project_Options;
2362: end if;
2363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2364: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
2365: p_procedure_name => 'Add_Project_Options',
2366: p_error_text => SUBSTRB(SQLERRM,1,240));
2367: when OTHERS then
2368: if p_commit = FND_API.G_TRUE then

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

2368: if p_commit = FND_API.G_TRUE then
2369: rollback to Add_Project_Options;
2370: end if;
2371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2372: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
2373: p_procedure_name => 'Add_Project_Options',
2374: p_error_text => SUBSTRB(SQLERRM,1,240));
2375: raise;
2376: END Add_Project_Options;

Line 2453: FND_MSG_PUB.initialize;

2449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2450: END IF;
2451:
2452: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
2453: FND_MSG_PUB.initialize;
2454: END IF;
2455:
2456: --bug
2457:

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

2512: if p_commit = FND_API.G_TRUE then
2513: rollback to Delete_Project_Options;
2514: end if;
2515: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2516: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
2517: p_procedure_name => 'Delete_Project_Options',
2518: p_error_text => SUBSTRB(SQLERRM,1,240));
2519: when OTHERS then
2520: if p_commit = FND_API.G_TRUE then

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

2520: if p_commit = FND_API.G_TRUE then
2521: rollback to Delete_Project_Options;
2522: end if;
2523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2524: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
2525: p_procedure_name => 'Delete_Project_Options',
2526: p_error_text => SUBSTRB(SQLERRM,1,240));
2527: raise;
2528: END Delete_Project_Options;

Line 2618: FND_MSG_PUB.initialize;

2614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2615: END IF;
2616:
2617: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
2618: FND_MSG_PUB.initialize;
2619: END IF;
2620:
2621: --check sort order unique
2622: OPEN cur_chk_sort_order;

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

2812: if p_commit = FND_API.G_TRUE then
2813: rollback to Add_Quick_Entry_Field;
2814: end if;
2815: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2816: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
2817: p_procedure_name => 'Add_Quick_Entry_Field',
2818: p_error_text => SUBSTRB(SQLERRM,1,240));
2819: when OTHERS then
2820: if p_commit = FND_API.G_TRUE then

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

2820: if p_commit = FND_API.G_TRUE then
2821: rollback to Add_Quick_Entry_Field;
2822: end if;
2823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2824: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
2825: p_procedure_name => 'Add_Quick_Entry_Field',
2826: p_error_text => SUBSTRB(SQLERRM,1,240));
2827: raise;
2828: END Add_Quick_Entry_Field;

Line 2911: FND_MSG_PUB.initialize;

2907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2908: END IF;
2909:
2910: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
2911: FND_MSG_PUB.initialize;
2912: END IF;
2913:
2914: --cant update Project Number or Proejct Name
2915: IF ( p_FIELD_NAME = 'SEGMENT1' OR p_FIELD_NAME = 'NAME' ) AND

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

3086: if p_commit = FND_API.G_TRUE then
3087: rollback to Update_Quick_Entry_Field;
3088: end if;
3089: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3090: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
3091: p_procedure_name => 'Update_Quick_Entry_Field',
3092: p_error_text => SUBSTRB(SQLERRM,1,240));
3093: when OTHERS then
3094: if p_commit = FND_API.G_TRUE then

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

3094: if p_commit = FND_API.G_TRUE then
3095: rollback to Update_Quick_Entry_Field;
3096: end if;
3097: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3098: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
3099: p_procedure_name => 'Update_Quick_Entry_Field',
3100: p_error_text => SUBSTRB(SQLERRM,1,240));
3101: raise;
3102: END Update_Quick_Entry_Field;

Line 3172: FND_MSG_PUB.initialize;

3168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3169: END IF;
3170:
3171: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
3172: FND_MSG_PUB.initialize;
3173: END IF;
3174:
3175: OPEN cur_chk_dflt_qe;
3176: FETCH cur_chk_dflt_qe INTO l_field_name;

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

3208: if p_commit = FND_API.G_TRUE then
3209: rollback to Delete_Quick_Entry_Field;
3210: end if;
3211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3212: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
3213: p_procedure_name => 'Delete_Quick_Entry_Field',
3214: p_error_text => SUBSTRB(SQLERRM,1,240));
3215: when OTHERS then
3216: if p_commit = FND_API.G_TRUE then

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

3216: if p_commit = FND_API.G_TRUE then
3217: rollback to Delete_Quick_Entry_Field;
3218: end if;
3219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3220: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
3221: p_procedure_name => 'Delete_Quick_Entry_Field',
3222: p_error_text => SUBSTRB(SQLERRM,1,240));
3223: raise;
3224: END Delete_Quick_Entry_Field;