DBA Data[Home] [Help]

APPS.MSC_RP_RELEASE_PUB dependencies on FND_MESSAGE

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

466: update msc_rp_release_status set completion_pcnt=100,status=4
467: where release_session_id=psid;
468: commit;
469:
470: fnd_message.set_name('MSC', 'MSC_REL_SETUP_ERR');
471: fnd_message.set_token('ERROR_MESSAGE', sqlerrm);
472: raise_application_error(-20001,sqlerrm);
473: -- commit;
474: END do_release;

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

467: where release_session_id=psid;
468: commit;
469:
470: fnd_message.set_name('MSC', 'MSC_REL_SETUP_ERR');
471: fnd_message.set_token('ERROR_MESSAGE', sqlerrm);
472: raise_application_error(-20001,sqlerrm);
473: -- commit;
474: END do_release;
475:

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

803:
804: /* if it is supply and order type not in (1,2,3,5,13) */
805: if (p_source_table='MSC_SUPPLIES' AND
806: p_order_type NOT IN (1, 2, 3, 5, 13) )then
807: p_rel_error :=FND_MESSAGE.GET_STRING('MSC', 'MSC_WB_RELEASE_3');
808: return p_rel_error;
809: END IF;
810:
811:

Line 816: fnd_message.set_name('MSC','MSC_ALLOW_RELEASE_INSTANCE');

812:
813: /* if the instance is not release enabled */
814: if (get_instance_release_status(p_inst_id) = 2) then
815: l_instance_code := substr(p_org_code,1,instr(p_org_code,':',-1)-1);
816: fnd_message.set_name('MSC','MSC_ALLOW_RELEASE_INSTANCE');
817: fnd_message.set_token('INSTANCE',l_instance_code);
818: p_rel_error :=fnd_message.get;
819: return p_rel_error;
820: end if;

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

813: /* if the instance is not release enabled */
814: if (get_instance_release_status(p_inst_id) = 2) then
815: l_instance_code := substr(p_org_code,1,instr(p_org_code,':',-1)-1);
816: fnd_message.set_name('MSC','MSC_ALLOW_RELEASE_INSTANCE');
817: fnd_message.set_token('INSTANCE',l_instance_code);
818: p_rel_error :=fnd_message.get;
819: return p_rel_error;
820: end if;
821:

Line 818: p_rel_error :=fnd_message.get;

814: if (get_instance_release_status(p_inst_id) = 2) then
815: l_instance_code := substr(p_org_code,1,instr(p_org_code,':',-1)-1);
816: fnd_message.set_name('MSC','MSC_ALLOW_RELEASE_INSTANCE');
817: fnd_message.set_token('INSTANCE',l_instance_code);
818: p_rel_error :=fnd_message.get;
819: return p_rel_error;
820: end if;
821:
822:

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

821:
822:
823: /* if source db is not running */
824: if not (msc_rel_wf.is_source_db_up(p_inst_id)) then
825: p_rel_error :=FND_MESSAGE.GET_STRING('MSC', 'MSC_SOURCE_IS_INVALID');
826: return p_rel_error;
827: end if;
828:
829:

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

828:
829:
830: /* if plan option does not allow to release sales order */
831: if (p_order_type=30) and (l_include_so='N') then
832: p_rel_error :=FND_MESSAGE.GET_STRING('MSC', 'MSC_WB_RELEASE1');
833: return p_rel_error;
834: end if;
835:
836:

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

835:
836:
837: /* model/option classes can not be released */
838: if (p_bom_item_type in (1, 2, 3, 5) )then
839: p_rel_error := FND_MESSAGE.GET_STRING('MRP', 'MRP_REL_ALL_MODEL');
840: return p_rel_error;
841: end if;
842:
843:

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

845:
846:
847: /* Kanban item can not be released */
848: if (p_order_type=5 and p_source_table='MSC_SUPPLIES' and p_release_time_fence_code = 6) then
849: p_rel_error := FND_MESSAGE.GET_STRING('MRP', 'MRP_REL_ALL_KANBAN');
850: return p_rel_error;
851: end if;
852:
853: /* can not release planned order as flow schedule */

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

862: p_item_id,
863: p_transaction_id,
864: p_implement_alternate_routing);
865: if l_temp = 1 then
866: p_rel_error := FND_MESSAGE.GET_STRING('MSC', 'MSC_NO_FLOW_SCHEDULE');
867: return p_rel_error;
868: end if;
869: end if;
870:

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

887: p_rel_schd_OK := nvl(fnd_profile.value('MSC_DRP_RELEASE_FROM_MRP'),'N');
888:
889: if (p_rel_schd_OK = 'N') then
890:
891: p_rel_error := FND_MESSAGE.GET_STRING('MRP', 'MSC_IN_SOURCE_PLAN');
892: return p_rel_error;
893: end if;
894: end if; -- if p_in_source_plan = 1 then
895:

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

906: and p_order_type = 5 and p_org_id = p_source_org_id) then
907: p_valid := MSC_SELECT_ALL_FOR_RELEASE_PUB.child_supplies_onhand(
908: p_plan_id, p_transaction_id);
909: if p_valid > 0 then
910: p_rel_error := FND_MESSAGE.GET_STRING('MSC', 'MSC_REL_ONLY_ONHAND_WARN2');
911: return p_rel_error;
912: end if;
913:
914: end if;