APPS.CTO_UPDATE_BOM_RTG_PK dependencies on CTO_MSG_PUB

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

747: **
748: ** In either case the error will be caught if the bom
749: ** was not created even in a single org.
750:
751: cto_msg_pub.cto_message('BOM','CTO_BOM_NOT_DEFINED');
752: raise fnd_api.g_exc_error;
753: */
754: end if; -- end check model bom
755:

Line 775: cto_msg_pub.count_and_get

771:
772: WHEN fnd_api.g_exc_error THEN
773: WriteToLog('Expected error in update_in_src_orgs: '||to_char(lStmtNum)||'::'||sqlerrm, 1);
774: xReturnStatus := fnd_api.g_ret_sts_error;
775: cto_msg_pub.count_and_get
776: ( p_msg_count => xMsgCount
777: , p_msg_data => xMsgData
778: );
779:

Line 783: cto_msg_pub.count_and_get

779:
780: WHEN fnd_api.g_exc_unexpected_error THEN
781: WriteToLog('Unexpected error in update_in_src_orgs: '||to_char(lStmtNum)||'::'||sqlerrm, 1);
782: xReturnStatus := fnd_api.g_ret_sts_unexp_error ;
783: cto_msg_pub.count_and_get
784: ( p_msg_count => xMsgCount
785: , p_msg_data => xMsgData
786: );
787:

Line 791: cto_msg_pub.count_and_get

787:
788: WHEN OTHERS then
789: WriteToLog('Others error in update_in_src_orgs: '||to_char(lStmtNum)||'::'||sqlerrm, 1);
790: xReturnStatus := fnd_api.g_ret_sts_unexp_error;
791: cto_msg_pub.count_and_get
792: ( p_msg_count => xMsgCount
793: , p_msg_data => xMsgData
794: );
795:

Line 846: l_token CTO_MSG_PUB.token_tbl;

842: v_model varchar2(50);
843: v_config varchar2(50);
844: v_missed_line_number varchar2(50);
845: v_order_number number;
846: l_token CTO_MSG_PUB.token_tbl;
847: lcreate_item number; -- 2986192
848: lorg_code varchar2(3); -- 2986192
849:
850: /* Cursor to select dropped lines */

Line 1087: l_token1 CTO_MSG_PUB.token_tbl;

1083:
1084:
1085:
1086: v_zero_qty_count number ;
1087: l_token1 CTO_MSG_PUB.token_tbl;
1088: v_model_item_name varchar2(2000) ;
1089:
1090: /* end 02-14-2005 Sushant */
1091:

Line 1132: l_token2 CTO_MSG_PUB.token_tbl;

1128:
1129: --- End Renga
1130:
1131: l_batch_id Number;
1132: l_token2 CTO_MSG_PUB.token_tbl;
1133:
1134: BEGIN
1135:
1136: WriteToLog('Entering Update_Bom_Rtg_Loop', 2);

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

1432: l_token1(1).token_name := 'MODEL_NAME';
1433: l_token1(1).token_value := v_model_item_name ;
1434:
1435:
1436: cto_msg_pub.cto_message('BOM','CTO_ZERO_BOM_COMP', l_token1 );
1437:
1438: raise fnd_api.g_exc_error;
1439:
1440:

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

1737: ' ' || v_t_overlap_src_disable_date(i) , 1);
1738:
1739: END IF;
1740:
1741: cto_msg_pub.cto_message('BOM','CTO_OVERLAP_DATE_ERROR');
1742:
1743: end loop ;
1744:
1745: raise fnd_api.g_exc_error;

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

3896: l_token(2).token_name := 'ORGANIZATION';
3897: l_token(2).token_value := l_org_name;
3898: l_token(3).token_name := 'COMPONENT';
3899: l_token(3).token_value := l_comp_name;
3900: cto_msg_pub.cto_message('BOM','CTO_CLUB_COMP_ERROR',l_token);
3901:
3902:
3903:
3904: raise fnd_api.g_exc_error;

Line 5570: cto_msg_pub.count_and_get

5566: WriteToLog('++++++++++++++++++++++++++++++++++++++++++++++++', 1);
5567: WriteToLog('ERROR: Others error in Update_Bom_Rtg_Bulk::'||to_char(lStmtNum)||sqlerrm,1);
5568: WriteToLog('++++++++++++++++++++++++++++++++++++++++++++++++', 1);
5569: xReturnStatus := fnd_api.g_ret_sts_unexp_error;
5570: cto_msg_pub.count_and_get
5571: ( p_msg_count => xMsgCount
5572: , p_msg_data => xMsgData
5573: );
5574:

Line 5767: l_token1 CTO_MSG_PUB.token_tbl;

5763: lCnt number;
5764:
5765: /* begin 04-04-2005 */
5766: v_zero_qty_count number ;
5767: l_token1 CTO_MSG_PUB.token_tbl;
5768: v_model_item_name varchar2(2000) ;
5769: /* end 04-04-2005 */
5770:
5771:

Line 5786: l_token2 CTO_MSG_PUB.token_tbl;

5782: v_t_overlap_dest_op_seq_num num_tab;
5783: v_t_overlap_dest_eff_date date_tab;
5784: v_t_overlap_dest_disable_date date_tab;
5785:
5786: l_token2 CTO_MSG_PUB.token_tbl;
5787:
5788:
5789: BEGIN
5790:

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

5992: l_token1(1).token_name := 'MODEL_NAME';
5993: l_token1(1).token_value := v_model_item_name ;
5994:
5995:
5996: cto_msg_pub.cto_message('BOM','CTO_ZERO_BOM_COMP' , l_token1 );
5997:
5998: raise fnd_api.g_exc_error;
5999:
6000:

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

6537:
6538: l_token1(2).token_name := 'MODEL';
6539: l_token1(2).token_value := v_model_item_name ;
6540:
6541: cto_msg_pub.cto_message('BOM','CTO_OVERLAP_DATE_ERROR');
6542: end loop ;
6543:
6544: raise fnd_api.g_exc_error;
6545: