APPS.CTO_SUBASSEMBLY_SUP_PK dependencies on CTO_UTILITY_PK

Line 1057: CTO_UTILITY_PK.QUERY_SOURCING_ORG(

1053: pitems_table(l_index).feeder_run := 'N';
1054:
1055:
1056: l_stmt_num := 50;
1057: CTO_UTILITY_PK.QUERY_SOURCING_ORG(
1058: P_inventory_item_id => pitems_table(l_index).item_id,
1059: P_organization_id => pOrganization_id,
1060: P_sourcing_rule_exists => v_sourcing_rule_exists,
1061: P_source_type => v_source_type,

Line 1070: oe_debug_pub.add ('get_child_configurations: ' || 'failed after call to CTO_UTILITY_PK.QUERY_SOURCING_ORG with status ' || x_return_status ,1);

1066: );
1067:
1068: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1069: IF PG_DEBUG <> 0 THEN
1070: oe_debug_pub.add ('get_child_configurations: ' || 'failed after call to CTO_UTILITY_PK.QUERY_SOURCING_ORG with status ' || x_return_status ,1);
1071: END IF;
1072: --oe_debug_pub.add ('error message' || l_error_msg ,1);
1073: RAISE FND_API.G_EXC_ERROR;
1074: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1076: oe_debug_pub.add ('get_child_configurations: ' || ' failed after call to CTO_UTILITY_PK.QUERY_SOURCING_ORG with status ' || x_return_status ,1);

1072: --oe_debug_pub.add ('error message' || l_error_msg ,1);
1073: RAISE FND_API.G_EXC_ERROR;
1074: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1075: IF PG_DEBUG <> 0 THEN
1076: oe_debug_pub.add ('get_child_configurations: ' || ' failed after call to CTO_UTILITY_PK.QUERY_SOURCING_ORG with status ' || x_return_status ,1);
1077: END IF;
1078: --oe_debug_pub.add ('error message' || l_error_msg ,1);
1079: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1080: ELSE

Line 1083: oe_debug_pub.add('get_child_configurations: ' || 'success from CTO_UTILITY_PK.QUERY_SOURCING_ORG ' ,1);

1079: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1080: ELSE
1081:
1082: IF PG_DEBUG <> 0 THEN
1083: oe_debug_pub.add('get_child_configurations: ' || 'success from CTO_UTILITY_PK.QUERY_SOURCING_ORG ' ,1);
1084: END IF;
1085: END IF;
1086:
1087:

Line 1257: CTO_UTILITY_PK.QUERY_SOURCING_ORG(

1253: pitems_table(l_index).parent_index := pParent_index;
1254: pitems_table(l_index).feeder_run := 'N';
1255:
1256: l_stmt_num := 80;
1257: CTO_UTILITY_PK.QUERY_SOURCING_ORG(
1258: P_inventory_item_id => pitems_table(l_index).item_id,
1259: P_organization_id => pOrganization_id,
1260: P_sourcing_rule_exists => v_sourcing_rule_exists,
1261: P_source_type => v_source_type,

Line 1271: oe_debug_pub.add ('get_child_configurations: ' || 'failed after call to CTO_UTILITY_PK.QUERY_SOURCING_ORG with status ' || x_return_status ,1);

1267:
1268:
1269: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1270: IF PG_DEBUG <> 0 THEN
1271: oe_debug_pub.add ('get_child_configurations: ' || 'failed after call to CTO_UTILITY_PK.QUERY_SOURCING_ORG with status ' || x_return_status ,1);
1272: END IF;
1273: --oe_debug_pub.add ('error message' || l_error_msg ,1);
1274: RAISE FND_API.G_EXC_ERROR;
1275: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1277: oe_debug_pub.add ('get_child_configurations: ' || ' failed after call to CTO_UTILITY_PK.QUERY_SOURCING_ORG with status ' || x_return_status ,1);

1273: --oe_debug_pub.add ('error message' || l_error_msg ,1);
1274: RAISE FND_API.G_EXC_ERROR;
1275: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1276: IF PG_DEBUG <> 0 THEN
1277: oe_debug_pub.add ('get_child_configurations: ' || ' failed after call to CTO_UTILITY_PK.QUERY_SOURCING_ORG with status ' || x_return_status ,1);
1278: END IF;
1279: --oe_debug_pub.add ('error message' || l_error_msg ,1);
1280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1281: ELSE

Line 1284: oe_debug_pub.add('get_child_configurations: ' || 'success from CTO_UTILITY_PK.QUERY_SOURCING_ORG ' ,1);

1280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1281: ELSE
1282:
1283: IF PG_DEBUG <> 0 THEN
1284: oe_debug_pub.add('get_child_configurations: ' || 'success from CTO_UTILITY_PK.QUERY_SOURCING_ORG ' ,1);
1285: END IF;
1286: END IF;
1287:
1288: