DBA Data[Home] [Help]

APPS.BOM_COPY_ROUTING dependencies on FND_MESSAGE

Line 162: fnd_message.set_name ('BOM', 'BOM_SQL_ERR');

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;

Line 163: fnd_message.set_token ('ENTITY', err_msg);

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:

Line 1973: fnd_message.set_name ('BOM', 'BOM_ROUTING_COPY_DONE');

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);

Line 1974: fnd_message.set_token ('ENTITY1', copy_operations);

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);

Line 1975: fnd_message.set_token ('ENTITY2', total_opseqs);

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

Line 1976: fnd_message.set_token ('ENTITY3', copy_resources);

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

Line 1977: fnd_message.set_token ('ENTITY4', total_resources);

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);

Line 1978: fnd_message.set_token ('ENTITY7', copy_sub_resources);

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);

Line 1980: fnd_message.set_token ('ENTITY8', total_sub_resources); -- Bug2991810

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);

Line 1981: fnd_message.set_token ('ENTITY5', copy_instrs);

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

Line 1982: fnd_message.set_token ('ENTITY6', total_instructions);

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

Line 1983: fnd_message.set_token ('ENTITY9', copy_hdr_instrs); --bug 3473851

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

Line 1984: fnd_message.set_token ('ENTITY10', total_hdr_instructions);

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

Line 1992: fnd_message.set_name ('BOM', 'BOM_SQL_ERR');

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;

Line 1993: fnd_message.set_token ('ENTITY', err_msg);

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:

Line 2143: fnd_message.set_name ('BOM', p_msg_name);

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)

Line 2144: fnd_message.set_token ('OP_SEQ', p_op_seq_num);

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

Line 2145: RETURN fnd_message.get;

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

Line 2151: fnd_message.set_name ('BOM', p_msg_name);

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;

Line 2152: fnd_message.set_token ('OP_SEQ', p_op_seq_num);

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)

Line 2153: fnd_message.set_token ('OP_TYPE', p_oper_type);

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

Line 2154: RETURN fnd_message.get;

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

Line 2160: fnd_message.set_name ('BOM', p_msg_name);

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

Line 2161: fnd_message.set_token ('OP_SEQ', p_op_seq_num);

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);

Line 2163: fnd_message.set_token ('FROM_DEPT', 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;

Line 2165: fnd_message.set_token ('RES_CODE', p_entity_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;
2168: END;
2169:

Line 2167: RETURN fnd_message.get;

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,

Line 3807: fnd_message.set_name ('BOM', 'BOM_ROUTING_COPY_DONE');

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);

Line 3808: fnd_message.set_token ('ENTITY1', copy_operations);

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);

Line 3809: fnd_message.set_token ('ENTITY2', total_opseqs);

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

Line 3810: fnd_message.set_token ('ENTITY3', copy_resources);

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

Line 3811: fnd_message.set_token ('ENTITY4', total_resources);

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);

Line 3812: fnd_message.set_token ('ENTITY7', copy_sub_resources);

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);

Line 3814: fnd_message.set_token ('ENTITY8', total_sub_resources); -- Bug2991810

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);

Line 3815: fnd_message.set_token ('ENTITY5', copy_instrs);

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

Line 3816: fnd_message.set_token ('ENTITY6', total_instructions);

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

Line 3817: fnd_message.set_token ('ENTITY9', copy_hdr_instrs); --bug 3473851

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

Line 3818: fnd_message.set_token ('ENTITY10', total_hdr_instructions);

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

Line 3826: fnd_message.set_name ('BOM', 'BOM_SQL_ERR');

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;

Line 3827: fnd_message.set_token ('ENTITY', err_msg);

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: