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: BEGIN
371:

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

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

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

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

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

1228: and rownum=1;
1229:
1230: l_token2(1).token_name :='MODEL';
1231: l_token2(1).token_value :=l_model_name;
1232: cto_msg_pub.cto_message('BOM','CTO_OVERLAP_DATE_ERROR',l_token2);
1233:
1234: end loop ;
1235:
1236: raise fnd_api.g_exc_error;

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

1387: l_token(4).token_value := v_model;
1388: l_token(5).token_name := 'ORDER_NUMBER';
1389: l_token(5).token_value := v_order_number;
1390:
1391: cto_msg_pub.cto_message('BOM','CTO_DROP_ITEM_FROM_CONFIG',l_token);
1392:
1393: */
1394:
1395:

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

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

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

1715: l_token(4).token_name := 'CONFIG_NAME';
1716: l_token(4).token_value := v_problem_config;
1717: l_token(5).token_name := 'ERROR_MESSAGE';
1718: l_token(5).token_value := v_ac_message_string ;
1719: cto_msg_pub.cto_message('BOM','CTO_AC_DROP_ITEM_FROM_CONFIG',l_token);
1720:
1721:
1722: else
1723:

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

1864: l_token(3).token_value := v_error_org;
1865: l_token(4).token_name := 'ERROR_MESSAGE';
1866: l_token(4).token_value := v_ac_message_string ;
1867:
1868: cto_msg_pub.cto_message('BOM','CTO_AC_DO_NOT_CREATE_ITEM',l_token);
1869:
1870: -- Bugfix 4084568: Adding message for model line on Hold.
1871:
1872: cto_msg_pub.cto_message('BOM','CTO_MODEL_LINE_EXCPN_HOLD');

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

1868: cto_msg_pub.cto_message('BOM','CTO_AC_DO_NOT_CREATE_ITEM',l_token);
1869:
1870: -- Bugfix 4084568: Adding message for model line on Hold.
1871:
1872: cto_msg_pub.cto_message('BOM','CTO_MODEL_LINE_EXCPN_HOLD');
1873:
1874:
1875:
1876: raise fnd_api.g_exc_error;

Line 2239: l_token CTO_MSG_PUB.token_tbl;

2235: v_sub_diff_basis_string varchar2(2000);
2236:
2237: l_new_line varchar2(10) := fnd_global.local_chr(10);
2238:
2239: l_token CTO_MSG_PUB.token_tbl;
2240: basis_model_comp_seq_id_arr seq_tab;
2241: basis_component_item_id_arr seq_tab;
2242: l_model_name varchar2(1000);
2243: l_comp_name varchar2(1000);

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

2481: l_token(2).token_name := 'ORGANIZATION';
2482: l_token(2).token_value := l_org_name;
2483: l_token(3).token_name := 'COMPONENT';
2484: l_token(3).token_value := l_comp_name;
2485: --cto_msg_pub.cto_message('BOM','CTO_CLUB_COMP_ERROR',l_token);
2486: cto_msg_pub.cto_message('BOM','CTO_CLUB_COMP_ERROR',l_token);
2487:
2488:
2489: raise fnd_api.g_exc_error;

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

2482: l_token(2).token_value := l_org_name;
2483: l_token(3).token_name := 'COMPONENT';
2484: l_token(3).token_value := l_comp_name;
2485: --cto_msg_pub.cto_message('BOM','CTO_CLUB_COMP_ERROR',l_token);
2486: cto_msg_pub.cto_message('BOM','CTO_CLUB_COMP_ERROR',l_token);
2487:
2488:
2489: raise fnd_api.g_exc_error;
2490:

Line 3997: l_token1 CTO_MSG_PUB.token_tbl;

3993: v_zero_qty_count number ;
3994: v_zero_qty_component number ;
3995:
3996:
3997: l_token1 CTO_MSG_PUB.token_tbl;
3998: v_model_item_name varchar2(2000) ;
3999:
4000:
4001: v_overlap_check number := 0 ;

Line 4013: l_token2 CTO_MSG_PUB.token_tbl;

4009: v_t_overlap_src_disable_date date_tab;
4010: v_t_overlap_dest_op_seq_num num_tab;
4011: v_t_overlap_dest_eff_date date_tab;
4012: v_t_overlap_dest_disable_date date_tab;
4013: l_token2 CTO_MSG_PUB.token_tbl;
4014: l_model_name varchar2(1000);
4015:
4016: BEGIN
4017:

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

4230: l_token1(1).token_name := 'MODEL_NAME';
4231: l_token1(1).token_value := v_model_item_name ;
4232:
4233:
4234: cto_msg_pub.cto_message('BOM','CTO_ZERO_BOM_COMP' , l_token1 );
4235:
4236: raise fnd_api.g_exc_error;
4237:
4238:

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

4806: and rownum=1;
4807:
4808: l_token2(1).token_name :='MODEL';
4809: l_token2(1).token_value :=l_model_name;
4810: cto_msg_pub.cto_message('BOM','CTO_OVERLAP_DATE_ERROR',l_token2);
4811: end loop ;
4812:
4813: raise fnd_api.g_exc_error;
4814:

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

4923: when others then
4924: IF PG_DEBUG <> 0 THEN
4925: oe_debug_pub.add ('check_bom: ' || 'Others exception for Check BOM::item id '||to_char(pItemId), 1);
4926: END IF;
4927: cto_msg_pub.cto_message('BOM', 'CTO_CREATE_BOM_ERROR');
4928: return(0);
4929:
4930: end check_bom;
4931:

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

5159: err_buf := 'CTOCBOMB: Invalid catalog group for the item ' || item_id || ' status:' || status;
5160: IF PG_DEBUG <> 0 THEN
5161: oe_debug_pub.add ('bmlupid_update_item_desc: ' || err_buf, 1);
5162: END IF;
5163: cto_msg_pub.cto_message ('BOM', 'CTO_INVALID_CATALOG_GRP');
5164: return(1);
5165:
5166: when OTHERS then
5167: err_buf := 'CTOCBOMB: ' || lStmtNum ||substrb(SQLERRM,1,150);

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

5167: err_buf := 'CTOCBOMB: ' || lStmtNum ||substrb(SQLERRM,1,150);
5168: IF PG_DEBUG <> 0 THEN
5169: oe_debug_pub.add ('bmlupid_update_item_desc: ' || err_buf, 1);
5170: END IF;
5171: cto_msg_pub.cto_message ('BOM', 'CTO_CREATE_BOM_ERROR');
5172: return(1);
5173:
5174: END bmlupid_update_item_desc;
5175: