DBA Data[Home] [Help]

APPS.PA_XC_PROJECT_PUB dependencies on FND_MSG_PUB

Line 428: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_XC_PROJECT_PUB',

424:
425: EXCEPTION
426: WHEN OTHERS THEN
427:
428: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_XC_PROJECT_PUB',
429: p_procedure_name => 'IMPORT_TASK',
430: p_error_text => SUBSTRB(SQLERRM,1,240)||' - stage '||l_stage);
431: raise;
432:

Line 755: -- fnd_msg_pub.add;

751: if l_check_proj_ver_id_csr%NOTFOUND then
752: -- fnd_message.set_name('PA', 'PA_INVLD_PROJ_VER_PR');
753: x_msg_count := x_msg_count + 1;
754: x_msg_data.extend(1);
755: -- fnd_msg_pub.add;
756: x_msg_data(x_msg_count) := fnd_message.get_string('PA', 'PA_INVLD_PROJ_VER_PR');
757: -- x_msg_data(x_msg_count) := fnd_message.get;
758: x_return_status := 'E';
759: raise API_ERROR;

Line 777: -- fnd_msg_pub.add;

773: CLOSE l_get_structure_count_csr;
774: -- fnd_message.set_name('PA', 'PA_NO_STRUCTURE_ID');
775: x_msg_count := x_msg_count + 1;
776: x_msg_data.extend(1);
777: -- fnd_msg_pub.add;
778: -- x_msg_data(x_msg_count) := fnd_message.get;
779: x_msg_data(x_msg_count) := fnd_message.get_string('PA', 'PA_NO_STRUCTURE_ID');
780: x_return_status := 'E';
781: raise API_ERROR;

Line 825: -- fnd_msg_pub.add;

821: elsif l_workplan_purpose = 'Y' then
822: -- fnd_message.set_name('PA', 'PA_NO_STRUCTURE_VER_ID');
823: x_msg_count := x_msg_count + 1;
824: x_msg_data.extend(1);
825: -- fnd_msg_pub.add;
826: -- x_msg_data(x_msg_count) := fnd_message.get;
827: x_msg_data(x_msg_count) := fnd_message.get_string('PA', 'PA_NO_STRUCTURE_VER_ID');
828: x_return_status := 'E';
829: raise API_ERROR;

Line 844: -- hyau fnd_msg_pub.add;

840: if l_get_struct_id_csr%NOTFOUND then
841: -- hyau fnd_message.set_name('PA', 'PA_NO_STRUCTURE_VER_ID');
842: x_msg_count := x_msg_count + 1;
843: x_msg_data.extend(1);
844: -- hyau fnd_msg_pub.add;
845: -- hyau x_msg_data(x_msg_count) := fnd_message.get;
846: x_msg_data(x_msg_count) := fnd_message.get_string('PA', 'PA_NO_STRUCTURE_VER_ID');
847: x_return_status := 'E';
848: raise API_ERROR;

Line 860: -- Other calling envs. rely on fnd_msg_pub.count_msg, for which we need to add msgs in stack

856:
857: IF (p_responsibility_id is NULL) OR (p_responsibility_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
858: -- Fix for Bug # 4513291. There was an old fix done thru Bug 2358887, do not put msgs in stack
859: -- This was wrong as the calling env. except MSP(I guess) does not look at the x_msg_data array.
860: -- Other calling envs. rely on fnd_msg_pub.count_msg, for which we need to add msgs in stack
861:
862: IF p_debug_mode = 'Y' THEN
863: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_responsibility_id is not specified', x_Log_Level=> 3);
864: END IF;

Line 871: fnd_msg_pub.add; -- Fix for Bug # 4513291. Uncommented and moved below.

867: x_msg_data.extend(1);
868: x_msg_data(x_msg_count) := fnd_message.get_string('PA', 'PA_FUNCTION_SECURITY_ENFORCED');
869: --added for bug 2192242
870: fnd_message.set_name('PA', 'PA_FUNCTION_SECURITY_ENFORCED'); -- Fix for Bug # 4513291. Uncommented and moved below.
871: fnd_msg_pub.add; -- Fix for Bug # 4513291. Uncommented and moved below.
872:
873: -- x_msg_data(x_msg_count) := fnd_message.get;
874: x_return_status := 'E';
875: raise API_ERROR;

Line 921: fnd_msg_pub.add; -- Fix for Bug # 4513291. Uncommented and moved below.

917: x_msg_data.extend(1);
918: x_msg_data(x_msg_count) := fnd_message.get_string('PA', 'PA_INVALID_PROJECT_ID');
919: --added for bug 2192242
920: fnd_message.set_name('PA', 'PA_INVALID_PROJECT_ID');-- Fix for Bug # 4513291. Uncommented and moved below.
921: fnd_msg_pub.add; -- Fix for Bug # 4513291. Uncommented and moved below.
922: -- x_msg_data(x_msg_count) := fnd_message.get;
923: x_msg_data(x_msg_count) := fnd_message.get_string('PA', 'PA_INVALID_PROJECT_ID');
924: x_return_status := 'E';
925: raise API_ERROR;

Line 948: fnd_msg_pub.add;

944: fnd_message.set_name('PA', 'PA_NO_PROJECT_ID');
945: x_msg_count := x_msg_count + 1;
946: x_msg_data.extend(1);
947: --added for bug 2192242
948: fnd_msg_pub.add;
949: -- x_msg_data(x_msg_count) := fnd_message.get;
950: x_msg_data(x_msg_count) := fnd_message.get_string('PA', 'PA_NO_PROJECT_ID');
951: x_return_status := 'E';
952:

Line 974: fnd_msg_pub.add;

970: FND_MESSAGE.Set_token('TASK',NULL);
971: x_msg_count := x_msg_count + 1;
972: x_msg_data.extend(1);
973: --added for bug 2192242
974: fnd_msg_pub.add;
975: x_msg_data(x_msg_count) := fnd_message.get;
976: x_return_status := 'E';
977:
978: raise API_ERROR;

Line 1069: fnd_msg_pub.add;

1065: fnd_message.set_name('PA', l_err_stage);
1066: x_msg_count := x_msg_count + 1;
1067: x_msg_data.extend(1);
1068: --added for bug 2192242
1069: fnd_msg_pub.add;
1070: x_msg_data(x_msg_count) := fnd_message.get;
1071: -- Sakthi
1072:
1073: raise API_ERROR;

Line 1180: p_msg_count := fnd_msg_pub.count_msg;

1176:
1177:
1178: EXCEPTION
1179: WHEN FND_API.G_EXC_ERROR THEN
1180: p_msg_count := fnd_msg_pub.count_msg;
1181: for i in 1..p_msg_count loop
1182: --dbms_output.put_line('INSIDE THE ERROR HANDLING PORTION ');
1183:
1184: if (p_debug_mode = 'Y') then

Line 1218: p_msg_count := fnd_msg_pub.count_msg;

1214: if (p_debug_mode = 'Y') then
1215: pa_debug.debug('Import-Project : Unhandled Expection ...');
1216: end if;
1217:
1218: p_msg_count := fnd_msg_pub.count_msg;
1219: for i in 1..p_msg_count loop
1220:
1221: if (p_debug_mode = 'Y') then
1222: pa_debug.debug('Import-Project : Inside Error Handling Program ...');

Line 1261: fnd_msg_pub.add;

1257: fnd_message.set_name('PA', 'PA_XC_NO_DATA_FOUND');
1258: x_msg_count := x_msg_count + 1;
1259: x_msg_data.extend(1);
1260: --added for bug 2192242
1261: fnd_msg_pub.add;
1262: x_msg_data(x_msg_count) := fnd_message.get;
1263: x_return_status := 'E';
1264:
1265: WHEN ROW_ALREADY_LOCKED THEN

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

1268: if (p_debug_mode = 'Y') then
1269: pa_debug.debug('Import-Project : Inside Row Already Locked Exception ...');
1270: end if;
1271:
1272: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1273: FND_MESSAGE.Set_Name('PA', 'PA_XC_ROW_ALREADY_LOCKED');
1274: FND_MESSAGE.Set_token('ENTITY', 'PA_PROJECTS_ALL');
1275: FND_MESSAGE.Set_token('PROJECT',to_char(P_PROJECT_ID));
1276: FND_MESSAGE.Set_token('TASK',NULL);

Line 1280: fnd_msg_pub.add;

1276: FND_MESSAGE.Set_token('TASK',NULL);
1277: x_msg_count := x_msg_count + 1;
1278: x_msg_data.extend(1);
1279: --added for bug 2192242
1280: fnd_msg_pub.add;
1281: x_msg_data(x_msg_count) := FND_MESSAGE.get;
1282: x_return_status := 'E';
1283: END IF;
1284:

Line 1348: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_XC_PROJECT_PUB'

1344:
1345: EXCEPTION --4537865
1346: WHEN OTHERS THEN
1347: x_task_id := NULL;
1348: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_XC_PROJECT_PUB'
1349: ,p_procedure_name => 'fetch_task_id'
1350: ,p_error_text => SUBSTRB(SQLERRM,1,240));
1351: RAISE;
1352: END fetch_task_id;

Line 1407: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_XC_PROJECT_PUB'

1403:
1404: EXCEPTION --4537865
1405: WHEN OTHERS THEN
1406: x_task_id := NULL;
1407: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_XC_PROJECT_PUB'
1408: ,p_procedure_name => 'fetch_proj_element_id'
1409: ,p_error_text => SUBSTRB(SQLERRM,1,240));
1410: RAISE;
1411: END fetch_proj_element_id;