APPS.CTO_UPDATE_BOM_RTG_PK dependencies on CTO_MSG_PUB

Line 808: cto_msg_pub.cto_message('BOM','CTO_BOM_NOT_DEFINED');

804: **
805: ** In either case the error will be caught if the bom
806: ** was not created even in a single org.
807:
808: cto_msg_pub.cto_message('BOM','CTO_BOM_NOT_DEFINED');
809: raise fnd_api.g_exc_error;
810: */
811: end if; -- end check model bom
812:

Line 832: cto_msg_pub.count_and_get

828:
829: WHEN fnd_api.g_exc_error THEN
830: WriteToLog('Expected error in update_in_src_orgs: '||to_char(lStmtNum)||'::'||sqlerrm, 1);
831: xReturnStatus := fnd_api.g_ret_sts_error;
832: cto_msg_pub.count_and_get
833: ( p_msg_count => xMsgCount
834: , p_msg_data => xMsgData
835: );
836:

Line 840: cto_msg_pub.count_and_get

836:
837: WHEN fnd_api.g_exc_unexpected_error THEN
838: WriteToLog('Unexpected error in update_in_src_orgs: '||to_char(lStmtNum)||'::'||sqlerrm, 1);
839: xReturnStatus := fnd_api.g_ret_sts_unexp_error ;
840: cto_msg_pub.count_and_get
841: ( p_msg_count => xMsgCount
842: , p_msg_data => xMsgData
843: );
844:

Line 848: cto_msg_pub.count_and_get

844:
845: WHEN OTHERS then
846: WriteToLog('Others error in update_in_src_orgs: '||to_char(lStmtNum)||'::'||sqlerrm, 1);
847: xReturnStatus := fnd_api.g_ret_sts_unexp_error;
848: cto_msg_pub.count_and_get
849: ( p_msg_count => xMsgCount
850: , p_msg_data => xMsgData
851: );
852:

Line 903: l_token CTO_MSG_PUB.token_tbl;

899: v_model varchar2(50);
900: v_config varchar2(50);
901: v_missed_line_number varchar2(50);
902: v_order_number number;
903: l_token CTO_MSG_PUB.token_tbl;
904: lcreate_item number; -- 2986192
905: lorg_code varchar2(3); -- 2986192
906:
907: /* Cursor to select dropped lines */

Line 1146: l_token1 CTO_MSG_PUB.token_tbl;

1142:
1143:
1144:
1145: v_zero_qty_count number ;
1146: l_token1 CTO_MSG_PUB.token_tbl;
1147: v_model_item_name varchar2(2000) ;
1148:
1149: /* end 02-14-2005 Sushant */
1150:

Line 1191: l_token2 CTO_MSG_PUB.token_tbl;

1187:
1188: --- End Renga
1189:
1190: l_batch_id Number;
1191: l_token2 CTO_MSG_PUB.token_tbl;
1192:
1193: BEGIN
1194:
1195: WriteToLog('Entering Update_Bom_Rtg_Loop', 2);

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

1491: l_token1(1).token_name := 'MODEL_NAME';
1492: l_token1(1).token_value := v_model_item_name ;
1493:
1494:
1495: cto_msg_pub.cto_message('BOM','CTO_ZERO_BOM_COMP', l_token1 );
1496:
1497: raise fnd_api.g_exc_error;
1498:
1499:

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

1796: ' ' || v_t_overlap_src_disable_date(i) , 1);
1797:
1798: END IF;
1799:
1800: cto_msg_pub.cto_message('BOM','CTO_OVERLAP_DATE_ERROR');
1801:
1802: end loop ;
1803:
1804: raise fnd_api.g_exc_error;

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

4063: l_token(2).token_name := 'ORGANIZATION';
4064: l_token(2).token_value := l_org_name;
4065: l_token(3).token_name := 'COMPONENT';
4066: l_token(3).token_value := l_comp_name;
4067: cto_msg_pub.cto_message('BOM','CTO_CLUB_COMP_ERROR',l_token);
4068:
4069:
4070:
4071: raise fnd_api.g_exc_error;

Line 5779: cto_msg_pub.count_and_get

5775: WriteToLog('++++++++++++++++++++++++++++++++++++++++++++++++', 1);
5776: WriteToLog('ERROR: Others error in Update_Bom_Rtg_Bulk::'||to_char(lStmtNum)||sqlerrm,1);
5777: WriteToLog('++++++++++++++++++++++++++++++++++++++++++++++++', 1);
5778: xReturnStatus := fnd_api.g_ret_sts_unexp_error;
5779: cto_msg_pub.count_and_get
5780: ( p_msg_count => xMsgCount
5781: , p_msg_data => xMsgData
5782: );
5783:

Line 5976: l_token1 CTO_MSG_PUB.token_tbl;

5972: lCnt number;
5973:
5974: /* begin 04-04-2005 */
5975: v_zero_qty_count number ;
5976: l_token1 CTO_MSG_PUB.token_tbl;
5977: v_model_item_name varchar2(2000) ;
5978: /* end 04-04-2005 */
5979:
5980:

Line 5995: l_token2 CTO_MSG_PUB.token_tbl;

5991: v_t_overlap_dest_op_seq_num num_tab;
5992: v_t_overlap_dest_eff_date date_tab;
5993: v_t_overlap_dest_disable_date date_tab;
5994:
5995: l_token2 CTO_MSG_PUB.token_tbl;
5996:
5997:
5998: BEGIN
5999:

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

6201: l_token1(1).token_name := 'MODEL_NAME';
6202: l_token1(1).token_value := v_model_item_name ;
6203:
6204:
6205: cto_msg_pub.cto_message('BOM','CTO_ZERO_BOM_COMP' , l_token1 );
6206:
6207: raise fnd_api.g_exc_error;
6208:
6209:

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

6749:
6750: l_token1(2).token_name := 'MODEL';
6751: l_token1(2).token_value := v_model_item_name ;
6752:
6753: cto_msg_pub.cto_message('BOM','CTO_OVERLAP_DATE_ERROR');
6754: end loop ;
6755:
6756: raise fnd_api.g_exc_error;
6757: