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_PLAN_RELEASE dependencies on FND_MESSAGE

Line 49: fnd_message.set_name('MSC', 'MSC_COLL_RUN_WARN');

45: fetch check_coll_cur into collection_status;
46: close check_coll_cur;
47:
48: if nvl(collection_status,0) >0 then
49: fnd_message.set_name('MSC', 'MSC_COLL_RUN_WARN');
50: p_return_msg := fnd_message.get;
51: p_return_status := 2;
52: return;
53: else

Line 50: p_return_msg := fnd_message.get;

46: close check_coll_cur;
47:
48: if nvl(collection_status,0) >0 then
49: fnd_message.set_name('MSC', 'MSC_COLL_RUN_WARN');
50: p_return_msg := fnd_message.get;
51: p_return_status := 2;
52: return;
53: else
54: p_return_status := 1; -- success

Line 78: fnd_message.set_name('MSC', 'MSC_COLL_RUN_WARN');

74:
75: l_query_id number ;
76: begin
77: p_return_status := 2;
78: fnd_message.set_name('MSC', 'MSC_COLL_RUN_WARN');
79: p_return_msg := fnd_message.get;
80: SELECT msc_form_query_s.nextval
81: INTO l_query_id
82: FROM dual;

Line 79: p_return_msg := fnd_message.get;

75: l_query_id number ;
76: begin
77: p_return_status := 2;
78: fnd_message.set_name('MSC', 'MSC_COLL_RUN_WARN');
79: p_return_msg := fnd_message.get;
80: SELECT msc_form_query_s.nextval
81: INTO l_query_id
82: FROM dual;
83:

Line 299: -- fnd_message.set_name('MSC', 'MSC_COLL_RUN_WARN');

295: fetch check_coll_cur into collection_status;
296: close check_coll_cur;
297:
298: if nvl(collection_status,0) >0 then
299: -- fnd_message.set_name('MSC', 'MSC_COLL_RUN_WARN');
300: p_return_status := 2;
301: return;
302: end if;
303:

Line 578: fnd_message.set_name('MSC', 'MSC_REL_SETUP_ERR');

574: -- print_debug('All done ...');
575: EXCEPTION
576: WHEN OTHERS THEN
577:
578: fnd_message.set_name('MSC', 'MSC_REL_SETUP_ERR');
579: fnd_message.set_token('ERROR_MESSAGE', sqlerrm);
580: raise_application_error(-20001,sqlerrm);
581: p_return_status := 2;
582: p_return_msg := fnd_message.get;

Line 579: fnd_message.set_token('ERROR_MESSAGE', sqlerrm);

575: EXCEPTION
576: WHEN OTHERS THEN
577:
578: fnd_message.set_name('MSC', 'MSC_REL_SETUP_ERR');
579: fnd_message.set_token('ERROR_MESSAGE', sqlerrm);
580: raise_application_error(-20001,sqlerrm);
581: p_return_status := 2;
582: p_return_msg := fnd_message.get;
583: -- commit;

Line 582: p_return_msg := fnd_message.get;

578: fnd_message.set_name('MSC', 'MSC_REL_SETUP_ERR');
579: fnd_message.set_token('ERROR_MESSAGE', sqlerrm);
580: raise_application_error(-20001,sqlerrm);
581: p_return_status := 2;
582: p_return_msg := fnd_message.get;
583: -- commit;
584: END do_release;
585:
586:

Line 925: p_rel_error :=FND_MESSAGE.GET_STRING('MSC', 'MSC_WB_RELEASE_3');

921:
922: /* if it is supply and order type not in (1,2,3,5,13) */
923: if (p_source_table='MSC_SUPPLIES' AND
924: p_order_type NOT IN (1, 2, 3, 5, 13) )then
925: p_rel_error :=FND_MESSAGE.GET_STRING('MSC', 'MSC_WB_RELEASE_3');
926: return p_rel_error;
927: END IF;
928:
929:

Line 934: fnd_message.set_name('MSC','MSC_RP_ALLOW_RELEASE_INSTANCE');

930:
931: /* if the instance is not release enabled */
932: if (get_instance_release_status(p_inst_id) = 2) then
933: l_instance_code := substr(p_org_code,1,instr(p_org_code,':',-1)-1);
934: fnd_message.set_name('MSC','MSC_RP_ALLOW_RELEASE_INSTANCE');
935: fnd_message.set_token('INSTANCE',l_instance_code);
936: p_rel_error :=fnd_message.get;
937: return p_rel_error;
938: end if;

Line 935: fnd_message.set_token('INSTANCE',l_instance_code);

931: /* if the instance is not release enabled */
932: if (get_instance_release_status(p_inst_id) = 2) then
933: l_instance_code := substr(p_org_code,1,instr(p_org_code,':',-1)-1);
934: fnd_message.set_name('MSC','MSC_RP_ALLOW_RELEASE_INSTANCE');
935: fnd_message.set_token('INSTANCE',l_instance_code);
936: p_rel_error :=fnd_message.get;
937: return p_rel_error;
938: end if;
939:

Line 936: p_rel_error :=fnd_message.get;

932: if (get_instance_release_status(p_inst_id) = 2) then
933: l_instance_code := substr(p_org_code,1,instr(p_org_code,':',-1)-1);
934: fnd_message.set_name('MSC','MSC_RP_ALLOW_RELEASE_INSTANCE');
935: fnd_message.set_token('INSTANCE',l_instance_code);
936: p_rel_error :=fnd_message.get;
937: return p_rel_error;
938: end if;
939:
940:

Line 943: p_rel_error :=FND_MESSAGE.GET_STRING('MSC', 'MSC_SOURCE_IS_INVALID');

939:
940:
941: /* if source db is not running */
942: if not (msc_rel_wf.is_source_db_up(p_inst_id)) then
943: p_rel_error :=FND_MESSAGE.GET_STRING('MSC', 'MSC_SOURCE_IS_INVALID');
944: return p_rel_error;
945: end if;
946:
947:

Line 950: p_rel_error :=FND_MESSAGE.GET_STRING('MSC', 'MSC_WB_RELEASE1');

946:
947:
948: /* if plan option does not allow to release sales order */
949: if (p_order_type=30) and (l_include_so='N') then
950: p_rel_error :=FND_MESSAGE.GET_STRING('MSC', 'MSC_WB_RELEASE1');
951: return p_rel_error;
952: end if;
953:
954:

Line 957: p_rel_error := FND_MESSAGE.GET_STRING('MRP', 'MRP_REL_ALL_MODEL');

953:
954:
955: /* model/option classes can not be released */
956: if (p_bom_item_type in (1, 2, 3, 5) )then
957: p_rel_error := FND_MESSAGE.GET_STRING('MRP', 'MRP_REL_ALL_MODEL');
958: return p_rel_error;
959: end if;
960:
961:

Line 964: p_rel_error := FND_MESSAGE.GET_STRING('MRP', 'MRP_REL_ALL_KANBAN');

960:
961:
962: /* Kanban item can not be released */
963: if (p_order_type=5 and p_source_table='MSC_SUPPLIES' and p_release_time_fence_code = 6) then
964: p_rel_error := FND_MESSAGE.GET_STRING('MRP', 'MRP_REL_ALL_KANBAN');
965: return p_rel_error;
966: end if;
967:
968: /* can not release planned order as flow schedule */

Line 981: p_rel_error := FND_MESSAGE.GET_STRING('MSC', 'MSC_NO_FLOW_SCHEDULE');

977: p_item_id,
978: p_transaction_id,
979: p_implement_alternate_routing);
980: if l_temp = 1 then
981: p_rel_error := FND_MESSAGE.GET_STRING('MSC', 'MSC_NO_FLOW_SCHEDULE');
982: return p_rel_error;
983: end if;
984: end if;
985:

Line 1006: p_rel_error := FND_MESSAGE.GET_STRING('MRP', 'MSC_IN_SOURCE_PLAN');

1002: p_rel_schd_OK := nvl(fnd_profile.value('MSC_DRP_RELEASE_FROM_MRP'),'N');
1003:
1004: if (p_rel_schd_OK = 'N') then
1005:
1006: p_rel_error := FND_MESSAGE.GET_STRING('MRP', 'MSC_IN_SOURCE_PLAN');
1007: return p_rel_error;
1008: end if;
1009: end if; -- if p_in_source_plan = 1 then
1010:

Line 1025: p_rel_error := FND_MESSAGE.GET_STRING('MSC', 'MSC_REL_ONLY_ONHAND_WARN2');

1021: and p_order_type = 5 and p_org_id = p_source_org_id) then
1022: p_valid := MSC_SELECT_ALL_FOR_RELEASE_PUB.child_supplies_onhand(
1023: p_plan_id, p_transaction_id);
1024: if p_valid > 0 then
1025: p_rel_error := FND_MESSAGE.GET_STRING('MSC', 'MSC_REL_ONLY_ONHAND_WARN2');
1026: return p_rel_error;
1027: end if;
1028:
1029: end if;