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 2037: fnd_message.set_name ('BOM', 'BOM_ROUTING_COPY_DONE');

2033: total_instructions := copy_instrs;
2034: total_hdr_instructions := copy_hdr_instrs; --bug 3473851
2035: END IF;
2036:
2037: fnd_message.set_name ('BOM', 'BOM_ROUTING_COPY_DONE');
2038: fnd_message.set_token ('ENTITY1', copy_operations);
2039: fnd_message.set_token ('ENTITY2', total_opseqs);
2040: fnd_message.set_token ('ENTITY3', copy_resources);
2041: fnd_message.set_token ('ENTITY4', total_resources);

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

2034: total_hdr_instructions := copy_hdr_instrs; --bug 3473851
2035: END IF;
2036:
2037: fnd_message.set_name ('BOM', 'BOM_ROUTING_COPY_DONE');
2038: fnd_message.set_token ('ENTITY1', copy_operations);
2039: fnd_message.set_token ('ENTITY2', total_opseqs);
2040: fnd_message.set_token ('ENTITY3', copy_resources);
2041: fnd_message.set_token ('ENTITY4', total_resources);
2042: fnd_message.set_token ('ENTITY7', copy_sub_resources);

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

2035: END IF;
2036:
2037: fnd_message.set_name ('BOM', 'BOM_ROUTING_COPY_DONE');
2038: fnd_message.set_token ('ENTITY1', copy_operations);
2039: fnd_message.set_token ('ENTITY2', total_opseqs);
2040: fnd_message.set_token ('ENTITY3', copy_resources);
2041: fnd_message.set_token ('ENTITY4', total_resources);
2042: fnd_message.set_token ('ENTITY7', copy_sub_resources);
2043: -- Bug2991810 the message also needs to be modified

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

2036:
2037: fnd_message.set_name ('BOM', 'BOM_ROUTING_COPY_DONE');
2038: fnd_message.set_token ('ENTITY1', copy_operations);
2039: fnd_message.set_token ('ENTITY2', total_opseqs);
2040: fnd_message.set_token ('ENTITY3', copy_resources);
2041: fnd_message.set_token ('ENTITY4', total_resources);
2042: fnd_message.set_token ('ENTITY7', copy_sub_resources);
2043: -- Bug2991810 the message also needs to be modified
2044: fnd_message.set_token ('ENTITY8', total_sub_resources); -- Bug2991810

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

2037: fnd_message.set_name ('BOM', 'BOM_ROUTING_COPY_DONE');
2038: fnd_message.set_token ('ENTITY1', copy_operations);
2039: fnd_message.set_token ('ENTITY2', total_opseqs);
2040: fnd_message.set_token ('ENTITY3', copy_resources);
2041: fnd_message.set_token ('ENTITY4', total_resources);
2042: fnd_message.set_token ('ENTITY7', copy_sub_resources);
2043: -- Bug2991810 the message also needs to be modified
2044: fnd_message.set_token ('ENTITY8', total_sub_resources); -- Bug2991810
2045: fnd_message.set_token ('ENTITY5', copy_instrs);

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

2038: fnd_message.set_token ('ENTITY1', copy_operations);
2039: fnd_message.set_token ('ENTITY2', total_opseqs);
2040: fnd_message.set_token ('ENTITY3', copy_resources);
2041: fnd_message.set_token ('ENTITY4', total_resources);
2042: fnd_message.set_token ('ENTITY7', copy_sub_resources);
2043: -- Bug2991810 the message also needs to be modified
2044: fnd_message.set_token ('ENTITY8', total_sub_resources); -- Bug2991810
2045: fnd_message.set_token ('ENTITY5', copy_instrs);
2046: fnd_message.set_token ('ENTITY6', total_instructions);

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

2040: fnd_message.set_token ('ENTITY3', copy_resources);
2041: fnd_message.set_token ('ENTITY4', total_resources);
2042: fnd_message.set_token ('ENTITY7', copy_sub_resources);
2043: -- Bug2991810 the message also needs to be modified
2044: fnd_message.set_token ('ENTITY8', total_sub_resources); -- Bug2991810
2045: fnd_message.set_token ('ENTITY5', copy_instrs);
2046: fnd_message.set_token ('ENTITY6', total_instructions);
2047: fnd_message.set_token ('ENTITY9', copy_hdr_instrs); --bug 3473851
2048: fnd_message.set_token ('ENTITY10', total_hdr_instructions);

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

2041: fnd_message.set_token ('ENTITY4', total_resources);
2042: fnd_message.set_token ('ENTITY7', copy_sub_resources);
2043: -- Bug2991810 the message also needs to be modified
2044: fnd_message.set_token ('ENTITY8', total_sub_resources); -- Bug2991810
2045: fnd_message.set_token ('ENTITY5', copy_instrs);
2046: fnd_message.set_token ('ENTITY6', total_instructions);
2047: fnd_message.set_token ('ENTITY9', copy_hdr_instrs); --bug 3473851
2048: fnd_message.set_token ('ENTITY10', total_hdr_instructions);
2049: --bug 3473851

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

2042: fnd_message.set_token ('ENTITY7', copy_sub_resources);
2043: -- Bug2991810 the message also needs to be modified
2044: fnd_message.set_token ('ENTITY8', total_sub_resources); -- Bug2991810
2045: fnd_message.set_token ('ENTITY5', copy_instrs);
2046: fnd_message.set_token ('ENTITY6', total_instructions);
2047: fnd_message.set_token ('ENTITY9', copy_hdr_instrs); --bug 3473851
2048: fnd_message.set_token ('ENTITY10', total_hdr_instructions);
2049: --bug 3473851
2050: EXCEPTION

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

2043: -- Bug2991810 the message also needs to be modified
2044: fnd_message.set_token ('ENTITY8', total_sub_resources); -- Bug2991810
2045: fnd_message.set_token ('ENTITY5', copy_instrs);
2046: fnd_message.set_token ('ENTITY6', total_instructions);
2047: fnd_message.set_token ('ENTITY9', copy_hdr_instrs); --bug 3473851
2048: fnd_message.set_token ('ENTITY10', total_hdr_instructions);
2049: --bug 3473851
2050: EXCEPTION
2051: WHEN OTHERS

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

2044: fnd_message.set_token ('ENTITY8', total_sub_resources); -- Bug2991810
2045: fnd_message.set_token ('ENTITY5', copy_instrs);
2046: fnd_message.set_token ('ENTITY6', total_instructions);
2047: fnd_message.set_token ('ENTITY9', copy_hdr_instrs); --bug 3473851
2048: fnd_message.set_token ('ENTITY10', total_hdr_instructions);
2049: --bug 3473851
2050: EXCEPTION
2051: WHEN OTHERS
2052: THEN

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

2052: THEN
2053: err_msg :=
2054: 'COPY_ROUTING (' || TO_CHAR (sql_stmt_num) || ') '
2055: || SQLERRM;
2056: fnd_message.set_name ('BOM', 'BOM_SQL_ERR');
2057: fnd_message.set_token ('ENTITY', err_msg);
2058: ROLLBACK TO begin_routing_copy;
2059: app_exception.raise_exception;
2060: END copy_routing;

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

2053: err_msg :=
2054: 'COPY_ROUTING (' || TO_CHAR (sql_stmt_num) || ') '
2055: || SQLERRM;
2056: fnd_message.set_name ('BOM', 'BOM_SQL_ERR');
2057: fnd_message.set_token ('ENTITY', err_msg);
2058: ROLLBACK TO begin_routing_copy;
2059: app_exception.raise_exception;
2060: END copy_routing;
2061:

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

2203: FUNCTION GET_MESSAGE (p_msg_name IN VARCHAR2, p_op_seq_num IN NUMBER)
2204: RETURN VARCHAR2
2205: IS
2206: BEGIN
2207: fnd_message.set_name ('BOM', p_msg_name);
2208: fnd_message.set_token ('OP_SEQ', p_op_seq_num);
2209: RETURN fnd_message.get;
2210: END;
2211: FUNCTION GET_MESSAGE (p_msg_name IN VARCHAR2, p_op_seq_num IN NUMBER, p_oper_type IN VARCHAR2)

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

2204: RETURN VARCHAR2
2205: IS
2206: BEGIN
2207: fnd_message.set_name ('BOM', p_msg_name);
2208: fnd_message.set_token ('OP_SEQ', p_op_seq_num);
2209: RETURN fnd_message.get;
2210: END;
2211: FUNCTION GET_MESSAGE (p_msg_name IN VARCHAR2, p_op_seq_num IN NUMBER, p_oper_type IN VARCHAR2)
2212: RETURN VARCHAR2

Line 2209: RETURN fnd_message.get;

2205: IS
2206: BEGIN
2207: fnd_message.set_name ('BOM', p_msg_name);
2208: fnd_message.set_token ('OP_SEQ', p_op_seq_num);
2209: RETURN fnd_message.get;
2210: END;
2211: FUNCTION GET_MESSAGE (p_msg_name IN VARCHAR2, p_op_seq_num IN NUMBER, p_oper_type IN VARCHAR2)
2212: RETURN VARCHAR2
2213: IS

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

2211: FUNCTION GET_MESSAGE (p_msg_name IN VARCHAR2, p_op_seq_num IN NUMBER, p_oper_type IN VARCHAR2)
2212: RETURN VARCHAR2
2213: IS
2214: BEGIN
2215: fnd_message.set_name ('BOM', p_msg_name);
2216: fnd_message.set_token ('OP_SEQ', p_op_seq_num);
2217: fnd_message.set_token ('OP_TYPE', p_oper_type);
2218: RETURN fnd_message.get;
2219: END;

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

2212: RETURN VARCHAR2
2213: IS
2214: BEGIN
2215: fnd_message.set_name ('BOM', p_msg_name);
2216: fnd_message.set_token ('OP_SEQ', p_op_seq_num);
2217: fnd_message.set_token ('OP_TYPE', p_oper_type);
2218: RETURN fnd_message.get;
2219: END;
2220: FUNCTION GET_MESSAGE (p_msg_name IN VARCHAR2, p_op_seq_num IN NUMBER, p_entity_name IN VARCHAR2, p_type IN VARCHAR2)

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

2213: IS
2214: BEGIN
2215: fnd_message.set_name ('BOM', p_msg_name);
2216: fnd_message.set_token ('OP_SEQ', p_op_seq_num);
2217: fnd_message.set_token ('OP_TYPE', p_oper_type);
2218: RETURN fnd_message.get;
2219: END;
2220: FUNCTION GET_MESSAGE (p_msg_name IN VARCHAR2, p_op_seq_num IN NUMBER, p_entity_name IN VARCHAR2, p_type IN VARCHAR2)
2221: RETURN VARCHAR2

Line 2218: RETURN fnd_message.get;

2214: BEGIN
2215: fnd_message.set_name ('BOM', p_msg_name);
2216: fnd_message.set_token ('OP_SEQ', p_op_seq_num);
2217: fnd_message.set_token ('OP_TYPE', p_oper_type);
2218: RETURN fnd_message.get;
2219: END;
2220: FUNCTION GET_MESSAGE (p_msg_name IN VARCHAR2, p_op_seq_num IN NUMBER, p_entity_name IN VARCHAR2, p_type IN VARCHAR2)
2221: RETURN VARCHAR2
2222: IS

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

2220: FUNCTION GET_MESSAGE (p_msg_name IN VARCHAR2, p_op_seq_num IN NUMBER, p_entity_name IN VARCHAR2, p_type IN VARCHAR2)
2221: RETURN VARCHAR2
2222: IS
2223: BEGIN
2224: fnd_message.set_name ('BOM', p_msg_name);
2225: fnd_message.set_token ('OP_SEQ', p_op_seq_num);
2226: IF p_type = 'DEP' THEN
2227: fnd_message.set_token ('FROM_DEPT', p_entity_name);
2228: ELSE

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

2221: RETURN VARCHAR2
2222: IS
2223: BEGIN
2224: fnd_message.set_name ('BOM', p_msg_name);
2225: fnd_message.set_token ('OP_SEQ', p_op_seq_num);
2226: IF p_type = 'DEP' THEN
2227: fnd_message.set_token ('FROM_DEPT', p_entity_name);
2228: ELSE
2229: fnd_message.set_token ('RES_CODE', p_entity_name);

Line 2227: fnd_message.set_token ('FROM_DEPT', p_entity_name);

2223: BEGIN
2224: fnd_message.set_name ('BOM', p_msg_name);
2225: fnd_message.set_token ('OP_SEQ', p_op_seq_num);
2226: IF p_type = 'DEP' THEN
2227: fnd_message.set_token ('FROM_DEPT', p_entity_name);
2228: ELSE
2229: fnd_message.set_token ('RES_CODE', p_entity_name);
2230: END IF;
2231: RETURN fnd_message.get;

Line 2229: fnd_message.set_token ('RES_CODE', p_entity_name);

2225: fnd_message.set_token ('OP_SEQ', p_op_seq_num);
2226: IF p_type = 'DEP' THEN
2227: fnd_message.set_token ('FROM_DEPT', p_entity_name);
2228: ELSE
2229: fnd_message.set_token ('RES_CODE', p_entity_name);
2230: END IF;
2231: RETURN fnd_message.get;
2232: END;
2233:

Line 2231: RETURN fnd_message.get;

2227: fnd_message.set_token ('FROM_DEPT', p_entity_name);
2228: ELSE
2229: fnd_message.set_token ('RES_CODE', p_entity_name);
2230: END IF;
2231: RETURN fnd_message.get;
2232: END;
2233:
2234: PROCEDURE switch_common_to_primary_rtg ( -- BUG 4712488
2235: p_org_id IN NUMBER,

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

3933: total_instructions := copy_instrs;
3934: total_hdr_instructions := copy_hdr_instrs; --bug 3473851
3935: END IF;
3936:
3937: fnd_message.set_name ('BOM', 'BOM_ROUTING_COPY_DONE');
3938: fnd_message.set_token ('ENTITY1', copy_operations);
3939: fnd_message.set_token ('ENTITY2', total_opseqs);
3940: fnd_message.set_token ('ENTITY3', copy_resources);
3941: fnd_message.set_token ('ENTITY4', total_resources);

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

3934: total_hdr_instructions := copy_hdr_instrs; --bug 3473851
3935: END IF;
3936:
3937: fnd_message.set_name ('BOM', 'BOM_ROUTING_COPY_DONE');
3938: fnd_message.set_token ('ENTITY1', copy_operations);
3939: fnd_message.set_token ('ENTITY2', total_opseqs);
3940: fnd_message.set_token ('ENTITY3', copy_resources);
3941: fnd_message.set_token ('ENTITY4', total_resources);
3942: fnd_message.set_token ('ENTITY7', copy_sub_resources);

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

3935: END IF;
3936:
3937: fnd_message.set_name ('BOM', 'BOM_ROUTING_COPY_DONE');
3938: fnd_message.set_token ('ENTITY1', copy_operations);
3939: fnd_message.set_token ('ENTITY2', total_opseqs);
3940: fnd_message.set_token ('ENTITY3', copy_resources);
3941: fnd_message.set_token ('ENTITY4', total_resources);
3942: fnd_message.set_token ('ENTITY7', copy_sub_resources);
3943: -- Bug2991810 the message also needs to be modified

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

3936:
3937: fnd_message.set_name ('BOM', 'BOM_ROUTING_COPY_DONE');
3938: fnd_message.set_token ('ENTITY1', copy_operations);
3939: fnd_message.set_token ('ENTITY2', total_opseqs);
3940: fnd_message.set_token ('ENTITY3', copy_resources);
3941: fnd_message.set_token ('ENTITY4', total_resources);
3942: fnd_message.set_token ('ENTITY7', copy_sub_resources);
3943: -- Bug2991810 the message also needs to be modified
3944: fnd_message.set_token ('ENTITY8', total_sub_resources); -- Bug2991810

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

3937: fnd_message.set_name ('BOM', 'BOM_ROUTING_COPY_DONE');
3938: fnd_message.set_token ('ENTITY1', copy_operations);
3939: fnd_message.set_token ('ENTITY2', total_opseqs);
3940: fnd_message.set_token ('ENTITY3', copy_resources);
3941: fnd_message.set_token ('ENTITY4', total_resources);
3942: fnd_message.set_token ('ENTITY7', copy_sub_resources);
3943: -- Bug2991810 the message also needs to be modified
3944: fnd_message.set_token ('ENTITY8', total_sub_resources); -- Bug2991810
3945: fnd_message.set_token ('ENTITY5', copy_instrs);

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

3938: fnd_message.set_token ('ENTITY1', copy_operations);
3939: fnd_message.set_token ('ENTITY2', total_opseqs);
3940: fnd_message.set_token ('ENTITY3', copy_resources);
3941: fnd_message.set_token ('ENTITY4', total_resources);
3942: fnd_message.set_token ('ENTITY7', copy_sub_resources);
3943: -- Bug2991810 the message also needs to be modified
3944: fnd_message.set_token ('ENTITY8', total_sub_resources); -- Bug2991810
3945: fnd_message.set_token ('ENTITY5', copy_instrs);
3946: fnd_message.set_token ('ENTITY6', total_instructions);

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

3940: fnd_message.set_token ('ENTITY3', copy_resources);
3941: fnd_message.set_token ('ENTITY4', total_resources);
3942: fnd_message.set_token ('ENTITY7', copy_sub_resources);
3943: -- Bug2991810 the message also needs to be modified
3944: fnd_message.set_token ('ENTITY8', total_sub_resources); -- Bug2991810
3945: fnd_message.set_token ('ENTITY5', copy_instrs);
3946: fnd_message.set_token ('ENTITY6', total_instructions);
3947: fnd_message.set_token ('ENTITY9', copy_hdr_instrs); --bug 3473851
3948: fnd_message.set_token ('ENTITY10', total_hdr_instructions);

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

3941: fnd_message.set_token ('ENTITY4', total_resources);
3942: fnd_message.set_token ('ENTITY7', copy_sub_resources);
3943: -- Bug2991810 the message also needs to be modified
3944: fnd_message.set_token ('ENTITY8', total_sub_resources); -- Bug2991810
3945: fnd_message.set_token ('ENTITY5', copy_instrs);
3946: fnd_message.set_token ('ENTITY6', total_instructions);
3947: fnd_message.set_token ('ENTITY9', copy_hdr_instrs); --bug 3473851
3948: fnd_message.set_token ('ENTITY10', total_hdr_instructions);
3949: --bug 3473851

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

3942: fnd_message.set_token ('ENTITY7', copy_sub_resources);
3943: -- Bug2991810 the message also needs to be modified
3944: fnd_message.set_token ('ENTITY8', total_sub_resources); -- Bug2991810
3945: fnd_message.set_token ('ENTITY5', copy_instrs);
3946: fnd_message.set_token ('ENTITY6', total_instructions);
3947: fnd_message.set_token ('ENTITY9', copy_hdr_instrs); --bug 3473851
3948: fnd_message.set_token ('ENTITY10', total_hdr_instructions);
3949: --bug 3473851
3950: EXCEPTION

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

3943: -- Bug2991810 the message also needs to be modified
3944: fnd_message.set_token ('ENTITY8', total_sub_resources); -- Bug2991810
3945: fnd_message.set_token ('ENTITY5', copy_instrs);
3946: fnd_message.set_token ('ENTITY6', total_instructions);
3947: fnd_message.set_token ('ENTITY9', copy_hdr_instrs); --bug 3473851
3948: fnd_message.set_token ('ENTITY10', total_hdr_instructions);
3949: --bug 3473851
3950: EXCEPTION
3951: WHEN OTHERS

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

3944: fnd_message.set_token ('ENTITY8', total_sub_resources); -- Bug2991810
3945: fnd_message.set_token ('ENTITY5', copy_instrs);
3946: fnd_message.set_token ('ENTITY6', total_instructions);
3947: fnd_message.set_token ('ENTITY9', copy_hdr_instrs); --bug 3473851
3948: fnd_message.set_token ('ENTITY10', total_hdr_instructions);
3949: --bug 3473851
3950: EXCEPTION
3951: WHEN OTHERS
3952: THEN

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

3952: THEN
3953: err_msg :=
3954: 'COPY_ROUTING (' || TO_CHAR (sql_stmt_num) || ') '
3955: || SQLERRM;
3956: fnd_message.set_name ('BOM', 'BOM_SQL_ERR');
3957: fnd_message.set_token ('ENTITY', err_msg);
3958: ROLLBACK TO begin_routing_copy;
3959: app_exception.raise_exception;
3960: END copy_routing_for_revised_item;

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

3953: err_msg :=
3954: 'COPY_ROUTING (' || TO_CHAR (sql_stmt_num) || ') '
3955: || SQLERRM;
3956: fnd_message.set_name ('BOM', 'BOM_SQL_ERR');
3957: fnd_message.set_token ('ENTITY', err_msg);
3958: ROLLBACK TO begin_routing_copy;
3959: app_exception.raise_exception;
3960: END copy_routing_for_revised_item;
3961: