eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_MANAGE_PLAN_PARTITIONS dependencies on FND_MESSAGE

Line 140: fnd_message.set_name('MSC','MSC_PART_UNDEFINED_SCHEMA');

136: -- get fnd schema name
137: --
138: if (FND_INSTALLATION.GET_APP_INFO('FND',dummy1,dummy2,l_applsys_schema) = FALSE) then
139: x_return_status := FND_API.G_RET_STS_ERROR;
140: fnd_message.set_name('MSC','MSC_PART_UNDEFINED_SCHEMA');
141: x_msg_data := fnd_message.get;
142: return;
143: end if;
144:

Line 141: x_msg_data := fnd_message.get;

137: --
138: if (FND_INSTALLATION.GET_APP_INFO('FND',dummy1,dummy2,l_applsys_schema) = FALSE) then
139: x_return_status := FND_API.G_RET_STS_ERROR;
140: fnd_message.set_name('MSC','MSC_PART_UNDEFINED_SCHEMA');
141: x_msg_data := fnd_message.get;
142: return;
143: end if;
144:
145: --dbms_output.put_line('Schemas are:'||l_applsys_schema);

Line 224: fnd_message.set_name('MSC','MSC_PART_UNDEFINED_SCHEMA');

220: -- get fnd schema name
221: --
222: if (FND_INSTALLATION.GET_APP_INFO('FND',dummy1,dummy2,l_applsys_schema) = FALSE) then
223: x_return_status := FND_API.G_RET_STS_ERROR;
224: fnd_message.set_name('MSC','MSC_PART_UNDEFINED_SCHEMA');
225: x_msg_data := fnd_message.get;
226: return;
227: end if;
228:

Line 225: x_msg_data := fnd_message.get;

221: --
222: if (FND_INSTALLATION.GET_APP_INFO('FND',dummy1,dummy2,l_applsys_schema) = FALSE) then
223: x_return_status := FND_API.G_RET_STS_ERROR;
224: fnd_message.set_name('MSC','MSC_PART_UNDEFINED_SCHEMA');
225: x_msg_data := fnd_message.get;
226: return;
227: end if;
228:
229: -- dbms_output.put_line('Schemas are:'||l_applsys_schema);

Line 303: -- fnd_message.set_name('MSC','MSC_PART_CREATE_FAILED');

299: --
300: WHEN OTHERS THEN
301:
302: -- dbms_output.put_line(sql_stmt || ' Error:'||to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));
303: -- fnd_message.set_name('MSC','MSC_PART_CREATE_FAILED');
304: -- fnd_message.set_token('PARTITION',l_partition_name);
305: -- x_msg_data := fnd_message.get;
306: x_msg_data := to_char(sqlcode) ||':'|| substr(sqlerrm,1,90);
307: x_return_status := FND_API.G_RET_STS_ERROR;

Line 304: -- fnd_message.set_token('PARTITION',l_partition_name);

300: WHEN OTHERS THEN
301:
302: -- dbms_output.put_line(sql_stmt || ' Error:'||to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));
303: -- fnd_message.set_name('MSC','MSC_PART_CREATE_FAILED');
304: -- fnd_message.set_token('PARTITION',l_partition_name);
305: -- x_msg_data := fnd_message.get;
306: x_msg_data := to_char(sqlcode) ||':'|| substr(sqlerrm,1,90);
307: x_return_status := FND_API.G_RET_STS_ERROR;
308:

Line 305: -- x_msg_data := fnd_message.get;

301:
302: -- dbms_output.put_line(sql_stmt || ' Error:'||to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));
303: -- fnd_message.set_name('MSC','MSC_PART_CREATE_FAILED');
304: -- fnd_message.set_token('PARTITION',l_partition_name);
305: -- x_msg_data := fnd_message.get;
306: x_msg_data := to_char(sqlcode) ||':'|| substr(sqlerrm,1,90);
307: x_return_status := FND_API.G_RET_STS_ERROR;
308:
309: --

Line 371: fnd_message.set_name('MSC','MSC_PART_UNDEFINED_SCHEMA');

367: -- get fnd schema name
368: --
369: if (FND_INSTALLATION.GET_APP_INFO('FND',dummy1,dummy2,l_applsys_schema) = FALSE) then
370: x_return_status := FND_API.G_RET_STS_ERROR;
371: fnd_message.set_name('MSC','MSC_PART_UNDEFINED_SCHEMA');
372: x_msg_data := fnd_message.get;
373: return;
374: end if;
375:

Line 372: x_msg_data := fnd_message.get;

368: --
369: if (FND_INSTALLATION.GET_APP_INFO('FND',dummy1,dummy2,l_applsys_schema) = FALSE) then
370: x_return_status := FND_API.G_RET_STS_ERROR;
371: fnd_message.set_name('MSC','MSC_PART_UNDEFINED_SCHEMA');
372: x_msg_data := fnd_message.get;
373: return;
374: end if;
375:
376: --dbms_output.put_line('Schemas are:'||l_applsys_schema);

Line 459: -- fnd_message.set_name('MSC','MSCFULL_PEGGINGCREATE_FAILED');

455: --
456: WHEN OTHERS THEN
457:
458: -- dbms_output.put_line(sql_stmt || ' Error:'||to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));
459: -- fnd_message.set_name('MSC','MSCFULL_PEGGINGCREATE_FAILED');
460: -- fnd_message.set_token('PARTITION',l_partition_name);
461: -- x_msg_data := fnd_message.get;
462: x_msg_data := to_char(sqlcode) ||':'|| substr(sqlerrm,1,90);
463: x_return_status := FND_API.G_RET_STS_ERROR;

Line 460: -- fnd_message.set_token('PARTITION',l_partition_name);

456: WHEN OTHERS THEN
457:
458: -- dbms_output.put_line(sql_stmt || ' Error:'||to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));
459: -- fnd_message.set_name('MSC','MSCFULL_PEGGINGCREATE_FAILED');
460: -- fnd_message.set_token('PARTITION',l_partition_name);
461: -- x_msg_data := fnd_message.get;
462: x_msg_data := to_char(sqlcode) ||':'|| substr(sqlerrm,1,90);
463: x_return_status := FND_API.G_RET_STS_ERROR;
464:

Line 461: -- x_msg_data := fnd_message.get;

457:
458: -- dbms_output.put_line(sql_stmt || ' Error:'||to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));
459: -- fnd_message.set_name('MSC','MSCFULL_PEGGINGCREATE_FAILED');
460: -- fnd_message.set_token('PARTITION',l_partition_name);
461: -- x_msg_data := fnd_message.get;
462: x_msg_data := to_char(sqlcode) ||':'|| substr(sqlerrm,1,90);
463: x_return_status := FND_API.G_RET_STS_ERROR;
464:
465: --

Line 566: fnd_message.set_name('MSC','MSC_NO_FREE_PARTITION');

562: -- should be created by the system dba because that involves
563: -- analyzing as well as recompiling db objects
564:
565: x_return_status := FND_API.G_RET_STS_ERROR;
566: fnd_message.set_name('MSC','MSC_NO_FREE_PARTITION');
567: x_msg_data := fnd_message.get;
568: l_plan_id := -1; --return -1;
569: EXIT;
570: --

Line 567: x_msg_data := fnd_message.get;

563: -- analyzing as well as recompiling db objects
564:
565: x_return_status := FND_API.G_RET_STS_ERROR;
566: fnd_message.set_name('MSC','MSC_NO_FREE_PARTITION');
567: x_msg_data := fnd_message.get;
568: l_plan_id := -1; --return -1;
569: EXIT;
570: --
571: -- the code below is no longer needed

Line 655: --fnd_message.set_name('MSC','MSC_PART_UPDATE_FAILED');

651: END IF;
652: EXCEPTION
653: WHEN OTHERS THEN
654: x_return_status := FND_API.G_RET_STS_ERROR;
655: --fnd_message.set_name('MSC','MSC_PART_UPDATE_FAILED');
656: x_msg_data := to_char(sqlcode) ||':'|| substr(sqlerrm,1,90);
657: -- fnd_message.get;
658: l_plan_id := -1;
659: EXIT; --return l_plan_id;

Line 657: -- fnd_message.get;

653: WHEN OTHERS THEN
654: x_return_status := FND_API.G_RET_STS_ERROR;
655: --fnd_message.set_name('MSC','MSC_PART_UPDATE_FAILED');
656: x_msg_data := to_char(sqlcode) ||':'|| substr(sqlerrm,1,90);
657: -- fnd_message.get;
658: l_plan_id := -1;
659: EXIT; --return l_plan_id;
660: END;
661: END IF;

Line 763: fnd_message.set_name('MSC','MSC_NO_FREE_PARTITION');

759: --
760: -- cannot create an instance partition dynamically.
761: -- the sysadmin will have to create them
762: --
763: fnd_message.set_name('MSC','MSC_NO_FREE_PARTITION');
764: x_return_status := FND_API.G_RET_STS_ERROR;
765: x_msg_data := fnd_message.get;
766: return -1;
767:

Line 765: x_msg_data := fnd_message.get;

761: -- the sysadmin will have to create them
762: --
763: fnd_message.set_name('MSC','MSC_NO_FREE_PARTITION');
764: x_return_status := FND_API.G_RET_STS_ERROR;
765: x_msg_data := fnd_message.get;
766: return -1;
767:
768: /*
769: SELECT msc_apps_instances_s.nextval

Line 793: --fnd_message.set_name('MSC','MSC_PART_UPDATE_FAILED');

789:
790: exception
791: when others then
792: x_return_status := FND_API.G_RET_STS_ERROR;
793: --fnd_message.set_name('MSC','MSC_PART_UPDATE_FAILED');
794: x_msg_data := to_char(sqlcode) ||':'|| substr(sqlerrm,1,90);
795: -- fnd_message.get;
796: l_inst_id := -1;
797: return l_inst_id;

Line 795: -- fnd_message.get;

791: when others then
792: x_return_status := FND_API.G_RET_STS_ERROR;
793: --fnd_message.set_name('MSC','MSC_PART_UPDATE_FAILED');
794: x_msg_data := to_char(sqlcode) ||':'|| substr(sqlerrm,1,90);
795: -- fnd_message.get;
796: l_inst_id := -1;
797: return l_inst_id;
798: end;
799:

Line 903: fnd_message.set_name('MSC','MSC_PART_UPDATE_FAILED');

899: WHERE plan_id = P_plan_id;
900: exception
901: when others then
902: x_return_status := FND_API.G_RET_STS_ERROR;
903: fnd_message.set_name('MSC','MSC_PART_UPDATE_FAILED');
904: x_msg_data := fnd_message.get;
905: return;
906: end;
907:

Line 904: x_msg_data := fnd_message.get;

900: exception
901: when others then
902: x_return_status := FND_API.G_RET_STS_ERROR;
903: fnd_message.set_name('MSC','MSC_PART_UPDATE_FAILED');
904: x_msg_data := fnd_message.get;
905: return;
906: end;
907:
908: end if;

Line 1001: fnd_message.set_name('MSC','MSC_PART_INSERT_FAILED');

997: clean_partition_pvt(-1,partition_num,2,'drop',x_return_status, errbuf);
998: end if;
999:
1000: x_return_status := FND_API.G_RET_STS_ERROR;
1001: fnd_message.set_name('MSC','MSC_PART_INSERT_FAILED');
1002: errbuf := fnd_message.get;
1003: retcode := to_number(x_return_status);
1004: end;
1005: exception

Line 1002: errbuf := fnd_message.get;

998: end if;
999:
1000: x_return_status := FND_API.G_RET_STS_ERROR;
1001: fnd_message.set_name('MSC','MSC_PART_INSERT_FAILED');
1002: errbuf := fnd_message.get;
1003: retcode := to_number(x_return_status);
1004: end;
1005: exception
1006: when others then