eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CTO_MSUTIL_PUB dependencies on CTO_MSUTIL_PUB

Line 1: package body CTO_MSUTIL_PUB as

1: package body CTO_MSUTIL_PUB as
2: /* $Header: CTOMSUTB.pls 120.17.12020000.3 2013/03/21 11:47:04 abhissri ship $*/
3:
4: /*----------------------------------------------------------------------------+
5: | Copyright (c) 1993 Oracle Corporation Belmont, California, USA

Line 71: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CTO_MSUTIL_PUB';

67: | Modified : 05-Jul-2005 Renga Kannan
68: | Modified for MOAC project
69: +-----------------------------------------------------------------------------*/
70:
71: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CTO_MSUTIL_PUB';
72: TYPE TAB_BCOL is TABLE of bom_cto_order_lines%rowtype index by binary_integer ;
73: gMrpAssignmentSet number ;
74:
75: gUserId number := nvl(fnd_global.user_id, -1);

Line 191: v_t_org_list CTO_MSUTIL_PUB.org_list;

187: and ato_line_id = pTopAtoLineId order by plan_level ;
188:
189:
190:
191: v_t_org_list CTO_MSUTIL_PUB.org_list;
192:
193: v_current_model_line_id number ;
194: v_current_model_item_id number ;
195: v_config_creation bom_cto_order_lines.config_creation%type ;

Line 200: x_orgs_list CTO_MSUTIL_PUB.org_list;

196:
197:
198: v_group_reference_id number ;
199: v_orgs_list cto_oss_source_pk.orgs_list ;
200: x_orgs_list CTO_MSUTIL_PUB.org_list;
201:
202: BEGIN
203:
204: IF PG_DEBUG <> 0 THEN

Line 332: CTO_MSUTIL_PUB.insert_type3_bcso( pTopAtoLineId

328:
329:
330: oe_debug_pub.add( '$$$$$$$$ GOING TO CALL insert_type3_bcso ' || v_model_lines.line_id , 1 ) ;
331:
332: CTO_MSUTIL_PUB.insert_type3_bcso( pTopAtoLineId
333: , v_model_lines.line_id
334: , v_model_lines.inventory_item_id ) ;
335:
336: elsif( v_model_lines.perform_match in ( 'Y' , 'C' ) ) then

Line 341: CTO_MSUTIL_PUB.insert_type3_referenced_bcso( pTopAtoLineId

337:
338:
339: oe_debug_pub.add( '$$$$$$$$ GOING TO CALL insert_type3_referenced_bcso ' || v_model_lines.line_id , 1 ) ;
340:
341: CTO_MSUTIL_PUB.insert_type3_referenced_bcso( pTopAtoLineId
342: , v_model_lines.line_id
343: , v_model_lines.inventory_item_id
344: , v_model_lines.config_item_id) ;
345:

Line 354: CTO_MSUTIL_PUB.insert_type3_bcmo_bcso( pTopAtoLineId

350:
351:
352: oe_debug_pub.add( '$$$$$$$$ GOING TO CALL insert_type3_bcmo_bcso ' || v_model_lines.line_id , 1 ) ;
353:
354: CTO_MSUTIL_PUB.insert_type3_bcmo_bcso( pTopAtoLineId
355: , v_model_lines.line_id
356: , v_model_lines.inventory_item_id ) ;
357:
358: end if ;

Line 543: CTO_MSUTIL_PUB.get_other_orgs( pmodellineid => v_current_model_line_id ,

539: if( v_config_creation = 1) then
540:
541: oe_debug_pub.add( '$$$$$$$$ TYPE 1 model line ' || v_current_model_line_id , 1 ) ;
542:
543: CTO_MSUTIL_PUB.get_other_orgs( pmodellineid => v_current_model_line_id ,
544: xorglst => v_t_org_list ,
545: x_return_status => x_return_status ,
546: x_msg_count => x_msg_count ,
547: x_msg_data => x_msg_data );

Line 573: CTO_MSUTIL_PUB.insert_val_into_bcso( pTopAtoLineId, v_current_model_line_id, v_current_model_item_id, v_t_org_list ) ;

569:
570: oe_debug_pub.add( '$$$$$$$$ ORg List for model line ' || v_current_model_line_id , 1 ) ;
571:
572:
573: CTO_MSUTIL_PUB.insert_val_into_bcso( pTopAtoLineId, v_current_model_line_id, v_current_model_item_id, v_t_org_list ) ;
574:
575:
576: oe_debug_pub.add( '$$$$$$$$ ORg List DONE for model line ' || v_current_model_line_id , 1 ) ;
577:

Line 581: CTO_MSUTIL_PUB.Get_Master_orgs(

577:
578: -- Added by Renga Kannan on 15-Sep-2005
579: -- Added for ATG performance Project
580:
581: CTO_MSUTIL_PUB.Get_Master_orgs(
582: p_model_line_id => v_current_model_line_id ,
583: x_orgs_list => x_orgs_list,
584: x_return_status => x_return_status,
585: x_msg_count => x_msg_count,

Line 606: CTO_MSUTIL_PUB.insert_val_into_bcso( pTopAtoLineId,

602: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
603:
604: end if;
605: If x_orgs_list.count <> 0 then
606: CTO_MSUTIL_PUB.insert_val_into_bcso( pTopAtoLineId,
607: v_current_model_line_id,
608: v_current_model_item_id,
609: x_orgs_list ) ;
610: End if;

Line 616: CTO_MSUTIL_PUB.insert_all_into_bcso( pTopAtoLineId, v_current_model_line_id, v_current_model_item_id ) ;

612: elsif( v_config_creation = 2 ) then
613:
614: oe_debug_pub.add( '$$$$$$$$ TYPE 2 model line ' || v_current_model_line_id , 1 ) ;
615:
616: CTO_MSUTIL_PUB.insert_all_into_bcso( pTopAtoLineId, v_current_model_line_id, v_current_model_item_id ) ;
617:
618: end if;
619:
620:

Line 776: v_t_org_list CTO_MSUTIL_PUB.org_list;

772: and ato_line_id = pTopAtoLineId order by plan_level ;
773:
774:
775:
776: v_t_org_list CTO_MSUTIL_PUB.org_list;
777:
778: v_current_model_line_id number ;
779: v_current_model_item_id number ;
780: v_current_config_item_id number;

Line 788: x_orgs_list CTO_MSUTIL_PUB.org_list;

784: v_group_reference_id number ;
785: v_orgs_list cto_oss_source_pk.orgs_list ;
786: -- Added by Renga Kannan on 15-Sep-2005
787: -- For ATG performance Project
788: x_orgs_list CTO_MSUTIL_PUB.org_list;
789:
790: BEGIN
791: --Bugfix 13362916
792: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 919: CTO_MSUTIL_PUB.insert_type3_referenced_bcso( pTopAtoLineId

915: oe_debug_pub.add( '$$$$$$$$ TYPE 3 model line ' || v_model_lines.line_id , 1 ) ;
916:
917: /* Fixed bug 3472654 */
918: if( v_model_lines.perform_match in ( 'Y' , 'U') ) then
919: CTO_MSUTIL_PUB.insert_type3_referenced_bcso( pTopAtoLineId
920: , v_model_lines.line_id
921: , v_model_lines.inventory_item_id
922: , v_model_lines.config_item_id) ;
923:

Line 928: CTO_MSUTIL_PUB.insert_type3_bcso( pTopAtoLineId

924:
925: else
926:
927:
928: CTO_MSUTIL_PUB.insert_type3_bcso( pTopAtoLineId
929: , v_model_lines.line_id
930: , v_model_lines.inventory_item_id
931: , v_model_lines.config_item_id) ;
932:

Line 1152: CTO_MSUTIL_PUB.get_other_orgs( pmodellineid => v_current_model_line_id ,

1148: if( v_config_creation = 1) then
1149:
1150: oe_debug_pub.add( '$$$$$$$$ TYPE 1 model line ' || v_current_model_line_id , 1 ) ;
1151:
1152: CTO_MSUTIL_PUB.get_other_orgs( pmodellineid => v_current_model_line_id ,
1153: p_mode => 'UPG',
1154: xorglst => v_t_org_list ,
1155: x_return_status => x_return_status ,
1156: x_msg_count => x_msg_count ,

Line 1183: CTO_MSUTIL_PUB.insert_val_into_bcso( pTopAtoLineId, v_current_model_line_id, v_current_model_item_id, v_t_org_list , v_current_config_item_id) ;

1179:
1180: oe_debug_pub.add( '$$$$$$$$ ORg List for model line ' || v_current_model_line_id , 1 ) ;
1181:
1182:
1183: CTO_MSUTIL_PUB.insert_val_into_bcso( pTopAtoLineId, v_current_model_line_id, v_current_model_item_id, v_t_org_list , v_current_config_item_id) ;
1184:
1185:
1186: oe_debug_pub.add( '$$$$$$$$ ORg List DONE for model line ' || v_current_model_line_id , 1 ) ;
1187: -- Added by Renga Kannan on 15-Sep-2005

Line 1190: CTO_MSUTIL_PUB.Get_Master_orgs(

1186: oe_debug_pub.add( '$$$$$$$$ ORg List DONE for model line ' || v_current_model_line_id , 1 ) ;
1187: -- Added by Renga Kannan on 15-Sep-2005
1188: -- Added for ATG performance Project
1189:
1190: CTO_MSUTIL_PUB.Get_Master_orgs(
1191: p_model_line_id => v_current_model_line_id ,
1192: x_orgs_list => x_orgs_list,
1193: x_return_status => x_return_status,
1194: x_msg_count => x_msg_count,

Line 1215: CTO_MSUTIL_PUB.insert_val_into_bcso( pTopAtoLineId,

1211: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1212:
1213: end if;
1214: If x_orgs_list.count <> 0 then
1215: CTO_MSUTIL_PUB.insert_val_into_bcso( pTopAtoLineId,
1216: v_current_model_line_id,
1217: v_current_model_item_id,
1218: x_orgs_list ) ;
1219: End if;

Line 1226: CTO_MSUTIL_PUB.insert_all_into_bcso( pTopAtoLineId, v_current_model_line_id, v_current_model_item_id , v_current_config_item_id) ;

1222: elsif( v_config_creation = 2 ) then
1223:
1224: oe_debug_pub.add( '$$$$$$$$ TYPE 2 model line ' || v_current_model_line_id , 1 ) ;
1225:
1226: CTO_MSUTIL_PUB.insert_all_into_bcso( pTopAtoLineId, v_current_model_line_id, v_current_model_item_id , v_current_config_item_id) ;
1227:
1228: end if;
1229:
1230:

Line 2932: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'Default assignment set is null, returning from create_sourcing_rules procedure',1);

2928:
2929:
2930: IF lMrpAssignmentSet is null THEN
2931: IF PG_DEBUG <> 0 THEN
2932: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'Default assignment set is null, returning from create_sourcing_rules procedure',1);
2933: END IF;
2934: return;
2935: ELSE
2936: IF PG_DEBUG <> 0 THEN

Line 2937: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'Default assignment set is '||to_char(lMrpAssignmentSet),2);

2933: END IF;
2934: return;
2935: ELSE
2936: IF PG_DEBUG <> 0 THEN
2937: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'Default assignment set is '||to_char(lMrpAssignmentSet),2);
2938: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'Upgrade assignment set is '||to_char(lUPGAssignmentSet),2);
2939: END IF;
2940: END IF;
2941:

Line 2938: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'Upgrade assignment set is '||to_char(lUPGAssignmentSet),2);

2934: return;
2935: ELSE
2936: IF PG_DEBUG <> 0 THEN
2937: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'Default assignment set is '||to_char(lMrpAssignmentSet),2);
2938: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'Upgrade assignment set is '||to_char(lUPGAssignmentSet),2);
2939: END IF;
2940: END IF;
2941:
2942: --

Line 2989: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'There is no sourcing rule defined ',1);

2985: EXCEPTION
2986: WHEN NO_DATA_FOUND THEN
2987:
2988: IF PG_DEBUG <> 0 THEN
2989: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'There is no sourcing rule defined ',1);
2990: END IF;
2991: raise no_sourcing_defined;
2992:
2993: END;

Line 2997: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'lAssnType::'||to_char(lAssignmentType)||'::lAssnId::'||to_char(lAssignmentId),2);

2993: END;
2994:
2995:
2996: IF PG_DEBUG <> 0 THEN
2997: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'lAssnType::'||to_char(lAssignmentType)||'::lAssnId::'||to_char(lAssignmentId),2);
2998: END IF;
2999:
3000: --
3001: -- copy assignment into lAssignmentRec

Line 3289: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'assignment exists already, do not recreate go to end of loop',2);

3285: EXCEPTION
3286: WHEN NO_DATA_FOUND THEN
3287:
3288: IF PG_DEBUG <> 0 THEN
3289: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'assignment exists already, do not recreate go to end of loop',2);
3290: END IF;
3291:
3292: RETURN;
3293:

Line 3296: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'others exception while checking ifassignment exists, not handling, creating assignment:: '||sqlerrm,2);

3292: RETURN;
3293:
3294: WHEN OTHERS THEN
3295: IF PG_DEBUG <> 0 THEN
3296: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'others exception while checking ifassignment exists, not handling, creating assignment:: '||sqlerrm,2);
3297: END IF;
3298: END;
3299:
3300: IF PG_DEBUG <> 0 THEN

Line 3301: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'after query row',2);

3297: END IF;
3298: END;
3299:
3300: IF PG_DEBUG <> 0 THEN
3301: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'after query row',2);
3302: END IF;
3303:
3304: --
3305: -- check if this assignment already exists for config item

Line 3311: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'assignment_set_id::'||to_char(lAssignmentRec.assignment_set_id),2);

3307: lStmtNum := 35;
3308: -- BEGIN
3309: --
3310: -- IF PG_DEBUG <> 0 THEN
3311: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'assignment_set_id::'||to_char(lAssignmentRec.assignment_set_id),2);
3312: --
3313: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'assignment_type::'||to_char(lAssignmentRec.assignment_type),2);
3314: --
3315: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'organization_id::'||to_char(lAssignmentRec.organization_id),2);

Line 3313: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'assignment_type::'||to_char(lAssignmentRec.assignment_type),2);

3309: --
3310: -- IF PG_DEBUG <> 0 THEN
3311: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'assignment_set_id::'||to_char(lAssignmentRec.assignment_set_id),2);
3312: --
3313: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'assignment_type::'||to_char(lAssignmentRec.assignment_type),2);
3314: --
3315: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'organization_id::'||to_char(lAssignmentRec.organization_id),2);
3316: --
3317: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'customer_id::'||to_char(lAssignmentRec.customer_id),2);

Line 3315: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'organization_id::'||to_char(lAssignmentRec.organization_id),2);

3311: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'assignment_set_id::'||to_char(lAssignmentRec.assignment_set_id),2);
3312: --
3313: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'assignment_type::'||to_char(lAssignmentRec.assignment_type),2);
3314: --
3315: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'organization_id::'||to_char(lAssignmentRec.organization_id),2);
3316: --
3317: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'customer_id::'||to_char(lAssignmentRec.customer_id),2);
3318: --
3319: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'ship_to_site_id::'||to_char(lAssignmentRec.ship_to_site_id),2);

Line 3317: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'customer_id::'||to_char(lAssignmentRec.customer_id),2);

3313: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'assignment_type::'||to_char(lAssignmentRec.assignment_type),2);
3314: --
3315: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'organization_id::'||to_char(lAssignmentRec.organization_id),2);
3316: --
3317: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'customer_id::'||to_char(lAssignmentRec.customer_id),2);
3318: --
3319: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'ship_to_site_id::'||to_char(lAssignmentRec.ship_to_site_id),2);
3320: --
3321: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'sourcing_rule_type::'||to_char(lAssignmentRec.sourcing_rule_type),2);

Line 3319: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'ship_to_site_id::'||to_char(lAssignmentRec.ship_to_site_id),2);

3315: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'organization_id::'||to_char(lAssignmentRec.organization_id),2);
3316: --
3317: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'customer_id::'||to_char(lAssignmentRec.customer_id),2);
3318: --
3319: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'ship_to_site_id::'||to_char(lAssignmentRec.ship_to_site_id),2);
3320: --
3321: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'sourcing_rule_type::'||to_char(lAssignmentRec.sourcing_rule_type),2);
3322: --
3323: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'inventory_item_id:: '||to_char(pConfigId),2);

Line 3321: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'sourcing_rule_type::'||to_char(lAssignmentRec.sourcing_rule_type),2);

3317: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'customer_id::'||to_char(lAssignmentRec.customer_id),2);
3318: --
3319: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'ship_to_site_id::'||to_char(lAssignmentRec.ship_to_site_id),2);
3320: --
3321: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'sourcing_rule_type::'||to_char(lAssignmentRec.sourcing_rule_type),2);
3322: --
3323: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'inventory_item_id:: '||to_char(pConfigId),2);
3324: --
3325: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'category_id:: '||to_char(lAssignmentRec.category_id),2);

Line 3323: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'inventory_item_id:: '||to_char(pConfigId),2);

3319: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'ship_to_site_id::'||to_char(lAssignmentRec.ship_to_site_id),2);
3320: --
3321: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'sourcing_rule_type::'||to_char(lAssignmentRec.sourcing_rule_type),2);
3322: --
3323: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'inventory_item_id:: '||to_char(pConfigId),2);
3324: --
3325: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'category_id:: '||to_char(lAssignmentRec.category_id),2);
3326: -- END IF;
3327: --

Line 3325: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'category_id:: '||to_char(lAssignmentRec.category_id),2);

3321: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'sourcing_rule_type::'||to_char(lAssignmentRec.sourcing_rule_type),2);
3322: --
3323: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'inventory_item_id:: '||to_char(pConfigId),2);
3324: --
3325: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'category_id:: '||to_char(lAssignmentRec.category_id),2);
3326: -- END IF;
3327: --
3328: -- -- bug 6617686
3329: -- IF pConfigId IS NOT NULL THEN

Line 3358: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'assignment exists already, do not recreate',2);

3354: -- -- end: bug 6617686
3355: --
3356: -- IF lAssignmentExists = 1 THEN
3357: -- IF PG_DEBUG <> 0 THEN
3358: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'assignment exists already, do not recreate',2);
3359: -- END IF;
3360: -- return;
3361: -- END IF;
3362: --

Line 3366: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'assignment does not exist, create it',2);

3362: --
3363: -- EXCEPTION
3364: -- when NO_DATA_FOUND then
3365: -- IF PG_DEBUG <> 0 THEN
3366: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'assignment does not exist, create it',2);
3367: -- END IF;
3368: -- when OTHERS then
3369: -- IF PG_DEBUG <> 0 THEN
3370: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'others exception while checking ifassignment exists, not handling, creating assignment:: '||sqlerrm,2);

Line 3370: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'others exception while checking ifassignment exists, not handling, creating assignment:: '||sqlerrm,2);

3366: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'assignment does not exist, create it',2);
3367: -- END IF;
3368: -- when OTHERS then
3369: -- IF PG_DEBUG <> 0 THEN
3370: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'others exception while checking ifassignment exists, not handling, creating assignment:: '||sqlerrm,2);
3371: -- END IF;
3372: -- END;
3373:
3374: --

Line 3427: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'after forming lAssignmentTbl',2);

3423: lAssignmentTbl(1).db_flag := NULL;
3424: lAssignmentTbl(1).operation := MRP_Globals.G_OPR_CREATE;
3425:
3426: IF PG_DEBUG <> 0 THEN
3427: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'after forming lAssignmentTbl',2);
3428: END IF;
3429:
3430: --
3431: -- form lAssignmentSetRec

Line 3436: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'after forming lAssignmentSetRec',2);

3432: --
3433: lStmtNum := 50;
3434: lAssignmentSetRec.operation := MRP_Globals.G_OPR_NONE;
3435: IF PG_DEBUG <> 0 THEN
3436: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'after forming lAssignmentSetRec',2);
3437: END IF;
3438:
3439: --
3440: -- call mrp API to insert rec into assignment set

Line 3444: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'before Process_Assignment',2);

3440: -- call mrp API to insert rec into assignment set
3441: --
3442: lStmtNum := 60;
3443: IF PG_DEBUG <> 0 THEN
3444: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'before Process_Assignment',2);
3445: END IF;
3446:
3447: -- currently, not passing commented out parameters, need to
3448: -- confirm with raghu, confirmed with stupe

Line 3470: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'unexp error in process_assignment::'||sqlerrm,1);

3466: );
3467:
3468: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3469: IF PG_DEBUG <> 0 THEN
3470: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'unexp error in process_assignment::'||sqlerrm,1);
3471: END IF;
3472: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3473:
3474: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 3476: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'error in process_assignment::'||sqlerrm,1);

3472: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3473:
3474: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3475: IF PG_DEBUG <> 0 THEN
3476: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'error in process_assignment::'||sqlerrm,1);
3477: END IF;
3478:
3479: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: count:'||l_msg_count , 1 );
3480:

Line 3479: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: count:'||l_msg_count , 1 );

3475: IF PG_DEBUG <> 0 THEN
3476: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'error in process_assignment::'||sqlerrm,1);
3477: END IF;
3478:
3479: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: count:'||l_msg_count , 1 );
3480:
3481: IF l_msg_count > 0 THEN
3482: FOR l_index IN 1..l_msg_count LOOP
3483: l_msg_data := fnd_msg_pub.get(

Line 3487: oe_debug_pub.add( 'CTO_MSUTIL_PUB.create_sourcing_rule: ' || substr(l_msg_data,1,250) , 1 );

3483: l_msg_data := fnd_msg_pub.get(
3484: p_msg_index => l_index,
3485: p_encoded => FND_API.G_FALSE);
3486:
3487: oe_debug_pub.add( 'CTO_MSUTIL_PUB.create_sourcing_rule: ' || substr(l_msg_data,1,250) , 1 );
3488: END LOOP;
3489:
3490: oe_debug_pub.add(' CTO_MSUTIL_PUB.create_sourcing_rules: MSG:'|| xAssignmentSetRec.return_status);
3491: END IF;

Line 3490: oe_debug_pub.add(' CTO_MSUTIL_PUB.create_sourcing_rules: MSG:'|| xAssignmentSetRec.return_status);

3486:
3487: oe_debug_pub.add( 'CTO_MSUTIL_PUB.create_sourcing_rule: ' || substr(l_msg_data,1,250) , 1 );
3488: END LOOP;
3489:
3490: oe_debug_pub.add(' CTO_MSUTIL_PUB.create_sourcing_rules: MSG:'|| xAssignmentSetRec.return_status);
3491: END IF;
3492:
3493: oe_debug_pub.add('Failure!' , 1 );
3494:

Line 3500: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'success in process_assignment',2);

3496: raise FND_API.G_EXC_ERROR;
3497:
3498: END IF;
3499: IF PG_DEBUG <> 0 THEN
3500: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'success in process_assignment',2);
3501: END IF;
3502:
3503: EXCEPTION
3504: When NO_sourcing_defined THEN

Line 3509: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'Create_Src_Rules::exp error::'||to_char(lStmtNum)||'::'||sqlerrm,1);

3505: null;
3506:
3507: when FND_API.G_EXC_ERROR then
3508: IF PG_DEBUG <> 0 THEN
3509: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'Create_Src_Rules::exp error::'||to_char(lStmtNum)||'::'||sqlerrm,1);
3510: END IF;
3511: x_return_status := FND_API.G_RET_STS_ERROR;
3512: CTO_MSG_PUB.Count_And_Get
3513: (p_msg_count => x_msg_count

Line 3519: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'Create_Src_Rules::unexp error::'||to_char(lStmtNum)||'::'||sqlerrm,1);

3515: );
3516:
3517: when FND_API.G_EXC_UNEXPECTED_ERROR then
3518: IF PG_DEBUG <> 0 THEN
3519: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'Create_Src_Rules::unexp error::'||to_char(lStmtNum)||'::'||sqlerrm,1);
3520: END IF;
3521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3522: CTO_MSG_PUB.Count_And_Get
3523: (p_msg_count => x_msg_count

Line 3529: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'Create_Src_Rules::others::'||to_char(lStmtNum)||'::'||sqlerrm,1);

3525: );
3526:
3527: when OTHERS then
3528: IF PG_DEBUG <> 0 THEN
3529: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'Create_Src_Rules::others::'||to_char(lStmtNum)||'::'||sqlerrm,1);
3530: END IF;
3531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3532: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3533: FND_MSG_PUB.Add_Exc_Msg

Line 3665: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'Default assignment set is null, returning from create_sourcing_rules procedure',1);

3661:
3662:
3663: IF lMrpAssignmentSet is null THEN
3664: IF PG_DEBUG <> 0 THEN
3665: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'Default assignment set is null, returning from create_sourcing_rules procedure',1);
3666: END IF;
3667: return;
3668: ELSE
3669: IF PG_DEBUG <> 0 THEN

Line 3670: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'Default assignment set is '||to_char(lMrpAssignmentSet),2);

3666: END IF;
3667: return;
3668: ELSE
3669: IF PG_DEBUG <> 0 THEN
3670: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'Default assignment set is '||to_char(lMrpAssignmentSet),2);
3671: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'UPG assignment set is '||to_char(lUPGAssignmentSet),2);
3672: END IF;
3673: END IF;
3674:

Line 3671: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'UPG assignment set is '||to_char(lUPGAssignmentSet),2);

3667: return;
3668: ELSE
3669: IF PG_DEBUG <> 0 THEN
3670: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'Default assignment set is '||to_char(lMrpAssignmentSet),2);
3671: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'UPG assignment set is '||to_char(lUPGAssignmentSet),2);
3672: END IF;
3673: END IF;
3674:
3675: --

Line 3717: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'There is no sourcing rule defined ',1);

3713: EXCEPTION
3714: WHEN NO_DATA_FOUND THEN
3715:
3716: IF PG_DEBUG <> 0 THEN
3717: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'There is no sourcing rule defined ',1);
3718: END IF;
3719: raise no_sourcing_defined;
3720:
3721: END;

Line 3745: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'lAssnType::'||to_char(lAssignmentType)||'::lAssnId::'||to_char(lAssignmentId),2);

3741: exit when c_type3_assignments%notfound ;
3742:
3743:
3744: IF PG_DEBUG <> 0 THEN
3745: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'lAssnType::'||to_char(lAssignmentType)||'::lAssnId::'||to_char(lAssignmentId),2);
3746: END IF;
3747:
3748: --
3749: -- copy assignment into lAssignmentRec

Line 4038: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'assignment exists already, do not recreate',2);

4034:
4035: EXCEPTION
4036: WHEN NO_DATA_FOUND THEN
4037: IF PG_DEBUG <> 0 THEN
4038: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'assignment exists already, do not recreate',2);
4039: END IF;
4040: goto END_OF_LOOP;
4041:
4042: WHEN OTHERS THEN

Line 4044: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'others exception while checking ifassignment exists, not handling, creating assignment:: '||sqlerrm,2);

4040: goto END_OF_LOOP;
4041:
4042: WHEN OTHERS THEN
4043: IF PG_DEBUG <> 0 THEN
4044: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: ' || 'others exception while checking ifassignment exists, not handling, creating assignment:: '||sqlerrm,2);
4045: END IF;
4046: END;
4047:
4048: IF PG_DEBUG <> 0 THEN

Line 4049: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'after query row',2);

4045: END IF;
4046: END;
4047:
4048: IF PG_DEBUG <> 0 THEN
4049: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'after query row',2);
4050: END IF;
4051:
4052: --
4053: -- check if this assignment already exists for config item

Line 4059: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'assignment_set_id::'||to_char(lAssignmentRec.assignment_set_id),2);

4055: lStmtNum := 35;
4056: -- BEGIN
4057: --
4058: -- IF PG_DEBUG <> 0 THEN
4059: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'assignment_set_id::'||to_char(lAssignmentRec.assignment_set_id),2);
4060: --
4061: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'Source assignment_set_id::'||to_char(lMrpAssignmentSet),2);
4062: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'Destination assignment_set_id::'||to_char(lUPGAssignmentSet),2);
4063: --

Line 4061: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'Source assignment_set_id::'||to_char(lMrpAssignmentSet),2);

4057: --
4058: -- IF PG_DEBUG <> 0 THEN
4059: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'assignment_set_id::'||to_char(lAssignmentRec.assignment_set_id),2);
4060: --
4061: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'Source assignment_set_id::'||to_char(lMrpAssignmentSet),2);
4062: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'Destination assignment_set_id::'||to_char(lUPGAssignmentSet),2);
4063: --
4064: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'assignment_type::'||to_char(lAssignmentRec.assignment_type),2);
4065: --

Line 4062: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'Destination assignment_set_id::'||to_char(lUPGAssignmentSet),2);

4058: -- IF PG_DEBUG <> 0 THEN
4059: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'assignment_set_id::'||to_char(lAssignmentRec.assignment_set_id),2);
4060: --
4061: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'Source assignment_set_id::'||to_char(lMrpAssignmentSet),2);
4062: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'Destination assignment_set_id::'||to_char(lUPGAssignmentSet),2);
4063: --
4064: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'assignment_type::'||to_char(lAssignmentRec.assignment_type),2);
4065: --
4066: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'organization_id::'||to_char(lAssignmentRec.organization_id),2);

Line 4064: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'assignment_type::'||to_char(lAssignmentRec.assignment_type),2);

4060: --
4061: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'Source assignment_set_id::'||to_char(lMrpAssignmentSet),2);
4062: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'Destination assignment_set_id::'||to_char(lUPGAssignmentSet),2);
4063: --
4064: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'assignment_type::'||to_char(lAssignmentRec.assignment_type),2);
4065: --
4066: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'organization_id::'||to_char(lAssignmentRec.organization_id),2);
4067: --
4068: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'customer_id::'||to_char(lAssignmentRec.customer_id),2);

Line 4066: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'organization_id::'||to_char(lAssignmentRec.organization_id),2);

4062: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'Destination assignment_set_id::'||to_char(lUPGAssignmentSet),2);
4063: --
4064: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'assignment_type::'||to_char(lAssignmentRec.assignment_type),2);
4065: --
4066: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'organization_id::'||to_char(lAssignmentRec.organization_id),2);
4067: --
4068: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'customer_id::'||to_char(lAssignmentRec.customer_id),2);
4069: --
4070: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'ship_to_site_id::'||to_char(lAssignmentRec.ship_to_site_id),2);

Line 4068: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'customer_id::'||to_char(lAssignmentRec.customer_id),2);

4064: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'assignment_type::'||to_char(lAssignmentRec.assignment_type),2);
4065: --
4066: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'organization_id::'||to_char(lAssignmentRec.organization_id),2);
4067: --
4068: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'customer_id::'||to_char(lAssignmentRec.customer_id),2);
4069: --
4070: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'ship_to_site_id::'||to_char(lAssignmentRec.ship_to_site_id),2);
4071: --
4072: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'sourcing_rule_type::'||to_char(lAssignmentRec.sourcing_rule_type),2);

Line 4070: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'ship_to_site_id::'||to_char(lAssignmentRec.ship_to_site_id),2);

4066: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'organization_id::'||to_char(lAssignmentRec.organization_id),2);
4067: --
4068: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'customer_id::'||to_char(lAssignmentRec.customer_id),2);
4069: --
4070: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'ship_to_site_id::'||to_char(lAssignmentRec.ship_to_site_id),2);
4071: --
4072: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'sourcing_rule_type::'||to_char(lAssignmentRec.sourcing_rule_type),2);
4073: --
4074: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'inventory_item_id:: '||to_char(pConfigId),2);

Line 4072: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'sourcing_rule_type::'||to_char(lAssignmentRec.sourcing_rule_type),2);

4068: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'customer_id::'||to_char(lAssignmentRec.customer_id),2);
4069: --
4070: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'ship_to_site_id::'||to_char(lAssignmentRec.ship_to_site_id),2);
4071: --
4072: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'sourcing_rule_type::'||to_char(lAssignmentRec.sourcing_rule_type),2);
4073: --
4074: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'inventory_item_id:: '||to_char(pConfigId),2);
4075: --
4076: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'category_id:: '||to_char(lAssignmentRec.category_id),2);

Line 4074: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'inventory_item_id:: '||to_char(pConfigId),2);

4070: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'ship_to_site_id::'||to_char(lAssignmentRec.ship_to_site_id),2);
4071: --
4072: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'sourcing_rule_type::'||to_char(lAssignmentRec.sourcing_rule_type),2);
4073: --
4074: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'inventory_item_id:: '||to_char(pConfigId),2);
4075: --
4076: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'category_id:: '||to_char(lAssignmentRec.category_id),2);
4077: -- END IF;
4078: --

Line 4076: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'category_id:: '||to_char(lAssignmentRec.category_id),2);

4072: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'sourcing_rule_type::'||to_char(lAssignmentRec.sourcing_rule_type),2);
4073: --
4074: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'inventory_item_id:: '||to_char(pConfigId),2);
4075: --
4076: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'category_id:: '||to_char(lAssignmentRec.category_id),2);
4077: -- END IF;
4078: --
4079: -- -- bug 6617686
4080: -- IF pConfigId IS NOT NULL THEN

Line 4109: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'assignment exists already, do not recreate',2);

4105: -- -- end : bug 6617686
4106: --
4107: -- IF lAssignmentExists = 1 THEN
4108: -- IF PG_DEBUG <> 0 THEN
4109: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'assignment exists already, do not recreate',2);
4110: -- END IF;
4111: --
4112: --
4113: --

Line 4122: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'assignment does not exist, create it',2);

4118: --
4119: -- EXCEPTION
4120: -- when NO_DATA_FOUND then
4121: -- IF PG_DEBUG <> 0 THEN
4122: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'assignment does not exist, create it',2);
4123: -- END IF;
4124: -- when OTHERS then
4125: -- IF PG_DEBUG <> 0 THEN
4126: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' ||

Line 4126: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' ||

4122: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'assignment does not exist, create it',2);
4123: -- END IF;
4124: -- when OTHERS then
4125: -- IF PG_DEBUG <> 0 THEN
4126: -- oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' ||
4127: -- 'others exception while checking ifassignment exists, not handling, creating assignment:: '||sqlerrm,2);
4128: -- END IF;
4129: -- END;
4130:

Line 4187: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'after forming lAssignmentTbl',2);

4183: lAssignmentTbl(1).db_flag := NULL;
4184: lAssignmentTbl(1).operation := MRP_Globals.G_OPR_CREATE;
4185:
4186: IF PG_DEBUG <> 0 THEN
4187: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'after forming lAssignmentTbl',2);
4188: END IF;
4189:
4190: --
4191: -- form lAssignmentSetRec

Line 4196: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'after forming lAssignmentSetRec',2);

4192: --
4193: lStmtNum := 50;
4194: lAssignmentSetRec.operation := MRP_Globals.G_OPR_NONE;
4195: IF PG_DEBUG <> 0 THEN
4196: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'after forming lAssignmentSetRec',2);
4197: END IF;
4198:
4199: --
4200: -- call mrp API to insert rec into assignment set

Line 4204: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'before Process_Assignment',2);

4200: -- call mrp API to insert rec into assignment set
4201: --
4202: lStmtNum := 60;
4203: IF PG_DEBUG <> 0 THEN
4204: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'before Process_Assignment',2);
4205: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'printing lAssignmentRec');
4206: oe_debug_pub.add('--------------------------------------------------------------------------');
4207: oe_debug_pub.add('lAssignmentRec.ASSIGNMENT_ID:' || lAssignmentRec.ASSIGNMENT_ID );
4208: oe_debug_pub.add('lAssignmentRec.ASSIGNMENT_SET_ID:' || lAssignmentRec.ASSIGNMENT_SET_ID );

Line 4205: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'printing lAssignmentRec');

4201: --
4202: lStmtNum := 60;
4203: IF PG_DEBUG <> 0 THEN
4204: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'before Process_Assignment',2);
4205: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'printing lAssignmentRec');
4206: oe_debug_pub.add('--------------------------------------------------------------------------');
4207: oe_debug_pub.add('lAssignmentRec.ASSIGNMENT_ID:' || lAssignmentRec.ASSIGNMENT_ID );
4208: oe_debug_pub.add('lAssignmentRec.ASSIGNMENT_SET_ID:' || lAssignmentRec.ASSIGNMENT_SET_ID );
4209: oe_debug_pub.add('lAssignmentRec.ASSIGNMENT_TYPE:' || lAssignmentRec.ASSIGNMENT_TYPE );

Line 4246: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'printing lAssignmentRec');

4242: oe_debug_pub.add('lAssignmentRec.SOURCING_RULE_ID:' || lAssignmentRec.SOURCING_RULE_ID );
4243: oe_debug_pub.add('lAssignmentRec.SOURCING_RULE_TYPE:' || lAssignmentRec.SOURCING_RULE_TYPE );
4244: oe_debug_pub.add('lAssignmentRec.OPERATION:' || lAssignmentRec.OPERATION );
4245: oe_debug_pub.add('--------------------------------------------------------------------------');
4246: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'printing lAssignmentRec');
4247: oe_debug_pub.add('++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
4248: oe_debug_pub.add('lAssignmentTbl(1).Assignment_Id:' || lAssignmentTbl(1).Assignment_Id);
4249: oe_debug_pub.add('lAssignmentTbl(1).Assignment_Set_Id:' || lAssignmentTbl(1).Assignment_Set_Id);
4250: oe_debug_pub.add('lAssignmentTbl(1).Assignment_Type:' || lAssignmentTbl(1).Assignment_Type);

Line 4314: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'unexp error in process_assignment::'||sqlerrm,1);

4310: );
4311:
4312: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4313: IF PG_DEBUG <> 0 THEN
4314: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'unexp error in process_assignment::'||sqlerrm,1);
4315: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'l_msg_data::'||l_msg_data,1);
4316: END IF;
4317: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4318:

Line 4315: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'l_msg_data::'||l_msg_data,1);

4311:
4312: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4313: IF PG_DEBUG <> 0 THEN
4314: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'unexp error in process_assignment::'||sqlerrm,1);
4315: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'l_msg_data::'||l_msg_data,1);
4316: END IF;
4317: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4318:
4319: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 4321: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'error in process_assignment::'||sqlerrm,1);

4317: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4318:
4319: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4320: IF PG_DEBUG <> 0 THEN
4321: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'error in process_assignment::'||sqlerrm,1);
4322: END IF;
4323:
4324:
4325: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: count:'||l_msg_count , 1 );

Line 4325: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: count:'||l_msg_count , 1 );

4321: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'error in process_assignment::'||sqlerrm,1);
4322: END IF;
4323:
4324:
4325: oe_debug_pub.add('CTO_MSUTIL_PUB.create_sourcing_rules: count:'||l_msg_count , 1 );
4326:
4327: IF l_msg_count > 0 THEN
4328: FOR l_index IN 1..l_msg_count LOOP
4329: l_msg_data := fnd_msg_pub.get(

Line 4333: oe_debug_pub.add( 'CTO_MSUTIL_PUB.create_sourcing_rule: ' || substr(l_msg_data,1,250) , 1 );

4329: l_msg_data := fnd_msg_pub.get(
4330: p_msg_index => l_index,
4331: p_encoded => FND_API.G_FALSE);
4332:
4333: oe_debug_pub.add( 'CTO_MSUTIL_PUB.create_sourcing_rule: ' || substr(l_msg_data,1,250) , 1 );
4334: END LOOP;
4335:
4336: oe_debug_pub.add(' CTO_MSUTIL_PUB.create_sourcing_rules: MSG:'|| xAssignmentSetRec.return_status);
4337: END IF;

Line 4336: oe_debug_pub.add(' CTO_MSUTIL_PUB.create_sourcing_rules: MSG:'|| xAssignmentSetRec.return_status);

4332:
4333: oe_debug_pub.add( 'CTO_MSUTIL_PUB.create_sourcing_rule: ' || substr(l_msg_data,1,250) , 1 );
4334: END LOOP;
4335:
4336: oe_debug_pub.add(' CTO_MSUTIL_PUB.create_sourcing_rules: MSG:'|| xAssignmentSetRec.return_status);
4337: END IF;
4338:
4339: oe_debug_pub.add('Failure!' , 1 );
4340:

Line 4346: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'success in process_assignment',2);

4342: raise FND_API.G_EXC_ERROR;
4343:
4344: END IF;
4345: IF PG_DEBUG <> 0 THEN
4346: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'success in process_assignment',2);
4347: END IF;
4348:
4349:
4350: lStmtNum := 70;

Line 4352: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'before end_of_loop',2);

4348:
4349:
4350: lStmtNum := 70;
4351:
4352: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'before end_of_loop',2);
4353: <>
4354: null ;
4355: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'after end_of_loop',2);
4356: END LOOP;

Line 4355: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'after end_of_loop',2);

4351:
4352: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'before end_of_loop',2);
4353: <>
4354: null ;
4355: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'after end_of_loop',2);
4356: END LOOP;
4357:
4358:
4359: if( c_type3_assignments%rowcount = 0 ) then

Line 4361: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'no sourcing assignments ',2);

4357:
4358:
4359: if( c_type3_assignments%rowcount = 0 ) then
4360:
4361: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'no sourcing assignments ',2);
4362:
4363: end if;
4364:
4365: lStmtNum := 80;

Line 4367: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'before close c_type3_assignments ',2);

4363: end if;
4364:
4365: lStmtNum := 80;
4366:
4367: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'before close c_type3_assignments ',2);
4368:
4369: close c_type3_assignments ;
4370:
4371: --debugging for bug 13362916

Line 4384: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'Exit Create_TYPE3_Sourcing_Rules.');

4380: '::rule_type::' || v_config_assignments.sourcing_rule_type ||
4381: '::cat::' || v_config_assignments.category_id);
4382: END LOOP;
4383: oe_debug_pub.add('++++++++++++++++++++++++++++++++++++++++++');
4384: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || 'Exit Create_TYPE3_Sourcing_Rules.');
4385: --end debugging for bug 13051516
4386:
4387: EXCEPTION
4388: When NO_sourcing_defined THEN

Line 4393: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || '::exp error::'||to_char(lStmtNum)||'::'||sqlerrm,1);

4389: null;
4390:
4391: when FND_API.G_EXC_ERROR then
4392: IF PG_DEBUG <> 0 THEN
4393: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || '::exp error::'||to_char(lStmtNum)||'::'||sqlerrm,1);
4394: END IF;
4395: x_return_status := FND_API.G_RET_STS_ERROR;
4396: CTO_MSG_PUB.Count_And_Get
4397: (p_msg_count => x_msg_count

Line 4403: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || '::unexp error::'||to_char(lStmtNum)||'::'||sqlerrm,1);

4399: );
4400:
4401: when FND_API.G_EXC_UNEXPECTED_ERROR then
4402: IF PG_DEBUG <> 0 THEN
4403: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || '::unexp error::'||to_char(lStmtNum)||'::'||sqlerrm,1);
4404: END IF;
4405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4406: CTO_MSG_PUB.Count_And_Get
4407: (p_msg_count => x_msg_count

Line 4413: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || '::others::'||to_char(lStmtNum)||'::'||sqlerrm,1);

4409: );
4410:
4411: when OTHERS then
4412: IF PG_DEBUG <> 0 THEN
4413: oe_debug_pub.add('CTO_MSUTIL_PUB.create_type3_sourcing_rules: ' || '::others::'||to_char(lStmtNum)||'::'||sqlerrm,1);
4414: END IF;
4415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4416: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4417: FND_MSG_PUB.Add_Exc_Msg

Line 4532: , p_t_org_list in CTO_MSUTIL_PUB.org_list

4528:
4529: procedure insert_val_into_bcso( p_top_ato_line_id in NUMBER
4530: , p_model_line_id in NUMBER
4531: , p_model_item_id in NUMBER
4532: , p_t_org_list in CTO_MSUTIL_PUB.org_list
4533: , p_config_item_id in number default null)
4534: is
4535: i number ;
4536: v_source_type_code varchar2(20) ;

Line 5113: xOrgLst OUT NOCOPY CTO_MSUTIL_PUB.Org_list,

5109:
5110: Procedure get_other_orgs (
5111: pModelLineId IN NUMBER,
5112: p_mode IN VARCHAR2 default 'ACC',
5113: xOrgLst OUT NOCOPY CTO_MSUTIL_PUB.Org_list,
5114: x_return_status OUT NOCOPY VARCHAR2,
5115: x_msg_count OUT NOCOPY NUMBER,
5116: x_msg_data OUT NOCOPY VARCHAR2
5117: ) IS

Line 5152: xOrgLst_copy CTO_MSUTIL_PUB.Org_list;

5148: select organization_id bcso_org_id
5149: from bom_cto_src_orgs
5150: where line_id = pModelLineId;
5151:
5152: xOrgLst_copy CTO_MSUTIL_PUB.Org_list;
5153: begin
5154:
5155: /* Clear OrgList array if any element exist */
5156:

Line 5751: x_orgs_list OUT NOCOPY CTO_MSUTIL_PUB.org_list,

5747: +-------------------------------------------------------------------------*/
5748:
5749: PROCEDURE Get_Master_Orgs(
5750: p_model_line_id IN Number,
5751: x_orgs_list OUT NOCOPY CTO_MSUTIL_PUB.org_list,
5752: x_msg_count OUT NOCOPY Number,
5753: x_msg_data OUT NOCOPY varchar2,
5754: x_return_status OUT NOCOPY varchar2) is
5755: LSTMT_NUM Number :=10;

Line 5972: oe_debug_pub.add('Count of configs:: '|| CTO_MSUTIL_PUB.cfg_tbl_var.count,2);

5968:
5969: BEGIN
5970: IF PG_DEBUG <> 0 THEN
5971: oe_debug_pub.add('Inside Raise_event_for_seibel',2);
5972: oe_debug_pub.add('Count of configs:: '|| CTO_MSUTIL_PUB.cfg_tbl_var.count,2);
5973: END IF;
5974:
5975: for i in 1..CTO_MSUTIL_PUB.cfg_tbl_var.count loop
5976: for l_org in config_orgs(CTO_MSUTIL_PUB.cfg_tbl_var(i)) loop

Line 5975: for i in 1..CTO_MSUTIL_PUB.cfg_tbl_var.count loop

5971: oe_debug_pub.add('Inside Raise_event_for_seibel',2);
5972: oe_debug_pub.add('Count of configs:: '|| CTO_MSUTIL_PUB.cfg_tbl_var.count,2);
5973: END IF;
5974:
5975: for i in 1..CTO_MSUTIL_PUB.cfg_tbl_var.count loop
5976: for l_org in config_orgs(CTO_MSUTIL_PUB.cfg_tbl_var(i)) loop
5977: IF PG_DEBUG <> 0 THEN
5978: oe_debug_pub.add('Config:: ' || CTO_MSUTIL_PUB.cfg_tbl_var(i),2);
5979: oe_debug_pub.add('Org:: ' || l_org.organization_id,2);

Line 5976: for l_org in config_orgs(CTO_MSUTIL_PUB.cfg_tbl_var(i)) loop

5972: oe_debug_pub.add('Count of configs:: '|| CTO_MSUTIL_PUB.cfg_tbl_var.count,2);
5973: END IF;
5974:
5975: for i in 1..CTO_MSUTIL_PUB.cfg_tbl_var.count loop
5976: for l_org in config_orgs(CTO_MSUTIL_PUB.cfg_tbl_var(i)) loop
5977: IF PG_DEBUG <> 0 THEN
5978: oe_debug_pub.add('Config:: ' || CTO_MSUTIL_PUB.cfg_tbl_var(i),2);
5979: oe_debug_pub.add('Org:: ' || l_org.organization_id,2);
5980: END IF;

Line 5978: oe_debug_pub.add('Config:: ' || CTO_MSUTIL_PUB.cfg_tbl_var(i),2);

5974:
5975: for i in 1..CTO_MSUTIL_PUB.cfg_tbl_var.count loop
5976: for l_org in config_orgs(CTO_MSUTIL_PUB.cfg_tbl_var(i)) loop
5977: IF PG_DEBUG <> 0 THEN
5978: oe_debug_pub.add('Config:: ' || CTO_MSUTIL_PUB.cfg_tbl_var(i),2);
5979: oe_debug_pub.add('Org:: ' || l_org.organization_id,2);
5980: END IF;
5981:
5982: sql_stmt := 'BEGIN '||

Line 5992: using IN CTO_MSUTIL_PUB.cfg_tbl_var(i),

5988: 'END;';
5989:
5990:
5991: EXECUTE IMMEDIATE sql_stmt
5992: using IN CTO_MSUTIL_PUB.cfg_tbl_var(i),
5993: IN l_org.organization_id;
5994: end loop; --loop for l_org
5995: end loop;
5996:

Line 6007: END CTO_MSUTIL_PUB ;

6003:
6004: End Raise_event_for_seibel;
6005: --End Bugfix 8305535
6006:
6007: END CTO_MSUTIL_PUB ;