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

4997: to_rtg_seq_id := -1;
4998: WHEN OTHERS
4999: THEN
5000: err_msg := 'COPY_BILL (' || sql_stmt_num || ') ' || SQLERRM;
5001: fnd_message.set_name ('BOM', 'BOM_SQL_ERR');
5002: fnd_message.set_token ('ENTITY', err_msg);
5003: ROLLBACK TO begin_bill_copy;
5004: app_exception.raise_exception;
5005: END;

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

4998: WHEN OTHERS
4999: THEN
5000: err_msg := 'COPY_BILL (' || sql_stmt_num || ') ' || SQLERRM;
5001: fnd_message.set_name ('BOM', 'BOM_SQL_ERR');
5002: fnd_message.set_token ('ENTITY', err_msg);
5003: ROLLBACK TO begin_bill_copy;
5004: app_exception.raise_exception;
5005: END;
5006:

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

5148: NULL;
5149: WHEN OTHERS
5150: THEN
5151: err_msg := 'COPY_BILL (' || sql_stmt_num || ') ' || SQLERRM;
5152: fnd_message.set_name ('BOM', 'BOM_SQL_ERR');
5153: fnd_message.set_token ('ENTITY', err_msg);
5154: ROLLBACK TO begin_bill_copy;
5155: app_exception.raise_exception;
5156: END;

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

5149: WHEN OTHERS
5150: THEN
5151: err_msg := 'COPY_BILL (' || sql_stmt_num || ') ' || SQLERRM;
5152: fnd_message.set_name ('BOM', 'BOM_SQL_ERR');
5153: fnd_message.set_token ('ENTITY', err_msg);
5154: ROLLBACK TO begin_bill_copy;
5155: app_exception.raise_exception;
5156: END;
5157: END IF;

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

6256: sql_stmt_num := 87;
6257: total_assembly_comments := copy_comts;
6258: END IF;
6259:
6260: fnd_message.set_name ('BOM', 'BOM_BILL_COPY_DONE');
6261: fnd_message.set_token ('ENTITY1', copy_comps);
6262: fnd_message.set_token ('ENTITY2', total_inventory_components);
6263: fnd_message.set_token ('ENTITY3', copy_comts);
6264: fnd_message.set_token ('ENTITY4', total_assembly_comments);

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

6257: total_assembly_comments := copy_comts;
6258: END IF;
6259:
6260: fnd_message.set_name ('BOM', 'BOM_BILL_COPY_DONE');
6261: fnd_message.set_token ('ENTITY1', copy_comps);
6262: fnd_message.set_token ('ENTITY2', total_inventory_components);
6263: fnd_message.set_token ('ENTITY3', copy_comts);
6264: fnd_message.set_token ('ENTITY4', total_assembly_comments);
6265: fnd_message.set_token ('ENTITY5', copy_desgs);

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

6258: END IF;
6259:
6260: fnd_message.set_name ('BOM', 'BOM_BILL_COPY_DONE');
6261: fnd_message.set_token ('ENTITY1', copy_comps);
6262: fnd_message.set_token ('ENTITY2', total_inventory_components);
6263: fnd_message.set_token ('ENTITY3', copy_comts);
6264: fnd_message.set_token ('ENTITY4', total_assembly_comments);
6265: fnd_message.set_token ('ENTITY5', copy_desgs);
6266: fnd_message.set_token ('ENTITY6', total_reference_designators);

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

6259:
6260: fnd_message.set_name ('BOM', 'BOM_BILL_COPY_DONE');
6261: fnd_message.set_token ('ENTITY1', copy_comps);
6262: fnd_message.set_token ('ENTITY2', total_inventory_components);
6263: fnd_message.set_token ('ENTITY3', copy_comts);
6264: fnd_message.set_token ('ENTITY4', total_assembly_comments);
6265: fnd_message.set_token ('ENTITY5', copy_desgs);
6266: fnd_message.set_token ('ENTITY6', total_reference_designators);
6267: fnd_message.set_token ('ENTITY7', copy_subs);

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

6260: fnd_message.set_name ('BOM', 'BOM_BILL_COPY_DONE');
6261: fnd_message.set_token ('ENTITY1', copy_comps);
6262: fnd_message.set_token ('ENTITY2', total_inventory_components);
6263: fnd_message.set_token ('ENTITY3', copy_comts);
6264: fnd_message.set_token ('ENTITY4', total_assembly_comments);
6265: fnd_message.set_token ('ENTITY5', copy_desgs);
6266: fnd_message.set_token ('ENTITY6', total_reference_designators);
6267: fnd_message.set_token ('ENTITY7', copy_subs);
6268: fnd_message.set_token ('ENTITY8', total_substitute_components);

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

6261: fnd_message.set_token ('ENTITY1', copy_comps);
6262: fnd_message.set_token ('ENTITY2', total_inventory_components);
6263: fnd_message.set_token ('ENTITY3', copy_comts);
6264: fnd_message.set_token ('ENTITY4', total_assembly_comments);
6265: fnd_message.set_token ('ENTITY5', copy_desgs);
6266: fnd_message.set_token ('ENTITY6', total_reference_designators);
6267: fnd_message.set_token ('ENTITY7', copy_subs);
6268: fnd_message.set_token ('ENTITY8', total_substitute_components);
6269: fnd_message.set_token ('ENTITY9', copy_compops);

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

6262: fnd_message.set_token ('ENTITY2', total_inventory_components);
6263: fnd_message.set_token ('ENTITY3', copy_comts);
6264: fnd_message.set_token ('ENTITY4', total_assembly_comments);
6265: fnd_message.set_token ('ENTITY5', copy_desgs);
6266: fnd_message.set_token ('ENTITY6', total_reference_designators);
6267: fnd_message.set_token ('ENTITY7', copy_subs);
6268: fnd_message.set_token ('ENTITY8', total_substitute_components);
6269: fnd_message.set_token ('ENTITY9', copy_compops);
6270: fnd_message.set_token ('ENTITY10', total_component_operations);

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

6263: fnd_message.set_token ('ENTITY3', copy_comts);
6264: fnd_message.set_token ('ENTITY4', total_assembly_comments);
6265: fnd_message.set_token ('ENTITY5', copy_desgs);
6266: fnd_message.set_token ('ENTITY6', total_reference_designators);
6267: fnd_message.set_token ('ENTITY7', copy_subs);
6268: fnd_message.set_token ('ENTITY8', total_substitute_components);
6269: fnd_message.set_token ('ENTITY9', copy_compops);
6270: fnd_message.set_token ('ENTITY10', total_component_operations);
6271: -- dbms_profiler.stop_profiler();

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

6264: fnd_message.set_token ('ENTITY4', total_assembly_comments);
6265: fnd_message.set_token ('ENTITY5', copy_desgs);
6266: fnd_message.set_token ('ENTITY6', total_reference_designators);
6267: fnd_message.set_token ('ENTITY7', copy_subs);
6268: fnd_message.set_token ('ENTITY8', total_substitute_components);
6269: fnd_message.set_token ('ENTITY9', copy_compops);
6270: fnd_message.set_token ('ENTITY10', total_component_operations);
6271: -- dbms_profiler.stop_profiler();
6272: EXCEPTION

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

6265: fnd_message.set_token ('ENTITY5', copy_desgs);
6266: fnd_message.set_token ('ENTITY6', total_reference_designators);
6267: fnd_message.set_token ('ENTITY7', copy_subs);
6268: fnd_message.set_token ('ENTITY8', total_substitute_components);
6269: fnd_message.set_token ('ENTITY9', copy_compops);
6270: fnd_message.set_token ('ENTITY10', total_component_operations);
6271: -- dbms_profiler.stop_profiler();
6272: EXCEPTION
6273: WHEN overlap_error

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

6266: fnd_message.set_token ('ENTITY6', total_reference_designators);
6267: fnd_message.set_token ('ENTITY7', copy_subs);
6268: fnd_message.set_token ('ENTITY8', total_substitute_components);
6269: fnd_message.set_token ('ENTITY9', copy_compops);
6270: fnd_message.set_token ('ENTITY10', total_component_operations);
6271: -- dbms_profiler.stop_profiler();
6272: EXCEPTION
6273: WHEN overlap_error
6274: THEN

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

6272: EXCEPTION
6273: WHEN overlap_error
6274: THEN
6275: bom_globals.g_skip_bomtbicx := 'N';
6276: fnd_message.set_name ('BOM', 'BOM_BAD_COPY_GUI');
6277:
6278: IF specific_copy_flag = 'Y'
6279: THEN
6280: INSERT INTO mtl_interface_errors

Line 6306: fnd_message.get,

6302: get_current_item_rev (to_item_id,
6303: from_org_id,
6304: SYSDATE
6305: ),
6306: fnd_message.get,
6307: 'BOM_COPY',
6308: SYSDATE,
6309: user_id,
6310: SYSDATE,

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

6321: END IF;
6322: WHEN common_error
6323: THEN
6324: bom_globals.g_skip_bomtbicx := 'N';
6325: fnd_message.set_name ('BOM', 'BOM_COMMON_OTHER_ORGS2');
6326:
6327: IF specific_copy_flag = 'Y'
6328: THEN
6329: INSERT INTO mtl_interface_errors

Line 6355: fnd_message.get,

6351: get_current_item_rev (to_item_id,
6352: from_org_id,
6353: SYSDATE
6354: ),
6355: fnd_message.get,
6356: 'BOM_COPY',
6357: SYSDATE,
6358: user_id,
6359: SYSDATE,

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

6371: WHEN OTHERS
6372: THEN
6373: bom_globals.g_skip_bomtbicx := 'N';
6374: err_msg := 'COPY_BILL (' || sql_stmt_num || ') ' || SQLERRM;
6375: fnd_message.set_name ('BOM', 'BOM_SQL_ERR');
6376: fnd_message.set_token ('ENTITY', err_msg);
6377: ROLLBACK TO begin_bill_copy;
6378: app_exception.raise_exception;
6379: END copy_bill;

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

6372: THEN
6373: bom_globals.g_skip_bomtbicx := 'N';
6374: err_msg := 'COPY_BILL (' || sql_stmt_num || ') ' || SQLERRM;
6375: fnd_message.set_name ('BOM', 'BOM_SQL_ERR');
6376: fnd_message.set_token ('ENTITY', err_msg);
6377: ROLLBACK TO begin_bill_copy;
6378: app_exception.raise_exception;
6379: END copy_bill;
6380:

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

6428: FUNCTION GET_MESSAGE (p_msg_name IN VARCHAR2, p_comp_item IN VARCHAR2)
6429: RETURN VARCHAR2
6430: IS
6431: BEGIN
6432: fnd_message.set_name ('BOM', p_msg_name);
6433: fnd_message.set_token ('COMP_ITEM', p_comp_item);
6434: RETURN fnd_message.get;
6435: END;
6436:

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

6429: RETURN VARCHAR2
6430: IS
6431: BEGIN
6432: fnd_message.set_name ('BOM', p_msg_name);
6433: fnd_message.set_token ('COMP_ITEM', p_comp_item);
6434: RETURN fnd_message.get;
6435: END;
6436:
6437: FUNCTION GET_MESSAGE (

Line 6434: RETURN fnd_message.get;

6430: IS
6431: BEGIN
6432: fnd_message.set_name ('BOM', p_msg_name);
6433: fnd_message.set_token ('COMP_ITEM', p_comp_item);
6434: RETURN fnd_message.get;
6435: END;
6436:
6437: FUNCTION GET_MESSAGE (
6438: p_msg_name IN VARCHAR2,

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

6441: )
6442: RETURN VARCHAR2
6443: IS
6444: BEGIN
6445: fnd_message.set_name ('BOM', p_msg_name);
6446: fnd_message.set_token ('COMP_ITEM', p_comp_item);
6447: fnd_message.set_token ('ASSEMBLY_ITEM', p_assembly_item);
6448: RETURN fnd_message.get;
6449: END;

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

6442: RETURN VARCHAR2
6443: IS
6444: BEGIN
6445: fnd_message.set_name ('BOM', p_msg_name);
6446: fnd_message.set_token ('COMP_ITEM', p_comp_item);
6447: fnd_message.set_token ('ASSEMBLY_ITEM', p_assembly_item);
6448: RETURN fnd_message.get;
6449: END;
6450:

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

6443: IS
6444: BEGIN
6445: fnd_message.set_name ('BOM', p_msg_name);
6446: fnd_message.set_token ('COMP_ITEM', p_comp_item);
6447: fnd_message.set_token ('ASSEMBLY_ITEM', p_assembly_item);
6448: RETURN fnd_message.get;
6449: END;
6450:
6451: FUNCTION GET_MESSAGE (

Line 6448: RETURN fnd_message.get;

6444: BEGIN
6445: fnd_message.set_name ('BOM', p_msg_name);
6446: fnd_message.set_token ('COMP_ITEM', p_comp_item);
6447: fnd_message.set_token ('ASSEMBLY_ITEM', p_assembly_item);
6448: RETURN fnd_message.get;
6449: END;
6450:
6451: FUNCTION GET_MESSAGE (
6452: p_msg_name IN VARCHAR2,

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

6456: )
6457: RETURN VARCHAR2
6458: IS
6459: BEGIN
6460: fnd_message.set_name ('BOM', p_msg_name);
6461: fnd_message.set_token ('COMP_ITEM', p_comp_item);
6462: fnd_message.set_token ('ASSEMBLY_ITEM', p_assembly_item);
6463: fnd_message.set_token ('COMP_REV', p_comp_rev);
6464: RETURN fnd_message.get;

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

6457: RETURN VARCHAR2
6458: IS
6459: BEGIN
6460: fnd_message.set_name ('BOM', p_msg_name);
6461: fnd_message.set_token ('COMP_ITEM', p_comp_item);
6462: fnd_message.set_token ('ASSEMBLY_ITEM', p_assembly_item);
6463: fnd_message.set_token ('COMP_REV', p_comp_rev);
6464: RETURN fnd_message.get;
6465: END;

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

6458: IS
6459: BEGIN
6460: fnd_message.set_name ('BOM', p_msg_name);
6461: fnd_message.set_token ('COMP_ITEM', p_comp_item);
6462: fnd_message.set_token ('ASSEMBLY_ITEM', p_assembly_item);
6463: fnd_message.set_token ('COMP_REV', p_comp_rev);
6464: RETURN fnd_message.get;
6465: END;
6466:

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

6459: BEGIN
6460: fnd_message.set_name ('BOM', p_msg_name);
6461: fnd_message.set_token ('COMP_ITEM', p_comp_item);
6462: fnd_message.set_token ('ASSEMBLY_ITEM', p_assembly_item);
6463: fnd_message.set_token ('COMP_REV', p_comp_rev);
6464: RETURN fnd_message.get;
6465: END;
6466:
6467: FUNCTION get_cnt_message (

Line 6464: RETURN fnd_message.get;

6460: fnd_message.set_name ('BOM', p_msg_name);
6461: fnd_message.set_token ('COMP_ITEM', p_comp_item);
6462: fnd_message.set_token ('ASSEMBLY_ITEM', p_assembly_item);
6463: fnd_message.set_token ('COMP_REV', p_comp_rev);
6464: RETURN fnd_message.get;
6465: END;
6466:
6467: FUNCTION get_cnt_message (
6468: p_msg_name IN VARCHAR2,

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

6471: )
6472: RETURN VARCHAR2
6473: IS
6474: BEGIN
6475: fnd_message.set_name ('BOM', p_msg_name);
6476: fnd_message.set_token ('ASSEMBLY_ITEM', p_assembly_item);
6477: fnd_message.set_token ('COMP_CNT', p_comp_count);
6478: RETURN fnd_message.get;
6479: END;

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

6472: RETURN VARCHAR2
6473: IS
6474: BEGIN
6475: fnd_message.set_name ('BOM', p_msg_name);
6476: fnd_message.set_token ('ASSEMBLY_ITEM', p_assembly_item);
6477: fnd_message.set_token ('COMP_CNT', p_comp_count);
6478: RETURN fnd_message.get;
6479: END;
6480:

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

6473: IS
6474: BEGIN
6475: fnd_message.set_name ('BOM', p_msg_name);
6476: fnd_message.set_token ('ASSEMBLY_ITEM', p_assembly_item);
6477: fnd_message.set_token ('COMP_CNT', p_comp_count);
6478: RETURN fnd_message.get;
6479: END;
6480:
6481: PROCEDURE assign_items_to_copy_to_org (

Line 6478: RETURN fnd_message.get;

6474: BEGIN
6475: fnd_message.set_name ('BOM', p_msg_name);
6476: fnd_message.set_token ('ASSEMBLY_ITEM', p_assembly_item);
6477: fnd_message.set_token ('COMP_CNT', p_comp_count);
6478: RETURN fnd_message.get;
6479: END;
6480:
6481: PROCEDURE assign_items_to_copy_to_org (
6482: p_cp_request_id IN NUMBER,

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

6744: EXCEPTION
6745: WHEN OTHERS
6746: THEN
6747: err_msg := 'COPY_BILL ( assign_items_to_org )' || SQLERRM;
6748: fnd_message.set_name ('BOM', 'BOM_SQL_ERR');
6749: fnd_message.set_token ('ENTITY', err_msg);
6750: ROLLBACK TO begin_assign_items_to_org;
6751: app_exception.raise_exception;
6752: END assign_items_to_copy_to_org;

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

6745: WHEN OTHERS
6746: THEN
6747: err_msg := 'COPY_BILL ( assign_items_to_org )' || SQLERRM;
6748: fnd_message.set_name ('BOM', 'BOM_SQL_ERR');
6749: fnd_message.set_token ('ENTITY', err_msg);
6750: ROLLBACK TO begin_assign_items_to_org;
6751: app_exception.raise_exception;
6752: END assign_items_to_copy_to_org;
6753:

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

6922: l_index := x_org_list_tbl.next(l_index);
6923: x_return_status := fnd_api.G_RET_STS_SUCCESS;
6924: EXCEPTION
6925: WHEN NO_DATA_FOUND THEN
6926: fnd_message.set_name ('BOM', 'BOM_CPY_IP_NO_ORG_IN_HRCHY');
6927: x_return_status := fnd_api.G_RET_STS_ERROR;
6928: x_error_msg := fnd_message.get;
6929: RETURN;
6930: END;

Line 6928: x_error_msg := fnd_message.get;

6924: EXCEPTION
6925: WHEN NO_DATA_FOUND THEN
6926: fnd_message.set_name ('BOM', 'BOM_CPY_IP_NO_ORG_IN_HRCHY');
6927: x_return_status := fnd_api.G_RET_STS_ERROR;
6928: x_error_msg := fnd_message.get;
6929: RETURN;
6930: END;
6931: END LOOP;
6932: END IF;

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

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

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

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

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

10877: NULL;
10878: WHEN OTHERS
10879: THEN
10880: err_msg := 'COPY_BILL (' || sql_stmt_num || ') ' || SQLERRM;
10881: fnd_message.set_name ('BOM', 'BOM_SQL_ERR');
10882: fnd_message.set_token ('ENTITY', err_msg);
10883: ROLLBACK TO begin_bill_copy;
10884: app_exception.raise_exception;
10885: END;

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

10878: WHEN OTHERS
10879: THEN
10880: err_msg := 'COPY_BILL (' || sql_stmt_num || ') ' || SQLERRM;
10881: fnd_message.set_name ('BOM', 'BOM_SQL_ERR');
10882: fnd_message.set_token ('ENTITY', err_msg);
10883: ROLLBACK TO begin_bill_copy;
10884: app_exception.raise_exception;
10885: END;
10886: END IF;

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

11635: EXCEPTION
11636: WHEN overlap_error
11637: THEN
11638: bom_globals.g_skip_bomtbicx := 'N';
11639: fnd_message.set_name ('BOM', 'BOM_BAD_COPY_GUI');
11640:
11641: INSERT INTO mtl_interface_errors
11642: (unique_id,
11643: organization_id,

Line 11667: fnd_message.get,

11663: get_current_item_rev (to_item_id,
11664: from_org_id,
11665: SYSDATE
11666: ),
11667: fnd_message.get,
11668: 'BOM_COPY',
11669: SYSDATE,
11670: user_id,
11671: SYSDATE,

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

11678: );
11679: WHEN common_error
11680: THEN
11681: bom_globals.g_skip_bomtbicx := 'N';
11682: fnd_message.set_name ('BOM', 'BOM_COMMON_OTHER_ORGS2');
11683:
11684: INSERT INTO mtl_interface_errors
11685: (unique_id,
11686: organization_id,

Line 11710: fnd_message.get,

11706: get_current_item_rev (to_item_id,
11707: from_org_id,
11708: SYSDATE
11709: ),
11710: fnd_message.get,
11711: 'BOM_COPY',
11712: SYSDATE,
11713: user_id,
11714: SYSDATE,

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

11722: WHEN OTHERS
11723: THEN
11724: bom_globals.g_skip_bomtbicx := 'N';
11725: err_msg := 'copy_bill_for_revised_item (' || sql_stmt_num || ') ' || SQLERRM;
11726: fnd_message.set_name ('BOM', 'BOM_SQL_ERR');
11727: fnd_message.set_token ('ENTITY', err_msg);
11728: ROLLBACK TO begin_revised_item_bill_copy;
11729: app_exception.raise_exception;
11730: END copy_bill_for_revised_item;

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

11723: THEN
11724: bom_globals.g_skip_bomtbicx := 'N';
11725: err_msg := 'copy_bill_for_revised_item (' || sql_stmt_num || ') ' || SQLERRM;
11726: fnd_message.set_name ('BOM', 'BOM_SQL_ERR');
11727: fnd_message.set_token ('ENTITY', err_msg);
11728: ROLLBACK TO begin_revised_item_bill_copy;
11729: app_exception.raise_exception;
11730: END copy_bill_for_revised_item;
11731:

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

11760: p_component_item IN VARCHAR2, p_component_item_type IN VARCHAR2)
11761: RETURN VARCHAR2
11762: IS
11763: BEGIN
11764: fnd_message.set_name('BOM',p_msg_name);
11765: fnd_message.set_token('PARENT_ITEM_NAME',p_assembly_item);
11766: fnd_message.set_token('PARENT_ITEM_TYPE',p_parent_item_type);
11767: fnd_message.set_token('COMPONENT_ITEM_NAME',p_component_item);
11768: fnd_message.set_token('COMPONENT_ITEM_TYPE',p_component_item_type);

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

11761: RETURN VARCHAR2
11762: IS
11763: BEGIN
11764: fnd_message.set_name('BOM',p_msg_name);
11765: fnd_message.set_token('PARENT_ITEM_NAME',p_assembly_item);
11766: fnd_message.set_token('PARENT_ITEM_TYPE',p_parent_item_type);
11767: fnd_message.set_token('COMPONENT_ITEM_NAME',p_component_item);
11768: fnd_message.set_token('COMPONENT_ITEM_TYPE',p_component_item_type);
11769: RETURN fnd_message.get;

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

11762: IS
11763: BEGIN
11764: fnd_message.set_name('BOM',p_msg_name);
11765: fnd_message.set_token('PARENT_ITEM_NAME',p_assembly_item);
11766: fnd_message.set_token('PARENT_ITEM_TYPE',p_parent_item_type);
11767: fnd_message.set_token('COMPONENT_ITEM_NAME',p_component_item);
11768: fnd_message.set_token('COMPONENT_ITEM_TYPE',p_component_item_type);
11769: RETURN fnd_message.get;
11770: END get_comp_type_rule_message;

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

11763: BEGIN
11764: fnd_message.set_name('BOM',p_msg_name);
11765: fnd_message.set_token('PARENT_ITEM_NAME',p_assembly_item);
11766: fnd_message.set_token('PARENT_ITEM_TYPE',p_parent_item_type);
11767: fnd_message.set_token('COMPONENT_ITEM_NAME',p_component_item);
11768: fnd_message.set_token('COMPONENT_ITEM_TYPE',p_component_item_type);
11769: RETURN fnd_message.get;
11770: END get_comp_type_rule_message;
11771:

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

11764: fnd_message.set_name('BOM',p_msg_name);
11765: fnd_message.set_token('PARENT_ITEM_NAME',p_assembly_item);
11766: fnd_message.set_token('PARENT_ITEM_TYPE',p_parent_item_type);
11767: fnd_message.set_token('COMPONENT_ITEM_NAME',p_component_item);
11768: fnd_message.set_token('COMPONENT_ITEM_TYPE',p_component_item_type);
11769: RETURN fnd_message.get;
11770: END get_comp_type_rule_message;
11771:
11772: -- Start of comments

Line 11769: RETURN fnd_message.get;

11765: fnd_message.set_token('PARENT_ITEM_NAME',p_assembly_item);
11766: fnd_message.set_token('PARENT_ITEM_TYPE',p_parent_item_type);
11767: fnd_message.set_token('COMPONENT_ITEM_NAME',p_component_item);
11768: fnd_message.set_token('COMPONENT_ITEM_TYPE',p_component_item_type);
11769: RETURN fnd_message.get;
11770: END get_comp_type_rule_message;
11771:
11772: -- Start of comments
11773: -- API name : check_component_type_rules