158: EXCEPTION
159: WHEN OTHERS
160: THEN
161: err_msg := 'RTG_GET_MSG_INFO (' || sql_stmt_num || ') ' || SQLERRM;
162: fnd_message.set_name ('BOM', 'BOM_SQL_ERR');
163: fnd_message.set_token ('ENTITY', err_msg);
164: ROLLBACK TO begin_routing_copy;
165: app_exception.raise_exception;
166: END rtg_get_msg_info;
159: WHEN OTHERS
160: THEN
161: err_msg := 'RTG_GET_MSG_INFO (' || sql_stmt_num || ') ' || SQLERRM;
162: fnd_message.set_name ('BOM', 'BOM_SQL_ERR');
163: fnd_message.set_token ('ENTITY', err_msg);
164: ROLLBACK TO begin_routing_copy;
165: app_exception.raise_exception;
166: END rtg_get_msg_info;
167:
1969: total_instructions := copy_instrs;
1970: total_hdr_instructions := copy_hdr_instrs; --bug 3473851
1971: END IF;
1972:
1973: fnd_message.set_name ('BOM', 'BOM_ROUTING_COPY_DONE');
1974: fnd_message.set_token ('ENTITY1', copy_operations);
1975: fnd_message.set_token ('ENTITY2', total_opseqs);
1976: fnd_message.set_token ('ENTITY3', copy_resources);
1977: fnd_message.set_token ('ENTITY4', total_resources);
1970: total_hdr_instructions := copy_hdr_instrs; --bug 3473851
1971: END IF;
1972:
1973: fnd_message.set_name ('BOM', 'BOM_ROUTING_COPY_DONE');
1974: fnd_message.set_token ('ENTITY1', copy_operations);
1975: fnd_message.set_token ('ENTITY2', total_opseqs);
1976: fnd_message.set_token ('ENTITY3', copy_resources);
1977: fnd_message.set_token ('ENTITY4', total_resources);
1978: fnd_message.set_token ('ENTITY7', copy_sub_resources);
1971: END IF;
1972:
1973: fnd_message.set_name ('BOM', 'BOM_ROUTING_COPY_DONE');
1974: fnd_message.set_token ('ENTITY1', copy_operations);
1975: fnd_message.set_token ('ENTITY2', total_opseqs);
1976: fnd_message.set_token ('ENTITY3', copy_resources);
1977: fnd_message.set_token ('ENTITY4', total_resources);
1978: fnd_message.set_token ('ENTITY7', copy_sub_resources);
1979: -- Bug2991810 the message also needs to be modified
1972:
1973: fnd_message.set_name ('BOM', 'BOM_ROUTING_COPY_DONE');
1974: fnd_message.set_token ('ENTITY1', copy_operations);
1975: fnd_message.set_token ('ENTITY2', total_opseqs);
1976: fnd_message.set_token ('ENTITY3', copy_resources);
1977: fnd_message.set_token ('ENTITY4', total_resources);
1978: fnd_message.set_token ('ENTITY7', copy_sub_resources);
1979: -- Bug2991810 the message also needs to be modified
1980: fnd_message.set_token ('ENTITY8', total_sub_resources); -- Bug2991810
1973: fnd_message.set_name ('BOM', 'BOM_ROUTING_COPY_DONE');
1974: fnd_message.set_token ('ENTITY1', copy_operations);
1975: fnd_message.set_token ('ENTITY2', total_opseqs);
1976: fnd_message.set_token ('ENTITY3', copy_resources);
1977: fnd_message.set_token ('ENTITY4', total_resources);
1978: fnd_message.set_token ('ENTITY7', copy_sub_resources);
1979: -- Bug2991810 the message also needs to be modified
1980: fnd_message.set_token ('ENTITY8', total_sub_resources); -- Bug2991810
1981: fnd_message.set_token ('ENTITY5', copy_instrs);
1974: fnd_message.set_token ('ENTITY1', copy_operations);
1975: fnd_message.set_token ('ENTITY2', total_opseqs);
1976: fnd_message.set_token ('ENTITY3', copy_resources);
1977: fnd_message.set_token ('ENTITY4', total_resources);
1978: fnd_message.set_token ('ENTITY7', copy_sub_resources);
1979: -- Bug2991810 the message also needs to be modified
1980: fnd_message.set_token ('ENTITY8', total_sub_resources); -- Bug2991810
1981: fnd_message.set_token ('ENTITY5', copy_instrs);
1982: fnd_message.set_token ('ENTITY6', total_instructions);
1976: fnd_message.set_token ('ENTITY3', copy_resources);
1977: fnd_message.set_token ('ENTITY4', total_resources);
1978: fnd_message.set_token ('ENTITY7', copy_sub_resources);
1979: -- Bug2991810 the message also needs to be modified
1980: fnd_message.set_token ('ENTITY8', total_sub_resources); -- Bug2991810
1981: fnd_message.set_token ('ENTITY5', copy_instrs);
1982: fnd_message.set_token ('ENTITY6', total_instructions);
1983: fnd_message.set_token ('ENTITY9', copy_hdr_instrs); --bug 3473851
1984: fnd_message.set_token ('ENTITY10', total_hdr_instructions);
1977: fnd_message.set_token ('ENTITY4', total_resources);
1978: fnd_message.set_token ('ENTITY7', copy_sub_resources);
1979: -- Bug2991810 the message also needs to be modified
1980: fnd_message.set_token ('ENTITY8', total_sub_resources); -- Bug2991810
1981: fnd_message.set_token ('ENTITY5', copy_instrs);
1982: fnd_message.set_token ('ENTITY6', total_instructions);
1983: fnd_message.set_token ('ENTITY9', copy_hdr_instrs); --bug 3473851
1984: fnd_message.set_token ('ENTITY10', total_hdr_instructions);
1985: --bug 3473851
1978: fnd_message.set_token ('ENTITY7', copy_sub_resources);
1979: -- Bug2991810 the message also needs to be modified
1980: fnd_message.set_token ('ENTITY8', total_sub_resources); -- Bug2991810
1981: fnd_message.set_token ('ENTITY5', copy_instrs);
1982: fnd_message.set_token ('ENTITY6', total_instructions);
1983: fnd_message.set_token ('ENTITY9', copy_hdr_instrs); --bug 3473851
1984: fnd_message.set_token ('ENTITY10', total_hdr_instructions);
1985: --bug 3473851
1986: EXCEPTION
1979: -- Bug2991810 the message also needs to be modified
1980: fnd_message.set_token ('ENTITY8', total_sub_resources); -- Bug2991810
1981: fnd_message.set_token ('ENTITY5', copy_instrs);
1982: fnd_message.set_token ('ENTITY6', total_instructions);
1983: fnd_message.set_token ('ENTITY9', copy_hdr_instrs); --bug 3473851
1984: fnd_message.set_token ('ENTITY10', total_hdr_instructions);
1985: --bug 3473851
1986: EXCEPTION
1987: WHEN OTHERS
1980: fnd_message.set_token ('ENTITY8', total_sub_resources); -- Bug2991810
1981: fnd_message.set_token ('ENTITY5', copy_instrs);
1982: fnd_message.set_token ('ENTITY6', total_instructions);
1983: fnd_message.set_token ('ENTITY9', copy_hdr_instrs); --bug 3473851
1984: fnd_message.set_token ('ENTITY10', total_hdr_instructions);
1985: --bug 3473851
1986: EXCEPTION
1987: WHEN OTHERS
1988: THEN
1988: THEN
1989: err_msg :=
1990: 'COPY_ROUTING (' || TO_CHAR (sql_stmt_num) || ') '
1991: || SQLERRM;
1992: fnd_message.set_name ('BOM', 'BOM_SQL_ERR');
1993: fnd_message.set_token ('ENTITY', err_msg);
1994: ROLLBACK TO begin_routing_copy;
1995: app_exception.raise_exception;
1996: END copy_routing;
1989: err_msg :=
1990: 'COPY_ROUTING (' || TO_CHAR (sql_stmt_num) || ') '
1991: || SQLERRM;
1992: fnd_message.set_name ('BOM', 'BOM_SQL_ERR');
1993: fnd_message.set_token ('ENTITY', err_msg);
1994: ROLLBACK TO begin_routing_copy;
1995: app_exception.raise_exception;
1996: END copy_routing;
1997:
2139: FUNCTION GET_MESSAGE (p_msg_name IN VARCHAR2, p_op_seq_num IN NUMBER)
2140: RETURN VARCHAR2
2141: IS
2142: BEGIN
2143: fnd_message.set_name ('BOM', p_msg_name);
2144: fnd_message.set_token ('OP_SEQ', p_op_seq_num);
2145: RETURN fnd_message.get;
2146: END;
2147: FUNCTION GET_MESSAGE (p_msg_name IN VARCHAR2, p_op_seq_num IN NUMBER, p_oper_type IN VARCHAR2)
2140: RETURN VARCHAR2
2141: IS
2142: BEGIN
2143: fnd_message.set_name ('BOM', p_msg_name);
2144: fnd_message.set_token ('OP_SEQ', p_op_seq_num);
2145: RETURN fnd_message.get;
2146: END;
2147: FUNCTION GET_MESSAGE (p_msg_name IN VARCHAR2, p_op_seq_num IN NUMBER, p_oper_type IN VARCHAR2)
2148: RETURN VARCHAR2
2141: IS
2142: BEGIN
2143: fnd_message.set_name ('BOM', p_msg_name);
2144: fnd_message.set_token ('OP_SEQ', p_op_seq_num);
2145: RETURN fnd_message.get;
2146: END;
2147: FUNCTION GET_MESSAGE (p_msg_name IN VARCHAR2, p_op_seq_num IN NUMBER, p_oper_type IN VARCHAR2)
2148: RETURN VARCHAR2
2149: IS
2147: FUNCTION GET_MESSAGE (p_msg_name IN VARCHAR2, p_op_seq_num IN NUMBER, p_oper_type IN VARCHAR2)
2148: RETURN VARCHAR2
2149: IS
2150: BEGIN
2151: fnd_message.set_name ('BOM', p_msg_name);
2152: fnd_message.set_token ('OP_SEQ', p_op_seq_num);
2153: fnd_message.set_token ('OP_TYPE', p_oper_type);
2154: RETURN fnd_message.get;
2155: END;
2148: RETURN VARCHAR2
2149: IS
2150: BEGIN
2151: fnd_message.set_name ('BOM', p_msg_name);
2152: fnd_message.set_token ('OP_SEQ', p_op_seq_num);
2153: fnd_message.set_token ('OP_TYPE', p_oper_type);
2154: RETURN fnd_message.get;
2155: END;
2156: FUNCTION GET_MESSAGE (p_msg_name IN VARCHAR2, p_op_seq_num IN NUMBER, p_entity_name IN VARCHAR2, p_type IN VARCHAR2)
2149: IS
2150: BEGIN
2151: fnd_message.set_name ('BOM', p_msg_name);
2152: fnd_message.set_token ('OP_SEQ', p_op_seq_num);
2153: fnd_message.set_token ('OP_TYPE', p_oper_type);
2154: RETURN fnd_message.get;
2155: END;
2156: FUNCTION GET_MESSAGE (p_msg_name IN VARCHAR2, p_op_seq_num IN NUMBER, p_entity_name IN VARCHAR2, p_type IN VARCHAR2)
2157: RETURN VARCHAR2
2150: BEGIN
2151: fnd_message.set_name ('BOM', p_msg_name);
2152: fnd_message.set_token ('OP_SEQ', p_op_seq_num);
2153: fnd_message.set_token ('OP_TYPE', p_oper_type);
2154: RETURN fnd_message.get;
2155: END;
2156: FUNCTION GET_MESSAGE (p_msg_name IN VARCHAR2, p_op_seq_num IN NUMBER, p_entity_name IN VARCHAR2, p_type IN VARCHAR2)
2157: RETURN VARCHAR2
2158: IS
2156: FUNCTION GET_MESSAGE (p_msg_name IN VARCHAR2, p_op_seq_num IN NUMBER, p_entity_name IN VARCHAR2, p_type IN VARCHAR2)
2157: RETURN VARCHAR2
2158: IS
2159: BEGIN
2160: fnd_message.set_name ('BOM', p_msg_name);
2161: fnd_message.set_token ('OP_SEQ', p_op_seq_num);
2162: IF p_type = 'DEP' THEN
2163: fnd_message.set_token ('FROM_DEPT', p_entity_name);
2164: ELSE
2157: RETURN VARCHAR2
2158: IS
2159: BEGIN
2160: fnd_message.set_name ('BOM', p_msg_name);
2161: fnd_message.set_token ('OP_SEQ', p_op_seq_num);
2162: IF p_type = 'DEP' THEN
2163: fnd_message.set_token ('FROM_DEPT', p_entity_name);
2164: ELSE
2165: fnd_message.set_token ('RES_CODE', p_entity_name);
2159: BEGIN
2160: fnd_message.set_name ('BOM', p_msg_name);
2161: fnd_message.set_token ('OP_SEQ', p_op_seq_num);
2162: IF p_type = 'DEP' THEN
2163: fnd_message.set_token ('FROM_DEPT', p_entity_name);
2164: ELSE
2165: fnd_message.set_token ('RES_CODE', p_entity_name);
2166: END IF;
2167: RETURN fnd_message.get;
2161: fnd_message.set_token ('OP_SEQ', p_op_seq_num);
2162: IF p_type = 'DEP' THEN
2163: fnd_message.set_token ('FROM_DEPT', p_entity_name);
2164: ELSE
2165: fnd_message.set_token ('RES_CODE', p_entity_name);
2166: END IF;
2167: RETURN fnd_message.get;
2168: END;
2169:
2163: fnd_message.set_token ('FROM_DEPT', p_entity_name);
2164: ELSE
2165: fnd_message.set_token ('RES_CODE', p_entity_name);
2166: END IF;
2167: RETURN fnd_message.get;
2168: END;
2169:
2170: PROCEDURE switch_common_to_primary_rtg ( -- BUG 4712488
2171: p_org_id IN NUMBER,
3803: total_instructions := copy_instrs;
3804: total_hdr_instructions := copy_hdr_instrs; --bug 3473851
3805: END IF;
3806:
3807: fnd_message.set_name ('BOM', 'BOM_ROUTING_COPY_DONE');
3808: fnd_message.set_token ('ENTITY1', copy_operations);
3809: fnd_message.set_token ('ENTITY2', total_opseqs);
3810: fnd_message.set_token ('ENTITY3', copy_resources);
3811: fnd_message.set_token ('ENTITY4', total_resources);
3804: total_hdr_instructions := copy_hdr_instrs; --bug 3473851
3805: END IF;
3806:
3807: fnd_message.set_name ('BOM', 'BOM_ROUTING_COPY_DONE');
3808: fnd_message.set_token ('ENTITY1', copy_operations);
3809: fnd_message.set_token ('ENTITY2', total_opseqs);
3810: fnd_message.set_token ('ENTITY3', copy_resources);
3811: fnd_message.set_token ('ENTITY4', total_resources);
3812: fnd_message.set_token ('ENTITY7', copy_sub_resources);
3805: END IF;
3806:
3807: fnd_message.set_name ('BOM', 'BOM_ROUTING_COPY_DONE');
3808: fnd_message.set_token ('ENTITY1', copy_operations);
3809: fnd_message.set_token ('ENTITY2', total_opseqs);
3810: fnd_message.set_token ('ENTITY3', copy_resources);
3811: fnd_message.set_token ('ENTITY4', total_resources);
3812: fnd_message.set_token ('ENTITY7', copy_sub_resources);
3813: -- Bug2991810 the message also needs to be modified
3806:
3807: fnd_message.set_name ('BOM', 'BOM_ROUTING_COPY_DONE');
3808: fnd_message.set_token ('ENTITY1', copy_operations);
3809: fnd_message.set_token ('ENTITY2', total_opseqs);
3810: fnd_message.set_token ('ENTITY3', copy_resources);
3811: fnd_message.set_token ('ENTITY4', total_resources);
3812: fnd_message.set_token ('ENTITY7', copy_sub_resources);
3813: -- Bug2991810 the message also needs to be modified
3814: fnd_message.set_token ('ENTITY8', total_sub_resources); -- Bug2991810
3807: fnd_message.set_name ('BOM', 'BOM_ROUTING_COPY_DONE');
3808: fnd_message.set_token ('ENTITY1', copy_operations);
3809: fnd_message.set_token ('ENTITY2', total_opseqs);
3810: fnd_message.set_token ('ENTITY3', copy_resources);
3811: fnd_message.set_token ('ENTITY4', total_resources);
3812: fnd_message.set_token ('ENTITY7', copy_sub_resources);
3813: -- Bug2991810 the message also needs to be modified
3814: fnd_message.set_token ('ENTITY8', total_sub_resources); -- Bug2991810
3815: fnd_message.set_token ('ENTITY5', copy_instrs);
3808: fnd_message.set_token ('ENTITY1', copy_operations);
3809: fnd_message.set_token ('ENTITY2', total_opseqs);
3810: fnd_message.set_token ('ENTITY3', copy_resources);
3811: fnd_message.set_token ('ENTITY4', total_resources);
3812: fnd_message.set_token ('ENTITY7', copy_sub_resources);
3813: -- Bug2991810 the message also needs to be modified
3814: fnd_message.set_token ('ENTITY8', total_sub_resources); -- Bug2991810
3815: fnd_message.set_token ('ENTITY5', copy_instrs);
3816: fnd_message.set_token ('ENTITY6', total_instructions);
3810: fnd_message.set_token ('ENTITY3', copy_resources);
3811: fnd_message.set_token ('ENTITY4', total_resources);
3812: fnd_message.set_token ('ENTITY7', copy_sub_resources);
3813: -- Bug2991810 the message also needs to be modified
3814: fnd_message.set_token ('ENTITY8', total_sub_resources); -- Bug2991810
3815: fnd_message.set_token ('ENTITY5', copy_instrs);
3816: fnd_message.set_token ('ENTITY6', total_instructions);
3817: fnd_message.set_token ('ENTITY9', copy_hdr_instrs); --bug 3473851
3818: fnd_message.set_token ('ENTITY10', total_hdr_instructions);
3811: fnd_message.set_token ('ENTITY4', total_resources);
3812: fnd_message.set_token ('ENTITY7', copy_sub_resources);
3813: -- Bug2991810 the message also needs to be modified
3814: fnd_message.set_token ('ENTITY8', total_sub_resources); -- Bug2991810
3815: fnd_message.set_token ('ENTITY5', copy_instrs);
3816: fnd_message.set_token ('ENTITY6', total_instructions);
3817: fnd_message.set_token ('ENTITY9', copy_hdr_instrs); --bug 3473851
3818: fnd_message.set_token ('ENTITY10', total_hdr_instructions);
3819: --bug 3473851
3812: fnd_message.set_token ('ENTITY7', copy_sub_resources);
3813: -- Bug2991810 the message also needs to be modified
3814: fnd_message.set_token ('ENTITY8', total_sub_resources); -- Bug2991810
3815: fnd_message.set_token ('ENTITY5', copy_instrs);
3816: fnd_message.set_token ('ENTITY6', total_instructions);
3817: fnd_message.set_token ('ENTITY9', copy_hdr_instrs); --bug 3473851
3818: fnd_message.set_token ('ENTITY10', total_hdr_instructions);
3819: --bug 3473851
3820: EXCEPTION
3813: -- Bug2991810 the message also needs to be modified
3814: fnd_message.set_token ('ENTITY8', total_sub_resources); -- Bug2991810
3815: fnd_message.set_token ('ENTITY5', copy_instrs);
3816: fnd_message.set_token ('ENTITY6', total_instructions);
3817: fnd_message.set_token ('ENTITY9', copy_hdr_instrs); --bug 3473851
3818: fnd_message.set_token ('ENTITY10', total_hdr_instructions);
3819: --bug 3473851
3820: EXCEPTION
3821: WHEN OTHERS
3814: fnd_message.set_token ('ENTITY8', total_sub_resources); -- Bug2991810
3815: fnd_message.set_token ('ENTITY5', copy_instrs);
3816: fnd_message.set_token ('ENTITY6', total_instructions);
3817: fnd_message.set_token ('ENTITY9', copy_hdr_instrs); --bug 3473851
3818: fnd_message.set_token ('ENTITY10', total_hdr_instructions);
3819: --bug 3473851
3820: EXCEPTION
3821: WHEN OTHERS
3822: THEN
3822: THEN
3823: err_msg :=
3824: 'COPY_ROUTING (' || TO_CHAR (sql_stmt_num) || ') '
3825: || SQLERRM;
3826: fnd_message.set_name ('BOM', 'BOM_SQL_ERR');
3827: fnd_message.set_token ('ENTITY', err_msg);
3828: ROLLBACK TO begin_routing_copy;
3829: app_exception.raise_exception;
3830: END copy_routing_for_revised_item;
3823: err_msg :=
3824: 'COPY_ROUTING (' || TO_CHAR (sql_stmt_num) || ') '
3825: || SQLERRM;
3826: fnd_message.set_name ('BOM', 'BOM_SQL_ERR');
3827: fnd_message.set_token ('ENTITY', err_msg);
3828: ROLLBACK TO begin_routing_copy;
3829: app_exception.raise_exception;
3830: END copy_routing_for_revised_item;
3831: