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 171: fnd_message.set_name('MSC','MSC_PART_UNDEFINED_SCHEMA');

167: -- get fnd schema name
168: --
169: if (FND_INSTALLATION.GET_APP_INFO('FND',dummy1,dummy2,l_applsys_schema) = FALSE) then
170: x_return_status := FND_API.G_RET_STS_ERROR;
171: fnd_message.set_name('MSC','MSC_PART_UNDEFINED_SCHEMA');
172: x_msg_data := fnd_message.get;
173: return;
174: end if;
175:

Line 172: x_msg_data := fnd_message.get;

168: --
169: if (FND_INSTALLATION.GET_APP_INFO('FND',dummy1,dummy2,l_applsys_schema) = FALSE) then
170: x_return_status := FND_API.G_RET_STS_ERROR;
171: fnd_message.set_name('MSC','MSC_PART_UNDEFINED_SCHEMA');
172: x_msg_data := fnd_message.get;
173: return;
174: end if;
175:
176: --dbms_output.put_line('Schemas are:'||l_applsys_schema);

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

252: -- get fnd schema name
253: --
254: if (FND_INSTALLATION.GET_APP_INFO('FND',dummy1,dummy2,l_applsys_schema) = FALSE) then
255: x_return_status := FND_API.G_RET_STS_ERROR;
256: fnd_message.set_name('MSC','MSC_PART_UNDEFINED_SCHEMA');
257: x_msg_data := fnd_message.get;
258: return;
259: end if;
260:

Line 257: x_msg_data := fnd_message.get;

253: --
254: if (FND_INSTALLATION.GET_APP_INFO('FND',dummy1,dummy2,l_applsys_schema) = FALSE) then
255: x_return_status := FND_API.G_RET_STS_ERROR;
256: fnd_message.set_name('MSC','MSC_PART_UNDEFINED_SCHEMA');
257: x_msg_data := fnd_message.get;
258: return;
259: end if;
260:
261: -- dbms_output.put_line('Schemas are:'||l_applsys_schema);

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

344: --
345: WHEN OTHERS THEN
346:
347: -- dbms_output.put_line(sql_stmt || ' Error:'||to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));
348: -- fnd_message.set_name('MSC','MSC_PART_CREATE_FAILED');
349: -- fnd_message.set_token('PARTITION',l_partition_name);
350: -- x_msg_data := fnd_message.get;
351: x_msg_data := to_char(sqlcode) ||':'|| substr(sqlerrm,1,90);
352: x_return_status := FND_API.G_RET_STS_ERROR;

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

345: WHEN OTHERS THEN
346:
347: -- dbms_output.put_line(sql_stmt || ' Error:'||to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));
348: -- fnd_message.set_name('MSC','MSC_PART_CREATE_FAILED');
349: -- fnd_message.set_token('PARTITION',l_partition_name);
350: -- x_msg_data := fnd_message.get;
351: x_msg_data := to_char(sqlcode) ||':'|| substr(sqlerrm,1,90);
352: x_return_status := FND_API.G_RET_STS_ERROR;
353:

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

346:
347: -- dbms_output.put_line(sql_stmt || ' Error:'||to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));
348: -- fnd_message.set_name('MSC','MSC_PART_CREATE_FAILED');
349: -- fnd_message.set_token('PARTITION',l_partition_name);
350: -- x_msg_data := fnd_message.get;
351: x_msg_data := to_char(sqlcode) ||':'|| substr(sqlerrm,1,90);
352: x_return_status := FND_API.G_RET_STS_ERROR;
353:
354: --

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

412: -- get fnd schema name
413: --
414: if (FND_INSTALLATION.GET_APP_INFO('FND',dummy1,dummy2,l_applsys_schema) = FALSE) then
415: x_return_status := FND_API.G_RET_STS_ERROR;
416: fnd_message.set_name('MSC','MSC_PART_UNDEFINED_SCHEMA');
417: x_msg_data := fnd_message.get;
418: return;
419: end if;
420:

Line 417: x_msg_data := fnd_message.get;

413: --
414: if (FND_INSTALLATION.GET_APP_INFO('FND',dummy1,dummy2,l_applsys_schema) = FALSE) then
415: x_return_status := FND_API.G_RET_STS_ERROR;
416: fnd_message.set_name('MSC','MSC_PART_UNDEFINED_SCHEMA');
417: x_msg_data := fnd_message.get;
418: return;
419: end if;
420:
421: --dbms_output.put_line('Schemas are:'||l_applsys_schema);

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

504: --
505: WHEN OTHERS THEN
506:
507: -- dbms_output.put_line(sql_stmt || ' Error:'||to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));
508: -- fnd_message.set_name('MSC','MSC_PART_CREATE_FAILED');
509: -- fnd_message.set_token('PARTITION',l_partition_name);
510: -- x_msg_data := fnd_message.get;
511: x_msg_data := to_char(sqlcode) ||':'|| substr(sqlerrm,1,90);
512: x_return_status := FND_API.G_RET_STS_ERROR;

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

505: WHEN OTHERS THEN
506:
507: -- dbms_output.put_line(sql_stmt || ' Error:'||to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));
508: -- fnd_message.set_name('MSC','MSC_PART_CREATE_FAILED');
509: -- fnd_message.set_token('PARTITION',l_partition_name);
510: -- x_msg_data := fnd_message.get;
511: x_msg_data := to_char(sqlcode) ||':'|| substr(sqlerrm,1,90);
512: x_return_status := FND_API.G_RET_STS_ERROR;
513:

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

506:
507: -- dbms_output.put_line(sql_stmt || ' Error:'||to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));
508: -- fnd_message.set_name('MSC','MSC_PART_CREATE_FAILED');
509: -- fnd_message.set_token('PARTITION',l_partition_name);
510: -- x_msg_data := fnd_message.get;
511: x_msg_data := to_char(sqlcode) ||':'|| substr(sqlerrm,1,90);
512: x_return_status := FND_API.G_RET_STS_ERROR;
513:
514: --

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

611: -- should be created by the system dba because that involves
612: -- analyzing as well as recompiling db objects
613:
614: x_return_status := FND_API.G_RET_STS_ERROR;
615: fnd_message.set_name('MSC','MSC_NO_FREE_PARTITION');
616: x_msg_data := fnd_message.get;
617: l_plan_id := -1; --return -1;
618: EXIT;
619: --

Line 616: x_msg_data := fnd_message.get;

612: -- analyzing as well as recompiling db objects
613:
614: x_return_status := FND_API.G_RET_STS_ERROR;
615: fnd_message.set_name('MSC','MSC_NO_FREE_PARTITION');
616: x_msg_data := fnd_message.get;
617: l_plan_id := -1; --return -1;
618: EXIT;
619: --
620: -- the code below is no longer needed

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

700: END IF;
701: EXCEPTION
702: WHEN OTHERS THEN
703: x_return_status := FND_API.G_RET_STS_ERROR;
704: --fnd_message.set_name('MSC','MSC_PART_UPDATE_FAILED');
705: x_msg_data := to_char(sqlcode) ||':'|| substr(sqlerrm,1,90);
706: -- fnd_message.get;
707: l_plan_id := -1;
708: EXIT; --return l_plan_id;

Line 706: -- fnd_message.get;

702: WHEN OTHERS THEN
703: x_return_status := FND_API.G_RET_STS_ERROR;
704: --fnd_message.set_name('MSC','MSC_PART_UPDATE_FAILED');
705: x_msg_data := to_char(sqlcode) ||':'|| substr(sqlerrm,1,90);
706: -- fnd_message.get;
707: l_plan_id := -1;
708: EXIT; --return l_plan_id;
709: END;
710: END IF;

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

808: --
809: -- cannot create an instance partition dynamically.
810: -- the sysadmin will have to create them
811: --
812: fnd_message.set_name('MSC','MSC_NO_FREE_PARTITION');
813: x_return_status := FND_API.G_RET_STS_ERROR;
814: x_msg_data := fnd_message.get;
815: return -1;
816:

Line 814: x_msg_data := fnd_message.get;

810: -- the sysadmin will have to create them
811: --
812: fnd_message.set_name('MSC','MSC_NO_FREE_PARTITION');
813: x_return_status := FND_API.G_RET_STS_ERROR;
814: x_msg_data := fnd_message.get;
815: return -1;
816:
817: /*
818: SELECT msc_apps_instances_s.nextval

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

838:
839: exception
840: when others then
841: x_return_status := FND_API.G_RET_STS_ERROR;
842: --fnd_message.set_name('MSC','MSC_PART_UPDATE_FAILED');
843: x_msg_data := to_char(sqlcode) ||':'|| substr(sqlerrm,1,90);
844: -- fnd_message.get;
845: l_inst_id := -1;
846: return l_inst_id;

Line 844: -- fnd_message.get;

840: when others then
841: x_return_status := FND_API.G_RET_STS_ERROR;
842: --fnd_message.set_name('MSC','MSC_PART_UPDATE_FAILED');
843: x_msg_data := to_char(sqlcode) ||':'|| substr(sqlerrm,1,90);
844: -- fnd_message.get;
845: l_inst_id := -1;
846: return l_inst_id;
847: end;
848:

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

949: WHERE plan_id = P_plan_id;
950: exception
951: when others then
952: x_return_status := FND_API.G_RET_STS_ERROR;
953: fnd_message.set_name('MSC','MSC_PART_UPDATE_FAILED');
954: x_msg_data := fnd_message.get;
955: return;
956: end;
957:

Line 954: x_msg_data := fnd_message.get;

950: exception
951: when others then
952: x_return_status := FND_API.G_RET_STS_ERROR;
953: fnd_message.set_name('MSC','MSC_PART_UPDATE_FAILED');
954: x_msg_data := fnd_message.get;
955: return;
956: end;
957:
958: end if;

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

1047: clean_partition_pvt(-1,partition_num,2,'drop',x_return_status, errbuf);
1048: end if;
1049:
1050: x_return_status := FND_API.G_RET_STS_ERROR;
1051: fnd_message.set_name('MSC','MSC_PART_INSERT_FAILED');
1052: errbuf := fnd_message.get;
1053: retcode := to_number(x_return_status);
1054: end;
1055: exception

Line 1052: errbuf := fnd_message.get;

1048: end if;
1049:
1050: x_return_status := FND_API.G_RET_STS_ERROR;
1051: fnd_message.set_name('MSC','MSC_PART_INSERT_FAILED');
1052: errbuf := fnd_message.get;
1053: retcode := to_number(x_return_status);
1054: end;
1055: exception
1056: when others then