DBA Data[Home] [Help]

APPS.BOM_COPY_BILL dependencies on FND_MESSAGE

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

213: EXCEPTION
214: WHEN OTHERS
215: THEN
216: err_msg := 'BILL_GET_MSG_INFO (' || sql_stmt_num || ') ' || SQLERRM;
217: fnd_message.set_name ('BOM', 'BOM_SQL_ERR');
218: fnd_message.set_token ('ENTITY', err_msg);
219: ROLLBACK TO begin_bill_copy;
220: app_exception.raise_exception;
221: END bill_get_msg_info;

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

214: WHEN OTHERS
215: THEN
216: err_msg := 'BILL_GET_MSG_INFO (' || sql_stmt_num || ') ' || SQLERRM;
217: fnd_message.set_name ('BOM', 'BOM_SQL_ERR');
218: fnd_message.set_token ('ENTITY', err_msg);
219: ROLLBACK TO begin_bill_copy;
220: app_exception.raise_exception;
221: END bill_get_msg_info;
222:

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

286: WHEN OTHERS
287: THEN
288: err_msg :=
289: 'BILL_GET_MSG_INFO_COMPOPS (' || sql_stmt_num || ') ' || SQLERRM;
290: fnd_message.set_name ('BOM', 'BOM_SQL_ERR');
291: fnd_message.set_token ('ENTITY', err_msg);
292: ROLLBACK TO begin_bill_copy;
293: app_exception.raise_exception;
294: END bill_get_msg_info_compops;

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

287: THEN
288: err_msg :=
289: 'BILL_GET_MSG_INFO_COMPOPS (' || sql_stmt_num || ') ' || SQLERRM;
290: fnd_message.set_name ('BOM', 'BOM_SQL_ERR');
291: fnd_message.set_token ('ENTITY', err_msg);
292: ROLLBACK TO begin_bill_copy;
293: app_exception.raise_exception;
294: END bill_get_msg_info_compops;
295:

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

4935: to_rtg_seq_id := -1;
4936: WHEN OTHERS
4937: THEN
4938: err_msg := 'COPY_BILL (' || sql_stmt_num || ') ' || SQLERRM;
4939: fnd_message.set_name ('BOM', 'BOM_SQL_ERR');
4940: fnd_message.set_token ('ENTITY', err_msg);
4941: ROLLBACK TO begin_bill_copy;
4942: app_exception.raise_exception;
4943: END;

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

4936: WHEN OTHERS
4937: THEN
4938: err_msg := 'COPY_BILL (' || sql_stmt_num || ') ' || SQLERRM;
4939: fnd_message.set_name ('BOM', 'BOM_SQL_ERR');
4940: fnd_message.set_token ('ENTITY', err_msg);
4941: ROLLBACK TO begin_bill_copy;
4942: app_exception.raise_exception;
4943: END;
4944:

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

5086: NULL;
5087: WHEN OTHERS
5088: THEN
5089: err_msg := 'COPY_BILL (' || sql_stmt_num || ') ' || SQLERRM;
5090: fnd_message.set_name ('BOM', 'BOM_SQL_ERR');
5091: fnd_message.set_token ('ENTITY', err_msg);
5092: ROLLBACK TO begin_bill_copy;
5093: app_exception.raise_exception;
5094: END;

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

5087: WHEN OTHERS
5088: THEN
5089: err_msg := 'COPY_BILL (' || sql_stmt_num || ') ' || SQLERRM;
5090: fnd_message.set_name ('BOM', 'BOM_SQL_ERR');
5091: fnd_message.set_token ('ENTITY', err_msg);
5092: ROLLBACK TO begin_bill_copy;
5093: app_exception.raise_exception;
5094: END;
5095: END IF;

Line 6164: fnd_message.set_name ('BOM', 'BOM_BILL_COPY_DONE');

6160: sql_stmt_num := 87;
6161: total_assembly_comments := copy_comts;
6162: END IF;
6163:
6164: fnd_message.set_name ('BOM', 'BOM_BILL_COPY_DONE');
6165: fnd_message.set_token ('ENTITY1', copy_comps);
6166: fnd_message.set_token ('ENTITY2', total_inventory_components);
6167: fnd_message.set_token ('ENTITY3', copy_comts);
6168: fnd_message.set_token ('ENTITY4', total_assembly_comments);

Line 6165: fnd_message.set_token ('ENTITY1', copy_comps);

6161: total_assembly_comments := copy_comts;
6162: END IF;
6163:
6164: fnd_message.set_name ('BOM', 'BOM_BILL_COPY_DONE');
6165: fnd_message.set_token ('ENTITY1', copy_comps);
6166: fnd_message.set_token ('ENTITY2', total_inventory_components);
6167: fnd_message.set_token ('ENTITY3', copy_comts);
6168: fnd_message.set_token ('ENTITY4', total_assembly_comments);
6169: fnd_message.set_token ('ENTITY5', copy_desgs);

Line 6166: fnd_message.set_token ('ENTITY2', total_inventory_components);

6162: END IF;
6163:
6164: fnd_message.set_name ('BOM', 'BOM_BILL_COPY_DONE');
6165: fnd_message.set_token ('ENTITY1', copy_comps);
6166: fnd_message.set_token ('ENTITY2', total_inventory_components);
6167: fnd_message.set_token ('ENTITY3', copy_comts);
6168: fnd_message.set_token ('ENTITY4', total_assembly_comments);
6169: fnd_message.set_token ('ENTITY5', copy_desgs);
6170: fnd_message.set_token ('ENTITY6', total_reference_designators);

Line 6167: fnd_message.set_token ('ENTITY3', copy_comts);

6163:
6164: fnd_message.set_name ('BOM', 'BOM_BILL_COPY_DONE');
6165: fnd_message.set_token ('ENTITY1', copy_comps);
6166: fnd_message.set_token ('ENTITY2', total_inventory_components);
6167: fnd_message.set_token ('ENTITY3', copy_comts);
6168: fnd_message.set_token ('ENTITY4', total_assembly_comments);
6169: fnd_message.set_token ('ENTITY5', copy_desgs);
6170: fnd_message.set_token ('ENTITY6', total_reference_designators);
6171: fnd_message.set_token ('ENTITY7', copy_subs);

Line 6168: fnd_message.set_token ('ENTITY4', total_assembly_comments);

6164: fnd_message.set_name ('BOM', 'BOM_BILL_COPY_DONE');
6165: fnd_message.set_token ('ENTITY1', copy_comps);
6166: fnd_message.set_token ('ENTITY2', total_inventory_components);
6167: fnd_message.set_token ('ENTITY3', copy_comts);
6168: fnd_message.set_token ('ENTITY4', total_assembly_comments);
6169: fnd_message.set_token ('ENTITY5', copy_desgs);
6170: fnd_message.set_token ('ENTITY6', total_reference_designators);
6171: fnd_message.set_token ('ENTITY7', copy_subs);
6172: fnd_message.set_token ('ENTITY8', total_substitute_components);

Line 6169: fnd_message.set_token ('ENTITY5', copy_desgs);

6165: fnd_message.set_token ('ENTITY1', copy_comps);
6166: fnd_message.set_token ('ENTITY2', total_inventory_components);
6167: fnd_message.set_token ('ENTITY3', copy_comts);
6168: fnd_message.set_token ('ENTITY4', total_assembly_comments);
6169: fnd_message.set_token ('ENTITY5', copy_desgs);
6170: fnd_message.set_token ('ENTITY6', total_reference_designators);
6171: fnd_message.set_token ('ENTITY7', copy_subs);
6172: fnd_message.set_token ('ENTITY8', total_substitute_components);
6173: fnd_message.set_token ('ENTITY9', copy_compops);

Line 6170: fnd_message.set_token ('ENTITY6', total_reference_designators);

6166: fnd_message.set_token ('ENTITY2', total_inventory_components);
6167: fnd_message.set_token ('ENTITY3', copy_comts);
6168: fnd_message.set_token ('ENTITY4', total_assembly_comments);
6169: fnd_message.set_token ('ENTITY5', copy_desgs);
6170: fnd_message.set_token ('ENTITY6', total_reference_designators);
6171: fnd_message.set_token ('ENTITY7', copy_subs);
6172: fnd_message.set_token ('ENTITY8', total_substitute_components);
6173: fnd_message.set_token ('ENTITY9', copy_compops);
6174: fnd_message.set_token ('ENTITY10', total_component_operations);

Line 6171: fnd_message.set_token ('ENTITY7', copy_subs);

6167: fnd_message.set_token ('ENTITY3', copy_comts);
6168: fnd_message.set_token ('ENTITY4', total_assembly_comments);
6169: fnd_message.set_token ('ENTITY5', copy_desgs);
6170: fnd_message.set_token ('ENTITY6', total_reference_designators);
6171: fnd_message.set_token ('ENTITY7', copy_subs);
6172: fnd_message.set_token ('ENTITY8', total_substitute_components);
6173: fnd_message.set_token ('ENTITY9', copy_compops);
6174: fnd_message.set_token ('ENTITY10', total_component_operations);
6175: -- dbms_profiler.stop_profiler();

Line 6172: fnd_message.set_token ('ENTITY8', total_substitute_components);

6168: fnd_message.set_token ('ENTITY4', total_assembly_comments);
6169: fnd_message.set_token ('ENTITY5', copy_desgs);
6170: fnd_message.set_token ('ENTITY6', total_reference_designators);
6171: fnd_message.set_token ('ENTITY7', copy_subs);
6172: fnd_message.set_token ('ENTITY8', total_substitute_components);
6173: fnd_message.set_token ('ENTITY9', copy_compops);
6174: fnd_message.set_token ('ENTITY10', total_component_operations);
6175: -- dbms_profiler.stop_profiler();
6176: EXCEPTION

Line 6173: fnd_message.set_token ('ENTITY9', copy_compops);

6169: fnd_message.set_token ('ENTITY5', copy_desgs);
6170: fnd_message.set_token ('ENTITY6', total_reference_designators);
6171: fnd_message.set_token ('ENTITY7', copy_subs);
6172: fnd_message.set_token ('ENTITY8', total_substitute_components);
6173: fnd_message.set_token ('ENTITY9', copy_compops);
6174: fnd_message.set_token ('ENTITY10', total_component_operations);
6175: -- dbms_profiler.stop_profiler();
6176: EXCEPTION
6177: WHEN overlap_error

Line 6174: fnd_message.set_token ('ENTITY10', total_component_operations);

6170: fnd_message.set_token ('ENTITY6', total_reference_designators);
6171: fnd_message.set_token ('ENTITY7', copy_subs);
6172: fnd_message.set_token ('ENTITY8', total_substitute_components);
6173: fnd_message.set_token ('ENTITY9', copy_compops);
6174: fnd_message.set_token ('ENTITY10', total_component_operations);
6175: -- dbms_profiler.stop_profiler();
6176: EXCEPTION
6177: WHEN overlap_error
6178: THEN

Line 6180: fnd_message.set_name ('BOM', 'BOM_BAD_COPY_GUI');

6176: EXCEPTION
6177: WHEN overlap_error
6178: THEN
6179: bom_globals.g_skip_bomtbicx := 'N';
6180: fnd_message.set_name ('BOM', 'BOM_BAD_COPY_GUI');
6181:
6182: IF specific_copy_flag = 'Y'
6183: THEN
6184: INSERT INTO mtl_interface_errors

Line 6210: fnd_message.get,

6206: get_current_item_rev (to_item_id,
6207: from_org_id,
6208: SYSDATE
6209: ),
6210: fnd_message.get,
6211: 'BOM_COPY',
6212: SYSDATE,
6213: user_id,
6214: SYSDATE,

Line 6229: fnd_message.set_name ('BOM', 'BOM_COMMON_OTHER_ORGS2');

6225: END IF;
6226: WHEN common_error
6227: THEN
6228: bom_globals.g_skip_bomtbicx := 'N';
6229: fnd_message.set_name ('BOM', 'BOM_COMMON_OTHER_ORGS2');
6230:
6231: IF specific_copy_flag = 'Y'
6232: THEN
6233: INSERT INTO mtl_interface_errors

Line 6259: fnd_message.get,

6255: get_current_item_rev (to_item_id,
6256: from_org_id,
6257: SYSDATE
6258: ),
6259: fnd_message.get,
6260: 'BOM_COPY',
6261: SYSDATE,
6262: user_id,
6263: SYSDATE,

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

6275: WHEN OTHERS
6276: THEN
6277: bom_globals.g_skip_bomtbicx := 'N';
6278: err_msg := 'COPY_BILL (' || sql_stmt_num || ') ' || SQLERRM;
6279: fnd_message.set_name ('BOM', 'BOM_SQL_ERR');
6280: fnd_message.set_token ('ENTITY', err_msg);
6281: ROLLBACK TO begin_bill_copy;
6282: app_exception.raise_exception;
6283: END copy_bill;

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

6276: THEN
6277: bom_globals.g_skip_bomtbicx := 'N';
6278: err_msg := 'COPY_BILL (' || sql_stmt_num || ') ' || SQLERRM;
6279: fnd_message.set_name ('BOM', 'BOM_SQL_ERR');
6280: fnd_message.set_token ('ENTITY', err_msg);
6281: ROLLBACK TO begin_bill_copy;
6282: app_exception.raise_exception;
6283: END copy_bill;
6284:

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

6332: FUNCTION GET_MESSAGE (p_msg_name IN VARCHAR2, p_comp_item IN VARCHAR2)
6333: RETURN VARCHAR2
6334: IS
6335: BEGIN
6336: fnd_message.set_name ('BOM', p_msg_name);
6337: fnd_message.set_token ('COMP_ITEM', p_comp_item);
6338: RETURN fnd_message.get;
6339: END;
6340:

Line 6337: fnd_message.set_token ('COMP_ITEM', p_comp_item);

6333: RETURN VARCHAR2
6334: IS
6335: BEGIN
6336: fnd_message.set_name ('BOM', p_msg_name);
6337: fnd_message.set_token ('COMP_ITEM', p_comp_item);
6338: RETURN fnd_message.get;
6339: END;
6340:
6341: FUNCTION GET_MESSAGE (

Line 6338: RETURN fnd_message.get;

6334: IS
6335: BEGIN
6336: fnd_message.set_name ('BOM', p_msg_name);
6337: fnd_message.set_token ('COMP_ITEM', p_comp_item);
6338: RETURN fnd_message.get;
6339: END;
6340:
6341: FUNCTION GET_MESSAGE (
6342: p_msg_name IN VARCHAR2,

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

6345: )
6346: RETURN VARCHAR2
6347: IS
6348: BEGIN
6349: fnd_message.set_name ('BOM', p_msg_name);
6350: fnd_message.set_token ('COMP_ITEM', p_comp_item);
6351: fnd_message.set_token ('ASSEMBLY_ITEM', p_assembly_item);
6352: RETURN fnd_message.get;
6353: END;

Line 6350: fnd_message.set_token ('COMP_ITEM', p_comp_item);

6346: RETURN VARCHAR2
6347: IS
6348: BEGIN
6349: fnd_message.set_name ('BOM', p_msg_name);
6350: fnd_message.set_token ('COMP_ITEM', p_comp_item);
6351: fnd_message.set_token ('ASSEMBLY_ITEM', p_assembly_item);
6352: RETURN fnd_message.get;
6353: END;
6354:

Line 6351: fnd_message.set_token ('ASSEMBLY_ITEM', p_assembly_item);

6347: IS
6348: BEGIN
6349: fnd_message.set_name ('BOM', p_msg_name);
6350: fnd_message.set_token ('COMP_ITEM', p_comp_item);
6351: fnd_message.set_token ('ASSEMBLY_ITEM', p_assembly_item);
6352: RETURN fnd_message.get;
6353: END;
6354:
6355: FUNCTION GET_MESSAGE (

Line 6352: RETURN fnd_message.get;

6348: BEGIN
6349: fnd_message.set_name ('BOM', p_msg_name);
6350: fnd_message.set_token ('COMP_ITEM', p_comp_item);
6351: fnd_message.set_token ('ASSEMBLY_ITEM', p_assembly_item);
6352: RETURN fnd_message.get;
6353: END;
6354:
6355: FUNCTION GET_MESSAGE (
6356: p_msg_name IN VARCHAR2,

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

6360: )
6361: RETURN VARCHAR2
6362: IS
6363: BEGIN
6364: fnd_message.set_name ('BOM', p_msg_name);
6365: fnd_message.set_token ('COMP_ITEM', p_comp_item);
6366: fnd_message.set_token ('ASSEMBLY_ITEM', p_assembly_item);
6367: fnd_message.set_token ('COMP_REV', p_comp_rev);
6368: RETURN fnd_message.get;

Line 6365: fnd_message.set_token ('COMP_ITEM', p_comp_item);

6361: RETURN VARCHAR2
6362: IS
6363: BEGIN
6364: fnd_message.set_name ('BOM', p_msg_name);
6365: fnd_message.set_token ('COMP_ITEM', p_comp_item);
6366: fnd_message.set_token ('ASSEMBLY_ITEM', p_assembly_item);
6367: fnd_message.set_token ('COMP_REV', p_comp_rev);
6368: RETURN fnd_message.get;
6369: END;

Line 6366: fnd_message.set_token ('ASSEMBLY_ITEM', p_assembly_item);

6362: IS
6363: BEGIN
6364: fnd_message.set_name ('BOM', p_msg_name);
6365: fnd_message.set_token ('COMP_ITEM', p_comp_item);
6366: fnd_message.set_token ('ASSEMBLY_ITEM', p_assembly_item);
6367: fnd_message.set_token ('COMP_REV', p_comp_rev);
6368: RETURN fnd_message.get;
6369: END;
6370:

Line 6367: fnd_message.set_token ('COMP_REV', p_comp_rev);

6363: BEGIN
6364: fnd_message.set_name ('BOM', p_msg_name);
6365: fnd_message.set_token ('COMP_ITEM', p_comp_item);
6366: fnd_message.set_token ('ASSEMBLY_ITEM', p_assembly_item);
6367: fnd_message.set_token ('COMP_REV', p_comp_rev);
6368: RETURN fnd_message.get;
6369: END;
6370:
6371: FUNCTION get_cnt_message (

Line 6368: RETURN fnd_message.get;

6364: fnd_message.set_name ('BOM', p_msg_name);
6365: fnd_message.set_token ('COMP_ITEM', p_comp_item);
6366: fnd_message.set_token ('ASSEMBLY_ITEM', p_assembly_item);
6367: fnd_message.set_token ('COMP_REV', p_comp_rev);
6368: RETURN fnd_message.get;
6369: END;
6370:
6371: FUNCTION get_cnt_message (
6372: p_msg_name IN VARCHAR2,

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

6375: )
6376: RETURN VARCHAR2
6377: IS
6378: BEGIN
6379: fnd_message.set_name ('BOM', p_msg_name);
6380: fnd_message.set_token ('ASSEMBLY_ITEM', p_assembly_item);
6381: fnd_message.set_token ('COMP_CNT', p_comp_count);
6382: RETURN fnd_message.get;
6383: END;

Line 6380: fnd_message.set_token ('ASSEMBLY_ITEM', p_assembly_item);

6376: RETURN VARCHAR2
6377: IS
6378: BEGIN
6379: fnd_message.set_name ('BOM', p_msg_name);
6380: fnd_message.set_token ('ASSEMBLY_ITEM', p_assembly_item);
6381: fnd_message.set_token ('COMP_CNT', p_comp_count);
6382: RETURN fnd_message.get;
6383: END;
6384:

Line 6381: fnd_message.set_token ('COMP_CNT', p_comp_count);

6377: IS
6378: BEGIN
6379: fnd_message.set_name ('BOM', p_msg_name);
6380: fnd_message.set_token ('ASSEMBLY_ITEM', p_assembly_item);
6381: fnd_message.set_token ('COMP_CNT', p_comp_count);
6382: RETURN fnd_message.get;
6383: END;
6384:
6385: PROCEDURE assign_items_to_copy_to_org (

Line 6382: RETURN fnd_message.get;

6378: BEGIN
6379: fnd_message.set_name ('BOM', p_msg_name);
6380: fnd_message.set_token ('ASSEMBLY_ITEM', p_assembly_item);
6381: fnd_message.set_token ('COMP_CNT', p_comp_count);
6382: RETURN fnd_message.get;
6383: END;
6384:
6385: PROCEDURE assign_items_to_copy_to_org (
6386: p_cp_request_id IN NUMBER,

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

6648: EXCEPTION
6649: WHEN OTHERS
6650: THEN
6651: err_msg := 'COPY_BILL ( assign_items_to_org )' || SQLERRM;
6652: fnd_message.set_name ('BOM', 'BOM_SQL_ERR');
6653: fnd_message.set_token ('ENTITY', err_msg);
6654: ROLLBACK TO begin_assign_items_to_org;
6655: app_exception.raise_exception;
6656: END assign_items_to_copy_to_org;

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

6649: WHEN OTHERS
6650: THEN
6651: err_msg := 'COPY_BILL ( assign_items_to_org )' || SQLERRM;
6652: fnd_message.set_name ('BOM', 'BOM_SQL_ERR');
6653: fnd_message.set_token ('ENTITY', err_msg);
6654: ROLLBACK TO begin_assign_items_to_org;
6655: app_exception.raise_exception;
6656: END assign_items_to_copy_to_org;
6657:

Line 6830: fnd_message.set_name ('BOM', 'BOM_CPY_IP_NO_ORG_IN_HRCHY');

6826: l_index := x_org_list_tbl.next(l_index);
6827: x_return_status := fnd_api.G_RET_STS_SUCCESS;
6828: EXCEPTION
6829: WHEN NO_DATA_FOUND THEN
6830: fnd_message.set_name ('BOM', 'BOM_CPY_IP_NO_ORG_IN_HRCHY');
6831: x_return_status := fnd_api.G_RET_STS_ERROR;
6832: x_error_msg := fnd_message.get;
6833: RETURN;
6834: END;

Line 6832: x_error_msg := fnd_message.get;

6828: EXCEPTION
6829: WHEN NO_DATA_FOUND THEN
6830: fnd_message.set_name ('BOM', 'BOM_CPY_IP_NO_ORG_IN_HRCHY');
6831: x_return_status := fnd_api.G_RET_STS_ERROR;
6832: x_error_msg := fnd_message.get;
6833: RETURN;
6834: END;
6835: END LOOP;
6836: END IF;

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

10570: to_rtg_seq_id := -1;
10571: WHEN OTHERS
10572: THEN
10573: err_msg := 'COPY_BILL (' || sql_stmt_num || ') ' || SQLERRM;
10574: fnd_message.set_name ('BOM', 'BOM_SQL_ERR');
10575: fnd_message.set_token ('ENTITY', err_msg);
10576: ROLLBACK TO begin_revised_item_bill_copy;
10577: app_exception.raise_exception;
10578: END;

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

10571: WHEN OTHERS
10572: THEN
10573: err_msg := 'COPY_BILL (' || sql_stmt_num || ') ' || SQLERRM;
10574: fnd_message.set_name ('BOM', 'BOM_SQL_ERR');
10575: fnd_message.set_token ('ENTITY', err_msg);
10576: ROLLBACK TO begin_revised_item_bill_copy;
10577: app_exception.raise_exception;
10578: END;
10579:

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

10724: NULL;
10725: WHEN OTHERS
10726: THEN
10727: err_msg := 'COPY_BILL (' || sql_stmt_num || ') ' || SQLERRM;
10728: fnd_message.set_name ('BOM', 'BOM_SQL_ERR');
10729: fnd_message.set_token ('ENTITY', err_msg);
10730: ROLLBACK TO begin_bill_copy;
10731: app_exception.raise_exception;
10732: END;

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

10725: WHEN OTHERS
10726: THEN
10727: err_msg := 'COPY_BILL (' || sql_stmt_num || ') ' || SQLERRM;
10728: fnd_message.set_name ('BOM', 'BOM_SQL_ERR');
10729: fnd_message.set_token ('ENTITY', err_msg);
10730: ROLLBACK TO begin_bill_copy;
10731: app_exception.raise_exception;
10732: END;
10733: END IF;

Line 11486: fnd_message.set_name ('BOM', 'BOM_BAD_COPY_GUI');

11482: EXCEPTION
11483: WHEN overlap_error
11484: THEN
11485: bom_globals.g_skip_bomtbicx := 'N';
11486: fnd_message.set_name ('BOM', 'BOM_BAD_COPY_GUI');
11487:
11488: INSERT INTO mtl_interface_errors
11489: (unique_id,
11490: organization_id,

Line 11514: fnd_message.get,

11510: get_current_item_rev (to_item_id,
11511: from_org_id,
11512: SYSDATE
11513: ),
11514: fnd_message.get,
11515: 'BOM_COPY',
11516: SYSDATE,
11517: user_id,
11518: SYSDATE,

Line 11529: fnd_message.set_name ('BOM', 'BOM_COMMON_OTHER_ORGS2');

11525: );
11526: WHEN common_error
11527: THEN
11528: bom_globals.g_skip_bomtbicx := 'N';
11529: fnd_message.set_name ('BOM', 'BOM_COMMON_OTHER_ORGS2');
11530:
11531: INSERT INTO mtl_interface_errors
11532: (unique_id,
11533: organization_id,

Line 11557: fnd_message.get,

11553: get_current_item_rev (to_item_id,
11554: from_org_id,
11555: SYSDATE
11556: ),
11557: fnd_message.get,
11558: 'BOM_COPY',
11559: SYSDATE,
11560: user_id,
11561: SYSDATE,

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

11569: WHEN OTHERS
11570: THEN
11571: bom_globals.g_skip_bomtbicx := 'N';
11572: err_msg := 'copy_bill_for_revised_item (' || sql_stmt_num || ') ' || SQLERRM;
11573: fnd_message.set_name ('BOM', 'BOM_SQL_ERR');
11574: fnd_message.set_token ('ENTITY', err_msg);
11575: ROLLBACK TO begin_revised_item_bill_copy;
11576: app_exception.raise_exception;
11577: END copy_bill_for_revised_item;

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

11570: THEN
11571: bom_globals.g_skip_bomtbicx := 'N';
11572: err_msg := 'copy_bill_for_revised_item (' || sql_stmt_num || ') ' || SQLERRM;
11573: fnd_message.set_name ('BOM', 'BOM_SQL_ERR');
11574: fnd_message.set_token ('ENTITY', err_msg);
11575: ROLLBACK TO begin_revised_item_bill_copy;
11576: app_exception.raise_exception;
11577: END copy_bill_for_revised_item;
11578:

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

11607: p_component_item IN VARCHAR2, p_component_item_type IN VARCHAR2)
11608: RETURN VARCHAR2
11609: IS
11610: BEGIN
11611: fnd_message.set_name('BOM',p_msg_name);
11612: fnd_message.set_token('PARENT_ITEM_NAME',p_assembly_item);
11613: fnd_message.set_token('PARENT_ITEM_TYPE',p_parent_item_type);
11614: fnd_message.set_token('COMPONENT_ITEM_NAME',p_component_item);
11615: fnd_message.set_token('COMPONENT_ITEM_TYPE',p_component_item_type);

Line 11612: fnd_message.set_token('PARENT_ITEM_NAME',p_assembly_item);

11608: RETURN VARCHAR2
11609: IS
11610: BEGIN
11611: fnd_message.set_name('BOM',p_msg_name);
11612: fnd_message.set_token('PARENT_ITEM_NAME',p_assembly_item);
11613: fnd_message.set_token('PARENT_ITEM_TYPE',p_parent_item_type);
11614: fnd_message.set_token('COMPONENT_ITEM_NAME',p_component_item);
11615: fnd_message.set_token('COMPONENT_ITEM_TYPE',p_component_item_type);
11616: RETURN fnd_message.get;

Line 11613: fnd_message.set_token('PARENT_ITEM_TYPE',p_parent_item_type);

11609: IS
11610: BEGIN
11611: fnd_message.set_name('BOM',p_msg_name);
11612: fnd_message.set_token('PARENT_ITEM_NAME',p_assembly_item);
11613: fnd_message.set_token('PARENT_ITEM_TYPE',p_parent_item_type);
11614: fnd_message.set_token('COMPONENT_ITEM_NAME',p_component_item);
11615: fnd_message.set_token('COMPONENT_ITEM_TYPE',p_component_item_type);
11616: RETURN fnd_message.get;
11617: END get_comp_type_rule_message;

Line 11614: fnd_message.set_token('COMPONENT_ITEM_NAME',p_component_item);

11610: BEGIN
11611: fnd_message.set_name('BOM',p_msg_name);
11612: fnd_message.set_token('PARENT_ITEM_NAME',p_assembly_item);
11613: fnd_message.set_token('PARENT_ITEM_TYPE',p_parent_item_type);
11614: fnd_message.set_token('COMPONENT_ITEM_NAME',p_component_item);
11615: fnd_message.set_token('COMPONENT_ITEM_TYPE',p_component_item_type);
11616: RETURN fnd_message.get;
11617: END get_comp_type_rule_message;
11618:

Line 11615: fnd_message.set_token('COMPONENT_ITEM_TYPE',p_component_item_type);

11611: fnd_message.set_name('BOM',p_msg_name);
11612: fnd_message.set_token('PARENT_ITEM_NAME',p_assembly_item);
11613: fnd_message.set_token('PARENT_ITEM_TYPE',p_parent_item_type);
11614: fnd_message.set_token('COMPONENT_ITEM_NAME',p_component_item);
11615: fnd_message.set_token('COMPONENT_ITEM_TYPE',p_component_item_type);
11616: RETURN fnd_message.get;
11617: END get_comp_type_rule_message;
11618:
11619: -- Start of comments

Line 11616: RETURN fnd_message.get;

11612: fnd_message.set_token('PARENT_ITEM_NAME',p_assembly_item);
11613: fnd_message.set_token('PARENT_ITEM_TYPE',p_parent_item_type);
11614: fnd_message.set_token('COMPONENT_ITEM_NAME',p_component_item);
11615: fnd_message.set_token('COMPONENT_ITEM_TYPE',p_component_item_type);
11616: RETURN fnd_message.get;
11617: END get_comp_type_rule_message;
11618:
11619: -- Start of comments
11620: -- API name : check_component_type_rules