DBA Data[Home] [Help]

APPS.CTO_CONFIG_BOM_PK dependencies on CTO_MSG_PUB

Line 271: l_token CTO_MSG_PUB.token_tbl;

267: v_config_item varchar2(50);
268: v_model varchar2(50);
269: v_missed_line_number varchar2(50);
270: v_order_number number;
271: l_token CTO_MSG_PUB.token_tbl;
272: lcreate_item number; -- 2986192
273: lorg_code varchar2(3); -- 2986192
274:
275: /* Cursor to select dropped lines */

Line 332: l_token1 CTO_MSG_PUB.token_tbl;

328:
329:
330: v_recipient varchar2(100) ;
331:
332: l_token1 CTO_MSG_PUB.token_tbl;
333: v_model_item_name varchar2(2000) ;
334:
335:
336:

Line 367: l_token2 CTO_MSG_PUB.token_tbl;

363: select component_item_id,component_sequence_id,operation_seq_num,effectivity_date,disable_date
364: from bom_inventory_comps_interface
365: where bill_sequence_id = lConfigBillId --Bugfix 6603382: So that components belonging to this bill only are picked up
366: order by component_item_id,operation_seq_num,effectivity_Date,disable_date;
367: l_token2 CTO_MSG_PUB.token_tbl;
368: l_model_name varchar2(1000);
369:
370: test_var number; --Bug 7418622.FP for 7154767
371:

Line 514: cto_msg_pub.cto_message('BOM','CTO_VALIDATION_ORG_NOT_SET');

510:
511: end if ;
512:
513: if (lOEValidationOrg = -99) then --bugfix 2646849
514: cto_msg_pub.cto_message('BOM','CTO_VALIDATION_ORG_NOT_SET');
515: raise FND_API.G_EXC_ERROR;
516: end if;
517:
518: IF PG_DEBUG <> 0 THEN

Line 893: cto_msg_pub.cto_message('BOM','CTO_ZERO_BOM_COMP', l_token1 );

889: l_token1(1).token_name := 'MODEL_NAME';
890: l_token1(1).token_value := v_model_item_name ;
891:
892:
893: cto_msg_pub.cto_message('BOM','CTO_ZERO_BOM_COMP', l_token1 );
894:
895: raise fnd_api.g_exc_error;
896:
897:

Line 1258: cto_msg_pub.cto_message('BOM','CTO_OVERLAP_DATE_ERROR',l_token2);

1254: and rownum=1;
1255:
1256: l_token2(1).token_name :='MODEL';
1257: l_token2(1).token_value :=l_model_name;
1258: cto_msg_pub.cto_message('BOM','CTO_OVERLAP_DATE_ERROR',l_token2);
1259:
1260: end loop ;
1261:
1262: raise fnd_api.g_exc_error;

Line 1417: cto_msg_pub.cto_message('BOM','CTO_DROP_ITEM_FROM_CONFIG',l_token);

1413: l_token(4).token_value := v_model;
1414: l_token(5).token_name := 'ORDER_NUMBER';
1415: l_token(5).token_value := v_order_number;
1416:
1417: cto_msg_pub.cto_message('BOM','CTO_DROP_ITEM_FROM_CONFIG',l_token);
1418:
1419: */
1420:
1421:

Line 1444: cto_msg_pub.cto_message('BOM','CTO_DO_NOT_CREATE_ITEM',l_token);

1440: l_token(4).token_value := v_model;
1441: l_token(5).token_name := 'ORDER_NUMBER';
1442: l_token(5).token_value := v_order_number;
1443:
1444: cto_msg_pub.cto_message('BOM','CTO_DO_NOT_CREATE_ITEM',l_token);
1445: */
1446:
1447: end if;
1448:

Line 1745: cto_msg_pub.cto_message('BOM','CTO_AC_DROP_ITEM_FROM_CONFIG',l_token);

1741: l_token(4).token_name := 'CONFIG_NAME';
1742: l_token(4).token_value := v_problem_config;
1743: l_token(5).token_name := 'ERROR_MESSAGE';
1744: l_token(5).token_value := v_ac_message_string ;
1745: cto_msg_pub.cto_message('BOM','CTO_AC_DROP_ITEM_FROM_CONFIG',l_token);
1746:
1747:
1748: else
1749:

Line 1894: cto_msg_pub.cto_message('BOM','CTO_AC_DO_NOT_CREATE_ITEM',l_token);

1890: l_token(3).token_value := v_error_org;
1891: l_token(4).token_name := 'ERROR_MESSAGE';
1892: l_token(4).token_value := v_ac_message_string ;
1893:
1894: cto_msg_pub.cto_message('BOM','CTO_AC_DO_NOT_CREATE_ITEM',l_token);
1895:
1896: -- Bugfix 4084568: Adding message for model line on Hold.
1897:
1898: cto_msg_pub.cto_message('BOM','CTO_MODEL_LINE_EXCPN_HOLD');

Line 1898: cto_msg_pub.cto_message('BOM','CTO_MODEL_LINE_EXCPN_HOLD');

1894: cto_msg_pub.cto_message('BOM','CTO_AC_DO_NOT_CREATE_ITEM',l_token);
1895:
1896: -- Bugfix 4084568: Adding message for model line on Hold.
1897:
1898: cto_msg_pub.cto_message('BOM','CTO_MODEL_LINE_EXCPN_HOLD');
1899:
1900:
1901:
1902: raise fnd_api.g_exc_error;

Line 2279: l_token CTO_MSG_PUB.token_tbl;

2275: v_sub_diff_basis_string varchar2(2000);
2276:
2277: l_new_line varchar2(10) := fnd_global.local_chr(10);
2278:
2279: l_token CTO_MSG_PUB.token_tbl;
2280: basis_model_comp_seq_id_arr seq_tab;
2281: basis_component_item_id_arr seq_tab;
2282: l_model_name varchar2(1000);
2283: l_comp_name varchar2(1000);

Line 2545: --cto_msg_pub.cto_message('BOM','CTO_CLUB_COMP_ERROR',l_token);

2541: l_token(2).token_name := 'ORGANIZATION';
2542: l_token(2).token_value := l_org_name;
2543: l_token(3).token_name := 'COMPONENT';
2544: l_token(3).token_value := l_comp_name;
2545: --cto_msg_pub.cto_message('BOM','CTO_CLUB_COMP_ERROR',l_token);
2546: cto_msg_pub.cto_message('BOM','CTO_CLUB_COMP_ERROR',l_token);
2547:
2548:
2549: raise fnd_api.g_exc_error;

Line 2546: cto_msg_pub.cto_message('BOM','CTO_CLUB_COMP_ERROR',l_token);

2542: l_token(2).token_value := l_org_name;
2543: l_token(3).token_name := 'COMPONENT';
2544: l_token(3).token_value := l_comp_name;
2545: --cto_msg_pub.cto_message('BOM','CTO_CLUB_COMP_ERROR',l_token);
2546: cto_msg_pub.cto_message('BOM','CTO_CLUB_COMP_ERROR',l_token);
2547:
2548:
2549: raise fnd_api.g_exc_error;
2550:

Line 4175: l_token1 CTO_MSG_PUB.token_tbl;

4171:
4172: v_zero_qty_count number ;
4173: v_zero_qty_component number ;
4174:
4175: l_token1 CTO_MSG_PUB.token_tbl;
4176: v_model_item_name varchar2(2000) ;
4177:
4178:
4179: v_overlap_check number := 0 ;

Line 4191: l_token2 CTO_MSG_PUB.token_tbl;

4187: v_t_overlap_src_disable_date date_tab;
4188: v_t_overlap_dest_op_seq_num num_tab;
4189: v_t_overlap_dest_eff_date date_tab;
4190: v_t_overlap_dest_disable_date date_tab;
4191: l_token2 CTO_MSG_PUB.token_tbl;
4192: l_model_name varchar2(1000);
4193:
4194: test_var number; --Bug 7418622.FP for 7154767
4195:

Line 4406: cto_msg_pub.cto_message('BOM','CTO_ZERO_BOM_COMP' , l_token1 );

4402:
4403: l_token1(1).token_name := 'MODEL_NAME';
4404: l_token1(1).token_value := v_model_item_name ;
4405:
4406: cto_msg_pub.cto_message('BOM','CTO_ZERO_BOM_COMP' , l_token1 );
4407:
4408: raise fnd_api.g_exc_error;
4409: end if ;
4410:

Line 5138: cto_msg_pub.cto_message('BOM','CTO_OVERLAP_DATE_ERROR',l_token2);

5134: and rownum=1;
5135:
5136: l_token2(1).token_name :='MODEL';
5137: l_token2(1).token_value :=l_model_name;
5138: cto_msg_pub.cto_message('BOM','CTO_OVERLAP_DATE_ERROR',l_token2);
5139: end loop ;
5140:
5141: raise fnd_api.g_exc_error;
5142: end if ;

Line 5239: cto_msg_pub.cto_message('BOM', 'CTO_CREATE_BOM_ERROR');

5235: when others then
5236: IF PG_DEBUG <> 0 THEN
5237: oe_debug_pub.add ('check_bom: ' || 'Others exception for Check BOM::item id '||to_char(pItemId), 1);
5238: END IF;
5239: cto_msg_pub.cto_message('BOM', 'CTO_CREATE_BOM_ERROR');
5240: return(0);
5241:
5242: end check_bom;
5243:

Line 5475: cto_msg_pub.cto_message ('BOM', 'CTO_INVALID_CATALOG_GRP');

5471: err_buf := 'CTOCBOMB: Invalid catalog group for the item ' || item_id || ' status:' || status;
5472: IF PG_DEBUG <> 0 THEN
5473: oe_debug_pub.add ('bmlupid_update_item_desc: ' || err_buf, 1);
5474: END IF;
5475: cto_msg_pub.cto_message ('BOM', 'CTO_INVALID_CATALOG_GRP');
5476: return(1);
5477:
5478: when OTHERS then
5479: err_buf := 'CTOCBOMB: ' || lStmtNum ||substrb(SQLERRM,1,150);

Line 5483: cto_msg_pub.cto_message ('BOM', 'CTO_CREATE_BOM_ERROR');

5479: err_buf := 'CTOCBOMB: ' || lStmtNum ||substrb(SQLERRM,1,150);
5480: IF PG_DEBUG <> 0 THEN
5481: oe_debug_pub.add ('bmlupid_update_item_desc: ' || err_buf, 1);
5482: END IF;
5483: cto_msg_pub.cto_message ('BOM', 'CTO_CREATE_BOM_ERROR');
5484: return(1);
5485:
5486: END bmlupid_update_item_desc;
5487: