DBA Data[Home] [Help]

APPS.PA_XC_PROJECT_PUB dependencies on FND_MSG_PUB

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

413:
414: EXCEPTION
415: WHEN OTHERS THEN
416:
417: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_XC_PROJECT_PUB',
418: p_procedure_name => 'IMPORT_TASK',
419: p_error_text => SUBSTRB(SQLERRM,1,240)||' - stage '||l_stage);
420: raise;
421:

Line 744: -- fnd_msg_pub.add;

740: if l_check_proj_ver_id_csr%NOTFOUND then
741: -- fnd_message.set_name('PA', 'PA_INVLD_PROJ_VER_PR');
742: x_msg_count := x_msg_count + 1;
743: x_msg_data.extend(1);
744: -- fnd_msg_pub.add;
745: x_msg_data(x_msg_count) := fnd_message.get_string('PA', 'PA_INVLD_PROJ_VER_PR');
746: -- x_msg_data(x_msg_count) := fnd_message.get;
747: x_return_status := 'E';
748: raise API_ERROR;

Line 766: -- fnd_msg_pub.add;

762: CLOSE l_get_structure_count_csr;
763: -- fnd_message.set_name('PA', 'PA_NO_STRUCTURE_ID');
764: x_msg_count := x_msg_count + 1;
765: x_msg_data.extend(1);
766: -- fnd_msg_pub.add;
767: -- x_msg_data(x_msg_count) := fnd_message.get;
768: x_msg_data(x_msg_count) := fnd_message.get_string('PA', 'PA_NO_STRUCTURE_ID');
769: x_return_status := 'E';
770: raise API_ERROR;

Line 814: -- fnd_msg_pub.add;

810: elsif l_workplan_purpose = 'Y' then
811: -- fnd_message.set_name('PA', 'PA_NO_STRUCTURE_VER_ID');
812: x_msg_count := x_msg_count + 1;
813: x_msg_data.extend(1);
814: -- fnd_msg_pub.add;
815: -- x_msg_data(x_msg_count) := fnd_message.get;
816: x_msg_data(x_msg_count) := fnd_message.get_string('PA', 'PA_NO_STRUCTURE_VER_ID');
817: x_return_status := 'E';
818: raise API_ERROR;

Line 833: -- hyau fnd_msg_pub.add;

829: if l_get_struct_id_csr%NOTFOUND then
830: -- hyau fnd_message.set_name('PA', 'PA_NO_STRUCTURE_VER_ID');
831: x_msg_count := x_msg_count + 1;
832: x_msg_data.extend(1);
833: -- hyau fnd_msg_pub.add;
834: -- hyau x_msg_data(x_msg_count) := fnd_message.get;
835: x_msg_data(x_msg_count) := fnd_message.get_string('PA', 'PA_NO_STRUCTURE_VER_ID');
836: x_return_status := 'E';
837: raise API_ERROR;

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

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

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

856: x_msg_data.extend(1);
857: x_msg_data(x_msg_count) := fnd_message.get_string('PA', 'PA_FUNCTION_SECURITY_ENFORCED');
858: --added for bug 2192242
859: fnd_message.set_name('PA', 'PA_FUNCTION_SECURITY_ENFORCED'); -- Fix for Bug # 4513291. Uncommented and moved below.
860: fnd_msg_pub.add; -- Fix for Bug # 4513291. Uncommented and moved below.
861:
862: -- x_msg_data(x_msg_count) := fnd_message.get;
863: x_return_status := 'E';
864: raise API_ERROR;

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

906: x_msg_data.extend(1);
907: x_msg_data(x_msg_count) := fnd_message.get_string('PA', 'PA_INVALID_PROJECT_ID');
908: --added for bug 2192242
909: fnd_message.set_name('PA', 'PA_INVALID_PROJECT_ID');-- Fix for Bug # 4513291. Uncommented and moved below.
910: fnd_msg_pub.add; -- Fix for Bug # 4513291. Uncommented and moved below.
911: -- x_msg_data(x_msg_count) := fnd_message.get;
912: x_msg_data(x_msg_count) := fnd_message.get_string('PA', 'PA_INVALID_PROJECT_ID');
913: x_return_status := 'E';
914: raise API_ERROR;

Line 937: fnd_msg_pub.add;

933: fnd_message.set_name('PA', 'PA_NO_PROJECT_ID');
934: x_msg_count := x_msg_count + 1;
935: x_msg_data.extend(1);
936: --added for bug 2192242
937: fnd_msg_pub.add;
938: -- x_msg_data(x_msg_count) := fnd_message.get;
939: x_msg_data(x_msg_count) := fnd_message.get_string('PA', 'PA_NO_PROJECT_ID');
940: x_return_status := 'E';
941:

Line 963: fnd_msg_pub.add;

959: FND_MESSAGE.Set_token('TASK',NULL);
960: x_msg_count := x_msg_count + 1;
961: x_msg_data.extend(1);
962: --added for bug 2192242
963: fnd_msg_pub.add;
964: x_msg_data(x_msg_count) := fnd_message.get;
965: x_return_status := 'E';
966:
967: raise API_ERROR;

Line 1058: fnd_msg_pub.add;

1054: fnd_message.set_name('PA', l_err_stage);
1055: x_msg_count := x_msg_count + 1;
1056: x_msg_data.extend(1);
1057: --added for bug 2192242
1058: fnd_msg_pub.add;
1059: x_msg_data(x_msg_count) := fnd_message.get;
1060: -- Sakthi
1061:
1062: raise API_ERROR;

Line 1169: p_msg_count := fnd_msg_pub.count_msg;

1165:
1166:
1167: EXCEPTION
1168: WHEN FND_API.G_EXC_ERROR THEN
1169: p_msg_count := fnd_msg_pub.count_msg;
1170: for i in 1..p_msg_count loop
1171: --dbms_output.put_line('INSIDE THE ERROR HANDLING PORTION ');
1172:
1173: if (p_debug_mode = 'Y') then

Line 1207: p_msg_count := fnd_msg_pub.count_msg;

1203: if (p_debug_mode = 'Y') then
1204: pa_debug.debug('Import-Project : Unhandled Expection ...');
1205: end if;
1206:
1207: p_msg_count := fnd_msg_pub.count_msg;
1208: for i in 1..p_msg_count loop
1209:
1210: if (p_debug_mode = 'Y') then
1211: pa_debug.debug('Import-Project : Inside Error Handling Program ...');

Line 1250: fnd_msg_pub.add;

1246: fnd_message.set_name('PA', 'PA_XC_NO_DATA_FOUND');
1247: x_msg_count := x_msg_count + 1;
1248: x_msg_data.extend(1);
1249: --added for bug 2192242
1250: fnd_msg_pub.add;
1251: x_msg_data(x_msg_count) := fnd_message.get;
1252: x_return_status := 'E';
1253:
1254: WHEN ROW_ALREADY_LOCKED THEN

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

1257: if (p_debug_mode = 'Y') then
1258: pa_debug.debug('Import-Project : Inside Row Already Locked Exception ...');
1259: end if;
1260:
1261: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1262: FND_MESSAGE.Set_Name('PA', 'PA_XC_ROW_ALREADY_LOCKED');
1263: FND_MESSAGE.Set_token('ENTITY', 'PA_PROJECTS_ALL');
1264: FND_MESSAGE.Set_token('PROJECT',to_char(P_PROJECT_ID));
1265: FND_MESSAGE.Set_token('TASK',NULL);

Line 1269: fnd_msg_pub.add;

1265: FND_MESSAGE.Set_token('TASK',NULL);
1266: x_msg_count := x_msg_count + 1;
1267: x_msg_data.extend(1);
1268: --added for bug 2192242
1269: fnd_msg_pub.add;
1270: x_msg_data(x_msg_count) := FND_MESSAGE.get;
1271: x_return_status := 'E';
1272: END IF;
1273:

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

1333:
1334: EXCEPTION --4537865
1335: WHEN OTHERS THEN
1336: x_task_id := NULL;
1337: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_XC_PROJECT_PUB'
1338: ,p_procedure_name => 'fetch_task_id'
1339: ,p_error_text => SUBSTRB(SQLERRM,1,240));
1340: RAISE;
1341: END fetch_task_id;

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

1392:
1393: EXCEPTION --4537865
1394: WHEN OTHERS THEN
1395: x_task_id := NULL;
1396: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_XC_PROJECT_PUB'
1397: ,p_procedure_name => 'fetch_proj_element_id'
1398: ,p_error_text => SUBSTRB(SQLERRM,1,240));
1399: RAISE;
1400: END fetch_proj_element_id;